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_LTP_MATRL_AVAL_PUB dependencies on AHL_LTP_MATRL_AVAL_PUB

Line 1: PACKAGE BODY AHL_LTP_MATRL_AVAL_PUB AS

1: PACKAGE BODY AHL_LTP_MATRL_AVAL_PUB AS
2: /* $Header: AHLPMTAB.pls 120.0 2005/05/25 23:44:11 appldev noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PUB';

1: PACKAGE BODY AHL_LTP_MATRL_AVAL_PUB AS
2: /* $Header: AHLPMTAB.pls 120.0 2005/05/25 23:44:11 appldev noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -- PACKAGE
8: -- AHL_LTP_MATRL_AVAL_PUB

Line 8: -- AHL_LTP_MATRL_AVAL_PUB

4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_MATRL_AVAL_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -- PACKAGE
8: -- AHL_LTP_MATRL_AVAL_PUB
9: --
10: -- PURPOSE
11: -- This Package is a Public API for verifying material availabilty for an item
12: -- Calling ATP

Line 165: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',

161: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
162: fnd_log.string
163: (
164: fnd_log.level_statement,
165: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',
166: ' Derieved Value, Visit Task Id: ' || p_x_material_avl_tbl(i).visit_task_id
167: );
168: fnd_log.string
169: (

Line 171: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',

167: );
168: fnd_log.string
169: (
170: fnd_log.level_statement,
171: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',
172: ' Derieved Value, Inventory Item Id: ' || p_x_material_avl_tbl(i).inventory_item_id
173: );
174: fnd_log.string
175: (

Line 177: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',

173: );
174: fnd_log.string
175: (
176: fnd_log.level_statement,
177: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',
178: ' Derieved Value, Quantity: ' || p_x_material_avl_tbl(i).quantity
179: );
180: fnd_log.string
181: (

Line 183: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',

179: );
180: fnd_log.string
181: (
182: fnd_log.level_statement,
183: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',
184: ' Derieved Value, Quantity Available: ' || p_x_material_avl_tbl(i).quantity_available
185: );
186: fnd_log.string
187: (

Line 189: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',

185: );
186: fnd_log.string
187: (
188: fnd_log.level_statement,
189: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',
190: ' Derieved Value, Error Message: ' || p_x_material_avl_tbl(i).error_message
191: );
192:
193: END IF;

Line 214: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check Material Aval.end',

210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
211: fnd_log.string
212: (
213: fnd_log.level_procedure,
214: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check Material Aval.end',
215: 'At the end of PLSQL procedure'
216: );
217: END IF;
218:

Line 239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

235: ROLLBACK TO check_material_aval;
236: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: THEN
239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
240: p_procedure_name => 'CHECK_MATERIAL_AVAL',
241: p_error_text => SUBSTR(SQLERRM,1,240));
242: END IF;
243: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 300: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Get_Visit_Task_Materials.begin',

296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
297: fnd_log.string
298: (
299: fnd_log.level_procedure,
300: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Get_Visit_Task_Materials.begin',
301: 'At the start of PLSQL procedure'
302: );
303: END IF;
304: -- Standard Start of API savepoint

Line 474: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Get_Visit_Task_Materials.end',

470: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
471: fnd_log.string
472: (
473: fnd_log.level_procedure,
474: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Get_Visit_Task_Materials.end',
475: 'At the end of PLSQL procedure'
476: );
477: END IF;
478:

Line 499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

495: ROLLBACK TO get_visit_task_materials;
496: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
498: THEN
499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
500: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
501: p_error_text => SUBSTR(SQLERRM,1,240));
502: END IF;
503: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 662: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
659: fnd_log.string
660: (
661: fnd_log.level_statement,
662: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
663: ' After Calling Get Visit Task Materials, Number of Records: ' || l_task_req_matrl_tbl.COUNT
664: );
665: END IF;
666:

Line 692: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

688: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
689: fnd_log.string
690: (
691: fnd_log.level_statement,
692: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
693: ' Before Calling Ahl ltp Matrl aval pvt Check Material Aval, Number of Records: ' || l_material_avl_tbl.COUNT
694: );
695: END IF;
696: --Call check material

Line 731: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
728: fnd_log.string
729: (
730: fnd_log.level_statement,
731: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
732: ' Before Assigning , Number of Records: ' || l_material_avl_tbl.COUNT
733: );
734: END IF;
735:

Line 759: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

755: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
756: fnd_log.string
757: (
758: fnd_log.level_statement,
759: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
760: ' Derieved Value, Visit Task Id: ' || x_task_matrl_aval_tbl(i).visit_task_id
761: );
762: fnd_log.string
763: (

Line 765: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

761: );
762: fnd_log.string
763: (
764: fnd_log.level_statement,
765: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
766: ' Derieved Value, Inventory Item Id: ' || x_task_matrl_aval_tbl(i).inventory_item_id
767: );
768: fnd_log.string
769: (

Line 771: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

767: );
768: fnd_log.string
769: (
770: fnd_log.level_statement,
771: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
772: ' Derieved Value, Quantity: ' || x_task_matrl_aval_tbl(i).quantity
773: );
774: fnd_log.string
775: (

Line 777: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',

773: );
774: fnd_log.string
775: (
776: fnd_log.level_statement,
777: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
778: ' Derieved Value, Quantity Available: ' || x_task_matrl_aval_tbl(i).quantity_available
779: );
780:
781: END IF;

Line 804: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check Materials For All.end',

800: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
801: fnd_log.string
802: (
803: fnd_log.level_procedure,
804: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check Materials For All.end',
805: 'At the end of PLSQL procedure'
806: );
807: END IF;
808:

Line 829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

825: ROLLBACK TO check_materials_for_all;
826: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
830: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
831: p_error_text => SUBSTR(SQLERRM,1,240));
832: END IF;
833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 893: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_Planned_Matrls.begin',

889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
890: fnd_log.string
891: (
892: fnd_log.level_procedure,
893: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_Planned_Matrls.begin',
894: 'At the start of PLSQL procedure'
895: );
896: END IF;
897:

Line 985: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',

981: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
982: fnd_log.string
983: (
984: fnd_log.level_statement,
985: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
986: ' Derieved Value, Schedule Material Id: ' || p_x_planned_matrl_tbl(i).schedule_material_id
987: );
988: fnd_log.string
989: (

Line 991: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',

987: );
988: fnd_log.string
989: (
990: fnd_log.level_statement,
991: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
992: ' Derieved Value, Available Quantity: ' || p_x_planned_matrl_tbl(i).quantity_available
993: );
994:
995: END IF;

Line 1008: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_Planned_Matrls.end',

1004: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1005: fnd_log.string
1006: (
1007: fnd_log.level_procedure,
1008: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_Planned_Matrls.end',
1009: 'At the end of PLSQL procedure'
1010: );
1011: END IF;
1012:

Line 1034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

1030: ROLLBACK TO Schedule_Planned_Matrls;
1031: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1035: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1036: p_error_text => SUBSTR(SQLERRM,1,240));
1037: END IF;
1038: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1106: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_All_Materials.begin',

1102: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1103: fnd_log.string
1104: (
1105: fnd_log.level_procedure,
1106: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_All_Materials.begin',
1107: 'At the start of PLSQL procedure'
1108: );
1109: END IF;
1110:

Line 1217: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',

1213: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1214: fnd_log.string
1215: (
1216: fnd_log.level_statement,
1217: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1218: ' Derieved Value, Schedule Material Id: ' || X_Planned_Matrl_Tbl(i).schedule_material_id
1219: );
1220: fnd_log.string
1221: (

Line 1223: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',

1219: );
1220: fnd_log.string
1221: (
1222: fnd_log.level_statement,
1223: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1224: ' Derieved Value, Available Quantity: ' || X_Planned_Matrl_Tbl(i).quantity_available
1225: );
1226:
1227: END IF;

Line 1241: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_All_Materials.end',

1237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1238: fnd_log.string
1239: (
1240: fnd_log.level_procedure,
1241: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_All_Materials.end',
1242: 'At the end of PLSQL procedure'
1243: );
1244: END IF;
1245:

Line 1266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

1262: ROLLBACK TO Schedule_All_Materials;
1263: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1267: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1268: p_error_text => SUBSTR(SQLERRM,1,240));
1269: END IF;
1270: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1277: END AHL_LTP_MATRL_AVAL_PUB;

1273:
1274: END Schedule_All_Materials;
1275:
1276: --
1277: END AHL_LTP_MATRL_AVAL_PUB;