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_COMPLEX_MX_RWSC_PVT dependencies on FND_LOG

Line 121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

117: OPEN is_visit_present(p_visit_id);
118: FETCH is_visit_present INTO l_count_visit;
119: CLOSE is_visit_present;
120:
121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
123: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
124: 'Records having Visit id ' || p_visit_id || ': ' || l_count_visit);
125: END IF;

Line 122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

118: FETCH is_visit_present INTO l_count_visit;
119: CLOSE is_visit_present;
120:
121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
123: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
124: 'Records having Visit id ' || p_visit_id || ': ' || l_count_visit);
125: END IF;
126:

Line 133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

129: If the visit in context is same and user has selected another unit/instance, retain the values in the table
130: There will be records in table only for one visit
131: */
132: IF l_count_visit = 0 THEN
133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
135: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
136: 'Deleting all rows in ahl_visit_ir_uc_details');
137: END IF;

Line 134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

130: There will be records in table only for one visit
131: */
132: IF l_count_visit = 0 THEN
133: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
134: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
135: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
136: 'Deleting all rows in ahl_visit_ir_uc_details');
137: END IF;
138:

Line 142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

138:
139: -- even if table rows are zero it will not throw error.
140: DELETE FROM ahl_visit_ir_uc_details;
141:
142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
145: 'all rows in ahl_visit_ir_uc_details deleted');
146: END IF;

Line 143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

139: -- even if table rows are zero it will not throw error.
140: DELETE FROM ahl_visit_ir_uc_details;
141:
142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
144: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
145: 'all rows in ahl_visit_ir_uc_details deleted');
146: END IF;
147:

Line 154: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

150: OPEN is_inst_present(p_item_instance_id);
151: FETCH is_inst_present INTO l_count_instance;
152: CLOSE is_inst_present;
153:
154: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
156: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
157: 'Records having inst id ' || p_item_instance_id || ': ' || l_count_instance);
158: END IF;

Line 155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

151: FETCH is_inst_present INTO l_count_instance;
152: CLOSE is_inst_present;
153:
154: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
155: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
156: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
157: 'Records having inst id ' || p_item_instance_id || ': ' || l_count_instance);
158: END IF;
159:

Line 175: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

171: p_visit_id => p_visit_id,
172: x_instance_details_tbl => x_visit_ir_uc_details_tbl);
173: END IF;
174:
175: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
177: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
178: 'New row Count ' || x_visit_ir_uc_details_tbl.count);
179: END IF;

Line 176: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

172: x_instance_details_tbl => x_visit_ir_uc_details_tbl);
173: END IF;
174:
175: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
176: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
177: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
178: 'New row Count ' || x_visit_ir_uc_details_tbl.count);
179: END IF;
180:

Line 279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

275: );
276: END LOOP;
277: END IF;
278:
279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
281: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
282: 'Newly Inserted Rows' || x_visit_ir_uc_details_tbl.count);
283: END IF;

Line 280: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

276: END LOOP;
277: END IF;
278:
279: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
281: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
282: 'Newly Inserted Rows' || x_visit_ir_uc_details_tbl.count);
283: END IF;
284:

Line 288: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

284:
285: -- Update Build goal for Position
286: l_count := Get_Build_Goal_Per_For_Pos(p_item_instance_id);
287:
288: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
290: 'Update Done root build goal ' || l_count);
291: END IF;
292:

Line 289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

285: -- Update Build goal for Position
286: l_count := Get_Build_Goal_Per_For_Pos(p_item_instance_id);
287:
288: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
290: 'Update Done root build goal ' || l_count);
291: END IF;
292:
293: END IF; -- l_count_instance check if

Line 299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

295: OPEN get_record_count;
296: FETCH get_record_count INTO l_count;
297: CLOSE get_record_count;
298:
299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
301: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
302: 'Records in Table are ' || l_count);
303: END IF;

Line 300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

296: FETCH get_record_count INTO l_count;
297: CLOSE get_record_count;
298:
299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
300: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
301: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
302: 'Records in Table are ' || l_count);
303: END IF;
304:

Line 408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

404: IF FND_API.to_boolean( p_init_msg_list ) THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407:
408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
410: 'Rows Count ' || p_x_instance_routings_tbl.count);
411: END IF;
412:

Line 409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,

405: FND_MSG_PUB.initialize;
406: END IF;
407:
408: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
410: 'Rows Count ' || p_x_instance_routings_tbl.count);
411: END IF;
412:
413: IF p_x_instance_routings_tbl.FIRST IS NOT NULL THEN

Line 795: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

791: CLOSE get_max_pk_count;
792:
793: l_curr_row := 1;
794:
795: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
796: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
797: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
798: 'Value of current pk ' || l_curr_pk);
799: END IF;

Line 796: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

792:
793: l_curr_row := 1;
794:
795: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
796: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
797: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
798: 'Value of current pk ' || l_curr_pk);
799: END IF;
800:

Line 856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

852: -- PRAKKUM :: 27/03/2012 :: Bug# : 13488251 :: Fixed code to get parent instance id's unit name :: START
853: --unit NHA
854: --l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_uc_details_tbl(l_curr_row).curr_instance_id);
855: AHL_UTIL_UC_PKG.get_parent_uc_header(l_uc_details_tbl(l_curr_row).curr_instance_id, l_parent_uc_header_id, l_parent_uc_instance_id);
856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);
858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);
859: END IF;
860: IF l_parent_uc_header_id IS NOT NULL THEN

Line 857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);

853: --unit NHA
854: --l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_uc_details_tbl(l_curr_row).curr_instance_id);
855: AHL_UTIL_UC_PKG.get_parent_uc_header(l_uc_details_tbl(l_curr_row).curr_instance_id, l_parent_uc_header_id, l_parent_uc_instance_id);
856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);
858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);
859: END IF;
860: IF l_parent_uc_header_id IS NOT NULL THEN
861: l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_parent_uc_instance_id);

Line 858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);

854: --l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_uc_details_tbl(l_curr_row).curr_instance_id);
855: AHL_UTIL_UC_PKG.get_parent_uc_header(l_uc_details_tbl(l_curr_row).curr_instance_id, l_parent_uc_header_id, l_parent_uc_instance_id);
856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_header_id --@>'||l_parent_uc_header_id);
858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'l_parent_uc_instance_id --@>'||l_parent_uc_instance_id);
859: END IF;
860: IF l_parent_uc_header_id IS NOT NULL THEN
861: l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_parent_uc_instance_id);
862: ELSE

Line 865: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

861: l_uc_details_tbl(l_curr_row).unit_nha := AHL_UTIL_UC_PKG.get_sub_unit_name(l_parent_uc_instance_id);
862: ELSE
863: l_uc_details_tbl(l_curr_row).unit_nha := NULL;
864: END IF;
865: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_name --@>'||l_uc_details_tbl(l_curr_row).unit_name);
867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_nha --@>'||l_uc_details_tbl(l_curr_row).unit_nha);
868: END IF;
869: -- PRAKKUM :: 27/03/2012 :: Bug# : 13488251 :: Fixed code to get parent instance id's unit name :: END

Line 866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_name --@>'||l_uc_details_tbl(l_curr_row).unit_name);

862: ELSE
863: l_uc_details_tbl(l_curr_row).unit_nha := NULL;
864: END IF;
865: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_name --@>'||l_uc_details_tbl(l_curr_row).unit_name);
867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_nha --@>'||l_uc_details_tbl(l_curr_row).unit_nha);
868: END IF;
869: -- PRAKKUM :: 27/03/2012 :: Bug# : 13488251 :: Fixed code to get parent instance id's unit name :: END
870:

Line 867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_nha --@>'||l_uc_details_tbl(l_curr_row).unit_nha);

863: l_uc_details_tbl(l_curr_row).unit_nha := NULL;
864: END IF;
865: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_name --@>'||l_uc_details_tbl(l_curr_row).unit_name);
867: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'unit_nha --@>'||l_uc_details_tbl(l_curr_row).unit_nha);
868: END IF;
869: -- PRAKKUM :: 27/03/2012 :: Bug# : 13488251 :: Fixed code to get parent instance id's unit name :: END
870:
871: -- If it is same as unit_name then leave it as blank

Line 977: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

973: END LOOP;
974: END IF;
975:
976:
977: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
979: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
980: 'Done fetching details');
981: END IF;

Line 978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

974: END IF;
975:
976:
977: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
979: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
980: 'Done fetching details');
981: END IF;
982:

Line 1131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1127: ELSE
1128: l_inst_details_tbl(l_curr_row).inst_routing_flag := 'F';
1129: END IF;
1130:
1131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1134: 'Done fetching details');
1135: END IF;

Line 1132: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1128: l_inst_details_tbl(l_curr_row).inst_routing_flag := 'F';
1129: END IF;
1130:
1131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1133: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
1134: 'Done fetching details');
1135: END IF;
1136:

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

1180:
1181: -- Initialize API return status to success
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1185: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin',
1186: 'Create_Instance_Routing. visit id = '||p_visit_id||
1187: 'Item Instance id = '||p_item_instance_id||
1188: 'Inst routing code = '||p_inst_routing_code

Line 1185: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin',

1181: -- Initialize API return status to success
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1185: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': Begin',
1186: 'Create_Instance_Routing. visit id = '||p_visit_id||
1187: 'Item Instance id = '||p_item_instance_id||
1188: 'Inst routing code = '||p_inst_routing_code
1189: );

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

1252:
1253: -- populate the OUT parameter
1254: x_inst_routing_id := l_inst_routing_id;
1255:
1256: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1257: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1258: 'Create_Instance_Routing, x_return_status=' || x_return_status);
1259: END IF;
1260: END Create_Instance_Routing;

Line 1257: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',

1253: -- populate the OUT parameter
1254: x_inst_routing_id := l_inst_routing_id;
1255:
1256: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1257: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1258: 'Create_Instance_Routing, x_return_status=' || x_return_status);
1259: END IF;
1260: END Create_Instance_Routing;
1261:

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

1291: l_inst_routings_rec validate_routing_csr%ROWTYPE;
1292:
1293: BEGIN
1294:
1295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1296: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name|| '.begin',
1297: 'Update_Instance_Routing. instance routing id = ' || p_inst_routing_id||
1298: 'inst_routing_code = ' || p_inst_routing_code
1299: );

Line 1296: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name|| '.begin',

1292:
1293: BEGIN
1294:
1295: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1296: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name|| '.begin',
1297: 'Update_Instance_Routing. instance routing id = ' || p_inst_routing_id||
1298: 'inst_routing_code = ' || p_inst_routing_code
1299: );
1300: END IF;

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

1317: CLOSE validate_routing_csr;
1318:
1319: -- check for object_version_number
1320: IF(p_object_version_number <> l_inst_routings_rec.object_version_number) THEN
1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1322: FND_LOG.string(FND_LOG.level_statement, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'object_version_number mismatch');
1323: END IF;
1324: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED'); -- Record has been modified by another user.
1325: FND_MSG_PUB.ADD;

Line 1322: FND_LOG.string(FND_LOG.level_statement, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'object_version_number mismatch');

1318:
1319: -- check for object_version_number
1320: IF(p_object_version_number <> l_inst_routings_rec.object_version_number) THEN
1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1322: FND_LOG.string(FND_LOG.level_statement, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name, 'object_version_number mismatch');
1323: END IF;
1324: FND_MESSAGE.Set_Name('AHL', 'AHL_COM_RECORD_CHANGED'); -- Record has been modified by another user.
1325: FND_MSG_PUB.ADD;
1326:

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

1337: last_updated_by = Fnd_Global.USER_ID,
1338: last_update_login = Fnd_Global.LOGIN_ID
1339: WHERE inst_routing_id = p_inst_routing_id;
1340:
1341: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1342: fnd_log.string(FND_LOG.level_procedure,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1343: 'Update_Instance_Routing, x_return_status=' || x_return_status);
1344: END IF;
1345: END Update_Instance_Routing;

Line 1342: fnd_log.string(FND_LOG.level_procedure,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',

1338: last_update_login = Fnd_Global.LOGIN_ID
1339: WHERE inst_routing_id = p_inst_routing_id;
1340:
1341: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1342: fnd_log.string(FND_LOG.level_procedure,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1343: 'Update_Instance_Routing, x_return_status=' || x_return_status);
1344: END IF;
1345: END Update_Instance_Routing;
1346:

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

1369: WHERE inst_routing_id = c_inst_routing_id;
1370: l_inst_routings_rec validate_routing_csr%ROWTYPE;
1371:
1372: BEGIN
1373: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1374: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin', 'Entering Procedure');
1375: END IF;
1376:
1377: -- Initialize API return status to success

Line 1374: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin', 'Entering Procedure');

1370: l_inst_routings_rec validate_routing_csr%ROWTYPE;
1371:
1372: BEGIN
1373: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1374: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.begin', 'Entering Procedure');
1375: END IF;
1376:
1377: -- Initialize API return status to success
1378: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1394: -- delete row
1395: DELETE FROM AHL_VISIT_INST_ROUTINGS
1396: WHERE inst_routing_id = p_inst_routing_id;
1397:
1398: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1399: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1400: ' x_return_status=' || x_return_status);
1401: END IF;
1402: END Delete_Instance_Routing;

Line 1399: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',

1395: DELETE FROM AHL_VISIT_INST_ROUTINGS
1396: WHERE inst_routing_id = p_inst_routing_id;
1397:
1398: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1399: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',
1400: ' x_return_status=' || x_return_status);
1401: END IF;
1402: END Delete_Instance_Routing;
1403: