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

Line 194: g_ret_sts_success varchar2(3) := FND_API.G_RET_STS_SUCCESS;

190: -- subhat: 12.1.2 BR ER FP changes
191: x_sr_ro_rma_tbl CSD_BULK_RECEIVE_UTIL.sr_ro_rma_tbl;
192: l_create_sr_flag VARCHAR2(3) := 'Y';
193: l_counter number := 0;
194: g_ret_sts_success varchar2(3) := FND_API.G_RET_STS_SUCCESS;
195: l_prod_txn_rec csd_process_pvt.product_txn_rec;
196: l_msg_index_out NUMBER;
197: l_req_data varchar2(30);
198: x number;

Line 357: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then

353: x_msg_count => l_msg_count,
354: x_msg_data => l_msg_data
355: );
356:
357: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
358:
359: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
360: fnd_log.STRING (fnd_log.level_statement,
361: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

Line 472: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then

468: x_msg_count => l_msg_count,
469: x_msg_data => l_msg_data
470: );
471:
472: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
473:
474: If (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
475: fnd_log.STRING (fnd_log.level_statement,
476: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',

Line 545: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then

541: x_msg_count => l_msg_count,
542: x_msg_data => l_msg_data
543: );
544:
545: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
546:
547: -- If RO is created in Draft status then
548: -- no Logistic lines are created
549:

Line 588: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then

584: x_msg_count => l_msg_count,
585: x_msg_data => l_msg_data
586: );
587:
588: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
589:
590: -- If Logistic line creation fails then rollback RO
591: Rollback To reprocess_ro_savepoint;
592:

Line 613: p_init_msg_list => Fnd_Api.G_FALSE,

609: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
610: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
611: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
612: p_api_version_number => 1.0,
613: p_init_msg_list => Fnd_Api.G_FALSE,
614: p_commit => Fnd_Api.G_FALSE,
615: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
616: p_repair_line_id => l_repair_line_id,
617: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 614: p_commit => Fnd_Api.G_FALSE,

610: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
611: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
612: p_api_version_number => 1.0,
613: p_init_msg_list => Fnd_Api.G_FALSE,
614: p_commit => Fnd_Api.G_FALSE,
615: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
616: p_repair_line_id => l_repair_line_id,
617: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
618: x_return_status => l_return_status,

Line 615: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

611: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
612: p_api_version_number => 1.0,
613: p_init_msg_list => Fnd_Api.G_FALSE,
614: p_commit => Fnd_Api.G_FALSE,
615: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
616: p_repair_line_id => l_repair_line_id,
617: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
618: x_return_status => l_return_status,
619: x_msg_count => l_msg_count,

Line 729: p_init_msg_list => fnd_api.g_false,

725: End if;
726: -- call the API to create the instance
727: csd_mass_rcv_pvt.create_item_instance (
728: p_api_version => 1.0,
729: p_init_msg_list => fnd_api.g_false,
730: p_commit => fnd_api.g_false,
731: p_validation_level => fnd_api.g_valid_level_full,
732: x_return_status => l_return_status,
733: x_msg_count => l_msg_count,

Line 730: p_commit => fnd_api.g_false,

726: -- call the API to create the instance
727: csd_mass_rcv_pvt.create_item_instance (
728: p_api_version => 1.0,
729: p_init_msg_list => fnd_api.g_false,
730: p_commit => fnd_api.g_false,
731: p_validation_level => fnd_api.g_valid_level_full,
732: x_return_status => l_return_status,
733: x_msg_count => l_msg_count,
734: x_msg_data => l_msg_data,

Line 731: p_validation_level => fnd_api.g_valid_level_full,

727: csd_mass_rcv_pvt.create_item_instance (
728: p_api_version => 1.0,
729: p_init_msg_list => fnd_api.g_false,
730: p_commit => fnd_api.g_false,
731: p_validation_level => fnd_api.g_valid_level_full,
732: x_return_status => l_return_status,
733: x_msg_count => l_msg_count,
734: x_msg_data => l_msg_data,
735: px_instance_rec => l_instance_rec,

Line 737: if not (l_return_status = fnd_api.g_ret_sts_success) then

733: x_msg_count => l_msg_count,
734: x_msg_data => l_msg_data,
735: px_instance_rec => l_instance_rec,
736: x_instance_id => l_instance_id );
737: if not (l_return_status = fnd_api.g_ret_sts_success) then
738: raise fnd_api.g_exc_error;
739: end if;
740: exception
741: when FND_API.G_EXC_ERROR then

Line 738: raise fnd_api.g_exc_error;

734: x_msg_data => l_msg_data,
735: px_instance_rec => l_instance_rec,
736: x_instance_id => l_instance_id );
737: if not (l_return_status = fnd_api.g_ret_sts_success) then
738: raise fnd_api.g_exc_error;
739: end if;
740: exception
741: when FND_API.G_EXC_ERROR then
742: null;

Line 741: when FND_API.G_EXC_ERROR then

737: if not (l_return_status = fnd_api.g_ret_sts_success) then
738: raise fnd_api.g_exc_error;
739: end if;
740: exception
741: when FND_API.G_EXC_ERROR then
742: null;
743: end;
744: else
745: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 768: if l_return_status <> fnd_api.g_ret_sts_success then

764: x_msg_count => l_msg_count,
765: x_msg_data => l_msg_data,
766: x_return_status => l_return_status
767: );
768: if l_return_status <> fnd_api.g_ret_sts_success then
769: -- the order is not booked and an attempt to book it has failed.
770: -- log it to concurrent log.
771: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
772: -- update the bulk receive record as errored.

Line 830: p_init_msg_list => FND_API.G_FALSE,

826: 'Over-receipt: Before calling csd_bulk_receive_util.create_new_rma');
827: End if;
828: csd_bulk_receive_util.create_new_rma(
829: p_api_version => 1,
830: p_init_msg_list => FND_API.G_FALSE,
831: p_commit => FND_API.G_FALSE,
832: p_order_header_id => bk_rcv_rec.order_header_id,
833: p_new_rma_qty => bk_rcv_rec.over_receipt_qty,
834: p_repair_line_id => bk_rcv_rec.repair_line_id,

Line 831: p_commit => FND_API.G_FALSE,

827: End if;
828: csd_bulk_receive_util.create_new_rma(
829: p_api_version => 1,
830: p_init_msg_list => FND_API.G_FALSE,
831: p_commit => FND_API.G_FALSE,
832: p_order_header_id => bk_rcv_rec.order_header_id,
833: p_new_rma_qty => bk_rcv_rec.over_receipt_qty,
834: p_repair_line_id => bk_rcv_rec.repair_line_id,
835: p_incident_id => bk_rcv_rec.incident_id,

Line 865: p_init_msg_list => FND_API.G_FALSE,

861: End if;
862: -- auto create the ship lines for the over-receipt quantity.
863: csd_bulk_receive_util.create_new_ship_line(
864: p_api_version => 1,
865: p_init_msg_list => FND_API.G_FALSE,
866: p_commit => FND_API.G_FALSE,
867: p_order_header_id => bk_rcv_rec.order_header_id,
868: p_new_ship_qty => bk_rcv_rec.over_receipt_qty,
869: p_repair_line_id => bk_rcv_rec.repair_line_id,

Line 866: p_commit => FND_API.G_FALSE,

862: -- auto create the ship lines for the over-receipt quantity.
863: csd_bulk_receive_util.create_new_ship_line(
864: p_api_version => 1,
865: p_init_msg_list => FND_API.G_FALSE,
866: p_commit => FND_API.G_FALSE,
867: p_order_header_id => bk_rcv_rec.order_header_id,
868: p_new_ship_qty => bk_rcv_rec.over_receipt_qty,
869: p_repair_line_id => bk_rcv_rec.repair_line_id,
870: p_incident_id => bk_rcv_rec.incident_id,

Line 989: if l_return_status <> fnd_api.g_ret_sts_success then

985: x_msg_data => l_msg_data,
986: x_return_status => l_return_status
987: );
988:
989: if l_return_status <> fnd_api.g_ret_sts_success then
990: -- the order is not booked and an attempt to book it has failed.
991: -- log it to concurrent log.
992: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
993: -- update the bulk receive record as errored.

Line 1088: p_init_msg_list => fnd_api.g_false,

1084:
1085: -- call the API to create the instance
1086: csd_mass_rcv_pvt.create_item_instance (
1087: p_api_version => 1.0,
1088: p_init_msg_list => fnd_api.g_false,
1089: p_commit => fnd_api.g_false,
1090: p_validation_level => fnd_api.g_valid_level_full,
1091: x_return_status => l_return_status,
1092: x_msg_count => l_msg_count,

Line 1089: p_commit => fnd_api.g_false,

1085: -- call the API to create the instance
1086: csd_mass_rcv_pvt.create_item_instance (
1087: p_api_version => 1.0,
1088: p_init_msg_list => fnd_api.g_false,
1089: p_commit => fnd_api.g_false,
1090: p_validation_level => fnd_api.g_valid_level_full,
1091: x_return_status => l_return_status,
1092: x_msg_count => l_msg_count,
1093: x_msg_data => l_msg_data,

Line 1090: p_validation_level => fnd_api.g_valid_level_full,

1086: csd_mass_rcv_pvt.create_item_instance (
1087: p_api_version => 1.0,
1088: p_init_msg_list => fnd_api.g_false,
1089: p_commit => fnd_api.g_false,
1090: p_validation_level => fnd_api.g_valid_level_full,
1091: x_return_status => l_return_status,
1092: x_msg_count => l_msg_count,
1093: x_msg_data => l_msg_data,
1094: px_instance_rec => l_instance_rec,

Line 1096: if not (l_return_status = fnd_api.g_ret_sts_success) then

1092: x_msg_count => l_msg_count,
1093: x_msg_data => l_msg_data,
1094: px_instance_rec => l_instance_rec,
1095: x_instance_id => l_instance_id );
1096: if not (l_return_status = fnd_api.g_ret_sts_success) then
1097: raise fnd_api.g_exc_error;
1098: end if;
1099: exception
1100: when FND_API.G_EXC_ERROR then

Line 1097: raise fnd_api.g_exc_error;

1093: x_msg_data => l_msg_data,
1094: px_instance_rec => l_instance_rec,
1095: x_instance_id => l_instance_id );
1096: if not (l_return_status = fnd_api.g_ret_sts_success) then
1097: raise fnd_api.g_exc_error;
1098: end if;
1099: exception
1100: when FND_API.G_EXC_ERROR then
1101: null;

Line 1100: when FND_API.G_EXC_ERROR then

1096: if not (l_return_status = fnd_api.g_ret_sts_success) then
1097: raise fnd_api.g_exc_error;
1098: end if;
1099: exception
1100: when FND_API.G_EXC_ERROR then
1101: null;
1102: end;
1103: else
1104: csd_repair_manager_util.update_external_reference(p_external_reference => bk_rcv_rec.external_reference,

Line 1139: raise fnd_api.g_exc_error;

1135: update csd_bulk_receive_items_b
1136: set status = 'ERRORED'
1137: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1138:
1139: raise fnd_api.g_exc_error;
1140: end if;
1141:
1142: -- update the csd_product_transactions table to mark it as unplanned.
1143:

Line 1182: raise fnd_api.g_exc_error;

1178: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1179:
1180: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
1181:
1182: raise fnd_api.g_exc_error;
1183: end if;
1184:
1185: update csd_bulk_receive_items_b
1186: set repair_line_id = l_repair_line_id

Line 1228: raise fnd_api.g_exc_error;

1224: update csd_bulk_receive_items_b
1225: set status = 'ERRORED'
1226: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1227:
1228: raise fnd_api.g_exc_error;
1229: end if;
1230: -- get the order header and line id for the RMA just created.
1231: begin
1232: select ced.order_header_id,ced.order_line_id

Line 1281: when FND_API.G_EXC_ERROR then

1277: l_create_sr_flag := 'Y';
1278:
1279: end if;
1280: exception
1281: when FND_API.G_EXC_ERROR then
1282: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1283: fnd_log.STRING (fnd_log.level_procedure,
1284: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1285: 'Error occured during unplanned receipt processing '||l_msg_data);

Line 1373: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then

1369: x_msg_count => l_msg_count,
1370: x_msg_data => l_msg_data
1371: );
1372:
1373: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
1374:
1375: -- Update the record status
1376:
1377: Update csd_bulk_receive_items_b

Line 1409: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then

1405: p_msg_data => l_msg_data);
1406:
1407: End if;
1408:
1409: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
1410:
1411: -- Initialize the error count
1412: l_ro_error_count := 0;
1413:

Line 1440: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then

1436: x_msg_count => l_msg_count,
1437: x_msg_data => l_msg_data
1438: );
1439:
1440: If (l_return_status = FND_API.G_RET_STS_SUCCESS) then
1441:
1442: -- If the RO is created in Draft status then
1443: -- no Logistic lines are created.
1444:

Line 1482: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then

1478: x_msg_count => l_msg_count,
1479: x_msg_data => l_msg_data
1480: );
1481:
1482: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1483:
1484: -- If Logistic line creation fails then rollback RO
1485:
1486: Rollback To create_ro_savepoint;

Line 1510: p_init_msg_list => Fnd_Api.G_FALSE,

1506: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
1507: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
1508: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => Fnd_Api.G_FALSE,
1511: p_commit => Fnd_Api.G_FALSE,
1512: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1513: p_repair_line_id => l_repair_line_id,
1514: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 1511: p_commit => Fnd_Api.G_FALSE,

1507: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
1508: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => Fnd_Api.G_FALSE,
1511: p_commit => Fnd_Api.G_FALSE,
1512: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1513: p_repair_line_id => l_repair_line_id,
1514: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
1515: x_return_status => l_return_status,

Line 1512: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

1508: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => Fnd_Api.G_FALSE,
1511: p_commit => Fnd_Api.G_FALSE,
1512: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1513: p_repair_line_id => l_repair_line_id,
1514: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
1515: x_return_status => l_return_status,
1516: x_msg_count => l_msg_count,

Line 1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1715: End if;
1716:
1717: EXCEPTION
1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: -- write message to log file indicating the failure of the concurrent program,
1721: -- return error retcode
1722: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_BULK_RECEIVE_FAILURE');
1723: retcode := c_error;

Line 1725: WHEN FND_API.G_EXC_ERROR THEN

1721: -- return error retcode
1722: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_BULK_RECEIVE_FAILURE');
1723: retcode := c_error;
1724:
1725: WHEN FND_API.G_EXC_ERROR THEN
1726: -- write message to log file indicating the failure of the concurrent program,
1727: -- return error retcode
1728: errbuf := FND_MESSAGE.GET_STRING('CSD','CSD_BULK_RECEIVE_FAILURE');
1729: retcode := c_error;

Line 1741: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1737:
1738: -- Get the count of the Messages from the message list, if the count is 1
1739: -- get the message as well
1740:
1741: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1742: p_count => l_msg_count,
1743: p_data => l_msg_data);
1744:
1745: IF l_msg_count = 1 THEN

Line 1756: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );

1752: -- message list, retrieve the messages and write it to the log file
1753:
1754: FOR l_msg_ctr IN 1..l_msg_count
1755: LOOP
1756: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1757: fnd_file.put_line( fnd_file.log, l_msg_data);
1758: END LOOP;
1759:
1760: END IF;