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_UTILS2 dependencies on FND_API

Line 2507: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

2503:
2504: /*
2505: * Processing related variables.
2506: */
2507: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2508: l_error_code VARCHAR2(30);
2509: l_error_stage VARCHAR2(30);
2510: l_debug_mode VARCHAR2(1);
2511: l_stage NUMBER ;

Line 3266: x_return_status := FND_API.G_RET_STS_SUCCESS;

3262: ---Initialize the out var.
3263:
3264: x_pa_date := NULL;
3265: x_pa_period_name := NULL;
3266: x_return_status := FND_API.G_RET_STS_SUCCESS;
3267: x_error_code := NULL;
3268:
3269: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3270: l_debug_mode := NVL(l_debug_mode, 'N');

Line 3368: x_return_status := FND_API.G_RET_STS_ERROR ;

3364: IF ( l_debug_mode = 'Y' ) THEN
3365: pa_debug.g_err_stage := 'NDF - get_accrual_pa_dt_per Org PA dt ';
3366: pa_debug.write_file(pa_debug.g_err_stage);
3367: END IF;
3368: x_return_status := FND_API.G_RET_STS_ERROR ;
3369: IF p_prvdr_recvr_flg = 'P' THEN
3370: x_error_code := 'NO_PA_DATE';
3371: ELSE
3372: x_error_code := 'NO_RECVR_PA_DATE';

Line 3380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3376: IF ( l_debug_mode = 'Y' ) THEN
3377: pa_debug.g_err_stage := 'WO Excep - get_accrual_pa_dt_per Org PA Date';
3378: pa_debug.write_file(pa_debug.g_err_stage);
3379: END IF;
3380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3381: raise;
3382: END;
3383: --- Assign the global variables
3384: IF p_prvdr_recvr_flg = 'P' THEN

Line 3487: x_return_status := FND_API.G_RET_STS_ERROR ;

3483: IF ( l_debug_mode = 'Y' ) THEN
3484: pa_debug.g_err_stage := 'get_accrual_pa_dt_per Rev NDF';
3485: pa_debug.write_file(pa_debug.g_err_stage);
3486: END IF;
3487: x_return_status := FND_API.G_RET_STS_ERROR ;
3488: IF p_prvdr_recvr_flg = 'P' THEN
3489: x_error_code := 'PA_NO_REV_PRVDR_ACCR_PA_DATE';
3490: ELSE
3491: x_error_code := 'PA_NO_REV_RECVR_ACCR_PA_DATE';

Line 3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3495: IF ( l_debug_mode = 'Y' ) THEN
3496: pa_debug.g_err_stage := 'get_accrual_pa_dt_per Rev WO';
3497: pa_debug.write_file(pa_debug.g_err_stage);
3498: END IF;
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3500: raise;
3501: END;
3502:
3503: IF p_prvdr_recvr_flg = 'P' THEN

Line 3526: x_return_status := FND_API.G_RET_STS_ERROR ;

3522: pa_debug.g_err_stage := 'get_accrual_pa_dt_per Rev PA Period not defined';
3523: pa_debug.write_file(pa_debug.g_err_stage);
3524: END IF;
3525:
3526: x_return_status := FND_API.G_RET_STS_ERROR ;
3527:
3528: IF p_prvdr_recvr_flg = 'P' THEN
3529: x_error_code := 'PA_NO_REV_PRVDR_ACCR_PA_DATE';
3530: ELSE

Line 3587: x_return_status := FND_API.G_RET_STS_SUCCESS;

3583:
3584: BEGIN
3585: ---Initialize the out variables.
3586: x_gl_period_name := NULL;
3587: x_return_status := FND_API.G_RET_STS_SUCCESS;
3588: x_error_code := NULL;
3589: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3590: l_debug_mode := NVL(l_debug_mode, 'N');
3591:

Line 3663: x_return_status := FND_API.G_RET_STS_ERROR ;

3659: AND PERIOD.adjustment_period_flag = 'N'
3660: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;
3661: EXCEPTION
3662: WHEN NO_DATA_FOUND THEN
3663: x_return_status := FND_API.G_RET_STS_ERROR ;
3664: IF p_prvdr_recvr_flg = 'P' THEN
3665: x_error_code := 'PA_GL_REV_PRVDR_ACCR_NDEF';
3666: ELSE
3667: x_error_code := 'PA_GL_REV_RECVR_ACCR_NDEF';

Line 3675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3671: pa_debug.write_file(pa_debug.g_err_stage);
3672: END IF;
3673: return(NULL);
3674: WHEN OTHERS THEN
3675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3676: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3677: raise;
3678: END;
3679:

Line 3712: x_return_status := FND_API.G_RET_STS_ERROR;

3708: g_r_org_accr_end_date := l_org_accr_end_date ;
3709: g_r_rev_gl_period_name := l_period_name;
3710: END IF;
3711: ELSE -- Period is closed.
3712: x_return_status := FND_API.G_RET_STS_ERROR;
3713: IF p_prvdr_recvr_flg = 'P' THEN
3714: x_error_code := 'PA_GL_REV_PRVDR_ACCR_CLOSED';
3715: ELSE
3716: x_error_code := 'PA_GL_REV_RECVR_ACCR_CLOSED';

Line 3738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3734: x_gl_period_name := l_period_name;
3735: return(l_rev_accr_dt);
3736: EXCEPTION
3737: WHEN OTHERS THEN
3738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3739: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3740: RAISE;
3741: END;
3742: ----------------------------------------------------------------------------------------------------------------

Line 3784: x_return_status := FND_API.G_RET_STS_SUCCESS;

3780:
3781: ---Initialize the out variables.
3782: x_gl_accr_period_name := NULL;
3783: x_gl_accr_dt := NULL;
3784: x_return_status := FND_API.G_RET_STS_SUCCESS;
3785: x_error_code := NULL;
3786: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3787: l_debug_mode := NVL(l_debug_mode, 'N');
3788:

Line 3865: x_return_status := FND_API.G_RET_STS_ERROR ;

3861: AND PERIOD.adjustment_period_flag = 'N'
3862: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;
3863: EXCEPTION
3864: WHEN NO_DATA_FOUND THEN
3865: x_return_status := FND_API.G_RET_STS_ERROR ;
3866: IF p_prvdr_recvr_flg = 'P' THEN
3867: x_error_code := 'PA_GL_PER_PRVDR_ACCR_NOT_DEF';
3868: ELSE
3869: x_error_code := 'PA_GL_PER_RECVR_ACCR_NOT_DEF';

Line 3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3881: pa_debug.write_file(pa_debug.g_err_stage);
3882: END IF;
3883: return;
3884: WHEN OTHERS THEN
3885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3886:
3887: pa_debug.g_err_stage := 'get_accrual_gl_dt_period()-WO sob - ['||p_set_of_books_id||']';
3888: IF ( l_debug_mode = 'Y' ) THEN
3889: pa_debug.write_file(pa_debug.g_err_stage);

Line 3941: x_return_status := FND_API.G_RET_STS_ERROR;

3937: x_gl_accr_dt := l_accr_gl_dt ;
3938: x_gl_accr_period_name := l_accr_gl_period_name ;
3939:
3940: ELSE -- Period is closed.
3941: x_return_status := FND_API.G_RET_STS_ERROR;
3942: x_gl_accr_period_name := l_accr_gl_period_name ; -- We need this for accounted TRX.
3943: IF p_prvdr_recvr_flg = 'P' THEN
3944: x_error_code := 'PA_GL_PER_PRVDR_ACCR_CLOSED';
3945: ELSE

Line 3965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3961: END IF;---------------------l_period_status in ('O','F')------------}
3962:
3963: EXCEPTION
3964: WHEN OTHERS THEN
3965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3966: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3967: raise;
3968: END;
3969: ----------------------------------------------------------------------------------------------------------------

Line 4122: x_return_status := FND_API.G_RET_STS_SUCCESS;

4118: END IF;
4119:
4120: ---Initialize the error var.
4121: x_error_code := NULL;
4122: x_return_status := FND_API.G_RET_STS_SUCCESS;
4123:
4124: pa_debug.g_err_stage :=' Profile option is [' || l_prof_new_gldate_derivation || ']';
4125: IF(l_debug_mode = 'Y') THEN
4126: pa_debug.write_file(pa_debug.g_err_stage);

Line 4471: x_return_status := FND_API.G_RET_STS_ERROR;

4467: pa_debug.g_err_stage := 'Prvdr GL Period Not Found for ORG EI Acct TRX -';
4468: IF(l_debug_mode = 'Y') THEN
4469: pa_debug.write_file(pa_debug.g_err_stage);
4470: END IF;
4471: x_return_status := FND_API.G_RET_STS_ERROR;
4472: x_error_code := 'PA_GL_PER_PRVDR_ACCR_CLOSED';
4473: return; -- Could not find the Period Name.
4474: END IF;
4475:

Line 4763: x_return_status := FND_API.G_RET_STS_SUCCESS;

4759: IF(l_debug_mode = 'Y') THEN
4760: pa_debug.write_file(pa_debug.g_err_stage);
4761: END IF;
4762:
4763: x_return_status := FND_API.G_RET_STS_SUCCESS;
4764: pa_debug.reset_err_stack;
4765:
4766: EXCEPTION
4767: WHEN NO_DATA_FOUND THEN