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 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35: l_charge_upload_status Varchar2(50);
36: l_ib_update_status Varchar2(50);
37: l_spare_update_status Varchar2(50);
38: Begin
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40: select charge_upload_status,ib_update_status,spare_update_status
41: into l_charge_upload_status,l_ib_update_status,l_spare_update_status
42: from csf_debrief_lines
43: where debrief_line_id = p_debrief_line_id

Line 47: x_return_status := FND_API.G_RET_STS_ERROR ;

43: where debrief_line_id = p_debrief_line_id
44: for update nowait;
45: Exception
46: WHEN RECORD_LOCK_EXCEPTION THEN
47: x_return_status := FND_API.G_RET_STS_ERROR ;
48: When OTHERS then
49: x_return_status := FND_API.G_RET_STS_ERROR ;
50: End;
51:

Line 49: x_return_status := FND_API.G_RET_STS_ERROR ;

45: Exception
46: WHEN RECORD_LOCK_EXCEPTION THEN
47: x_return_status := FND_API.G_RET_STS_ERROR ;
48: When OTHERS then
49: x_return_status := FND_API.G_RET_STS_ERROR ;
50: End;
51:
52: PROCEDURE main
53: (

Line 128: l_inv_master_organization_id Number :=fnd_api.g_miss_num;

124: l_mesg Varchar2(2000) ;
125: l_msg_dummy Number ;
126: l_transaction_type_id_csi Number ;
127: l_txn_sub_type_id Number ;
128: l_inv_master_organization_id Number :=fnd_api.g_miss_num;
129: l_customer_account_id Number ;
130: l_party_id Number ;
131: l_install_site_use_id Number ;
132: l_ship_site_use_id Number ;

Line 636: P_Init_Msg_List => FND_API.G_FALSE,

632: if not l_cleanup_done then
633: log('main','calling delete_in_progress_charges');
634: Cs_service_billing_engine_pvt.Delete_In_Progress_Charges(
635: P_Api_Version_Number => 1.0,
636: P_Init_Msg_List => FND_API.G_FALSE,
637: P_Commit => FND_API.G_FALSE,
638: p_incident_id => l_incident_id,
639: p_debrief_header_id => l_debrief_header_id, -- added for bug 3549864
640: x_return_status => l_return_status,

Line 637: P_Commit => FND_API.G_FALSE,

633: log('main','calling delete_in_progress_charges');
634: Cs_service_billing_engine_pvt.Delete_In_Progress_Charges(
635: P_Api_Version_Number => 1.0,
636: P_Init_Msg_List => FND_API.G_FALSE,
637: P_Commit => FND_API.G_FALSE,
638: p_incident_id => l_incident_id,
639: p_debrief_header_id => l_debrief_header_id, -- added for bug 3549864
640: x_return_status => l_return_status,
641: x_msg_count => l_msg_count,

Line 720: If l_return_status = FND_API.G_RET_STS_ERROR THEN

716: log('main','calling record lock:'||l_debrief_line_id);
717: record_lock(l_debrief_line_id, l_return_status) ;
718: log('main','l_return_status:'||l_return_status);
719:
720: If l_return_status = FND_API.G_RET_STS_ERROR THEN
721: rollback to before_fetch;
722: l_processed_flag := 'COMPLETED W/ERRORS';
723: l_record_lock := 'Y';
724: exit ;

Line 733: l_charges_instance_id := fnd_api.g_miss_num;

729: l_charges_interface_status := null;
730: l_ib_interface_status := null;
731: l_inv_interface_status := null;
732: l_msg_data := null;
733: l_charges_instance_id := fnd_api.g_miss_num;
734: l_organization_id := nvl(l_receiving_inventory_org_id,
735: nvl(l_issuing_inventory_org_id,
736: cs_std.get_item_valdn_orgzn_id));
737: l_subinventory_code := nvl(l_issuing_sub_inventory_code,

Line 815: fnd_api.g_false,

811: l_trans_items(1).shipment_number := l_shipping_number;
812: log('main','calling transact_intorg_transfer');
813: csp_transactions_pub.transact_intorg_transfer(
814: 1.0,
815: fnd_api.g_false,
816: fnd_api.g_false,
817: l_trans_items,
818: l_is_intransit,
819: l_return_status,

Line 816: fnd_api.g_false,

812: log('main','calling transact_intorg_transfer');
813: csp_transactions_pub.transact_intorg_transfer(
814: 1.0,
815: fnd_api.g_false,
816: fnd_api.g_false,
817: l_trans_items,
818: l_is_intransit,
819: l_return_status,
820: l_msg_count,

Line 833: fnd_api.g_false,

829: elsif l_organization_id = l_dest_organization_id then
830: log('main','calling transact_subinv_transfer');
831: csp_transactions_pub.transact_subinv_transfer(
832: 1.0,
833: fnd_api.g_false,
834: fnd_api.g_false,
835: l_trans_items,
836: l_return_status,
837: l_msg_count,

Line 834: fnd_api.g_false,

830: log('main','calling transact_subinv_transfer');
831: csp_transactions_pub.transact_subinv_transfer(
832: 1.0,
833: fnd_api.g_false,
834: fnd_api.g_false,
835: l_trans_items,
836: l_return_status,
837: l_msg_count,
838: l_msg_data);

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

907: end if;
908: --FOR TRAVEL LINES END
909:
910: if (l_inventory_item_id is not null
911: and l_inventory_item_id <> fnd_api.g_miss_num) Then
912:
913: open c_trans (l_transaction_type_id,
914: l_inventory_item_id,
915: l_organization_id);

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

1080: l_processed_flag := 'COMPLETED W/ERRORS';
1081: if l_msg_count > 0 then
1082: FOR counter IN REVERSE 1..l_msg_count
1083: LOOP
1084: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1085: FND_FILE.put_line(FND_FILE.log,l_msg_data);
1086: end loop;
1087: end if;
1088: l_charges_interface_status := 'FAILED';

Line 1100: l_charges_interface_status := fnd_api.g_miss_char;

1096: if l_charges_interface_status = 'FAILED' then
1097: rollback to before_fetch;
1098:
1099: if l_charges_interface_status <> 'FAILED' then
1100: l_charges_interface_status := fnd_api.g_miss_char;
1101: end if;
1102: log('main','calling update_row when failed');
1103: csf_debrief_lines_pkg.update_row(
1104: p_debrief_line_id => l_debrief_line_id,

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

1198: l_processed_flag := 'COMPLETED W/ERRORS';
1199: if l_msg_count > 0 then --1
1200: FOR counter IN REVERSE 1..l_msg_count
1201: LOOP
1202: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1203: fnd_file.put_line(fnd_file.log,l_msg_data);
1204: log('main','error1:'||l_msg_data);
1205: end loop;
1206: end if; --1

Line 1219: l_charges_interface_status := fnd_api.g_miss_char;

1215: or l_charges_interface_status = 'FAILED' then
1216: rollback to before_fetch;
1217:
1218: if l_charges_interface_status <> 'FAILED' then
1219: l_charges_interface_status := fnd_api.g_miss_char;
1220: end if;
1221: if l_ib_interface_status <> 'FAILED' then
1222: l_ib_interface_status := fnd_api.g_miss_char;
1223: end if;

Line 1222: l_ib_interface_status := fnd_api.g_miss_char;

1218: if l_charges_interface_status <> 'FAILED' then
1219: l_charges_interface_status := fnd_api.g_miss_char;
1220: end if;
1221: if l_ib_interface_status <> 'FAILED' then
1222: l_ib_interface_status := fnd_api.g_miss_char;
1223: end if;
1224: log('main','update_row a');
1225: csf_debrief_lines_pkg.update_row(
1226: p_debrief_line_id => l_debrief_line_id,

Line 1269: l_return_status := fnd_api.g_ret_sts_success;

1265: and ( (l_ib_interface_status = 'SUCCEEDED' and l_trackable='Y')
1266: or (l_ib_update_status = 'SUCCEEDED' and l_trackable ='Y')
1267: or l_trackable ='N' or l_trackable is null ) Then
1268:
1269: l_return_status := fnd_api.g_ret_sts_success;
1270: IF jtf_usr_hks.Ok_To_Execute('CSF_DEBRIEF_UPDATE_PKG',
1271: 'TRANSACT_MATERIAL','B','C') THEN
1272: csf_debrief_update_pkg.g_debrief_line_id := l_debrief_line_id;
1273: csf_debrief_update_pkg.g_account_id := null;

Line 1279: if l_return_status = fnd_api.g_ret_sts_success then

1275: 'TRANSACT_MATERIAL','B',
1276: l_return_status);
1277: end if;
1278: log('main','after hook l_return_status:'||l_return_status);
1279: if l_return_status = fnd_api.g_ret_sts_success then
1280: if l_date_type = 'Y' then
1281: l_service_date := sysdate;
1282: end if;
1283:

Line 1304: p_init_msg_list => FND_API.G_TRUE,

1300: p_api_version => l_api_version,
1301: x_return_status => l_RETURN_STATUS,
1302: x_msg_count => l_MSG_COUNT,
1303: x_msg_data => l_MSG_DATA,
1304: p_init_msg_list => FND_API.G_TRUE,
1305: p_commit => FND_API.G_FALSE,
1306: p_inventory_item_id => l_inventory_item_id,
1307: p_organization_id => l_organization_id,
1308: p_subinventory_code => l_subinventory_code,

Line 1305: p_commit => FND_API.G_FALSE,

1301: x_return_status => l_RETURN_STATUS,
1302: x_msg_count => l_MSG_COUNT,
1303: x_msg_data => l_MSG_DATA,
1304: p_init_msg_list => FND_API.G_TRUE,
1305: p_commit => FND_API.G_FALSE,
1306: p_inventory_item_id => l_inventory_item_id,
1307: p_organization_id => l_organization_id,
1308: p_subinventory_code => l_subinventory_code,
1309: p_locator_id => l_locator_id,

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

1349: l_processed_flag := 'COMPLETED W/ERRORS';
1350: if l_msg_count > 0 then
1351: FOR counter IN REVERSE 1..l_msg_count
1352: LOOP
1353: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1354: l_position := instr(l_msg_data, 'ERROR_EXPLANATION');
1355: l_msg_data := substr(l_msg_data, l_position);
1356: fnd_file.put_line(fnd_file.log,l_msg_data);
1357: log('main','error'||l_msg_data);

Line 1397: fnd_api.g_false,

1393: l_trans_items(1).shipment_number := l_shipping_number;
1394: log('main','calling transact_intorg_transfer');
1395: csp_transactions_pub.transact_intorg_transfer(
1396: 1.0,
1397: fnd_api.g_false,
1398: fnd_api.g_false,
1399: l_trans_items,
1400: l_is_intransit,
1401: l_return_status,

Line 1398: fnd_api.g_false,

1394: log('main','calling transact_intorg_transfer');
1395: csp_transactions_pub.transact_intorg_transfer(
1396: 1.0,
1397: fnd_api.g_false,
1398: fnd_api.g_false,
1399: l_trans_items,
1400: l_is_intransit,
1401: l_return_status,
1402: l_msg_count,

Line 1414: fnd_api.g_false,

1410: elsif l_organization_id = l_return_organization_id then
1411: log('main','calling transact_subinv_transfer');
1412: csp_transactions_pub.transact_subinv_transfer(
1413: 1.0,
1414: fnd_api.g_false,
1415: fnd_api.g_false,
1416: l_trans_items,
1417: l_return_status,
1418: l_msg_count,

Line 1415: fnd_api.g_false,

1411: log('main','calling transact_subinv_transfer');
1412: csp_transactions_pub.transact_subinv_transfer(
1413: 1.0,
1414: fnd_api.g_false,
1415: fnd_api.g_false,
1416: l_trans_items,
1417: l_return_status,
1418: l_msg_count,
1419: l_msg_data);

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

1480: retcode := 1;
1481: l_processed_flag := 'COMPLETED W/ERRORS';
1482: if l_msg_count > 0 then
1483: FOR counter IN REVERSE 1..l_msg_count LOOP
1484: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1485: l_position := instr(l_msg_data, 'ERROR_EXPLANATION');
1486: l_msg_data := substr(l_msg_data, l_position);
1487: fnd_file.put_line(fnd_file.log,l_msg_data);
1488: log('main','l_msg_data:'||l_msg_data);

Line 1502: l_charges_interface_status := fnd_api.g_miss_char;

1498: or l_charges_interface_status = 'FAILED'
1499: or l_inv_interface_status = 'FAILED' then
1500: rollback;
1501: if l_charges_interface_status <> 'FAILED' then
1502: l_charges_interface_status := fnd_api.g_miss_char;
1503: end if;
1504: if l_ib_interface_status <> 'FAILED' then
1505: l_ib_interface_status := fnd_api.g_miss_char;
1506: end if;

Line 1505: l_ib_interface_status := fnd_api.g_miss_char;

1501: if l_charges_interface_status <> 'FAILED' then
1502: l_charges_interface_status := fnd_api.g_miss_char;
1503: end if;
1504: if l_ib_interface_status <> 'FAILED' then
1505: l_ib_interface_status := fnd_api.g_miss_char;
1506: end if;
1507: if l_inv_interface_status <> 'FAILED' then
1508: l_inv_interface_status := fnd_api.g_miss_char;
1509: end if;

Line 1508: l_inv_interface_status := fnd_api.g_miss_char;

1504: if l_ib_interface_status <> 'FAILED' then
1505: l_ib_interface_status := fnd_api.g_miss_char;
1506: end if;
1507: if l_inv_interface_status <> 'FAILED' then
1508: l_inv_interface_status := fnd_api.g_miss_char;
1509: end if;
1510: log('main','calling update_row e');
1511: csf_debrief_lines_pkg.update_row(
1512: p_debrief_line_id => l_debrief_line_id,

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

1586: retcode := 1;
1587:
1588: if l_msg_count > 0 then
1589: FOR counter IN REVERSE 1..l_msg_count LOOP
1590: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1591: fnd_file.put_line(fnd_file.log,l_msg_data);
1592: log('main','error2:'||l_msg_data);
1593: end loop;
1594: end if;

Line 1682: , p_validation_level => fnd_api.g_valid_level_none

1678: csf_task_assignments_pub.update_assignment_status
1679: ( p_api_version => 1.0
1680: , p_init_msg_list => null
1681: , p_commit => null
1682: , p_validation_level => fnd_api.g_valid_level_none
1683: , p_task_assignment_id => l_task_assignment_id
1684: , p_object_version_number => l_object_version_number
1685: , p_assignment_status_id => l_debrief_error_status
1686: , p_update_task => 'T'

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

1696: retcode := 1;
1697:
1698: if l_msg_count > 0 then
1699: FOR counter IN REVERSE 1..l_msg_count LOOP
1700: fnd_msg_pub.get(counter,FND_API.G_FALSE,l_msg_data,l1);
1701: fnd_file.put_line(fnd_file.log,l_msg_data);
1702: log('main','error3:'||l_msg_data);
1703: end loop;
1704: end if;

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

1714: where debrief_header_id = l_debrief_header_id;
1715: commit;
1716:
1717: log('main','l_return_status:'||l_return_status||' l_record_lock:'||l_record_lock);
1718: If l_return_status = FND_API.G_RET_STS_ERROR and l_record_lock = 'Y' THEN
1719: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_CONC_PROG_RECLOCK');
1720: FND_MESSAGE.Set_Token('DEBRIEF_NUMBER',l_debrief_number);
1721: FND_MSG_PUB.ADD;
1722: l_msg_data := FND_MSG_PUB.Get(p_msg_index => fnd_msg_pub.G_LAST,

Line 1723: p_encoded => FND_API.G_FALSE);

1719: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_CONC_PROG_RECLOCK');
1720: FND_MESSAGE.Set_Token('DEBRIEF_NUMBER',l_debrief_number);
1721: FND_MSG_PUB.ADD;
1722: l_msg_data := FND_MSG_PUB.Get(p_msg_index => fnd_msg_pub.G_LAST,
1723: p_encoded => FND_API.G_FALSE);
1724: fnd_file.put_line(fnd_file.log, l_msg_data);
1725: l_conc_result := fnd_concurrent.set_completion_status('WARNING','Warning');
1726: exit;
1727: end if;

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

1738: exception
1739: when e_no_header_id then
1740: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER_ID');
1741: fnd_msg_pub.add;
1742: fnd_msg_pub.get(1,FND_API.G_FALSE,l_msg_data,l1);
1743: fnd_file.put_line(fnd_file.log,l_msg_data);
1744: log('main','error4:'||l_msg_data);
1745: retcode := 2;
1746: errbuf := l_msg_data;

Line 1803: l_relieve_all varchar2(1) := fnd_api.g_false;

1799: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1800: l_serial_number inv_reservation_global.serial_number_tbl_type;
1801: l_relieved_quantity NUMBER;
1802: l_relieved_quantity1 NUMBER;
1803: l_relieve_all varchar2(1) := fnd_api.g_false;
1804: l_remaining_quantity NUMBER;
1805: l_req_line_detail_id NUMBER;
1806: l_requirement_header_id number := null;
1807: l_req_header_id number := null;

Line 1842: l_relieve_all := fnd_api.g_true;

1838: 1 debrief line: Item1 - 4qty
1839: In this scenario we should be able to relieve 4 qty. 2 from Res1 and 2 from Res2
1840: */
1841: if l_relieved_quantity is null or l_relieved_quantity > l_max_reservation_qty then
1842: l_relieve_all := fnd_api.g_true;
1843: l_qty_to_relieve := l_max_reservation_qty;
1844: else
1845: l_relieve_all := fnd_api.g_false;
1846: l_qty_to_relieve := l_relieved_quantity;

Line 1845: l_relieve_all := fnd_api.g_false;

1841: if l_relieved_quantity is null or l_relieved_quantity > l_max_reservation_qty then
1842: l_relieve_all := fnd_api.g_true;
1843: l_qty_to_relieve := l_max_reservation_qty;
1844: else
1845: l_relieve_all := fnd_api.g_false;
1846: l_qty_to_relieve := l_relieved_quantity;
1847: end if;
1848: log('relieve_reservations', 'l_qty_to_relieve=' || l_qty_to_relieve);
1849:

Line 1854: fnd_api.g_false

1850: inv_reservation_pub.relieve_reservation
1851: (
1852: p_api_version_number => 1.0
1853: ,p_init_msg_lst =>
1854: fnd_api.g_false
1855: ,x_return_status =>
1856: x_return_status
1857: ,x_msg_count =>
1858: x_msg_count

Line 1870: fnd_api.g_true

1866: l_relieve_all
1867: ,p_original_serial_number =>
1868: l_serial_number
1869: ,p_validation_flag =>
1870: fnd_api.g_true
1871: ,x_primary_relieved_quantity =>
1872: l_relieved_quantity1
1873: ,x_primary_remain_quantity =>
1874: l_remaining_quantity

Line 1880: If x_return_status <> FND_API.G_RET_STS_SUCCESS then

1876:
1877: log('relieve_reservations', 'l_relieved_quantity1=' || l_relieved_quantity1);
1878: log('relieve_reservations', 'l_remaining_quantity=' || l_remaining_quantity);
1879:
1880: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
1881: exit;
1882: end if;
1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: if nvl(l_remaining_quantity, 0) <= 0 then

Line 1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1879:
1880: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
1881: exit;
1882: end if;
1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1884: if nvl(l_remaining_quantity, 0) <= 0 then
1885: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_line_detail_id);
1886: end if;
1887:

Line 2001: x_return_status := FND_API.G_RET_STS_SUCCESS;

1997: and cdh.processed_flag in ('PENDING','COMPLETED W/ERRORS')
1998: and cr.incident_id = p_incident_id;
1999:
2000: BEGIN
2001: x_return_status := FND_API.G_RET_STS_SUCCESS;
2002: for cr in get_debrief_status loop
2003: l_debrief_status_tbl(get_debrief_status%rowcount) := cr;
2004: if p_validation_level = 0 and get_debrief_status%rowcount = 1 then
2005: exit;

Line 2010: x_return_status := fnd_api.g_ret_sts_error;

2006: end if;
2007: end loop;
2008: if l_debrief_status_tbl.count > 0 then
2009: x_debrief_status := l_debrief_status_tbl;
2010: x_return_status := fnd_api.g_ret_sts_error;
2011: end if;
2012: exception when others then
2013: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2014: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

Line 2016: x_return_status := fnd_api.g_ret_sts_unexp_error;

2012: exception when others then
2013: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2014: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2015: fnd_msg_pub.add;
2016: x_return_status := fnd_api.g_ret_sts_unexp_error;
2017: END DEBRIEF_STATUS_CHECK ;
2018:
2019: End Csf_Debrief_Update_pkg;
2020: