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 529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1024: 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
1025: iex_debug_pub.logmessage ('IEX Summary Synchronization , Completed Update. ' );
1026: END IF;
1027:
1028: ELSE

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

1063: logMessage ('IEX Summary Synchronization ==> P_ACCOUNT_ID : ' || P_ACCOUNT_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 );

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

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