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_BUS_EVENT_SUB_PVT dependencies on IEX_BUS_EVENT_SUB_PVT

Line 1: PACKAGE BODY IEX_BUS_EVENT_SUB_PVT AS

1: PACKAGE BODY IEX_BUS_EVENT_SUB_PVT AS
2: /* $Header: iexbsubb.pls 120.2.12020000.2 2012/12/06 12:44:06 schekuri ship $*/
3:
4: pg_debug NUMBER := nvl(to_number(fnd_profile.value('IEX_DEBUG_LEVEL')),20);
5:

Line 55: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Started ' );

51: BEGIN
52:
53: IF pg_debug <=10
54: THEN
55: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Started ' );
56: END IF;
57:
58: l_customer_trx_id := p_event.GetValueForParameter('CUSTOMER_TRX_ID');
59: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 90: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Skipped ' );

86: x_return_status := UPDATE_SUMMARY(l_customer_trx_id,l_org_id ,'INV');
87: ELSE
88: IF pg_debug <=10
89: THEN
90: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Skipped ' );
91: END IF;
92: END IF;
93:
94: IF pg_debug <=10

Line 96: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Finished ' );

92: END IF;
93:
94: IF pg_debug <=10
95: THEN
96: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Finished ' );
97: END IF;
98:
99: Return 'SUCCESS';
100: EXCEPTION

Line 108: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);

104: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
105: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
106: FND_MSG_PUB.ADD;
107:
108: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);
109: WF_EVENT.setErrorInfo(p_event, 'ERROR');
110:
111: RETURN 'ERROR';
112: END SYNC_SUMMARY;

Line 139: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Started ' );

135: BEGIN
136:
137: IF pg_debug <=10
138: THEN
139: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Started ' );
140: END IF;
141:
142: l_payment_schedule_id := p_event.GetValueForParameter('PAYMENT_SCHEDULE_ID');
143: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 171: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Skipped ' );

167: x_return_status := UPDATE_SUMMARY(l_payment_schedule_id,l_org_id ,'REC');
168: ELSE
169: IF pg_debug <=10
170: THEN
171: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Skipped ' );
172: END IF;
173: END IF;
174:
175: IF pg_debug <=10

Line 177: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Finished ' );

173: END IF;
174:
175: IF pg_debug <=10
176: THEN
177: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Finished ' );
178: END IF;
179:
180: Return 'SUCCESS';
181:

Line 189: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);

185: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
186: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
187: FND_MSG_PUB.ADD;
188:
189: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);
190: WF_EVENT.setErrorInfo(p_event, 'ERROR');
191:
192: RETURN 'ERROR';
193:

Line 213: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Started ' );

209: BEGIN
210:
211: IF pg_debug <=10
212: THEN
213: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Started ' );
214: END IF;
215:
216: l_receivable_application_id :=
217: p_event.GetValueForParameter('RECEIVABLE_APPLICATION_ID');

Line 242: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Skipped ' );

238: x_return_status := UPDATE_SUMMARY(l_receivable_application_id,l_org_id ,'CM');
239: ELSE
240: IF pg_debug <=10
241: THEN
242: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Skipped ' );
243: END IF;
244: END IF;
245:
246:

Line 249: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Finished ' );

245:
246:
247: IF pg_debug <=10
248: THEN
249: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Finished ' );
250: END IF;
251: Return 'SUCCESS';
252:
253: EXCEPTION

Line 260: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);

256: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
257: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
258: FND_MSG_PUB.ADD;
259:
260: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);
261: WF_EVENT.setErrorInfo(p_event, 'ERROR');
262:
263: RETURN 'ERROR';
264:

Line 286: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );

282: BEGIN
283:
284: IF pg_debug <=10
285: THEN
286: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );
287: END IF;
288: -- insert into sch_test values('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ');
289: --commit; --Commented for bug#15932134 schekuri 06-Dec-2012
290: l_adjustment_id := p_event.GetValueForParameter('ADJUSTMENT_ID');

Line 288: -- insert into sch_test values('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ');

284: IF pg_debug <=10
285: THEN
286: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );
287: END IF;
288: -- insert into sch_test values('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ');
289: --commit; --Commented for bug#15932134 schekuri 06-Dec-2012
290: l_adjustment_id := p_event.GetValueForParameter('ADJUSTMENT_ID');
291: l_org_id := p_event.GetValueForParameter('ORG_ID');
292: l_user_id := p_event.GetValueForParameter('USER_ID');

Line 317: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Skipped ' );

313: x_return_status := UPDATE_SUMMARY(l_adjustment_id,l_org_id ,'ADJ');
314: ELSE
315: IF pg_debug <=10
316: THEN
317: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Skipped ' );
318: END IF;
319: END IF;
320:
321: IF pg_debug <=10

Line 323: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Finished ' );

319: END IF;
320:
321: IF pg_debug <=10
322: THEN
323: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Finished ' );
324: END IF;
325:
326: Return 'SUCCESS';
327:

Line 335: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);

331: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
332: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
333: FND_MSG_PUB.ADD;
334:
335: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);
336: WF_EVENT.setErrorInfo(p_event, 'ERROR');
337:
338: RETURN 'ERROR';
339:

Line 359: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Started ' );

355: x_return_status VARCHAR2(30);
356: BEGIN
357: IF pg_debug <=10
358: THEN
359: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Started ' );
360: END IF;
361:
362: l_request_id := p_event.GetValueForParameter('REQUEST_ID');
363: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 387: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Skipped ' );

383: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOADJ');
384: ELSE
385: IF pg_debug <=10
386: THEN
387: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Skipped ' );
388: END IF;
389: END IF;
390:
391: IF pg_debug <=10

Line 393: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Finished ' );

389: END IF;
390:
391: IF pg_debug <=10
392: THEN
393: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Finished ' );
394: END IF;
395:
396:
397: Return 'SUCCESS';

Line 406: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_ADJ', p_event.getEventName(), p_subscription_guid);

402: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
403: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
404: FND_MSG_PUB.ADD;
405:
406: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_ADJ', p_event.getEventName(), p_subscription_guid);
407: WF_EVENT.setErrorInfo(p_event, 'ERROR');
408:
409: RETURN 'ERROR';
410:

Line 431: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Started ' );

427: BEGIN
428:
429: IF pg_debug <=10
430: THEN
431: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Started ' );
432: END IF;
433:
434:
435: l_request_id := p_event.GetValueForParameter('REQUEST_ID');

Line 462: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Skipped ' );

458: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOREC');
459: ELSE
460: IF pg_debug <=10
461: THEN
462: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Skipped ' );
463: END IF;
464: END IF;
465:
466: IF pg_debug <=10

Line 468: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Finished ' );

464: END IF;
465:
466: IF pg_debug <=10
467: THEN
468: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Finished ' );
469: END IF;
470:
471: Return 'SUCCESS';
472:

Line 480: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_RECEIPTS', p_event.getEventName(), p_subscription_guid);

476: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
477: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
478: FND_MSG_PUB.ADD;
479:
480: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_RECEIPTS', p_event.getEventName(), p_subscription_guid);
481: WF_EVENT.setErrorInfo(p_event, 'ERROR');
482:
483: RETURN 'ERROR';
484:

Line 504: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Started ' );

500: x_return_status VARCHAR2(30);
501: BEGIN
502: IF pg_debug <=10
503: THEN
504: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Started ' );
505: END IF;
506:
507: l_request_id := p_event.GetValueForParameter('REQUEST_ID');
508: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 531: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Skipped ' );

527: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOINV');
528: ELSE
529: IF pg_debug <=10
530: THEN
531: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Skipped ' );
532: END IF;
533: END IF;
534:
535: IF pg_debug <=10

Line 537: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Finished ' );

533: END IF;
534:
535: IF pg_debug <=10
536: THEN
537: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Finished ' );
538: END IF;
539:
540: Return 'SUCCESS';
541:

Line 549: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_INVOICES', p_event.getEventName(), p_subscription_guid);

545: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
546: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
547: FND_MSG_PUB.ADD;
548:
549: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_INVOICES', p_event.getEventName(), p_subscription_guid);
550: WF_EVENT.setErrorInfo(p_event, 'ERROR');
551:
552: RETURN 'ERROR';
553:

Line 1209: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);

1205: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1206: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1207: FND_MSG_PUB.ADD;
1208:
1209: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);
1210:
1211: RETURN 'ERROR';
1212: END UPDATE_SUMMARY;
1213:

Line 1216: END IEX_BUS_EVENT_SUB_PVT; -- Package spec

1212: END UPDATE_SUMMARY;
1213:
1214:
1215:
1216: END IEX_BUS_EVENT_SUB_PVT; -- Package spec