[Home] [Help]
4616: SELECT group_id
4617: FROM csi_ctr_item_associations
4618: WHERE inventory_item_id = p_src_object_id;
4619: BEGIN
4620: -- Standard Start of API savepoint
4621: SAVEPOINT create_item_instance_pvt;
4622:
4623: -- Standard call to check for call compatibility.
4624: IF NOT FND_API.Compatible_API_Call (l_api_version,
4619: BEGIN
4620: -- Standard Start of API savepoint
4621: SAVEPOINT create_item_instance_pvt;
4622:
4623: -- Standard call to check for call compatibility.
4624: IF NOT FND_API.Compatible_API_Call (l_api_version,
4625: p_api_version,
4626: l_api_name ,
4627: G_PKG_NAME )
6507:
6508: END IF; -- Check for p_called_from_grp
6509: -- End of API body
6510:
6511: -- Standard check of p_commit.
6512: IF FND_API.To_Boolean( p_commit ) THEN
6513: COMMIT WORK;
6514: END IF;
6515:
6512: IF FND_API.To_Boolean( p_commit ) THEN
6513: COMMIT WORK;
6514: END IF;
6515:
6516: -- Standard call to get message count and IF count is get message info.
6517: FND_MSG_PUB.Count_And_Get
6518: (p_count => x_msg_count,
6519: p_data => x_msg_data
6520: );
6827: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
6828:
6829: BEGIN
6830:
6831: -- Standard Start of API savepoint
6832: IF fnd_api.to_boolean(p_commit)
6833: THEN
6834: SAVEPOINT get_and_update_acct_class;
6835: END IF;
6833: THEN
6834: SAVEPOINT get_and_update_acct_class;
6835: END IF;
6836:
6837: -- Standard call to check for call compatibility.
6838: IF NOT FND_API.Compatible_API_Call (l_api_version,
6839: p_api_version,
6840: l_api_name ,
6841: G_PKG_NAME )
6940: THEN
6941: COMMIT WORK;
6942: END IF;
6943:
6944: -- Standard call to get message count and IF count is get message info.
6945: FND_MSG_PUB.Count_And_Get
6946: (p_count => x_msg_count,
6947: p_data => x_msg_data
6948: );
7402: l_config_valid_status VARCHAR2(30) := fnd_api.g_miss_char;
7403:
7404: BEGIN
7405:
7406: -- Standard Start of API savepoint
7407: IF FND_API.To_Boolean( p_commit )
7408: THEN
7409: SAVEPOINT update_child_instance_pvt;
7410: END IF;
7409: SAVEPOINT update_child_instance_pvt;
7410: END IF;
7411:
7412:
7413: -- Standard call to check for call compatibility.
7414: IF NOT FND_API.Compatible_API_Call (l_api_version,
7415: p_api_version,
7416: l_api_name ,
7417: G_PKG_NAME )
10648: THEN
10649: COMMIT WORK;
10650: END IF;
10651:
10652: -- Standard call to get message count and if count is get message info.
10653: FND_MSG_PUB.Count_And_Get
10654: (p_count => x_msg_count ,
10655: p_data => x_msg_data
10656: );
11883: l_equipment_type NUMBER;
11884: l_network_asset_flag VARCHAR2(1);
11885: l_pn_location_id NUMBER;
11886: BEGIN
11887: -- Standard Start of API savepoint
11888: IF FND_API.To_Boolean( p_commit )
11889: THEN
11890: SAVEPOINT update_item_instance_pvt;
11891: END IF;
11889: THEN
11890: SAVEPOINT update_item_instance_pvt;
11891: END IF;
11892:
11893: -- Standard call to check for call compatibility.
11894: IF NOT FND_API.Compatible_API_Call (l_api_version,
11895: p_api_version,
11896: l_api_name ,
11897: G_PKG_NAME )
18763: END IF;
18764:
18765: -- End of API body
18766:
18767: -- Standard check of p_commit.
18768: IF FND_API.To_Boolean( p_commit ) THEN
18769: COMMIT WORK;
18770: END IF;
18771:
18768: IF FND_API.To_Boolean( p_commit ) THEN
18769: COMMIT WORK;
18770: END IF;
18771:
18772: -- Standard call to get message count and if count is get message info.
18773: FND_MSG_PUB.Count_And_Get
18774: (p_count => x_msg_count ,
18775: p_data => x_msg_data
18776: );
18994: l_instance_history_id NUMBER;
18995: l_valid BOOLEAN := TRUE;
18996: l_creation_flag VARCHAR2(1);
18997: BEGIN
18998: -- Standard Start of API savepoint
18999: SAVEPOINT expire_child_instance_pvt;
19000:
19001: -- Standard call to check for call compatibility.
19002: IF NOT FND_API.Compatible_API_Call (l_api_version,
18997: BEGIN
18998: -- Standard Start of API savepoint
18999: SAVEPOINT expire_child_instance_pvt;
19000:
19001: -- Standard call to check for call compatibility.
19002: IF NOT FND_API.Compatible_API_Call (l_api_version,
19003: p_api_version,
19004: l_api_name,
19005: G_PKG_NAME )
19882: END IF;
19883:
19884: END LOOP;
19885: END IF; -- l_rel_tbl count check
19886: -- Standard call to get message count and if count is get message info.
19887: FND_MSG_PUB.Count_And_Get
19888: (p_count => x_msg_count ,
19889: p_data => x_msg_data
19890: );
20111: l_creation_flag VARCHAR2(1);
20112:
20113: BEGIN
20114:
20115: -- Standard Start of API savepoint
20116: SAVEPOINT expire_item_instance_pvt;
20117:
20118: -- Standard call to check for call compatibility.
20119: IF NOT FND_API.Compatible_API_Call (l_api_version,
20114:
20115: -- Standard Start of API savepoint
20116: SAVEPOINT expire_item_instance_pvt;
20117:
20118: -- Standard call to check for call compatibility.
20119: IF NOT FND_API.Compatible_API_Call (l_api_version,
20120: p_api_version,
20121: l_api_name,
20122: G_PKG_NAME )
21370:
21371: --
21372: -- End of API body
21373:
21374: -- Standard check of p_commit.
21375: IF FND_API.To_Boolean( p_commit ) THEN
21376: COMMIT WORK;
21377: END IF;
21378:
21375: IF FND_API.To_Boolean( p_commit ) THEN
21376: COMMIT WORK;
21377: END IF;
21378:
21379: -- Standard call to get message count and if count is get message info.
21380: FND_MSG_PUB.Count_And_Get
21381: (p_count => x_msg_count ,
21382: p_data => x_msg_data
21383: );
21490:
21491: l_account_id NUMBER;
21492: l_dummy NUMBER;
21493: BEGIN
21494: -- Standard Start of API savepoint
21495: SAVEPOINT split_item_instance_pvt;
21496:
21497: -- Standard call to check for call compatibility.
21498: IF NOT FND_API.Compatible_API_Call (l_api_version,
21493: BEGIN
21494: -- Standard Start of API savepoint
21495: SAVEPOINT split_item_instance_pvt;
21496:
21497: -- Standard call to check for call compatibility.
21498: IF NOT FND_API.Compatible_API_Call (l_api_version,
21499: p_api_version,
21500: l_api_name,
21501: G_PKG_NAME )
21874: -- Modification ends
21875: -- End Calling Contracts.
21876: -- End of API body
21877:
21878: -- Standard check of p_commit.
21879: IF FND_API.To_Boolean( p_commit ) THEN
21880: COMMIT WORK;
21881: END IF;
21882:
21881: END IF;
21882:
21883: -- End disable trace
21884:
21885: -- Standard call to get message count and IF count is get message info.
21886: FND_MSG_PUB.Count_And_Get
21887: (p_count => x_msg_count ,
21888: p_data => x_msg_data
21889: );
21989: l_batch_id NUMBER;
21990: --
21991: BEGIN
21992:
21993: -- Standard Start of API savepoint
21994: SAVEPOINT split_item_instance_lines_pvt;
21995:
21996: -- Standard call to check for call compatibility.
21997: IF NOT FND_API.Compatible_API_Call (l_api_version,
21992:
21993: -- Standard Start of API savepoint
21994: SAVEPOINT split_item_instance_lines_pvt;
21995:
21996: -- Standard call to check for call compatibility.
21997: IF NOT FND_API.Compatible_API_Call (l_api_version,
21998: p_api_version,
21999: l_api_name,
22000: G_PKG_NAME )
22385: -- x_new_instance_tbl(i+1) := l_instance_id_lst(1);
22386:
22387: -- End of API body
22388:
22389: -- Standard check of p_commit.
22390: IF FND_API.To_Boolean( p_commit ) THEN
22391: COMMIT WORK;
22392: END IF;
22393:
22392: END IF;
22393:
22394: -- End disable trace
22395:
22396: -- Standard call to get message count and IF count is get message info.
22397: FND_MSG_PUB.Count_And_Get
22398: (p_count => x_msg_count ,
22399: p_data => x_msg_data
22400: );
23049: l_version_label_hist_id NUMBER ;
23050: l_flag VARCHAR2(1) :='N';
23051:
23052: BEGIN
23053: -- Standard Start of API savepoint
23054: SAVEPOINT create_version_label_pvt;
23055:
23056: -- Standard call to check for call compatibility.
23057: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23052: BEGIN
23053: -- Standard Start of API savepoint
23054: SAVEPOINT create_version_label_pvt;
23055:
23056: -- Standard call to check for call compatibility.
23057: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23058: p_api_version ,
23059: l_api_name ,
23060: G_PKG_NAME )
23291:
23292: --
23293: -- End of API body
23294:
23295: -- Standard check of p_commit.
23296:
23297: IF FND_API.To_Boolean( p_commit ) THEN
23298: COMMIT WORK;
23299: END IF;
23297: IF FND_API.To_Boolean( p_commit ) THEN
23298: COMMIT WORK;
23299: END IF;
23300:
23301: -- Standard call to get message count and if count is get message info.
23302: FND_MSG_PUB.Count_And_Get
23303: (p_count => x_msg_count ,
23304: p_data => x_msg_data );
23305:
23408: l_version_hist_csr version_hist_csr%ROWTYPE;
23409: l_version_hist_id NUMBER;
23410: BEGIN
23411:
23412: -- Standard Start of API savepoint
23413: SAVEPOINT update_version_label_pvt;
23414:
23415: -- Standard call to check for call compatibility.
23416: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23411:
23412: -- Standard Start of API savepoint
23413: SAVEPOINT update_version_label_pvt;
23414:
23415: -- Standard call to check for call compatibility.
23416: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23417: p_api_version ,
23418: l_api_name ,
23419: G_PKG_NAME )
24419: -- End of modification for Bug#2547034 on 09/20/02 - rtalluri
24420: --
24421: -- End of API body
24422:
24423: -- Standard check of p_commit.
24424: IF FND_API.To_Boolean( p_commit ) THEN
24425: COMMIT WORK;
24426: END IF;
24427:
24424: IF FND_API.To_Boolean( p_commit ) THEN
24425: COMMIT WORK;
24426: END IF;
24427:
24428: -- Standard call to get message count and if count is get message info.
24429: FND_MSG_PUB.Count_And_Get
24430: (p_count => x_msg_count ,
24431: p_data => x_msg_data );
24432:
24522: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
24523: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
24524:
24525: BEGIN
24526: -- Standard Start of API savepoint
24527: SAVEPOINT expire_version_label_pvt;
24528:
24529: -- Standard call to check for call compatibility.
24530: IF NOT FND_API.Compatible_API_Call (l_api_version ,
24525: BEGIN
24526: -- Standard Start of API savepoint
24527: SAVEPOINT expire_version_label_pvt;
24528:
24529: -- Standard call to check for call compatibility.
24530: IF NOT FND_API.Compatible_API_Call (l_api_version ,
24531: p_api_version ,
24532: l_api_name ,
24533: G_PKG_NAME )
24807: END IF;
24808: --
24809: -- End of API body
24810:
24811: -- Standard check of p_commit.
24812: IF FND_API.To_Boolean( p_commit ) THEN
24813: COMMIT WORK;
24814: END IF;
24815:
24812: IF FND_API.To_Boolean( p_commit ) THEN
24813: COMMIT WORK;
24814: END IF;
24815:
24816: -- Standard call to get message count and if count is get message info.
24817: FND_MSG_PUB.Count_And_Get
24818: (p_count => x_msg_count ,
24819: p_data => x_msg_data );
24820: EXCEPTION
25448: l_valid_flag VARCHAR2(1);
25449:
25450: BEGIN
25451:
25452: -- Standard Start of API savepoint
25453: SAVEPOINT create_extended_attrib_values;
25454:
25455: -- Standard call to check for call compatibility.
25456: IF NOT FND_API.Compatible_API_Call (l_api_version,
25451:
25452: -- Standard Start of API savepoint
25453: SAVEPOINT create_extended_attrib_values;
25454:
25455: -- Standard call to check for call compatibility.
25456: IF NOT FND_API.Compatible_API_Call (l_api_version,
25457: p_api_version,
25458: l_api_name ,
25459: g_pkg_name)
25931:
25932: END IF; -- Added by sk for bug 2232880
25933: -- End of API body
25934:
25935: -- Standard check of p_commit.
25936: IF FND_API.To_Boolean( p_commit ) THEN
25937: COMMIT WORK;
25938: END IF;
25939:
25936: IF FND_API.To_Boolean( p_commit ) THEN
25937: COMMIT WORK;
25938: END IF;
25939:
25940: -- Standard call to get message count and if count is get message info.
25941: FND_MSG_PUB.Count_And_Get
25942: (p_count => x_msg_count ,
25943: p_data => x_msg_data
25944: );
26028: l_ieav_hist_id NUMBER;
26029: l_ieav_hist_csr ieav_hist_csr%ROWTYPE;
26030:
26031: BEGIN
26032: -- Standard Start of API savepoint
26033: SAVEPOINT update_extended_attrib_values;
26034:
26035: -- Standard call to check for call compatibility.
26036: IF NOT FND_API.Compatible_API_Call (l_api_version,
26031: BEGIN
26032: -- Standard Start of API savepoint
26033: SAVEPOINT update_extended_attrib_values;
26034:
26035: -- Standard call to check for call compatibility.
26036: IF NOT FND_API.Compatible_API_Call (l_api_version,
26037: p_api_version,
26038: l_api_name ,
26039: g_pkg_name)
27023: END;
27024: -- End of modifications for Bug#2547034 on 09/20/02 - rtalluri
27025: -- End of API body
27026:
27027: -- Standard check of p_commit.
27028: IF FND_API.To_Boolean( p_commit ) THEN
27029: COMMIT WORK;
27030: END IF;
27031:
27028: IF FND_API.To_Boolean( p_commit ) THEN
27029: COMMIT WORK;
27030: END IF;
27031:
27032: -- Standard call to get message count and if count is get message info.
27033: FND_MSG_PUB.Count_And_Get
27034: (p_count => x_msg_count ,
27035: p_data => x_msg_data
27036: );
27104: l_msg_count NUMBER;
27105: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
27106: BEGIN
27107:
27108: -- Standard Start of API savepoint
27109: SAVEPOINT expire_extended_attrib_values;
27110:
27111: -- Standard call to check for call compatibility.
27112: IF NOT FND_API.Compatible_API_Call (l_api_version,
27107:
27108: -- Standard Start of API savepoint
27109: SAVEPOINT expire_extended_attrib_values;
27110:
27111: -- Standard call to check for call compatibility.
27112: IF NOT FND_API.Compatible_API_Call (l_api_version,
27113: p_api_version,
27114: l_api_name ,
27115: g_pkg_name)
27216:
27217:
27218: -- End of API body
27219:
27220: -- Standard check of p_commit.
27221: IF FND_API.To_Boolean( p_commit ) THEN
27222: COMMIT WORK;
27223: END IF;
27224:
27221: IF FND_API.To_Boolean( p_commit ) THEN
27222: COMMIT WORK;
27223: END IF;
27224:
27225: -- Standard call to get message count and if count is get message info.
27226: FND_MSG_PUB.Count_And_Get
27227: (p_count => x_msg_count ,
27228: p_data => x_msg_data
27229: );
27356: l_batch_type VARCHAR2(50);
27357: l_batch_id NUMBER;
27358: --
27359: BEGIN
27360: -- Standard Start of API savepoint
27361: SAVEPOINT copy_single_item_instance;
27362: -- Standard call to check for call compatibility.
27363: IF NOT FND_API.Compatible_API_Call (l_api_version,
27364: p_api_version,
27358: --
27359: BEGIN
27360: -- Standard Start of API savepoint
27361: SAVEPOINT copy_single_item_instance;
27362: -- Standard call to check for call compatibility.
27363: IF NOT FND_API.Compatible_API_Call (l_api_version,
27364: p_api_version,
27365: l_api_name ,
27366: G_PKG_NAME)
29139: END IF;
29140: -- End Addition by sk for fixing the bug 2234365
29141: END IF;
29142: -- End of API body
29143: -- Standard check of p_commit
29144: IF FND_API.To_Boolean( p_commit ) THEN
29145: COMMIT WORK;
29146: END IF;
29147: -- Standard call to get message count and if count is get message info.
29143: -- Standard check of p_commit
29144: IF FND_API.To_Boolean( p_commit ) THEN
29145: COMMIT WORK;
29146: END IF;
29147: -- Standard call to get message count and if count is get message info.
29148: FND_MSG_PUB.Count_And_Get
29149: (p_count => x_msg_count ,
29150: p_data => x_msg_data
29151: );
29269: AND bom.organization_id = msip.organization_id
29270: AND msi.organization_id = mp.organization_id
29271: ORDER BY bet.sort_order;
29272: BEGIN
29273: -- Standard Start of API savepoint
29274: SAVEPOINT explode_bom;
29275: -- Standard call to check for call compatibility.
29276: IF NOT FND_API.Compatible_API_Call (l_api_version,
29277: p_api_version,
29271: ORDER BY bet.sort_order;
29272: BEGIN
29273: -- Standard Start of API savepoint
29274: SAVEPOINT explode_bom;
29275: -- Standard call to check for call compatibility.
29276: IF NOT FND_API.Compatible_API_Call (l_api_version,
29277: p_api_version,
29278: l_api_name ,
29279: G_PKG_NAME)
29293: csi_gen_utility_pvt.put_line( 'explode_bom');
29294: END IF;
29295: -- If the debug level = 2 then dump all the parameters values.
29296: IF (l_debug_level > 1) THEN
29297: csi_gen_utility_pvt.put_line('explode_standard_bom'||'-'
29298: || p_api_version ||'-'
29299: || p_commit ||'-'
29300: || p_init_msg_list ||'-'
29301: || p_validation_level ||'-'
29723: -- Delete records from bom_small_exp_temp
29724: DELETE FROM bom_small_expl_temp where group_id = l_group_id;
29725: --
29726: -- End of API body
29727: -- Standard check of p_commit
29728: IF FND_API.To_Boolean( p_commit ) THEN
29729: COMMIT WORK;
29730: END IF;
29731: -- Standard call to get message count and if count is get message info.
29727: -- Standard check of p_commit
29728: IF FND_API.To_Boolean( p_commit ) THEN
29729: COMMIT WORK;
29730: END IF;
29731: -- Standard call to get message count and if count is get message info.
29732: FND_MSG_PUB.Count_And_Get
29733: ( p_count => x_msg_count ,
29734: p_data => x_msg_data
29735: );
29813: SAVEPOINT get_instance_hist;
29814: END IF;
29815: */
29816:
29817: -- Standard call to check for call compatibility.
29818: IF NOT FND_API.Compatible_API_Call (l_api_version ,
29819: p_api_version ,
29820: l_api_name ,
29821: G_PKG_NAME )
31633: END LOOP;
31634:
31635: -- End of API body
31636:
31637: -- Standard check of p_commit.
31638: /*
31639: IF FND_API.To_Boolean( p_commit ) THEN
31640: COMMIT WORK;
31641: END IF;
31648: END IF;
31649: -- End disable trace
31650: ****/
31651:
31652: -- Standard call to get message count and if count is get message info.
31653: FND_MSG_PUB.Count_And_Get
31654: (p_count => x_msg_count ,
31655: p_data => x_msg_data );
31656: EXCEPTION
31759: SAVEPOINT get_ext_attrib_val_hist;
31760: END IF;
31761: */
31762:
31763: -- Standard call to check for call compatibility.
31764: IF NOT FND_API.Compatible_API_Call (l_api_version ,
31765: p_api_version ,
31766: l_api_name ,
31767: G_PKG_NAME )
32016: END LOOP;
32017:
32018: -- End of API body
32019:
32020: -- Standard check of p_commit.
32021: /*
32022: IF FND_API.To_Boolean( p_commit ) THEN
32023: COMMIT WORK;
32024: END IF;
32031: END IF;
32032: -- End disable trace
32033: ****/
32034:
32035: -- Standard call to get message count and if count is get message info.
32036: FND_MSG_PUB.Count_And_Get
32037: (p_count => x_msg_count ,
32038: p_data => x_msg_data );
32039: EXCEPTION
32172: l_owner_party_id NUMBER;
32173: -- End Add Code for Siebel Genesis Project
32174: BEGIN
32175:
32176: -- Standard Start of API savepoint
32177: SAVEPOINT copy_item_instance;
32178:
32179: -- Standard call to check for call compatibility.
32180: IF NOT FND_API.Compatible_API_Call (l_api_version,
32175:
32176: -- Standard Start of API savepoint
32177: SAVEPOINT copy_item_instance;
32178:
32179: -- Standard call to check for call compatibility.
32180: IF NOT FND_API.Compatible_API_Call (l_api_version,
32181: p_api_version,
32182: l_api_name ,
32183: G_PKG_NAME)
34108: l_link_to_line_id := null;
34109: l_item_type_code := null;
34110: END;
34111:
34112: IF l_link_to_line_id is null and l_item_type_code = 'STANDARD' THEN
34113: CSI_BUSINESS_EVENT_PVT.CREATE_INSTANCE_EVENT
34114: (p_api_version => p_api_version
34115: ,p_commit => fnd_api.g_false
34116: ,p_init_msg_list => p_init_msg_list
34144: -- End Add Code for Siebel Genesis Project
34145:
34146: -- End of API body
34147:
34148: -- Standard check of p_commit
34149: IF FND_API.To_Boolean( p_commit ) THEN
34150: COMMIT WORK;
34151: END IF;
34152:
34150: COMMIT WORK;
34151: END IF;
34152:
34153:
34154: -- Standard call to get message count and if count is get message info.
34155: FND_MSG_PUB.Count_And_Get
34156: (p_count => x_msg_count ,
34157: p_data => x_msg_data
34158: );
34277: AND vlh.version_label_id = vl.version_label_id;
34278:
34279:
34280: BEGIN
34281: -- Standard Start of API savepoint
34282: -- SAVEPOINT get_version_label_history;
34283:
34284:
34285: -- Standard call to check for call compatibility.
34281: -- Standard Start of API savepoint
34282: -- SAVEPOINT get_version_label_history;
34283:
34284:
34285: -- Standard call to check for call compatibility.
34286: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
34287: p_api_version ,
34288: l_api_name ,
34289: g_pkg_name )
34386: END LOOP;
34387:
34388: -- End of API body
34389:
34390: -- Standard check of p_commit.
34391: /*
34392: IF FND_API.To_Boolean( p_commit ) THEN
34393: COMMIT WORK;
34394: END IF;
34401: END IF;
34402: -- End disable trace
34403: ****/
34404:
34405: -- Standard call to get message count and if count is get message info.
34406: FND_MSG_PUB.Count_And_Get
34407: (p_count => x_msg_count ,
34408: p_data => x_msg_data );
34409: EXCEPTION
34458: l_flag VARCHAR2(1) := 'N';
34459: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
34460:
34461: BEGIN
34462: -- Standard Start of API savepoint
34463: -- SAVEPOINT get_instance_link_locations;
34464:
34465: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
34466: csi_utility_grp.check_ib_active;
34464:
34465: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
34466: csi_utility_grp.check_ib_active;
34467:
34468: -- Standard call to check for call compatibility.
34469: IF NOT FND_API.Compatible_API_Call (l_api_version,
34470: p_api_version,
34471: l_api_name,
34472: G_PKG_NAME )
34558: x_instance_link_rec.end_loc_postal_code := l_instance_header_tbl(1).end_loc_postal_code;
34559: x_instance_link_rec.end_loc_country := l_instance_header_tbl(1).end_loc_country;
34560:
34561: -- End of API body
34562: -- Standard check of p_commit.
34563: /*
34564: IF FND_API.To_Boolean( p_commit ) THEN
34565: COMMIT WORK;
34566: END IF;
34572: END IF;
34573: -- End disable trace
34574: ****/
34575:
34576: -- Standard call to get message count and if count is get message info.
34577: FND_MSG_PUB.Count_And_Get
34578: (p_count => x_msg_count ,
34579: p_data => x_msg_data
34580: );
34824: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
34825:
34826: csi_utility_grp.check_ib_active;
34827:
34828: -- Standard call to check for call compatibility.
34829: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
34830: p_api_version ,
34831: l_api_name ,
34832: g_pkg_name )
35321: IF FND_API.To_Boolean( p_commit ) THEN
35322: COMMIT WORK;
35323: END IF;
35324:
35325: -- Standard call to get message count and if count is get message info.
35326: FND_MSG_PUB.Count_And_Get
35327: (p_count => x_msg_count ,
35328: p_data => x_msg_data );
35329:
35599: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
35600:
35601: csi_utility_grp.check_ib_active;
35602:
35603: -- Standard call to check for call compatibility.
35604: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
35605: p_api_version ,
35606: l_api_name ,
35607: g_pkg_name )
36050: IF FND_API.To_Boolean( p_commit ) THEN
36051: COMMIT WORK;
36052: END IF;
36053:
36054: -- Standard call to get message count and if count is get message info.
36055: FND_MSG_PUB.Count_And_Get
36056: (p_count => x_msg_count ,
36057: p_data => x_msg_data );
36058: