DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on FND_MESSAGE

Line 376: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_UNIT_MAND');

372: * validate log_series is not null
373: */
374: IF (p_x_nonroutine_rec.unit_config_header_id is null or p_x_nonroutine_rec.unit_config_header_id = FND_API.G_MISS_NUM)
375: THEN
376: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_UNIT_MAND');
377: -- Unit is mandatory for associating MEL/CDL instructions
378: FND_MSG_PUB.ADD;
379: END IF;
380:

Line 387: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');

383: AND
384: p_x_nonroutine_rec.log_series_number IS NULL OR p_x_nonroutine_rec.log_series_number = FND_API.G_MISS_NUM
385: )
386: THEN
387: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');
388: -- Log Series and Number are mandatory for associating MEL/CDL instructions
389: FND_MSG_PUB.ADD;
390: END IF;
391:

Line 412: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_NO_ACCOM');

408: WHERE ata.repair_category_id = repcat.repair_category_id and ata.mel_cdl_ata_sequence_id = l_ata_sequence_id;
409:
410: IF (NVL(l_ata_rep_time, 0) <> 0 AND trunc(l_service_request_rec.incident_occurred_date) + trunc(l_ata_rep_time/24) < trunc(l_service_request_rec.request_date))
411: THEN
412: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_NO_ACCOM');
413: -- Repair Time of the associated MEL/CDL Instructions cannot accomodate resolution of the Non-routine before Log Date
414: FND_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;

Line 955: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_UNIT_MAND');

951: * validate log_series is not null
952: */
953: IF (p_x_nonroutine_rec.unit_config_header_id is null or p_x_nonroutine_rec.unit_config_header_id = FND_API.G_MISS_NUM)
954: THEN
955: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_UNIT_MAND');
956: -- Unit is mandatory for associating MEL/CDL instructions
957: FND_MSG_PUB.ADD;
958: END IF;
959:

Line 966: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');

962: AND
963: p_x_nonroutine_rec.log_series_number IS NULL OR p_x_nonroutine_rec.log_series_number = FND_API.G_MISS_NUM
964: )
965: THEN
966: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');
967: -- Log Series and Number are mandatory for associating MEL/CDL instructions
968: FND_MSG_PUB.ADD;
969: END IF;
970:

Line 991: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_NO_ACCOM');

987: WHERE ata.repair_category_id = repcat.repair_category_id and ata.mel_cdl_ata_sequence_id = l_ata_sequence_id;
988:
989: IF (NVL(l_ata_rep_time, 0) <> 0 AND trunc(l_service_request_rec.incident_occurred_date) + trunc(l_ata_rep_time/24) < trunc(l_service_request_rec.request_date))
990: THEN
991: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_NO_ACCOM');
992: -- Repair Time of the associated MEL/CDL Instructions cannot accomodate resolution of the Non-routine before Log Date
993: FND_MSG_PUB.ADD;
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;

Line 1142: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_QUAL_APPR');

1138:
1139: END IF;
1140: /*
1141: ELSE
1142: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_QUAL_APPR');
1143: -- Cannot modify MEL/CDL Instructions for Non-routine pending for MEL/CDL approval or already approved
1144: FND_MSG_PUB.ADD;
1145: */
1146: END IF;

Line 1423: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_UE_INVALID');

1419: OPEN unit_effect_csr (p_ue_id);
1420: FETCH unit_effect_csr INTO l_ue_rec;
1421: IF (unit_effect_csr%NOTFOUND) THEN
1422: CLOSE unit_effect_csr;
1423: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_UE_INVALID');
1424: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);
1425: FND_MSG_PUB.ADD;
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF (l_ue_rec.object_version_number <> p_ue_object_version) THEN

Line 1424: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);

1420: FETCH unit_effect_csr INTO l_ue_rec;
1421: IF (unit_effect_csr%NOTFOUND) THEN
1422: CLOSE unit_effect_csr;
1423: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_UE_INVALID');
1424: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);
1425: FND_MSG_PUB.ADD;
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF (l_ue_rec.object_version_number <> p_ue_object_version) THEN
1428: CLOSE unit_effect_csr;

Line 1429: FND_MESSAGE.Set_Name('AHL','AHL_COM_CHANGED');

1425: FND_MSG_PUB.ADD;
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF (l_ue_rec.object_version_number <> p_ue_object_version) THEN
1428: CLOSE unit_effect_csr;
1429: FND_MESSAGE.Set_Name('AHL','AHL_COM_CHANGED');
1430: FND_MSG_PUB.ADD;
1431: RAISE FND_API.G_EXC_ERROR;
1432: END IF;
1433: CLOSE unit_effect_csr;

Line 1442: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');

1438: p_visit_id => null,
1439: p_item_instance_id => null) = FND_API.g_true THEN
1440: -- Unit is locked, therefore cannot proceed for approval.
1441: -- and cannot login to the workorder
1442: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');
1443: FND_MESSAGE.set_token('UE_ID', p_ue_id);
1444: FND_MSG_PUB.ADD;
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;

Line 1443: FND_MESSAGE.set_token('UE_ID', p_ue_id);

1439: p_item_instance_id => null) = FND_API.g_true THEN
1440: -- Unit is locked, therefore cannot proceed for approval.
1441: -- and cannot login to the workorder
1442: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UNITLCKED');
1443: FND_MESSAGE.set_token('UE_ID', p_ue_id);
1444: FND_MSG_PUB.ADD;
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447:

Line 1453: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NOT_PRD');

1449: OPEN visit_det_csr(p_ue_id);
1450: FETCH visit_det_csr INTO l_junk;
1451: IF (visit_det_csr%NOTFOUND) THEN
1452: CLOSE visit_det_csr;
1453: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NOT_PRD');
1454: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;

Line 1454: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);

1450: FETCH visit_det_csr INTO l_junk;
1451: IF (visit_det_csr%NOTFOUND) THEN
1452: CLOSE visit_det_csr;
1453: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NOT_PRD');
1454: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458: CLOSE visit_det_csr;

Line 1465: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NOT_DEFER');

1461: OPEN ue_deferral_csr(p_ue_id);
1462: FETCH ue_deferral_csr INTO l_deferral_rec;
1463: IF (ue_deferral_csr%NOTFOUND) THEN
1464: CLOSE ue_deferral_csr;
1465: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NOT_DEFER');
1466: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);
1467: FND_MSG_PUB.ADD;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;

Line 1466: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);

1462: FETCH ue_deferral_csr INTO l_deferral_rec;
1463: IF (ue_deferral_csr%NOTFOUND) THEN
1464: CLOSE ue_deferral_csr;
1465: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NOT_DEFER');
1466: FND_MESSAGE.Set_Token('UE_ID',p_ue_id);
1467: FND_MSG_PUB.ADD;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: CLOSE ue_deferral_csr;

Line 1473: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_APPR_STATUS_INVALID');

1469: END IF;
1470: CLOSE ue_deferral_csr;
1471:
1472: IF (l_deferral_rec.approval_status_code IN ('DEFERRED','DEFERRAL_PENDING')) THEN
1473: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_APPR_STATUS_INVALID');
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:

Line 1479: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NO_SYS_SEQ_ASSOC');

1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478: IF (l_deferral_rec.ata_sequence_id IS NULL) THEN
1479: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_NO_SYS_SEQ_ASSOC');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: END IF;
1483:

Line 1489: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_IN_DEFER');

1485: OPEN ue_defer_csr(p_ue_id);
1486: FETCH ue_defer_csr INTO l_junk;
1487: IF (ue_defer_csr%FOUND) THEN
1488: CLOSE ue_defer_csr;
1489: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_IN_DEFER');
1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493: CLOSE ue_defer_csr;

Line 1500: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_CHILD_UE_DEFER');

1496: OPEN ue_defer_child_csr(p_ue_id);
1497: FETCH ue_defer_child_csr INTO l_junk;
1498: IF (ue_defer_child_csr%FOUND) THEN
1499: CLOSE ue_defer_child_csr;
1500: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_CHILD_UE_DEFER');
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_ERROR;
1503: END IF;
1504: CLOSE ue_defer_child_csr;

Line 1512: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_MEL_CDL_INVALID');

1508: OPEN mel_cdl_header_csr(l_deferral_rec.ata_sequence_id);
1509: FETCH mel_cdl_header_csr INTO l_installed_number, l_dispatch_number, l_repair_time;
1510: IF (mel_cdl_header_csr%NOTFOUND) THEN
1511: CLOSE mel_cdl_header_csr;
1512: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_MEL_CDL_INVALID');
1513: FND_MSG_PUB.ADD;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:

Line 1522: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_CS_INC_MISSING');

1518: OPEN get_exp_resolution_csr(l_ue_rec.cs_incident_id);
1519: FETCH get_exp_resolution_csr INTO l_expected_resolu_date;
1520: IF (get_exp_resolution_csr%NOTFOUND) THEN
1521: CLOSE get_exp_resolution_csr;
1522: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_CS_INC_MISSING');
1523: FND_MSG_PUB.ADD;
1524: RAISE FND_API.G_EXC_ERROR;
1525: ELSIF (nvl(l_repair_time, 0) = 0) AND (l_expected_resolu_date IS NULL) THEN
1526: CLOSE get_exp_resolution_csr;

Line 1527: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_RESOLUTION_MAND');

1523: FND_MSG_PUB.ADD;
1524: RAISE FND_API.G_EXC_ERROR;
1525: ELSIF (nvl(l_repair_time, 0) = 0) AND (l_expected_resolu_date IS NULL) THEN
1526: CLOSE get_exp_resolution_csr;
1527: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_RESOLUTION_MAND');
1528: FND_MSG_PUB.ADD;
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531: CLOSE get_exp_resolution_csr;

Line 1537: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_NO_ACCOM');

1533: /* Commented this validation to fix second issue reported in bug#7697685
1534: -- Bug #5230869 - validate inc_occ_date + rep_time >= inc_date
1535: IF (NVL(l_repair_time, 0) <> 0 AND trunc(l_deferral_rec.deferral_effective_on) + trunc(l_repair_time/24) < trunc(sysdate))
1536: THEN
1537: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_NO_ACCOM');
1538: -- Repair Time of the associated MEL/CDL Instructions cannot accomodate resolution of the Non-routine before Log Date
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;

Line 1547: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_APPR_MAND_INV');

1543:
1544: -- Validate log_series, number + unit_config are not null for NR that is being submitted for MEL/CDL deferral
1545: IF (l_ue_rec.unit_config_header_id is null or l_ue_rec.log_series_code is null or l_ue_rec.log_series_number is null)
1546: THEN
1547: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_APPR_MAND_INV');
1548: -- Unit, Log Series and Number are mandatory for submitting for MEL/CDL approval
1549: FND_MSG_PUB.ADD;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;

Line 1570: FND_MESSAGE.Set_Name('AHL','AHL_UMP_OPEN_NR_EXCEEDS');

1566: FETCH get_open_NRs_csr INTO l_NR_count;
1567: CLOSE get_open_NRs_csr;
1568:
1569: IF ((l_installed_number - l_NR_count) <= l_dispatch_number) THEN
1570: FND_MESSAGE.Set_Name('AHL','AHL_UMP_OPEN_NR_EXCEEDS');
1571: FND_MSG_PUB.ADD;
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;
1574: END IF;

Line 1715: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_INTERRELATION_ERROR');

1711: l_ue_rec.unit_config_header_id);
1712: FETCH get_open_NRs_csr INTO l_count;
1713: CLOSE get_open_NRs_csr;
1714: IF (l_count > 0) THEN
1715: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_INTERRELATION_ERROR');
1716: FND_MESSAGE.Set_token('SEQ1',l_deferral_rec.ata_sequence_id);
1717: FND_MESSAGE.Set_token('SEQ2',ata_seq_rec.ata_sequence_id);
1718: FND_MSG_PUB.ADD;
1719: END IF;

Line 1716: FND_MESSAGE.Set_token('SEQ1',l_deferral_rec.ata_sequence_id);

1712: FETCH get_open_NRs_csr INTO l_count;
1713: CLOSE get_open_NRs_csr;
1714: IF (l_count > 0) THEN
1715: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_INTERRELATION_ERROR');
1716: FND_MESSAGE.Set_token('SEQ1',l_deferral_rec.ata_sequence_id);
1717: FND_MESSAGE.Set_token('SEQ2',ata_seq_rec.ata_sequence_id);
1718: FND_MSG_PUB.ADD;
1719: END IF;
1720:

Line 1717: FND_MESSAGE.Set_token('SEQ2',ata_seq_rec.ata_sequence_id);

1713: CLOSE get_open_NRs_csr;
1714: IF (l_count > 0) THEN
1715: FND_MESSAGE.Set_Name('AHL','AHL_UMP_NR_INTERRELATION_ERROR');
1716: FND_MESSAGE.Set_token('SEQ1',l_deferral_rec.ata_sequence_id);
1717: FND_MESSAGE.Set_token('SEQ2',ata_seq_rec.ata_sequence_id);
1718: FND_MSG_PUB.ADD;
1719: END IF;
1720:
1721: END LOOP;

Line 1898: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_NR_MULTI_PARAM');

1894: -- Check for multiple inputs.
1895: IF (p_mel_cdl_header_id IS NOT NULL AND p_pc_node_id IS NOT NULL)
1896: THEN
1897: -- return error.
1898: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_NR_MULTI_PARAM');
1899: FND_MSG_PUB.ADD;
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1901: END IF;
1902:

Line 2290: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_NULL');

2286: /*
2287: -- Validate unit_config_header_id NOT NULL
2288: IF (p_x_nonroutine_rec.unit_config_header_id is null or p_x_nonroutine_rec.unit_config_header_id = FND_API.G_MISS_NUM)
2289: THEN
2290: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_NULL');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: */
2294:

Line 2310: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_QUAR_INV');

2306: THEN
2307: p_x_nonroutine_rec.unit_config_header_id := l_uc_header_id;
2308: ELSIF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
2309: THEN
2310: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_QUAR_INV');
2311: FND_MSG_PUB.ADD;
2312: RAISE FND_API.G_EXC_ERROR;
2313: END IF;
2314: ELSE

Line 2319: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_QUAR_INV');

2315: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(p_x_nonroutine_rec.unit_config_header_id);
2316: -- Check for not active and/or quarantined unit
2317: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
2318: THEN
2319: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_QUAR_INV');
2320: FND_MSG_PUB.ADD;
2321: RAISE FND_API.G_EXC_ERROR;
2322: ELSIF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2323: THEN

Line 2328: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_NOMATCH');

2324: -- Validate instance exists on the unit specified... Assume instance is validated before this is called...
2325: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2326: IF (NVL(l_uc_header_id, -1 ) <> p_x_nonroutine_rec.unit_config_header_id)
2327: THEN
2328: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_NOMATCH');
2329: FND_MSG_PUB.ADD;
2330: RAISE FND_API.G_EXC_ERROR;
2331: END IF;
2332: ELSE

Line 2333: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_ACTV_INV');

2329: FND_MSG_PUB.ADD;
2330: RAISE FND_API.G_EXC_ERROR;
2331: END IF;
2332: ELSE
2333: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_ACTV_INV');
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;
2337: END IF;

Line 2358: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');

2354: x_return_val => l_ret_val
2355: );
2356: IF NOT (l_ret_val)
2357: THEN
2358: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');
2359: -- Log Series is invalid
2360: FND_MSG_PUB.ADD;
2361: END IF;
2362: END IF;

Line 2366: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');

2362: END IF;
2363: ELSE
2364: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_LOG_SERIES_CODE', p_x_nonroutine_rec.log_series_code))
2365: THEN
2366: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');
2367: -- Log Series is invalid
2368: FND_MSG_PUB.ADD;
2369: END IF;
2370: END IF;

Line 2374: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_LOGNUM_INV');

2370: END IF;
2371:
2372: IF (p_x_nonroutine_rec.log_series_number IS NOT NULL AND p_x_nonroutine_rec.log_series_number <> FND_API.G_MISS_NUM AND p_x_nonroutine_rec.log_series_number < 0)
2373: THEN
2374: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_LOGNUM_INV');
2375: -- Non-routine Log Number must be a positive integer
2376: FND_MSG_PUB.ADD;
2377: END IF;
2378:

Line 2391: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_COMB');

2387: AND
2388: (p_x_nonroutine_rec.log_series_number IS NULL OR p_x_nonroutine_rec.log_series_number = FND_API.G_MISS_NUM)
2389: )
2390: THEN
2391: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_COMB');
2392: -- If Log Series is selected, Log Number is mandatory and vice-versa.
2393: FND_MSG_PUB.ADD;
2394: END IF;
2395:

Line 2406: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_INV');

2402: OPEN check_lognum_unique;
2403: FETCH check_lognum_unique INTO l_dummy_varchar;
2404: IF (check_lognum_unique%FOUND)
2405: THEN
2406: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_INV');
2407: FND_MESSAGE.SET_TOKEN('LOGNUM', p_x_nonroutine_rec.log_series_code||'-'||p_x_nonroutine_rec.log_series_number);
2408: -- Log Number already exists for another non-routine
2409: FND_MSG_PUB.ADD;
2410: END IF;

Line 2407: FND_MESSAGE.SET_TOKEN('LOGNUM', p_x_nonroutine_rec.log_series_code||'-'||p_x_nonroutine_rec.log_series_number);

2403: FETCH check_lognum_unique INTO l_dummy_varchar;
2404: IF (check_lognum_unique%FOUND)
2405: THEN
2406: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_INV');
2407: FND_MESSAGE.SET_TOKEN('LOGNUM', p_x_nonroutine_rec.log_series_code||'-'||p_x_nonroutine_rec.log_series_number);
2408: -- Log Number already exists for another non-routine
2409: FND_MSG_PUB.ADD;
2410: END IF;
2411: CLOSE check_lognum_unique;

Line 2429: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_NOCHG');

2425: p_x_nonroutine_rec.log_series_number IS NULL OR p_x_nonroutine_rec.log_series_number = FND_API.G_MISS_NUM
2426: )
2427: )
2428: THEN
2429: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_NOCHG');
2430: -- Log Series is mandatory for Non-Routines that have MEL/CDL Instruction associated.
2431: FND_MSG_PUB.ADD;
2432: END IF;
2433: CLOSE is_ue_mel_cdl_qual;

Line 2444: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');

2440: IF (p_x_nonroutine_rec.log_series_code IS NULL OR p_x_nonroutine_rec.log_series_code = FND_API.G_MISS_CHAR)
2441: THEN
2442: IF (p_x_nonroutine_rec.log_series_meaning IS NULL OR p_x_nonroutine_rec.log_series_meaning = FND_API.G_MISS_CHAR)
2443: THEN
2444: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_MAND');
2445: -- Log Series is mandatory
2446: FND_MSG_PUB.ADD;
2447: ELSE
2448: AHL_UTIL_MC_PKG.Convert_To_LookupCode

Line 2457: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');

2453: x_return_val => l_ret_val
2454: );
2455: IF NOT (l_ret_val)
2456: THEN
2457: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');
2458: -- Log Series is invalid
2459: FND_MSG_PUB.ADD;
2460: END IF;
2461: END IF;

Line 2465: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');

2461: END IF;
2462: ELSE
2463: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_LOG_SERIES_CODE', p_x_nonroutine_rec.log_series_code))
2464: THEN
2465: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_INV');
2466: -- Log Series is invalid
2467: FND_MSG_PUB.ADD;
2468: END IF;
2469: END IF;

Line 2474: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_NOCHG');

2470: ELSIF (p_dml_operation = 'U' AND l_ue_detail_rec.log_series_code IS NOT NULL)
2471: THEN
2472: IF (l_ue_detail_rec.log_series_code <> p_x_nonroutine_rec.log_series_code)
2473: THEN
2474: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGSER_NOCHG');
2475: -- Log Series cannot be modified after non-routine is created
2476: FND_MSG_PUB.ADD;
2477: END IF;
2478: END IF;

Line 2491: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_INV');

2487: OPEN check_lognum_unique;
2488: FETCH check_lognum_unique INTO l_dummy_varchar;
2489: IF (check_lognum_unique%FOUND)
2490: THEN
2491: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_INV');
2492: -- Log Number already exists for another non-routine
2493: FND_MSG_PUB.ADD;
2494: END IF;
2495: CLOSE check_lognum_unique;

Line 2501: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_NOCHG');

2497: ELSIF (p_dml_operation = 'U' AND l_ue_detail_rec.log_series_number IS NOT NULL)
2498: THEN
2499: IF (l_ue_detail_rec.log_series_number <> p_x_nonroutine_rec.log_series_number)
2500: THEN
2501: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_LOGNUM_NOCHG');
2502: -- Log Number cannot be modified after non-routine is created
2503: FND_MSG_PUB.ADD;
2504: END IF;
2505: END IF;

Line 2522: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_TYPE_INV');

2518: x_return_val => l_ret_val
2519: );
2520: IF NOT (l_ret_val)
2521: THEN
2522: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_TYPE_INV');
2523: -- Position ATA is invalid
2524: FND_MSG_PUB.ADD;
2525: END IF;
2526: END IF;

Line 2530: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_TYPE_INV');

2526: END IF;
2527: ELSE
2528: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_MEL_CDL_TYPE', p_x_nonroutine_rec.mel_cdl_type_code))
2529: THEN
2530: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_TYPE_INV');
2531: -- Position ATA is invalid
2532: FND_MSG_PUB.ADD;
2533: END IF;
2534: END IF;

Line 2550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ATA_INV');

2546: x_return_val => l_ret_val
2547: );
2548: IF NOT (l_ret_val)
2549: THEN
2550: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ATA_INV');
2551: -- Position ATA is invalid
2552: FND_MSG_PUB.ADD;
2553: END IF;
2554: END IF;

Line 2558: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ATA_INV');

2554: END IF;
2555: ELSE
2556: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_ATA_CODE', p_x_nonroutine_rec.ata_code))
2557: THEN
2558: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ATA_INV');
2559: -- Position ATA is invalid
2560: FND_MSG_PUB.ADD;
2561: END IF;
2562: END IF;

Line 2585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_POSPATH_INV');

2581: OPEN check_pos_path_exists;
2582: FETCH check_pos_path_exists INTO l_dummy_varchar;
2583: IF (check_pos_path_exists%NOTFOUND)
2584: THEN
2585: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_POSPATH_INV');
2586: -- Position path does not exist on the unit
2587: FND_MSG_PUB.ADD;
2588: END IF;
2589: CLOSE check_pos_path_exists;

Line 2617: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_QUAL_APPR');

2613: AND
2614: l_ue_detail_rec.position_path_id <> p_x_nonroutine_rec.position_path_id
2615: )
2616: THEN
2617: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_QUAL_APPR');
2618: -- Cannot modify either of MEL/CDL Type, Position and Position ATA since Non-routine is either pending for MEL/CDL approval or already approved.
2619: FND_MSG_PUB.ADD;
2620: END IF;
2621: END IF;

Line 2633: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ORG_INV');

2629: OPEN get_org_id_from_name(p_x_nonroutine_rec.clear_station_org);
2630: FETCH get_org_id_from_name INTO p_x_nonroutine_rec.clear_station_org_id;
2631: IF (get_org_id_from_name%NOTFOUND)
2632: THEN
2633: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ORG_INV');
2634: -- Clear station organization is invalid
2635: FND_MSG_PUB.ADD;
2636: END IF;
2637: CLOSE get_org_id_from_name;

Line 2644: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ORG_INV');

2640: OPEN check_org_id(p_x_nonroutine_rec.clear_station_org_id);
2641: FETCH check_org_id INTO l_dummy_varchar;
2642: IF (check_org_id%NOTFOUND)
2643: THEN
2644: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_ORG_INV');
2645: -- Clear station organization is invalid
2646: FND_MSG_PUB.ADD;
2647: END IF;
2648: CLOSE check_org_id;

Line 2660: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_DEPT_INV');

2656: OPEN get_dept_id_from_name(p_x_nonroutine_rec.clear_station_dept, p_x_nonroutine_rec.clear_station_org_id);
2657: FETCH get_dept_id_from_name INTO p_x_nonroutine_rec.clear_station_dept_id;
2658: IF (get_dept_id_from_name%NOTFOUND)
2659: THEN
2660: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_DEPT_INV');
2661: -- Clear station department is invalid
2662: FND_MSG_PUB.ADD;
2663: END IF;
2664: CLOSE get_dept_id_from_name;

Line 2671: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_DEPT_INV');

2667: OPEN check_dept_id(p_x_nonroutine_rec.clear_station_dept_id, p_x_nonroutine_rec.clear_station_org_id);
2668: FETCH check_dept_id INTO l_dummy_varchar;
2669: IF (check_dept_id%NOTFOUND)
2670: THEN
2671: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_NR_DEPT_INV');
2672: -- Clear station department is invalid
2673: FND_MSG_PUB.ADD;
2674: END IF;
2675: CLOSE check_dept_id;

Line 2773: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_TYPE_MAND');

2769: END IF;
2770:
2771: IF (l_ue_details_rec.mel_cdl_type_code IS NULL OR l_ue_details_rec.mel_cdl_type_code = FND_API.G_MISS_CHAR)
2772: THEN
2773: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_TYPE_MAND');
2774: -- MEL/CDL Type is mandatory, hence cannot qualify for MEL/CDL
2775: FND_MSG_PUB.ADD;
2776: END IF;
2777:

Line 2791: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_SETUP_MAND');

2787: END IF;
2788:
2789: IF (l_mel_cdl_header_id IS NULL)
2790: THEN
2791: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_SETUP_MAND');
2792: FND_MESSAGE.SET_TOKEN('UCNAME', l_ue_details_rec.unit_config_name);
2793: -- No MEL/CDL has been setup for the unit "UCNAME", hence cannot qualify for MEL/CDL
2794: FND_MSG_PUB.ADD;
2795: ELSE

Line 2792: FND_MESSAGE.SET_TOKEN('UCNAME', l_ue_details_rec.unit_config_name);

2788:
2789: IF (l_mel_cdl_header_id IS NULL)
2790: THEN
2791: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_SETUP_MAND');
2792: FND_MESSAGE.SET_TOKEN('UCNAME', l_ue_details_rec.unit_config_name);
2793: -- No MEL/CDL has been setup for the unit "UCNAME", hence cannot qualify for MEL/CDL
2794: FND_MSG_PUB.ADD;
2795: ELSE
2796: IF (

Line 2802: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_ALL_NULL');

2798: AND
2799: (l_ue_details_rec.position_path_id IS NULL OR l_ue_details_rec.position_path_id = FND_API.G_MISS_NUM)
2800: )
2801: THEN
2802: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_ALL_NULL');
2803: -- One of Position ATA and Position is mandatory, hence cannot qualify for MEL/CDL
2804: FND_MSG_PUB.ADD;
2805: END IF;
2806:

Line 2857: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_POS_ATA_NO_MATCH');

2853: -- matches with the Position ATA Code entered.
2854: -- If it does not match , throw an error .
2855: IF (l_ata_for_position <> p_ata_code)
2856: THEN
2857: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_POS_ATA_NO_MATCH');
2858: -- ATA code of the Position ATA and MC Position does not match .
2859: FND_MSG_PUB.ADD;
2860: RAISE FND_API.G_EXC_ERROR;
2861: END IF;

Line 2917: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_SEQ_FAIL');

2913: END IF;
2914:
2915: IF (x_ata_sequence_id IS NULL)
2916: THEN
2917: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_MEL_CDL_QUAL_SEQ_FAIL');
2918: -- Cannot retrieve any System Sequence information for non-routine, hence cannot qualify for MEL/CDL
2919: FND_MSG_PUB.ADD;
2920: END IF;
2921: END IF;

Line 2989: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INSTANCE_NULL');

2985: IF (p_x_nonroutine_rec.instance_number IS NULL OR p_x_nonroutine_rec.instance_number = FND_API.G_MISS_CHAR)
2986: THEN
2987: IF (p_x_nonroutine_rec.instance_id is null or p_x_nonroutine_rec.instance_id = FND_API.G_MISS_NUM)
2988: THEN
2989: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INSTANCE_NULL');
2990: FND_MSG_PUB.ADD;
2991: RAISE FND_API.G_EXC_ERROR;
2992: END IF;
2993: ELSE

Line 3006: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INSTANCE_INV');

3002: trunc(nvl(csi.active_end_date, sysdate+1)) > trunc(sysdate) and
3003: csi.instance_number = p_x_nonroutine_rec.instance_number;
3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INSTANCE_INV');
3007: FND_MESSAGE.SET_TOKEN('INSTANCE', p_x_nonroutine_rec.instance_number);
3008: FND_MSG_PUB.ADD;
3009: END;
3010: END IF;

Line 3007: FND_MESSAGE.SET_TOKEN('INSTANCE', p_x_nonroutine_rec.instance_number);

3003: csi.instance_number = p_x_nonroutine_rec.instance_number;
3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INSTANCE_INV');
3007: FND_MESSAGE.SET_TOKEN('INSTANCE', p_x_nonroutine_rec.instance_number);
3008: FND_MSG_PUB.ADD;
3009: END;
3010: END IF;
3011:

Line 3031: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_TYPE_INV');

3027: incident_subtype = 'INC' and
3028: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3029: EXCEPTION
3030: WHEN NO_DATA_FOUND THEN
3031: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_TYPE_INV');
3032: FND_MESSAGE.SET_TOKEN('TYPE', p_x_nonroutine_rec.type_name);
3033: FND_MSG_PUB.ADD;
3034: END;
3035: ELSIF (p_x_nonroutine_rec.type_id is null or p_x_nonroutine_rec.type_id = FND_API.G_MISS_NUM)

Line 3032: FND_MESSAGE.SET_TOKEN('TYPE', p_x_nonroutine_rec.type_name);

3028: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3029: EXCEPTION
3030: WHEN NO_DATA_FOUND THEN
3031: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_TYPE_INV');
3032: FND_MESSAGE.SET_TOKEN('TYPE', p_x_nonroutine_rec.type_name);
3033: FND_MSG_PUB.ADD;
3034: END;
3035: ELSIF (p_x_nonroutine_rec.type_id is null or p_x_nonroutine_rec.type_id = FND_API.G_MISS_NUM)
3036: THEN

Line 3041: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_TYPE_NULL');

3037: p_x_nonroutine_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
3038:
3039: IF (p_x_nonroutine_rec.type_id is null or p_x_nonroutine_rec.type_id = FND_API.G_MISS_NUM)
3040: THEN
3041: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_TYPE_NULL');
3042: FND_MSG_PUB.ADD;
3043: END IF;
3044: END IF;
3045:

Line 3057: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_STATUS_INV');

3053: WHERE name = p_x_nonroutine_rec.status_name and
3054: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3055: EXCEPTION
3056: WHEN NO_DATA_FOUND THEN
3057: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_STATUS_INV');
3058: FND_MESSAGE.SET_TOKEN('STATUS', p_x_nonroutine_rec.status_name);
3059: FND_MSG_PUB.ADD;
3060: END;
3061: ELSIF (p_x_nonroutine_rec.status_id is null or p_x_nonroutine_rec.status_id = FND_API.G_MISS_NUM)

Line 3058: FND_MESSAGE.SET_TOKEN('STATUS', p_x_nonroutine_rec.status_name);

3054: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3055: EXCEPTION
3056: WHEN NO_DATA_FOUND THEN
3057: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_STATUS_INV');
3058: FND_MESSAGE.SET_TOKEN('STATUS', p_x_nonroutine_rec.status_name);
3059: FND_MSG_PUB.ADD;
3060: END;
3061: ELSIF (p_x_nonroutine_rec.status_id is null or p_x_nonroutine_rec.status_id = FND_API.G_MISS_NUM)
3062: THEN

Line 3077: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEVERITY_INV');

3073: WHERE name = p_x_nonroutine_rec.severity_name and
3074: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3075: EXCEPTION
3076: WHEN NO_DATA_FOUND THEN
3077: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEVERITY_INV');
3078: FND_MESSAGE.SET_TOKEN('SEVERITY', p_x_nonroutine_rec.severity_name);
3079: FND_MSG_PUB.ADD;
3080: END;
3081: ELSIF (p_x_nonroutine_rec.severity_id is null or p_x_nonroutine_rec.severity_id = FND_API.G_MISS_NUM)

Line 3078: FND_MESSAGE.SET_TOKEN('SEVERITY', p_x_nonroutine_rec.severity_name);

3074: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3075: EXCEPTION
3076: WHEN NO_DATA_FOUND THEN
3077: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEVERITY_INV');
3078: FND_MESSAGE.SET_TOKEN('SEVERITY', p_x_nonroutine_rec.severity_name);
3079: FND_MSG_PUB.ADD;
3080: END;
3081: ELSIF (p_x_nonroutine_rec.severity_id is null or p_x_nonroutine_rec.severity_id = FND_API.G_MISS_NUM)
3082: THEN

Line 3087: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEVERITY_NULL');

3083: p_x_nonroutine_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');
3084:
3085: IF (p_x_nonroutine_rec.severity_id is null or p_x_nonroutine_rec.severity_id = FND_API.G_MISS_NUM)
3086: THEN
3087: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEVERITY_NULL');
3088: FND_MSG_PUB.ADD;
3089: END IF;
3090: END IF;
3091:

Line 3098: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEV_EAM_INV');

3094: THEN
3095: OPEN cs_severity_in_eam_priority;
3096: FETCH cs_severity_in_eam_priority INTO l_dummy_varchar;
3097: IF (cs_severity_in_eam_priority%NOTFOUND) THEN
3098: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SEV_EAM_INV');
3099: FND_MSG_PUB.ADD;
3100: END IF;
3101: CLOSE cs_severity_in_eam_priority;
3102: END IF;*/

Line 3124: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_INVALID');

3120: party_id = NVL(p_x_nonroutine_rec.customer_id, party_id);
3121: --AMSRINIV. Bug 5199456. Added last AND condition to the above query.
3122: EXCEPTION
3123: WHEN NO_DATA_FOUND THEN
3124: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_INVALID');
3125: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);
3126: FND_MSG_PUB.ADD;
3127: WHEN TOO_MANY_ROWS THEN
3128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_NOT_UNIQUE');

Line 3125: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);

3121: --AMSRINIV. Bug 5199456. Added last AND condition to the above query.
3122: EXCEPTION
3123: WHEN NO_DATA_FOUND THEN
3124: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_INVALID');
3125: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);
3126: FND_MSG_PUB.ADD;
3127: WHEN TOO_MANY_ROWS THEN
3128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_NOT_UNIQUE');
3129: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);

Line 3128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_NOT_UNIQUE');

3124: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_INVALID');
3125: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);
3126: FND_MSG_PUB.ADD;
3127: WHEN TOO_MANY_ROWS THEN
3128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_NOT_UNIQUE');
3129: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);
3130: FND_MSG_PUB.ADD;
3131: END;
3132:

Line 3129: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);

3125: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);
3126: FND_MSG_PUB.ADD;
3127: WHEN TOO_MANY_ROWS THEN
3128: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CUST_NAME_NOT_UNIQUE');
3129: FND_MESSAGE.SET_TOKEN('CUST_NAME', p_x_nonroutine_rec.customer_name);
3130: FND_MSG_PUB.ADD;
3131: END;
3132:
3133: -- Validate user-input customer against instance owner...

Line 3136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_CUSTOMER_NOMATCH');

3132:
3133: -- Validate user-input customer against instance owner...
3134: IF (nvl(p_x_nonroutine_rec.customer_id, -1) <> l_instance_owner_id)
3135: THEN
3136: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_CUSTOMER_NOMATCH');
3137: FND_MSG_PUB.ADD;
3138: END IF;
3139: ELSIF (p_x_nonroutine_rec.customer_id IS NULL or p_x_nonroutine_rec.customer_id = FND_API.G_MISS_NUM)
3140: THEN

Line 3163: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_CUST_TYPE_NULL');

3159: AND
3160: (p_x_nonroutine_rec.customer_type is null or p_x_nonroutine_rec.customer_type = FND_API.G_MISS_CHAR)
3161: )
3162: THEN
3163: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_CUST_TYPE_NULL');
3164: FND_MSG_PUB.ADD;
3165: END IF;
3166:
3167: -- Validate and contact name and type... Error if contact_type is NULL and contact_id NOT NULL

Line 3190: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_CONT_TYPE_INV');

3186: FROM per_people_x
3187: WHERE full_name = p_x_nonroutine_rec.contact_name and
3188: person_id = nvl(p_x_nonroutine_rec.contact_id,person_id);
3189: ELSE
3190: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_CONT_TYPE_INV');
3191: FND_MESSAGE.SET_TOKEN('CONT_TYPE', p_x_nonroutine_rec.contact_type);
3192: FND_MSG_PUB.ADD;
3193: END IF;
3194: EXCEPTION

Line 3191: FND_MESSAGE.SET_TOKEN('CONT_TYPE', p_x_nonroutine_rec.contact_type);

3187: WHERE full_name = p_x_nonroutine_rec.contact_name and
3188: person_id = nvl(p_x_nonroutine_rec.contact_id,person_id);
3189: ELSE
3190: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_CONT_TYPE_INV');
3191: FND_MESSAGE.SET_TOKEN('CONT_TYPE', p_x_nonroutine_rec.contact_type);
3192: FND_MSG_PUB.ADD;
3193: END IF;
3194: EXCEPTION
3195: WHEN NO_DATA_FOUND THEN

Line 3196: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_INVALID');

3192: FND_MSG_PUB.ADD;
3193: END IF;
3194: EXCEPTION
3195: WHEN NO_DATA_FOUND THEN
3196: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_INVALID');
3197: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);
3198: FND_MSG_PUB.ADD;
3199: WHEN TOO_MANY_ROWS THEN
3200: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_NOT_UNIQUE');

Line 3197: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);

3193: END IF;
3194: EXCEPTION
3195: WHEN NO_DATA_FOUND THEN
3196: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_INVALID');
3197: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);
3198: FND_MSG_PUB.ADD;
3199: WHEN TOO_MANY_ROWS THEN
3200: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_NOT_UNIQUE');
3201: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);

Line 3200: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_NOT_UNIQUE');

3196: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_INVALID');
3197: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);
3198: FND_MSG_PUB.ADD;
3199: WHEN TOO_MANY_ROWS THEN
3200: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_NOT_UNIQUE');
3201: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);
3202: FND_MSG_PUB.ADD;
3203: END;
3204: END IF;

Line 3201: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);

3197: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);
3198: FND_MSG_PUB.ADD;
3199: WHEN TOO_MANY_ROWS THEN
3200: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_CONT_NAME_NOT_UNIQUE');
3201: FND_MESSAGE.SET_TOKEN('CONT_NAME', p_x_nonroutine_rec.contact_name);
3202: FND_MSG_PUB.ADD;
3203: END;
3204: END IF;
3205:

Line 3209: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SUMMARY_NULL');

3205:
3206: -- Error if problem_summary NULL
3207: IF (p_x_nonroutine_rec.problem_summary is null or p_x_nonroutine_rec.problem_summary = FND_API.G_MISS_CHAR)
3208: THEN
3209: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SUMMARY_NULL');
3210: FND_MSG_PUB.ADD;
3211: END IF;
3212:
3213: -- bachandr added following validation for Bug # 6447467 (Base ER # 5571440)

Line 3223: Fnd_Message.SET_NAME(G_APP_NAME,'AHL_PRD_RESL_CODE_REQ');

3219:
3220: IF ( p_x_nonroutine_rec.resolution_code IS NULL OR
3221: p_x_nonroutine_rec.resolution_code = FND_API.G_MISS_CHAR) THEN
3222:
3223: Fnd_Message.SET_NAME(G_APP_NAME,'AHL_PRD_RESL_CODE_REQ');
3224: Fnd_Msg_Pub.ADD;
3225: END IF;
3226:
3227: END IF;

Line 3232: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_EXP_RES_DATE_INV');

3228:
3229: -- Validate if expected resolution date is passed, it is greater than the incident date
3230: IF (p_x_nonroutine_rec.expected_resolution_date is not null and p_x_nonroutine_rec.expected_resolution_date <> FND_API.G_MISS_DATE and trunc(p_x_nonroutine_rec.expected_resolution_date) < trunc(sysdate))
3231: THEN
3232: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_EXP_RES_DATE_INV');
3233: FND_MSG_PUB.ADD;
3234: END IF;
3235:
3236: -- Validate if the incident date is greater than the sysdate

Line 3240: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INC_DATE_INV');

3236: -- Validate if the incident date is greater than the sysdate
3237: -- Changes made for Bug # 5183032
3238: IF (p_x_nonroutine_rec.incident_date is not null and p_x_nonroutine_rec.incident_date <> FND_API.G_MISS_DATE and trunc(p_x_nonroutine_rec.incident_date) > trunc(sysdate))
3239: THEN
3240: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_INC_DATE_INV');
3241: FND_MSG_PUB.ADD;
3242: END IF;
3243:
3244: --SALOGAN added the following for Complex Mx - Begin

Line 3250: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_CAM_DUP_REM_NR');

3246: IF(p_x_nonroutine_rec.type_id = fnd_profile.value('AHL_REMOVAL_NON_ROUTINE')) THEN
3247: OPEN cr_duplicate_removal_nr(p_x_nonroutine_rec.instance_id);
3248: FETCH cr_duplicate_removal_nr into l_c_nr_num;
3249: IF(cr_duplicate_removal_nr%FOUND) THEN
3250: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_CAM_DUP_REM_NR');
3251: FND_MESSAGE.Set_Token('SR_NUM', l_c_nr_num);
3252: FND_MSG_PUB.ADD;
3253: CLOSE cr_duplicate_removal_nr;
3254: RAISE FND_API.G_EXC_ERROR;

Line 3251: FND_MESSAGE.Set_Token('SR_NUM', l_c_nr_num);

3247: OPEN cr_duplicate_removal_nr(p_x_nonroutine_rec.instance_id);
3248: FETCH cr_duplicate_removal_nr into l_c_nr_num;
3249: IF(cr_duplicate_removal_nr%FOUND) THEN
3250: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_CAM_DUP_REM_NR');
3251: FND_MESSAGE.Set_Token('SR_NUM', l_c_nr_num);
3252: FND_MSG_PUB.ADD;
3253: CLOSE cr_duplicate_removal_nr;
3254: RAISE FND_API.G_EXC_ERROR;
3255: END IF;

Line 3267: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_INC_INV');

3263: OPEN cs_incident_exists;
3264: FETCH cs_incident_exists INTO l_incident_number, l_incident_date;
3265: IF (cs_incident_exists%NOTFOUND)
3266: THEN
3267: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_INC_INV');
3268: FND_MSG_PUB.ADD;
3269: CLOSE cs_incident_exists;
3270: RAISE FND_API.G_EXC_ERROR;
3271: ELSIF (l_incident_number <> p_x_nonroutine_rec.incident_number)

Line 3273: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_NUM_INV');

3269: CLOSE cs_incident_exists;
3270: RAISE FND_API.G_EXC_ERROR;
3271: ELSIF (l_incident_number <> p_x_nonroutine_rec.incident_number)
3272: THEN
3273: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_NUM_INV');
3274: FND_MSG_PUB.ADD;
3275: CLOSE cs_incident_exists;
3276: RAISE FND_API.G_EXC_ERROR;
3277: END IF;

Line 3283: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_STATUS_NULL');

3279:
3280: -- Validate status_id is not null
3281: IF (p_x_nonroutine_rec.status_id is null or p_x_nonroutine_rec.status_id = FND_API.G_MISS_NUM)
3282: THEN
3283: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_STATUS_NULL');
3284: FND_MSG_PUB.ADD;
3285: END IF;
3286:
3287: -- Validate type_id is not null

Line 3290: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_TYPE_NULL');

3286:
3287: -- Validate type_id is not null
3288: IF (p_x_nonroutine_rec.type_id is null or p_x_nonroutine_rec.type_id = FND_API.G_MISS_NUM)
3289: THEN
3290: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_UMP_NR_TYPE_NULL');
3291: FND_MSG_PUB.ADD;
3292: END IF;
3293:
3294: -- Error if problem_summary NULL

Line 3297: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SUMMARY_NULL');

3293:
3294: -- Error if problem_summary NULL
3295: IF (p_x_nonroutine_rec.problem_summary is null or p_x_nonroutine_rec.problem_summary = FND_API.G_MISS_CHAR)
3296: THEN
3297: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_SUMMARY_NULL');
3298: FND_MSG_PUB.ADD;
3299: END IF;
3300:
3301: -- bachandr added following validation for Bug # 6447467 (Base ER # 5571440)

Line 3311: Fnd_Message.SET_NAME(G_APP_NAME,'AHL_PRD_RESL_CODE_REQ');

3307:
3308: IF ( p_x_nonroutine_rec.resolution_code IS NULL OR
3309: p_x_nonroutine_rec.resolution_code = FND_API.G_MISS_CHAR) THEN
3310:
3311: Fnd_Message.SET_NAME(G_APP_NAME,'AHL_PRD_RESL_CODE_REQ');
3312: Fnd_Msg_Pub.ADD;
3313: END IF;
3314:
3315: END IF;

Line 3321: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_EXP_RES_DATE_INV');

3317: -- Validate if the expected resolution date is not null and that it is not lesser than the Incident Request Date
3318: -- Changes made for Bug # 5183032
3319: IF (p_x_nonroutine_rec.expected_resolution_date is not null and p_x_nonroutine_rec.expected_resolution_date <> FND_API.G_MISS_DATE and trunc(p_x_nonroutine_rec.expected_resolution_date) < trunc(l_incident_date))
3320: THEN
3321: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_EXP_RES_DATE_INV');
3322: FND_MSG_PUB.ADD;
3323: END IF;
3324:
3325: --SALOGAN added the following for Complex Mx - Begin

Line 3331: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_CAM_DUP_REM_NR');

3327: IF(p_x_nonroutine_rec.type_id = fnd_profile.value('AHL_REMOVAL_NON_ROUTINE')) THEN
3328: OPEN upd_duplicate_removal_nr(p_x_nonroutine_rec.instance_id, p_x_nonroutine_rec.incident_id);
3329: FETCH upd_duplicate_removal_nr into l_c_nr_num;
3330: IF(upd_duplicate_removal_nr%FOUND) THEN
3331: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_CAM_DUP_REM_NR');
3332: FND_MESSAGE.Set_Token('SR_NUM', l_c_nr_num);
3333: FND_MSG_PUB.ADD;
3334: CLOSE upd_duplicate_removal_nr;
3335: RAISE FND_API.G_EXC_ERROR;

Line 3332: FND_MESSAGE.Set_Token('SR_NUM', l_c_nr_num);

3328: OPEN upd_duplicate_removal_nr(p_x_nonroutine_rec.instance_id, p_x_nonroutine_rec.incident_id);
3329: FETCH upd_duplicate_removal_nr into l_c_nr_num;
3330: IF(upd_duplicate_removal_nr%FOUND) THEN
3331: FND_MESSAGE.SET_NAME(G_APP_NAME,'AHL_CAM_DUP_REM_NR');
3332: FND_MESSAGE.Set_Token('SR_NUM', l_c_nr_num);
3333: FND_MSG_PUB.ADD;
3334: CLOSE upd_duplicate_removal_nr;
3335: RAISE FND_API.G_EXC_ERROR;
3336: END IF;

Line 3533: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_INC_ERROR');

3529: OPEN cs_inc_csr(p_cs_incident_id);
3530: FETCH cs_inc_csr INTO l_inc_rec;
3531: IF (cs_inc_csr%NOTFOUND) THEN
3532: CLOSE cs_inc_csr;
3533: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_INC_ERROR');
3534: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);
3535: FND_MSG_PUB.ADD;
3536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3537: END IF;

Line 3534: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);

3530: FETCH cs_inc_csr INTO l_inc_rec;
3531: IF (cs_inc_csr%NOTFOUND) THEN
3532: CLOSE cs_inc_csr;
3533: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_INC_ERROR');
3534: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);
3535: FND_MSG_PUB.ADD;
3536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3537: END IF;
3538:

Line 3550: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_ATA_ERROR');

3546: OPEN get_urgency_details_csr (p_ata_sequence_id);
3547: FETCH get_urgency_details_csr INTO l_repair_time, l_sr_urgency_id;
3548: IF (get_urgency_details_csr%NOTFOUND) THEN
3549: CLOSE get_urgency_details_csr;
3550: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_ATA_ERROR');
3551: FND_MESSAGE.set_token('ATA_ID', p_ata_sequence_id);
3552: FND_MSG_PUB.ADD;
3553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3554: END IF;

Line 3551: FND_MESSAGE.set_token('ATA_ID', p_ata_sequence_id);

3547: FETCH get_urgency_details_csr INTO l_repair_time, l_sr_urgency_id;
3548: IF (get_urgency_details_csr%NOTFOUND) THEN
3549: CLOSE get_urgency_details_csr;
3550: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_ATA_ERROR');
3551: FND_MESSAGE.set_token('ATA_ID', p_ata_sequence_id);
3552: FND_MSG_PUB.ADD;
3553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3554: END IF;
3555: CLOSE get_urgency_details_csr;

Line 3638: fnd_message.set_name('AHL','AHL_PRD_SR_SUMMARY');

3634: Open GetWoName(p_unit_effectivity_id);
3635: Fetch GetWoName into l_wo_name, l_visit_id, l_scheduled_start_date, l_close_date_time;
3636: Close GetWoName;
3637:
3638: fnd_message.set_name('AHL','AHL_PRD_SR_SUMMARY');
3639: fnd_message.set_token('WORKORDER_NUM',rtrim(l_wo_name));
3640: fnd_message.set_token('INC_NUM', rtrim(l_inc_rec.incident_number));
3641: l_summary := fnd_message.get;
3642:

Line 3639: fnd_message.set_token('WORKORDER_NUM',rtrim(l_wo_name));

3635: Fetch GetWoName into l_wo_name, l_visit_id, l_scheduled_start_date, l_close_date_time;
3636: Close GetWoName;
3637:
3638: fnd_message.set_name('AHL','AHL_PRD_SR_SUMMARY');
3639: fnd_message.set_token('WORKORDER_NUM',rtrim(l_wo_name));
3640: fnd_message.set_token('INC_NUM', rtrim(l_inc_rec.incident_number));
3641: l_summary := fnd_message.get;
3642:
3643: -- log debug message.

Line 3640: fnd_message.set_token('INC_NUM', rtrim(l_inc_rec.incident_number));

3636: Close GetWoName;
3637:
3638: fnd_message.set_name('AHL','AHL_PRD_SR_SUMMARY');
3639: fnd_message.set_token('WORKORDER_NUM',rtrim(l_wo_name));
3640: fnd_message.set_token('INC_NUM', rtrim(l_inc_rec.incident_number));
3641: l_summary := fnd_message.get;
3642:
3643: -- log debug message.
3644: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN

Line 3641: l_summary := fnd_message.get;

3637:
3638: fnd_message.set_name('AHL','AHL_PRD_SR_SUMMARY');
3639: fnd_message.set_token('WORKORDER_NUM',rtrim(l_wo_name));
3640: fnd_message.set_token('INC_NUM', rtrim(l_inc_rec.incident_number));
3641: l_summary := fnd_message.get;
3642:
3643: -- log debug message.
3644: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3645: fnd_log.string(G_DEBUG_STMT,'ahl.plsql.AHL_UMP_NONROUTINES_PVT.Process_MO_Procedures',

Line 3654: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_INCIDENT_ERROR');

3650: Open default_incident_type_csr;
3651: Fetch default_incident_type_csr INTO l_incident_type_id;
3652: IF ( default_incident_type_csr%NOTFOUND) THEN
3653: CLOSE default_incident_type_csr;
3654: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_INCIDENT_ERROR');
3655: Fnd_Msg_Pub.ADD;
3656: RAISE FND_API.G_EXC_ERROR;
3657: END IF;
3658: CLOSE default_incident_type_csr;

Line 3700: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_ORG_ERROR');

3696: open default_item_org_id(p_unit_effectivity_id);
3697: Fetch default_item_org_id INTO l_service_request_rec.inventory_item_id,
3698: l_service_request_rec.inventory_org_id;
3699: IF (default_item_org_id%NOTFOUND ) THEN
3700: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_ORG_ERROR');
3701: Fnd_Msg_Pub.ADD;
3702: RAISE FND_API.G_EXC_ERROR;
3703: END IF;
3704:

Line 3755: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');

3751: OPEN get_ue_detls (l_new_incident_id);
3752: FETCH get_ue_detls INTO l_cs_object_version, l_new_ue_id;
3753: IF (get_ue_detls%NOTFOUND) THEN
3754: CLOSE get_ue_detls;
3755: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');
3756: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);
3757: FND_MSG_PUB.ADD;
3758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3759: END IF;

Line 3756: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);

3752: FETCH get_ue_detls INTO l_cs_object_version, l_new_ue_id;
3753: IF (get_ue_detls%NOTFOUND) THEN
3754: CLOSE get_ue_detls;
3755: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_ERROR');
3756: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);
3757: FND_MSG_PUB.ADD;
3758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3759: END IF;
3760:

Line 3937: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_DEF_MISSING');

3933: OPEN deferral_ue_csr(p_unit_deferral_id);
3934: FETCH deferral_ue_csr INTO l_deferral_rec;
3935: IF (deferral_ue_csr%NOTFOUND) THEN
3936: CLOSE deferral_ue_csr;
3937: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_DEF_MISSING');
3938: FND_MESSAGE.set_token('UE_DEF', p_unit_deferral_id);
3939: FND_MSG_PUB.ADD;
3940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3941: END IF;

Line 3938: FND_MESSAGE.set_token('UE_DEF', p_unit_deferral_id);

3934: FETCH deferral_ue_csr INTO l_deferral_rec;
3935: IF (deferral_ue_csr%NOTFOUND) THEN
3936: CLOSE deferral_ue_csr;
3937: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_UE_DEF_MISSING');
3938: FND_MESSAGE.set_token('UE_DEF', p_unit_deferral_id);
3939: FND_MSG_PUB.ADD;
3940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3941: END IF;
3942: CLOSE deferral_ue_csr;

Line 3949: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_NEW_UE_MISSING');

3945: OPEN get_new_ue_csr(p_cs_incident_id);
3946: FETCH get_new_ue_csr INTO l_new_cs_ue_id;
3947: IF (get_new_ue_csr%NOTFOUND) THEN
3948: CLOSE get_new_ue_csr;
3949: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_NEW_UE_MISSING');
3950: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3953: END IF;

Line 3950: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);

3946: FETCH get_new_ue_csr INTO l_new_cs_ue_id;
3947: IF (get_new_ue_csr%NOTFOUND) THEN
3948: CLOSE get_new_ue_csr;
3949: FND_MESSAGE.set_name('AHL', 'AHL_UMP_NR_NEW_UE_MISSING');
3950: FND_MESSAGE.set_token('INC_ID', p_cs_incident_id);
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3953: END IF;
3954: CLOSE get_new_ue_csr;

Line 4076: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CAM_SR_ID_INVLD'); --AHL_WARRANTY_ENTL_ID_INVLD

4072:
4073: -- check for the entitlement id
4074: IF (p_sr_incident_id IS NULL) THEN
4075: x_return_status := FND_API.G_RET_STS_ERROR;
4076: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CAM_SR_ID_INVLD'); --AHL_WARRANTY_ENTL_ID_INVLD
4077: FND_MESSAGE.Set_Token('SR_ID', p_sr_incident_id);
4078: FND_MSG_PUB.ADD;
4079: RETURN;
4080: END IF;

Line 4077: FND_MESSAGE.Set_Token('SR_ID', p_sr_incident_id);

4073: -- check for the entitlement id
4074: IF (p_sr_incident_id IS NULL) THEN
4075: x_return_status := FND_API.G_RET_STS_ERROR;
4076: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_CAM_SR_ID_INVLD'); --AHL_WARRANTY_ENTL_ID_INVLD
4077: FND_MESSAGE.Set_Token('SR_ID', p_sr_incident_id);
4078: FND_MSG_PUB.ADD;
4079: RETURN;
4080: END IF;
4081:

Line 4108: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, l_warranty_entl_sbj);

4104:
4105: -- if the mapping is active, call the notification API
4106: If (l_active_flag = 'Y') THEN
4107: -- get the subject text
4108: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, l_warranty_entl_sbj);
4109:
4110: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
4111: FND_LOG.string(G_DEBUG_STMT, l_full_name,
4112: 'before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||