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

Line 16: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode ;

12: -- Run id of the batch being processed.
13: -- 3699045
14: current_sponsored_flag gms_project_types.sponsored_flag%TYPE := 'N' ;
15:
16: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode ;
17:
18: P_BTC_SRC_RESRC varchar2(1) := NVL(FND_PROFILE.value('PA_RPT_BTC_SRC_RESRC'), 'N'); -- 4057874
19: G_MOAC_ORG_ID NUMBER ;
20:

Line 501: if pa_cc_utils.g_debug_mode then

497: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
498:
499: -- Step 1 . Select All projects
500:
501: if pa_cc_utils.g_debug_mode then
502: l_debug_mode := 'Y';
503: else
504: l_debug_mode := 'N';
505: end if;

Line 511: pa_cc_utils.set_curr_function('create_burden_expenditure_item');

507: x_process => 'PLSQL',
508: x_debug_mode => l_debug_mode);
509: pa_debug.G_Err_Stage := 'Starting Create_burden_expenditure_item' ;
510:
511: pa_cc_utils.set_curr_function('create_burden_expenditure_item');
512:
513: IF P_DEBUG_MODE THEN
514: pa_cc_utils.log_message('50:Entered create_burden_expenditure_item');
515: END IF;

Line 514: pa_cc_utils.log_message('50:Entered create_burden_expenditure_item');

510:
511: pa_cc_utils.set_curr_function('create_burden_expenditure_item');
512:
513: IF P_DEBUG_MODE THEN
514: pa_cc_utils.log_message('50:Entered create_burden_expenditure_item');
515: END IF;
516:
517: begin
518: -- Expenditure group is set to current run id of the program

Line 526: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '100:Select Org_id from Implementations');

522: stage := 100; -- At start
523:
524: /*
525: IF P_DEBUG_MODE THEN
526: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '100:Select Org_id from Implementations');
527: END IF;
528: select org_id
529: into x_org_id
530: from pa_implementations;

Line 533: pa_cc_utils.log_message('Create_Burden_Expenditure_Item: ' || '100:Select Current Org_id.');

529: into x_org_id
530: from pa_implementations;
531: */
532: IF P_DEBUG_MODE THEN
533: pa_cc_utils.log_message('Create_Burden_Expenditure_Item: ' || '100:Select Current Org_id.');
534: END IF;
535: IF ( G_MOAC_ORG_ID IS NULL )
536: THEN
537: G_MOAC_ORG_ID := pa_moac_utils.get_current_org_id ;

Line 550: * pa_cc_utils.log_message('150:Get Exp Group and Run Id');

546: THEN
547: l_profile_set_size := l_default_set_size ;
548: END IF;
549: /* Bug# 2255068
550: * pa_cc_utils.log_message('150:Get Exp Group and Run Id');
551: * select SUBSTRB(meaning,1,6), pa_burden_sum_run_s.nextval
552: * into exp_group, current_run_id
553: * from pa_lookups
554: * where lookup_type = 'BURDEN_ACCOUNTING'

Line 562: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '200:Get Exp Group and Run Id:No_Data_Found');

558: */
559: exception
560: when no_data_found then
561: IF P_DEBUG_MODE THEN
562: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '200:Get Exp Group and Run Id:No_Data_Found');
563: END IF;
564: goto END_OF_PROCESS;
565: when others then
566: IF P_DEBUG_MODE THEN

Line 567: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '200:Get Exp Group and Run Id:Others');

563: END IF;
564: goto END_OF_PROCESS;
565: when others then
566: IF P_DEBUG_MODE THEN
567: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '200:Get Exp Group and Run Id:Others');
568: END IF;
569: goto END_OF_PROCESS;
570: end;
571:

Line 639: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '250:Processing for Project:'||to_char(proj_rec.project_id));

635: proj_rec.dest_task_id := l_tbl_dest_task_id(K);
636: proj_rec.burden_amt_display_method := l_tbl_burden_amt_disp_method(K);
637:
638: IF P_DEBUG_MODE THEN
639: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '250:Processing for Project:'||to_char(proj_rec.project_id));
640: END IF;
641: stage := 110; -- in project loop
642: -- Set current project id in the package pa_burden_costing for
643: -- view definitions and for local variable

Line 646: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '300:before set current project id');

642: -- Set current project id in the package pa_burden_costing for
643: -- view definitions and for local variable
644:
645: IF P_DEBUG_MODE THEN
646: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '300:before set current project id');
647: END IF;
648:
649: /*PA_BURDEN_COSTING.set_current_project_id(proj_rec.project_id); 5406802*/
650:

Line 662: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '350:after set current project id');

658: END IF;
659:
660: current_project_id := proj_rec.project_id;
661: IF P_DEBUG_MODE THEN
662: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '350:after set current project id');
663: END IF;
664:
665: l_proj_bc_enabled := Pa_Funds_Control_Utils.Get_Fnd_Reqd_Flag(current_project_id, 'STD'); /* 5406802 moved here */
666:

Line 677: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '400:within if for burden_account and same ei case');

673: over_project_id := proj_rec.dest_project_id;
674: over_task_id := proj_rec.dest_task_id;
675:
676: IF P_DEBUG_MODE THEN
677: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '400:within if for burden_account and same ei case');
678: END IF;
679: if over_project_id is null or over_task_id is null then
680: begin
681:

Line 688: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '450:before update CDL for error:project_task_null');

684: -- project/task is opted
685: -- Mark all the CDLs of the project with error
686: stage := 120; -- in CDL update for project/task null
687: IF P_DEBUG_MODE THEN
688: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '450:before update CDL for error:project_task_null');
689: END IF;
690:
691: /* Removed ei table and pa_tasks table and changed cdl_all table to cdl view for
692: bug# 1668634 */

Line 748: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '500:after update CDL for error:project_task_null');

744: END IF ;
745: end loop ;
746:
747: IF P_DEBUG_MODE THEN
748: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '500:after update CDL for error:project_task_null');
749: END IF;
750: goto NEXT_PROJECT;
751: exception
752: when others then

Line 754: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '550:CDL update:Others');

750: goto NEXT_PROJECT;
751: exception
752: when others then
753: IF P_DEBUG_MODE THEN
754: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '550:CDL update:Others');
755: END IF;
756: goto NEXT_PROJECT;
757: end;
758: end if;

Line 769: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '600:Lock the current Project');

765:
766: begin
767: stage := 130; -- Locking current project
768: IF P_DEBUG_MODE THEN
769: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '600:Lock the current Project');
770: END IF;
771: select attribute1
772: into l_attribute1
773: from pa_projects_all

Line 827: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '603:Update CDL with prev_ind_compiled_set_id');

823:
824: If l_burden_profile ='Y' Then /*3040724 :process special eis only when profile is 'Y'*/
825:
826: IF P_DEBUG_MODE THEN
827: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '603:Update CDL with prev_ind_compiled_set_id');
828: END IF;
829: /*SOM Bug# 5743708*/
830: l_tbl_eiid.delete;
831: l_tbl_cdlln.delete;

Line 900: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '604:Creating Audit in pa_aud_cost_dist_lines');

896: and ei.expenditure_Item_id = l_tbl_eiid(i);
897:
898:
899: IF P_DEBUG_MODE THEN
900: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '604:Creating Audit in pa_aud_cost_dist_lines');
901: END IF;
902:
903: PA_BURDEN_COSTING.InsBurdenAudit(current_project_id,x_request_id,l_user_id,lstatus);
904:

Line 908: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '605:Deriving compiled set id for special eis');

904:
905: /*To get compiled set for special cdls and update on ei and cdl*/
906:
907: IF P_DEBUG_MODE THEN
908: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '605:Deriving compiled set id for special eis');
909: END IF;
910:
911:
912: OPEN get_compile_cursor(current_project_id) ;

Line 1001: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '607 STATUS :Update eis/cdls ');/5980459/

997: END IF ; /*If ((l_status = 100) and (l_stage = 400))*/
998: END loop ;
999:
1000: IF P_DEBUG_MODE THEN
1001: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '607 STATUS :Update eis/cdls ');/*5980459*/
1002: END IF;
1003:
1004: FORALL i in 1..l_eiid_tbl.count
1005: update pa_cost_distribution_lines cdl

Line 1168: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '606:Update CDL with rejection reason ');

1164: reason := 'GET_INDIRECT_COST_FAIL';
1165: END IF;
1166:
1167: IF P_DEBUG_MODE THEN
1168: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '606:Update CDL with rejection reason ');
1169: END IF;
1170:
1171: update pa_cost_distribution_lines cdl
1172: set cdl.burden_sum_rejection_code = reason,

Line 1195: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '607:Update eis/cdls with newly derived compiled set id ');

1191:
1192: /*2933915 : Update affected ei with the newly derived compiled set_id
1193:
1194: IF P_DEBUG_MODE THEN
1195: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '607:Update eis/cdls with newly derived compiled set id ');
1196: END IF;
1197:
1198: IF ((l_status = 0) OR (l_status =100 AND l_stage =400)) THEN
1199:

Line 1243: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '608:Special cdls are also ready for resummarized now ');

1239: END IF ; /*2933915 :End if -((status = 0) OR (status =100 AND stage =400))
1240: END LOOP; /* End loop for get_compile_cursor
1241: */
1242: IF P_DEBUG_MODE THEN
1243: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '608:Special cdls are also ready for resummarized now ');
1244: END IF;
1245: End if ; /*End of profile option check :3040724*/
1246:
1247: /*End of changes for 2933915*/

Line 1253: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '650:Lock the CDLs');

1249: begin
1250: stage := 140; -- Locking CDLs, initializing rejection code
1251:
1252: IF P_DEBUG_MODE THEN
1253: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '650:Lock the CDLs');
1254: END IF;
1255:
1256: /*Bug#2255068 :Resetting this flag */
1257:

Line 1449: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '700:Lock the CDLs:Resource_busy');

1445: */
1446: exception
1447: when resource_busy then
1448: IF P_DEBUG_MODE THEN
1449: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '700:Lock the CDLs:Resource_busy');
1450: END IF;
1451: ROLLBACK;
1452: goto NEXT_PROJECT;
1453: when others then

Line 1456: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '700:Lock the CDLs:Others');

1452: goto NEXT_PROJECT;
1453: when others then
1454: ROLLBACK;
1455: IF P_DEBUG_MODE THEN
1456: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '700:Lock the CDLs:Others');
1457: END IF;
1458: goto NEXT_PROJECT;
1459: end;
1460:

Line 1487: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '850:call Flusheitabs');

1483: /* EOM Bug# 5406802 */
1484: begin
1485:
1486: IF P_DEBUG_MODE THEN
1487: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '850:call Flusheitabs');
1488: END IF;
1489: pa_transactions.FlushEiTabs();
1490: i := 0;
1491: /*=========================================================+

Line 1568: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '900:Processing for:'||bcc_rec.dest_summary_group);

1564:
1565: -- 5a. For each invokation create only one expenditure group.
1566:
1567: IF P_DEBUG_MODE THEN
1568: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '900:Processing for:'||bcc_rec.dest_summary_group);
1569: END IF;
1570: if (create_exp_grp_flag ) then
1571: IF P_DEBUG_MODE THEN
1572: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');

Line 1572: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');

1568: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '900:Processing for:'||bcc_rec.dest_summary_group);
1569: END IF;
1570: if (create_exp_grp_flag ) then
1571: IF P_DEBUG_MODE THEN
1572: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');
1573: END IF;
1574: pa_transactions.InsertExpGroup(exp_group,'APPROVED',sysdate,'BTC',0,NULL,NULL,G_MOAC_ORG_ID);
1575: IF P_DEBUG_MODE THEN
1576: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1000:back from insertexpgroup');

Line 1576: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1000:back from insertexpgroup');

1572: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');
1573: END IF;
1574: pa_transactions.InsertExpGroup(exp_group,'APPROVED',sysdate,'BTC',0,NULL,NULL,G_MOAC_ORG_ID);
1575: IF P_DEBUG_MODE THEN
1576: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1000:back from insertexpgroup');
1577: END IF;
1578: -- Handle error
1579: create_exp_grp_flag := FALSE;
1580: end if;

Line 1625: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1050:Get Expenditure Information');

1621: else
1622: -- begining of a block to process items
1623: begin
1624: IF P_DEBUG_MODE THEN
1625: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1050:Get Expenditure Information');
1626: END IF;
1627: /*===================================================+
1628: | Bug 4115096 : Added person_id check to create new |
1629: | Expenditure for change in person. |

Line 1644: pa_cc_utils.log_message('create_burden_expenditure_item: ' || 'See ->exp_id'||exp_id);

1640: and expenditure_ending_date = l_next_weekend_date -- Bug 3551106
1641: and nvl(vendor_id,-99) = nvl(bcc_rec.source_vendor_id,-99); -- Bug 6993002
1642:
1643: IF P_DEBUG_MODE THEN
1644: pa_cc_utils.log_message('create_burden_expenditure_item: ' || 'See ->exp_id'||exp_id);
1645: END IF;
1646: exception
1647: when no_data_found then
1648: IF P_DEBUG_MODE THEN

Line 1649: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1100:Get Expenditure Information:No_data_found');

1645: END IF;
1646: exception
1647: when no_data_found then
1648: IF P_DEBUG_MODE THEN
1649: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1100:Get Expenditure Information:No_data_found');
1650: END IF;
1651: create_exp_flag := TRUE;
1652: exp_org_id := bcc_rec.source_org_id;
1653: end;

Line 1660: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1150:Get Expenditure Id from sequence');

1656:
1657: if (create_exp_flag ) then
1658: -- Get new expenditure id
1659: IF P_DEBUG_MODE THEN
1660: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1150:Get Expenditure Id from sequence');
1661: END IF;
1662: select pa_expenditures_s.nextval
1663: into exp_id from dual;
1664: stage := 170; -- Creating burden expenditure

Line 1675: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1200:Call InsertExp');

1671: Multi-Currency Related changes: Added additional parameters (denom currency code and acct currency code;
1672: all other currency attributes are set to null)
1673: */
1674: IF P_DEBUG_MODE THEN
1675: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1200:Call InsertExp');
1676: END IF;
1677: pa_transactions.InsertExp(
1678: x_expenditure_id =>exp_id,
1679: x_expend_status =>'APPROVED',

Line 1712: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1250:Back from InsertExp');

1708: ,P_Org_Id => G_MOAC_ORG_ID
1709: );
1710:
1711: IF P_DEBUG_MODE THEN
1712: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1250:Back from InsertExp');
1713: END IF;
1714: -- Setting the flag to false to avoid unnecessary insertion of the records
1715: -- 09/11/98
1716: create_exp_flag := FALSE;

Line 1726: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1300:No change in Summary Group ..');

1722: -- 5c. Create expenditure item for every dest_summary_group change
1723:
1724: if bcc_rec.dest_summary_group = prev_bcc_rec.dest_summary_group and NVL(l_prev_expenditure_id,-1) = NVL(l_curr_expenditure_id,-1) then -- Bug 3551106
1725: IF P_DEBUG_MODE THEN
1726: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1300:No change in Summary Group ..');
1727: END IF;
1728: l_burden_cost := l_burden_cost + bcc_rec.source_burden_cost;
1729:
1730: /*

Line 1748: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1350:Change in Summary Group ..');

1744: end if;
1745: ******/
1746: else
1747: IF P_DEBUG_MODE THEN
1748: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1350:Change in Summary Group ..');
1749: END IF;
1750:
1751: -- Create new summarization expenditure item
1752: -- Get new expenditure item id

Line 1783: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1400:Get Expenditure Item Id from Sequence');

1779: if ( l_denom_burdened_cost <> 0 OR l_acct_burdened_cost <> 0 OR l_burden_cost <> 0 OR l_project_burdened_cost <> 0 )
1780: then
1781: begin
1782: IF P_DEBUG_MODE THEN
1783: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1400:Get Expenditure Item Id from Sequence');
1784: END IF;
1785: select pa_expenditure_items_s.nextval
1786: into exp_item_id from dual;
1787: i := i +1;

Line 1800: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1450:No Dest Override');

1796: then
1797: -- if bcc_rec.dest_task_id is NULL then -- commented for bug 3069632
1798: if proj_rec.dest_task_id is NULL then
1799: IF P_DEBUG_MODE THEN
1800: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1450:No Dest Override');
1801: END IF;
1802: over_task_id := bcc_rec.source_task_id;
1803: over_project_id := bcc_rec.source_project_id;
1804: else -- destination override was provided by user

Line 1806: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1500:Dest Override');

1802: over_task_id := bcc_rec.source_task_id;
1803: over_project_id := bcc_rec.source_project_id;
1804: else -- destination override was provided by user
1805: IF P_DEBUG_MODE THEN
1806: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1500:Dest Override');
1807: END IF;
1808: /*3069632 :Commented ************************
1809: over_task_id := bcc_rec.dest_task_id;
1810: over_project_id := bcc_rec.dest_project_id;

Line 1822: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1510:Calling Get_work_type_id with Project_id [' ||

1818: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
1819: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1820: THEN
1821: IF P_DEBUG_MODE THEN
1822: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1510:Calling Get_work_type_id with Project_id [' ||
1823: to_char(over_project_id) ||
1824: '] task_id [' || to_char(over_task_id) || ']');
1825: END IF;
1826:

Line 1833: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1520:Obtained work_type_id [' || to_char(l_work_type_id) || ']');

1829: ,p_task_id => over_task_id
1830: ,p_assignment_id => NULL
1831: );
1832: IF P_DEBUG_MODE THEN
1833: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1520:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
1834: END IF;
1835: END IF; -- 2607781
1836:
1837: -- The following section of the code was added by Sandeep. It gets

Line 1855: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1550:Call PATC for project,task or exp type change');

1851: calculated using existing CDL's which are already converted.
1852: */
1853:
1854: IF P_DEBUG_MODE THEN
1855: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1550:Call PATC for project,task or exp type change');
1856: END IF;
1857: /* modified for the Bug#1825827 */
1858: pa_transactions_pub.validate_transaction(
1859: x_project_id =>over_project_id,

Line 1908: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1600:Back from PATC call');

1904: p_sys_link_function => 'BTC',
1905: p_work_type_id => l_work_type_id -- 2607781
1906: );
1907: IF P_DEBUG_MODE THEN
1908: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1600:Back from PATC call');
1909: END IF;
1910: if c_status is not null then
1911: null ;
1912: end if;

Line 1946: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Calling Get_work_type_id with Project_id [' ||

1942: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
1943: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1944: THEN
1945: IF P_DEBUG_MODE THEN
1946: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Calling Get_work_type_id with Project_id [' ||
1947: to_char(over_project_id) ||
1948: '] task_id [' || to_char(over_task_id) || ']');
1949: END IF;
1950:

Line 1957: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Obtained work_type_id [' || to_char(l_work_type_id) || ']');

1953: ,p_task_id => over_task_id
1954: ,p_assignment_id => NULL
1955: );
1956: IF P_DEBUG_MODE THEN
1957: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
1958: END IF;
1959: END IF; */
1960:
1961: /*

Line 1974: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1650:Call Loadei');

1970: * prev_bcc_rec.source_org_id - because exp_org_id actually holds the
1971: * organization_id of the next grouping.
1972: */
1973: IF P_DEBUG_MODE THEN
1974: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1650:Call Loadei');
1975: END IF;
1976:
1977: pa_transactions.LoadEi(
1978: x_expenditure_item_id =>exp_item_id,

Line 2062: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1700:Back from Loadei');

2058: ,p_vendor_id => prev_bcc_rec.source_vendor_id -- Bug 6993002
2059: ,p_cbs_element_id => prev_bcc_rec.cbs_element_id -- Added for CBS enahncement bug 16579913
2060: );
2061: IF P_DEBUG_MODE THEN
2062: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1700:Back from Loadei');
2063: END IF;
2064:
2065:
2066: -- Frequently create EI and flush EiTabs to reduce load on LoadEi

Line 2069: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1750:Call Insitems for i>=500');

2065:
2066: -- Frequently create EI and flush EiTabs to reduce load on LoadEi
2067: if ( i >= 500) then
2068: IF P_DEBUG_MODE THEN
2069: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1750:Call Insitems for i>=500');
2070: END IF;
2071: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');
2072:
2073: -- -----------------------------------------------------------------------

Line 2081: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');

2077: -- The folowing procedure returns doing nothing if status returned from
2078: -- pa_transactions.InsItemsis is in error.
2079: -- ------------------------------------------------------------------------
2080: IF P_DEBUG_MODE THEN
2081: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2082: END IF;
2083: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2084: IF P_DEBUG_MODE THEN
2085: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');

Line 2085: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');

2081: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2082: END IF;
2083: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2084: IF P_DEBUG_MODE THEN
2085: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2086: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
2087: END IF;
2088: pa_transactions.FlushEiTabs();
2089: IF P_DEBUG_MODE THEN

Line 2086: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');

2082: END IF;
2083: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2084: IF P_DEBUG_MODE THEN
2085: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2086: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
2087: END IF;
2088: pa_transactions.FlushEiTabs();
2089: IF P_DEBUG_MODE THEN
2090: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1850:Back from FlushEiTabs');

Line 2090: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1850:Back from FlushEiTabs');

2086: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
2087: END IF;
2088: pa_transactions.FlushEiTabs();
2089: IF P_DEBUG_MODE THEN
2090: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1850:Back from FlushEiTabs');
2091: END IF;
2092: i := 0;
2093: end if;
2094: -- end of a block to process items

Line 2128: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1900:Display method D and dest task id null');

2124: then
2125: ----- if bcc_rec.dest_task_id is NULL then
2126: if proj_rec.dest_task_id is NULL then
2127: IF P_DEBUG_MODE THEN
2128: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1900:Display method D and dest task id null');
2129: END IF;
2130: over_task_id := bcc_rec.source_task_id;
2131: over_project_id := bcc_rec.source_project_id;
2132: else -- destination override was provided by user

Line 2134: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1950:Display method D and dest task id provided');

2130: over_task_id := bcc_rec.source_task_id;
2131: over_project_id := bcc_rec.source_project_id;
2132: else -- destination override was provided by user
2133: IF P_DEBUG_MODE THEN
2134: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1950:Display method D and dest task id provided');
2135: END IF;
2136: /*3069632 :Commented this
2137: over_task_id := bcc_rec.dest_task_id;
2138: over_project_id := bcc_rec.dest_project_id;

Line 2148: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2000:Display method S');

2144: end if;
2145: end if;
2146: if (proj_rec.burden_amt_display_method='S') then
2147: IF P_DEBUG_MODE THEN
2148: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2000:Display method S');
2149: END IF;
2150:
2151: /*3069632 :Commented this
2152: over_task_id := bcc_rec.dest_task_id;

Line 2236: pa_cc_utils.log_message('create_burden_expenditure_item: ' ||

2232:
2233: /* bug fix 4091690 starts */
2234:
2235: IF P_DEBUG_MODE THEN
2236: pa_cc_utils.log_message('create_burden_expenditure_item: ' ||
2237: '1625:Call pa_client_extn_burden_summary grouping.CLIENT_column_values');
2238: END IF;
2239:
2240: /*

Line 2271: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1625:Call pa_client_extn_burden_resource.client_column_values');

2267:
2268: If P_BTC_SRC_RESRC = 'Y' then -- 4057874
2269:
2270: IF P_DEBUG_MODE THEN
2271: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1625:Call pa_client_extn_burden_resource.client_column_values');
2272: END IF;
2273:
2274: pa_client_extn_burden_resource.client_column_values (
2275: p_job_id => prev_bcc_rec.source_job_id,

Line 2302: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2050:End of bcc rec loop');

2298:
2299: /* bug fix 4091690 */
2300:
2301: IF P_DEBUG_MODE THEN
2302: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2050:End of bcc rec loop');
2303: END IF;
2304: end loop;
2305: end;
2306:

Line 2338: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2100:Process Last set .. Get Exp item id from sequence');

2334: then
2335: begin
2336:
2337: IF P_DEBUG_MODE THEN
2338: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2100:Process Last set .. Get Exp item id from sequence');
2339: END IF;
2340: select pa_expenditure_items_s.nextval
2341: into exp_item_id from dual;
2342:

Line 2347: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||

2343: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2344: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2345: THEN
2346: IF P_DEBUG_MODE THEN
2347: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||
2348: to_char(over_project_id) ||
2349: '] task_id [' || to_char(over_task_id) || ']');
2350: END IF;
2351: l_work_type_id := pa_utils4.Get_work_type_id

Line 2357: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2120:Obtained work_type_id [' || to_char(l_work_type_id) || ']');

2353: ,p_task_id => over_task_id
2354: ,p_assignment_id => NULL
2355: );
2356: IF P_DEBUG_MODE THEN
2357: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2120:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
2358: END IF;
2359: END IF; -- 2607781
2360:
2361:

Line 2377: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2150:Process Last Set .. call PATC');

2373: calculated using existing CDL's which are already converted.
2374: */
2375:
2376: IF P_DEBUG_MODE THEN
2377: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2150:Process Last Set .. call PATC');
2378: END IF;
2379: /* modified for the Bug#1825827 */
2380: pa_transactions_pub.validate_transaction(
2381: x_project_id =>over_project_id,

Line 2430: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2200:Process Last Set .. back from PATC');

2426: p_sys_link_function => 'BTC',
2427: p_work_type_id => l_work_type_id -- 2607781
2428: );
2429: IF P_DEBUG_MODE THEN
2430: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2200:Process Last Set .. back from PATC');
2431: END IF;
2432: if c_status is not null then
2433: null ;
2434: end if;

Line 2450: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||

2446: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
2447: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2448: THEN
2449: IF P_DEBUG_MODE THEN
2450: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||
2451: to_char(over_project_id) ||
2452: '] task_id [' || to_char(over_task_id) || ']');
2453: END IF;
2454: l_work_type_id := pa_utils4.Get_work_type_id

Line 2460: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Obtained work_type_id [' || to_char(l_work_type_id) || ']');

2456: ,p_task_id => over_task_id
2457: ,p_assignment_id => NULL
2458: );
2459: IF P_DEBUG_MODE THEN
2460: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
2461: END IF;
2462: END IF; */
2463:
2464: /*

Line 2477: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2250:Process Last Set ..Call Loadei');

2473:
2474: -- IC Changes
2475: -- BTC txns should not be cross charged, so setting cross charge code to X.
2476: IF P_DEBUG_MODE THEN
2477: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2250:Process Last Set ..Call Loadei');
2478: END IF;
2479: pa_transactions.LoadEi(
2480: x_expenditure_item_id =>exp_item_id,
2481: x_expenditure_id =>x_exp_id,

Line 2567: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2300:Process Last Set ..Call Insitems');

2563:
2564: end if;
2565: if i > 0 then
2566: IF P_DEBUG_MODE THEN
2567: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2300:Process Last Set ..Call Insitems');
2568: END IF;
2569: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');
2570:
2571: -- -----------------------------------------------------------------------

Line 2579: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');

2575: -- The folowing procedure returns doing nothing if status is in ERROR for
2576: -- pa_transactions.InsItems.
2577: -- ------------------------------------------------------------------------
2578: IF P_DEBUG_MODE THEN
2579: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2580: END IF;
2581:
2582: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2583:

Line 2585: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');

2581:
2582: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2583:
2584: IF P_DEBUG_MODE THEN
2585: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2586: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');
2587: END IF;
2588: pa_transactions.FlushEiTabs();
2589: i := 0;

Line 2586: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');

2582: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2583:
2584: IF P_DEBUG_MODE THEN
2585: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2586: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');
2587: END IF;
2588: pa_transactions.FlushEiTabs();
2589: i := 0;
2590: end if;

Line 2599: * pa_cc_utils.log_message('2400:Update successful CDLs');

2595: *
2596: *
2597: * ** Update those CDLs which are successfully processed with run id
2598: *
2599: * pa_cc_utils.log_message('2400:Update successful CDLs');
2600: *
2601: * ** Removed ei table and pa_tasks table and
2602: * changed cdl_all table to cdl view for
2603: * bug# 1668634

Line 2613: * pa_cc_utils.log_message('2500:before commit');

2609: * and cdl.project_id = current_project_id
2610: * cdl.PA_DATE <= nvl(to_date(x_end_date,'DD-MM-RR'),cdl.PA_DATE)
2611: * and request_id = x_request_id ;
2612: *
2613: * pa_cc_utils.log_message('2500:before commit');
2614: */
2615:
2616:
2617: /* IF ( l_last_batch_for_project = 'Y')

Line 2717: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2550:End of Project loop');

2713: COMMIT ;
2714: end loop; -- Loop for processing CDLs in batches for this project.
2715:
2716: IF P_DEBUG_MODE THEN
2717: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2550:End of Project loop');
2718: END IF;
2719: <>
2720: null;
2721: END LOOP; -- FOR LOOP

Line 2738: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2600:At the end of the Process');

2734: /* E.N. Bug 3618193 : Added following code to close the cursor */
2735:
2736: <>
2737: IF P_DEBUG_MODE THEN
2738: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2600:At the end of the Process');
2739: END IF;
2740: null;
2741: x_run_id := current_run_id;
2742: pa_cc_utils.reset_curr_function;

Line 2742: pa_cc_utils.reset_curr_function;

2738: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2600:At the end of the Process');
2739: END IF;
2740: null;
2741: x_run_id := current_run_id;
2742: pa_cc_utils.reset_curr_function;
2743: end create_burden_expenditure_item;
2744:
2745:
2746: