DBA Data[Home] [Help]

APPS.FARX_MCP dependencies on FARX_MCP

Line 1: PACKAGE BODY FARX_MCP AS

1: PACKAGE BODY FARX_MCP AS
2: /* $Header: FARXMCPB.pls 120.10 2010/06/14 15:49:18 klakshmi ship $ */
3:
4: -- Mass change record from fa_mass_changes table.
5: mc_rec FA_MASS_CHG_UTILS_PKG.mass_change_rec_type;

Line 438: fa_debug_pkg.add('FARX_MCP.Preview_Change',

434: h_debug_flag := 'YES';
435: END IF;
436:
437: if (g_print_debug) then
438: fa_debug_pkg.add('FARX_MCP.Preview_Change',
439: 'Starting Preview',
440: '');
441: end if;
442:

Line 456: fa_debug_pkg.add('FARX_MCP.Preview_Change',

452: request id, if there is any.
453: =========================================================================*/
454:
455: if (g_print_debug) then
456: fa_debug_pkg.add('FARX_MCP.Preview_Change',
457: 'before deleting rows from itf table',
458: '');
459: end if;
460:

Line 478: CALLING_FN => 'FARX_MCP.Preview_Change',

474:
475: IF (h_preview_status_d <> h_current_status_d) THEN
476: -- Re-using message for mass change program.
477: FA_SRVR_MSG.Add_Message(
478: CALLING_FN => 'FARX_MCP.Preview_Change',
479: NAME => 'FA_MASSRCL_WRONG_STATUS',
480: TOKEN1 => 'CURRENT',
481: VALUE1 => h_current_status_d,
482: TOKEN2 => 'RUNNING',

Line 599: fa_debug_pkg.add('FARX_MCP.Preview_Change',

595:
596: END LOOP;
597:
598: if (g_print_debug) then
599: fa_debug_pkg.add('FARX_MCP.Preview_Change',
600: 'after loop',
601: '');
602: end if;
603:

Line 611: fa_debug_pkg.add('FARX_MCP.Preview_Change',

607: -- Up to a_index - 1, to account for the extra increment taken for a_index
608: -- when no more rows were found in the cursor loop.
609:
610: if (g_print_debug) then
611: fa_debug_pkg.add('FARX_MCP.Preview_Change',
612: 'after closing cursor',
613: '');
614: end if;
615:

Line 620: fa_debug_pkg.add('FARX_MCP.Preview_Change',

616:
617: FOR i IN 1 .. (a_index - 1) LOOP
618:
619: if (g_print_debug) then
620: fa_debug_pkg.add('FARX_MCP.Preview_Change',
621: 'asset inserted',
622: a_tbl(i).asset_id);
623: fa_debug_pkg.add('FARX_MCP.Preview_Change',
624: 'book inserted',

Line 623: fa_debug_pkg.add('FARX_MCP.Preview_Change',

619: if (g_print_debug) then
620: fa_debug_pkg.add('FARX_MCP.Preview_Change',
621: 'asset inserted',
622: a_tbl(i).asset_id);
623: fa_debug_pkg.add('FARX_MCP.Preview_Change',
624: 'book inserted',
625: a_tbl(i).book_type_code);
626: end if;
627:

Line 1000: CALLING_FN => 'FARX_MCP.Store_Results');

996:
997: EXCEPTION
998: WHEN OTHERS THEN
999: FA_SRVR_MSG.Add_SQL_Error(
1000: CALLING_FN => 'FARX_MCP.Store_Results');
1001: raise;
1002:
1003: END Store_Results;
1004:

Line 1007: END FARX_MCP;

1003: END Store_Results;
1004:
1005:
1006:
1007: END FARX_MCP;