DBA Data[Home] [Help]

APPS.GCS_CONS_ENG_RUNS_PKG dependencies on FND_LOG

Line 21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

17:
18: IS PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: BEGIN
21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');
23: END IF;
24:
25: INSERT INTO gcs_cons_eng_runs

Line 22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');

18: IS PRAGMA AUTONOMOUS_TRANSACTION;
19:
20: BEGIN
21: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
22: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');
23: END IF;
24:
25: INSERT INTO gcs_cons_eng_runs
26: (

Line 75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

71: sysdate,
72: p_request_id
73: );
74:
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');
77: END IF;
78:
79: COMMIT;

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');

72: p_request_id
73: );
74:
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');
77: END IF;
78:
79: COMMIT;
80:

Line 92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

88:
89: IS PRAGMA AUTONOMOUS_TRANSACTION;
90:
91: BEGIN
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');
94: END IF;
95:
96: UPDATE gcs_cons_eng_runs

Line 93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');

89: IS PRAGMA AUTONOMOUS_TRANSACTION;
90:
91: BEGIN
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');
94: END IF;
95:
96: UPDATE gcs_cons_eng_runs
97: SET most_recent_flag = p_most_recent_flag,

Line 105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

101: last_updated_by = FND_GLOBAL.USER_ID
102: WHERE run_name = p_run_name
103: AND run_entity_id = p_run_entity_id;
104:
105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');
107: END IF;
108:
109:

Line 106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');

102: WHERE run_name = p_run_name
103: AND run_entity_id = p_run_entity_id;
104:
105: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
106: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_STATUS', '<>');
107: END IF;
108:
109:
110: COMMIT;