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_MSG_PUB

Line 185: FND_MSG_PUB.Initialize;

181: -- setting up module type
182: G_MODULE_TYPE := p_module_type;
183: -- Initialize message list if p_init_msg_list is set to TRUE
184: IF FND_API.To_Boolean( p_init_msg_list) THEN
185: FND_MSG_PUB.Initialize;
186: END IF;
187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
189: fnd_log.string

Line 304: x_msg_count := FND_MSG_PUB.count_msg;

300: );
301: END IF;
302:
303: -- Check Error Message stack.
304: x_msg_count := FND_MSG_PUB.count_msg;
305: IF x_msg_count > 0 THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308:

Line 317: FND_MSG_PUB.Count_And_Get

313:
314:
315:
316: -- Standard call to get message count and if count is 1, get message info
317: FND_MSG_PUB.Count_And_Get
318: ( p_count => x_msg_count,
319: p_data => x_msg_data,
320: p_encoded => fnd_api.g_false
321: );

Line 340: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: Rollback to process_deferral;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
341: p_data => x_msg_data,
342: p_encoded => fnd_api.g_false);
343:
344:

Line 348: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

344:
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: Rollback to process_deferral;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
349: p_data => x_msg_data,
350: p_encoded => fnd_api.g_false);
351:
352:

Line 356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

352:
353: WHEN OTHERS THEN
354: Rollback to process_deferral;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
357: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
358: p_procedure_name => l_api_name,
359: p_error_text => SUBSTR(SQLERRM,1,500));
360: END IF;

Line 357: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

353: WHEN OTHERS THEN
354: Rollback to process_deferral;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
357: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
358: p_procedure_name => l_api_name,
359: p_error_text => SUBSTR(SQLERRM,1,500));
360: END IF;
361: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 361: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

357: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
358: p_procedure_name => l_api_name,
359: p_error_text => SUBSTR(SQLERRM,1,500));
360: END IF;
361: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
362: p_data => x_msg_data,
363: p_encoded => fnd_api.g_false);
364: END process_deferral;
365:

Line 510: FND_MSG_PUB.ADD;

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: (
514: fnd_log.level_unexpected,

Line 532: FND_MSG_PUB.ADD;

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: (
536: fnd_log.level_unexpected,

Line 546: FND_MSG_PUB.ADD;

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: (
550: fnd_log.level_unexpected,

Line 560: FND_MSG_PUB.ADD;

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: (
564: fnd_log.level_error,

Line 732: IF(FND_MSG_PUB.count_msg > 0)THEN

728: x_attribute15 => p_x_df_header_rec.attribute15
729: );
730: END IF;
731:
732: IF(FND_MSG_PUB.count_msg > 0)THEN
733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 973: FND_MSG_PUB.ADD;

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: (
977: fnd_log.level_unexpected,

Line 1011: FND_MSG_PUB.ADD;

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
1015: (

Line 1037: FND_MSG_PUB.ADD;

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: (
1041: fnd_log.level_unexpected,

Line 1061: FND_MSG_PUB.ADD;

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: (
1065: fnd_log.level_unexpected,

Line 1085: FND_MSG_PUB.ADD;

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: (
1089: fnd_log.level_unexpected,

Line 1102: FND_MSG_PUB.ADD;

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: (
1106: fnd_log.level_unexpected,

Line 1121: FND_MSG_PUB.ADD;

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: (
1125: fnd_log.level_unexpected,

Line 1145: FND_MSG_PUB.ADD;

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: (
1149: fnd_log.level_error,

Line 1167: FND_MSG_PUB.ADD;

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: (
1171: fnd_log.level_unexpected,

Line 1180: FND_MSG_PUB.ADD;

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: (
1184: fnd_log.level_unexpected,

Line 1200: FND_MSG_PUB.ADD;

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;
1204:

Line 1211: FND_MSG_PUB.ADD;

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: (
1215: fnd_log.level_unexpected,

Line 1224: FND_MSG_PUB.ADD;

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
1228: IF(p_df_header_rec.affect_due_calc_flag = G_NO_FLAG AND

Line 1231: FND_MSG_PUB.ADD;

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: (
1235: fnd_log.level_unexpected,

Line 1245: FND_MSG_PUB.ADD;

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: (
1249: fnd_log.level_unexpected,

Line 1262: FND_MSG_PUB.ADD;

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: (
1266: fnd_log.level_unexpected,

Line 1276: FND_MSG_PUB.ADD;

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: (
1280: fnd_log.level_unexpected,

Line 1295: FND_MSG_PUB.ADD;

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: (
1299: fnd_log.level_error,

Line 1309: FND_MSG_PUB.ADD;

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: (
1313: fnd_log.level_error,

Line 1322: IF(FND_MSG_PUB.count_msg > 0)THEN

1318: END IF;
1319: END IF;
1320:
1321: -- raise expected error
1322: IF(FND_MSG_PUB.count_msg > 0)THEN
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325:
1326: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1374: FND_MSG_PUB.ADD;

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: (
1378: fnd_log.level_unexpected,

Line 1394: FND_MSG_PUB.ADD;

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: (
1398: fnd_log.level_unexpected,

Line 1413: IF(FND_MSG_PUB.count_msg > 0)THEN

1409: END IF;
1410: EXIT WHEN exit_flag;
1411: END LOOP;
1412:
1413: IF(FND_MSG_PUB.count_msg > 0)THEN
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415: END IF;
1416:
1417: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1472: FND_MSG_PUB.ADD;

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: (
1476: fnd_log.level_error,

Line 1486: FND_MSG_PUB.ADD;

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: (
1490: fnd_log.level_unexpected,

Line 1503: FND_MSG_PUB.ADD;

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: (
1507: fnd_log.level_unexpected,

Line 1520: FND_MSG_PUB.ADD;

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: (
1524: fnd_log.level_unexpected,

Line 1573: FND_MSG_PUB.ADD;

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: (
1577: fnd_log.level_unexpected,

Line 1688: FND_MSG_PUB.ADD;

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: (
1692: fnd_log.level_unexpected,

Line 1806: IF(FND_MSG_PUB.count_msg > 0)THEN

1802: END IF;
1803: END IF;
1804:
1805: -- raise expected error
1806: IF(FND_MSG_PUB.count_msg > 0)THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1849: FND_MSG_PUB.ADD;

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: (
1853: fnd_log.level_unexpected,

Line 1863: FND_MSG_PUB.ADD;

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: (
1867: fnd_log.level_unexpected,

Line 1876: FND_MSG_PUB.ADD;

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: (
1880: fnd_log.level_unexpected,

Line 1891: FND_MSG_PUB.ADD;

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: (
1895: fnd_log.level_unexpected,

Line 1907: FND_MSG_PUB.ADD;

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: (
1911: fnd_log.level_unexpected,

Line 1926: FND_MSG_PUB.ADD;

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: (
1930: fnd_log.level_error,

Line 1943: IF(FND_MSG_PUB.count_msg > 0)THEN

1939: END IF;
1940: END LOOP;
1941:
1942: -- raise expected error
1943: IF(FND_MSG_PUB.count_msg > 0)THEN
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946:
1947: default_unchanged_df_schedules(p_x_df_schedules_tbl => p_x_df_schedules_tbl);

Line 1964: IF(FND_MSG_PUB.count_msg > 0)THEN

1960: p_df_header_rec => p_df_header_rec,
1961: p_df_schedules_tbl => p_x_df_schedules_tbl
1962: );
1963:
1964: IF(FND_MSG_PUB.count_msg > 0)THEN
1965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1966: END IF;
1967:
1968:

Line 2057: IF(FND_MSG_PUB.count_msg > 0)THEN

2053: );
2054: END IF;
2055: END LOOP;
2056:
2057: IF(FND_MSG_PUB.count_msg > 0)THEN
2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060:
2061: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 2188: FND_MSG_PUB.ADD;

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: (
2192: fnd_log.level_error,

Line 2205: FND_MSG_PUB.ADD;

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;*/
2209:

Line 2216: FND_MSG_PUB.ADD;

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: (
2220: fnd_log.level_error,

Line 2231: IF(FND_MSG_PUB.count_msg > 0)THEN

2227: END IF;
2228: END LOOP;
2229:
2230: -- raise expected error
2231: IF(FND_MSG_PUB.count_msg > 0)THEN
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2234:
2235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 2281: FND_MSG_PUB.ADD;

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: (
2285: fnd_log.level_error,

Line 2295: FND_MSG_PUB.ADD;

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: (
2299: fnd_log.level_unexpected,

Line 2330: FND_MSG_PUB.ADD;

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: (
2334: fnd_log.level_error,

Line 2345: FND_MSG_PUB.ADD;

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: (
2349: fnd_log.level_unexpected,

Line 2461: FND_MSG_PUB.ADD;

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: (
2465: fnd_log.level_unexpected,

Line 2477: FND_MSG_PUB.ADD;

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: (
2481: fnd_log.level_error,

Line 2494: FND_MSG_PUB.ADD;

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: (
2498: fnd_log.level_error,

Line 2508: FND_MSG_PUB.ADD;

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: (
2512: fnd_log.level_unexpected,

Line 2588: IF(FND_MSG_PUB.count_msg > 0)THEN

2584: END IF;
2585: END LOOP;
2586:
2587: -- raise expected error
2588: IF(FND_MSG_PUB.count_msg > 0)THEN
2589: RAISE FND_API.G_EXC_ERROR;
2590: END IF;
2591:
2592: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 2690: FND_MSG_PUB.ADD;

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: (
2694: fnd_log.level_error,

Line 2704: FND_MSG_PUB.ADD;

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: (
2708: fnd_log.level_error,

Line 2721: FND_MSG_PUB.ADD;

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: (
2725: fnd_log.level_error,

Line 2733: IF(FND_MSG_PUB.count_msg > 0)THEN

2729: END IF;
2730: END IF;
2731: END IF;
2732:
2733: IF(FND_MSG_PUB.count_msg > 0)THEN
2734: RAISE FND_API.G_EXC_ERROR;
2735: END IF;
2736:
2737: IF(l_calc_due_date_flag)THEN

Line 2760: FND_MSG_PUB.ADD;

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: (
2764: fnd_log.level_error,

Line 2779: IF(FND_MSG_PUB.count_msg > 0)THEN

2775: i := i + 1;
2776: END LOOP;
2777: CLOSE counter_values_csr;
2778: -- throw errors if any here and do not proceed.
2779: IF(FND_MSG_PUB.count_msg > 0)THEN
2780: RAISE FND_API.G_EXC_ERROR;
2781: END IF;
2782:
2783: IF((p_df_header_rec.deferral_type = G_DEFERRAL_TYPE_MR) AND

Line 2795: FND_MSG_PUB.ADD;

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: (
2799: fnd_log.level_unexpected,

Line 2842: IF(FND_MSG_PUB.count_msg > 0)THEN

2838: END IF;
2839: END IF;
2840: -- add validations here if needed in future
2841: -- throw errors if any
2842: IF(FND_MSG_PUB.count_msg > 0)THEN
2843: RAISE FND_API.G_EXC_ERROR;
2844: END IF;
2845:
2846: x_warning_msg_data := l_msg_data;

Line 2885: FND_MSG_PUB.ADD;

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: (
2889: fnd_log.level_unexpected,

Line 2899: FND_MSG_PUB.ADD;

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: (
2903: fnd_log.level_error,

Line 2976: FND_MSG_PUB.ADD;

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: (
2980: fnd_log.level_error,

Line 3068: IF(FND_MSG_PUB.count_msg > 0)THEN

3064: END IF;
3065: END IF;
3066:
3067: -- throw errors if any
3068: IF(FND_MSG_PUB.count_msg > 0)THEN
3069: RAISE FND_API.G_EXC_ERROR;
3070: END IF;
3071:
3072:

Line 3275: FND_MSG_PUB.ADD;

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: (
3279: fnd_log.level_error,

Line 3836: FND_MSG_PUB.ADD;

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
3840: (

Line 3867: FND_MSG_PUB.ADD;

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
3871: (

Line 3911: FND_MSG_PUB.ADD;

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;
3915: CLOSE ue_title_csr;

Line 3918: FND_MSG_PUB.ADD;

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;
3922: -- rroy

Line 4006: FND_MSG_PUB.add;

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;
4010: END IF;

Line 4037: FND_MSG_PUB.ADD;

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: (
4041: fnd_log.level_unexpected,

Line 4096: FND_MSG_PUB.ADD;

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: (
4100: fnd_log.level_unexpected,

Line 4139: FND_MSG_PUB.ADD;

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: (
4143: fnd_log.level_unexpected,

Line 4164: IF(FND_MSG_PUB.count_msg > 0)THEN

4160: );
4161: END IF;
4162:
4163: -- throw errors if any
4164: IF(FND_MSG_PUB.count_msg > 0)THEN
4165: RETURN;
4166: END IF;
4167:
4168: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 4196: FND_MSG_PUB.ADD;

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: (
4200: fnd_log.level_unexpected,

Line 4397: FND_MSG_PUB.ADD;

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: (
4401: fnd_log.level_unexpected,

Line 4600: FND_MSG_PUB.ADD;

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: (
4604: fnd_log.level_unexpected,

Line 5122: FND_MSG_PUB.Initialize;

5118: );
5119: END IF;
5120: -- Initialize message list if p_init_msg_list is set to TRUE
5121: IF FND_API.To_Boolean( p_init_msg_list) THEN
5122: FND_MSG_PUB.Initialize;
5123: END IF;
5124: -- Initialize API return status to success
5125: x_return_status := FND_API.G_RET_STS_SUCCESS;
5126:

Line 5138: FND_MSG_PUB.ADD;

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: (
5142: fnd_log.level_unexpected,

Line 5153: IF(FND_MSG_PUB.count_msg > 0)THEN

5149: --get applicable ue id and find out whether deferral record should be shown.
5150: l_applicable_ue_id := get_applicable_ue(p_unit_effectivity_id);
5151:
5152: -- throw errors if any
5153: IF(FND_MSG_PUB.count_msg > 0)THEN
5154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5155: END IF;
5156:
5157: IF(l_applicable_ue_id IS NULL)THEN

Line 5160: FND_MSG_PUB.ADD;

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: (
5164: fnd_log.level_error,

Line 5182: FND_MSG_PUB.ADD;

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: (
5186: fnd_log.level_unexpected,

Line 5203: FND_MSG_PUB.ADD;

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: (
5207: fnd_log.level_unexpected,

Line 5223: FND_MSG_PUB.ADD;

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: (
5227: fnd_log.level_unexpected,

Line 5257: IF(FND_MSG_PUB.count_msg > 0)THEN

5253: l_df_header_info_rec.reset_counter_flag := G_YES_FLAG;
5254: END IF;
5255:
5256: -- throw errors if any
5257: IF(FND_MSG_PUB.count_msg > 0)THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: END IF;
5260: -- fetch deferral header record
5261: OPEN df_header_info_csr(l_applicable_ue_id);

Line 5291: IF(FND_MSG_PUB.count_msg > 0)THEN

5287: END IF;
5288: CLOSE df_header_info_csr;
5289:
5290: -- throw errors if any
5291: IF(FND_MSG_PUB.count_msg > 0)THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: END IF;
5294:
5295: -- fetch deferral schedule rec

Line 5315: IF(FND_MSG_PUB.count_msg > 0)THEN

5311: CLOSE df_schedule_tbl_csr;
5312: END IF;
5313:
5314: -- throw errors if any
5315: IF(FND_MSG_PUB.count_msg > 0)THEN
5316: RAISE FND_API.G_EXC_ERROR;
5317: END IF;
5318:
5319: x_df_header_info_rec := l_df_header_info_rec;

Line 5337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

5333: WHEN FND_API.G_EXC_ERROR THEN
5334: x_df_header_info_rec := l_df_header_info_rec;
5335: x_df_schedules_tbl := l_df_schedules_tbl;
5336: x_return_status := FND_API.G_RET_STS_ERROR;
5337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5338: p_data => x_msg_data,
5339: p_encoded => fnd_api.g_false);
5340:
5341:

Line 5346: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

5342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5343: x_df_header_info_rec := l_df_header_info_rec;
5344: x_df_schedules_tbl := l_df_schedules_tbl;
5345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5346: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5347: p_data => x_msg_data,
5348: p_encoded => fnd_api.g_false);
5349:
5350:

Line 5355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5351: WHEN OTHERS THEN
5352: x_df_header_info_rec := l_df_header_info_rec;
5353: x_df_schedules_tbl := l_df_schedules_tbl;
5354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5356: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5357: p_procedure_name => l_api_name,
5358: p_error_text => SUBSTR(SQLERRM,1,500));
5359: END IF;

Line 5356: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

5352: x_df_header_info_rec := l_df_header_info_rec;
5353: x_df_schedules_tbl := l_df_schedules_tbl;
5354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5356: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5357: p_procedure_name => l_api_name,
5358: p_error_text => SUBSTR(SQLERRM,1,500));
5359: END IF;
5360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 5360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

5356: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5357: p_procedure_name => l_api_name,
5358: p_error_text => SUBSTR(SQLERRM,1,500));
5359: END IF;
5360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5361: p_data => x_msg_data,
5362: p_encoded => fnd_api.g_false);
5363: END get_deferral_details;
5364:

Line 5385: FND_MSG_PUB.ADD;

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: (
5389: fnd_log.level_unexpected,