eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_STATUS_UPDATE_PVT dependencies on FND_FILE

Line 102: FND_FILE.PUT_LINE(FND_FILE.LOG, '* BEGIN contract_status_updater *');

98:
99:
100:
101: BEGIN
102: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** BEGIN contract_status_updater *****');
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status = ' || p_status);
105:
106: l_api_name := 'contract_status_updater';

Line 104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status = ' || p_status);

100:
101: BEGIN
102: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** BEGIN contract_status_updater *****');
103:
104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status = ' || p_status);
105:
106: l_api_name := 'contract_status_updater';
107: l_api_version := 1.0;
108: l_first_iteration := 'Y';

Line 135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

131: IF (l_first_iteration = 'Y') THEN
132:
133: l_first_iteration := 'N';
134:
135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));

Line 136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

132:
133: l_first_iteration := 'N';
134:
135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
140: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');

Line 137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));

133: l_first_iteration := 'N';
134:
135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
140: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
141:

Line 138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');

134:
135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
140: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
141:
142: END IF;

Line 139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));

135: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
140: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
141:
142: END IF;
143:

Line 140: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');

136: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
138: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
139: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
140: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
141:
142: END IF;
143:
144:

Line 156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_contracts(i).contract_name);

152: l_doc_type := OKC_API.get_contract_type(selected_contracts(i).contract_id);
153: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_ATTR_CON_NAME',l_doc_type);
154: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
155:
156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_contracts(i).contract_name);
157: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name) || ' : '|| selected_contracts(i).contract_name);
158:
159: -- Add Contract Number
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);

Line 157: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name) || ' : '|| selected_contracts(i).contract_name);

153: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_ATTR_CON_NAME',l_doc_type);
154: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
155:
156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_contracts(i).contract_name);
157: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name) || ' : '|| selected_contracts(i).contract_name);
158:
159: -- Add Contract Number
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
161: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);

Line 160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);

156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_contracts(i).contract_name);
157: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name) || ' : '|| selected_contracts(i).contract_name);
158:
159: -- Add Contract Number
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
161: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
162:
163: -- Add Contract Version Number
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);

Line 161: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);

157: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name) || ' : '|| selected_contracts(i).contract_name);
158:
159: -- Add Contract Number
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
161: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
162:
163: -- Add Contract Version Number
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
165: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);

Line 164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);

160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
161: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
162:
163: -- Add Contract Version Number
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
165: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
166:
167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
168: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 165: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);

161: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_contracts(i).contract_number);
162:
163: -- Add Contract Version Number
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
165: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
166:
167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
168: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
169:

Line 167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

163: -- Add Contract Version Number
164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
165: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
166:
167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
168: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
169:
170: -- Prepare a number array of contract ids, this is required by the UPDATE
171: -- statement under FORALL as it will not take selected_contracts(i).contract_id in the WHERE clause

Line 168: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
165: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_contracts(i).contract_version_num);
166:
167: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
168: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
169:
170: -- Prepare a number array of contract ids, this is required by the UPDATE
171: -- statement under FORALL as it will not take selected_contracts(i).contract_id in the WHERE clause
172: -- Getting the following compilation error

Line 206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

202: IF (l_first_iteration = 'Y') THEN
203:
204: l_first_iteration := 'N';
205:
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));

Line 207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

203:
204: l_first_iteration := 'N';
205:
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
211: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');

Line 208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));

204: l_first_iteration := 'N';
205:
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
211: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
212:

Line 209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');

205:
206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
211: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
212:
213: END IF;

Line 210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));

206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
211: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
212:
213: END IF;
214:

Line 211: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');

207: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '================');
210: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_CONTRACT_DETAILS'));
211: FND_FILE.PUT_LINE(FND_FILE.LOG, '================');
212:
213: END IF;
214:
215: FOR i IN 1..NVL(selected_vers_contracts.LAST, -1) LOOP

Line 226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);

222: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_ATTR_CON_NAME',l_doc_type);
223: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
224: -- Add Contract Name
225:
226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
227: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
228:
229: -- Add Contract Number
230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);

223: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
224: -- Add Contract Name
225:
226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
227: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
228:
229: -- Add Contract Number
230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
231: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);

Line 230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);

226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
227: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
228:
229: -- Add Contract Number
230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
231: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
232:
233: -- Add Contract Version Number
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);

Line 231: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);

227: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : '|| selected_vers_contracts(i).contract_name);
228:
229: -- Add Contract Number
230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
231: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
232:
233: -- Add Contract Version Number
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);

Line 234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);

230: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
231: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
232:
233: -- Add Contract Version Number
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
238: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 235: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);

231: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_NUMBER') || ' : '|| selected_vers_contracts(i).contract_number);
232:
233: -- Add Contract Version Number
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
238: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
239:

Line 237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

233: -- Add Contract Version Number
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
238: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
239:
240: -- Prepare a number array of contract ids and version numbers, this is required by the UPDATE
241: -- statement under FORALL as it will not take selected_vers_contracts(i).contract_id in the WHERE clause

Line 238: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
235: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_SW_ATTR_CON_VER_NUM') || ' : '|| selected_vers_contracts(i).contract_version_num);
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
238: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
239:
240: -- Prepare a number array of contract ids and version numbers, this is required by the UPDATE
241: -- statement under FORALL as it will not take selected_vers_contracts(i).contract_id in the WHERE clause
242: -- Getting the following compilation error

Line 268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : ' || l_count);

264: l_doc_type := OKC_API.get_contract_type(l_contract_id);
265: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_UPD_STS_SUMMARY',l_doc_type);
266: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
267:
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : ' || l_count);
269: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : ' || l_count);
270:
271: COMMIT;
272:

Line 269: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : ' || l_count);

265: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_UPD_STS_SUMMARY',l_doc_type);
266: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
267:
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : ' || l_count);
269: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token) || ' : ' || l_count);
270:
271: COMMIT;
272:
273: EXCEPTION

Line 281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));

277: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_UPD_STS_ERROR',l_doc_type);
278: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
279:
280:
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);

Line 282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));

278: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
279:
280:
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
286:

Line 284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);

280:
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
286:
287: ROLLBACK;
288:

Line 285: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);

281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
282: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, l_resolved_msg_name,'HDR_TOKEN',l_resolved_token));
283:
284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
285: FND_FILE.PUT_LINE(FND_FILE.LOG, OKC_TERMS_UTIL_PVT.get_message(G_APP_NAME, 'OKC_REP_UPD_STS_SYS_ERR') || ' ' || sqlerrm);
286:
287: ROLLBACK;
288:
289: --close cursors

Line 346: FND_FILE.PUT_LINE(FND_FILE.LOG, '* BEGIN contract_status_update_manager *');

342: l_status VARCHAR2(32);
343:
344: BEGIN
345:
346: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** BEGIN contract_status_update_manager *****');
347:
348: l_api_name := 'contract_status_update_manager';
349: l_api_version := 1.0;
350: l_init_msg_list := FND_API.G_FALSE;

Line 353: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status = (' || p_status || ')');

349: l_api_version := 1.0;
350: l_init_msg_list := FND_API.G_FALSE;
351: l_status := 'NONE';
352:
353: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status = (' || p_status || ')');
354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_status = (' || l_status || ')');
355:
356: IF p_status IS NULL OR LENGTH(TRIM(p_status)) = 0 THEN
357: l_status := G_REP_CON_STATUS_TERMINATED;

Line 354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_status = (' || l_status || ')');

350: l_init_msg_list := FND_API.G_FALSE;
351: l_status := 'NONE';
352:
353: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_status = (' || p_status || ')');
354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_status = (' || l_status || ')');
355:
356: IF p_status IS NULL OR LENGTH(TRIM(p_status)) = 0 THEN
357: l_status := G_REP_CON_STATUS_TERMINATED;
358: END IF;

Line 360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_status = (' || l_status || ')');

356: IF p_status IS NULL OR LENGTH(TRIM(p_status)) = 0 THEN
357: l_status := G_REP_CON_STATUS_TERMINATED;
358: END IF;
359:
360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_status = (' || l_status || ')');
361:
362: contract_status_updater(
363: p_api_version => l_api_version,
364: p_init_msg_list => l_init_msg_list,

Line 376: FND_FILE.PUT_LINE(FND_FILE.LOG, '* END contract_status_update_manager() *');

372: retcode := G_RETURN_CODE_ERROR;
373: errbuf := substr(FND_MSG_PUB.Get(), 1, 200);
374: END IF;
375:
376: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** END contract_status_update_manager() *****');
377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** EXCEPTION OTHERS*****');

Line 380: FND_FILE.PUT_LINE(FND_FILE.LOG, '* EXCEPTION OTHERS*');

376: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** END contract_status_update_manager() *****');
377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** EXCEPTION OTHERS*****');
381: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
382:
383: retcode := G_RETURN_CODE_ERROR;
384: errbuf := substr(SQLERRM, 1, 200);

Line 381: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);

377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** EXCEPTION OTHERS*****');
381: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM);
382:
383: retcode := G_RETURN_CODE_ERROR;
384: errbuf := substr(SQLERRM, 1, 200);
385: