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.AHL_PRD_DF_PVT dependencies on FND_MESSAGE

Line 509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');

505: END IF;
506: END IF;
507: -- raise error if input keys are wrong.
508: IF(l_input_key_error_flag)THEN
509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');
510: FND_MSG_PUB.ADD;
511: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
512: fnd_log.string
513: (

Line 531: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');

527: l_ue_status_code,
528: l_def_status_code,
529: l_manually_planned_flag;
530: IF(unit_effectivity_info_csr%NOTFOUND) THEN
531: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
532: FND_MSG_PUB.ADD;
533: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
534: fnd_log.string
535: (

Line 545: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');

541: CLOSE unit_effectivity_info_csr;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: ELSE
544: IF(l_orig_deferral_ue_id IS NOT NULL) THEN
545: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
546: FND_MSG_PUB.ADD;
547: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
548: fnd_log.string
549: (

Line 559: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');

555: CLOSE unit_effectivity_info_csr;
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: ELSIF((NVL(l_ue_status_code,'x') IN ('ACCOMPLISHED','DEFERRED','EXCEPTION','TERMINATED','CANCELLED','MR-TERMINATE'))
558: OR (NVL(l_def_status_code,'x')IN ('DEFERRED','DEFERRAL_PENDING','TERMINATED','CANCELLED')))THEN
559: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
560: FND_MSG_PUB.ADD;
561: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
562: fnd_log.string
563: (

Line 972: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_FLAG');

968: );
969: END IF;
970:
971: IF(p_df_header_rec.operation_flag IS NOT NULL AND p_df_header_rec.operation_flag NOT IN(G_OP_CREATE,G_OP_UPDATE,G_OP_DELETE))THEN
972: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_FLAG');
973: FND_MSG_PUB.ADD;
974: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
975: fnd_log.string
976: (

Line 1010: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');

1006: OPEN valid_deferral_csr(p_df_header_rec.unit_effectivity_id);
1007: FETCH valid_deferral_csr INTO l_exists;
1008: IF(valid_deferral_csr%NOTFOUND)
1009: THEN
1010: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1011: FND_MSG_PUB.ADD;
1012: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1013: THEN
1014: fnd_log.string

Line 1036: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_NS_DF_INVALID');

1032: IF (p_df_header_rec.skip_mr_flag = G_NO_FLAG) THEN
1033: OPEN is_orig_ue_nonserial(p_df_header_rec.unit_effectivity_id);
1034: FETCH is_orig_ue_nonserial INTO l_serial_number;
1035: IF (is_orig_ue_nonserial%FOUND AND l_serial_number IS NULL) THEN
1036: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_NS_DF_INVALID');
1037: FND_MSG_PUB.ADD;
1038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1039: fnd_log.string
1040: (

Line 1060: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');

1056: /*-- check whether this MR or SR (basically UE) available for deferral processing
1057: OPEN valid_deferral_csr(p_df_header_rec.unit_effectivity_id);
1058: FETCH valid_deferral_csr INTO l_exists;
1059: IF(valid_deferral_csr%NOTFOUND)THEN
1060: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1061: FND_MSG_PUB.ADD;
1062: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1063: fnd_log.string
1064: (

Line 1084: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_REXIST');

1080: -- check whether any record alreasy exists for the UE, IF yes raise error
1081: OPEN deferral_rec_exists_csr(p_df_header_rec.unit_effectivity_id);
1082: FETCH deferral_rec_exists_csr INTO l_exists;
1083: IF(deferral_rec_exists_csr%FOUND)THEN
1084: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HD_OP_REXIST');
1085: FND_MSG_PUB.ADD;
1086: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string
1088: (

Line 1101: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');

1097: CLOSE deferral_rec_exists_csr;
1098:
1099: -- check whether status is nothing but draft while creating record for deferral
1100: IF(p_df_header_rec.approval_status_code <> 'DRAFT')THEN
1101: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');
1102: FND_MSG_PUB.ADD;
1103: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1104: fnd_log.string
1105: (

Line 1120: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');

1116: -- check whether deferral record can be updated or deleted
1117: OPEN valid_deferral_up_csr(p_df_header_rec.unit_deferral_id);
1118: FETCH valid_deferral_up_csr INTO l_exists;
1119: IF(valid_deferral_up_csr%NOTFOUND)THEN
1120: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
1121: FND_MSG_PUB.ADD;
1122: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1123: fnd_log.string
1124: (

Line 1144: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');

1140: IF(p_df_header_rec.deferral_type = G_DEFERRAL_TYPE_MR) THEN
1141: OPEN valid_mr_csr(p_df_header_rec.unit_effectivity_id);
1142: FETCH valid_mr_csr INTO l_exists;
1143: IF(valid_mr_csr%NOTFOUND)THEN
1144: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');
1145: FND_MSG_PUB.ADD;
1146: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1147: fnd_log.string
1148: (

Line 1166: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');

1162: validate_reason_codes(p_df_header_rec.defer_reason_code);
1163: END IF;
1164: -- general validations for flags
1165: IF(p_df_header_rec.skip_mr_flag NOT IN(G_YES_FLAG,G_NO_FLAG))THEN
1166: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1167: FND_MSG_PUB.ADD;
1168: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1169: fnd_log.string
1170: (

Line 1179: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');

1175: END IF;
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178: IF(p_df_header_rec.affect_due_calc_flag NOT IN(G_YES_FLAG,G_NO_FLAG))THEN
1179: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1180: FND_MSG_PUB.ADD;
1181: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1182: fnd_log.string
1183: (

Line 1198: FND_MESSAGE.Set_Name('AHL','AHL_UMP_INVALID_DEF_TYPE');

1194: p_df_header_rec.user_deferral_type_code <> FND_API.G_MISS_CHAR) THEN
1195: OPEN validate_user_defer_csr(p_df_header_rec.user_deferral_type_code);
1196: FETCH validate_user_defer_csr INTO l_exists;
1197: IF (validate_user_defer_csr%NOTFOUND) THEN
1198: FND_MESSAGE.Set_Name('AHL','AHL_UMP_INVALID_DEF_TYPE');
1199: FND_MESSAGE.Set_token('CODE', p_df_header_rec.user_deferral_type_code);
1200: FND_MSG_PUB.ADD;
1201: END IF;
1202: CLOSE validate_user_defer_csr;

Line 1199: FND_MESSAGE.Set_token('CODE', p_df_header_rec.user_deferral_type_code);

1195: OPEN validate_user_defer_csr(p_df_header_rec.user_deferral_type_code);
1196: FETCH validate_user_defer_csr INTO l_exists;
1197: IF (validate_user_defer_csr%NOTFOUND) THEN
1198: FND_MESSAGE.Set_Name('AHL','AHL_UMP_INVALID_DEF_TYPE');
1199: FND_MESSAGE.Set_token('CODE', p_df_header_rec.user_deferral_type_code);
1200: FND_MSG_PUB.ADD;
1201: END IF;
1202: CLOSE validate_user_defer_csr;
1203: END IF;

Line 1210: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');

1206: IF(p_df_header_rec.deferral_type = G_DEFERRAL_TYPE_MR) THEN
1207: -- check validity of skip MR flag for MR
1208: IF(p_df_header_rec.mr_repetitive_flag = G_NO_FLAG AND p_df_header_rec.manually_planned_flag = G_NO_FLAG)THEN
1209: IF(p_df_header_rec.skip_mr_flag = G_YES_FLAG) THEN
1210: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1211: FND_MSG_PUB.ADD;
1212: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1213: fnd_log.string
1214: (

Line 1223: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');

1219: END IF;
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG AND p_df_header_rec.reset_counter_flag = G_YES_FLAG) THEN
1223: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1224: FND_MSG_PUB.ADD;
1225: END IF;
1226: ELSE -- MR is repetitive or manually planned
1227: IF(p_df_header_rec.skip_mr_flag = G_NO_FLAG) THEN

Line 1230: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');

1226: ELSE -- MR is repetitive or manually planned
1227: IF(p_df_header_rec.skip_mr_flag = G_NO_FLAG) THEN
1228: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG AND
1229: p_df_header_rec.reset_counter_flag = G_YES_FLAG) THEN
1230: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1231: FND_MSG_PUB.ADD;
1232: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1233: fnd_log.string
1234: (

Line 1244: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');

1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: END IF;
1242: ELSE
1243: IF(p_df_header_rec.affect_due_calc_flag = G_YES_FLAG) THEN
1244: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1245: FND_MSG_PUB.ADD;
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1247: fnd_log.string
1248: (

Line 1261: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');

1257: END IF;
1258: ELSIF (p_df_header_rec.deferral_type = G_DEFERRAL_TYPE_SR) THEN
1259: /* SR cancellation allowed for non-serialized items.
1260: IF(p_df_header_rec.skip_mr_flag = G_YES_FLAG) THEN
1261: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SKIP_FLAG');
1262: FND_MSG_PUB.ADD;
1263: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1264: fnd_log.string
1265: (

Line 1275: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');

1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: */
1274: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG)THEN
1275: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_AFFDUE_FLAG');
1276: FND_MSG_PUB.ADD;
1277: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1278: fnd_log.string
1279: (

Line 1293: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_DT');

1289: -- part of this validation has been moved for post processing
1290: IF(p_df_header_rec.skip_mr_flag = G_NO_FLAG AND
1291: (p_df_header_rec.set_due_date IS NOT NULL AND
1292: trunc(p_df_header_rec.set_due_date) < trunc(SYSDATE))) THEN
1293: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_DT');
1294: FND_MESSAGE.Set_Token('SET_DUE_DATE',p_df_header_rec.set_due_date);
1295: FND_MSG_PUB.ADD;
1296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1297: fnd_log.string

Line 1294: FND_MESSAGE.Set_Token('SET_DUE_DATE',p_df_header_rec.set_due_date);

1290: IF(p_df_header_rec.skip_mr_flag = G_NO_FLAG AND
1291: (p_df_header_rec.set_due_date IS NOT NULL AND
1292: trunc(p_df_header_rec.set_due_date) < trunc(SYSDATE))) THEN
1293: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_DT');
1294: FND_MESSAGE.Set_Token('SET_DUE_DATE',p_df_header_rec.set_due_date);
1295: FND_MSG_PUB.ADD;
1296: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1297: fnd_log.string
1298: (

Line 1307: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');

1303: END IF;
1304: END IF;
1305: IF(p_df_header_rec.deferral_effective_on IS NULL OR
1306: p_df_header_rec.deferral_effective_on > SYSDATE) THEN
1307: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
1308: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
1309: FND_MSG_PUB.ADD;
1310: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1311: fnd_log.string

Line 1308: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);

1304: END IF;
1305: IF(p_df_header_rec.deferral_effective_on IS NULL OR
1306: p_df_header_rec.deferral_effective_on > SYSDATE) THEN
1307: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
1308: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
1309: FND_MSG_PUB.ADD;
1310: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1311: fnd_log.string
1312: (

Line 1373: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');

1369: l_string := substr(p_defer_reason_code,l_temp1);
1370: OPEN val_reason_code_csr(l_string);
1371: FETCH val_reason_code_csr INTO l_exists;
1372: IF(val_reason_code_csr%NOTFOUND) THEN
1373: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');
1374: FND_MSG_PUB.ADD;
1375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1376: fnd_log.string
1377: (

Line 1393: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');

1389: l_string := substr(p_defer_reason_code,l_temp1,l_temp2 - l_temp1);
1390: OPEN val_reason_code_csr(l_string);
1391: FETCH val_reason_code_csr INTO l_exists;
1392: IF(val_reason_code_csr%NOTFOUND) THEN
1393: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_RSN_CODE');
1394: FND_MSG_PUB.ADD;
1395: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1396: fnd_log.string
1397: (

Line 1471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');

1467: l_df_header_rec.attribute9, l_df_header_rec.attribute10, l_df_header_rec.attribute11,
1468: l_df_header_rec.attribute12, l_df_header_rec.attribute13, l_df_header_rec.attribute14,
1469: l_df_header_rec.attribute15;
1470: IF (df_header_csr%NOTFOUND) THEN
1471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');
1472: FND_MSG_PUB.ADD;
1473: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1474: fnd_log.string
1475: (

Line 1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');

1481: ELSE
1482: IF (p_x_df_header_rec.unit_effectivity_id IS NULL) THEN
1483: p_x_df_header_rec.unit_effectivity_id := l_df_header_rec.unit_effectivity_id;
1484: ELSIF(p_x_df_header_rec.unit_effectivity_id <> l_df_header_rec.unit_effectivity_id ) THEN
1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');
1486: FND_MSG_PUB.ADD;
1487: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1488: fnd_log.string
1489: (

Line 1502: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDF_TYPE');

1498:
1499: IF (p_x_df_header_rec.unit_deferral_type IS NULL) THEN
1500: p_x_df_header_rec.unit_deferral_type := l_df_header_rec.unit_deferral_type;
1501: ELSIF(p_x_df_header_rec.unit_deferral_type <> l_df_header_rec.unit_deferral_type) THEN
1502: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDF_TYPE');
1503: FND_MSG_PUB.ADD;
1504: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (

Line 1519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');

1515:
1516: IF (p_x_df_header_rec.approval_status_code IS NULL) THEN
1517: p_x_df_header_rec.approval_status_code := l_df_header_rec.approval_status_code;
1518: ELSIF(p_x_df_header_rec.approval_status_code <> l_df_header_rec.approval_status_code) THEN
1519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_STATUS');
1520: FND_MSG_PUB.ADD;
1521: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1522: fnd_log.string
1523: (

Line 1572: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_NOTES');

1568:
1569: IF (p_x_df_header_rec.approver_notes IS NULL) THEN
1570: p_x_df_header_rec.approver_notes := l_df_header_rec.approver_notes;
1571: ELSIF(p_x_df_header_rec.approver_notes <> l_df_header_rec.approver_notes) THEN
1572: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_NOTES');
1573: FND_MSG_PUB.ADD;
1574: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1575: fnd_log.string
1576: (

Line 1687: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');

1683: ELSIF (p_x_df_header_rec.operation_flag = G_OP_CREATE) THEN
1684:
1685: IF (p_x_df_header_rec.unit_effectivity_id IS NULL OR
1686: p_x_df_header_rec.unit_effectivity_id = FND_API.G_MISS_NUM) THEN
1687: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE');
1688: FND_MSG_PUB.ADD;
1689: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1690: fnd_log.string
1691: (

Line 1848: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');

1844: -- record dml validations and key requirement validations
1845: FOR i IN p_x_df_schedules_tbl.FIRST..p_x_df_schedules_tbl.LAST LOOP
1846: -- key requirements
1847: IF(p_x_df_schedules_tbl(i).operation_flag NOT IN (G_OP_CREATE,G_OP_UPDATE,G_OP_DELETE)) THEN
1848: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');
1849: FND_MSG_PUB.ADD;
1850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1851: fnd_log.string
1852: (

Line 1862: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_KEY_MISS');

1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859: ELSIF(p_x_df_schedules_tbl(i).operation_flag IN (G_OP_UPDATE,G_OP_DELETE)) THEN
1860: IF(p_x_df_schedules_tbl(i).unit_threshold_id IS NULL OR
1861: p_x_df_schedules_tbl(i).object_version_number IS NULL) THEN
1862: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_KEY_MISS');
1863: FND_MSG_PUB.ADD;
1864: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1865: fnd_log.string
1866: (

Line 1875: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');

1871: END IF;
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: ELSIF (p_x_df_schedules_tbl(i).unit_deferral_id IS NOT NULL AND
1874: p_x_df_schedules_tbl(i).unit_deferral_id <> p_df_header_rec.unit_deferral_id) THEN
1875: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
1876: FND_MSG_PUB.ADD;
1877: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1878: fnd_log.string
1879: (

Line 1890: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');

1886: END IF;
1887: ELSIF(p_x_df_schedules_tbl(i).operation_flag = G_OP_CREATE) THEN
1888: IF(p_x_df_schedules_tbl(i).unit_threshold_id IS NOT NULL OR
1889: p_x_df_schedules_tbl(i).object_version_number IS NOT NULL) THEN
1890: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_OP');
1891: FND_MSG_PUB.ADD;
1892: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1893: fnd_log.string
1894: (

Line 1906: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');

1902: IF(p_x_df_schedules_tbl(i).unit_deferral_id IS NULL OR
1903: p_x_df_schedules_tbl(i).unit_deferral_id = FND_API.G_MISS_NUM) THEN
1904: p_x_df_schedules_tbl(i).unit_deferral_id := p_df_header_rec.unit_deferral_id;
1905: ELSIF(p_x_df_schedules_tbl(i).unit_deferral_id <> p_df_header_rec.unit_deferral_id)THEN
1906: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
1907: FND_MSG_PUB.ADD;
1908: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
1909: fnd_log.string
1910: (

Line 1924: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');

1920: IF(G_MODULE_TYPE = 'JSP' AND p_x_df_schedules_tbl(i).operation_flag IN (G_OP_CREATE,G_OP_UPDATE))THEN
1921: OPEN counter_id_csr(p_x_df_schedules_tbl(i).counter_name, p_df_header_rec.unit_effectivity_id);
1922: FETCH counter_id_csr INTO l_counter_id;
1923: IF(counter_id_csr%NOTFOUND)THEN
1924: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
1925: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
1926: FND_MSG_PUB.ADD;
1927: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1928: fnd_log.string

Line 1925: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);

1921: OPEN counter_id_csr(p_x_df_schedules_tbl(i).counter_name, p_df_header_rec.unit_effectivity_id);
1922: FETCH counter_id_csr INTO l_counter_id;
1923: IF(counter_id_csr%NOTFOUND)THEN
1924: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
1925: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
1926: FND_MSG_PUB.ADD;
1927: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1928: fnd_log.string
1929: (

Line 2186: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');

2182: -- validate whether valid items' counter
2183: OPEN valid_counter_csr(p_df_schedules_tbl(i).unit_deferral_id,p_df_schedules_tbl(i).counter_id);
2184: FETCH valid_counter_csr INTO l_exists;
2185: IF(valid_counter_csr%NOTFOUND)THEN
2186: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2187: FND_MESSAGE.Set_Token('COUNTER_NAME',p_df_schedules_tbl(i).counter_name);
2188: FND_MSG_PUB.ADD;
2189: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2190: fnd_log.string

Line 2187: FND_MESSAGE.Set_Token('COUNTER_NAME',p_df_schedules_tbl(i).counter_name);

2183: OPEN valid_counter_csr(p_df_schedules_tbl(i).unit_deferral_id,p_df_schedules_tbl(i).counter_id);
2184: FETCH valid_counter_csr INTO l_exists;
2185: IF(valid_counter_csr%NOTFOUND)THEN
2186: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2187: FND_MESSAGE.Set_Token('COUNTER_NAME',p_df_schedules_tbl(i).counter_name);
2188: FND_MSG_PUB.ADD;
2189: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2190: fnd_log.string
2191: (

Line 2204: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_CNT');

2200: /*IF(p_df_header_rec.deferral_type = 'MR')THEN
2201: OPEN mr_valid_counter_csr(p_df_schedules_tbl(i).unit_deferral_id,p_df_schedules_tbl(i).counter_id);
2202: FETCH mr_valid_counter_csr INTO l_exists;
2203: IF(mr_valid_counter_csr%NOTFOUND)THEN
2204: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_INV_CNT');
2205: FND_MSG_PUB.ADD;
2206: END IF;
2207: CLOSE mr_valid_counter_csr;
2208: END IF;*/

Line 2215: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');

2211: -- validate whether record exists for delete
2212: OPEN valid_df_rec_del_csr(p_df_schedules_tbl(i).unit_threshold_id,p_df_schedules_tbl(i).object_version_number);
2213: FETCH valid_df_rec_del_csr INTO l_exists;
2214: IF(valid_df_rec_del_csr%NOTFOUND) THEN
2215: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');
2216: FND_MSG_PUB.ADD;
2217: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2218: fnd_log.string
2219: (

Line 2280: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');

2276: l_df_schedules_rec.attribute6, l_df_schedules_rec.attribute7, l_df_schedules_rec.attribute8,
2277: l_df_schedules_rec.attribute9, l_df_schedules_rec.attribute10, l_df_schedules_rec.attribute11,
2278: l_df_schedules_rec.attribute12, l_df_schedules_rec.attribute13, l_df_schedules_rec.attribute14, l_df_schedules_rec.attribute15;
2279: IF (df_schedules_csr%NOTFOUND) THEN
2280: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_REC_MISS');
2281: FND_MSG_PUB.ADD;
2282: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2283: fnd_log.string
2284: (

Line 2294: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');

2290: ELSE
2291: IF (p_x_df_schedules_tbl(i).unit_deferral_id IS NULL) THEN
2292: p_x_df_schedules_tbl(i).unit_deferral_id := l_df_schedules_rec.unit_deferral_id;
2293: ELSIF(p_x_df_schedules_tbl(i).unit_deferral_id <> l_df_schedules_rec.unit_deferral_id) THEN
2294: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_SCH_HDR_MISS');
2295: FND_MSG_PUB.ADD;
2296: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2297: fnd_log.string
2298: (

Line 2311: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');

2307:
2308: IF (p_x_df_schedules_tbl(i).counter_id IS NULL) THEN
2309: p_x_df_schedules_tbl(i).counter_id := l_df_schedules_rec.counter_id;
2310: ELSIF(p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2311: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2312: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2313: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2314: fnd_log.string
2315: (

Line 2312: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);

2308: IF (p_x_df_schedules_tbl(i).counter_id IS NULL) THEN
2309: p_x_df_schedules_tbl(i).counter_id := l_df_schedules_rec.counter_id;
2310: ELSIF(p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2311: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2312: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2313: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2314: fnd_log.string
2315: (
2316: fnd_log.level_error,

Line 2327: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');

2323: IF (p_x_df_schedules_tbl(i).counter_value IS NULL) THEN
2324: p_x_df_schedules_tbl(i).counter_value := l_df_schedules_rec.counter_value;
2325: ELSIF(p_x_df_schedules_tbl(i).counter_value = FND_API.G_MISS_NUM OR
2326: p_x_df_schedules_tbl(i).counter_value <= 0) THEN
2327: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2328: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2329: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2330: FND_MSG_PUB.ADD;
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 2328: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);

2324: p_x_df_schedules_tbl(i).counter_value := l_df_schedules_rec.counter_value;
2325: ELSIF(p_x_df_schedules_tbl(i).counter_value = FND_API.G_MISS_NUM OR
2326: p_x_df_schedules_tbl(i).counter_value <= 0) THEN
2327: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2328: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2329: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2330: FND_MSG_PUB.ADD;
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2332: fnd_log.string

Line 2329: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);

2325: ELSIF(p_x_df_schedules_tbl(i).counter_value = FND_API.G_MISS_NUM OR
2326: p_x_df_schedules_tbl(i).counter_value <= 0) THEN
2327: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2328: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2329: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2330: FND_MSG_PUB.ADD;
2331: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2332: fnd_log.string
2333: (

Line 2344: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');

2340:
2341: IF (p_x_df_schedules_tbl(i).ctr_value_type_code IS NULL) THEN
2342: p_x_df_schedules_tbl(i).ctr_value_type_code := l_df_schedules_rec.ctr_value_type_code;
2343: ELSIF(p_x_df_schedules_tbl(i).ctr_value_type_code NOT IN(G_DEFER_BY,G_DEFER_TO)) THEN
2344: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');
2345: FND_MSG_PUB.ADD;
2346: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2347: fnd_log.string
2348: (

Line 2460: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDID');

2456: ELSIF (p_x_df_schedules_tbl(i).operation_flag = G_OP_CREATE) THEN
2457:
2458: IF (p_x_df_schedules_tbl(i).unit_deferral_id IS NULL OR
2459: p_x_df_schedules_tbl(i).unit_deferral_id = FND_API.G_MISS_NUM) THEN
2460: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UDID');
2461: FND_MSG_PUB.ADD;
2462: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2463: fnd_log.string
2464: (

Line 2475: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');

2471: END IF;
2472:
2473: IF (p_x_df_schedules_tbl(i).counter_id IS NULL OR
2474: p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2475: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2476: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2477: FND_MSG_PUB.ADD;
2478: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2479: fnd_log.string

Line 2476: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);

2472:
2473: IF (p_x_df_schedules_tbl(i).counter_id IS NULL OR
2474: p_x_df_schedules_tbl(i).counter_id = FND_API.G_MISS_NUM) THEN
2475: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNT_NAME');
2476: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2477: FND_MSG_PUB.ADD;
2478: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2479: fnd_log.string
2480: (

Line 2491: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');

2487:
2488: IF (p_x_df_schedules_tbl(i).counter_value IS NULL OR
2489: p_x_df_schedules_tbl(i).counter_value = FND_API.G_MISS_NUM OR
2490: p_x_df_schedules_tbl(i).counter_value <= 0 ) THEN
2491: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2492: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2493: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2494: FND_MSG_PUB.ADD;
2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 2492: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);

2488: IF (p_x_df_schedules_tbl(i).counter_value IS NULL OR
2489: p_x_df_schedules_tbl(i).counter_value = FND_API.G_MISS_NUM OR
2490: p_x_df_schedules_tbl(i).counter_value <= 0 ) THEN
2491: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2492: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2493: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2494: FND_MSG_PUB.ADD;
2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2496: fnd_log.string

Line 2493: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);

2489: p_x_df_schedules_tbl(i).counter_value = FND_API.G_MISS_NUM OR
2490: p_x_df_schedules_tbl(i).counter_value <= 0 ) THEN
2491: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVAL');
2492: FND_MESSAGE.Set_Token('COUNTER_NAME',p_x_df_schedules_tbl(i).counter_name);
2493: FND_MESSAGE.Set_Token('COUNTER_VALUE',p_x_df_schedules_tbl(i).counter_value);
2494: FND_MSG_PUB.ADD;
2495: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2496: fnd_log.string
2497: (

Line 2507: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');

2503: END IF;
2504:
2505: IF (p_x_df_schedules_tbl(i).ctr_value_type_code IS NULL OR
2506: p_x_df_schedules_tbl(i).ctr_value_type_code NOT IN(G_DEFER_BY,G_DEFER_TO)) THEN
2507: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_CNTVL_TPCD');
2508: FND_MSG_PUB.ADD;
2509: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2510: fnd_log.string
2511: (

Line 2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_CNT_NAME_REP');

2685:
2686: SELECT count(*) INTO l_count2 from (SELECT DISTINCT counter_id FROM ahl_unit_thresholds
2687: WHERE unit_deferral_id = p_df_header_rec.unit_deferral_id);
2688: IF(l_count1 <> l_count2) THEN
2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_CNT_NAME_REP');
2690: FND_MSG_PUB.ADD;
2691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2692: fnd_log.string
2693: (

Line 2703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_MAND');

2699: END IF;
2700:
2701: IF(l_count2 = 0)THEN
2702: IF(p_df_header_rec.set_due_date IS NULL)THEN
2703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SET_DUE_MAND');
2704: FND_MSG_PUB.ADD;
2705: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2706: fnd_log.string
2707: (

Line 2719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');

2715: END IF;
2716: ELSE
2717: l_calc_due_date_flag := true;
2718: IF(p_df_header_rec.deferral_effective_on IS NULL OR p_df_header_rec.deferral_effective_on > SYSDATE)THEN
2719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
2720: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
2721: FND_MSG_PUB.ADD;
2722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2723: fnd_log.string

Line 2720: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);

2716: ELSE
2717: l_calc_due_date_flag := true;
2718: IF(p_df_header_rec.deferral_effective_on IS NULL OR p_df_header_rec.deferral_effective_on > SYSDATE)THEN
2719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_DF_EFF_DT');
2720: FND_MESSAGE.Set_Token('DEFERRAL_EFFECTIVE_ON',p_df_header_rec.deferral_effective_on);
2721: FND_MSG_PUB.ADD;
2722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2723: fnd_log.string
2724: (

Line 2757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_LS_CNTVAL');

2753: IF(l_ctr_value_type_code = G_DEFER_BY) THEN
2754: l_counter_value := l_current_counter_value + l_counter_value;
2755: ELSE
2756: IF(l_counter_value < l_current_counter_value) THEN
2757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_LS_CNTVAL');
2758: FND_MESSAGE.Set_Token('COUNTER_NAME',l_counter_name);
2759: FND_MESSAGE.Set_Token('COUNTER_VALUE',l_counter_value);
2760: FND_MSG_PUB.ADD;
2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 2758: FND_MESSAGE.Set_Token('COUNTER_NAME',l_counter_name);

2754: l_counter_value := l_current_counter_value + l_counter_value;
2755: ELSE
2756: IF(l_counter_value < l_current_counter_value) THEN
2757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_LS_CNTVAL');
2758: FND_MESSAGE.Set_Token('COUNTER_NAME',l_counter_name);
2759: FND_MESSAGE.Set_Token('COUNTER_VALUE',l_counter_value);
2760: FND_MSG_PUB.ADD;
2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2762: fnd_log.string

Line 2759: FND_MESSAGE.Set_Token('COUNTER_VALUE',l_counter_value);

2755: ELSE
2756: IF(l_counter_value < l_current_counter_value) THEN
2757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_LS_CNTVAL');
2758: FND_MESSAGE.Set_Token('COUNTER_NAME',l_counter_name);
2759: FND_MESSAGE.Set_Token('COUNTER_VALUE',l_counter_value);
2760: FND_MSG_PUB.ADD;
2761: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2762: fnd_log.string
2763: (

Line 2794: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_DUE_DT_CALC_ERR');

2790: x_return_status => l_return_status ,
2791: x_msg_data => l_msg_data,
2792: x_msg_count => l_msg_count);
2793: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2794: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_DUE_DT_CALC_ERR');
2795: FND_MSG_PUB.ADD;
2796: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2797: fnd_log.string
2798: (

Line 2830: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_DUE_DATE_WARN');

2826: FETCH next_due_date_csr INTO l_next_due_date;
2827: IF(next_due_date_csr%NOTFOUND)THEN
2828: NULL;-- thorw warning here
2829: ELSIF( TRUNC(l_next_due_date) < TRUNC(l_defer_due_date))THEN
2830: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_DUE_DATE_WARN');
2831: FND_MESSAGE.SET_TOKEN('DEFER_DUE_DATE',l_defer_due_date,false);
2832: FND_MESSAGE.SET_TOKEN('NEXT_DUE_DATE',l_next_due_date,false);
2833: l_msg_data := FND_MESSAGE.get;
2834: END IF;

Line 2831: FND_MESSAGE.SET_TOKEN('DEFER_DUE_DATE',l_defer_due_date,false);

2827: IF(next_due_date_csr%NOTFOUND)THEN
2828: NULL;-- thorw warning here
2829: ELSIF( TRUNC(l_next_due_date) < TRUNC(l_defer_due_date))THEN
2830: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_DUE_DATE_WARN');
2831: FND_MESSAGE.SET_TOKEN('DEFER_DUE_DATE',l_defer_due_date,false);
2832: FND_MESSAGE.SET_TOKEN('NEXT_DUE_DATE',l_next_due_date,false);
2833: l_msg_data := FND_MESSAGE.get;
2834: END IF;
2835: CLOSE next_due_date_csr;

Line 2832: FND_MESSAGE.SET_TOKEN('NEXT_DUE_DATE',l_next_due_date,false);

2828: NULL;-- thorw warning here
2829: ELSIF( TRUNC(l_next_due_date) < TRUNC(l_defer_due_date))THEN
2830: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_DUE_DATE_WARN');
2831: FND_MESSAGE.SET_TOKEN('DEFER_DUE_DATE',l_defer_due_date,false);
2832: FND_MESSAGE.SET_TOKEN('NEXT_DUE_DATE',l_next_due_date,false);
2833: l_msg_data := FND_MESSAGE.get;
2834: END IF;
2835: CLOSE next_due_date_csr;
2836: END IF;

Line 2833: l_msg_data := FND_MESSAGE.get;

2829: ELSIF( TRUNC(l_next_due_date) < TRUNC(l_defer_due_date))THEN
2830: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_DUE_DATE_WARN');
2831: FND_MESSAGE.SET_TOKEN('DEFER_DUE_DATE',l_defer_due_date,false);
2832: FND_MESSAGE.SET_TOKEN('NEXT_DUE_DATE',l_next_due_date,false);
2833: l_msg_data := FND_MESSAGE.get;
2834: END IF;
2835: CLOSE next_due_date_csr;
2836: END IF;
2837:

Line 2884: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_APPR_STS');

2880: );
2881: END IF;
2882:
2883: IF(p_df_header_rec.approval_status_code NOT IN('DRAFT','DEFERRAL_REJECTED'))THEN
2884: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_APPR_STS');
2885: FND_MSG_PUB.ADD;
2886: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
2887: fnd_log.string
2888: (

Line 2898: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_PRC_STS');

2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: END IF;
2896:
2897: IF(valid_for_submission( p_df_header_rec.unit_effectivity_id) = FALSE)THEN
2898: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_SUB_PRC_STS');
2899: FND_MSG_PUB.ADD;
2900: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2901: fnd_log.string
2902: (

Line 2975: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_WF_INACTIVE');

2971: END IF;
2972:
2973: IF((l_return_status <> FND_API.G_RET_STS_SUCCESS) OR
2974: ( l_active <> G_YES_FLAG))THEN
2975: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_WF_INACTIVE');
2976: FND_MSG_PUB.ADD;
2977: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2978: fnd_log.string
2979: (

Line 3274: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');

3270:
3271: /*OPEN valid_mr_csr(p_unit_deferral_id ,p_object_version_number);
3272: FETCH valid_mr_csr INTO l_exists;
3273: IF(valid_mr_csr%NOTFOUND)THEN
3274: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MR_TERM');
3275: FND_MSG_PUB.ADD;
3276: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3277: fnd_log.string
3278: (

Line 3835: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');

3831: -- validating ue and getting it
3832: OPEN unit_effectivity_id_csr(p_unit_deferral_id, p_object_version_number);
3833: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id, l_object_type;
3834: IF(unit_effectivity_id_csr%NOTFOUND)THEN
3835: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INVOP_HREC_MISS');
3836: FND_MSG_PUB.ADD;
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3839: fnd_log.string

Line 3866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_SETUP');

3862: IF (p_approval_result_code IN ( G_DEFERRAL_REJECTED,G_DEFERRAL_APPROVED ))THEN
3863: OPEN validate_approver_privilages(l_unit_effectivity_id);
3864: FETCH validate_approver_privilages INTO l_workorder_id;
3865: IF(validate_approver_privilages%NOTFOUND)THEN
3866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_APPR_SETUP');
3867: FND_MSG_PUB.ADD;
3868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3869: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3870: fnd_log.string

Line 3909: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_DFSR_UNTLCKD');

3905: --tokens passed changed to MR_TITLE
3906:
3907: IF l_return_status = FND_API.G_TRUE THEN
3908: IF l_object_type IS NOT NULL AND l_object_type = 'SR' THEN
3909: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_DFSR_UNTLCKD');
3910: FND_MESSAGE.Set_Token('WO_NAME', workorder_rec.workorder_name);
3911: FND_MSG_PUB.ADD;
3912: ELSE
3913: OPEN ue_title_csr(l_unit_effectivity_id);

Line 3910: FND_MESSAGE.Set_Token('WO_NAME', workorder_rec.workorder_name);

3906:
3907: IF l_return_status = FND_API.G_TRUE THEN
3908: IF l_object_type IS NOT NULL AND l_object_type = 'SR' THEN
3909: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_DFSR_UNTLCKD');
3910: FND_MESSAGE.Set_Token('WO_NAME', workorder_rec.workorder_name);
3911: FND_MSG_PUB.ADD;
3912: ELSE
3913: OPEN ue_title_csr(l_unit_effectivity_id);
3914: FETCH ue_title_csr into l_ue_title;

Line 3916: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_DFMR_UNTLCKD');

3912: ELSE
3913: OPEN ue_title_csr(l_unit_effectivity_id);
3914: FETCH ue_title_csr into l_ue_title;
3915: CLOSE ue_title_csr;
3916: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_DFMR_UNTLCKD');
3917: FND_MESSAGE.Set_Token('MR_TITLE', l_ue_title);
3918: FND_MSG_PUB.ADD;
3919: END IF;
3920: EXIT;

Line 3917: FND_MESSAGE.Set_Token('MR_TITLE', l_ue_title);

3913: OPEN ue_title_csr(l_unit_effectivity_id);
3914: FETCH ue_title_csr into l_ue_title;
3915: CLOSE ue_title_csr;
3916: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_DFMR_UNTLCKD');
3917: FND_MESSAGE.Set_Token('MR_TITLE', l_ue_title);
3918: FND_MSG_PUB.ADD;
3919: END IF;
3920: EXIT;
3921: END IF;

Line 4003: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');

3999: SELECT meaning INTO l_status_meaning
4000: FROM fnd_lookup_values_vl
4001: WHERE lookup_type = 'AHL_JOB_STATUS'
4002: AND LOOKUP_CODE = l_prd_workorder_rec.status_code;
4003: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');
4004: FND_MESSAGE.set_token('WO_STATUS', l_status_meaning);
4005: FND_MESSAGE.set_token('WO_NAME', workorder_rec.workorder_name);
4006: FND_MSG_PUB.add;
4007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4004: FND_MESSAGE.set_token('WO_STATUS', l_status_meaning);

4000: FROM fnd_lookup_values_vl
4001: WHERE lookup_type = 'AHL_JOB_STATUS'
4002: AND LOOKUP_CODE = l_prd_workorder_rec.status_code;
4003: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');
4004: FND_MESSAGE.set_token('WO_STATUS', l_status_meaning);
4005: FND_MESSAGE.set_token('WO_NAME', workorder_rec.workorder_name);
4006: FND_MSG_PUB.add;
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: END IF;

Line 4005: FND_MESSAGE.set_token('WO_NAME', workorder_rec.workorder_name);

4001: WHERE lookup_type = 'AHL_JOB_STATUS'
4002: AND LOOKUP_CODE = l_prd_workorder_rec.status_code;
4003: FND_MESSAGE.set_name('AHL','AHL_PRD_MAT_NOT_RETURN');
4004: FND_MESSAGE.set_token('WO_STATUS', l_status_meaning);
4005: FND_MESSAGE.set_token('WO_NAME', workorder_rec.workorder_name);
4006: FND_MSG_PUB.add;
4007: x_return_status := FND_API.G_RET_STS_ERROR;
4008: END IF;
4009: CLOSE chk_inst_in_job;

Line 4036: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');

4032: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4033: );
4034: END IF;
4035: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4036: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');
4037: FND_MSG_PUB.ADD;
4038: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4039: fnd_log.string
4040: (

Line 4095: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');

4091: 'Status after AHL_PRD_WORKORDER_PVT.update_job API call : ' || x_return_status
4092: );
4093: END IF;
4094: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4095: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_UPD_JB_FAIL');
4096: FND_MSG_PUB.ADD;
4097: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4098: fnd_log.string
4099: (

Line 4138: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');

4134: 'Status after AHL_COMPLETIONS_PVT.defer_workorder API call : ' || x_return_status
4135: );
4136: END IF;
4137: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4138: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');
4139: FND_MSG_PUB.ADD;
4140: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4141: fnd_log.string
4142: (

Line 4195: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');

4191: p_unit_effectivity_id => l_unit_effectivity_id,
4192: p_workorder_id => NULL
4193: );
4194: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
4195: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_CMP_JB_FAIL');
4196: FND_MSG_PUB.ADD;
4197: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4198: fnd_log.string
4199: (

Line 4395: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');

4391:
4392: OPEN unit_effectivity_id_csr(p_unit_deferral_id ,p_object_version_number);
4393: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id;
4394: IF(unit_effectivity_id_csr%NOTFOUND)THEN
4395: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
4396: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',p_unit_deferral_id);
4397: FND_MSG_PUB.ADD;
4398: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4399: fnd_log.string

Line 4396: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',p_unit_deferral_id);

4392: OPEN unit_effectivity_id_csr(p_unit_deferral_id ,p_object_version_number);
4393: FETCH unit_effectivity_id_csr INTO l_unit_effectivity_id;
4394: IF(unit_effectivity_id_csr%NOTFOUND)THEN
4395: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
4396: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',p_unit_deferral_id);
4397: FND_MSG_PUB.ADD;
4398: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4399: fnd_log.string
4400: (

Line 4598: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_INVALID_INCIDENT_ID');

4594: AND p_new_status IN ('DEFERRED','CANCELLED'))
4595: THEN
4596: IF NOT (l_cs_incident_id IS NOT NULL AND l_cs_incident_id > 0)
4597: THEN
4598: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_INVALID_INCIDENT_ID');
4599: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', l_cs_incident_id);
4600: FND_MSG_PUB.ADD;
4601: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string

Line 4599: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', l_cs_incident_id);

4595: THEN
4596: IF NOT (l_cs_incident_id IS NOT NULL AND l_cs_incident_id > 0)
4597: THEN
4598: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_INVALID_INCIDENT_ID');
4599: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', l_cs_incident_id);
4600: FND_MSG_PUB.ADD;
4601: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
4602: fnd_log.string
4603: (

Line 5137: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');

5133: );
5134: END IF;
5135:
5136: IF(p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM)THEN
5137: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_KMISS');
5138: FND_MSG_PUB.ADD;
5139: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5140: fnd_log.string
5141: (

Line 5159: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');

5155: END IF;
5156:
5157: IF(l_applicable_ue_id IS NULL)THEN
5158: l_applicable_ue_id := p_unit_effectivity_id;
5159: /*FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_MRSR_STATUS');
5160: FND_MSG_PUB.ADD;
5161: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
5162: fnd_log.string
5163: (

Line 5181: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');

5177: l_df_header_info_rec.incident_number,l_df_header_info_rec.summary,
5178: l_df_header_info_rec.manually_planned_flag;
5179:
5180: IF(context_info_csr%NOTFOUND)THEN
5181: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
5182: FND_MSG_PUB.ADD;
5183: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5184: fnd_log.string
5185: (

Line 5202: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_MR');

5198:
5199: OPEN mr_status_meaning_csr(l_df_header_info_rec.ue_status_code);
5200: FETCH mr_status_meaning_csr INTO l_df_header_info_rec.ue_status_meaning;
5201: IF(mr_status_meaning_csr%NOTFOUND)THEN
5202: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_MR');
5203: FND_MSG_PUB.ADD;
5204: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5205: fnd_log.string
5206: (

Line 5222: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_VISIT');

5218: OPEN visit_info_csr(l_applicable_ue_id);
5219: FETCH visit_info_csr INTO l_df_header_info_rec.visit_id,l_df_header_info_rec.visit_number;
5220: /* R12: UMP Deferral.
5221: IF(visit_info_csr%NOTFOUND)THEN
5222: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_UE_VISIT');
5223: FND_MSG_PUB.ADD;
5224: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5225: fnd_log.string
5226: (

Line 5384: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');

5380: FETCH applicable_ue_csr INTO l_orig_deferral_ue_id,
5381: l_ue_status_code,
5382: l_def_status_code;
5383: IF(applicable_ue_csr%NOTFOUND)THEN
5384: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_INV_HREC_UE_ID');
5385: FND_MSG_PUB.ADD;
5386: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
5387: fnd_log.string
5388: (