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.FEM_PL_INCR_PKG dependencies on FEM_PL_INCR_PKG

Line 1: PACKAGE BODY FEM_PL_INCR_PKG AS

1: PACKAGE BODY FEM_PL_INCR_PKG AS
2: /* $Header: fem_pl_incr.plb 120.1 2006/02/27 17:35:33 gcheng noship $ */
3:
4: -- Private package variables
5: G_RUNNING CONSTANT VARCHAR2(10) := 'RUNNING';

Line 133: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

129: BEGIN
130:
131: FEM_ENGINES_PKG.Tech_Message
132: (p_severity => fnd_log.level_procedure,
133: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
134: 'exec_lock_exists.begin',
135: p_msg_text => 'BEGIN');
136:
137: -- ----------------------------------------------------------------------

Line 186: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

182: IF x_exec_lock_exists = 'T' THEN
183:
184: FEM_ENGINES_PKG.Tech_Message
185: (p_severity => fnd_log.level_procedure,
186: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
187: 'exec_lock_exists.oele',
188: p_msg_text => 'RETURNING: Object Execution Lock Exists');
189:
190: RETURN;

Line 228: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

224: IF x_exec_lock_exists = 'T' THEN
225:
226: FEM_ENGINES_PKG.Tech_Message
227: (p_severity => fnd_log.level_procedure,
228: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
229: 'exec_lock_exists.emle',
230: p_msg_text => 'RETURNING: Execution Mode Lock Exists; ' ||
231: 'x_exec_state = NULL');
232:

Line 240: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

236: END IF;
237:
238: FEM_ENGINES_PKG.Tech_Message
239: (p_severity => fnd_log.level_procedure,
240: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
241: 'exec_lock_exists.end',
242: p_msg_text => 'END');
243:
244: END Exec_Lock_Exists;

Line 324: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

320: BEGIN
321:
322: FEM_ENGINES_PKG.Tech_Message
323: (p_severity => fnd_log.level_procedure,
324: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
325: 'xgl_obj_exec_lock_exists.begin',
326: p_msg_text => 'BEGIN');
327:
328: -- ----------------------------------------------------------------------

Line 337: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

333: FOR reset IN c1 LOOP
334:
335: FEM_ENGINES_PKG.Tech_Message
336: (p_severity => fnd_log.level_statement,
337: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
338: 'xgl_obj_exec_lock_exists.reset_request_id.',
339: p_app_name => 'FEM',
340: p_msg_name => 'FEM_GL_POST_204',
341: p_token1 => 'VAR_NAME',

Line 394: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

390: -- ----------------------------------------------------------------
391:
392: FEM_ENGINES_PKG.Tech_Message
393: (p_severity => fnd_log.level_procedure,
394: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
395: 'xgl_obj_exec_lock_exists.end.normal1.',
396: p_msg_text => 'END: x_exec_state = NORMAL');
397:
398: x_obj_exec_lock_exists := 'F';

Line 421: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

417: -- -------------------------------------------------------------------
418:
419: FEM_ENGINES_PKG.Tech_Message
420: (p_severity => fnd_log.level_exception,
421: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
422: 'xgl_obj_exec_lock_exists.end.wr',
423: p_app_name => 'FEM',
424: p_msg_name => 'FEM_GL_POST_016');
425:

Line 454: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

450: -- -------------------------------------------------------------------
451:
452: FEM_ENGINES_PKG.Tech_Message
453: (p_severity => fnd_log.level_exception,
454: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
455: 'xgl_obj_exec_lock_exists.end.wrv',
456: p_app_name => 'FEM',
457: p_msg_name => 'FEM_GL_POST_017');
458:

Line 501: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

497: -- -------------------------------------------------------------------
498:
499: FEM_ENGINES_PKG.Tech_Message
500: (p_severity => fnd_log.level_procedure,
501: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
502: 'xgl_obj_exec_lock_exists.end.normal2.',
503: p_msg_text => 'END: x_exec_state = NORMAL');
504:
505: x_obj_exec_lock_exists := 'F';

Line 519: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

515: -- -------------------------------------------------------------------
516:
517: FEM_ENGINES_PKG.Tech_Message
518: (p_severity => fnd_log.level_procedure,
519: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
520: 'xgl_obj_exec_lock_exists.end.rerun',
521: p_msg_text => 'END: x_exec_state = RERUN');
522:
523: x_obj_exec_lock_exists := 'F';

Line 539: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

535: -- -------------------------------------------------------------------
536:
537: FEM_ENGINES_PKG.Tech_Message
538: (p_severity => fnd_log.level_exception,
539: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
540: 'xgl_obj_exec_lock_exists.end.eule1.',
541: p_app_name => 'FEM',
542: p_msg_name => 'FEM_GL_POST_018');
543:

Line 577: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

573: -- ----------------------------------------------------------------
574:
575: FEM_ENGINES_PKG.Tech_Message
576: (p_severity => fnd_log.level_exception,
577: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
578: 'xgl_obj_exec_lock_exists.end.oar1.',
579: p_app_name => 'FEM',
580: p_msg_name => 'FEM_GL_POST_019');
581:

Line 608: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

604: -- -------------------------------------------------------------
605:
606: FEM_ENGINES_PKG.Tech_Message
607: (p_severity => fnd_log.level_procedure,
608: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
609: 'xgl_obj_exec_lock_exists.end.restart',
610: p_msg_text => 'END: x_exec_state = RESTART');
611:
612: x_obj_exec_lock_exists := 'F';

Line 629: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

625: -- -------------------------------------------------------------
626:
627: FEM_ENGINES_PKG.Tech_Message
628: (p_severity => fnd_log.level_exception,
629: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
630: 'xgl_obj_exec_lock_exists.end.oar2.',
631: p_app_name => 'FEM',
632: p_msg_name => 'FEM_GL_POST_019');
633:

Line 652: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

648: END IF;
649:
650: FEM_ENGINES_PKG.Tech_Message
651: (p_severity => fnd_log.level_exception,
652: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
653: 'xgl_obj_exec_lock_exists.end',
654: p_msg_text => 'Invalid Exec Status for previous execution: ' ||
655: v_prev_exec_status_cd ||
656: '. Previous Request ID: ' || TO_CHAR(v_prev_request_id));

Line 660: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

656: '. Previous Request ID: ' || TO_CHAR(v_prev_request_id));
657:
658: FEM_ENGINES_PKG.Tech_Message
659: (p_severity => fnd_log.level_exception,
660: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
661: 'xgl_obj_exec_lock_exists.end.eule2.',
662: p_app_name => 'FEM',
663: p_msg_name => 'FEM_GL_POST_018');
664:

Line 724: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

720: BEGIN
721:
722: FEM_ENGINES_PKG.Tech_Message
723: (p_severity => fnd_log.level_procedure,
724: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
725: 'xgl_exec_mode_lock_exists.begin',
726: p_msg_text => 'BEGIN');
727:
728: IF p_exec_mode NOT IN ('S', 'I', 'E') THEN

Line 734: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

730: -- Execution mode is invalid
731:
732: FEM_ENGINES_PKG.Tech_Message
733: (p_severity => fnd_log.level_exception,
734: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
735: 'xgl_exec_mode_lock_exists.iem',
736: p_app_name => 'FEM',
737: p_msg_name => 'FEM_GL_POST_014');
738:

Line 776: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

772: -- ------------------------------------------------------------------
773:
774: FEM_ENGINES_PKG.Tech_Message
775: (p_severity => fnd_log.level_exception,
776: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
777: 'xgl_exec_mode_lock_exists.ssar',
778: p_app_name => 'FEM',
779: p_msg_name => 'FEM_GL_POST_012');
780:

Line 799: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

795: -- ------------------------------------------------------------------
796:
797: FEM_ENGINES_PKG.Tech_Message
798: (p_severity => fnd_log.level_exception,
799: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
800: 'xgl_exec_mode_lock_exists.ssnry',
801: p_app_name => 'FEM',
802: p_msg_name => 'FEM_GL_POST_013');
803:

Line 820: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

816: x_exec_mode_lock_exists := 'F';
817:
818: FEM_ENGINES_PKG.Tech_Message
819: (p_severity => fnd_log.level_procedure,
820: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
821: 'xgl_exec_mode_lock_exists.end',
822: p_msg_text => 'END');
823:
824: END XGL_Exec_Mode_Lock_Exists;

Line 876: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

872: BEGIN
873:
874: FEM_ENGINES_PKG.Tech_Message
875: (p_severity => fnd_log.level_procedure,
876: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
877: 'snapshot_period_lock_exists.begin',
878: p_msg_text => 'BEGIN');
879:
880: -- -----------------------------------------------------------------------

Line 910: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

906: AND cal_period_id = p_cal_period_id;
907:
908: FEM_ENGINES_PKG.Tech_Message
909: (p_severity => fnd_log.level_statement,
910: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
911: 'snapshot_period_lock_exists.v_cal_per_end_date',
912: p_app_name => 'FEM',
913: p_msg_name => 'FEM_GL_POST_204',
914: p_token1 => 'VAR_NAME',

Line 965: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

961: -- This snapshot load is being run out of order.
962:
963: FEM_ENGINES_PKG.Tech_Message
964: (p_severity => fnd_log.level_exception,
965: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
966: 'snapshot_period_lock_exists.ssple',
967: p_app_name => 'FEM',
968: p_msg_name => 'FEM_GL_POST_015');
969:

Line 986: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

982: x_ss_per_lock_exists := 'F';
983:
984: FEM_ENGINES_PKG.Tech_Message
985: (p_severity => fnd_log.level_procedure,
986: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
987: 'snapshot_period_lock_exists.end',
988: p_msg_text => 'END');
989:
990: EXCEPTION

Line 1015: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||

1011: END IF;
1012:
1013: FEM_ENGINES_PKG.Tech_Message
1014: (p_severity => fnd_log.level_exception,
1015: p_module => 'fem.plsql.fem_pl_incr_pkg.' ||
1016: 'snapshot_period_lock_exists.invalid_cal_period_id',
1017: p_app_name => 'FEM',
1018: p_msg_name => 'FEM_GL_POST_003',
1019: p_token1 => 'DIMENSION_NAME1',

Line 1083: -- Called by FEM_PL_INCR_PKG.Exec_Lock_Exists.

1079: -- system, table and object when x_exec_state = 'RERUN'.
1080: -- x_num_msg Returns the number of end-user messages put onto
1081: -- the FND message stack by this procedure.
1082: -- Notes
1083: -- Called by FEM_PL_INCR_PKG.Exec_Lock_Exists.
1084: -- =========================================================================
1085:
1086: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1087: 'fem.plsql.fem_pl_incr_pkg.fact_obj_exec_lock_exists';

Line 1087: 'fem.plsql.fem_pl_incr_pkg.fact_obj_exec_lock_exists';

1083: -- Called by FEM_PL_INCR_PKG.Exec_Lock_Exists.
1084: -- =========================================================================
1085:
1086: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1087: 'fem.plsql.fem_pl_incr_pkg.fact_obj_exec_lock_exists';
1088:
1089: v_prev_event_order fem_pl_object_executions.event_order%TYPE;
1090: v_prev_exec_status_cd fem_pl_object_executions.exec_status_code%TYPE;
1091: v_prev_request_id fem_pl_object_executions.request_id%TYPE;

Line 1375: -- Called by FEM_PL_INCR_PKG.Exec_Lock_Exists.

1371: -- Also, the Fact Data Loader can only run in Error Reprocessing (E)
1372: -- or Replacement (R) mode once Snapshot mode was run once,
1373: -- regardless if that Snapshot run wrote any data to the table.
1374: -- Notes
1375: -- Called by FEM_PL_INCR_PKG.Exec_Lock_Exists.
1376: -- =========================================================================
1377:
1378: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1379: 'fem.plsql.fem_pl_incr_pkg.fact_exec_mode_lock_exists';

Line 1379: 'fem.plsql.fem_pl_incr_pkg.fact_exec_mode_lock_exists';

1375: -- Called by FEM_PL_INCR_PKG.Exec_Lock_Exists.
1376: -- =========================================================================
1377:
1378: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1379: 'fem.plsql.fem_pl_incr_pkg.fact_exec_mode_lock_exists';
1380:
1381: v_row_count NUMBER;
1382:
1383: BEGIN

Line 1531: END FEM_PL_INCR_PKG;

1527: END Fact_Exec_Mode_Lock_Exists;
1528: -- =========================================================================
1529:
1530:
1531: END FEM_PL_INCR_PKG;