DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on FND_API

Line 692: AND ((l_osa_flag =1) AND (l_return_status = FND_API.G_RET_STS_SUCCESS))

688: END IF ;
689: END IF ;
690:
691: IF Is_Valid_Location(p_organization_id, l_subcontracting_type)
692: AND ((l_osa_flag =1) AND (l_return_status = FND_API.G_RET_STS_SUCCESS))
693: THEN
694:
695: -- To check if the OEM/TP relationship exists, check the cache to see
696: -- if the OEM/TP combn exists. If it does, get the status from the

Line 814: IF ((l_osa_flag <>1) OR (l_return_status <> FND_API.G_RET_STS_SUCCESS))

810: );
811: END IF;
812: END IF;
813:
814: IF ((l_osa_flag <>1) OR (l_return_status <> FND_API.G_RET_STS_SUCCESS))
815: THEN
816: x_valid_flag := 'N';
817: ELSE
818:

Line 1099: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

1095: , x_outsourced_assembly => l_osa_flag
1096: , x_subcontracting_component => l_comp_flag
1097: );
1098:
1099: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1100: (l_comp_flag IN (1,2))
1101: THEN
1102: -- Check if the Shikyu component flag is enabled at the TP orgn
1103:

Line 1116: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

1112: , x_outsourced_assembly => l_osa_flag
1113: , x_subcontracting_component => l_comp_flag
1114: );
1115:
1116: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1117: (l_comp_flag IN (1,2))
1118: THEN
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: ELSE

Line 1119: x_return_status := FND_API.G_RET_STS_SUCCESS;

1115:
1116: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1117: (l_comp_flag IN (1,2))
1118: THEN
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: ELSE
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1123: FND_MSG_PUB.add;

Line 1121: x_return_status := FND_API.G_RET_STS_ERROR;

1117: (l_comp_flag IN (1,2))
1118: THEN
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: ELSE
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1123: FND_MSG_PUB.add;
1124:
1125: IF g_log_enabled AND

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

1137: END IF;
1138:
1139: END IF;
1140: ELSE
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1143: FND_MSG_PUB.add;
1144:
1145: IF g_log_enabled AND

Line 1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1585: END IF;
1586:
1587: FND_MESSAGE.set_name('JMF', 'JMF_SHK_OSA_LD_ERR');
1588: FND_MSG_PUB.add;
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590:
1591: END Load_Subcontract_Orders;
1592:
1593: --========================================================================

Line 1875: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

1871: );
1872: END IF;
1873: END IF;
1874:
1875: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1876: (l_comp_flag = 1) -- Pre-positioned
1877: THEN
1878:
1879: l_additional_supply := 'N';

Line 1881: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

1877: THEN
1878:
1879: l_additional_supply := 'N';
1880:
1881: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1882: (l_comp_flag = 2) -- sync-ship
1883: THEN
1884:
1885: -- This indicates that there are PO's that are created but not picked

Line 1931: IF l_return_status = FND_API.G_RET_STS_SUCCESS

1927: || l_order_line_id
1928: );
1929: END IF;
1930:
1931: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1932: THEN
1933:
1934: SELECT header_id
1935: , schedule_ship_date

Line 2063: END IF; /* IF l_return_status = FND_API.G_RET_STS_SUCCESS */

2059: END IF;
2060:
2061: END IF;
2062:
2063: END IF; /* IF l_return_status = FND_API.G_RET_STS_SUCCESS */
2064:
2065: END LOOP;
2066:
2067: IF g_log_enabled THEN

Line 2137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2133: , p_qty => l_qty
2134: , p_skip_po_replen_creation => NVL(l_replen_so_creation_failed, 'N')
2135: );
2136:
2137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2138: THEN
2139:
2140: IF g_log_enabled
2141: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2149: END IF; /* IF l_return_status <> FND_API.G_RET_STS_SUCCESS */

2145: , '>> ' || l_program || ': Allocation Failed'
2146: );
2147: END IF;
2148:
2149: END IF; /* IF l_return_status <> FND_API.G_RET_STS_SUCCESS */
2150:
2151: -- Reset the replen_so_creation_failed flag
2152: IF l_replen_so_creation_failed IS NOT NULL
2153: THEN

Line 2477: , p_initMsgList => fnd_api.g_false

2473: , p_txnDate => l_start_date
2474: , p_implFlag => 2
2475: , p_projectID => l_osa_tbl(i).project_id
2476: , p_taskID => l_osa_tbl(i).task_id
2477: , p_initMsgList => fnd_api.g_false
2478: , p_endDebug => fnd_api.g_true
2479: , x_compTbl => l_comp_tbl
2480: , x_returnStatus => l_return_status);
2481:

Line 2478: , p_endDebug => fnd_api.g_true

2474: , p_implFlag => 2
2475: , p_projectID => l_osa_tbl(i).project_id
2476: , p_taskID => l_osa_tbl(i).task_id
2477: , p_initMsgList => fnd_api.g_false
2478: , p_endDebug => fnd_api.g_true
2479: , x_compTbl => l_comp_tbl
2480: , x_returnStatus => l_return_status);
2481:
2482: IF g_log_enabled THEN

Line 2494: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2490: END IF;
2491: END IF;
2492:
2493: -- if WIP Explode Requirements erred out
2494: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2495: THEN
2496: -- Error in bom explosion. Mark the shipment line status as error.
2497: -- Skip and move on to the next shipment line. In the next run,
2498: -- the shipment line that is marked as error, will be processed

Line 2653: IF l_return_status = FND_API.G_RET_STS_SUCCESS

2649:
2650: -- Bug 5364037: To validate that the OSA item is not Lot and/or
2651: -- Serial controlled in the TP Organization
2652:
2653: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2654: THEN
2655:
2656: Validate_Lot_Serial_Control
2657: ( p_item_id => l_comp_tbl(l_curr_index).inventory_item_id

Line 2664: l_return_status := FND_API.G_RET_STS_ERROR;

2660: );
2661:
2662: IF l_lot_serial_valid_flag = 'N'
2663: THEN
2664: l_return_status := FND_API.G_RET_STS_ERROR;
2665: END IF;
2666:
2667: IF g_log_enabled AND
2668: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2697: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

2693: END IF;
2694: END IF;
2695:
2696: /* if component validation passed */
2697: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
2698: THEN
2699: -- Load the Components table.
2700:
2701: IF NVL(l_count_seq, 0) = 0

Line 2798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2794:
2795: -- If the return status from Process_Replenishment_SO (doing Price Quote)
2796: -- is not success, move on to the next shipment line
2797: /*
2798: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2799: THEN
2800:
2801: -- Update the interlock_status of the current Subcontracting Order to 'E',
2802: -- signifying that some errors occurred when loading the components

Line 2849: END IF; /* IF (l_return_status = FND_API.G_RET_STS_SUCCESS) */

2845: -- Skip current Subcontracting Order (since component validation failed) and
2846: -- move on to the next Order
2847: EXIT;
2848:
2849: END IF; /* IF (l_return_status = FND_API.G_RET_STS_SUCCESS) */
2850:
2851: END IF; /* IF l_comp_tbl(l_curr_index).wip_supply_type = 6 */
2852:
2853: l_curr_index := l_comp_tbl.next(l_curr_index);

Line 2858: END IF; /* IF l_return_status <> FND_API.G_RET_STS_SUCCESS*/

2854: EXIT WHEN l_curr_index IS NULL;
2855:
2856: END LOOP; /* End of FOR LOOP iterating l_comp_tbl */
2857:
2858: END IF; /* IF l_return_status <> FND_API.G_RET_STS_SUCCESS*/
2859:
2860: ELSE /* IF l_routing_count <= 0 */
2861:
2862: IF g_log_enabled AND

Line 2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2916: END IF;
2917:
2918: FND_MESSAGE.set_name('JMF', 'JMF_SHIKYU_COMP_LD_ERR');
2919: FND_MSG_PUB.add;
2920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2921:
2922: END Load_Shikyu_Components;
2923:
2924: --========================================================================

Line 3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3069: END IF;
3070:
3071: FND_MESSAGE.set_name('JMF', 'JMF_SHK_STAMP_COMP_PRICE_ERR');
3072: FND_MSG_PUB.add;
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074:
3075: END Stamp_Null_Shikyu_Comp_Prices;
3076:
3077: --========================================================================

Line 3243: IF l_return_status = FND_API.G_RET_STS_SUCCESS

3239: , p_quantity => l_quantity
3240: , x_return_status => l_return_status
3241: );
3242:
3243: IF l_return_status = FND_API.G_RET_STS_SUCCESS
3244: THEN
3245: -- If WIP job is created, update with the WIP job id
3246:
3247: SELECT wip_entity_id

Line 3541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3537: );
3538: END IF;
3539: END IF;
3540:
3541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3542: THEN
3543: IF g_log_enabled THEN
3544: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3545: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

Line 3651: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE) ) THEN

3647: );
3648: END IF;
3649:
3650: -- Initialize message list if p_init_msg_list is set to TRUE
3651: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE) ) THEN
3652: FND_MSG_PUB.initialize;
3653: END IF;
3654:
3655: -- If SHIKYU is not enabled, do not process the records.

Line 3718: WHEN FND_API.G_EXC_ERROR THEN

3714: END IF;
3715:
3716: EXCEPTION
3717:
3718: WHEN FND_API.G_EXC_ERROR THEN
3719: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INTERLK_MGR_ERR');
3720: FND_MSG_PUB.add;
3721: FND_MSG_PUB.Count_And_Get
3722: ( p_count => l_msg_count

Line 3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3787: END IF;
3788:
3789: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INTERLK_WRKR_ERR');
3790: FND_MSG_PUB.add;
3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3792:
3793: END Subcontract_Orders_Worker;
3794:
3795: END JMF_SUBCONTRACT_ORDERS_PVT;