DBA Data[Home] [Help]

APPS.AHL_PC_NODE_PVT dependencies on FND_MESSAGE

Line 251: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');

247:
248: IF (pc_node_csr%NOTFOUND)
249: THEN
250: CLOSE pc_node_csr;
251: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
252: FND_MSG_PUB.ADD;
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255: CLOSE pc_node_csr;

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

257: END IF;
258:
259: IF (l_object_version_number <> p_x_node_rec.object_version_number)
260: THEN
261: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
262: FND_MSG_PUB.ADD;
263: END IF;
264:
265: IF (l_pc_status <> 'DRAFT' and l_pc_status <> 'APPROVAL_REJECTED')

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

263: END IF;
264:
265: IF (l_pc_status <> 'DRAFT' and l_pc_status <> 'APPROVAL_REJECTED')
266: THEN
267: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
268: FND_MSG_PUB.ADD;
269: END IF;
270:
271: IF (p_x_node_rec.DRAFT_FLAG = 'Y')

Line 273: FND_MESSAGE.Set_Name('AHL','AHL_PC_DRAFT_PC_EXISTS');

269: END IF;
270:
271: IF (p_x_node_rec.DRAFT_FLAG = 'Y')
272: THEN
273: FND_MESSAGE.Set_Name('AHL','AHL_PC_DRAFT_PC_EXISTS');
274: FND_MSG_PUB.ADD;
275: END IF;
276:
277: -- Check Error Message stack.

Line 759: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_OPEN_NR');

755: INTO p_x_node_rec.name
756: FROM ahl_pc_nodes_b
757: WHERE pc_node_id = p_x_node_rec.pc_node_id;
758:
759: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_OPEN_NR');
760: FND_MESSAGE.Set_Token('PCN',p_x_node_rec.name);
761: FND_MSG_PUB.ADD;
762: ELSE
763: --There exists open Non-routines for units associated to the corresponding complete PC,

Line 760: FND_MESSAGE.Set_Token('PCN',p_x_node_rec.name);

756: FROM ahl_pc_nodes_b
757: WHERE pc_node_id = p_x_node_rec.pc_node_id;
758:
759: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_OPEN_NR');
760: FND_MESSAGE.Set_Token('PCN',p_x_node_rec.name);
761: FND_MSG_PUB.ADD;
762: ELSE
763: --There exists open Non-routines for units associated to the corresponding complete PC,
764: -- hence cannot delete the draft version.

Line 765: FND_MESSAGE.Set_Name('AHL','AHL_PC_HEADER_DEL_OPEN_NR');

761: FND_MSG_PUB.ADD;
762: ELSE
763: --There exists open Non-routines for units associated to the corresponding complete PC,
764: -- hence cannot delete the draft version.
765: FND_MESSAGE.Set_Name('AHL','AHL_PC_HEADER_DEL_OPEN_NR');
766: FND_MSG_PUB.ADD;
767: RAISE FND_API.G_EXC_ERROR;
768: END IF;
769: ELSIF (l_mel_cdl_attached <> FND_API.G_FALSE)

Line 771: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_MELCDL_ASSOS');

767: RAISE FND_API.G_EXC_ERROR;
768: END IF;
769: ELSIF (l_mel_cdl_attached <> FND_API.G_FALSE)
770: THEN
771: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_MELCDL_ASSOS');
772: FND_MSG_PUB.ADD;
773: -- R12 [priyan MEL/CDL]
774: ELSIF (l_fmp_attached <> FND_API.G_FALSE)
775: THEN

Line 776: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_FMP_ASSOS');

772: FND_MSG_PUB.ADD;
773: -- R12 [priyan MEL/CDL]
774: ELSIF (l_fmp_attached <> FND_API.G_FALSE)
775: THEN
776: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_FMP_ASSOS');
777: FND_MSG_PUB.ADD;
778: -- Bug 5130623
779: -- TYPO - Added l_ump_unit_attached check below
780: ELSIF (l_ump_node_attached <> FND_API.G_FALSE OR l_ump_part_attached <> FND_API.G_FALSE OR l_ump_unit_attached <> FND_API.G_FALSE)

Line 782: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_UMP_ASSOS');

778: -- Bug 5130623
779: -- TYPO - Added l_ump_unit_attached check below
780: ELSIF (l_ump_node_attached <> FND_API.G_FALSE OR l_ump_part_attached <> FND_API.G_FALSE OR l_ump_unit_attached <> FND_API.G_FALSE)
781: THEN
782: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_UMP_ASSOS');
783: FND_MSG_PUB.ADD;
784: -- Bug 5130623
785: -- Commented Unconditional Else Clause.
786: /*

Line 788: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_HAS_ASSOS');

784: -- Bug 5130623
785: -- Commented Unconditional Else Clause.
786: /*
787: ELSE
788: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_DEL_HAS_ASSOS');
789: FND_MSG_PUB.ADD;
790: */
791: END IF;
792:

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

952: FETCH get_node_object_version INTO l_object_version_number;
953: CLOSE get_node_object_version;
954: IF (l_object_version_number <> p_node_rec.object_version_number)
955: THEN
956: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
957: FND_MSG_PUB.ADD;
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: END IF;

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

963: OPEN check_header_id_exists (p_node_rec.pc_header_id);
964: FETCH check_header_id_exists INTO l_header_id, l_pc_status;
965: IF (check_header_id_exists%NOTFOUND)
966: THEN
967: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:

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

971:
972: -- If PC status is DRAFT/APPROVAL_REJECTED, allow node operations
973: IF (l_pc_status <> 'DRAFT' and l_pc_status <> 'APPROVAL_REJECTED')
974: THEN
975: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: CLOSE check_header_id_exists;

Line 988: FND_MESSAGE.Set_Name('AHL','AHL_PC_PARENT_NODE_NOT_FOUND');

984: OPEN check_parent_exists (p_node_rec.pc_header_id, p_node_rec.parent_node_id);
985: FETCH check_parent_exists INTO l_dummy;
986: IF (check_parent_exists%NOTFOUND)
987: THEN
988: FND_MESSAGE.Set_Name('AHL','AHL_PC_PARENT_NODE_NOT_FOUND');
989: FND_MSG_PUB.ADD;
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992: CLOSE check_parent_exists;

Line 1005: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NAME_EXISTS');

1001: OPEN check_name_exists ( p_node_rec.parent_node_id, p_node_rec.pc_node_id, p_node_rec.name);
1002: FETCH check_name_exists INTO l_dummy;
1003: IF (check_name_exists%FOUND)
1004: THEN
1005: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NAME_EXISTS');
1006: FND_MSG_PUB.ADD;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: CLOSE check_name_exists;

Line 1018: FND_MESSAGE.Set_Name('AHL','AHL_PC_ROOT_NODE_EXISTS');

1014: OPEN check_root_node_exists (p_node_rec.pc_header_id);
1015: FETCH check_root_node_exists INTO l_dummy;
1016: IF (check_root_node_exists%FOUND)
1017: THEN
1018: FND_MESSAGE.Set_Name('AHL','AHL_PC_ROOT_NODE_EXISTS');
1019: FND_MSG_PUB.ADD;
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: CLOSE check_root_node_exists;

Line 1034: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');

1030: OPEN check_id_exists (p_node_rec.pc_header_id, p_node_rec.pc_node_id);
1031: FETCH check_id_exists INTO l_dummy;
1032: IF (check_id_exists%NOTFOUND)
1033: THEN
1034: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
1035: FND_MSG_PUB.ADD;
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038: CLOSE check_id_exists;

Line 1048: FND_MESSAGE.Set_Name('AHL','AHL_PC_LEAF_NODE');

1044: OPEN check_leaf_node (p_node_rec.parent_node_id);
1045: FETCH check_leaf_node INTO l_dummy;
1046: IF (check_leaf_node%FOUND)
1047: THEN
1048: FND_MESSAGE.Set_Name('AHL','AHL_PC_LEAF_NODE');
1049: FND_MSG_PUB.ADD;
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052: CLOSE check_leaf_node;