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_PP_RESRC_ASSIGN_PVT dependencies on FND_MESSAGE

Line 507: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);
504: END IF;
505:
506: /*IF SQL%rowcount = 0 THEN
507: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
508: Fnd_Msg_Pub.ADD;
509: END IF;*/
510: END UPDATE_ROW;
511:

Line 544: Fnd_Message.set_name ('AHL', 'AHL_PP_OPER_SEQ_MISSING');

540: IF (p_resrc_assign_rec.ASSIGNMENT_ID IS NULL OR p_resrc_assign_rec.ASSIGNMENT_ID = Fnd_Api.G_MISS_NUM) THEN
541: -- OPERATION_SEQ_NUMBER
542: IF (p_resrc_assign_rec.OPERATION_SEQ_NUMBER IS NULL OR p_resrc_assign_rec.OPERATION_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
543: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
544: Fnd_Message.set_name ('AHL', 'AHL_PP_OPER_SEQ_MISSING');
545: Fnd_Msg_Pub.ADD;
546: END IF;
547: x_return_status := Fnd_Api.g_ret_sts_error;
548: RETURN;

Line 555: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');

551: -- OPERATION_SEQ_NUMBER - Positive
552: IF (p_resrc_assign_rec.OPERATION_SEQ_NUMBER IS NOT NULL AND p_resrc_assign_rec.OPERATION_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
553: IF p_resrc_assign_rec.OPERATION_SEQ_NUMBER < 0 THEN
554: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
555: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
556: Fnd_Msg_Pub.ADD;
557: END IF;
558: x_return_status := Fnd_Api.g_ret_sts_error;
559: RETURN;

Line 566: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MISSING');

562:
563: -- RESOURCE_SEQ_NUMBER
564: IF (p_resrc_assign_rec.RESOURCE_SEQ_NUMBER IS NULL OR p_resrc_assign_rec.RESOURCE_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
565: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
566: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MISSING');
567: Fnd_Msg_Pub.ADD;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570: x_return_status := Fnd_Api.g_ret_sts_error;

Line 578: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');

574: -- RESOURCE_SEQ_NUMBER - Positive
575: IF (p_resrc_assign_rec.RESOURCE_SEQ_NUMBER IS NOT NULL AND p_resrc_assign_rec.RESOURCE_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
576: IF p_resrc_assign_rec.RESOURCE_SEQ_NUMBER < 0 THEN
577: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
578: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
579: Fnd_Msg_Pub.ADD;
580: END IF;
581: x_return_status := Fnd_Api.g_ret_sts_error;
582: RETURN;

Line 606: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');

602: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
603: END IF;
604:
605: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
606: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');
607: Fnd_Msg_Pub.ADD;
608: END IF;
609: x_return_status := Fnd_Api.g_ret_sts_error;
610: RETURN;

Line 619: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');

615: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
616: END IF;
617:
618: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
619: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');
620: Fnd_Msg_Pub.ADD;
621: END IF;
622: x_return_status := Fnd_Api.g_ret_sts_error;
623: RETURN;

Line 631: Fnd_Message.set_name ('AHL', 'AHL_PP_SERIAL_MISSING');

627: IF p_resrc_assign_rec.RESOURCE_TYPE_CODE <> 2 THEN
628: -- SERIAL NUMBER
629: IF (p_resrc_assign_rec.SERIAL_NUMBER IS NULL OR p_resrc_assign_rec.SERIAL_NUMBER = Fnd_Api.G_MISS_CHAR) THEN
630: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
631: Fnd_Message.set_name ('AHL', 'AHL_PP_SERIAL_MISSING');
632: Fnd_Msg_Pub.ADD;
633: END IF;
634: x_return_status := Fnd_Api.g_ret_sts_error;
635: RETURN;

Line 642: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_ST_DT_MISSING');

638:
639: -- ASSIGN_START_DATE
640: IF (p_resrc_assign_rec.ASSIGN_START_DATE IS NULL OR p_resrc_assign_rec.ASSIGN_START_DATE = Fnd_Api.G_MISS_DATE)THEN
641: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
642: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_ST_DT_MISSING');
643: Fnd_Msg_Pub.ADD;
644: END IF;
645: x_return_status := Fnd_Api.g_ret_sts_error;
646: RETURN;

Line 652: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_END_DT_MISSING');

648:
649: -- ASSIGN_END_DATE
650: IF (p_resrc_assign_rec.ASSIGN_END_DATE IS NULL OR p_resrc_assign_rec.ASSIGN_END_DATE = Fnd_Api.G_MISS_DATE)THEN
651: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
652: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_END_DT_MISSING');
653: Fnd_Msg_Pub.ADD;
654: END IF;
655: x_return_status := Fnd_Api.g_ret_sts_error;
656: RETURN;

Line 835: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_FROMDT_GTR_TODT');

831: ---End date must be greater than or equal to Start Date
832:
833: IF l_assign_start_date > l_assign_end_date THEN
834: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
835: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_FROMDT_GTR_TODT');
836: Fnd_Msg_Pub.ADD;
837: END IF;
838: x_return_status := Fnd_Api.g_ret_sts_error;
839: RETURN;

Line 856: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_ACTUAL');

852:
853: IF l_actual_start_date is not null and l_assign_start_date < l_actual_start_date THEN
854:
855: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
856: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_ACTUAL');
857: Fnd_Msg_Pub.ADD;
858: END IF;
859: x_return_status := Fnd_Api.g_ret_sts_error;
860: RETURN;

Line 866: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_ACTUAL');

862:
863: IF l_actual_end_date is not null and l_assign_end_date > l_actual_end_date THEN
864:
865: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
866: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_ACTUAL');
867: Fnd_Msg_Pub.ADD;
868: END IF;
869: x_return_status := Fnd_Api.g_ret_sts_error;
870: RETURN;

Line 878: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_SCHEDULE');

874:
875: IF l_scheduled_start_date is not null and l_assign_start_date < l_scheduled_start_date THEN
876:
877: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
878: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_SCHEDULE');
879: Fnd_Msg_Pub.ADD;
880: END IF;
881: x_return_status := Fnd_Api.g_ret_sts_error;
882: RETURN;

Line 888: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_SCHEDULE');

884:
885: IF l_scheduled_end_date is not null and l_assign_end_date > l_scheduled_end_date THEN
886:
887: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
888: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_SCHEDULE');
889: Fnd_Msg_Pub.ADD;
890: END IF;
891: x_return_status := Fnd_Api.g_ret_sts_error;
892: RETURN;

Line 913: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_STDT_GTR_EMP_STDT');

909: END IF;
910: /*
911: IF trunc(l_assign_start_date) < trunc(l_eff_st_date) THEN
912: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
913: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_STDT_GTR_EMP_STDT');
914: Fnd_Msg_Pub.ADD;
915: END IF;
916: x_return_status := Fnd_Api.g_ret_sts_error;
917: RETURN;

Line 922: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_ENDDT_GTR_ASG_ENDDT');

918: END IF;
919: */
920: IF trunc(l_assign_end_date) > trunc(l_eff_end_date) THEN
921: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
922: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_ENDDT_GTR_ASG_ENDDT');
923: Fnd_Msg_Pub.ADD;
924: END IF;
925: x_return_status := Fnd_Api.g_ret_sts_error;
926: RETURN;

Line 1260: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_REQ_NOT_EXISTS');

1256: p_x_resrc_assign_tbl(i).resource_seq_number);
1257: FETCH c_oper_resrc INTO l_oper_resrc_id, l_wo_operation_id,l_resource_id;
1258: IF c_oper_resrc%NOTFOUND THEN
1259: AHL_DEBUG_PUB.debug(l_full_name || 'c_oper_resrc i.e Cursor not found');
1260: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_REQ_NOT_EXISTS');
1261: Fnd_Msg_Pub.ADD;
1262: RAISE Fnd_Api.G_EXC_ERROR;
1263: END IF;
1264: CLOSE c_oper_resrc;

Line 1268: Fnd_Message.SET_NAME('AHL','AHL_PP_JOB_NOT_EXISTS');

1264: CLOSE c_oper_resrc;
1265:
1266: END IF; -- Check resrc sequence number
1267: ELSE
1268: Fnd_Message.SET_NAME('AHL','AHL_PP_JOB_NOT_EXISTS');
1269: Fnd_Msg_Pub.ADD;
1270: END IF; -- Check of work order id
1271:
1272: -- rroy

Line 1279: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_RESASG_UNTLCKD');

1275: p_ue_id => NULL,
1276: p_visit_id => NULL,
1277: p_item_instance_id => NULL);
1278: IF l_return_status = FND_API.G_TRUE THEN
1279: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_RESASG_UNTLCKD');
1280: FND_MSG_PUB.ADD;
1281: RAISE FND_API.G_EXC_ERROR;
1282: END IF;
1283: -- rroy

Line 1308: Fnd_Message.SET_NAME('AHL','AHL_PP_NO_RES_TYPE_FOUND');

1304: AHL_DEBUG_PUB.debug(l_full_name || 'c_resource i.e Cursor not found');
1305: END IF;
1306:
1307: CLOSE c_resource;
1308: Fnd_Message.SET_NAME('AHL','AHL_PP_NO_RES_TYPE_FOUND');
1309: Fnd_Msg_Pub.ADD;
1310: RAISE Fnd_Api.G_EXC_ERROR;
1311: END IF;
1312:

Line 1443: Fnd_Message.SET_NAME('AHL','AHL_PP_EMPLOYEE_NOT_REQ');

1439: /*IF ((l_Resrc_Assign_Rec.employee_number IS NOT NULL AND l_Resrc_Assign_Rec.employee_number <> Fnd_Api.G_MISS_CHAR)
1440: Ot
1441: (l_Resrc_Assign_Rec.employee_name IS NOT NULL AND l_Resrc_Assign_Rec.employee_name <> Fnd_Api.G_MISS_CHAR))
1442: THEN
1443: Fnd_Message.SET_NAME('AHL','AHL_PP_EMPLOYEE_NOT_REQ');
1444: Fnd_Msg_Pub.ADD;
1445: RAISE Fnd_Api.G_EXC_ERROR;
1446: END IF;*/
1447:

Line 1474: Fnd_Message.SET_NAME('AHL','AHL_PP_SERIAL_NOT_EXISTS');

1470: END IF;
1471:
1472: IF NVL(l_return_status,'x') <> 'S'
1473: THEN
1474: Fnd_Message.SET_NAME('AHL','AHL_PP_SERIAL_NOT_EXISTS');
1475: Fnd_Msg_Pub.ADD;
1476: RAISE Fnd_Api.G_EXC_ERROR;
1477: END IF;
1478: END IF;

Line 1501: Fnd_Message.SET_NAME('AHL','AHL_PP_EMPLOYEE_NOT_REQ');

1497: END IF;
1498:
1499: /*IF (l_Resrc_Assign_Rec.serial_number IS NOT NULL AND l_Resrc_Assign_Rec.serial_number <> Fnd_Api.G_MISS_CHAR)
1500: THEN
1501: Fnd_Message.SET_NAME('AHL','AHL_PP_EMPLOYEE_NOT_REQ');
1502: Fnd_Msg_Pub.ADD;
1503: RAISE Fnd_Api.G_EXC_ERROR;
1504: END IF;*/
1505: IF G_DEBUG='Y' THEN

Line 1530: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NUM_NOT_EXISTS');

1526: );
1527:
1528: IF NVL(l_return_status, 'X') <> 'S'
1529: THEN
1530: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NUM_NOT_EXISTS');
1531: Fnd_Msg_Pub.ADD;
1532: RAISE Fnd_Api.G_EXC_ERROR;
1533: END IF;
1534:

Line 1558: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');

1554: );
1555:
1556: IF NVL(l_return_status, 'X') <> 'S'
1557: THEN
1558: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
1559: Fnd_Msg_Pub.ADD;
1560: RAISE Fnd_Api.G_EXC_ERROR;
1561: END IF;
1562:

Line 1564: Fnd_Message.SET_NAME('AHL','AHL_PP_USE_EMP_NAME_LOV');

1560: RAISE Fnd_Api.G_EXC_ERROR;
1561: END IF;
1562:
1563: IF p_x_resrc_assign_tbl(i).employee_id <> l_employee_id THEN
1564: Fnd_Message.SET_NAME('AHL','AHL_PP_USE_EMP_NAME_LOV');
1565: Fnd_Msg_Pub.ADD;
1566: END IF;
1567:
1568: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN

Line 1569: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');

1565: Fnd_Msg_Pub.ADD;
1566: END IF;
1567:
1568: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN
1569: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
1570: Fnd_Msg_Pub.ADD;
1571: END IF;
1572:
1573: --

Line 1837: Fnd_Message.SET_NAME('AHL','AHL_PP_SEQUENCE_NO_EXISTS');

1833: FETCH Sch_id_exists INTO l_dummy;
1834: CLOSE Sch_id_exists;
1835: --
1836: IF l_dummy IS NOT NULL THEN
1837: Fnd_Message.SET_NAME('AHL','AHL_PP_SEQUENCE_NO_EXISTS');
1838: Fnd_Msg_Pub.ADD;
1839: RAISE FND_API.G_EXC_ERROR;
1840: END IF;
1841:

Line 2245: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_RESASG_UNTLCKD');

2241: p_ue_id => NULL,
2242: p_visit_id => NULL,
2243: p_item_instance_id => NULL);
2244: IF l_return_status = FND_API.G_TRUE THEN
2245: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_RESASG_UNTLCKD');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: END IF;
2249:

Line 2394: Fnd_Message.SET_NAME('AHL','AHL_PP_SERIAL_NOT_EXISTS');

2390: END IF;
2391:
2392: IF NVL(l_return_status,'x') <> 'S'
2393: THEN
2394: Fnd_Message.SET_NAME('AHL','AHL_PP_SERIAL_NOT_EXISTS');
2395: Fnd_Msg_Pub.ADD;
2396: RAISE Fnd_Api.G_EXC_ERROR;
2397: END IF;
2398: END IF;

Line 2434: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NUM_NOT_EXISTS');

2430: );
2431:
2432: IF NVL(l_return_status, 'X') <> 'S'
2433: THEN
2434: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NUM_NOT_EXISTS');
2435: Fnd_Msg_Pub.ADD;
2436: RAISE Fnd_Api.G_EXC_ERROR;
2437: END IF;
2438:

Line 2458: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');

2454: );
2455:
2456: IF NVL(l_return_status, 'X') <> 'S'
2457: THEN
2458: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
2459: Fnd_Msg_Pub.ADD;
2460: RAISE Fnd_Api.G_EXC_ERROR;
2461: END IF;
2462:

Line 2464: Fnd_Message.SET_NAME('AHL','AHL_PP_USE_EMP_NAME_LOV');

2460: RAISE Fnd_Api.G_EXC_ERROR;
2461: END IF;
2462:
2463: IF p_x_resrc_assign_tbl(i).employee_id <> l_employee_id THEN
2464: Fnd_Message.SET_NAME('AHL','AHL_PP_USE_EMP_NAME_LOV');
2465: Fnd_Msg_Pub.ADD;
2466: END IF;
2467:
2468: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN

Line 2469: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');

2465: Fnd_Msg_Pub.ADD;
2466: END IF;
2467:
2468: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN
2469: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
2470: Fnd_Msg_Pub.ADD;
2471: END IF;
2472: END IF;
2473: END IF;

Line 2590: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

2586:
2587: -- Check Object version number.
2588: IF (p_x_resrc_assign_tbl(i).object_version_number <> c_assign_rec.object_version_number) THEN
2589: AHL_DEBUG_PUB.debug(l_full_name || 'Inside OVN comparison');
2590: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2591: Fnd_Msg_Pub.ADD;
2592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2593: END IF;
2594:

Line 3001: Fnd_Message.Set_Name('AHL','AHL_COM_INVALID_RECORD');

2997: --Get the exisitng record
2998: OPEN get_resrc_assign_cur(p_x_resrc_assign_tbl(i).assignment_id);
2999: FETCH get_resrc_assign_cur INTO l_resrc_assign_rec;
3000: IF get_resrc_assign_cur%NOTFOUND THEN
3001: Fnd_Message.Set_Name('AHL','AHL_COM_INVALID_RECORD');
3002: Fnd_Msg_Pub.ADD;
3003: CLOSE get_resrc_assign_cur;
3004: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3005: END IF;

Line 3012: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

3008: END IF;
3009: --Check for object version number
3010: IF p_x_resrc_assign_tbl(i).object_version_number <> l_resrc_assign_rec.object_version_number
3011: THEN
3012: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3013: Fnd_Msg_Pub.ADD;
3014: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3015: END IF;
3016: --