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_PP_RESRC_ASSIGN_PVT dependencies on AHL_DEBUG_PUB

Line 7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

3:
4: -- Declare Constants --
5: -----------------------
6: G_PKG_NAME VARCHAR2(30) := 'AHL_PP_RESRC_ASSIGN_PVT';
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8: -------------------------------------------------
9: -- Declare Locally used Record and Table Types --
10: -------------------------------------------------
11:

Line 85: Ahl_Debug_Pub.debug( ': Inside Check Serial Number= ' || p_serial_number);

81: )
82: IS
83: BEGIN
84: IF G_DEBUG='Y' THEN
85: Ahl_Debug_Pub.debug( ': Inside Check Serial Number= ' || p_serial_number);
86: END IF;
87:
88: IF (p_serial_number IS NOT NULL) THEN
89: /*SELECT DISTINCT(instance_id)

Line 117: Ahl_Debug_Pub.debug(': Inside Check Serial Number = ' || x_instance_id);

113: );
114: END IF;
115:
116: IF G_DEBUG='Y' THEN
117: Ahl_Debug_Pub.debug(': Inside Check Serial Number = ' || x_instance_id);
118: END IF;
119:
120: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
121: EXCEPTION

Line 209: Ahl_Debug_Pub.debug(': Inside Check Employee Id= ' || x_Employee_id);

205:
206: END IF;
207:
208: IF G_DEBUG='Y' THEN
209: Ahl_Debug_Pub.debug(': Inside Check Employee Id= ' || x_Employee_id);
210: END IF;
211:
212: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
213: EXCEPTION

Line 499: AHL_DEBUG_PUB.debug(' Inside Update Row procedure');

495: WHERE ASSIGNMENT_ID = X_ASSIGNMENT_ID
496: AND OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER;
497:
498: IF G_DEBUG='Y' THEN
499: AHL_DEBUG_PUB.debug(' Inside Update Row procedure');
500: AHL_DEBUG_PUB.debug(' Assign ID = ' || X_ASSIGNMENT_ID);
501: AHL_DEBUG_PUB.debug(' Object version = ' || X_OBJECT_VERSION_NUMBER);
502: AHL_DEBUG_PUB.debug(' Assign Start Date = ' || x_assign_start_date);
503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);

Line 500: AHL_DEBUG_PUB.debug(' Assign ID = ' || X_ASSIGNMENT_ID);

496: AND OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER;
497:
498: IF G_DEBUG='Y' THEN
499: AHL_DEBUG_PUB.debug(' Inside Update Row procedure');
500: AHL_DEBUG_PUB.debug(' Assign ID = ' || X_ASSIGNMENT_ID);
501: AHL_DEBUG_PUB.debug(' Object version = ' || X_OBJECT_VERSION_NUMBER);
502: AHL_DEBUG_PUB.debug(' Assign Start Date = ' || x_assign_start_date);
503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);
504: END IF;

Line 501: AHL_DEBUG_PUB.debug(' Object version = ' || X_OBJECT_VERSION_NUMBER);

497:
498: IF G_DEBUG='Y' THEN
499: AHL_DEBUG_PUB.debug(' Inside Update Row procedure');
500: AHL_DEBUG_PUB.debug(' Assign ID = ' || X_ASSIGNMENT_ID);
501: AHL_DEBUG_PUB.debug(' Object version = ' || X_OBJECT_VERSION_NUMBER);
502: AHL_DEBUG_PUB.debug(' Assign Start Date = ' || x_assign_start_date);
503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);
504: END IF;
505:

Line 502: AHL_DEBUG_PUB.debug(' Assign Start Date = ' || x_assign_start_date);

498: IF G_DEBUG='Y' THEN
499: AHL_DEBUG_PUB.debug(' Inside Update Row procedure');
500: AHL_DEBUG_PUB.debug(' Assign ID = ' || X_ASSIGNMENT_ID);
501: AHL_DEBUG_PUB.debug(' Object version = ' || X_OBJECT_VERSION_NUMBER);
502: AHL_DEBUG_PUB.debug(' Assign Start Date = ' || x_assign_start_date);
503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);
504: END IF;
505:
506: /*IF SQL%rowcount = 0 THEN

Line 503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);

499: AHL_DEBUG_PUB.debug(' Inside Update Row procedure');
500: AHL_DEBUG_PUB.debug(' Assign ID = ' || X_ASSIGNMENT_ID);
501: AHL_DEBUG_PUB.debug(' Object version = ' || X_OBJECT_VERSION_NUMBER);
502: AHL_DEBUG_PUB.debug(' Assign Start Date = ' || x_assign_start_date);
503: AHL_DEBUG_PUB.debug(' Assign End Date = ' || x_assign_end_date);
504: END IF;
505:
506: /*IF SQL%rowcount = 0 THEN
507: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

Line 535: Ahl_Debug_Pub.debug( ': ASSIGNMENT_ID = ' || p_resrc_assign_rec.ASSIGNMENT_ID);

531: )
532: IS
533: BEGIN
534: IF G_DEBUG='Y' THEN
535: Ahl_Debug_Pub.debug( ': ASSIGNMENT_ID = ' || p_resrc_assign_rec.ASSIGNMENT_ID);
536: Ahl_Debug_Pub.debug( ': OPERATION_SEQ_NUMBER = ' || p_resrc_assign_rec.OPERATION_SEQ_NUMBER);
537: Ahl_Debug_Pub.debug( ': RESOURCE_SEQ_NUMBER = ' || p_resrc_assign_rec.RESOURCE_SEQ_NUMBER);
538: END IF;
539:

Line 536: Ahl_Debug_Pub.debug( ': OPERATION_SEQ_NUMBER = ' || p_resrc_assign_rec.OPERATION_SEQ_NUMBER);

532: IS
533: BEGIN
534: IF G_DEBUG='Y' THEN
535: Ahl_Debug_Pub.debug( ': ASSIGNMENT_ID = ' || p_resrc_assign_rec.ASSIGNMENT_ID);
536: Ahl_Debug_Pub.debug( ': OPERATION_SEQ_NUMBER = ' || p_resrc_assign_rec.OPERATION_SEQ_NUMBER);
537: Ahl_Debug_Pub.debug( ': RESOURCE_SEQ_NUMBER = ' || p_resrc_assign_rec.RESOURCE_SEQ_NUMBER);
538: END IF;
539:
540: IF (p_resrc_assign_rec.ASSIGNMENT_ID IS NULL OR p_resrc_assign_rec.ASSIGNMENT_ID = Fnd_Api.G_MISS_NUM) THEN

Line 537: Ahl_Debug_Pub.debug( ': RESOURCE_SEQ_NUMBER = ' || p_resrc_assign_rec.RESOURCE_SEQ_NUMBER);

533: BEGIN
534: IF G_DEBUG='Y' THEN
535: Ahl_Debug_Pub.debug( ': ASSIGNMENT_ID = ' || p_resrc_assign_rec.ASSIGNMENT_ID);
536: Ahl_Debug_Pub.debug( ': OPERATION_SEQ_NUMBER = ' || p_resrc_assign_rec.OPERATION_SEQ_NUMBER);
537: Ahl_Debug_Pub.debug( ': RESOURCE_SEQ_NUMBER = ' || p_resrc_assign_rec.RESOURCE_SEQ_NUMBER);
538: END IF;
539:
540: IF (p_resrc_assign_rec.ASSIGNMENT_ID IS NULL OR p_resrc_assign_rec.ASSIGNMENT_ID = Fnd_Api.G_MISS_NUM) THEN
541: -- OPERATION_SEQ_NUMBER

Line 587: Ahl_Debug_Pub.debug( ': Resource Type = ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);

583: END IF;
584: END IF;
585: END IF;
586: IF G_DEBUG='Y' THEN
587: Ahl_Debug_Pub.debug( ': Resource Type = ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
588: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_resrc_assign_rec.employee_name);
589: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_resrc_assign_rec.employee_number);
590: END IF;
591:

Line 588: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_resrc_assign_rec.employee_name);

584: END IF;
585: END IF;
586: IF G_DEBUG='Y' THEN
587: Ahl_Debug_Pub.debug( ': Resource Type = ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
588: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_resrc_assign_rec.employee_name);
589: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_resrc_assign_rec.employee_number);
590: END IF;
591:
592: IF p_resrc_assign_rec.RESOURCE_TYPE_CODE = 2 THEN

Line 589: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_resrc_assign_rec.employee_number);

585: END IF;
586: IF G_DEBUG='Y' THEN
587: Ahl_Debug_Pub.debug( ': Resource Type = ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
588: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_resrc_assign_rec.employee_name);
589: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_resrc_assign_rec.employee_number);
590: END IF;
591:
592: IF p_resrc_assign_rec.RESOURCE_TYPE_CODE = 2 THEN
593: -- EMPLOYEE_NUMBER

Line 595: Ahl_Debug_Pub.debug( ': Resource Type 11111= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);

591:
592: IF p_resrc_assign_rec.RESOURCE_TYPE_CODE = 2 THEN
593: -- EMPLOYEE_NUMBER
594: IF G_DEBUG='Y' THEN
595: Ahl_Debug_Pub.debug( ': Resource Type 11111= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
596: END IF;
597:
598: --IF (p_resrc_assign_rec.employee_id IS NULL) THEN
599: /*

Line 602: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);

598: --IF (p_resrc_assign_rec.employee_id IS NULL) THEN
599: /*
600: IF (p_resrc_assign_rec.EMPLOYEE_NUMBER IS NULL OR p_resrc_assign_rec.EMPLOYEE_NUMBER = Fnd_Api.G_MISS_CHAR) THEN
601: IF G_DEBUG='Y' THEN
602: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
603: END IF;
604:
605: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
606: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');

Line 615: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);

611: END IF; */
612: --END IF; -- p_resrc_assign_rec.employee_id IS NULL
613: IF (p_resrc_assign_rec.EMPLOYEE_ID IS NULL OR p_resrc_assign_rec.EMPLOYEE_ID = Fnd_Api.G_MISS_NUM) THEN
614: IF G_DEBUG='Y' THEN
615: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
616: END IF;
617:
618: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
619: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');

Line 775: Ahl_Debug_Pub.enable_debug;

771: BEGIN
772: --------------------- initialize -----------------------
773: -- Check if API is called in debug mode. If yes, enable debug.
774: IF G_DEBUG='Y' THEN
775: Ahl_Debug_Pub.enable_debug;
776: END IF;
777:
778: -- Debug info.
779: IF G_DEBUG='Y' THEN

Line 780: Ahl_Debug_Pub.debug( l_full_name ||':Start');

776: END IF;
777:
778: -- Debug info.
779: IF G_DEBUG='Y' THEN
780: Ahl_Debug_Pub.debug( l_full_name ||':Start');
781: END IF;
782:
783: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
784: Fnd_Msg_Pub.initialize;

Line 799: Ahl_Debug_Pub.debug( l_full_name ||':Check items');

795: x_return_status := Fnd_Api.g_ret_sts_success;
796:
797: ---------------------- validate ------------------------
798: IF G_DEBUG='Y' THEN
799: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
800: END IF;
801:
802: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
803: Check_Resrc_Assign_Items (

Line 906: Ahl_Debug_Pub.debug( 'l_assign_start_date'||l_assign_start_date);

902: FETCH c_emp_date INTO l_eff_st_date, l_eff_end_date;
903: CLOSE c_emp_date;
904:
905: IF G_DEBUG='Y' THEN
906: Ahl_Debug_Pub.debug( 'l_assign_start_date'||l_assign_start_date);
907: Ahl_Debug_Pub.debug( 'l_eff_st_date'||l_eff_st_date);
908:
909: END IF;
910: /*

Line 907: Ahl_Debug_Pub.debug( 'l_eff_st_date'||l_eff_st_date);

903: CLOSE c_emp_date;
904:
905: IF G_DEBUG='Y' THEN
906: Ahl_Debug_Pub.debug( 'l_assign_start_date'||l_assign_start_date);
907: Ahl_Debug_Pub.debug( 'l_eff_st_date'||l_eff_st_date);
908:
909: END IF;
910: /*
911: IF trunc(l_assign_start_date) < trunc(l_eff_st_date) THEN

Line 938: Ahl_Debug_Pub.debug( l_full_name ||':End');

934: p_data => x_msg_data
935: );
936:
937: IF G_DEBUG='Y' THEN
938: Ahl_Debug_Pub.debug( l_full_name ||':End');
939: END IF;
940:
941: -- Check if API is called in debug mode. If yes, disable debug.
942: IF G_DEBUG='Y' THEN

Line 943: Ahl_Debug_Pub.disable_debug;

939: END IF;
940:
941: -- Check if API is called in debug mode. If yes, disable debug.
942: IF G_DEBUG='Y' THEN
943: Ahl_Debug_Pub.disable_debug;
944: END IF;
945:
946: EXCEPTION
947: WHEN Fnd_Api.g_exc_error THEN

Line 1207: AHL_DEBUG_PUB.enable_debug;

1203: SAVEPOINT Create_Resrc_Assign;
1204:
1205: -- Check if API is called in debug mode. If yes, enable debug.
1206: IF G_DEBUG='Y' THEN
1207: AHL_DEBUG_PUB.enable_debug;
1208: END IF;
1209:
1210: -- Debug info.
1211: IF G_DEBUG='Y' THEN

Line 1212: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN_PVT. Create_Resrc_Assign','+PPResrc_Assign_Pvt+');

1208: END IF;
1209:
1210: -- Debug info.
1211: IF G_DEBUG='Y' THEN
1212: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN_PVT. Create_Resrc_Assign','+PPResrc_Assign_Pvt+');
1213: END IF;
1214:
1215: -- Standard call to check for call compatibility.
1216: IF FND_API.to_boolean(p_init_msg_list)

Line 1245: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);

1241: p_x_resrc_assign_tbl(i).employee_id := NULL;
1242: END IF;
1243:
1244: IF G_DEBUG='Y' THEN
1245: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
1246: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
1247: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
1248: END IF;
1249: --

Line 1246: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);

1242: END IF;
1243:
1244: IF G_DEBUG='Y' THEN
1245: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
1246: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
1247: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
1248: END IF;
1249: --
1250: IF p_x_resrc_assign_tbl(i).workorder_id IS NOT NULL THEN

Line 1247: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);

1243:
1244: IF G_DEBUG='Y' THEN
1245: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
1246: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
1247: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
1248: END IF;
1249: --
1250: IF p_x_resrc_assign_tbl(i).workorder_id IS NOT NULL THEN
1251: IF p_x_resrc_assign_tbl(i).operation_seq_number IS NOT NULL AND

Line 1259: AHL_DEBUG_PUB.debug(l_full_name || 'c_oper_resrc i.e Cursor not found');

1255: OPEN c_oper_resrc(p_x_resrc_assign_tbl(i).workorder_id, p_x_resrc_assign_tbl(i).operation_seq_number,
1256: p_x_resrc_assign_tbl(i).resource_seq_number);
1257: FETCH c_oper_resrc INTO l_oper_resrc_id, l_wo_operation_id,l_resource_id;
1258: IF c_oper_resrc%NOTFOUND THEN
1259: AHL_DEBUG_PUB.debug(l_full_name || 'c_oper_resrc i.e Cursor not found');
1260: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_REQ_NOT_EXISTS');
1261: Fnd_Msg_Pub.ADD;
1262: RAISE Fnd_Api.G_EXC_ERROR;
1263: END IF;

Line 1287: Ahl_Debug_Pub.debug( 'l_oper_resrc_id = ' || l_oper_resrc_id);

1283: -- rroy
1284: -- ACL Changes
1285:
1286: IF G_DEBUG='Y' THEN
1287: Ahl_Debug_Pub.debug( 'l_oper_resrc_id = ' || l_oper_resrc_id);
1288: Ahl_Debug_Pub.debug( 'l_wo_operation_id = ' || l_wo_operation_id);
1289: END IF;
1290:
1291: -- For Resource Type

Line 1288: Ahl_Debug_Pub.debug( 'l_wo_operation_id = ' || l_wo_operation_id);

1284: -- ACL Changes
1285:
1286: IF G_DEBUG='Y' THEN
1287: Ahl_Debug_Pub.debug( 'l_oper_resrc_id = ' || l_oper_resrc_id);
1288: Ahl_Debug_Pub.debug( 'l_wo_operation_id = ' || l_wo_operation_id);
1289: END IF;
1290:
1291: -- For Resource Type
1292: OPEN c_resource(p_x_resrc_assign_tbl(i).operation_seq_number, p_x_resrc_assign_tbl(i).resource_seq_number,

Line 1297: AHL_DEBUG_PUB.debug(l_full_name || 'c_resource i.e Cursor found');

1293: p_x_resrc_assign_tbl(i).workorder_id);
1294: FETCH c_resource INTO l_resource_type;
1295: IF c_resource%FOUND THEN
1296: IF G_DEBUG='Y' THEN
1297: AHL_DEBUG_PUB.debug(l_full_name || 'c_resource i.e Cursor found');
1298: END IF;
1299:
1300: CLOSE c_resource;
1301: p_x_resrc_assign_tbl(i).resource_type_code := l_resource_type;

Line 1304: AHL_DEBUG_PUB.debug(l_full_name || 'c_resource i.e Cursor not found');

1300: CLOSE c_resource;
1301: p_x_resrc_assign_tbl(i).resource_type_code := l_resource_type;
1302: ELSE
1303: IF G_DEBUG='Y' THEN
1304: AHL_DEBUG_PUB.debug(l_full_name || 'c_resource i.e Cursor not found');
1305: END IF;
1306:
1307: CLOSE c_resource;
1308: Fnd_Message.SET_NAME('AHL','AHL_PP_NO_RES_TYPE_FOUND');

Line 1313: Ahl_Debug_Pub.debug( 'l_resource_type = ' || l_resource_type);

1309: Fnd_Msg_Pub.ADD;
1310: RAISE Fnd_Api.G_EXC_ERROR;
1311: END IF;
1312:
1313: Ahl_Debug_Pub.debug( 'l_resource_type = ' || l_resource_type);
1314: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).instance_id = ' || p_x_resrc_assign_tbl(i).instance_id);
1315: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).serial_number = ' || p_x_resrc_assign_tbl(i).serial_number);
1316:
1317: -- R12

Line 1314: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).instance_id = ' || p_x_resrc_assign_tbl(i).instance_id);

1310: RAISE Fnd_Api.G_EXC_ERROR;
1311: END IF;
1312:
1313: Ahl_Debug_Pub.debug( 'l_resource_type = ' || l_resource_type);
1314: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).instance_id = ' || p_x_resrc_assign_tbl(i).instance_id);
1315: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).serial_number = ' || p_x_resrc_assign_tbl(i).serial_number);
1316:
1317: -- R12
1318: -- Alignment to resource requirement dates is no longer required since

Line 1315: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).serial_number = ' || p_x_resrc_assign_tbl(i).serial_number);

1311: END IF;
1312:
1313: Ahl_Debug_Pub.debug( 'l_resource_type = ' || l_resource_type);
1314: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).instance_id = ' || p_x_resrc_assign_tbl(i).instance_id);
1315: Ahl_Debug_Pub.debug( 'p_x_resrc_assign_tbl(i).serial_number = ' || p_x_resrc_assign_tbl(i).serial_number);
1316:
1317: -- R12
1318: -- Alignment to resource requirement dates is no longer required since
1319: -- assignment times can now be entered by the user

Line 1433: AHL_DEBUG_PUB.debug(l_full_name || 'Organization ID:' || p_x_resrc_assign_tbl(i).organization_id);

1429: p_x_resrc_assign_tbl(i).department_id := l_dept_id;
1430: p_x_resrc_assign_tbl(i).oper_resource_id := l_oper_resrc_id;
1431:
1432: IF (G_DEBUG = 'Y') THEN
1433: AHL_DEBUG_PUB.debug(l_full_name || 'Organization ID:' || p_x_resrc_assign_tbl(i).organization_id);
1434: AHL_DEBUG_PUB.debug(l_full_name || 'Dept ID:' || p_x_resrc_assign_tbl(i).department_id);
1435: AHL_DEBUG_PUB.debug(l_full_name || 'Serial:' || p_x_resrc_assign_tbl(i).serial_number);
1436: END IF;
1437:

Line 1434: AHL_DEBUG_PUB.debug(l_full_name || 'Dept ID:' || p_x_resrc_assign_tbl(i).department_id);

1430: p_x_resrc_assign_tbl(i).oper_resource_id := l_oper_resrc_id;
1431:
1432: IF (G_DEBUG = 'Y') THEN
1433: AHL_DEBUG_PUB.debug(l_full_name || 'Organization ID:' || p_x_resrc_assign_tbl(i).organization_id);
1434: AHL_DEBUG_PUB.debug(l_full_name || 'Dept ID:' || p_x_resrc_assign_tbl(i).department_id);
1435: AHL_DEBUG_PUB.debug(l_full_name || 'Serial:' || p_x_resrc_assign_tbl(i).serial_number);
1436: END IF;
1437:
1438: IF l_resource_type <> 2 THEN

Line 1435: AHL_DEBUG_PUB.debug(l_full_name || 'Serial:' || p_x_resrc_assign_tbl(i).serial_number);

1431:
1432: IF (G_DEBUG = 'Y') THEN
1433: AHL_DEBUG_PUB.debug(l_full_name || 'Organization ID:' || p_x_resrc_assign_tbl(i).organization_id);
1434: AHL_DEBUG_PUB.debug(l_full_name || 'Dept ID:' || p_x_resrc_assign_tbl(i).department_id);
1435: AHL_DEBUG_PUB.debug(l_full_name || 'Serial:' || p_x_resrc_assign_tbl(i).serial_number);
1436: END IF;
1437:
1438: IF l_resource_type <> 2 THEN
1439: /*IF ((l_Resrc_Assign_Rec.employee_number IS NOT NULL AND l_Resrc_Assign_Rec.employee_number <> Fnd_Api.G_MISS_CHAR)

Line 1469: Ahl_Debug_Pub.debug( l_full_name ||'Status Serial' || l_return_status );

1465: x_return_status => l_return_status,
1466: x_error_msg_code => l_msg_data);
1467:
1468: IF G_DEBUG='Y' THEN
1469: Ahl_Debug_Pub.debug( l_full_name ||'Status Serial' || l_return_status );
1470: END IF;
1471:
1472: IF NVL(l_return_status,'x') <> 'S'
1473: THEN

Line 1485: Ahl_Debug_Pub.debug(': Serial Id After= ' || p_x_resrc_assign_tbl(i).instance_id);

1481: p_x_resrc_assign_tbl(i).instance_id := l_instance_id;
1482: p_x_resrc_assign_tbl(i).oper_resource_id := l_oper_resrc_id;
1483:
1484: IF G_DEBUG='Y' THEN
1485: Ahl_Debug_Pub.debug(': Serial Id After= ' || p_x_resrc_assign_tbl(i).instance_id);
1486: END IF;
1487:
1488: END IF;
1489: IF G_DEBUG='Y' THEN

Line 1490: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_x_resrc_assign_tbl(i).employee_name);

1486: END IF;
1487:
1488: END IF;
1489: IF G_DEBUG='Y' THEN
1490: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_x_resrc_assign_tbl(i).employee_name);
1491: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);
1492: END IF;
1493:
1494: IF l_resource_type = 2 THEN

Line 1491: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);

1487:
1488: END IF;
1489: IF G_DEBUG='Y' THEN
1490: Ahl_Debug_Pub.debug( ': Employee Name = ' || p_x_resrc_assign_tbl(i).employee_name);
1491: Ahl_Debug_Pub.debug( ': EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);
1492: END IF;
1493:
1494: IF l_resource_type = 2 THEN
1495: IF G_DEBUG='Y' THEN

Line 1496: AHL_DEBUG_PUB.debug(l_full_name || 'RESOURCE TYPE in Cursor' || l_resource_type);

1492: END IF;
1493:
1494: IF l_resource_type = 2 THEN
1495: IF G_DEBUG='Y' THEN
1496: AHL_DEBUG_PUB.debug(l_full_name || 'RESOURCE TYPE in Cursor' || l_resource_type);
1497: END IF;
1498:
1499: /*IF (l_Resrc_Assign_Rec.serial_number IS NOT NULL AND l_Resrc_Assign_Rec.serial_number <> Fnd_Api.G_MISS_CHAR)
1500: THEN

Line 1506: AHL_DEBUG_PUB.debug(l_full_name || 'RESOURCE TYPE in record -- ' || p_x_resrc_assign_tbl(i).resource_type_code);

1502: Fnd_Msg_Pub.ADD;
1503: RAISE Fnd_Api.G_EXC_ERROR;
1504: END IF;*/
1505: IF G_DEBUG='Y' THEN
1506: AHL_DEBUG_PUB.debug(l_full_name || 'RESOURCE TYPE in record -- ' || p_x_resrc_assign_tbl(i).resource_type_code);
1507: END IF;
1508:
1509: -- For Employee Number
1510: IF (p_x_resrc_assign_tbl(i).employee_number IS NOT NULL AND p_x_resrc_assign_tbl(i).employee_number <> Fnd_Api.G_MISS_CHAR)

Line 1513: Ahl_Debug_Pub.debug(': Inside EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);

1509: -- For Employee Number
1510: IF (p_x_resrc_assign_tbl(i).employee_number IS NOT NULL AND p_x_resrc_assign_tbl(i).employee_number <> Fnd_Api.G_MISS_CHAR)
1511: THEN
1512: IF G_DEBUG='Y' THEN
1513: Ahl_Debug_Pub.debug(': Inside EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);
1514: END IF;
1515:
1516: Check_Employee_Number_Or_Id
1517: (p_employee_id => p_x_resrc_assign_tbl(i).employee_id,

Line 1541: Ahl_Debug_Pub.debug( l_full_name ||': Inside Employee Name = ' || p_x_resrc_assign_tbl(i).employee_name);

1537: -- For Employee Name
1538: IF (p_x_resrc_assign_tbl(i).employee_name IS NOT NULL AND p_x_resrc_assign_tbl(i).employee_name <> Fnd_Api.G_MISS_CHAR)
1539: THEN
1540: IF G_DEBUG='Y' THEN
1541: Ahl_Debug_Pub.debug( l_full_name ||': Inside Employee Name = ' || p_x_resrc_assign_tbl(i).employee_name);
1542: END IF;
1543: Check_Employee_Name_Or_Id
1544: (p_employee_id => l_employee_id,
1545: p_employee_number => p_x_resrc_assign_tbl(i).employee_number,

Line 1590: Ahl_Debug_Pub.debug(l_full_name || ': Instance Id After= ' || p_x_resrc_assign_tbl(i).instance_id);

1586: END IF;
1587: END IF;
1588:
1589: IF G_DEBUG='Y' THEN
1590: Ahl_Debug_Pub.debug(l_full_name || ': Instance Id After= ' || p_x_resrc_assign_tbl(i).instance_id);
1591: Ahl_Debug_Pub.debug(l_full_name || ': Employee Id= ' || p_x_resrc_assign_tbl(i).employee_id);
1592: END IF;
1593:
1594: -------------------------------- Validate -----------------------------------------

Line 1591: Ahl_Debug_Pub.debug(l_full_name || ': Employee Id= ' || p_x_resrc_assign_tbl(i).employee_id);

1587: END IF;
1588:
1589: IF G_DEBUG='Y' THEN
1590: Ahl_Debug_Pub.debug(l_full_name || ': Instance Id After= ' || p_x_resrc_assign_tbl(i).instance_id);
1591: Ahl_Debug_Pub.debug(l_full_name || ': Employee Id= ' || p_x_resrc_assign_tbl(i).employee_id);
1592: END IF;
1593:
1594: -------------------------------- Validate -----------------------------------------
1595: IF G_DEBUG='Y' THEN

Line 1596: Ahl_Debug_Pub.debug( l_full_name ||': Before Validate Assignment');

1592: END IF;
1593:
1594: -------------------------------- Validate -----------------------------------------
1595: IF G_DEBUG='Y' THEN
1596: Ahl_Debug_Pub.debug( l_full_name ||': Before Validate Assignment');
1597: END IF;
1598:
1599: Validate_Resrc_Assign (
1600: p_api_version => l_api_version,

Line 1627: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );

1623: FOR i IN p_x_resrc_assign_tbl.FIRST..p_x_resrc_assign_tbl.LAST
1624: LOOP
1625: --
1626: IF G_DEBUG='Y' THEN
1627: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );

Line 1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );

1624: LOOP
1625: --
1626: IF G_DEBUG='Y' THEN
1627: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
1632: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );

Line 1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );

1625: --
1626: IF G_DEBUG='Y' THEN
1627: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
1632: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
1633:

Line 1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );

1626: IF G_DEBUG='Y' THEN
1627: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
1632: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
1633:
1634: END IF;

Line 1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );

1627: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
1632: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
1633:
1634: END IF;
1635:

Line 1632: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );

1628: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
1629: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
1630: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
1631: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
1632: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
1633:
1634: END IF;
1635:
1636: --

Line 1901: Ahl_Debug_Pub.debug( 'End of public api Create Resource Reqst','+PPResrc_Assign_Pvt+');

1897: COMMIT;
1898: END IF;
1899: -- Debug info
1900: IF G_DEBUG='Y' THEN
1901: Ahl_Debug_Pub.debug( 'End of public api Create Resource Reqst','+PPResrc_Assign_Pvt+');
1902: -- Check if API is called in debug mode. If yes, disable debug.
1903: Ahl_Debug_Pub.disable_debug;
1904: END IF;
1905:

Line 1903: Ahl_Debug_Pub.disable_debug;

1899: -- Debug info
1900: IF G_DEBUG='Y' THEN
1901: Ahl_Debug_Pub.debug( 'End of public api Create Resource Reqst','+PPResrc_Assign_Pvt+');
1902: -- Check if API is called in debug mode. If yes, disable debug.
1903: Ahl_Debug_Pub.disable_debug;
1904: END IF;
1905:
1906: EXCEPTION
1907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1915: AHL_DEBUG_PUB.log_app_messages (

1911: p_count => x_msg_count,
1912: p_data => x_msg_data);
1913:
1914: IF G_DEBUG='Y' THEN
1915: AHL_DEBUG_PUB.log_app_messages (
1916: x_msg_count, x_msg_data, 'ERROR' );
1917: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1918: -- Check if API is called in debug mode. If yes, disable debug.
1919: AHL_DEBUG_PUB.disable_debug;

Line 1917: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');

1913:
1914: IF G_DEBUG='Y' THEN
1915: AHL_DEBUG_PUB.log_app_messages (
1916: x_msg_count, x_msg_data, 'ERROR' );
1917: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1918: -- Check if API is called in debug mode. If yes, disable debug.
1919: AHL_DEBUG_PUB.disable_debug;
1920: END IF;
1921:

Line 1919: AHL_DEBUG_PUB.disable_debug;

1915: AHL_DEBUG_PUB.log_app_messages (
1916: x_msg_count, x_msg_data, 'ERROR' );
1917: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1918: -- Check if API is called in debug mode. If yes, disable debug.
1919: AHL_DEBUG_PUB.disable_debug;
1920: END IF;
1921:
1922: WHEN FND_API.G_EXC_ERROR THEN
1923: ROLLBACK TO Create_Resrc_Assign;

Line 1930: AHL_DEBUG_PUB.log_app_messages (

1926: p_count => x_msg_count,
1927: p_data => X_msg_data);
1928: IF G_DEBUG='Y' THEN
1929: -- Debug info.
1930: AHL_DEBUG_PUB.log_app_messages (
1931: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1932: AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1933: -- Check if API is called in debug mode. If yes, disable debug.
1934: AHL_DEBUG_PUB.disable_debug;

Line 1932: AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');

1928: IF G_DEBUG='Y' THEN
1929: -- Debug info.
1930: AHL_DEBUG_PUB.log_app_messages (
1931: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1932: AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1933: -- Check if API is called in debug mode. If yes, disable debug.
1934: AHL_DEBUG_PUB.disable_debug;
1935: END IF;
1936:

Line 1934: AHL_DEBUG_PUB.disable_debug;

1930: AHL_DEBUG_PUB.log_app_messages (
1931: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
1932: AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1933: -- Check if API is called in debug mode. If yes, disable debug.
1934: AHL_DEBUG_PUB.disable_debug;
1935: END IF;
1936:
1937: WHEN OTHERS THEN
1938: ROLLBACK TO Create_Resrc_Assign;

Line 1952: AHL_DEBUG_PUB.log_app_messages (

1948: p_data => X_msg_data);
1949:
1950: IF G_DEBUG='Y' THEN
1951: -- Debug info.
1952: AHL_DEBUG_PUB.log_app_messages (
1953: x_msg_count, x_msg_data, 'SQL ERROR' );
1954: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1955: -- Check if API is called in debug mode. If yes, disable debug.
1956: AHL_DEBUG_PUB.disable_debug;

Line 1954: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');

1950: IF G_DEBUG='Y' THEN
1951: -- Debug info.
1952: AHL_DEBUG_PUB.log_app_messages (
1953: x_msg_count, x_msg_data, 'SQL ERROR' );
1954: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1955: -- Check if API is called in debug mode. If yes, disable debug.
1956: AHL_DEBUG_PUB.disable_debug;
1957: END IF;
1958:

Line 1956: AHL_DEBUG_PUB.disable_debug;

1952: AHL_DEBUG_PUB.log_app_messages (
1953: x_msg_count, x_msg_data, 'SQL ERROR' );
1954: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Create Resource Reqst','+PPResrc_Assign_Pvt+');
1955: -- Check if API is called in debug mode. If yes, disable debug.
1956: AHL_DEBUG_PUB.disable_debug;
1957: END IF;
1958:
1959: END Create_Resrc_Assign;
1960:

Line 2173: AHL_DEBUG_PUB.enable_debug;

2169: SAVEPOINT Update_Resrc_Assign;
2170:
2171: -- Check if API is called in debug mode. If yes, enable debug.
2172: IF G_DEBUG='Y' THEN
2173: AHL_DEBUG_PUB.enable_debug;
2174: END IF;
2175: -- Debug info.
2176: IF G_DEBUG='Y' THEN
2177: AHL_DEBUG_PUB.debug( 'Enter ahl_pp_assign_pvt. Update Resource reqst','+PPResrc_Assign_Pvt+');

Line 2177: AHL_DEBUG_PUB.debug( 'Enter ahl_pp_assign_pvt. Update Resource reqst','+PPResrc_Assign_Pvt+');

2173: AHL_DEBUG_PUB.enable_debug;
2174: END IF;
2175: -- Debug info.
2176: IF G_DEBUG='Y' THEN
2177: AHL_DEBUG_PUB.debug( 'Enter ahl_pp_assign_pvt. Update Resource reqst','+PPResrc_Assign_Pvt+');
2178: END IF;
2179:
2180: -- Standard call to check for call compatibility.
2181: IF FND_API.to_boolean(p_init_msg_list)

Line 2212: AHL_DEBUG_PUB.debug( 'Assignment_id' || p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);

2208: p_x_resrc_assign_tbl(i).employee_id := NULL;
2209: END IF;
2210: --
2211: IF G_DEBUG='Y' THEN
2212: AHL_DEBUG_PUB.debug( 'Assignment_id' || p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);
2213: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
2214: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
2215: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
2216: END IF;

Line 2213: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);

2209: END IF;
2210: --
2211: IF G_DEBUG='Y' THEN
2212: AHL_DEBUG_PUB.debug( 'Assignment_id' || p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);
2213: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
2214: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
2215: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
2216: END IF;
2217: -- For Resource Type

Line 2214: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);

2210: --
2211: IF G_DEBUG='Y' THEN
2212: AHL_DEBUG_PUB.debug( 'Assignment_id' || p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);
2213: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
2214: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
2215: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
2216: END IF;
2217: -- For Resource Type
2218: OPEN c_resource(p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);

Line 2215: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);

2211: IF G_DEBUG='Y' THEN
2212: AHL_DEBUG_PUB.debug( 'Assignment_id' || p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);
2213: AHL_DEBUG_PUB.debug( 'Workorder ID = ' || p_x_resrc_assign_tbl(i).workorder_id);
2214: AHL_DEBUG_PUB.debug( 'Oper Seq Num = ' || p_x_resrc_assign_tbl(i).operation_seq_number);
2215: AHL_DEBUG_PUB.debug( 'Resrc Seq Num = ' || p_x_resrc_assign_tbl(i).resource_seq_number);
2216: END IF;
2217: -- For Resource Type
2218: OPEN c_resource(p_x_resrc_assign_tbl(i).ASSIGNMENT_ID);
2219: FETCH c_resource INTO c_resource_rec;

Line 2228: AHL_DEBUG_PUB.debug(l_full_name || 'Operation Resource Id = ' || p_x_resrc_assign_tbl(i).oper_resource_id);

2224: p_x_resrc_assign_tbl(i).oper_resource_id := c_resource_rec.requirement_id;
2225: p_x_resrc_assign_tbl(i).workorder_id := c_resource_rec.job_id;
2226:
2227: IF G_DEBUG='Y' THEN
2228: AHL_DEBUG_PUB.debug(l_full_name || 'Operation Resource Id = ' || p_x_resrc_assign_tbl(i).oper_resource_id);
2229: AHL_DEBUG_PUB.debug(l_full_name || 'Resource Type = ' || l_resource_type);
2230: END IF;
2231:
2232: OPEN c_work (p_x_resrc_assign_tbl(i).workorder_id,

Line 2229: AHL_DEBUG_PUB.debug(l_full_name || 'Resource Type = ' || l_resource_type);

2225: p_x_resrc_assign_tbl(i).workorder_id := c_resource_rec.job_id;
2226:
2227: IF G_DEBUG='Y' THEN
2228: AHL_DEBUG_PUB.debug(l_full_name || 'Operation Resource Id = ' || p_x_resrc_assign_tbl(i).oper_resource_id);
2229: AHL_DEBUG_PUB.debug(l_full_name || 'Resource Type = ' || l_resource_type);
2230: END IF;
2231:
2232: OPEN c_work (p_x_resrc_assign_tbl(i).workorder_id,
2233: p_x_resrc_assign_tbl(i).operation_seq_number);

Line 2389: Ahl_Debug_Pub.debug( l_full_name ||'Status Serial' || l_return_status );

2385: x_return_status => l_return_status,
2386: x_error_msg_code => l_msg_data);
2387:
2388: IF G_DEBUG='Y' THEN
2389: Ahl_Debug_Pub.debug( l_full_name ||'Status Serial' || l_return_status );
2390: END IF;
2391:
2392: IF NVL(l_return_status,'x') <> 'S'
2393: THEN

Line 2404: Ahl_Debug_Pub.debug( l_full_name ||': Serial Id After= ' || p_x_resrc_assign_tbl(i).instance_id);

2400: --Assign the returned value
2401: p_x_resrc_assign_tbl(i).instance_id := l_instance_id;
2402:
2403: IF G_DEBUG='Y' THEN
2404: Ahl_Debug_Pub.debug( l_full_name ||': Serial Id After= ' || p_x_resrc_assign_tbl(i).instance_id);
2405: END IF;
2406:
2407: END IF;
2408: IF G_DEBUG='Y' THEN

Line 2409: AHL_DEBUG_PUB.debug('Resource Type' || p_x_resrc_assign_tbl(i).resource_type_name);

2405: END IF;
2406:
2407: END IF;
2408: IF G_DEBUG='Y' THEN
2409: AHL_DEBUG_PUB.debug('Resource Type' || p_x_resrc_assign_tbl(i).resource_type_name);
2410: AHL_DEBUG_PUB.debug('Employee Number' || p_x_resrc_assign_tbl(i).employee_number);
2411: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2412: END IF;
2413:

Line 2410: AHL_DEBUG_PUB.debug('Employee Number' || p_x_resrc_assign_tbl(i).employee_number);

2406:
2407: END IF;
2408: IF G_DEBUG='Y' THEN
2409: AHL_DEBUG_PUB.debug('Resource Type' || p_x_resrc_assign_tbl(i).resource_type_name);
2410: AHL_DEBUG_PUB.debug('Employee Number' || p_x_resrc_assign_tbl(i).employee_number);
2411: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2412: END IF;
2413:
2414: IF l_resource_type = 2 THEN

Line 2411: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);

2407: END IF;
2408: IF G_DEBUG='Y' THEN
2409: AHL_DEBUG_PUB.debug('Resource Type' || p_x_resrc_assign_tbl(i).resource_type_name);
2410: AHL_DEBUG_PUB.debug('Employee Number' || p_x_resrc_assign_tbl(i).employee_number);
2411: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2412: END IF;
2413:
2414: IF l_resource_type = 2 THEN
2415:

Line 2478: AHL_DEBUG_PUB.debug('Resource id' || l_resource_id);

2474: --Assign
2475: p_x_resrc_assign_tbl(i).employee_id := l_employee_id;
2476: --
2477: IF G_DEBUG='Y' THEN
2478: AHL_DEBUG_PUB.debug('Resource id' || l_resource_id);
2479: AHL_DEBUG_PUB.debug('Department id' || p_x_resrc_assign_tbl(i).department_id);
2480: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2481: END IF;
2482:

Line 2479: AHL_DEBUG_PUB.debug('Department id' || p_x_resrc_assign_tbl(i).department_id);

2475: p_x_resrc_assign_tbl(i).employee_id := l_employee_id;
2476: --
2477: IF G_DEBUG='Y' THEN
2478: AHL_DEBUG_PUB.debug('Resource id' || l_resource_id);
2479: AHL_DEBUG_PUB.debug('Department id' || p_x_resrc_assign_tbl(i).department_id);
2480: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2481: END IF;
2482:
2483: -- Get instance id

Line 2480: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);

2476: --
2477: IF G_DEBUG='Y' THEN
2478: AHL_DEBUG_PUB.debug('Resource id' || l_resource_id);
2479: AHL_DEBUG_PUB.debug('Department id' || p_x_resrc_assign_tbl(i).department_id);
2480: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2481: END IF;
2482:
2483: -- Get instance id
2484: IF (p_x_resrc_assign_tbl(i).employee_id IS NOT NULL AND p_x_resrc_assign_tbl(i).employee_id <> Fnd_Api.G_MISS_NUM)

Line 2530: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );

2526: FOR i IN p_x_resrc_assign_tbl.FIRST..p_x_resrc_assign_tbl.LAST
2527: LOOP
2528:
2529: IF G_DEBUG='Y' THEN
2530: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );

Line 2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );

2527: LOOP
2528:
2529: IF G_DEBUG='Y' THEN
2530: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
2535: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );

Line 2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );

2528:
2529: IF G_DEBUG='Y' THEN
2530: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
2535: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
2536:

Line 2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );

2529: IF G_DEBUG='Y' THEN
2530: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
2535: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
2536:
2537: END IF;

Line 2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );

2530: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );
2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
2535: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
2536:
2537: END IF;
2538:

Line 2535: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );

2531: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).organization_id' ||p_x_resrc_assign_tbl(i).organization_id );
2532: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).operation_seq_number' ||p_x_resrc_assign_tbl(i).operation_seq_number );
2533: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).resource_seq_number' ||p_x_resrc_assign_tbl(i).resource_seq_number );
2534: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).instance_id' ||p_x_resrc_assign_tbl(i).instance_id );
2535: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).serial_number' ||p_x_resrc_assign_tbl(i).serial_number );
2536:
2537: END IF;
2538:
2539: --

Line 2583: AHL_DEBUG_PUB.debug(' Record OVN = ' || p_x_resrc_assign_tbl(i).object_version_number);

2579: FETCH c_assign INTO c_assign_rec;
2580: CLOSE c_assign;
2581:
2582: IF G_DEBUG='Y' THEN
2583: AHL_DEBUG_PUB.debug(' Record OVN = ' || p_x_resrc_assign_tbl(i).object_version_number);
2584: AHL_DEBUG_PUB.debug(' Cursor OVN = ' || c_assign_rec.object_version_number);
2585: END IF;
2586:
2587: -- Check Object version number.

Line 2584: AHL_DEBUG_PUB.debug(' Cursor OVN = ' || c_assign_rec.object_version_number);

2580: CLOSE c_assign;
2581:
2582: IF G_DEBUG='Y' THEN
2583: AHL_DEBUG_PUB.debug(' Record OVN = ' || p_x_resrc_assign_tbl(i).object_version_number);
2584: AHL_DEBUG_PUB.debug(' Cursor OVN = ' || c_assign_rec.object_version_number);
2585: END IF;
2586:
2587: -- Check Object version number.
2588: IF (p_x_resrc_assign_tbl(i).object_version_number <> c_assign_rec.object_version_number) THEN

Line 2589: AHL_DEBUG_PUB.debug(l_full_name || 'Inside OVN comparison');

2585: END IF;
2586:
2587: -- Check Object version number.
2588: IF (p_x_resrc_assign_tbl(i).object_version_number <> c_assign_rec.object_version_number) THEN
2589: AHL_DEBUG_PUB.debug(l_full_name || 'Inside OVN comparison');
2590: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2591: Fnd_Msg_Pub.ADD;
2592: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2593: END IF;

Line 2783: AHL_DEBUG_PUB.debug(l_full_name || ' Before calling Update Row procedure');

2779: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2780: END IF;
2781:
2782: IF G_DEBUG='Y' THEN
2783: AHL_DEBUG_PUB.debug(l_full_name || ' Before calling Update Row procedure');
2784: END IF;
2785:
2786: -- Create Record in schedule Resources
2787: Update_Row (

Line 2821: AHL_DEBUG_PUB.debug(l_full_name || ' After calling Update Row procedure');

2817: );
2818: END IF;
2819:
2820: IF G_DEBUG='Y' THEN
2821: AHL_DEBUG_PUB.debug(l_full_name || ' After calling Update Row procedure');
2822: AHL_DEBUG_PUB.debug(l_full_name || ' Assign Start Date = ' || p_x_resrc_assign_tbl(i).assign_start_date);
2823: AHL_DEBUG_PUB.debug(l_full_name || ' Assign End Date = ' || p_x_resrc_assign_tbl(i).assign_end_date);
2824: END IF;
2825: END LOOP;

Line 2822: AHL_DEBUG_PUB.debug(l_full_name || ' Assign Start Date = ' || p_x_resrc_assign_tbl(i).assign_start_date);

2818: END IF;
2819:
2820: IF G_DEBUG='Y' THEN
2821: AHL_DEBUG_PUB.debug(l_full_name || ' After calling Update Row procedure');
2822: AHL_DEBUG_PUB.debug(l_full_name || ' Assign Start Date = ' || p_x_resrc_assign_tbl(i).assign_start_date);
2823: AHL_DEBUG_PUB.debug(l_full_name || ' Assign End Date = ' || p_x_resrc_assign_tbl(i).assign_end_date);
2824: END IF;
2825: END LOOP;
2826: END IF;

Line 2823: AHL_DEBUG_PUB.debug(l_full_name || ' Assign End Date = ' || p_x_resrc_assign_tbl(i).assign_end_date);

2819:
2820: IF G_DEBUG='Y' THEN
2821: AHL_DEBUG_PUB.debug(l_full_name || ' After calling Update Row procedure');
2822: AHL_DEBUG_PUB.debug(l_full_name || ' Assign Start Date = ' || p_x_resrc_assign_tbl(i).assign_start_date);
2823: AHL_DEBUG_PUB.debug(l_full_name || ' Assign End Date = ' || p_x_resrc_assign_tbl(i).assign_end_date);
2824: END IF;
2825: END LOOP;
2826: END IF;
2827:

Line 2845: Ahl_Debug_Pub.debug( 'End of public api Update Resource Reqst','+PPResrc_Assign_Pvt+');

2841: COMMIT;
2842: END IF;
2843: -- Debug info
2844: IF G_DEBUG='Y' THEN
2845: Ahl_Debug_Pub.debug( 'End of public api Update Resource Reqst','+PPResrc_Assign_Pvt+');
2846: -- Check if API is called in debug mode. If yes, disable debug.
2847: Ahl_Debug_Pub.disable_debug;
2848: --
2849: END IF;

Line 2847: Ahl_Debug_Pub.disable_debug;

2843: -- Debug info
2844: IF G_DEBUG='Y' THEN
2845: Ahl_Debug_Pub.debug( 'End of public api Update Resource Reqst','+PPResrc_Assign_Pvt+');
2846: -- Check if API is called in debug mode. If yes, disable debug.
2847: Ahl_Debug_Pub.disable_debug;
2848: --
2849: END IF;
2850: EXCEPTION
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2858: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR' );

2854: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2855: p_count => x_msg_count,
2856: p_data => x_msg_data);
2857: IF G_DEBUG='Y' THEN
2858: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR' );
2859:
2860: -- Check if API is called in debug mode. If yes, disable debug.
2861: AHL_DEBUG_PUB.disable_debug;
2862: --

Line 2861: AHL_DEBUG_PUB.disable_debug;

2857: IF G_DEBUG='Y' THEN
2858: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR' );
2859:
2860: -- Check if API is called in debug mode. If yes, disable debug.
2861: AHL_DEBUG_PUB.disable_debug;
2862: --
2863: END IF;
2864: WHEN FND_API.G_EXC_ERROR THEN
2865: ROLLBACK TO update_Resrc_Assign;

Line 2872: AHL_DEBUG_PUB.log_app_messages (

2868: p_count => x_msg_count,
2869: p_data => X_msg_data);
2870: IF G_DEBUG='Y' THEN
2871: -- Debug info.
2872: AHL_DEBUG_PUB.log_app_messages (
2873: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2874: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Update Resource Reqst','+PPResrc_Assign_Pvt+');
2875: -- Check if API is called in debug mode. If yes, disable debug.
2876: AHL_DEBUG_PUB.disable_debug;

Line 2874: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Update Resource Reqst','+PPResrc_Assign_Pvt+');

2870: IF G_DEBUG='Y' THEN
2871: -- Debug info.
2872: AHL_DEBUG_PUB.log_app_messages (
2873: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2874: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Update Resource Reqst','+PPResrc_Assign_Pvt+');
2875: -- Check if API is called in debug mode. If yes, disable debug.
2876: AHL_DEBUG_PUB.disable_debug;
2877: END IF;
2878: WHEN OTHERS THEN

Line 2876: AHL_DEBUG_PUB.disable_debug;

2872: AHL_DEBUG_PUB.log_app_messages (
2873: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2874: --AHL_DEBUG_PUB.debug( 'ahl_ltp_pp_Resources_pvt. Update Resource Reqst','+PPResrc_Assign_Pvt+');
2875: -- Check if API is called in debug mode. If yes, disable debug.
2876: AHL_DEBUG_PUB.disable_debug;
2877: END IF;
2878: WHEN OTHERS THEN
2879: ROLLBACK TO update_Resrc_Assign;
2880: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2893: AHL_DEBUG_PUB.log_app_messages (

2889: p_data => X_msg_data);
2890:
2891: IF G_DEBUG='Y' THEN
2892: -- Debug info.
2893: AHL_DEBUG_PUB.log_app_messages (
2894: x_msg_count, x_msg_data, 'SQL ERROR' );
2895: -- Check if API is called in debug mode. If yes, disable debug.
2896: AHL_DEBUG_PUB.disable_debug;
2897: END IF;

Line 2896: AHL_DEBUG_PUB.disable_debug;

2892: -- Debug info.
2893: AHL_DEBUG_PUB.log_app_messages (
2894: x_msg_count, x_msg_data, 'SQL ERROR' );
2895: -- Check if API is called in debug mode. If yes, disable debug.
2896: AHL_DEBUG_PUB.disable_debug;
2897: END IF;
2898: END Update_Resrc_Assign;
2899: --
2900: PROCEDURE Remove_Resource_Assignment (

Line 2965: Ahl_Debug_Pub.enable_debug;

2961: SAVEPOINT Remove_Resource_Assignment;
2962:
2963: -- Check if API is called in debug mode. If yes, enable debug.
2964: IF G_DEBUG='Y' THEN
2965: Ahl_Debug_Pub.enable_debug;
2966: END IF;
2967: -- Debug info.
2968: IF G_DEBUG='Y' THEN
2969: Ahl_Debug_Pub.debug( 'enter ahl_ltp_reqst_matrl_pvt Remove Resource Assignment ','+MAATP+');

Line 2969: Ahl_Debug_Pub.debug( 'enter ahl_ltp_reqst_matrl_pvt Remove Resource Assignment ','+MAATP+');

2965: Ahl_Debug_Pub.enable_debug;
2966: END IF;
2967: -- Debug info.
2968: IF G_DEBUG='Y' THEN
2969: Ahl_Debug_Pub.debug( 'enter ahl_ltp_reqst_matrl_pvt Remove Resource Assignment ','+MAATP+');
2970: END IF;
2971: -- Standard call to check for call compatibility.
2972: IF Fnd_Api.to_boolean(p_init_msg_list)
2973: THEN

Line 3124: Ahl_Debug_Pub.debug( 'End of private api Remove Resource Assignment ','+MAMRP+');

3120: COMMIT;
3121: END IF;
3122: -- Debug info
3123: IF G_DEBUG='Y' THEN
3124: Ahl_Debug_Pub.debug( 'End of private api Remove Resource Assignment ','+MAMRP+');
3125: -- Check if API is called in debug mode. If yes, disable debug.
3126: Ahl_Debug_Pub.disable_debug;
3127: --
3128: END IF;

Line 3126: Ahl_Debug_Pub.disable_debug;

3122: -- Debug info
3123: IF G_DEBUG='Y' THEN
3124: Ahl_Debug_Pub.debug( 'End of private api Remove Resource Assignment ','+MAMRP+');
3125: -- Check if API is called in debug mode. If yes, disable debug.
3126: Ahl_Debug_Pub.disable_debug;
3127: --
3128: END IF;
3129: EXCEPTION
3130: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 3137: Ahl_Debug_Pub.log_app_messages (

3133: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3134: p_count => x_msg_count,
3135: p_data => x_msg_data);
3136: IF G_DEBUG='Y' THEN
3137: Ahl_Debug_Pub.log_app_messages (
3138: x_msg_count, x_msg_data, 'ERROR' );
3139: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');
3140: -- Check if API is called in debug mode. If yes, disable debug.
3141: Ahl_Debug_Pub.disable_debug;

Line 3139: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');

3135: p_data => x_msg_data);
3136: IF G_DEBUG='Y' THEN
3137: Ahl_Debug_Pub.log_app_messages (
3138: x_msg_count, x_msg_data, 'ERROR' );
3139: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');
3140: -- Check if API is called in debug mode. If yes, disable debug.
3141: Ahl_Debug_Pub.disable_debug;
3142: END IF;
3143:

Line 3141: Ahl_Debug_Pub.disable_debug;

3137: Ahl_Debug_Pub.log_app_messages (
3138: x_msg_count, x_msg_data, 'ERROR' );
3139: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');
3140: -- Check if API is called in debug mode. If yes, disable debug.
3141: Ahl_Debug_Pub.disable_debug;
3142: END IF;
3143:
3144: WHEN Fnd_Api.G_EXC_ERROR THEN
3145: ROLLBACK TO remove_Resource_Assignment;

Line 3152: Ahl_Debug_Pub.log_app_messages (

3148: p_count => x_msg_count,
3149: p_data => X_msg_data);
3150: IF G_DEBUG='Y' THEN
3151: -- Debug info.
3152: Ahl_Debug_Pub.log_app_messages (
3153: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3154: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');
3155: -- Check if API is called in debug mode. If yes, disable debug.
3156: Ahl_Debug_Pub.disable_debug;

Line 3154: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');

3150: IF G_DEBUG='Y' THEN
3151: -- Debug info.
3152: Ahl_Debug_Pub.log_app_messages (
3153: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3154: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');
3155: -- Check if API is called in debug mode. If yes, disable debug.
3156: Ahl_Debug_Pub.disable_debug;
3157: END IF;
3158:

Line 3156: Ahl_Debug_Pub.disable_debug;

3152: Ahl_Debug_Pub.log_app_messages (
3153: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3154: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MAMRP+');
3155: -- Check if API is called in debug mode. If yes, disable debug.
3156: Ahl_Debug_Pub.disable_debug;
3157: END IF;
3158:
3159: WHEN OTHERS THEN
3160: ROLLBACK TO remove_Resource_Assignment;

Line 3173: Ahl_Debug_Pub.log_app_messages (

3169: p_count => x_msg_count,
3170: p_data => X_msg_data);
3171: IF G_DEBUG='Y' THEN
3172: -- Debug info.
3173: Ahl_Debug_Pub.log_app_messages (
3174: x_msg_count, x_msg_data, 'SQL ERROR' );
3175: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MTMRP+');
3176: -- Check if API is called in debug mode. If yes, disable debug.
3177: Ahl_Debug_Pub.disable_debug;

Line 3175: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MTMRP+');

3171: IF G_DEBUG='Y' THEN
3172: -- Debug info.
3173: Ahl_Debug_Pub.log_app_messages (
3174: x_msg_count, x_msg_data, 'SQL ERROR' );
3175: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MTMRP+');
3176: -- Check if API is called in debug mode. If yes, disable debug.
3177: Ahl_Debug_Pub.disable_debug;
3178: END IF;
3179: END Remove_Resource_Assignment;

Line 3177: Ahl_Debug_Pub.disable_debug;

3173: Ahl_Debug_Pub.log_app_messages (
3174: x_msg_count, x_msg_data, 'SQL ERROR' );
3175: --Ahl_Debug_Pub.debug( 'ahl_ltp_reqst_matrl_pvt. Remove Resource Assignment ','+MTMRP+');
3176: -- Check if API is called in debug mode. If yes, disable debug.
3177: Ahl_Debug_Pub.disable_debug;
3178: END IF;
3179: END Remove_Resource_Assignment;
3180:
3181: -----------------------------------------------------------------------------------

Line 3240: AHL_DEBUG_PUB.enable_debug;

3236: SAVEPOINT Process_Resrc_Assign;
3237:
3238: -- Check if API is called in debug mode. If yes, enable debug.
3239: IF G_DEBUG='Y' THEN
3240: AHL_DEBUG_PUB.enable_debug;
3241: END IF;
3242: -- Debug info.
3243: IF G_DEBUG='Y' THEN
3244: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN.process_resrc_assign','+PPResrc_Assign_Pvt+');

Line 3244: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN.process_resrc_assign','+PPResrc_Assign_Pvt+');

3240: AHL_DEBUG_PUB.enable_debug;
3241: END IF;
3242: -- Debug info.
3243: IF G_DEBUG='Y' THEN
3244: AHL_DEBUG_PUB.debug( 'Enter AHL_PP_RESRC_ASSIGN.process_resrc_assign','+PPResrc_Assign_Pvt+');
3245: END IF;
3246: -- Standard call to check for call compatibility.
3247: IF FND_API.to_boolean(p_init_msg_list)
3248: THEN

Line 3270: Ahl_Debug_Pub.debug( 'Start of pvt api for create Resource Assignment','+PPResrc_Assign_Pvt+');

3266: IF p_operation_flag = 'C' THEN
3267: --
3268: -- Call create Resource Assignment
3269: IF G_DEBUG='Y' THEN
3270: Ahl_Debug_Pub.debug( 'Start of pvt api for create Resource Assignment','+PPResrc_Assign_Pvt+');
3271: END IF;
3272: Create_Resrc_Assign (
3273: p_api_version => p_api_version,
3274: p_init_msg_list => p_init_msg_list,

Line 3285: Ahl_Debug_Pub.debug( 'End of pvt api for create Resource Assignment','+PPResrc_Assign_Pvt+');

3281: x_msg_data => l_msg_data
3282: ) ;
3283:
3284: IF G_DEBUG='Y' THEN
3285: Ahl_Debug_Pub.debug( 'End of pvt api for create Resource Assignment','+PPResrc_Assign_Pvt+');
3286: END IF;
3287:
3288: ELSIF p_operation_flag = 'U' THEN
3289: IF G_DEBUG='Y' THEN

Line 3290: AHL_DEBUG_PUB.debug( 'after update'||p_operation_flag);

3286: END IF;
3287:
3288: ELSIF p_operation_flag = 'U' THEN
3289: IF G_DEBUG='Y' THEN
3290: AHL_DEBUG_PUB.debug( 'after update'||p_operation_flag);
3291: END IF;
3292: -- Call Update Resource Assignment
3293: Update_Resrc_Assign (
3294: p_api_version => p_api_version,

Line 3338: Ahl_Debug_Pub.debug( 'End of public api Process Resource Assignment','+PPResrc_Assign_Pvt+');

3334: END IF;
3335:
3336: -- Debug info
3337: IF G_DEBUG='Y' THEN
3338: Ahl_Debug_Pub.debug( 'End of public api Process Resource Assignment','+PPResrc_Assign_Pvt+');
3339: END IF;
3340: -- Check if API is called in debug mode. If yes, disable debug.
3341: IF G_DEBUG='Y' THEN
3342: Ahl_Debug_Pub.disable_debug;

Line 3342: Ahl_Debug_Pub.disable_debug;

3338: Ahl_Debug_Pub.debug( 'End of public api Process Resource Assignment','+PPResrc_Assign_Pvt+');
3339: END IF;
3340: -- Check if API is called in debug mode. If yes, disable debug.
3341: IF G_DEBUG='Y' THEN
3342: Ahl_Debug_Pub.disable_debug;
3343: END IF;
3344:
3345: EXCEPTION
3346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3353: AHL_DEBUG_PUB.log_app_messages (

3349: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3350: p_count => x_msg_count,
3351: p_data => x_msg_data);
3352: IF G_DEBUG='Y' THEN
3353: AHL_DEBUG_PUB.log_app_messages (
3354: x_msg_count, x_msg_data, 'ERROR' );
3355: -- Check if API is called in debug mode. If yes, disable debug.
3356: AHL_DEBUG_PUB.disable_debug;
3357: END IF;

Line 3356: AHL_DEBUG_PUB.disable_debug;

3352: IF G_DEBUG='Y' THEN
3353: AHL_DEBUG_PUB.log_app_messages (
3354: x_msg_count, x_msg_data, 'ERROR' );
3355: -- Check if API is called in debug mode. If yes, disable debug.
3356: AHL_DEBUG_PUB.disable_debug;
3357: END IF;
3358:
3359: WHEN FND_API.G_EXC_ERROR THEN
3360: ROLLBACK TO Process_Resrc_Assign;

Line 3367: AHL_DEBUG_PUB.log_app_messages (

3363: p_count => x_msg_count,
3364: p_data => X_msg_data);
3365: IF G_DEBUG='Y' THEN
3366: -- Debug info.
3367: AHL_DEBUG_PUB.log_app_messages (
3368: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3369: -- Check if API is called in debug mode. If yes, disable debug.
3370: AHL_DEBUG_PUB.disable_debug;
3371: END IF;

Line 3370: AHL_DEBUG_PUB.disable_debug;

3366: -- Debug info.
3367: AHL_DEBUG_PUB.log_app_messages (
3368: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
3369: -- Check if API is called in debug mode. If yes, disable debug.
3370: AHL_DEBUG_PUB.disable_debug;
3371: END IF;
3372: WHEN OTHERS THEN
3373: ROLLBACK TO Process_Resrc_Assign;
3374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3386: AHL_DEBUG_PUB.log_app_messages (

3382: p_count => x_msg_count,
3383: p_data => X_msg_data);
3384: IF G_DEBUG='Y' THEN
3385: -- Debug info.
3386: AHL_DEBUG_PUB.log_app_messages (
3387: x_msg_count, x_msg_data, 'SQL ERROR' );
3388: -- Check if API is called in debug mode. If yes, disable debug.
3389: AHL_DEBUG_PUB.disable_debug;
3390: END IF;

Line 3389: AHL_DEBUG_PUB.disable_debug;

3385: -- Debug info.
3386: AHL_DEBUG_PUB.log_app_messages (
3387: x_msg_count, x_msg_data, 'SQL ERROR' );
3388: -- Check if API is called in debug mode. If yes, disable debug.
3389: AHL_DEBUG_PUB.disable_debug;
3390: END IF;
3391: END Process_Resrc_Assign;
3392:
3393: END AHL_PP_RESRC_ASSIGN_PVT;