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.3.12010000.1 2008/07/28 13:13:55 appldev ship $ */
3:
4: -- Mass change record from fa_mass_changes table.
5: mc_rec FA_MASS_CHG_UTILS_PKG.mass_change_rec_type;

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

328: h_debug_flag := 'YES';
329: END IF;
330:
331: if (g_print_debug) then
332: fa_debug_pkg.add('FARX_MCP.Preview_Change',
333: 'Starting Preview',
334: '');
335: end if;
336:

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

346: request id, if there is any.
347: =========================================================================*/
348:
349: if (g_print_debug) then
350: fa_debug_pkg.add('FARX_MCP.Preview_Change',
351: 'before deleting rows from itf table',
352: '');
353: end if;
354:

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

368:
369: IF (h_preview_status_d <> h_current_status_d) THEN
370: -- Re-using message for mass change program.
371: FA_SRVR_MSG.Add_Message(
372: CALLING_FN => 'FARX_MCP.Preview_Change',
373: NAME => 'FA_MASSRCL_WRONG_STATUS',
374: TOKEN1 => 'CURRENT',
375: VALUE1 => h_current_status_d,
376: TOKEN2 => 'RUNNING',

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

488:
489: END LOOP;
490:
491: if (g_print_debug) then
492: fa_debug_pkg.add('FARX_MCP.Preview_Change',
493: 'after loop',
494: '');
495: end if;
496:

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

500: -- Up to a_index - 1, to account for the extra increment taken for a_index
501: -- when no more rows were found in the cursor loop.
502:
503: if (g_print_debug) then
504: fa_debug_pkg.add('FARX_MCP.Preview_Change',
505: 'after closing cursor',
506: '');
507: end if;
508:

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

509:
510: FOR i IN 1 .. (a_index - 1) LOOP
511:
512: if (g_print_debug) then
513: fa_debug_pkg.add('FARX_MCP.Preview_Change',
514: 'asset inserted',
515: a_tbl(i).asset_id);
516: fa_debug_pkg.add('FARX_MCP.Preview_Change',
517: 'book inserted',

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

512: if (g_print_debug) then
513: fa_debug_pkg.add('FARX_MCP.Preview_Change',
514: 'asset inserted',
515: a_tbl(i).asset_id);
516: fa_debug_pkg.add('FARX_MCP.Preview_Change',
517: 'book inserted',
518: a_tbl(i).book_type_code);
519: end if;
520:

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

892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: FA_SRVR_MSG.Add_SQL_Error(
896: CALLING_FN => 'FARX_MCP.Store_Results');
897: raise;
898:
899: END Store_Results;
900:

Line 903: END FARX_MCP;

899: END Store_Results;
900:
901:
902:
903: END FARX_MCP;