[Home] [Help]
140: l_batch_id NUMBER;
141: l_batch_type VARCHAR2(50);
142: BEGIN
143:
144: -- Standard Start of API savepoint
145: SAVEPOINT create_item_instance;
146:
147: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
148:
147: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
148:
149: csi_utility_grp.check_ib_active;
150:
151: -- Standard call to check for call compatibility.
152: IF NOT FND_API.Compatible_API_Call (l_api_version,
153: p_api_version,
154: l_api_name ,
155: G_PKG_NAME )
1062: l_link_to_line_id := null;
1063: l_item_type_code := null;
1064: END;
1065:
1066: IF l_link_to_line_id is null and l_item_type_code = 'STANDARD' THEN
1067: CSI_BUSINESS_EVENT_PVT.CREATE_INSTANCE_EVENT
1068: (p_api_version => p_api_version
1069: ,p_commit => fnd_api.g_false
1070: ,p_init_msg_list => p_init_msg_list
1096: END IF;
1097: END IF;
1098: -- End Add Code for Siebel Genesis Project - Call the Business Event
1099:
1100: -- Standard check of p_commit.
1101: IF FND_API.To_Boolean( p_commit ) THEN
1102: COMMIT WORK;
1103: END IF;
1104: /***** srramakr commented for bug # 3304439
1108: END IF;
1109: ****/
1110: -- End disable trace
1111:
1112: -- Standard call to get message count and if count is get message info.
1113: FND_MSG_PUB.Count_And_Get
1114: (p_count => x_msg_count ,
1115: p_data => x_msg_data
1116: );
1396: l_batch_type VARCHAR2(50);
1397: l_batch_id NUMBER;
1398:
1399: BEGIN
1400: -- Standard Start of API savepoint
1401: SAVEPOINT update_item_instance;
1402:
1403: -- srramakr fix for Bug # 2909878
1404: -- Bug 3804960 commented the following as we are not going to use l_date.
1423: -- End of 3804960
1424: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
1425: csi_utility_grp.check_ib_active;
1426:
1427: -- Standard call to check for call compatibility.
1428: IF NOT FND_API.Compatible_API_Call (l_api_version,
1429: p_api_version,
1430: l_api_name ,
1431: G_PKG_NAME )
3181: RAISE FND_API.G_EXC_ERROR;
3182: END IF;
3183: END IF;
3184: -- End of API body
3185: -- Standard check of p_commit.
3186: IF FND_API.To_Boolean( p_commit ) THEN
3187: COMMIT WORK;
3188: END IF;
3189: /***** srramakr commented for bug # 3304439
3192: dbms_session.set_sql_trace(FALSE);
3193: END IF;
3194: -- End disable trace
3195: ****/
3196: -- Standard call to get message count and if count is get message info.
3197: FND_MSG_PUB.Count_And_Get
3198: (p_count => x_msg_count ,
3199: p_data => x_msg_data
3200: );
3318: l_link_to_line_id := null;
3319: l_item_type_code := null;
3320: END;
3321:
3322: IF l_link_to_line_id is null and l_item_type_code = 'STANDARD' THEN
3323: csi_gen_utility_pvt.put_line('It is standard calling update instance event');
3324: CSI_BUSINESS_EVENT_PVT.UPDATE_INSTANCE_EVENT
3325: (p_api_version => p_api_version
3326: ,p_commit => fnd_api.g_false
3319: l_item_type_code := null;
3320: END;
3321:
3322: IF l_link_to_line_id is null and l_item_type_code = 'STANDARD' THEN
3323: csi_gen_utility_pvt.put_line('It is standard calling update instance event');
3324: CSI_BUSINESS_EVENT_PVT.UPDATE_INSTANCE_EVENT
3325: (p_api_version => p_api_version
3326: ,p_commit => fnd_api.g_false
3327: ,p_init_msg_list => p_init_msg_list
3348: END LOOP;
3349: RAISE FND_API.G_EXC_ERROR;
3350: END IF;
3351: ELSE
3352: csi_gen_utility_pvt.put_line(' Not standard it is in configuration');
3353: -- Check if relationships is already been built then allow update
3354: BEGIN
3355: SELECT 'Y',subject_id,object_id,relationship_type_code
3356: INTO l_relationship_exists,l_subject_id,l_object_id,l_relationship_type_code
3535: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
3536: l_batch_type VARCHAR2(50);
3537: l_batch_id NUMBER;
3538: BEGIN
3539: -- Standard Start of API savepoint
3540: SAVEPOINT expire_item_instance;
3541:
3542: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3543:
3542: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
3543:
3544: csi_utility_grp.check_ib_active;
3545:
3546: -- Standard call to check for call compatibility.
3547: IF NOT FND_API.Compatible_API_Call (l_api_version,
3548: p_api_version,
3549: l_api_name ,
3550: G_PKG_NAME )
3984: RAISE FND_API.G_EXC_ERROR;
3985: END IF;
3986: END IF;
3987: -- End of API body
3988: -- Standard check of p_commit.
3989: IF FND_API.To_Boolean( p_commit ) THEN
3990: COMMIT WORK;
3991: END IF;
3992: /***** srramakr commented for bug # 3304439
3995: dbms_session.set_sql_trace(FALSE);
3996: END IF;
3997: -- End disable trace
3998: ****/
3999: -- Standard call to get message count and if count is get message info.
4000: FND_MSG_PUB.Count_And_Get
4001: (p_count => x_msg_count ,
4002: p_data => x_msg_data );
4003: -- Call Post Vertical User Hook
4120: l_select_stmt VARCHAR2(20000) := '';
4121:
4122:
4123: BEGIN
4124: -- Standard Start of API savepoint
4125: --SAVEPOINT get_item_instances;
4126:
4127: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4128:
4128:
4129: csi_utility_grp.check_ib_active;
4130:
4131:
4132: -- Standard call to check for call compatibility.
4133: IF NOT FND_API.Compatible_API_Call (l_api_version,
4134: p_api_version,
4135: l_api_name ,
4136: G_PKG_NAME )
4308: END IF;
4309: END IF;
4310:
4311: -- End of API body
4312: -- Standard check of p_commit.
4313: /*
4314: IF FND_API.To_Boolean( p_commit ) THEN
4315: COMMIT WORK;
4316: END IF;
4323: END IF;
4324: -- End disable trace
4325: ****/
4326:
4327: -- Standard call to get message count and if count is get message info.
4328: FND_MSG_PUB.Count_And_Get
4329: (p_count => x_msg_count ,
4330: p_data => x_msg_data
4331: );
4448: l_time_stamp DATE;
4449:
4450: BEGIN
4451:
4452: -- Standard Start of API savepoint
4453: -- SAVEPOINT get_item_instance_details;
4454:
4455:
4456: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4456: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4457:
4458: csi_utility_grp.check_ib_active;
4459:
4460: -- Standard call to check for call compatibility.
4461: IF NOT FND_API.Compatible_API_Call (l_api_version,
4462: p_api_version,
4463: l_api_name ,
4464: G_PKG_NAME )
4805: END IF;
4806:
4807: -- End of API body
4808:
4809: -- Standard check of p_commit.
4810: /*
4811: IF FND_API.To_Boolean( p_commit ) THEN
4812: COMMIT WORK;
4813: END IF;
4820: END IF;
4821: -- End disable trace
4822: ****/
4823:
4824: -- Standard call to get message count and if count is get message info.
4825: FND_MSG_PUB.Count_And_Get
4826: (p_count => x_msg_count ,
4827: p_data => x_msg_data
4828: );
4899: l_version_label_rec csi_datastructures_pub.version_label_rec;
4900: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_VERSION_LABELS ';
4901:
4902: BEGIN
4903: -- Standard Start of API savepoint
4904: -- SAVEPOINT get_version_label_pub;
4905:
4906: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4907:
4906: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
4907:
4908: csi_utility_grp.check_ib_active;
4909:
4910: -- Standard call to check for call compatibility.
4911: IF NOT FND_API.Compatible_API_Call (l_api_version ,
4912: p_api_version ,
4913: l_api_name ,
4914: G_PKG_NAME )
5004:
5005: --
5006: -- End of API body
5007:
5008: -- Standard check of p_commit.
5009: /*
5010: IF FND_API.To_Boolean( p_commit ) THEN
5011: COMMIT WORK;
5012: END IF;
5019: END IF;
5020: -- End disable trace
5021: ****/
5022:
5023: -- Standard call to get message count and if count is get message info.
5024: FND_MSG_PUB.Count_And_Get
5025: (p_count => x_msg_count ,
5026: p_data => x_msg_data);
5027:
5079: l_flag VARCHAR2(1) :='N' ;
5080: l_msg_count NUMBER;
5081: BEGIN
5082:
5083: -- Standard Start of API savepoint
5084: SAVEPOINT create_version_label_pub;
5085:
5086: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5087:
5086: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5087:
5088: csi_utility_grp.check_ib_active;
5089:
5090: -- Standard call to check for call compatibility.
5091: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5092: p_api_version ,
5093: l_api_name ,
5094: G_PKG_NAME )
5169: END IF;
5170: --
5171: -- End of API body
5172:
5173: -- Standard check of p_commit.
5174: IF FND_API.To_Boolean( p_commit ) THEN
5175: COMMIT WORK;
5176: END IF;
5177:
5182: END IF;
5183: -- End disable trace
5184: ****/
5185:
5186: -- Standard call to get message count and if count is get message info.
5187: FND_MSG_PUB.Count_And_Get
5188: (p_count => x_msg_count ,
5189: p_data => x_msg_data );
5190:
5245: l_msg_count NUMBER;
5246:
5247: BEGIN
5248:
5249: -- Standard Start of API savepoint
5250: SAVEPOINT update_version_label_pub;
5251:
5252: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5253:
5252: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5253:
5254: csi_utility_grp.check_ib_active;
5255:
5256: -- Standard call to check for call compatibility.
5257: IF NOT FND_API.Compatible_API_Call (l_api_version ,
5258: p_api_version ,
5259: l_api_name ,
5260: G_PKG_NAME )
5334: END IF;
5335: --
5336: -- End of API body
5337:
5338: -- Standard check of p_commit.
5339: IF FND_API.To_Boolean( p_commit ) THEN
5340: COMMIT WORK;
5341: END IF;
5342:
5347: END IF;
5348: -- End disable trace
5349: ****/
5350:
5351: -- Standard call to get message count and if count is get message info.
5352: FND_MSG_PUB.Count_And_Get
5353: (p_count => x_msg_count ,
5354: p_data => x_msg_data);
5355: EXCEPTION
5409: l_msg_count NUMBER;
5410:
5411: BEGIN
5412:
5413: -- Standard Start of API savepoint
5414: SAVEPOINT expire_version_label_pub;
5415:
5416: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5417:
5416: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5417:
5418: csi_utility_grp.check_ib_active;
5419:
5420: -- Standard call to check for call compatibility.
5421: IF NOT FND_API.Compatible_API_Call (l_api_version ,
5422: p_api_version ,
5423: l_api_name ,
5424: G_PKG_NAME )
5492: END IF;
5493: --
5494: -- End of API body
5495:
5496: -- Standard check of p_commit.
5497: IF FND_API.To_Boolean( p_commit ) THEN
5498: COMMIT WORK;
5499: END IF;
5500:
5505: END IF;
5506: -- End disable trace
5507: ****/
5508:
5509: -- Standard call to get message count and if count is get message info.
5510: FND_MSG_PUB.Count_And_Get
5511: (p_count => x_msg_count ,
5512: p_data => x_msg_data );
5513: EXCEPTION
5721: AND ia.instance_id = p_instance_id;
5722:
5723: BEGIN
5724:
5725: -- Standard Start of API savepoint
5726: -- SAVEPOINT get_extended_attrib_values;
5727:
5728: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5729:
5728: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5729:
5730: csi_utility_grp.check_ib_active;
5731:
5732: -- Standard call to check for call compatibility.
5733: IF NOT FND_API.Compatible_API_Call (l_api_version,
5734: p_api_version,
5735: l_api_name,
5736: g_pkg_name)
5903: END IF;
5904:
5905: -- End of API body
5906:
5907: -- Standard check of p_commit.
5908: /*
5909: IF FND_API.To_Boolean( p_commit ) THEN
5910: COMMIT WORK;
5911: END IF;
5918: END IF;
5919: -- End disable trace
5920: ****/
5921:
5922: -- Standard call to get message count and if count is get message info.
5923: FND_MSG_PUB.Count_And_Get
5924: (p_count => x_msg_count ,
5925: p_data => x_msg_data
5926: );
5997: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
5998: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
5999: BEGIN
6000:
6001: -- Standard Start of API savepoint
6002: SAVEPOINT create_extended_attrib_values;
6003:
6004: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6005:
6004: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6005:
6006: csi_utility_grp.check_ib_active;
6007:
6008: -- Standard call to check for call compatibility.
6009: IF NOT FND_API.Compatible_API_Call (l_api_version,
6010: p_api_version,
6011: l_api_name ,
6012: g_pkg_name)
6099:
6100: -- End of API body
6101:
6102:
6103: -- Standard check of p_commit.
6104: IF FND_API.To_Boolean( p_commit ) THEN
6105: COMMIT WORK;
6106: END IF;
6107:
6113: -- End disable trace
6114: ****/
6115:
6116:
6117: -- Standard call to get message count and if count is get message info.
6118: FND_MSG_PUB.Count_And_Get
6119: (p_count => x_msg_count ,
6120: p_data => x_msg_data
6121: );
6190: l_ext_attr_tbl csi_item_instance_pvt.ext_attr_tbl;
6191: l_ext_cat_tbl csi_item_instance_pvt.ext_cat_tbl;
6192: BEGIN
6193:
6194: -- Standard Start of API savepoint
6195: SAVEPOINT update_extended_attrib_values;
6196:
6197: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6198:
6197: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6198:
6199: csi_utility_grp.check_ib_active;
6200:
6201: -- Standard call to check for call compatibility.
6202: IF NOT FND_API.Compatible_API_Call (l_api_version,
6203: p_api_version,
6204: l_api_name,
6205: g_pkg_name)
6289: END IF;
6290:
6291: -- End of API body
6292:
6293: -- Standard check of p_commit.
6294: IF FND_API.To_Boolean( p_commit ) THEN
6295: COMMIT WORK;
6296: END IF;
6297:
6302: END IF;
6303: -- End disable trace
6304: ****/
6305:
6306: -- Standard call to get message count and if count is get message info.
6307: FND_MSG_PUB.Count_And_Get
6308: (p_count => x_msg_count ,
6309: p_data => x_msg_data
6310: );
6374: l_msg_count NUMBER;
6375: l_trace_enable_flag VARCHAR2(1) :='N';
6376: BEGIN
6377:
6378: -- Standard Start of API savepoint
6379: SAVEPOINT delete_extended_attrib_values;
6380:
6381: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6382:
6381: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6382:
6383: csi_utility_grp.check_ib_active;
6384:
6385: -- Standard call to check for call compatibility.
6386: IF NOT FND_API.Compatible_API_Call (l_api_version,
6387: p_api_version,
6388: l_api_name ,
6389: g_pkg_name)
6471:
6472: -- End of API body
6473:
6474:
6475: -- Standard check of p_commit.
6476: IF FND_API.To_Boolean( p_commit ) THEN
6477: COMMIT WORK;
6478: END IF;
6479:
6485: -- End disable trace
6486: ****/
6487:
6488:
6489: -- Standard call to get message count and if count is get message info.
6490: FND_MSG_PUB.Count_And_Get
6491: (p_count => x_msg_count ,
6492: p_data => x_msg_data
6493: );
6571: l_msg_count NUMBER;
6572: x_msg_index_out NUMBER;
6573: BEGIN
6574:
6575: -- Standard Start of API savepoint
6576: SAVEPOINT copy_item_instance;
6577:
6578: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6579:
6578: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6579:
6580: csi_utility_grp.check_ib_active;
6581:
6582: -- Standard call to check for call compatibility.
6583: IF NOT FND_API.Compatible_API_Call (l_api_version,
6584: p_api_version,
6585: l_api_name ,
6586: G_PKG_NAME)
6664: END IF;
6665:
6666: -- End of API body
6667:
6668: -- Standard check of p_commit
6669: IF FND_API.To_Boolean( p_commit ) THEN
6670: COMMIT WORK;
6671: END IF;
6672:
6670: COMMIT WORK;
6671: END IF;
6672:
6673:
6674: -- Standard call to get message count and if count is get message info.
6675:
6676: FND_MSG_PUB.Count_And_Get
6677: (p_count => x_msg_count ,
6678: p_data => x_msg_data