DBA Data[Home] [Help]

APPS.PA_TASK_UTILS dependencies on PA_PROJ_TSK_UTILS

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

188: if (x_task_id is null) then
189: return(null);
190: end if;
191:
192: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
193:
194: if (x_project_id is null) then
195: return(null);
196: end if ;

Line 363: -- for pa_proj_tsk_utils.check_ap_inv_dist_exists

359: --
360: -- HISTORY
361: -- 25-FEB-05 djoseph Bug 409938: Added the api pjm_projtask_deletion.CheckUse_ProjectTask
362: -- to check against PJM. Also changed the value of x_err_stage
363: -- for pa_proj_tsk_utils.check_ap_inv_dist_exists
364: -- 14-AUG-2002 Vejayara Bug# 2331201 - Financial planning development
365: -- related changes. If a task is present in
366: -- pa_fp_elements, then a sub-task cannot be added
367: -- to the task - check_create_subtask_ok

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

426: return;
427: end if;
428:
429: -- End of fix
430: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
431:
432: open p1;
433: fetch p1 into temp;
434: if p1%notfound then null;

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

452:
453: -- Check if task has transaction control.
454: x_err_stage := 'check txn control for '|| x_task_id;
455: status_code :=
456: pa_proj_tsk_utils.check_transaction_control(null, x_task_id);
457: if ( status_code = 1 ) then
458: x_err_code := 30;
459: x_err_stage := 'PA_TSK_TXN_CONT_EXIST';
460: return;

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

465:
466: -- Check if task has burden schedule override
467: x_err_stage := 'check burden schedule override for '|| x_task_id;
468: status_code :=
469: pa_proj_tsk_utils.check_burden_sched_override(null, x_task_id);
470: if ( status_code = 1 ) then
471: x_err_code := 40;
472: x_err_stage := 'PA_TSK_BURDEN_SCH_OVRIDE_EXIST';
473: return;

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

591:
592: -- Check if task has project asset assignment
593: x_err_stage := 'check asset assignment for '|| x_task_id;
594: status_code :=
595: pa_proj_tsk_utils.check_asset_assignmt_exists(null, x_task_id);
596: if ( status_code = 1 ) then
597: x_err_code := 100;
598: x_err_stage := 'PA_TSK_ASSET_ASSIGNMT_EXIST';
599: return;

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

641:
642: -- Check if task has job bill rate override
643: x_err_stage := 'check job bill rate override for '|| x_task_id;
644: status_code :=
645: pa_proj_tsk_utils.check_job_bill_rate_override(null, x_task_id);
646: if ( status_code = 1 ) then
647: x_err_code := 180;
648: x_err_stage := 'PA_TSK_JOB_BILL_RATE_O_EXIST';
649: return;

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

654:
655: -- Check if task has emp bill rate override
656: x_err_stage := 'check emp bill rate override for '|| x_task_id;
657: status_code :=
658: pa_proj_tsk_utils.check_emp_bill_rate_override(null, x_task_id);
659: if ( status_code = 1 ) then
660: x_err_code := 190;
661: x_err_stage := 'PA_TSK_EMP_BILL_RATE_O_EXIST';
662: return;

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

667:
668: -- Check if task has labor multiplier
669: x_err_stage := 'check labor multiplier for '|| x_task_id;
670: status_code :=
671: pa_proj_tsk_utils.check_labor_multiplier(null, x_task_id);
672: if ( status_code = 1 ) then
673: x_err_code := 200;
674: x_err_stage := 'PA_TSK_LABOR_MULTIPLIER_EXIST';
675: return;

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

680:
681: -- Check if task has nl bill rate override
682: x_err_stage := 'check nl bill rate override for '|| x_task_id;
683: status_code :=
684: pa_proj_tsk_utils.check_nl_bill_rate_override(null, x_task_id);
685: if ( status_code = 1 ) then
686: x_err_code := 210;
687: x_err_stage := 'PA_TSK_NL_BILL_RATE_O_EXIST';
688: return;

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

693:
694: -- Check if task has job bill title override
695: x_err_stage := 'check job bill title override for '|| x_task_id;
696: status_code :=
697: pa_proj_tsk_utils.check_job_bill_title_override(null, x_task_id);
698: if ( status_code = 1 ) then
699: x_err_code := 230;
700: x_err_stage := 'PA_TSK_JOB_BILL_TITLE_O_EXIST';
701: return;

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

706:
707: -- Check if task has job assignment override
708: x_err_stage := 'check job assignment override for '|| x_task_id;
709: status_code :=
710: pa_proj_tsk_utils.check_job_assignmt_override(null, x_task_id);
711: if ( status_code = 1 ) then
712: x_err_code := 240;
713: x_err_stage := 'PA_TSK_JOB_ASSIGNMENT_O_EXIST';
714: return;

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

720:
721: -- Check if task has expenditure item
722: x_err_stage := 'check expenditure item for '|| x_task_id;
723: status_code :=
724: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id, FALSE);
725: if ( status_code = 1 ) then
726: x_err_code := 110;
727: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
728: return;

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

733:
734: -- Check if task has purchase order distribution
735: x_err_stage := 'check purchase order for '|| x_task_id;
736: status_code :=
737: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460
738: if ( status_code = 1 ) then
739: x_err_code := 120;
740: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
741: return;

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

746:
747: -- Check if task has purchase order requisition
748: x_err_stage := 'check purchase order req for '|| x_task_id;
749: status_code :=
750: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460
751: if ( status_code = 1 ) then
752: x_err_code := 130;
753: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
754: return;

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

759:
760: -- Check if task has ap invoice
761: x_err_stage := 'check ap invoice for '|| x_task_id;
762: status_code :=
763: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, x_task_id, FALSE); -- 4903460
764: if ( status_code = 1 ) then
765: x_err_code := 140;
766: x_err_stage := 'PA_TSK_AP_INV_EXIST';
767: return;

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

772:
773: -- Check if task has ap invoice distribution
774: x_err_stage := 'check ap inv distribution for '|| x_task_id;
775: status_code :=
776: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, x_task_id, FALSE); -- 4903460
777: if ( status_code = 1 ) then
778: x_err_code := 150;
779: /*Changed for bug 4069938*/
780: -- x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';

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

797:
798: -- Check if task has draft invoices
799: x_err_stage := 'check draft invoice for '|| x_task_id;
800: status_code :=
801: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id,FALSE); -- 4903460
802: if ( status_code = 1 ) then
803: x_err_code := 170;
804: x_err_stage := 'PA_TSK_CC_DINV_EXIST';
805: return;

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

810:
811: -- Check if task has Project_customers
812: x_err_stage := 'check Project Customers for '|| x_task_id;
813: status_code :=
814: pa_proj_tsk_utils.check_project_customer_exists(X_task_id,FALSE); -- 4903460
815: if ( status_code = 1 ) then
816: x_err_code := 180;
817: x_err_stage := 'PA_TSK_CC_CUST_EXIST';
818: return;

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

823:
824: -- Check if task assign to projects table as a cc_tax_task_id
825: x_err_stage := 'check task assign to projects table as a cc_tax_task_id '|| x_task_id;
826: status_code :=
827: pa_proj_tsk_utils.check_projects_exists(x_task_id,FALSE); -- 4903460
828: if ( status_code = 1 ) then
829: x_err_code := 190;
830: x_err_stage := 'PA_TSK_CC_PROJ_EXIST';
831: return;

Line 966: -- pa_proj_tsk_utils.check_ap_inv_dist_exists

962: -- If it's ok to change task number, the x_err_code will be 0.
963: --
964: -- HISTORY
965: -- 24-FEB-05 djoseph Bug 409938: Changed the value of x_err_stage for
966: -- pa_proj_tsk_utils.check_ap_inv_dist_exists
967: -- 10-FEB-99 Ri. Singh Modified as explained below
968: -- 29-DEC-95 R.Krishnamurthy Created
969: --
970: procedure change_lowest_task_num_ok ( x_task_id IN number

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

999: end if;
1000:
1001: -- End of fix
1002:
1003: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); -- 4903460
1004: -- Check if task has expenditure item
1005: x_err_stage := 'check expenditure item for '|| x_task_id;
1006: status_code :=
1007: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id,FALSE); -- 4903460

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

1003: x_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id); -- 4903460
1004: -- Check if task has expenditure item
1005: x_err_stage := 'check expenditure item for '|| x_task_id;
1006: status_code :=
1007: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, x_task_id,FALSE); -- 4903460
1008: if ( status_code = 1 ) then
1009: x_err_code := 20;
1010: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
1011: return;

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

1017: -- Check if task has purchase order distribution
1018:
1019: x_err_stage := 'check purchase order for '|| x_task_id;
1020: status_code :=
1021: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460
1022: if ( status_code = 1 ) then
1023: x_err_code := 30;
1024: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
1025: return;

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

1030:
1031: -- Check if task has purchase order requisition
1032: x_err_stage := 'check purchase order req for '|| x_task_id;
1033: status_code :=
1034: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460
1035: if ( status_code = 1 ) then
1036: x_err_code := 40;
1037: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
1038: return;

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

1043:
1044: -- Check if task has ap invoice
1045: x_err_stage := 'check ap invoice for '|| x_task_id;
1046: status_code :=
1047: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, x_task_id,FALSE); -- 4903460
1048: if ( status_code = 1 ) then
1049: x_err_code := 50;
1050: x_err_stage := 'PA_TSK_AP_INV_EXIST';
1051: return;

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

1056:
1057: -- Check if task has ap invoice distribution
1058: x_err_stage := 'check ap inv distribution for '|| x_task_id;
1059: status_code :=
1060: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, x_task_id,FALSE); -- 4903460
1061: if ( status_code = 1 ) then
1062: x_err_code := 60;
1063: /*Changed for bug 4069938*/
1064: -- x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';

Line 1219: status_code := pa_proj_tsk_utils.check_cdl_exists

1215: old_stack := x_err_stack;
1216:
1217: x_err_stage := 'Check CDLs for Task '||x_task_id;
1218:
1219: status_code := pa_proj_tsk_utils.check_cdl_exists
1220: (Null, x_task_id);
1221:
1222: if status_code <> 0 Then
1223: x_err_code := 10;

Line 1231: status_code := pa_proj_tsk_utils.check_rdl_exists

1227:
1228: -- Check RDLs for the Task
1229:
1230: x_err_stage := 'check RDLs for Task '||x_task_id;
1231: status_code := pa_proj_tsk_utils.check_rdl_exists
1232: (Null, x_task_id);
1233:
1234: if status_code <> 0 Then
1235: x_err_code := 20;

Line 1243: status_code := pa_proj_tsk_utils.check_erdl_exists

1239:
1240: -- Check ERDLs for the Task
1241:
1242: x_err_stage := 'check ERDLs for Task '||x_task_id;
1243: status_code := pa_proj_tsk_utils.check_erdl_exists
1244: (Null, x_task_id, null);
1245:
1246: if status_code <> 0 Then
1247: x_err_code := 30;

Line 1377: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists

1373: and project_id = p_project_id;
1374:
1375: BEGIN
1376:
1377: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists
1378: (Null, p_task_id);
1379: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists
1380: (Null, p_task_id);
1381: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists

Line 1379: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists

1375: BEGIN
1376:
1377: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists
1378: (Null, p_task_id);
1379: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists
1380: (Null, p_task_id);
1381: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists
1382: (Null, p_task_id, null);
1383:

Line 1381: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists

1377: status_code_cdl := pa_proj_tsk_utils.check_cdl_exists
1378: (Null, p_task_id);
1379: status_code_rdl := pa_proj_tsk_utils.check_rdl_exists
1380: (Null, p_task_id);
1381: status_code_erdl := pa_proj_tsk_utils.check_erdl_exists
1382: (Null, p_task_id, null);
1383:
1384:
1385: OPEN c1;

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

1580: -- HISTORY
1581: -- 14-AUG-02 vejayara Bug# 2331201 - Financial planning development
1582: -- changes - Added pa_fp_elements in the existence check
1583: -- in check_delete_task_ok
1584: -- 29-MAY-02 gjain added a call to pa_proj_tsk_utils.check_iex_task_charged
1585: -- for bug 2367945
1586: -- 22-JAN-02 bvarnasi After all the checks for EI,PO etc. are done,we
1587: -- need not check for the existance of cc_tax_task_id
1588: -- as there can not be any cross charge transactions

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

1670: -- x_task_id is a top task
1671: -- Check if task has event
1672: x_err_stage := 'check event for '|| x_task_id;
1673: status_code :=
1674: pa_proj_tsk_utils.check_event_exists(null, x_task_id);
1675: if ( status_code = 1 ) then
1676: x_err_code := 30;
1677: x_err_stage := 'PA_TSK_EVENT_EXIST';
1678: return;

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

1683:
1684: -- Check if task has funding
1685: x_err_stage := 'check funding for '|| x_task_id;
1686: status_code :=
1687: pa_proj_tsk_utils.check_funding_exists(null, x_task_id);
1688: if ( status_code = 1 ) then
1689: x_err_code := 40;
1690: x_err_stage := 'PA_TSK_FUND_EXIST';
1691: return;

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

1769: -- All commented validations in this API for this perf fix are done in
1770: -- the following API : PA_PROJ_ELEMENTS_UTILS.perform_task_validations
1771:
1772: -- Added the following api call to get the project_id and pass it to perform_task_validations. Done for Bug#4964992
1773: l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
1774: -- End of changes for Bug#4964992
1775:
1776: PA_PROJ_ELEMENTS_UTILS.perform_task_validations
1777: (

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

1796: -- Start of commenting for Performance Fix 4903460
1797: -- Check if task has expenditure item
1798: /*x_err_stage := 'check expenditure item for '|| x_task_id;
1799: status_code :=
1800: pa_proj_tsk_utils.check_exp_item_exists(null, x_task_id);
1801: if ( status_code = 1 ) then
1802: x_err_code := 50;
1803: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
1804: return;

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

1809:
1810: -- Check if task has purchase order distribution
1811: x_err_stage := 'check purchase order for '|| x_task_id;
1812: status_code :=
1813: pa_proj_tsk_utils.check_po_dist_exists(null, x_task_id);
1814: if ( status_code = 1 ) then
1815: x_err_code := 60;
1816: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
1817: return;

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

1822:
1823: -- Check if task has purchase order requisition
1824: x_err_stage := 'check purchase order requisition for '|| x_task_id;
1825: status_code :=
1826: pa_proj_tsk_utils.check_po_req_dist_exists(null, x_task_id);
1827: if ( status_code = 1 ) then
1828: x_err_code := 70;
1829: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
1830: return;

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

1835:
1836: -- Check if task has supplier invoices
1837: x_err_stage := 'check supplier invoice for '|| x_task_id;
1838: status_code :=
1839: pa_proj_tsk_utils.check_ap_invoice_exists(null, x_task_id);
1840: if ( status_code = 1 ) then
1841: x_err_code := 80;
1842: x_err_stage := 'PA_TSK_AP_INV_EXIST';
1843: return;

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

1848:
1849: -- Check if task has supplier invoice distribution
1850: x_err_stage := 'check supplier inv distribution for '|| x_task_id;
1851: status_code :=
1852: pa_proj_tsk_utils.check_ap_inv_dist_exists(null, x_task_id);
1853: if ( status_code = 1 ) then
1854: x_err_code := 90;
1855: x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';
1856: return;

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

1861:
1862: -- Check if task has commitment transaction
1863: x_err_stage := 'check commitment transaction for '|| x_task_id;
1864: status_code :=
1865: pa_proj_tsk_utils.check_commitment_txn_exists(null, x_task_id);
1866: if ( status_code = 1 ) then
1867: x_err_code := 110;
1868: x_err_stage := 'PA_TSK_CMT_TXN_EXIST';
1869: return;

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

1874:
1875: -- Check if task has compensation rule set
1876: x_err_stage := 'check compensation rule set for '|| x_task_id;
1877: status_code :=
1878: pa_proj_tsk_utils.check_comp_rule_set_exists(null, x_task_id);
1879: if ( status_code = 1 ) then
1880: x_err_code := 120;
1881: x_err_stage := 'PA_TSK_COMP_RULE_SET_EXIST';
1882: return;

Line 1931: --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

1927:
1928: -- Check if task has progress
1929: x_err_stage := 'check object has progress for '|| x_task_id;
1930:
1931: --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
1932:
1933: if (pa_progress_utils.check_object_has_prog(p_project_id => l_project_id
1934: -- ,p_proj_element_id => x_task_id
1935: , p_object_id => x_task_id

Line 1950: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id);

1946: /* Start of Commenting for Performance Fix 4903460
1947: -- Check if task has draft invoices
1948: x_err_stage := 'check draft invoice for '|| x_task_id;
1949: status_code :=
1950: pa_proj_tsk_utils.check_draft_inv_details_exists(x_task_id);
1951: if ( status_code = 1 ) then
1952: x_err_code := 160;
1953: x_err_stage := 'PA_TSK_CC_DINV_EXIST';
1954: return;

Line 1963: pa_proj_tsk_utils.check_project_customer_exists(x_task_id);

1959:
1960: -- Check if task has Project_customers
1961: x_err_stage := 'check Project Customers for '|| x_task_id;
1962: status_code :=
1963: pa_proj_tsk_utils.check_project_customer_exists(x_task_id);
1964: if ( status_code = 1 ) then
1965: x_err_code := 170;
1966: x_err_stage := 'PA_TSK_CC_CUST_EXIST';
1967: return;

Line 1979: pa_proj_tsk_utils.check_projects_exists(x_task_id);

1975: /* Commented for Bug # 2185521.
1976: -- Check if task assign to projects table as a cc_tax_task_id
1977: x_err_stage := 'check task assign to projects table as a cc_tax_task_id '|| x_task_id;
1978: status_code :=
1979: pa_proj_tsk_utils.check_projects_exists(x_task_id);
1980: if ( status_code = 1 ) then
1981: x_err_code := 180;
1982: x_err_stage := 'PA_TSK_CC_PROJ_EXIST';
1983: return;

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

2019: --fix for bug2367945 starts
2020: Is_IEX_Installed := pa_install.is_product_installed('IEX');
2021: If Is_IEX_Installed then
2022: x_err_stage := 'check if task '|| x_task_id || ' is charged in iexpense';
2023: status_code := pa_proj_tsk_utils.check_iex_task_charged(x_task_id);
2024: if ( status_code = 1 ) then
2025: x_err_code := 210;
2026: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
2027: return;

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

2072: x_err_stage := 'get project id of '|| x_task_id;
2073: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2074: --the data has already been deleted from pa_tasks in delete_project flow
2075: /*x_project_id :=
2076: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2077: OPEN get_task_project_id(x_task_id);
2078: FETCH get_task_project_id INTO x_project_id;
2079: CLOSE get_task_project_id;
2080: --Bug 3617393 end

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

2353: -- Check if the task has purchase order distributions
2354:
2355: x_err_stage := 'check purchase order for '|| x_task_id;
2356: status_code :=
2357: pa_proj_tsk_utils.check_po_dist_exists(null, x_task_id);
2358: if ( status_code = 1 ) then
2359: x_err_code := 30;
2360: x_err_stage := 'PA_TSK_PO_DIST_EXIST';
2361: return;

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

2366:
2367: -- Check if the task has purchase order requisitions
2368: x_err_stage := 'check purchase order req for '|| x_task_id;
2369: status_code :=
2370: pa_proj_tsk_utils.check_po_req_dist_exists(null, x_task_id);
2371: if ( status_code = 1 ) then
2372: x_err_code := 40;
2373: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';
2374: return;

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

2379:
2380: -- Check if task has ap invoice distributions
2381: x_err_stage := 'check ap inv distribution for '|| x_task_id;
2382: status_code :=
2383: pa_proj_tsk_utils.check_ap_inv_dist_exists(null, x_task_id);
2384: if ( status_code = 1 ) then
2385: x_err_code := 60;
2386: x_err_stage := 'PA_TSK_AP_INV_EXIST';
2387: return;