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 774: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;

770: l_valid_status VARCHAR2(1) := 'N';
771: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;
772: l_ret_status VARCHAR2(100);
773: l_valid_pack_type NUMBER := 0;
774: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;
775: l_old_gdsn_flag VARCHAR2(1);
776: l_is_primary_uom_base VARCHAR2(1);
777: l_err_text VARCHAR2(1000);
778: l_ego_exists VARCHAR2(1) := 'N';

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

789: l_old_catalog_group_id NUMBER;
790: l_approval_status VARCHAR2(1);
791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
793: l_valid VARCHAR2(100) := FND_API.G_TRUE;
794: l_is_gdsn NUMBER;
795: l_unit_wt_disp_name VARCHAR2(1000);
796: l_unit_wt_uom_disp_name VARCHAR2(1000);
797: l_gtid_disp_name VARCHAR2(1000);

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

977: THEN
978: l_valid := EGO_GTIN_PVT.Validate_Unit_Wt_Uom(p_inventory_item_id => cur.inventory_item_id,
979: p_org_id => cur.organization_id );
980:
981: IF (l_valid <> FND_API.G_TRUE) THEN
982: l_unit_wt_disp_name := Get_Attr_Display_Name('EGO_MASTER_ITEMS', 'PhysicalAttributes' , 'UNIT_WEIGHT');
983: l_unit_wt_uom_disp_name := Get_Attr_Display_Name('EGO_MASTER_ITEMS', 'PhysicalAttributes' , 'WEIGHT_UOM_CODE');
984: l_gtid_disp_name := Get_Attr_Display_Name('EGO_ITEM_GTIN_ATTRS', 'Trade_Item_Description' , 'Trade_Item_Descriptor');
985: FND_MESSAGE.SET_NAME ( 'EGO', 'EGO_2ATTRS_NOT_EDITABLE');

Line 1056: ,P_COMMIT => FND_API.G_FALSE

1052: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id
1053: ,P_NEW_LIFECYCLE_ID => cur.lifecycle_id
1054: ,P_NEW_PHASE_ID => cur.current_phase_id
1055: ,P_NEW_ITEM_STATUS_CODE => cur.inventory_item_status_code
1056: ,P_COMMIT => FND_API.G_FALSE
1057: ,X_RETURN_STATUS => X_RETURN_STATUS
1058: ,X_MSG_COUNT => X_MSG_COUNT
1059: ,X_MSG_DATA => X_MSG_DATA );
1060:

Line 1062: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1058: ,X_MSG_COUNT => X_MSG_COUNT
1059: ,X_MSG_DATA => X_MSG_DATA );
1060:
1061: /* Bug 5389029 - Passing the right arguments for clear error log */
1062: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1063: l_error_logged := INVPUOPI.mtl_log_interface_err(
1064: cur.organization_id,
1065: P_User_Id,
1066: P_Login_Id,

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

1117: Raise LOGGING_ERR;
1118: END IF;
1119: l_error_status := 1;
1120: END IF;
1121: END IF; -- X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS
1122: -- Bug 11768298 : Start
1123: -- If the ICC is not getting changed, checkif LC or LCP are getting changed then handle the LC/LCP change
1124: -- for master and child orgs also.
1125: ELSE

Line 1135: p_commit => FND_API.G_FALSE,

1131: p_new_catalog_category_id => cur.item_catalog_group_id,
1132: p_new_lifecycle_id => cur.lifecycle_id,
1133: p_new_phase_id => cur.current_phase_id,
1134: p_new_item_status_code => cur.inventory_item_status_code,
1135: p_commit => FND_API.G_FALSE,
1136: x_return_status => x_return_status,
1137: x_msg_data => x_msg_data,
1138: x_msg_count => x_msg_count);
1139:

Line 1140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1136: x_return_status => x_return_status,
1137: x_msg_data => x_msg_data,
1138: x_msg_count => x_msg_count);
1139:
1140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1141: l_error_logged := INVPUOPI.mtl_log_interface_err(
1142: cur.organization_id,
1143: P_User_Id,
1144: P_Login_Id,

Line 1266: IF l_item_in_pack = FND_API.G_TRUE THEN

1262: STRUCT_TYPE => 'Packaging Hierarchy',
1263: PREFERRED_ONLY => 2 ,
1264: USED_IN_STRUCTURE => l_item_in_pack);
1265:
1266: IF l_item_in_pack = FND_API.G_TRUE THEN
1267: l_error_logged := INVPUOPI.mtl_log_interface_err (
1268: Cur.organization_id,
1269: P_User_Id,
1270: P_Login_Id,

Line 1292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1288: ,x_return_status => x_return_status
1289: ,x_msg_count => x_msg_count
1290: ,x_msg_data => x_msg_data);
1291:
1292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1293: l_error_logged := INVPUOPI.mtl_log_interface_err (
1294: Cur.organization_id,
1295: P_User_Id,
1296: P_Login_Id,

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

1403: THEN
1404: l_valid := EGO_GTIN_PVT.Validate_Unit_Wt_Uom(p_inventory_item_id => cur.inventory_item_id,
1405: p_org_id => cur.organization_id );
1406:
1407: IF (l_valid <> FND_API.G_TRUE) THEN
1408: FND_MESSAGE.SET_NAME ( 'EGO', 'EGO_ATTR_NOT_EDITABLE');
1409: FND_MESSAGE.SET_TOKEN ('ATTR_NAME', 'UNIT WEIGHT AND WEIGHT_UOM_CODE');
1410: FND_MESSAGE.SET_TOKEN ('GTID', 'TRADE ITEM DESCRIPTOR');
1411: l_error_msg := FND_MESSAGE.GET;

Line 1479: ,P_COMMIT => FND_API.G_FALSE

1475: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id
1476: ,P_NEW_LIFECYCLE_ID => cur.lifecycle_id
1477: ,P_NEW_PHASE_ID => cur.current_phase_id
1478: ,P_NEW_ITEM_STATUS_CODE => cur.inventory_item_status_code
1479: ,P_COMMIT => FND_API.G_FALSE
1480: ,X_RETURN_STATUS => X_RETURN_STATUS
1481: ,X_MSG_COUNT => X_MSG_COUNT
1482: ,X_MSG_DATA => X_MSG_DATA );
1483:

Line 1485: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1481: ,X_MSG_COUNT => X_MSG_COUNT
1482: ,X_MSG_DATA => X_MSG_DATA );
1483:
1484: /* Bug 5389029 - Passing the right arguments for clear error log */
1485: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1486: l_error_logged := INVPUOPI.mtl_log_interface_err(
1487: cur.organization_id,
1488: P_User_Id,
1489: P_Login_Id,

Line 1649: IF l_item_in_pack = FND_API.G_TRUE THEN

1645: STRUCT_TYPE => 'Packaging Hierarchy',
1646: PREFERRED_ONLY => 2 ,
1647: USED_IN_STRUCTURE => l_item_in_pack);
1648:
1649: IF l_item_in_pack = FND_API.G_TRUE THEN
1650: l_error_logged := INVPUOPI.mtl_log_interface_err (
1651: Cur.organization_id,
1652: P_User_Id,
1653: P_Login_Id,

Line 1675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1671: ,x_return_status => x_return_status
1672: ,x_msg_count => x_msg_count
1673: ,x_msg_data => x_msg_data);
1674:
1675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1676: l_error_logged := INVPUOPI.mtl_log_interface_err (
1677: Cur.organization_id,
1678: P_User_Id,
1679: P_Login_Id,

Line 2261: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2257: ,x_errorcode => l_error_code
2258: ,x_msg_count => l_msg_count
2259: ,x_msg_data => l_msg_data);
2260:
2261: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2262:
2263: UPDATE mtl_system_items_interface
2264: SET process_flag = 3
2265: WHERE rowid = cur.rowid;

Line 2407: p_commit => FND_API.G_FALSE,

2403: BEGIN
2404: IF (p_attribute_name IS NULL) THEN --Insert
2405: EGO_TEMPL_ATTRS_PUB.Sync_Template(
2406: p_template_id => p_template_id,
2407: p_commit => FND_API.G_FALSE,
2408: x_return_status => l_return_status,
2409: x_message_text => l_message_text);
2410: ELSE --Update
2411: EGO_TEMPL_ATTRS_PUB.Sync_Template_Attribute(

Line 2414: p_commit => FND_API.G_FALSE,

2410: ELSE --Update
2411: EGO_TEMPL_ATTRS_PUB.Sync_Template_Attribute(
2412: p_template_id => p_template_id,
2413: p_attribute_name => p_attribute_name,
2414: p_commit => FND_API.G_FALSE,
2415: x_return_status => l_return_status,
2416: x_message_text => l_message_text);
2417: END IF;
2418: EXCEPTION

Line 2446: p_init_msg_list => FND_API.G_FALSE,

2442: p_application_id => 431,
2443: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,
2444: p_application_column_name => p_application_column_name,
2445: p_control_level => p_control_level,
2446: p_init_msg_list => FND_API.G_FALSE,
2447: p_commit => FND_API.G_FALSE,
2448: x_return_status => l_return_status,
2449: x_msg_count => l_message_count,
2450: x_msg_data => l_msg_data);

Line 2447: p_commit => FND_API.G_FALSE,

2443: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,
2444: p_application_column_name => p_application_column_name,
2445: p_control_level => p_control_level,
2446: p_init_msg_list => FND_API.G_FALSE,
2447: p_commit => FND_API.G_FALSE,
2448: x_return_status => l_return_status,
2449: x_msg_count => l_message_count,
2450: x_msg_data => l_msg_data);
2451:

Line 2461: p_init_msg_list => FND_API.G_FALSE,

2457: p_application_id => 431,
2458: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,
2459: p_application_column_name => cur.att_name,
2460: p_control_level => p_control_level,
2461: p_init_msg_list => FND_API.G_FALSE,
2462: p_commit => FND_API.G_FALSE,
2463: x_return_status => l_return_status,
2464: x_msg_count => l_message_count,
2465: x_msg_data => l_msg_data);

Line 2462: p_commit => FND_API.G_FALSE,

2458: p_descriptive_flexfield_name => 'EGO_MASTER_ITEMS' ,
2459: p_application_column_name => cur.att_name,
2460: p_control_level => p_control_level,
2461: p_init_msg_list => FND_API.G_FALSE,
2462: p_commit => FND_API.G_FALSE,
2463: x_return_status => l_return_status,
2464: x_msg_count => l_message_count,
2465: x_msg_data => l_msg_data);
2466: END LOOP;

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

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

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

2600: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2601: ||' ,P_ITEM_REVISION_ID => NULL '
2602: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2603: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2604: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2605: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2606: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2607: ||' ,X_RETURN_STATUS => :l_return_status '
2608: ||' ,X_MSG_COUNT => :l_msg_count '

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

2601: ||' ,P_ITEM_REVISION_ID => NULL '
2602: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2603: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2604: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2605: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2606: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2607: ||' ,X_RETURN_STATUS => :l_return_status '
2608: ||' ,X_MSG_COUNT => :l_msg_count '
2609: ||' ,X_MSG_DATA => :l_msg_text); '

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

2602: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2603: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2604: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2605: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2606: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2607: ||' ,X_RETURN_STATUS => :l_return_status '
2608: ||' ,X_MSG_COUNT => :l_msg_count '
2609: ||' ,X_MSG_DATA => :l_msg_text); '
2610: ||' EXCEPTION '

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

2633: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2634: ||' ,P_ITEM_REVISION_ID => NULL '
2635: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2636: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2637: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2638: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2639: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2640: ||' ,X_RETURN_STATUS => :l_return_status '
2641: ||' ,X_MSG_COUNT => :l_msg_count '

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

2634: ||' ,P_ITEM_REVISION_ID => NULL '
2635: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2636: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2637: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2638: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2639: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2640: ||' ,X_RETURN_STATUS => :l_return_status '
2641: ||' ,X_MSG_COUNT => :l_msg_count '
2642: ||' ,X_MSG_DATA => :l_msg_text); '

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

2635: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2636: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2637: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2638: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2639: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2640: ||' ,X_RETURN_STATUS => :l_return_status '
2641: ||' ,X_MSG_COUNT => :l_msg_count '
2642: ||' ,X_MSG_DATA => :l_msg_text); '
2643: ||' EXCEPTION '

Line 2656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2652: OUT l_msg_count,
2653: OUT l_msg_text;
2654: END IF;
2655:
2656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2657:
2658: UPDATE mtl_system_items_interface
2659: SET process_flag = 3
2660: WHERE rowid = cur.rowid;

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

2703: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2704: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2705: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2706: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2707: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2708: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2709: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2710: ||' ,X_RETURN_STATUS => :l_return_status '
2711: ||' ,X_MSG_COUNT => :l_msg_count '

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

2704: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2705: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2706: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2707: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2708: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2709: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2710: ||' ,X_RETURN_STATUS => :l_return_status '
2711: ||' ,X_MSG_COUNT => :l_msg_count '
2712: ||' ,X_MSG_DATA => :l_msg_text); '

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

2705: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2706: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2707: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_TRUE '
2708: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2709: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2710: ||' ,X_RETURN_STATUS => :l_return_status '
2711: ||' ,X_MSG_COUNT => :l_msg_count '
2712: ||' ,X_MSG_DATA => :l_msg_text); '
2713: ||' EXCEPTION '

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

2737: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2738: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2739: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2740: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2741: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2742: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2743: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2744: ||' ,X_RETURN_STATUS => :l_return_status '
2745: ||' ,X_MSG_COUNT => :l_msg_count '

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

2738: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '
2739: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2740: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2741: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2742: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2743: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2744: ||' ,X_RETURN_STATUS => :l_return_status '
2745: ||' ,X_MSG_COUNT => :l_msg_count '
2746: ||' ,X_MSG_DATA => :l_msg_text); '

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

2739: ||' ,P_LIFECYCLE_ID => :cur.lifecycle_id '
2740: ||' ,P_LIFECYCLE_PHASE_ID => :cur.current_phase_id '
2741: ||' ,P_LIFECYCLE_CHANGED => FND_API.G_FALSE '
2742: ||' ,P_LIFECYCLE_PHASE_CHANGED => FND_API.G_TRUE '
2743: ||' ,P_PERFORM_SYNC_ONLY => FND_API.G_FALSE '
2744: ||' ,X_RETURN_STATUS => :l_return_status '
2745: ||' ,X_MSG_COUNT => :l_msg_count '
2746: ||' ,X_MSG_DATA => :l_msg_text); '
2747: ||' EXCEPTION '

Line 2761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2757: OUT l_msg_count,
2758: OUT l_msg_text;
2759: END IF;
2760:
2761: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2762:
2763: UPDATE mtl_item_revisions_interface
2764: SET process_flag = 3
2765: WHERE rowid = cur.rowid;

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

3143: x_return_status => l_ret_status,
3144: x_msg_data => l_msg_data,
3145: x_msg_count => l_msg_count );
3146:
3147: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS )THEN
3148: UPDATE mtl_system_items_interface
3149: SET process_flag = 4
3150: WHERE set_process_id = p_set_process_id
3151: AND process_flag = 5;

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

3286: ,'ITEM_NUMBER'
3287: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3288: ,'INV_IOI_NO_AUTO_NIR'
3289: ,err_text);
3290: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3291: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3292: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3293: SET process_flag = 3
3294: WHERE rowid = i.rowid;

Line 3383: x_return_status := FND_API.G_RET_STS_SUCCESS;

3379: ,x_msg_data OUT NOCOPY VARCHAR2) IS
3380:
3381: l_sql VARCHAR2(1000);
3382: BEGIN
3383: x_return_status := FND_API.G_RET_STS_SUCCESS;
3384: x_msg_count := 0;
3385: x_msg_data := NULL;
3386: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
3387: INV_ITEM_UTIL.Object_Exists

Line 3415: x_return_status := FND_API.G_RET_STS_ERROR;

3411: OUT x_msg_data;
3412:
3413: EXCEPTION
3414: WHEN OTHERS THEN
3415: x_return_status := FND_API.G_RET_STS_ERROR;
3416: x_msg_count := 1;
3417: x_msg_data := SQLERRM;
3418: END Populate_Seq_Gen_Item_Nums;
3419:

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

3469: l_cursor_id NUMBER;
3470: l_error_table Error_Handler.Error_Tbl_Type;
3471: l_change_id NUMBER;
3472: l_change_notice VARCHAR2(100);
3473: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
3474: l_pk1_value VARCHAR2(100);
3475: l_raise_create_nir BOOLEAN := FALSE;
3476: l_raise_cancel_nir BOOLEAN := FALSE;
3477: l_update_msb BOOLEAN := FALSE;

Line 3612: ,p_auto_commit => FND_API.G_FALSE

3608: Cancel_New_Item_Request(
3609: p_inventory_item_id => p_inventory_item_id
3610: ,p_organization_id => p_organization_id
3611: ,p_item_number => p_item_number
3612: ,p_auto_commit => FND_API.G_FALSE
3613: ,p_wf_user_id => p_user_id
3614: ,p_fnd_user_id => p_login_id
3615: ,x_return_status => l_return_status );
3616:

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

3613: ,p_wf_user_id => p_user_id
3614: ,p_fnd_user_id => p_login_id
3615: ,x_return_status => l_return_status );
3616:
3617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3618: l_error_occured := TRUE;
3619:
3620: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3621: SET process_flag = 3

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

3633: 'ITEM_CATALOG_GORUP_ID',
3634: 'MTL_SYSTEM_ITEMS_INTERFACE',
3635: 'INV_IOI_CANCEL_NIR_FAILED',
3636: x_err_text);
3637: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3638: l_error_occured := TRUE;
3639: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3640:
3641: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

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

3687: ,'ITEM_NUMBER'
3688: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3689: ,'INV_IOI_NO_AUTO_NIR'
3690: ,x_err_text);
3691: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3692: l_error_occured := TRUE;
3693: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3694: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3695: SET process_flag = 3

Line 3752: x_return_status := FND_API.G_RET_STS_SUCCESS;

3748: l_nir_cancel_status VARCHAR2(10);
3749:
3750: BEGIN
3751:
3752: x_return_status := FND_API.G_RET_STS_SUCCESS;
3753: dumm_status := INVUPD2B.get_message('EGO_NIR_CANCEL_COMMENT', l_translated_text);
3754:
3755: ENG_NIR_UTIL_PKG.Cancel_nir_for_item(
3756: p_item_id => p_inventory_item_id

Line 3791: x_return_status := FND_API.G_RET_STS_ERROR;

3787: IN l_translated_text,
3788: OUT l_nir_cancel_status; */
3789: EXCEPTION
3790: WHEN others THEN
3791: x_return_status := FND_API.G_RET_STS_ERROR;
3792: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Cancel_NIR: Exception'||substr(SQLERRM,1,200));
3793: END Cancel_New_Item_Request;
3794:
3795: /* Obsoleting this procedure and recreating it below with new NIR create signature for R12 FPC

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

3805: l_dynamic_sql VARCHAR2(2000);
3806: l_dummy NUMBER;
3807: l_cursor_id NUMBER;
3808: l_error_table Error_Handler.Error_Tbl_Type;
3809: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
3810: BEGIN
3811:
3812: SELECT organization_code INTO l_org_code
3813: FROM mtl_parameters

Line 3857: l_return_status := FND_API.G_RET_STS_ERROR;

3853: IN l_type_name,
3854: IN l_org_code,
3855: OUT l_return_status;
3856: ELSE
3857: l_return_status := FND_API.G_RET_STS_ERROR;
3858: END IF;
3859: x_return_status := l_return_status;
3860: IF l_cursor_id IS NOT NULL THEN
3861: dbms_sql.close_cursor(l_cursor_id);

Line 3865: x_return_status := FND_API.G_RET_STS_ERROR;

3861: dbms_sql.close_cursor(l_cursor_id);
3862: END IF;
3863: EXCEPTION
3864: WHEN others THEN
3865: x_return_status := FND_API.G_RET_STS_ERROR;
3866: IF l_cursor_id IS NOT NULL THEN
3867: dbms_sql.close_cursor(l_cursor_id);
3868: END IF;
3869: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));

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

3903: ,x_msg_count => l_msg_count);
3904:
3905: x_return_status := l_return_status;
3906:
3907: IF (l_return_status = FND_API.G_RET_STS_SUCCESS )THEN
3908: UPDATE mtl_system_items_interface
3909: SET process_flag = p_process_flag
3910: WHERE rowid = p_row_id;
3911: ELSE

Line 3930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3926: IF l_inv_debug_level IN(101, 102) THEN
3927: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3928: END IF;
3929:
3930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3931:
3932: UPDATE mtl_system_items_interface
3933: SET process_flag = 3,
3934: change_id = NULL,

Line 3961: /* Bug 8275121. Pass the parameter p_validate_only as FND_API.G_TRUE to validate Item Associations against both

3957: IF SUBSTR(NVL(G_PROCESS_CONTROL,'SSSSSS'),1,6) <> 'NO_NIR'
3958: AND NVL(G_PROCESS_CONTROL,'SSSSSS') NOT IN ('EGO_XL_IMPORT_ITEM1','EGO_XL_IMPORT_ITEM2','EGO_XL_IMPORT_ITEM3')
3959: THEN
3960: -- commit; /* Commented to fix Bug#7422423*/
3961: /* Bug 8275121. Pass the parameter p_validate_only as FND_API.G_TRUE to validate Item Associations against both
3962: EGO_ITEM_ASSOCIATIONS and EGO_ITEM_ASSOCIATIONS_INTF tables, in the function
3963: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data(). */
3964:
3965: /* Bug 9336604 - Commenting the below call since EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data

Line 3971: ,p_initialize_error_handler => FND_API.G_FALSE -- Added for bug 8351181

3967: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data(
3968: ERRBUF => l_err_bug
3969: ,RETCODE => l_err_bug
3970: ,p_data_set_id => P_Set_id
3971: ,p_initialize_error_handler => FND_API.G_FALSE -- Added for bug 8351181
3972: ,p_validate_only => FND_API.G_TRUE
3973: ,p_commit => l_commit_flag ); */ -- Bug 9336604 /* Added to fix Bug#7422423*/
3974:
3975: NULL; -- Bug 9336604

Line 3972: ,p_validate_only => FND_API.G_TRUE

3968: ERRBUF => l_err_bug
3969: ,RETCODE => l_err_bug
3970: ,p_data_set_id => P_Set_id
3971: ,p_initialize_error_handler => FND_API.G_FALSE -- Added for bug 8351181
3972: ,p_validate_only => FND_API.G_TRUE
3973: ,p_commit => l_commit_flag ); */ -- Bug 9336604 /* Added to fix Bug#7422423*/
3974:
3975: NULL; -- Bug 9336604
3976: