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_UTIL dependencies on FND_API

Line 208: if x_return_status <> fnd_api.g_ret_sts_success then

204: x_line_number => x_line_number,
205: p_Charges_Rec => l_Charge_Details_rec
206: );
207:
208: if x_return_status <> fnd_api.g_ret_sts_success then
209: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
210: fnd_log.STRING (fnd_log.level_procedure,
211: 'CSD.PLSQL.CSD_BULK_RECEIVE_UTIL.AFTER_UNDER_RECEIPT_PRCS',
212: 'Under-receipt: Error in creating charge lines: '|| x_msg_data);

Line 867: p_commit => fnd_api.g_false,

863:
864: -- Call the Service Request API
865: CSD_PROCESS_PVT.process_service_request
866: ( p_api_version => 1.0,
867: p_commit => fnd_api.g_false,
868: p_init_msg_list => fnd_api.g_true,
869: p_validation_level => fnd_api.g_valid_level_full,
870: p_action => 'CREATE',
871: p_incident_id => NULL,

Line 868: p_init_msg_list => fnd_api.g_true,

864: -- Call the Service Request API
865: CSD_PROCESS_PVT.process_service_request
866: ( p_api_version => 1.0,
867: p_commit => fnd_api.g_false,
868: p_init_msg_list => fnd_api.g_true,
869: p_validation_level => fnd_api.g_valid_level_full,
870: p_action => 'CREATE',
871: p_incident_id => NULL,
872: p_service_request_rec => l_service_request_rec,

Line 869: p_validation_level => fnd_api.g_valid_level_full,

865: CSD_PROCESS_PVT.process_service_request
866: ( p_api_version => 1.0,
867: p_commit => fnd_api.g_false,
868: p_init_msg_list => fnd_api.g_true,
869: p_validation_level => fnd_api.g_valid_level_full,
870: p_action => 'CREATE',
871: p_incident_id => NULL,
872: p_service_request_rec => l_service_request_rec,
873: p_notes_tbl => p_sr_notes_tbl,

Line 881: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

877: x_msg_count => x_msg_count,
878: x_msg_data => x_msg_data
879: );
880:
881: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
882: RAISE FND_API.G_EXC_ERROR;
883: End If;
884:
885: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 882: RAISE FND_API.G_EXC_ERROR;

878: x_msg_data => x_msg_data
879: );
880:
881: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
882: RAISE FND_API.G_EXC_ERROR;
883: End If;
884:
885: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
886: fnd_log.STRING (fnd_log.level_procedure,

Line 892: When FND_API.G_EXC_ERROR then

888: 'Exit - Create Blkrcv SR');
889: End if;
890:
891: EXCEPTION
892: When FND_API.G_EXC_ERROR then
893: Rollback To create_blkrcv_sr;
894: x_return_status := FND_API.G_RET_STS_ERROR ;
895: FND_MSG_PUB.Count_And_Get
896: (p_count => x_msg_count,

Line 894: x_return_status := FND_API.G_RET_STS_ERROR ;

890:
891: EXCEPTION
892: When FND_API.G_EXC_ERROR then
893: Rollback To create_blkrcv_sr;
894: x_return_status := FND_API.G_RET_STS_ERROR ;
895: FND_MSG_PUB.Count_And_Get
896: (p_count => x_msg_count,
897: p_data => x_msg_data );
898:

Line 899: When FND_API.G_EXC_UNEXPECTED_ERROR then

895: FND_MSG_PUB.Count_And_Get
896: (p_count => x_msg_count,
897: p_data => x_msg_data );
898:
899: When FND_API.G_EXC_UNEXPECTED_ERROR then
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901: ROLLBACK TO create_blkrcv_sr;
902: FND_MSG_PUB.Count_And_Get
903: ( p_count => x_msg_count,

Line 900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

896: (p_count => x_msg_count,
897: p_data => x_msg_data );
898:
899: When FND_API.G_EXC_UNEXPECTED_ERROR then
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901: ROLLBACK TO create_blkrcv_sr;
902: FND_MSG_PUB.Count_And_Get
903: ( p_count => x_msg_count,
904: p_data => x_msg_data );

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

903: ( p_count => x_msg_count,
904: p_data => x_msg_data );
905:
906: When OTHERS then
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: Rollback To create_blkrcv_sr;
909: If FND_MSG_PUB.Check_Msg_Level
910: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
911: FND_MSG_PUB.Add_Exc_Msg

Line 1187: p_init_msg_list => fnd_api.g_false,

1183:
1184:
1185: csd_mass_rcv_pvt.create_item_instance (
1186: p_api_version => 1.0,
1187: p_init_msg_list => fnd_api.g_false,
1188: p_commit => fnd_api.g_false,
1189: p_validation_level => fnd_api.g_valid_level_full,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,

Line 1188: p_commit => fnd_api.g_false,

1184:
1185: csd_mass_rcv_pvt.create_item_instance (
1186: p_api_version => 1.0,
1187: p_init_msg_list => fnd_api.g_false,
1188: p_commit => fnd_api.g_false,
1189: p_validation_level => fnd_api.g_valid_level_full,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,

Line 1189: p_validation_level => fnd_api.g_valid_level_full,

1185: csd_mass_rcv_pvt.create_item_instance (
1186: p_api_version => 1.0,
1187: p_init_msg_list => fnd_api.g_false,
1188: p_commit => fnd_api.g_false,
1189: p_validation_level => fnd_api.g_valid_level_full,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,
1193: px_instance_rec => l_instance_rec,

Line 1196: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1192: x_msg_data => x_msg_data,
1193: px_instance_rec => l_instance_rec,
1194: x_instance_id => l_instance_id );
1195:
1196: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1197: RAISE FND_API.G_EXC_ERROR;
1198: End if;
1199:
1200: End if;

Line 1197: RAISE FND_API.G_EXC_ERROR;

1193: px_instance_rec => l_instance_rec,
1194: x_instance_id => l_instance_id );
1195:
1196: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1197: RAISE FND_API.G_EXC_ERROR;
1198: End if;
1199:
1200: End if;
1201:

Line 1239: p_init_msg_list => fnd_api.g_false,

1235: fnd_profile.get('SERVER_TIMEZONE_ID', l_server_tz_id);
1236:
1237: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
1238: p_api_version_number => 1.0,
1239: p_init_msg_list => fnd_api.g_false,
1240: p_commit => fnd_api.g_false,
1241: p_contract_number => null,
1242: p_service_line_id => null,
1243: p_customer_id => l_customer_id,

Line 1240: p_commit => fnd_api.g_false,

1236:
1237: CSD_REPAIRS_UTIL.GET_ENTITLEMENTS(
1238: p_api_version_number => 1.0,
1239: p_init_msg_list => fnd_api.g_false,
1240: p_commit => fnd_api.g_false,
1241: p_contract_number => null,
1242: p_service_line_id => null,
1243: p_customer_id => l_customer_id,
1244: p_site_id => l_install_site_use_id,

Line 1260: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1256: x_return_status => x_return_status,
1257: x_msg_count => x_msg_count,
1258: x_msg_data => x_msg_data);
1259:
1260: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1261: RAISE FND_API.G_EXC_ERROR;
1262: End if;
1263:
1264: If (l_ent_contracts.count = 0 ) then

Line 1261: RAISE FND_API.G_EXC_ERROR;

1257: x_msg_count => x_msg_count,
1258: x_msg_data => x_msg_data);
1259:
1260: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1261: RAISE FND_API.G_EXC_ERROR;
1262: End if;
1263:
1264: If (l_ent_contracts.count = 0 ) then
1265:

Line 1281: l_repln_rec.contract_line_id = fnd_api.g_miss_num) then

1277: end if;
1278: End Loop;
1279:
1280: If (l_repln_rec.contract_line_id is null or
1281: l_repln_rec.contract_line_id = fnd_api.g_miss_num) then
1282: l_repln_rec.contract_line_id := l_ent_contracts(1).service_line_id;
1283: End if;
1284:
1285: End if;

Line 1292: p_init_msg_list => fnd_api.g_false,

1288: -- Default PL and Currency
1289: --
1290: csd_process_util.get_ro_default_curr_pl
1291: ( p_api_version => 1.0,
1292: p_init_msg_list => fnd_api.g_false,
1293: p_incident_id => l_blkrcv_rec.incident_id,
1294: p_repair_type_id => l_repair_type_id,
1295: p_ro_contract_line_id => l_repln_rec.contract_line_id,
1296: x_contract_pl_id => l_contract_pl_id,

Line 1303: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1299: x_return_status => x_return_status,
1300: x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data );
1302:
1303: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1304: RAISE FND_API.G_EXC_ERROR;
1305: End if;
1306:
1307: If ( l_contract_pl_id is not null) then

Line 1304: RAISE FND_API.G_EXC_ERROR;

1300: x_msg_count => x_msg_count,
1301: x_msg_data => x_msg_data );
1302:
1303: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1304: RAISE FND_API.G_EXC_ERROR;
1305: End if;
1306:
1307: If ( l_contract_pl_id is not null) then
1308: l_repln_rec.price_list_header_id := l_contract_pl_id;

Line 1330: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;

1326: -- Inventory org id
1327: --
1328: -- swai: bug 7657379 - use defaulting rules to get the inventory org
1329: -- l_repln_rec.inventory_org_id := fnd_profile.value('CSD_DEF_REP_INV_ORG');
1330: l_repln_rec.inventory_org_id := fnd_api.g_miss_num;
1331:
1332: --
1333: -- Initialize / Assign the values to Repair Rec type
1334: --

Line 1366: p_commit => fnd_api.g_false,

1362:
1363: -- Call the Repairs private API
1364: CSD_REPAIRS_PVT.Create_Repair_Order
1365: (p_api_version_number => 1.0,
1366: p_commit => fnd_api.g_false,
1367: p_init_msg_list => fnd_api.g_true,
1368: p_validation_level => fnd_api.g_valid_level_full,
1369: p_repair_line_id => x_repair_line_id,
1370: p_Repln_Rec => l_repln_rec,

Line 1367: p_init_msg_list => fnd_api.g_true,

1363: -- Call the Repairs private API
1364: CSD_REPAIRS_PVT.Create_Repair_Order
1365: (p_api_version_number => 1.0,
1366: p_commit => fnd_api.g_false,
1367: p_init_msg_list => fnd_api.g_true,
1368: p_validation_level => fnd_api.g_valid_level_full,
1369: p_repair_line_id => x_repair_line_id,
1370: p_Repln_Rec => l_repln_rec,
1371: x_repair_line_id => x_repair_line_id,

Line 1368: p_validation_level => fnd_api.g_valid_level_full,

1364: CSD_REPAIRS_PVT.Create_Repair_Order
1365: (p_api_version_number => 1.0,
1366: p_commit => fnd_api.g_false,
1367: p_init_msg_list => fnd_api.g_true,
1368: p_validation_level => fnd_api.g_valid_level_full,
1369: p_repair_line_id => x_repair_line_id,
1370: p_Repln_Rec => l_repln_rec,
1371: x_repair_line_id => x_repair_line_id,
1372: x_repair_number => x_repair_number,

Line 1378: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1374: x_msg_count => x_msg_count,
1375: x_msg_data => x_msg_data
1376: );
1377:
1378: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1379: RAISE FND_API.G_EXC_ERROR;
1380: End If;
1381:
1382: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 1379: RAISE FND_API.G_EXC_ERROR;

1375: x_msg_data => x_msg_data
1376: );
1377:
1378: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1379: RAISE FND_API.G_EXC_ERROR;
1380: End If;
1381:
1382: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1383: fnd_log.STRING (fnd_log.level_procedure,

Line 1389: When FND_API.G_EXC_ERROR then

1385: 'Exit - Create Blkrcv RO');
1386: End if;
1387:
1388: EXCEPTION
1389: When FND_API.G_EXC_ERROR then
1390: Rollback To create_blkrcv_ro;
1391: x_return_status := FND_API.G_RET_STS_ERROR ;
1392: FND_MSG_PUB.Count_And_Get
1393: (p_count => x_msg_count,

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR ;

1387:
1388: EXCEPTION
1389: When FND_API.G_EXC_ERROR then
1390: Rollback To create_blkrcv_ro;
1391: x_return_status := FND_API.G_RET_STS_ERROR ;
1392: FND_MSG_PUB.Count_And_Get
1393: (p_count => x_msg_count,
1394: p_data => x_msg_data );
1395:

Line 1396: When FND_API.G_EXC_UNEXPECTED_ERROR then

1392: FND_MSG_PUB.Count_And_Get
1393: (p_count => x_msg_count,
1394: p_data => x_msg_data );
1395:
1396: When FND_API.G_EXC_UNEXPECTED_ERROR then
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: ROLLBACK TO create_blkrcv_ro;
1399: FND_MSG_PUB.Count_And_Get
1400: ( p_count => x_msg_count,

Line 1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1393: (p_count => x_msg_count,
1394: p_data => x_msg_data );
1395:
1396: When FND_API.G_EXC_UNEXPECTED_ERROR then
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: ROLLBACK TO create_blkrcv_ro;
1399: FND_MSG_PUB.Count_And_Get
1400: ( p_count => x_msg_count,
1401: p_data => x_msg_data );

Line 1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1400: ( p_count => x_msg_count,
1401: p_data => x_msg_data );
1402:
1403: When OTHERS then
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1405: Rollback To create_blkrcv_ro;
1406: If FND_MSG_PUB.Check_Msg_Level
1407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1408: FND_MSG_PUB.Add_Exc_Msg

Line 1462: p_commit => fnd_api.g_false,

1458:
1459: -- Call the Create default prod txn api
1460: csd_process_pvt.create_default_prod_txn
1461: (p_api_version => 1.0,
1462: p_commit => fnd_api.g_false,
1463: p_init_msg_list => fnd_api.g_true,
1464: p_validation_level => fnd_api.g_valid_level_full,
1465: p_repair_line_id => l_blkrcv_rec.repair_line_id,
1466: x_return_status => x_return_status,

Line 1463: p_init_msg_list => fnd_api.g_true,

1459: -- Call the Create default prod txn api
1460: csd_process_pvt.create_default_prod_txn
1461: (p_api_version => 1.0,
1462: p_commit => fnd_api.g_false,
1463: p_init_msg_list => fnd_api.g_true,
1464: p_validation_level => fnd_api.g_valid_level_full,
1465: p_repair_line_id => l_blkrcv_rec.repair_line_id,
1466: x_return_status => x_return_status,
1467: x_msg_count => x_msg_count,

Line 1464: p_validation_level => fnd_api.g_valid_level_full,

1460: csd_process_pvt.create_default_prod_txn
1461: (p_api_version => 1.0,
1462: p_commit => fnd_api.g_false,
1463: p_init_msg_list => fnd_api.g_true,
1464: p_validation_level => fnd_api.g_valid_level_full,
1465: p_repair_line_id => l_blkrcv_rec.repair_line_id,
1466: x_return_status => x_return_status,
1467: x_msg_count => x_msg_count,
1468: x_msg_data => x_msg_data);

Line 1470: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1466: x_return_status => x_return_status,
1467: x_msg_count => x_msg_count,
1468: x_msg_data => x_msg_data);
1469:
1470: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1471: RAISE FND_API.G_EXC_ERROR;
1472: End If;
1473:
1474: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 1471: RAISE FND_API.G_EXC_ERROR;

1467: x_msg_count => x_msg_count,
1468: x_msg_data => x_msg_data);
1469:
1470: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1471: RAISE FND_API.G_EXC_ERROR;
1472: End If;
1473:
1474: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1475: fnd_log.STRING (fnd_log.level_procedure,

Line 1481: When FND_API.G_EXC_ERROR then

1477: 'Exit - Create Blkrcv Default Prod Txn');
1478: End if;
1479:
1480: EXCEPTION
1481: When FND_API.G_EXC_ERROR then
1482: Rollback To create_blkrcv_default_prod_txn;
1483: x_return_status := FND_API.G_RET_STS_ERROR ;
1484: FND_MSG_PUB.Count_And_Get
1485: (p_count => x_msg_count,

Line 1483: x_return_status := FND_API.G_RET_STS_ERROR ;

1479:
1480: EXCEPTION
1481: When FND_API.G_EXC_ERROR then
1482: Rollback To create_blkrcv_default_prod_txn;
1483: x_return_status := FND_API.G_RET_STS_ERROR ;
1484: FND_MSG_PUB.Count_And_Get
1485: (p_count => x_msg_count,
1486: p_data => x_msg_data );
1487:

Line 1488: When FND_API.G_EXC_UNEXPECTED_ERROR then

1484: FND_MSG_PUB.Count_And_Get
1485: (p_count => x_msg_count,
1486: p_data => x_msg_data );
1487:
1488: When FND_API.G_EXC_UNEXPECTED_ERROR then
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1490: ROLLBACK TO create_blkrcv_default_prod_txn;
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_count => x_msg_count,

Line 1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1485: (p_count => x_msg_count,
1486: p_data => x_msg_data );
1487:
1488: When FND_API.G_EXC_UNEXPECTED_ERROR then
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1490: ROLLBACK TO create_blkrcv_default_prod_txn;
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_count => x_msg_count,
1493: p_data => x_msg_data );

Line 1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1492: ( p_count => x_msg_count,
1493: p_data => x_msg_data );
1494:
1495: When OTHERS then
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1497: Rollback To create_blkrcv_default_prod_txn;
1498: If FND_MSG_PUB.Check_Msg_Level
1499: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1500: FND_MSG_PUB.Add_Exc_Msg

Line 1687: p_commit => fnd_api.g_false,

1683: -- Call the Update item instance API
1684: csi_item_instance_pub.update_item_instance
1685: (
1686: p_api_version => 1.0,
1687: p_commit => fnd_api.g_false,
1688: p_init_msg_list => fnd_api.g_true,
1689: p_validation_level => fnd_api.g_valid_level_full,
1690: p_instance_rec => l_instance_rec,
1691: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,

Line 1688: p_init_msg_list => fnd_api.g_true,

1684: csi_item_instance_pub.update_item_instance
1685: (
1686: p_api_version => 1.0,
1687: p_commit => fnd_api.g_false,
1688: p_init_msg_list => fnd_api.g_true,
1689: p_validation_level => fnd_api.g_valid_level_full,
1690: p_instance_rec => l_instance_rec,
1691: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1692: p_party_tbl => l_party_tbl,

Line 1689: p_validation_level => fnd_api.g_valid_level_full,

1685: (
1686: p_api_version => 1.0,
1687: p_commit => fnd_api.g_false,
1688: p_init_msg_list => fnd_api.g_true,
1689: p_validation_level => fnd_api.g_valid_level_full,
1690: p_instance_rec => l_instance_rec,
1691: p_ext_attrib_values_tbl => l_ext_attrib_values_tbl,
1692: p_party_tbl => l_party_tbl,
1693: p_account_tbl => l_account_tbl,

Line 1704: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1700: x_msg_count => x_msg_count,
1701: x_msg_data => x_msg_data
1702: );
1703:
1704: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1705: RAISE FND_API.G_EXC_ERROR;
1706: End If;
1707:
1708: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then

Line 1705: RAISE FND_API.G_EXC_ERROR;

1701: x_msg_data => x_msg_data
1702: );
1703:
1704: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1705: RAISE FND_API.G_EXC_ERROR;
1706: End If;
1707:
1708: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
1709: fnd_log.STRING (fnd_log.level_procedure,

Line 1715: When FND_API.G_EXC_ERROR then

1711: 'Exit - Change Blkrcv IB Owner');
1712: End if;
1713:
1714: EXCEPTION
1715: When FND_API.G_EXC_ERROR then
1716: Rollback To change_blkrcv_ib_owner;
1717: x_return_status := FND_API.G_RET_STS_ERROR ;
1718: FND_MSG_PUB.Count_And_Get
1719: (p_count => x_msg_count,

Line 1717: x_return_status := FND_API.G_RET_STS_ERROR ;

1713:
1714: EXCEPTION
1715: When FND_API.G_EXC_ERROR then
1716: Rollback To change_blkrcv_ib_owner;
1717: x_return_status := FND_API.G_RET_STS_ERROR ;
1718: FND_MSG_PUB.Count_And_Get
1719: (p_count => x_msg_count,
1720: p_data => x_msg_data );
1721:

Line 1722: When FND_API.G_EXC_UNEXPECTED_ERROR then

1718: FND_MSG_PUB.Count_And_Get
1719: (p_count => x_msg_count,
1720: p_data => x_msg_data );
1721:
1722: When FND_API.G_EXC_UNEXPECTED_ERROR then
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1724: ROLLBACK TO change_blkrcv_ib_owner;
1725: FND_MSG_PUB.Count_And_Get
1726: ( p_count => x_msg_count,

Line 1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1719: (p_count => x_msg_count,
1720: p_data => x_msg_data );
1721:
1722: When FND_API.G_EXC_UNEXPECTED_ERROR then
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1724: ROLLBACK TO change_blkrcv_ib_owner;
1725: FND_MSG_PUB.Count_And_Get
1726: ( p_count => x_msg_count,
1727: p_data => x_msg_data );

Line 1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1726: ( p_count => x_msg_count,
1727: p_data => x_msg_data );
1728:
1729: When OTHERS then
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1731: Rollback To change_blkrcv_ib_owner;
1732: If FND_MSG_PUB.Check_Msg_Level
1733: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
1734: FND_MSG_PUB.Add_Exc_Msg

Line 1961: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then -- Status check If statement

1957: if csd_bulk_receive_pvt.g_conc_req_id is not null then
1958: return;
1959: end if;
1960:
1961: If NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) then -- Status check If statement
1962:
1963: -- Verify if there are any errors in header
1964:
1965: csd_bulk_receive_util.write_to_conc_log

Line 2080: p_commit => fnd_api.g_false,

2076: -- end changes, subhat
2077: -- Call Update receipts program
2078: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
2079: ( p_api_version => 1.0,
2080: p_commit => fnd_api.g_false,
2081: p_init_msg_list => fnd_api.g_true,
2082: p_validation_level => 0,
2083: x_return_status => l_return_status,
2084: x_msg_count => l_msg_count,

Line 2081: p_init_msg_list => fnd_api.g_true,

2077: -- Call Update receipts program
2078: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
2079: ( p_api_version => 1.0,
2080: p_commit => fnd_api.g_false,
2081: p_init_msg_list => fnd_api.g_true,
2082: p_validation_level => 0,
2083: x_return_status => l_return_status,
2084: x_msg_count => l_msg_count,
2085: x_msg_data => l_msg_data,

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

2087: p_order_header_id => null,
2088: p_repair_line_id => p_bulk_autorcv_tbl(i).repair_line_id);
2089:
2090: -- fix for bug 5227347
2091: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
2092:
2093: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
2094: csd_bulk_receive_util.write_to_conc_log
2095: ( p_msg_count => l_msg_count,

Line 2157: p_commit => fnd_api.g_false,

2153:
2154: -- Call Update receipts program
2155: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
2156: ( p_api_version => 1.0,
2157: p_commit => fnd_api.g_false,
2158: p_init_msg_list => fnd_api.g_true,
2159: p_validation_level => 0,
2160: x_return_status => l_return_status,
2161: x_msg_count => l_msg_count,

Line 2158: p_init_msg_list => fnd_api.g_true,

2154: -- Call Update receipts program
2155: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
2156: ( p_api_version => 1.0,
2157: p_commit => fnd_api.g_false,
2158: p_init_msg_list => fnd_api.g_true,
2159: p_validation_level => 0,
2160: x_return_status => l_return_status,
2161: x_msg_count => l_msg_count,
2162: x_msg_data => l_msg_data,

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

2164: p_order_header_id => null,
2165: p_repair_line_id => p_bulk_autorcv_tbl(i).repair_line_id);
2166:
2167: -- fix for bug 5227347
2168: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
2169:
2170: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
2171: csd_bulk_receive_util.write_to_conc_log
2172: ( p_msg_count => l_msg_count,

Line 2205: When FND_API.G_EXC_ERROR then

2201: 'Exit - Bulk auto receive');
2202: End if;
2203:
2204: EXCEPTION
2205: When FND_API.G_EXC_ERROR then
2206: Rollback To bulk_auto_receive;
2207: x_return_status := FND_API.G_RET_STS_ERROR ;
2208: FND_MSG_PUB.Count_And_Get
2209: (p_count => x_msg_count,

Line 2207: x_return_status := FND_API.G_RET_STS_ERROR ;

2203:
2204: EXCEPTION
2205: When FND_API.G_EXC_ERROR then
2206: Rollback To bulk_auto_receive;
2207: x_return_status := FND_API.G_RET_STS_ERROR ;
2208: FND_MSG_PUB.Count_And_Get
2209: (p_count => x_msg_count,
2210: p_data => x_msg_data );
2211:

Line 2212: When FND_API.G_EXC_UNEXPECTED_ERROR then

2208: FND_MSG_PUB.Count_And_Get
2209: (p_count => x_msg_count,
2210: p_data => x_msg_data );
2211:
2212: When FND_API.G_EXC_UNEXPECTED_ERROR then
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2214: ROLLBACK TO bulk_auto_receive;
2215: FND_MSG_PUB.Count_And_Get
2216: ( p_count => x_msg_count,

Line 2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2209: (p_count => x_msg_count,
2210: p_data => x_msg_data );
2211:
2212: When FND_API.G_EXC_UNEXPECTED_ERROR then
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2214: ROLLBACK TO bulk_auto_receive;
2215: FND_MSG_PUB.Count_And_Get
2216: ( p_count => x_msg_count,
2217: p_data => x_msg_data );

Line 2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2216: ( p_count => x_msg_count,
2217: p_data => x_msg_data );
2218:
2219: When OTHERS then
2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2221: Rollback To bulk_auto_receive;
2222: If FND_MSG_PUB.Check_Msg_Level
2223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)then
2224: FND_MSG_PUB.Add_Exc_Msg

Line 2517: p_init_msg_list => fnd_api.g_false,

2513:
2514: l_default_val_num := null;
2515: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2516: p_api_version_number => 1.0,
2517: p_init_msg_list => fnd_api.g_false,
2518: p_commit => fnd_api.g_false,
2519: p_validation_level => fnd_api.g_valid_level_full,
2520: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
2521: p_entity_attribute_code => 'REPAIR_TYPE',

Line 2518: p_commit => fnd_api.g_false,

2514: l_default_val_num := null;
2515: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2516: p_api_version_number => 1.0,
2517: p_init_msg_list => fnd_api.g_false,
2518: p_commit => fnd_api.g_false,
2519: p_validation_level => fnd_api.g_valid_level_full,
2520: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
2521: p_entity_attribute_code => 'REPAIR_TYPE',
2522: p_rule_input_rec => l_rule_input_rec,

Line 2519: p_validation_level => fnd_api.g_valid_level_full,

2515: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2516: p_api_version_number => 1.0,
2517: p_init_msg_list => fnd_api.g_false,
2518: p_commit => fnd_api.g_false,
2519: p_validation_level => fnd_api.g_valid_level_full,
2520: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
2521: p_entity_attribute_code => 'REPAIR_TYPE',
2522: p_rule_input_rec => l_rule_input_rec,
2523: x_default_value => l_default_val_num,

Line 2533: if (l_return_status = fnd_api.g_ret_sts_success) and

2529:
2530: -- if default rule id is null, then no defaulting rule was found, and the
2531: -- profile for regular repair types was returned. We want the bulk receive
2532: -- profile option, so need to check default rule id.
2533: if (l_return_status = fnd_api.g_ret_sts_success) and
2534: (l_default_val_num is not null) and
2535: (l_default_rule_id is not null)
2536: then
2537: l_repair_type_id := l_default_val_num;

Line 2575: p_init_msg_list => fnd_api.g_false,

2571: l_rule_input_rec.repair_line_id := p_repair_line_id;
2572: l_default_val_str := null;
2573: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2574: p_api_version_number => 1.0,
2575: p_init_msg_list => fnd_api.g_false,
2576: p_commit => fnd_api.g_false,
2577: p_validation_level => fnd_api.g_valid_level_full,
2578: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
2579: p_entity_attribute_code => 'RMA_RCV_SUBINV',

Line 2576: p_commit => fnd_api.g_false,

2572: l_default_val_str := null;
2573: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2574: p_api_version_number => 1.0,
2575: p_init_msg_list => fnd_api.g_false,
2576: p_commit => fnd_api.g_false,
2577: p_validation_level => fnd_api.g_valid_level_full,
2578: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
2579: p_entity_attribute_code => 'RMA_RCV_SUBINV',
2580: p_rule_input_rec => l_rule_input_rec,

Line 2577: p_validation_level => fnd_api.g_valid_level_full,

2573: CSD_RULES_ENGINE_PVT.GET_DEFAULT_VALUE_FROM_RULE(
2574: p_api_version_number => 1.0,
2575: p_init_msg_list => fnd_api.g_false,
2576: p_commit => fnd_api.g_false,
2577: p_validation_level => fnd_api.g_valid_level_full,
2578: p_entity_attribute_type => 'CSD_DEF_ENTITY_ATTR_RO',
2579: p_entity_attribute_code => 'RMA_RCV_SUBINV',
2580: p_rule_input_rec => l_rule_input_rec,
2581: x_default_value => l_default_val_str,

Line 2591: if (l_return_status = fnd_api.g_ret_sts_success) and

2587:
2588: -- if default rule id is null, then no defaulting rule was found, and the
2589: -- profile for regular rma subinv was returned. We want the bulk receive
2590: -- profile option, so need to check default rule id.
2591: if (l_return_status = fnd_api.g_ret_sts_success) and
2592: (l_default_val_str is not null) and
2593: (l_default_rule_id is not null)
2594: then
2595: l_rma_subinv := l_default_val_str;

Line 3196: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3192: PROCEDURE create_new_rma
3193: (
3194: p_api_version IN NUMBER DEFAULT 1,
3195: p_init_msg_list IN VARCHAR2 DEFAULT 'F',
3196: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3197: p_order_header_id IN NUMBER,
3198: p_new_rma_qty IN NUMBER,
3199: p_repair_line_id IN NUMBER,
3200: p_incident_id IN NUMBER,

Line 3300: if x_return_status <> FND_API.g_ret_sts_success then

3296: x_msg_data => x_msg_data,
3297: x_msg_count => x_msg_count
3298: );
3299:
3300: if x_return_status <> FND_API.g_ret_sts_success then
3301: -- to do.
3302: -- Need to put a note with the error message.
3303: raise FND_API.G_EXC_ERROR;
3304: end if;

Line 3303: raise FND_API.G_EXC_ERROR;

3299:
3300: if x_return_status <> FND_API.g_ret_sts_success then
3301: -- to do.
3302: -- Need to put a note with the error message.
3303: raise FND_API.G_EXC_ERROR;
3304: end if;
3305: -- bug#8599965, get the order header from DB.
3306: -- x_order_header_id := l_prod_txn_rec.order_header_id;
3307: -- fetch order line id into the l_order_line_id variable.

Line 3321: when FND_API.G_EXC_ERROR THEN

3317: when no_data_found then
3318: null;
3319: end;
3320: EXCEPTION
3321: when FND_API.G_EXC_ERROR THEN
3322: -- an error occured during creation of new RMA.
3323: ROLLBACK TO create_new_rma;
3324: when others then
3325: ROLLBACK TO create_new_rma;

Line 3741: p_commit => fnd_api.g_false,

3737: End if;
3738: -- Call Update receipts program
3739: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
3740: ( p_api_version => 1.0,
3741: p_commit => fnd_api.g_false,
3742: p_init_msg_list => fnd_api.g_true,
3743: p_validation_level => 0,
3744: x_return_status => l_return_status,
3745: x_msg_count => l_msg_count,

Line 3742: p_init_msg_list => fnd_api.g_true,

3738: -- Call Update receipts program
3739: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
3740: ( p_api_version => 1.0,
3741: p_commit => fnd_api.g_false,
3742: p_init_msg_list => fnd_api.g_true,
3743: p_validation_level => 0,
3744: x_return_status => l_return_status,
3745: x_msg_count => l_msg_count,
3746: x_msg_data => l_msg_data,

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

3748: p_order_header_id => null,
3749: p_repair_line_id => l_bulk_autorcv_tbl(i).repair_line_id);
3750:
3751:
3752: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
3753: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
3754: fnd_log.STRING (fnd_log.level_procedure,
3755: lc_api_name,
3756: 'Error in CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE: Return status '||l_return_status);

Line 3803: p_commit => fnd_api.g_false,

3799:
3800: -- Call Update receipts program
3801: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
3802: ( p_api_version => 1.0,
3803: p_commit => fnd_api.g_false,
3804: p_init_msg_list => fnd_api.g_true,
3805: p_validation_level => 0,
3806: x_return_status => l_return_status,
3807: x_msg_count => l_msg_count,

Line 3804: p_init_msg_list => fnd_api.g_true,

3800: -- Call Update receipts program
3801: CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE
3802: ( p_api_version => 1.0,
3803: p_commit => fnd_api.g_false,
3804: p_init_msg_list => fnd_api.g_true,
3805: p_validation_level => 0,
3806: x_return_status => l_return_status,
3807: x_msg_count => l_msg_count,
3808: x_msg_data => l_msg_data,

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

3810: p_order_header_id => null,
3811: p_repair_line_id => l_bulk_autorcv_tbl(i).repair_line_id);
3812:
3813:
3814: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
3815: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
3816: fnd_log.STRING (fnd_log.level_procedure,
3817: lc_api_name,
3818: 'Error in CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE: Return status '||l_return_status);

Line 3904: x_return_status := fnd_api.g_ret_sts_success;

3900: lc_api_name,
3901: 'Begin pre_process_rma');
3902: End if;
3903: -- initialize the return status.
3904: x_return_status := fnd_api.g_ret_sts_success;
3905:
3906: if l_order_header_id is not null and l_order_line_id is not null then
3907: select cpt.prod_txn_status
3908: into l_rma_status

Line 4098: p_commit => FND_API.G_FALSE,

4094: End if;
4095:
4096: csd_process_pvt.update_product_txn
4097: ( p_api_version => 1,
4098: p_commit => FND_API.G_FALSE,
4099: p_init_msg_list => FND_API.G_TRUE,
4100: p_validation_level=> fnd_api.g_valid_level_full,
4101: x_product_txn_rec => l_prod_txn_rec,
4102: x_return_status => x_return_status,

Line 4099: p_init_msg_list => FND_API.G_TRUE,

4095:
4096: csd_process_pvt.update_product_txn
4097: ( p_api_version => 1,
4098: p_commit => FND_API.G_FALSE,
4099: p_init_msg_list => FND_API.G_TRUE,
4100: p_validation_level=> fnd_api.g_valid_level_full,
4101: x_product_txn_rec => l_prod_txn_rec,
4102: x_return_status => x_return_status,
4103: x_msg_count => x_msg_count,

Line 4100: p_validation_level=> fnd_api.g_valid_level_full,

4096: csd_process_pvt.update_product_txn
4097: ( p_api_version => 1,
4098: p_commit => FND_API.G_FALSE,
4099: p_init_msg_list => FND_API.G_TRUE,
4100: p_validation_level=> fnd_api.g_valid_level_full,
4101: x_product_txn_rec => l_prod_txn_rec,
4102: x_return_status => x_return_status,
4103: x_msg_count => x_msg_count,
4104: x_msg_data => x_msg_data

Line 4106: if x_return_status <> fnd_api.g_ret_sts_success then

4102: x_return_status => x_return_status,
4103: x_msg_count => x_msg_count,
4104: x_msg_data => x_msg_data
4105: );
4106: if x_return_status <> fnd_api.g_ret_sts_success then
4107: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
4108: fnd_log.STRING (fnd_log.level_procedure,
4109: lc_api_name,
4110: 'Error while trying to book the existing line ');

Line 4112: raise fnd_api.g_exc_error;

4108: fnd_log.STRING (fnd_log.level_procedure,
4109: lc_api_name,
4110: 'Error while trying to book the existing line ');
4111: End if;
4112: raise fnd_api.g_exc_error;
4113: end if;
4114:
4115: select ced.order_header_id,ced.order_line_id
4116: into px_order_header_id,px_order_line_id

Line 4125: when fnd_api.g_exc_error then

4121: and ced.estimate_detail_id = l_prod_txn_rec.estimate_detail_id
4122: and cpt.action_type = 'RMA';
4123:
4124: exception
4125: when fnd_api.g_exc_error then
4126: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
4127: fnd_log.STRING (fnd_log.level_procedure,
4128: lc_api_name,
4129: 'In g_exc_error exception, rolling back to pre_process_rma ');

Line 4131: x_return_status := fnd_api.g_ret_sts_error;

4127: fnd_log.STRING (fnd_log.level_procedure,
4128: lc_api_name,
4129: 'In g_exc_error exception, rolling back to pre_process_rma ');
4130: End if;
4131: x_return_status := fnd_api.g_ret_sts_error;
4132: rollback to pre_process_rma;
4133: when no_data_found then
4134: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
4135: fnd_log.STRING (fnd_log.level_procedure,

Line 4139: x_return_status := fnd_api.g_ret_sts_error;

4135: fnd_log.STRING (fnd_log.level_procedure,
4136: lc_api_name,
4137: 'In no_data_found exception.');
4138: End if;
4139: x_return_status := fnd_api.g_ret_sts_error;
4140: rollback to pre_process_rma;
4141: when others then
4142: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
4143: fnd_log.STRING (fnd_log.level_procedure,

Line 4158: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4154:
4155: procedure create_new_ship_line
4156: (
4157: p_api_version IN VARCHAR2,
4158: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4159: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4160: p_order_header_id IN NUMBER,
4161: p_new_ship_qty IN NUMBER,
4162: p_repair_line_id IN NUMBER,

Line 4159: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4155: procedure create_new_ship_line
4156: (
4157: p_api_version IN VARCHAR2,
4158: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4159: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4160: p_order_header_id IN NUMBER,
4161: p_new_ship_qty IN NUMBER,
4162: p_repair_line_id IN NUMBER,
4163: p_incident_id IN NUMBER,

Line 4242: if x_return_status <> FND_API.g_ret_sts_success then

4238: x_msg_data => x_msg_data,
4239: x_msg_count => x_msg_count
4240: );
4241:
4242: if x_return_status <> FND_API.g_ret_sts_success then
4243: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
4244: fnd_log.STRING (fnd_log.level_procedure,
4245: lc_api_name,
4246: 'Error in csd_process_pvt.create_product_txn');

Line 4248: raise FND_API.G_EXC_ERROR;

4244: fnd_log.STRING (fnd_log.level_procedure,
4245: lc_api_name,
4246: 'Error in csd_process_pvt.create_product_txn');
4247: End if;
4248: raise FND_API.G_EXC_ERROR;
4249: end if;
4250:
4251: EXCEPTION
4252: when FND_API.G_EXC_ERROR THEN

Line 4252: when FND_API.G_EXC_ERROR THEN

4248: raise FND_API.G_EXC_ERROR;
4249: end if;
4250:
4251: EXCEPTION
4252: when FND_API.G_EXC_ERROR THEN
4253: -- an error occured during creation of new RMA.
4254: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
4255: fnd_log.STRING (fnd_log.level_procedure,
4256: lc_api_name,