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_FMP_PVT dependencies on AHL_DEBUG_PUB

Line 85: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

81: l_mr_header_id NUMBER;
82: l_index NUMBER;
83: i NUMBER;
84: l_inst_attri get_inst_attri%ROWTYPE;
85: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
86: l_error_flag VARCHAR2(1) :='N';
87: --check whether the given mr exists
88: CURSOR check_mr_exists(c_mr_header_id number)
89: IS

Line 681: AHL_DEBUG_PUB.enable_debug;

677: l_counter number;
678: BEGIN
679: SAVEPOINT GET_MR_AFFECTED_ITEMS_PVT;
680: IF l_debug = 'Y' THEN
681: AHL_DEBUG_PUB.enable_debug;
682: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
683: END IF;
684: IF FND_API.to_boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;

Line 682: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

678: BEGIN
679: SAVEPOINT GET_MR_AFFECTED_ITEMS_PVT;
680: IF l_debug = 'Y' THEN
681: AHL_DEBUG_PUB.enable_debug;
682: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
683: END IF;
684: IF FND_API.to_boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;
686: END IF;

Line 696: AHL_DEBUG_PUB.debug(' Phase 1');

692: THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: -- Check whether the mr_header_id exists --
696: AHL_DEBUG_PUB.debug(' Phase 1');
697:
698: DELETE FROM ahl_mr_instances_temp;
699: DELETE FROM ahl_applicable_instances;
700:

Line 710: AHL_DEBUG_PUB.debug(' Phase 2');

706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709: CLOSE check_mr_exists;
710: AHL_DEBUG_PUB.debug(' Phase 2');
711:
712: -- Check whether the mr_effectivity_id exists and if it does, check whether it
713: -- belongs to the mr_header_id
714: OPEN check_mr_effect(p_mr_effectivity_id,p_mr_header_id);

Line 734: AHL_DEBUG_PUB.debug(' After Call to MC path positions');

730: x_msg_data =>l_msg_data
731: );
732:
733: IF l_debug = 'Y' THEN
734: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
735: Select count(*) into l_counter
736: from ahl_applicable_instances;
737: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
738: END IF;

Line 737: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);

733: IF l_debug = 'Y' THEN
734: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
735: Select count(*) into l_counter
736: from ahl_applicable_instances;
737: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
738: END IF;
739: END IF;
740: l_mr_header_id := l_mr_effect.mr_header_id;
741:

Line 754: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);

750: IF L_ERROR_FLAG='Y'
751: THEN
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);
755:
756: -- To avoid being in the same database session when refreshing or table navigating
757: -- the same page due to using the global temporary table.
758: AHL_DEBUG_PUB.debug(' Phase 4');

Line 758: AHL_DEBUG_PUB.debug(' Phase 4');

754: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);
755:
756: -- To avoid being in the same database session when refreshing or table navigating
757: -- the same page due to using the global temporary table.
758: AHL_DEBUG_PUB.debug(' Phase 4');
759: l_index :=1;
760:
761: FOR l_mr_effect IN get_mr_effect(p_mr_header_id, p_mr_effectivity_id)
762: LOOP

Line 765: AHL_DEBUG_PUB.debug(' Phase 8');

761: FOR l_mr_effect IN get_mr_effect(p_mr_header_id, p_mr_effectivity_id)
762: LOOP
763: IF (l_mr_effect.inventory_item_id IS NOT NULL AND l_mr_effect.relationship_id IS NULL
764: AND l_mr_effect.pc_node_id IS NULL) THEN
765: AHL_DEBUG_PUB.debug(' Phase 8');
766: --DBMS_OUTPUT.put_line('API1: Come here in case 1B and l_index is: '||l_index);
767: FOR l_get_inst1 IN get_inst1(l_mr_effect.inventory_item_id)
768: LOOP
769: AHL_DEBUG_PUB.debug(' Phase 9');

Line 769: AHL_DEBUG_PUB.debug(' Phase 9');

765: AHL_DEBUG_PUB.debug(' Phase 8');
766: --DBMS_OUTPUT.put_line('API1: Come here in case 1B and l_index is: '||l_index);
767: FOR l_get_inst1 IN get_inst1(l_mr_effect.inventory_item_id)
768: LOOP
769: AHL_DEBUG_PUB.debug(' Phase 9');
770: IF (check_effectivity_details(l_get_inst1.instance_id, l_mr_effect.mr_effectivity_id )) THEN
771: x_mr_item_inst_tbl(l_index).item_instance_id := l_get_inst1.instance_id;
772: x_mr_item_inst_tbl(l_index).mr_effectivity_id := l_mr_effect.mr_effectivity_id;
773: l_index := l_index+1;

Line 775: AHL_DEBUG_PUB.debug(' Phase 10');

771: x_mr_item_inst_tbl(l_index).item_instance_id := l_get_inst1.instance_id;
772: x_mr_item_inst_tbl(l_index).mr_effectivity_id := l_mr_effect.mr_effectivity_id;
773: l_index := l_index+1;
774: END IF;
775: AHL_DEBUG_PUB.debug(' Phase 10');
776: END LOOP;
777: ELSIF (l_mr_effect.relationship_id IS NOT NULL
778: AND l_mr_effect.inventory_item_id IS NULL
779: AND l_mr_effect.pc_node_id IS NULL)

Line 999: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

995: --IF FND_API.TO_BOOLEAN(p_commit) THEN
996: -- COMMIT;
997: --END IF;
998: IF l_debug = 'Y' THEN
999: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1000: AHL_DEBUG_PUB.disable_debug;
1001: END IF;
1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;

Line 1000: AHL_DEBUG_PUB.disable_debug;

996: -- COMMIT;
997: --END IF;
998: IF l_debug = 'Y' THEN
999: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1000: AHL_DEBUG_PUB.disable_debug;
1001: END IF;
1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1009: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1006: p_count => x_msg_count,
1007: p_data => x_msg_data);
1008: IF l_debug = 'Y' THEN
1009: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1010: 'UNEXPECTED ERROR IN PRIVATE:' );
1011: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1012: AHL_DEBUG_PUB.disable_debug;
1013: END IF;

Line 1011: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1007: p_data => x_msg_data);
1008: IF l_debug = 'Y' THEN
1009: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1010: 'UNEXPECTED ERROR IN PRIVATE:' );
1011: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1012: AHL_DEBUG_PUB.disable_debug;
1013: END IF;
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;

Line 1012: AHL_DEBUG_PUB.disable_debug;

1008: IF l_debug = 'Y' THEN
1009: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1010: 'UNEXPECTED ERROR IN PRIVATE:' );
1011: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1012: AHL_DEBUG_PUB.disable_debug;
1013: END IF;
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1016: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1021: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1017: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: IF l_debug = 'Y' THEN
1021: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1022: 'ERROR IN PRIVATE:' );
1023: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1024: AHL_DEBUG_PUB.disable_debug;
1025: END IF;

Line 1023: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1019: p_data => x_msg_data);
1020: IF l_debug = 'Y' THEN
1021: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1022: 'ERROR IN PRIVATE:' );
1023: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1024: AHL_DEBUG_PUB.disable_debug;
1025: END IF;
1026: WHEN OTHERS THEN
1027: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;

Line 1024: AHL_DEBUG_PUB.disable_debug;

1020: IF l_debug = 'Y' THEN
1021: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1022: 'ERROR IN PRIVATE:' );
1023: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1024: AHL_DEBUG_PUB.disable_debug;
1025: END IF;
1026: WHEN OTHERS THEN
1027: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1038: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

1034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data);
1037: IF l_debug = 'Y' THEN
1038: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1039: 'OTHER ERROR IN PRIVATE:' );
1040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1041: AHL_DEBUG_PUB.disable_debug;
1042: END IF;

Line 1040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1036: p_data => x_msg_data);
1037: IF l_debug = 'Y' THEN
1038: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1039: 'OTHER ERROR IN PRIVATE:' );
1040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1041: AHL_DEBUG_PUB.disable_debug;
1042: END IF;
1043: END GET_MR_AFFECTED_ITEMS;
1044:

Line 1041: AHL_DEBUG_PUB.disable_debug;

1037: IF l_debug = 'Y' THEN
1038: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1039: 'OTHER ERROR IN PRIVATE:' );
1040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1041: AHL_DEBUG_PUB.disable_debug;
1042: END IF;
1043: END GET_MR_AFFECTED_ITEMS;
1044:
1045: -- This API is revamped to fix Bug 6266738

Line 1069: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

1065: l_api_version CONSTANT NUMBER := 1.0;
1066: l_msg_count NUMBER;
1067: l_return_status VARCHAR2(1);
1068: l_item_instance_id NUMBER;
1069: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
1070:
1071:
1072: --Get inst_relation_rec for top node of UC
1073: CURSOR uc_top_inst(c_item_instance_id NUMBER) IS

Line 1824: AHL_DEBUG_PUB.enable_debug;

1820: BEGIN
1821: SAVEPOINT GET_APPLICABLE_MRS_PVT;
1822:
1823: IF l_debug = 'Y' THEN
1824: AHL_DEBUG_PUB.enable_debug;
1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);

Line 1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');

1821: SAVEPOINT GET_APPLICABLE_MRS_PVT;
1822:
1823: IF l_debug = 'Y' THEN
1824: AHL_DEBUG_PUB.enable_debug;
1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);
1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);

Line 1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);

1822:
1823: IF l_debug = 'Y' THEN
1824: AHL_DEBUG_PUB.enable_debug;
1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);
1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);
1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);

Line 1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);

1823: IF l_debug = 'Y' THEN
1824: AHL_DEBUG_PUB.enable_debug;
1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);
1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);
1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);
1831: END IF;

Line 1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);

1824: AHL_DEBUG_PUB.enable_debug;
1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);
1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);
1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);
1831: END IF;
1832:

Line 1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);

1825: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);
1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);
1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);
1831: END IF;
1832:
1833: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);

1826: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id);
1827: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id);
1828: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag);
1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);
1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);
1831: END IF;
1832:
1833: IF FND_API.to_boolean(p_init_msg_list) THEN
1834: FND_MSG_PUB.initialize;

Line 1861: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id);

1857: CLOSE check_instance_exists;
1858: END IF;
1859:
1860: IF l_debug = 'Y' THEN
1861: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id);
1862: END IF;
1863:
1864: /* -- commenting as this is not required.
1865: -- get root instance.

Line 1884: AHL_DEBUG_PUB.debug('Start Processing..');

1880: -- start processing. First populate temp table ahl_applicable_instances by calling
1881: -- MC api to map instance (and components) to path positions.
1882:
1883: IF l_debug = 'Y' THEN
1884: AHL_DEBUG_PUB.debug('Start Processing..');
1885: END IF;
1886:
1887: l_path_posn_flag := FALSE;
1888:

Line 1921: AHL_DEBUG_PUB.debug('Processing MC Relationships..');

1917:
1918: IF (l_path_posn_flag) THEN
1919:
1920: IF l_debug = 'Y' THEN
1921: AHL_DEBUG_PUB.debug('Processing MC Relationships..');
1922: END IF;
1923:
1924: DELETE FROM ahl_applicable_instances;
1925: -- for input instance.

Line 1947: AHL_DEBUG_PUB.debug('Processing Component MC Relationships..');

1943: END IF;
1944:
1945: IF (p_components_flag = 'Y') THEN
1946: IF l_debug = 'Y' THEN
1947: AHL_DEBUG_PUB.debug('Processing Component MC Relationships..');
1948: END IF;
1949:
1950: OPEN get_config_tree_csr(p_item_instance_id);
1951: LOOP

Line 1984: AHL_DEBUG_PUB.debug('Processing Inventory Items..');

1980:
1981: END IF; -- l_path_posn_flag
1982:
1983: IF l_debug = 'Y' THEN
1984: AHL_DEBUG_PUB.debug('Processing Inventory Items..');
1985: END IF;
1986:
1987: l_index := 1;
1988:

Line 2013: AHL_DEBUG_PUB.debug('Processing Component Effectivities based on Inventory Items..');

2009: ELSE
2010: OPEN get_comp_vst_inv_csr(p_item_instance_id, p_visit_type_code);
2011: END IF;
2012: IF l_debug = 'Y' THEN
2013: AHL_DEBUG_PUB.debug('Processing Component Effectivities based on Inventory Items..');
2014: END IF;
2015:
2016: ELSIF (l_process_loop = 3) THEN
2017: -- get eff based on positions

Line 2025: AHL_DEBUG_PUB.debug('Processing Effectivities based on MC Positions..');

2021: OPEN get_posn_vst_csr(p_visit_type_code);
2022: END IF;
2023:
2024: IF l_debug = 'Y' THEN
2025: AHL_DEBUG_PUB.debug('Processing Effectivities based on MC Positions..');
2026: END IF;
2027: END IF;
2028:
2029: LOOP

Line 2073: AHL_DEBUG_PUB.debug('Count of l_mr_header_id_tbl:' || l_mr_header_id_tbl.count);

2069:
2070: EXIT WHEN (l_mr_header_id_tbl.count = 0);
2071:
2072: IF l_debug = 'Y' THEN
2073: AHL_DEBUG_PUB.debug('Count of l_mr_header_id_tbl:' || l_mr_header_id_tbl.count);
2074: END IF;
2075:
2076: -- process retrieved effectivity IDs.
2077: FOR i IN l_mr_effectivity_id_tbl.FIRST..l_mr_effectivity_id_tbl.LAST LOOP

Line 2081: AHL_DEBUG_PUB.debug('Now processing MR ID:EFF ID:INST ID:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_instance_id_tbl(i));

2077: FOR i IN l_mr_effectivity_id_tbl.FIRST..l_mr_effectivity_id_tbl.LAST LOOP
2078:
2079: /*
2080: IF l_debug = 'Y' THEN
2081: AHL_DEBUG_PUB.debug('Now processing MR ID:EFF ID:INST ID:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_instance_id_tbl(i));
2082: END IF;
2083: */
2084:
2085: -- to begin with, set effectivity as valid.

Line 2168: AHL_DEBUG_PUB.debug('MR ID:EFF ID:INST ID:Valid Flag:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_instance_id_tbl(i) || ':' || l_valid_mr_flag);

2164: END IF;
2165: --amsriniv End
2166:
2167: IF l_debug = 'Y' THEN
2168: AHL_DEBUG_PUB.debug('MR ID:EFF ID:INST ID:Valid Flag:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_instance_id_tbl(i) || ':' || l_valid_mr_flag);
2169: END IF;
2170:
2171: -- add row to x_applicable_mr_tbl
2172: IF (l_valid_mr_flag = 'Y') THEN

Line 2201: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||

2197: x_applicable_mr_tbl(l_index).copy_accomplishment_flag := l_get_mr_attri.copy_accomplishment_flag;
2198: x_applicable_mr_tbl(l_index).implement_status_code := l_get_mr_attri.implement_status_code;
2199: x_applicable_mr_tbl(l_index).descendent_count := l_get_mr_attri.descendent_count;
2200: IF l_debug = 'Y' THEN
2201: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
2202: x_applicable_mr_tbl(l_index).mr_header_id || ' mr_effectivity_id ' ||
2203: x_applicable_mr_tbl(l_index).mr_effectivity_id || ' item_instance_id ' ||
2204: x_applicable_mr_tbl(l_index).item_instance_id || ' repetitive_flag ' ||
2205: x_applicable_mr_tbl(l_index).repetitive_flag || ' show_repetitive_code ' ||

Line 2268: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');

2264: DELETE FROM ahl_applicable_instances;
2265:
2266: --DBMS_OUTPUT.PUT_LINE('API2: Successfully executed API2!');
2267: IF l_debug = 'Y' THEN
2268: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
2269: AHL_DEBUG_PUB.disable_debug;
2270: END IF;
2271:
2272:

Line 2269: AHL_DEBUG_PUB.disable_debug;

2265:
2266: --DBMS_OUTPUT.PUT_LINE('API2: Successfully executed API2!');
2267: IF l_debug = 'Y' THEN
2268: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS');
2269: AHL_DEBUG_PUB.disable_debug;
2270: END IF;
2271:
2272:
2273: EXCEPTION

Line 2282: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

2278: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281: IF l_debug = 'Y' THEN
2282: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
2283: 'UNEXPECTED ERROR IN PRIVATE:' );
2284: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2285: AHL_DEBUG_PUB.disable_debug;
2286: END IF;

Line 2284: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');

2280: p_data => x_msg_data);
2281: IF l_debug = 'Y' THEN
2282: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
2283: 'UNEXPECTED ERROR IN PRIVATE:' );
2284: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2285: AHL_DEBUG_PUB.disable_debug;
2286: END IF;
2287:
2288: WHEN FND_API.G_EXC_ERROR THEN

Line 2285: AHL_DEBUG_PUB.disable_debug;

2281: IF l_debug = 'Y' THEN
2282: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
2283: 'UNEXPECTED ERROR IN PRIVATE:' );
2284: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2285: AHL_DEBUG_PUB.disable_debug;
2286: END IF;
2287:
2288: WHEN FND_API.G_EXC_ERROR THEN
2289: ROLLBACK TO GET_APPLICABLE_MRS_PVT;

Line 2295: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

2291: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2292: p_count => x_msg_count,
2293: p_data => x_msg_data);
2294: IF l_debug = 'Y' THEN
2295: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
2296: 'ERROR IN PRIVATE:' );
2297: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2298: AHL_DEBUG_PUB.disable_debug;
2299: END IF;

Line 2297: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');

2293: p_data => x_msg_data);
2294: IF l_debug = 'Y' THEN
2295: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
2296: 'ERROR IN PRIVATE:' );
2297: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2298: AHL_DEBUG_PUB.disable_debug;
2299: END IF;
2300:
2301: WHEN OTHERS THEN

Line 2298: AHL_DEBUG_PUB.disable_debug;

2294: IF l_debug = 'Y' THEN
2295: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
2296: 'ERROR IN PRIVATE:' );
2297: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2298: AHL_DEBUG_PUB.disable_debug;
2299: END IF;
2300:
2301: WHEN OTHERS THEN
2302: ROLLBACK TO GET_APPLICABLE_MRS_PVT;

Line 2313: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

2309: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2310: p_count => x_msg_count,
2311: p_data => x_msg_data);
2312: IF l_debug = 'Y' THEN
2313: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
2314: 'OTHER ERROR IN PRIVATE:' );
2315: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2316: AHL_DEBUG_PUB.disable_debug;
2317: END IF;

Line 2315: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');

2311: p_data => x_msg_data);
2312: IF l_debug = 'Y' THEN
2313: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
2314: 'OTHER ERROR IN PRIVATE:' );
2315: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2316: AHL_DEBUG_PUB.disable_debug;
2317: END IF;
2318: END GET_APPLICABLE_MRS;
2319:

Line 2316: AHL_DEBUG_PUB.disable_debug;

2312: IF l_debug = 'Y' THEN
2313: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
2314: 'OTHER ERROR IN PRIVATE:' );
2315: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2316: AHL_DEBUG_PUB.disable_debug;
2317: END IF;
2318: END GET_APPLICABLE_MRS;
2319:
2320: -- Define procedure get_ucHeader, get the unit_config_header_id and unit name for

Line 2354: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

2350: AND trunc(nvl(active_end_date, SYSDATE+1));
2351:
2352: l_get_unit_name_com get_unit_name_com%ROWTYPE;
2353: l_get_unit_name_top get_unit_name_top%ROWTYPE;
2354: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
2355: BEGIN
2356: --Check for top node.
2357: OPEN get_unit_name_top(p_item_instance_id);
2358: FETCH get_unit_name_top INTO l_get_unit_name_top;

Line 2414: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

2410: WHERE instance_id = p_item_instance_id
2411: AND sysdate between trunc(nvl(active_start_date,sysdate))
2412: AND trunc(nvl(active_end_date, SYSDATE+1));
2413:
2414: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
2415: l_top_instance_id NUMBER;
2416: BEGIN
2417: --Check for top node.
2418: OPEN get_instance_top(p_item_instance_id);

Line 2760: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

2756: x_serial_prefix OUT NOCOPY VARCHAR2,
2757: x_serial_suffix OUT NOCOPY NUMBER
2758: ) IS
2759: i NUMBER := 0;
2760: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
2761: BEGIN
2762: LOOP
2763: i := i+1;
2764: EXIT WHEN SUBSTR(p_serial_number,-i,1) NOT IN ('0','1','2','3','4','5','6','7','8','9')

Line 3008: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

3004: implement_status_code
3005: FROM ahl_mr_headers_app_v
3006: WHERE mr_header_id = c_mr_header_id;
3007: l_get_mr_attri get_mr_attri%ROWTYPE;
3008: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3009: BEGIN
3010: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3011: IF l_debug = 'Y' THEN
3012: AHL_DEBUG_PUB.enable_debug;

Line 3012: AHL_DEBUG_PUB.enable_debug;

3008: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3009: BEGIN
3010: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3011: IF l_debug = 'Y' THEN
3012: AHL_DEBUG_PUB.enable_debug;
3013: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3014: AHL_DEBUG_PUB.debug('');
3015: END IF;
3016: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3013: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

3009: BEGIN
3010: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3011: IF l_debug = 'Y' THEN
3012: AHL_DEBUG_PUB.enable_debug;
3013: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3014: AHL_DEBUG_PUB.debug('');
3015: END IF;
3016: IF FND_API.to_boolean(p_init_msg_list) THEN
3017: FND_MSG_PUB.initialize;

Line 3014: AHL_DEBUG_PUB.debug('');

3010: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3011: IF l_debug = 'Y' THEN
3012: AHL_DEBUG_PUB.enable_debug;
3013: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3014: AHL_DEBUG_PUB.debug('');
3015: END IF;
3016: IF FND_API.to_boolean(p_init_msg_list) THEN
3017: FND_MSG_PUB.initialize;
3018: END IF;

Line 3056: AHL_DEBUG_PUB.debug('Item instance id:' || l_item_instance_id);

3052: END IF;
3053: CLOSE get_inventory_item;
3054:
3055: IF l_debug = 'Y' THEN
3056: AHL_DEBUG_PUB.debug('Item instance id:' || l_item_instance_id);
3057: END IF;
3058:
3059: -- Call OKS API to get program_ids
3060: l_inp_rec.contract_number := NULL;

Line 3093: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);

3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091:
3092: IF l_debug = 'Y' THEN
3093: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);
3094: AHL_DEBUG_PUB.debug('Count on pm_activities:' || l_pm_activities.count );
3095: END IF;
3096:
3097: iap := 1;

Line 3094: AHL_DEBUG_PUB.debug('Count on pm_activities:' || l_pm_activities.count );

3090: END IF;
3091:
3092: IF l_debug = 'Y' THEN
3093: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);
3094: AHL_DEBUG_PUB.debug('Count on pm_activities:' || l_pm_activities.count );
3095: END IF;
3096:
3097: iap := 1;
3098: iaa := 1;

Line 3103: AHL_DEBUG_PUB.debug('Appl MR found:' || l_get_applicable_mrs.mr_header_id);

3099: -- iap_u := 1;
3100: -- l_prior_mr_header_id := -1;
3101: FOR l_get_applicable_mrs IN get_applicable_mrs(l_inventory_item_id) LOOP
3102: IF l_debug = 'Y' THEN
3103: AHL_DEBUG_PUB.debug('Appl MR found:' || l_get_applicable_mrs.mr_header_id);
3104: END IF;
3105:
3106: IF l_ent_contracts.COUNT > 0 THEN
3107: FOR i IN l_ent_contracts.FIRST..l_ent_contracts.LAST LOOP

Line 3111: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);

3107: FOR i IN l_ent_contracts.FIRST..l_ent_contracts.LAST LOOP
3108: IF l_ent_contracts(i).pm_program_id = l_get_applicable_mrs.mr_header_id THEN
3109:
3110: IF l_debug = 'Y' THEN
3111: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);
3112: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);
3113: AHL_DEBUG_PUB.debug('---------------------------');
3114: END IF;
3115:

Line 3112: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);

3108: IF l_ent_contracts(i).pm_program_id = l_get_applicable_mrs.mr_header_id THEN
3109:
3110: IF l_debug = 'Y' THEN
3111: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);
3112: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);
3113: AHL_DEBUG_PUB.debug('---------------------------');
3114: END IF;
3115:
3116: x_applicable_programs_tbl(iap).contract_id := l_ent_contracts(i).contract_id;

Line 3113: AHL_DEBUG_PUB.debug('---------------------------');

3109:
3110: IF l_debug = 'Y' THEN
3111: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);
3112: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);
3113: AHL_DEBUG_PUB.debug('---------------------------');
3114: END IF;
3115:
3116: x_applicable_programs_tbl(iap).contract_id := l_ent_contracts(i).contract_id;
3117: x_applicable_programs_tbl(iap).contract_number := l_ent_contracts(i).contract_number;

Line 3204: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

3200: END LOOP;
3201: END IF;
3202:
3203: IF l_debug = 'Y' THEN
3204: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3205: AHL_DEBUG_PUB.disable_debug;
3206: END IF;
3207:
3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3205: AHL_DEBUG_PUB.disable_debug;

3201: END IF;
3202:
3203: IF l_debug = 'Y' THEN
3204: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3205: AHL_DEBUG_PUB.disable_debug;
3206: END IF;
3207:
3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;

Line 3215: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

3211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,
3213: p_data => x_msg_data);
3214: IF l_debug = 'Y' THEN
3215: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3216: 'UNEXPECTED ERROR IN PRIVATE:' );
3217: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3218: AHL_DEBUG_PUB.disable_debug;
3219: END IF;

Line 3217: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

3213: p_data => x_msg_data);
3214: IF l_debug = 'Y' THEN
3215: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3216: 'UNEXPECTED ERROR IN PRIVATE:' );
3217: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3218: AHL_DEBUG_PUB.disable_debug;
3219: END IF;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;

Line 3218: AHL_DEBUG_PUB.disable_debug;

3214: IF l_debug = 'Y' THEN
3215: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3216: 'UNEXPECTED ERROR IN PRIVATE:' );
3217: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3218: AHL_DEBUG_PUB.disable_debug;
3219: END IF;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3222: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3227: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

3223: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);
3226: IF l_debug = 'Y' THEN
3227: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3228: 'ERROR IN PRIVATE:' );
3229: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3230: AHL_DEBUG_PUB.disable_debug;
3231: END IF;

Line 3229: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

3225: p_data => x_msg_data);
3226: IF l_debug = 'Y' THEN
3227: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3228: 'ERROR IN PRIVATE:' );
3229: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3230: AHL_DEBUG_PUB.disable_debug;
3231: END IF;
3232: WHEN OTHERS THEN
3233: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;

Line 3230: AHL_DEBUG_PUB.disable_debug;

3226: IF l_debug = 'Y' THEN
3227: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3228: 'ERROR IN PRIVATE:' );
3229: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3230: AHL_DEBUG_PUB.disable_debug;
3231: END IF;
3232: WHEN OTHERS THEN
3233: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3245: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

3241: p_count => x_msg_count,
3242: p_data => x_msg_data);
3243: IF l_debug = 'Y' THEN
3244:
3245: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
3246: 'OTHER ERROR IN PRIVATE:' );
3247: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3248: AHL_DEBUG_PUB.disable_debug;
3249: END IF;

Line 3247: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

3243: IF l_debug = 'Y' THEN
3244:
3245: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
3246: 'OTHER ERROR IN PRIVATE:' );
3247: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3248: AHL_DEBUG_PUB.disable_debug;
3249: END IF;
3250:
3251: END GET_PM_APPLICABLE_MRS;

Line 3248: AHL_DEBUG_PUB.disable_debug;

3244:
3245: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
3246: 'OTHER ERROR IN PRIVATE:' );
3247: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3248: AHL_DEBUG_PUB.disable_debug;
3249: END IF;
3250:
3251: END GET_PM_APPLICABLE_MRS;
3252: