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

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

1: PACKAGE BODY AHL_PRD_OPERATIONS_PVT AS
2: /* $Header: AHLVPROB.pls 120.22.12020000.2 2012/12/07 13:24:17 sareepar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_OPERATIONS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: FUNCTION get_date_and_time(p_date IN DATE,
8: p_date_hh24 IN VARCHAR2,
9: p_date_mi IN VARCHAR2,

Line 74: AHL_DEBUG_PUB.debug( 'Job Operation is based on Route Management Operation' );

70:
71: IF ( p_x_prd_workoper_rec.operation_code IS NOT NULL ) THEN
72:
73: IF ( G_DEBUG = 'Y' ) THEN
74: AHL_DEBUG_PUB.debug( 'Job Operation is based on Route Management Operation' );
75: END IF;
76:
77: OPEN get_operation_details(p_x_prd_workoper_rec.operation_code);
78: FETCH get_operation_details

Line 124: AHL_DEBUG_PUB.debug( 'Job Route ID :'||l_job_route_id );

120: p_x_prd_workoper_rec.organization_id := l_job_organization_id;
121: END IF;
122:
123: IF ( G_DEBUG = 'Y' ) THEN
124: AHL_DEBUG_PUB.debug( 'Job Route ID :'||l_job_route_id );
125: AHL_DEBUG_PUB.debug( 'Operation Code :'|| p_x_prd_workoper_rec.operation_code );
126: AHL_DEBUG_PUB.debug( 'Operation ID :'|| p_x_prd_workoper_rec.operation_id );
127: END IF;
128:

Line 125: AHL_DEBUG_PUB.debug( 'Operation Code :'|| p_x_prd_workoper_rec.operation_code );

121: END IF;
122:
123: IF ( G_DEBUG = 'Y' ) THEN
124: AHL_DEBUG_PUB.debug( 'Job Route ID :'||l_job_route_id );
125: AHL_DEBUG_PUB.debug( 'Operation Code :'|| p_x_prd_workoper_rec.operation_code );
126: AHL_DEBUG_PUB.debug( 'Operation ID :'|| p_x_prd_workoper_rec.operation_id );
127: END IF;
128:
129: IF ( l_job_route_id IS NULL AND

Line 126: AHL_DEBUG_PUB.debug( 'Operation ID :'|| p_x_prd_workoper_rec.operation_id );

122:
123: IF ( G_DEBUG = 'Y' ) THEN
124: AHL_DEBUG_PUB.debug( 'Job Route ID :'||l_job_route_id );
125: AHL_DEBUG_PUB.debug( 'Operation Code :'|| p_x_prd_workoper_rec.operation_code );
126: AHL_DEBUG_PUB.debug( 'Operation ID :'|| p_x_prd_workoper_rec.operation_id );
127: END IF;
128:
129: IF ( l_job_route_id IS NULL AND
130: p_x_prd_workoper_rec.operation_id IS NULL ) THEN

Line 134: AHL_DEBUG_PUB.debug( 'Defaulting QA Inspection Type for Operation from Profile' );

130: p_x_prd_workoper_rec.operation_id IS NULL ) THEN
131: l_qa_inspection_type:=fnd_profile.value('AHL_NR_WO_OP_PLAN_TYPE');
132:
133: IF ( G_DEBUG = 'Y' ) THEN
134: AHL_DEBUG_PUB.debug( 'Defaulting QA Inspection Type for Operation from Profile' );
135: END IF;
136:
137: END IF;
138:

Line 890: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );

886: FETCH get_op_sch_sec INTO l_sch_start_sec, l_sch_end_sec;
887: CLOSE get_op_sch_sec;
888:
889: IF ( G_DEBUG = 'Y' ) THEN
890: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );
891: END IF;
892:
893: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NOT NULL AND
894: p_x_prd_workoper_rec.SCHEDULED_START_DATE <> FND_API.G_MISS_DATE THEN

Line 907: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );

903: p_date_hh24 => p_x_prd_workoper_rec.SCHEDULED_START_HR,
904: p_date_mi => p_x_prd_workoper_rec.SCHEDULED_START_MI,
905: p_date_ss => l_sec);
906: IF ( G_DEBUG = 'Y' ) THEN
907: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );
908: END IF;
909: END IF;
910:
911: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NOT NULL AND

Line 925: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_END_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_END_DATE,'DD-MON-YY hh24:mi:ss') );

921: p_date_hh24 => p_x_prd_workoper_rec.SCHEDULED_END_HR,
922: p_date_mi => p_x_prd_workoper_rec.SCHEDULED_END_MI,
923: p_date_ss => l_sec);
924: IF ( G_DEBUG = 'Y' ) THEN
925: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_END_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_END_DATE,'DD-MON-YY hh24:mi:ss') );
926: END IF;
927: END IF;
928:
929: -- Balaji added for Release NR error

Line 948: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.ACTUAL_START_DATE : ' || to_char(p_x_prd_workoper_rec.ACTUAL_START_DATE,'DD-MON-YY hh24:mi:ss') );

944: p_date_hh24 => p_x_prd_workoper_rec.ACTUAL_START_HR,
945: p_date_mi => p_x_prd_workoper_rec.ACTUAL_START_MI,
946: p_date_ss => l_sec);
947: IF ( G_DEBUG = 'Y' ) THEN
948: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.ACTUAL_START_DATE : ' || to_char(p_x_prd_workoper_rec.ACTUAL_START_DATE,'DD-MON-YY hh24:mi:ss') );
949: END IF;
950: END IF;
951:
952: IF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND

Line 966: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.ACTUAL_END_DATE : ' || to_char(p_x_prd_workoper_rec.ACTUAL_END_DATE,'DD-MON-YY hh24:mi:ss') );

962: p_date_hh24 => p_x_prd_workoper_rec.ACTUAL_END_HR,
963: p_date_mi => p_x_prd_workoper_rec.ACTUAL_END_MI,
964: p_date_ss => l_sec);
965: IF ( G_DEBUG = 'Y' ) THEN
966: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.ACTUAL_END_DATE : ' || to_char(p_x_prd_workoper_rec.ACTUAL_END_DATE,'DD-MON-YY hh24:mi:ss') );
967: END IF;
968: END IF;
969:
970: END convert_values_to_ids;

Line 1262: AHL_DEBUG_PUB.enable_debug;

1258:
1259: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1260:
1261: IF G_DEBUG='Y' THEN
1262: AHL_DEBUG_PUB.enable_debug;
1263: END IF;
1264:
1265: IF ( G_DEBUG = 'Y' ) THEN
1266: AHL_DEBUG_PUB.debug( l_api_name || ' - Total number of Operations - ' || p_x_prd_operation_tbl.COUNT );

Line 1266: AHL_DEBUG_PUB.debug( l_api_name || ' - Total number of Operations - ' || p_x_prd_operation_tbl.COUNT );

1262: AHL_DEBUG_PUB.enable_debug;
1263: END IF;
1264:
1265: IF ( G_DEBUG = 'Y' ) THEN
1266: AHL_DEBUG_PUB.debug( l_api_name || ' - Total number of Operations - ' || p_x_prd_operation_tbl.COUNT );
1267: END IF;
1268:
1269: IF FND_API.to_boolean(p_default) THEN
1270: IF p_x_prd_operation_tbl.COUNT >0 THEN

Line 1276: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_attributes' );

1272: LOOP
1273:
1274: IF p_x_prd_operation_tbl(i).DML_OPERATION='C' THEN
1275: IF ( G_DEBUG = 'Y' ) THEN
1276: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_attributes' );
1277: END IF;
1278:
1279: default_attributes
1280: (

Line 1286: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_missing_attributes' );

1282: );
1283:
1284: ELSIF p_x_prd_operation_tbl(i).DML_OPERATION='U' THEN
1285: IF ( G_DEBUG = 'Y' ) THEN
1286: AHL_DEBUG_PUB.debug( l_api_name || ' - Before default_missing_attributes' );
1287: END IF;
1288:
1289: default_missing_attributes
1290: (

Line 1304: AHL_DEBUG_PUB.debug( l_api_name || ' - Before convert_values_to_ids' );

1300: IF p_x_prd_operation_tbl.COUNT >0 THEN
1301: FOR i in p_x_prd_operation_tbl.FIRST..p_x_prd_operation_tbl.LAST
1302: LOOP
1303: IF ( G_DEBUG = 'Y' ) THEN
1304: AHL_DEBUG_PUB.debug( l_api_name || ' - Before convert_values_to_ids' );
1305: END IF;
1306:
1307: convert_values_to_ids
1308: (

Line 1334: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_operation' );

1330: LOOP
1331: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1332:
1333: IF ( G_DEBUG = 'Y' ) THEN
1334: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_operation' );
1335: END IF;
1336:
1337: validate_operation
1338: (

Line 1353: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_OPERATIONS' );

1349:
1350: IF p_x_prd_operation_tbl(i).dml_operation='C' THEN
1351:
1352: IF ( G_DEBUG = 'Y' ) THEN
1353: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Inserting into AHL_WORKORDER_OPERATIONS' );
1354: END IF;
1355:
1356: INSERT INTO AHL_WORKORDER_OPERATIONS
1357: (

Line 1428: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDER_OPERATIONS' );

1424: );
1425: ELSIF p_x_prd_operation_tbl(I).DML_OPERATION='U' THEN
1426:
1427: IF ( G_DEBUG = 'Y' ) THEN
1428: AHL_DEBUG_PUB.debug( l_api_name || ' - Before Updating AHL_WORKORDER_OPERATIONS' );
1429: END IF;
1430:
1431: -- R12
1432: -- Tech UIs

Line 1523: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.update_job_operations' );

1519:
1520: IF p_wip_mass_load_flag='Y' THEN
1521:
1522: IF ( G_DEBUG = 'Y' ) THEN
1523: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.update_job_operations' );
1524: END IF;
1525:
1526: AHL_EAM_JOB_PVT.update_job_operations
1527: (

Line 1577: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );

1573: COMMIT;
1574: END IF;
1575:
1576: IF ( G_DEBUG = 'Y' ) THEN
1577: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );
1578: END IF;
1579:
1580: IF G_DEBUG='Y' THEN
1581: AHL_DEBUG_PUB.disable_debug;

Line 1581: AHL_DEBUG_PUB.disable_debug;

1577: AHL_DEBUG_PUB.debug( l_api_name || ' - Success' );
1578: END IF;
1579:
1580: IF G_DEBUG='Y' THEN
1581: AHL_DEBUG_PUB.disable_debug;
1582: END IF;
1583:
1584: EXCEPTION
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN