[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_relationships_pub;
42:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
43: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
44:
45: csi_utility_grp.check_ib_active;
46:
47: -- standard call TO check for call compatibility.
48: IF NOT fnd_api.compatible_api_call ( l_api_version,
49: p_api_version,
50: l_api_name,
51: g_pkg_name)
129: dbms_session.set_sql_trace(FALSE);
130: END IF;
131: ****/
132:
133: -- standard call TO get message count AND IF count is 1, get message info.
134: fnd_msg_pub.count_and_get
135: ( p_count => x_msg_count,
136: p_data => x_msg_data
137: );
200: l_relationship_exists VARCHAR2(1);
201: l_root_asset_id NUMBER;
202: -- End Add Code for Siebel Genesis Project
203: BEGIN
204: -- standard start of api savepoint
205: SAVEPOINT create_relationship_pub;
206:
207: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
208:
207: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
208:
209: csi_utility_grp.check_ib_active;
210:
211: -- standard call TO check for call compatibility.
212: IF NOT fnd_api.compatible_api_call ( l_api_version,
213: p_api_version,
214: l_api_name,
215: g_pkg_name)
469: --
470: -- END of api body.
471: --
472:
473: -- standard check for p_commit
474: IF fnd_api.to_boolean( p_commit )
475: THEN
476: COMMIT WORK;
477: END IF;
480: IF (l_flag = 'Y') THEN
481: dbms_session.set_sql_trace(FALSE);
482: END IF;
483: ****/
484: -- standard call TO get message count AND IF count is 1, get message info.
485: fnd_msg_pub.count_and_get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data
488: );
544: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
545: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl:=p_relationship_tbl;
546: l_replace_flag VARCHAR2(1);
547: BEGIN
548: -- standard start of api savepoint
549: SAVEPOINT update_relationship_pub;
550:
551: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
552:
551: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
552:
553: csi_utility_grp.check_ib_active;
554:
555: -- standard call TO check for call compatibility.
556: IF NOT fnd_api.compatible_api_call ( l_api_version,
557: p_api_version,
558: l_api_name,
559: g_pkg_name)
748: l_msg_count := l_msg_count - 1;
749: END LOOP;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: -- standard check for p_commit
753: IF fnd_api.to_boolean( p_commit )
754: THEN
755: COMMIT WORK;
756: END IF;
759: IF (l_flag = 'Y') THEN
760: dbms_session.set_sql_trace(FALSE);
761: END IF;
762: ****/
763: -- standard call TO get message count AND IF count is 1, get message info.
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count,
766: p_data => x_msg_data
767: );
818: l_debug_level NUMBER;
819:
820:
821: BEGIN
822: -- standard start of api savepoint
823: SAVEPOINT expire_relationship_pub;
824:
825: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
826:
825: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
826:
827: csi_utility_grp.check_ib_active;
828:
829: -- standard call TO check for call compatibility.
830: IF NOT fnd_api.compatible_api_call ( l_api_version,
831: p_api_version,
832: l_api_name,
833: g_pkg_name)
900: END IF;
901:
902:
903:
904: -- standard check for p_commit
905: IF fnd_api.to_boolean( p_commit )
906: THEN
907: COMMIT WORK;
908: END IF;
911: IF (l_flag = 'Y') THEN
912: dbms_session.set_sql_trace(FALSE);
913: END IF;
914: *****/
915: -- standard call TO get message count AND IF count is 1, get message info.
916: fnd_msg_pub.count_and_get
917: ( p_count => x_msg_count,
918: p_data => x_msg_data
919: );