DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on PA_PROJ_TSK_UTILS

Line 906: pa_proj_tsk_utils.check_event_exists(x_project_id, null);

902:
903: -- Check if project has event
904: x_err_stage := 'check event for '|| x_project_id;
905: status_code :=
906: pa_proj_tsk_utils.check_event_exists(x_project_id, null);
907: if ( status_code = 1 ) then
908: x_err_code := 20;
909: x_err_stage := 'PA_PROJ_EVENT_EXIST';
910: return;

Line 919: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, null);

915:
916: -- Check if project has expenditure item
917: x_err_stage := 'check expenditure item for '|| x_project_id;
918: status_code :=
919: pa_proj_tsk_utils.check_exp_item_exists(x_project_id, null);
920: if ( status_code = 1 ) then
921: x_err_code := 30;
922: x_err_stage := 'PA_PROJ_EXP_ITEM_EXIST';
923: return;

Line 932: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, null);

928:
929: -- Check if project has purchase order distribution
930: x_err_stage := 'check purchase order for '|| x_project_id;
931: status_code :=
932: pa_proj_tsk_utils.check_po_dist_exists(x_project_id, null);
933: if ( status_code = 1 ) then
934: x_err_code := 40;
935: x_err_stage := 'PA_PROJ_PO_DIST_EXIST';
936: return;

Line 945: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, null);

941:
942: -- Check if project has purchase order requisition
943: x_err_stage := 'check purchase order requisition for '|| x_project_id;
944: status_code :=
945: pa_proj_tsk_utils.check_po_req_dist_exists(x_project_id, null);
946: if ( status_code = 1 ) then
947: x_err_code := 50;
948: x_err_stage := 'PA_PROJ_PO_REQ_DIST_EXIST';
949: return;

Line 958: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, null);

954:
955: -- Check if project has supplier invoices
956: x_err_stage := 'check supplier invoice for '|| x_project_id;
957: status_code :=
958: pa_proj_tsk_utils.check_ap_invoice_exists(x_project_id, null);
959: if ( status_code = 1 ) then
960: x_err_code := 60;
961: x_err_stage := 'PA_PROJ_AP_INV_EXIST';
962: return;

Line 971: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, null);

967:
968: -- Check if project has supplier invoice distribution
969: x_err_stage := 'check supplier inv distribution for '|| x_project_id;
970: status_code :=
971: pa_proj_tsk_utils.check_ap_inv_dist_exists(x_project_id, null);
972: if ( status_code = 1 ) then
973: x_err_code := 70;
974: x_err_stage := 'PA_PROJ_AP_INV_DIST_EXIST';
975: return;

Line 984: pa_proj_tsk_utils.check_funding_exists(x_project_id, null);

980:
981: -- Check if project has funding
982: x_err_stage := 'check funding for '|| x_project_id;
983: status_code :=
984: pa_proj_tsk_utils.check_funding_exists(x_project_id, null);
985: if ( status_code = 1 ) then
986: x_err_code := 80;
987: x_err_stage := 'PA_PROJ_FUND_EXIST';
988: return;

Line 1025: pa_proj_tsk_utils.check_commitment_txn_exists(x_project_id, null);

1021:
1022: -- Check if project has commitment transaction
1023: x_err_stage := 'check commitment transaction for '|| x_project_id;
1024: status_code :=
1025: pa_proj_tsk_utils.check_commitment_txn_exists(x_project_id, null);
1026: if ( status_code = 1 ) then
1027: x_err_code := 100;
1028: x_err_stage := 'PA_PROJ_CMT_TXN_EXIST';
1029: return;

Line 1038: pa_proj_tsk_utils.check_comp_rule_set_exists(x_project_id, null);

1034:
1035: -- Check if project has compensation rule set
1036: x_err_stage := 'check compensation rule set for '|| x_project_id;
1037: status_code :=
1038: pa_proj_tsk_utils.check_comp_rule_set_exists(x_project_id, null);
1039: if ( status_code = 1 ) then
1040: x_err_code := 110;
1041: x_err_stage := 'PA_PROJ_COMP_RULE_SET_EXIST';
1042: return;

Line 1242: pa_proj_tsk_utils.check_service_order_exists(x_project_id, null);

1238: -- End Bug 5750624: Cursor to check the project is allowed to deleted from PJR assignments
1239: /* Start changes for Service Intgration bug#16535441*/
1240: x_err_stage := 'check expenditure item for '|| x_project_id;
1241: status_code :=
1242: pa_proj_tsk_utils.check_service_order_exists(x_project_id, null);
1243: if ( status_code = 1 ) then
1244: x_err_code := 330;
1245: x_err_stage := 'PA_PROJ_SER_ORD_EXIST';
1246: return;

Line 1296: status_code := pa_proj_tsk_utils.check_cdl_exists

1292: return;
1293: end if ;
1294: -- Check for cdls for the project
1295: x_err_stage := 'check cdls for project '|| x_project_id;
1296: status_code := pa_proj_tsk_utils.check_cdl_exists
1297: (x_project_id,Null);
1298: if status_code <> 0 Then
1299: x_err_code := 20;
1300: x_err_stage := 'PA_PR_CANT_CHG_PROJ_TYPE';

Line 1306: status_code := pa_proj_tsk_utils.check_draft_rev_item_exists

1302: end if;
1303:
1304: -- Check for draft revenue items for the project
1305: x_err_stage := 'check draft rev for project '|| x_project_id;
1306: status_code := pa_proj_tsk_utils.check_draft_rev_item_exists
1307: (x_project_id,Null);
1308: if status_code <> 0 Then
1309: x_err_code := 30;
1310: x_err_stage := 'PA_PR_CANT_CHG_PROJ_TYPE';

Line 1316: status_code := pa_proj_tsk_utils.check_draft_inv_item_exists

1312: end if;
1313:
1314: -- Check for draft inv items for the project
1315: x_err_stage := 'check draft inv for project '|| x_project_id;
1316: status_code := pa_proj_tsk_utils.check_draft_inv_item_exists
1317: (x_project_id,Null);
1318: if status_code <> 0 Then
1319: x_err_code := 40;
1320: x_err_stage := 'PA_PR_CANT_CHG_PROJ_TYPE';

Line 1371: status_code := pa_proj_tsk_utils.check_exp_item_exists

1367: end if ;
1368:
1369: -- Check for exp items for the project
1370: x_err_stage := 'check exp items for project '|| x_project_id;
1371: status_code := pa_proj_tsk_utils.check_exp_item_exists
1372: (x_project_id,Null);
1373: if status_code <> 0 Then
1374: x_err_code := 20;
1375: x_err_stage := 'PA_PR_NO_UPD_SEGMENT1_EXP';

Line 1381: status_code := pa_proj_tsk_utils.check_draft_inv_item_exists

1377: end if;
1378:
1379: -- Check for invoices for the project
1380: x_err_stage := 'check invoices for project '|| x_project_id;
1381: status_code := pa_proj_tsk_utils.check_draft_inv_item_exists
1382: (x_project_id,Null);
1383: if status_code <> 0 Then
1384: x_err_code := 30;
1385: x_err_stage := 'PA_PR_NO_UPD_SEGMENT1_INV';

Line 1391: status_code := pa_proj_tsk_utils.check_po_req_dist_exists

1387: end if;
1388:
1389: -- Check for po reqs for the project
1390: x_err_stage := 'check po reqs for project '|| x_project_id;
1391: status_code := pa_proj_tsk_utils.check_po_req_dist_exists
1392: (x_project_id,Null);
1393: if status_code <> 0 Then
1394: x_err_code := 40;
1395: x_err_stage := 'PA_PR_NO_UPD_SEGMENT1_EXP';

Line 1401: status_code := pa_proj_tsk_utils.check_po_dist_exists

1397: end if;
1398:
1399: -- Check for po dist for the project
1400: x_err_stage := 'check po dist for project '|| x_project_id;
1401: status_code := pa_proj_tsk_utils.check_po_dist_exists
1402: (x_project_id,Null);
1403: if status_code <> 0 Then
1404: x_err_code := 50;
1405: x_err_stage := 'PA_PR_NO_UPD_SEGMENT1_EXP';

Line 1411: status_code := pa_proj_tsk_utils.check_ap_invoice_exists

1407: end if;
1408:
1409: -- Check for ap inv for the project
1410: x_err_stage := 'check ap inv for project '|| x_project_id;
1411: status_code := pa_proj_tsk_utils.check_ap_invoice_exists
1412: (x_project_id,Null);
1413: if status_code <> 0 Then
1414: x_err_code := 60;
1415: x_err_stage := 'PA_PR_NO_UPD_SEGMENT1_INV';

Line 1421: status_code := pa_proj_tsk_utils.check_ap_inv_dist_exists

1417: end if;
1418:
1419: -- Check for ap inv dist for the project
1420: x_err_stage := 'check ap inv dist for project '|| x_project_id;
1421: status_code := pa_proj_tsk_utils.check_ap_inv_dist_exists
1422: (x_project_id,Null);
1423: if status_code <> 0 Then
1424: x_err_code := 70;
1425: x_err_stage := 'PA_PR_NO_UPD_SEGMENT1_INV';