DBA Data[Home] [Help]

APPS.PA_TASK_UTILS dependencies on PA_PROJ_TSK_UTILS

Line 378: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);

374: if (x_task_id is null) then
375: return(null);
376: end if;
377:
378: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
379:
380: if (x_project_id is null) then
381: return(null);
382: end if ;

Line 549: -- for pa_proj_tsk_utils.check_ap_inv_dist_exists

545: --
546: -- HISTORY
547: -- 25-FEB-05 djoseph Bug 409938: Added the api pjm_projtask_deletion.CheckUse_ProjectTask
548: -- to check against PJM. Also changed the value of x_err_stage
549: -- for pa_proj_tsk_utils.check_ap_inv_dist_exists
550: -- 14-AUG-2002 Vejayara Bug# 2331201 - Financial planning development
551: -- related changes. If a task is present in
552: -- pa_fp_elements, then a sub-task cannot be added
553: -- to the task - check_create_subtask_ok

Line 616: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);

612: return;
613: end if;
614:
615: -- End of fix
616: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
617:
618: --anuragag Bug 8566495 - No validation on task_id if the task is created through change management
619: if x_project_id is null then
620: select project_id into x_project_id

Line 653: pa_proj_tsk_utils.check_transaction_control(null, x_task_id);

649: end if;
650: -- Check if task has transaction control.
651: x_err_stage := 'check txn control for '|| x_task_id;
652: status_code :=
653: pa_proj_tsk_utils.check_transaction_control(null, x_task_id);
654: if ( status_code = 1 ) then
655: x_err_code := 30;
656: x_err_stage := 'PA_TSK_TXN_CONT_EXIST';
657: return;

Line 666: pa_proj_tsk_utils.check_burden_sched_override(null, x_task_id);

662:
663: -- Check if task has burden schedule override
664: x_err_stage := 'check burden schedule override for '|| x_task_id;
665: status_code :=
666: pa_proj_tsk_utils.check_burden_sched_override(null, x_task_id);
667: if ( status_code = 1 ) then
668: x_err_code := 40;
669: x_err_stage := 'PA_TSK_BURDEN_SCH_OVRIDE_EXIST';
670: return;

Line 792: pa_proj_tsk_utils.check_asset_assignmt_exists(null, x_task_id);

788:
789: -- Check if task has project asset assignment
790: x_err_stage := 'check asset assignment for '|| x_task_id;
791: status_code :=
792: pa_proj_tsk_utils.check_asset_assignmt_exists(null, x_task_id);
793: if ( status_code = 1 ) then
794: x_err_code := 100;
795: x_err_stage := 'PA_TSK_ASSET_ASSIGNMT_EXIST';
796: return;

Line 842: pa_proj_tsk_utils.check_job_bill_rate_override(null, x_task_id);

838:
839: -- Check if task has job bill rate override
840: x_err_stage := 'check job bill rate override for '|| x_task_id;
841: status_code :=
842: pa_proj_tsk_utils.check_job_bill_rate_override(null, x_task_id);
843: if ( status_code = 1 ) then
844: x_err_code := 180;
845: x_err_stage := 'PA_TSK_JOB_BILL_RATE_O_EXIST';
846: return;

Line 855: pa_proj_tsk_utils.check_emp_bill_rate_override(null, x_task_id);

851:
852: -- Check if task has emp bill rate override
853: x_err_stage := 'check emp bill rate override for '|| x_task_id;
854: status_code :=
855: pa_proj_tsk_utils.check_emp_bill_rate_override(null, x_task_id);
856: if ( status_code = 1 ) then
857: x_err_code := 190;
858: x_err_stage := 'PA_TSK_EMP_BILL_RATE_O_EXIST';
859: return;

Line 868: pa_proj_tsk_utils.check_labor_multiplier(null, x_task_id);

864:
865: -- Check if task has labor multiplier
866: x_err_stage := 'check labor multiplier for '|| x_task_id;
867: status_code :=
868: pa_proj_tsk_utils.check_labor_multiplier(null, x_task_id);
869: if ( status_code = 1 ) then
870: x_err_code := 200;
871: x_err_stage := 'PA_TSK_LABOR_MULTIPLIER_EXIST';
872: return;

Line 881: pa_proj_tsk_utils.check_nl_bill_rate_override(null, x_task_id);

877:
878: -- Check if task has nl bill rate override
879: x_err_stage := 'check nl bill rate override for '|| x_task_id;
880: status_code :=
881: pa_proj_tsk_utils.check_nl_bill_rate_override(null, x_task_id);
882: if ( status_code = 1 ) then
883: x_err_code := 210;
884: x_err_stage := 'PA_TSK_NL_BILL_RATE_O_EXIST';
885: return;

Line 894: pa_proj_tsk_utils.check_job_bill_title_override(null, x_task_id);

890:
891: -- Check if task has job bill title override
892: x_err_stage := 'check job bill title override for '|| x_task_id;
893: status_code :=
894: pa_proj_tsk_utils.check_job_bill_title_override(null, x_task_id);
895: if ( status_code = 1 ) then
896: x_err_code := 230;
897: x_err_stage := 'PA_TSK_JOB_BILL_TITLE_O_EXIST';
898: return;

Line 907: pa_proj_tsk_utils.check_job_assignmt_override(null, x_task_id);

903:
904: -- Check if task has job assignment override
905: x_err_stage := 'check job assignment override for '|| x_task_id;
906: status_code :=
907: pa_proj_tsk_utils.check_job_assignmt_override(null, x_task_id);
908: if ( status_code = 1 ) then
909: x_err_code := 240;
910: x_err_stage := 'PA_TSK_JOB_ASSIGNMENT_O_EXIST';
911: return;

Line 921: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id, FALSE);

917:
918: -- Check if task has expenditure item
919: x_err_stage := 'check expenditure item for '|| x_task_id;
920: status_code :=
921: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id, FALSE);
922: if ( status_code = 1 ) then
923: x_err_code := 110;
924: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
925: return;

Line 934: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460

930:
931: -- Check if task has purchase order distribution
932: x_err_stage := 'check purchase order for '|| x_task_id;
933: status_code :=
934: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460
935: if ( status_code = 1 ) then
936: x_err_code := 120;
937: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
938: return;

Line 947: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460

943:
944: -- Check if task has purchase order requisition
945: x_err_stage := 'check purchase order req for '|| x_task_id;
946: status_code :=
947: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460
948: if ( status_code = 1 ) then
949: x_err_code := 130;
950: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
951: return;

Line 960: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, x_task_id, FALSE); -- 4903460

956:
957: -- Check if task has ap invoice
958: x_err_stage := 'check ap invoice for '|| x_task_id;
959: status_code :=
960: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, x_task_id, FALSE); -- 4903460
961: if ( status_code = 1 ) then
962: x_err_code := 140;
963: x_err_stage := 'PA_TSK_AP_INV_EXIST';
964: return;

Line 973: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460

969:
970: -- Check if task has ap invoice distribution
971: x_err_stage := 'check ap inv distribution for '|| x_task_id;
972: status_code :=
973: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460
974: if ( status_code = 1 ) then
975: x_err_code := 150;
976: /*Changed for bug 4069938*/
977: -- x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';

Line 998: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id,FALSE); -- 4903460

994:
995: -- Check if task has draft invoices
996: x_err_stage := 'check draft invoice for '|| x_task_id;
997: status_code :=
998: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id,FALSE); -- 4903460
999: if ( status_code = 1 ) then
1000: x_err_code := 170;
1001: x_err_stage := 'PA_TSK_CC_DINV_EXIST';
1002: return;

Line 1011: pa_proj_tsk_utils.check_project_customer_exists(X_task_id,FALSE); -- 4903460

1007:
1008: -- Check if task has Project_customers
1009: x_err_stage := 'check Project Customers for '|| x_task_id;
1010: status_code :=
1011: pa_proj_tsk_utils.check_project_customer_exists(X_task_id,FALSE); -- 4903460
1012: if ( status_code = 1 ) then
1013: x_err_code := 180;
1014: x_err_stage := 'PA_TSK_CC_CUST_EXIST';
1015: return;

Line 1024: pa_proj_tsk_utils.check_projects_exists(x_task_id,FALSE); -- 4903460

1020:
1021: -- Check if task assign to projects table as a cc_tax_task_id
1022: x_err_stage := 'check task assign to projects table as a cc_tax_task_id '|| x_task_id;
1023: status_code :=
1024: pa_proj_tsk_utils.check_projects_exists(x_task_id,FALSE); -- 4903460
1025: if ( status_code = 1 ) then
1026: x_err_code := 190;
1027: x_err_stage := 'PA_TSK_CC_PROJ_EXIST';
1028: return;

Line 1145: pa_proj_tsk_utils.check_service_order_exists(x_project_id,

1141: /* Start changes for Service Intgration bug#16535441*/
1142:
1143: x_err_stage := 'check expenditure item for '|| x_project_id;
1144: status_code :=
1145: pa_proj_tsk_utils.check_service_order_exists(x_project_id,
1146: x_task_id);
1147: if ( status_code = 1 ) then
1148: x_err_code := 330;
1149: x_err_stage := 'PA_TSK_SER_ORD_EXIST';

Line 1178: -- pa_proj_tsk_utils.check_ap_inv_dist_exists

1174: -- If it's ok to change task number, the x_err_code will be 0.
1175: --
1176: -- HISTORY
1177: -- 24-FEB-05 djoseph Bug 409938: Changed the value of x_err_stage for
1178: -- pa_proj_tsk_utils.check_ap_inv_dist_exists
1179: -- 10-FEB-99 Ri. Singh Modified as explained below
1180: -- 29-DEC-95 R.Krishnamurthy Created
1181: --
1182: procedure change_lowest_task_num_ok ( x_task_id IN number

Line 1215: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); -- 4903460

1211: end if;
1212:
1213: -- End of fix
1214:
1215: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); -- 4903460
1216: -- Check if task has expenditure item
1217: x_err_stage := 'check expenditure item for '|| x_task_id;
1218: status_code :=
1219: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id,FALSE); -- 4903460

Line 1219: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id,FALSE); -- 4903460

1215: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); -- 4903460
1216: -- Check if task has expenditure item
1217: x_err_stage := 'check expenditure item for '|| x_task_id;
1218: status_code :=
1219: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id,FALSE); -- 4903460
1220: if ( status_code = 1 ) then
1221: x_err_code := 20;
1222: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
1223: return;

Line 1233: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460

1229: -- Check if task has purchase order distribution
1230:
1231: x_err_stage := 'check purchase order for '|| x_task_id;
1232: status_code :=
1233: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460
1234: if ( status_code = 1 ) then
1235: x_err_code := 30;
1236: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
1237: return;

Line 1246: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460

1242:
1243: -- Check if task has purchase order requisition
1244: x_err_stage := 'check purchase order req for '|| x_task_id;
1245: status_code :=
1246: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460
1247: if ( status_code = 1 ) then
1248: x_err_code := 40;
1249: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
1250: return;

Line 1259: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, x_task_id,FALSE); -- 4903460

1255:
1256: -- Check if task has ap invoice
1257: x_err_stage := 'check ap invoice for '|| x_task_id;
1258: status_code :=
1259: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, x_task_id,FALSE); -- 4903460
1260: if ( status_code = 1 ) then
1261: x_err_code := 50;
1262: x_err_stage := 'PA_TSK_AP_INV_EXIST';
1263: return;

Line 1272: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460

1268:
1269: -- Check if task has ap invoice distribution
1270: x_err_stage := 'check ap inv distribution for '|| x_task_id;
1271: status_code :=
1272: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460
1273: if ( status_code = 1 ) then
1274: x_err_code := 60;
1275: /*Changed for bug 4069938*/
1276: -- x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';

Line 1431: status_code := pa_proj_tsk_utils.check_cdl_exists

1427: old_stack := x_err_stack;
1428:
1429: x_err_stage := 'Check CDLs for Task '||x_task_id;
1430:
1431: status_code := pa_proj_tsk_utils.check_cdl_exists
1432: (Null, x_task_id);
1433:
1434: if status_code <> 0 Then
1435: x_err_code := 10;

Line 1443: status_code := pa_proj_tsk_utils.check_rdl_exists

1439:
1440: -- Check RDLs for the Task
1441:
1442: x_err_stage := 'check RDLs for Task '||x_task_id;
1443: status_code := pa_proj_tsk_utils.check_rdl_exists
1444: (Null, x_task_id);
1445:
1446: if status_code <> 0 Then
1447: x_err_code := 20;

Line 1455: status_code := pa_proj_tsk_utils.check_erdl_exists

1451:
1452: -- Check ERDLs for the Task
1453:
1454: x_err_stage := 'check ERDLs for Task '||x_task_id;
1455: status_code := pa_proj_tsk_utils.check_erdl_exists
1456: (Null, x_task_id, null);
1457:
1458: if status_code <> 0 Then
1459: x_err_code := 30;

Line 1589: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists

1585: and project_id = p_project_id;
1586:
1587: BEGIN
1588:
1589: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists
1590: (Null, p_task_id);
1591: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists
1592: (Null, p_task_id);
1593: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists

Line 1591: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists

1587: BEGIN
1588:
1589: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists
1590: (Null, p_task_id);
1591: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists
1592: (Null, p_task_id);
1593: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists
1594: (Null, p_task_id, null);
1595:

Line 1593: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists

1589: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists
1590: (Null, p_task_id);
1591: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists
1592: (Null, p_task_id);
1593: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists
1594: (Null, p_task_id, null);
1595:
1596:
1597: OPEN c1;

Line 1796: -- 29-MAY-02 gjain added a call to pa_proj_tsk_utils.check_iex_task_charged

1792: -- HISTORY
1793: -- 14-AUG-02 vejayara Bug# 2331201 - Financial planning development
1794: -- changes - Added pa_fp_elements in the existence check
1795: -- in check_delete_task_ok
1796: -- 29-MAY-02 gjain added a call to pa_proj_tsk_utils.check_iex_task_charged
1797: -- for bug 2367945
1798: -- 22-JAN-02 bvarnasi After all the checks for EI,PO etc. are done,we
1799: -- need not check for the existance of cc_tax_task_id
1800: -- as there can not be any cross charge transactions

Line 1886: pa_proj_tsk_utils.check_event_exists(null, x_task_id);

1882: -- x_task_id is a top task
1883: -- Check if task has event
1884: x_err_stage := 'check event for '|| x_task_id;
1885: status_code :=
1886: pa_proj_tsk_utils.check_event_exists(null, x_task_id);
1887: if ( status_code = 1 ) then
1888: x_err_code := 30;
1889: x_err_stage := 'PA_TSK_EVENT_EXIST';
1890: return;

Line 1899: pa_proj_tsk_utils.check_funding_exists(null, x_task_id);

1895:
1896: -- Check if task has funding
1897: x_err_stage := 'check funding for '|| x_task_id;
1898: status_code :=
1899: pa_proj_tsk_utils.check_funding_exists(null, x_task_id);
1900: if ( status_code = 1 ) then
1901: x_err_code := 40;
1902: x_err_stage := 'PA_TSK_FUND_EXIST';
1903: return;

Line 1985: l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);

1981: -- All commented validations in this API for this perf fix are done in
1982: -- the following API : PA_PROJ_ELEMENTS_UTILS.perform_task_validations
1983:
1984: -- Added the following api call to get the project_id and pass it to perform_task_validations. Done for Bug#4964992
1985: l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
1986: -- End of changes for Bug#4964992
1987:
1988: PA_PROJ_ELEMENTS_UTILS.perform_task_validations
1989: (

Line 2012: pa_proj_tsk_utils.check_exp_item_exists(null, x_task_id);

2008: -- Start of commenting for Performance Fix 4903460
2009: -- Check if task has expenditure item
2010: /*x_err_stage := 'check expenditure item for '|| x_task_id;
2011: status_code :=
2012: pa_proj_tsk_utils.check_exp_item_exists(null, x_task_id);
2013: if ( status_code = 1 ) then
2014: x_err_code := 50;
2015: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
2016: return;

Line 2025: pa_proj_tsk_utils.check_po_dist_exists(null, x_task_id);

2021:
2022: -- Check if task has purchase order distribution
2023: x_err_stage := 'check purchase order for '|| x_task_id;
2024: status_code :=
2025: pa_proj_tsk_utils.check_po_dist_exists(null, x_task_id);
2026: if ( status_code = 1 ) then
2027: x_err_code := 60;
2028: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
2029: return;

Line 2038: pa_proj_tsk_utils.check_po_req_dist_exists(null, x_task_id);

2034:
2035: -- Check if task has purchase order requisition
2036: x_err_stage := 'check purchase order requisition for '|| x_task_id;
2037: status_code :=
2038: pa_proj_tsk_utils.check_po_req_dist_exists(null, x_task_id);
2039: if ( status_code = 1 ) then
2040: x_err_code := 70;
2041: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
2042: return;

Line 2051: pa_proj_tsk_utils.check_ap_invoice_exists(null, x_task_id);

2047:
2048: -- Check if task has supplier invoices
2049: x_err_stage := 'check supplier invoice for '|| x_task_id;
2050: status_code :=
2051: pa_proj_tsk_utils.check_ap_invoice_exists(null, x_task_id);
2052: if ( status_code = 1 ) then
2053: x_err_code := 80;
2054: x_err_stage := 'PA_TSK_AP_INV_EXIST';
2055: return;

Line 2064: pa_proj_tsk_utils.check_ap_inv_dist_exists(null, x_task_id);

2060:
2061: -- Check if task has supplier invoice distribution
2062: x_err_stage := 'check supplier inv distribution for '|| x_task_id;
2063: status_code :=
2064: pa_proj_tsk_utils.check_ap_inv_dist_exists(null, x_task_id);
2065: if ( status_code = 1 ) then
2066: x_err_code := 90;
2067: x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';
2068: return;

Line 2077: pa_proj_tsk_utils.check_commitment_txn_exists(null, x_task_id);

2073:
2074: -- Check if task has commitment transaction
2075: x_err_stage := 'check commitment transaction for '|| x_task_id;
2076: status_code :=
2077: pa_proj_tsk_utils.check_commitment_txn_exists(null, x_task_id);
2078: if ( status_code = 1 ) then
2079: x_err_code := 110;
2080: x_err_stage := 'PA_TSK_CMT_TXN_EXIST';
2081: return;

Line 2090: pa_proj_tsk_utils.check_comp_rule_set_exists(null, x_task_id);

2086:
2087: -- Check if task has compensation rule set
2088: x_err_stage := 'check compensation rule set for '|| x_task_id;
2089: status_code :=
2090: pa_proj_tsk_utils.check_comp_rule_set_exists(null, x_task_id);
2091: if ( status_code = 1 ) then
2092: x_err_code := 120;
2093: x_err_stage := 'PA_TSK_COMP_RULE_SET_EXIST';
2094: return;

Line 2143: --l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); Commented this line as we have already retrieved the project_id of the task above for Bug#4964992

2139:
2140: -- Check if task has progress
2141: x_err_stage := 'check object has progress for '|| x_task_id;
2142:
2143: --l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); Commented this line as we have already retrieved the project_id of the task above for Bug#4964992
2144:
2145: if (pa_progress_utils.check_object_has_prog(p_project_id => l_project_id
2146: -- ,p_proj_element_id => x_task_id
2147: , p_object_id => x_task_id

Line 2162: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id);

2158: /* Start of Commenting for Performance Fix 4903460
2159: -- Check if task has draft invoices
2160: x_err_stage := 'check draft invoice for '|| x_task_id;
2161: status_code :=
2162: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id);
2163: if ( status_code = 1 ) then
2164: x_err_code := 160;
2165: x_err_stage := 'PA_TSK_CC_DINV_EXIST';
2166: return;

Line 2175: pa_proj_tsk_utils.check_project_customer_exists(x_task_id);

2171:
2172: -- Check if task has Project_customers
2173: x_err_stage := 'check Project Customers for '|| x_task_id;
2174: status_code :=
2175: pa_proj_tsk_utils.check_project_customer_exists(x_task_id);
2176: if ( status_code = 1 ) then
2177: x_err_code := 170;
2178: x_err_stage := 'PA_TSK_CC_CUST_EXIST';
2179: return;

Line 2191: pa_proj_tsk_utils.check_projects_exists(x_task_id);

2187: /* Commented for Bug # 2185521.
2188: -- Check if task assign to projects table as a cc_tax_task_id
2189: x_err_stage := 'check task assign to projects table as a cc_tax_task_id '|| x_task_id;
2190: status_code :=
2191: pa_proj_tsk_utils.check_projects_exists(x_task_id);
2192: if ( status_code = 1 ) then
2193: x_err_code := 180;
2194: x_err_stage := 'PA_TSK_CC_PROJ_EXIST';
2195: return;

Line 2235: status_code := pa_proj_tsk_utils.check_iex_task_charged(x_task_id);

2231: --fix for bug2367945 starts
2232: Is_IEX_Installed := pa_install.is_product_installed('IEX');
2233: If Is_IEX_Installed then
2234: x_err_stage := 'check if task '|| x_task_id || ' is charged in iexpense';
2235: status_code := pa_proj_tsk_utils.check_iex_task_charged(x_task_id);
2236: if ( status_code = 1 ) then
2237: x_err_code := 210;
2238: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
2239: return;

Line 2288: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/

2284: x_err_stage := 'get project id of '|| x_task_id;
2285: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2286: --the data has already been deleted from pa_tasks in delete_project flow
2287: /*x_project_id :=
2288: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2289: OPEN get_task_project_id(x_task_id);
2290: FETCH get_task_project_id INTO x_project_id;
2291: CLOSE get_task_project_id;
2292: --Bug 3617393 end

Line 2569: pa_proj_tsk_utils.check_po_dist_exists(null, x_task_id);

2565: -- Check if the task has purchase order distributions
2566:
2567: x_err_stage := 'check purchase order for '|| x_task_id;
2568: status_code :=
2569: pa_proj_tsk_utils.check_po_dist_exists(null, x_task_id);
2570: if ( status_code = 1 ) then
2571: x_err_code := 30;
2572: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
2573: return;

Line 2582: pa_proj_tsk_utils.check_po_req_dist_exists(null, x_task_id);

2578:
2579: -- Check if the task has purchase order requisitions
2580: x_err_stage := 'check purchase order req for '|| x_task_id;
2581: status_code :=
2582: pa_proj_tsk_utils.check_po_req_dist_exists(null, x_task_id);
2583: if ( status_code = 1 ) then
2584: x_err_code := 40;
2585: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
2586: return;

Line 2595: pa_proj_tsk_utils.check_ap_inv_dist_exists(null, x_task_id);

2591:
2592: -- Check if task has ap invoice distributions
2593: x_err_stage := 'check ap inv distribution for '|| x_task_id;
2594: status_code :=
2595: pa_proj_tsk_utils.check_ap_inv_dist_exists(null, x_task_id);
2596: if ( status_code = 1 ) then
2597: x_err_code := 60;
2598: x_err_stage := 'PA_TSK_AP_INV_EXIST';
2599: return;