DBA Data[Home] [Help]

APPS.JTS_CONFIG_VER_STATUS_PVT dependencies on FND_API

Line 21: IF NOT fnd_api.compatible_api_call ( l_api_version,

17: l_api_version CONSTANT NUMBER := 1.0;
18: l_api_name CONSTANT VARCHAR2 (30) := 'IN_REPLAY_STATUS';
19: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
20: BEGIN
21: IF NOT fnd_api.compatible_api_call ( l_api_version,
22: p_api_version,
23: l_api_name,
24: G_PKG_NAME
25: )

Line 27: RAISE fnd_api.g_exc_unexpected_error;

23: l_api_name,
24: G_PKG_NAME
25: )
26: THEN
27: RAISE fnd_api.g_exc_unexpected_error;
28: END IF;
29:
30: -- Replay Status column, could change depending on the business logic
31: IF ( p_status IN (C_SUBMIT_REPLAY_STATUS, C_FAIL_REPLAY_STATUS, C_CANCEL_REPLAY_STATUS,

Line 50: IF NOT fnd_api.compatible_api_call ( l_api_version,

46: l_api_version CONSTANT NUMBER := 1.0;
47: l_api_name CONSTANT VARCHAR2 (30) := 'IN_VERSION_STATUS';
48: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
49: BEGIN
50: IF NOT fnd_api.compatible_api_call ( l_api_version,
51: p_api_version,
52: l_api_name,
53: G_PKG_NAME
54: )

Line 56: RAISE fnd_api.g_exc_unexpected_error;

52: l_api_name,
53: G_PKG_NAME
54: )
55: THEN
56: RAISE fnd_api.g_exc_unexpected_error;
57: END IF;
58:
59: -- Version Status column, could change depending on the business logic
60: IF (p_status IN (C_INIT_VERSION_STATUS, C_PROCESS_VERSION_STATUS, C_COMPLETE_VERSION_STATUS)) THEN

Line 80: IF NOT fnd_api.compatible_api_call ( l_api_version,

76: l_api_version CONSTANT NUMBER := 1.0;
77: l_api_name CONSTANT VARCHAR2 (30) := 'NOT_REPLAYED';
78: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
79: BEGIN
80: IF NOT fnd_api.compatible_api_call ( l_api_version,
81: p_api_version,
82: l_api_name,
83: G_PKG_NAME
84: )

Line 86: RAISE fnd_api.g_exc_unexpected_error;

82: l_api_name,
83: G_PKG_NAME
84: )
85: THEN
86: RAISE fnd_api.g_exc_unexpected_error;
87: END IF;
88:
89: -- Replay has been cancelled or Replay was never submitted, could change depending on the business logic
90: IF (p_status = C_NOSUBMIT_REPLAY_STATUS OR p_status = C_CANCEL_REPLAY_STATUS) THEN

Line 118: IF NOT fnd_api.compatible_api_call ( l_api_version,

114: l_replayed_by_name FND_USER.user_name%TYPE;
115: l_not_replayed BOOLEAN := TRUE;
116: l_in_replay BOOLEAN := FALSE;
117: BEGIN
118: IF NOT fnd_api.compatible_api_call ( l_api_version,
119: p_api_version,
120: l_api_name,
121: G_PKG_NAME
122: )

Line 124: RAISE fnd_api.g_exc_unexpected_error;

120: l_api_name,
121: G_PKG_NAME
122: )
123: THEN
124: RAISE fnd_api.g_exc_unexpected_error;
125: END IF;
126:
127: JTS_CONFIG_UTIL_PVT.GET_VERSIONS_CURSOR(p_api_version,
128: p_config_id,

Line 191: IF NOT fnd_api.compatible_api_call ( l_api_version,

187: AND u.user_id (+) = vs.created_by
188: ORDER BY vs.creation_date DESC;
189:
190: BEGIN
191: IF NOT fnd_api.compatible_api_call ( l_api_version,
192: p_api_version,
193: l_api_name,
194: G_PKG_NAME
195: )

Line 197: RAISE fnd_api.g_exc_unexpected_error;

193: l_api_name,
194: G_PKG_NAME
195: )
196: THEN
197: RAISE fnd_api.g_exc_unexpected_error;
198: END IF;
199:
200: x_replay_status_code := NULL;
201: x_replay_status := NULL;

Line 248: IF NOT fnd_api.compatible_api_call ( l_api_version,

244: l_api_version CONSTANT NUMBER := 1.0;
245: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_VERSION_STATUS';
246: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
247: BEGIN
248: IF NOT fnd_api.compatible_api_call ( l_api_version,
249: p_api_version,
250: l_api_name,
251: G_PKG_NAME
252: )

Line 254: RAISE fnd_api.g_exc_unexpected_error;

250: l_api_name,
251: G_PKG_NAME
252: )
253: THEN
254: RAISE fnd_api.g_exc_unexpected_error;
255: END IF;
256:
257: INSERT INTO jts_config_version_statuses
258: (

Line 288: IF (FND_API.to_boolean(p_commit)) THEN

284: p_version_id,
285: p_status);
286: END IF;
287:
288: IF (FND_API.to_boolean(p_commit)) THEN
289: COMMIT;
290: END IF;
291:
292: EXCEPTION

Line 304: IF NOT fnd_api.compatible_api_call ( l_api_version,

300: l_api_version CONSTANT NUMBER := 1.0;
301: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_VERSION_STATUSES';
302: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
303: BEGIN
304: IF NOT fnd_api.compatible_api_call ( l_api_version,
305: p_api_version,
306: l_api_name,
307: G_PKG_NAME
308: )

Line 310: RAISE fnd_api.g_exc_unexpected_error;

306: l_api_name,
307: G_PKG_NAME
308: )
309: THEN
310: RAISE fnd_api.g_exc_unexpected_error;
311: END IF;
312:
313: DELETE FROM jts_config_version_statuses
314: WHERE version_id = p_version_id;

Line 331: IF NOT fnd_api.compatible_api_call ( l_api_version,

327: l_full_name CONSTANT VARCHAR2 (60) := G_PKG_NAME || '.' || l_api_name;
328: versions_csr JTS_CONFIG_UTIL_PVT.Versions_Csr_Type;
329: l_version_id JTS_CONFIG_VERSION_STATUSES.version_id%TYPE;
330: BEGIN
331: IF NOT fnd_api.compatible_api_call ( l_api_version,
332: p_api_version,
333: l_api_name,
334: G_PKG_NAME
335: )

Line 337: RAISE fnd_api.g_exc_unexpected_error;

333: l_api_name,
334: G_PKG_NAME
335: )
336: THEN
337: RAISE fnd_api.g_exc_unexpected_error;
338: END IF;
339:
340: JTS_CONFIG_UTIL_PVT.GET_VERSIONS_CURSOR(p_api_version,
341: p_config_id,