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.CSE_PO_RECEIPT_INTO_PROJECT dependencies on FND_API

Line 46: IF (nvl(l_Rcv_Transaction_Id,fnd_api.g_miss_num) = fnd_api.g_miss_num) THEN

42: debug(' msg.creation_date : '||p_msg_header.creation_date);
43:
44: xnp_xml_utils.decode(p_msg_text, 'RCV_TRANSACTION_ID', l_rcv_transaction_id);
45:
46: IF (nvl(l_Rcv_Transaction_Id,fnd_api.g_miss_num) = fnd_api.g_miss_num) THEN
47: RAISE fnd_api.g_exc_error;
48: END IF;
49:
50: x_rcv_attributes_rec.rcv_transaction_id := l_rcv_transaction_id;

Line 47: RAISE fnd_api.g_exc_error;

43:
44: xnp_xml_utils.decode(p_msg_text, 'RCV_TRANSACTION_ID', l_rcv_transaction_id);
45:
46: IF (nvl(l_Rcv_Transaction_Id,fnd_api.g_miss_num) = fnd_api.g_miss_num) THEN
47: RAISE fnd_api.g_exc_error;
48: END IF;
49:
50: x_rcv_attributes_rec.rcv_transaction_id := l_rcv_transaction_id;
51: x_rcv_attributes_rec.message_Id := p_msg_header.message_id;

Line 56: WHEN fnd_api.g_exc_error THEN

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

Line 60: x_return_status := fnd_api.g_ret_sts_error;

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:
64: PROCEDURE cleanup_transaction_temps(

Line 93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;

89: l_rcv_transaction_id NUMBER;
90: l_instance_rec csi_datastructures_pub.Instance_Rec;
91: l_instance_query_rec csi_datastructures_pub.Instance_Query_Rec;
92: l_api_version NUMBER DEFAULT 1.0;
93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;
94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;
95: l_active_instance_only varchar2(1) DEFAULT FND_API.G_FALSE;
96: l_resolve_id_columns varchar2(1) DEFAULT FND_API.G_FALSE;
97: l_time_stamp varchar2(50);

Line 94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;

90: l_instance_rec csi_datastructures_pub.Instance_Rec;
91: l_instance_query_rec csi_datastructures_pub.Instance_Query_Rec;
92: l_api_version NUMBER DEFAULT 1.0;
93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;
94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;
95: l_active_instance_only varchar2(1) DEFAULT FND_API.G_FALSE;
96: l_resolve_id_columns varchar2(1) DEFAULT FND_API.G_FALSE;
97: l_time_stamp varchar2(50);
98: l_object_version_number NUMBER := 1;

Line 95: l_active_instance_only varchar2(1) DEFAULT FND_API.G_FALSE;

91: l_instance_query_rec csi_datastructures_pub.Instance_Query_Rec;
92: l_api_version NUMBER DEFAULT 1.0;
93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;
94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;
95: l_active_instance_only varchar2(1) DEFAULT FND_API.G_FALSE;
96: l_resolve_id_columns varchar2(1) DEFAULT FND_API.G_FALSE;
97: l_time_stamp varchar2(50);
98: l_object_version_number NUMBER := 1;
99: l_sysdate DATE := SYSDATE;

Line 96: l_resolve_id_columns varchar2(1) DEFAULT FND_API.G_FALSE;

92: l_api_version NUMBER DEFAULT 1.0;
93: l_commit varchar2(1) DEFAULT FND_API.G_FALSE;
94: l_init_msg_list varchar2(1) DEFAULT FND_API.G_TRUE;
95: l_active_instance_only varchar2(1) DEFAULT FND_API.G_FALSE;
96: l_resolve_id_columns varchar2(1) DEFAULT FND_API.G_FALSE;
97: l_time_stamp varchar2(50);
98: l_object_version_number NUMBER := 1;
99: l_sysdate DATE := SYSDATE;
100: l_instance_header_tbl_out csi_datastructures_pub.instance_header_tbl;

Line 107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

103: l_msg_count NUMBER;
104: l_msg_data varchar2(2000);
105: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
106: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
107: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
108: l_Is_Item_Serialized varchar2(2);
109: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
110: l_party_tbl csi_datastructures_pub.party_tbl;
111: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 170: RAISE fnd_api.g_exc_error;

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
174: fnd_message.set_name('CSE','CSE_RCV_DETAILS_NOT_FOUND');

Line 176: RAISE fnd_api.g_exc_error;

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
180: l_is_item_serialized :='N';

Line 231: RAISE fnd_api.g_exc_error;

227: x_return_status => l_return_status,
228: x_error_message => l_error_message);
229:
230: IF NOT l_return_status = g_ret_sts_success THEN
231: RAISE fnd_api.g_exc_error;
232: END IF;
233:
234: l_instance_query_rec := cse_util_pkg.init_instance_query_rec;
235:

Line 269: RAISE fnd_api.g_exc_error;

265: x_msg_count => l_msg_count,
266: x_msg_data => l_msg_data );
267:
268: IF NOT l_return_status = g_ret_sts_success THEN
269: RAISE fnd_api.g_exc_error;
270: END IF;
271:
272: debug(' l_instance_header_tbl_out.count : '||l_instance_header_tbl_out.count);
273:

Line 330: RAISE fnd_api.g_exc_error;

326: x_msg_count => l_msg_count,
327: x_msg_data => l_msg_data );
328:
329: IF NOT l_return_status = g_ret_sts_success THEN
330: RAISE fnd_api.g_exc_error;
331: END IF;
332:
333: debug(' instance_id : '||l_instance_rec.instance_id);
334:

Line 348: RAISE fnd_api.g_exc_error;

344: x_return_status => l_return_status,
345: x_error_message => l_error_message);
346:
347: IF NOT l_return_status = g_ret_sts_success THEN
348: RAISE fnd_api.g_exc_error;
349: END IF;
350:
351: debug(' dest_instance_id : '||l_instance_rec.instance_id);
352:

Line 389: RAISE fnd_api.g_exc_error;

385: x_msg_count => l_msg_count,
386: x_msg_data => l_msg_data );
387:
388: IF NOT l_return_status = g_ret_sts_success THEN
389: RAISE fnd_api.g_exc_error;
390: END IF;
391: x_rcv_txn_tbl(i).CSI_Transaction_Id := l_txn_rec.Transaction_Id;
392: END IF;
393:

Line 440: RAISE fnd_api.g_exc_error;

436: x_msg_count => l_msg_count,
437: x_msg_data => l_msg_data );
438:
439: IF NOT l_return_status = g_ret_sts_success THEN
440: RAISE fnd_api.g_exc_error;
441: END IF;
442:
443: x_rcv_txn_tbl(i).csi_transaction_id := l_txn_rec.transaction_id;
444:

Line 500: RAISE fnd_api.g_exc_error;

496: x_msg_count => l_msg_count,
497: x_msg_data => l_msg_data );
498:
499: IF NOT l_return_status = g_ret_sts_success THEN
500: RAISE fnd_api.g_exc_error;
501: END IF;
502:
503: debug(' instance_id : '||l_instance_rec.instance_id);
504:

Line 528: WHEN fnd_api.g_exc_error THEN

524: debug('update_csi_data successful. rcv_transaction_id : '||p_rcv_attributes_rec.rcv_transaction_id);
525: commit;
526:
527: EXCEPTION
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');

Line 707: WHEN fnd_api.g_exc_error THEN

703:
704: x_rcv_txn_tbl := l_rcv_txn_tbl;
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:

Line 708: x_return_status := fnd_api.g_ret_sts_error;

704: x_rcv_txn_tbl := l_rcv_txn_tbl;
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(

Line 719: x_return_status := fnd_api.g_ret_sts_success;

715: IS
716: l_sql_stmt varchar2(540);
717: BEGIN
718:
719: x_return_status := fnd_api.g_ret_sts_success;
720:
721: l_sql_stmt := 'UPDATE rcv_receiving_sub_ledger '||
722: 'SET pa_addition_flag = ''Y'''||
723: 'WHERE rcv_transaction_id = :rcv_txn_id ';

Line 737: WHEN fnd_api.g_exc_error THEN

733: WHERE transaction_id = p_rcv_transaction_id;
734: END;
735:
736: EXCEPTION
737: WHEN fnd_api.g_exc_error THEN
738: x_return_status := fnd_api.g_ret_sts_success;
739: END knock_the_commitment;
740:
741: PROCEDURE interface_nl_to_pa(

Line 738: x_return_status := fnd_api.g_ret_sts_success;

734: END;
735:
736: EXCEPTION
737: WHEN fnd_api.g_exc_error THEN
738: x_return_status := fnd_api.g_ret_sts_success;
739: END knock_the_commitment;
740:
741: PROCEDURE interface_nl_to_pa(
742: p_rcv_txn_tbl IN cse_datastructures_pub.Rcv_Txn_Tbl_Type,

Line 823: RAISE FND_API.g_Exc_Error;

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:
826: l_user_id := fnd_global.user_id ;
827:

Line 1000: IF l_return_status = fnd_api.g_ret_sts_success THEN

996: p_nl_pa_interface_tbl => l_nl_pa_interface_tbl,
997: x_return_status => l_return_status,
998: x_error_message => l_error_message);
999:
1000: IF l_return_status = fnd_api.g_ret_sts_success THEN
1001: knock_the_commitment(
1002: p_rcv_transaction_id => p_rcv_txn_tbl(1).rcv_transaction_id,
1003: x_return_status => l_return_status);
1004: commit;

Line 1016: WHEN FND_API.G_Exc_Error THEN

1012: debug('interface_nl_to_pa successful. rcv_transaction_id : '||p_rcv_txn_tbl(1).rcv_transaction_id);
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');