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 527: iex_debug_pub.logmessage ('profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());

523: begin
524: l_profile_id := p_event.GetValueForParameter('CUST_ACCOUNT_PROFILE_ID');
525:
526: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
527: iex_debug_pub.logmessage ('profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
528: iex_debug_pub.logmessage ('profile_check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
529: END IF;
530:
531: BEGIN

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

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

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

548: END IF;
549: ELSE
550: IF pg_debug <=10
551: THEN
552: iex_debug_pub.LogMessage('IEX_TERR_PUB.profile_check Skipped ' );
553: END IF;
554: END IF;
555:
556:

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

555:
556:
557: EXCEPTION
558: WHEN others then
559: iex_debug_pub.logmessage (' Error in profile_check: ' || 'P_CUST_ACCOUNT_PROFILE_ID =>' ||l_profile_id);
560: logmessage ('Exception occurred profile_check: ' || 'P_CUST_ACCOUNT_PROFILE_IDt =>'|| l_profile_id);
561: END;
562:
563: RETURN 'SUCCESS';

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

565: EXCEPTION
566: WHEN EXC THEN
567: logmessage ('exception in profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
569: iex_debug_pub.logmessage ('profile_check: ' || 'raised exe error');
570: END IF;
571: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profile_check', p_event.getEventName(), p_subscription_guid);
572: WF_EVENT.setErrorInfo(p_event, 'ERROR');
573: RETURN 'ERROR';

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

609: PG_DEBUG := 0;
610:
611: --IF PG_DEBUG < 10 THEN
612: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
613: iex_debug_pub.logmessage ('profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
614: iex_debug_pub.logmessage ('profileamt_check: ' || 'CUST_ACCT_PROFILE_AMT_ID =>' || l_prof_amt);
615: END IF;
616:
617: IF x_return_status <> 'S' THEN

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

610:
611: --IF PG_DEBUG < 10 THEN
612: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
613: iex_debug_pub.logmessage ('profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
614: iex_debug_pub.logmessage ('profileamt_check: ' || 'CUST_ACCT_PROFILE_AMT_ID =>' || l_prof_amt);
615: END IF;
616:
617: IF x_return_status <> 'S' THEN
618: RAISE EXC;

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

623: EXCEPTION
624: WHEN EXC THEN
625: logmessage ('exception exc profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
627: iex_debug_pub.logmessage ('profileamt_check: ' || 'raised exe error');
628: END IF;
629: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profileamt_check', p_event.getEventName(), p_subscription_guid);
630: WF_EVENT.setErrorInfo(p_event, 'ERROR');
631: RETURN 'ERROR';

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

664: logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id);
665:
666: --IF PG_DEBUG < 10 THEN
667: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
668: iex_debug_pub.logmessage ('acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
669: iex_debug_pub.logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id );
670: END IF;
671:
672: IF x_return_status <> 'S' THEN

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

665:
666: --IF PG_DEBUG < 10 THEN
667: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
668: iex_debug_pub.logmessage ('acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
669: iex_debug_pub.logmessage ('acctsite_check: ' || 'ACCOUNT_SITE_ID =>' || l_acct_site_id );
670: END IF;
671:
672: IF x_return_status <> 'S' THEN
673: RAISE EXC;

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

678: WHEN EXC THEN
679: logmessage ('Exception exc acctsite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
680: -- IF PG_DEBUG < 10 THEN
681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
682: iex_debug_pub.logmessage ('acctsite_check: ' || 'raised exe error');
683: END IF;
684: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'acctsite_check', p_event.getEventName(), p_subscription_guid);
685: WF_EVENT.setErrorInfo(p_event, 'ERROR');
686: RETURN 'ERROR';

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

779: logmessage ('acctsiteuse_check: ' || ' x_msg_data => ' || l_msg_data);
780:
781: --IF PG_DEBUG < 10 THEN
782: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
783: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
784: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_acctsiteuse_id );
785: END IF;
786:
787: IF x_return_status <> 'S' THEN

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

780:
781: --IF PG_DEBUG < 10 THEN
782: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
783: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
784: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_acctsiteuse_id );
785: END IF;
786:
787: IF x_return_status <> 'S' THEN
788: RAISE EXC;

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

793: WHEN EXC THEN
794: logmessage ('Exception exc acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
795: -- IF PG_DEBUG < 10 THEN
796: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
797: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'raised exe error');
798: END IF;
799: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'acctsiteuse_check', p_event.getEventName(), p_subscription_guid);
800: WF_EVENT.setErrorInfo(p_event, 'ERROR');
801: RETURN 'ERROR';

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

840: logmessage ('acctsiteuse_check: ' || 'FINANCIAL_PROFILE_ID =>' || l_finprofile_id);
841:
842: --IF PG_DEBUG < 10 THEN
843: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
844: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
845: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_finprofile_id );
846: END IF;
847:
848: IF x_return_status <> 'S' THEN

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

841:
842: --IF PG_DEBUG < 10 THEN
843: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
844: iex_debug_pub.logmessage ('acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
845: iex_debug_pub.logmessage ('acctsiteuse_check: ' || '_ID =>' || l_finprofile_id );
846: END IF;
847:
848: IF x_return_status <> 'S' THEN
849: RAISE EXC;

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

853: EXCEPTION
854: WHEN EXC THEN
855: logmessage ('Exception exc acctsiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
856: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
857: iex_debug_pub.logmessage ('finprofile_check: ' || 'raised exe error');
858: END IF;
859: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'finprofile_check', p_event.getEventName(), p_subscription_guid);
860: WF_EVENT.setErrorInfo(p_event, 'ERROR');
861: RETURN 'ERROR';

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

935: ' AND party.country = fnd_terr.territory_code(+) ' ||
936: ' AND fnd_terr.LANGUAGE(+) = userenv(''LANG'') ' ;
937:
938: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
939: iex_debug_pub.logmessage ('Started TCA IEX Summarty Synchronization for level ' || p_level);
940: END IF;
941:
942: -- Bug #6251613 bibeura 11-Dec-2007 Used Bind Variables for Dynamic SQL to avoid performance problem
943: IF (p_level = 'PARTY') THEN

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

951: HZ_CUST_ACCOUNTS WHERE
952: CUST_ACCOUNT_ID = p_party_id;
953: EXCEPTION WHEN OTHERS THEN
954: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
955: iex_debug_pub.logmessage ('IEX Summarty Synchronization , Error occurred in party_id select ' || sqlerrm);
956: END IF;
957: END;
958:
959: END IF;

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

980: l_phone_extension;
981: EXIT;
982: END LOOP;
983: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
984: iex_debug_pub.logmessage ('IEX Summarty Synchronization , fetching values ' );
985: END IF;
986:
987: BEGIN
988: UPDATE IEX_DLN_UWQ_SUMMARY SET

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

1001: phone_extension = l_phone_extension
1002: WHERE party_id = l_party_id;
1003: EXCEPTION WHEN OTHERS THEN
1004: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1005: iex_debug_pub.logmessage ('IEX Summarty Synchronization error occurred while updating ' || sqlerrm );
1006: END IF;
1007: END;
1008:
1009: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1006: END IF;
1007: END;
1008:
1009: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1010: iex_debug_pub.logmessage ('IEX Summary Synchronization , Completed Update. ' );
1011: END IF;
1012:
1013: ELSE
1014:

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

1044: RETURN 'S';
1045:
1046: EXCEPTION WHEN OTHERS THEN
1047: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1048: iex_debug_pub.logmessage ('IEX Summarty Synchronization error occurred' || sqlerrm );
1049: END IF;
1050: RETURN 'F';
1051: END SYNC_TCA_SUMMARY;
1052: