[Home] [Help]
78: AND WES.owner_tag = fa.application_short_name
79: AND wes.status = 'ENABLED'
80: AND we.status = 'ENABLED';
81:
82: iex_debug_pub.logmessage( 'l_noof_active_busi_events: '||l_noof_active_busi_events );
83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_noof_active_busi_events: '||l_noof_active_busi_events);
84:
85: IF ( l_noof_active_busi_events > 0 ) THEN
86: SELECT count(1) INTO l_count
89: FROM fnd_concurrent_programs_vl
90: WHERE concurrent_program_name = 'IEXDLMGB')
91: AND ((phase_code = 'R') OR (phase_code = 'P' AND status_code = 'C'));
92:
93: iex_debug_pub.logmessage( 'l_count :'||l_count );
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_count: '||l_count);
95: IF l_count > 0 THEN
96: RETURN TRUE;
97: ELSE
102: END IF;
103:
104: EXCEPTION
105: WHEN OTHERS THEN
106: iex_debug_pub.logmessage('Error Found in function is_incompatible');
107: END is_incompatible;
108: -- End Bug13987015 by bibeura
109:
110: --Begin Bug 9597052 28-Apr-2010 barathsr
184: FETCH c_cust_account_id_1 BULK COLLECT INTO
185: l_cust_account_id_1 LIMIT G_BATCH_SIZE;
186: IF l_cust_account_id_1.count = 0 THEN
187:
188: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1...');
189:
190: CLOSE c_cust_account_id_1;
191: EXIT;
192: ELSE
198: l_cust_account_id_1.delete;
199:
200: commit;
201:
202: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');
203: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Rows updated in ar_trx_bal_summary with reference_1 = 1-->'||l_cust_account_id_1.count);
204:
205: END IF;
206: END LOOP;
218: LOOP
219: FETCH c_cust_account_id_1 BULK COLLECT INTO
220: l_cust_account_id_1 LIMIT G_BATCH_SIZE;
221: IF l_cust_account_id_1.count = 0 THEN
222: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1 in Deadlock handler');
223: CLOSE c_cust_account_id_1;
224: EXIT;
225: ELSE
226: FOR i IN l_cust_account_id_1.first..l_cust_account_id_1.last
250: END;
251:
252: END LOOP;
253:
254: IEX_DEBUG_PUB.LOGMESSAGE(l_cust_account_id_1.count || ' rows updated in ar_trx_bal_summary with reference_1 = 1');
255: l_cust_account_id_1.delete;
256: commit;
257:
258: END IF;
264: end if;
265: ROLLBACK;
266:
267: WHEN OTHERS THEN
268: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = 1');
269: END;
270:
271: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Starting to update ar_trx_bal_summary with reference_1 = Null...');
272: BEGIN
304: LOOP
305: FETCH c_cust_account_id_n BULK COLLECT INTO
306: l_cust_account_id_n LIMIT G_BATCH_SIZE;
307: IF l_cust_account_id_n.count = 0 THEN
308: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = null in Deadlock handler');
309: CLOSE c_cust_account_id_n;
310: EXIT;
311: ELSE
312: FOR i IN l_cust_account_id_n.first..l_cust_account_id_n.last
336: END;
337:
338: END LOOP;
339:
340: IEX_DEBUG_PUB.LOGMESSAGE(l_cust_account_id_1.count || ' rows updated in ar_trx_bal_summary with reference_1 = 1');
341: l_cust_account_id_1.delete;
342: commit;
343:
344: END IF;
14178: FETCH c_get_details BULK COLLECT INTO
14179: l_party_id,l_cust_acct_id,l_site_use_id,l_org_id LIMIT G_BATCH_SIZE;
14180: IF l_party_id.count = 0 and l_cust_acct_id.count=0 and l_site_use_id.count=0 THEN
14181:
14182: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating iex_dln_uwq_summ...');
14183:
14184: CLOSE c_get_details;
14185: EXIT;
14186: ELSE