DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_UTIL2 dependencies on RCV_ERROR_PKG

Line 45: IF ( l_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

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;
47: ELSE
48: resultout := 'COMPLETE:SUCCESS';
49: IF (g_asn_debug = 'Y') THEN

Line 145: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

141:
142:
143: l_txns_history_rec.transaction_status := p_transaction_status;
144:
145: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN
146: raise update_history;
147: END IF;
148:
149: RCV_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History (l_txns_history_rec,

Line 158: IF ( x_return_status <> rcv_error_pkg.g_ret_sts_success ) THEN

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;
160: ELSE
161: COMMIT;
162: END IF;

Line 178: x_return_status := rcv_error_pkg.g_ret_sts_error;

174: where event_name = p_item_type
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;

Line 192: x_return_status := rcv_error_pkg.g_ret_sts_error;

188: where event_name = p_item_type
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;

Line 237: X_Return_Status := rcv_error_pkg.g_ret_sts_success;

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;
239:
240: IF ( P_Entity_TYPE <> 'RCPT' ) THEN
241: RAISE invalid_entity_type;

Line 314: IF (l_Return_Status <> rcv_error_pkg.g_ret_sts_success ) 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;
316: END IF;
317:
318: EXCEPTION

Line 321: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

317:
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:

Line 327: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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;
328: IF (g_asn_debug = 'Y') THEN
329: asn_debug.put_line('invalid_action_type exception has occured');
330: END IF;
331:

Line 333: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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;
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('invalid_doc_type exception has occured');
336: END IF;
337:

Line 339: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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;
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:

Line 345: X_Return_Status := rcv_error_pkg.g_ret_sts_error;

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;
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;

Line 394: x_return_status := rcv_error_pkg.g_ret_sts_error;

390:
391: EXCEPTION
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;

Line 401: x_return_status := rcv_error_pkg.g_ret_sts_error;

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;
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;