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.IEX_ASSIGN_COLL_LEVEL_PVT dependencies on IEX_DEBUG_PUB

Line 108: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Starting MAIN PROCESS .....');

104: select define_party_running_level,using_delinquency_level,using_billto_level,using_account_level,using_customer_level
105: into l_party_level,l_using_del_level,l_using_billto_level,l_using_acc_level,l_using_cust_level
106: from iex_questionnaire_items;
107:
108: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Starting MAIN PROCESS .....');
109: select max(request_id) into l_req_id from iex_score_histories where score_object_code <> 'IEX_INVOICES';
110:
111: --Begin Bug 8839374 16-Feb-2010 barathsr
112: if l_party_level <> 'Y' then

Line 156: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- Exception = ' ||SQLERRM);

152: Close C_get_PartyId_Account;
153:
154: exception
155: when others then
156: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- Exception = ' ||SQLERRM);
157: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjCode = ' ||'ACCOUNT');
158: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjId = ' ||v_score_object_id(i));
159: l_party_id := 0;
160: end;

Line 157: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjCode = ' ||'ACCOUNT');

153:
154: exception
155: when others then
156: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- Exception = ' ||SQLERRM);
157: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjCode = ' ||'ACCOUNT');
158: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjId = ' ||v_score_object_id(i));
159: l_party_id := 0;
160: end;
161:

Line 158: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjId = ' ||v_score_object_id(i));

154: exception
155: when others then
156: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- Exception = ' ||SQLERRM);
157: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjCode = ' ||'ACCOUNT');
158: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Account- ObjId = ' ||v_score_object_id(i));
159: l_party_id := 0;
160: end;
161:
162: if (l_party_id > 0) then

Line 168: iex_debug_pub.logmessage('ASSIGN LEVEL Account Party Does Not Exist for Account = '||v_score_object_id(i));

164: t_level_tbl(i).ObjectCode := 'ACCOUNT';
165: t_level_tbl(i).party_id := l_party_id;
166:
167: else
168: iex_debug_pub.logmessage('ASSIGN LEVEL Account Party Does Not Exist for Account = '||v_score_object_id(i));
169: end if;
170:
171: ELSIF v_score_object_code(i) = 'IEX_DELINQUENCY' and l_using_del_level='Y' then
172:

Line 184: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- Exception = ' ||SQLERRM);

180: Close C_get_PartyId_Del;
181:
182: exception
183: when others then
184: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- Exception = ' ||SQLERRM);
185: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjCode = ' ||'DELINQUENCY');
186: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjId = ' ||v_score_object_id(i));
187: l_party_id := 0;
188: end;

Line 185: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjCode = ' ||'DELINQUENCY');

181:
182: exception
183: when others then
184: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- Exception = ' ||SQLERRM);
185: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjCode = ' ||'DELINQUENCY');
186: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjId = ' ||v_score_object_id(i));
187: l_party_id := 0;
188: end;
189:

Line 186: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjId = ' ||v_score_object_id(i));

182: exception
183: when others then
184: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- Exception = ' ||SQLERRM);
185: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjCode = ' ||'DELINQUENCY');
186: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_Del- ObjId = ' ||v_score_object_id(i));
187: l_party_id := 0;
188: end;
189:
190: if (l_party_id > 0) then

Line 196: iex_debug_pub.logmessage('ASSIGN LEVEL Delinquency Party Does Not Exist for Deliquency = '||v_score_object_id(i));

192: t_level_tbl(i).ObjectCode := 'DELINQUENCY';
193: t_level_tbl(i).party_id := l_party_id;
194:
195: else
196: iex_debug_pub.logmessage('ASSIGN LEVEL Delinquency Party Does Not Exist for Deliquency = '||v_score_object_id(i));
197: end if;
198:
199: ELSIF v_score_object_code(i) = 'IEX_BILLTO' and l_using_billto_level='Y' then
200:

Line 212: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-Exception = ' ||SQLERRM);

208: Close C_get_PartyId_BillTo;
209:
210: exception
211: when others then
212: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-Exception = ' ||SQLERRM);
213: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjCode = ' ||'BILLTO');
214: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjId = ' ||v_score_object_id(i));
215: l_party_id := 0;
216: end;

Line 213: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjCode = ' ||'BILLTO');

209:
210: exception
211: when others then
212: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-Exception = ' ||SQLERRM);
213: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjCode = ' ||'BILLTO');
214: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjId = ' ||v_score_object_id(i));
215: l_party_id := 0;
216: end;
217:

Line 214: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjId = ' ||v_score_object_id(i));

210: exception
211: when others then
212: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-Exception = ' ||SQLERRM);
213: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjCode = ' ||'BILLTO');
214: iex_debug_pub.logmessage('ASSIGN COLLECTION LEVEL-C_get_PartyId_BillTo-ObjId = ' ||v_score_object_id(i));
215: l_party_id := 0;
216: end;
217:
218: if (l_party_id > 0) then

Line 224: iex_debug_pub.logmessage('ASSIGN LEVEL BILLTO Party Does Not Exist for Site Use ID = '||v_score_object_id(i));

220: t_level_tbl(i).ObjectCode := 'BILL_TO';
221: t_level_tbl(i).party_id := l_party_id;
222:
223: else
224: iex_debug_pub.logmessage('ASSIGN LEVEL BILLTO Party Does Not Exist for Site Use ID = '||v_score_object_id(i));
225: end if;
226: --Begin Bug 8839374 16-Feb-2010 barathsr
227: ELSE
228: if FND_GLOBAL.Conc_Request_Id is not null then

Line 279: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Insert Party Count = '||G_insert_count);

275: END LOOP;
276:
277: CLOSE C_get_CodeIds;
278:
279: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Insert Party Count = '||G_insert_count);
280: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Update Party Count = '||G_update_count);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Parties Assigned Collection Level Created..>> '|| G_insert_count);
282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Parties Assigned Collection Level Updated..>> '|| G_update_count);
283:

Line 280: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Update Party Count = '||G_update_count);

276:
277: CLOSE C_get_CodeIds;
278:
279: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Insert Party Count = '||G_insert_count);
280: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - Update Party Count = '||G_update_count);
281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Parties Assigned Collection Level Created..>> '|| G_insert_count);
282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Parties Assigned Collection Level Updated..>> '|| G_update_count);
283:
284: if l_return_status <> 'S' then

Line 285: iex_debug_pub.logmessage('Error from IEX_PARTY_PREF_PUB ..>> '||l_msg_data);

281: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Parties Assigned Collection Level Created..>> '|| G_insert_count);
282: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Parties Assigned Collection Level Updated..>> '|| G_update_count);
283:
284: if l_return_status <> 'S' then
285: iex_debug_pub.logmessage('Error from IEX_PARTY_PREF_PUB ..>> '||l_msg_data);
286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error from IEX_PARTY_PREF_PUB ..>> '||l_msg_data);
287: ERRBUF := ' ASSIGN COLLECTION LEVEL - - Exception = ' ||SQLERRM;
288: RETCODE := -1;
289: end if;

Line 293: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - - Exception = ' ||SQLERRM);

289: end if;
290:
291: EXCEPTION
292: when others then
293: iex_debug_pub.logmessage (' ASSIGN COLLECTION LEVEL - - Exception = ' ||SQLERRM);
294: ERRBUF := ' ASSIGN COLLECTION LEVEL - - Exception = ' ||SQLERRM;
295: RETCODE := -1;
296:
297: END;