[Home] [Help]
4647: COUNTER_ID --Added for bug 9142776
4648: FROM csi_ctr_item_associations
4649: WHERE inventory_item_id = p_src_object_id;
4650: BEGIN
4651: -- Standard Start of API savepoint
4652: SAVEPOINT create_item_instance_pvt;
4653:
4654: -- Standard call to check for call compatibility.
4655: IF NOT FND_API.Compatible_API_Call (l_api_version,
4650: BEGIN
4651: -- Standard Start of API savepoint
4652: SAVEPOINT create_item_instance_pvt;
4653:
4654: -- Standard call to check for call compatibility.
4655: IF NOT FND_API.Compatible_API_Call (l_api_version,
4656: p_api_version,
4657: l_api_name ,
4658: G_PKG_NAME )
6580:
6581: END IF; -- Check for p_called_from_grp
6582: -- End of API body
6583:
6584: -- Standard check of p_commit.
6585: IF FND_API.To_Boolean( p_commit ) THEN
6586: COMMIT WORK;
6587: END IF;
6588:
6585: IF FND_API.To_Boolean( p_commit ) THEN
6586: COMMIT WORK;
6587: END IF;
6588:
6589: -- Standard call to get message count and IF count is get message info.
6590: FND_MSG_PUB.Count_And_Get
6591: (p_encoded => FND_API.G_FALSE, --Added for bug 7657438
6592: p_count => x_msg_count,
6593: p_data => x_msg_data
6904: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
6905:
6906: BEGIN
6907:
6908: -- Standard Start of API savepoint
6909: IF fnd_api.to_boolean(p_commit)
6910: THEN
6911: SAVEPOINT get_and_update_acct_class;
6912: END IF;
6910: THEN
6911: SAVEPOINT get_and_update_acct_class;
6912: END IF;
6913:
6914: -- Standard call to check for call compatibility.
6915: IF NOT FND_API.Compatible_API_Call (l_api_version,
6916: p_api_version,
6917: l_api_name ,
6918: G_PKG_NAME )
7017: THEN
7018: COMMIT WORK;
7019: END IF;
7020:
7021: -- Standard call to get message count and IF count is get message info.
7022: FND_MSG_PUB.Count_And_Get
7023: (p_encoded => FND_API.G_FALSE,
7024: p_count => x_msg_count,
7025: p_data => x_msg_data
7488: l_root_asset_id NUMBER;
7489: l_exists VARCHAR2(1);
7490: BEGIN
7491:
7492: -- Standard Start of API savepoint
7493: IF FND_API.To_Boolean( p_commit )
7494: THEN
7495: SAVEPOINT update_child_instance_pvt;
7496: END IF;
7495: SAVEPOINT update_child_instance_pvt;
7496: END IF;
7497:
7498:
7499: -- Standard call to check for call compatibility.
7500: IF NOT FND_API.Compatible_API_Call (l_api_version,
7501: p_api_version,
7502: l_api_name ,
7503: G_PKG_NAME )
10895: THEN
10896: COMMIT WORK;
10897: END IF;
10898:
10899: -- Standard call to get message count and if count is get message info.
10900: FND_MSG_PUB.Count_And_Get
10901: (p_encoded => FND_API.G_FALSE,
10902: p_count => x_msg_count ,
10903: p_data => x_msg_data
12201:
12202: l_wip_loc_chgd BOOLEAN := FALSE; --bug9553621
12203:
12204: BEGIN
12205: -- Standard Start of API savepoint
12206: IF FND_API.To_Boolean( p_commit )
12207: THEN
12208: SAVEPOINT update_item_instance_pvt;
12209: END IF;
12207: THEN
12208: SAVEPOINT update_item_instance_pvt;
12209: END IF;
12210:
12211: -- Standard call to check for call compatibility.
12212: IF NOT FND_API.Compatible_API_Call (l_api_version,
12213: p_api_version,
12214: l_api_name ,
12215: G_PKG_NAME )
19256: END IF;
19257:
19258: -- End of API body
19259:
19260: -- Standard check of p_commit.
19261: IF FND_API.To_Boolean( p_commit ) THEN
19262: COMMIT WORK;
19263: END IF;
19264:
19261: IF FND_API.To_Boolean( p_commit ) THEN
19262: COMMIT WORK;
19263: END IF;
19264:
19265: -- Standard call to get message count and if count is get message info.
19266: FND_MSG_PUB.Count_And_Get
19267: (p_encoded => FND_API.G_FALSE,
19268: p_count => x_msg_count ,
19269: p_data => x_msg_data
19491: l_instance_history_id NUMBER;
19492: l_valid BOOLEAN := TRUE;
19493: l_creation_flag VARCHAR2(1);
19494: BEGIN
19495: -- Standard Start of API savepoint
19496: SAVEPOINT expire_child_instance_pvt;
19497:
19498: -- Standard call to check for call compatibility.
19499: IF NOT FND_API.Compatible_API_Call (l_api_version,
19494: BEGIN
19495: -- Standard Start of API savepoint
19496: SAVEPOINT expire_child_instance_pvt;
19497:
19498: -- Standard call to check for call compatibility.
19499: IF NOT FND_API.Compatible_API_Call (l_api_version,
19500: p_api_version,
19501: l_api_name,
19502: G_PKG_NAME )
20379: END IF;
20380:
20381: END LOOP;
20382: END IF; -- l_rel_tbl count check
20383: -- Standard call to get message count and if count is get message info.
20384: FND_MSG_PUB.Count_And_Get
20385: (p_encoded => FND_API.G_FALSE,
20386: p_count => x_msg_count ,
20387: p_data => x_msg_data
20615: l_parent_found VARCHAR2(1); -- Added for bug#14559620
20616:
20617: BEGIN
20618:
20619: -- Standard Start of API savepoint
20620: SAVEPOINT expire_item_instance_pvt;
20621:
20622: -- Standard call to check for call compatibility.
20623: IF NOT FND_API.Compatible_API_Call (l_api_version,
20618:
20619: -- Standard Start of API savepoint
20620: SAVEPOINT expire_item_instance_pvt;
20621:
20622: -- Standard call to check for call compatibility.
20623: IF NOT FND_API.Compatible_API_Call (l_api_version,
20624: p_api_version,
20625: l_api_name,
20626: G_PKG_NAME )
20709: IF l_txn_date IS NOT NULL
20710: THEN
20711:
20712: -- Added for bug#14559620
20713: -- Standard Concurrent Job: End-dated Instances Process expiring child instances before parent
20714: -- by leaving future transactions in csi_inst_transactions_v, which was causing an
20715: -- error, added below code to over come this situation
20716: l_parent_found := 'Y';
20717: IF p_txn_rec.transaction_type_id = 5 THEN
21907:
21908: --
21909: -- End of API body
21910:
21911: -- Standard check of p_commit.
21912: IF FND_API.To_Boolean( p_commit ) THEN
21913: COMMIT WORK;
21914: END IF;
21915:
21912: IF FND_API.To_Boolean( p_commit ) THEN
21913: COMMIT WORK;
21914: END IF;
21915:
21916: -- Standard call to get message count and if count is get message info.
21917: FND_MSG_PUB.Count_And_Get
21918: (p_encoded => FND_API.G_FALSE,
21919: p_count => x_msg_count ,
21920: p_data => x_msg_data
22031:
22032: l_account_id NUMBER;
22033: l_dummy NUMBER;
22034: BEGIN
22035: -- Standard Start of API savepoint
22036: SAVEPOINT split_item_instance_pvt;
22037:
22038: -- Standard call to check for call compatibility.
22039: IF NOT FND_API.Compatible_API_Call (l_api_version,
22034: BEGIN
22035: -- Standard Start of API savepoint
22036: SAVEPOINT split_item_instance_pvt;
22037:
22038: -- Standard call to check for call compatibility.
22039: IF NOT FND_API.Compatible_API_Call (l_api_version,
22040: p_api_version,
22041: l_api_name,
22042: G_PKG_NAME )
22415: -- Modification ends
22416: -- End Calling Contracts.
22417: -- End of API body
22418:
22419: -- Standard check of p_commit.
22420: IF FND_API.To_Boolean( p_commit ) THEN
22421: COMMIT WORK;
22422: END IF;
22423:
22422: END IF;
22423:
22424: -- End disable trace
22425:
22426: -- Standard call to get message count and IF count is get message info.
22427: FND_MSG_PUB.Count_And_Get
22428: (p_encoded => FND_API.G_FALSE,
22429: p_count => x_msg_count ,
22430: p_data => x_msg_data
22534: l_batch_id NUMBER;
22535: --
22536: BEGIN
22537:
22538: -- Standard Start of API savepoint
22539: SAVEPOINT split_item_instance_lines_pvt;
22540:
22541: -- Standard call to check for call compatibility.
22542: IF NOT FND_API.Compatible_API_Call (l_api_version,
22537:
22538: -- Standard Start of API savepoint
22539: SAVEPOINT split_item_instance_lines_pvt;
22540:
22541: -- Standard call to check for call compatibility.
22542: IF NOT FND_API.Compatible_API_Call (l_api_version,
22543: p_api_version,
22544: l_api_name,
22545: G_PKG_NAME )
22934: -- x_new_instance_tbl(i+1) := l_instance_id_lst(1);
22935:
22936: -- End of API body
22937:
22938: -- Standard check of p_commit.
22939: IF FND_API.To_Boolean( p_commit ) THEN
22940: COMMIT WORK;
22941: END IF;
22942:
22941: END IF;
22942:
22943: -- End disable trace
22944:
22945: -- Standard call to get message count and IF count is get message info.
22946: FND_MSG_PUB.Count_And_Get
22947: (p_encoded => FND_API.G_FALSE,
22948: p_count => x_msg_count ,
22949: p_data => x_msg_data
23602: l_version_label_hist_id NUMBER ;
23603: l_flag VARCHAR2(1) :='N';
23604:
23605: BEGIN
23606: -- Standard Start of API savepoint
23607: SAVEPOINT create_version_label_pvt;
23608:
23609: -- Standard call to check for call compatibility.
23610: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23605: BEGIN
23606: -- Standard Start of API savepoint
23607: SAVEPOINT create_version_label_pvt;
23608:
23609: -- Standard call to check for call compatibility.
23610: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23611: p_api_version ,
23612: l_api_name ,
23613: G_PKG_NAME )
23844:
23845: --
23846: -- End of API body
23847:
23848: -- Standard check of p_commit.
23849:
23850: IF FND_API.To_Boolean( p_commit ) THEN
23851: COMMIT WORK;
23852: END IF;
23850: IF FND_API.To_Boolean( p_commit ) THEN
23851: COMMIT WORK;
23852: END IF;
23853:
23854: -- Standard call to get message count and if count is get message info.
23855: FND_MSG_PUB.Count_And_Get
23856: (p_encoded => FND_API.G_FALSE,
23857: p_count => x_msg_count ,
23858: p_data => x_msg_data );
23965: l_version_hist_csr version_hist_csr%ROWTYPE;
23966: l_version_hist_id NUMBER;
23967: BEGIN
23968:
23969: -- Standard Start of API savepoint
23970: SAVEPOINT update_version_label_pvt;
23971:
23972: -- Standard call to check for call compatibility.
23973: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23968:
23969: -- Standard Start of API savepoint
23970: SAVEPOINT update_version_label_pvt;
23971:
23972: -- Standard call to check for call compatibility.
23973: IF NOT FND_API.Compatible_API_Call (l_api_version ,
23974: p_api_version ,
23975: l_api_name ,
23976: G_PKG_NAME )
24976: -- End of modification for Bug#2547034 on 09/20/02 - rtalluri
24977: --
24978: -- End of API body
24979:
24980: -- Standard check of p_commit.
24981: IF FND_API.To_Boolean( p_commit ) THEN
24982: COMMIT WORK;
24983: END IF;
24984:
24981: IF FND_API.To_Boolean( p_commit ) THEN
24982: COMMIT WORK;
24983: END IF;
24984:
24985: -- Standard call to get message count and if count is get message info.
24986: FND_MSG_PUB.Count_And_Get
24987: (p_encoded => FND_API.G_FALSE,
24988: p_count => x_msg_count ,
24989: p_data => x_msg_data );
25083: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE))
25084: FOR UPDATE OF OBJECT_VERSION_NUMBER ;
25085:
25086: BEGIN
25087: -- Standard Start of API savepoint
25088: SAVEPOINT expire_version_label_pvt;
25089:
25090: -- Standard call to check for call compatibility.
25091: IF NOT FND_API.Compatible_API_Call (l_api_version ,
25086: BEGIN
25087: -- Standard Start of API savepoint
25088: SAVEPOINT expire_version_label_pvt;
25089:
25090: -- Standard call to check for call compatibility.
25091: IF NOT FND_API.Compatible_API_Call (l_api_version ,
25092: p_api_version ,
25093: l_api_name ,
25094: G_PKG_NAME )
25368: END IF;
25369: --
25370: -- End of API body
25371:
25372: -- Standard check of p_commit.
25373: IF FND_API.To_Boolean( p_commit ) THEN
25374: COMMIT WORK;
25375: END IF;
25376:
25373: IF FND_API.To_Boolean( p_commit ) THEN
25374: COMMIT WORK;
25375: END IF;
25376:
25377: -- Standard call to get message count and if count is get message info.
25378: FND_MSG_PUB.Count_And_Get
25379: (p_encoded => FND_API.G_FALSE,
25380: p_count => x_msg_count ,
25381: p_data => x_msg_data );
26013: l_valid_flag VARCHAR2(1);
26014:
26015: BEGIN
26016:
26017: -- Standard Start of API savepoint
26018: SAVEPOINT create_extended_attrib_values;
26019:
26020: -- Standard call to check for call compatibility.
26021: IF NOT FND_API.Compatible_API_Call (l_api_version,
26016:
26017: -- Standard Start of API savepoint
26018: SAVEPOINT create_extended_attrib_values;
26019:
26020: -- Standard call to check for call compatibility.
26021: IF NOT FND_API.Compatible_API_Call (l_api_version,
26022: p_api_version,
26023: l_api_name ,
26024: g_pkg_name)
26496:
26497: END IF; -- Added by sk for bug 2232880
26498: -- End of API body
26499:
26500: -- Standard check of p_commit.
26501: IF FND_API.To_Boolean( p_commit ) THEN
26502: COMMIT WORK;
26503: END IF;
26504:
26501: IF FND_API.To_Boolean( p_commit ) THEN
26502: COMMIT WORK;
26503: END IF;
26504:
26505: -- Standard call to get message count and if count is get message info.
26506: FND_MSG_PUB.Count_And_Get
26507: (p_encoded => FND_API.G_FALSE,
26508: p_count => x_msg_count ,
26509: p_data => x_msg_data
26597: l_ieav_hist_id NUMBER;
26598: l_ieav_hist_csr ieav_hist_csr%ROWTYPE;
26599:
26600: BEGIN
26601: -- Standard Start of API savepoint
26602: SAVEPOINT update_extended_attrib_values;
26603:
26604: -- Standard call to check for call compatibility.
26605: IF NOT FND_API.Compatible_API_Call (l_api_version,
26600: BEGIN
26601: -- Standard Start of API savepoint
26602: SAVEPOINT update_extended_attrib_values;
26603:
26604: -- Standard call to check for call compatibility.
26605: IF NOT FND_API.Compatible_API_Call (l_api_version,
26606: p_api_version,
26607: l_api_name ,
26608: g_pkg_name)
27592: END;
27593: -- End of modifications for Bug#2547034 on 09/20/02 - rtalluri
27594: -- End of API body
27595:
27596: -- Standard check of p_commit.
27597: IF FND_API.To_Boolean( p_commit ) THEN
27598: COMMIT WORK;
27599: END IF;
27600:
27597: IF FND_API.To_Boolean( p_commit ) THEN
27598: COMMIT WORK;
27599: END IF;
27600:
27601: -- Standard call to get message count and if count is get message info.
27602: FND_MSG_PUB.Count_And_Get
27603: (p_encoded => FND_API.G_FALSE,
27604: p_count => x_msg_count ,
27605: p_data => x_msg_data
27677: l_msg_count NUMBER;
27678: l_ext_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
27679: BEGIN
27680:
27681: -- Standard Start of API savepoint
27682: SAVEPOINT expire_extended_attrib_values;
27683:
27684: -- Standard call to check for call compatibility.
27685: IF NOT FND_API.Compatible_API_Call (l_api_version,
27680:
27681: -- Standard Start of API savepoint
27682: SAVEPOINT expire_extended_attrib_values;
27683:
27684: -- Standard call to check for call compatibility.
27685: IF NOT FND_API.Compatible_API_Call (l_api_version,
27686: p_api_version,
27687: l_api_name ,
27688: g_pkg_name)
27789:
27790:
27791: -- End of API body
27792:
27793: -- Standard check of p_commit.
27794: IF FND_API.To_Boolean( p_commit ) THEN
27795: COMMIT WORK;
27796: END IF;
27797:
27794: IF FND_API.To_Boolean( p_commit ) THEN
27795: COMMIT WORK;
27796: END IF;
27797:
27798: -- Standard call to get message count and if count is get message info.
27799: FND_MSG_PUB.Count_And_Get
27800: (p_encoded => FND_API.G_FALSE,
27801: p_count => x_msg_count ,
27802: p_data => x_msg_data
27933: l_batch_type VARCHAR2(50);
27934: l_batch_id NUMBER;
27935: --
27936: BEGIN
27937: -- Standard Start of API savepoint
27938: SAVEPOINT copy_single_item_instance;
27939: -- Standard call to check for call compatibility.
27940: IF NOT FND_API.Compatible_API_Call (l_api_version,
27941: p_api_version,
27935: --
27936: BEGIN
27937: -- Standard Start of API savepoint
27938: SAVEPOINT copy_single_item_instance;
27939: -- Standard call to check for call compatibility.
27940: IF NOT FND_API.Compatible_API_Call (l_api_version,
27941: p_api_version,
27942: l_api_name ,
27943: G_PKG_NAME)
29716: END IF;
29717: -- End Addition by sk for fixing the bug 2234365
29718: END IF;
29719: -- End of API body
29720: -- Standard check of p_commit
29721: IF FND_API.To_Boolean( p_commit ) THEN
29722: COMMIT WORK;
29723: END IF;
29724: -- Standard call to get message count and if count is get message info.
29720: -- Standard check of p_commit
29721: IF FND_API.To_Boolean( p_commit ) THEN
29722: COMMIT WORK;
29723: END IF;
29724: -- Standard call to get message count and if count is get message info.
29725: FND_MSG_PUB.Count_And_Get
29726: (p_encoded => FND_API.G_FALSE,
29727: p_count => x_msg_count ,
29728: p_data => x_msg_data
29851: AND bom.organization_id = msip.organization_id
29852: AND msi.organization_id = mp.organization_id
29853: ORDER BY bet.sort_order;
29854: BEGIN
29855: -- Standard Start of API savepoint
29856: SAVEPOINT explode_bom;
29857: -- Standard call to check for call compatibility.
29858: IF NOT FND_API.Compatible_API_Call (l_api_version,
29859: p_api_version,
29853: ORDER BY bet.sort_order;
29854: BEGIN
29855: -- Standard Start of API savepoint
29856: SAVEPOINT explode_bom;
29857: -- Standard call to check for call compatibility.
29858: IF NOT FND_API.Compatible_API_Call (l_api_version,
29859: p_api_version,
29860: l_api_name ,
29861: G_PKG_NAME)
29875: csi_gen_utility_pvt.put_line( 'explode_bom');
29876: END IF;
29877: -- If the debug level = 2 then dump all the parameters values.
29878: IF (l_debug_level > 1) THEN
29879: csi_gen_utility_pvt.put_line('explode_standard_bom'||'-'
29880: || p_api_version ||'-'
29881: || p_commit ||'-'
29882: || p_init_msg_list ||'-'
29883: || p_validation_level ||'-'
30321: -- Delete records from bom_small_exp_temp
30322: DELETE FROM bom_small_expl_temp where group_id = l_group_id;
30323: --
30324: -- End of API body
30325: -- Standard check of p_commit
30326: IF FND_API.To_Boolean( p_commit ) THEN
30327: COMMIT WORK;
30328: END IF;
30329: -- Standard call to get message count and if count is get message info.
30325: -- Standard check of p_commit
30326: IF FND_API.To_Boolean( p_commit ) THEN
30327: COMMIT WORK;
30328: END IF;
30329: -- Standard call to get message count and if count is get message info.
30330: FND_MSG_PUB.Count_And_Get
30331: ( p_encoded => FND_API.G_FALSE,
30332: p_count => x_msg_count ,
30333: p_data => x_msg_data
30415: SAVEPOINT get_instance_hist;
30416: END IF;
30417: */
30418:
30419: -- Standard call to check for call compatibility.
30420: IF NOT FND_API.Compatible_API_Call (l_api_version ,
30421: p_api_version ,
30422: l_api_name ,
30423: G_PKG_NAME )
32249: END LOOP;
32250:
32251: -- End of API body
32252:
32253: -- Standard check of p_commit.
32254: /*
32255: IF FND_API.To_Boolean( p_commit ) THEN
32256: COMMIT WORK;
32257: END IF;
32264: END IF;
32265: -- End disable trace
32266: ****/
32267:
32268: -- Standard call to get message count and if count is get message info.
32269: FND_MSG_PUB.Count_And_Get
32270: (p_encoded => FND_API.G_FALSE,
32271: p_count => x_msg_count ,
32272: p_data => x_msg_data );
32377: SAVEPOINT get_ext_attrib_val_hist;
32378: END IF;
32379: */
32380:
32381: -- Standard call to check for call compatibility.
32382: IF NOT FND_API.Compatible_API_Call (l_api_version ,
32383: p_api_version ,
32384: l_api_name ,
32385: G_PKG_NAME )
32634: END LOOP;
32635:
32636: -- End of API body
32637:
32638: -- Standard check of p_commit.
32639: /*
32640: IF FND_API.To_Boolean( p_commit ) THEN
32641: COMMIT WORK;
32642: END IF;
32649: END IF;
32650: -- End disable trace
32651: ****/
32652:
32653: -- Standard call to get message count and if count is get message info.
32654: FND_MSG_PUB.Count_And_Get
32655: (p_encoded => FND_API.G_FALSE,
32656: p_count => x_msg_count ,
32657: p_data => x_msg_data );
32793: -- End Add Code for Siebel Genesis Project
32794: l_contract_exists VARCHAR2(1) := NULL; --Added for Bug 14593787
32795: BEGIN
32796:
32797: -- Standard Start of API savepoint
32798: SAVEPOINT copy_item_instance;
32799:
32800: -- Standard call to check for call compatibility.
32801: IF NOT FND_API.Compatible_API_Call (l_api_version,
32796:
32797: -- Standard Start of API savepoint
32798: SAVEPOINT copy_item_instance;
32799:
32800: -- Standard call to check for call compatibility.
32801: IF NOT FND_API.Compatible_API_Call (l_api_version,
32802: p_api_version,
32803: l_api_name ,
32804: G_PKG_NAME)
34751: l_link_to_line_id := null;
34752: l_item_type_code := null;
34753: END;
34754:
34755: IF l_link_to_line_id is null and l_item_type_code = 'STANDARD' THEN
34756: CSI_BUSINESS_EVENT_PVT.CREATE_INSTANCE_EVENT
34757: (p_api_version => p_api_version
34758: ,p_commit => fnd_api.g_false
34759: ,p_init_msg_list => p_init_msg_list
34787: -- End Add Code for Siebel Genesis Project
34788:
34789: -- End of API body
34790:
34791: -- Standard check of p_commit
34792: IF FND_API.To_Boolean( p_commit ) THEN
34793: COMMIT WORK;
34794: END IF;
34795:
34793: COMMIT WORK;
34794: END IF;
34795:
34796:
34797: -- Standard call to get message count and if count is get message info.
34798: FND_MSG_PUB.Count_And_Get
34799: (p_encoded => FND_API.G_FALSE,
34800: p_count => x_msg_count ,
34801: p_data => x_msg_data
34924: AND vlh.version_label_id = vl.version_label_id;
34925:
34926:
34927: BEGIN
34928: -- Standard Start of API savepoint
34929: -- SAVEPOINT get_version_label_history;
34930:
34931:
34932: -- Standard call to check for call compatibility.
34928: -- Standard Start of API savepoint
34929: -- SAVEPOINT get_version_label_history;
34930:
34931:
34932: -- Standard call to check for call compatibility.
34933: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
34934: p_api_version ,
34935: l_api_name ,
34936: g_pkg_name )
35033: END LOOP;
35034:
35035: -- End of API body
35036:
35037: -- Standard check of p_commit.
35038: /*
35039: IF FND_API.To_Boolean( p_commit ) THEN
35040: COMMIT WORK;
35041: END IF;
35048: END IF;
35049: -- End disable trace
35050: ****/
35051:
35052: -- Standard call to get message count and if count is get message info.
35053: FND_MSG_PUB.Count_And_Get
35054: (p_encoded => FND_API.G_FALSE,
35055: p_count => x_msg_count ,
35056: p_data => x_msg_data );
35109: l_flag VARCHAR2(1) := 'N';
35110: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
35111:
35112: BEGIN
35113: -- Standard Start of API savepoint
35114: -- SAVEPOINT get_instance_link_locations;
35115:
35116: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
35117: csi_utility_grp.check_ib_active;
35115:
35116: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
35117: csi_utility_grp.check_ib_active;
35118:
35119: -- Standard call to check for call compatibility.
35120: IF NOT FND_API.Compatible_API_Call (l_api_version,
35121: p_api_version,
35122: l_api_name,
35123: G_PKG_NAME )
35209: x_instance_link_rec.end_loc_postal_code := l_instance_header_tbl(1).end_loc_postal_code;
35210: x_instance_link_rec.end_loc_country := l_instance_header_tbl(1).end_loc_country;
35211:
35212: -- End of API body
35213: -- Standard check of p_commit.
35214: /*
35215: IF FND_API.To_Boolean( p_commit ) THEN
35216: COMMIT WORK;
35217: END IF;
35223: END IF;
35224: -- End disable trace
35225: ****/
35226:
35227: -- Standard call to get message count and if count is get message info.
35228: FND_MSG_PUB.Count_And_Get
35229: (p_encoded => FND_API.G_FALSE,
35230: p_count => x_msg_count ,
35231: p_data => x_msg_data
35481: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
35482:
35483: csi_utility_grp.check_ib_active;
35484:
35485: -- Standard call to check for call compatibility.
35486: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
35487: p_api_version ,
35488: l_api_name ,
35489: g_pkg_name )
35978: IF FND_API.To_Boolean( p_commit ) THEN
35979: COMMIT WORK;
35980: END IF;
35981:
35982: -- Standard call to get message count and if count is get message info.
35983: FND_MSG_PUB.Count_And_Get
35984: (p_encoded => FND_API.G_FALSE,
35985: p_count => x_msg_count ,
35986: p_data => x_msg_data );
36260: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
36261:
36262: csi_utility_grp.check_ib_active;
36263:
36264: -- Standard call to check for call compatibility.
36265: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
36266: p_api_version ,
36267: l_api_name ,
36268: g_pkg_name )
36711: IF FND_API.To_Boolean( p_commit ) THEN
36712: COMMIT WORK;
36713: END IF;
36714:
36715: -- Standard call to get message count and if count is get message info.
36716: FND_MSG_PUB.Count_And_Get
36717: (p_encoded => FND_API.G_FALSE,
36718: p_count => x_msg_count ,
36719: p_data => x_msg_data );