DBA Data[Home] [Help]

APPS.AHL_MC_PATH_POSITION_PUB dependencies on FND_LOG

Line 49: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

45: l_path_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type DEFAULT p_path_position_tbl;
46: --
47:
48: BEGIN
49: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
50: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
51: END IF;
52:
53: -- Standard start of API savepoint

Line 50: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');

46: --
47:
48: BEGIN
49: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
50: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
51: END IF;
52:
53: -- Standard start of API savepoint
54: SAVEPOINT Create_Position_ID_Pub;

Line 70: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

66: IF FND_API.To_Boolean(p_init_msg_list) THEN
67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
71: FND_LOG.string(FND_LOG.level_statement, l_full_name,
72: 'p_path_position_tbl.COUNT = '|| p_path_position_tbl.COUNT);
73: END IF;
74:

Line 71: FND_LOG.string(FND_LOG.level_statement, l_full_name,

67: FND_MSG_PUB.Initialize;
68: END IF;
69:
70: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
71: FND_LOG.string(FND_LOG.level_statement, l_full_name,
72: 'p_path_position_tbl.COUNT = '|| p_path_position_tbl.COUNT);
73: END IF;
74:
75: -- check for path position table

Line 86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

82:
83: -- call Convert_Path_Pos_Values_to_Id
84: Convert_Path_Pos_Values_to_Id(l_path_position_tbl);
85:
86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
87: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Calling private API AHL_MC_PATH_POSITION_PVT.Create_Position_ID.');
88: END IF;
89:
90: -- call the private API

Line 87: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Calling private API AHL_MC_PATH_POSITION_PVT.Create_Position_ID.');

83: -- call Convert_Path_Pos_Values_to_Id
84: Convert_Path_Pos_Values_to_Id(l_path_position_tbl);
85:
86: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
87: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Calling private API AHL_MC_PATH_POSITION_PVT.Create_Position_ID.');
88: END IF;
89:
90: -- call the private API
91: AHL_MC_PATH_POSITION_PVT.Create_Position_ID(

Line 107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

103: );
104:
105: -- check for the return status
106: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
108: FND_LOG.string(FND_LOG.level_statement, l_full_name,
109: 'Raising exception with x_return_status = ' || x_return_status);
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;

Line 108: FND_LOG.string(FND_LOG.level_statement, l_full_name,

104:
105: -- check for the return status
106: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
107: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
108: FND_LOG.string(FND_LOG.level_statement, l_full_name,
109: 'Raising exception with x_return_status = ' || x_return_status);
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;

Line 114: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);
116: END IF;
117:
118: -- Standard check of p_commit

Line 115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);

111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
115: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'AHL_MC_PATH_POSITION_PVT.Create_Position_ID returned x_return_status as ' || x_return_status);
116: END IF;
117:
118: -- Standard check of p_commit
119: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 130: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

126: p_data => x_msg_data,
127: p_encoded => FND_API.G_FALSE
128: );
129:
130: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
131: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
132: END IF;
133:
134: EXCEPTION

Line 131: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');

127: p_encoded => FND_API.G_FALSE
128: );
129:
130: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
131: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
132: END IF;
133:
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN

Line 211: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

207: l_validation_failed_flag VARCHAR2(1) := 'N';
208: --
209:
210: BEGIN
211: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
212: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
213: END IF;
214:
215: FOR i IN l_path_position_tbl.FIRST..l_path_position_tbl.LAST LOOP

Line 212: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');

208: --
209:
210: BEGIN
211: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
212: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
213: END IF;
214:
215: FOR i IN l_path_position_tbl.FIRST..l_path_position_tbl.LAST LOOP
216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

212: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
213: END IF;
214:
215: FOR i IN l_path_position_tbl.FIRST..l_path_position_tbl.LAST LOOP
216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_statement, l_full_name,
218: 'i = ' || i ||
219: ', l_path_position_tbl(i).mc_id = ' || l_path_position_tbl(i).mc_id||
220: ', l_path_position_tbl(i).mc_name = ' || l_path_position_tbl(i).mc_name||

Line 217: FND_LOG.string(FND_LOG.level_statement, l_full_name,

213: END IF;
214:
215: FOR i IN l_path_position_tbl.FIRST..l_path_position_tbl.LAST LOOP
216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_statement, l_full_name,
218: 'i = ' || i ||
219: ', l_path_position_tbl(i).mc_id = ' || l_path_position_tbl(i).mc_id||
220: ', l_path_position_tbl(i).mc_name = ' || l_path_position_tbl(i).mc_name||
221: ', l_path_position_tbl(i).mc_revision = ' || l_path_position_tbl(i).mc_revision||

Line 306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

302: CLOSE chk_mc_ver_no_csr;
303: END IF;
304: END IF;
305:
306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_statement, l_full_name,
308: 'i = '|| i ||
309: ', l_path_position_tbl(i).mc_id = ' || l_path_position_tbl(i).mc_id ||
310: ', l_path_position_tbl(i).mc_name = ' || l_path_position_tbl(i).mc_name ||

Line 307: FND_LOG.string(FND_LOG.level_statement, l_full_name,

303: END IF;
304: END IF;
305:
306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_statement, l_full_name,
308: 'i = '|| i ||
309: ', l_path_position_tbl(i).mc_id = ' || l_path_position_tbl(i).mc_id ||
310: ', l_path_position_tbl(i).mc_name = ' || l_path_position_tbl(i).mc_name ||
311: ', l_path_position_tbl(i).mc_revision = ' || l_path_position_tbl(i).mc_revision ||

Line 325: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

321:
322: -- return changed record
323: p_x_path_position_tbl := l_path_position_tbl;
324:
325: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
326: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
327: END IF;
328:
329: END Convert_Path_Pos_Values_to_Id;

Line 326: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');

322: -- return changed record
323: p_x_path_position_tbl := l_path_position_tbl;
324:
325: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
326: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
327: END IF;
328:
329: END Convert_Path_Pos_Values_to_Id;
330: