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

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

1: PACKAGE BODY AHL_PRD_RESOURCE_TRANX_PVT AS
2: /*$Header: AHLVTRSB.pls 120.19.12020000.2 2012/12/07 15:30:37 sareepar ship $*/
3: --
4: G_PKG_NAME VARCHAR2(30):='AHL_PRD_RESOURCE_TRANX_PVT';
5: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
6: PROCEDURE VALIDATE_RES_TRNX
7: (
8: p_prd_resrc_txn_tbl IN OUT NOCOPY PRD_RESOURCE_TXNS_TBL,
9: x_return_status OUT NOCOPY VARCHAR2

Line 171: AHL_DEBUG_PUB.debug( 'Start of procedure',l_proc_name);

167: l_msg_index_out number;
168:
169: BEGIN
170: IF G_DEBUG='Y' THEN
171: AHL_DEBUG_PUB.debug( 'Start of procedure',l_proc_name);
172: END IF;
173:
174: IF p_prd_resrc_txn_tbl.COUNT >0
175: THEN

Line 200: AHL_DEBUG_PUB.Debug('Before GetResourceDet:' || l_org_id || ':' || p_prd_resrc_txn_tbl(i).resource_name);

196: End if;
197: **sracha */
198:
199: IF (G_DEBUG = 'Y') THEN
200: AHL_DEBUG_PUB.Debug('Before GetResourceDet:' || l_org_id || ':' || p_prd_resrc_txn_tbl(i).resource_name);
201: END IF;
202:
203: Open GetResourceDet(--p_prd_resrc_txn_tbl(i).operation_sequence_num,
204: p_prd_resrc_txn_tbl(i).organization_id,

Line 241: AHL_DEBUG_PUB.debug('Unit is Locked',l_proc_name);

237: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_RESTXN_UNTLCKD');
238: FND_MESSAGE.Set_Token('WO_NAME', l_wrkrec.workorder_name);
239: FND_MSG_PUB.ADD;
240: IF G_DEBUG='Y' THEN
241: AHL_DEBUG_PUB.debug('Unit is Locked',l_proc_name);
242: END IF;
243: END IF;
244: -- rroy
245: -- ACL Changes

Line 266: AHL_DEBUG_PUB.debug( 'After Work Order ID validation:status is:' || l_wrkrec.STATUS_CODE,l_proc_name);

262: END IF;
263: END IF; -- work order ID is null
264:
265: IF G_DEBUG='Y' THEN
266: AHL_DEBUG_PUB.debug( 'After Work Order ID validation:status is:' || l_wrkrec.STATUS_CODE,l_proc_name);
267: END IF;
268:
269: IF p_prd_resrc_txn_tbl(I).workorder_operation_id IS NULL
270: OR p_prd_resrc_txn_tbl(I).workorder_operation_id=FND_API.G_MISS_NUM

Line 326: AHL_DEBUG_PUB.debug( 'After resource seq/dept validation',l_proc_name);

322: FND_MSG_PUB.ADD;
323: End if;
324:
325: IF G_DEBUG='Y' THEN
326: AHL_DEBUG_PUB.debug( 'After resource seq/dept validation',l_proc_name);
327: END IF;
328:
329: --Validate for employee number when resource is 'Labor'
330: IF l_res_rec.resource_type =2 THEN

Line 377: AHL_DEBUG_PUB.debug( 'After employee validation:employee_num:'|| p_prd_resrc_txn_tbl(I).employee_num || ':Person ID:' || p_prd_resrc_txn_tbl(I).person_id,l_proc_name);

373:
374: END IF; -- l_res_rec.resource_type =2
375:
376: IF G_DEBUG='Y' THEN
377: AHL_DEBUG_PUB.debug( 'After employee validation:employee_num:'|| p_prd_resrc_txn_tbl(I).employee_num || ':Person ID:' || p_prd_resrc_txn_tbl(I).person_id,l_proc_name);
378: END IF;
379:
380: If p_prd_resrc_txn_tbl(I).uom_code is null
381: Then

Line 420: AHL_DEBUG_PUB.debug( 'After quantity validation' ,l_proc_name);

416:
417: End if;
418:
419: IF G_DEBUG='Y' THEN
420: AHL_DEBUG_PUB.debug( 'After quantity validation' ,l_proc_name);
421: END IF;
422:
423: -- validate and set txn date or end date.
424: IF (p_prd_resrc_txn_tbl(i).end_date IS NULL) THEN

Line 429: ahl_debug_pub.debug('End Date is null and Txn date is not Null. Txn Date is:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));

425: IF (p_prd_resrc_txn_tbl(i).transaction_date) IS NOT NULL THEN
426: p_prd_resrc_txn_tbl(i).end_date := p_prd_resrc_txn_tbl(i).transaction_date + (p_prd_resrc_txn_tbl(I).qty/24);
427:
428: IF (G_DEBUG = 'Y') THEN
429: ahl_debug_pub.debug('End Date is null and Txn date is not Null. Txn Date is:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));
430: ahl_debug_pub.debug('Calc End Date is:' || to_char(p_prd_resrc_txn_tbl(i).end_date,'DD-MON-YYYY HH24:MI:SS'));
431: END IF;
432:
433: IF (p_prd_resrc_txn_tbl(i).end_date > sysdate)

Line 430: ahl_debug_pub.debug('Calc End Date is:' || to_char(p_prd_resrc_txn_tbl(i).end_date,'DD-MON-YYYY HH24:MI:SS'));

426: p_prd_resrc_txn_tbl(i).end_date := p_prd_resrc_txn_tbl(i).transaction_date + (p_prd_resrc_txn_tbl(I).qty/24);
427:
428: IF (G_DEBUG = 'Y') THEN
429: ahl_debug_pub.debug('End Date is null and Txn date is not Null. Txn Date is:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));
430: ahl_debug_pub.debug('Calc End Date is:' || to_char(p_prd_resrc_txn_tbl(i).end_date,'DD-MON-YYYY HH24:MI:SS'));
431: END IF;
432:
433: IF (p_prd_resrc_txn_tbl(i).end_date > sysdate)
434: THEN

Line 441: ahl_debug_pub.debug('End Date > sysdate' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

437: ||p_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM);
438:
439: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_prd_resrc_txn_tbl(i).end_date,fnd_date.outputDT_mask));
440: IF (G_DEBUG = 'Y') THEN
441: ahl_debug_pub.debug('End Date > sysdate' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
442: END IF;
443: FND_MSG_PUB.ADD;
444: END IF;
445: END IF; -- (p_prd_resrc_txn_tbl(i).transaction_date)

Line 450: ahl_debug_pub.debug('End Date is not null and Txn date is Null. End Date is:' || to_char(p_prd_resrc_txn_tbl(i).End_date,'DD-MON-YYYY HH24:MI:SS'));

446: ELSE -- p_prd_resrc_txn_tbl(i).end_date IS NULL
447: IF (p_prd_resrc_txn_tbl(i).transaction_date IS NULL) THEN
448: p_prd_resrc_txn_tbl(i).transaction_date := p_prd_resrc_txn_tbl(i).end_date - (p_prd_resrc_txn_tbl(I).qty/24) ;
449: IF (G_DEBUG = 'Y') THEN
450: ahl_debug_pub.debug('End Date is not null and Txn date is Null. End Date is:' || to_char(p_prd_resrc_txn_tbl(i).End_date,'DD-MON-YYYY HH24:MI:SS'));
451: ahl_debug_pub.debug('Calc Txn Date is:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));
452: END IF;
453: END IF;
454: END IF;

Line 451: ahl_debug_pub.debug('Calc Txn Date is:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));

447: IF (p_prd_resrc_txn_tbl(i).transaction_date IS NULL) THEN
448: p_prd_resrc_txn_tbl(i).transaction_date := p_prd_resrc_txn_tbl(i).end_date - (p_prd_resrc_txn_tbl(I).qty/24) ;
449: IF (G_DEBUG = 'Y') THEN
450: ahl_debug_pub.debug('End Date is not null and Txn date is Null. End Date is:' || to_char(p_prd_resrc_txn_tbl(i).End_date,'DD-MON-YYYY HH24:MI:SS'));
451: ahl_debug_pub.debug('Calc Txn Date is:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));
452: END IF;
453: END IF;
454: END IF;
455:

Line 464: ahl_debug_pub.debug('Trx Date is greater than sysdate:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));

460: -- transaction date should be less than or equal to sysdate
461: IF p_prd_resrc_txn_tbl(i).transaction_date IS NOT NULL THEN
462: IF p_prd_resrc_txn_tbl(i).transaction_date > sysdate THEN
463: IF (G_DEBUG = 'Y') THEN
464: ahl_debug_pub.debug('Trx Date is greater than sysdate:' || to_char(p_prd_resrc_txn_tbl(i).transaction_date,'DD-MON-YYYY HH24:MI:SS'));
465: END IF;
466:
467: FND_MESSAGE.set_name('AHL','AHL_PRD_RESTXN_DT_INVALID');
468: FND_MESSAGE.SET_TOKEN('OPER_RES',P_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM||'-'

Line 472: ahl_debug_pub.debug('Txn Date > sysdate' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

468: FND_MESSAGE.SET_TOKEN('OPER_RES',P_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM||'-'
469: ||p_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM);
470: FND_MESSAGE.SET_TOKEN('DATE', to_char(p_prd_resrc_txn_tbl(i).transaction_date,fnd_date.outputDT_mask));
471: IF (G_DEBUG = 'Y') THEN
472: ahl_debug_pub.debug('Txn Date > sysdate' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
473: END IF;
474: FND_MSG_PUB.ADD;
475: END IF;-- IF p_prd_resrc_txn_tbl(i).transaction_date > sysdate THEN
476:

Line 499: AHL_DEBUG_PUB.debug( 'After transaction date validation' ,l_proc_name);

495: END IF;-- IF p_prd_resrc_txn_tbl(i).transaction_date < l_release_date THEN
496: END IF;-- IF p_prd_resrc_txn_tbl(i).transaction_date IS NOT NULL THEN
497:
498: IF G_DEBUG='Y' THEN
499: AHL_DEBUG_PUB.debug( 'After transaction date validation' ,l_proc_name);
500: END IF;
501:
502: -- validate serial number.
503: -- Adithya modified the code to take department_id for Bug # 6326254 - Start

Line 536: AHL_DEBUG_PUB.debug( 'After serial number validation' ,l_proc_name);

532:
533: END IF; -- p_prd_resrc_txn_tbl(i).serial_number
534:
535: IF G_DEBUG='Y' THEN
536: AHL_DEBUG_PUB.debug( 'After serial number validation' ,l_proc_name);
537: END IF;
538:
539: END LOOP;
540: END IF; -- IF p_prd_resrc_txn_tbl.COUNT >0

Line 542: AHL_DEBUG_PUB.debug( 'End of procedure',l_proc_name);

538:
539: END LOOP;
540: END IF; -- IF p_prd_resrc_txn_tbl.COUNT >0
541: IF G_DEBUG='Y' THEN
542: AHL_DEBUG_PUB.debug( 'End of procedure',l_proc_name);
543: END IF;
544:
545: --Adithya added the following debug
546: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 553: AHL_DEBUG_PUB.debug( l_msg_data,l_proc_name);

549: IF l_msg_count > 0 THEN
550: if (l_msg_count = 1) THEN
551:
552: IF G_DEBUG='Y' THEN
553: AHL_DEBUG_PUB.debug( l_msg_data,l_proc_name);
554: END IF;
555: else
556: FOR i IN 1..l_msg_count LOOP
557:

Line 563: AHL_DEBUG_PUB.debug( 'Err mesg(i) -'|| i || ' ' || l_msg_data,l_proc_name);

559: p_encoded => 'F',
560: p_data => l_msg_data,
561: p_msg_index_out => l_msg_index_out);
562: IF G_DEBUG='Y' THEN
563: AHL_DEBUG_PUB.debug( 'Err mesg(i) -'|| i || ' ' || l_msg_data,l_proc_name);
564: END IF;
565:
566: end loop;
567: end if;

Line 714: AHL_DEBUG_PUB.enable_debug;

710:
711: BEGIN
712:
713: IF G_DEBUG='Y' THEN
714: AHL_DEBUG_PUB.enable_debug;
715: END IF;
716:
717: IF p_x_prd_resrc_txn_tbl.COUNT>0
718: THEN

Line 723: AHL_DEBUG_PUB.debug( ' API Input Dump->',l_proc_name);

719: FOR i in p_x_prd_resrc_txn_tbl.FIRST..p_x_prd_resrc_txn_tbl.LAST
720: LOOP
721: ---
722: IF G_DEBUG='Y' THEN
723: AHL_DEBUG_PUB.debug( ' API Input Dump->',l_proc_name);
724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);
725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);

Line 724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);

720: LOOP
721: ---
722: IF G_DEBUG='Y' THEN
723: AHL_DEBUG_PUB.debug( ' API Input Dump->',l_proc_name);
724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);
725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);

Line 725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);

721: ---
722: IF G_DEBUG='Y' THEN
723: AHL_DEBUG_PUB.debug( ' API Input Dump->',l_proc_name);
724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);
725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);

Line 726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);

722: IF G_DEBUG='Y' THEN
723: AHL_DEBUG_PUB.debug( ' API Input Dump->',l_proc_name);
724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);
725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);

Line 727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);

723: AHL_DEBUG_PUB.debug( ' API Input Dump->',l_proc_name);
724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);
725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);

Line 728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);

724: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID,l_proc_name);
725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);

Line 729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);

725: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id,l_proc_name);
726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);

Line 730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);

726: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,l_proc_name);
727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);

Line 731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);

727: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num,l_proc_name);
728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);
735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);

Line 732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);

728: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id,l_proc_name);
729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);
735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
736: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);

Line 733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);

729: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id,l_proc_name);
730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);
735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
736: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
737: END IF;

Line 734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);

730: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number,l_proc_name);
731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);
735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
736: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
737: END IF;
738: ---

Line 735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);

731: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id,l_proc_name);
732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);
735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
736: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
737: END IF;
738: ---
739:

Line 736: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);

732: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
733: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
734: AHL_DEBUG_PUB.debug( ' Person ID------->'||p_x_prd_resrc_txn_tbl(I).person_id,l_proc_name);
735: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
736: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
737: END IF;
738: ---
739:
740: IF p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM IS NOT NULL AND

Line 770: AHL_DEBUG_PUB.debug( 'Defaulting Dept Id and Code',l_proc_name);

766: ( p_x_prd_resrc_txn_tbl(I).department_code IS NULL OR
767: p_x_prd_resrc_txn_tbl(I).department_code = FND_API.G_MISS_CHAR )
768: THEN
769: IF G_DEBUG='Y' THEN
770: AHL_DEBUG_PUB.debug( 'Defaulting Dept Id and Code',l_proc_name);
771: END IF;
772: p_x_prd_resrc_txn_tbl(I).department_id:=l_oper_rec.department_id;
773: p_x_prd_resrc_txn_tbl(I).department_code:=l_oper_rec.department_code;
774: p_x_prd_resrc_txn_tbl(I).organization_id:=l_oper_rec.organization_id;

Line 952: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);

948: CLOSE CurGetEmployee;
949: End if;
950:
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);
953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);
954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);

Line 953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);

949: End if;
950:
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);
953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);
954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);

Line 954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);

950:
951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);
953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);
954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);

Line 955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);

951: IF G_DEBUG='Y' THEN
952: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);
953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);
954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);

Line 956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);

952: AHL_DEBUG_PUB.debug( ' workorder_id------->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);
953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);
954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);

Line 957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);

953: AHL_DEBUG_PUB.debug( ' workorder_Oper_id-->'||p_x_prd_resrc_txn_tbl(I).WORKORDER_operation_id);
954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);

Line 958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);

954: AHL_DEBUG_PUB.debug( ' operation_sequence->'||p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM);
955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);

Line 959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);

955: AHL_DEBUG_PUB.debug( ' resource_sequence-->'||p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_num);
956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);

Line 960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);

956: AHL_DEBUG_PUB.debug( ' Organization id -->'||p_x_prd_resrc_txn_tbl(I).organization_id);
957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
964: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);

Line 961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);

957: AHL_DEBUG_PUB.debug( ' Resource id -->'||p_x_prd_resrc_txn_tbl(I).resource_id);
958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
964: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
965:

Line 962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);

958: AHL_DEBUG_PUB.debug( ' Serial Number------->'||p_x_prd_resrc_txn_tbl(I).serial_number);
959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
964: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
965:
966: END IF;

Line 963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);

959: AHL_DEBUG_PUB.debug( ' Instance Id------->'||p_x_prd_resrc_txn_tbl(I).instance_id);
960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
964: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
965:
966: END IF;
967: END LOOP;

Line 964: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);

960: AHL_DEBUG_PUB.debug( ' Person Id------->'|| p_x_prd_resrc_txn_tbl(I).person_id);
961: AHL_DEBUG_PUB.debug( ' Quantity------->'||p_x_prd_resrc_txn_tbl(I).qty,l_proc_name);
962: AHL_DEBUG_PUB.debug( ' Employee Num------->'||p_x_prd_resrc_txn_tbl(I).employee_num,l_proc_name);
963: AHL_DEBUG_PUB.debug( ' uom_code------->'||p_x_prd_resrc_txn_tbl(I).uom_code,l_proc_name);
964: AHL_DEBUG_PUB.debug( ' uom_meaning------->'||p_x_prd_resrc_txn_tbl(I).uom_meaning,l_proc_name);
965:
966: END IF;
967: END LOOP;
968: END IF;

Line 1045: -- AHL_DEBUG_PUB.enable_debug;

1041:
1042: -- Enable Debug
1043:
1044: IF G_DEBUG='Y' THEN
1045: -- AHL_DEBUG_PUB.enable_debug;
1046: AHL_DEBUG_PUB.debug('At start of procedure PROCESS_RESOURCE_TRANX');
1047: END IF;
1048:
1049:

Line 1046: AHL_DEBUG_PUB.debug('At start of procedure PROCESS_RESOURCE_TRANX');

1042: -- Enable Debug
1043:
1044: IF G_DEBUG='Y' THEN
1045: -- AHL_DEBUG_PUB.enable_debug;
1046: AHL_DEBUG_PUB.debug('At start of procedure PROCESS_RESOURCE_TRANX');
1047: END IF;
1048:
1049:
1050:

Line 1073: AHL_DEBUG_PUB.debug( 'Enter PROCESS_RESOURCE_TRNX',L_API_NAME);

1069:
1070: -- Debug info.
1071:
1072: IF G_DEBUG='Y' THEN
1073: AHL_DEBUG_PUB.debug( 'Enter PROCESS_RESOURCE_TRNX',L_API_NAME);
1074: END IF;
1075: IF p_module_type IN ('JSP','OAF') THEN
1076: IF p_x_prd_resrc_txn_tbl.COUNT>0 THEN
1077: FOR i in p_x_prd_resrc_txn_tbl.FIRST..p_x_prd_resrc_txn_tbl.LAST LOOP

Line 1095: AHL_DEBUG_PUB.debug( 'Error Thrown in translate',L_API_NAME);

1091: IF l_msg_count > 0 THEN
1092: X_msg_count := l_msg_count;
1093: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF G_DEBUG='Y' THEN
1095: AHL_DEBUG_PUB.debug( 'Error Thrown in translate',L_API_NAME);
1096: END IF;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099:

Line 1118: AHL_DEBUG_PUB.debug( 'Error Thrown In Validation',L_API_NAME);

1114: l_msg_count := FND_MSG_PUB.count_msg;
1115: IF l_msg_count > 0 THEN
1116: X_msg_count := l_msg_count;
1117: IF G_DEBUG='Y' THEN
1118: AHL_DEBUG_PUB.debug( 'Error Thrown In Validation',L_API_NAME);
1119: END IF;
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122:

Line 1150: AHL_DEBUG_PUB.debug('Resource seq number: from DB' || p_x_prd_resrc_txn_tbl(i).resource_sequence_num);

1146: END IF;
1147: CLOSE get_oper_res_det;
1148:
1149: IF (G_DEBUG = 'Y') THEN
1150: AHL_DEBUG_PUB.debug('Resource seq number: from DB' || p_x_prd_resrc_txn_tbl(i).resource_sequence_num);
1151: END IF;
1152: -- Fix for Bug # 8892646 - start
1153: l_max_res_seq_no := p_x_prd_resrc_txn_tbl(i).resource_sequence_num;
1154: found := FALSE;

Line 1175: AHL_DEBUG_PUB.debug('Resource seq number: generated' || p_x_prd_resrc_txn_tbl(i).resource_sequence_num);

1171: END IF;
1172: p_x_prd_resrc_txn_tbl(i).resource_sequence_num := l_max_res_seq_no;
1173:
1174: IF (G_DEBUG = 'Y') THEN
1175: AHL_DEBUG_PUB.debug('Resource seq number: generated' || p_x_prd_resrc_txn_tbl(i).resource_sequence_num);
1176: END IF;
1177:
1178: -- Fix for Bug # 8892646 - end
1179: l_Resrc_Require_Tbl(l_ctr).resource_seq_number :=

Line 1232: AHL_DEBUG_PUB.debug( 'Before Process transactions',L_API_NAME);

1228:
1229: END IF;
1230:
1231: IF G_DEBUG='Y' THEN
1232: AHL_DEBUG_PUB.debug( 'Before Process transactions',L_API_NAME);
1233: AHL_DEBUG_PUB.debug( 'Number of Records'||p_x_prd_resrc_txn_tbl.count,L_API_NAME);
1234: END IF;
1235:
1236: l_ctr := 0;

Line 1233: AHL_DEBUG_PUB.debug( 'Number of Records'||p_x_prd_resrc_txn_tbl.count,L_API_NAME);

1229: END IF;
1230:
1231: IF G_DEBUG='Y' THEN
1232: AHL_DEBUG_PUB.debug( 'Before Process transactions',L_API_NAME);
1233: AHL_DEBUG_PUB.debug( 'Number of Records'||p_x_prd_resrc_txn_tbl.count,L_API_NAME);
1234: END IF;
1235:
1236: l_ctr := 0;
1237: FOR i IN p_x_prd_resrc_txn_tbl.FIRST..p_x_prd_resrc_txn_tbl.LAST

Line 1241: AHL_DEBUG_PUB.debug( 'Enter loop ',L_API_NAME);

1237: FOR i IN p_x_prd_resrc_txn_tbl.FIRST..p_x_prd_resrc_txn_tbl.LAST
1238: LOOP
1239:
1240: IF G_DEBUG='Y' THEN
1241: AHL_DEBUG_PUB.debug( 'Enter loop ',L_API_NAME);
1242: END IF;
1243:
1244: IF p_x_prd_resrc_txn_tbl(i).DML_operation = 'C'
1245: THEN

Line 1251: AHL_DEBUG_PUB.debug( 'Workorder id'||p_x_prd_resrc_txn_tbl(i).workorder_id,L_API_NAME);

1247: Fetch GetWipid into l_wip_entity_id;
1248: Close GetWipid;
1249:
1250: IF G_DEBUG='Y' THEN
1251: AHL_DEBUG_PUB.debug( 'Workorder id'||p_x_prd_resrc_txn_tbl(i).workorder_id,L_API_NAME);
1252: END IF;
1253:
1254: l_ahl_res_txn_tbl(l_ctr).wip_entity_id := l_wip_entity_id;
1255: l_ahl_res_txn_tbl(l_ctr).operation_seq_num :=p_x_prd_resrc_txn_tbl(i).Operation_sequence_num;

Line 1311: AHL_DEBUG_PUB.debug( 'Before Insert Process transactions',L_API_NAME);

1307:
1308: END LOOP;
1309:
1310: IF G_DEBUG='Y' THEN
1311: AHL_DEBUG_PUB.debug( 'Before Insert Process transactions',L_API_NAME);
1312:
1313: END IF;
1314:
1315: IF l_ahl_res_txn_tbl.count >0

Line 1338: AHL_DEBUG_PUB.debug( 'Validation Errors in interface API');

1334: X_msg_count := l_msg_count;
1335: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: RAISE FND_API.G_EXC_ERROR;
1337: IF G_DEBUG='Y' THEN
1338: AHL_DEBUG_PUB.debug( 'Validation Errors in interface API');
1339: END IF;
1340:
1341: END IF;
1342:

Line 1353: AHL_DEBUG_PUB.debug( 'End of Private api '||l_api_name,'+debug+');

1349:
1350: -- Debug info
1351:
1352: IF G_DEBUG='Y' THEN
1353: AHL_DEBUG_PUB.debug( 'End of Private api '||l_api_name,'+debug+');
1354:
1355: END IF;
1356:
1357: IF G_DEBUG='Y' THEN

Line 1358: AHL_DEBUG_PUB.disable_debug;

1354:
1355: END IF;
1356:
1357: IF G_DEBUG='Y' THEN
1358: AHL_DEBUG_PUB.disable_debug;
1359:
1360: END IF;
1361:
1362: EXCEPTION

Line 1430: AHL_DEBUG_PUB.debug( 'Error in Quantity');

1426: FND_MESSAGE.SET_TOKEN('OPER_RES', p_prd_myworkorder_txn_tbl(i).OPERATION_SEQUENCE||'-'|| p_prd_myworkorder_txn_tbl(i).RESOURCE_SEQUENCE);
1427: FND_MSG_PUB.ADD;
1428:
1429: IF G_DEBUG='Y' THEN
1430: AHL_DEBUG_PUB.debug( 'Error in Quantity');
1431: END IF;
1432: END IF;
1433: END IF ;
1434: */

Line 1444: AHL_DEBUG_PUB.debug( 'Error in Quantity');

1440: THEN
1441: FND_MESSAGE.set_name('AHL','AHL_PRD_WORKORDER_ID_NULL');
1442: FND_MSG_PUB.ADD;
1443: IF G_DEBUG='Y' THEN
1444: AHL_DEBUG_PUB.debug( 'Error in Quantity');
1445: END IF;
1446: END IF ;
1447:
1448: -- rroy

Line 1473: AHL_DEBUG_PUB.debug( 'Error in Quantity');

1469: THEN
1470: FND_MESSAGE.set_name('AHL','AHL_PRD_OPERATION_NULL');
1471: FND_MSG_PUB.ADD;
1472: IF G_DEBUG='Y' THEN
1473: AHL_DEBUG_PUB.debug( 'Error in Quantity');
1474: END IF;
1475: END IF ;
1476:
1477: IF p_prd_myworkorder_txn_tbl(i).RESOURCE_SEQUENCE IS NULL OR

Line 1483: AHL_DEBUG_PUB.debug( 'Error in Quantity');

1479: THEN
1480: FND_MESSAGE.set_name('AHL','AHL_PRD_RESOURCE_NULL');
1481: FND_MSG_PUB.ADD;
1482: IF G_DEBUG='Y' THEN
1483: AHL_DEBUG_PUB.debug( 'Error in Quantity');
1484: END IF;
1485: END IF ;
1486: END LOOP;
1487: END IF ;

Line 1626: AHL_DEBUG_PUB.enable_debug;

1622:
1623: -- Enable Debug
1624:
1625: IF G_DEBUG='Y' THEN
1626: AHL_DEBUG_PUB.enable_debug;
1627: END IF;
1628:
1629:
1630:

Line 1653: AHL_DEBUG_PUB.debug( 'Enter PROCESS_MYWORKORDER_TXNS',L_API_NAME);

1649:
1650: -- Debug info.
1651:
1652: IF G_DEBUG='Y' THEN
1653: AHL_DEBUG_PUB.debug( 'Enter PROCESS_MYWORKORDER_TXNS',L_API_NAME);
1654: END IF;
1655:
1656: VALIDATE_MYWORKORDER_TRNX(
1657: p_prd_myworkorder_txn_tbl => p_x_prd_myworkorder_txn_tbl,

Line 1667: AHL_DEBUG_PUB.debug( 'Error Thrown in Validate',L_API_NAME);

1663: IF l_msg_count > 0 THEN
1664: X_msg_count := l_msg_count;
1665: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1666: IF G_DEBUG='Y' THEN
1667: AHL_DEBUG_PUB.debug( 'Error Thrown in Validate',L_API_NAME);
1668: END IF;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END IF;
1671: -- Get the Defalut UOM Code --- Hr

Line 1683: AHL_DEBUG_PUB.debug( 'Enter loop ',L_API_NAME);

1679: IF p_x_prd_myworkorder_txn_tbl(i).TRANSACTED_HOURS > 0
1680: THEN
1681:
1682: IF G_DEBUG='Y' THEN
1683: AHL_DEBUG_PUB.debug( 'Enter loop ',L_API_NAME);
1684: END IF;
1685:
1686: OPEN GetWipid (p_x_prd_myworkorder_txn_tbl(i).workorder_id);
1687: FETCH GetWipid into l_wip_entity_id, l_wo_status_code;

Line 1699: AHL_DEBUG_PUB.debug( 'Workorder id'||p_x_prd_myworkorder_txn_tbl(i).workorder_id,L_API_NAME);

1695: Open getResDetails(p_x_prd_myworkorder_txn_tbl(i).ASSIGNMENT_ID);
1696: FETCH getResDetails into l_res_rec;
1697: CLOSE getResDetails;
1698: IF G_DEBUG='Y' THEN
1699: AHL_DEBUG_PUB.debug( 'Workorder id'||p_x_prd_myworkorder_txn_tbl(i).workorder_id,L_API_NAME);
1700: END IF;
1701: l_ahl_res_txn_tbl(l_ctr).operation_seq_num :=l_res_rec.OPERATION_SEQUENCE;
1702: l_ahl_res_txn_tbl(l_ctr).resource_seq_num :=l_res_rec.RESOURCE_SEQUENCE;
1703: l_ahl_res_txn_tbl(l_ctr).resource_id :=l_res_rec.RESOURCE_ID;

Line 1719: AHL_DEBUG_PUB.debug( 'Before Insert Process transactions',L_API_NAME);

1715: END LOOP;
1716: END IF;
1717:
1718: IF G_DEBUG='Y' THEN
1719: AHL_DEBUG_PUB.debug( 'Before Insert Process transactions',L_API_NAME);
1720:
1721: END IF;
1722:
1723:

Line 1745: AHL_DEBUG_PUB.debug( 'Error in Insert_Resource_Txn API');

1741: X_msg_count := l_msg_count;
1742: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1743: RAISE FND_API.G_EXC_ERROR;
1744: IF G_DEBUG='Y' THEN
1745: AHL_DEBUG_PUB.debug( 'Error in Insert_Resource_Txn API');
1746: END IF;
1747: END IF;
1748:
1749: --- Complete the Operation if the Complete Operation is True

Line 1796: AHL_DEBUG_PUB.debug( 'Error in Process Operations API');

1792: X_msg_count := l_msg_count;
1793: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: RAISE FND_API.G_EXC_ERROR;
1795: IF G_DEBUG='Y' THEN
1796: AHL_DEBUG_PUB.debug( 'Error in Process Operations API');
1797: END IF;
1798: END IF;
1799:
1800: --- Complete the Operation

Line 1826: AHL_DEBUG_PUB.debug( 'Error in Complete Operation API');

1822: X_msg_count := l_msg_count;
1823: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824: RAISE FND_API.G_EXC_ERROR;
1825: IF G_DEBUG='Y' THEN
1826: AHL_DEBUG_PUB.debug( 'Error in Complete Operation API');
1827: END IF;
1828: END IF;
1829:
1830: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1837: AHL_DEBUG_PUB.debug( 'End of api '||l_api_name,'+debug+');

1833:
1834: -- Debug info
1835:
1836: IF G_DEBUG='Y' THEN
1837: AHL_DEBUG_PUB.debug( 'End of api '||l_api_name,'+debug+');
1838:
1839: END IF;
1840:
1841: IF G_DEBUG='Y' THEN

Line 1842: AHL_DEBUG_PUB.disable_debug;

1838:
1839: END IF;
1840:
1841: IF G_DEBUG='Y' THEN
1842: AHL_DEBUG_PUB.disable_debug;
1843: END IF;
1844:
1845: EXCEPTION
1846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN