DBA Data[Home] [Help]

APPS.IEX_TERR_PUB dependencies on IEX_TERR_PUB

Line 1: PACKAGE BODY IEX_TERR_PUB AS

1: PACKAGE BODY IEX_TERR_PUB AS
2: /* $Header: iexkterb.pls 120.10.12020000.2 2012/12/06 12:49:50 schekuri ship $ */
3:
4:
5: --

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 99: WF_CORE.CONTEXT('IEX_TERR_PUB', 'party_check', p_event.getEventName(), p_subscription_guid);

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';
102: WHEN OTHERS THEN
103: logmessage ('exception others party_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 104: WF_CORE.CONTEXT('IEX_TERR_PUB', 'party_check', p_event.getEventName(), p_subscription_guid);

100: WF_EVENT.setErrorInfo(p_event, 'ERROR');
101: RETURN 'ERROR';
102: WHEN OTHERS THEN
103: logmessage ('exception others party_check: ' || 'EVENT NAME =>'||p_event.getEventName());
104: WF_CORE.CONTEXT('IEX_TERR_PUB', 'party_check', p_event.getEventName(), p_subscription_guid);
105: WF_EVENT.setErrorInfo(p_event, 'ERROR');
106: RETURN 'ERROR';
107:
108: END party_check;

Line 153: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysite_check', p_event.getEventName(), p_subscription_guid);

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';
156: WHEN OTHERS THEN
157: logmessage ('exception others partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 158: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysite_check', p_event.getEventName(), p_subscription_guid);

154: WF_EVENT.setErrorInfo(p_event, 'ERROR');
155: RETURN 'ERROR';
156: WHEN OTHERS THEN
157: logmessage ('exception others partysite_check: ' || 'EVENT NAME =>'||p_event.getEventName());
158: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysite_check', p_event.getEventName(), p_subscription_guid);
159: WF_EVENT.setErrorInfo(p_event, 'ERROR');
160: RETURN 'ERROR';
161:
162:

Line 210: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysiteuse_check', p_event.getEventName(), p_subscription_guid);

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';
213: WHEN OTHERS THEN
214: logmessage ('Exception Others partysiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 215: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysite_check', p_event.getEventName(), p_subscription_guid);

211: WF_EVENT.setErrorInfo(p_event, 'ERROR');
212: RETURN 'ERROR';
213: WHEN OTHERS THEN
214: logmessage ('Exception Others partysiteuse_check: ' || 'EVENT NAME =>'||p_event.getEventName());
215: WF_CORE.CONTEXT('IEX_TERR_PUB', 'partysite_check', p_event.getEventName(), p_subscription_guid);
216: WF_EVENT.setErrorInfo(p_event, 'ERROR');
217: RETURN 'ERROR';
218:
219:

Line 266: WF_CORE.CONTEXT('IEX_TERR_PUB', 'location_check', p_event.getEventName(), p_subscription_guid);

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';
269: WHEN OTHERS THEN
270: logmessage ('Exception Others location_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 271: WF_CORE.CONTEXT('IEX_TERR_PUB', 'location_check', p_event.getEventName(), p_subscription_guid);

267: WF_EVENT.setErrorInfo(p_event, 'ERROR');
268: RETURN 'ERROR';
269: WHEN OTHERS THEN
270: logmessage ('Exception Others location_check: ' || 'EVENT NAME =>'||p_event.getEventName());
271: WF_CORE.CONTEXT('IEX_TERR_PUB', 'location_check', p_event.getEventName(), p_subscription_guid);
272: WF_EVENT.setErrorInfo(p_event, 'ERROR');
273: RETURN 'ERROR';
274:
275: END location_check;

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 490: WF_CORE.CONTEXT('IEX_TERR_PUB', 'account_check', p_event.getEventName(), p_subscription_guid);

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';
493: WHEN OTHERS THEN
494: logmessage ('Exception Others account_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 495: WF_CORE.CONTEXT('IEX_TERR_PUB', 'account_check', p_event.getEventName(), p_subscription_guid);

491: WF_EVENT.setErrorInfo(p_event, 'ERROR');
492: RETURN 'ERROR';
493: WHEN OTHERS THEN
494: logmessage ('Exception Others account_check: ' || 'EVENT NAME =>'||p_event.getEventName());
495: WF_CORE.CONTEXT('IEX_TERR_PUB', 'account_check', p_event.getEventName(), p_subscription_guid);
496: WF_EVENT.setErrorInfo(p_event, 'ERROR');
497: RETURN 'ERROR';
498:
499: END account_check;

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 585: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profile_check', p_event.getEventName(), p_subscription_guid);

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';
588: WHEN OTHERS THEN
589: logmessage ('exception others profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 590: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profile_check', p_event.getEventName(), p_subscription_guid);

586: WF_EVENT.setErrorInfo(p_event, 'ERROR');
587: RETURN 'ERROR';
588: WHEN OTHERS THEN
589: logmessage ('exception others profile_check: ' || 'EVENT NAME =>'||p_event.getEventName());
590: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profile_check', p_event.getEventName(), p_subscription_guid);
591: WF_EVENT.setErrorInfo(p_event, 'ERROR');
592: RETURN 'ERROR';
593:
594:

Line 643: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profileamt_check', p_event.getEventName(), p_subscription_guid);

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';
646: WHEN OTHERS THEN
647: logmessage ('exception others profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());

Line 648: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profileamt_check', p_event.getEventName(), p_subscription_guid);

644: WF_EVENT.setErrorInfo(p_event, 'ERROR');
645: RETURN 'ERROR';
646: WHEN OTHERS THEN
647: logmessage ('exception others profileamt_check: ' || 'EVENT NAME =>'||p_event.getEventName());
648: WF_CORE.CONTEXT('IEX_TERR_PUB', 'profileamt_check', p_event.getEventName(), p_subscription_guid);
649: WF_EVENT.setErrorInfo(p_event, 'ERROR');
650: RETURN 'ERROR';
651:
652:

Line 1104: HZ_UTILITY_V2PUB.debug( 'IEX_TERR_PUB ' || p_text );

1100: --IEX Summary Table Synchronization End.
1101:
1102: PROCEDURE logMessage (p_text in varchar2) IS
1103: begin
1104: HZ_UTILITY_V2PUB.debug( 'IEX_TERR_PUB ' || p_text );
1105: --insert into temp_log values(p_text);
1106: -- commit; --Commented for bug#15932134 schekuri 06-Dec-2012
1107: end;
1108: