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

Line 55: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Started ' );

51: BEGIN
52:
53: IF pg_debug <=10
54: THEN
55: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Started ' );
56: END IF;
57:
58: l_customer_trx_id := p_event.GetValueForParameter('CUSTOMER_TRX_ID');
59: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 69: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);

65:
66: SAVEPOINT Event;
67: IF pg_debug <=10
68: THEN
69: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);
70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);
71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);
72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);
73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);

Line 70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);

66: SAVEPOINT Event;
67: IF pg_debug <=10
68: THEN
69: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);
70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);
71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);
72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);
73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);
74: iex_debug_pub.LogMessage ('l_security_gr_id= '||l_security_gr_id);

Line 71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);

67: IF pg_debug <=10
68: THEN
69: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);
70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);
71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);
72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);
73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);
74: iex_debug_pub.LogMessage ('l_security_gr_id= '||l_security_gr_id);
75: null;

Line 72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);

68: THEN
69: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);
70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);
71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);
72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);
73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);
74: iex_debug_pub.LogMessage ('l_security_gr_id= '||l_security_gr_id);
75: null;
76: END IF;

Line 73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);

69: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);
70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);
71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);
72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);
73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);
74: iex_debug_pub.LogMessage ('l_security_gr_id= '||l_security_gr_id);
75: null;
76: END IF;
77:

Line 74: iex_debug_pub.LogMessage ('l_security_gr_id= '||l_security_gr_id);

70: iex_debug_pub.LogMessage ('l_org_id= '||l_org_id);
71: iex_debug_pub.LogMessage ('l_user_id= '||l_user_id);
72: iex_debug_pub.LogMessage ('l_resp_id= '||l_resp_id);
73: iex_debug_pub.LogMessage ('l_application_id= '||l_application_id);
74: iex_debug_pub.LogMessage ('l_security_gr_id= '||l_security_gr_id);
75: null;
76: END IF;
77:
78: --

Line 88: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Skipped ' );

84: x_return_status := UPDATE_SUMMARY(l_customer_trx_id,l_org_id ,'INV');
85: ELSE
86: IF pg_debug <=10
87: THEN
88: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Skipped ' );
89: END IF;
90: END IF;
91:
92: IF pg_debug <=10

Line 94: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Finished ' );

90: END IF;
91:
92: IF pg_debug <=10
93: THEN
94: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.Synch_Summary Finished ' );
95: END IF;
96:
97: Return 'SUCCESS';
98: EXCEPTION

Line 137: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Started ' );

133: BEGIN
134:
135: IF pg_debug <=10
136: THEN
137: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Started ' );
138: END IF;
139:
140: l_payment_schedule_id := p_event.GetValueForParameter('PAYMENT_SCHEDULE_ID');
141: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 153: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Pmt Sch. Id: ' || l_payment_schedule_id);

149: --set the application context.
150: --
151: IF pg_debug <=10
152: THEN
153: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Pmt Sch. Id: ' || l_payment_schedule_id);
154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);
155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);

Line 154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);

150: --
151: IF pg_debug <=10
152: THEN
153: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Pmt Sch. Id: ' || l_payment_schedule_id);
154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);
155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);
158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );

Line 155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);

151: IF pg_debug <=10
152: THEN
153: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Pmt Sch. Id: ' || l_payment_schedule_id);
154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);
155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);
158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );
159: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Grp Id : ' || l_security_gr_id);

Line 156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);

152: THEN
153: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Pmt Sch. Id: ' || l_payment_schedule_id);
154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);
155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);
158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );
159: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Grp Id : ' || l_security_gr_id);
160: END IF;

Line 157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);

153: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Pmt Sch. Id: ' || l_payment_schedule_id);
154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);
155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);
158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );
159: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Grp Id : ' || l_security_gr_id);
160: END IF;
161:

Line 158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );

154: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT cust acct Id: ' || l_cust_account_id);
155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);
158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );
159: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Grp Id : ' || l_security_gr_id);
160: END IF;
161:
162: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

Line 159: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Grp Id : ' || l_security_gr_id);

155: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Org Id :' || l_org_id);
156: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT User Id : ' || l_user_id);
157: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Resp Id : ' || l_resp_id);
158: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Appl Id: ' || l_application_id );
159: iex_debug_pub.LogMessage ('IEX SYNC_CASHRECEIPT Grp Id : ' || l_security_gr_id);
160: END IF;
161:
162: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
163:

Line 169: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Skipped ' );

165: x_return_status := UPDATE_SUMMARY(l_payment_schedule_id,l_org_id ,'REC');
166: ELSE
167: IF pg_debug <=10
168: THEN
169: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Skipped ' );
170: END IF;
171: END IF;
172:
173: IF pg_debug <=10

Line 175: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Finished ' );

171: END IF;
172:
173: IF pg_debug <=10
174: THEN
175: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CASHRECEIPT Finished ' );
176: END IF;
177:
178:
179: Return 'SUCCESS';

Line 212: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Started ' );

208: BEGIN
209:
210: IF pg_debug <=10
211: THEN
212: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Started ' );
213: END IF;
214:
215: l_receivable_application_id :=
216: p_event.GetValueForParameter('RECEIVABLE_APPLICATION_ID');

Line 227: iex_debug_pub.LogMessage ('IEX SYNC_CM RECEIVABLE_APPLICATION_ID: ' || l_receivable_application_id);

223: --set the application context.
224: --
225: IF pg_debug <=10
226: THEN
227: iex_debug_pub.LogMessage ('IEX SYNC_CM RECEIVABLE_APPLICATION_ID: ' || l_receivable_application_id);
228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );

Line 228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);

224: --
225: IF pg_debug <=10
226: THEN
227: iex_debug_pub.LogMessage ('IEX SYNC_CM RECEIVABLE_APPLICATION_ID: ' || l_receivable_application_id);
228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
232: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);

Line 229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);

225: IF pg_debug <=10
226: THEN
227: iex_debug_pub.LogMessage ('IEX SYNC_CM RECEIVABLE_APPLICATION_ID: ' || l_receivable_application_id);
228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
232: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
233: END IF;

Line 230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);

226: THEN
227: iex_debug_pub.LogMessage ('IEX SYNC_CM RECEIVABLE_APPLICATION_ID: ' || l_receivable_application_id);
228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
232: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
233: END IF;
234: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

Line 231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );

227: iex_debug_pub.LogMessage ('IEX SYNC_CM RECEIVABLE_APPLICATION_ID: ' || l_receivable_application_id);
228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
232: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
233: END IF;
234: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
235:

Line 232: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);

228: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
229: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
230: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
231: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
232: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
233: END IF;
234: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
235:
236: IF NOT isRefreshProgramsRunning THEN

Line 241: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Skipped ' );

237: x_return_status := UPDATE_SUMMARY(l_receivable_application_id,l_org_id ,'CM');
238: ELSE
239: IF pg_debug <=10
240: THEN
241: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Skipped ' );
242: END IF;
243: END IF;
244:
245:

Line 248: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Finished ' );

244:
245:
246: IF pg_debug <=10
247: THEN
248: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_CM Finished ' );
249: END IF;
250: Return 'SUCCESS';
251:
252: EXCEPTION

Line 285: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );

281: BEGIN
282:
283: IF pg_debug <=10
284: THEN
285: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );
286: END IF;
287: l_adjustment_id := p_event.GetValueForParameter('ADJUSTMENT_ID');
288: l_org_id := p_event.GetValueForParameter('ORG_ID');
289: l_user_id := p_event.GetValueForParameter('USER_ID');

Line 296: iex_debug_pub.LogMessage ('IEX SYNC_ADJ ADJUSTMENT_ID: ' || l_adjustment_id);

292: l_security_gr_id := p_event.GetValueForParameter('SECURITY_GROUP_ID');
293:
294: IF pg_debug <=10
295: THEN
296: iex_debug_pub.LogMessage ('IEX SYNC_ADJ ADJUSTMENT_ID: ' || l_adjustment_id);
297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );

Line 297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);

293:
294: IF pg_debug <=10
295: THEN
296: iex_debug_pub.LogMessage ('IEX SYNC_ADJ ADJUSTMENT_ID: ' || l_adjustment_id);
297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
301: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);

Line 298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);

294: IF pg_debug <=10
295: THEN
296: iex_debug_pub.LogMessage ('IEX SYNC_ADJ ADJUSTMENT_ID: ' || l_adjustment_id);
297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
301: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
302: END IF;

Line 299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);

295: THEN
296: iex_debug_pub.LogMessage ('IEX SYNC_ADJ ADJUSTMENT_ID: ' || l_adjustment_id);
297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
301: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
302: END IF;
303: --

Line 300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );

296: iex_debug_pub.LogMessage ('IEX SYNC_ADJ ADJUSTMENT_ID: ' || l_adjustment_id);
297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
301: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
302: END IF;
303: --
304: --set the application context.

Line 301: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);

297: iex_debug_pub.LogMessage ('IEX SYNC_CM Org Id :' || l_org_id);
298: iex_debug_pub.LogMessage ('IEX SYNC_CM User Id : ' || l_user_id);
299: iex_debug_pub.LogMessage ('IEX SYNC_CM Resp Id : ' || l_resp_id);
300: iex_debug_pub.LogMessage ('IEX SYNC_CM Appl Id: ' || l_application_id );
301: iex_debug_pub.LogMessage ('IEX SYNC_CM Grp Id : ' || l_security_gr_id);
302: END IF;
303: --
304: --set the application context.
305: --

Line 313: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Skipped ' );

309: x_return_status := UPDATE_SUMMARY(l_adjustment_id,l_org_id ,'ADJ');
310: ELSE
311: IF pg_debug <=10
312: THEN
313: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Skipped ' );
314: END IF;
315: END IF;
316:
317: IF pg_debug <=10

Line 319: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Finished ' );

315: END IF;
316:
317: IF pg_debug <=10
318: THEN
319: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Finished ' );
320: END IF;
321:
322: Return 'SUCCESS';
323:

Line 355: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Started ' );

351: x_return_status VARCHAR2(30);
352: BEGIN
353: IF pg_debug <=10
354: THEN
355: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Started ' );
356: END IF;
357:
358: l_request_id := p_event.GetValueForParameter('REQUEST_ID');
359: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 369: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);

365: --
366:
367: IF pg_debug <=10
368: THEN
369: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );

Line 370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);

366:
367: IF pg_debug <=10
368: THEN
369: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
374: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);

Line 371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);

367: IF pg_debug <=10
368: THEN
369: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
374: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
375: END IF;

Line 372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);

368: THEN
369: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
374: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
375: END IF;
376:

Line 373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );

369: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
374: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
375: END IF;
376:
377: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

Line 374: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);

370: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
371: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
372: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
373: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
374: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
375: END IF;
376:
377: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
378: IF NOT isRefreshProgramsRunning THEN

Line 383: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Skipped ' );

379: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOADJ');
380: ELSE
381: IF pg_debug <=10
382: THEN
383: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Skipped ' );
384: END IF;
385: END IF;
386:
387: IF pg_debug <=10

Line 389: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Finished ' );

385: END IF;
386:
387: IF pg_debug <=10
388: THEN
389: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Finished ' );
390: END IF;
391:
392:
393: Return 'SUCCESS';

Line 427: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Started ' );

423: BEGIN
424:
425: IF pg_debug <=10
426: THEN
427: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Started ' );
428: END IF;
429:
430:
431: l_request_id := p_event.GetValueForParameter('REQUEST_ID');

Line 442: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);

438: --set the application context.
439: --
440: IF pg_debug <=10
441: THEN
442: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );

Line 443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);

439: --
440: IF pg_debug <=10
441: THEN
442: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
447: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);

Line 444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);

440: IF pg_debug <=10
441: THEN
442: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
447: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
448: END IF;

Line 445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);

441: THEN
442: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
447: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
448: END IF;
449:

Line 446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );

442: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
447: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
448: END IF;
449:
450:

Line 447: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);

443: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
444: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
445: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
446: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
447: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
448: END IF;
449:
450:
451:

Line 458: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Skipped ' );

454: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOREC');
455: ELSE
456: IF pg_debug <=10
457: THEN
458: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Skipped ' );
459: END IF;
460: END IF;
461:
462: IF pg_debug <=10

Line 464: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Finished ' );

460: END IF;
461:
462: IF pg_debug <=10
463: THEN
464: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Finished ' );
465: END IF;
466:
467: Return 'SUCCESS';
468:

Line 500: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Started ' );

496: x_return_status VARCHAR2(30);
497: BEGIN
498: IF pg_debug <=10
499: THEN
500: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Started ' );
501: END IF;
502:
503: l_request_id := p_event.GetValueForParameter('REQUEST_ID');
504: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 514: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);

510: --set the application context.
511: --
512: IF pg_debug <=10
513: THEN
514: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );

Line 515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);

511: --
512: IF pg_debug <=10
513: THEN
514: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
519: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);

Line 516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);

512: IF pg_debug <=10
513: THEN
514: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
519: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
520: END IF;

Line 517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);

513: THEN
514: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
519: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
520: END IF;
521: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

Line 518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );

514: iex_debug_pub.LogMessage ('IEX Auto Receipts Request Id: ' || l_request_id);
515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
519: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
520: END IF;
521: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
522: IF NOT isRefreshProgramsRunning THEN

Line 519: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);

515: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
516: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
517: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
518: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
519: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
520: END IF;
521: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
522: IF NOT isRefreshProgramsRunning THEN
523: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOINV');

Line 527: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Skipped ' );

523: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOINV');
524: ELSE
525: IF pg_debug <=10
526: THEN
527: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Skipped ' );
528: END IF;
529: END IF;
530:
531: IF pg_debug <=10

Line 533: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Finished ' );

529: END IF;
530:
531: IF pg_debug <=10
532: THEN
533: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Finished ' );
534: END IF;
535:
536: Return 'SUCCESS';
537:

Line 868: iex_debug_pub.LogMessage ('IEX Update Summary started for Invoice Event with id ' || id_val);

864:
865: IF (trx_type = 'INV') THEN
866: IF pg_debug <=10
867: THEN
868: iex_debug_pub.LogMessage ('IEX Update Summary started for Invoice Event with id ' || id_val);
869: END IF;
870: OPEN select_ps (id_val); --id_val Contains Transaction ID .
871: i := 1;
872: LOOP

Line 892: iex_debug_pub.LogMessage ('IEX Update Summary started for Receipt Event with id ' || id_val);

888: --Receipts.
889: ELSIF (trx_type = 'REC') THEN
890: IF pg_debug <=10
891: THEN
892: iex_debug_pub.LogMessage ('IEX Update Summary started for Receipt Event with id ' || id_val);
893: END IF;
894: OPEN select_ps_rec (id_val); --id_val Contains Payment Schedule ID .
895: i := 1;
896: LOOP

Line 915: iex_debug_pub.LogMessage ('IEX Update Summary started for credit memo Event with id ' || id_val);

911:
912: ELSIF (trx_type = 'CM') THEN
913: IF pg_debug <=10
914: THEN
915: iex_debug_pub.LogMessage ('IEX Update Summary started for credit memo Event with id ' || id_val);
916: END IF;
917: OPEN select_ps_cm (id_val); --id_val Contains Transaction ID .
918: i := 1;
919: LOOP

Line 938: iex_debug_pub.LogMessage ('IEX Update Summary started for Adjustment Event with id ' || id_val);

934:
935: ELSIF (trx_type = 'ADJ') THEN
936: IF pg_debug <=10
937: THEN
938: iex_debug_pub.LogMessage ('IEX Update Summary started for Adjustment Event with id ' || id_val);
939: END IF;
940: OPEN select_ps_adj (id_val); --id_val Contains Adjustment ID
941: i := 1;
942: LOOP

Line 961: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Adjustment Event with id ' || id_val);

957:
958: ELSIF (trx_type = 'AUTOADJ') THEN
959: IF pg_debug <=10
960: THEN
961: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Adjustment Event with id ' || id_val);
962: END IF;
963: OPEN select_ps_auto_adj (id_val); --id_val Contains Request ID
964: i := 1;
965: LOOP

Line 984: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Receipt Event with id ' || id_val);

980:
981: ELSIF (trx_type = 'AUTOREC') THEN
982: IF pg_debug <=10
983: THEN
984: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Receipt Event with id ' || id_val);
985: END IF;
986: OPEN select_ps_auto_rec (id_val); --id_val Contains Request ID
987: i := 1;
988: LOOP

Line 1007: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Invoice Event with id ' || id_val);

1003:
1004: ELSIF (trx_type = 'AUTOINV') THEN
1005: IF pg_debug <=10
1006: THEN
1007: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Invoice Event with id ' || id_val);
1008: END IF;
1009: OPEN select_ps_auto_inv (id_val); --id_val Contains Request ID
1010: i := 1;
1011: LOOP

Line 1034: iex_debug_pub.LogMessage ('IEX Update Summary l_ps_exists , Starting...' );

1030:
1031: IF l_ps_exists THEN
1032: IF pg_debug <=10
1033: THEN
1034: iex_debug_pub.LogMessage ('IEX Update Summary l_ps_exists , Starting...' );
1035: END IF;
1036: FOR j in 1..l_ps_tab.COUNT
1037: LOOP
1038:

Line 1169: iex_debug_pub.LogMessage ('IEX Update Summary updated ' || sql%rowcount || ' Rows' );

1165: null;
1166: END IF; --l_ps_exists
1167: IF pg_debug <=10
1168: THEN
1169: iex_debug_pub.LogMessage ('IEX Update Summary updated ' || sql%rowcount || ' Rows' );
1170: END IF;
1171: COMMIT;
1172: RETURN 'SUCCESS';
1173: