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.1.12020000.2 2012/12/07 00:45:04 sareepar ship $ */
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.1.12020000.2 2012/12/07 00:45:04 sareepar ship $ */
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 168: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Material_Aval',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

761: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
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, Visit Task Id: ' || x_task_matrl_aval_tbl(i).visit_task_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, Inventory Item Id: ' || x_task_matrl_aval_tbl(i).inventory_item_id
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: ' || x_task_matrl_aval_tbl(i).quantity
779: );
780: fnd_log.string
781: (

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

779: );
780: fnd_log.string
781: (
782: fnd_log.level_statement,
783: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
784: ' Derieved Value, Quantity Available: ' || x_task_matrl_aval_tbl(i).quantity_available
785: );
786: fnd_log.string
787: (

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

785: );
786: fnd_log.string
787: (
788: fnd_log.level_statement,
789: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check_Materials_For_All',
790: 'at last x_task_matrl_aval_tbl(i).scheduled_date ' || x_task_matrl_aval_tbl(i).scheduled_date
791: );
792:
793: END IF;

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

812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
813: fnd_log.string
814: (
815: fnd_log.level_procedure,
816: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Check Materials For All.end',
817: 'At the end of PLSQL procedure'
818: );
819: END IF;
820:

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

837: ROLLBACK TO check_materials_for_all;
838: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
842: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
843: p_error_text => SUBSTR(SQLERRM,1,240));
844: END IF;
845: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
902: fnd_log.string
903: (
904: fnd_log.level_procedure,
905: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_Planned_Matrls.begin',
906: 'At the start of PLSQL procedure'
907: );
908: END IF;
909:

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

996: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
997: fnd_log.string
998: (
999: fnd_log.level_statement,
1000: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1001: ' Derieved Value, Schedule Material Id: ' || p_x_planned_matrl_tbl(i).schedule_material_id
1002: );
1003: fnd_log.string
1004: (

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

1002: );
1003: fnd_log.string
1004: (
1005: fnd_log.level_statement,
1006: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1007: ' Derieved Value, Available Quantity: ' || p_x_planned_matrl_tbl(i).quantity_available
1008: );
1009: fnd_log.string
1010: (

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

1008: );
1009: fnd_log.string
1010: (
1011: fnd_log.level_statement,
1012: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1013: 'p_x_planned_matrl_tbl(i).scheduled_date: ' || p_x_planned_matrl_tbl(i).scheduled_date
1014: );
1015:
1016: END IF;

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

1025: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1026: fnd_log.string
1027: (
1028: fnd_log.level_procedure,
1029: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_Planned_Matrls.end',
1030: 'At the end of PLSQL procedure'
1031: );
1032: END IF;
1033:

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

1051: ROLLBACK TO Schedule_Planned_Matrls;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1056: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1123: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1124: fnd_log.string
1125: (
1126: fnd_log.level_procedure,
1127: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_All_Materials.begin',
1128: 'At the start of PLSQL procedure'
1129: );
1130: END IF;
1131:

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

1237: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1238: fnd_log.string
1239: (
1240: fnd_log.level_statement,
1241: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1242: ' Derieved Value, Schedule Material Id: ' || X_Planned_Matrl_Tbl(i).schedule_material_id
1243: );
1244: fnd_log.string
1245: (

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

1243: );
1244: fnd_log.string
1245: (
1246: fnd_log.level_statement,
1247: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1248: ' Derieved Value, Available Quantity: ' || X_Planned_Matrl_Tbl(i).quantity_available
1249: );
1250: fnd_log.string
1251: (

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

1249: );
1250: fnd_log.string
1251: (
1252: fnd_log.level_statement,
1253: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule Planned Matrls',
1254: 'X_Planned_Matrl_Tbl(i).scheduled_date: ' ||X_Planned_Matrl_Tbl(i).scheduled_date
1255: );
1256:
1257: END IF;

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

1267: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1268: fnd_log.string
1269: (
1270: fnd_log.level_procedure,
1271: 'ahl.plsql.AHL_LTP_MATRL_AVAL_PUB.Schedule_All_Materials.end',
1272: 'At the end of PLSQL procedure'
1273: );
1274: END IF;
1275:

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

1292: ROLLBACK TO Schedule_All_Materials;
1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1295: THEN
1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1297: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1298: p_error_text => SUBSTR(SQLERRM,1,240));
1299: END IF;
1300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1307: END AHL_LTP_MATRL_AVAL_PUB;

1303:
1304: END Schedule_All_Materials;
1305:
1306: --
1307: END AHL_LTP_MATRL_AVAL_PUB;