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 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 299: asn_debug.g_debugging_enabled := 'Y';

295: fnd_profile.put('AFLOG_MODULE', '%');
296: fnd_profile.put('AFLOG_BUFFER_MODE', '1');
297: fnd_profile.put('PO_RVCTP_ENABLE_TRACE', 'Y');
298: fnd_profile.put('RCV_DEBUG_MODE', 'Y');
299: asn_debug.g_debugging_enabled := 'Y';
300: fnd_profile.put('INV_DEBUG_TRACE', '1');
301: fnd_profile.put('INV_DEBUG_LEVEL', '11');
302:
303: -- Processing for INV Debug file

Line 382: asn_debug.g_debugging_enabled := g_rcv_debug_enabled;

378: fnd_profile.put('INV_DEBUG_TRACE', g_inv_debug_enabled);
379: fnd_profile.put('INV_DEBUG_LEVEL', g_inv_debug_level);
380: fnd_profile.put('INV_DEBUG_FILE', g_inv_debug_file);
381: g_debug_started := 'N';
382: asn_debug.g_debugging_enabled := g_rcv_debug_enabled;
383: END IF;
384: END switch_debug;
385:
386:

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

456: END IF;
457:
458: --
459: IF l_debug_on THEN
460: asn_debug.put_line('Entering :' || l_module_name);
461: asn_debug.put_line('p_action_code' || p_action_code);
462: asn_debug.put_line('p_raise_exception' || p_raise_exception);
463: END IF;
464:

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

457:
458: --
459: IF l_debug_on THEN
460: asn_debug.put_line('Entering :' || l_module_name);
461: asn_debug.put_line('p_action_code' || p_action_code);
462: asn_debug.put_line('p_raise_exception' || p_raise_exception);
463: END IF;
464:
465: l_rollback_allowed := NVL(p_raise_exception, 'Y');

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

458: --
459: IF l_debug_on THEN
460: asn_debug.put_line('Entering :' || l_module_name);
461: asn_debug.put_line('p_action_code' || p_action_code);
462: asn_debug.put_line('p_raise_exception' || p_raise_exception);
463: END IF;
464:
465: l_rollback_allowed := NVL(p_raise_exception, 'Y');
466:

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

483: l_conc_request_id := NULL;
484: END IF;
485:
486: IF l_debug_on THEN
487: asn_debug.put_line('User Id' || g_userid);
488: asn_debug.put_line('User Name' || g_user_name);
489: asn_debug.put_line('Env' || g_env);
490: END IF;
491:

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

484: END IF;
485:
486: IF l_debug_on THEN
487: asn_debug.put_line('User Id' || g_userid);
488: asn_debug.put_line('User Name' || g_user_name);
489: asn_debug.put_line('Env' || g_env);
490: END IF;
491:
492: IF (g_dc_table.COUNT > 0) THEN

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

485:
486: IF l_debug_on THEN
487: asn_debug.put_line('User Id' || g_userid);
488: asn_debug.put_line('User Name' || g_user_name);
489: asn_debug.put_line('Env' || g_env);
490: END IF;
491:
492: IF (g_dc_table.COUNT > 0) THEN
493:

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

495: switch_debug(p_action => 'ON', p_file_name => g_file_name);
496: l_debug_on := TRUE;
497: g_debug_on := 'Y';
498:
499: asn_debug.put_line('DCP - Started Debugger');
500: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
501: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
502: asn_debug.put_line('conc. request id :' || l_conc_request_id);
503:

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

496: l_debug_on := TRUE;
497: g_debug_on := 'Y';
498:
499: asn_debug.put_line('DCP - Started Debugger');
500: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
501: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
502: asn_debug.put_line('conc. request id :' || l_conc_request_id);
503:
504: IF (l_rollback_allowed = 'Y') THEN

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

497: g_debug_on := 'Y';
498:
499: asn_debug.put_line('DCP - Started Debugger');
500: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
501: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
502: asn_debug.put_line('conc. request id :' || l_conc_request_id);
503:
504: IF (l_rollback_allowed = 'Y') THEN
505: RAISE dcp_caught;

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

498:
499: asn_debug.put_line('DCP - Started Debugger');
500: asn_debug.put_line('g_dc_table count :' || g_dc_table.COUNT);
501: asn_debug.put_line('l_rollback_allowed :' || l_rollback_allowed);
502: asn_debug.put_line('conc. request id :' || l_conc_request_id);
503:
504: IF (l_rollback_allowed = 'Y') THEN
505: RAISE dcp_caught;
506: END IF;

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

534: -- if global was set , turn debug off
535: -- Put CallStack in debug file
536: IF l_debug_on THEN
537: l_call_stack := DBMS_UTILITY.format_call_stack;
538: asn_debug.put_line('**********Begining of Call Stack**********');
539: asn_debug.put_line(l_call_stack);
540: asn_debug.put_line('**********End of Call Stack**********');
541: END IF;
542:

Line 539: asn_debug.put_line(l_call_stack);

535: -- Put CallStack in debug file
536: IF l_debug_on THEN
537: l_call_stack := DBMS_UTILITY.format_call_stack;
538: asn_debug.put_line('**********Begining of Call Stack**********');
539: asn_debug.put_line(l_call_stack);
540: asn_debug.put_line('**********End of Call Stack**********');
541: END IF;
542:
543:

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

536: IF l_debug_on THEN
537: l_call_stack := DBMS_UTILITY.format_call_stack;
538: asn_debug.put_line('**********Begining of Call Stack**********');
539: asn_debug.put_line(l_call_stack);
540: asn_debug.put_line('**********End of Call Stack**********');
541: END IF;
542:
543:
544: l_message := l_message || '********** Here are the Details **********' || crlf;

Line 614: asn_debug.put_line(l_temp_message);

610: ' || l_temp_message || '. ';
611: END IF;
612:
613: IF l_debug_on THEN
614: asn_debug.put_line(l_temp_message);
615: END IF;
616:
617: k := g_dc_table.NEXT(k);
618: --}

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

631: -- Stop the debugger if it was started earlier
632: IF g_debug_started = 'Y' THEN
633: switch_debug(p_action => 'OFF', p_file_name => l_file_name);
634: IF l_debug_on THEN
635: asn_debug.put_line('DCP - Stopped Debugger');
636: g_debug_on := g_rcv_debug_enabled;
637: END IF;
638: END IF;
639: EXCEPTION

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

638: END IF;
639: EXCEPTION
640: WHEN dcp_caught THEN
641: IF l_debug_on THEN
642: asn_debug.put_line('DCP Caught: Post Process');
643: asn_debug.put_line('Exception: dcp_caught');
644: END IF;
645:
646: RAISE dcp_caught;

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

639: EXCEPTION
640: WHEN dcp_caught THEN
641: IF l_debug_on THEN
642: asn_debug.put_line('DCP Caught: Post Process');
643: asn_debug.put_line('Exception: dcp_caught');
644: END IF;
645:
646: RAISE dcp_caught;
647: WHEN OTHERS THEN

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

645:
646: RAISE dcp_caught;
647: WHEN OTHERS THEN
648: IF l_debug_on THEN
649: asn_debug.put_line('Unexpected error has occured. Oracle error message is ' || SQLERRM);
650: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
651: END IF;
652: END post_process;
653:

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

646: RAISE dcp_caught;
647: WHEN OTHERS THEN
648: IF l_debug_on THEN
649: asn_debug.put_line('Unexpected error has occured. Oracle error message is ' || SQLERRM);
650: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
651: END IF;
652: END post_process;
653:
654: PROCEDURE check_scripts(p_action_code IN VARCHAR2, p_header_interface_id IN NUMBER, p_interface_transaction_id IN NUMBER) IS

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

1048:
1049: g_table_count := i;
1050: IF (i > 1) THEN
1051: IF l_debug_on THEN
1052: asn_debug.put_line('Data is inconsistent');
1053: END IF;
1054: END IF;
1055: EXCEPTION
1056: WHEN OTHERS THEN

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

1054: END IF;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: IF l_debug_on THEN
1058: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1059: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1060: END IF;
1061: END check_scripts;
1062:

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

1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: IF l_debug_on THEN
1058: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1059: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1060: END IF;
1061: END check_scripts;
1062:
1063: PROCEDURE validate_data(

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

1103: l_debug_on := FALSE;
1104: END IF;
1105:
1106: IF l_debug_on THEN
1107: asn_debug.put_line('p_request_id= ' || p_request_id);
1108: asn_debug.put_line('p_group_id= ' || p_group_id);
1109: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1110: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1111: asn_debug.put_line('p_raise_exception' || p_raise_exception);

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

1104: END IF;
1105:
1106: IF l_debug_on THEN
1107: asn_debug.put_line('p_request_id= ' || p_request_id);
1108: asn_debug.put_line('p_group_id= ' || p_group_id);
1109: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1110: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1111: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1112: END IF;

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

1105:
1106: IF l_debug_on THEN
1107: asn_debug.put_line('p_request_id= ' || p_request_id);
1108: asn_debug.put_line('p_group_id= ' || p_group_id);
1109: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1110: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1111: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1112: END IF;
1113: IF p_dcp_event = 'PREPROCESSOR' THEN

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

1106: IF l_debug_on THEN
1107: asn_debug.put_line('p_request_id= ' || p_request_id);
1108: asn_debug.put_line('p_group_id= ' || p_group_id);
1109: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1110: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1111: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1112: END IF;
1113: IF p_dcp_event = 'PREPROCESSOR' THEN
1114: FOR header_cur_rec IN headers_cur_dcp(p_request_id, p_group_id) LOOP

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

1107: asn_debug.put_line('p_request_id= ' || p_request_id);
1108: asn_debug.put_line('p_group_id= ' || p_group_id);
1109: asn_debug.put_line('p_lpn_group_id= ' || p_lpn_group_id);
1110: asn_debug.put_line('p_interface_transaction_id=' || p_interface_transaction_id);
1111: asn_debug.put_line('p_raise_exception' || p_raise_exception);
1112: END IF;
1113: IF p_dcp_event = 'PREPROCESSOR' THEN
1114: FOR header_cur_rec IN headers_cur_dcp(p_request_id, p_group_id) LOOP
1115: 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 1135: asn_debug.put_line('dcp_caught exception: Validate_data');

1131: x_return_status := 'S';
1132: EXCEPTION
1133: WHEN dcp_caught THEN
1134: IF l_debug_on THEN
1135: asn_debug.put_line('dcp_caught exception: Validate_data');
1136: asn_debug.put_line('EXCEPTION:DCP_CAUGHT: Validate_data');
1137: END IF;
1138:
1139: x_return_status := 'S';

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

1132: EXCEPTION
1133: WHEN dcp_caught THEN
1134: IF l_debug_on THEN
1135: asn_debug.put_line('dcp_caught exception: Validate_data');
1136: asn_debug.put_line('EXCEPTION:DCP_CAUGHT: Validate_data');
1137: END IF;
1138:
1139: x_return_status := 'S';
1140: RAISE data_inconsistency_exception;

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

1139: x_return_status := 'S';
1140: RAISE data_inconsistency_exception;
1141: WHEN OTHERS THEN
1142: IF l_debug_on THEN
1143: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1144: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1145: x_return_status := 'E';
1146: END IF;
1147: END validate_data;

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

1140: RAISE data_inconsistency_exception;
1141: WHEN OTHERS THEN
1142: IF l_debug_on THEN
1143: asn_debug.put_line('Unexpected error has occurred. Oracle error message is ' || SUBSTR(SQLERRM, 1, 180));
1144: asn_debug.put_line('EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1145: x_return_status := 'E';
1146: END IF;
1147: END validate_data;
1148: END rcv_dcp_pvt;