680: ELSE
681: --Bug: 5200023 Added the ELSE BLOCK
682: IF l_item_number <> fnd_flex_keyval.concatenated_values THEN
683: status := 1;
684: FND_MESSAGE.SET_NAME ('INV', 'INV_ITEM_SEGMENTS_INVALID');
685: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', l_item_number);
686: error_msg := FND_MESSAGE.GET;
687:
688: dumm_status := INVPUOPI.mtl_log_interface_err(
681: --Bug: 5200023 Added the ELSE BLOCK
682: IF l_item_number <> fnd_flex_keyval.concatenated_values THEN
683: status := 1;
684: FND_MESSAGE.SET_NAME ('INV', 'INV_ITEM_SEGMENTS_INVALID');
685: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', l_item_number);
686: error_msg := FND_MESSAGE.GET;
687:
688: dumm_status := INVPUOPI.mtl_log_interface_err(
689: cr.organization_id,
682: IF l_item_number <> fnd_flex_keyval.concatenated_values THEN
683: status := 1;
684: FND_MESSAGE.SET_NAME ('INV', 'INV_ITEM_SEGMENTS_INVALID');
685: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', l_item_number);
686: error_msg := FND_MESSAGE.GET;
687:
688: dumm_status := INVPUOPI.mtl_log_interface_err(
689: cr.organization_id,
690: user_id,
1033: org_name := NVL(org_name, cr.organization_code);
1034: status := 1;
1035: stmt := 3;
1036:
1037: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1038: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1039: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1040: error_msg := FND_MESSAGE.GET;
1041: dumm_status := INVPUOPI.mtl_log_interface_err(
1034: status := 1;
1035: stmt := 3;
1036:
1037: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1038: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1039: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1040: error_msg := FND_MESSAGE.GET;
1041: dumm_status := INVPUOPI.mtl_log_interface_err(
1042: cr.organization_id,
1035: stmt := 3;
1036:
1037: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1038: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1039: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1040: error_msg := FND_MESSAGE.GET;
1041: dumm_status := INVPUOPI.mtl_log_interface_err(
1042: cr.organization_id,
1043: user_id,
1036:
1037: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1038: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1039: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1040: error_msg := FND_MESSAGE.GET;
1041: dumm_status := INVPUOPI.mtl_log_interface_err(
1042: cr.organization_id,
1043: user_id,
1044: login_id,
1082: Close get_organization_code;
1083: org_name := NVL(org_name, cr.organization_code);
1084: status := 1;
1085: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1086: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1087: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1088: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1089: error_msg := FND_MESSAGE.GET;
1090: dumm_status := INVPUOPI.mtl_log_interface_err(
1083: org_name := NVL(org_name, cr.organization_code);
1084: status := 1;
1085: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1086: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1087: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1088: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1089: error_msg := FND_MESSAGE.GET;
1090: dumm_status := INVPUOPI.mtl_log_interface_err(
1091: cr.organization_id,
1084: status := 1;
1085: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1086: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1087: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1088: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1089: error_msg := FND_MESSAGE.GET;
1090: dumm_status := INVPUOPI.mtl_log_interface_err(
1091: cr.organization_id,
1092: user_id,
1085: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1086: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1087: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1088: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1089: error_msg := FND_MESSAGE.GET;
1090: dumm_status := INVPUOPI.mtl_log_interface_err(
1091: cr.organization_id,
1092: user_id,
1093: login_id,
1197: Close get_organization_code;
1198: org_name := NVL(org_name, cr.organization_code);
1199: status := 1;
1200:
1201: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1202: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1203: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1204: error_msg := FND_MESSAGE.GET;
1205: dumm_status := INVPUOPI.mtl_log_interface_err(
1198: org_name := NVL(org_name, cr.organization_code);
1199: status := 1;
1200:
1201: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1202: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1203: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1204: error_msg := FND_MESSAGE.GET;
1205: dumm_status := INVPUOPI.mtl_log_interface_err(
1206: cr.organization_id,
1199: status := 1;
1200:
1201: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1202: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1203: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1204: error_msg := FND_MESSAGE.GET;
1205: dumm_status := INVPUOPI.mtl_log_interface_err(
1206: cr.organization_id,
1207: user_id,
1200:
1201: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_ITEM_MSI');
1202: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1203: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1204: error_msg := FND_MESSAGE.GET;
1205: dumm_status := INVPUOPI.mtl_log_interface_err(
1206: cr.organization_id,
1207: user_id,
1208: login_id,
1322: Close get_organization_code;
1323: org_name := NVL(org_name, cr.organization_code);
1324: status := 1;
1325: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1326: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1327: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1328: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1329: error_msg := FND_MESSAGE.GET;
1330: dumm_status := INVPUOPI.mtl_log_interface_err(
1323: org_name := NVL(org_name, cr.organization_code);
1324: status := 1;
1325: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1326: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1327: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1328: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1329: error_msg := FND_MESSAGE.GET;
1330: dumm_status := INVPUOPI.mtl_log_interface_err(
1331: cr.organization_id,
1324: status := 1;
1325: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1326: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1327: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1328: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1329: error_msg := FND_MESSAGE.GET;
1330: dumm_status := INVPUOPI.mtl_log_interface_err(
1331: cr.organization_id,
1332: user_id,
1325: --Bug: 4777089 Flagging INV_IOI_DUPLICATE_REC_MSII in place of INV_IOI_DUPLICATE_ITEM_MSI
1326: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_DUPLICATE_REC_MSII');
1327: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', cr.item_number);
1328: FND_MESSAGE.SET_TOKEN ('ORGANIZATION', org_name);
1329: error_msg := FND_MESSAGE.GET;
1330: dumm_status := INVPUOPI.mtl_log_interface_err(
1331: cr.organization_id,
1332: user_id,
1333: login_id,