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

Line 205: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');

201: THEN
202: l_header_status := Get_MC_Status(null, p_x_node_rec.mc_header_id);
203: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
204: THEN
205: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
206: FND_MSG_PUB.ADD;
207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
208: THEN
209: fnd_log.message

Line 244: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DUP_POSKEY');

240: OPEN check_dup_poskey;
241: FETCH check_dup_poskey INTO l_dummy_varchar;
242: IF (check_dup_poskey%FOUND)
243: THEN
244: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DUP_POSKEY');
245: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
246: FND_MSG_PUB.ADD;
247: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
248: THEN

Line 245: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

241: FETCH check_dup_poskey INTO l_dummy_varchar;
242: IF (check_dup_poskey%FOUND)
243: THEN
244: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DUP_POSKEY');
245: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
246: FND_MSG_PUB.ADD;
247: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
248: THEN
249: fnd_log.message

Line 661: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');

657: -- 1a.i. Validate config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
658: l_header_status := Get_MC_Status(null, p_x_node_rec.mc_header_id);
659: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
660: THEN
661: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
662: FND_MSG_PUB.ADD;
663: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
664: THEN
665: fnd_log.message

Line 701: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSKEY_NOUPD');

697: OPEN check_poskey_update;
698: FETCH check_poskey_update INTO l_dummy_varchar;
699: IF (check_poskey_update%FOUND)
700: THEN
701: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSKEY_NOUPD');
702: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
703: FND_MSG_PUB.ADD;
704:
705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 702: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

698: FETCH check_poskey_update INTO l_dummy_varchar;
699: IF (check_poskey_update%FOUND)
700: THEN
701: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSKEY_NOUPD');
702: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
703: FND_MSG_PUB.ADD;
704:
705: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
706: THEN

Line 798: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');

794:
795: l_header_status := Get_MC_Status(p_x_node_rec.relationship_id, null);
796: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
797: THEN
798: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
799: FND_MSG_PUB.ADD;
800: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
801: THEN
802: fnd_log.message

Line 823: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');

819:
820: -- Validate active_end_date >= sysdate exists
821: IF (trunc(nvl(l_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
822: THEN
823: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
824: FND_MSG_PUB.ADD;
825: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
826: THEN
827: fnd_log.message

Line 978: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');

974: IF (l_get_ata_top_node_rec.ata_code <> p_x_node_rec.ata_code)
975: THEN
976:
977: -- Raise warning msg
978: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
979: FND_MESSAGE.Set_Token('POS', l_get_ata_top_node_rec.POSITION_REF_MEANING);
980: FND_MESSAGE.Set_Token('MC', l_get_ata_top_node_rec.NAME);
981: FND_MESSAGE.Set_Token('SUBCONFIG', p_x_node_rec.POSITION_REF_MEANING);
982: FND_MSG_PUB.add;

Line 979: FND_MESSAGE.Set_Token('POS', l_get_ata_top_node_rec.POSITION_REF_MEANING);

975: THEN
976:
977: -- Raise warning msg
978: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
979: FND_MESSAGE.Set_Token('POS', l_get_ata_top_node_rec.POSITION_REF_MEANING);
980: FND_MESSAGE.Set_Token('MC', l_get_ata_top_node_rec.NAME);
981: FND_MESSAGE.Set_Token('SUBCONFIG', p_x_node_rec.POSITION_REF_MEANING);
982: FND_MSG_PUB.add;
983: END IF;

Line 980: FND_MESSAGE.Set_Token('MC', l_get_ata_top_node_rec.NAME);

976:
977: -- Raise warning msg
978: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
979: FND_MESSAGE.Set_Token('POS', l_get_ata_top_node_rec.POSITION_REF_MEANING);
980: FND_MESSAGE.Set_Token('MC', l_get_ata_top_node_rec.NAME);
981: FND_MESSAGE.Set_Token('SUBCONFIG', p_x_node_rec.POSITION_REF_MEANING);
982: FND_MSG_PUB.add;
983: END IF;
984: END LOOP;

Line 981: FND_MESSAGE.Set_Token('SUBCONFIG', p_x_node_rec.POSITION_REF_MEANING);

977: -- Raise warning msg
978: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
979: FND_MESSAGE.Set_Token('POS', l_get_ata_top_node_rec.POSITION_REF_MEANING);
980: FND_MESSAGE.Set_Token('MC', l_get_ata_top_node_rec.NAME);
981: FND_MESSAGE.Set_Token('SUBCONFIG', p_x_node_rec.POSITION_REF_MEANING);
982: FND_MSG_PUB.add;
983: END IF;
984: END LOOP;
985:

Line 1011: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');

1007:
1008: IF (l_get_ata_leaf_node_rec.ata_code <> p_x_node_rec.ata_code)
1009: THEN
1010: -- Raise warning msg
1011: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
1012: FND_MESSAGE.Set_Token('POS', p_x_node_rec.POSITION_REF_MEANING);
1013: FND_MESSAGE.Set_Token('MC',l_get_ata_leaf_node_rec.POSITION_REF_MEANING );
1014: FND_MESSAGE.Set_Token('SUBCONFIG', l_get_ata_leaf_node_rec.name);
1015: FND_MSG_PUB.add;

Line 1012: FND_MESSAGE.Set_Token('POS', p_x_node_rec.POSITION_REF_MEANING);

1008: IF (l_get_ata_leaf_node_rec.ata_code <> p_x_node_rec.ata_code)
1009: THEN
1010: -- Raise warning msg
1011: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
1012: FND_MESSAGE.Set_Token('POS', p_x_node_rec.POSITION_REF_MEANING);
1013: FND_MESSAGE.Set_Token('MC',l_get_ata_leaf_node_rec.POSITION_REF_MEANING );
1014: FND_MESSAGE.Set_Token('SUBCONFIG', l_get_ata_leaf_node_rec.name);
1015: FND_MSG_PUB.add;
1016: END IF;

Line 1013: FND_MESSAGE.Set_Token('MC',l_get_ata_leaf_node_rec.POSITION_REF_MEANING );

1009: THEN
1010: -- Raise warning msg
1011: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
1012: FND_MESSAGE.Set_Token('POS', p_x_node_rec.POSITION_REF_MEANING);
1013: FND_MESSAGE.Set_Token('MC',l_get_ata_leaf_node_rec.POSITION_REF_MEANING );
1014: FND_MESSAGE.Set_Token('SUBCONFIG', l_get_ata_leaf_node_rec.name);
1015: FND_MSG_PUB.add;
1016: END IF;
1017: END LOOP;

Line 1014: FND_MESSAGE.Set_Token('SUBCONFIG', l_get_ata_leaf_node_rec.name);

1010: -- Raise warning msg
1011: FND_MESSAGE.set_name('AHL', 'AHL_MC_POS_SUBMC_ATA_NOMATCH');
1012: FND_MESSAGE.Set_Token('POS', p_x_node_rec.POSITION_REF_MEANING);
1013: FND_MESSAGE.Set_Token('MC',l_get_ata_leaf_node_rec.POSITION_REF_MEANING );
1014: FND_MESSAGE.Set_Token('SUBCONFIG', l_get_ata_leaf_node_rec.name);
1015: FND_MSG_PUB.add;
1016: END IF;
1017: END LOOP;
1018: CLOSE get_ata_for_leaf_node;

Line 1160: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');

1156: l_header_status := Get_MC_Status(p_node_id, null);
1157: -- 6i. Validate that the config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
1158: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
1159: THEN
1160: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
1161: FND_MSG_PUB.ADD;
1162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1163: THEN
1164: fnd_log.message

Line 1380: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');

1376: l_header_status := Get_MC_Status(p_parent_rel_id, null);
1377: -- 3a. Validate that the config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
1378: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
1379: THEN
1380: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
1381: FND_MSG_PUB.ADD;
1382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1383: THEN
1384: fnd_log.message

Line 2156: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_STS_INV');

2152: l_header_status := Get_MC_Status(p_node_id, null);
2153: -- 6i. Validate that the config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
2154: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
2155: THEN
2156: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_STS_INV');
2157: FND_MSG_PUB.ADD;
2158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2159: THEN
2160: fnd_log.message

Line 2200: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_NO_REV');

2196:
2197: -- If revision not chosen, throw error
2198: IF (p_x_documents_tbl(i).REVISION_NO IS NULL AND p_x_documents_tbl(i).dml_operation <> G_DML_DELETE)
2199: THEN
2200: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_NO_REV');
2201: FND_MESSAGE.Set_Token('DOC', p_x_documents_tbl(i).DOCUMENT_NO);
2202: FND_MSG_PUB.ADD;
2203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2204: THEN

Line 2201: FND_MESSAGE.Set_Token('DOC', p_x_documents_tbl(i).DOCUMENT_NO);

2197: -- If revision not chosen, throw error
2198: IF (p_x_documents_tbl(i).REVISION_NO IS NULL AND p_x_documents_tbl(i).dml_operation <> G_DML_DELETE)
2199: THEN
2200: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DOC_NO_REV');
2201: FND_MESSAGE.Set_Token('DOC', p_x_documents_tbl(i).DOCUMENT_NO);
2202: FND_MSG_PUB.ADD;
2203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2204: THEN
2205: fnd_log.message

Line 2401: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');

2397: -- Validate config_status_code of the MC is 'DRAFT' or 'APPROVAL_REJECTED'
2398: l_header_status := Get_MC_Status(p_nodes_tbl(i).relationship_id, null);
2399: IF NOT (l_header_status IN ('DRAFT', 'APPROVAL_REJECTED'))
2400: THEN
2401: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_STS_INV');
2402: FND_MSG_PUB.ADD;
2403: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2404: THEN
2405: fnd_log.message

Line 2429: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');

2425: OPEN get_item_group_det (p_nodes_tbl(i).item_group_id);
2426: FETCH get_item_group_det INTO l_type_code,l_item_group_name;
2427: IF (get_item_group_det%NOTFOUND)
2428: THEN
2429: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2430: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_id);
2431: FND_MSG_PUB.ADD;
2432: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2433: THEN

Line 2430: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_id);

2426: FETCH get_item_group_det INTO l_type_code,l_item_group_name;
2427: IF (get_item_group_det%NOTFOUND)
2428: THEN
2429: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2430: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_id);
2431: FND_MSG_PUB.ADD;
2432: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2433: THEN
2434: fnd_log.message

Line 2445: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');

2441: ELSE
2442: IF l_type_code = 'TRACKED' THEN
2443: l_item_group_id := p_nodes_tbl(i).item_group_id;
2444: ELSE
2445: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2446: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
2447: FND_MSG_PUB.ADD;
2448: END IF;
2449:

Line 2446: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);

2442: IF l_type_code = 'TRACKED' THEN
2443: l_item_group_id := p_nodes_tbl(i).item_group_id;
2444: ELSE
2445: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2446: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
2447: FND_MSG_PUB.ADD;
2448: END IF;
2449:
2450: END IF;

Line 2458: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');

2454: OPEN get_item_group_csr (p_nodes_tbl(i).item_group_name);
2455: FETCH get_item_group_csr INTO l_item_group_id,l_type_code,l_item_group_name;
2456: IF (get_item_group_csr%NOTFOUND)
2457: THEN
2458: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2459: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_name);
2460: FND_MSG_PUB.ADD;
2461: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2462: THEN

Line 2459: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_name);

2455: FETCH get_item_group_csr INTO l_item_group_id,l_type_code,l_item_group_name;
2456: IF (get_item_group_csr%NOTFOUND)
2457: THEN
2458: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2459: FND_MESSAGE.Set_Token('ITEM_GRP', p_nodes_tbl(i).item_group_name);
2460: FND_MSG_PUB.ADD;
2461: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2462: THEN
2463: fnd_log.message

Line 2471: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');

2467: false
2468: );
2469: END IF;
2470: ELSIF l_type_code <> 'TRACKED' THEN
2471: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2472: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
2473: FND_MSG_PUB.ADD;
2474: END IF;
2475: CLOSE get_item_group_csr;

Line 2472: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);

2468: );
2469: END IF;
2470: ELSIF l_type_code <> 'TRACKED' THEN
2471: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2472: FND_MESSAGE.Set_Token('IG_NAME', l_item_group_name);
2473: FND_MSG_PUB.ADD;
2474: END IF;
2475: CLOSE get_item_group_csr;
2476: ELSE

Line 2477: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_NULL');

2473: FND_MSG_PUB.ADD;
2474: END IF;
2475: CLOSE get_item_group_csr;
2476: ELSE
2477: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_NULL');
2478: FND_MSG_PUB.ADD;
2479: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2480: THEN
2481: fnd_log.message

Line 2617: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');

2613: OPEN check_node_exists;
2614: FETCH check_node_exists INTO l_dummy_number;
2615: IF (check_node_exists%NOTFOUND)
2616: THEN
2617: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');
2618: FND_MSG_PUB.ADD;
2619: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2620: THEN
2621: fnd_log.message

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

2628: CLOSE check_node_exists;
2629: RAISE FND_API.G_EXC_ERROR;
2630: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
2631: THEN
2632: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
2633: FND_MSG_PUB.ADD;
2634: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2635: THEN
2636: fnd_log.message

Line 2754: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_INVALID');

2750: FETCH get_node_details INTO l_qty, l_end_date;
2751: IF (get_node_details%NOTFOUND)
2752: THEN
2753: -- 2a. Validate that the parent node exists
2754: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_INVALID');
2755: FND_MSG_PUB.ADD;
2756: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2757: THEN
2758: fnd_log.message

Line 2774: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_QTY_INV');

2770:
2771: -- 2c. Validate that the parent node has quantity = 1 [only in this can a child node be added to the parent position]
2772: IF (l_qty <> 1)
2773: THEN
2774: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_QTY_INV');
2775: FND_MSG_PUB.ADD;
2776: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2777: THEN
2778: fnd_log.message

Line 2790: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_DATE_INV');

2786:
2787: -- 2d. Validate for the parent node active_end_date > SYSDATE
2788: IF (trunc(nvl(l_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
2789: THEN
2790: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_DATE_INV');
2791: FND_MSG_PUB.ADD;
2792: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2793: THEN
2794: fnd_log.message

Line 2808: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_HAS_SUBMC');

2804: OPEN check_subconfig_assos;
2805: FETCH check_subconfig_assos INTO l_dummy_varchar;
2806: IF (check_subconfig_assos%FOUND)
2807: THEN
2808: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_HAS_SUBMC');
2809: FND_MSG_PUB.ADD;
2810: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2811: THEN
2812: fnd_log.message

Line 2827: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARCHD_INVALID');

2823: OPEN check_dup_pos_ref;
2824: FETCH check_dup_pos_ref INTO l_dummy_varchar;
2825: IF (check_dup_pos_ref%FOUND)
2826: THEN
2827: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARCHD_INVALID');
2828: FND_MESSAGE.Set_Token('CHILD', p_x_node_rec.position_ref_meaning);
2829: FND_MSG_PUB.ADD;
2830: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2831: THEN

Line 2828: FND_MESSAGE.Set_Token('CHILD', p_x_node_rec.position_ref_meaning);

2824: FETCH check_dup_pos_ref INTO l_dummy_varchar;
2825: IF (check_dup_pos_ref%FOUND)
2826: THEN
2827: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARCHD_INVALID');
2828: FND_MESSAGE.Set_Token('CHILD', p_x_node_rec.position_ref_meaning);
2829: FND_MSG_PUB.ADD;
2830: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2831: THEN
2832: fnd_log.message

Line 2849: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_EXISTS');

2845: OPEN check_topnode_exists;
2846: FETCH check_topnode_exists INTO l_dummy_varchar;
2847: IF (check_topnode_exists%FOUND)
2848: THEN
2849: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PARENT_EXISTS');
2850: FND_MSG_PUB.ADD;
2851: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2852: THEN
2853: fnd_log.message

Line 2872: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_NULL');

2868:
2869: IF (p_x_node_rec.position_ref_meaning IS NULL)
2870: THEN
2871: -- This is a mandatory field, hence throw error
2872: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_NULL');
2873: FND_MSG_PUB.ADD;
2874: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2875: THEN
2876: fnd_log.message

Line 2894: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_INVALID');

2890: );
2891:
2892: IF NOT (l_ret_val)
2893: THEN
2894: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_INVALID');
2895: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2896: FND_MSG_PUB.ADD;
2897: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2898: THEN

Line 2895: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

2891:
2892: IF NOT (l_ret_val)
2893: THEN
2894: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_POSREF_INVALID');
2895: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2896: FND_MSG_PUB.ADD;
2897: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2898: THEN
2899: fnd_log.message

Line 2913: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_NULL');

2909: -- Validate position Necessity
2910: IF (p_x_node_rec.position_necessity_code IS NULL)
2911: THEN
2912: -- This is a mandatory field, hence throw error
2913: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_NULL');
2914: FND_MSG_PUB.ADD;
2915: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2916: THEN
2917: fnd_log.message

Line 2926: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');

2922: );
2923: END IF;
2924: ELSIF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_POSITION_NECESSITY', p_x_node_rec.position_necessity_code))
2925: THEN
2926: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');
2927: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2928: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
2929: FND_MSG_PUB.ADD;
2930: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 2927: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

2923: END IF;
2924: ELSIF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_POSITION_NECESSITY', p_x_node_rec.position_necessity_code))
2925: THEN
2926: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');
2927: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2928: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
2929: FND_MSG_PUB.ADD;
2930: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2931: THEN

Line 2928: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);

2924: ELSIF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_POSITION_NECESSITY', p_x_node_rec.position_necessity_code))
2925: THEN
2926: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NECESSITY_INVALID');
2927: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
2928: FND_MESSAGE.Set_Token('CODE', p_x_node_rec.position_necessity_code);
2929: FND_MSG_PUB.ADD;
2930: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2931: THEN
2932: fnd_log.message

Line 2950: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');

2946: OPEN get_item_group_id;
2947: FETCH get_item_group_id INTO p_x_node_rec.item_group_id, l_ig_type, l_ig_status;
2948: IF (get_item_group_id%NOTFOUND)
2949: THEN
2950: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2951: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);
2952: FND_MSG_PUB.ADD;
2953: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2954: THEN

Line 2951: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);

2947: FETCH get_item_group_id INTO p_x_node_rec.item_group_id, l_ig_type, l_ig_status;
2948: IF (get_item_group_id%NOTFOUND)
2949: THEN
2950: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEMGRP_INVALID');
2951: FND_MESSAGE.Set_Token('ITEM_GRP', p_x_node_rec.item_group_name);
2952: FND_MSG_PUB.ADD;
2953: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2954: THEN
2955: fnd_log.message

Line 2973: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEM_ASSOS_QTY_INV');

2969: OPEN check_item_assos_qty;
2970: FETCH check_item_assos_qty INTO l_dummy_varchar;
2971: IF (check_item_assos_qty%FOUND)
2972: THEN
2973: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_ITEM_ASSOS_QTY_INV');
2974: FND_MSG_PUB.ADD;
2975: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2976: THEN
2977: fnd_log.message

Line 2991: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');

2987:
2988: -- Validate item group is trackable
2989: IF (l_ig_type <> 'TRACKED')
2990: THEN
2991: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2992: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);
2993: FND_MSG_PUB.ADD;
2994: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2995: THEN

Line 2992: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);

2988: -- Validate item group is trackable
2989: IF (l_ig_type <> 'TRACKED')
2990: THEN
2991: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_NOT_TRACKED');
2992: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);
2993: FND_MSG_PUB.ADD;
2994: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
2995: THEN
2996: fnd_log.message

Line 3008: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_STS_INV');

3004:
3005: -- Validate itemgroup status is not REMOVED
3006: IF (l_ig_status = 'REMOVED')
3007: THEN
3008: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_STS_INV');
3009: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);
3010: FND_MSG_PUB.ADD;
3011: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3012: THEN

Line 3009: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);

3005: -- Validate itemgroup status is not REMOVED
3006: IF (l_ig_status = 'REMOVED')
3007: THEN
3008: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_IG_STS_INV');
3009: FND_MESSAGE.Set_Token('IG_NAME', p_x_node_rec.item_group_name);
3010: FND_MSG_PUB.ADD;
3011: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3012: THEN
3013: fnd_log.message

Line 3031: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_NULL');

3027:
3028: -- Validate quantity
3029: IF (p_x_node_rec.quantity IS NULL)
3030: THEN
3031: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_NULL');
3032: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3033: FND_MSG_PUB.ADD;
3034: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3035: THEN

Line 3032: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3028: -- Validate quantity
3029: IF (p_x_node_rec.quantity IS NULL)
3030: THEN
3031: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_NULL');
3032: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3033: FND_MSG_PUB.ADD;
3034: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3035: THEN
3036: fnd_log.message

Line 3045: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_INVALID');

3041: );
3042: END IF;
3043: ELSIF (p_x_node_rec.quantity <= 0)
3044: THEN
3045: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_INVALID');
3046: FND_MESSAGE.Set_Token('QTY', p_x_node_rec.quantity);
3047: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3048: FND_MSG_PUB.ADD;
3049: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3046: FND_MESSAGE.Set_Token('QTY', p_x_node_rec.quantity);

3042: END IF;
3043: ELSIF (p_x_node_rec.quantity <= 0)
3044: THEN
3045: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_INVALID');
3046: FND_MESSAGE.Set_Token('QTY', p_x_node_rec.quantity);
3047: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3048: FND_MSG_PUB.ADD;
3049: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3050: THEN

Line 3047: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3043: ELSIF (p_x_node_rec.quantity <= 0)
3044: THEN
3045: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_QUANTITY_INVALID');
3046: FND_MESSAGE.Set_Token('QTY', p_x_node_rec.quantity);
3047: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3048: FND_MSG_PUB.ADD;
3049: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3050: THEN
3051: fnd_log.message

Line 3064: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PAR_QTY_INV');

3060: OPEN check_child_exists;
3061: FETCH check_child_exists INTO l_dummy_varchar;
3062: IF (check_child_exists%FOUND)
3063: THEN
3064: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PAR_QTY_INV');
3065: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3066: FND_MSG_PUB.ADD;
3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3068: THEN

Line 3065: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3061: FETCH check_child_exists INTO l_dummy_varchar;
3062: IF (check_child_exists%FOUND)
3063: THEN
3064: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PAR_QTY_INV');
3065: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3066: FND_MSG_PUB.ADD;
3067: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3068: THEN
3069: fnd_log.message

Line 3083: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_NULL');

3079:
3080: -- Validate display order
3081: IF (p_x_node_rec.display_order IS NULL)
3082: THEN
3083: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_NULL');
3084: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3085: FND_MSG_PUB.ADD;
3086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3087: THEN

Line 3084: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3080: -- Validate display order
3081: IF (p_x_node_rec.display_order IS NULL)
3082: THEN
3083: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_NULL');
3084: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3085: FND_MSG_PUB.ADD;
3086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3087: THEN
3088: fnd_log.message

