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_TERR_PUB dependencies on IEX_DEBUG_PUB

Line 71: iex_debug_pub.logmessage ('party_check: ' || 'EVENT NAME =>'||p_event.getEventName());

67: l_party_id := p_event.GetValueForParameter('PARTY_ID');
68: logmessage ('party_check: ' || 'PARTY_ID =>' || l_party_id);
69: --PG_DEBUG := 0;
70: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
71: iex_debug_pub.logmessage ('party_check: ' || 'EVENT NAME =>'||p_event.getEventName());
72: iex_debug_pub.logmessage ('party_check: ' || 'PARTY_ID =>' || l_party_id);
73: END IF;
74:
75: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 72: iex_debug_pub.logmessage ('party_check: ' || 'PARTY_ID =>' || l_party_id);

68: logmessage ('party_check: ' || 'PARTY_ID =>' || l_party_id);
69: --PG_DEBUG := 0;
70: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
71: iex_debug_pub.logmessage ('party_check: ' || 'EVENT NAME =>'||p_event.getEventName());
72: iex_debug_pub.logmessage ('party_check: ' || 'PARTY_ID =>' || l_party_id);
73: END IF;
74:
75: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
76: iex_debug_pub.logmessage (' Start IEX Summarty Synchronization ');

Line 76: iex_debug_pub.logmessage (' Start IEX Summarty Synchronization ');

72: iex_debug_pub.logmessage ('party_check: ' || 'PARTY_ID =>' || l_party_id);
73: END IF;
74:
75: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
76: iex_debug_pub.logmessage (' Start IEX Summarty Synchronization ');
77: END IF;
78:
79: IF NOT isRefreshProgramsRunning THEN
80: x_return_status := SYNC_TCA_SUMMARY(p_party_id =>l_party_id,p_level=>'PARTY');

Line 87: iex_debug_pub.LogMessage('IEX_TERR_PUB.party_check Skipped ' );

83: END IF;
84: ELSE
85: IF pg_debug <=10
86: THEN
87: iex_debug_pub.LogMessage('IEX_TERR_PUB.party_check Skipped ' );
88: END IF;
89: END IF;
90:
91: RETURN 'SUCCESS';

Line 97: iex_debug_pub.logmessage ('party_check: ' || 'raised exe error');

93: EXCEPTION
94: WHEN EXC THEN
95: logmessage ('exception exc party_check: ' || 'EVENT NAME =>'||p_event.getEventName());
96: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
97: iex_debug_pub.logmessage ('party_check: ' || 'raised exe error');
98: END IF;
99: WF_CORE.CONTEXT('IEX_TERR_PUB', 'party_check', p_event.getEventName(), p_subscription_guid);
100: WF_EVENT.setErrorInfo(p_event, 'ERROR');
101: RETURN 'ERROR';

Line 137: iex_debug_pub.logmessage ('partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());

133: logmessage ('partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
134: l_partysite_id := p_event.GetValueForParameter('PARTY_SITE_ID');
135: logmessage ('partysite_check: ' || 'PARTY_SITE_ID =>' || l_partysite_id);
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: iex_debug_pub.logmessage ('partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
138: iex_debug_pub.logmessage ('partysite_check: ' || 'PARTY_SITE_ID =>' || l_partysite_id);
139: END IF;
140:
141: IF x_return_status <> 'S' THEN

Line 138: iex_debug_pub.logmessage ('partysite_check: ' || 'PARTY_SITE_ID =>' || l_partysite_id);

134: l_partysite_id := p_event.GetValueForParameter('PARTY_SITE_ID');
135: logmessage ('partysite_check: ' || 'PARTY_SITE_ID =>' || l_partysite_id);
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: iex_debug_pub.logmessage ('partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
138: iex_debug_pub.logmessage ('partysite_check: ' || 'PARTY_SITE_ID =>' || l_partysite_id);
139: END IF;
140:
141: IF x_return_status <> 'S' THEN
142: RAISE EXC;

Line 151: iex_debug_pub.logmessage ('partysite_check: ' || 'raised exe error');

147: EXCEPTION
148: WHEN EXC THEN
149: logmessage ('exception exc partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: iex_debug_pub.logmessage ('partysite_check: ' || 'raised exe error');
152: END IF;
153: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysite_check', p_event.getEventName(), p_subscription_guid);
154: WF_EVENT.setErrorInfo(p_event, 'ERROR');
155: RETURN 'ERROR';

Line 194: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());

190:
191: logmessage ('partysiteuse_check: ' || 'PARTY_SITE_USE_ID =>' || l_partysiteuse_id);
192:
193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
194: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
195: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'PARTY_SITE_USE_ID =>' || l_partysiteuse_id);
196: END IF;
197:
198: IF x_return_status <> 'S' THEN

Line 195: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'PARTY_SITE_USE_ID =>' || l_partysiteuse_id);

191: logmessage ('partysiteuse_check: ' || 'PARTY_SITE_USE_ID =>' || l_partysiteuse_id);
192:
193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
194: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
195: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'PARTY_SITE_USE_ID =>' || l_partysiteuse_id);
196: END IF;
197:
198: IF x_return_status <> 'S' THEN
199: RAISE EXC;

Line 208: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'raised exe error');

