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 207: Ahl_Debug_Pub.debug(': Inside Check Employee Id= ' || x_Employee_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 773: Ahl_Debug_Pub.enable_debug;

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

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

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

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

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

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

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

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

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

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

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

Line 941: Ahl_Debug_Pub.disable_debug;

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

Line 1205: AHL_DEBUG_PUB.enable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1500: Fnd_Msg_Pub.ADD;
1501: RAISE Fnd_Api.G_EXC_ERROR;
1502: END IF;*/
1503: IF G_DEBUG='Y' THEN
1504: AHL_DEBUG_PUB.debug(l_full_name || 'RESOURCE TYPE in record -- ' || p_x_resrc_assign_tbl(i).resource_type_code);
1505: END IF;
1506:
1507: -- For Employee Number
1508: 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 1511: Ahl_Debug_Pub.debug(': Inside EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);

1507: -- For Employee Number
1508: 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)
1509: THEN
1510: IF G_DEBUG='Y' THEN
1511: Ahl_Debug_Pub.debug(': Inside EMployee Number = ' || p_x_resrc_assign_tbl(i).employee_number);
1512: END IF;
1513:
1514: Check_Employee_Number_Or_Id
1515: (p_employee_id => p_x_resrc_assign_tbl(i).employee_id,

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

1535: -- For Employee Name
1536: 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)
1537: THEN
1538: IF G_DEBUG='Y' THEN
1539: Ahl_Debug_Pub.debug( l_full_name ||': Inside Employee Name = ' || p_x_resrc_assign_tbl(i).employee_name);
1540: END IF;
1541: Check_Employee_Name_Or_Id
1542: (p_employee_id => l_employee_id,
1543: p_employee_number => p_x_resrc_assign_tbl(i).employee_number,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1901: Ahl_Debug_Pub.disable_debug;

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

Line 1913: AHL_DEBUG_PUB.log_app_messages (

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

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

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

Line 1917: AHL_DEBUG_PUB.disable_debug;

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

Line 1928: AHL_DEBUG_PUB.log_app_messages (

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

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

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

Line 1932: AHL_DEBUG_PUB.disable_debug;

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

Line 1950: AHL_DEBUG_PUB.log_app_messages (

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

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

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

Line 1954: AHL_DEBUG_PUB.disable_debug;

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

Line 2171: AHL_DEBUG_PUB.enable_debug;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2474: --
2475: IF G_DEBUG='Y' THEN
2476: AHL_DEBUG_PUB.debug('Resource id' || l_resource_id);
2477: AHL_DEBUG_PUB.debug('Department id' || p_x_resrc_assign_tbl(i).department_id);
2478: AHL_DEBUG_PUB.debug('Employee id' || p_x_resrc_assign_tbl(i).employee_id);
2479: END IF;
2480:
2481: -- Get instance id
2482: 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 2528: Ahl_Debug_Pub.debug ('p_x_resrc_assign_tbl(i).wip_entity_id' ||p_x_resrc_assign_tbl(i).wip_entity_id );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2845: Ahl_Debug_Pub.disable_debug;

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

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

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

Line 2859: AHL_DEBUG_PUB.disable_debug;

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

Line 2870: AHL_DEBUG_PUB.log_app_messages (

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

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

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

Line 2874: AHL_DEBUG_PUB.disable_debug;

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

Line 2891: AHL_DEBUG_PUB.log_app_messages (

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

Line 2894: AHL_DEBUG_PUB.disable_debug;

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

Line 2963: Ahl_Debug_Pub.enable_debug;

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

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

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

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

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

Line 3124: Ahl_Debug_Pub.disable_debug;

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

Line 3135: Ahl_Debug_Pub.log_app_messages (

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

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

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

Line 3139: Ahl_Debug_Pub.disable_debug;

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

Line 3150: Ahl_Debug_Pub.log_app_messages (

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

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

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

Line 3154: Ahl_Debug_Pub.disable_debug;

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

Line 3171: Ahl_Debug_Pub.log_app_messages (

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

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

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

Line 3175: Ahl_Debug_Pub.disable_debug;

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

Line 3238: AHL_DEBUG_PUB.enable_debug;

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

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

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

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

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

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

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

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

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

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

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

Line 3340: Ahl_Debug_Pub.disable_debug;

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

Line 3351: AHL_DEBUG_PUB.log_app_messages (

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

Line 3354: AHL_DEBUG_PUB.disable_debug;

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

Line 3365: AHL_DEBUG_PUB.log_app_messages (

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

Line 3368: AHL_DEBUG_PUB.disable_debug;

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

Line 3384: AHL_DEBUG_PUB.log_app_messages (

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

Line 3387: AHL_DEBUG_PUB.disable_debug;

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