DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PUB dependencies on FND_LOG

Line 70: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

66: l_commit VARCHAR2(10) := FND_API.g_false;
67: l_planned_materials_tbl planned_materials_tbl := p_planned_materials_tbl;
68: BEGIN
69:
70: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
71: fnd_log.string
72: (
73: fnd_log.level_procedure,
74: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',

Line 71: fnd_log.string

67: l_planned_materials_tbl planned_materials_tbl := p_planned_materials_tbl;
68: BEGIN
69:
70: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
71: fnd_log.string
72: (
73: fnd_log.level_procedure,
74: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',
75: 'At the start of PLSQL procedure'

Line 73: fnd_log.level_procedure,

69:
70: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
71: fnd_log.string
72: (
73: fnd_log.level_procedure,
74: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',
75: 'At the start of PLSQL procedure'
76: );
77: END IF;

Line 87: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

83: END IF;
84: -- Initialize API return status to success
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: --
87: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
88: fnd_log.string
89: (
90: fnd_log.level_statement,
91: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 88: fnd_log.string

84: -- Initialize API return status to success
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: --
87: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
88: fnd_log.string
89: (
90: fnd_log.level_statement,
91: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
92: 'Request for Update Material Number of Records : '|| l_planned_materials_tbl.COUNT

Line 90: fnd_log.level_statement,

86: --
87: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
88: fnd_log.string
89: (
90: fnd_log.level_statement,
91: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
92: 'Request for Update Material Number of Records : '|| l_planned_materials_tbl.COUNT
93: );
94:

Line 99: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

95: END IF;
96:
97: IF l_planned_materials_tbl.COUNT > 0 THEN
98: --
99: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
100: fnd_log.string
101: (
102: fnd_log.level_procedure,
103: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 100: fnd_log.string

96:
97: IF l_planned_materials_tbl.COUNT > 0 THEN
98: --
99: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
100: fnd_log.string
101: (
102: fnd_log.level_procedure,
103: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
104: 'Before calling ahl ltp reqst matrl pvt.Update Planned Materials'

Line 102: fnd_log.level_procedure,

98: --
99: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
100: fnd_log.string
101: (
102: fnd_log.level_procedure,
103: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
104: 'Before calling ahl ltp reqst matrl pvt.Update Planned Materials'
105: );
106:

Line 120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

116: x_msg_count => l_msg_count,
117: x_msg_data => l_msg_data);
118: END IF;
119:
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fnd_log.string
122: (
123: fnd_log.level_procedure,
124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',

Line 121: fnd_log.string

117: x_msg_data => l_msg_data);
118: END IF;
119:
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fnd_log.string
122: (
123: fnd_log.level_procedure,
124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
125: 'After calling ahl ltp reqst matrl pvt.Update Planned Materials, Return Status : '|| l_return_status

Line 123: fnd_log.level_procedure,

119:
120: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
121: fnd_log.string
122: (
123: fnd_log.level_procedure,
124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
125: 'After calling ahl ltp reqst matrl pvt.Update Planned Materials, Return Status : '|| l_return_status
126: );
127: END IF;

Line 141: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

137: IF FND_API.TO_BOOLEAN(p_commit) THEN
138: COMMIT WORK;
139: END IF;
140:
141: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
142: fnd_log.string
143: (
144: fnd_log.level_procedure,
145: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update Planned Materials.end',

Line 142: fnd_log.string

138: COMMIT WORK;
139: END IF;
140:
141: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
142: fnd_log.string
143: (
144: fnd_log.level_procedure,
145: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update Planned Materials.end',
146: 'At the end of PLSQL procedure'

Line 144: fnd_log.level_procedure,

140:
141: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
142: fnd_log.string
143: (
144: fnd_log.level_procedure,
145: 'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update Planned Materials.end',
146: 'At the end of PLSQL procedure'
147: );
148: END IF;