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_PROJ_ELEMENTS_UTILS dependencies on PA_PROJ_TSK_UTILS

Line 4004: pa_proj_tsk_utils.check_exp_item_exists(null, p_task_id);

4000: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check expenditure item for '|| p_task_id;
4001: Pa_Debug.WRITE(g_module_name , Pa_Debug.g_err_stage , l_debug_level3);
4002: END IF;
4003: l_status_code :=
4004: pa_proj_tsk_utils.check_exp_item_exists(null, p_task_id);
4005: IF ( l_status_code = 1 ) THEN
4006: x_error_code := 50;
4007: x_error_msg_code := 'PA_TSK_EXP_ITEM_EXIST';
4008: return;

Line 4021: pa_proj_tsk_utils.check_po_dist_exists(NULL, p_task_id);

4017: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4018: l_debug_level3);
4019: END IF;
4020: l_status_code :=
4021: pa_proj_tsk_utils.check_po_dist_exists(NULL, p_task_id);
4022: IF ( l_status_code = 1 ) THEN
4023: x_error_code := 60;
4024: x_error_msg_code := 'PA_TSK_PO_DIST_EXIST';
4025: return;

Line 4039: pa_proj_tsk_utils.check_po_req_dist_exists(NULL, p_task_id);

4035: l_debug_level3);
4036: END IF;
4037:
4038: l_status_code :=
4039: pa_proj_tsk_utils.check_po_req_dist_exists(NULL, p_task_id);
4040: IF ( l_status_code = 1 ) THEN
4041: x_error_code := 70;
4042: x_error_msg_code := 'PA_TSK_PO_REQ_DIST_EXIST';
4043: return;

Line 4057: pa_proj_tsk_utils.check_ap_invoice_exists(NULL, p_task_id);

4053: l_debug_level3);
4054: END IF;
4055:
4056: l_status_code :=
4057: pa_proj_tsk_utils.check_ap_invoice_exists(NULL, p_task_id);
4058: IF ( l_status_code = 1 ) THEN
4059: x_error_code := 80;
4060: x_error_msg_code := 'PA_TSK_AP_INV_EXIST';
4061: return;

Line 4075: pa_proj_tsk_utils.check_ap_inv_dist_exists(NULL, p_task_id);

4071: l_debug_level3);
4072: END IF;
4073:
4074: l_status_code :=
4075: pa_proj_tsk_utils.check_ap_inv_dist_exists(NULL, p_task_id);
4076: IF ( l_status_code = 1 ) THEN
4077: x_error_code := 90;
4078: x_error_msg_code := 'PA_TSK_AP_INV_DIST_EXIST';
4079: return;

Line 4092: pa_proj_tsk_utils.check_commitment_txn_exists(null, p_task_id);

4088: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4089: l_debug_level3);
4090: END IF;
4091: l_status_code :=
4092: pa_proj_tsk_utils.check_commitment_txn_exists(null, p_task_id);
4093: IF ( l_status_code = 1 ) THEN
4094: x_error_code := 110;
4095: x_error_msg_code := 'PA_TSK_CMT_TXN_EXIST';
4096: return;

Line 4110: pa_proj_tsk_utils.check_comp_rule_set_exists(NULL, p_task_id);

4106: l_debug_level3);
4107: END IF;
4108:
4109: l_status_code :=
4110: pa_proj_tsk_utils.check_comp_rule_set_exists(NULL, p_task_id);
4111: IF ( l_status_code = 1 ) THEN
4112: x_error_code := 120;
4113: x_error_msg_code := 'PA_TSK_COMP_RULE_SET_EXIST';
4114: return;

Line 4173: pa_proj_tsk_utils.check_draft_inv_details_exists(p_task_id);

4169: l_debug_level3);
4170: END IF;
4171:
4172: l_status_code :=
4173: pa_proj_tsk_utils.check_draft_inv_details_exists(p_task_id);
4174: IF ( l_status_code = 1 ) THEN
4175: x_error_code := 160;
4176: x_error_msg_code := 'PA_TSK_CC_DINV_EXIST';
4177: return;

Line 4192: pa_proj_tsk_utils.check_project_customer_exists(p_task_id);

4188: END IF;
4189:
4190:
4191: l_status_code :=
4192: pa_proj_tsk_utils.check_project_customer_exists(p_task_id);
4193: IF ( l_status_code = 1 ) THEN
4194: x_error_code := 170;
4195: x_error_msg_code := 'PA_TSK_CC_CUST_EXIST';
4196: return;

Line 4255: l_status_code := pa_proj_tsk_utils.check_iex_task_charged(p_task_id);

4251: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4252: l_debug_level3);
4253: END IF;
4254:
4255: l_status_code := pa_proj_tsk_utils.check_iex_task_charged(p_task_id);
4256: IF ( l_status_code = 1 ) THEN
4257: x_error_code := 210;
4258: x_error_msg_code := 'PA_TSK_EXP_ITEM_EXIST';
4259: return;

Line 5439: Pa_Debug.WRITE('pa_proj_tsk_utils', Pa_Debug.g_err_stage ,l_debug_level3 );

5435: END IF;
5436:
5437: IF l_debug_mode = 'Y' THEN
5438: Pa_Debug.g_err_stage:= 'TASK_VALIDATIONS : Printing Input parameters';
5439: Pa_Debug.WRITE('pa_proj_tsk_utils', Pa_Debug.g_err_stage ,l_debug_level3 );
5440: Pa_Debug.WRITE('pa_proj_tsk_utils', 'p_task_id'||':'||p_task_id , l_debug_level3);
5441: END IF;
5442:
5443: l_Cbs_Enabled := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => p_project_id); -- bug#16461684

Line 5440: Pa_Debug.WRITE('pa_proj_tsk_utils', 'p_task_id'||':'||p_task_id , l_debug_level3);

5436:
5437: IF l_debug_mode = 'Y' THEN
5438: Pa_Debug.g_err_stage:= 'TASK_VALIDATIONS : Printing Input parameters';
5439: Pa_Debug.WRITE('pa_proj_tsk_utils', Pa_Debug.g_err_stage ,l_debug_level3 );
5440: Pa_Debug.WRITE('pa_proj_tsk_utils', 'p_task_id'||':'||p_task_id , l_debug_level3);
5441: END IF;
5442:
5443: l_Cbs_Enabled := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => p_project_id); -- bug#16461684
5444:

Line 5528: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5524: EXCEPTION
5525: WHEN NO_DATA_FOUND THEN
5526: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS : No Expenditure Items exist in the entire task hierarchy';
5527: IF l_debug_mode = 'Y' THEN
5528: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5529: END IF;
5530: WHEN OTHERS THEN
5531: x_error_code := SQLCODE;
5532: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5536: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5532: x_error_msg_code := substrb(SQLERRM,1,120);
5533: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking Expenditure Items';
5534:
5535: IF l_debug_mode = 'Y' THEN
5536: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5537: END IF;
5538: return;
5539: END;
5540:

Line 5570: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5566: EXCEPTION
5567: WHEN NO_DATA_FOUND THEN
5568: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No purchase order distribution exist in the entire task hierarchy';
5569: IF l_debug_mode = 'Y' THEN
5570: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5571: END IF;
5572: WHEN OTHERS THEN
5573: x_error_code := SQLCODE;
5574: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5578: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5574: x_error_msg_code := substrb(SQLERRM,1,120);
5575: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking purchase order distribution';
5576:
5577: IF l_debug_mode = 'Y' THEN
5578: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5579: END IF;
5580:
5581: return;
5582: END;

Line 5612: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5608: EXCEPTION
5609: WHEN NO_DATA_FOUND THEN
5610: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No purchase order requisition exist in the entire task hierarchy';
5611: IF l_debug_mode = 'Y' THEN
5612: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5613: END IF;
5614: WHEN OTHERS THEN
5615: x_error_code := SQLCODE;
5616: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5620: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5616: x_error_msg_code := substrb(SQLERRM,1,120);
5617: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking purchase order requisition';
5618:
5619: IF l_debug_mode = 'Y' THEN
5620: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5621: END IF;
5622:
5623: return;
5624: END;

Line 5654: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5650: EXCEPTION
5651: WHEN NO_DATA_FOUND THEN
5652: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No supplier invoices exist in the entire task hierarchy' ;
5653: IF l_debug_mode = 'Y' THEN
5654: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5655: END IF;
5656: WHEN OTHERS THEN
5657: x_error_code := SQLCODE;
5658: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5662: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5658: x_error_msg_code := substrb(SQLERRM,1,120);
5659: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking supplier invoices';
5660:
5661: IF l_debug_mode = 'Y' THEN
5662: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5663: END IF;
5664: return;
5665: END;
5666:

Line 5695: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5691: EXCEPTION
5692: WHEN NO_DATA_FOUND THEN
5693: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No supplier invoice distribution exist';
5694: IF l_debug_mode = 'Y' THEN
5695: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5696: END IF;
5697: WHEN OTHERS THEN
5698: x_error_code := SQLCODE;
5699: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5703: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5699: x_error_msg_code := substrb(SQLERRM,1,120);
5700: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking supplier invoice distribution' ;
5701:
5702: IF l_debug_mode = 'Y' THEN
5703: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5704: END IF;
5705: return;
5706: END;
5707:

Line 5733: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5729: EXCEPTION
5730: WHEN NO_DATA_FOUND THEN
5731: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No commitment transaction exist';
5732: IF l_debug_mode = 'Y' THEN
5733: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5734: END IF;
5735: WHEN OTHERS THEN
5736: x_error_code := SQLCODE;
5737: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5741: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5737: x_error_msg_code := substrb(SQLERRM,1,120);
5738: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking commitment transaction';
5739:
5740: IF l_debug_mode = 'Y' THEN
5741: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5742: END IF;
5743: return;
5744: END;
5745:

Line 5775: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5771: EXCEPTION
5772: WHEN NO_DATA_FOUND THEN
5773: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No compensation rule set exist';
5774: IF l_debug_mode = 'Y' THEN
5775: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5776: END IF;
5777: WHEN OTHERS THEN
5778: x_error_code := SQLCODE;
5779: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5783: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5779: x_error_msg_code := substrb(SQLERRM,1,120);
5780: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking compensation rule set';
5781:
5782: IF l_debug_mode = 'Y' THEN
5783: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5784: END IF;
5785: return;
5786: END;
5787:

Line 5816: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5812: EXCEPTION
5813: WHEN NO_DATA_FOUND THEN
5814: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No draft invoice exist';
5815: IF l_debug_mode = 'Y' THEN
5816: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5817: END IF;
5818: WHEN OTHERS THEN
5819: x_error_code := SQLCODE;
5820: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5824: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5820: x_error_msg_code := substrb(SQLERRM,1,120);
5821: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking draft invoices';
5822:
5823: IF l_debug_mode = 'Y' THEN
5824: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5825: END IF;
5826: return;
5827: END;
5828:

Line 5854: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5850: EXCEPTION
5851: WHEN NO_DATA_FOUND THEN
5852: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No Project_customers exist';
5853: IF l_debug_mode = 'Y' THEN
5854: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5855: END IF;
5856: WHEN OTHERS THEN
5857: x_error_code := SQLCODE;
5858: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5862: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5858: x_error_msg_code := substrb(SQLERRM,1,120);
5859: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking project customers';
5860:
5861: IF l_debug_mode = 'Y' THEN
5862: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5863: END IF;
5864: return;
5865: END;
5866:

Line 5896: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5892: EXCEPTION
5893: WHEN NO_DATA_FOUND THEN
5894: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No IExpenses exist in the entire task hierarchy';
5895: IF l_debug_mode = 'Y' THEN
5896: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5897: END IF;
5898: WHEN OTHERS THEN
5899: x_error_code := SQLCODE;
5900: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5904: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5900: x_error_msg_code := substrb(SQLERRM,1,120);
5901: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking IExpense Records';
5902:
5903: IF l_debug_mode = 'Y' THEN
5904: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5905: END IF;
5906:
5907: return;
5908: END;

Line 5938: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5934: EXCEPTION
5935: WHEN NO_DATA_FOUND THEN
5936: Pa_Debug.g_err_stage:= 'API : TASK_VALIDATIONS : No Inventory transactions exist in the entire task hierarchy';
5937: IF l_debug_mode = 'Y' THEN
5938: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5939: END IF;
5940: WHEN OTHERS THEN
5941: x_error_code := SQLCODE;
5942: x_error_msg_code := substrb(SQLERRM,1,120);

Line 5946: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

5942: x_error_msg_code := substrb(SQLERRM,1,120);
5943: Pa_Debug.g_err_stage:= ' TASK_VALIDATIONS :Unexpected Error occured while checking Inventory Records';
5944:
5945: IF l_debug_mode = 'Y' THEN
5946: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
5947: END IF;
5948:
5949: return;
5950: END;

Line 5967: ( p_pkg_name => 'pa_proj_tsk_utils'

5963:
5964: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_error_msg_code;
5965:
5966: Fnd_Msg_Pub.add_exc_msg
5967: ( p_pkg_name => 'pa_proj_tsk_utils'
5968: ,p_procedure_name => 'TASK_VALIDATIONS'
5969: ,p_error_text => x_error_msg_code);
5970:
5971: IF l_debug_mode = 'Y' THEN

Line 5972: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,

5968: ,p_procedure_name => 'TASK_VALIDATIONS'
5969: ,p_error_text => x_error_msg_code);
5970:
5971: IF l_debug_mode = 'Y' THEN
5972: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,
5973: l_debug_level5);
5974:
5975: Pa_Debug.reset_curr_function;
5976: END IF;

Line 6069: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

6065: EXCEPTION
6066: WHEN OTHERS THEN
6067: Pa_Debug.g_err_stage:= ' API:get_task_hierarchy :Unexpected Error occured while retrieving task strucutre for '|| p_task_id;
6068: IF l_debug_mode = 'Y' THEN
6069: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
6070: pa_debug.reset_curr_function; --Bug 8525293
6071: END IF;
6072: RAISE;
6073: END get_task_hierarchy;

Line 6128: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);

6124: EXCEPTION
6125: WHEN OTHERS THEN
6126: Pa_Debug.g_err_stage:= ' API:get_Alt_task_List :Unexpected Error occured while retrieving task strucutre for '|| p_task_id;
6127: IF l_debug_mode = 'Y' THEN
6128: Pa_Debug.WRITE('pa_proj_tsk_utils',Pa_Debug.g_err_stage,l_debug_level3);
6129: pa_debug.reset_curr_function;
6130: END IF;
6131: RAISE;
6132: END get_Alt_task_List;