DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on FND_MESSAGE

Line 329: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');

325: THEN
326: l_is_dup_assos := GET_DUP_UNIT_ITEM_ASSOS (p_x_pc_header_rec.pc_header_id);
327: IF (l_is_dup_assos)
328: THEN
329: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: END IF;

Line 559: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');

555: OPEN check_header_status(p_x_pc_header_rec.PC_HEADER_ID);
556: FETCH check_header_status INTO l_status;
557: IF(check_header_status%NOTFOUND)
558: THEN
559: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
560: FND_MSG_PUB.ADD;
561: CLOSE check_header_status;
562: RAISE FND_API.G_EXC_ERROR;
563: ELSE

Line 567: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DRAFT_DELETE');

563: ELSE
564: CLOSE check_header_status;
565: IF (l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED')
566: THEN
567: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DRAFT_DELETE');
568: FND_MSG_PUB.ADD;
569: RAISE FND_API.G_EXC_ERROR;
570: ELSE
571:

Line 951: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');

947: OPEN check_name_unique( p_x_pc_header_rec.name );
948: FETCH check_name_unique INTO l_dummy_2;
949: IF (check_name_unique%FOUND)
950: THEN
951: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');
952: FND_MSG_PUB.ADD;
953: CLOSE check_name_unique;
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;

Line 971: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');

967: THEN
968: l_is_dup_assos := GET_DUP_UNIT_ITEM_ASSOS (l_old_header_id);
969: IF (l_is_dup_assos)
970: THEN
971: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: END IF;

Line 982: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');

978: l_dummy := VALIDATE_UNIT_PART_ATTACHED (p_x_pc_header_rec.PC_HEADER_ID, p_x_pc_header_rec.PRODUCT_TYPE_CODE, p_x_pc_header_rec.ASSOCIATION_TYPE_FLAG);
979:
980: IF (l_dummy = FALSE AND p_x_pc_header_rec.COPY_ASSOS_FLAG = 'Y')
981: THEN
982: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');
983: FND_MSG_PUB.ADD;
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:

Line 1400: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1396:
1397: -- If no updation happened, record must have already been modified by another user...
1398: IF (sql%rowcount) = 0
1399: THEN
1400: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1401: FND_MSG_PUB.ADD;
1402: RAISE FND_API.G_EXC_ERROR;
1403: -- Else start PCWF workflow process for this PC
1404: ELSE

Line 1417: FND_MESSAGE.SET_NAME('AHL','AHL_PC_WITHOUT_BUE_MSG');

1413: -- To achieve this, we set the parameter 'l_bue_msg' based on the BUE flag, and pass it as an IN parameter to the variable 'P_NOTES_FROM_REQUESTER' in call to the above mentioned procedure.
1414: -- While retrieving back, we decode the message to 'Y' or 'N' in the procedure AHL_PC_APPROVAL_PVT.UPDATE_STATUS
1415:
1416: IF (UPPER( p_x_pc_header_rec.bue_flag) = 'N') THEN
1417: FND_MESSAGE.SET_NAME('AHL','AHL_PC_WITHOUT_BUE_MSG');
1418: l_bue_msg := FND_MESSAGE.GET;
1419: ELSE
1420: l_bue_msg := null;
1421: END IF;

Line 1418: l_bue_msg := FND_MESSAGE.GET;

1414: -- While retrieving back, we decode the message to 'Y' or 'N' in the procedure AHL_PC_APPROVAL_PVT.UPDATE_STATUS
1415:
1416: IF (UPPER( p_x_pc_header_rec.bue_flag) = 'N') THEN
1417: FND_MESSAGE.SET_NAME('AHL','AHL_PC_WITHOUT_BUE_MSG');
1418: l_bue_msg := FND_MESSAGE.GET;
1419: ELSE
1420: l_bue_msg := null;
1421: END IF;
1422:

Line 1487: FND_MESSAGE.set_name('AHL', 'AHL_PC_RUN_BUE_MANUAL');

1483:
1484: END IF;
1485:
1486: IF ( UPPER(p_x_pc_header_rec.bue_flag) = 'N' ) THEN
1487: FND_MESSAGE.set_name('AHL', 'AHL_PC_RUN_BUE_MANUAL');
1488: x_warning_msg_data(0) := FND_MESSAGE.get;
1489: END IF;
1490:
1491: IF G_DEBUG='Y' THEN

Line 1488: x_warning_msg_data(0) := FND_MESSAGE.get;

1484: END IF;
1485:
1486: IF ( UPPER(p_x_pc_header_rec.bue_flag) = 'N' ) THEN
1487: FND_MESSAGE.set_name('AHL', 'AHL_PC_RUN_BUE_MANUAL');
1488: x_warning_msg_data(0) := FND_MESSAGE.get;
1489: END IF;
1490:
1491: IF G_DEBUG='Y' THEN
1492: AHL_DEBUG_PUB.debug('PCH -- PVT -- INITIATE_PC_APPROVAL -- After PC Approval');

Line 1553: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');

1549: p_status => p_x_pc_header_rec.STATUS );
1550: FETCH check_name into l_dummy;
1551: IF (check_name%FOUND)
1552: THEN
1553: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');
1554: FND_MSG_PUB.ADD;
1555: CLOSE check_name;
1556: RAISE FND_API.G_EXC_ERROR;
1557: END IF;

Line 1569: FND_MESSAGE.Set_Name('AHL','AHL_PC_PROD_PRIM_EXISTS');

1565: p_pc_header_id => p_x_pc_header_rec.PC_HEADER_ID );
1566: FETCH check_prod_type into l_dummy;
1567: IF (check_prod_type%FOUND)
1568: THEN
1569: FND_MESSAGE.Set_Name('AHL','AHL_PC_PROD_PRIM_EXISTS');
1570: FND_MSG_PUB.ADD;
1571: CLOSE check_prod_type;
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;

Line 3660: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');

3656: l_old_primary_flag,
3657: l_old_assos_type,p_x_pc_header_rec.link_to_pc_id;
3658: IF (check_header_data%NOTFOUND)
3659: THEN
3660: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
3661: FND_MSG_PUB.ADD;
3662: CLOSE check_header_data;
3663: RAISE FND_API.G_EXC_ERROR;
3664: END IF;

Line 3669: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

3665: CLOSE check_header_data;
3666:
3667: IF l_old_obj_ver_no <> p_x_pc_header_rec.OBJECT_VERSION_NUMBER
3668: THEN
3669: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_ERROR;
3672: END IF;
3673:

Line 3678: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');

3674: l_dummy := VALIDATE_UNIT_PART_ATTACHED (p_x_pc_header_rec.PC_HEADER_ID, p_x_pc_header_rec.PRODUCT_TYPE_CODE, p_x_pc_header_rec.ASSOCIATION_TYPE_FLAG);
3675:
3676: IF (l_dummy = FALSE)
3677: THEN
3678: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');
3679: FND_MSG_PUB.ADD;
3680: RAISE FND_API.G_EXC_ERROR;
3681: END IF;
3682:

Line 3690: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');

3686:
3687: -- PC is COMPLETE -- User submits without changing to DRAFT -- ERROR
3688: IF p_x_pc_header_rec.STATUS = 'COMPLETE' AND l_old_status = 'COMPLETE'
3689: THEN
3690: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
3691: FND_MSG_PUB.ADD;
3692: RAISE FND_API.G_EXC_ERROR;
3693:
3694: -- PC is APPROVAL_REJECTED -- User submits after making any change -- Change status to DRAFT