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 505: if pa_cc_utils.g_debug_mode then

501: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
502:
503: -- Step 1 . Select All projects
504:
505: if pa_cc_utils.g_debug_mode then
506: l_debug_mode := 'Y';
507: else
508: l_debug_mode := 'N';
509: end if;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

754: goto NEXT_PROJECT;
755: exception
756: when others then
757: IF P_DEBUG_MODE THEN
758: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '550:CDL update:Others');
759: END IF;
760: goto NEXT_PROJECT;
761: end;
762: end if;

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

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

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

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

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

869: and ei.expenditure_Item_id = l_tbl_eiid(i);
870:
871:
872: IF P_DEBUG_MODE THEN
873: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '604:Creating Audit in pa_aud_cost_dist_lines');
874: END IF;
875:
876: PA_BURDEN_COSTING.InsBurdenAudit(current_project_id,x_request_id,l_user_id,lstatus);
877:

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

877:
878: /*To get compiled set for special cdls and update on ei and cdl*/
879:
880: IF P_DEBUG_MODE THEN
881: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '605:Deriving compiled set id for special eis');
882: END IF;
883:
884:
885: OPEN get_compile_cursor(current_project_id) ;

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

970: END IF ; /*If ((l_status = 100) and (l_stage = 400))*/
971: END loop ;
972:
973: IF P_DEBUG_MODE THEN
974: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '607 STATUS :Update eis/cdls ');/*5980459*/
975: END IF;
976:
977: FORALL i in 1..l_eiid_tbl.count
978: update pa_cost_distribution_lines cdl

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

1129: reason := 'GET_INDIRECT_COST_FAIL';
1130: END IF;
1131:
1132: IF P_DEBUG_MODE THEN
1133: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '606:Update CDL with rejection reason ');
1134: END IF;
1135:
1136: update pa_cost_distribution_lines cdl
1137: set cdl.burden_sum_rejection_code = reason,

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

1156:
1157: /*2933915 : Update affected ei with the newly derived compiled set_id
1158:
1159: IF P_DEBUG_MODE THEN
1160: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '607:Update eis/cdls with newly derived compiled set id ');
1161: END IF;
1162:
1163: IF ((l_status = 0) OR (l_status =100 AND l_stage =400)) THEN
1164:

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

1204: END IF ; /*2933915 :End if -((status = 0) OR (status =100 AND stage =400))
1205: END LOOP; /* End loop for get_compile_cursor
1206: */
1207: IF P_DEBUG_MODE THEN
1208: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '608:Special cdls are also ready for resummarized now ');
1209: END IF;
1210: End if ; /*End of profile option check :3040724*/
1211:
1212: /*End of changes for 2933915*/

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

1214: begin
1215: stage := 140; -- Locking CDLs, initializing rejection code
1216:
1217: IF P_DEBUG_MODE THEN
1218: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '650:Lock the CDLs');
1219: END IF;
1220:
1221: /*Bug#2255068 :Resetting this flag */
1222:

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

1311: */
1312: exception
1313: when resource_busy then
1314: IF P_DEBUG_MODE THEN
1315: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '700:Lock the CDLs:Resource_busy');
1316: END IF;
1317: ROLLBACK;
1318: goto NEXT_PROJECT;
1319: when others then

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

1318: goto NEXT_PROJECT;
1319: when others then
1320: ROLLBACK;
1321: IF P_DEBUG_MODE THEN
1322: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '700:Lock the CDLs:Others');
1323: END IF;
1324: goto NEXT_PROJECT;
1325: end;
1326:

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

1349: /* EOM Bug# 5406802 */
1350: begin
1351:
1352: IF P_DEBUG_MODE THEN
1353: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '850:call Flusheitabs');
1354: END IF;
1355: pa_transactions.FlushEiTabs();
1356: i := 0;
1357: /*=========================================================+

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

1429:
1430: -- 5a. For each invokation create only one expenditure group.
1431:
1432: IF P_DEBUG_MODE THEN
1433: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '900:Processing for:'||bcc_rec.dest_summary_group);
1434: END IF;
1435: if (create_exp_grp_flag ) then
1436: IF P_DEBUG_MODE THEN
1437: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');

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

1433: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '900:Processing for:'||bcc_rec.dest_summary_group);
1434: END IF;
1435: if (create_exp_grp_flag ) then
1436: IF P_DEBUG_MODE THEN
1437: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');
1438: END IF;
1439: pa_transactions.InsertExpGroup(exp_group,'APPROVED',sysdate,'BTC',0,NULL,NULL,G_MOAC_ORG_ID);
1440: IF P_DEBUG_MODE THEN
1441: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1000:back from insertexpgroup');

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

1437: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '950:call to insertexpgroup');
1438: END IF;
1439: pa_transactions.InsertExpGroup(exp_group,'APPROVED',sysdate,'BTC',0,NULL,NULL,G_MOAC_ORG_ID);
1440: IF P_DEBUG_MODE THEN
1441: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1000:back from insertexpgroup');
1442: END IF;
1443: -- Handle error
1444: create_exp_grp_flag := FALSE;
1445: end if;

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

1486: else
1487: -- begining of a block to process items
1488: begin
1489: IF P_DEBUG_MODE THEN
1490: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1050:Get Expenditure Information');
1491: END IF;
1492: /*===================================================+
1493: | Bug 4115096 : Added person_id check to create new |
1494: | Expenditure for change in person. |

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

1504: and NVL(incurred_by_person_id,-99) = nvl(bcc_rec.source_incurred_by_person_id,-99) -- changes done for 4324340 . Bug 4115096 and added NVL By 4282553
1505: and expenditure_ending_date = l_next_weekend_date; -- Bug 3551106
1506:
1507: IF P_DEBUG_MODE THEN
1508: pa_cc_utils.log_message('create_burden_expenditure_item: ' || 'See ->exp_id'||exp_id);
1509: END IF;
1510: exception
1511: when no_data_found then
1512: IF P_DEBUG_MODE THEN

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

1509: END IF;
1510: exception
1511: when no_data_found then
1512: IF P_DEBUG_MODE THEN
1513: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1100:Get Expenditure Information:No_data_found');
1514: END IF;
1515: create_exp_flag := TRUE;
1516: exp_org_id := bcc_rec.source_org_id;
1517: end;

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

1520:
1521: if (create_exp_flag ) then
1522: -- Get new expenditure id
1523: IF P_DEBUG_MODE THEN
1524: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1150:Get Expenditure Id from sequence');
1525: END IF;
1526: select pa_expenditures_s.nextval
1527: into exp_id from dual;
1528: stage := 170; -- Creating burden expenditure

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

1535: Multi-Currency Related changes: Added additional parameters (denom currency code and acct currency code;
1536: all other currency attributes are set to null)
1537: */
1538: IF P_DEBUG_MODE THEN
1539: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1200:Call InsertExp');
1540: END IF;
1541: pa_transactions.InsertExp(
1542: x_expenditure_id =>exp_id,
1543: x_expend_status =>'APPROVED',

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

1572: ,P_Org_Id => G_MOAC_ORG_ID
1573: );
1574:
1575: IF P_DEBUG_MODE THEN
1576: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1250:Back from InsertExp');
1577: END IF;
1578: -- Setting the flag to false to avoid unnecessary insertion of the records
1579: -- 09/11/98
1580: create_exp_flag := FALSE;

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

1583: -- 5c. Create expenditure item for every dest_summary_group change
1584:
1585: 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
1586: IF P_DEBUG_MODE THEN
1587: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1300:No change in Summary Group ..');
1588: END IF;
1589: l_burden_cost := l_burden_cost + bcc_rec.source_burden_cost;
1590:
1591: /*

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

1605: end if;
1606: ******/
1607: else
1608: IF P_DEBUG_MODE THEN
1609: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1350:Change in Summary Group ..');
1610: END IF;
1611:
1612: -- Create new summarization expenditure item
1613: -- Get new expenditure item id

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

1640: if ( l_denom_burdened_cost <> 0 OR l_acct_burdened_cost <> 0 OR l_burden_cost <> 0 OR l_project_burdened_cost <> 0 )
1641: then
1642: begin
1643: IF P_DEBUG_MODE THEN
1644: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1400:Get Expenditure Item Id from Sequence');
1645: END IF;
1646: select pa_expenditure_items_s.nextval
1647: into exp_item_id from dual;
1648: i := i +1;

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

1657: then
1658: -- if bcc_rec.dest_task_id is NULL then -- commented for bug 3069632
1659: if proj_rec.dest_task_id is NULL then
1660: IF P_DEBUG_MODE THEN
1661: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1450:No Dest Override');
1662: END IF;
1663: over_task_id := bcc_rec.source_task_id;
1664: over_project_id := bcc_rec.source_project_id;
1665: else -- destination override was provided by user

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

1663: over_task_id := bcc_rec.source_task_id;
1664: over_project_id := bcc_rec.source_project_id;
1665: else -- destination override was provided by user
1666: IF P_DEBUG_MODE THEN
1667: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1500:Dest Override');
1668: END IF;
1669: /*3069632 :Commented ************************
1670: over_task_id := bcc_rec.dest_task_id;
1671: over_project_id := bcc_rec.dest_project_id;

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

1679: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
1680: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1681: THEN
1682: IF P_DEBUG_MODE THEN
1683: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1510:Calling Get_work_type_id with Project_id [' ||
1684: to_char(over_project_id) ||
1685: '] task_id [' || to_char(over_task_id) || ']');
1686: END IF;
1687:

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

1690: ,p_task_id => over_task_id
1691: ,p_assignment_id => NULL
1692: );
1693: IF P_DEBUG_MODE THEN
1694: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1520:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
1695: END IF;
1696: END IF; -- 2607781
1697:
1698: -- The following section of the code was added by Sandeep. It gets

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

1712: calculated using existing CDL's which are already converted.
1713: */
1714:
1715: IF P_DEBUG_MODE THEN
1716: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1550:Call PATC for project,task or exp type change');
1717: END IF;
1718: /* modified for the Bug#1825827 */
1719: pa_transactions_pub.validate_transaction(
1720: x_project_id =>over_project_id,

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

1765: p_sys_link_function => 'BTC',
1766: p_work_type_id => l_work_type_id -- 2607781
1767: );
1768: IF P_DEBUG_MODE THEN
1769: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1600:Back from PATC call');
1770: END IF;
1771: if c_status is not null then
1772: null ;
1773: end if;

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

1803: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
1804: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
1805: THEN
1806: IF P_DEBUG_MODE THEN
1807: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Calling Get_work_type_id with Project_id [' ||
1808: to_char(over_project_id) ||
1809: '] task_id [' || to_char(over_task_id) || ']');
1810: END IF;
1811:

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

1814: ,p_task_id => over_task_id
1815: ,p_assignment_id => NULL
1816: );
1817: IF P_DEBUG_MODE THEN
1818: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1645:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
1819: END IF;
1820: END IF; */
1821:
1822: /*

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

1831: * prev_bcc_rec.source_org_id - because exp_org_id actually holds the
1832: * organization_id of the next grouping.
1833: */
1834: IF P_DEBUG_MODE THEN
1835: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1650:Call Loadei');
1836: END IF;
1837:
1838: pa_transactions.LoadEi(
1839: x_expenditure_item_id =>exp_item_id,

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

1917: ,p_Inventory_Item_Id => prev_bcc_rec.source_inventory_item_id -- 4057874
1918: ,p_src_system_linkage_function => prev_bcc_rec.source_system_linkage_function -- 4057874
1919: );
1920: IF P_DEBUG_MODE THEN
1921: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1700:Back from Loadei');
1922: END IF;
1923:
1924:
1925: -- Frequently create EI and flush EiTabs to reduce load on LoadEi

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

1924:
1925: -- Frequently create EI and flush EiTabs to reduce load on LoadEi
1926: if ( i >= 500) then
1927: IF P_DEBUG_MODE THEN
1928: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1750:Call Insitems for i>=500');
1929: END IF;
1930: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');
1931:
1932: -- -----------------------------------------------------------------------

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

1936: -- The folowing procedure returns doing nothing if status returned from
1937: -- pa_transactions.InsItemsis is in error.
1938: -- ------------------------------------------------------------------------
1939: IF P_DEBUG_MODE THEN
1940: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
1941: END IF;
1942: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
1943: IF P_DEBUG_MODE THEN
1944: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');

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

1940: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
1941: END IF;
1942: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
1943: IF P_DEBUG_MODE THEN
1944: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
1945: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
1946: END IF;
1947: pa_transactions.FlushEiTabs();
1948: IF P_DEBUG_MODE THEN

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

1941: END IF;
1942: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
1943: IF P_DEBUG_MODE THEN
1944: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
1945: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
1946: END IF;
1947: pa_transactions.FlushEiTabs();
1948: IF P_DEBUG_MODE THEN
1949: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1850:Back from FlushEiTabs');

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

1945: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1800:Call FlushEiTabs');
1946: END IF;
1947: pa_transactions.FlushEiTabs();
1948: IF P_DEBUG_MODE THEN
1949: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1850:Back from FlushEiTabs');
1950: END IF;
1951: i := 0;
1952: end if;
1953: -- end of a block to process items

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

1983: then
1984: ----- if bcc_rec.dest_task_id is NULL then
1985: if proj_rec.dest_task_id is NULL then
1986: IF P_DEBUG_MODE THEN
1987: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1900:Display method D and dest task id null');
1988: END IF;
1989: over_task_id := bcc_rec.source_task_id;
1990: over_project_id := bcc_rec.source_project_id;
1991: else -- destination override was provided by user

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

1989: over_task_id := bcc_rec.source_task_id;
1990: over_project_id := bcc_rec.source_project_id;
1991: else -- destination override was provided by user
1992: IF P_DEBUG_MODE THEN
1993: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1950:Display method D and dest task id provided');
1994: END IF;
1995: /*3069632 :Commented this
1996: over_task_id := bcc_rec.dest_task_id;
1997: over_project_id := bcc_rec.dest_project_id;

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

2003: end if;
2004: end if;
2005: if (proj_rec.burden_amt_display_method='S') then
2006: IF P_DEBUG_MODE THEN
2007: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2000:Display method S');
2008: END IF;
2009:
2010: /*3069632 :Commented this
2011: over_task_id := bcc_rec.dest_task_id;

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

2090:
2091: /* bug fix 4091690 starts */
2092:
2093: IF P_DEBUG_MODE THEN
2094: pa_cc_utils.log_message('create_burden_expenditure_item: ' ||
2095: '1625:Call pa_client_extn_burden_summary grouping.CLIENT_column_values');
2096: END IF;
2097:
2098: /*

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

2125:
2126: If P_BTC_SRC_RESRC = 'Y' then -- 4057874
2127:
2128: IF P_DEBUG_MODE THEN
2129: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1625:Call pa_client_extn_burden_resource.client_column_values');
2130: END IF;
2131:
2132: pa_client_extn_burden_resource.client_column_values (
2133: p_job_id => prev_bcc_rec.source_job_id,

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

2156:
2157: /* bug fix 4091690 */
2158:
2159: IF P_DEBUG_MODE THEN
2160: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2050:End of bcc rec loop');
2161: END IF;
2162: end loop;
2163: end;
2164:

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

2192: then
2193: begin
2194:
2195: IF P_DEBUG_MODE THEN
2196: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2100:Process Last set .. Get Exp item id from sequence');
2197: END IF;
2198: select pa_expenditure_items_s.nextval
2199: into exp_item_id from dual;
2200:

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

2201: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2202: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2203: THEN
2204: IF P_DEBUG_MODE THEN
2205: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2110:Calling Get_work_type_id with Project_id [' ||
2206: to_char(over_project_id) ||
2207: '] task_id [' || to_char(over_task_id) || ']');
2208: END IF;
2209: l_work_type_id := pa_utils4.Get_work_type_id

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

2211: ,p_task_id => over_task_id
2212: ,p_assignment_id => NULL
2213: );
2214: IF P_DEBUG_MODE THEN
2215: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2120:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
2216: END IF;
2217: END IF; -- 2607781
2218:
2219:

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

2231: calculated using existing CDL's which are already converted.
2232: */
2233:
2234: IF P_DEBUG_MODE THEN
2235: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2150:Process Last Set .. call PATC');
2236: END IF;
2237: /* modified for the Bug#1825827 */
2238: pa_transactions_pub.validate_transaction(
2239: x_project_id =>over_project_id,

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

2284: p_sys_link_function => 'BTC',
2285: p_work_type_id => l_work_type_id -- 2607781
2286: );
2287: IF P_DEBUG_MODE THEN
2288: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2200:Process Last Set .. back from PATC');
2289: END IF;
2290: if c_status is not null then
2291: null ;
2292: end if;

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

2304: /* Commenting this for bug 2607781 as work type id needs to be derived before the call to pa_transactions_pub.validate_transaction
2305: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2306: THEN
2307: IF P_DEBUG_MODE THEN
2308: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Calling Get_work_type_id with Project_id [' ||
2309: to_char(over_project_id) ||
2310: '] task_id [' || to_char(over_task_id) || ']');
2311: END IF;
2312: l_work_type_id := pa_utils4.Get_work_type_id

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

2314: ,p_task_id => over_task_id
2315: ,p_assignment_id => NULL
2316: );
2317: IF P_DEBUG_MODE THEN
2318: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2245:Obtained work_type_id [' || to_char(l_work_type_id) || ']');
2319: END IF;
2320: END IF; */
2321:
2322: /*

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

2331:
2332: -- IC Changes
2333: -- BTC txns should not be cross charged, so setting cross charge code to X.
2334: IF P_DEBUG_MODE THEN
2335: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2250:Process Last Set ..Call Loadei');
2336: END IF;
2337: pa_transactions.LoadEi(
2338: x_expenditure_item_id =>exp_item_id,
2339: x_expenditure_id =>x_exp_id,

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

2419:
2420: end if;
2421: if i > 0 then
2422: IF P_DEBUG_MODE THEN
2423: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2300:Process Last Set ..Call Insitems');
2424: END IF;
2425: pa_transactions.InsItems(1,0,'BTC','BTC',i, status,'N');
2426:
2427: -- -----------------------------------------------------------------------

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

2431: -- The folowing procedure returns doing nothing if status is in ERROR for
2432: -- pa_transactions.InsItems.
2433: -- ------------------------------------------------------------------------
2434: IF P_DEBUG_MODE THEN
2435: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500');
2436: END IF;
2437:
2438: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2439:

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

2437:
2438: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2439:
2440: IF P_DEBUG_MODE THEN
2441: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2442: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');
2443: END IF;
2444: pa_transactions.FlushEiTabs();
2445: i := 0;

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

2438: PA_GMS_API.vert_trx_interface(0,0,'PAXCBCAB', 'PA_BURDEN_COSTING', i, status, 'N') ;
2439:
2440: IF P_DEBUG_MODE THEN
2441: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1760:Call Vertical APPS interface for i>=500 END.');
2442: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2350:Process Last Set ..Call Flusheitabs');
2443: END IF;
2444: pa_transactions.FlushEiTabs();
2445: i := 0;
2446: end if;

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

2451: *
2452: *
2453: * ** Update those CDLs which are successfully processed with run id
2454: *
2455: * pa_cc_utils.log_message('2400:Update successful CDLs');
2456: *
2457: * ** Removed ei table and pa_tasks table and
2458: * changed cdl_all table to cdl view for
2459: * bug# 1668634

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

2465: * and cdl.project_id = current_project_id
2466: * cdl.PA_DATE <= nvl(to_date(x_end_date,'DD-MM-RR'),cdl.PA_DATE)
2467: * and request_id = x_request_id ;
2468: *
2469: * pa_cc_utils.log_message('2500:before commit');
2470: */
2471:
2472:
2473: /* IF ( l_last_batch_for_project = 'Y')

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

2569: COMMIT ;
2570: end loop; -- Loop for processing CDLs in batches for this project.
2571:
2572: IF P_DEBUG_MODE THEN
2573: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2550:End of Project loop');
2574: END IF;
2575: <>
2576: null;
2577: END LOOP; -- FOR LOOP

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

2590: /* E.N. Bug 3618193 : Added following code to close the cursor */
2591:
2592: <>
2593: IF P_DEBUG_MODE THEN
2594: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2600:At the end of the Process');
2595: END IF;
2596: null;
2597: x_run_id := current_run_id;
2598: pa_cc_utils.reset_curr_function;

Line 2598: pa_cc_utils.reset_curr_function;

2594: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2600:At the end of the Process');
2595: END IF;
2596: null;
2597: x_run_id := current_run_id;
2598: pa_cc_utils.reset_curr_function;
2599: end create_burden_expenditure_item;
2600:
2601:
2602: