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 2157: FND_MESSAGE.Set_Name('AHL', 'AHL_DI_ASSO_UPDATE_ERROR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3197: END IF;
3198:
3199: 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)
3200: THEN
3201: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
3202: FND_MSG_PUB.ADD;
3203: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3204: THEN
3205: fnd_log.message

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

3212: END IF;
3213:
3214: 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)
3215: THEN
3216: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
3217: FND_MSG_PUB.ADD;
3218: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3219: THEN
3220: fnd_log.message

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

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

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

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

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

3259: END IF;
3260:
3261: 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)))
3262: THEN
3263: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
3264: FND_MSG_PUB.ADD;
3265: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
3266: THEN
3267: fnd_log.message

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4169: OPEN check_root_node;
4170: FETCH check_root_node INTO l_dummy_varchar;
4171: IF (check_root_node%FOUND)
4172: THEN
4173: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_TOP_NODE');
4174: FND_MSG_PUB.ADD;
4175: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4176: THEN
4177: fnd_log.message

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

4188: OPEN check_leaf_node;
4189: FETCH check_leaf_node INTO l_dummy_varchar;
4190: IF (check_leaf_node%FOUND)
4191: THEN
4192: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4193: FND_MSG_PUB.ADD;
4194: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4195: THEN
4196: fnd_log.message

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

4207: -- Validate the MC with mc_header_id = p_x_subconfig_rec.mc_header_id is complete/draft/approval_rejected
4208: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4209: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4210: THEN
4211: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4212: FND_MSG_PUB.ADD;
4213: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4214: THEN
4215: fnd_log.message

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

4226: OPEN check_submc_exists;
4227: FETCH check_submc_exists INTO l_mc_name;
4228: IF (check_submc_exists%FOUND)
4229: THEN
4230: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');
4231: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);
4232: FND_MSG_PUB.ADD;
4233: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4234: THEN

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

4227: FETCH check_submc_exists INTO l_mc_name;
4228: IF (check_submc_exists%FOUND)
4229: THEN
4230: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_EXISTS');
4231: FND_MESSAGE.Set_Token('SUBMC', l_mc_name);
4232: FND_MSG_PUB.ADD;
4233: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4234: THEN
4235: fnd_log.message

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

4258: CLOSE get_node_mc_details;
4259: OPEN get_mc_details(p_x_subconfig_rec.mc_header_id);
4260: FETCH get_mc_details INTO l_submc_name;
4261: CLOSE get_mc_details;
4262: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4263: FND_MESSAGE.Set_Token('MC', l_mc_name);
4264: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4265: FND_MSG_PUB.ADD;
4266: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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

4259: OPEN get_mc_details(p_x_subconfig_rec.mc_header_id);
4260: FETCH get_mc_details INTO l_submc_name;
4261: CLOSE get_mc_details;
4262: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4263: FND_MESSAGE.Set_Token('MC', l_mc_name);
4264: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4265: FND_MSG_PUB.ADD;
4266: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4267: THEN

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

4260: FETCH get_mc_details INTO l_submc_name;
4261: CLOSE get_mc_details;
4262: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4263: FND_MESSAGE.Set_Token('MC', l_mc_name);
4264: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4265: FND_MSG_PUB.ADD;
4266: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4267: THEN
4268: fnd_log.message

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

4283:
4284: -- Validate dates for the subconfig association
4285: IF (trunc(nvl(p_x_subconfig_rec.active_start_date, G_SYSDATE)) < G_TRUNC_DATE)
4286: THEN
4287: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4288: FND_MSG_PUB.ADD;
4289: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4290: THEN
4291: fnd_log.message

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

4298: END IF;
4299:
4300: IF (trunc(nvl(p_x_subconfig_rec.active_end_date, G_SYSDATE + 1)) <= G_TRUNC_DATE)
4301: THEN
4302: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4303: FND_MSG_PUB.ADD;
4304: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4305: THEN
4306: fnd_log.message

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

4313: END IF;
4314:
4315: 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)))
4316: THEN
4317: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4318: FND_MSG_PUB.ADD;
4319: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4320: THEN
4321: fnd_log.message

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

4328: END IF;
4329:
4330: IF (p_x_subconfig_rec.priority IS NULL)
4331: THEN
4332: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4333: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4334: FND_MSG_PUB.ADD;
4335: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4336: THEN

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

4329:
4330: IF (p_x_subconfig_rec.priority IS NULL)
4331: THEN
4332: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4333: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4334: FND_MSG_PUB.ADD;
4335: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4336: THEN
4337: fnd_log.message

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

4342: );
4343: END IF;
4344: ELSIF (p_x_subconfig_rec.priority <= 0)
4345: THEN
4346: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4347: FND_MSG_PUB.ADD;
4348: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4349: THEN
4350: fnd_log.message

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

4492: -- Validate the MC with mc_header_id = p_x_subconfig_rec.mc_header_id is complete
4493: l_header_status := Get_MC_Status(null, p_x_subconfig_rec.mc_header_id);
4494: IF (l_header_status NOT IN ('APPROVAL_PENDING', 'COMPLETE', 'DRAFT', 'APPROVAL_REJECTED'))
4495: THEN
4496: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_STS_INV');
4497: FND_MSG_PUB.ADD;
4498: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4499: THEN
4500: fnd_log.message

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

4515: /*
4516: -- Should be able to unexpire an expired subconfiguration association
4517: IF (G_TRUNC_DATE >= trunc(nvl(l_end_date, G_SYSDATE + 1)))
4518: THEN
4519: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_SUBMC_DATE_INV');
4520: FND_MSG_PUB.ADD;
4521: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4522: THEN
4523: fnd_log.message

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

4531: */
4532:
4533: 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)
4534: THEN
4535: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_DATE_INV');
4536: FND_MSG_PUB.ADD;
4537: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4538: THEN
4539: fnd_log.message

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

4546: END IF;
4547:
4548: 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)
4549: THEN
4550: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_END_DATE_INV');
4551: FND_MSG_PUB.ADD;
4552: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4553: THEN
4554: fnd_log.message

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

4561: END IF;
4562:
4563: 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)))
4564: THEN
4565: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_START_END_INV');
4566: FND_MSG_PUB.ADD;
4567: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4568: THEN
4569: fnd_log.message

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

4577:
4578:
4579: IF (p_x_subconfig_rec.priority IS NULL)
4580: THEN
4581: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4582: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4583: FND_MSG_PUB.ADD;
4584: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4585: THEN

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

4578:
4579: IF (p_x_subconfig_rec.priority IS NULL)
4580: THEN
4581: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_SUBMC_NULL');
4582: FND_MESSAGE.Set_Token('SUB_MC',p_x_subconfig_rec.name);
4583: FND_MSG_PUB.ADD;
4584: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4585: THEN
4586: fnd_log.message

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

4591: );
4592: END IF;
4593: ELSIF (p_x_subconfig_rec.priority <= 0)
4594: THEN
4595: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PRIORITY_INVALID_JSP');
4596: FND_MSG_PUB.ADD;
4597: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4598: THEN
4599: fnd_log.message

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

4799: OPEN check_leaf_node(p_dest_rel_id);
4800: FETCH check_leaf_node INTO l_dummy_varchar;
4801: IF (check_leaf_node%FOUND)
4802: THEN
4803: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NOT_LEAF_NODE');
4804: FND_MSG_PUB.ADD;
4805: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4806: THEN
4807: fnd_log.message

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

4833:
4834: OPEN get_mc_details(l_subconfig_csr_rec.mc_header_id);
4835: FETCH get_mc_details INTO l_submc_name;
4836: CLOSE get_mc_details;
4837: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4838: FND_MESSAGE.Set_Token('MC', l_mc_name);
4839: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4840: FND_MSG_PUB.ADD;
4841: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

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

4834: OPEN get_mc_details(l_subconfig_csr_rec.mc_header_id);
4835: FETCH get_mc_details INTO l_submc_name;
4836: CLOSE get_mc_details;
4837: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4838: FND_MESSAGE.Set_Token('MC', l_mc_name);
4839: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4840: FND_MSG_PUB.ADD;
4841: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4842: THEN

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

4835: FETCH get_mc_details INTO l_submc_name;
4836: CLOSE get_mc_details;
4837: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_CYCLIC_REL_EXIST');
4838: FND_MESSAGE.Set_Token('MC', l_mc_name);
4839: FND_MESSAGE.Set_Token('SUBMC', l_submc_name);
4840: FND_MSG_PUB.ADD;
4841: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
4842: THEN
4843: fnd_log.message