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_DCP_PVT dependencies on ASN_DEBUG

Line 8: g_debug_on VARCHAR2(2) := asn_debug.is_debug_on; -- Bug 9152790

4: g_userid NUMBER;
5: g_user_email VARCHAR2(32767);
6: g_user_name VARCHAR2(32767);
7: g_env VARCHAR2(32767);
8: g_debug_on VARCHAR2(2) := asn_debug.is_debug_on; -- Bug 9152790
9: g_table_count NUMBER :=1;
10:
11: FUNCTION get_email_server
12: RETURN VARCHAR2 IS

Line 23: asn_debug.put_line('Entering ' || l_module_name);

19: l_debug_on := FALSE;
20: END IF;
21:
22: IF l_debug_on THEN
23: asn_debug.put_line('Entering ' || l_module_name);
24: END IF;
25:
26: IF rcv_dcp_pvt.g_email_server IS NOT NULL THEN
27: IF l_debug_on THEN

Line 28: asn_debug.put_line('Server name in cache:' || rcv_dcp_pvt.g_email_server);

24: END IF;
25:
26: IF rcv_dcp_pvt.g_email_server IS NOT NULL THEN
27: IF l_debug_on THEN
28: asn_debug.put_line('Server name in cache:' || rcv_dcp_pvt.g_email_server);
29: END IF;
30:
31: RETURN rcv_dcp_pvt.g_email_server;
32: END IF;

Line 37: asn_debug.put_line('Server name profile :' || rcv_dcp_pvt.g_email_server);

33:
34: rcv_dcp_pvt.g_email_server := fnd_profile.VALUE('RCV_DCP_EMAIL_SERVER');
35:
36: IF l_debug_on THEN
37: asn_debug.put_line('Server name profile :' || rcv_dcp_pvt.g_email_server);
38: END IF;
39:
40: RETURN rcv_dcp_pvt.g_email_server;
41: EXCEPTION

Line 44: asn_debug.put_line('When others error has occurred. Oracle error message is ' || SQLERRM);

40: RETURN rcv_dcp_pvt.g_email_server;
41: EXCEPTION
42: WHEN OTHERS THEN
43: IF l_debug_on THEN
44: asn_debug.put_line('When others error has occurred. Oracle error message is ' || SQLERRM);
45: END IF;
46:
47: RETURN NULL;
48: END get_email_server;

Line 62: asn_debug.put_line('Entering:' || l_module_name);

58: l_debug_on := FALSE;
59: END IF;
60:
61: IF l_debug_on THEN
62: asn_debug.put_line('Entering:' || l_module_name);
63: END IF;
64:
65: IF rcv_dcp_pvt.g_email_address IS NOT NULL THEN
66: IF l_debug_on THEN

Line 67: asn_debug.put_line('Email Address cache :' || rcv_dcp_pvt.g_email_address);

63: END IF;
64:
65: IF rcv_dcp_pvt.g_email_address IS NOT NULL THEN
66: IF l_debug_on THEN
67: asn_debug.put_line('Email Address cache :' || rcv_dcp_pvt.g_email_address);
68: END IF;
69:
70: RETURN rcv_dcp_pvt.g_email_address;
71: END IF;

Line 76: asn_debug.put_line('Email Address profile :' || rcv_dcp_pvt.g_email_address);

72:
73: rcv_dcp_pvt.g_email_address := fnd_profile.VALUE('RCV_DCP_EMAIL_ADDRESSES');
74:
75: IF l_debug_on THEN
76: asn_debug.put_line('Email Address profile :' || rcv_dcp_pvt.g_email_address);
77: END IF;
78:
79: RETURN rcv_dcp_pvt.g_email_address;
80: EXCEPTION

Line 83: asn_debug.put_line('When others error has occurred. Oracle error message is ' || SQLERRM);

79: RETURN rcv_dcp_pvt.g_email_address;
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF l_debug_on THEN
83: asn_debug.put_line('When others error has occurred. Oracle error message is ' || SQLERRM);
84: END IF;
85:
86: RETURN NULL;
87: END get_email_address;

Line 129: asn_debug.put_line('Entering:' || l_module_name);

125: l_sender := l_sender || '-' || c_env_rec.NAME;
126: END LOOP;
127:
128: IF l_debug_on THEN
129: asn_debug.put_line('Entering:' || l_module_name);
130: asn_debug.put_line('sender: ' || sender);
131: asn_debug.put_line('recipient1: ' || recipient1);
132: asn_debug.put_line('recipient2: ' || recipient2);
133: asn_debug.put_line('recipient3: ' || recipient3);

Line 130: asn_debug.put_line('sender: ' || sender);

126: END LOOP;
127:
128: IF l_debug_on THEN
129: asn_debug.put_line('Entering:' || l_module_name);
130: asn_debug.put_line('sender: ' || sender);
131: asn_debug.put_line('recipient1: ' || recipient1);
132: asn_debug.put_line('recipient2: ' || recipient2);
133: asn_debug.put_line('recipient3: ' || recipient3);
134: asn_debug.put_line('recipient4: ' || recipient4);

Line 131: asn_debug.put_line('recipient1: ' || recipient1);

127:
128: IF l_debug_on THEN
129: asn_debug.put_line('Entering:' || l_module_name);
130: asn_debug.put_line('sender: ' || sender);
131: asn_debug.put_line('recipient1: ' || recipient1);
132: asn_debug.put_line('recipient2: ' || recipient2);
133: asn_debug.put_line('recipient3: ' || recipient3);
134: asn_debug.put_line('recipient4: ' || recipient4);
135: END IF;

Line 132: asn_debug.put_line('recipient2: ' || recipient2);

128: IF l_debug_on THEN
129: asn_debug.put_line('Entering:' || l_module_name);
130: asn_debug.put_line('sender: ' || sender);
131: asn_debug.put_line('recipient1: ' || recipient1);
132: asn_debug.put_line('recipient2: ' || recipient2);
133: asn_debug.put_line('recipient3: ' || recipient3);
134: asn_debug.put_line('recipient4: ' || recipient4);
135: END IF;
136:

Line 133: asn_debug.put_line('recipient3: ' || recipient3);

129: asn_debug.put_line('Entering:' || l_module_name);
130: asn_debug.put_line('sender: ' || sender);
131: asn_debug.put_line('recipient1: ' || recipient1);
132: asn_debug.put_line('recipient2: ' || recipient2);
133: asn_debug.put_line('recipient3: ' || recipient3);
134: asn_debug.put_line('recipient4: ' || recipient4);
135: END IF;
136:
137: --Call function that will return the email server name

Line 134: asn_debug.put_line('recipient4: ' || recipient4);

130: asn_debug.put_line('sender: ' || sender);
131: asn_debug.put_line('recipient1: ' || recipient1);
132: asn_debug.put_line('recipient2: ' || recipient2);
133: asn_debug.put_line('recipient3: ' || recipient3);
134: asn_debug.put_line('recipient4: ' || recipient4);
135: END IF;
136:
137: --Call function that will return the email server name
138: l_mailhost := get_email_server;

Line 144: asn_debug.put_line('l_mailhost: ' || l_mailhost);

140: l_email_addrs := get_email_address;
141:
142: --Parse to get individual recipients
143: IF l_debug_on THEN
144: asn_debug.put_line('l_mailhost: ' || l_mailhost);
145: asn_debug.put_line('l_email_addrs: ' || l_email_addrs);
146: END IF;
147:
148: IF l_mailhost IS NOT NULL

Line 145: asn_debug.put_line('l_email_addrs: ' || l_email_addrs);

141:
142: --Parse to get individual recipients
143: IF l_debug_on THEN
144: asn_debug.put_line('l_mailhost: ' || l_mailhost);
145: asn_debug.put_line('l_email_addrs: ' || l_email_addrs);
146: END IF;
147:
148: IF l_mailhost IS NOT NULL
149: AND l_email_addrs IS NOT NULL THEN

Line 198: asn_debug.put_line('Now sender :' || l_sender);

194:
195: l_recipient5 := SUBSTRB(l_email_addrs, l_start_pos, l_end_pos - l_start_pos);
196:
197: IF l_debug_on THEN
198: asn_debug.put_line('Now sender :' || l_sender);
199: asn_debug.put_line('Now recipient1: ' || l_recipient1);
200: asn_debug.put_line('Now recipient2: ' || l_recipient2);
201: asn_debug.put_line('Now recipient3: ' || l_recipient3);
202: asn_debug.put_line('Now recipient4: ' || l_recipient4);

Line 199: asn_debug.put_line('Now recipient1: ' || l_recipient1);

195: l_recipient5 := SUBSTRB(l_email_addrs, l_start_pos, l_end_pos - l_start_pos);
196:
197: IF l_debug_on THEN
198: asn_debug.put_line('Now sender :' || l_sender);
199: asn_debug.put_line('Now recipient1: ' || l_recipient1);
200: asn_debug.put_line('Now recipient2: ' || l_recipient2);
201: asn_debug.put_line('Now recipient3: ' || l_recipient3);
202: asn_debug.put_line('Now recipient4: ' || l_recipient4);
203: asn_debug.put_line('Now recipient5: ' || l_recipient5);

Line 200: asn_debug.put_line('Now recipient2: ' || l_recipient2);

196:
197: IF l_debug_on THEN
198: asn_debug.put_line('Now sender :' || l_sender);
199: asn_debug.put_line('Now recipient1: ' || l_recipient1);
200: asn_debug.put_line('Now recipient2: ' || l_recipient2);
201: asn_debug.put_line('Now recipient3: ' || l_recipient3);
202: asn_debug.put_line('Now recipient4: ' || l_recipient4);
203: asn_debug.put_line('Now recipient5: ' || l_recipient5);
204: END IF;

Line 201: asn_debug.put_line('Now recipient3: ' || l_recipient3);

197: IF l_debug_on THEN
198: asn_debug.put_line('Now sender :' || l_sender);
199: asn_debug.put_line('Now recipient1: ' || l_recipient1);
200: asn_debug.put_line('Now recipient2: ' || l_recipient2);
201: asn_debug.put_line('Now recipient3: ' || l_recipient3);
202: asn_debug.put_line('Now recipient4: ' || l_recipient4);
203: asn_debug.put_line('Now recipient5: ' || l_recipient5);
204: END IF;
205:

Line 202: asn_debug.put_line('Now recipient4: ' || l_recipient4);

198: asn_debug.put_line('Now sender :' || l_sender);
199: asn_debug.put_line('Now recipient1: ' || l_recipient1);
200: asn_debug.put_line('Now recipient2: ' || l_recipient2);
201: asn_debug.put_line('Now recipient3: ' || l_recipient3);
202: asn_debug.put_line('Now recipient4: ' || l_recipient4);
203: asn_debug.put_line('Now recipient5: ' || l_recipient5);
204: END IF;
205:
206: UTL_SMTP.helo(l_mail_conn, l_mailhost);

Line 203: asn_debug.put_line('Now recipient5: ' || l_recipient5);

199: asn_debug.put_line('Now recipient1: ' || l_recipient1);
200: asn_debug.put_line('Now recipient2: ' || l_recipient2);
201: asn_debug.put_line('Now recipient3: ' || l_recipient3);
202: asn_debug.put_line('Now recipient4: ' || l_recipient4);
203: asn_debug.put_line('Now recipient5: ' || l_recipient5);
204: END IF;
205:
206: UTL_SMTP.helo(l_mail_conn, l_mailhost);
207: UTL_SMTP.mail(l_mail_conn, l_sender);

Line 233: asn_debug.put_line('Not sending mail. Server Name or Email id is null');

229: UTL_SMTP.DATA(l_mail_conn, MESSAGE);
230: UTL_SMTP.quit(l_mail_conn);
231: ELSE
232: IF l_debug_on THEN
233: asn_debug.put_line('Not sending mail. Server Name or Email id is null');
234: END IF;
235: END IF;
236:
237: IF l_debug_on THEN

Line 238: asn_debug.put_line('Exiting :' || l_module_name);

234: END IF;
235: END IF;
236:
237: IF l_debug_on THEN
238: asn_debug.put_line('Exiting :' || l_module_name);
239: END IF;
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF l_debug_on THEN

Line 243: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SQLERRM);

239: END IF;
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF l_debug_on THEN
243: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SQLERRM);
244: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
245: END IF;
246: END send_mail;
247:

Line 244: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

240: EXCEPTION
241: WHEN OTHERS THEN
242: IF l_debug_on THEN
243: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SQLERRM);
244: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
245: END IF;
246: END send_mail;
247:
248: /*===========================================================================

Line 432: asn_debug.put_line('Entering :' || l_module_name);

428: END IF;
429:
430: --
431: IF l_debug_on THEN
432: asn_debug.put_line('Entering :' || l_module_name);
433: asn_debug.put_line('p_action_code' || p_action_code);
434: asn_debug.put_line('p_raise_exception' || p_raise_exception);
435: END IF;
436:

Line 433: asn_debug.put_line('p_action_code' || p_action_code);

429:
430: --
431: IF l_debug_on THEN
432: asn_debug.put_line('Entering :' || l_module_name);
433: asn_debug.put_line('p_action_code' || p_action_code);
434: asn_debug.put_line('p_raise_exception' || p_raise_exception);
435: END IF;
436:
437: l_rollback_allowed := NVL(p_raise_exception, 'Y');

Line 434: asn_debug.put_line('p_raise_exception' || p_raise_exception);

430: --
431: IF l_debug_on THEN
432: asn_debug.put_line('Entering :' || l_module_name);
433: asn_debug.put_line('p_action_code' || p_action_code);
434: asn_debug.put_line('p_raise_exception' || p_raise_exception);
435: END IF;
436:
437: l_rollback_allowed := NVL(p_raise_exception, 'Y');
438:

Line 459: asn_debug.put_line('User Id' || g_userid);

455: l_conc_request_id := NULL;
456: END IF;
457:
458: IF l_debug_on THEN
459: asn_debug.put_line('User Id' || g_userid);
460: asn_debug.put_line('User Name' || g_user_name);
461: asn_debug.put_line('Env' || g_env);
462: END IF;
463:

Line 460: asn_debug.put_line('User Name' || g_user_name);

456: END IF;
457:
458: IF l_debug_on THEN
459: asn_debug.put_line('User Id' || g_userid);
460: asn_debug.put_line('User Name' || g_user_name);
461: asn_debug.put_line('Env' || g_env);
462: END IF;
463:
464: IF (g_dc_table.COUNT > 0) THEN

Line 461: asn_debug.put_line('Env' || g_env);

457:
458: IF l_debug_on THEN
459: asn_debug.put_line('User Id' || g_userid);
460: asn_debug.put_line('User Name' || g_user_name);
461: asn_debug.put_line('Env' || g_env);
462: END IF;
463:
464: IF (g_dc_table.COUNT > 0) THEN
465:

Line 471: asn_debug.put_line('DCP - Started Debugger');

467: switch_debug(p_action => 'ON', p_file_name => g_file_name);
468: l_debug_on := TRUE;
469: g_debug_on := 'Y';
470:
471: asn_debug.put_line('DCP - Started Debugger');
472: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
473: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
474: asn_debug.put_line('conc. request id :' || l_conc_request_id);
475:

Line 472: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);

468: l_debug_on := TRUE;
469: g_debug_on := 'Y';
470:
471: asn_debug.put_line('DCP - Started Debugger');
472: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
473: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
474: asn_debug.put_line('conc. request id :' || l_conc_request_id);
475:
476: IF (l_rollback_allowed = 'Y') THEN

Line 473: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);

469: g_debug_on := 'Y';
470:
471: asn_debug.put_line('DCP - Started Debugger');
472: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
473: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
474: asn_debug.put_line('conc. request id :' || l_conc_request_id);
475:
476: IF (l_rollback_allowed = 'Y') THEN
477: RAISE dcp_caught;

Line 474: asn_debug.put_line('conc. request id :' || l_conc_request_id);

470:
471: asn_debug.put_line('DCP - Started Debugger');
472: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
473: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
474: asn_debug.put_line('conc. request id :' || l_conc_request_id);
475:
476: IF (l_rollback_allowed = 'Y') THEN
477: RAISE dcp_caught;
478: END IF;

Line 510: asn_debug.put_line('Begining of Call Stack');

506: -- if global was set , turn debug off
507: -- Put CallStack in debug file
508: IF l_debug_on THEN
509: l_call_stack := DBMS_UTILITY.format_call_stack;
510: asn_debug.put_line('**********Begining of Call Stack**********');
511: asn_debug.put_line(l_call_stack);
512: asn_debug.put_line('**********End of Call Stack**********');
513: END IF;
514:

Line 511: asn_debug.put_line(l_call_stack);

507: -- Put CallStack in debug file
508: IF l_debug_on THEN
509: l_call_stack := DBMS_UTILITY.format_call_stack;
510: asn_debug.put_line('**********Begining of Call Stack**********');
511: asn_debug.put_line(l_call_stack);
512: asn_debug.put_line('**********End of Call Stack**********');
513: END IF;
514:
515:

Line 512: asn_debug.put_line('End of Call Stack');

508: IF l_debug_on THEN
509: l_call_stack := DBMS_UTILITY.format_call_stack;
510: asn_debug.put_line('**********Begining of Call Stack**********');
511: asn_debug.put_line(l_call_stack);
512: asn_debug.put_line('**********End of Call Stack**********');
513: END IF;
514:
515:
516: l_message := l_message || '********** Here are the Details **********' || crlf;

Line 586: asn_debug.put_line(l_temp_message);

582: ' || l_temp_message || '. ';
583: END IF;
584:
585: IF l_debug_on THEN
586: asn_debug.put_line(l_temp_message);
587: END IF;
588:
589: k := g_dc_table.NEXT(k);
590: --}

Line 607: asn_debug.put_line('DCP - Stopped Debugger');

603: -- Stop the debugger if it was started earlier
604: IF g_debug_started = 'Y' THEN
605: switch_debug(p_action => 'OFF', p_file_name => l_file_name);
606: IF l_debug_on THEN
607: asn_debug.put_line('DCP - Stopped Debugger');
608: g_debug_on := asn_debug.is_debug_on; -- Bug 9152790
609: END IF;
610: END IF;
611: EXCEPTION

Line 608: g_debug_on := asn_debug.is_debug_on; -- Bug 9152790

604: IF g_debug_started = 'Y' THEN
605: switch_debug(p_action => 'OFF', p_file_name => l_file_name);
606: IF l_debug_on THEN
607: asn_debug.put_line('DCP - Stopped Debugger');
608: g_debug_on := asn_debug.is_debug_on; -- Bug 9152790
609: END IF;
610: END IF;
611: EXCEPTION
612: WHEN dcp_caught THEN

Line 614: asn_debug.put_line('DCP Caught: Post Process');

610: END IF;
611: EXCEPTION
612: WHEN dcp_caught THEN
613: IF l_debug_on THEN
614: asn_debug.put_line('DCP Caught: Post Process');
615: asn_debug.put_line('Exception: dcp_caught');
616: END IF;
617:
618: RAISE dcp_caught;

Line 615: asn_debug.put_line('Exception: dcp_caught');

611: EXCEPTION
612: WHEN dcp_caught THEN
613: IF l_debug_on THEN
614: asn_debug.put_line('DCP Caught: Post Process');
615: asn_debug.put_line('Exception: dcp_caught');
616: END IF;
617:
618: RAISE dcp_caught;
619: WHEN OTHERS THEN

Line 621: asn_debug.put_line('Unexpected error has occured. Oracle error message is ' || SQLERRM);

617:
618: RAISE dcp_caught;
619: WHEN OTHERS THEN
620: IF l_debug_on THEN
621: asn_debug.put_line('Unexpected error has occured. Oracle error message is ' || SQLERRM);
622: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
623: END IF;
624: END post_process;
625:

Line 622: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

618: RAISE dcp_caught;
619: WHEN OTHERS THEN
620: IF l_debug_on THEN
621: asn_debug.put_line('Unexpected error has occured. Oracle error message is ' || SQLERRM);
622: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
623: END IF;
624: END post_process;
625:
626: PROCEDURE check_scripts(p_action_code IN VARCHAR2, p_header_interface_id IN NUMBER, p_interface_transaction_id IN NUMBER) IS

Line 1024: asn_debug.put_line('Data is inconsistent');

1020:
1021: g_table_count := i;
1022: IF (i > 1) THEN
1023: IF l_debug_on THEN
1024: asn_debug.put_line('Data is inconsistent');
1025: END IF;
1026: END IF;
1027: EXCEPTION
1028: WHEN OTHERS THEN

Line 1030: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));

1026: END IF;
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF l_debug_on THEN
1030: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1031: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1032: END IF;
1033: END check_scripts;
1034:

Line 1031: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF l_debug_on THEN
1030: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1031: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1032: END IF;
1033: END check_scripts;
1034:
1035: PROCEDURE validate_data(

Line 1079: asn_debug.put_line('p_request_id= ' || p_request_id);

1075: l_debug_on := FALSE;
1076: END IF;
1077:
1078: IF l_debug_on THEN
1079: asn_debug.put_line('p_request_id= ' || p_request_id);
1080: asn_debug.put_line('p_group_id= ' || p_group_id);
1081: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1082: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1083: asn_debug.put_line('p_raise_exception' || p_raise_exception);

Line 1080: asn_debug.put_line('p_group_id= ' || p_group_id);

1076: END IF;
1077:
1078: IF l_debug_on THEN
1079: asn_debug.put_line('p_request_id= ' || p_request_id);
1080: asn_debug.put_line('p_group_id= ' || p_group_id);
1081: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1082: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1083: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1084: END IF;

Line 1081: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);

1077:
1078: IF l_debug_on THEN
1079: asn_debug.put_line('p_request_id= ' || p_request_id);
1080: asn_debug.put_line('p_group_id= ' || p_group_id);
1081: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1082: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1083: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1084: END IF;
1085: IF p_dcp_event = 'PREPROCESSOR' THEN

Line 1082: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);

1078: IF l_debug_on THEN
1079: asn_debug.put_line('p_request_id= ' || p_request_id);
1080: asn_debug.put_line('p_group_id= ' || p_group_id);
1081: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1082: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1083: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1084: END IF;
1085: IF p_dcp_event = 'PREPROCESSOR' THEN
1086: FOR header_cur_rec IN headers_cur_dcp(p_request_id, p_group_id) LOOP

Line 1083: asn_debug.put_line('p_raise_exception' || p_raise_exception);

1079: asn_debug.put_line('p_request_id= ' || p_request_id);
1080: asn_debug.put_line('p_group_id= ' || p_group_id);
1081: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1082: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1083: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1084: END IF;
1085: IF p_dcp_event = 'PREPROCESSOR' THEN
1086: FOR header_cur_rec IN headers_cur_dcp(p_request_id, p_group_id) LOOP
1087: check_scripts(p_action_code => p_dcp_event, p_header_interface_id => header_cur_rec.header_interface_id, p_interface_transaction_id => p_interface_transaction_id);

Line 1107: asn_debug.put_line('dcp_caught exception: Validate_data');

1103: x_return_status := 'S';
1104: EXCEPTION
1105: WHEN dcp_caught THEN
1106: IF l_debug_on THEN
1107: asn_debug.put_line('dcp_caught exception: Validate_data');
1108: asn_debug.put_line('EXCEPTION:DCP_CAUGHT: Validate_data');
1109: END IF;
1110:
1111: x_return_status := 'S';

Line 1108: asn_debug.put_line('EXCEPTION:DCP_CAUGHT: Validate_data');

1104: EXCEPTION
1105: WHEN dcp_caught THEN
1106: IF l_debug_on THEN
1107: asn_debug.put_line('dcp_caught exception: Validate_data');
1108: asn_debug.put_line('EXCEPTION:DCP_CAUGHT: Validate_data');
1109: END IF;
1110:
1111: x_return_status := 'S';
1112: RAISE data_inconsistency_exception;

Line 1115: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));

1111: x_return_status := 'S';
1112: RAISE data_inconsistency_exception;
1113: WHEN OTHERS THEN
1114: IF l_debug_on THEN
1115: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1116: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1117: x_return_status := 'E';
1118: END IF;
1119: END validate_data;

Line 1116: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1112: RAISE data_inconsistency_exception;
1113: WHEN OTHERS THEN
1114: IF l_debug_on THEN
1115: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1116: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1117: x_return_status := 'E';
1118: END IF;
1119: END validate_data;
1120: END rcv_dcp_pvt;