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

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

1: PACKAGE BODY rcv_transactions_util2 AS
2: /* $Header: RCVTXUTB.pls 120.1 2010/01/26 20:08:50 vthevark noship $ */
3:
4: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
5:
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'RCV_TRANSACTIONS_UTIL2';
7:
8:

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

20:
21:
22: BEGIN
23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');
26: asn_debug.put_line('item_type is '||item_type);
27: asn_debug.put_line('item_key is '||item_key);
28: asn_debug.put_line('actid is '||actid);

Line 25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');

21:
22: BEGIN
23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');
26: asn_debug.put_line('item_type is '||item_type);
27: asn_debug.put_line('item_key is '||item_key);
28: asn_debug.put_line('actid is '||actid);
29: asn_debug.put_line('funcmode is '||funcmode);

Line 26: asn_debug.put_line('item_type is '||item_type);

22: BEGIN
23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');
26: asn_debug.put_line('item_type is '||item_type);
27: asn_debug.put_line('item_key is '||item_key);
28: asn_debug.put_line('actid is '||actid);
29: asn_debug.put_line('funcmode is '||funcmode);
30: END IF;

Line 27: asn_debug.put_line('item_key is '||item_key);

23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');
26: asn_debug.put_line('item_type is '||item_type);
27: asn_debug.put_line('item_key is '||item_key);
28: asn_debug.put_line('actid is '||actid);
29: asn_debug.put_line('funcmode is '||funcmode);
30: END IF;
31:

Line 28: asn_debug.put_line('actid is '||actid);

24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');
26: asn_debug.put_line('item_type is '||item_type);
27: asn_debug.put_line('item_key is '||item_key);
28: asn_debug.put_line('actid is '||actid);
29: asn_debug.put_line('funcmode is '||funcmode);
30: END IF;
31:
32:

Line 29: asn_debug.put_line('funcmode is '||funcmode);

25: asn_debug.put_line('Entering Update_Txn_Hist_Success_WF');
26: asn_debug.put_line('item_type is '||item_type);
27: asn_debug.put_line('item_key is '||item_key);
28: asn_debug.put_line('actid is '||actid);
29: asn_debug.put_line('funcmode is '||funcmode);
30: END IF;
31:
32:
33: IF ( funcmode = 'RUN' ) THEN

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

37: 'ST',
38: l_return_status
39: );
40:
41: IF (g_asn_debug = 'Y') THEN
42: asn_debug.put_line('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status);
43: END IF;
44:
45: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

Line 42: asn_debug.put_line('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status);

38: l_return_status
39: );
40:
41: IF (g_asn_debug = 'Y') THEN
42: asn_debug.put_line('Update_Txn_Hist_Success_WF.l_return_status is '||l_return_status);
43: END IF;
44:
45: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
46: raise update_history;

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

45: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
46: raise update_history;
47: ELSE
48: resultout := 'COMPLETE:SUCCESS';
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line('Update_Txn_Hist_Success_WF.resultout is '||resultout);
51: END IF;
52: RETURN;
53: END IF;

Line 50: asn_debug.put_line('Update_Txn_Hist_Success_WF.resultout is '||resultout);

46: raise update_history;
47: ELSE
48: resultout := 'COMPLETE:SUCCESS';
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line('Update_Txn_Hist_Success_WF.resultout is '||resultout);
51: END IF;
52: RETURN;
53: END IF;
54: END IF;

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

52: RETURN;
53: END IF;
54: END IF;
55:
56: IF (g_asn_debug = 'Y') THEN
57: asn_debug.put_line('Exiting Update_Txn_Hist_Success_WF');
58: END IF;
59:
60: EXCEPTION

Line 57: asn_debug.put_line('Exiting Update_Txn_Hist_Success_WF');

53: END IF;
54: END IF;
55:
56: IF (g_asn_debug = 'Y') THEN
57: asn_debug.put_line('Exiting Update_Txn_Hist_Success_WF');
58: END IF;
59:
60: EXCEPTION
61: WHEN update_history THEN

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

67: and event_key = Item_key
68: and transaction_status = 'IP';
69:
70: resultout := 'COMPLETE:FAILURE';
71: IF (g_asn_debug = 'Y') THEN
72: asn_debug.put_line('update_history exception has occured.');
73: END IF;
74: raise;
75: WHEN OTHERS THEN

Line 72: asn_debug.put_line('update_history exception has occured.');

68: and transaction_status = 'IP';
69:
70: resultout := 'COMPLETE:FAILURE';
71: IF (g_asn_debug = 'Y') THEN
72: asn_debug.put_line('update_history exception has occured.');
73: END IF;
74: raise;
75: WHEN OTHERS THEN
76:

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

81: and event_key = Item_key
82: and transaction_status = 'IP';
83:
84: resultout := 'COMPLETE:FAILURE';
85: IF (g_asn_debug = 'Y') THEN
86: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
87: END IF;
88: raise;
89: END Update_Txn_Hist_Success_WF;

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

82: and transaction_status = 'IP';
83:
84: resultout := 'COMPLETE:FAILURE';
85: IF (g_asn_debug = 'Y') THEN
86: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
87: END IF;
88: raise;
89: END Update_Txn_Hist_Success_WF;
90:

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

110:
111:
112: BEGIN
113:
114: IF (g_asn_debug = 'Y') THEN
115: asn_debug.put_line('Entering Update_Txn_History');
116: asn_debug.put_line('p_transaction_status is '||p_transaction_status);
117: END IF;
118:

Line 115: asn_debug.put_line('Entering Update_Txn_History');

111:
112: BEGIN
113:
114: IF (g_asn_debug = 'Y') THEN
115: asn_debug.put_line('Entering Update_Txn_History');
116: asn_debug.put_line('p_transaction_status is '||p_transaction_status);
117: END IF;
118:
119:

Line 116: asn_debug.put_line('p_transaction_status is '||p_transaction_status);

112: BEGIN
113:
114: IF (g_asn_debug = 'Y') THEN
115: asn_debug.put_line('Entering Update_Txn_History');
116: asn_debug.put_line('p_transaction_status is '||p_transaction_status);
117: END IF;
118:
119:
120: IF ( p_item_type = 'PORCPTO' ) THEN

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

134: l_txns_history_rec,
135: x_return_status );
136:
137:
138: IF (g_asn_debug = 'Y') THEN
139: asn_debug.put_line('Update_Txn_History.x_return_status is '||x_return_status);
140: END IF;
141:
142:

Line 139: asn_debug.put_line('Update_Txn_History.x_return_status is '||x_return_status);

135: x_return_status );
136:
137:
138: IF (g_asn_debug = 'Y') THEN
139: asn_debug.put_line('Update_Txn_History.x_return_status is '||x_return_status);
140: END IF;
141:
142:
143: l_txns_history_rec.transaction_status := p_transaction_status;

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

150: l_xml_document_id,
151: l_txn_id,
152: x_return_status );
153:
154: IF (g_asn_debug = 'Y') THEN
155: asn_debug.put_line('Update_Txn_History.x_return_status is '||x_return_status);
156: END IF;
157:
158: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

Line 155: asn_debug.put_line('Update_Txn_History.x_return_status is '||x_return_status);

151: l_txn_id,
152: x_return_status );
153:
154: IF (g_asn_debug = 'Y') THEN
155: asn_debug.put_line('Update_Txn_History.x_return_status is '||x_return_status);
156: END IF;
157:
158: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
159: raise update_history;

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

160: ELSE
161: COMMIT;
162: END IF;
163:
164: IF (g_asn_debug = 'Y') THEN
165: asn_debug.put_line('Exiting Update_Txn_History');
166: END IF;
167:
168: EXCEPTION

Line 165: asn_debug.put_line('Exiting Update_Txn_History');

161: COMMIT;
162: END IF;
163:
164: IF (g_asn_debug = 'Y') THEN
165: asn_debug.put_line('Exiting Update_Txn_History');
166: END IF;
167:
168: EXCEPTION
169: WHEN update_history THEN

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

175: and event_key = p_item_key
176: and transaction_status = 'IP';
177:
178: x_return_status := rcv_error_pkg.g_ret_sts_error;
179: IF (g_asn_debug = 'Y') THEN
180: asn_debug.put_line('update_history exception has occured.');
181: END IF;
182: ROLLBACK;
183: WHEN OTHERS THEN

Line 180: asn_debug.put_line('update_history exception has occured.');

176: and transaction_status = 'IP';
177:
178: x_return_status := rcv_error_pkg.g_ret_sts_error;
179: IF (g_asn_debug = 'Y') THEN
180: asn_debug.put_line('update_history exception has occured.');
181: END IF;
182: ROLLBACK;
183: WHEN OTHERS THEN
184:

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

189: and event_key = p_item_key
190: and transaction_status = 'IP';
191:
192: x_return_status := rcv_error_pkg.g_ret_sts_error;
193: IF (g_asn_debug = 'Y') THEN
194: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
195: END IF;
196: ROLLBACK;
197: END Update_Txn_History;

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

190: and transaction_status = 'IP';
191:
192: x_return_status := rcv_error_pkg.g_ret_sts_error;
193: IF (g_asn_debug = 'Y') THEN
194: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
195: END IF;
196: ROLLBACK;
197: END Update_Txn_History;
198:

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

222:
223: BEGIN
224:
225:
226: IF (g_asn_debug = 'Y') THEN
227: asn_debug.put_line('Entering Send_Receipt_Confirmation');
228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);

Line 227: asn_debug.put_line('Entering Send_Receipt_Confirmation');

223: BEGIN
224:
225:
226: IF (g_asn_debug = 'Y') THEN
227: asn_debug.put_line('Entering Send_Receipt_Confirmation');
228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);

Line 228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);

224:
225:
226: IF (g_asn_debug = 'Y') THEN
227: asn_debug.put_line('Entering Send_Receipt_Confirmation');
228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));

Line 229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);

225:
226: IF (g_asn_debug = 'Y') THEN
227: asn_debug.put_line('Entering Send_Receipt_Confirmation');
228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));
233: asn_debug.put_line('Client Code is '|| P_client_code);

Line 230: asn_debug.put_line('Action Type is ' || P_Action_Type);

226: IF (g_asn_debug = 'Y') THEN
227: asn_debug.put_line('Entering Send_Receipt_Confirmation');
228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));
233: asn_debug.put_line('Client Code is '|| P_client_code);
234: asn_debug.put_line('XML Document ID is '|| to_char(p_xml_document_id));

Line 231: asn_debug.put_line('Dcument Type is ' || p_document_type);

227: asn_debug.put_line('Entering Send_Receipt_Confirmation');
228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));
233: asn_debug.put_line('Client Code is '|| P_client_code);
234: asn_debug.put_line('XML Document ID is '|| to_char(p_xml_document_id));
235: END IF;

Line 232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));

228: asn_debug.put_line('Entity_ID is ' || P_Entity_ID);
229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));
233: asn_debug.put_line('Client Code is '|| P_client_code);
234: asn_debug.put_line('XML Document ID is '|| to_char(p_xml_document_id));
235: END IF;
236:

Line 233: asn_debug.put_line('Client Code is '|| P_client_code);

229: asn_debug.put_line('Entity Type is ' || P_Entity_Type);
230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));
233: asn_debug.put_line('Client Code is '|| P_client_code);
234: asn_debug.put_line('XML Document ID is '|| to_char(p_xml_document_id));
235: END IF;
236:
237: X_Return_Status := rcv_error_pkg.g_ret_sts_success;

Line 234: asn_debug.put_line('XML Document ID is '|| to_char(p_xml_document_id));

230: asn_debug.put_line('Action Type is ' || P_Action_Type);
231: asn_debug.put_line('Dcument Type is ' || p_document_type);
232: asn_debug.put_line('Org ID is ' || to_char(P_Org_ID));
233: asn_debug.put_line('Client Code is '|| P_client_code);
234: asn_debug.put_line('XML Document ID is '|| to_char(p_xml_document_id));
235: END IF;
236:
237: X_Return_Status := rcv_error_pkg.g_ret_sts_success;
238: l_xml_document_id := P_xml_document_id;

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

285:
286: l_curr_txn_hist_record.Trading_Partner_ID := l_party_id;
287:
288:
289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);
291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));

Line 290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);

286: l_curr_txn_hist_record.Trading_Partner_ID := l_party_id;
287:
288:
289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);
291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);

Line 291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);

287:
288:
289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);
291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);
295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);

Line 292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);

288:
289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);
291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);
295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);
296: asn_debug.put_line('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number));

Line 293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));

289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);
291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);
295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);
296: asn_debug.put_line('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number));
297: END IF;

Line 294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);

290: asn_debug.put_line('Item Type is ' || l_curr_txn_hist_record.Item_Type);
291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);
295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);
296: asn_debug.put_line('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number));
297: END IF;
298:

Line 295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);

291: asn_debug.put_line('Event Name is ' || l_curr_txn_hist_record.Event_Name);
292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);
295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);
296: asn_debug.put_line('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number));
297: END IF;
298:
299:

Line 296: asn_debug.put_line('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number));

292: asn_debug.put_line('Event Key is ' || l_curr_txn_hist_record.Event_Key);
293: asn_debug.put_line('Trading Partner ID is ' || To_Char(l_curr_txn_hist_record.Trading_Partner_ID));
294: asn_debug.put_line('Document Type is ' || l_curr_txn_hist_record.Document_Type);
295: asn_debug.put_line('Document Direction is ' || l_curr_txn_hist_record.Document_Direction);
296: asn_debug.put_line('Document Number is ' || to_char(l_curr_txn_hist_record.Document_Number));
297: END IF;
298:
299:
300: /* Raise event will insert the record into the transaction history table

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

305: l_xml_document_id,
306: l_Return_Status );
307:
308:
309: IF (g_asn_debug = 'Y') THEN
310: asn_debug.put_line('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status);
311: asn_debug.put_line('Exiting Send_Receipt_Confirmation');
312: END IF;
313:

Line 310: asn_debug.put_line('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status);

306: l_Return_Status );
307:
308:
309: IF (g_asn_debug = 'Y') THEN
310: asn_debug.put_line('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status);
311: asn_debug.put_line('Exiting Send_Receipt_Confirmation');
312: END IF;
313:
314: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN

Line 311: asn_debug.put_line('Exiting Send_Receipt_Confirmation');

307:
308:
309: IF (g_asn_debug = 'Y') THEN
310: asn_debug.put_line('Send_Receipt_Confirmation.l_Return_Status is '||l_Return_Status);
311: asn_debug.put_line('Exiting Send_Receipt_Confirmation');
312: END IF;
313:
314: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) THEN
315: RAISE raise_event_error;

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

318: EXCEPTION
319:
320: WHEN invalid_entity_type THEN
321: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
322: IF (g_asn_debug = 'Y') THEN
323: asn_debug.put_line('invalid_entity_type exception has occured');
324: END IF;
325:
326: WHEN invalid_action_type THEN

Line 323: asn_debug.put_line('invalid_entity_type exception has occured');

319:
320: WHEN invalid_entity_type THEN
321: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
322: IF (g_asn_debug = 'Y') THEN
323: asn_debug.put_line('invalid_entity_type exception has occured');
324: END IF;
325:
326: WHEN invalid_action_type THEN
327: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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

324: END IF;
325:
326: WHEN invalid_action_type THEN
327: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
328: IF (g_asn_debug = 'Y') THEN
329: asn_debug.put_line('invalid_action_type exception has occured');
330: END IF;
331:
332: WHEN invalid_doc_type THEN

Line 329: asn_debug.put_line('invalid_action_type exception has occured');

325:
326: WHEN invalid_action_type THEN
327: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
328: IF (g_asn_debug = 'Y') THEN
329: asn_debug.put_line('invalid_action_type exception has occured');
330: END IF;
331:
332: WHEN invalid_doc_type THEN
333: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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

330: END IF;
331:
332: WHEN invalid_doc_type THEN
333: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('invalid_doc_type exception has occured');
336: END IF;
337:
338: WHEN raise_event_error THEN

Line 335: asn_debug.put_line('invalid_doc_type exception has occured');

331:
332: WHEN invalid_doc_type THEN
333: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('invalid_doc_type exception has occured');
336: END IF;
337:
338: WHEN raise_event_error THEN
339: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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

336: END IF;
337:
338: WHEN raise_event_error THEN
339: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
340: IF (g_asn_debug = 'Y') THEN
341: asn_debug.put_line('raise_event_error exception has occured, error message is '|| SQLERRM);
342: END IF;
343:
344: WHEN OTHERS THEN

Line 341: asn_debug.put_line('raise_event_error exception has occured, error message is '|| SQLERRM);

337:
338: WHEN raise_event_error THEN
339: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
340: IF (g_asn_debug = 'Y') THEN
341: asn_debug.put_line('raise_event_error exception has occured, error message is '|| SQLERRM);
342: END IF;
343:
344: WHEN OTHERS THEN
345: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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

342: END IF;
343:
344: WHEN OTHERS THEN
345: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
346: IF (g_asn_debug = 'Y') THEN
347: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
348: END IF;
349: END Send_Receipt_Confirmation;
350:

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

343:
344: WHEN OTHERS THEN
345: X_Return_Status := rcv_error_pkg.g_ret_sts_error;
346: IF (g_asn_debug = 'Y') THEN
347: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
348: END IF;
349: END Send_Receipt_Confirmation;
350:
351:

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

363: invalid_doc_type EXCEPTION;
364:
365: BEGIN
366:
367: IF (g_asn_debug = 'Y') THEN
368: asn_debug.put_line( 'Entering Send_Document');
369: END IF;
370:
371: IF ( p_document_type = 'RC' ) THEN

Line 368: asn_debug.put_line( 'Entering Send_Document');

364:
365: BEGIN
366:
367: IF (g_asn_debug = 'Y') THEN
368: asn_debug.put_line( 'Entering Send_Document');
369: END IF;
370:
371: IF ( p_document_type = 'RC' ) THEN
372:

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

378: p_client_code,
379: p_xml_document_id,
380: x_return_status);
381:
382: IF (g_asn_debug = 'Y') THEN
383: asn_debug.put_line('Exiting Send_Document');
384: asn_debug.put_line('Send_Document.x_return_status is '|| x_return_status);
385: END IF;
386:

Line 383: asn_debug.put_line('Exiting Send_Document');

379: p_xml_document_id,
380: x_return_status);
381:
382: IF (g_asn_debug = 'Y') THEN
383: asn_debug.put_line('Exiting Send_Document');
384: asn_debug.put_line('Send_Document.x_return_status is '|| x_return_status);
385: END IF;
386:
387: ELSE

Line 384: asn_debug.put_line('Send_Document.x_return_status is '|| x_return_status);

380: x_return_status);
381:
382: IF (g_asn_debug = 'Y') THEN
383: asn_debug.put_line('Exiting Send_Document');
384: asn_debug.put_line('Send_Document.x_return_status is '|| x_return_status);
385: END IF;
386:
387: ELSE
388: raise invalid_doc_type;

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

392:
393: WHEN invalid_doc_type THEN
394: x_return_status := rcv_error_pkg.g_ret_sts_error;
395:
396: IF (g_asn_debug = 'Y') THEN
397: asn_debug.put_line('invalid_doc_type exception has occured.');
398: END IF;
399:
400: WHEN OTHERS THEN

Line 397: asn_debug.put_line('invalid_doc_type exception has occured.');

393: WHEN invalid_doc_type THEN
394: x_return_status := rcv_error_pkg.g_ret_sts_error;
395:
396: IF (g_asn_debug = 'Y') THEN
397: asn_debug.put_line('invalid_doc_type exception has occured.');
398: END IF;
399:
400: WHEN OTHERS THEN
401: x_return_status := rcv_error_pkg.g_ret_sts_error;

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

399:
400: WHEN OTHERS THEN
401: x_return_status := rcv_error_pkg.g_ret_sts_error;
402:
403: IF (g_asn_debug = 'Y') THEN
404: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
405: END IF;
406:
407: END Send_Document;

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

400: WHEN OTHERS THEN
401: x_return_status := rcv_error_pkg.g_ret_sts_error;
402:
403: IF (g_asn_debug = 'Y') THEN
404: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
405: END IF;
406:
407: END Send_Document;
408: