[Home] [Help]
36: l_flag VARCHAR2(1) :='N';
37: l_debug_level NUMBER;
38:
39: BEGIN
40: -- standard start of api savepoint
41: --SAVEPOINT get_systems_pub;
42:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
44:
45: csi_utility_grp.check_ib_active;
46:
47:
48: -- standard call to check for call compatibility.
49: IF NOT fnd_api.compatible_api_call ( l_api_version,
50: p_api_version,
51: l_api_name,
52: g_pkg_name)
128: dbms_session.set_sql_trace(false);
129: END IF;
130: ****/
131:
132: -- standard call to get message count and if count is 1, get message info.
133: fnd_msg_pub.count_and_get
134: ( p_count => x_msg_count,
135: p_data => x_msg_data
136: );
188: l_debug_level NUMBER;
189:
190:
191: BEGIN
192: -- standard start of api savepoint
193: SAVEPOINT create_system_pub;
194:
195: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
196:
196:
197: csi_utility_grp.check_ib_active;
198:
199:
200: -- standard call to check for call compatibility.
201: IF NOT fnd_api.compatible_api_call ( l_api_version,
202: p_api_version,
203: l_api_name,
204: g_pkg_name)
275: --
276: -- end of api body.
277: --
278:
279: -- standard check for p_commit
280: IF fnd_api.to_boolean( p_commit )
281: THEN
282: COMMIT WORK;
283: END IF;
287: dbms_session.set_sql_trace(false);
288: END IF;
289: ****/
290:
291: -- standard call to get message count and if count is 1, get message info.
292: fnd_msg_pub.count_and_get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
345: l_debug_level NUMBER;
346:
347:
348: BEGIN
349: -- standard start of api savepoint
350: SAVEPOINT update_system_pub;
351:
352: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
353:
353:
354: csi_utility_grp.check_ib_active;
355:
356:
357: -- standard call to check for call compatibility.
358: IF NOT fnd_api.compatible_api_call ( l_api_version,
359: p_api_version,
360: l_api_name,
361: g_pkg_name)
427: --
428: -- end of api body
429: --
430:
431: -- standard check for p_commit
432: IF fnd_api.to_boolean( p_commit )
433: THEN
434: COMMIT WORK;
435: END IF;
439: dbms_session.set_sql_trace(false);
440: END IF;
441: ****/
442:
443: -- standard call to get message count and if count is 1, get message info.
444: fnd_msg_pub.count_and_get
445: ( p_count => x_msg_count,
446: p_data => x_msg_data
447: );
497: l_debug_level NUMBER;
498:
499:
500: BEGIN
501: -- standard start of api savepoint
502: SAVEPOINT expire_system_pub;
503:
504: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
505:
505:
506: csi_utility_grp.check_ib_active;
507:
508:
509: -- standard call to check for call compatibility.
510: IF NOT fnd_api.compatible_api_call ( l_api_version,
511: p_api_version,
512: l_api_name,
513: g_pkg_name)
582: --
583: -- end of api body
584: --
585:
586: -- standard check for p_commit
587: IF fnd_api.to_boolean( p_commit )
588: THEN
589: COMMIT WORK;
590: END IF;
594: dbms_session.set_sql_trace(false);
595: END IF;
596: ****/
597:
598: -- standard call to get message count and if count is 1, get message info.
599: fnd_msg_pub.count_and_get
600: ( p_count => x_msg_count,
601: p_data => x_msg_data
602: );