DBA Data[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on INVPUOPI

Line 820: INVPUOPI.mtl_log_interface_err(

816:
817: EXCEPTION
818: WHEN LOGGING_ERR THEN
819: l_error_logged :=
820: INVPUOPI.mtl_log_interface_err(
821: cur.organization_id,
822: P_User_Id,
823: P_Login_Id,
824: P_Prog_AppId,

Line 857: INVPUOPI.mtl_log_interface_err(

853:
854: EXCEPTION
855: WHEN LOGGING_ERR THEN
856: l_error_logged :=
857: INVPUOPI.mtl_log_interface_err(
858: cur.organization_id,
859: P_User_Id,
860: P_Login_Id,
861: P_Prog_AppId,

Line 881: l_error_logged := INVPUOPI.mtl_log_interface_err(

877: ELSE
878: --3457443 : lifecycle and phase validation during update also.
879: --Life Cyle is null but phase has been provided
880: IF cur.current_phase_id IS NOT NULL THEN
881: l_error_logged := INVPUOPI.mtl_log_interface_err(
882: cur.organization_id,
883: P_User_Id,
884: P_Login_Id,
885: P_Prog_AppId,

Line 935: l_error_logged := INVPUOPI.mtl_log_interface_err(

931: FND_MESSAGE.SET_TOKEN ('ATTR2', l_unit_wt_uom_disp_name);
932: FND_MESSAGE.SET_TOKEN ('GTID', l_gtid_disp_name);
933: l_error_msg := FND_MESSAGE.GET;
934:
935: l_error_logged := INVPUOPI.mtl_log_interface_err(
936: cur.organization_id,
937: P_User_Id,
938: P_Login_Id,
939: P_Prog_AppId,

Line 967: l_error_logged := INVPUOPI.mtl_log_interface_err(

963: UPDATE mtl_system_items_interface
964: SET process_flag = 3
965: WHERE rowid = cur.rowid;
966:
967: l_error_logged := INVPUOPI.mtl_log_interface_err(
968: cur.organization_id,
969: P_User_Id,
970: P_Login_Id,
971: P_Prog_AppId,

Line 1006: l_error_logged := INVPUOPI.mtl_log_interface_err(

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

Line 1045: l_error_logged := INVPUOPI.mtl_log_interface_err(

1041: ,p_login_id => p_login_id
1042: ,x_err_text => x_err_text);
1043:
1044: IF l_return_status <> 0 THEN
1045: l_error_logged := INVPUOPI.mtl_log_interface_err(
1046: cur.organization_id,
1047: P_User_Id,
1048: P_Login_Id,
1049: P_Prog_AppId,

Line 1071: l_error_logged := INVPUOPI.mtl_log_interface_err (

1067:
1068: /* Pack Item Type Validations */
1069: IF ((cur.gdsn_outbound_enabled_flag IS NULL OR cur.gdsn_outbound_enabled_flag = 'N')
1070: AND (l_old_gdsn_flag = 'Y')) THEN
1071: l_error_logged := INVPUOPI.mtl_log_interface_err (
1072: Cur.organization_id,
1073: P_User_Id,
1074: P_Login_Id,
1075: P_Prog_AppId,

Line 1098: l_error_logged := INVPUOPI.mtl_log_interface_err (

1094: FETCH c_pack_item_type INTO l_valid_pack_type;
1095: CLOSE c_pack_item_type;
1096:
1097: IF l_valid_pack_type <> 1 THEN
1098: l_error_logged := INVPUOPI.mtl_log_interface_err (
1099: Cur.organization_id,
1100: P_User_Id,
1101: P_Login_Id,
1102: P_Prog_AppId,

Line 1122: l_error_logged := INVPUOPI.mtl_log_interface_err (

1118: IF (l_is_primary_uom_base <> 'Y') THEN
1119: FND_MESSAGE.Set_Name('EGO', 'EGO_GTID_CANNOT_BE_BASE');
1120: FND_MESSAGE.Set_Token('ATTR_NAME', l_gtid_disp_name);
1121: l_err_text := FND_MESSAGE.GET;
1122: l_error_logged := INVPUOPI.mtl_log_interface_err (
1123: Cur.organization_id,
1124: P_User_Id,
1125: P_Login_Id,
1126: P_Prog_AppId,

Line 1170: l_error_logged := INVPUOPI.mtl_log_interface_err (

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

Line 1196: l_error_logged := INVPUOPI.mtl_log_interface_err (

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

Line 1246: INVPUOPI.mtl_log_interface_err(

1242: ,X_Error_Code => X_Error_Code);
1243: EXCEPTION
1244: WHEN LOGGING_ERR THEN
1245: l_error_logged :=
1246: INVPUOPI.mtl_log_interface_err(
1247: cur.organization_id,
1248: P_User_Id,
1249: P_Login_Id,
1250: P_Prog_AppId,

Line 1269: l_error_logged := INVPUOPI.mtl_log_interface_err(

1265: ELSE
1266: --3457443 : lifecycle and phase validation during update also.
1267: --Life Cyle is null but phase has been provided
1268: IF cur.current_phase_id IS NOT NULL THEN
1269: l_error_logged := INVPUOPI.mtl_log_interface_err(
1270: cur.organization_id,
1271: P_User_Id,
1272: P_Login_Id,
1273: P_Prog_AppId,

Line 1315: l_error_logged := INVPUOPI.mtl_log_interface_err(

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;
1314:
1315: l_error_logged := INVPUOPI.mtl_log_interface_err(
1316: cur.organization_id,
1317: P_User_Id,
1318: P_Login_Id,
1319: P_Prog_AppId,

Line 1349: l_error_logged := INVPUOPI.mtl_log_interface_err(

1345: UPDATE mtl_system_items_interface
1346: SET process_flag = 3
1347: WHERE rowid = cur.rowid;
1348:
1349: l_error_logged := INVPUOPI.mtl_log_interface_err(
1350: cur.organization_id,
1351: P_User_Id,
1352: P_Login_Id,
1353: P_Prog_AppId,

Line 1388: l_error_logged := INVPUOPI.mtl_log_interface_err(

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

Line 1427: l_error_logged := INVPUOPI.mtl_log_interface_err(

1423: ,p_login_id => p_login_id
1424: ,x_err_text => x_err_text);
1425:
1426: IF l_return_status <> 0 THEN
1427: l_error_logged := INVPUOPI.mtl_log_interface_err(
1428: cur.organization_id,
1429: P_User_Id,
1430: P_Login_Id,
1431: P_Prog_AppId,

Line 1453: l_error_logged := INVPUOPI.mtl_log_interface_err (

1449:
1450: /* Pack Item Type Validations */
1451: IF ((cur.gdsn_outbound_enabled_flag IS NULL OR cur.gdsn_outbound_enabled_flag = 'N')
1452: AND(l_old_gdsn_flag = 'Y')) THEN
1453: l_error_logged := INVPUOPI.mtl_log_interface_err (
1454: Cur.organization_id,
1455: P_User_Id,
1456: P_Login_Id,
1457: P_Prog_AppId,

Line 1480: l_error_logged := INVPUOPI.mtl_log_interface_err (

1476: FETCH c_pack_item_type INTO l_valid_pack_type;
1477: CLOSE c_pack_item_type;
1478:
1479: IF l_valid_pack_type <> 1 THEN
1480: l_error_logged := INVPUOPI.mtl_log_interface_err (
1481: Cur.organization_id,
1482: P_User_Id,
1483: P_Login_Id,
1484: P_Prog_AppId,

Line 1505: l_error_logged := INVPUOPI.mtl_log_interface_err (

1501: IF (l_is_primary_uom_base <> 'Y') THEN
1502: FND_MESSAGE.Set_Name('EGO', 'EGO_GTID_CANNOT_BE_BASE');
1503: FND_MESSAGE.Set_Token('ATTR_NAME', l_gtid_disp_name);
1504: l_err_text := FND_MESSAGE.GET;
1505: l_error_logged := INVPUOPI.mtl_log_interface_err (
1506: Cur.organization_id,
1507: P_User_Id,
1508: P_Login_Id,
1509: P_Prog_AppId,

Line 1552: l_error_logged := INVPUOPI.mtl_log_interface_err (

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

Line 1578: l_error_logged := INVPUOPI.mtl_log_interface_err (

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

Line 1923: l_error_logged := INVPUOPI.mtl_log_interface_err(

1919: --Bug:3491746 Added catalog group validation PLM Ended
1920: END IF;
1921:
1922: IF l_log_error THEN
1923: l_error_logged := INVPUOPI.mtl_log_interface_err(
1924: cur.organization_id,
1925: P_User_Id,
1926: P_Login_Id,
1927: P_Prog_AppId,

Line 2114: l_error_logged := INVPUOPI.mtl_log_interface_err(

2110:
2111: UPDATE mtl_system_items_interface
2112: SET process_flag = 3
2113: WHERE rowid = cur.rowid;
2114: l_error_logged := INVPUOPI.mtl_log_interface_err(
2115: cur.organization_id,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.LOGIN_ID,
2118: FND_GLOBAL.PROG_APPL_ID,

Line 2153: l_error_logged := INVPUOPI.mtl_log_interface_err(

2149: LOOP
2150: UPDATE mtl_system_items_interface
2151: SET process_flag = 3
2152: WHERE rowid = exc.rowid;
2153: l_error_logged := INVPUOPI.mtl_log_interface_err(
2154: exc.organization_id,
2155: FND_GLOBAL.USER_ID,
2156: FND_GLOBAL.LOGIN_ID,
2157: FND_GLOBAL.PROG_APPL_ID,

Line 2491: dumm_status := INVPUOPI.mtl_log_interface_err(

2487: UPDATE mtl_system_items_interface
2488: SET process_flag = 3
2489: WHERE rowid = cur.rowid;
2490:
2491: dumm_status := INVPUOPI.mtl_log_interface_err(
2492: cur.organization_id
2493: ,P_User_Id
2494: ,P_Login_Id
2495: ,P_Prog_AppId

Line 2596: dumm_status := INVPUOPI.mtl_log_interface_err(

2592: UPDATE mtl_item_revisions_interface
2593: SET process_flag = 3
2594: WHERE rowid = cur.rowid;
2595:
2596: dumm_status := INVPUOPI.mtl_log_interface_err(
2597: cur.organization_id
2598: ,P_User_Id
2599: ,P_Login_Id
2600: ,P_Prog_AppId

Line 3067: dumm_status := INVPUOPI.mtl_log_interface_err(

3063: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3064: SET process_flag = 3
3065: WHERE rowid = i.rowid;
3066:
3067: dumm_status := INVPUOPI.mtl_log_interface_err(
3068: i.organization_id,
3069: FND_GLOBAL.USER_ID,
3070: FND_GLOBAL.LOGIN_ID,
3071: FND_GLOBAL.PROG_APPL_ID,

Line 3086: dumm_status := INVPUOPI.mtl_log_interface_err(

3082: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3083: SET process_flag = 3
3084: WHERE rowid = i.rowid;
3085:
3086: dumm_status := INVPUOPI.mtl_log_interface_err(
3087: i.organization_id,
3088: FND_GLOBAL.USER_ID,
3089: FND_GLOBAL.LOGIN_ID,
3090: FND_GLOBAL.PROG_APPL_ID,

Line 3121: dumm_status := INVPUOPI.mtl_log_interface_err(

3117: IF l_inv_debug_level IN(101, 102) THEN
3118: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3119: END IF;
3120:
3121: dumm_status := INVPUOPI.mtl_log_interface_err(
3122: null,--i.organization_id,
3123: FND_GLOBAL.USER_ID,
3124: FND_GLOBAL.LOGIN_ID,
3125: FND_GLOBAL.PROG_APPL_ID,

Line 3403: dumm_status := INVPUOPI.mtl_log_interface_err(

3399: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3400: SET process_flag = 3
3401: WHERE rowid = p_rowid;
3402:
3403: dumm_status := INVPUOPI.mtl_log_interface_err(
3404: p_organization_id,
3405: p_user_id,
3406: p_login_id,
3407: p_prog_appid,

Line 3424: dumm_status := INVPUOPI.mtl_log_interface_err(

3420: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3421: SET process_flag = 3
3422: WHERE rowid = p_rowid;
3423:
3424: dumm_status := INVPUOPI.mtl_log_interface_err(
3425: p_organization_id,
3426: p_user_id,
3427: p_login_id,
3428: p_prog_appid,

Line 3457: dumm_status := INVPUOPI.mtl_log_interface_err(

3453: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3454: SET process_flag = 3
3455: WHERE rowid = p_rowid;
3456:
3457: dumm_status := INVPUOPI.mtl_log_interface_err(
3458: p_organization_id
3459: ,p_user_id
3460: ,p_login_id
3461: ,p_prog_appid

Line 3477: dumm_status := INVPUOPI.mtl_log_interface_err(

3473: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3474: SET process_flag = 3
3475: WHERE rowid = p_rowid;
3476:
3477: dumm_status := INVPUOPI.mtl_log_interface_err(
3478: p_organization_id
3479: ,p_user_id
3480: ,p_login_id
3481: ,p_prog_appid

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

3816: IF l_msii_icc_id IS NULL THEN
3817: IF l_inv_debug_level IN(101, 102) THEN
3818: INVPUTLI.info('INVEGRVB.validate_style_sku: ICC is mandatory');
3819: END IF;
3820: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3821: l_User_Id,
3822: l_Login_Id,
3823: l_Prog_Appl_Id,
3824: l_Conc_prog_id,

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

3837: THEN
3838: IF l_inv_debug_level IN(101, 102) THEN
3839: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Flag ');
3840: END IF;
3841: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3842: l_User_Id,
3843: l_Login_Id,
3844: l_Prog_Appl_Id,
3845: l_Conc_prog_id,

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

3858: THEN
3859: IF l_inv_debug_level IN(101, 102) THEN
3860: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Id ');
3861: END IF;
3862: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3863: l_User_Id,
3864: l_Login_Id,
3865: l_Prog_Appl_Id,
3866: l_Conc_prog_id,

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

3878: IF (l_msii_style_item_flag = 'Y' AND l_msii_gdsn_flag = 'Y') THEN
3879: IF l_inv_debug_level IN(101, 102) THEN
3880: INVPUTLI.info('INVEGRVB.validate_style_sku: Style Item cannot be GDSN SYndicated ');
3881: END IF;
3882: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3883: l_User_Id,
3884: l_Login_Id,
3885: l_Prog_Appl_Id,
3886: l_Conc_prog_id,

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

3903: WHERE style_item_id = l_msii_inv_item_id
3904: AND organization_id = l_msii_org_id;
3905:
3906: IF l_sku_exists <> 0 THEN
3907: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3908: l_User_Id,
3909: l_Login_Id,
3910: l_Prog_Appl_Id,
3911: l_Conc_prog_id,

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

3930: IF l_valid_icc = 0 THEN
3931: IF l_inv_debug_level IN(101, 102) THEN
3932: INVPUTLI.info('INVEGRVB.validate_style_sku: Invalid ICC ');
3933: END IF;
3934: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3935: l_User_Id,
3936: l_Login_Id,
3937: l_Prog_Appl_Id,
3938: l_Conc_prog_id,

Line 3957: l_error_logged := INVPUOPI.mtl_log_interface_err(

3953: p_inventory_item_id => l_msii_inv_item_id,
3954: p_item_catalog_group_id => l_msii_icc_id,
3955: x_err_text => l_err_text );
3956: IF l_error_logged <> 0 THEN
3957: l_error_logged := INVPUOPI.mtl_log_interface_err(
3958: l_msii_org_id,
3959: l_User_Id,
3960: l_Login_Id,
3961: l_Prog_Appl_Id,

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

3986: IF l_style_icc_id IS NULL OR l_style_icc_id <> l_msii_icc_id THEN
3987: IF l_inv_debug_level IN(101, 102) THEN
3988: INVPUTLI.info('INVEGRVB.validate_style_sku: SKU and Style must belong to same ICC ');
3989: END IF;
3990: l_error_logged := INVPUOPI.mtl_log_interface_err (l_msii_org_id,
3991: l_User_Id,
3992: l_Login_Id,
3993: l_Prog_Appl_Id,
3994: l_Conc_prog_id,

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

4017: ,x_sku_exists => l_sku_variant
4018: ,x_err_text => l_err_text
4019: ,x_var_attrs_missing => l_var_attrs_missing);
4020: IF l_sku_variant THEN
4021: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4022: l_User_Id,
4023: l_Login_Id,
4024: l_Prog_Appl_Id,
4025: l_Conc_prog_id,

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

4031: 'INV_SKU_VAR_NO_UNIQUE',
4032: X_Err_Text);
4033: l_error_exists := 1;
4034: ELSIF l_error_logged <> 0 THEN
4035: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4036: l_User_Id,
4037: l_Login_Id,
4038: l_Prog_Appl_Id,
4039: l_Conc_prog_id,

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

4045: 'INV_IOI_ERR',
4046: X_Err_Text);
4047: l_error_exists := 1;
4048: ELSIF l_var_attrs_missing = TRUE THEN
4049: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
4050: l_User_Id,
4051: l_Login_Id,
4052: l_Prog_Appl_Id,
4053: l_Conc_prog_id,