DBA Data[Home] [Help]

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.0.12000000.1 2007/05/02 07:07:35 appldev noship $*/
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 88: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Skipped ' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

281: BEGIN
282:
283: IF pg_debug <=10
284: THEN
285: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );
286: END IF;
287: l_adjustment_id := p_event.GetValueForParameter('ADJUSTMENT_ID');
288: l_org_id := p_event.GetValueForParameter('ORG_ID');
289: l_user_id := p_event.GetValueForParameter('USER_ID');

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

309: x_return_status := UPDATE_SUMMARY(l_adjustment_id,l_org_id ,'ADJ');
310: ELSE
311: IF pg_debug <=10
312: THEN
313: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Skipped ' );
314: END IF;
315: END IF;
316:
317: IF pg_debug <=10

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

315: END IF;
316:
317: IF pg_debug <=10
318: THEN
319: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Finished ' );
320: END IF;
321:
322: Return 'SUCCESS';
323:

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

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

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

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

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

379: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOADJ');
380: ELSE
381: IF pg_debug <=10
382: THEN
383: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Skipped ' );
384: END IF;
385: END IF;
386:
387: IF pg_debug <=10

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

385: END IF;
386:
387: IF pg_debug <=10
388: THEN
389: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Finished ' );
390: END IF;
391:
392:
393: Return 'SUCCESS';

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

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

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

423: BEGIN
424:
425: IF pg_debug <=10
426: THEN
427: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Started ' );
428: END IF;
429:
430:
431: l_request_id := p_event.GetValueForParameter('REQUEST_ID');

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

454: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOREC');
455: ELSE
456: IF pg_debug <=10
457: THEN
458: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Skipped ' );
459: END IF;
460: END IF;
461:
462: IF pg_debug <=10

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

460: END IF;
461:
462: IF pg_debug <=10
463: THEN
464: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Finished ' );
465: END IF;
466:
467: Return 'SUCCESS';
468:

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

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

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

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

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

523: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOINV');
524: ELSE
525: IF pg_debug <=10
526: THEN
527: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Skipped ' );
528: END IF;
529: END IF;
530:
531: IF pg_debug <=10

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

529: END IF;
530:
531: IF pg_debug <=10
532: THEN
533: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Finished ' );
534: END IF;
535:
536: Return 'SUCCESS';
537:

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

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

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

1178: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1179: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1180: FND_MSG_PUB.ADD;
1181:
1182: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);
1183:
1184: RETURN 'ERROR';
1185: END UPDATE_SUMMARY;
1186:

Line 1189: END IEX_BUS_EVENT_SUB_PVT; -- Package spec

1185: END UPDATE_SUMMARY;
1186:
1187:
1188:
1189: END IEX_BUS_EVENT_SUB_PVT; -- Package spec