DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on FND_API

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

728: END IF ;
729: END IF ;
730:
731: IF Is_Valid_Location(p_organization_id, l_subcontracting_type)
732: AND ((l_osa_flag =1) AND (l_return_status = FND_API.G_RET_STS_SUCCESS))
733: THEN
734:
735: -- To check if the OEM/TP relationship exists, check the cache to see
736: -- if the OEM/TP combn exists. If it does, get the status from the

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

850: );
851: END IF;
852: END IF;
853:
854: IF ((l_osa_flag <>1) OR (l_return_status <> FND_API.G_RET_STS_SUCCESS))
855: THEN
856: x_valid_flag := 'N';
857: ELSE
858:

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

1141: , x_outsourced_assembly => l_osa_flag
1142: , x_subcontracting_component => l_comp_flag
1143: );
1144:
1145: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1146: (l_comp_flag IN (1,2))
1147: THEN
1148: -- Check if the Shikyu component flag is enabled at the TP orgn
1149:

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

1158: , x_outsourced_assembly => l_osa_flag
1159: , x_subcontracting_component => l_comp_flag
1160: );
1161:
1162: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1163: (l_comp_flag IN (1,2))
1164: THEN
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166: ELSE

Line 1165: x_return_status := FND_API.G_RET_STS_SUCCESS;

1161:
1162: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
1163: (l_comp_flag IN (1,2))
1164: THEN
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166: ELSE
1167: x_return_status := FND_API.G_RET_STS_ERROR;
1168: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1169: FND_MSG_PUB.add;

Line 1167: x_return_status := FND_API.G_RET_STS_ERROR;

1163: (l_comp_flag IN (1,2))
1164: THEN
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166: ELSE
1167: x_return_status := FND_API.G_RET_STS_ERROR;
1168: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1169: FND_MSG_PUB.add;
1170:
1171: IF g_log_enabled AND

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

1183: END IF;
1184:
1185: END IF;
1186: ELSE
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: FND_MESSAGE.set_name('JMF', 'JMF_SHK_COMP_ATTR_ERR');
1189: FND_MSG_PUB.add;
1190:
1191: IF g_log_enabled AND

Line 1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1754: END IF;
1755:
1756: FND_MESSAGE.set_name('JMF', 'JMF_SHK_OSA_LD_ERR');
1757: FND_MSG_PUB.add;
1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759:
1760: END Load_Subcontract_Orders;
1761:
1762: --========================================================================

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

2051: );
2052: END IF;
2053: END IF;
2054:
2055: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
2056: (l_comp_flag = 1) -- Pre-positioned
2057: THEN
2058:
2059: l_additional_supply := 'N';

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

2057: THEN
2058:
2059: l_additional_supply := 'N';
2060:
2061: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
2062: (l_comp_flag = 2) -- sync-ship
2063: THEN
2064:
2065: -- This indicates that there are PO's that are created but not picked

Line 2111: IF l_return_status = FND_API.G_RET_STS_SUCCESS

2107: || l_order_line_id
2108: );
2109: END IF;
2110:
2111: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2112: THEN
2113:
2114: SELECT header_id
2115: , schedule_ship_date

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

2273: END IF;
2274:
2275: END IF;
2276:
2277: END IF; /* IF l_return_status = FND_API.G_RET_STS_SUCCESS */
2278:
2279: END LOOP;
2280:
2281: --Bugfix 9315131

Line 2356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2352: , p_qty => l_qty
2353: , p_skip_po_replen_creation => NVL(l_replen_so_creation_failed, 'N')
2354: );
2355:
2356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2357: THEN
2358:
2359: IF g_log_enabled
2360: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

2364: , '>> ' || l_program || ': Allocation Failed'
2365: );
2366: END IF;
2367:
2368: END IF; /* IF l_return_status <> FND_API.G_RET_STS_SUCCESS */
2369:
2370: --Debug changes for bugfix 9315131
2371: IF g_log_enabled
2372: AND (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2728: , p_initMsgList => fnd_api.g_false

2724: , p_txnDate => l_start_date
2725: , p_implFlag => 2
2726: , p_projectID => l_osa_tbl(i).project_id
2727: , p_taskID => l_osa_tbl(i).task_id
2728: , p_initMsgList => fnd_api.g_false
2729: , p_endDebug => fnd_api.g_true
2730: , x_compTbl => l_comp_tbl
2731: , x_returnStatus => l_return_status);
2732:

Line 2729: , p_endDebug => fnd_api.g_true

2725: , p_implFlag => 2
2726: , p_projectID => l_osa_tbl(i).project_id
2727: , p_taskID => l_osa_tbl(i).task_id
2728: , p_initMsgList => fnd_api.g_false
2729: , p_endDebug => fnd_api.g_true
2730: , x_compTbl => l_comp_tbl
2731: , x_returnStatus => l_return_status);
2732:
2733: IF g_log_enabled THEN

Line 2748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR

2744: -- if WIP Explode Requirements erred out
2745: -- Bugfix 9315131: Adding an OR condition. The else used to fail
2746: -- with ORA-06502: PL/SQL: numeric or value error: NULL index table key value
2747: -- if OSA didn't have any BOM.
2748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR
2749: l_comp_tbl.COUNT = 0
2750: THEN
2751: -- Error in bom explosion. Mark the shipment line status as error.
2752: -- Skip and move on to the next shipment line. In the next run,

Line 2925: IF l_return_status = FND_API.G_RET_STS_SUCCESS

2921:
2922: -- Bug 5364037: To validate that the OSA item is not Lot and/or
2923: -- Serial controlled in the TP Organization
2924:
2925: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2926: THEN
2927:
2928: Validate_Lot_Serial_Control
2929: ( p_item_id => l_comp_tbl(l_curr_index).inventory_item_id

Line 2936: l_return_status := FND_API.G_RET_STS_ERROR;

2932: );
2933:
2934: IF l_lot_serial_valid_flag = 'N'
2935: THEN
2936: l_return_status := FND_API.G_RET_STS_ERROR;
2937: END IF;
2938:
2939: IF g_log_enabled AND
2940: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 2969: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

2965: END IF;
2966: END IF;
2967:
2968: /* if component validation passed */
2969: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
2970: THEN
2971: -- Load the Components table.
2972:
2973: IF NVL(l_count_seq, 0) = 0

Line 3070: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3066:
3067: -- If the return status from Process_Replenishment_SO (doing Price Quote)
3068: -- is not success, move on to the next shipment line
3069: /*
3070: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3071: THEN
3072:
3073: -- Update the interlock_status of the current Subcontracting Order to 'E',
3074: -- signifying that some errors occurred when loading the components

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

3117: -- Skip current Subcontracting Order (since component validation failed) and
3118: -- move on to the next Order
3119: EXIT;
3120:
3121: END IF; /* IF (l_return_status = FND_API.G_RET_STS_SUCCESS) */
3122:
3123: END IF; /* IF l_comp_tbl(l_curr_index).wip_supply_type = 6 */
3124:
3125: l_curr_index := l_comp_tbl.next(l_curr_index);

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

3126: EXIT WHEN l_curr_index IS NULL;
3127:
3128: END LOOP; /* End of FOR LOOP iterating l_comp_tbl */
3129:
3130: END IF; /* IF l_return_status <> FND_API.G_RET_STS_SUCCESS*/
3131:
3132: ELSE /* IF l_routing_count <= 0 */
3133:
3134: IF g_log_enabled AND

Line 3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3188: END IF;
3189:
3190: FND_MESSAGE.set_name('JMF', 'JMF_SHIKYU_COMP_LD_ERR');
3191: FND_MSG_PUB.add;
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193:
3194: END Load_Shikyu_Components;
3195:
3196: --========================================================================

Line 3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3346: END IF;
3347:
3348: FND_MESSAGE.set_name('JMF', 'JMF_SHK_STAMP_COMP_PRICE_ERR');
3349: FND_MSG_PUB.add;
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351:
3352: END Stamp_Null_Shikyu_Comp_Prices;
3353:
3354: --========================================================================

Line 3520: IF l_return_status = FND_API.G_RET_STS_SUCCESS

3516: , p_quantity => l_quantity
3517: , x_return_status => l_return_status
3518: );
3519:
3520: IF l_return_status = FND_API.G_RET_STS_SUCCESS
3521: THEN
3522: -- If WIP job is created, update with the WIP job id
3523:
3524: SELECT wip_entity_id

Line 3844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3840: );
3841: END IF;
3842: END IF;
3843:
3844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3845: THEN
3846: IF g_log_enabled THEN
3847: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3848: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

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

3990: --End OM debugging.
3991: END IF;
3992:
3993: -- Initialize message list if p_init_msg_list is set to TRUE
3994: IF FND_API.to_boolean(NVL(p_init_msg_list, FND_API.G_FALSE) ) THEN
3995: FND_MSG_PUB.initialize;
3996: END IF;
3997:
3998: -- If SHIKYU is not enabled, do not process the records.

Line 4065: WHEN FND_API.G_EXC_ERROR THEN

4061: END IF;
4062:
4063: EXCEPTION
4064:
4065: WHEN FND_API.G_EXC_ERROR THEN
4066: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INTERLK_MGR_ERR');
4067: FND_MSG_PUB.add;
4068: FND_MSG_PUB.Count_And_Get
4069: ( p_count => l_msg_count

Line 4138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4134: END IF;
4135:
4136: FND_MESSAGE.set_name('JMF', 'JMF_SHK_INTERLK_WRKR_ERR');
4137: FND_MSG_PUB.add;
4138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4139:
4140: END Subcontract_Orders_Worker;
4141:
4142: END JMF_SUBCONTRACT_ORDERS_PVT;