DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_UTILS2

Line 1365: IF pa_utils2.CheckExporg(p_incurred_by_org_id,p_exp_item_date) = 'N' then

1361:
1362: IF PG_DEBUG = 'Y' THEN
1363: log_message('log_message: Validating exp dates -> Exp Org Level' );
1364: END IF;
1365: IF pa_utils2.CheckExporg(p_incurred_by_org_id,p_exp_item_date) = 'N' then
1366: x_err_msg_cd := 'PA_EXP_ORG_NOT_ACTIVE' ;
1367: x_status := FND_API.G_RET_STS_ERROR ;
1368: RETURN ;
1369: END IF;

Line 1765: G_Business_Group_Id := pa_utils2.GetBusinessGroupId(X_Business_Group_Name);

1761: ELSIF G_Prev_Business_Group_Name = X_Business_Group_Name THEN
1762:
1763: G_Business_Group_Id := G_Prev_Business_Group_Id ;
1764: ELSE
1765: G_Business_Group_Id := pa_utils2.GetBusinessGroupId(X_Business_Group_Name);
1766:
1767: IF G_Business_Group_Id is NULL THEN
1768:
1769: X_status := 'PA_INVALID_BUSINESS_GROUP';

Line 1980: pa_utils2.GetEmpId( G_business_Group_id,

1976: END IF;
1977: -- Fixed Bug 1534973, 1581184
1978: -- Passing X_Ei_Date parameter to GetEmpId
1979:
1980: pa_utils2.GetEmpId( G_business_Group_id,
1981: X_enum,
1982: G_person_id,
1983: P_person_type, /* cwk */
1984: X_Ei_Date );

Line 1986: IF ( pa_utils2.G_return_status IS NOT NULL ) THEN

1982: G_person_id,
1983: P_person_type, /* cwk */
1984: X_Ei_Date );
1985:
1986: IF ( pa_utils2.G_return_status IS NOT NULL ) THEN
1987: X_status := pa_utils2.G_return_status ;
1988: pa_cc_utils.reset_curr_function;
1989: RETURN;
1990: ELSE

Line 1987: X_status := pa_utils2.G_return_status ;

1983: P_person_type, /* cwk */
1984: X_Ei_Date );
1985:
1986: IF ( pa_utils2.G_return_status IS NOT NULL ) THEN
1987: X_status := pa_utils2.G_return_status ;
1988: pa_cc_utils.reset_curr_function;
1989: RETURN;
1990: ELSE
1991: last_empno := X_enum;

Line 2244: pa_debug.G_err_stage := 'Calling pa_utils2.CheckExporg';

2240: IF G_org_id is not NULL THEN
2241: IF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' then /* Added for Bug # 2170237 */
2242: -- Modified the above condition for BUG6931833
2243: IF PG_DEBUG = 'Y' THEN
2244: pa_debug.G_err_stage := 'Calling pa_utils2.CheckExporg';
2245: log_message('log_message: ' || pa_debug.G_err_Stage);
2246: log_message('log_message: ' || 'G_org_id = ' || G_org_id);
2247: END IF;
2248: IF pa_utils2.CheckExporg(G_org_id,X_ei_date) = 'N' then

Line 2248: IF pa_utils2.CheckExporg(G_org_id,X_ei_date) = 'N' then

2244: pa_debug.G_err_stage := 'Calling pa_utils2.CheckExporg';
2245: log_message('log_message: ' || pa_debug.G_err_Stage);
2246: log_message('log_message: ' || 'G_org_id = ' || G_org_id);
2247: END IF;
2248: IF pa_utils2.CheckExporg(G_org_id,X_ei_date) = 'N' then
2249: X_status := 'PA_EXP_ORG_NOT_ACTIVE';
2250: pa_cc_utils.reset_curr_function;
2251: RETURN;
2252: END IF;

Line 2296: IF pa_utils2.CheckExporg(G_override_to_org_id, X_ei_date) = 'N' THEN

2292: pa_cc_utils.reset_curr_function;
2293: RETURN;
2294: ELSIF pa_trx_import.g_skip_tc_flag <> 'Y' and PA_TRX_IMPORT.Get_GVal_ProjTskEi_Date = 'Y' THEN /* Added for Bug # 2170237 */
2295: --Modified above condition for bug6931833
2296: IF pa_utils2.CheckExporg(G_override_to_org_id, X_ei_date) = 'N' THEN
2297: X_status := 'PA_OVERRIDE_ORG_NOT_ACTIVE';
2298: pa_cc_utils.reset_curr_function;
2299: RETURN;
2300: END IF;

Line 2657: pa_debug.G_err_stage := 'Calling pa_utils2.GetLaborCostMultiplier';

2653: pa_cc_utils.reset_curr_function;
2654: RETURN;
2655: ELSE
2656: IF PG_DEBUG = 'Y' THEN
2657: pa_debug.G_err_stage := 'Calling pa_utils2.GetLaborCostMultiplier';
2658: log_message('log_message: ' || pa_debug.G_err_Stage);
2659: END IF;
2660: G_lcm := pa_utils2.GetLaborCostMultiplier(G_Task_id);
2661: last_task := X_tnum;

Line 2660: G_lcm := pa_utils2.GetLaborCostMultiplier(G_Task_id);

2656: IF PG_DEBUG = 'Y' THEN
2657: pa_debug.G_err_stage := 'Calling pa_utils2.GetLaborCostMultiplier';
2658: log_message('log_message: ' || pa_debug.G_err_Stage);
2659: END IF;
2660: G_lcm := pa_utils2.GetLaborCostMultiplier(G_Task_id);
2661: last_task := X_tnum;
2662: END IF;
2663:
2664: END IF;

Line 4019: X_gl_date := pa_utils2.get_prvdr_gl_date( X_ei_date, l_appl_id , l_SobId) ;

4015: into l_SobId
4016: from pa_implementations_all
4017: where nvl(org_id,-99) = nvl(X_org_id,-99);
4018:
4019: X_gl_date := pa_utils2.get_prvdr_gl_date( X_ei_date, l_appl_id , l_SobId) ;
4020:
4021: END IF;
4022: */
4023:

Line 4285: unaccounted case, we call PA_UTILS2.GetPrjOrgId to get

4281: /* IC Change: we need to get receiver org ID regarldess
4282: of accounted or unaccounted transaction. For accounted
4283: case, we call PA_CC_IDENT.pa_cc_identify_txn_adj to
4284: get receiver org ID along with other info. For
4285: unaccounted case, we call PA_UTILS2.GetPrjOrgId to get
4286: only the reciever org id info. */
4287: ELSE
4288: /* IC Changes: Get receiver organization ID */
4289: IF PG_DEBUG = 'Y' THEN

Line 4290: pa_debug.G_err_stage := 'Calling PA_UTILS2.GetPrjOrgId';

4286: only the reciever org id info. */
4287: ELSE
4288: /* IC Changes: Get receiver organization ID */
4289: IF PG_DEBUG = 'Y' THEN
4290: pa_debug.G_err_stage := 'Calling PA_UTILS2.GetPrjOrgId';
4291: log_message('log_message: ' || pa_debug.G_err_Stage);
4292: END IF;
4293: G_RecvrOrgId := PA_UTILS2.GetPrjOrgId(p_project_id => G_project_id,
4294: p_task_id => NULL);

Line 4293: G_RecvrOrgId := PA_UTILS2.GetPrjOrgId(p_project_id => G_project_id,

4289: IF PG_DEBUG = 'Y' THEN
4290: pa_debug.G_err_stage := 'Calling PA_UTILS2.GetPrjOrgId';
4291: log_message('log_message: ' || pa_debug.G_err_Stage);
4292: END IF;
4293: G_RecvrOrgId := PA_UTILS2.GetPrjOrgId(p_project_id => G_project_id,
4294: p_task_id => NULL);
4295: END IF; -- End gl_accted_flag = Y
4296: -- ==========================================================================
4297:

Line 4522: --pa_utils2.get_period_information to derive the accrual period information for the original

4518:
4519: END IF; --Accted = Y and Period_End = N
4520:
4521: --If transaction is accounted or unaccounted, period end accrual transaction then call
4522: --pa_utils2.get_period_information to derive the accrual period information for the original
4523: --and reversing line.
4524: IF ( l_period_end_txn = 'Y' ) THEN
4525:
4526: IF PG_DEBUG = 'Y' THEN

Line 4532: pa_debug.G_err_stage := 'Calling pa_utils2.get_accrual_period_information';

4528: log_message('log_message: ' || pa_debug.G_err_Stage);
4529: END IF;
4530:
4531: IF PG_DEBUG = 'Y' THEN
4532: pa_debug.G_err_stage := 'Calling pa_utils2.get_accrual_period_information';
4533: log_message('log_message: ' || pa_debug.G_err_Stage);
4534: END IF;
4535:
4536: G_GlDate := X_gl_date;

Line 4539: pa_utils2.get_accrual_period_information (

4535:
4536: G_GlDate := X_gl_date;
4537:
4538: --Call get_accrual_period_information API for the original line
4539: pa_utils2.get_accrual_period_information (
4540: p_expenditure_item_date => X_ei_date --in
4541: ,x_prvdr_accrual_date => G_AccDate --in/out. For original item this is passed OUT
4542: ,x_recvr_accrual_date => G_RecvrAccDate --in/out. For original item this is passed OUT
4543: ,p_prvdr_org_id => X_org_id --in

Line 4594: pa_debug.G_err_stage := 'Calling pa_utils2.get_accrual_period_information for the reversing line';

4590: G_RevAccDate := G_AccDate;
4591: G_RevRecvrAccDate := G_RecvrAccDate;
4592:
4593: IF PG_DEBUG = 'Y' THEN
4594: pa_debug.G_err_stage := 'Calling pa_utils2.get_accrual_period_information for the reversing line';
4595: log_message('log_message: ' || pa_debug.G_err_Stage);
4596: END IF;
4597:
4598:

Line 4600: pa_utils2.get_accrual_period_information (

4596: END IF;
4597:
4598:
4599: --Call get_accrual_period_information API for the reversing line
4600: pa_utils2.get_accrual_period_information (
4601: p_expenditure_item_date => X_ei_date
4602: ,x_prvdr_accrual_date => G_RevAccDate --in/out (both)
4603: ,x_recvr_accrual_date => G_RevRecvrAccDate --in/out (both)
4604: ,p_prvdr_org_id => X_org_id

Line 5496: G_OrgNameBGId := pa_utils2.GetBusinessGroupId(business_group_name);

5492: RETURN G_OrgNameOrgName;
5493:
5494: Else
5495:
5496: G_OrgNameBGId := pa_utils2.GetBusinessGroupId(business_group_name);
5497:
5498: BEGIN
5499:
5500: pa_utils2.GetEmpId ( P_Business_Group_Id => G_OrgNameBGId

Line 5500: pa_utils2.GetEmpId ( P_Business_Group_Id => G_OrgNameBGId

5496: G_OrgNameBGId := pa_utils2.GetBusinessGroupId(business_group_name);
5497:
5498: BEGIN
5499:
5500: pa_utils2.GetEmpId ( P_Business_Group_Id => G_OrgNameBGId
5501: , P_Employee_Number => employee_number
5502: , X_Employee_Id => X_emp_id
5503: , P_Person_Type => person_type
5504: , P_EiDate => expenditure_item_date);

Line 11432: pa_debug.G_err_stage := 'Calling PA_UTILS2.GetPrjOrgId';

11428:
11429: END IF;
11430:
11431: IF PG_DEBUG = 'Y' THEN
11432: pa_debug.G_err_stage := 'Calling PA_UTILS2.GetPrjOrgId';
11433: log_message('log_message: ' || pa_debug.G_err_Stage);
11434: END IF;
11435: G_RecvrOrgId := PA_UTILS2.GetPrjOrgId(p_project_id => G_project_id,
11436: p_task_id => NULL);

Line 11435: G_RecvrOrgId := PA_UTILS2.GetPrjOrgId(p_project_id => G_project_id,

11431: IF PG_DEBUG = 'Y' THEN
11432: pa_debug.G_err_stage := 'Calling PA_UTILS2.GetPrjOrgId';
11433: log_message('log_message: ' || pa_debug.G_err_Stage);
11434: END IF;
11435: G_RecvrOrgId := PA_UTILS2.GetPrjOrgId(p_project_id => G_project_id,
11436: p_task_id => NULL);
11437:
11438: IF PG_DEBUG = 'Y' THEN
11439: pa_debug.G_err_stage := 'Calling API to derive/validate assignment and work type info';