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

Line 765: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;

761:
762: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;
763: l_ret_status VARCHAR2(100);
764: l_valid_pack_type NUMBER := 0;
765: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;
766: l_old_gdsn_flag VARCHAR2(1);
767: l_is_primary_uom_base VARCHAR2(1);
768: l_err_text VARCHAR2(1000);
769: l_ego_exists VARCHAR2(1) := 'N';

Line 784: l_valid VARCHAR2(100) := FND_API.G_TRUE;

780: l_old_catalog_group_id NUMBER;
781: l_approval_status VARCHAR2(1);
782: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
783: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
784: l_valid VARCHAR2(100) := FND_API.G_TRUE;
785: l_is_gdsn NUMBER;
786: l_unit_wt_disp_name VARCHAR2(1000);
787: l_unit_wt_uom_disp_name VARCHAR2(1000);
788: l_gtid_disp_name VARCHAR2(1000);

Line 925: IF (l_valid <> FND_API.G_TRUE) THEN

921: THEN
922: l_valid := EGO_GTIN_PVT.Validate_Unit_Wt_Uom(p_inventory_item_id => cur.inventory_item_id,
923: p_org_id => cur.organization_id );
924:
925: IF (l_valid <> FND_API.G_TRUE) THEN
926: l_unit_wt_disp_name := Get_Attr_Display_Name('EGO_MASTER_ITEMS', 'PhysicalAttributes' , 'UNIT_WEIGHT');
927: l_unit_wt_uom_disp_name := Get_Attr_Display_Name('EGO_MASTER_ITEMS', 'PhysicalAttributes' , 'WEIGHT_UOM_CODE');
928: l_gtid_disp_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Description' , 'Trade_Item_Descriptor');
929: FND_MESSAGE.SET_NAME ( 'EGO', 'EGO_2ATTRS_NOT_EDITABLE');

Line 999: ,P_COMMIT => FND_API.G_FALSE

995: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id
996: ,P_NEW_LIFECYCLE_ID => cur.lifecycle_id
997: ,P_NEW_PHASE_ID => cur.current_phase_id
998: ,P_NEW_ITEM_STATUS_CODE => cur.inventory_item_status_code
999: ,P_COMMIT => FND_API.G_FALSE
1000: ,X_RETURN_STATUS => X_RETURN_STATUS
1001: ,X_MSG_COUNT => X_MSG_COUNT
1002: ,X_MSG_DATA => X_MSG_DATA );
1003:

Line 1005: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1001: ,X_MSG_COUNT => X_MSG_COUNT
1002: ,X_MSG_DATA => X_MSG_DATA );
1003:
1004: /* Bug 5389029 - Passing the right arguments for clear error log */
1005: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1006: l_error_logged := INVPUOPI.mtl_log_interface_err(
1007: cur.organization_id,
1008: P_User_Id,
1009: P_Login_Id,

Line 1064: END IF; -- X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS

1060: Raise LOGGING_ERR;
1061: END IF;
1062: l_error_status := 1;
1063: END IF;
1064: END IF; -- X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS
1065: END IF; -- (l_old_catalog_group_id <> cur.item_catalog_group_id)
1066: END IF; --(cur.item_catalog_group_id IS NOT NULL)
1067:
1068: /* Pack Item Type Validations */

Line 1169: IF l_item_in_pack = FND_API.G_TRUE THEN

1165: STRUCT_TYPE => 'Packaging Hierarchy',
1166: PREFERRED_ONLY => 2 ,
1167: USED_IN_STRUCTURE => l_item_in_pack);
1168:
1169: IF l_item_in_pack = FND_API.G_TRUE THEN
1170: l_error_logged := INVPUOPI.mtl_log_interface_err (
1171: Cur.organization_id,
1172: P_User_Id,
1173: P_Login_Id,

Line 1195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1191: ,x_return_status => x_return_status
1192: ,x_msg_count => x_msg_count
1193: ,x_msg_data => x_msg_data);
1194:
1195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1196: l_error_logged := INVPUOPI.mtl_log_interface_err (
1197: Cur.organization_id,
1198: P_User_Id,
1199: P_Login_Id,

Line 1309: IF (l_valid <> FND_API.G_TRUE) THEN

1305: THEN
1306: l_valid := EGO_GTIN_PVT.Validate_Unit_Wt_Uom(p_inventory_item_id => cur.inventory_item_id,
1307: p_org_id => cur.organization_id );
1308:
1309: IF (l_valid <> FND_API.G_TRUE) THEN
1310: FND_MESSAGE.SET_NAME ( 'EGO', 'EGO_ATTR_NOT_EDITABLE');
1311: FND_MESSAGE.SET_TOKEN ('ATTR_NAME', 'UNIT WEIGHT AND WEIGHT_UOM_CODE');
1312: FND_MESSAGE.SET_TOKEN ('GTID', 'TRADE ITEM DESCRIPTOR');
1313: l_error_msg := FND_MESSAGE.GET;

Line 1381: ,P_COMMIT => FND_API.G_FALSE

1377: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id
1378: ,P_NEW_LIFECYCLE_ID => cur.lifecycle_id
1379: ,P_NEW_PHASE_ID => cur.current_phase_id
1380: ,P_NEW_ITEM_STATUS_CODE => cur.inventory_item_status_code
1381: ,P_COMMIT => FND_API.G_FALSE
1382: ,X_RETURN_STATUS => X_RETURN_STATUS
1383: ,X_MSG_COUNT => X_MSG_COUNT
1384: ,X_MSG_DATA => X_MSG_DATA );
1385:

Line 1387: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1383: ,X_MSG_COUNT => X_MSG_COUNT
1384: ,X_MSG_DATA => X_MSG_DATA );
1385:
1386: /* Bug 5389029 - Passing the right arguments for clear error log */
1387: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1388: l_error_logged := INVPUOPI.mtl_log_interface_err(
1389: cur.organization_id,
1390: P_User_Id,
1391: P_Login_Id,

Line 1551: IF l_item_in_pack = FND_API.G_TRUE THEN

1547: STRUCT_TYPE => 'Packaging Hierarchy',
1548: PREFERRED_ONLY => 2 ,
1549: USED_IN_STRUCTURE => l_item_in_pack);
1550:
1551: IF l_item_in_pack = FND_API.G_TRUE THEN
1552: l_error_logged := INVPUOPI.mtl_log_interface_err (
1553: Cur.organization_id,
1554: P_User_Id,
1555: P_Login_Id,

Line 1577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1573: ,x_return_status => x_return_status
1574: ,x_msg_count => x_msg_count
1575: ,x_msg_data => x_msg_data);
1576:
1577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1578: l_error_logged := INVPUOPI.mtl_log_interface_err (
1579: Cur.organization_id,
1580: P_User_Id,
1581: P_Login_Id,

Line 2109: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2105: ,x_errorcode => l_error_code
2106: ,x_msg_count => l_msg_count
2107: ,x_msg_data => l_msg_data);
2108:
2109: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2110:
2111: UPDATE mtl_system_items_interface
2112: SET process_flag = 3
2113: WHERE rowid = cur.rowid;

Line 2255: p_commit => FND_API.G_FALSE,

2251: BEGIN
2252: IF (p_attribute_name IS NULL) THEN --Insert
2253: EGO_TEMPL_ATTRS_PUB.Sync_Template(
2254: p_template_id => p_template_id,
2255: p_commit => FND_API.G_FALSE,
2256: x_return_status => l_return_status,
2257: x_message_text => l_message_text);
2258: ELSE --Update
2259: EGO_TEMPL_ATTRS_PUB.Sync_Template_Attribute(

Line 2262: p_commit => FND_API.G_FALSE,

2258: ELSE --Update
2259: EGO_TEMPL_ATTRS_PUB.Sync_Template_Attribute(
2260: p_template_id => p_template_id,
2261: p_attribute_name => p_attribute_name,
2262: p_commit => FND_API.G_FALSE,
2263: x_return_status => l_return_status,
2264: x_message_text => l_message_text);
2265: END IF;
2266: EXCEPTION

Line 2294: p_init_msg_list => FND_API.G_FALSE,

2290: p_application_id => 431,
2291: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,
2292: p_application_column_name => p_application_column_name,
2293: p_control_level => p_control_level,
2294: p_init_msg_list => FND_API.G_FALSE,
2295: p_commit => FND_API.G_FALSE,
2296: x_return_status => l_return_status,
2297: x_msg_count => l_message_count,
2298: x_msg_data => l_msg_data);

Line 2295: p_commit => FND_API.G_FALSE,

2291: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,
2292: p_application_column_name => p_application_column_name,
2293: p_control_level => p_control_level,
2294: p_init_msg_list => FND_API.G_FALSE,
2295: p_commit => FND_API.G_FALSE,
2296: x_return_status => l_return_status,
2297: x_msg_count => l_message_count,
2298: x_msg_data => l_msg_data);
2299: EXCEPTION

Line 2400: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_TRUE '

2396: ||' ,P_LIFECYCLE_ID => NULL '
2397: ||' ,P_LIFECYCLE_PHASE_ID => NULL '
2398: ||' ,P_LIFECYCLE_CHANGED => NULL '
2399: ||' ,P_LIFECYCLE_PHASE_CHANGED => NULL '
2400: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_TRUE '
2401: ||' ,X_RETURN_STATUS => :l_return_status '
2402: ||' ,X_MSG_COUNT => :l_msg_count '
2403: ||' ,X_MSG_DATA => :l_msg_text); '
2404: ||' EXCEPTION '

Line 2433: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '

2429: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2430: ||' ,P_ITEM_REVISION_ID => NULL '
2431: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2432: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2433: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2434: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2435: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2436: ||' ,X_RETURN_STATUS => :l_return_status '
2437: ||' ,X_MSG_COUNT => :l_msg_count '

Line 2434: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '

2430: ||' ,P_ITEM_REVISION_ID => NULL '
2431: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2432: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2433: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2434: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2435: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2436: ||' ,X_RETURN_STATUS => :l_return_status '
2437: ||' ,X_MSG_COUNT => :l_msg_count '
2438: ||' ,X_MSG_DATA => :l_msg_text); '

Line 2435: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '

2431: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2432: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2433: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2434: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2435: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2436: ||' ,X_RETURN_STATUS => :l_return_status '
2437: ||' ,X_MSG_COUNT => :l_msg_count '
2438: ||' ,X_MSG_DATA => :l_msg_text); '
2439: ||' EXCEPTION '

Line 2466: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '

2462: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2463: ||' ,P_ITEM_REVISION_ID => NULL '
2464: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2465: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2466: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2467: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2468: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2469: ||' ,X_RETURN_STATUS => :l_return_status '
2470: ||' ,X_MSG_COUNT => :l_msg_count '

Line 2467: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '

2463: ||' ,P_ITEM_REVISION_ID => NULL '
2464: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2465: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2466: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2467: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2468: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2469: ||' ,X_RETURN_STATUS => :l_return_status '
2470: ||' ,X_MSG_COUNT => :l_msg_count '
2471: ||' ,X_MSG_DATA => :l_msg_text); '

Line 2468: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '

2464: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2465: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2466: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2467: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2468: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2469: ||' ,X_RETURN_STATUS => :l_return_status '
2470: ||' ,X_MSG_COUNT => :l_msg_count '
2471: ||' ,X_MSG_DATA => :l_msg_text); '
2472: ||' EXCEPTION '

Line 2485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2481: OUT l_msg_count,
2482: OUT l_msg_text;
2483: END IF;
2484:
2485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2486:
2487: UPDATE mtl_system_items_interface
2488: SET process_flag = 3
2489: WHERE rowid = cur.rowid;

Line 2536: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '

2532: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2533: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2534: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2535: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2536: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2537: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2538: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2539: ||' ,X_RETURN_STATUS => :l_return_status '
2540: ||' ,X_MSG_COUNT => :l_msg_count '

Line 2537: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '

2533: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2534: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2535: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2536: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2537: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2538: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2539: ||' ,X_RETURN_STATUS => :l_return_status '
2540: ||' ,X_MSG_COUNT => :l_msg_count '
2541: ||' ,X_MSG_DATA => :l_msg_text); '

Line 2538: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '

2534: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2535: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2536: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2537: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2538: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2539: ||' ,X_RETURN_STATUS => :l_return_status '
2540: ||' ,X_MSG_COUNT => :l_msg_count '
2541: ||' ,X_MSG_DATA => :l_msg_text); '
2542: ||' EXCEPTION '

Line 2570: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '

2566: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2567: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2568: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2569: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2570: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2571: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2572: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2573: ||' ,X_RETURN_STATUS => :l_return_status '
2574: ||' ,X_MSG_COUNT => :l_msg_count '

Line 2571: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '

2567: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2568: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2569: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2570: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2571: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2572: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2573: ||' ,X_RETURN_STATUS => :l_return_status '
2574: ||' ,X_MSG_COUNT => :l_msg_count '
2575: ||' ,X_MSG_DATA => :l_msg_text); '

Line 2572: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '

2568: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2569: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2570: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2571: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2572: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2573: ||' ,X_RETURN_STATUS => :l_return_status '
2574: ||' ,X_MSG_COUNT => :l_msg_count '
2575: ||' ,X_MSG_DATA => :l_msg_text); '
2576: ||' EXCEPTION '

Line 2590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2586: OUT l_msg_count,
2587: OUT l_msg_text;
2588: END IF;
2589:
2590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2591:
2592: UPDATE mtl_item_revisions_interface
2593: SET process_flag = 3
2594: WHERE rowid = cur.rowid;

Line 2937: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS )THEN

2933: x_return_status => l_ret_status,
2934: x_msg_data => l_msg_data,
2935: x_msg_count => l_msg_count );
2936:
2937: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS )THEN
2938: UPDATE mtl_system_items_interface
2939: SET process_flag = 4
2940: WHERE set_process_id = p_set_process_id
2941: AND process_flag = 5;

Line 3080: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN

3076: ,'ITEM_NUMBER'
3077: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3078: ,'INV_IOI_NO_AUTO_NIR'
3079: ,err_text);
3080: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3081: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3082: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3083: SET process_flag = 3
3084: WHERE rowid = i.rowid;

Line 3162: x_return_status := FND_API.G_RET_STS_SUCCESS;

3158: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3159:
3160: l_sql VARCHAR2(1000);
3161: BEGIN
3162: x_return_status := FND_API.G_RET_STS_SUCCESS;
3163: x_msg_count := 0;
3164: x_msg_data := NULL;
3165: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
3166: INV_ITEM_UTIL.Object_Exists

Line 3194: x_return_status := FND_API.G_RET_STS_ERROR;

3190: OUT x_msg_data;
3191:
3192: EXCEPTION
3193: WHEN OTHERS THEN
3194: x_return_status := FND_API.G_RET_STS_ERROR;
3195: x_msg_count := 1;
3196: x_msg_data := SQLERRM;
3197: END Populate_Seq_Gen_Item_Nums;
3198:

Line 3252: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;

3248: l_cursor_id NUMBER;
3249: l_error_table Error_Handler.Error_Tbl_Type;
3250: l_change_id NUMBER;
3251: l_change_notice VARCHAR2(100);
3252: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
3253: l_pk1_value VARCHAR2(100);
3254: l_raise_create_nir BOOLEAN := FALSE;
3255: l_raise_cancel_nir BOOLEAN := FALSE;
3256: l_update_msb BOOLEAN := FALSE;

Line 3391: ,p_auto_commit => FND_API.G_FALSE

3387: Cancel_New_Item_Request(
3388: p_inventory_item_id => p_inventory_item_id
3389: ,p_organization_id => p_organization_id
3390: ,p_item_number => p_item_number
3391: ,p_auto_commit => FND_API.G_FALSE
3392: ,p_wf_user_id => p_user_id
3393: ,p_fnd_user_id => p_login_id
3394: ,x_return_status => l_return_status );
3395:

Line 3396: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3392: ,p_wf_user_id => p_user_id
3393: ,p_fnd_user_id => p_login_id
3394: ,x_return_status => l_return_status );
3395:
3396: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3397: l_error_occured := TRUE;
3398:
3399: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3400: SET process_flag = 3

Line 3416: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN

3412: 'ITEM_CATALOG_GORUP_ID',
3413: 'MTL_SYSTEM_ITEMS_INTERFACE',
3414: 'INV_IOI_CANCEL_NIR_FAILED',
3415: x_err_text);
3416: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3417: l_error_occured := TRUE;
3418: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3419:
3420: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 3470: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN

3466: ,'ITEM_NUMBER'
3467: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3468: ,'INV_IOI_NO_AUTO_NIR'
3469: ,x_err_text);
3470: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3471: l_error_occured := TRUE;
3472: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3473: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3474: SET process_flag = 3

Line 3531: x_return_status := FND_API.G_RET_STS_SUCCESS;

3527: l_nir_cancel_status VARCHAR2(10);
3528:
3529: BEGIN
3530:
3531: x_return_status := FND_API.G_RET_STS_SUCCESS;
3532: dumm_status := INVUPD2B.get_message('EGO_NIR_CANCEL_COMMENT', l_translated_text);
3533:
3534: ENG_NIR_UTIL_PKG.Cancel_nir_for_item(
3535: p_item_id => p_inventory_item_id

Line 3570: x_return_status := FND_API.G_RET_STS_ERROR;

3566: IN l_translated_text,
3567: OUT l_nir_cancel_status; */
3568: EXCEPTION
3569: WHEN others THEN
3570: x_return_status := FND_API.G_RET_STS_ERROR;
3571: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Cancel_NIR: Exception'||substr(SQLERRM,1,200));
3572: END Cancel_New_Item_Request;
3573:
3574: /* Obsoleting this procedure and recreating it below with new NIR create signature for R12 FPC

Line 3588: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;

3584: l_dynamic_sql VARCHAR2(2000);
3585: l_dummy NUMBER;
3586: l_cursor_id NUMBER;
3587: l_error_table Error_Handler.Error_Tbl_Type;
3588: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
3589: BEGIN
3590:
3591: SELECT organization_code INTO l_org_code
3592: FROM mtl_parameters

Line 3636: l_return_status := FND_API.G_RET_STS_ERROR;

3632: IN l_type_name,
3633: IN l_org_code,
3634: OUT l_return_status;
3635: ELSE
3636: l_return_status := FND_API.G_RET_STS_ERROR;
3637: END IF;
3638: x_return_status := l_return_status;
3639: IF l_cursor_id IS NOT NULL THEN
3640: dbms_sql.close_cursor(l_cursor_id);

Line 3644: x_return_status := FND_API.G_RET_STS_ERROR;

3640: dbms_sql.close_cursor(l_cursor_id);
3641: END IF;
3642: EXCEPTION
3643: WHEN others THEN
3644: x_return_status := FND_API.G_RET_STS_ERROR;
3645: IF l_cursor_id IS NOT NULL THEN
3646: dbms_sql.close_cursor(l_cursor_id);
3647: END IF;
3648: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));

Line 3686: IF (l_return_status = FND_API.G_RET_STS_SUCCESS )THEN

3682: ,x_msg_count => l_msg_count);
3683:
3684: x_return_status := l_return_status;
3685:
3686: IF (l_return_status = FND_API.G_RET_STS_SUCCESS )THEN
3687: UPDATE mtl_system_items_interface
3688: SET process_flag = p_process_flag
3689: WHERE rowid = p_row_id;
3690: ELSE

Line 3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3705: IF l_inv_debug_level IN(101, 102) THEN
3706: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3707: END IF;
3708:
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3710:
3711: UPDATE mtl_system_items_interface
3712: SET process_flag = 3,
3713: change_id = NULL,