[Home] [Help]
141: l_batch_id NUMBER;
142: l_batch_type VARCHAR2(50);
143: BEGIN
144:
145: -- Standard Start of API savepoint
146: SAVEPOINT create_item_instance;
147:
148: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
149:
148: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
149:
150: csi_utility_grp.check_ib_active;
151:
152: -- Standard call to check for call compatibility.
153: IF NOT FND_API.Compatible_API_Call (l_api_version,
154: p_api_version,
155: l_api_name ,
156: G_PKG_NAME )
1110: END IF;
1111: END IF;
1112: -- End Add Code for Siebel Genesis Project - Call the Business Event
1113:
1114: -- Standard check of p_commit.
1115: IF FND_API.To_Boolean( p_commit ) THEN
1116: COMMIT WORK;
1117: END IF;
1118: /***** srramakr commented for bug # 3304439
1122: END IF;
1123: ****/
1124: -- End disable trace
1125:
1126: -- Standard call to get message count and if count is get message info.
1127: FND_MSG_PUB.Count_And_Get
1128: (p_encoded => FND_API.G_FALSE, --Added for bug 7657438
1129: p_count => x_msg_count ,
1130: p_data => x_msg_data
1417: l_batch_type VARCHAR2(50);
1418: l_batch_id NUMBER;
1419:
1420: BEGIN
1421: -- Standard Start of API savepoint
1422: SAVEPOINT update_item_instance;
1423:
1424: -- srramakr fix for Bug # 2909878
1425: -- Bug 3804960 commented the following as we are not going to use l_date.
1444: -- End of 3804960
1445: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1446: csi_utility_grp.check_ib_active;
1447:
1448: -- Standard call to check for call compatibility.
1449: IF NOT FND_API.Compatible_API_Call (l_api_version,
1450: p_api_version,
1451: l_api_name ,
1452: G_PKG_NAME )
3289: RAISE FND_API.G_EXC_ERROR;
3290: END IF;
3291: END IF;
3292: -- End of API body
3293: -- Standard check of p_commit.
3294: IF FND_API.To_Boolean( p_commit ) THEN
3295: COMMIT WORK;
3296: END IF;
3297: /***** srramakr commented for bug # 3304439
3300: dbms_session.set_sql_trace(FALSE);
3301: END IF;
3302: -- End disable trace
3303: ****/
3304: -- Standard call to get message count and if count is get message info.
3305: FND_MSG_PUB.Count_And_Get
3306: (p_encoded => FND_API.G_FALSE,
3307: p_count => x_msg_count ,
3308: p_data => x_msg_data
3572: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
3573: l_batch_type VARCHAR2(50);
3574: l_batch_id NUMBER;
3575: BEGIN
3576: -- Standard Start of API savepoint
3577: SAVEPOINT expire_item_instance;
3578:
3579: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3580:
3579: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3580:
3581: csi_utility_grp.check_ib_active;
3582:
3583: -- Standard call to check for call compatibility.
3584: IF NOT FND_API.Compatible_API_Call (l_api_version,
3585: p_api_version,
3586: l_api_name ,
3587: G_PKG_NAME )
4022: RAISE FND_API.G_EXC_ERROR;
4023: END IF;
4024: END IF;
4025: -- End of API body
4026: -- Standard check of p_commit.
4027: IF FND_API.To_Boolean( p_commit ) THEN
4028: COMMIT WORK;
4029: END IF;
4030: /***** srramakr commented for bug # 3304439
4033: dbms_session.set_sql_trace(FALSE);
4034: END IF;
4035: -- End disable trace
4036: ****/
4037: -- Standard call to get message count and if count is get message info.
4038: FND_MSG_PUB.Count_And_Get
4039: (p_encoded => FND_API.G_FALSE,
4040: p_count => x_msg_count ,
4041: p_data => x_msg_data );
4162: l_select_stmt VARCHAR2(20000) := '';
4163:
4164:
4165: BEGIN
4166: -- Standard Start of API savepoint
4167: --SAVEPOINT get_item_instances;
4168:
4169: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4170:
4170:
4171: csi_utility_grp.check_ib_active;
4172:
4173:
4174: -- Standard call to check for call compatibility.
4175: IF NOT FND_API.Compatible_API_Call (l_api_version,
4176: p_api_version,
4177: l_api_name ,
4178: G_PKG_NAME )
4350: END IF;
4351: END IF;
4352:
4353: -- End of API body
4354: -- Standard check of p_commit.
4355: /*
4356: IF FND_API.To_Boolean( p_commit ) THEN
4357: COMMIT WORK;
4358: END IF;
4365: END IF;
4366: -- End disable trace
4367: ****/
4368:
4369: -- Standard call to get message count and if count is get message info.
4370: FND_MSG_PUB.Count_And_Get
4371: (p_encoded => FND_API.G_FALSE,
4372: p_count => x_msg_count ,
4373: p_data => x_msg_data
4494: l_time_stamp DATE;
4495:
4496: BEGIN
4497:
4498: -- Standard Start of API savepoint
4499: -- SAVEPOINT get_item_instance_details;
4500:
4501:
4502: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4502: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4503:
4504: csi_utility_grp.check_ib_active;
4505:
4506: -- Standard call to check for call compatibility.
4507: IF NOT FND_API.Compatible_API_Call (l_api_version,
4508: p_api_version,
4509: l_api_name ,
4510: G_PKG_NAME )
4851: END IF;
4852:
4853: -- End of API body
4854:
4855: -- Standard check of p_commit.
4856: /*
4857: IF FND_API.To_Boolean( p_commit ) THEN
4858: COMMIT WORK;
4859: END IF;
4866: END IF;
4867: -- End disable trace
4868: ****/
4869:
4870: -- Standard call to get message count and if count is get message info.
4871: FND_MSG_PUB.Count_And_Get
4872: (p_encoded => FND_API.G_FALSE,
4873: p_count => x_msg_count ,
4874: p_data => x_msg_data
4951: l_version_label_rec csi_datastructures_pub.version_label_rec;
4952: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_VERSION_LABELS ';
4953:
4954: BEGIN
4955: -- Standard Start of API savepoint
4956: -- SAVEPOINT get_version_label_pub;
4957:
4958: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4959:
4958: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4959:
4960: csi_utility_grp.check_ib_active;
4961:
4962: -- Standard call to check for call compatibility.
4963: IF NOT FND_API.Compatible_API_Call (l_api_version ,
4964: p_api_version ,
4965: l_api_name ,
4966: G_PKG_NAME )
5056:
5057: --
5058: -- End of API body
5059:
5060: -- Standard check of p_commit.
5061: /*
5062: IF FND_API.To_Boolean( p_commit ) THEN
5063: COMMIT WORK;
5064: END IF;
5071: END IF;
5072: -- End disable trace
5073: ****/
5074:
5075: -- Standard call to get message count and if count is get message info.
5076: FND_MSG_PUB.Count_And_Get
5077: (p_encoded => FND_API.G_FALSE,
5078: p_count => x_msg_count ,
5079: p_data => x_msg_data);
5135: l_flag VARCHAR2(1) :='N' ;
5136: l_msg_count NUMBER;
5137: BEGIN
5138:
5139: -- Standard Start of API savepoint
5140: SAVEPOINT create_version_label_pub;
5141:
5142: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5143:
5142: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5143:
5144: csi_utility_grp.check_ib_active;
5145:
5146: -- Standard call to check for call compatibility.
5147: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5148: p_api_version ,
5149: l_api_name ,
5150: G_PKG_NAME )
5225: END IF;
5226: --
5227: -- End of API body
5228:
5229: -- Standard check of p_commit.
5230: IF FND_API.To_Boolean( p_commit ) THEN
5231: COMMIT WORK;
5232: END IF;
5233:
5238: END IF;
5239: -- End disable trace
5240: ****/
5241:
5242: -- Standard call to get message count and if count is get message info.
5243: FND_MSG_PUB.Count_And_Get
5244: (p_encoded => FND_API.G_FALSE,
5245: p_count => x_msg_count ,
5246: p_data => x_msg_data );
5305: l_msg_count NUMBER;
5306:
5307: BEGIN
5308:
5309: -- Standard Start of API savepoint
5310: SAVEPOINT update_version_label_pub;
5311:
5312: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5313:
5312: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5313:
5314: csi_utility_grp.check_ib_active;
5315:
5316: -- Standard call to check for call compatibility.
5317: IF NOT FND_API.Compatible_API_Call (l_api_version ,
5318: p_api_version ,
5319: l_api_name ,
5320: G_PKG_NAME )
5394: END IF;
5395: --
5396: -- End of API body
5397:
5398: -- Standard check of p_commit.
5399: IF FND_API.To_Boolean( p_commit ) THEN
5400: COMMIT WORK;
5401: END IF;
5402:
5407: END IF;
5408: -- End disable trace
5409: ****/
5410:
5411: -- Standard call to get message count and if count is get message info.
5412: FND_MSG_PUB.Count_And_Get
5413: (p_encoded => FND_API.G_FALSE,
5414: p_count => x_msg_count ,
5415: p_data => x_msg_data);
5473: l_msg_count NUMBER;
5474:
5475: BEGIN
5476:
5477: -- Standard Start of API savepoint
5478: SAVEPOINT expire_version_label_pub;
5479:
5480: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5481:
5480: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5481:
5482: csi_utility_grp.check_ib_active;
5483:
5484: -- Standard call to check for call compatibility.
5485: IF NOT FND_API.Compatible_API_Call (l_api_version ,
5486: p_api_version ,
5487: l_api_name ,
5488: G_PKG_NAME )
5556: END IF;
5557: --
5558: -- End of API body
5559:
5560: -- Standard check of p_commit.
5561: IF FND_API.To_Boolean( p_commit ) THEN
5562: COMMIT WORK;
5563: END IF;
5564:
5569: END IF;
5570: -- End disable trace
5571: ****/
5572:
5573: -- Standard call to get message count and if count is get message info.
5574: FND_MSG_PUB.Count_And_Get
5575: (p_encoded => FND_API.G_FALSE,
5576: p_count => x_msg_count ,
5577: p_data => x_msg_data );
5789: AND ia.instance_id = p_instance_id;
5790:
5791: BEGIN
5792:
5793: -- Standard Start of API savepoint
5794: -- SAVEPOINT get_extended_attrib_values;
5795:
5796: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5797:
5796: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5797:
5798: csi_utility_grp.check_ib_active;
5799:
5800: -- Standard call to check for call compatibility.
5801: IF NOT FND_API.Compatible_API_Call (l_api_version,
5802: p_api_version,
5803: l_api_name,
5804: g_pkg_name)
5971: END IF;
5972:
5973: -- End of API body
5974:
5975: -- Standard check of p_commit.
5976: /*
5977: IF FND_API.To_Boolean( p_commit ) THEN
5978: COMMIT WORK;
5979: END IF;
5986: END IF;
5987: -- End disable trace
5988: ****/
5989:
5990: -- Standard call to get message count and if count is get message info.
5991: FND_MSG_PUB.Count_And_Get
5992: (p_encoded => FND_API.G_FALSE,
5993: p_count => x_msg_count ,
5994: p_data => x_msg_data
6069: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
6070: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
6071: BEGIN
6072:
6073: -- Standard Start of API savepoint
6074: SAVEPOINT create_extended_attrib_values;
6075:
6076: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6077:
6076: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6077:
6078: csi_utility_grp.check_ib_active;
6079:
6080: -- Standard call to check for call compatibility.
6081: IF NOT FND_API.Compatible_API_Call (l_api_version,
6082: p_api_version,
6083: l_api_name ,
6084: g_pkg_name)
6171:
6172: -- End of API body
6173:
6174:
6175: -- Standard check of p_commit.
6176: IF FND_API.To_Boolean( p_commit ) THEN
6177: COMMIT WORK;
6178: END IF;
6179:
6185: -- End disable trace
6186: ****/
6187:
6188:
6189: -- Standard call to get message count and if count is get message info.
6190: FND_MSG_PUB.Count_And_Get
6191: (p_encoded => FND_API.G_FALSE,
6192: p_count => x_msg_count ,
6193: p_data => x_msg_data
6266: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
6267: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
6268: BEGIN
6269:
6270: -- Standard Start of API savepoint
6271: SAVEPOINT update_extended_attrib_values;
6272:
6273: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6274:
6273: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6274:
6275: csi_utility_grp.check_ib_active;
6276:
6277: -- Standard call to check for call compatibility.
6278: IF NOT FND_API.Compatible_API_Call (l_api_version,
6279: p_api_version,
6280: l_api_name,
6281: g_pkg_name)
6365: END IF;
6366:
6367: -- End of API body
6368:
6369: -- Standard check of p_commit.
6370: IF FND_API.To_Boolean( p_commit ) THEN
6371: COMMIT WORK;
6372: END IF;
6373:
6378: END IF;
6379: -- End disable trace
6380: ****/
6381:
6382: -- Standard call to get message count and if count is get message info.
6383: FND_MSG_PUB.Count_And_Get
6384: (p_encoded => FND_API.G_FALSE,
6385: p_count => x_msg_count ,
6386: p_data => x_msg_data
6454: l_msg_count NUMBER;
6455: l_trace_enable_flag VARCHAR2(1) :='N';
6456: BEGIN
6457:
6458: -- Standard Start of API savepoint
6459: SAVEPOINT delete_extended_attrib_values;
6460:
6461: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6462:
6461: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6462:
6463: csi_utility_grp.check_ib_active;
6464:
6465: -- Standard call to check for call compatibility.
6466: IF NOT FND_API.Compatible_API_Call (l_api_version,
6467: p_api_version,
6468: l_api_name ,
6469: g_pkg_name)
6551:
6552: -- End of API body
6553:
6554:
6555: -- Standard check of p_commit.
6556: IF FND_API.To_Boolean( p_commit ) THEN
6557: COMMIT WORK;
6558: END IF;
6559:
6565: -- End disable trace
6566: ****/
6567:
6568:
6569: -- Standard call to get message count and if count is get message info.
6570: FND_MSG_PUB.Count_And_Get
6571: (p_encoded => FND_API.G_FALSE,
6572: p_count => x_msg_count ,
6573: p_data => x_msg_data
6655: l_msg_count NUMBER;
6656: x_msg_index_out NUMBER;
6657: BEGIN
6658:
6659: -- Standard Start of API savepoint
6660: SAVEPOINT copy_item_instance;
6661:
6662: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6663:
6662: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6663:
6664: csi_utility_grp.check_ib_active;
6665:
6666: -- Standard call to check for call compatibility.
6667: IF NOT FND_API.Compatible_API_Call (l_api_version,
6668: p_api_version,
6669: l_api_name ,
6670: G_PKG_NAME)
6748: END IF;
6749:
6750: -- End of API body
6751:
6752: -- Standard check of p_commit
6753: IF FND_API.To_Boolean( p_commit ) THEN
6754: COMMIT WORK;
6755: END IF;
6756:
6754: COMMIT WORK;
6755: END IF;
6756:
6757:
6758: -- Standard call to get message count and if count is get message info.
6759:
6760: FND_MSG_PUB.Count_And_Get
6761: (p_encoded => FND_API.G_FALSE,
6762: p_count => x_msg_count ,