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 71: iex_debug_pub.LogMessage ('l_customer_trx_id= '||l_customer_trx_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

282: BEGIN
283:
284: IF pg_debug <=10
285: THEN
286: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ' );
287: END IF;
288: -- insert into sch_test values('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Started ');
289: --commit; --Commented for bug#15932134 schekuri 06-Dec-2012
290: l_adjustment_id := p_event.GetValueForParameter('ADJUSTMENT_ID');

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

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

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

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

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

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

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

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

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

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

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

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

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

313: x_return_status := UPDATE_SUMMARY(l_adjustment_id,l_org_id ,'ADJ');
314: ELSE
315: IF pg_debug <=10
316: THEN
317: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Skipped ' );
318: END IF;
319: END IF;
320:
321: IF pg_debug <=10

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

319: END IF;
320:
321: IF pg_debug <=10
322: THEN
323: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_ADJ Finished ' );
324: END IF;
325:
326: Return 'SUCCESS';
327:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

383: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOADJ');
384: ELSE
385: IF pg_debug <=10
386: THEN
387: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Skipped ' );
388: END IF;
389: END IF;
390:
391: IF pg_debug <=10

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

389: END IF;
390:
391: IF pg_debug <=10
392: THEN
393: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOADJ Finished ' );
394: END IF;
395:
396:
397: Return 'SUCCESS';

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

427: BEGIN
428:
429: IF pg_debug <=10
430: THEN
431: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Started ' );
432: END IF;
433:
434:
435: l_request_id := p_event.GetValueForParameter('REQUEST_ID');

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

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

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

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

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

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

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

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

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

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

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

447: iex_debug_pub.LogMessage ('IEX Auto Receipts Org Id :' || l_org_id);
448: iex_debug_pub.LogMessage ('IEX Auto Receipts User Id : ' || l_user_id);
449: iex_debug_pub.LogMessage ('IEX Auto Receipts Resp Id : ' || l_resp_id);
450: iex_debug_pub.LogMessage ('IEX Auto Receipts Appl Id: ' || l_application_id );
451: iex_debug_pub.LogMessage ('IEX Auto Receipts Grp Id : ' || l_security_gr_id);
452: END IF;
453:
454:
455:

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

458: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOREC');
459: ELSE
460: IF pg_debug <=10
461: THEN
462: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Skipped ' );
463: END IF;
464: END IF;
465:
466: IF pg_debug <=10

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

464: END IF;
465:
466: IF pg_debug <=10
467: THEN
468: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOREC Finished ' );
469: END IF;
470:
471: Return 'SUCCESS';
472:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

527: x_return_status := UPDATE_SUMMARY(l_request_id,l_org_id ,'AUTOINV');
528: ELSE
529: IF pg_debug <=10
530: THEN
531: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Skipped ' );
532: END IF;
533: END IF;
534:
535: IF pg_debug <=10

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

533: END IF;
534:
535: IF pg_debug <=10
536: THEN
537: iex_debug_pub.LogMessage('IEX_BUS_EVENT_SUB_PVT.SYNC_AUTOINV Finished ' );
538: END IF;
539:
540: Return 'SUCCESS';
541:

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

883:
884: IF (trx_type = 'INV') THEN
885: IF pg_debug <=10
886: THEN
887: iex_debug_pub.LogMessage ('IEX Update Summary started for Invoice Event with id ' || id_val);
888: END IF;
889: OPEN select_ps (id_val); --id_val Contains Transaction ID .
890: i := 1;
891: LOOP

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

907: --Receipts.
908: ELSIF (trx_type = 'REC') THEN
909: IF pg_debug <=10
910: THEN
911: iex_debug_pub.LogMessage ('IEX Update Summary started for Receipt Event with id ' || id_val);
912: END IF;
913: OPEN select_ps_rec (id_val); --id_val Contains Payment Schedule ID .
914: i := 1;
915: LOOP

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

930:
931: ELSIF (trx_type = 'CM') THEN
932: IF pg_debug <=10
933: THEN
934: iex_debug_pub.LogMessage ('IEX Update Summary started for credit memo Event with id ' || id_val);
935: END IF;
936: OPEN select_ps_cm (id_val); --id_val Contains Transaction ID .
937: i := 1;
938: LOOP

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

953:
954: ELSIF (trx_type = 'ADJ') THEN
955: IF pg_debug <=10
956: THEN
957: iex_debug_pub.LogMessage ('IEX Update Summary started for Adjustment Event with id ' || id_val);
958: END IF;
959: OPEN select_ps_adj (id_val); --id_val Contains Adjustment ID
960: i := 1;
961: LOOP

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

976:
977: ELSIF (trx_type = 'AUTOADJ') THEN
978: IF pg_debug <=10
979: THEN
980: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Adjustment Event with id ' || id_val);
981: END IF;
982: OPEN select_ps_auto_adj (id_val); --id_val Contains Request ID
983: i := 1;
984: LOOP

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

999:
1000: ELSIF (trx_type = 'AUTOREC') THEN
1001: IF pg_debug <=10
1002: THEN
1003: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Receipt Event with id ' || id_val);
1004: END IF;
1005: OPEN select_ps_auto_rec (id_val); --id_val Contains Request ID
1006: i := 1;
1007: LOOP

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

1022:
1023: ELSIF (trx_type = 'AUTOINV') THEN
1024: IF pg_debug <=10
1025: THEN
1026: iex_debug_pub.LogMessage ('IEX Update Summary started for Auto Invoice Event with id ' || id_val);
1027: END IF;
1028: OPEN select_ps_auto_inv (id_val); --id_val Contains Request ID
1029: i := 1;
1030: LOOP

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

1049:
1050: IF l_ps_exists THEN
1051: IF pg_debug <=10
1052: THEN
1053: iex_debug_pub.LogMessage ('IEX Update Summary l_ps_exists , Starting...' );
1054: END IF;
1055: FOR j in 1..l_ps_tab.COUNT
1056: LOOP
1057:

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

1192: null;
1193: END IF; --l_ps_exists
1194: IF pg_debug <=10
1195: THEN
1196: iex_debug_pub.LogMessage ('IEX Update Summary updated ' || sql%rowcount || ' Rows' );
1197: END IF;
1198: --COMMIT; --Commented for bug#15932134 schekuri 06-Dec-2012
1199: RETURN 'SUCCESS';
1200: