APPS.CSP_SUPERSESSIONS_PVT dependencies on FND_API

Line 924: IF l_return_status = FND_API.G_RET_STS_SUCCESS and l_excess_parts_tbl.count > 0 THEN

920: ,x_return_status => l_return_status
921: ,x_msg_data => l_msg_data
922: ,x_msg_count => l_msg_count);
923: l_excess_quantity := 0;
924: IF l_return_status = FND_API.G_RET_STS_SUCCESS and l_excess_parts_tbl.count > 0 THEN
925: FOR I IN 1..l_excess_parts_tbl.count LOOP
926: l_excess_quantity := l_excess_quantity + l_excess_parts_tbl(I).quantity ;
927: -- l_cumulative_att := l_cumulative_att + l_excess_parts_tbl(I).quantity ;
928: END LOOP;

Line 1367: x_return_status := FND_API.G_RET_STS_SUCCESS;

1363: and secondary_inventory = l_subinv_code;
1364:
1365:
1366: BEGIN
1367: x_return_status := FND_API.G_RET_STS_SUCCESS;
1368: savepoint PROCESS_SUPERSESSIONS;
1369: CSP_AUTO_ASLMSL_PVT.Create_supply_chain (
1370: P_Api_Version_Number => 1.0 ,
1371: P_Init_Msg_List => FND_API.G_TRUE,

Line 1371: P_Init_Msg_List => FND_API.G_TRUE,

1367: x_return_status := FND_API.G_RET_STS_SUCCESS;
1368: savepoint PROCESS_SUPERSESSIONS;
1369: CSP_AUTO_ASLMSL_PVT.Create_supply_chain (
1370: P_Api_Version_Number => 1.0 ,
1371: P_Init_Msg_List => FND_API.G_TRUE,
1372: P_Commit => FND_API.G_FALSE,
1373: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
1374: P_Level_id => p_level_id,
1375: X_Return_Status => x_return_status,

Line 1372: P_Commit => FND_API.G_FALSE,

1368: savepoint PROCESS_SUPERSESSIONS;
1369: CSP_AUTO_ASLMSL_PVT.Create_supply_chain (
1370: P_Api_Version_Number => 1.0 ,
1371: P_Init_Msg_List => FND_API.G_TRUE,
1372: P_Commit => FND_API.G_FALSE,
1373: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
1374: P_Level_id => p_level_id,
1375: X_Return_Status => x_return_status,
1376: X_Msg_Count => x_msg_count ,

Line 1373: P_validation_level => FND_API.G_VALID_LEVEL_FULL,

1369: CSP_AUTO_ASLMSL_PVT.Create_supply_chain (
1370: P_Api_Version_Number => 1.0 ,
1371: P_Init_Msg_List => FND_API.G_TRUE,
1372: P_Commit => FND_API.G_FALSE,
1373: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
1374: P_Level_id => p_level_id,
1375: X_Return_Status => x_return_status,
1376: X_Msg_Count => x_msg_count ,
1377: X_Msg_Data => x_msg_data

Line 1379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1375: X_Return_Status => x_return_status,
1376: X_Msg_Count => x_msg_count ,
1377: X_Msg_Data => x_msg_data
1378: );
1379: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1380: ROLLBACK TO PROCESS_SUPERSESSIONS;
1381: return;
1382: END IF;
1383: OPEN get_org_subinv;

Line 1403: IF FND_API.to_Boolean( p_commit)

1399: ,p_supply_chain_id => gsc.supply_chain_id
1400: ,x_return_status => l_return_status);
1401: END IF;
1402: END LOOP;
1403: IF FND_API.to_Boolean( p_commit)
1404: THEN
1405: commit work;
1406: END IF;
1407:

Line 1410: x_return_status := FND_API.G_RET_STS_ERROR;

1406: END IF;
1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: ROLLBACK TO PROCESS_SUPERSESSIONS;
1412: END PROCESS_SUPERSESSIONS;
1413: PROCEDURE check_for_duplicate_parts(l_parts_list IN CSP_SCH_INT_PVT.CSP_PARTS_TBL_TYP1
1414: ,p_org_id IN NUMBER

Line 1468: x_return_status := FND_API.G_RET_STS_ERROR;

1464: END IF;*/
1465: IF l_supersede_item_id = l_supersede_items(J).l_supersede_item THEN
1466: l_duplicate := TRUE;
1467: l_duplicate_item := l_supersede_items(J).l_item;
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: l_duplicate_item_number := null;
1470: OPEN get_item_number(l_duplicate_item);
1471: FETCH get_item_number INTO l_duplicate_item_number;
1472: CLOSE get_item_number;

Line 1488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1484: , p_data => x_message);
1485: exit;
1486: END IF;
1487: END LOOP;
1488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1489: exit;
1490: END IF;
1491: IF NOT l_already_processed THEN
1492: FOR K IN 1..l_parts_list.count LOOP

Line 1494: x_return_status := FND_API.G_RET_STS_ERROR;

1490: END IF;
1491: IF NOT l_already_processed THEN
1492: FOR K IN 1..l_parts_list.count LOOP
1493: IF l_supersede_item_id = l_parts_list(K).item_id THEN
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: l_duplicate_item_number := null;
1496: l_duplicate_item := l_supersede_item_id;
1497: l_temp_item := l_parts_list(I).item_id;
1498: OPEN get_item_number(l_duplicate_item);

Line 1516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1512: , p_data => x_message);
1513: exit;
1514: END IF;
1515: END LOOP;
1516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: exit;
1518: END IF;
1519: l_temp_item := null;
1520: IF NOT l_duplicate THEN

Line 1533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1529: END IF;
1530: END LOOP;
1531: CLOSE get_supersede_item;
1532: l_temp_item := l_supersede_item_id;
1533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1534: return;
1535: END IF;
1536: END LOOP;
1537: END LOOP;