DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on FND_MESSAGE

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

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

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

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

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

549: -- OPERATION_SEQ_NUMBER - Positive
550: 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
551: IF p_resrc_assign_rec.OPERATION_SEQ_NUMBER < 0 THEN
552: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
553: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
554: Fnd_Msg_Pub.ADD;
555: END IF;
556: x_return_status := Fnd_Api.g_ret_sts_error;
557: RETURN;

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

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

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

572: -- RESOURCE_SEQ_NUMBER - Positive
573: 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
574: IF p_resrc_assign_rec.RESOURCE_SEQ_NUMBER < 0 THEN
575: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
576: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
577: Fnd_Msg_Pub.ADD;
578: END IF;
579: x_return_status := Fnd_Api.g_ret_sts_error;
580: RETURN;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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