1: PACKAGE BODY AHL_LTP_REQST_MATRL_PUB AS
2: /* $Header: AHLPRMTB.pls 120.0.12020000.2 2012/12/10 15:48:51 prakkum ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_REQST_MATRL_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
1: PACKAGE BODY AHL_LTP_REQST_MATRL_PUB AS
2: /* $Header: AHLPRMTB.pls 120.0.12020000.2 2012/12/10 15:48:51 prakkum ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_REQST_MATRL_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -- PACKAGE
8: -- AHL_LTP_REQST_MATRL_PUB
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_REQST_MATRL_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -- PACKAGE
8: -- AHL_LTP_REQST_MATRL_PUB
9: --
10: -- PURPOSE
11: -- This Public API is used to schedule and unschedule materials requests
12: -- using Material Requirement Interface
71: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
72: fnd_log.string
73: (
74: fnd_log.level_procedure,
75: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',
76: 'At the start of PLSQL procedure'
77: );
78: END IF;
79: -- Standard start of API savepoint
142: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
143: fnd_log.string
144: (
145: fnd_log.level_procedure,
146: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update Planned Materials.end',
147: 'At the end of PLSQL procedure'
148: );
149: END IF;
150: EXCEPTION
236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
237: fnd_log.string
238: (
239: fnd_log.level_procedure,
240: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Process_Planned_Materials',
241: 'At the start of PLSQL procedure'
242: );
243: END IF;
244: -- Standard start of API savepoint
311: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
312: fnd_log.string
313: (
314: fnd_log.level_procedure,
315: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Process_Planned_Materials.end',
316: 'At the end of PLSQL procedure'
317: );
318: END IF;
319: EXCEPTION
345: p_data => x_msg_data,
346: p_encoded => fnd_api.g_false);
347: END Process_Planned_Materials;
348:
349: END AHL_LTP_REQST_MATRL_PUB;