Line 3097: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_INVALID');

3093: );
3094: END IF;
3095: ELSIF (p_x_node_rec.display_order <= 0)
3096: THEN
3097: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_INVALID');
3098: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3099: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3100: FND_MSG_PUB.ADD;
3101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3098: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);

3094: END IF;
3095: ELSIF (p_x_node_rec.display_order <= 0)
3096: THEN
3097: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_INVALID');
3098: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3099: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3100: FND_MSG_PUB.ADD;
3101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3102: THEN

Line 3099: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3095: ELSIF (p_x_node_rec.display_order <= 0)
3096: THEN
3097: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_INVALID');
3098: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3099: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3100: FND_MSG_PUB.ADD;
3101: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3102: THEN
3103: fnd_log.message

Line 3116: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_EXISTS');

3112: OPEN check_dup_display_order;
3113: FETCH check_dup_display_order INTO l_dummy_varchar;
3114: IF (check_dup_display_order%FOUND)
3115: THEN
3116: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_EXISTS');
3117: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3119: FND_MSG_PUB.ADD;
3120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3117: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);

3113: FETCH check_dup_display_order INTO l_dummy_varchar;
3114: IF (check_dup_display_order%FOUND)
3115: THEN
3116: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_EXISTS');
3117: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3119: FND_MSG_PUB.ADD;
3120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3121: THEN

Line 3118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3114: IF (check_dup_display_order%FOUND)
3115: THEN
3116: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_DISPORD_EXISTS');
3117: FND_MESSAGE.Set_Token('DSP', p_x_node_rec.display_order);
3118: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3119: FND_MSG_PUB.ADD;
3120: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3121: THEN
3122: fnd_log.message

Line 3136: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');

3132:
3133: -- Validate UOM
3134: IF (p_x_node_rec.uom_code IS NULL)
3135: THEN
3136: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');
3137: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3138: FND_MSG_PUB.ADD;
3139: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3140: THEN

Line 3137: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3133: -- Validate UOM
3134: IF (p_x_node_rec.uom_code IS NULL)
3135: THEN
3136: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');
3137: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3138: FND_MSG_PUB.ADD;
3139: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3140: THEN
3141: fnd_log.message

Line 3153: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');

3149: OPEN check_uom_exists(p_x_node_rec.uom_code);
3150: FETCH check_uom_exists INTO l_dummy_varchar;
3151: IF (check_uom_exists%NOTFOUND)
3152: THEN
3153: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3154: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3155: FND_MESSAGE.Set_Token('UOM', p_x_node_rec.uom_code);
3156: FND_MSG_PUB.ADD;
3157: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3154: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);

3150: FETCH check_uom_exists INTO l_dummy_varchar;
3151: IF (check_uom_exists%NOTFOUND)
3152: THEN
3153: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3154: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3155: FND_MESSAGE.Set_Token('UOM', p_x_node_rec.uom_code);
3156: FND_MSG_PUB.ADD;
3157: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3158: THEN

Line 3155: FND_MESSAGE.Set_Token('UOM', p_x_node_rec.uom_code);

3151: IF (check_uom_exists%NOTFOUND)
3152: THEN
3153: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3154: FND_MESSAGE.Set_Token('POSREF', p_x_node_rec.position_ref_meaning);
3155: FND_MESSAGE.Set_Token('UOM', p_x_node_rec.uom_code);
3156: FND_MSG_PUB.ADD;
3157: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3158: THEN
3159: fnd_log.message

Line 3183: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_DATE_INV');

3179: CLOSE get_node_dates;
3180:
3181: IF (G_TRUNC_DATE >= trunc(nvl(l_end_date, G_SYSDATE + 1)))
3182: THEN
3183: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_DATE_INV');
3184: FND_MSG_PUB.ADD;
3185: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3186: THEN
3187: fnd_log.message

Line 3198: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');

3194: END IF;
3195:
3196: IF (p_x_node_rec.active_start_date IS NOT NULL AND trunc(nvl(l_start_date, G_SYSDATE)) <> trunc(p_x_node_rec.active_start_date) AND trunc(p_x_node_rec.active_start_date) < G_TRUNC_DATE)
3197: THEN
3198: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
3199: FND_MSG_PUB.ADD;
3200: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3201: THEN
3202: fnd_log.message

Line 3213: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');

3209: END IF;
3210:
3211: IF (trunc(nvl(l_end_date, G_SYSDATE)) <> trunc(nvl(p_x_node_rec.active_end_date, G_SYSDATE)) AND trunc(nvl(p_x_node_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
3212: THEN
3213: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
3214: FND_MSG_PUB.ADD;
3215: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3216: THEN
3217: fnd_log.message

Line 3229: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');

3225: ELSIF (p_x_node_rec.operation_flag = G_DML_CREATE)
3226: THEN
3227: IF (trunc(nvl(p_x_node_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)
3228: THEN
3229: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
3230: FND_MSG_PUB.ADD;
3231: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3232: THEN
3233: fnd_log.message

Line 3244: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');

3240: END IF;
3241:
3242: IF (trunc(nvl(p_x_node_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
3243: THEN
3244: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
3245: FND_MSG_PUB.ADD;
3246: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3247: THEN
3248: fnd_log.message

Line 3260: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');

3256: END IF;
3257:
3258: IF (p_x_node_rec.operation_flag <> G_DML_COPY AND trunc(nvl(p_x_node_rec.active_end_date, nvl(p_x_node_rec.active_start_date, G_SYSDATE) + 1)) <= trunc(nvl(p_x_node_rec.active_start_date, G_SYSDATE)))
3259: THEN
3260: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
3261: FND_MSG_PUB.ADD;
3262: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3263: THEN
3264: fnd_log.message

Line 3294: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTR_NOT_FOUND');

3290: OPEN check_counter_exists;
3291: FETCH check_counter_exists INTO l_dummy_number;
3292: IF (check_counter_exists%NOTFOUND)
3293: THEN
3294: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTR_NOT_FOUND');
3295: FND_MSG_PUB.ADD;
3296: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3297: THEN
3298: fnd_log.message

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

3305: CLOSE check_counter_exists;
3306: RAISE FND_API.G_EXC_ERROR;
3307: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
3308: THEN
3309: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
3310: FND_MSG_PUB.ADD;
3311: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3312: THEN
3313: fnd_log.message

Line 3361: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');

3357:
3358: -- Validate p_counter_rule_rec.uom_code
3359: IF (p_counter_rule_rec.uom_code IS NULL)
3360: THEN
3361: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');
3362: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3363: FND_MSG_PUB.ADD;
3364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3365: THEN

Line 3362: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);

3358: -- Validate p_counter_rule_rec.uom_code
3359: IF (p_counter_rule_rec.uom_code IS NULL)
3360: THEN
3361: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_NULL');
3362: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3363: FND_MSG_PUB.ADD;
3364: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3365: THEN
3366: fnd_log.message

Line 3378: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');

3374: OPEN check_uom_exists(p_counter_rule_rec.uom_code);
3375: FETCH check_uom_exists INTO l_dummy_varchar;
3376: IF (check_uom_exists%NOTFOUND)
3377: THEN
3378: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3379: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3380: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3381: FND_MSG_PUB.ADD;
3382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3379: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);

3375: FETCH check_uom_exists INTO l_dummy_varchar;
3376: IF (check_uom_exists%NOTFOUND)
3377: THEN
3378: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3379: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3380: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3381: FND_MSG_PUB.ADD;
3382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3383: THEN

Line 3380: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);

3376: IF (check_uom_exists%NOTFOUND)
3377: THEN
3378: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_UOM_INVALID');
3379: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3380: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3381: FND_MSG_PUB.ADD;
3382: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3383: THEN
3384: fnd_log.message

Line 3398: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_NULL');

3394:
3395: -- Validate p_counter_rule_rec.rule_code
3396: IF (p_counter_rule_rec.rule_code IS NULL)
3397: THEN
3398: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_NULL');
3399: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3400: FND_MSG_PUB.ADD;
3401: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3402: THEN

Line 3399: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);

3395: -- Validate p_counter_rule_rec.rule_code
3396: IF (p_counter_rule_rec.rule_code IS NULL)
3397: THEN
3398: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_NULL');
3399: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3400: FND_MSG_PUB.ADD;
3401: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3402: THEN
3403: fnd_log.message

Line 3412: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_INVALID');

3408: );
3409: END IF;
3410: ELSIF NOT(AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_COUNTER_RULE_TYPE', p_counter_rule_rec.rule_code))
3411: THEN
3412: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_INVALID');
3413: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3414: FND_MESSAGE.Set_Token('RULE_CODE', p_counter_rule_rec.rule_meaning);
3415: FND_MSG_PUB.ADD;
3416: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3413: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);

3409: END IF;
3410: ELSIF NOT(AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_COUNTER_RULE_TYPE', p_counter_rule_rec.rule_code))
3411: THEN
3412: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_INVALID');
3413: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3414: FND_MESSAGE.Set_Token('RULE_CODE', p_counter_rule_rec.rule_meaning);
3415: FND_MSG_PUB.ADD;
3416: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3417: THEN

Line 3414: FND_MESSAGE.Set_Token('RULE_CODE', p_counter_rule_rec.rule_meaning);

3410: ELSIF NOT(AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_COUNTER_RULE_TYPE', p_counter_rule_rec.rule_code))
3411: THEN
3412: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RCODE_INVALID');
3413: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3414: FND_MESSAGE.Set_Token('RULE_CODE', p_counter_rule_rec.rule_meaning);
3415: FND_MSG_PUB.ADD;
3416: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3417: THEN
3418: fnd_log.message

Line 3432: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTRRULE_EXISTS');

3428: OPEN check_uom_rule;
3429: FETCH check_uom_rule INTO l_dummy_varchar;
3430: IF (check_uom_rule%FOUND)
3431: THEN
3432: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTRRULE_EXISTS');
3433: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3434: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3435: FND_MESSAGE.Set_Token('RULE', p_counter_rule_rec.rule_code);
3436: FND_MSG_PUB.ADD;

Line 3433: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);

3429: FETCH check_uom_rule INTO l_dummy_varchar;
3430: IF (check_uom_rule%FOUND)
3431: THEN
3432: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTRRULE_EXISTS');
3433: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3434: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3435: FND_MESSAGE.Set_Token('RULE', p_counter_rule_rec.rule_code);
3436: FND_MSG_PUB.ADD;
3437: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3434: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);

3430: IF (check_uom_rule%FOUND)
3431: THEN
3432: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTRRULE_EXISTS');
3433: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3434: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3435: FND_MESSAGE.Set_Token('RULE', p_counter_rule_rec.rule_code);
3436: FND_MSG_PUB.ADD;
3437: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3438: THEN

Line 3435: FND_MESSAGE.Set_Token('RULE', p_counter_rule_rec.rule_code);

3431: THEN
3432: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CTRRULE_EXISTS');
3433: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3434: FND_MESSAGE.Set_Token('UOM', p_counter_rule_rec.uom_code);
3435: FND_MESSAGE.Set_Token('RULE', p_counter_rule_rec.rule_code);
3436: FND_MSG_PUB.ADD;
3437: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3438: THEN
3439: fnd_log.message

Line 3452: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RATIO_INVALID');

3448:
3449: -- Validate counter rule ratio is a positive number
3450: IF (nvl(p_counter_rule_rec.ratio, 0) <= 0)
3451: THEN
3452: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RATIO_INVALID');
3453: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3454: FND_MESSAGE.Set_Token('RATIO', p_counter_rule_rec.ratio);
3455: FND_MSG_PUB.ADD;
3456: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3453: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);

3449: -- Validate counter rule ratio is a positive number
3450: IF (nvl(p_counter_rule_rec.ratio, 0) <= 0)
3451: THEN
3452: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RATIO_INVALID');
3453: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3454: FND_MESSAGE.Set_Token('RATIO', p_counter_rule_rec.ratio);
3455: FND_MSG_PUB.ADD;
3456: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3457: THEN

Line 3454: FND_MESSAGE.Set_Token('RATIO', p_counter_rule_rec.ratio);

3450: IF (nvl(p_counter_rule_rec.ratio, 0) <= 0)
3451: THEN
3452: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RATIO_INVALID');
3453: FND_MESSAGE.Set_Token('POSREF', l_posref_meaning);
3454: FND_MESSAGE.Set_Token('RATIO', p_counter_rule_rec.ratio);
3455: FND_MSG_PUB.ADD;
3456: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3457: THEN
3458: fnd_log.message

Line 3488: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NOT_FOUND');

3484: OPEN check_submc_exists;
3485: FETCH check_submc_exists INTO l_dummy_number;
3486: IF (check_submc_exists%NOTFOUND)
3487: THEN
3488: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_NOT_FOUND');
3489: FND_MSG_PUB.ADD;
3490: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3491: THEN
3492: fnd_log.message

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

3499: CLOSE check_submc_exists;
3500: RAISE FND_API.G_EXC_ERROR;
3501: ELSIF (NVL(p_object_ver_num, l_dummy_number) <> l_dummy_number)
3502: THEN
3503: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED');
3504: FND_MSG_PUB.ADD;
3505: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3506: THEN
3507: fnd_log.message

Line 3544: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');

3540: OPEN check_priority_dup_exists;
3541: FETCH check_priority_dup_exists INTO l_priority;
3542: IF (check_priority_dup_exists%FOUND)
3543: THEN
3544: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_NON_UNIQUE');
3545: FND_MSG_PUB.ADD;
3546: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3547: THEN
3548: fnd_log.message

Line 3620: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');

3616: OPEN get_mc_details;
3617: FETCH get_mc_details INTO l_submc_name;
3618: CLOSE get_mc_details;
3619:
3620: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
3621: FND_MESSAGE.Set_Token('MC', l_mc_name);
3622: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
3623: FND_MSG_PUB.ADD;
3624: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 3621: FND_MESSAGE.Set_Token('MC', l_mc_name);

3617: FETCH get_mc_details INTO l_submc_name;
3618: CLOSE get_mc_details;
3619:
3620: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
3621: FND_MESSAGE.Set_Token('MC', l_mc_name);
3622: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
3623: FND_MSG_PUB.ADD;
3624: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3625: THEN

Line 3622: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);

3618: CLOSE get_mc_details;
3619:
3620: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
3621: FND_MESSAGE.Set_Token('MC', l_mc_name);
3622: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
3623: FND_MSG_PUB.ADD;
3624: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3625: THEN
3626: fnd_log.message

Line 3672: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_FOUND');

3668: OPEN get_node_mc_status;
3669: FETCH get_node_mc_status INTO l_status;
3670: IF (get_node_mc_status%NOTFOUND)
3671: THEN
3672: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_FOUND');
3673: FND_MSG_PUB.ADD;
3674: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3675: THEN
3676: fnd_log.message

Line 3693: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_FOUND');

3689: OPEN get_mc_status;
3690: FETCH get_mc_status INTO l_status;
3691: IF (get_mc_status%NOTFOUND)
3692: THEN
3693: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_FOUND');
3694: FND_MSG_PUB.ADD;
3695: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3696: THEN
3697: fnd_log.message

Line 4147: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_TOP_NODE');

4143: OPEN check_root_node;
4144: FETCH check_root_node INTO l_dummy_varchar;
4145: IF (check_root_node%FOUND)
4146: THEN
4147: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_TOP_NODE');
4148: FND_MSG_PUB.ADD;
4149: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4150: THEN
4151: fnd_log.message

Line 4166: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');

4162: OPEN check_leaf_node;
4163: FETCH check_leaf_node INTO l_dummy_varchar;
4164: IF (check_leaf_node%FOUND)
4165: THEN
4166: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4167: FND_MSG_PUB.ADD;
4168: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4169: THEN
4170: fnd_log.message

Line 4185: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');

4181: -- Validate the MC with mc_header_id = p_x_subconfig_rec.mc_header_id is complete/draft/approval_rejected
4182: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4183: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4184: THEN
4185: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4186: FND_MSG_PUB.ADD;
4187: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4188: THEN
4189: fnd_log.message

Line 4204: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');

4200: OPEN check_submc_exists;
4201: FETCH check_submc_exists INTO l_mc_name;
4202: IF (check_submc_exists%FOUND)
4203: THEN
4204: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');
4205: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);
4206: FND_MSG_PUB.ADD;
4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4208: THEN

Line 4205: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);

4201: FETCH check_submc_exists INTO l_mc_name;
4202: IF (check_submc_exists%FOUND)
4203: THEN
4204: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');
4205: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);
4206: FND_MSG_PUB.ADD;
4207: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4208: THEN
4209: fnd_log.message

Line 4236: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');

4232: CLOSE get_node_mc_details;
4233: OPEN get_mc_details(p_x_subconfig_rec.mc_header_id);
4234: FETCH get_mc_details INTO l_submc_name;
4235: CLOSE get_mc_details;
4236: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4237: FND_MESSAGE.Set_Token('MC', l_mc_name);
4238: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4239: FND_MSG_PUB.ADD;
4240: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 4237: FND_MESSAGE.Set_Token('MC', l_mc_name);

4233: OPEN get_mc_details(p_x_subconfig_rec.mc_header_id);
4234: FETCH get_mc_details INTO l_submc_name;
4235: CLOSE get_mc_details;
4236: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4237: FND_MESSAGE.Set_Token('MC', l_mc_name);
4238: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4239: FND_MSG_PUB.ADD;
4240: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4241: THEN

Line 4238: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);

4234: FETCH get_mc_details INTO l_submc_name;
4235: CLOSE get_mc_details;
4236: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4237: FND_MESSAGE.Set_Token('MC', l_mc_name);
4238: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4239: FND_MSG_PUB.ADD;
4240: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4241: THEN
4242: fnd_log.message

Line 4261: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');

4257:
4258: -- Validate dates for the subconfig association
4259: IF (trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)
4260: THEN
4261: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4262: FND_MSG_PUB.ADD;
4263: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4264: THEN
4265: fnd_log.message

Line 4276: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');

4272: END IF;
4273:
4274: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
4275: THEN
4276: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4277: FND_MSG_PUB.ADD;
4278: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4279: THEN
4280: fnd_log.message

Line 4291: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');

4287: END IF;
4288:
4289: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE) + 1)) <= trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)))
4290: THEN
4291: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4292: FND_MSG_PUB.ADD;
4293: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4294: THEN
4295: fnd_log.message

Line 4306: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');

4302: END IF;
4303:
4304: IF (p_x_subconfig_rec.priority IS NULL)
4305: THEN
4306: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4307: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4308: FND_MSG_PUB.ADD;
4309: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4310: THEN

Line 4307: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);

4303:
4304: IF (p_x_subconfig_rec.priority IS NULL)
4305: THEN
4306: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4307: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4308: FND_MSG_PUB.ADD;
4309: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4310: THEN
4311: fnd_log.message

Line 4320: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');

4316: );
4317: END IF;
4318: ELSIF (p_x_subconfig_rec.priority <= 0)
4319: THEN
4320: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4321: FND_MSG_PUB.ADD;
4322: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4323: THEN
4324: fnd_log.message

Line 4470: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');

4466: -- Validate the MC with mc_header_id = p_x_subconfig_rec.mc_header_id is complete
4467: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4468: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4469: THEN
4470: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4471: FND_MSG_PUB.ADD;
4472: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4473: THEN
4474: fnd_log.message

Line 4493: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_DATE_INV');

4489: /*
4490: -- Should be able to unexpire an expired subconfiguration association
4491: IF (G_TRUNC_DATE >= trunc(nvl(l_end_date, G_SYSDATE + 1)))
4492: THEN
4493: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_DATE_INV');
4494: FND_MSG_PUB.ADD;
4495: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4496: THEN
4497: fnd_log.message

Line 4509: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');

4505: */
4506:
4507: IF (p_x_subconfig_rec.active_start_date IS NOT NULL AND trunc(nvl(l_start_date, G_SYSDATE)) <> trunc(p_x_subconfig_rec.active_start_date) AND trunc(p_x_subconfig_rec.active_start_date) < G_TRUNC_DATE)
4508: THEN
4509: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4510: FND_MSG_PUB.ADD;
4511: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4512: THEN
4513: fnd_log.message

Line 4524: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');

4520: END IF;
4521:
4522: IF (trunc(nvl(l_end_date, G_SYSDATE)) <> trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE)) AND trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
4523: THEN
4524: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4525: FND_MSG_PUB.ADD;
4526: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4527: THEN
4528: fnd_log.message

Line 4539: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');

4535: END IF;
4536:
4537: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE) + 1)) <= trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)))
4538: THEN
4539: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4540: FND_MSG_PUB.ADD;
4541: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4542: THEN
4543: fnd_log.message

Line 4555: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');

4551:
4552:
4553: IF (p_x_subconfig_rec.priority IS NULL)
4554: THEN
4555: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4556: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4557: FND_MSG_PUB.ADD;
4558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4559: THEN

Line 4556: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);

4552:
4553: IF (p_x_subconfig_rec.priority IS NULL)
4554: THEN
4555: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4556: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4557: FND_MSG_PUB.ADD;
4558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4559: THEN
4560: fnd_log.message

Line 4569: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');

4565: );
4566: END IF;
4567: ELSIF (p_x_subconfig_rec.priority <= 0)
4568: THEN
4569: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4570: FND_MSG_PUB.ADD;
4571: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4572: THEN
4573: fnd_log.message

Line 4777: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');

4773: OPEN check_leaf_node(p_dest_rel_id);
4774: FETCH check_leaf_node INTO l_dummy_varchar;
4775: IF (check_leaf_node%FOUND)
4776: THEN
4777: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4778: FND_MSG_PUB.ADD;
4779: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4780: THEN
4781: fnd_log.message

Line 4811: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');

4807:
4808: OPEN get_mc_details(l_subconfig_csr_rec.mc_header_id);
4809: FETCH get_mc_details INTO l_submc_name;
4810: CLOSE get_mc_details;
4811: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4812: FND_MESSAGE.Set_Token('MC', l_mc_name);
4813: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4814: FND_MSG_PUB.ADD;
4815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 4812: FND_MESSAGE.Set_Token('MC', l_mc_name);

4808: OPEN get_mc_details(l_subconfig_csr_rec.mc_header_id);
4809: FETCH get_mc_details INTO l_submc_name;
4810: CLOSE get_mc_details;
4811: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4812: FND_MESSAGE.Set_Token('MC', l_mc_name);
4813: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4814: FND_MSG_PUB.ADD;
4815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4816: THEN

Line 4813: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);

4809: FETCH get_mc_details INTO l_submc_name;
4810: CLOSE get_mc_details;
4811: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4812: FND_MESSAGE.Set_Token('MC', l_mc_name);
4813: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4814: FND_MSG_PUB.ADD;
4815: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4816: THEN
4817: fnd_log.message