204: EXCEPTION
205: WHEN EXC THEN
206: logmessage ('Exception exc partysiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
207: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
208: iex_debug_pub.logmessage ('partysiteuse_check: ' || 'raised exe error');
209: END IF;
210: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysiteuse_check', p_event.getEventName(), p_subscription_guid);
211: WF_EVENT.setErrorInfo(p_event, 'ERROR');
212: RETURN 'ERROR';

Line 250: iex_debug_pub.logmessage ('location_check: ' || 'EVENT NAME =>'||p_event.getEventName());

246: --PG_DEBUG := 0;
247: logmessage ('location_check: ' || 'LOCATION_ID =>' || l_location_id);
248:
249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
250: iex_debug_pub.logmessage ('location_check: ' || 'EVENT NAME =>'||p_event.getEventName());
251: iex_debug_pub.logmessage ('location_check: ' || 'PARTY_SITE_USE_ID =>' || l_location_id);
252: END IF;
253:
254: IF x_return_status <> 'S' THEN

Line 251: iex_debug_pub.logmessage ('location_check: ' || 'PARTY_SITE_USE_ID =>' || l_location_id);

247: logmessage ('location_check: ' || 'LOCATION_ID =>' || l_location_id);
248:
249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
250: iex_debug_pub.logmessage ('location_check: ' || 'EVENT NAME =>'||p_event.getEventName());
251: iex_debug_pub.logmessage ('location_check: ' || 'PARTY_SITE_USE_ID =>' || l_location_id);
252: END IF;
253:
254: IF x_return_status <> 'S' THEN
255: RAISE EXC;

Line 264: iex_debug_pub.logmessage ('location_check: ' || 'raised exe error');

260: EXCEPTION
261: WHEN EXC THEN
262: logmessage ('Exception exc location_check: ' || 'EVENT NAME =>'||p_event.getEventName());
263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
264: iex_debug_pub.logmessage ('location_check: ' || 'raised exe error');
265: END IF;
266: WF_CORE.CONTEXT('IEX_TERR_PUB', 'location_check', p_event.getEventName(), p_subscription_guid);
267: WF_EVENT.setErrorInfo(p_event, 'ERROR');
268: RETURN 'ERROR';

Line 335: iex_debug_pub.logmessage ('account_check: ' || 'EVENT NAME =>'||p_event.getEventName());

331: logmessage ('Account Check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);
332:
333:
334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
335: iex_debug_pub.logmessage ('account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
336: iex_debug_pub.logmessage ('account_check: ' || 'PARTY_ID =>' || l_party_id);
337: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_ID =>' || l_custaccount_id);
338: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
339: iex_debug_pub.logmessage ('account_check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);

Line 336: iex_debug_pub.logmessage ('account_check: ' || 'PARTY_ID =>' || l_party_id);

332:
333:
334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
335: iex_debug_pub.logmessage ('account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
336: iex_debug_pub.logmessage ('account_check: ' || 'PARTY_ID =>' || l_party_id);
337: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_ID =>' || l_custaccount_id);
338: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
339: iex_debug_pub.logmessage ('account_check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);
340: END IF;

Line 337: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_ID =>' || l_custaccount_id);

333:
334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
335: iex_debug_pub.logmessage ('account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
336: iex_debug_pub.logmessage ('account_check: ' || 'PARTY_ID =>' || l_party_id);
337: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_ID =>' || l_custaccount_id);
338: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
339: iex_debug_pub.logmessage ('account_check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);
340: END IF;
341:

Line 338: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);

334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
335: iex_debug_pub.logmessage ('account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
336: iex_debug_pub.logmessage ('account_check: ' || 'PARTY_ID =>' || l_party_id);
337: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_ID =>' || l_custaccount_id);
338: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
339: iex_debug_pub.logmessage ('account_check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);
340: END IF;
341:
342:

Line 339: iex_debug_pub.logmessage ('account_check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);

335: iex_debug_pub.logmessage ('account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
336: iex_debug_pub.logmessage ('account_check: ' || 'PARTY_ID =>' || l_party_id);
337: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_ID =>' || l_custaccount_id);
338: iex_debug_pub.logmessage ('account_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
339: iex_debug_pub.logmessage ('account_check: ' || 'P_CREATE_PROFILE_AMT =>' ||l_prof_amt_id);
340: END IF;
341:
342:
343: logmessage ('account_check: ' || ' custaccount_id = '|| l_custaccount_id ||

Line 478: iex_debug_pub.LogMessage('IEX_TERR_PUB.account_check Skipped ' );

474: END IF;
475: ELSE
476: IF pg_debug <=10
477: THEN
478: iex_debug_pub.LogMessage('IEX_TERR_PUB.account_check Skipped ' );
479: END IF;
480: END IF;
481:
482: RETURN 'SUCCESS';

Line 488: iex_debug_pub.logmessage ('account_check: ' || 'raised exe error');

484: EXCEPTION
485: WHEN EXC THEN
486: logmessage ('Exception exc account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
487: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
488: iex_debug_pub.logmessage ('account_check: ' || 'raised exe error');
489: END IF;
490: WF_CORE.CONTEXT('IEX_TERR_PUB', 'account_check', p_event.getEventName(), p_subscription_guid);
491: WF_EVENT.setErrorInfo(p_event, 'ERROR');
492: RETURN 'ERROR';

Line 530: iex_debug_pub.logmessage ('profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());

526: logMessage ('profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
527: logMessage ('profile_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
528:
529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
530: iex_debug_pub.logmessage ('profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
531: iex_debug_pub.logmessage ('profile_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
532: END IF;
533:
534: BEGIN

Line 531: iex_debug_pub.logmessage ('profile_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);

527: logMessage ('profile_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
528:
529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
530: iex_debug_pub.logmessage ('profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
531: iex_debug_pub.logmessage ('profile_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
532: END IF;
533:
534: BEGIN
535: IF NOT isRefreshProgramsRunning THEN

Line 546: iex_debug_pub.logmessage ('profile_check: ' || 'l_custaccount_id =>'||l_custaccount_id);

542: logMessage ('profile_check: ' || 'l_siteuse_id =>' || l_siteuse_id);
543: logMessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);
544:
545: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
546: iex_debug_pub.logmessage ('profile_check: ' || 'l_custaccount_id =>'||l_custaccount_id);
547: iex_debug_pub.logmessage ('profile_check: ' || 'l_siteuse_id =>' || l_siteuse_id);
548: iex_debug_pub.logmessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);
549: END IF;
550:

Line 547: iex_debug_pub.logmessage ('profile_check: ' || 'l_siteuse_id =>' || l_siteuse_id);

543: logMessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);
544:
545: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
546: iex_debug_pub.logmessage ('profile_check: ' || 'l_custaccount_id =>'||l_custaccount_id);
547: iex_debug_pub.logmessage ('profile_check: ' || 'l_siteuse_id =>' || l_siteuse_id);
548: iex_debug_pub.logmessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);
549: END IF;
550:
551: x_return_status := SYNC_TCA_SUMMARY

Line 548: iex_debug_pub.logmessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);

544:
545: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
546: iex_debug_pub.logmessage ('profile_check: ' || 'l_custaccount_id =>'||l_custaccount_id);
547: iex_debug_pub.logmessage ('profile_check: ' || 'l_siteuse_id =>' || l_siteuse_id);
548: iex_debug_pub.logmessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);
549: END IF;
550:
551: x_return_status := SYNC_TCA_SUMMARY
552: ( p_party_id => l_party_id,

Line 566: iex_debug_pub.LogMessage('IEX_TERR_PUB.profile_check Skipped ' );

562: END IF;
563: ELSE
564: IF pg_debug <=10
565: THEN
566: iex_debug_pub.LogMessage('IEX_TERR_PUB.profile_check Skipped ' );
567: END IF;
568: END IF;
569:
570:

Line 573: iex_debug_pub.logmessage (' Error in profile_check: ' || 'P_CUST_ACCOUNT_PROFILE_ID =>' ||l_profile_id);

569:
570:
571: EXCEPTION
572: WHEN others then
573: iex_debug_pub.logmessage (' Error in profile_check: ' || 'P_CUST_ACCOUNT_PROFILE_ID =>' ||l_profile_id);
574: logmessage ('Exception occurred profile_check: ' || 'P_CUST_ACCOUNT_PROFILE_IDt =>'|| l_profile_id);
575: END;
576:
577: RETURN 'SUCCESS';

Line 583: iex_debug_pub.logmessage ('profile_check: ' || 'raised exe error');

579: EXCEPTION
580: WHEN EXC THEN
581: logmessage ('exception in profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
582: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
583: iex_debug_pub.logmessage ('profile_check: ' || 'raised exe error');
584: END IF;
585: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profile_check', p_event.getEventName(), p_subscription_guid);
586: WF_EVENT.setErrorInfo(p_event, 'ERROR');
587: RETURN 'ERROR';

Line 627: iex_debug_pub.logmessage ('profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());

623: PG_DEBUG := 0;
624:
625: --IF PG_DEBUG < 10 THEN
626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
627: iex_debug_pub.logmessage ('profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
628: iex_debug_pub.logmessage ('profileamt_check: ' || 'CUST_ACCT_PROFILE_AMT_ID =>' || l_prof_amt);
629: END IF;
630:
631: IF x_return_status <> 'S' THEN

Line 628: iex_debug_pub.logmessage ('profileamt_check: ' || 'CUST_ACCT_PROFILE_AMT_ID =>' || l_prof_amt);

624:
625: --IF PG_DEBUG < 10 THEN
626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
627: iex_debug_pub.logmessage ('profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
628: iex_debug_pub.logmessage ('profileamt_check: ' || 'CUST_ACCT_PROFILE_AMT_ID =>' || l_prof_amt);
629: END IF;
630:
631: IF x_return_status <> 'S' THEN
632: RAISE EXC;

Line 641: iex_debug_pub.logmessage ('profileamt_check: ' || 'raised exe error');

637: EXCEPTION
638: WHEN EXC THEN
639: logmessage ('exception exc profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
641: iex_debug_pub.logmessage ('profileamt_check: ' || 'raised exe error');
642: END IF;
643: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profileamt_check', p_event.getEventName(), p_subscription_guid);
644: WF_EVENT.setErrorInfo(p_event, 'ERROR');
645: RETURN 'ERROR';

Line 682: iex_debug_pub.logmessage ('acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());

678: logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id);
679:
680: --IF PG_DEBUG < 10 THEN
681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
682: iex_debug_pub.logmessage ('acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
683: iex_debug_pub.logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id );
684: END IF;
685:
686: IF x_return_status <> 'S' THEN

Line 683: iex_debug_pub.logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id );

679:
680: --IF PG_DEBUG < 10 THEN
681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
682: iex_debug_pub.logmessage ('acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
683: iex_debug_pub.logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id );
684: END IF;
685:
686: IF x_return_status <> 'S' THEN
687: RAISE EXC;

Line 696: iex_debug_pub.logmessage ('acctsite_check: ' || 'raised exe error');

692: WHEN EXC THEN
693: logmessage ('Exception exc acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
694: -- IF PG_DEBUG < 10 THEN
695: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
696: iex_debug_pub.logmessage ('acctsite_check: ' || 'raised exe error');
697: END IF;
698: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'acctsite_check', p_event.getEventName(), p_subscription_guid);
699: WF_EVENT.setErrorInfo(p_event, 'ERROR');
700: RETURN 'ERROR';

Line 797: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());

793: logmessage ('acctsiteuse_check: ' || ' x_msg_data => ' || l_msg_data);
794:
795: --IF PG_DEBUG < 10 THEN
796: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
797: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
798: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_acctsiteuse_id );
799: END IF;
800:
801: IF x_return_status <> 'S' THEN

Line 798: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_acctsiteuse_id );

794:
795: --IF PG_DEBUG < 10 THEN
796: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
797: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
798: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_acctsiteuse_id );
799: END IF;
800:
801: IF x_return_status <> 'S' THEN
802: RAISE EXC;

Line 811: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'raised exe error');

807: WHEN EXC THEN
808: logmessage ('Exception exc acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
809: -- IF PG_DEBUG < 10 THEN
810: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
811: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'raised exe error');
812: END IF;
813: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'acctsiteuse_check', p_event.getEventName(), p_subscription_guid);
814: WF_EVENT.setErrorInfo(p_event, 'ERROR');
815: RETURN 'ERROR';

Line 858: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());

854: logmessage ('acctsiteuse_check: ' || 'FINANCIAL_PROFILE_ID =>' || l_finprofile_id);
855:
856: --IF PG_DEBUG < 10 THEN
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
858: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
859: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_finprofile_id );
860: END IF;
861:
862: IF x_return_status <> 'S' THEN

Line 859: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_finprofile_id );

855:
856: --IF PG_DEBUG < 10 THEN
857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
858: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
859: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_finprofile_id );
860: END IF;
861:
862: IF x_return_status <> 'S' THEN
863: RAISE EXC;

Line 871: iex_debug_pub.logmessage ('finprofile_check: ' || 'raised exe error');

867: EXCEPTION
868: WHEN EXC THEN
869: logmessage ('Exception exc acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
870: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
871: iex_debug_pub.logmessage ('finprofile_check: ' || 'raised exe error');
872: END IF;
873: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'finprofile_check', p_event.getEventName(), p_subscription_guid);
874: WF_EVENT.setErrorInfo(p_event, 'ERROR');
875: RETURN 'ERROR';

Line 954: iex_debug_pub.logmessage ('Started TCA IEX Summarty Synchronization for level ' || p_level);

950: ' AND party.country = fnd_terr.territory_code(+) ' ||
951: ' AND fnd_terr.LANGUAGE(+) = userenv(''LANG'') ' ;
952:
953: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
954: iex_debug_pub.logmessage ('Started TCA IEX Summarty Synchronization for level ' || p_level);
955: END IF;
956:
957: -- Bug #6251613 bibeura 11-Dec-2007 Used Bind Variables for Dynamic SQL to avoid performance problem
958: IF (p_level = 'PARTY') THEN

Line 970: iex_debug_pub.logmessage ('IEX Summarty Synchronization , Error occurred in party_id select ' || sqlerrm);

966: HZ_CUST_ACCOUNTS WHERE
967: CUST_ACCOUNT_ID = p_party_id;
968: EXCEPTION WHEN OTHERS THEN
969: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
970: iex_debug_pub.logmessage ('IEX Summarty Synchronization , Error occurred in party_id select ' || sqlerrm);
971: END IF;
972: END;
973:
974: END IF;

Line 999: iex_debug_pub.logmessage ('IEX Summarty Synchronization , fetching values ' );

995: l_phone_extension;
996: EXIT;
997: END LOOP;
998: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
999: iex_debug_pub.logmessage ('IEX Summarty Synchronization , fetching values ' );
1000: END IF;
1001:
1002: BEGIN
1003: UPDATE IEX_DLN_UWQ_SUMMARY SET

Line 1020: iex_debug_pub.logmessage ('IEX Summarty Synchronization error occurred while updating ' || sqlerrm );

1016: phone_extension = l_phone_extension
1017: WHERE party_id = l_party_id;
1018: EXCEPTION WHEN OTHERS THEN
1019: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1020: iex_debug_pub.logmessage ('IEX Summarty Synchronization error occurred while updating ' || sqlerrm );
1021: END IF;
1022: END;
1023:
1024: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1025: iex_debug_pub.logmessage ('IEX Summary Synchronization , Completed Update. ' );

1021: END IF;
1022: END;
1023:
1024: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1025: iex_debug_pub.logmessage ('IEX Summary Synchronization , Completed Update. ' );
1026: END IF;
1027:
1028: ELSE
1029:

Line 1068: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_COLLECTOR_ID : ' || P_COLLECTOR_ID );

1064: logMessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );
1065: logMessage ('IEX Summary Synchronization ==> l_resource_name : '||l_resource_name);
1066: logMessage ('IEX Summary Synchronization ==> l_ieu_param_pk_col : '|| l_ieu_param_pk_col );
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_COLLECTOR_ID : ' || P_COLLECTOR_ID );
1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );
1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );
1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );
1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );

Line 1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );

1065: logMessage ('IEX Summary Synchronization ==> l_resource_name : '||l_resource_name);
1066: logMessage ('IEX Summary Synchronization ==> l_ieu_param_pk_col : '|| l_ieu_param_pk_col );
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_COLLECTOR_ID : ' || P_COLLECTOR_ID );
1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );
1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );
1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );
1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );
1073: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );

Line 1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );

1066: logMessage ('IEX Summary Synchronization ==> l_ieu_param_pk_col : '|| l_ieu_param_pk_col );
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_COLLECTOR_ID : ' || P_COLLECTOR_ID );
1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );
1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );
1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );
1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );
1073: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );
1074: END IF;

Line 1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );

1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_COLLECTOR_ID : ' || P_COLLECTOR_ID );
1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );
1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );
1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );
1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );
1073: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );
1074: END IF;
1075:

Line 1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );

1068: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_COLLECTOR_ID : ' || P_COLLECTOR_ID );
1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );
1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );
1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );
1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );
1073: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );
1074: END IF;
1075:
1076: UPDATE IEX_DLN_UWQ_SUMMARY IDS

Line 1073: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );

1069: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_ID : ' || L_RESOURCE_ID );
1070: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> L_RESOURCE_TYPE : '|| L_RESOURCE_TYPE );
1071: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_PARTY_ID : ' || P_PARTY_ID );
1072: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_ID );
1073: iex_debug_pub.logmessage ('IEX Summary Synchronization ==> P_SITE_USE_ID : '|| P_SITE_USE_ID );
1074: END IF;
1075:
1076: UPDATE IEX_DLN_UWQ_SUMMARY IDS
1077: SET COLLECTOR_ID = P_COLLECTOR_ID,

Line 1095: iex_debug_pub.logmessage ('IEX Summarty Synchronization error occurred' || sqlerrm );

1091: RETURN 'S';
1092:
1093: EXCEPTION WHEN OTHERS THEN
1094: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1095: iex_debug_pub.logmessage ('IEX Summarty Synchronization error occurred' || sqlerrm );
1096: END IF;
1097: RETURN 'F';
1098: END SYNC_TCA_SUMMARY;
1099: