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 2483: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

2479:
2480: /*
2481: * Processing related variables.
2482: */
2483: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
2484: l_error_code VARCHAR2(30);
2485: l_error_stage VARCHAR2(30);
2486: l_debug_mode VARCHAR2(1);
2487: l_stage NUMBER ;

Line 3228: x_return_status := FND_API.G_RET_STS_SUCCESS;

3224: ---Initialize the out var.
3225:
3226: x_pa_date := NULL;
3227: x_pa_period_name := NULL;
3228: x_return_status := FND_API.G_RET_STS_SUCCESS;
3229: x_error_code := NULL;
3230:
3231: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3232: l_debug_mode := NVL(l_debug_mode, 'N');

Line 3330: x_return_status := FND_API.G_RET_STS_ERROR ;

3326: IF ( l_debug_mode = 'Y' ) THEN
3327: pa_debug.g_err_stage := 'NDF - get_accrual_pa_dt_per Org PA dt ';
3328: pa_debug.write_file(pa_debug.g_err_stage);
3329: END IF;
3330: x_return_status := FND_API.G_RET_STS_ERROR ;
3331: IF p_prvdr_recvr_flg = 'P' THEN
3332: x_error_code := 'NO_PA_DATE';
3333: ELSE
3334: x_error_code := 'NO_RECVR_PA_DATE';

Line 3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3338: IF ( l_debug_mode = 'Y' ) THEN
3339: pa_debug.g_err_stage := 'WO Excep - get_accrual_pa_dt_per Org PA Date';
3340: pa_debug.write_file(pa_debug.g_err_stage);
3341: END IF;
3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3343: raise;
3344: END;
3345: --- Assign the global variables
3346: IF p_prvdr_recvr_flg = 'P' THEN

Line 3449: x_return_status := FND_API.G_RET_STS_ERROR ;

3445: IF ( l_debug_mode = 'Y' ) THEN
3446: pa_debug.g_err_stage := 'get_accrual_pa_dt_per Rev NDF';
3447: pa_debug.write_file(pa_debug.g_err_stage);
3448: END IF;
3449: x_return_status := FND_API.G_RET_STS_ERROR ;
3450: IF p_prvdr_recvr_flg = 'P' THEN
3451: x_error_code := 'PA_NO_REV_PRVDR_ACCR_PA_DATE';
3452: ELSE
3453: x_error_code := 'PA_NO_REV_RECVR_ACCR_PA_DATE';

Line 3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3457: IF ( l_debug_mode = 'Y' ) THEN
3458: pa_debug.g_err_stage := 'get_accrual_pa_dt_per Rev WO';
3459: pa_debug.write_file(pa_debug.g_err_stage);
3460: END IF;
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3462: raise;
3463: END;
3464:
3465: IF p_prvdr_recvr_flg = 'P' THEN

Line 3488: x_return_status := FND_API.G_RET_STS_ERROR ;

3484: pa_debug.g_err_stage := 'get_accrual_pa_dt_per Rev PA Period not defined';
3485: pa_debug.write_file(pa_debug.g_err_stage);
3486: END IF;
3487:
3488: x_return_status := FND_API.G_RET_STS_ERROR ;
3489:
3490: IF p_prvdr_recvr_flg = 'P' THEN
3491: x_error_code := 'PA_NO_REV_PRVDR_ACCR_PA_DATE';
3492: ELSE

Line 3549: x_return_status := FND_API.G_RET_STS_SUCCESS;

3545:
3546: BEGIN
3547: ---Initialize the out variables.
3548: x_gl_period_name := NULL;
3549: x_return_status := FND_API.G_RET_STS_SUCCESS;
3550: x_error_code := NULL;
3551: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3552: l_debug_mode := NVL(l_debug_mode, 'N');
3553:

Line 3625: x_return_status := FND_API.G_RET_STS_ERROR ;

3621: AND PERIOD.adjustment_period_flag = 'N'
3622: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;
3623: EXCEPTION
3624: WHEN NO_DATA_FOUND THEN
3625: x_return_status := FND_API.G_RET_STS_ERROR ;
3626: IF p_prvdr_recvr_flg = 'P' THEN
3627: x_error_code := 'PA_GL_REV_PRVDR_ACCR_NDEF';
3628: ELSE
3629: x_error_code := 'PA_GL_REV_RECVR_ACCR_NDEF';

Line 3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3633: pa_debug.write_file(pa_debug.g_err_stage);
3634: END IF;
3635: return(NULL);
3636: WHEN OTHERS THEN
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3638: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3639: raise;
3640: END;
3641:

Line 3674: x_return_status := FND_API.G_RET_STS_ERROR;

3670: g_r_org_accr_end_date := l_org_accr_end_date ;
3671: g_r_rev_gl_period_name := l_period_name;
3672: END IF;
3673: ELSE -- Period is closed.
3674: x_return_status := FND_API.G_RET_STS_ERROR;
3675: IF p_prvdr_recvr_flg = 'P' THEN
3676: x_error_code := 'PA_GL_REV_PRVDR_ACCR_CLOSED';
3677: ELSE
3678: x_error_code := 'PA_GL_REV_RECVR_ACCR_CLOSED';

Line 3700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3696: x_gl_period_name := l_period_name;
3697: return(l_rev_accr_dt);
3698: EXCEPTION
3699: WHEN OTHERS THEN
3700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3701: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3702: RAISE;
3703: END;
3704: ----------------------------------------------------------------------------------------------------------------

Line 3746: x_return_status := FND_API.G_RET_STS_SUCCESS;

3742:
3743: ---Initialize the out variables.
3744: x_gl_accr_period_name := NULL;
3745: x_gl_accr_dt := NULL;
3746: x_return_status := FND_API.G_RET_STS_SUCCESS;
3747: x_error_code := NULL;
3748: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3749: l_debug_mode := NVL(l_debug_mode, 'N');
3750:

Line 3827: x_return_status := FND_API.G_RET_STS_ERROR ;

3823: AND PERIOD.adjustment_period_flag = 'N'
3824: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;
3825: EXCEPTION
3826: WHEN NO_DATA_FOUND THEN
3827: x_return_status := FND_API.G_RET_STS_ERROR ;
3828: IF p_prvdr_recvr_flg = 'P' THEN
3829: x_error_code := 'PA_GL_PER_PRVDR_ACCR_NOT_DEF';
3830: ELSE
3831: x_error_code := 'PA_GL_PER_RECVR_ACCR_NOT_DEF';

Line 3847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3843: pa_debug.write_file(pa_debug.g_err_stage);
3844: END IF;
3845: return;
3846: WHEN OTHERS THEN
3847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3848:
3849: pa_debug.g_err_stage := 'get_accrual_gl_dt_period()-WO sob - ['||p_set_of_books_id||']';
3850: IF ( l_debug_mode = 'Y' ) THEN
3851: pa_debug.write_file(pa_debug.g_err_stage);

Line 3903: x_return_status := FND_API.G_RET_STS_ERROR;

3899: x_gl_accr_dt := l_accr_gl_dt ;
3900: x_gl_accr_period_name := l_accr_gl_period_name ;
3901:
3902: ELSE -- Period is closed.
3903: x_return_status := FND_API.G_RET_STS_ERROR;
3904: x_gl_accr_period_name := l_accr_gl_period_name ; -- We need this for accounted TRX.
3905: IF p_prvdr_recvr_flg = 'P' THEN
3906: x_error_code := 'PA_GL_PER_PRVDR_ACCR_CLOSED';
3907: ELSE

Line 3927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3923: END IF;---------------------l_period_status in ('O','F')------------}
3924:
3925: EXCEPTION
3926: WHEN OTHERS THEN
3927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3928: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3929: raise;
3930: END;
3931: ----------------------------------------------------------------------------------------------------------------

Line 4084: x_return_status := FND_API.G_RET_STS_SUCCESS;

4080: END IF;
4081:
4082: ---Initialize the error var.
4083: x_error_code := NULL;
4084: x_return_status := FND_API.G_RET_STS_SUCCESS;
4085:
4086: pa_debug.g_err_stage :=' Profile option is [' || l_prof_new_gldate_derivation || ']';
4087: IF(l_debug_mode = 'Y') THEN
4088: pa_debug.write_file(pa_debug.g_err_stage);

Line 4433: x_return_status := FND_API.G_RET_STS_ERROR;

4429: pa_debug.g_err_stage := 'Prvdr GL Period Not Found for ORG EI Acct TRX -';
4430: IF(l_debug_mode = 'Y') THEN
4431: pa_debug.write_file(pa_debug.g_err_stage);
4432: END IF;
4433: x_return_status := FND_API.G_RET_STS_ERROR;
4434: x_error_code := 'PA_GL_PER_PRVDR_ACCR_CLOSED';
4435: return; -- Could not find the Period Name.
4436: END IF;
4437:

Line 4725: x_return_status := FND_API.G_RET_STS_SUCCESS;

4721: IF(l_debug_mode = 'Y') THEN
4722: pa_debug.write_file(pa_debug.g_err_stage);
4723: END IF;
4724:
4725: x_return_status := FND_API.G_RET_STS_SUCCESS;
4726: pa_debug.reset_err_stack;
4727:
4728: EXCEPTION
4729: WHEN NO_DATA_FOUND THEN