APPS.PA_UTILS4 dependencies on PA_PROJ_TSK_UTILS

Line 863: x_status_code:=PA_PROJ_TSK_UTILS.check_exp_item_exists(p_project_id,p_task_id);

859:
860: -- Check if task has expenditure item
861: x_err_stage := 'check expenditure item for project:'|| p_project_id;
862:
863: x_status_code:=PA_PROJ_TSK_UTILS.check_exp_item_exists(p_project_id,p_task_id);
864: IF ( x_status_code = 1) THEN
865: x_err_code :=50;
866: x_err_stage := 'PA_TSK_EXP_ITEM_EXIST';
867: return;

Line 876: x_status_code :=pa_proj_tsk_utils.check_po_dist_exists(p_project_id, p_task_id);

872:
873: -- Check if task has purchase order distribution
874: x_err_stage := 'check purchase order for project:'|| p_project_id;
875:
876: x_status_code :=pa_proj_tsk_utils.check_po_dist_exists(p_project_id, p_task_id);
877:
878: IF ( x_status_code = 1 ) then
879: x_err_code := 60;
880: x_err_stage := 'PA_TSK_PO_DIST_EXIST';

Line 889: x_status_code := pa_proj_tsk_utils.check_po_req_dist_exists(p_project_id, p_task_id);

885: END IF;
886:
887: -- Check if task has purchase order requisition
888: x_err_stage := 'check purchase order requisition for project: '|| p_project_id;
889: x_status_code := pa_proj_tsk_utils.check_po_req_dist_exists(p_project_id, p_task_id);
890:
891: IF ( x_status_code = 1 ) then
892: x_err_code := 70;
893: x_err_stage := 'PA_TSK_PO_REQ_DIST_EXIST';

Line 902: x_status_code := pa_proj_tsk_utils.check_ap_invoice_exists(p_project_id, p_task_id);

898: END IF;
899:
900: -- Check if task has supplier invoices
901: x_err_stage := 'check supplier invoice for project:'|| p_project_id;
902: x_status_code := pa_proj_tsk_utils.check_ap_invoice_exists(p_project_id, p_task_id);
903: IF ( x_status_code = 1 ) then
904: x_err_code := 80;
905: x_err_stage := 'PA_TSK_AP_INV_EXIST';
906: return;

Line 914: x_status_code := pa_proj_tsk_utils.check_ap_inv_dist_exists(p_project_id, p_task_id);

910: END IF;
911:
912: -- Check if task has supplier invoice distribution
913: x_err_stage := 'check supplier inv distribution for project: '|| p_project_id;
914: x_status_code := pa_proj_tsk_utils.check_ap_inv_dist_exists(p_project_id, p_task_id);
915: IF ( x_status_code = 1 ) then
916: x_err_code := 90;
917: x_err_stage := 'PA_TSK_AP_INV_DIST_EXIST';
918: return;

Line 1247: l_status_code := pa_proj_tsk_utils.check_po_req_dist_exists(l_project_id, l_task_id);

1243:
1244: -- Check for Requisitions
1245: l_stage := 'Check for Requisitions';
1246: IF x_return_status = 'S' Then
1247: l_status_code := pa_proj_tsk_utils.check_po_req_dist_exists(l_project_id, l_task_id);
1248: IF ( l_status_code = 1 ) then
1249: x_error_msg_code := 'PA_PRJ_PO_REQ_DIST_EXIST';
1250: x_error_stage := l_stage||l_param;
1251: x_return_status := 'E';

Line 1258: l_status_code := pa_proj_tsk_utils.check_po_dist_exists(l_project_id, l_task_id);

1254:
1255: -- Check for Purchase order
1256: IF x_return_status = 'S' Then
1257: l_stage := 'Check purchase order';
1258: l_status_code := pa_proj_tsk_utils.check_po_dist_exists(l_project_id, l_task_id);
1259: IF ( l_status_code = 1 ) then
1260: x_error_msg_code := 'PA_PRJ_PO_DIST_EXIST';
1261: x_error_stage := l_stage||l_param;
1262: x_return_status := 'E';

Line 1269: Hence call to pa_proj_tsk_utils.check_ap_invoice_existsis is commented here

1265:
1266:
1267: /* Bug 6153950: start
1268: Bug 6153950: It is sufficient to query AP Invoice Distributions to check for AP Txns
1269: Hence call to pa_proj_tsk_utils.check_ap_invoice_existsis is commented here
1270:
1271: -- Check for Supplier Invoices
1272: IF x_return_status = 'S' Then
1273: l_stage := 'Check for Supplier Invoices';

Line 1274: l_status_code := pa_proj_tsk_utils.check_ap_invoice_exists(l_project_id, l_task_id);

1270:
1271: -- Check for Supplier Invoices
1272: IF x_return_status = 'S' Then
1273: l_stage := 'Check for Supplier Invoices';
1274: l_status_code := pa_proj_tsk_utils.check_ap_invoice_exists(l_project_id, l_task_id);
1275: IF ( l_status_code = 1 ) then
1276: x_error_msg_code := 'PA_PRJ_AP_INV_EXIST';
1277: x_error_stage := l_stage||l_param;
1278: x_return_status := 'E';

Line 1287: l_status_code := pa_proj_tsk_utils.check_ap_inv_dist_exists(l_project_id, l_task_id);

1283:
1284: -- Check if task has supplier invoice distribution
1285: IF x_return_status = 'S' Then
1286: l_stage := 'Check for Supplier Invoice Distributions';
1287: l_status_code := pa_proj_tsk_utils.check_ap_inv_dist_exists(l_project_id, l_task_id);
1288: IF ( l_status_code = 1 ) then
1289: x_error_msg_code := 'PA_PRJ_AP_INV_DIST_EXIST';
1290: x_error_stage := l_stage||l_param;
1291: x_return_status := 'E';