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

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

1: PACKAGE BODY RCV_SHIPMENT_LINE_SV AS
2: /* $Header: RCVTHCB.pls 120.0.12010000.2 2010/01/25 23:33:00 vthevark ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
6:
7: /*===========================================================================+
8: | |
9: | PROCEDURE NAME: create_shipment_line() |

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

26:
27:
28: BEGIN
29:
30: IF (g_asn_debug = 'Y') THEN
31: ASN_DEBUG.PUT_LINE('Enter create shipment line');
32: END IF;
33:
34: IF (g_asn_debug = 'Y') THEN

Line 31: ASN_DEBUG.PUT_LINE('Enter create shipment line');

27:
28: BEGIN
29:
30: IF (g_asn_debug = 'Y') THEN
31: ASN_DEBUG.PUT_LINE('Enter create shipment line');
32: END IF;
33:
34: IF (g_asn_debug = 'Y') THEN
35: ASN_DEBUG.PUT_LINE('Initialize the table structure used for storing the cascaded rows');

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

30: IF (g_asn_debug = 'Y') THEN
31: ASN_DEBUG.PUT_LINE('Enter create shipment line');
32: END IF;
33:
34: IF (g_asn_debug = 'Y') THEN
35: ASN_DEBUG.PUT_LINE('Initialize the table structure used for storing the cascaded rows');
36: END IF;
37:
38: -- delete all records from used_for_cascaded_rows

Line 35: ASN_DEBUG.PUT_LINE('Initialize the table structure used for storing the cascaded rows');

31: ASN_DEBUG.PUT_LINE('Enter create shipment line');
32: END IF;
33:
34: IF (g_asn_debug = 'Y') THEN
35: ASN_DEBUG.PUT_LINE('Initialize the table structure used for storing the cascaded rows');
36: END IF;
37:
38: -- delete all records from used_for_cascaded_rows
39:

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

49: -- derive IDs and also explode rows
50:
51: rcv_transactions_interface_sv.derive_shipment_line (X_cascaded_table, n, used_for_cascaded_rows, V_header_record);
52:
53: IF (g_asn_debug = 'Y') THEN
54: ASN_DEBUG.PUT_LINE('Back from derive routine with ' || to_char(used_for_cascaded_rows.count) || ' rows');
55: ASN_DEBUG.PUT_LINE('Error Status ' || x_cascaded_table(n).error_status);
56: ASN_DEBUG.PUT_LINE('Error Message ' || x_cascaded_table(n).error_message);
57: END IF;

Line 54: ASN_DEBUG.PUT_LINE('Back from derive routine with ' || to_char(used_for_cascaded_rows.count) || ' rows');

50:
51: rcv_transactions_interface_sv.derive_shipment_line (X_cascaded_table, n, used_for_cascaded_rows, V_header_record);
52:
53: IF (g_asn_debug = 'Y') THEN
54: ASN_DEBUG.PUT_LINE('Back from derive routine with ' || to_char(used_for_cascaded_rows.count) || ' rows');
55: ASN_DEBUG.PUT_LINE('Error Status ' || x_cascaded_table(n).error_status);
56: ASN_DEBUG.PUT_LINE('Error Message ' || x_cascaded_table(n).error_message);
57: END IF;
58:

Line 55: ASN_DEBUG.PUT_LINE('Error Status ' || x_cascaded_table(n).error_status);

51: rcv_transactions_interface_sv.derive_shipment_line (X_cascaded_table, n, used_for_cascaded_rows, V_header_record);
52:
53: IF (g_asn_debug = 'Y') THEN
54: ASN_DEBUG.PUT_LINE('Back from derive routine with ' || to_char(used_for_cascaded_rows.count) || ' rows');
55: ASN_DEBUG.PUT_LINE('Error Status ' || x_cascaded_table(n).error_status);
56: ASN_DEBUG.PUT_LINE('Error Message ' || x_cascaded_table(n).error_message);
57: END IF;
58:
59: X_progress := '010';

Line 56: ASN_DEBUG.PUT_LINE('Error Message ' || x_cascaded_table(n).error_message);

52:
53: IF (g_asn_debug = 'Y') THEN
54: ASN_DEBUG.PUT_LINE('Back from derive routine with ' || to_char(used_for_cascaded_rows.count) || ' rows');
55: ASN_DEBUG.PUT_LINE('Error Status ' || x_cascaded_table(n).error_status);
56: ASN_DEBUG.PUT_LINE('Error Message ' || x_cascaded_table(n).error_message);
57: END IF;
58:
59: X_progress := '010';
60:

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

62: used_for_cascaded_rows.count > 0 then -- we have returned with a cascaded table
63:
64: for i in 1..used_for_cascaded_rows.count loop
65:
66: IF (g_asn_debug = 'Y') THEN
67: ASN_DEBUG.PUT_LINE('Defaulting for cascaded row ' || to_char(i));
68: END IF;
69: rcv_transactions_interface_sv.default_shipment_line (used_for_cascaded_rows, i, X_header_id, V_header_record);
70:

Line 67: ASN_DEBUG.PUT_LINE('Defaulting for cascaded row ' || to_char(i));

63:
64: for i in 1..used_for_cascaded_rows.count loop
65:
66: IF (g_asn_debug = 'Y') THEN
67: ASN_DEBUG.PUT_LINE('Defaulting for cascaded row ' || to_char(i));
68: END IF;
69: rcv_transactions_interface_sv.default_shipment_line (used_for_cascaded_rows, i, X_header_id, V_header_record);
70:
71: X_progress := '020';

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

82: X_cascaded_table(n).processing_status_code := 'ERROR';
83: X_cascaded_table(n).error_status := used_for_cascaded_rows(i).error_status;
84: X_cascaded_table(n).error_message := used_for_cascaded_rows(i).error_message;
85:
86: IF (g_asn_debug = 'Y') THEN
87: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
88: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
89: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
90: END IF;

Line 87: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');

83: X_cascaded_table(n).error_status := used_for_cascaded_rows(i).error_status;
84: X_cascaded_table(n).error_message := used_for_cascaded_rows(i).error_message;
85:
86: IF (g_asn_debug = 'Y') THEN
87: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
88: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
89: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
90: END IF;
91:

Line 88: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');

84: X_cascaded_table(n).error_message := used_for_cascaded_rows(i).error_message;
85:
86: IF (g_asn_debug = 'Y') THEN
87: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
88: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
89: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
90: END IF;
91:
92: for j in 1..used_for_cascaded_rows.count loop

Line 89: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');

85:
86: IF (g_asn_debug = 'Y') THEN
87: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
88: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
89: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
90: END IF;
91:
92: for j in 1..used_for_cascaded_rows.count loop
93:

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

101: end loop;
102:
103: IF X_cascaded_table(n).processing_status_code = 'ERROR' THEN
104:
105: IF (g_asn_debug = 'Y') THEN
106: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
107: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
108: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
109: END IF;

Line 106: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');

102:
103: IF X_cascaded_table(n).processing_status_code = 'ERROR' THEN
104:
105: IF (g_asn_debug = 'Y') THEN
106: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
107: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
108: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
109: END IF;
110:

Line 107: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');

103: IF X_cascaded_table(n).processing_status_code = 'ERROR' THEN
104:
105: IF (g_asn_debug = 'Y') THEN
106: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
107: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
108: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
109: END IF;
110:
111: for j in 1..used_for_cascaded_rows.count loop

Line 108: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');

104:
105: IF (g_asn_debug = 'Y') THEN
106: ASN_DEBUG.PUT_LINE('Have hit error condition in validation');
107: ASN_DEBUG.PUT_LINE('Mark needed flags and error message');
108: ASN_DEBUG.PUT_LINE('Delete the cascaded rows');
109: END IF;
110:
111: for j in 1..used_for_cascaded_rows.count loop
112:

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

115: end loop;
116:
117: ELSE
118:
119: IF (g_asn_debug = 'Y') THEN
120: ASN_DEBUG.PUT_LINE('Have finished default and validation');
121: ASN_DEBUG.PUT_LINE('Process has encountered no fatal errors');
122: ASN_DEBUG.PUT_LINE('Will write the cascaded rows into actual table');
123: ASN_DEBUG.PUT_LINE('Count of cascaded rows ' || to_char(used_for_cascaded_rows.count));

Line 120: ASN_DEBUG.PUT_LINE('Have finished default and validation');

116:
117: ELSE
118:
119: IF (g_asn_debug = 'Y') THEN
120: ASN_DEBUG.PUT_LINE('Have finished default and validation');
121: ASN_DEBUG.PUT_LINE('Process has encountered no fatal errors');
122: ASN_DEBUG.PUT_LINE('Will write the cascaded rows into actual table');
123: ASN_DEBUG.PUT_LINE('Count of cascaded rows ' || to_char(used_for_cascaded_rows.count));
124: END IF;

Line 121: ASN_DEBUG.PUT_LINE('Process has encountered no fatal errors');

117: ELSE
118:
119: IF (g_asn_debug = 'Y') THEN
120: ASN_DEBUG.PUT_LINE('Have finished default and validation');
121: ASN_DEBUG.PUT_LINE('Process has encountered no fatal errors');
122: ASN_DEBUG.PUT_LINE('Will write the cascaded rows into actual table');
123: ASN_DEBUG.PUT_LINE('Count of cascaded rows ' || to_char(used_for_cascaded_rows.count));
124: END IF;
125:

Line 122: ASN_DEBUG.PUT_LINE('Will write the cascaded rows into actual table');

118:
119: IF (g_asn_debug = 'Y') THEN
120: ASN_DEBUG.PUT_LINE('Have finished default and validation');
121: ASN_DEBUG.PUT_LINE('Process has encountered no fatal errors');
122: ASN_DEBUG.PUT_LINE('Will write the cascaded rows into actual table');
123: ASN_DEBUG.PUT_LINE('Count of cascaded rows ' || to_char(used_for_cascaded_rows.count));
124: END IF;
125:
126: for j in 1..used_for_cascaded_rows.count loop

Line 123: ASN_DEBUG.PUT_LINE('Count of cascaded rows ' || to_char(used_for_cascaded_rows.count));

119: IF (g_asn_debug = 'Y') THEN
120: ASN_DEBUG.PUT_LINE('Have finished default and validation');
121: ASN_DEBUG.PUT_LINE('Process has encountered no fatal errors');
122: ASN_DEBUG.PUT_LINE('Will write the cascaded rows into actual table');
123: ASN_DEBUG.PUT_LINE('Count of cascaded rows ' || to_char(used_for_cascaded_rows.count));
124: END IF;
125:
126: for j in 1..used_for_cascaded_rows.count loop
127:

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

124: END IF;
125:
126: for j in 1..used_for_cascaded_rows.count loop
127:
128: IF (g_asn_debug = 'Y') THEN
129: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));
130: END IF;
131: X_cascaded_table(n) := used_for_cascaded_rows(j);
132: used_for_cascaded_rows.delete(j);

Line 129: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));

125:
126: for j in 1..used_for_cascaded_rows.count loop
127:
128: IF (g_asn_debug = 'Y') THEN
129: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));
130: END IF;
131: X_cascaded_table(n) := used_for_cascaded_rows(j);
132: used_for_cascaded_rows.delete(j);
133: n := n + 1;

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

133: n := n + 1;
134:
135: end loop;
136:
137: IF (g_asn_debug = 'Y') THEN
138: ASN_DEBUG.PUT_LINE('Current counter before decrementing in actual table is at ' || to_char(n));
139: END IF;
140: n := n -1; -- Get the counter in sync
141: IF (g_asn_debug = 'Y') THEN

Line 138: ASN_DEBUG.PUT_LINE('Current counter before decrementing in actual table is at ' || to_char(n));

134:
135: end loop;
136:
137: IF (g_asn_debug = 'Y') THEN
138: ASN_DEBUG.PUT_LINE('Current counter before decrementing in actual table is at ' || to_char(n));
139: END IF;
140: n := n -1; -- Get the counter in sync
141: IF (g_asn_debug = 'Y') THEN
142: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));

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

137: IF (g_asn_debug = 'Y') THEN
138: ASN_DEBUG.PUT_LINE('Current counter before decrementing in actual table is at ' || to_char(n));
139: END IF;
140: n := n -1; -- Get the counter in sync
141: IF (g_asn_debug = 'Y') THEN
142: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));
143: END IF;
144:
145: END IF;

Line 142: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));

138: ASN_DEBUG.PUT_LINE('Current counter before decrementing in actual table is at ' || to_char(n));
139: END IF;
140: n := n -1; -- Get the counter in sync
141: IF (g_asn_debug = 'Y') THEN
142: ASN_DEBUG.PUT_LINE('Current counter in actual table is at ' || to_char(n));
143: END IF;
144:
145: END IF;
146:

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

149: X_cascaded_table(n).processing_status_code := 'ERROR'; -- changed (i) -> (n)
150: return;
151: end if;
152:
153: IF (g_asn_debug = 'Y') THEN
154: ASN_DEBUG.PUT_LINE('Exit create shipment line');
155: END IF;
156:
157: END create_shipment_line;

Line 154: ASN_DEBUG.PUT_LINE('Exit create shipment line');

150: return;
151: end if;
152:
153: IF (g_asn_debug = 'Y') THEN
154: ASN_DEBUG.PUT_LINE('Exit create shipment line');
155: END IF;
156:
157: END create_shipment_line;
158: