DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on INVPUOPI

Line 839: INVPUOPI.mtl_log_interface_err(

835: CLOSE c_check_item_type;
836:
837: IF l_valid_status ='Y' THEN
838: l_error_logged :=
839: INVPUOPI.mtl_log_interface_err(
840: cur.organization_id,
841: P_User_Id,
842: P_Login_Id,
843: P_Prog_AppId,

Line 875: INVPUOPI.mtl_log_interface_err(

871:
872: EXCEPTION
873: WHEN LOGGING_ERR THEN
874: l_error_logged :=
875: INVPUOPI.mtl_log_interface_err(
876: cur.organization_id,
877: P_User_Id,
878: P_Login_Id,
879: P_Prog_AppId,

Line 912: INVPUOPI.mtl_log_interface_err(

908:
909: EXCEPTION
910: WHEN LOGGING_ERR THEN
911: l_error_logged :=
912: INVPUOPI.mtl_log_interface_err(
913: cur.organization_id,
914: P_User_Id,
915: P_Login_Id,
916: P_Prog_AppId,

Line 936: l_error_logged := INVPUOPI.mtl_log_interface_err(

932: ELSE
933: --3457443 : lifecycle and phase validation during update also.
934: --Life Cyle is null but phase has been provided
935: IF cur.current_phase_id IS NOT NULL THEN
936: l_error_logged := INVPUOPI.mtl_log_interface_err(
937: cur.organization_id,
938: P_User_Id,
939: P_Login_Id,
940: P_Prog_AppId,

Line 991: l_error_logged := INVPUOPI.mtl_log_interface_err(

987: FND_MESSAGE.SET_TOKEN ('ATTR2', l_unit_wt_uom_disp_name);
988: FND_MESSAGE.SET_TOKEN ('GTID', l_gtid_disp_name);
989: l_error_msg := FND_MESSAGE.GET;
990:
991: l_error_logged := INVPUOPI.mtl_log_interface_err(
992: cur.organization_id,
993: P_User_Id,
994: P_Login_Id,
995: P_Prog_AppId,

Line 1023: l_error_logged := INVPUOPI.mtl_log_interface_err(

1019: UPDATE mtl_system_items_interface
1020: SET process_flag = 3
1021: WHERE rowid = cur.rowid;
1022:
1023: l_error_logged := INVPUOPI.mtl_log_interface_err(
1024: cur.organization_id,
1025: P_User_Id,
1026: P_Login_Id,
1027: P_Prog_AppId,

Line 1063: l_error_logged := INVPUOPI.mtl_log_interface_err(

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,
1067: P_Prog_AppId,

Line 1102: l_error_logged := INVPUOPI.mtl_log_interface_err(

1098: ,p_login_id => p_login_id
1099: ,x_err_text => x_err_text);
1100:
1101: IF l_return_status <> 0 THEN
1102: l_error_logged := INVPUOPI.mtl_log_interface_err(
1103: cur.organization_id,
1104: P_User_Id,
1105: P_Login_Id,
1106: P_Prog_AppId,

Line 1141: l_error_logged := INVPUOPI.mtl_log_interface_err(

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,
1145: P_Prog_AppId,

Line 1168: l_error_logged := INVPUOPI.mtl_log_interface_err (

1164:
1165: /* Pack Item Type Validations */
1166: IF ((cur.gdsn_outbound_enabled_flag IS NULL OR cur.gdsn_outbound_enabled_flag = 'N')
1167: AND (l_old_gdsn_flag = 'Y')) THEN
1168: l_error_logged := INVPUOPI.mtl_log_interface_err (
1169: Cur.organization_id,
1170: P_User_Id,
1171: P_Login_Id,
1172: P_Prog_AppId,

Line 1195: l_error_logged := INVPUOPI.mtl_log_interface_err (

1191: FETCH c_pack_item_type INTO l_valid_pack_type;
1192: CLOSE c_pack_item_type;
1193:
1194: IF l_valid_pack_type <> 1 THEN
1195: l_error_logged := INVPUOPI.mtl_log_interface_err (
1196: Cur.organization_id,
1197: P_User_Id,
1198: P_Login_Id,
1199: P_Prog_AppId,

Line 1219: l_error_logged := INVPUOPI.mtl_log_interface_err (

1215: IF (l_is_primary_uom_base <> 'Y') THEN
1216: FND_MESSAGE.Set_Name('EGO', 'EGO_GTID_CANNOT_BE_BASE');
1217: FND_MESSAGE.Set_Token('ATTR_NAME', l_gtid_disp_name);
1218: l_err_text := FND_MESSAGE.GET;
1219: l_error_logged := INVPUOPI.mtl_log_interface_err (
1220: Cur.organization_id,
1221: P_User_Id,
1222: P_Login_Id,
1223: P_Prog_AppId,

Line 1267: l_error_logged := INVPUOPI.mtl_log_interface_err (

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,
1271: P_Prog_AppId,

Line 1293: l_error_logged := INVPUOPI.mtl_log_interface_err (

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,
1297: P_Prog_AppId,

Line 1343: INVPUOPI.mtl_log_interface_err(

1339: ,X_Error_Code => X_Error_Code);
1340: EXCEPTION
1341: WHEN LOGGING_ERR THEN
1342: l_error_logged :=
1343: INVPUOPI.mtl_log_interface_err(
1344: cur.organization_id,
1345: P_User_Id,
1346: P_Login_Id,
1347: P_Prog_AppId,

Line 1366: l_error_logged := INVPUOPI.mtl_log_interface_err(

1362: ELSE
1363: --3457443 : lifecycle and phase validation during update also.
1364: --Life Cyle is null but phase has been provided
1365: IF cur.current_phase_id IS NOT NULL THEN
1366: l_error_logged := INVPUOPI.mtl_log_interface_err(
1367: cur.organization_id,
1368: P_User_Id,
1369: P_Login_Id,
1370: P_Prog_AppId,

Line 1413: l_error_logged := INVPUOPI.mtl_log_interface_err(

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;
1412:
1413: l_error_logged := INVPUOPI.mtl_log_interface_err(
1414: cur.organization_id,
1415: P_User_Id,
1416: P_Login_Id,
1417: P_Prog_AppId,

Line 1447: l_error_logged := INVPUOPI.mtl_log_interface_err(

1443: UPDATE mtl_system_items_interface
1444: SET process_flag = 3
1445: WHERE rowid = cur.rowid;
1446:
1447: l_error_logged := INVPUOPI.mtl_log_interface_err(
1448: cur.organization_id,
1449: P_User_Id,
1450: P_Login_Id,
1451: P_Prog_AppId,

Line 1486: l_error_logged := INVPUOPI.mtl_log_interface_err(

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,
1490: P_Prog_AppId,

Line 1525: l_error_logged := INVPUOPI.mtl_log_interface_err(

1521: ,p_login_id => p_login_id
1522: ,x_err_text => x_err_text);
1523:
1524: IF l_return_status <> 0 THEN
1525: l_error_logged := INVPUOPI.mtl_log_interface_err(
1526: cur.organization_id,
1527: P_User_Id,
1528: P_Login_Id,
1529: P_Prog_AppId,

Line 1551: l_error_logged := INVPUOPI.mtl_log_interface_err (

1547:
1548: /* Pack Item Type Validations */
1549: IF ((cur.gdsn_outbound_enabled_flag IS NULL OR cur.gdsn_outbound_enabled_flag = 'N')
1550: AND(l_old_gdsn_flag = 'Y')) THEN
1551: l_error_logged := INVPUOPI.mtl_log_interface_err (
1552: Cur.organization_id,
1553: P_User_Id,
1554: P_Login_Id,
1555: P_Prog_AppId,

Line 1578: l_error_logged := INVPUOPI.mtl_log_interface_err (

1574: FETCH c_pack_item_type INTO l_valid_pack_type;
1575: CLOSE c_pack_item_type;
1576:
1577: IF l_valid_pack_type <> 1 THEN
1578: l_error_logged := INVPUOPI.mtl_log_interface_err (
1579: Cur.organization_id,
1580: P_User_Id,
1581: P_Login_Id,
1582: P_Prog_AppId,

Line 1603: l_error_logged := INVPUOPI.mtl_log_interface_err (

1599: IF (l_is_primary_uom_base <> 'Y') THEN
1600: FND_MESSAGE.Set_Name('EGO', 'EGO_GTID_CANNOT_BE_BASE');
1601: FND_MESSAGE.Set_Token('ATTR_NAME', l_gtid_disp_name);
1602: l_err_text := FND_MESSAGE.GET;
1603: l_error_logged := INVPUOPI.mtl_log_interface_err (
1604: Cur.organization_id,
1605: P_User_Id,
1606: P_Login_Id,
1607: P_Prog_AppId,

Line 1650: l_error_logged := INVPUOPI.mtl_log_interface_err (

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,
1654: P_Prog_AppId,

Line 1676: l_error_logged := INVPUOPI.mtl_log_interface_err (

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,
1680: P_Prog_AppId,

Line 2023: l_error_logged := INVPUOPI.mtl_log_interface_err(

2019: --Bug:3491746 Added catalog group validation PLM Ended
2020: END IF;
2021:
2022: IF l_log_error THEN
2023: l_error_logged := INVPUOPI.mtl_log_interface_err(
2024: cur.organization_id,
2025: P_User_Id,
2026: P_Login_Id,
2027: P_Prog_AppId,

Line 2266: l_error_logged := INVPUOPI.mtl_log_interface_err(

2262:
2263: UPDATE mtl_system_items_interface
2264: SET process_flag = 3
2265: WHERE rowid = cur.rowid;
2266: l_error_logged := INVPUOPI.mtl_log_interface_err(
2267: cur.organization_id,
2268: FND_GLOBAL.USER_ID,
2269: FND_GLOBAL.LOGIN_ID,
2270: FND_GLOBAL.PROG_APPL_ID,

Line 2305: l_error_logged := INVPUOPI.mtl_log_interface_err(

2301: LOOP
2302: UPDATE mtl_system_items_interface
2303: SET process_flag = 3
2304: WHERE rowid = exc.rowid;
2305: l_error_logged := INVPUOPI.mtl_log_interface_err(
2306: exc.organization_id,
2307: FND_GLOBAL.USER_ID,
2308: FND_GLOBAL.LOGIN_ID,
2309: FND_GLOBAL.PROG_APPL_ID,

Line 2662: dumm_status := INVPUOPI.mtl_log_interface_err(

2658: UPDATE mtl_system_items_interface
2659: SET process_flag = 3
2660: WHERE rowid = cur.rowid;
2661:
2662: dumm_status := INVPUOPI.mtl_log_interface_err(
2663: cur.organization_id
2664: ,P_User_Id
2665: ,P_Login_Id
2666: ,P_Prog_AppId

Line 2767: dumm_status := INVPUOPI.mtl_log_interface_err(

2763: UPDATE mtl_item_revisions_interface
2764: SET process_flag = 3
2765: WHERE rowid = cur.rowid;
2766:
2767: dumm_status := INVPUOPI.mtl_log_interface_err(
2768: cur.organization_id
2769: ,P_User_Id
2770: ,P_Login_Id
2771: ,P_Prog_AppId

Line 3277: dumm_status := INVPUOPI.mtl_log_interface_err(

3273: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3274: SET process_flag = 3
3275: WHERE rowid = i.rowid;
3276:
3277: dumm_status := INVPUOPI.mtl_log_interface_err(
3278: i.organization_id,
3279: FND_GLOBAL.USER_ID,
3280: FND_GLOBAL.LOGIN_ID,
3281: FND_GLOBAL.PROG_APPL_ID,

Line 3296: dumm_status := INVPUOPI.mtl_log_interface_err(

3292: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3293: SET process_flag = 3
3294: WHERE rowid = i.rowid;
3295:
3296: dumm_status := INVPUOPI.mtl_log_interface_err(
3297: i.organization_id,
3298: FND_GLOBAL.USER_ID,
3299: FND_GLOBAL.LOGIN_ID,
3300: FND_GLOBAL.PROG_APPL_ID,

Line 3331: dumm_status := INVPUOPI.mtl_log_interface_err(

3327: IF l_inv_debug_level IN(101, 102) THEN
3328: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3329: END IF;
3330:
3331: dumm_status := INVPUOPI.mtl_log_interface_err(
3332: null,--i.organization_id,
3333: FND_GLOBAL.USER_ID,
3334: FND_GLOBAL.LOGIN_ID,
3335: FND_GLOBAL.PROG_APPL_ID,

Line 3624: dumm_status := INVPUOPI.mtl_log_interface_err(

3620: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3621: SET process_flag = 3
3622: WHERE rowid = p_rowid;
3623:
3624: dumm_status := INVPUOPI.mtl_log_interface_err(
3625: p_organization_id,
3626: p_user_id,
3627: p_login_id,
3628: p_prog_appid,

Line 3645: dumm_status := INVPUOPI.mtl_log_interface_err(

3641: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3642: SET process_flag = 3
3643: WHERE rowid = p_rowid;
3644:
3645: dumm_status := INVPUOPI.mtl_log_interface_err(
3646: p_organization_id,
3647: p_user_id,
3648: p_login_id,
3649: p_prog_appid,

Line 3678: dumm_status := INVPUOPI.mtl_log_interface_err(

3674: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3675: SET process_flag = 3
3676: WHERE rowid = p_rowid;
3677:
3678: dumm_status := INVPUOPI.mtl_log_interface_err(
3679: p_organization_id
3680: ,p_user_id
3681: ,p_login_id
3682: ,p_prog_appid

Line 3698: dumm_status := INVPUOPI.mtl_log_interface_err(

3694: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3695: SET process_flag = 3
3696: WHERE rowid = p_rowid;
3697:
3698: dumm_status := INVPUOPI.mtl_log_interface_err(
3699: p_organization_id
3700: ,p_user_id
3701: ,p_login_id
3702: ,p_prog_appid

Line 4080: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4076: IF l_msii_icc_id IS NULL THEN
4077: IF l_inv_debug_level IN(101, 102) THEN
4078: INVPUTLI.info('INVEGRVB.validate_style_sku: ICC is mandatory');
4079: END IF;
4080: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4081: l_User_Id,
4082: l_Login_Id,
4083: l_Prog_Appl_Id,
4084: l_Conc_prog_id,

Line 4101: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4097: THEN
4098: IF l_inv_debug_level IN(101, 102) THEN
4099: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Flag ');
4100: END IF;
4101: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4102: l_User_Id,
4103: l_Login_Id,
4104: l_Prog_Appl_Id,
4105: l_Conc_prog_id,

Line 4122: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4118: THEN
4119: IF l_inv_debug_level IN(101, 102) THEN
4120: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Id ');
4121: END IF;
4122: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4123: l_User_Id,
4124: l_Login_Id,
4125: l_Prog_Appl_Id,
4126: l_Conc_prog_id,

Line 4142: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4138: IF (l_msii_style_item_flag = 'Y' AND l_msii_gdsn_flag = 'Y') THEN
4139: IF l_inv_debug_level IN(101, 102) THEN
4140: INVPUTLI.info('INVEGRVB.validate_style_sku: Style Item cannot be GDSN SYndicated ');
4141: END IF;
4142: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4143: l_User_Id,
4144: l_Login_Id,
4145: l_Prog_Appl_Id,
4146: l_Conc_prog_id,

Line 4167: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4163: WHERE style_item_id = l_msii_inv_item_id
4164: AND organization_id = l_msii_org_id;
4165:
4166: IF l_sku_exists <> 0 THEN
4167: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4168: l_User_Id,
4169: l_Login_Id,
4170: l_Prog_Appl_Id,
4171: l_Conc_prog_id,

Line 4194: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4190: IF l_valid_icc = 0 THEN
4191: IF l_inv_debug_level IN(101, 102) THEN
4192: INVPUTLI.info('INVEGRVB.validate_style_sku: Invalid ICC ');
4193: END IF;
4194: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4195: l_User_Id,
4196: l_Login_Id,
4197: l_Prog_Appl_Id,
4198: l_Conc_prog_id,

Line 4217: l_error_logged := INVPUOPI.mtl_log_interface_err(

4213: p_inventory_item_id => l_msii_inv_item_id,
4214: p_item_catalog_group_id => l_msii_icc_id,
4215: x_err_text => l_err_text );
4216: IF l_error_logged <> 0 THEN
4217: l_error_logged := INVPUOPI.mtl_log_interface_err(
4218: l_msii_org_id,
4219: l_User_Id,
4220: l_Login_Id,
4221: l_Prog_Appl_Id,

Line 4250: l_error_logged := INVPUOPI.mtl_log_interface_err (l_msii_org_id,

4246: IF l_style_icc_id IS NULL OR l_style_icc_id <> l_msii_icc_id THEN
4247: IF l_inv_debug_level IN(101, 102) THEN
4248: INVPUTLI.info('INVEGRVB.validate_style_sku: SKU and Style must belong to same ICC ');
4249: END IF;
4250: l_error_logged := INVPUOPI.mtl_log_interface_err (l_msii_org_id,
4251: l_User_Id,
4252: l_Login_Id,
4253: l_Prog_Appl_Id,
4254: l_Conc_prog_id,

Line 4281: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4277: ,x_sku_exists => l_sku_variant
4278: ,x_err_text => l_err_text
4279: ,x_var_attrs_missing => l_var_attrs_missing);
4280: IF l_sku_variant THEN
4281: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4282: l_User_Id,
4283: l_Login_Id,
4284: l_Prog_Appl_Id,
4285: l_Conc_prog_id,

Line 4295: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4291: 'INV_SKU_VAR_NO_UNIQUE',
4292: X_Err_Text);
4293: l_error_exists := 1;
4294: ELSIF l_error_logged <> 0 THEN
4295: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4296: l_User_Id,
4297: l_Login_Id,
4298: l_Prog_Appl_Id,
4299: l_Conc_prog_id,

Line 4309: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,

4305: 'INV_IOI_ERR_VLD_SKU_USAGE',--bug 11894684, replace INV_IOI_ERR
4306: X_Err_Text);
4307: l_error_exists := 1;
4308: ELSIF l_var_attrs_missing = TRUE THEN
4309: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4310: l_User_Id,
4311: l_Login_Id,
4312: l_Prog_Appl_Id,
4313: l_Conc_prog_id,