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.AP_UTILITIES_PKG dependencies on FND_LOG

Line 13: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

11: G_LINES_PER_FETCH CONSTANT NUMBER := 1000;
12:
13: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

12:
13: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_UTILITIES_PKG';

Line 17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

13: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_UTILITIES_PKG';
21:

Line 18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

14: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_UTILITIES_PKG';
21:
22: function AP_Get_Displayed_Field

Line 19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

15: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
16: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
17: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
18: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_UTILITIES_PKG';
21:
22: function AP_Get_Displayed_Field
23: (LookupType IN varchar2

Line 422: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

418: begin
419:
420: l_debug_info := 'Begining of Function';
421: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
422: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
423: END IF;
424:
425: l_acct_date_org := To_Char(P_Date, 'DD-MON-YYYY')||'-'||To_Char(P_Org_Id);
426:

Line 429: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

425: l_acct_date_org := To_Char(P_Date, 'DD-MON-YYYY')||'-'||To_Char(P_Org_Id);
426:
427: l_debug_info := 'Index Value: '||l_acct_date_org;
428: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
429: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
430: END IF;
431:
432:
433: If g_curr_period_name_t.Count > 0 Then

Line 441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

437: l_period_name := g_curr_period_name_t(l_acct_date_org).period_name;
438:
439: l_debug_info := 'Period Name from existing plsql table for index found: '||l_period_name;
440: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
442: END IF;
443:
444: Else
445:

Line 454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

450: g_curr_period_name_t(l_acct_date_org).period_name := l_period_name;
451:
452: l_debug_info :='Period Name from existing plsql table for index not found: '||l_period_name;
453: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
455: END IF;
456:
457:
458: End If;

Line 470: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

466: g_curr_period_name_t(l_acct_date_org).period_name := l_period_name;
467:
468: l_debug_info := 'Period Name not there in plsql table : '||l_period_name;
469: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
470: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
471: END IF;
472:
473: End If;
474:

Line 554: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

550: begin
551:
552: l_debug_info := 'Begining of Function';
553: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
554: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
555: END IF;
556:
557: l_acct_date_org := To_Char(P_Date, 'DD-MON-YYYY')||'-'||To_Char(P_Org_Id);
558:

Line 561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

557: l_acct_date_org := To_Char(P_Date, 'DD-MON-YYYY')||'-'||To_Char(P_Org_Id);
558:
559: l_debug_info := 'Index Value: '||l_acct_date_org;
560: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
561: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
562: END IF;
563:
564:
565: If g_open_period_name_t.Count > 0 Then

Line 574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

570: l_start_date := g_open_period_name_t(l_acct_date_org).start_date;
571:
572: l_debug_info := 'Period Name from existing plsql table for index found: '||l_period_name;
573: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
575: END IF;
576:
577: Else
578:

Line 585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

581: close l_open_cursor;
582:
583: l_debug_info:='Period Name from existing plsql table for index not found: '||l_period_name;
584: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
586: END IF;
587:
588:
589: g_open_period_name_t(l_acct_date_org).period_name := l_period_name;

Line 605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

601: g_open_period_name_t(l_acct_date_org).start_date := l_start_date;
602:
603: l_debug_info := 'Period Name not there in plsql table: '||l_period_name;
604: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
606: END IF;
607:
608: End If;
609:

Line 3372: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3368: IS
3369:
3370: l_current_calling_sequence VARCHAR2(2000);
3371: l_procedure_name CONSTANT VARCHAR2(60) := 'Get_PO_Reversed_Encumb_Amount';
3372: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3373:
3374: l_unencumbered_amount NUMBER;
3375: l_upg_unencumbered_amount NUMBER;
3376: l_total_unencumbered_amount NUMBER;

Line 3435: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3431: l_current_calling_sequence := 'AP_UTILITIES_PKG.'
3432: || 'Get_PO_Reversed_Encumb_Amount<-'
3433: || P_calling_sequence;
3434:
3435: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3436:
3437: l_log_msg := 'Begin of procedure '|| l_procedure_name;
3438: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3439: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 3439: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3435: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3436:
3437: l_log_msg := 'Begin of procedure '|| l_procedure_name;
3438: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3439: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3440: G_MODULE_NAME||l_procedure_name||'.begin',
3441: l_log_msg);
3442: END IF;
3443:

Line 3448: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3444: -----------------------------------------------------------
3445: l_log_msg := 'Start to Open the po_encumbrance_cur' ;
3446: -----------------------------------------------------------
3447: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3448: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3449: G_MODULE_NAME||l_procedure_name||'.begin',
3450: l_log_msg);
3451: END IF;
3452:

Line 3463: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3459: -----------------------------------------------------------
3460: l_log_msg := 'NO encumbrance line exists' ;
3461: -----------------------------------------------------------
3462: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3463: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3464: G_MODULE_NAME||l_procedure_name||'.begin',
3465: l_log_msg);
3466: END IF;
3467:

Line 3477: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3473: -----------------------------------------------------------
3474: l_log_msg := 'close the cursor po_enc_reversed_cur' ;
3475: -----------------------------------------------------------
3476: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3477: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3478: G_MODULE_NAME||l_procedure_name||'.begin',
3479: l_log_msg);
3480: END IF;
3481:

Line 3488: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3484: -----------------------------------------------------------
3485: l_log_msg := 'Open upgraded_po_enc_rev_cur' ;
3486: -----------------------------------------------------------
3487: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3488: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3489: G_MODULE_NAME||l_procedure_name||'.begin',
3490: l_log_msg);
3491: END IF;
3492:

Line 3501: FND_LOG.STRING(G_LEVEL_PROCEDURE,

3497: -----------------------------------------------------------
3498: l_log_msg := 'NO upgraded encumbrance reversals exist' ;
3499: -----------------------------------------------------------
3500: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
3501: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3502: G_MODULE_NAME||l_procedure_name||'.begin',
3503: l_log_msg);
3504: END IF;
3505:

Line 3524: FND_LOG.STRING(G_LEVEL_EXCEPTION,

3520: EXCEPTION
3521: WHEN OTHERS THEN
3522:
3523: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
3524: FND_LOG.STRING(G_LEVEL_EXCEPTION,
3525: G_MODULE_NAME || l_procedure_name,
3526: 'EXCEPTION');
3527: END IF;
3528:

Line 3670: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

3666: l_current_calling_sequence := P_calling_sequence||'->'||'get_gl_natural_account';
3667:
3668: l_debug_info := 'Begin of get_gl_natural_account';
3669: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3670: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
3671: END IF;
3672:
3673: /* Bug 7172942 - Added caching logic to improve performance. */
3674:

Line 3683: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

3679: ELSE
3680: --Bug 7172942
3681: l_debug_info := 'Natural Segment not found in Cache';
3682: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3683: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
3684: END IF;
3685:
3686: l_success := FND_FLEX_APIS.get_segment_column(101,
3687: 'GL#',

Line 3694: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

3690: l_segment_num);
3691:
3692: l_debug_info := 'FND API returned Natural Account: '||To_Char(l_segment_num);
3693: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3694: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
3695: END IF;
3696:
3697: IF (l_success = FALSE) THEN
3698: l_debug_info := 'FND API Failed';

Line 3700: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

3696:
3697: IF (l_success = FALSE) THEN
3698: l_debug_info := 'FND API Failed';
3699: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3700: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
3701: END IF;
3702: RAISE e_api_failure;
3703: END IF;
3704:

Line 3707: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

3703: END IF;
3704:
3705: l_debug_info := 'Dyn SQL to be run for ccid: '||p_ccid||' and CoA ID:'||p_coa_id;
3706: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3707: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
3708: END IF;
3709:
3710: EXECUTE IMMEDIATE 'SELECT '|| l_segment_num ||
3711: ' from gl_code_combinations where code_combination_id = :a '

Line 3716: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);

3712: INTO l_nat_account USING p_ccid;
3713:
3714: l_debug_info := 'Natural account: '||l_nat_account||'. end of function call. ';
3715: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3716: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
3717: END IF;
3718:
3719: --Bug 7172942
3720: g_natural_acct_seg_t(l_coa_ccid).natural_acct_seg := l_nat_account ;