53: debug(' rcv_transaction_id : '||l_rcv_transaction_id);
54:
55: EXCEPTION
56: WHEN fnd_api.g_exc_error THEN
57: fnd_message.set_name('CSE','CSE_DECODE_MSG_ERROR');
58: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
59: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
60: x_return_status := fnd_api.g_ret_sts_error;
61: x_error_message := fnd_message.get;
54:
55: EXCEPTION
56: WHEN fnd_api.g_exc_error THEN
57: fnd_message.set_name('CSE','CSE_DECODE_MSG_ERROR');
58: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
59: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
60: x_return_status := fnd_api.g_ret_sts_error;
61: x_error_message := fnd_message.get;
62: END decode_message;
55: EXCEPTION
56: WHEN fnd_api.g_exc_error THEN
57: fnd_message.set_name('CSE','CSE_DECODE_MSG_ERROR');
58: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
59: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
60: x_return_status := fnd_api.g_ret_sts_error;
61: x_error_message := fnd_message.get;
62: END decode_message;
63:
57: fnd_message.set_name('CSE','CSE_DECODE_MSG_ERROR');
58: fnd_message.set_token('MESSAGE_ID',p_msg_header.message_id);
59: fnd_message.set_token('MESSAGE_CODE',p_msg_header.message_code);
60: x_return_status := fnd_api.g_ret_sts_error;
61: x_error_message := fnd_message.get;
62: END decode_message;
63:
64: PROCEDURE cleanup_transaction_temps(
65: p_rcv_transaction_id IN number)
164: x_return_status => l_return_status,
165: x_error_message => l_error_message);
166:
167: IF NOT l_return_status = g_ret_sts_success THEN
168: fnd_message.set_name('CSE','CSE_RCV_VALIDATION_ERROR');
169: fnd_message.set_token('RCV_TRANSACTION_ID',l_Rcv_Transaction_Id);
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:
165: x_error_message => l_error_message);
166:
167: IF NOT l_return_status = g_ret_sts_success THEN
168: fnd_message.set_name('CSE','CSE_RCV_VALIDATION_ERROR');
169: fnd_message.set_token('RCV_TRANSACTION_ID',l_Rcv_Transaction_Id);
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:
173: IF x_rcv_txn_tbl.count = 0 THEN
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:
173: IF x_rcv_txn_tbl.count = 0 THEN
174: fnd_message.set_name('CSE','CSE_RCV_DETAILS_NOT_FOUND');
175: fnd_message.set_token('RCV_TRANSACTION_ID',l_Rcv_Transaction_Id);
176: RAISE fnd_api.g_exc_error;
177: END IF;
178:
171: END IF;
172:
173: IF x_rcv_txn_tbl.count = 0 THEN
174: fnd_message.set_name('CSE','CSE_RCV_DETAILS_NOT_FOUND');
175: fnd_message.set_token('RCV_TRANSACTION_ID',l_Rcv_Transaction_Id);
176: RAISE fnd_api.g_exc_error;
177: END IF;
178:
179: IF x_rcv_txn_tbl(1).serial_number IS NULL THEN
528: WHEN fnd_api.g_exc_error THEN
529: x_return_status := g_ret_sts_error;
530: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
531: WHEN OTHERS THEN
532: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
533: fnd_message.set_token('ERR_MSG', SQLERRM);
534: x_error_message := fnd_message.get;
535: x_return_status := g_ret_sts_unexp_error;
536: END update_csi_data;
529: x_return_status := g_ret_sts_error;
530: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
531: WHEN OTHERS THEN
532: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
533: fnd_message.set_token('ERR_MSG', SQLERRM);
534: x_error_message := fnd_message.get;
535: x_return_status := g_ret_sts_unexp_error;
536: END update_csi_data;
537:
530: x_error_message := nvl(l_error_message, cse_util_pkg.dump_error_stack);
531: WHEN OTHERS THEN
532: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
533: fnd_message.set_token('ERR_MSG', SQLERRM);
534: x_error_message := fnd_message.get;
535: x_return_status := g_ret_sts_unexp_error;
536: END update_csi_data;
537:
538: PROCEDURE get_rcv_transaction_details(
705:
706: EXCEPTION
707: WHEN fnd_api.g_exc_error THEN
708: x_return_status := fnd_api.g_ret_sts_error;
709: x_error_message := fnd_message.get;
710: END get_rcv_transaction_details;
711:
712: PROCEDURE knock_the_commitment(
713: p_rcv_transaction_id IN number,
817:
818: debug('Inside API cse_po_receipt_into_project.interface_nl_to_pa');
819:
820: IF p_rcv_txn_tbl.COUNT = 0 THEN
821: fnd_message.set_name('CSE','CSE_RCV_TXN_TBL_NO_ROWS');
822: fnd_msg_pub.add;
823: RAISE FND_API.g_Exc_Error;
824: END IF;
825:
1013: debug('==============================================================================');
1014:
1015: EXCEPTION
1016: WHEN FND_API.G_Exc_Error THEN
1017: x_error_message := fnd_message.get;
1018: x_return_status := g_ret_sts_error;
1019: WHEN OTHERS THEN
1020: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1021: fnd_message.set_token('ERR_MSG', SQLERRM);
1016: WHEN FND_API.G_Exc_Error THEN
1017: x_error_message := fnd_message.get;
1018: x_return_status := g_ret_sts_error;
1019: WHEN OTHERS THEN
1020: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1021: fnd_message.set_token('ERR_MSG', SQLERRM);
1022: x_error_message := fnd_message.get;
1023: x_return_status := g_ret_sts_unexp_error;
1024: END interface_nl_to_pa;
1017: x_error_message := fnd_message.get;
1018: x_return_status := g_ret_sts_error;
1019: WHEN OTHERS THEN
1020: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1021: fnd_message.set_token('ERR_MSG', SQLERRM);
1022: x_error_message := fnd_message.get;
1023: x_return_status := g_ret_sts_unexp_error;
1024: END interface_nl_to_pa;
1025:
1018: x_return_status := g_ret_sts_error;
1019: WHEN OTHERS THEN
1020: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1021: fnd_message.set_token('ERR_MSG', SQLERRM);
1022: x_error_message := fnd_message.get;
1023: x_return_status := g_ret_sts_unexp_error;
1024: END interface_nl_to_pa;
1025:
1026: END cse_po_receipt_into_project;