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

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25: l_charge_upload_status Varchar2(50);
26: l_ib_update_status Varchar2(50);
27: l_spare_update_status Varchar2(50);
28: Begin
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30: select charge_upload_status,ib_update_status,spare_update_status
31: into l_charge_upload_status,l_ib_update_status,l_spare_update_status
32: from csf_debrief_lines
33: where debrief_line_id = p_debrief_line_id

Line 37: x_return_status := FND_API.G_RET_STS_ERROR ;

33: where debrief_line_id = p_debrief_line_id
34: for update nowait;
35: Exception
36: WHEN RECORD_LOCK_EXCEPTION THEN
37: x_return_status := FND_API.G_RET_STS_ERROR ;
38: When OTHERS then
39: x_return_status := FND_API.G_RET_STS_ERROR ;
40: End;
41:

Line 39: x_return_status := FND_API.G_RET_STS_ERROR ;

35: Exception
36: WHEN RECORD_LOCK_EXCEPTION THEN
37: x_return_status := FND_API.G_RET_STS_ERROR ;
38: When OTHERS then
39: x_return_status := FND_API.G_RET_STS_ERROR ;
40: End;
41:
42: PROCEDURE main
43: (

Line 116: l_inv_master_organization_id Number :=fnd_api.g_miss_num;

112: l_mesg Varchar2(2000) ;
113: l_msg_dummy Number ;
114: l_transaction_type_id_csi Number ;
115: l_txn_sub_type_id Number ;
116: l_inv_master_organization_id Number :=fnd_api.g_miss_num;
117: l_customer_account_id Number ;
118: l_party_id Number ;
119: l_install_site_use_id Number ;
120: l_ship_site_use_id Number ;

Line 137: l_instance_status_id Number :=9.99E125 ;--fnd_api.g_miss_num --added for bug3192060

133: l_closed_flag Varchar2(1) ;
134: l_cleanup_done Boolean := FALSE;
135: l_position Number;
136: l_instance_status Varchar(30) :=NULL; --added for bug 3192060
137: l_instance_status_id Number :=9.99E125 ;--fnd_api.g_miss_num --added for bug3192060
138: l_header_id Number; -- added for 3264030
139: l_record_lock Varchar2(1) := 'N'; -- added for bug 3142094
140: l_conc_result Boolean;
141: e_no_header_id Exception;

Line 501: P_Init_Msg_List => FND_API.G_FALSE,

497: ------------------------------------------------------------------
498: If not l_cleanup_done Then
499: Cs_service_billing_engine_pvt.Delete_In_Progress_Charges(
500: P_Api_Version_Number => 1.0,
501: P_Init_Msg_List => FND_API.G_FALSE,
502: P_Commit => FND_API.G_FALSE,
503: p_incident_id => l_incident_id,
504: p_debrief_header_id => l_debrief_header_id, -- added for bug 3549864
505: x_return_status => l_return_status,

Line 502: P_Commit => FND_API.G_FALSE,

498: If not l_cleanup_done Then
499: Cs_service_billing_engine_pvt.Delete_In_Progress_Charges(
500: P_Api_Version_Number => 1.0,
501: P_Init_Msg_List => FND_API.G_FALSE,
502: P_Commit => FND_API.G_FALSE,
503: p_incident_id => l_incident_id,
504: p_debrief_header_id => l_debrief_header_id, -- added for bug 3549864
505: x_return_status => l_return_status,
506: x_msg_count => l_msg_count,

Line 572: If l_return_status = FND_API.G_RET_STS_ERROR THEN

568: l_record_lock := 'N';
569:
570: Record_Lock(l_debrief_line_id, l_return_status) ;
571:
572: If l_return_status = FND_API.G_RET_STS_ERROR THEN
573: rollback to before_fetch;
574: l_processed_flag := 'COMPLETED W/ERRORS';
575: l_record_lock := 'Y';
576: exit ;

Line 586: l_charges_instance_id := fnd_api.g_miss_num;

582: l_charges_interface_status := null;
583: l_ib_interface_status := null;
584: l_inv_interface_status := null;
585: l_msg_data := null;
586: l_charges_instance_id := fnd_api.g_miss_num;
587: l_organization_id := nvl(l_receiving_inventory_org_id, nvl(l_issuing_inventory_org_id,cs_std.get_item_valdn_orgzn_id));
588:
589:
590: --we use c_trans cursor only when we have item number

Line 597: and l_inventory_item_id <> fnd_api.g_miss_num) Then

593: fetch c_cost_charge_flags into l_create_cost_flag, l_create_charge_flag;
594: close c_cost_charge_flags;
595:
596: if (l_inventory_item_id is not null
597: and l_inventory_item_id <> fnd_api.g_miss_num) Then
598:
599: open c_trans (l_transaction_type_id, l_inventory_item_id, l_organization_id);
600: fetch c_trans into l_line_category_code,
601: l_txn_billing_type_id,

Line 765: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);

761: l_processed_flag := 'COMPLETED W/ERRORS';
762: if l_msg_count > 0 then
763: FOR counter IN REVERSE 1..l_msg_count
764: LOOP
765: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
766: FND_FILE.put_line(FND_FILE.log,l_msg_data);
767: end loop;
768: end if;
769: l_charges_interface_status := 'FAILED';

Line 785: l_charges_interface_status := fnd_api.g_miss_char;

781: if l_charges_interface_status = 'FAILED' then
782: rollback to before_fetch;
783:
784: if l_charges_interface_status <> 'FAILED' then
785: l_charges_interface_status := fnd_api.g_miss_char;
786: end if;
787: csf_debrief_lines_pkg.update_row(
788: p_debrief_line_id => l_debrief_line_id,
789: p_error_text => substr(l_msg_data,1,2000),

Line 870: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);

866: l_processed_flag := 'COMPLETED W/ERRORS';
867: if l_msg_count > 0 then --1
868: FOR counter IN REVERSE 1..l_msg_count
869: LOOP
870: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
871: FND_FILE.put_line(FND_FILE.log,l_msg_data);
872: end loop;
873: end if; --1
874: l_ib_interface_status := 'FAILED';

Line 886: l_charges_interface_status := fnd_api.g_miss_char;

882: if l_ib_interface_status = 'FAILED' or l_charges_interface_status = 'FAILED' then
883: rollback to before_fetch;
884:
885: if l_charges_interface_status <> 'FAILED' then
886: l_charges_interface_status := fnd_api.g_miss_char;
887: end if;
888: if l_ib_interface_status <> 'FAILED' then
889: l_ib_interface_status := fnd_api.g_miss_char;
890: end if;

Line 889: l_ib_interface_status := fnd_api.g_miss_char;

885: if l_charges_interface_status <> 'FAILED' then
886: l_charges_interface_status := fnd_api.g_miss_char;
887: end if;
888: if l_ib_interface_status <> 'FAILED' then
889: l_ib_interface_status := fnd_api.g_miss_char;
890: end if;
891: csf_debrief_lines_pkg.update_row(
892: p_debrief_line_id => l_debrief_line_id,
893: p_error_text => substr(l_msg_data,1,2000),

Line 948: l_return_status := fnd_api.g_ret_sts_success;

944: dbms_output.put_line('p_party_account_id =' ||l_customer_account_id);
945: dbms_output.put_line('p_party_site_id =' ||l_party_site_id);
946: dbms_output.put_line('p_parent_instance_id =' ||l_parent_product_id) ;*/
947:
948: l_return_status := fnd_api.g_ret_sts_success;
949: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG','TRANSACT_MATERIAL','B','C') THEN
950: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
951: csf_debrief_update_pkg.g_account_id := null;
952: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG','TRANSACT_MATERIAL','B',l_return_status);

Line 954: if l_return_status = fnd_api.g_ret_sts_success then

950: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
951: csf_debrief_update_pkg.g_account_id := null;
952: csf_debrief_pub.call_internal_hook('CSF_DEBRIEF_UPDATE_PKG','TRANSACT_MATERIAL','B',l_return_status);
953: end if;
954: if l_return_status = fnd_api.g_ret_sts_success then
955: CSP_TRANSACTIONS_PUB.TRANSACT_MATERIAL(
956: p_api_version => l_api_version,
957: x_return_status => l_RETURN_STATUS,
958: x_msg_count => l_MSG_COUNT,

Line 960: p_init_msg_list => FND_API.G_TRUE,

956: p_api_version => l_api_version,
957: x_return_status => l_RETURN_STATUS,
958: x_msg_count => l_MSG_COUNT,
959: x_msg_data => l_MSG_DATA,
960: p_init_msg_list => FND_API.G_TRUE,
961: p_commit => FND_API.G_FALSE,
962: p_inventory_item_id => l_inventory_item_id,
963: p_organization_id => l_organization_id,
964: p_subinventory_code => l_subinventory_code,

Line 961: p_commit => FND_API.G_FALSE,

957: x_return_status => l_RETURN_STATUS,
958: x_msg_count => l_MSG_COUNT,
959: x_msg_data => l_MSG_DATA,
960: p_init_msg_list => FND_API.G_TRUE,
961: p_commit => FND_API.G_FALSE,
962: p_inventory_item_id => l_inventory_item_id,
963: p_organization_id => l_organization_id,
964: p_subinventory_code => l_subinventory_code,
965: p_locator_id => l_locator_id,

Line 994: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);

990: l_processed_flag := 'COMPLETED W/ERRORS';
991: if l_msg_count > 0 then
992: FOR counter IN REVERSE 1..l_msg_count
993: LOOP
994: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
995: l_position := instr(l_msg_data, 'ERROR_EXPLANATION');
996: l_msg_data := substr(l_msg_data, l_position);
997: FND_FILE.put_line(FND_FILE.log,l_msg_data);
998: end loop;

Line 1059: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);

1055: retcode := 1;
1056: l_processed_flag := 'COMPLETED W/ERRORS';
1057: if l_msg_count > 0 then
1058: FOR counter IN REVERSE 1..l_msg_count LOOP
1059: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1060: l_position := instr(l_msg_data, 'ERROR_EXPLANATION');
1061: l_msg_data := substr(l_msg_data, l_position);
1062: FND_FILE.put_line(FND_FILE.log,l_msg_data);
1063: end loop;

Line 1075: l_charges_interface_status := fnd_api.g_miss_char;

1071: if l_ib_interface_status = 'FAILED' or l_charges_interface_status = 'FAILED' or
1072: l_inv_interface_status = 'FAILED' then
1073: rollback;
1074: if l_charges_interface_status <> 'FAILED' then
1075: l_charges_interface_status := fnd_api.g_miss_char;
1076: end if;
1077: if l_ib_interface_status <> 'FAILED' then
1078: l_ib_interface_status := fnd_api.g_miss_char;
1079: end if;

Line 1078: l_ib_interface_status := fnd_api.g_miss_char;

1074: if l_charges_interface_status <> 'FAILED' then
1075: l_charges_interface_status := fnd_api.g_miss_char;
1076: end if;
1077: if l_ib_interface_status <> 'FAILED' then
1078: l_ib_interface_status := fnd_api.g_miss_char;
1079: end if;
1080: if l_inv_interface_status <> 'FAILED' then
1081: l_inv_interface_status := fnd_api.g_miss_char;
1082: end if;

Line 1081: l_inv_interface_status := fnd_api.g_miss_char;

1077: if l_ib_interface_status <> 'FAILED' then
1078: l_ib_interface_status := fnd_api.g_miss_char;
1079: end if;
1080: if l_inv_interface_status <> 'FAILED' then
1081: l_inv_interface_status := fnd_api.g_miss_char;
1082: end if;
1083: csf_debrief_lines_pkg.update_row(
1084: p_debrief_line_id => l_debrief_line_id,
1085: p_error_text => substr(l_msg_data,1,2000),

Line 1154: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);

1150: retcode := 1;
1151:
1152: if l_msg_count > 0 then
1153: FOR counter IN REVERSE 1..l_msg_count LOOP
1154: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1155: FND_FILE.put_line(FND_FILE.log,l_msg_data);
1156: end loop;
1157: end if;
1158: else

Line 1178: If l_return_status = FND_API.G_RET_STS_ERROR and l_record_lock = 'Y' THEN

1174: set processed_flag = nvl(l_processed_flag,'UNPROCESSED')
1175: where debrief_header_id = l_debrief_header_id;
1176: commit;
1177:
1178: If l_return_status = FND_API.G_RET_STS_ERROR and l_record_lock = 'Y' THEN
1179: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_CONC_PROG_RECLOCK');
1180: FND_MESSAGE.Set_Token('DEBRIEF_NUMBER',l_debrief_number);
1181: FND_MSG_PUB.ADD;
1182: l_msg_data := FND_MSG_PUB.Get(p_msg_index => fnd_msg_pub.G_LAST,

Line 1183: p_encoded => FND_API.G_FALSE);

1179: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_CONC_PROG_RECLOCK');
1180: FND_MESSAGE.Set_Token('DEBRIEF_NUMBER',l_debrief_number);
1181: FND_MSG_PUB.ADD;
1182: l_msg_data := FND_MSG_PUB.Get(p_msg_index => fnd_msg_pub.G_LAST,
1183: p_encoded => FND_API.G_FALSE);
1184: fnd_file.put_line(fnd_file.log, l_msg_data);
1185: l_conc_result := fnd_concurrent.set_completion_status('WARNING','Warning');
1186: exit;
1187: end if;

Line 1202: fnd_msg_pub.get(1,FND_API.G_FALSE,l_msg_data,l1);

1198: exception
1199: when e_no_header_id then
1200: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER_ID');
1201: fnd_msg_pub.add;
1202: fnd_msg_pub.get(1,FND_API.G_FALSE,l_msg_data,l1);
1203: FND_FILE.put_line(FND_FILE.log,l_msg_data);
1204: retcode := 2;
1205: errbuf := l_msg_data;
1206:

Line 1271: fnd_api.g_false

1267: inv_reservation_pub.relieve_reservation
1268: (
1269: p_api_version_number => 1.0
1270: ,p_init_msg_lst =>
1271: fnd_api.g_false
1272: ,x_return_status =>
1273: x_return_status
1274: ,x_msg_count =>
1275: x_msg_count

Line 1283: fnd_api.g_true

1279: l_reservation_rec
1280: ,p_primary_relieved_quantity =>
1281: l_relieved_quantity
1282: ,p_relieve_all =>
1283: fnd_api.g_true
1284: ,p_original_serial_number =>
1285: l_serial_number
1286: ,p_validation_flag =>
1287: fnd_api.g_true

Line 1287: fnd_api.g_true

1283: fnd_api.g_true
1284: ,p_original_serial_number =>
1285: l_serial_number
1286: ,p_validation_flag =>
1287: fnd_api.g_true
1288: ,x_primary_relieved_quantity =>
1289: l_relieved_quantity
1290: ,x_primary_remain_quantity =>
1291: l_remaining_quantity

Line 1293: If x_return_status <> FND_API.G_RET_STS_SUCCESS then

1289: l_relieved_quantity
1290: ,x_primary_remain_quantity =>
1291: l_remaining_quantity
1292: );
1293: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
1294: exit;
1295: end if;
1296: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1297: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_detail_id);

Line 1296: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1292: );
1293: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
1294: exit;
1295: end if;
1296: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1297: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_detail_id);
1298: END IF;
1299: END LOOP;
1300: CLOSE reservations;

Line 1388: x_return_status := FND_API.G_RET_STS_SUCCESS;

1384: and cdh.processed_flag in ('PENDING','COMPLETED W/ERRORS')
1385: and cr.incident_id = p_incident_id;
1386:
1387: BEGIN
1388: x_return_status := FND_API.G_RET_STS_SUCCESS;
1389: for cr in get_debrief_status loop
1390: l_debrief_status_tbl(get_debrief_status%rowcount) := cr;
1391: if p_validation_level = 0 and get_debrief_status%rowcount = 1 then
1392: exit;

Line 1397: x_return_status := fnd_api.g_ret_sts_error;

1393: end if;
1394: end loop;
1395: if l_debrief_status_tbl.count > 0 then
1396: x_debrief_status := l_debrief_status_tbl;
1397: x_return_status := fnd_api.g_ret_sts_error;
1398: end if;
1399: exception when others then
1400: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1401: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 1403: x_return_status := fnd_api.g_ret_sts_unexp_error;

1399: exception when others then
1400: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1401: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1402: fnd_msg_pub.add;
1403: x_return_status := fnd_api.g_ret_sts_unexp_error;
1404: END DEBRIEF_STATUS_CHECK ;
1405:
1406: End Csf_Debrief_Update_pkg;
1407: