APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on FND_LOG

Line 51: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

47:
48: -- yazhou 24Aug2005 starts
49: -- Resource Leveling Re-design
50:
51: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
52: l_log_statement NUMBER := fnd_log.level_statement;
53: l_log_procedure NUMBER := fnd_log.level_procedure;
54: l_log_error NUMBER := fnd_log.level_error;
55: l_log_unexpected NUMBER := fnd_log.level_unexpected;

Line 52: l_log_statement NUMBER := fnd_log.level_statement;

48: -- yazhou 24Aug2005 starts
49: -- Resource Leveling Re-design
50:
51: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
52: l_log_statement NUMBER := fnd_log.level_statement;
53: l_log_procedure NUMBER := fnd_log.level_procedure;
54: l_log_error NUMBER := fnd_log.level_error;
55: l_log_unexpected NUMBER := fnd_log.level_unexpected;
56:

Line 53: l_log_procedure NUMBER := fnd_log.level_procedure;

49: -- Resource Leveling Re-design
50:
51: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
52: l_log_statement NUMBER := fnd_log.level_statement;
53: l_log_procedure NUMBER := fnd_log.level_procedure;
54: l_log_error NUMBER := fnd_log.level_error;
55: l_log_unexpected NUMBER := fnd_log.level_unexpected;
56:
57: -- Record of Operation Details

Line 54: l_log_error NUMBER := fnd_log.level_error;

50:
51: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
52: l_log_statement NUMBER := fnd_log.level_statement;
53: l_log_procedure NUMBER := fnd_log.level_procedure;
54: l_log_error NUMBER := fnd_log.level_error;
55: l_log_unexpected NUMBER := fnd_log.level_unexpected;
56:
57: -- Record of Operation Details
58: TYPE Time_Period_Details_Rec_Type IS RECORD (

Line 55: l_log_unexpected NUMBER := fnd_log.level_unexpected;

51: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
52: l_log_statement NUMBER := fnd_log.level_statement;
53: l_log_procedure NUMBER := fnd_log.level_procedure;
54: l_log_error NUMBER := fnd_log.level_error;
55: l_log_unexpected NUMBER := fnd_log.level_unexpected;
56:
57: -- Record of Operation Details
58: TYPE Time_Period_Details_Rec_Type IS RECORD (
59: VISIT_ID NUMBER := NULL, -- Visit Id

Line 959: fnd_log.string

955: -- Resource Leveling Re-design
956: -- Added Organization, start and end date mandatory check
957:
958: IF (l_log_statement >= l_log_current_level) THEN
959: fnd_log.string
960: (
961: fnd_log.level_statement,
962: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
963: 'p_plan_id:'||p_plan_id

Line 961: fnd_log.level_statement,

957:
958: IF (l_log_statement >= l_log_current_level) THEN
959: fnd_log.string
960: (
961: fnd_log.level_statement,
962: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
963: 'p_plan_id:'||p_plan_id
964: );
965: fnd_log.string

Line 965: fnd_log.string

961: fnd_log.level_statement,
962: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
963: 'p_plan_id:'||p_plan_id
964: );
965: fnd_log.string
966: (
967: fnd_log.level_statement,
968: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
969: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')

Line 967: fnd_log.level_statement,

963: 'p_plan_id:'||p_plan_id
964: );
965: fnd_log.string
966: (
967: fnd_log.level_statement,
968: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
969: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
970: );
971: fnd_log.string

Line 971: fnd_log.string

967: fnd_log.level_statement,
968: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
969: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
970: );
971: fnd_log.string
972: (
973: fnd_log.level_statement,
974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
975: 'p_end_time:'||TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')

Line 973: fnd_log.level_statement,

969: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
970: );
971: fnd_log.string
972: (
973: fnd_log.level_statement,
974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
975: 'p_end_time:'||TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')
976: );
977: fnd_log.string

Line 977: fnd_log.string

973: fnd_log.level_statement,
974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
975: 'p_end_time:'||TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')
976: );
977: fnd_log.string
978: (
979: fnd_log.level_statement,
980: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
981: 'p_UOM_code:'||p_UOM_code

Line 979: fnd_log.level_statement,

975: 'p_end_time:'||TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')
976: );
977: fnd_log.string
978: (
979: fnd_log.level_statement,
980: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
981: 'p_UOM_code:'||p_UOM_code
982: );
983: fnd_log.string

Line 983: fnd_log.string

979: fnd_log.level_statement,
980: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
981: 'p_UOM_code:'||p_UOM_code
982: );
983: fnd_log.string
984: (
985: fnd_log.level_statement,
986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
987: 'p_org_name:'||p_org_name

Line 985: fnd_log.level_statement,

981: 'p_UOM_code:'||p_UOM_code
982: );
983: fnd_log.string
984: (
985: fnd_log.level_statement,
986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
987: 'p_org_name:'||p_org_name
988: );
989: fnd_log.string

Line 989: fnd_log.string

985: fnd_log.level_statement,
986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
987: 'p_org_name:'||p_org_name
988: );
989: fnd_log.string
990: (
991: fnd_log.level_statement,
992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
993: 'p_dept_name:'||p_dept_name

Line 991: fnd_log.level_statement,

987: 'p_org_name:'||p_org_name
988: );
989: fnd_log.string
990: (
991: fnd_log.level_statement,
992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
993: 'p_dept_name:'||p_dept_name
994: );
995: fnd_log.string

Line 995: fnd_log.string

991: fnd_log.level_statement,
992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
993: 'p_dept_name:'||p_dept_name
994: );
995: fnd_log.string
996: (
997: fnd_log.level_statement,
998: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
999: 'p_required_capacity:'||p_required_capacity

Line 997: fnd_log.level_statement,

993: 'p_dept_name:'||p_dept_name
994: );
995: fnd_log.string
996: (
997: fnd_log.level_statement,
998: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
999: 'p_required_capacity:'||p_required_capacity
1000: );
1001: END IF;

Line 1135: fnd_log.string

1131: l_department_name := var.dept_name;
1132: -- yazhou 24Aug2005 ends
1133:
1134: IF (l_log_statement >= l_log_current_level) THEN
1135: fnd_log.string
1136: (
1137: fnd_log.level_statement,
1138: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1139: 'l_org_id:'||l_org_id

Line 1137: fnd_log.level_statement,

1133:
1134: IF (l_log_statement >= l_log_current_level) THEN
1135: fnd_log.string
1136: (
1137: fnd_log.level_statement,
1138: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1139: 'l_org_id:'||l_org_id
1140: );
1141: fnd_log.string

Line 1141: fnd_log.string

1137: fnd_log.level_statement,
1138: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1139: 'l_org_id:'||l_org_id
1140: );
1141: fnd_log.string
1142: (
1143: fnd_log.level_statement,
1144: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1145: 'l_dept_id:'||l_dept_id

Line 1143: fnd_log.level_statement,

1139: 'l_org_id:'||l_org_id
1140: );
1141: fnd_log.string
1142: (
1143: fnd_log.level_statement,
1144: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1145: 'l_dept_id:'||l_dept_id
1146: );
1147: fnd_log.string

Line 1147: fnd_log.string

1143: fnd_log.level_statement,
1144: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1145: 'l_dept_id:'||l_dept_id
1146: );
1147: fnd_log.string
1148: (
1149: fnd_log.level_statement,
1150: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1151: 'l_department_name:'||l_department_name

Line 1149: fnd_log.level_statement,

1145: 'l_dept_id:'||l_dept_id
1146: );
1147: fnd_log.string
1148: (
1149: fnd_log.level_statement,
1150: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1151: 'l_department_name:'||l_department_name
1152: );
1153: END IF;

Line 1173: fnd_log.string

1169: x_tp_dtls_tbl => l_tp_dtls_table, -- Table for Operation Time Period details
1170: x_visit_task_times_tbl => l_task_times_tbl);
1171:
1172: IF (l_log_statement >= l_log_current_level) THEN
1173: fnd_log.string
1174: (
1175: fnd_log.level_statement,
1176: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1177: 'After calling Get_Plan_Tasks'

Line 1175: fnd_log.level_statement,

1171:
1172: IF (l_log_statement >= l_log_current_level) THEN
1173: fnd_log.string
1174: (
1175: fnd_log.level_statement,
1176: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1177: 'After calling Get_Plan_Tasks'
1178: );
1179: fnd_log.string

Line 1179: fnd_log.string

1175: fnd_log.level_statement,
1176: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1177: 'After calling Get_Plan_Tasks'
1178: );
1179: fnd_log.string
1180: (
1181: fnd_log.level_statement,
1182: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1183: 'l_tp_dtls_table.COUNT:'||l_tp_dtls_table.COUNT

Line 1181: fnd_log.level_statement,

1177: 'After calling Get_Plan_Tasks'
1178: );
1179: fnd_log.string
1180: (
1181: fnd_log.level_statement,
1182: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1183: 'l_tp_dtls_table.COUNT:'||l_tp_dtls_table.COUNT
1184: );
1185: fnd_log.string

Line 1185: fnd_log.string

1181: fnd_log.level_statement,
1182: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1183: 'l_tp_dtls_table.COUNT:'||l_tp_dtls_table.COUNT
1184: );
1185: fnd_log.string
1186: (
1187: fnd_log.level_statement,
1188: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1189: 'l_task_times_tbl.COUNT:'||l_task_times_tbl.COUNT

Line 1187: fnd_log.level_statement,

1183: 'l_tp_dtls_table.COUNT:'||l_tp_dtls_table.COUNT
1184: );
1185: fnd_log.string
1186: (
1187: fnd_log.level_statement,
1188: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1189: 'l_task_times_tbl.COUNT:'||l_task_times_tbl.COUNT
1190: );
1191: END IF;

Line 1207: fnd_log.string

1203: p_dept_id => l_dept_id,
1204: x_per_rsrc_tbl => l_per_rsrc_tbl);
1205:
1206: IF (l_log_statement >= l_log_current_level) THEN
1207: fnd_log.string
1208: (
1209: fnd_log.level_statement,
1210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1211: 'After calling Create_Time_Periods'

Line 1209: fnd_log.level_statement,

1205:
1206: IF (l_log_statement >= l_log_current_level) THEN
1207: fnd_log.string
1208: (
1209: fnd_log.level_statement,
1210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1211: 'After calling Create_Time_Periods'
1212: );
1213: fnd_log.string

Line 1213: fnd_log.string

1209: fnd_log.level_statement,
1210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1211: 'After calling Create_Time_Periods'
1212: );
1213: fnd_log.string
1214: (
1215: fnd_log.level_statement,
1216: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1217: 'l_per_rsrc_tbl.COUNT:'||l_per_rsrc_tbl.COUNT

Line 1215: fnd_log.level_statement,

1211: 'After calling Create_Time_Periods'
1212: );
1213: fnd_log.string
1214: (
1215: fnd_log.level_statement,
1216: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1217: 'l_per_rsrc_tbl.COUNT:'||l_per_rsrc_tbl.COUNT
1218: );
1219: END IF;

Line 1232: fnd_log.string

1228:
1229: l_tp_dtls_table_dept := l_tp_dtls_table;
1230:
1231: IF (l_log_statement >= l_log_current_level) THEN
1232: fnd_log.string
1233: (
1234: fnd_log.level_statement,
1235: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1236: 'l_per_rsrc_tbl('||i||').period_start:'||TO_CHAR( l_period_start_time, 'DD-MON-YYYY hh24:mi')

Line 1234: fnd_log.level_statement,

1230:
1231: IF (l_log_statement >= l_log_current_level) THEN
1232: fnd_log.string
1233: (
1234: fnd_log.level_statement,
1235: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1236: 'l_per_rsrc_tbl('||i||').period_start:'||TO_CHAR( l_period_start_time, 'DD-MON-YYYY hh24:mi')
1237: );
1238: fnd_log.string

Line 1238: fnd_log.string

1234: fnd_log.level_statement,
1235: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1236: 'l_per_rsrc_tbl('||i||').period_start:'||TO_CHAR( l_period_start_time, 'DD-MON-YYYY hh24:mi')
1237: );
1238: fnd_log.string
1239: (
1240: fnd_log.level_statement,
1241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1242: 'l_per_rsrc_tbl('||i||').period_end:'||TO_CHAR( l_period_end_time, 'DD-MON-YYYY hh24:mi')

Line 1240: fnd_log.level_statement,

1236: 'l_per_rsrc_tbl('||i||').period_start:'||TO_CHAR( l_period_start_time, 'DD-MON-YYYY hh24:mi')
1237: );
1238: fnd_log.string
1239: (
1240: fnd_log.level_statement,
1241: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1242: 'l_per_rsrc_tbl('||i||').period_end:'||TO_CHAR( l_period_end_time, 'DD-MON-YYYY hh24:mi')
1243: );
1244: END IF;

Line 1256: fnd_log.string

1252: p_tp_dtls_tbl => l_tp_dtls_table_dept,
1253: x_resources_tbl => l_resc_tbl);
1254:
1255: IF (l_log_statement >= l_log_current_level) THEN
1256: fnd_log.string
1257: (
1258: fnd_log.level_statement,
1259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1260: 'After calling Get_Used_Resources'

Line 1258: fnd_log.level_statement,

1254:
1255: IF (l_log_statement >= l_log_current_level) THEN
1256: fnd_log.string
1257: (
1258: fnd_log.level_statement,
1259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1260: 'After calling Get_Used_Resources'
1261: );
1262: fnd_log.string

Line 1262: fnd_log.string

1258: fnd_log.level_statement,
1259: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1260: 'After calling Get_Used_Resources'
1261: );
1262: fnd_log.string
1263: (
1264: fnd_log.level_statement,
1265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1266: 'l_resc_tbl.COUNT:'||l_resc_tbl.COUNT

Line 1264: fnd_log.level_statement,

1260: 'After calling Get_Used_Resources'
1261: );
1262: fnd_log.string
1263: (
1264: fnd_log.level_statement,
1265: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1266: 'l_resc_tbl.COUNT:'||l_resc_tbl.COUNT
1267: );
1268: END IF;

Line 1277: fnd_log.string

1273:
1274: l_tp_dtls_table_resc := l_tp_dtls_table_dept;
1275:
1276: IF (l_log_statement >= l_log_current_level) THEN
1277: fnd_log.string
1278: (
1279: fnd_log.level_statement,
1280: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1281: 'l_resc_tbl('||j||'):' || l_resc_tbl(j)

Line 1279: fnd_log.level_statement,

1275:
1276: IF (l_log_statement >= l_log_current_level) THEN
1277: fnd_log.string
1278: (
1279: fnd_log.level_statement,
1280: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1281: 'l_resc_tbl('||j||'):' || l_resc_tbl(j)
1282: );
1283: END IF;

Line 1294: fnd_log.string

1290: p_end_time =>l_period_end_time,
1291: p_x_tp_dtls_tbl =>l_tp_dtls_table_resc);
1292:
1293: IF (l_log_statement >= l_log_current_level) THEN
1294: fnd_log.string
1295: (
1296: fnd_log.level_statement,
1297: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1298: 'After Calling Filter_By_Resource'

Line 1296: fnd_log.level_statement,

1292:
1293: IF (l_log_statement >= l_log_current_level) THEN
1294: fnd_log.string
1295: (
1296: fnd_log.level_statement,
1297: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1298: 'After Calling Filter_By_Resource'
1299: );
1300: fnd_log.string

Line 1300: fnd_log.string

1296: fnd_log.level_statement,
1297: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1298: 'After Calling Filter_By_Resource'
1299: );
1300: fnd_log.string
1301: (
1302: fnd_log.level_statement,
1303: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1304: 'l_tp_dtls_table_resc.count: ' ||l_tp_dtls_table_resc.count

Line 1302: fnd_log.level_statement,

1298: 'After Calling Filter_By_Resource'
1299: );
1300: fnd_log.string
1301: (
1302: fnd_log.level_statement,
1303: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1304: 'l_tp_dtls_table_resc.count: ' ||l_tp_dtls_table_resc.count
1305: );
1306: END IF;

Line 1321: fnd_log.string

1317: p_resource_id => l_resc_tbl(j),
1318: p_x_tp_dtls_tbl => l_tp_dtls_table_resc);
1319:
1320: IF (l_log_statement >= l_log_current_level) THEN
1321: fnd_log.string
1322: (
1323: fnd_log.level_statement,
1324: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1325: 'After Calling Append_WIP_Requirements'

Line 1323: fnd_log.level_statement,

1319:
1320: IF (l_log_statement >= l_log_current_level) THEN
1321: fnd_log.string
1322: (
1323: fnd_log.level_statement,
1324: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1325: 'After Calling Append_WIP_Requirements'
1326: );
1327: fnd_log.string

Line 1327: fnd_log.string

1323: fnd_log.level_statement,
1324: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1325: 'After Calling Append_WIP_Requirements'
1326: );
1327: fnd_log.string
1328: (
1329: fnd_log.level_statement,
1330: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1331: 'l_tp_dtls_table_resc.count: ' ||l_tp_dtls_table_resc.count

Line 1329: fnd_log.level_statement,

1325: 'After Calling Append_WIP_Requirements'
1326: );
1327: fnd_log.string
1328: (
1329: fnd_log.level_statement,
1330: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1331: 'l_tp_dtls_table_resc.count: ' ||l_tp_dtls_table_resc.count
1332: );
1333: END IF;

Line 1341: fnd_log.string

1337: p_end_time =>l_period_end_time,
1338: p_tp_dtls_tbl =>l_tp_dtls_table_resc);
1339:
1340: IF (l_log_statement >= l_log_current_level) THEN
1341: fnd_log.string
1342: (
1343: fnd_log.level_statement,
1344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1345: 'l_required_quantity:'||l_required_quantity

Line 1343: fnd_log.level_statement,

1339:
1340: IF (l_log_statement >= l_log_current_level) THEN
1341: fnd_log.string
1342: (
1343: fnd_log.level_statement,
1344: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1345: 'l_required_quantity:'||l_required_quantity
1346: );
1347: END IF;

Line 1354: fnd_log.string

1350: p_resource_id =>l_resc_tbl(j),
1351: p_dept_id =>l_dept_id);
1352:
1353: IF (l_log_statement >= l_log_current_level) THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_statement,
1357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1358: 'l_available_quantity:'||l_available_quantity

Line 1356: fnd_log.level_statement,

1352:
1353: IF (l_log_statement >= l_log_current_level) THEN
1354: fnd_log.string
1355: (
1356: fnd_log.level_statement,
1357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1358: 'l_available_quantity:'||l_available_quantity
1359: );
1360: END IF;

Line 1367: fnd_log.string

1363:
1364: l_unused_capacity := (1-(l_required_quantity/l_available_quantity))*100;
1365:
1366: IF (l_log_statement >= l_log_current_level) THEN
1367: fnd_log.string
1368: (
1369: fnd_log.level_statement,
1370: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1371: 'l_unused_capacity:'||l_unused_capacity

Line 1369: fnd_log.level_statement,

1365:
1366: IF (l_log_statement >= l_log_current_level) THEN
1367: fnd_log.string
1368: (
1369: fnd_log.level_statement,
1370: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1371: 'l_unused_capacity:'||l_unused_capacity
1372: );
1373: END IF;

Line 1400: fnd_log.string

1396:
1397: l_idx := l_idx +1;
1398:
1399: IF (l_log_statement >= l_log_current_level) THEN
1400: fnd_log.string
1401: (
1402: fnd_log.level_statement,
1403: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1404: 'l_idx:'||l_idx

Line 1402: fnd_log.level_statement,

1398:
1399: IF (l_log_statement >= l_log_current_level) THEN
1400: fnd_log.string
1401: (
1402: fnd_log.level_statement,
1403: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1404: 'l_idx:'||l_idx
1405: );
1406: END IF;

Line 1855: fnd_log.string

1851:
1852: BEGIN
1853:
1854: IF (l_log_statement >= l_log_current_level) THEN
1855: fnd_log.string
1856: (
1857: fnd_log.level_statement,
1858: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1859: 'p_start_time:'||p_start_time

Line 1857: fnd_log.level_statement,

1853:
1854: IF (l_log_statement >= l_log_current_level) THEN
1855: fnd_log.string
1856: (
1857: fnd_log.level_statement,
1858: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1859: 'p_start_time:'||p_start_time
1860: );
1861: fnd_log.string

Line 1861: fnd_log.string

1857: fnd_log.level_statement,
1858: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1859: 'p_start_time:'||p_start_time
1860: );
1861: fnd_log.string
1862: (
1863: fnd_log.level_statement,
1864: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1865: 'l_end_time:'||l_end_time

Line 1863: fnd_log.level_statement,

1859: 'p_start_time:'||p_start_time
1860: );
1861: fnd_log.string
1862: (
1863: fnd_log.level_statement,
1864: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1865: 'l_end_time:'||l_end_time
1866: );
1867: fnd_log.string

Line 1867: fnd_log.string

1863: fnd_log.level_statement,
1864: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1865: 'l_end_time:'||l_end_time
1866: );
1867: fnd_log.string
1868: (
1869: fnd_log.level_statement,
1870: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1871: 'p_dept_id:'||p_dept_id

Line 1869: fnd_log.level_statement,

1865: 'l_end_time:'||l_end_time
1866: );
1867: fnd_log.string
1868: (
1869: fnd_log.level_statement,
1870: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1871: 'p_dept_id:'||p_dept_id
1872: );
1873:

Line 1882: fnd_log.string

1878: FETCH l_get_plan_visits INTO l_temp_visit;
1879: EXIT WHEN l_get_plan_visits%NOTFOUND;
1880:
1881: IF (l_log_statement >= l_log_current_level) THEN
1882: fnd_log.string
1883: (
1884: fnd_log.level_statement,
1885: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1886: 'l_temp_visit:'||l_temp_visit

Line 1884: fnd_log.level_statement,

1880:
1881: IF (l_log_statement >= l_log_current_level) THEN
1882: fnd_log.string
1883: (
1884: fnd_log.level_statement,
1885: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1886: 'l_temp_visit:'||l_temp_visit
1887: );
1888: END IF;

Line 1909: fnd_log.string

1905: x_visit_end_hour => l_temp_num1,
1906: x_visit_task_times_tbl => l_final_times_tbl);
1907:
1908: IF (l_log_statement >= l_log_current_level) THEN
1909: fnd_log.string
1910: (
1911: fnd_log.level_statement,
1912: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1913: 'After calling Derive_Task_Op_Times'

Line 1911: fnd_log.level_statement,

1907:
1908: IF (l_log_statement >= l_log_current_level) THEN
1909: fnd_log.string
1910: (
1911: fnd_log.level_statement,
1912: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1913: 'After calling Derive_Task_Op_Times'
1914: );
1915: fnd_log.string

Line 1915: fnd_log.string

1911: fnd_log.level_statement,
1912: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1913: 'After calling Derive_Task_Op_Times'
1914: );
1915: fnd_log.string
1916: (
1917: fnd_log.level_statement,
1918: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1919: 'l_final_times_tbl.count: '|| l_final_times_tbl.count

Line 1917: fnd_log.level_statement,

1913: 'After calling Derive_Task_Op_Times'
1914: );
1915: fnd_log.string
1916: (
1917: fnd_log.level_statement,
1918: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1919: 'l_final_times_tbl.count: '|| l_final_times_tbl.count
1920: );
1921: END IF;

Line 1955: fnd_log.string

1951: FETCH l_get_plan_type_csr INTO l_plan_type;
1952: CLOSE l_get_plan_type_csr;
1953:
1954: IF (l_log_statement >= l_log_current_level) THEN
1955: fnd_log.string
1956: (
1957: fnd_log.level_statement,
1958: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1959: 'l_plan_type: '|| l_plan_type

Line 1957: fnd_log.level_statement,

1953:
1954: IF (l_log_statement >= l_log_current_level) THEN
1955: fnd_log.string
1956: (
1957: fnd_log.level_statement,
1958: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1959: 'l_plan_type: '|| l_plan_type
1960: );
1961: END IF;

Line 1971: fnd_log.string

1967: FETCH l_get_primary_visits INTO l_temp_visit;
1968: EXIT WHEN l_get_primary_visits%NOTFOUND;
1969:
1970: IF (l_log_statement >= l_log_current_level) THEN
1971: fnd_log.string
1972: (
1973: fnd_log.level_statement,
1974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1975: 'l_temp_visit:'||l_temp_visit

Line 1973: fnd_log.level_statement,

1969:
1970: IF (l_log_statement >= l_log_current_level) THEN
1971: fnd_log.string
1972: (
1973: fnd_log.level_statement,
1974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1975: 'l_temp_visit:'||l_temp_visit
1976: );
1977: END IF;

Line 1992: fnd_log.string

1988: x_visit_end_hour => l_temp_num1,
1989: x_visit_task_times_tbl => l_temp_times_tbl);
1990:
1991: IF (l_log_statement >= l_log_current_level) THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement,
1995: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1996: 'After calling Derive_Task_Op_Times'

Line 1994: fnd_log.level_statement,

1990:
1991: IF (l_log_statement >= l_log_current_level) THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement,
1995: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1996: 'After calling Derive_Task_Op_Times'
1997: );
1998: fnd_log.string

Line 1998: fnd_log.string

1994: fnd_log.level_statement,
1995: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1996: 'After calling Derive_Task_Op_Times'
1997: );
1998: fnd_log.string
1999: (
2000: fnd_log.level_statement,
2001: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2002: 'l_temp_times_tbl.count: '|| l_temp_times_tbl.count

Line 2000: fnd_log.level_statement,

1996: 'After calling Derive_Task_Op_Times'
1997: );
1998: fnd_log.string
1999: (
2000: fnd_log.level_statement,
2001: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2002: 'l_temp_times_tbl.count: '|| l_temp_times_tbl.count
2003: );
2004: END IF;

Line 2041: fnd_log.string

2037:
2038: x_visit_task_times_tbl := l_final_times_tbl;
2039:
2040: IF (l_log_statement >= l_log_current_level) THEN
2041: fnd_log.string
2042: (
2043: fnd_log.level_statement,
2044: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2045: 'x_visit_task_times_tbl.count: '|| x_visit_task_times_tbl.count

Line 2043: fnd_log.level_statement,

2039:
2040: IF (l_log_statement >= l_log_current_level) THEN
2041: fnd_log.string
2042: (
2043: fnd_log.level_statement,
2044: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2045: 'x_visit_task_times_tbl.count: '|| x_visit_task_times_tbl.count
2046: );
2047: END IF;

Line 2067: fnd_log.string

2063: FOR i IN x_tp_dtls_tbl.FIRST..x_tp_dtls_tbl.LAST
2064: LOOP
2065:
2066: IF (l_log_statement >= l_log_current_level) THEN
2067: fnd_log.string
2068: (
2069: fnd_log.level_statement,
2070: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2071: 'x_tp_dtls_tbl('||i||').visit_id: '|| x_tp_dtls_tbl(i).visit_id

Line 2069: fnd_log.level_statement,

2065:
2066: IF (l_log_statement >= l_log_current_level) THEN
2067: fnd_log.string
2068: (
2069: fnd_log.level_statement,
2070: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2071: 'x_tp_dtls_tbl('||i||').visit_id: '|| x_tp_dtls_tbl(i).visit_id
2072: );
2073: fnd_log.string

Line 2073: fnd_log.string

2069: fnd_log.level_statement,
2070: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2071: 'x_tp_dtls_tbl('||i||').visit_id: '|| x_tp_dtls_tbl(i).visit_id
2072: );
2073: fnd_log.string
2074: (
2075: fnd_log.level_statement,
2076: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2077: 'x_tp_dtls_tbl('||i||').route_id: '|| x_tp_dtls_tbl(i).route_id

Line 2075: fnd_log.level_statement,

2071: 'x_tp_dtls_tbl('||i||').visit_id: '|| x_tp_dtls_tbl(i).visit_id
2072: );
2073: fnd_log.string
2074: (
2075: fnd_log.level_statement,
2076: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2077: 'x_tp_dtls_tbl('||i||').route_id: '|| x_tp_dtls_tbl(i).route_id
2078: );
2079: fnd_log.string

Line 2079: fnd_log.string

2075: fnd_log.level_statement,
2076: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2077: 'x_tp_dtls_tbl('||i||').route_id: '|| x_tp_dtls_tbl(i).route_id
2078: );
2079: fnd_log.string
2080: (
2081: fnd_log.level_statement,
2082: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2083: 'x_tp_dtls_tbl('||i||').mr_route_id: '|| x_tp_dtls_tbl(i).mr_route_id

Line 2081: fnd_log.level_statement,

2077: 'x_tp_dtls_tbl('||i||').route_id: '|| x_tp_dtls_tbl(i).route_id
2078: );
2079: fnd_log.string
2080: (
2081: fnd_log.level_statement,
2082: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2083: 'x_tp_dtls_tbl('||i||').mr_route_id: '|| x_tp_dtls_tbl(i).mr_route_id
2084: );
2085: fnd_log.string

Line 2085: fnd_log.string

2081: fnd_log.level_statement,
2082: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2083: 'x_tp_dtls_tbl('||i||').mr_route_id: '|| x_tp_dtls_tbl(i).mr_route_id
2084: );
2085: fnd_log.string
2086: (
2087: fnd_log.level_statement,
2088: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2089: 'x_tp_dtls_tbl('||i||').operation_id: '|| x_tp_dtls_tbl(i).operation_id

Line 2087: fnd_log.level_statement,

2083: 'x_tp_dtls_tbl('||i||').mr_route_id: '|| x_tp_dtls_tbl(i).mr_route_id
2084: );
2085: fnd_log.string
2086: (
2087: fnd_log.level_statement,
2088: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2089: 'x_tp_dtls_tbl('||i||').operation_id: '|| x_tp_dtls_tbl(i).operation_id
2090: );
2091: fnd_log.string

Line 2091: fnd_log.string

2087: fnd_log.level_statement,
2088: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2089: 'x_tp_dtls_tbl('||i||').operation_id: '|| x_tp_dtls_tbl(i).operation_id
2090: );
2091: fnd_log.string
2092: (
2093: fnd_log.level_statement,
2094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2095: 'x_tp_dtls_tbl('||i||').task_id: '|| x_tp_dtls_tbl(i).task_id

Line 2093: fnd_log.level_statement,

2089: 'x_tp_dtls_tbl('||i||').operation_id: '|| x_tp_dtls_tbl(i).operation_id
2090: );
2091: fnd_log.string
2092: (
2093: fnd_log.level_statement,
2094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2095: 'x_tp_dtls_tbl('||i||').task_id: '|| x_tp_dtls_tbl(i).task_id
2096: );
2097: fnd_log.string

Line 2097: fnd_log.string

2093: fnd_log.level_statement,
2094: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2095: 'x_tp_dtls_tbl('||i||').task_id: '|| x_tp_dtls_tbl(i).task_id
2096: );
2097: fnd_log.string
2098: (
2099: fnd_log.level_statement,
2100: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2101: 'x_tp_dtls_tbl('||i||').start_time: '|| x_tp_dtls_tbl(i).start_time

Line 2099: fnd_log.level_statement,

2095: 'x_tp_dtls_tbl('||i||').task_id: '|| x_tp_dtls_tbl(i).task_id
2096: );
2097: fnd_log.string
2098: (
2099: fnd_log.level_statement,
2100: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2101: 'x_tp_dtls_tbl('||i||').start_time: '|| x_tp_dtls_tbl(i).start_time
2102: );
2103: fnd_log.string

Line 2103: fnd_log.string

2099: fnd_log.level_statement,
2100: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2101: 'x_tp_dtls_tbl('||i||').start_time: '|| x_tp_dtls_tbl(i).start_time
2102: );
2103: fnd_log.string
2104: (
2105: fnd_log.level_statement,
2106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2107: 'x_tp_dtls_tbl('||i||').end_time: '|| x_tp_dtls_tbl(i).end_time

Line 2105: fnd_log.level_statement,

2101: 'x_tp_dtls_tbl('||i||').start_time: '|| x_tp_dtls_tbl(i).start_time
2102: );
2103: fnd_log.string
2104: (
2105: fnd_log.level_statement,
2106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2107: 'x_tp_dtls_tbl('||i||').end_time: '|| x_tp_dtls_tbl(i).end_time
2108: );
2109: fnd_log.string

Line 2109: fnd_log.string

2105: fnd_log.level_statement,
2106: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2107: 'x_tp_dtls_tbl('||i||').end_time: '|| x_tp_dtls_tbl(i).end_time
2108: );
2109: fnd_log.string
2110: (
2111: fnd_log.level_statement,
2112: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2113: 'x_tp_dtls_tbl('||i||').bom_resource_id: '|| x_tp_dtls_tbl(i).bom_resource_id

Line 2111: fnd_log.level_statement,

2107: 'x_tp_dtls_tbl('||i||').end_time: '|| x_tp_dtls_tbl(i).end_time
2108: );
2109: fnd_log.string
2110: (
2111: fnd_log.level_statement,
2112: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2113: 'x_tp_dtls_tbl('||i||').bom_resource_id: '|| x_tp_dtls_tbl(i).bom_resource_id
2114: );
2115: fnd_log.string

Line 2115: fnd_log.string

2111: fnd_log.level_statement,
2112: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2113: 'x_tp_dtls_tbl('||i||').bom_resource_id: '|| x_tp_dtls_tbl(i).bom_resource_id
2114: );
2115: fnd_log.string
2116: (
2117: fnd_log.level_statement,
2118: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2119: 'x_tp_dtls_tbl('||i||').department_id: '|| x_tp_dtls_tbl(i).department_id

Line 2117: fnd_log.level_statement,

2113: 'x_tp_dtls_tbl('||i||').bom_resource_id: '|| x_tp_dtls_tbl(i).bom_resource_id
2114: );
2115: fnd_log.string
2116: (
2117: fnd_log.level_statement,
2118: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2119: 'x_tp_dtls_tbl('||i||').department_id: '|| x_tp_dtls_tbl(i).department_id
2120: );
2121: fnd_log.string

Line 2121: fnd_log.string

2117: fnd_log.level_statement,
2118: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2119: 'x_tp_dtls_tbl('||i||').department_id: '|| x_tp_dtls_tbl(i).department_id
2120: );
2121: fnd_log.string
2122: (
2123: fnd_log.level_statement,
2124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2125: 'x_tp_dtls_tbl('||i||').quantity: '|| x_tp_dtls_tbl(i).quantity

Line 2123: fnd_log.level_statement,

2119: 'x_tp_dtls_tbl('||i||').department_id: '|| x_tp_dtls_tbl(i).department_id
2120: );
2121: fnd_log.string
2122: (
2123: fnd_log.level_statement,
2124: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2125: 'x_tp_dtls_tbl('||i||').quantity: '|| x_tp_dtls_tbl(i).quantity
2126: );
2127:

Line 2208: fnd_log.string

2204:
2205: BEGIN
2206:
2207: IF (l_log_statement >= l_log_current_level) THEN
2208: fnd_log.string
2209: (
2210: fnd_log.level_statement,
2211: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2212: 'p_start_time:'||p_start_time

Line 2210: fnd_log.level_statement,

2206:
2207: IF (l_log_statement >= l_log_current_level) THEN
2208: fnd_log.string
2209: (
2210: fnd_log.level_statement,
2211: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2212: 'p_start_time:'||p_start_time
2213: );
2214: fnd_log.string

Line 2214: fnd_log.string

2210: fnd_log.level_statement,
2211: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2212: 'p_start_time:'||p_start_time
2213: );
2214: fnd_log.string
2215: (
2216: fnd_log.level_statement,
2217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2218: 'p_end_time:'||p_end_time

Line 2216: fnd_log.level_statement,

2212: 'p_start_time:'||p_start_time
2213: );
2214: fnd_log.string
2215: (
2216: fnd_log.level_statement,
2217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2218: 'p_end_time:'||p_end_time
2219: );
2220: fnd_log.string

Line 2220: fnd_log.string

2216: fnd_log.level_statement,
2217: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2218: 'p_end_time:'||p_end_time
2219: );
2220: fnd_log.string
2221: (
2222: fnd_log.level_statement,
2223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2224: 'p_department_id:'||p_department_id

Line 2222: fnd_log.level_statement,

2218: 'p_end_time:'||p_end_time
2219: );
2220: fnd_log.string
2221: (
2222: fnd_log.level_statement,
2223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2224: 'p_department_id:'||p_department_id
2225: );
2226: fnd_log.string

Line 2226: fnd_log.string

2222: fnd_log.level_statement,
2223: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2224: 'p_department_id:'||p_department_id
2225: );
2226: fnd_log.string
2227: (
2228: fnd_log.level_statement,
2229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2230: 'p_visit_id:'||p_visit_id

Line 2228: fnd_log.level_statement,

2224: 'p_department_id:'||p_department_id
2225: );
2226: fnd_log.string
2227: (
2228: fnd_log.level_statement,
2229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2230: 'p_visit_id:'||p_visit_id
2231: );
2232: fnd_log.string

Line 2232: fnd_log.string

2228: fnd_log.level_statement,
2229: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2230: 'p_visit_id:'||p_visit_id
2231: );
2232: fnd_log.string
2233: (
2234: fnd_log.level_statement,
2235: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2236: 'p_x_tp_dtls_tbl.count:'||p_x_tp_dtls_tbl.count

Line 2234: fnd_log.level_statement,

2230: 'p_visit_id:'||p_visit_id
2231: );
2232: fnd_log.string
2233: (
2234: fnd_log.level_statement,
2235: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2236: 'p_x_tp_dtls_tbl.count:'||p_x_tp_dtls_tbl.count
2237: );
2238:

Line 2296: fnd_log.string

2292: -- x_visit_task_times_tbl := l_task_times_tbl;
2293: -- ELSE
2294:
2295: IF (l_log_statement >= l_log_current_level) THEN
2296: fnd_log.string
2297: (
2298: fnd_log.level_statement,
2299: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2300: 'l_task_times_tbl.COUNT:'||l_task_times_tbl.COUNT

Line 2298: fnd_log.level_statement,

2294:
2295: IF (l_log_statement >= l_log_current_level) THEN
2296: fnd_log.string
2297: (
2298: fnd_log.level_statement,
2299: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2300: 'l_task_times_tbl.COUNT:'||l_task_times_tbl.COUNT
2301: );
2302: END IF;

Line 2334: fnd_log.string

2330: p_end_time => p_end_time,
2331: p_x_tp_dtls_tbl => p_x_tp_dtls_tbl);
2332:
2333: IF (l_log_statement >= l_log_current_level) THEN
2334: fnd_log.string
2335: (
2336: fnd_log.level_statement,
2337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2338: 'l_index-('||l_index||') After Calling Get_Operation_Details'

Line 2336: fnd_log.level_statement,

2332:
2333: IF (l_log_statement >= l_log_current_level) THEN
2334: fnd_log.string
2335: (
2336: fnd_log.level_statement,
2337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2338: 'l_index-('||l_index||') After Calling Get_Operation_Details'
2339: );
2340: fnd_log.string

Line 2340: fnd_log.string

2336: fnd_log.level_statement,
2337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2338: 'l_index-('||l_index||') After Calling Get_Operation_Details'
2339: );
2340: fnd_log.string
2341: (
2342: fnd_log.level_statement,
2343: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2344: 'p_x_tp_dtls_tbl.COUNT:'||p_x_tp_dtls_tbl.COUNT

Line 2342: fnd_log.level_statement,

2338: 'l_index-('||l_index||') After Calling Get_Operation_Details'
2339: );
2340: fnd_log.string
2341: (
2342: fnd_log.level_statement,
2343: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2344: 'p_x_tp_dtls_tbl.COUNT:'||p_x_tp_dtls_tbl.COUNT
2345: );
2346: END IF;

Line 2354: fnd_log.string

2350: END IF;
2351: -- END IF;
2352:
2353: IF (l_log_statement >= l_log_current_level) THEN
2354: fnd_log.string
2355: (
2356: fnd_log.level_statement,
2357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2358: 'l_task_times_tbl.COUNT:'||l_task_times_tbl.COUNT

Line 2356: fnd_log.level_statement,

2352:
2353: IF (l_log_statement >= l_log_current_level) THEN
2354: fnd_log.string
2355: (
2356: fnd_log.level_statement,
2357: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2358: 'l_task_times_tbl.COUNT:'||l_task_times_tbl.COUNT
2359: );
2360: END IF;

Line 2862: fnd_log.string

2858:
2859: BEGIN
2860:
2861: IF (l_log_statement >= l_log_current_level) THEN
2862: fnd_log.string
2863: (
2864: fnd_log.level_statement,
2865: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2866: 'p_start_time:'||p_start_time

Line 2864: fnd_log.level_statement,

2860:
2861: IF (l_log_statement >= l_log_current_level) THEN
2862: fnd_log.string
2863: (
2864: fnd_log.level_statement,
2865: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2866: 'p_start_time:'||p_start_time
2867: );
2868: fnd_log.string

Line 2868: fnd_log.string

2864: fnd_log.level_statement,
2865: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2866: 'p_start_time:'||p_start_time
2867: );
2868: fnd_log.string
2869: (
2870: fnd_log.level_statement,
2871: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2872: 'p_end_time:'||p_end_time

Line 2870: fnd_log.level_statement,

2866: 'p_start_time:'||p_start_time
2867: );
2868: fnd_log.string
2869: (
2870: fnd_log.level_statement,
2871: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2872: 'p_end_time:'||p_end_time
2873: );
2874: fnd_log.string

Line 2874: fnd_log.string

2870: fnd_log.level_statement,
2871: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2872: 'p_end_time:'||p_end_time
2873: );
2874: fnd_log.string
2875: (
2876: fnd_log.level_statement,
2877: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2878: 'p_department_id:'||p_department_id

Line 2876: fnd_log.level_statement,

2872: 'p_end_time:'||p_end_time
2873: );
2874: fnd_log.string
2875: (
2876: fnd_log.level_statement,
2877: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2878: 'p_department_id:'||p_department_id
2879: );
2880: fnd_log.string

Line 2880: fnd_log.string

2876: fnd_log.level_statement,
2877: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2878: 'p_department_id:'||p_department_id
2879: );
2880: fnd_log.string
2881: (
2882: fnd_log.level_statement,
2883: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2884: 'p_visit_id:'||p_visit_id

Line 2882: fnd_log.level_statement,

2878: 'p_department_id:'||p_department_id
2879: );
2880: fnd_log.string
2881: (
2882: fnd_log.level_statement,
2883: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2884: 'p_visit_id:'||p_visit_id
2885: );
2886: fnd_log.string

Line 2886: fnd_log.string

2882: fnd_log.level_statement,
2883: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2884: 'p_visit_id:'||p_visit_id
2885: );
2886: fnd_log.string
2887: (
2888: fnd_log.level_statement,
2889: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2890: 'p_organization_id:'||p_organization_id

Line 2888: fnd_log.level_statement,

2884: 'p_visit_id:'||p_visit_id
2885: );
2886: fnd_log.string
2887: (
2888: fnd_log.level_statement,
2889: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2890: 'p_organization_id:'||p_organization_id
2891: );
2892: fnd_log.string

Line 2892: fnd_log.string

2888: fnd_log.level_statement,
2889: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2890: 'p_organization_id:'||p_organization_id
2891: );
2892: fnd_log.string
2893: (
2894: fnd_log.level_statement,
2895: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2896: 'p_task_dtls.MR_ROUTE_ID:'||p_task_dtls.MR_ROUTE_ID

Line 2894: fnd_log.level_statement,

2890: 'p_organization_id:'||p_organization_id
2891: );
2892: fnd_log.string
2893: (
2894: fnd_log.level_statement,
2895: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2896: 'p_task_dtls.MR_ROUTE_ID:'||p_task_dtls.MR_ROUTE_ID
2897: );
2898: fnd_log.string

Line 2898: fnd_log.string

2894: fnd_log.level_statement,
2895: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2896: 'p_task_dtls.MR_ROUTE_ID:'||p_task_dtls.MR_ROUTE_ID
2897: );
2898: fnd_log.string
2899: (
2900: fnd_log.level_statement,
2901: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2902: 'p_task_dtls.VISIT_TASK_ID:'||p_task_dtls.VISIT_TASK_ID

Line 2900: fnd_log.level_statement,

2896: 'p_task_dtls.MR_ROUTE_ID:'||p_task_dtls.MR_ROUTE_ID
2897: );
2898: fnd_log.string
2899: (
2900: fnd_log.level_statement,
2901: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2902: 'p_task_dtls.VISIT_TASK_ID:'||p_task_dtls.VISIT_TASK_ID
2903: );
2904: END IF;

Line 2918: fnd_log.string

2914: FETCH l_get_route_id INTO l_route_id;
2915: CLOSE l_get_route_id;
2916:
2917: IF (l_log_statement >= l_log_current_level) THEN
2918: fnd_log.string
2919: (
2920: fnd_log.level_statement,
2921: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2922: 'l_route_id:'||l_route_id

Line 2920: fnd_log.level_statement,

2916:
2917: IF (l_log_statement >= l_log_current_level) THEN
2918: fnd_log.string
2919: (
2920: fnd_log.level_statement,
2921: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2922: 'l_route_id:'||l_route_id
2923: );
2924: END IF;

Line 2932: fnd_log.string

2928: FETCH l_get_rt_rsrc_count INTO l_temp_count;
2929: CLOSE l_get_rt_rsrc_count;
2930:
2931: IF (l_log_statement >= l_log_current_level) THEN
2932: fnd_log.string
2933: (
2934: fnd_log.level_statement,
2935: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2936: 'number of resources associated to route:'||l_temp_count

Line 2934: fnd_log.level_statement,

2930:
2931: IF (l_log_statement >= l_log_current_level) THEN
2932: fnd_log.string
2933: (
2934: fnd_log.level_statement,
2935: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2936: 'number of resources associated to route:'||l_temp_count
2937: );
2938: END IF;

Line 2971: fnd_log.string

2967: p_x_tp_dtls_tbl(l_table_index).BOM_RESOURCE_ID := l_rt_resource_dtl_rec.BOM_RESOURCE_ID;
2968: p_x_tp_dtls_tbl(l_table_index).DEPARTMENT_ID := p_department_id;
2969:
2970: IF (l_log_statement >= l_log_current_level) THEN
2971: fnd_log.string
2972: (
2973: fnd_log.level_statement,
2974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2975: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')

Line 2973: fnd_log.level_statement,

2969:
2970: IF (l_log_statement >= l_log_current_level) THEN
2971: fnd_log.string
2972: (
2973: fnd_log.level_statement,
2974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2975: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')
2976: );
2977: fnd_log.string

Line 2977: fnd_log.string

2973: fnd_log.level_statement,
2974: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2975: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')
2976: );
2977: fnd_log.string
2978: (
2979: fnd_log.level_statement,
2980: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2981: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')

Line 2979: fnd_log.level_statement,

2975: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')
2976: );
2977: fnd_log.string
2978: (
2979: fnd_log.level_statement,
2980: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2981: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')
2982: );
2983: fnd_log.string

Line 2983: fnd_log.string

2979: fnd_log.level_statement,
2980: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2981: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')
2982: );
2983: fnd_log.string
2984: (
2985: fnd_log.level_statement,
2986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2987: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id

Line 2985: fnd_log.level_statement,

2981: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')
2982: );
2983: fnd_log.string
2984: (
2985: fnd_log.level_statement,
2986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2987: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id
2988: );
2989: fnd_log.string

Line 2989: fnd_log.string

2985: fnd_log.level_statement,
2986: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2987: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id
2988: );
2989: fnd_log.string
2990: (
2991: fnd_log.level_statement,
2992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2993: 'p_x_tp_dtls_tbl('||l_table_index||').quantity: '|| p_x_tp_dtls_tbl(l_table_index).quantity

Line 2991: fnd_log.level_statement,

2987: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id
2988: );
2989: fnd_log.string
2990: (
2991: fnd_log.level_statement,
2992: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2993: 'p_x_tp_dtls_tbl('||l_table_index||').quantity: '|| p_x_tp_dtls_tbl(l_table_index).quantity
2994: );
2995:

Line 3012: fnd_log.string

3008: FETCH l_get_ops_count INTO l_temp_count;
3009: CLOSE l_get_ops_count;
3010:
3011: IF (l_log_statement >= l_log_current_level) THEN
3012: fnd_log.string
3013: (
3014: fnd_log.level_statement,
3015: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3016: 'number of operations associated to route:'||l_temp_count

Line 3014: fnd_log.level_statement,

3010:
3011: IF (l_log_statement >= l_log_current_level) THEN
3012: fnd_log.string
3013: (
3014: fnd_log.level_statement,
3015: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3016: 'number of operations associated to route:'||l_temp_count
3017: );
3018: END IF;

Line 3029: fnd_log.string

3025: -- l_next_start_hour := p_task_dtls.TASK_START_HOUR; -- Start hour of first operation w.r.t visit
3026: l_oper_END_TIME :=p_task_dtls.TASK_START_TIME;
3027:
3028: IF (l_log_statement >= l_log_current_level) THEN
3029: fnd_log.string
3030: (
3031: fnd_log.level_statement,
3032: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3033: 'p_task_dtls.TASK_START_TIME:'||TO_CHAR(p_task_dtls.TASK_START_TIME, 'DD-MON-YYYY hh24:mi')

Line 3031: fnd_log.level_statement,

3027:
3028: IF (l_log_statement >= l_log_current_level) THEN
3029: fnd_log.string
3030: (
3031: fnd_log.level_statement,
3032: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3033: 'p_task_dtls.TASK_START_TIME:'||TO_CHAR(p_task_dtls.TASK_START_TIME, 'DD-MON-YYYY hh24:mi')
3034: );
3035: END IF;

Line 3046: fnd_log.string

3042: -- Ahl_Debug_Pub.debug('l_operation_id:'||l_operation_id);
3043: l_temp_duration := 0;
3044:
3045: IF (l_log_statement >= l_log_current_level) THEN
3046: fnd_log.string
3047: (
3048: fnd_log.level_statement,
3049: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3050: 'l_operation_id:'||l_operation_id

Line 3048: fnd_log.level_statement,

3044:
3045: IF (l_log_statement >= l_log_current_level) THEN
3046: fnd_log.string
3047: (
3048: fnd_log.level_statement,
3049: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3050: 'l_operation_id:'||l_operation_id
3051: );
3052: fnd_log.string

Line 3052: fnd_log.string

3048: fnd_log.level_statement,
3049: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3050: 'l_operation_id:'||l_operation_id
3051: );
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement,
3055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3056: 'l_operation_step:'||l_operation_step

Line 3054: fnd_log.level_statement,

3050: 'l_operation_id:'||l_operation_id
3051: );
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement,
3055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3056: 'l_operation_step:'||l_operation_step
3057: );
3058: END IF;

Line 3067: fnd_log.string

3063: l_oper_START_TIME := l_oper_END_TIME;
3064: l_oper_END_TIME := AHL_VWP_TIMES_PVT.COMPUTE_DATE(l_oper_START_TIME,p_department_id,l_temp_duration);
3065:
3066: IF (l_log_statement >= l_log_current_level) THEN
3067: fnd_log.string
3068: (
3069: fnd_log.level_statement,
3070: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3071: 'operation duration:'||l_temp_duration

Line 3069: fnd_log.level_statement,

3065:
3066: IF (l_log_statement >= l_log_current_level) THEN
3067: fnd_log.string
3068: (
3069: fnd_log.level_statement,
3070: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3071: 'operation duration:'||l_temp_duration
3072: );
3073: fnd_log.string

Line 3073: fnd_log.string

3069: fnd_log.level_statement,
3070: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3071: 'operation duration:'||l_temp_duration
3072: );
3073: fnd_log.string
3074: (
3075: fnd_log.level_statement,
3076: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3077: 'l_oper_START_TIME:'||TO_CHAR(l_oper_START_TIME, 'DD-MON-YYYY hh24:mi')

Line 3075: fnd_log.level_statement,

3071: 'operation duration:'||l_temp_duration
3072: );
3073: fnd_log.string
3074: (
3075: fnd_log.level_statement,
3076: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3077: 'l_oper_START_TIME:'||TO_CHAR(l_oper_START_TIME, 'DD-MON-YYYY hh24:mi')
3078: );
3079: fnd_log.string

Line 3079: fnd_log.string

3075: fnd_log.level_statement,
3076: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3077: 'l_oper_START_TIME:'||TO_CHAR(l_oper_START_TIME, 'DD-MON-YYYY hh24:mi')
3078: );
3079: fnd_log.string
3080: (
3081: fnd_log.level_statement,
3082: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3083: 'l_oper_END_TIME:'||TO_CHAR(l_oper_END_TIME, 'DD-MON-YYYY hh24:mi')

Line 3081: fnd_log.level_statement,

3077: 'l_oper_START_TIME:'||TO_CHAR(l_oper_START_TIME, 'DD-MON-YYYY hh24:mi')
3078: );
3079: fnd_log.string
3080: (
3081: fnd_log.level_statement,
3082: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3083: 'l_oper_END_TIME:'||TO_CHAR(l_oper_END_TIME, 'DD-MON-YYYY hh24:mi')
3084: );
3085: END IF;

Line 3116: fnd_log.string

3112: p_x_tp_dtls_tbl(l_table_index).BOM_RESOURCE_ID := l_oper_resource_dtl_rec.BOM_RESOURCE_ID;
3113: p_x_tp_dtls_tbl(l_table_index).DEPARTMENT_ID := p_department_id;
3114:
3115: IF (l_log_statement >= l_log_current_level) THEN
3116: fnd_log.string
3117: (
3118: fnd_log.level_statement,
3119: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3120: 'p_x_tp_dtls_tbl('||l_table_index||').OPERATION_ID: '|| p_x_tp_dtls_tbl(l_table_index).OPERATION_ID

Line 3118: fnd_log.level_statement,

3114:
3115: IF (l_log_statement >= l_log_current_level) THEN
3116: fnd_log.string
3117: (
3118: fnd_log.level_statement,
3119: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3120: 'p_x_tp_dtls_tbl('||l_table_index||').OPERATION_ID: '|| p_x_tp_dtls_tbl(l_table_index).OPERATION_ID
3121: );
3122: fnd_log.string

Line 3122: fnd_log.string

3118: fnd_log.level_statement,
3119: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3120: 'p_x_tp_dtls_tbl('||l_table_index||').OPERATION_ID: '|| p_x_tp_dtls_tbl(l_table_index).OPERATION_ID
3121: );
3122: fnd_log.string
3123: (
3124: fnd_log.level_statement,
3125: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3126: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')

Line 3124: fnd_log.level_statement,

3120: 'p_x_tp_dtls_tbl('||l_table_index||').OPERATION_ID: '|| p_x_tp_dtls_tbl(l_table_index).OPERATION_ID
3121: );
3122: fnd_log.string
3123: (
3124: fnd_log.level_statement,
3125: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3126: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')
3127: );
3128: fnd_log.string

Line 3128: fnd_log.string

3124: fnd_log.level_statement,
3125: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3126: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')
3127: );
3128: fnd_log.string
3129: (
3130: fnd_log.level_statement,
3131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3132: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')

Line 3130: fnd_log.level_statement,

3126: 'p_x_tp_dtls_tbl('||l_table_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_table_index).start_time, 'DD-MON-YYYY hh24:mi')
3127: );
3128: fnd_log.string
3129: (
3130: fnd_log.level_statement,
3131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3132: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')
3133: );
3134: fnd_log.string

Line 3134: fnd_log.string

3130: fnd_log.level_statement,
3131: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3132: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')
3133: );
3134: fnd_log.string
3135: (
3136: fnd_log.level_statement,
3137: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3138: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id

Line 3136: fnd_log.level_statement,

3132: 'p_x_tp_dtls_tbl('||l_table_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_table_index).end_time, 'DD-MON-YYYY hh24:mi')
3133: );
3134: fnd_log.string
3135: (
3136: fnd_log.level_statement,
3137: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3138: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id
3139: );
3140: fnd_log.string

Line 3140: fnd_log.string

3136: fnd_log.level_statement,
3137: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3138: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id
3139: );
3140: fnd_log.string
3141: (
3142: fnd_log.level_statement,
3143: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3144: 'p_x_tp_dtls_tbl('||l_table_index||').quantity: '|| p_x_tp_dtls_tbl(l_table_index).quantity

Line 3142: fnd_log.level_statement,

3138: 'p_x_tp_dtls_tbl('||l_table_index||').bom_resource_id: '|| p_x_tp_dtls_tbl(l_table_index).bom_resource_id
3139: );
3140: fnd_log.string
3141: (
3142: fnd_log.level_statement,
3143: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3144: 'p_x_tp_dtls_tbl('||l_table_index||').quantity: '|| p_x_tp_dtls_tbl(l_table_index).quantity
3145: );
3146: END IF;

Line 3192: fnd_log.string

3188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3189: END IF;
3190:
3191: IF (l_log_statement >= l_log_current_level) THEN
3192: fnd_log.string
3193: (
3194: fnd_log.level_statement,
3195: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3196: 'p_resource_id: '|| p_resource_id

Line 3194: fnd_log.level_statement,

3190:
3191: IF (l_log_statement >= l_log_current_level) THEN
3192: fnd_log.string
3193: (
3194: fnd_log.level_statement,
3195: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3196: 'p_resource_id: '|| p_resource_id
3197: );
3198: fnd_log.string

Line 3198: fnd_log.string

3194: fnd_log.level_statement,
3195: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3196: 'p_resource_id: '|| p_resource_id
3197: );
3198: fnd_log.string
3199: (
3200: fnd_log.level_statement,
3201: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3202: 'p_start_time: '|| TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')

Line 3200: fnd_log.level_statement,

3196: 'p_resource_id: '|| p_resource_id
3197: );
3198: fnd_log.string
3199: (
3200: fnd_log.level_statement,
3201: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3202: 'p_start_time: '|| TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
3203: );
3204: fnd_log.string

Line 3204: fnd_log.string

3200: fnd_log.level_statement,
3201: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3202: 'p_start_time: '|| TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
3203: );
3204: fnd_log.string
3205: (
3206: fnd_log.level_statement,
3207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3208: 'p_end_time: '|| TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')

Line 3206: fnd_log.level_statement,

3202: 'p_start_time: '|| TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
3203: );
3204: fnd_log.string
3205: (
3206: fnd_log.level_statement,
3207: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3208: 'p_end_time: '|| TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')
3209: );
3210:

Line 3242: fnd_log.string

3238: FOR i IN p_x_tp_dtls_tbl.FIRST..p_x_tp_dtls_tbl.LAST
3239: LOOP
3240:
3241: IF (l_log_statement >= l_log_current_level) THEN
3242: fnd_log.string
3243: (
3244: fnd_log.level_statement,
3245: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3246: 'p_x_tp_dtls_tbl('||i||').visit_id: '|| p_x_tp_dtls_tbl(i).visit_id

Line 3244: fnd_log.level_statement,

3240:
3241: IF (l_log_statement >= l_log_current_level) THEN
3242: fnd_log.string
3243: (
3244: fnd_log.level_statement,
3245: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3246: 'p_x_tp_dtls_tbl('||i||').visit_id: '|| p_x_tp_dtls_tbl(i).visit_id
3247: );
3248: fnd_log.string

Line 3248: fnd_log.string

3244: fnd_log.level_statement,
3245: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3246: 'p_x_tp_dtls_tbl('||i||').visit_id: '|| p_x_tp_dtls_tbl(i).visit_id
3247: );
3248: fnd_log.string
3249: (
3250: fnd_log.level_statement,
3251: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3252: 'p_x_tp_dtls_tbl('||i||').route_id: '|| p_x_tp_dtls_tbl(i).route_id

Line 3250: fnd_log.level_statement,

3246: 'p_x_tp_dtls_tbl('||i||').visit_id: '|| p_x_tp_dtls_tbl(i).visit_id
3247: );
3248: fnd_log.string
3249: (
3250: fnd_log.level_statement,
3251: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3252: 'p_x_tp_dtls_tbl('||i||').route_id: '|| p_x_tp_dtls_tbl(i).route_id
3253: );
3254: fnd_log.string

Line 3254: fnd_log.string

3250: fnd_log.level_statement,
3251: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3252: 'p_x_tp_dtls_tbl('||i||').route_id: '|| p_x_tp_dtls_tbl(i).route_id
3253: );
3254: fnd_log.string
3255: (
3256: fnd_log.level_statement,
3257: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3258: 'p_x_tp_dtls_tbl('||i||').mr_route_id: '|| p_x_tp_dtls_tbl(i).mr_route_id

Line 3256: fnd_log.level_statement,

3252: 'p_x_tp_dtls_tbl('||i||').route_id: '|| p_x_tp_dtls_tbl(i).route_id
3253: );
3254: fnd_log.string
3255: (
3256: fnd_log.level_statement,
3257: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3258: 'p_x_tp_dtls_tbl('||i||').mr_route_id: '|| p_x_tp_dtls_tbl(i).mr_route_id
3259: );
3260: fnd_log.string

Line 3260: fnd_log.string

3256: fnd_log.level_statement,
3257: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3258: 'p_x_tp_dtls_tbl('||i||').mr_route_id: '|| p_x_tp_dtls_tbl(i).mr_route_id
3259: );
3260: fnd_log.string
3261: (
3262: fnd_log.level_statement,
3263: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3264: 'p_x_tp_dtls_tbl('||i||').operation_id: '|| p_x_tp_dtls_tbl(i).operation_id

Line 3262: fnd_log.level_statement,

3258: 'p_x_tp_dtls_tbl('||i||').mr_route_id: '|| p_x_tp_dtls_tbl(i).mr_route_id
3259: );
3260: fnd_log.string
3261: (
3262: fnd_log.level_statement,
3263: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3264: 'p_x_tp_dtls_tbl('||i||').operation_id: '|| p_x_tp_dtls_tbl(i).operation_id
3265: );
3266: fnd_log.string

Line 3266: fnd_log.string

3262: fnd_log.level_statement,
3263: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3264: 'p_x_tp_dtls_tbl('||i||').operation_id: '|| p_x_tp_dtls_tbl(i).operation_id
3265: );
3266: fnd_log.string
3267: (
3268: fnd_log.level_statement,
3269: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3270: 'p_x_tp_dtls_tbl('||i||').task_id: '|| p_x_tp_dtls_tbl(i).task_id

Line 3268: fnd_log.level_statement,

3264: 'p_x_tp_dtls_tbl('||i||').operation_id: '|| p_x_tp_dtls_tbl(i).operation_id
3265: );
3266: fnd_log.string
3267: (
3268: fnd_log.level_statement,
3269: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3270: 'p_x_tp_dtls_tbl('||i||').task_id: '|| p_x_tp_dtls_tbl(i).task_id
3271: );
3272: fnd_log.string

Line 3272: fnd_log.string

3268: fnd_log.level_statement,
3269: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3270: 'p_x_tp_dtls_tbl('||i||').task_id: '|| p_x_tp_dtls_tbl(i).task_id
3271: );
3272: fnd_log.string
3273: (
3274: fnd_log.level_statement,
3275: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3276: 'p_x_tp_dtls_tbl('||i||').start_time: '|| p_x_tp_dtls_tbl(i).start_time

Line 3274: fnd_log.level_statement,

3270: 'p_x_tp_dtls_tbl('||i||').task_id: '|| p_x_tp_dtls_tbl(i).task_id
3271: );
3272: fnd_log.string
3273: (
3274: fnd_log.level_statement,
3275: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3276: 'p_x_tp_dtls_tbl('||i||').start_time: '|| p_x_tp_dtls_tbl(i).start_time
3277: );
3278: fnd_log.string

Line 3278: fnd_log.string

3274: fnd_log.level_statement,
3275: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3276: 'p_x_tp_dtls_tbl('||i||').start_time: '|| p_x_tp_dtls_tbl(i).start_time
3277: );
3278: fnd_log.string
3279: (
3280: fnd_log.level_statement,
3281: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3282: 'p_x_tp_dtls_tbl('||i||').end_time: '|| p_x_tp_dtls_tbl(i).end_time

Line 3280: fnd_log.level_statement,

3276: 'p_x_tp_dtls_tbl('||i||').start_time: '|| p_x_tp_dtls_tbl(i).start_time
3277: );
3278: fnd_log.string
3279: (
3280: fnd_log.level_statement,
3281: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3282: 'p_x_tp_dtls_tbl('||i||').end_time: '|| p_x_tp_dtls_tbl(i).end_time
3283: );
3284:

Line 3285: fnd_log.string

3281: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3282: 'p_x_tp_dtls_tbl('||i||').end_time: '|| p_x_tp_dtls_tbl(i).end_time
3283: );
3284:
3285: fnd_log.string
3286: (
3287: fnd_log.level_statement,
3288: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3289: 'p_x_tp_dtls_tbl('||i||').quantity: '|| p_x_tp_dtls_tbl(i).quantity

Line 3287: fnd_log.level_statement,

3283: );
3284:
3285: fnd_log.string
3286: (
3287: fnd_log.level_statement,
3288: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3289: 'p_x_tp_dtls_tbl('||i||').quantity: '|| p_x_tp_dtls_tbl(i).quantity
3290: );
3291:

Line 3427: fnd_log.string

3423:
3424: BEGIN
3425:
3426: IF (l_log_statement >= l_log_current_level) THEN
3427: fnd_log.string
3428: (
3429: fnd_log.level_statement,
3430: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3431: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')

Line 3429: fnd_log.level_statement,

3425:
3426: IF (l_log_statement >= l_log_current_level) THEN
3427: fnd_log.string
3428: (
3429: fnd_log.level_statement,
3430: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3431: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
3432: );
3433: fnd_log.string

Line 3433: fnd_log.string

3429: fnd_log.level_statement,
3430: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3431: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
3432: );
3433: fnd_log.string
3434: (
3435: fnd_log.level_statement,
3436: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3437: 'p_end_time:'||TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')

Line 3435: fnd_log.level_statement,

3431: 'p_start_time:'||TO_CHAR( p_start_time, 'DD-MON-YYYY hh24:mi')
3432: );
3433: fnd_log.string
3434: (
3435: fnd_log.level_statement,
3436: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3437: 'p_end_time:'||TO_CHAR( p_end_time, 'DD-MON-YYYY hh24:mi')
3438: );
3439: END IF;

Line 3651: fnd_log.string

3647: IF x_per_rsrc_tbl.COUNT > 0 THEN
3648: FOR i in x_per_rsrc_tbl.FIRST..x_per_rsrc_tbl.LAST LOOP
3649:
3650: IF (l_log_statement >= l_log_current_level) THEN
3651: fnd_log.string
3652: (
3653: fnd_log.level_statement,
3654: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3655: 'x_per_rsrc_tbl('||i||') START:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_START, 'DD-MON-YYYY hh24:mi')

Line 3653: fnd_log.level_statement,

3649:
3650: IF (l_log_statement >= l_log_current_level) THEN
3651: fnd_log.string
3652: (
3653: fnd_log.level_statement,
3654: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3655: 'x_per_rsrc_tbl('||i||') START:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_START, 'DD-MON-YYYY hh24:mi')
3656: );
3657: fnd_log.string

Line 3657: fnd_log.string

3653: fnd_log.level_statement,
3654: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3655: 'x_per_rsrc_tbl('||i||') START:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_START, 'DD-MON-YYYY hh24:mi')
3656: );
3657: fnd_log.string
3658: (
3659: fnd_log.level_statement,
3660: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3661: 'x_per_rsrc_tbl('||i||') END:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_END, 'DD-MON-YYYY hh24:mi')

Line 3659: fnd_log.level_statement,

3655: 'x_per_rsrc_tbl('||i||') START:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_START, 'DD-MON-YYYY hh24:mi')
3656: );
3657: fnd_log.string
3658: (
3659: fnd_log.level_statement,
3660: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3661: 'x_per_rsrc_tbl('||i||') END:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_END, 'DD-MON-YYYY hh24:mi')
3662: );
3663: fnd_log.string

Line 3663: fnd_log.string

3659: fnd_log.level_statement,
3660: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3661: 'x_per_rsrc_tbl('||i||') END:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_END, 'DD-MON-YYYY hh24:mi')
3662: );
3663: fnd_log.string
3664: (
3665: fnd_log.level_statement,
3666: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3667: 'x_per_rsrc_tbl('||i||') STRING:'||x_per_rsrc_tbl(i).PERIOD_STRING

Line 3665: fnd_log.level_statement,

3661: 'x_per_rsrc_tbl('||i||') END:'||TO_CHAR( x_per_rsrc_tbl(i).PERIOD_END, 'DD-MON-YYYY hh24:mi')
3662: );
3663: fnd_log.string
3664: (
3665: fnd_log.level_statement,
3666: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
3667: 'x_per_rsrc_tbl('||i||') STRING:'||x_per_rsrc_tbl(i).PERIOD_STRING
3668: );
3669:

Line 4453: fnd_log.string

4449:
4450: BEGIN
4451:
4452: IF (l_log_statement >= l_log_current_level) THEN
4453: fnd_log.string
4454: (
4455: fnd_log.level_statement,
4456: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4457: 'inside Get_Required_Quantity. p_tp_dtls_tbl.count: '||p_tp_dtls_tbl.count

Line 4455: fnd_log.level_statement,

4451:
4452: IF (l_log_statement >= l_log_current_level) THEN
4453: fnd_log.string
4454: (
4455: fnd_log.level_statement,
4456: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4457: 'inside Get_Required_Quantity. p_tp_dtls_tbl.count: '||p_tp_dtls_tbl.count
4458: );
4459:

Line 4467: fnd_log.string

4463: -- progress during the time period, Getting the Initial demand along the way
4464: FOR i IN p_tp_dtls_tbl.FIRST .. p_tp_dtls_tbl.LAST LOOP
4465:
4466: IF (l_log_statement >= l_log_current_level) THEN
4467: fnd_log.string
4468: (
4469: fnd_log.level_statement,
4470: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4471: ' i: '||i

Line 4469: fnd_log.level_statement,

4465:
4466: IF (l_log_statement >= l_log_current_level) THEN
4467: fnd_log.string
4468: (
4469: fnd_log.level_statement,
4470: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4471: ' i: '||i
4472: );
4473: END IF;

Line 4478: fnd_log.string

4474:
4475: IF (Periods_Overlap(p_start_time, p_end_time, p_tp_dtls_tbl(i).START_TIME, p_tp_dtls_tbl(i).END_TIME)) THEN
4476:
4477: IF (l_log_statement >= l_log_current_level) THEN
4478: fnd_log.string
4479: (
4480: fnd_log.level_statement,
4481: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4482: ' Periods_Overlap'

Line 4480: fnd_log.level_statement,

4476:
4477: IF (l_log_statement >= l_log_current_level) THEN
4478: fnd_log.string
4479: (
4480: fnd_log.level_statement,
4481: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4482: ' Periods_Overlap'
4483: );
4484: END IF;

Line 4490: fnd_log.string

4486: l_qty_change_tbl(l_temp_index).EVENT_TIME := p_tp_dtls_tbl(i).START_TIME;
4487: l_qty_change_tbl(l_temp_index).QTY_CHANGE := p_tp_dtls_tbl(i).QUANTITY;
4488:
4489: IF (l_log_statement >= l_log_current_level) THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_statement,
4493: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4494: ' l_qty_change_tbl('||l_temp_index||').QTY_CHANGE: '||l_qty_change_tbl(l_temp_index).QTY_CHANGE

Line 4492: fnd_log.level_statement,

4488:
4489: IF (l_log_statement >= l_log_current_level) THEN
4490: fnd_log.string
4491: (
4492: fnd_log.level_statement,
4493: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4494: ' l_qty_change_tbl('||l_temp_index||').QTY_CHANGE: '||l_qty_change_tbl(l_temp_index).QTY_CHANGE
4495: );
4496:

Line 4504: fnd_log.string

4500: l_qty_change_tbl(l_temp_index).EVENT_TIME := p_tp_dtls_tbl(i).END_TIME;
4501: l_qty_change_tbl(l_temp_index).QTY_CHANGE := -(p_tp_dtls_tbl(i).QUANTITY);
4502:
4503: IF (l_log_statement >= l_log_current_level) THEN
4504: fnd_log.string
4505: (
4506: fnd_log.level_statement,
4507: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4508: ' l_qty_change_tbl('||l_temp_index||').QTY_CHANGE: '||l_qty_change_tbl(l_temp_index).QTY_CHANGE

Line 4506: fnd_log.level_statement,

4502:
4503: IF (l_log_statement >= l_log_current_level) THEN
4504: fnd_log.string
4505: (
4506: fnd_log.level_statement,
4507: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4508: ' l_qty_change_tbl('||l_temp_index||').QTY_CHANGE: '||l_qty_change_tbl(l_temp_index).QTY_CHANGE
4509: );
4510:

Line 4519: fnd_log.string

4515: l_initial_req := l_initial_req + p_tp_dtls_tbl(i).QUANTITY;
4516: END IF;
4517:
4518: IF (l_log_statement >= l_log_current_level) THEN
4519: fnd_log.string
4520: (
4521: fnd_log.level_statement,
4522: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4523: ' l_temp_index: '||l_temp_index

Line 4521: fnd_log.level_statement,

4517:
4518: IF (l_log_statement >= l_log_current_level) THEN
4519: fnd_log.string
4520: (
4521: fnd_log.level_statement,
4522: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4523: ' l_temp_index: '||l_temp_index
4524: );
4525:

Line 4531: fnd_log.string

4527: END IF;
4528: END LOOP;
4529:
4530: IF (l_log_statement >= l_log_current_level) THEN
4531: fnd_log.string
4532: (
4533: fnd_log.level_statement,
4534: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4535: 'After loop l_qty_change_tbl.count: '||l_qty_change_tbl.count

Line 4533: fnd_log.level_statement,

4529:
4530: IF (l_log_statement >= l_log_current_level) THEN
4531: fnd_log.string
4532: (
4533: fnd_log.level_statement,
4534: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4535: 'After loop l_qty_change_tbl.count: '||l_qty_change_tbl.count
4536: );
4537:

Line 4567: fnd_log.string

4563: END IF;
4564: END LOOP;
4565:
4566: IF (l_log_statement >= l_log_current_level) THEN
4567: fnd_log.string
4568: (
4569: fnd_log.level_statement,
4570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4571: 'Complete Get_Required_Quantity. l_max_demand: '||l_max_demand

Line 4569: fnd_log.level_statement,

4565:
4566: IF (l_log_statement >= l_log_current_level) THEN
4567: fnd_log.string
4568: (
4569: fnd_log.level_statement,
4570: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4571: 'Complete Get_Required_Quantity. l_max_demand: '||l_max_demand
4572: );
4573:

Line 4916: fnd_log.string

4912: -- None of the other fields in the p_x_tp_dtls_tbl(l_temp_index) record
4913: -- are populated since they are not relevant.
4914:
4915: IF (l_log_statement >= l_log_current_level) THEN
4916: fnd_log.string
4917: (
4918: fnd_log.level_statement,
4919: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4920: 'wip_entity_id: '|| wip_req_dtls.wip_entity_id

Line 4918: fnd_log.level_statement,

4914:
4915: IF (l_log_statement >= l_log_current_level) THEN
4916: fnd_log.string
4917: (
4918: fnd_log.level_statement,
4919: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4920: 'wip_entity_id: '|| wip_req_dtls.wip_entity_id
4921: );
4922: fnd_log.string

Line 4922: fnd_log.string

4918: fnd_log.level_statement,
4919: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4920: 'wip_entity_id: '|| wip_req_dtls.wip_entity_id
4921: );
4922: fnd_log.string
4923: (
4924: fnd_log.level_statement,
4925: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4926: 'p_x_tp_dtls_tbl('||l_temp_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_temp_index).start_time, 'DD-MON-YYYY hh24:mi')

Line 4924: fnd_log.level_statement,

4920: 'wip_entity_id: '|| wip_req_dtls.wip_entity_id
4921: );
4922: fnd_log.string
4923: (
4924: fnd_log.level_statement,
4925: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4926: 'p_x_tp_dtls_tbl('||l_temp_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_temp_index).start_time, 'DD-MON-YYYY hh24:mi')
4927: );
4928: fnd_log.string

Line 4928: fnd_log.string

4924: fnd_log.level_statement,
4925: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4926: 'p_x_tp_dtls_tbl('||l_temp_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_temp_index).start_time, 'DD-MON-YYYY hh24:mi')
4927: );
4928: fnd_log.string
4929: (
4930: fnd_log.level_statement,
4931: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4932: 'p_x_tp_dtls_tbl('||l_temp_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_temp_index).end_time, 'DD-MON-YYYY hh24:mi')

Line 4930: fnd_log.level_statement,

4926: 'p_x_tp_dtls_tbl('||l_temp_index||').start_time: '|| TO_CHAR(p_x_tp_dtls_tbl(l_temp_index).start_time, 'DD-MON-YYYY hh24:mi')
4927: );
4928: fnd_log.string
4929: (
4930: fnd_log.level_statement,
4931: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4932: 'p_x_tp_dtls_tbl('||l_temp_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_temp_index).end_time, 'DD-MON-YYYY hh24:mi')
4933: );
4934: fnd_log.string

Line 4934: fnd_log.string

4930: fnd_log.level_statement,
4931: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4932: 'p_x_tp_dtls_tbl('||l_temp_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_temp_index).end_time, 'DD-MON-YYYY hh24:mi')
4933: );
4934: fnd_log.string
4935: (
4936: fnd_log.level_statement,
4937: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4938: 'p_x_tp_dtls_tbl('||l_temp_index||').quantity: '|| p_x_tp_dtls_tbl(l_temp_index).quantity

Line 4936: fnd_log.level_statement,

4932: 'p_x_tp_dtls_tbl('||l_temp_index||').end_time: '|| TO_CHAR( p_x_tp_dtls_tbl(l_temp_index).end_time, 'DD-MON-YYYY hh24:mi')
4933: );
4934: fnd_log.string
4935: (
4936: fnd_log.level_statement,
4937: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
4938: 'p_x_tp_dtls_tbl('||l_temp_index||').quantity: '|| p_x_tp_dtls_tbl(l_temp_index).quantity
4939: );
4940: