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 FND_LOG

Line 70: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

66: 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:

Line 75: 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 ');
77: END IF;
78:
79: IF NOT isRefreshProgramsRunning THEN

Line 96: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

92:
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');

Line 136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

132: -- writes into the log file
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:

Line 150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

146:
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');

Line 193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

189: --PG_DEBUG := 0;
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:

Line 207: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

203:
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');

Line 249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

245: l_location_id := p_event.GetValueForParameter('LOCATION_ID');
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:

Line 263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

259:
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');

Line 334: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

330: logmessage ('Account Check: ' || 'CUST_ACCOUNT_PROFILE_ID =>' || l_profile_id);
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);

Line 487: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

483:
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');

Line 526: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

522: l_collector_id NUMBER;
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:

Line 568: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

564:
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');

Line 612: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

608:
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:

Line 626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

622:
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');

Line 667: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

663: l_acct_site_id := p_event.GetValueForParameter('CUST_ACCT_SITE_ID');
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:

Line 681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

677: EXCEPTION
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');

Line 782: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

778: logmessage ('acctsiteuse_check: ' || ' x_msg_count => ' || l_msg_count);
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:

Line 796: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

792: EXCEPTION
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');

Line 843: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

839: l_finprofile_id := p_event.GetValueForParameter('FINANCIAL_PROFILE_ID');
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:

Line 856: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

852:
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');

Line 938: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

934: ' AND nvl(phone.do_not_use_flag(+), ''N'') = ''N'' ' ||
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

Line 954: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

950: SELECT PARTY_ID INTO l_party_id from
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:

Line 983: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

979: l_phone_number,
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

Line 1004: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1000: phone_number = l_phone_number,
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:

Line 1009: 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
1010: iex_debug_pub.logmessage ('IEX Summary Synchronization , Completed Update. ' );
1011: END IF;
1012:
1013: ELSE

Line 1047: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1043:
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;