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.RCV_RECEIPT_CONFIRMATION dependencies on ASN_DEBUG

Line 4: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790

1: package BODY rcv_receipt_confirmation AS
2: /* $Header: RCVRCCNB.pls 120.0.12010000.12 2010/04/13 11:32:34 smididud noship $ */
3:
4: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
5:
6: PROCEDURE send_confirmation (x_errbuf OUT NOCOPY VARCHAR2,
7: x_retcode OUT NOCOPY NUMBER,
8: p_deploy_mode IN VARCHAR2,

Line 136: IF (g_asn_debug = 'Y') THEN

132: BEGIN
133:
134: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
135:
136: IF (g_asn_debug = 'Y') THEN
137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);
138: END IF;
139:
140: IF (l_wms_deployment_mode not in ('L','D')) THEN

Line 137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);

133:
134: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
135:
136: IF (g_asn_debug = 'Y') THEN
137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);
138: END IF;
139:
140: IF (l_wms_deployment_mode not in ('L','D')) THEN
141: RETURN;

Line 144: IF (g_asn_debug = 'Y') THEN

140: IF (l_wms_deployment_mode not in ('L','D')) THEN
141: RETURN;
142: END IF;
143:
144: IF (g_asn_debug = 'Y') THEN
145: asn_debug.put_line('Entering send_confirmation call');
146: asn_debug.put_line('p_org_id is '||p_org_id);
147: asn_debug.put_line('p_client_code is '||p_client_code);
148: asn_debug.put_line('p_xml_doc_id is ' ||p_xml_doc_id);

Line 145: asn_debug.put_line('Entering send_confirmation call');

141: RETURN;
142: END IF;
143:
144: IF (g_asn_debug = 'Y') THEN
145: asn_debug.put_line('Entering send_confirmation call');
146: asn_debug.put_line('p_org_id is '||p_org_id);
147: asn_debug.put_line('p_client_code is '||p_client_code);
148: asn_debug.put_line('p_xml_doc_id is ' ||p_xml_doc_id);
149: END IF;

Line 146: asn_debug.put_line('p_org_id is '||p_org_id);

142: END IF;
143:
144: IF (g_asn_debug = 'Y') THEN
145: asn_debug.put_line('Entering send_confirmation call');
146: asn_debug.put_line('p_org_id is '||p_org_id);
147: asn_debug.put_line('p_client_code is '||p_client_code);
148: asn_debug.put_line('p_xml_doc_id is ' ||p_xml_doc_id);
149: END IF;
150:

Line 147: asn_debug.put_line('p_client_code is '||p_client_code);

143:
144: IF (g_asn_debug = 'Y') THEN
145: asn_debug.put_line('Entering send_confirmation call');
146: asn_debug.put_line('p_org_id is '||p_org_id);
147: asn_debug.put_line('p_client_code is '||p_client_code);
148: asn_debug.put_line('p_xml_doc_id is ' ||p_xml_doc_id);
149: END IF;
150:
151:

Line 148: asn_debug.put_line('p_xml_doc_id is ' ||p_xml_doc_id);

144: IF (g_asn_debug = 'Y') THEN
145: asn_debug.put_line('Entering send_confirmation call');
146: asn_debug.put_line('p_org_id is '||p_org_id);
147: asn_debug.put_line('p_client_code is '||p_client_code);
148: asn_debug.put_line('p_xml_doc_id is ' ||p_xml_doc_id);
149: END IF;
150:
151:
152: x_errbuf := 'Success';

Line 187: IF (g_asn_debug = 'Y') THEN

183: xml_doc_id := p_xml_doc_id;
184: end if;
185:
186:
187: IF (g_asn_debug = 'Y') THEN
188: asn_debug.put_line('p_shid_from is '||p_shid_from);
189: asn_debug.put_line('p_shid_to is '||p_shid_to);
190: END IF;
191:

Line 188: asn_debug.put_line('p_shid_from is '||p_shid_from);

184: end if;
185:
186:
187: IF (g_asn_debug = 'Y') THEN
188: asn_debug.put_line('p_shid_from is '||p_shid_from);
189: asn_debug.put_line('p_shid_to is '||p_shid_to);
190: END IF;
191:
192:

Line 189: asn_debug.put_line('p_shid_to is '||p_shid_to);

185:
186:
187: IF (g_asn_debug = 'Y') THEN
188: asn_debug.put_line('p_shid_from is '||p_shid_from);
189: asn_debug.put_line('p_shid_to is '||p_shid_to);
190: END IF;
191:
192:
193: IF p_trx_date_from IS NOT NULL AND p_trx_date_to IS NULL THEN

Line 212: IF (g_asn_debug = 'Y') THEN

208: l_trx_date_from := to_Date(trx_date_from, 'YYYY/MM/DD HH24:MI:SS');
209: l_trx_date_to := to_Date(trx_date_to, 'YYYY/MM/DD HH24:MI:SS');
210: END IF;
211:
212: IF (g_asn_debug = 'Y') THEN
213: asn_debug.put_line('From Trxn Date = ' ||to_char(l_trx_date_from,'DD-MON-YYYY HH24:MI:SS'));
214: asn_debug.put_line('To Trxn Date = ' || to_char(l_trx_date_to,'DD-MON-YYYY HH24:MI:SS'));
215: asn_debug.put_line('xml_doc_id = '||xml_doc_id);
216: END IF;

Line 213: asn_debug.put_line('From Trxn Date = ' ||to_char(l_trx_date_from,'DD-MON-YYYY HH24:MI:SS'));

209: l_trx_date_to := to_Date(trx_date_to, 'YYYY/MM/DD HH24:MI:SS');
210: END IF;
211:
212: IF (g_asn_debug = 'Y') THEN
213: asn_debug.put_line('From Trxn Date = ' ||to_char(l_trx_date_from,'DD-MON-YYYY HH24:MI:SS'));
214: asn_debug.put_line('To Trxn Date = ' || to_char(l_trx_date_to,'DD-MON-YYYY HH24:MI:SS'));
215: asn_debug.put_line('xml_doc_id = '||xml_doc_id);
216: END IF;
217:

Line 214: asn_debug.put_line('To Trxn Date = ' || to_char(l_trx_date_to,'DD-MON-YYYY HH24:MI:SS'));

210: END IF;
211:
212: IF (g_asn_debug = 'Y') THEN
213: asn_debug.put_line('From Trxn Date = ' ||to_char(l_trx_date_from,'DD-MON-YYYY HH24:MI:SS'));
214: asn_debug.put_line('To Trxn Date = ' || to_char(l_trx_date_to,'DD-MON-YYYY HH24:MI:SS'));
215: asn_debug.put_line('xml_doc_id = '||xml_doc_id);
216: END IF;
217:
218: l_event_name := 'oracle.apps.po.standalone.rcpto';

Line 215: asn_debug.put_line('xml_doc_id = '||xml_doc_id);

211:
212: IF (g_asn_debug = 'Y') THEN
213: asn_debug.put_line('From Trxn Date = ' ||to_char(l_trx_date_from,'DD-MON-YYYY HH24:MI:SS'));
214: asn_debug.put_line('To Trxn Date = ' || to_char(l_trx_date_to,'DD-MON-YYYY HH24:MI:SS'));
215: asn_debug.put_line('xml_doc_id = '||xml_doc_id);
216: END IF;
217:
218: l_event_name := 'oracle.apps.po.standalone.rcpto';
219:

Line 222: IF (g_asn_debug = 'Y') THEN

218: l_event_name := 'oracle.apps.po.standalone.rcpto';
219:
220: IF ( p_xml_doc_id is null and p_client_code is not null ) THEN
221:
222: IF (g_asn_debug = 'Y') THEN
223: asn_debug.put_line('Opening cursor get_rcv_headers_1');
224: END IF;
225:
226: OPEN get_rcv_headers_1(l_trx_date_from,l_trx_date_to);

Line 223: asn_debug.put_line('Opening cursor get_rcv_headers_1');

219:
220: IF ( p_xml_doc_id is null and p_client_code is not null ) THEN
221:
222: IF (g_asn_debug = 'Y') THEN
223: asn_debug.put_line('Opening cursor get_rcv_headers_1');
224: END IF;
225:
226: OPEN get_rcv_headers_1(l_trx_date_from,l_trx_date_to);
227:

Line 230: IF (g_asn_debug = 'Y') THEN

226: OPEN get_rcv_headers_1(l_trx_date_from,l_trx_date_to);
227:
228: ELSIF (p_xml_doc_id is not null and p_client_code is not null) THEN
229:
230: IF (g_asn_debug = 'Y') THEN
231: asn_debug.put_line('Opening cursor get_rcv_headers_2');
232: END IF;
233:
234: OPEN get_rcv_headers_2(l_trx_date_from,l_trx_date_to);

Line 231: asn_debug.put_line('Opening cursor get_rcv_headers_2');

227:
228: ELSIF (p_xml_doc_id is not null and p_client_code is not null) THEN
229:
230: IF (g_asn_debug = 'Y') THEN
231: asn_debug.put_line('Opening cursor get_rcv_headers_2');
232: END IF;
233:
234: OPEN get_rcv_headers_2(l_trx_date_from,l_trx_date_to);
235:

Line 238: IF (g_asn_debug = 'Y') THEN

234: OPEN get_rcv_headers_2(l_trx_date_from,l_trx_date_to);
235:
236: ELSIF (p_xml_doc_id is null and p_client_code is null) THEN
237:
238: IF (g_asn_debug = 'Y') THEN
239: asn_debug.put_line('Opening cursor get_rcv_headers_3');
240: END IF;
241:
242: OPEN get_rcv_headers_3(l_trx_date_from,l_trx_date_to);

Line 239: asn_debug.put_line('Opening cursor get_rcv_headers_3');

235:
236: ELSIF (p_xml_doc_id is null and p_client_code is null) THEN
237:
238: IF (g_asn_debug = 'Y') THEN
239: asn_debug.put_line('Opening cursor get_rcv_headers_3');
240: END IF;
241:
242: OPEN get_rcv_headers_3(l_trx_date_from,l_trx_date_to);
243:

Line 246: IF (g_asn_debug = 'Y') THEN

242: OPEN get_rcv_headers_3(l_trx_date_from,l_trx_date_to);
243:
244: ELSIF (p_xml_doc_id is not null and p_client_code is null) THEN
245:
246: IF (g_asn_debug = 'Y') THEN
247: asn_debug.put_line('Opening cursor get_rcv_headers_4');
248: END IF;
249:
250: OPEN get_rcv_headers_4(l_trx_date_from,l_trx_date_to);

Line 247: asn_debug.put_line('Opening cursor get_rcv_headers_4');

243:
244: ELSIF (p_xml_doc_id is not null and p_client_code is null) THEN
245:
246: IF (g_asn_debug = 'Y') THEN
247: asn_debug.put_line('Opening cursor get_rcv_headers_4');
248: END IF;
249:
250: OPEN get_rcv_headers_4(l_trx_date_from,l_trx_date_to);
251:

Line 257: IF (g_asn_debug = 'Y') THEN

253:
254: LOOP
255:
256: IF get_rcv_headers_1%ISOPEN THEN
257: IF (g_asn_debug = 'Y') THEN
258: asn_debug.put_line('Fetching cursor get_rcv_headers_1');
259: END IF;
260: FETCH get_rcv_headers_1 INTO grh;
261:

Line 258: asn_debug.put_line('Fetching cursor get_rcv_headers_1');

254: LOOP
255:
256: IF get_rcv_headers_1%ISOPEN THEN
257: IF (g_asn_debug = 'Y') THEN
258: asn_debug.put_line('Fetching cursor get_rcv_headers_1');
259: END IF;
260: FETCH get_rcv_headers_1 INTO grh;
261:
262: IF (get_rcv_headers_1%NOTFOUND) THEN

Line 263: IF (g_asn_debug = 'Y') THEN

259: END IF;
260: FETCH get_rcv_headers_1 INTO grh;
261:
262: IF (get_rcv_headers_1%NOTFOUND) THEN
263: IF (g_asn_debug = 'Y') THEN
264: asn_debug.put_line('Closing cursor get_rcv_headers_1');
265: END IF;
266: CLOSE get_rcv_headers_1;
267: EXIT;

Line 264: asn_debug.put_line('Closing cursor get_rcv_headers_1');

260: FETCH get_rcv_headers_1 INTO grh;
261:
262: IF (get_rcv_headers_1%NOTFOUND) THEN
263: IF (g_asn_debug = 'Y') THEN
264: asn_debug.put_line('Closing cursor get_rcv_headers_1');
265: END IF;
266: CLOSE get_rcv_headers_1;
267: EXIT;
268: END IF;

Line 271: IF (g_asn_debug = 'Y') THEN

267: EXIT;
268: END IF;
269:
270: ELSIF get_rcv_headers_2%ISOPEN THEN
271: IF (g_asn_debug = 'Y') THEN
272: asn_debug.put_line('Fetching cursor get_rcv_headers_2');
273: END IF;
274: FETCH get_rcv_headers_2 INTO grh;
275:

Line 272: asn_debug.put_line('Fetching cursor get_rcv_headers_2');

268: END IF;
269:
270: ELSIF get_rcv_headers_2%ISOPEN THEN
271: IF (g_asn_debug = 'Y') THEN
272: asn_debug.put_line('Fetching cursor get_rcv_headers_2');
273: END IF;
274: FETCH get_rcv_headers_2 INTO grh;
275:
276: IF (get_rcv_headers_2%NOTFOUND) THEN

Line 277: IF (g_asn_debug = 'Y') THEN

273: END IF;
274: FETCH get_rcv_headers_2 INTO grh;
275:
276: IF (get_rcv_headers_2%NOTFOUND) THEN
277: IF (g_asn_debug = 'Y') THEN
278: asn_debug.put_line('Closing cursor get_rcv_headers_2');
279: END IF;
280: CLOSE get_rcv_headers_2;
281: EXIT;

Line 278: asn_debug.put_line('Closing cursor get_rcv_headers_2');

274: FETCH get_rcv_headers_2 INTO grh;
275:
276: IF (get_rcv_headers_2%NOTFOUND) THEN
277: IF (g_asn_debug = 'Y') THEN
278: asn_debug.put_line('Closing cursor get_rcv_headers_2');
279: END IF;
280: CLOSE get_rcv_headers_2;
281: EXIT;
282: END IF;

Line 285: IF (g_asn_debug = 'Y') THEN

281: EXIT;
282: END IF;
283:
284: ELSIF get_rcv_headers_3%ISOPEN THEN
285: IF (g_asn_debug = 'Y') THEN
286: asn_debug.put_line('Fetching cursor get_rcv_headers_3');
287: END IF;
288: FETCH get_rcv_headers_3 INTO grh;
289:

Line 286: asn_debug.put_line('Fetching cursor get_rcv_headers_3');

282: END IF;
283:
284: ELSIF get_rcv_headers_3%ISOPEN THEN
285: IF (g_asn_debug = 'Y') THEN
286: asn_debug.put_line('Fetching cursor get_rcv_headers_3');
287: END IF;
288: FETCH get_rcv_headers_3 INTO grh;
289:
290: IF (get_rcv_headers_3%NOTFOUND) THEN

Line 291: IF (g_asn_debug = 'Y') THEN

287: END IF;
288: FETCH get_rcv_headers_3 INTO grh;
289:
290: IF (get_rcv_headers_3%NOTFOUND) THEN
291: IF (g_asn_debug = 'Y') THEN
292: asn_debug.put_line('Closing cursor get_rcv_headers_3');
293: END IF;
294: CLOSE get_rcv_headers_3;
295: EXIT;

Line 292: asn_debug.put_line('Closing cursor get_rcv_headers_3');

288: FETCH get_rcv_headers_3 INTO grh;
289:
290: IF (get_rcv_headers_3%NOTFOUND) THEN
291: IF (g_asn_debug = 'Y') THEN
292: asn_debug.put_line('Closing cursor get_rcv_headers_3');
293: END IF;
294: CLOSE get_rcv_headers_3;
295: EXIT;
296: END IF;

Line 299: IF (g_asn_debug = 'Y') THEN

295: EXIT;
296: END IF;
297:
298: ELSIF get_rcv_headers_4%ISOPEN THEN
299: IF (g_asn_debug = 'Y') THEN
300: asn_debug.put_line('Fetching cursor get_rcv_headers_4');
301: END IF;
302: FETCH get_rcv_headers_4 INTO grh;
303:

Line 300: asn_debug.put_line('Fetching cursor get_rcv_headers_4');

296: END IF;
297:
298: ELSIF get_rcv_headers_4%ISOPEN THEN
299: IF (g_asn_debug = 'Y') THEN
300: asn_debug.put_line('Fetching cursor get_rcv_headers_4');
301: END IF;
302: FETCH get_rcv_headers_4 INTO grh;
303:
304: IF (get_rcv_headers_4%NOTFOUND) THEN

Line 305: IF (g_asn_debug = 'Y') THEN

301: END IF;
302: FETCH get_rcv_headers_4 INTO grh;
303:
304: IF (get_rcv_headers_4%NOTFOUND) THEN
305: IF (g_asn_debug = 'Y') THEN
306: asn_debug.put_line('Closing cursor get_rcv_headers_4');
307: END IF;
308: CLOSE get_rcv_headers_4; EXIT;
309: END IF;

Line 306: asn_debug.put_line('Closing cursor get_rcv_headers_4');

302: FETCH get_rcv_headers_4 INTO grh;
303:
304: IF (get_rcv_headers_4%NOTFOUND) THEN
305: IF (g_asn_debug = 'Y') THEN
306: asn_debug.put_line('Closing cursor get_rcv_headers_4');
307: END IF;
308: CLOSE get_rcv_headers_4; EXIT;
309: END IF;
310: END IF;

Line 317: IF (g_asn_debug = 'Y') THEN

313: IF (xml_doc_id is NULL) THEN
314:
315: IF (l_wms_deployment_mode = 'L') then
316:
317: IF (g_asn_debug = 'Y') THEN
318: asn_debug.put_line('WMS Deploy Mode is LSP');
319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
320: END IF;
321:

Line 318: asn_debug.put_line('WMS Deploy Mode is LSP');

314:
315: IF (l_wms_deployment_mode = 'L') then
316:
317: IF (g_asn_debug = 'Y') THEN
318: asn_debug.put_line('WMS Deploy Mode is LSP');
319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
320: END IF;
321:
322: UPDATE rcv_transactions rt

Line 319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');

315: IF (l_wms_deployment_mode = 'L') then
316:
317: IF (g_asn_debug = 'Y') THEN
318: asn_debug.put_line('WMS Deploy Mode is LSP');
319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
320: END IF;
321:
322: UPDATE rcv_transactions rt
323: SET rt.receipt_confirmation_extracted = 'P'

Line 344: IF (g_asn_debug = 'Y') THEN

340: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);
341:
342: ELSE
343:
344: IF (g_asn_debug = 'Y') THEN
345: asn_debug.put_line('WMS Deploy Mode is Distributed');
346: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
347: END IF;
348:

Line 345: asn_debug.put_line('WMS Deploy Mode is Distributed');

341:
342: ELSE
343:
344: IF (g_asn_debug = 'Y') THEN
345: asn_debug.put_line('WMS Deploy Mode is Distributed');
346: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
347: END IF;
348:
349:

Line 346: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');

342: ELSE
343:
344: IF (g_asn_debug = 'Y') THEN
345: asn_debug.put_line('WMS Deploy Mode is Distributed');
346: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
347: END IF;
348:
349:
350: UPDATE rcv_transactions rt

Line 384: IF (g_asn_debug = 'Y') THEN

380: p_client_code => p_client_code,
381: p_xml_document_id => p_xml_doc_id,
382: x_return_status => l_return_status);
383:
384: IF (g_asn_debug = 'Y') THEN
385: asn_debug.put_line('Send_Document.l_return_status is ' || l_return_status);
386: asn_debug.put_line('Exiting Send_Document call');
387: END IF;
388:

Line 385: asn_debug.put_line('Send_Document.l_return_status is ' || l_return_status);

381: p_xml_document_id => p_xml_doc_id,
382: x_return_status => l_return_status);
383:
384: IF (g_asn_debug = 'Y') THEN
385: asn_debug.put_line('Send_Document.l_return_status is ' || l_return_status);
386: asn_debug.put_line('Exiting Send_Document call');
387: END IF;
388:
389: IF (l_return_status <> rcv_error_pkg.g_ret_sts_success) THEN

Line 386: asn_debug.put_line('Exiting Send_Document call');

382: x_return_status => l_return_status);
383:
384: IF (g_asn_debug = 'Y') THEN
385: asn_debug.put_line('Send_Document.l_return_status is ' || l_return_status);
386: asn_debug.put_line('Exiting Send_Document call');
387: END IF;
388:
389: IF (l_return_status <> rcv_error_pkg.g_ret_sts_success) THEN
390: IF (xml_doc_id is null) THEN

Line 394: IF (g_asn_debug = 'Y') THEN

390: IF (xml_doc_id is null) THEN
391:
392: IF (l_wms_deployment_mode = 'L') then
393:
394: IF (g_asn_debug = 'Y') THEN
395: asn_debug.put_line('WMS Deploy Mode is LSP');
396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
397: END IF;
398:

Line 395: asn_debug.put_line('WMS Deploy Mode is LSP');

391:
392: IF (l_wms_deployment_mode = 'L') then
393:
394: IF (g_asn_debug = 'Y') THEN
395: asn_debug.put_line('WMS Deploy Mode is LSP');
396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
397: END IF;
398:
399: UPDATE rcv_transactions rt

Line 396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');

392: IF (l_wms_deployment_mode = 'L') then
393:
394: IF (g_asn_debug = 'Y') THEN
395: asn_debug.put_line('WMS Deploy Mode is LSP');
396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
397: END IF;
398:
399: UPDATE rcv_transactions rt
400: SET rt.receipt_confirmation_extracted = null,

Line 422: IF (g_asn_debug = 'Y') THEN

418: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);
419:
420: ELSE
421:
422: IF (g_asn_debug = 'Y') THEN
423: asn_debug.put_line('WMS Deploy Mode is Distributed');
424: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
425: END IF;
426:

Line 423: asn_debug.put_line('WMS Deploy Mode is Distributed');

419:
420: ELSE
421:
422: IF (g_asn_debug = 'Y') THEN
423: asn_debug.put_line('WMS Deploy Mode is Distributed');
424: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
425: END IF;
426:
427: UPDATE rcv_transactions rt

Line 424: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');

420: ELSE
421:
422: IF (g_asn_debug = 'Y') THEN
423: asn_debug.put_line('WMS Deploy Mode is Distributed');
424: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
425: END IF;
426:
427: UPDATE rcv_transactions rt
428: SET rt.receipt_confirmation_extracted = null,

Line 452: IF (g_asn_debug = 'Y') THEN

448: END IF;
449:
450: END LOOP;
451:
452: IF (g_asn_debug = 'Y') THEN
453: asn_debug.put_line('Exit Loop');
454: asn_debug.put_line('Exiting send_confirmation call');
455: END IF;
456:

Line 453: asn_debug.put_line('Exit Loop');

449:
450: END LOOP;
451:
452: IF (g_asn_debug = 'Y') THEN
453: asn_debug.put_line('Exit Loop');
454: asn_debug.put_line('Exiting send_confirmation call');
455: END IF;
456:
457: COMMIT;

Line 454: asn_debug.put_line('Exiting send_confirmation call');

450: END LOOP;
451:
452: IF (g_asn_debug = 'Y') THEN
453: asn_debug.put_line('Exit Loop');
454: asn_debug.put_line('Exiting send_confirmation call');
455: END IF;
456:
457: COMMIT;
458:

Line 462: IF (g_asn_debug = 'Y') THEN

458:
459: EXCEPTION
460: WHEN OTHERS THEN
461:
462: IF (g_asn_debug = 'Y') THEN
463: asn_debug.put_line('Exception : '||sqlerrm||' occurred in Send_Confirmation');
464: END IF;
465: ROLLBACK;
466:

Line 463: asn_debug.put_line('Exception : '||sqlerrm||' occurred in Send_Confirmation');

459: EXCEPTION
460: WHEN OTHERS THEN
461:
462: IF (g_asn_debug = 'Y') THEN
463: asn_debug.put_line('Exception : '||sqlerrm||' occurred in Send_Confirmation');
464: END IF;
465: ROLLBACK;
466:
467: IF ( get_rcv_headers_1%ISOPEN) THEN

Line 468: IF (g_asn_debug = 'Y') THEN

464: END IF;
465: ROLLBACK;
466:
467: IF ( get_rcv_headers_1%ISOPEN) THEN
468: IF (g_asn_debug = 'Y') THEN
469: asn_debug.put_line('Closing cursor get_rcv_headers_1 in exception block');
470: END IF;
471: close get_rcv_headers_1;
472: END IF;

Line 469: asn_debug.put_line('Closing cursor get_rcv_headers_1 in exception block');

465: ROLLBACK;
466:
467: IF ( get_rcv_headers_1%ISOPEN) THEN
468: IF (g_asn_debug = 'Y') THEN
469: asn_debug.put_line('Closing cursor get_rcv_headers_1 in exception block');
470: END IF;
471: close get_rcv_headers_1;
472: END IF;
473:

Line 475: IF (g_asn_debug = 'Y') THEN

471: close get_rcv_headers_1;
472: END IF;
473:
474: IF ( get_rcv_headers_2%ISOPEN) THEN
475: IF (g_asn_debug = 'Y') THEN
476: asn_debug.put_line('Closing cursor get_rcv_headers_2 in exception block');
477: END IF;
478: close get_rcv_headers_2;
479: END IF;

Line 476: asn_debug.put_line('Closing cursor get_rcv_headers_2 in exception block');

472: END IF;
473:
474: IF ( get_rcv_headers_2%ISOPEN) THEN
475: IF (g_asn_debug = 'Y') THEN
476: asn_debug.put_line('Closing cursor get_rcv_headers_2 in exception block');
477: END IF;
478: close get_rcv_headers_2;
479: END IF;
480:

Line 482: IF (g_asn_debug = 'Y') THEN

478: close get_rcv_headers_2;
479: END IF;
480:
481: IF ( get_rcv_headers_3%ISOPEN) THEN
482: IF (g_asn_debug = 'Y') THEN
483: asn_debug.put_line('Closing cursor get_rcv_headers_3 in exception block');
484: END IF;
485: close get_rcv_headers_3;
486: END IF;

Line 483: asn_debug.put_line('Closing cursor get_rcv_headers_3 in exception block');

479: END IF;
480:
481: IF ( get_rcv_headers_3%ISOPEN) THEN
482: IF (g_asn_debug = 'Y') THEN
483: asn_debug.put_line('Closing cursor get_rcv_headers_3 in exception block');
484: END IF;
485: close get_rcv_headers_3;
486: END IF;
487:

Line 489: IF (g_asn_debug = 'Y') THEN

485: close get_rcv_headers_3;
486: END IF;
487:
488: IF ( get_rcv_headers_4%ISOPEN) THEN
489: IF (g_asn_debug = 'Y') THEN
490: asn_debug.put_line('Closing cursor get_rcv_headers_4 in exception block');
491: END IF;
492: close get_rcv_headers_4;
493: END IF;

Line 490: asn_debug.put_line('Closing cursor get_rcv_headers_4 in exception block');

486: END IF;
487:
488: IF ( get_rcv_headers_4%ISOPEN) THEN
489: IF (g_asn_debug = 'Y') THEN
490: asn_debug.put_line('Closing cursor get_rcv_headers_4 in exception block');
491: END IF;
492: close get_rcv_headers_4;
493: END IF;
494: