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.GMS_LD_PKG dependencies on PA_CC_UTILS

Line 284: pa_cc_utils.set_curr_function('lockCntrlRec');

280: FOR UPDATE OF status NOWAIT;
281:
282: BEGIN
283:
284: pa_cc_utils.set_curr_function('lockCntrlRec');
285:
286: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||
287: ' transaction source ='||trx_source||
288: ' batch = '||batch||

Line 286: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||

282: BEGIN
283:
284: pa_cc_utils.set_curr_function('lockCntrlRec');
285:
286: pa_cc_utils.log_message('Trying to get lock for record in xface ctrl:'||
287: ' transaction source ='||trx_source||
288: ' batch = '||batch||
289: ' sys link = '||etypeclasscode, 1);
290:

Line 296: pa_cc_utils.log_message('Got lock for record',1);

292: FOR i in C_lock_records LOOP
293: NULL;
294: END LOOP;
295:
296: pa_cc_utils.log_message('Got lock for record',1);
297:
298: /* Bug 3035863: Explanation on below code modification
299:
300: Oracle projects Transaction import process picks the PENDING status records

Line 324: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Deleting interface control record in IN_PROGRESS status which is created during last run' ,1);

320:
321: Solution: Delete the 'IN_PROGRESS' record created during the previous unsuccessful
322: run before updating the current run record to same status. */
323:
324: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Deleting interface control record in IN_PROGRESS status which is created during last run' ,1);
325:
326: DELETE pa_transaction_xface_control
327: WHERE transaction_source = trx_source
328: AND batch_name = NVL(batch,batch_name) -- Bug 3035863

Line 332: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Number of records deleted from pa_transaction_xface_control : '||SQl%ROWCOUNT);

328: AND batch_name = NVL(batch,batch_name) -- Bug 3035863
329: AND system_linkage_function = NVL(etypeclasscode,system_linkage_function) -- Bug 3035863
330: AND status = 'IN_PROGRESS' ;
331:
332: pa_cc_utils.log_message('GMS_LD_PKG.LOCKCNTRLREC : Number of records deleted from pa_transaction_xface_control : '||SQl%ROWCOUNT);
333:
334: UPDATE pa_transaction_xface_control
335: SET
336: interface_id = P_xface_id

Line 344: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);

340: AND batch_name = NVL(batch,batch_name) -- Bug 3035863
341: AND system_linkage_function = NVL(etypeclasscode,system_linkage_function) -- Bug 3035863
342: AND status = 'PENDING';
343:
344: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
345:
346: pa_cc_utils.reset_curr_function;
347: RETURN 0;
348:

Line 346: pa_cc_utils.reset_curr_function;

342: AND status = 'PENDING';
343:
344: pa_cc_utils.log_message('Updated interface id/status on pa_transaction_xface_control',1);
345:
346: pa_cc_utils.reset_curr_function;
347: RETURN 0;
348:
349: EXCEPTION
350: WHEN RESOURCE_BUSY THEN

Line 351: pa_cc_utils.log_message('Cannot get lock',1);

347: RETURN 0;
348:
349: EXCEPTION
350: WHEN RESOURCE_BUSY THEN
351: pa_cc_utils.log_message('Cannot get lock',1);
352: pa_cc_utils.reset_curr_function;
353: write_to_log('GMS :lockCntrlRec RESOURCE_BUSY exception raised '||SQLCODE) ;
354: write_to_log('GMS :SQLERRM '||SQLERRM) ;
355: write_to_log('GMS :Parameter trx_source :'||trx_source||' system_linkage_function :'||etypeclasscode) ;

Line 352: pa_cc_utils.reset_curr_function;

348:
349: EXCEPTION
350: WHEN RESOURCE_BUSY THEN
351: pa_cc_utils.log_message('Cannot get lock',1);
352: pa_cc_utils.reset_curr_function;
353: write_to_log('GMS :lockCntrlRec RESOURCE_BUSY exception raised '||SQLCODE) ;
354: write_to_log('GMS :SQLERRM '||SQLERRM) ;
355: write_to_log('GMS :Parameter trx_source :'||trx_source||' system_linkage_function :'||etypeclasscode) ;
356: raise_application_error(SQLCODE,SQLERRM) ;

Line 387: pa_cc_utils.log_message('Unexpected error : get_award_id: '||SQLERRM,1);

383: when others then
384: IF c1%isopen then
385: close c1 ;
386: end if ;
387: pa_cc_utils.log_message('Unexpected error : get_award_id: '||SQLERRM,1);
388: write_to_log('GMS :get_award_id When OTHERS exception raised '||SQLCODE) ;
389: write_to_log('GMS :SQLERRM '||SQLERRM) ;
390: write_to_log('GMS :Parameter txn_interface_id :'||Trxrec.txn_interface_id||' award id :'||NVL(x_award_id,0)) ;
391: return 0 ;

Line 501: pa_cc_utils.log_message('Unexpected error : PROC_CREATE_GROUP: '||SQLERRM,1);

497: END IF ;
498: EXCEPTION
499: WHEN OTHERS THEN
500: X_SUCCESS := 'F' ;
501: pa_cc_utils.log_message('Unexpected error : PROC_CREATE_GROUP: '||SQLERRM,1);
502: write_to_log('GMS :proc_create_group When OTHERS exception raised '||SQLCODE) ;
503: write_to_log('GMS :SQLERRM '||SQLERRM) ;
504: write_to_log('GMS :Parameter x_encumbrance_group :'||l_encumbrance_grp) ;
505: END PROC_CREATE_GROUP ;

Line 526: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : Start');

522: AND gei.encumbrance_item_id = l_orig_enc_item_id ;
523:
524: BEGIN
525:
526: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : Start');
527:
528: -- Bug 3465936 : Added following code to validate the original_encumbrance_item_id and
529: -- to check whether liquidation of encumbrance item id is allowed
530:

Line 533: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : Before vaildating the liquidated Encumbrance');

529: -- to check whether liquidation of encumbrance item id is allowed
530:
531: IF l_orig_enc_item_id IS NOT NULL THEN
532:
533: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : Before vaildating the liquidated Encumbrance');
534:
535: IF l_allow_reversal_flag = 'N' THEN
536: p_status_code := 'GMS_IMP_ENC_NO_REVERSAL';
537: ELSE

Line 552: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : After vaildating the liquidated Encumbrance ,p_status_code : '||p_status_code);

548: CLOSE c_original_enc_exists ;
549:
550: END IF;
551:
552: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : After vaildating the liquidated Encumbrance ,p_status_code : '||p_status_code);
553:
554: IF p_status_code IS NOT NULL THEN
555: X_success := 'F' ;
556: RETURN;

Line 574: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);

570: X_Employee_Id => l_person_id,
571: P_EiDate => TrxRec.expenditure_ending_date );
572: IF ( pa_utils2.G_return_status IS NOT NULL and TrxRec.system_linkage not in ('PJ', 'USG')) THEN --Bug: 4594620
573: X_status := pa_utils2.G_return_status ;
574: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
575: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
576: pa_cc_utils.log_message('EXECPTION : Person ID validation ' || x_status);
577:
578: X_success := 'F' ;

Line 575: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);

571: P_EiDate => TrxRec.expenditure_ending_date );
572: IF ( pa_utils2.G_return_status IS NOT NULL and TrxRec.system_linkage not in ('PJ', 'USG')) THEN --Bug: 4594620
573: X_status := pa_utils2.G_return_status ;
574: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
575: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
576: pa_cc_utils.log_message('EXECPTION : Person ID validation ' || x_status);
577:
578: X_success := 'F' ;
579: return ;

Line 576: pa_cc_utils.log_message('EXECPTION : Person ID validation ' || x_status);

572: IF ( pa_utils2.G_return_status IS NOT NULL and TrxRec.system_linkage not in ('PJ', 'USG')) THEN --Bug: 4594620
573: X_status := pa_utils2.G_return_status ;
574: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
575: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
576: pa_cc_utils.log_message('EXECPTION : Person ID validation ' || x_status);
577:
578: X_success := 'F' ;
579: return ;
580: END IF ;

Line 607: pa_cc_utils.log_message('EXECPTION : organization_name validation ' || x_status);

603: X_Return_Status => x_status);
604:
605: If x_status is Not Null OR l_temp_org_id is NULL Then
606: X_success := 'F';
607: pa_cc_utils.log_message('EXECPTION : organization_name validation ' || x_status);
608: RETURN;
609: End If;
610:
611:

Line 618: pa_cc_utils.log_message('Organization ' || l_organization_id, 1);

614: ELSE
615: l_organization_id := l_temp_org_id ;
616: END IF ;
617:
618: pa_cc_utils.log_message('Organization ' || l_organization_id, 1);
619: l_gen_seq := 'Y';
620: ORG_FIRST := FALSE;
621:
622: select organization_id

Line 634: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : End');

630:
631: X_success := 'S' ;
632: end if;
633:
634: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : End');
635: EXCEPTION
636: WHEN no_data_found THEN
637: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
638: pa_cc_utils.log_message('EXECPTION :Override Organization ' || TrxRec.override_to_organization_name, 1);

Line 637: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);

633:
634: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : End');
635: EXCEPTION
636: WHEN no_data_found THEN
637: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
638: pa_cc_utils.log_message('EXECPTION :Override Organization ' || TrxRec.override_to_organization_name, 1);
639: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
640: pa_cc_utils.log_message('EXECPTION :Organization ' || TrxRec.organization_name, 1);
641:

Line 638: pa_cc_utils.log_message('EXECPTION :Override Organization ' || TrxRec.override_to_organization_name, 1);

634: pa_cc_utils.log_message('GMS_LD_PKG.PROC_VALIDATE_LOCAL : End');
635: EXCEPTION
636: WHEN no_data_found THEN
637: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
638: pa_cc_utils.log_message('EXECPTION :Override Organization ' || TrxRec.override_to_organization_name, 1);
639: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
640: pa_cc_utils.log_message('EXECPTION :Organization ' || TrxRec.organization_name, 1);
641:
642: X_success := 'F' ;

Line 639: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);

635: EXCEPTION
636: WHEN no_data_found THEN
637: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
638: pa_cc_utils.log_message('EXECPTION :Override Organization ' || TrxRec.override_to_organization_name, 1);
639: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
640: pa_cc_utils.log_message('EXECPTION :Organization ' || TrxRec.organization_name, 1);
641:
642: X_success := 'F' ;
643: write_to_log('GMS :proc_validate_local When no_data_found exception raised '||SQLCODE) ;

Line 640: pa_cc_utils.log_message('EXECPTION :Organization ' || TrxRec.organization_name, 1);

636: WHEN no_data_found THEN
637: pa_cc_utils.log_message('EXECPTION :Person ' || TrxRec.employee_number, 1);
638: pa_cc_utils.log_message('EXECPTION :Override Organization ' || TrxRec.override_to_organization_name, 1);
639: pa_cc_utils.log_message('EXECPTION :Expenditure Item date ' || TrxRec.expenditure_ending_date, 1);
640: pa_cc_utils.log_message('EXECPTION :Organization ' || TrxRec.organization_name, 1);
641:
642: X_success := 'F' ;
643: write_to_log('GMS :proc_validate_local When no_data_found exception raised '||SQLCODE) ;
644: write_to_log('GMS :SQLERRM '||SQLERRM) ;

Line 652: pa_cc_utils.log_message('Unexpected error: PROC_VALIDATE_LOCAL: '||SQLERRM,1);

648: write_to_log('GMS :Organization ' || TrxRec.organization_name);
649:
650: When others then
651: X_success := 'F' ;
652: pa_cc_utils.log_message('Unexpected error: PROC_VALIDATE_LOCAL: '||SQLERRM,1);
653: write_to_log('GMS :proc_validate_local When OTHERS exception raised '||SQLCODE) ;
654: write_to_log('GMS :SQLERRM '||SQLERRM) ;
655: write_to_log('GMS :Parameter person :'||TrxRec.employee_number) ;
656: write_to_log('GMS :Parameter Override Organization :'||TrxRec.override_to_organization_name) ;

Line 706: pa_cc_utils.log_message('Unexpected error: F_create_adls: '||SQLERRM,1);

702:
703: return TRUE ;
704: exception
705: when others then
706: pa_cc_utils.log_message('Unexpected error: F_create_adls: '||SQLERRM,1);
707: write_to_log('GMS :f_create_adls When OTHERS exception raised '||SQLCODE) ;
708: write_to_log('GMS :SQLERRM '||SQLERRM) ;
709: write_to_log('GMS :Parameter X_ei_id :'|| l_enc_item_id) ;
710: write_to_log('GMS :Parameter project_id, task_id :'||l_project_id||' , '||l_task_id) ;

Line 727: pa_cc_utils.log_message('Task : ' || TrxRec.task_number ||' , project id : ' || l_project_id, 1);

723: where segment1 = TrxRec.project_number;
724:
725: PROJ_FIRST := FALSE;
726: end if;
727: pa_cc_utils.log_message('Task : ' || TrxRec.task_number ||' , project id : ' || l_project_id, 1);
728: PROJ_FAIL := FALSE;
729:
730: ----------------------------------------------------------------------------
731: -- BUG:2389535 - Encumbrances have Identical Task Ids

Line 752: pa_cc_utils.log_message('EXCEPTION:Project : ' || TrxRec.project_number, 1);

748: l_task_number := TrxRec.task_number;
749:
750: EXCEPTION
751: when no_data_found then
752: pa_cc_utils.log_message('EXCEPTION:Project : ' || TrxRec.project_number, 1);
753: pa_cc_utils.log_message('EXCEPTION:Task : ' || TrxRec.task_number, 1);
754: x_success := 'F' ;
755: write_to_log('GMS :proc_project_task When no_data_found exception raised '||SQLCODE) ;
756: write_to_log('GMS :SQLERRM '||SQLERRM) ;

Line 753: pa_cc_utils.log_message('EXCEPTION:Task : ' || TrxRec.task_number, 1);

749:
750: EXCEPTION
751: when no_data_found then
752: pa_cc_utils.log_message('EXCEPTION:Project : ' || TrxRec.project_number, 1);
753: pa_cc_utils.log_message('EXCEPTION:Task : ' || TrxRec.task_number, 1);
754: x_success := 'F' ;
755: write_to_log('GMS :proc_project_task When no_data_found exception raised '||SQLCODE) ;
756: write_to_log('GMS :SQLERRM '||SQLERRM) ;
757: write_to_log('GMS :Parameter project_number, task_number :'|| TrxRec.project_number||','||TrxRec.task_number) ;

Line 760: pa_cc_utils.log_message('Unexpected error: PROC_PROJECT_TASK: '||SQLERRM,1);

756: write_to_log('GMS :SQLERRM '||SQLERRM) ;
757: write_to_log('GMS :Parameter project_number, task_number :'|| TrxRec.project_number||','||TrxRec.task_number) ;
758: When others then
759: x_success := 'F' ;
760: pa_cc_utils.log_message('Unexpected error: PROC_PROJECT_TASK: '||SQLERRM,1);
761: write_to_log('GMS :proc_project_task when others exception raised '||SQLCODE) ;
762: write_to_log('GMS :SQLERRM '||SQLERRM) ;
763: write_to_log('GMS :Parameter project_number, task_number :'|| TrxRec.project_number||','||TrxRec.task_number) ;
764: END PROC_PROJECT_TASK ;

Line 773: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Start');

769: BEGIN
770: -- Bug 3035863: The following code is added to stop further processing of
771: -- encumbrance if flags not properly set .
772:
773: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Start');
774: x_status := NULL;
775:
776: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Validating transaction source '||p_transaction_source );
777:

Line 776: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Validating transaction source '||p_transaction_source );

772:
773: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Start');
774: x_status := NULL;
775:
776: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Validating transaction source '||p_transaction_source );
777:
778: IF NVL(l_gl_accted_flag ,'N') = 'Y' THEN
779: x_status := 'GMS_IMP_ENC_GLACCT_FLAG';
780: ELSIF NVL(l_costed_flag,'N') = 'N' THEN

Line 786: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : After validating transaction source ,Value of x_status : '||x_status );

782: ELSIF NVL(l_allow_burden_flag,'N') = 'Y' THEN
783: x_status := 'GMS_IMP_ENC_BURDEN_FLAG';
784: END IF;
785:
786: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : After validating transaction source ,Value of x_status : '||x_status );
787:
788: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : End ');
789:
790: EXCEPTION

Line 788: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : End ');

784: END IF;
785:
786: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : After validating transaction source ,Value of x_status : '||x_status );
787:
788: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : End ');
789:
790: EXCEPTION
791: When others then
792: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Unexpected error : '||SQLERRM,1);

Line 792: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Unexpected error : '||SQLERRM,1);

788: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : End ');
789:
790: EXCEPTION
791: When others then
792: pa_cc_utils.log_message('GMS_LD_PKG.VALIDATE_TRANSACTION_SOURCE : Unexpected error : '||SQLERRM,1);
793: x_status := 'GMS_UNEXPECTED_ERROR';
794: END;
795:
796: BEGIN

Line 826: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Before calling VALIDATE_TRANSACTION_SOURCE ');

822: fetch c_trans_source into l_emp_org_oride,l_purgeable_flag,l_allow_dup_ref_flag ,
823: l_gl_accted_flag,l_allow_reversal_flag,l_costed_flag,l_allow_burden_flag; -- Bug 3035863
824: close c_trans_source ;
825:
826: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Before calling VALIDATE_TRANSACTION_SOURCE ');
827:
828: -- Bug 3035863 : Call to validate encumbrance transaction source.
829:
830: IF SUBSTR(p_transaction_source,1,4) ='GMSE' THEN

Line 848: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Number of records marked for failure after VALIDATE_TRANSACTION_SOURCE'||SQL%ROWCOUNT);

844: WHERE xc.transaction_source = P_transaction_source
845: AND xc.batch_name = nvl(P_batch, xc.batch_name)
846: AND xc.status = 'PENDING');
847:
848: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Number of records marked for failure after VALIDATE_TRANSACTION_SOURCE'||SQL%ROWCOUNT);
849:
850: dummy := lockCntrlRec( p_transaction_source,
851: p_batch ,
852: NULL );

Line 880: pa_cc_utils.log_message(pa_debug.G_err_stage||

876: x_success := 'S' ;
877: FOR eachGroup IN TrxBatches LOOP
878:
879: pa_debug.G_err_Stage := 'Locking xface ctrl record';
880: pa_cc_utils.log_message(pa_debug.G_err_stage||
881: 'Transaction source = '||eachGroup.transaction_source
882: ||' batch= '||eachGroup.batch_name||' sys link= '||
883: eachGroup.system_linkage_function,1);
884:

Line 895: pa_cc_utils.log_message( pa_debug.G_err_Stage,1);

891: GOTO NEXTREC ;
892: END IF ;
893:
894: pa_debug.G_err_Stage := 'Open cursor trxrecs';
895: pa_cc_utils.log_message( pa_debug.G_err_Stage,1);
896:
897: IF TrxRecs%ISOPEN THEN
898: CLOSE TrxRecs ;
899: END IF ;

Line 929: pa_cc_utils.log_message('Zero Records Fetched',1);

925:
926: SAVEPOINT SAVE_TrxREC ;
927:
928: IF ( TrxRecs%ROWCOUNT = 0 ) THEN
929: pa_cc_utils.log_message('Zero Records Fetched',1);
930: EXIT expenditures ;
931:
932: elsif TrxRecs%NOTFOUND then
933: exit expenditures;

Line 941: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Fetching liquidated Encumbrance for txn interface id : '||TrxRec.txn_interface_id);

937:
938: -- Bug 3465939 :Code to fetch liquidated encumbrance item id information
939: -- from grants transaction_interface table
940:
941: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Fetching liquidated Encumbrance for txn interface id : '||TrxRec.txn_interface_id);
942:
943: OPEN c_get_org_enc_item_id(TrxRec.txn_interface_id);
944: FETCH c_get_org_enc_item_id INTO l_orig_enc_item_id,l_net_zero_adj_flag ;
945: CLOSE c_get_org_enc_item_id;

Line 947: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Value of l_orig_enc_item_id'||l_orig_enc_item_id);

943: OPEN c_get_org_enc_item_id(TrxRec.txn_interface_id);
944: FETCH c_get_org_enc_item_id INTO l_orig_enc_item_id,l_net_zero_adj_flag ;
945: CLOSE c_get_org_enc_item_id;
946:
947: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Value of l_orig_enc_item_id'||l_orig_enc_item_id);
948: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Value of l_net_zero_adj_flag'||l_net_zero_adj_flag);
949:
950: -- Bug 3465939 :Shifted the call to PROC_VALIDATE_LOCAL before encumbrance group creation
951:

Line 948: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Value of l_net_zero_adj_flag'||l_net_zero_adj_flag);

944: FETCH c_get_org_enc_item_id INTO l_orig_enc_item_id,l_net_zero_adj_flag ;
945: CLOSE c_get_org_enc_item_id;
946:
947: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Value of l_orig_enc_item_id'||l_orig_enc_item_id);
948: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Value of l_net_zero_adj_flag'||l_net_zero_adj_flag);
949:
950: -- Bug 3465939 :Shifted the call to PROC_VALIDATE_LOCAL before encumbrance group creation
951:
952: PROC_PROJECT_TASK ;

Line 1011: pa_cc_utils.log_message('Trying to call the validate item proc', 1);

1007: l_project_id,
1008: l_task_id,
1009: l_orig_enc_item_id);
1010:
1011: pa_cc_utils.log_message('Trying to call the validate item proc', 1);
1012: l_emporg_id := NULL ;
1013: l_empjob_id := NULL ;
1014:
1015: IF NVL(l_emp_org_oride, 'N') = 'N' AND

Line 1113: pa_cc_utils.log_message('Done calling ValidateItem....from pre-process ', 1);

1109: , TrxRec.po_line_num
1110: , TrxRec.po_line_id
1111: , TrxRec.person_type
1112: , TrxRec.po_price_type );
1113: pa_cc_utils.log_message('Done calling ValidateItem....from pre-process ', 1);
1114: -- --------------------------------------------------
1115: -- INFORMATION :
1116: -- We do this because validate item pkg calls
1117: -- GetTrxSrcInfo is called for external each time

Line 1122: pa_cc_utils.reset_curr_function ;

1118: -- we want it to be called only the 1st time.
1119: -- -------------------------------------------------
1120: x_calling_module := 'PAXTRTRX' ;
1121:
1122: pa_cc_utils.reset_curr_function ;
1123: -- gms validations for Bug:2431943
1124: gms_pa_api.vert_app_validate(eachGroup.transaction_source,
1125: eachGroup.batch_name,
1126: TrxRec.txn_interface_id,

Line 1151: pa_cc_utils.log_message('This record is rejected Stage: Pre-Process ' || X_status, 1);

1147: /* UPDATE gms_transaction_interface_all
1148: SET transaction_status_code = 'R'
1149: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference; */
1150:
1151: pa_cc_utils.log_message('This record is rejected Stage: Pre-Process ' || X_status, 1);
1152:
1153: GOTO MOVETONEXT ;
1154:
1155: end if; -- For the accepted records

Line 1162: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Before calling PROC_VALIDATE_LOCAL');

1158: pa_multi_currency.init;
1159: x_acct_currency_code := pa_multi_currency.G_accounting_currency_code;
1160: end if;
1161:
1162: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Before calling PROC_VALIDATE_LOCAL');
1163:
1164: PROC_VALIDATE_LOCAL(TrxRec.raw_cost,x_status_code) ;
1165:
1166: IF x_success = 'F' THEN

Line 1280: pa_cc_utils.log_message('Project : ' || TrxRec.project_number, 1);

1276: l_gen_seq := 'N';
1277:
1278: end if;
1279:
1280: pa_cc_utils.log_message('Project : ' || TrxRec.project_number, 1);
1281:
1282: -- Bug 3035863 : Added below if condition to check for duplicate flags based on
1283: -- Allow_duplicate_flag value.
1284:

Line 1398: pa_cc_utils.log_message('This record validated ' || X_status, 1);

1394: x_burden_sum_dest_run_id => NULL,
1395: x_burden_sum_source_run_id => NULL,
1396: x_org_id => TrxRec.org_id ); -- fix for bug : 2376730
1397:
1398: pa_cc_utils.log_message('This record validated ' || X_status, 1);
1399:
1400: IF f_create_adls THEN
1401: UPDATE pa_transaction_interface_all
1402: SET transaction_rejection_code = NULL,

Line 1446: pa_cc_utils.log_message('Cannot get lock',1);

1442: <>
1443: NULL ;
1444: EXCEPTION
1445: WHEN RESOURCE_BUSY THEN
1446: pa_cc_utils.log_message('Cannot get lock',1);
1447: pa_cc_utils.reset_curr_function;
1448: write_to_log('GMS :RESOURCE_BUSY exception stage 20 ') ;
1449: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1450: write_to_log('GMS :SQLERRM '||SQLERRM) ;

Line 1447: pa_cc_utils.reset_curr_function;

1443: NULL ;
1444: EXCEPTION
1445: WHEN RESOURCE_BUSY THEN
1446: pa_cc_utils.log_message('Cannot get lock',1);
1447: pa_cc_utils.reset_curr_function;
1448: write_to_log('GMS :RESOURCE_BUSY exception stage 20 ') ;
1449: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1450: write_to_log('GMS :SQLERRM '||SQLERRM) ;
1451: raise_application_error(SQLCODE,SQLERRM) ;

Line 1475: pa_cc_utils.log_message('Unexpected error :TrxRecs LOOP: '||SQLERRM,1);

1471: /* UPDATE gms_transaction_interface_all
1472: SET transaction_status_code = 'R'
1473: WHERE orig_transaction_reference = TrxRec.orig_transaction_reference; */
1474:
1475: pa_cc_utils.log_message('Unexpected error :TrxRecs LOOP: '||SQLERRM,1);
1476: END ;
1477: end loop; -- TrxRecs
1478: --end if;
1479: <>

Line 1495: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Number of success records deleted from Grants interface table :'||SQL%ROWCOUNT);

1491: WHERE txn_interface_id IN (SELECT txn_interface_id
1492: FROM pa_transaction_interface_all
1493: WHERE interface_id = P_XFACE_ID
1494: AND transaction_status_code ='A' );
1495: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Number of success records deleted from Grants interface table :'||SQL%ROWCOUNT);
1496:
1497: END IF ;
1498:
1499: write_to_log('GMS :end time gms_ld_pkg.pre_process :'||to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')) ;

Line 1506: pa_cc_utils.log_message('Cannot get lock',1);

1502: commit;
1503:
1504: EXCEPTION
1505: WHEN RESOURCE_BUSY THEN
1506: pa_cc_utils.log_message('Cannot get lock',1);
1507: pa_cc_utils.reset_curr_function;
1508: write_to_log('GMS :RESOURCE_BUSY exception stage30 ') ;
1509: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1510: write_to_log('GMS :SQLERRM '||SQLERRM) ;

Line 1507: pa_cc_utils.reset_curr_function;

1503:
1504: EXCEPTION
1505: WHEN RESOURCE_BUSY THEN
1506: pa_cc_utils.log_message('Cannot get lock',1);
1507: pa_cc_utils.reset_curr_function;
1508: write_to_log('GMS :RESOURCE_BUSY exception stage30 ') ;
1509: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1510: write_to_log('GMS :SQLERRM '||SQLERRM) ;
1511: raise_application_error(SQLCODE,SQLERRM) ;

Line 1513: pa_cc_utils.log_message('No data found for some item..', 1);

1509: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1510: write_to_log('GMS :SQLERRM '||SQLERRM) ;
1511: raise_application_error(SQLCODE,SQLERRM) ;
1512: when no_data_found then
1513: pa_cc_utils.log_message('No data found for some item..', 1);
1514: write_to_log('GMS :NO_DATA_FOUND exception stage30 ') ;
1515: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1516: write_to_log('GMS :SQLERRM '||SQLERRM) ;
1517: raise_application_error(SQLCODE, SQLERRM) ;

Line 1520: pa_cc_utils.log_message('Unexpected error: '||SQLERRM,1);

1516: write_to_log('GMS :SQLERRM '||SQLERRM) ;
1517: raise_application_error(SQLCODE, SQLERRM) ;
1518: rollback ;
1519: when others then
1520: pa_cc_utils.log_message('Unexpected error: '||SQLERRM,1);
1521: write_to_log('GMS :OTHERS exception stage30 ') ;
1522: write_to_log('GMS :SQLCODE '||SQLCODE) ;
1523: write_to_log('GMS :SQLERRM '||SQLERRM) ;
1524: raise_application_error(SQLCODE, SQLERRM) ;