[Home] [Help]
6009: l_eam_item_type NUMBER;
6010: --
6011: BEGIN
6012:
6013: -- Standard Start of API savepoint
6014: -- SAVEPOINT create_item_instance;
6015:
6016: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6017: csi_utility_grp.check_ib_active;
6015:
6016: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
6017: csi_utility_grp.check_ib_active;
6018:
6019: -- Standard call to check for call compatibility.
6020: IF NOT FND_API.Compatible_API_Call (l_api_version,
6021: p_api_version,
6022: l_api_name ,
6023: G_PKG_NAME )
6210: IF p_instance_tbl.EXISTS(inst_tab_row) THEN
6211: FND_MSG_PUB.initialize;
6212: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(inst_tab_row));
6213:
6214: -- Standard Start of API savepoint
6215: SAVEPOINT create_item_instance;
6216: l_iface_id := p_instance_tbl(inst_tab_row).interface_id;
6217: l_iface_error_text := NULL;
6218: l_intf_id_array(inst_tab_row) := p_instance_tbl(inst_tab_row).interface_id;
8155: x_return_status := FND_API.G_RET_STS_SUCCESS;
8156: --
8157: END IF; --end of instance_tbl count check
8158: -- End of API body
8159: -- Standard check of p_commit.
8160: IF FND_API.To_Boolean( p_commit ) THEN
8161: COMMIT WORK;
8162: END IF;
8163: /***** srramakr commented for bug # 3304439
8167: END IF;
8168: -- End disable trace
8169: ****/
8170:
8171: -- Standard call to get message count and if count is get message info.
8172: FND_MSG_PUB.Count_And_Get
8173: (p_count => x_msg_count ,
8174: p_data => x_msg_data
8175: );
8511: where instance_party_id=p_ins_pty_id
8512: and relationship_type_code<>'OWNER';
8513:
8514: BEGIN
8515: -- Standard Start of API savepoint
8516: SAVEPOINT update_item_instance;
8517:
8518: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
8519:
8518: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
8519:
8520: csi_utility_grp.check_ib_active;
8521:
8522: -- Standard call to check for call compatibility.
8523: IF NOT FND_API.Compatible_API_Call (l_api_version,
8524: p_api_version,
8525: l_api_name ,
8526: G_PKG_NAME )
9730: --
9731: p_grp_upd_error_tbl := l_grp_upd_error_tbl;
9732: --
9733: -- End of API body
9734: -- Standard check of p_commit.
9735: IF FND_API.To_Boolean( p_commit ) THEN
9736: COMMIT WORK;
9737: END IF;
9738: /***** srramakr commented for bug # 3304439
9741: dbms_session.set_sql_trace(FALSE);
9742: END IF;
9743: -- End disable trace
9744: ****/
9745: -- Standard call to get message count and if count is get message info.
9746: FND_MSG_PUB.Count_And_Get
9747: (p_count => x_msg_count ,
9748: p_data => x_msg_data
9749: );
9816: l_batch_type VARCHAR2(50);
9817: l_batch_id NUMBER;
9818: --
9819: BEGIN
9820: -- Standard Start of API savepoint
9821: SAVEPOINT expire_item_instance;
9822:
9823: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
9824:
9823: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
9824:
9825: csi_utility_grp.check_ib_active;
9826:
9827: -- Standard call to check for call compatibility.
9828: IF NOT FND_API.Compatible_API_Call (l_api_version,
9829: p_api_version,
9830: l_api_name ,
9831: G_PKG_NAME )
9975: END IF;
9976: --
9977: p_grp_error_tbl := l_grp_error_tbl;
9978: -- End of API body
9979: -- Standard check of p_commit.
9980: IF FND_API.To_Boolean( p_commit ) THEN
9981: COMMIT WORK;
9982: END IF;
9983:
9987: dbms_session.set_sql_trace(FALSE);
9988: END IF;
9989: -- End disable trace
9990: ****/
9991: -- Standard call to get message count and if count is get message info.
9992: FND_MSG_PUB.Count_And_Get
9993: (p_count => x_msg_count ,
9994: p_data => x_msg_data );
9995:
10053: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
10054: BEGIN
10055: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
10056: csi_utility_grp.check_ib_active;
10057: -- Standard call to check for call compatibility.
10058: IF NOT FND_API.Compatible_API_Call (l_api_version,
10059: p_api_version,
10060: l_api_name,
10061: G_PKG_NAME
10118: exit;
10119: End;
10120: END LOOP;
10121: -- End of API body
10122: -- Standard call to get message count and if count is get message info.
10123: FND_MSG_PUB.Count_And_Get
10124: (p_count => x_msg_count ,
10125: p_data => x_msg_data
10126: );
10658: l_ctr NUMBER;
10659: l_bom_expl_org_flag VARCHAR2(3);
10660: --
10661: BEGIN
10662: -- Standard Start of API savepoint
10663: SAVEPOINT explode_bom;
10664: -- Standard call to check for call compatibility.
10665: IF NOT FND_API.Compatible_API_Call (l_api_version,
10666: p_api_version,
10660: --
10661: BEGIN
10662: -- Standard Start of API savepoint
10663: SAVEPOINT explode_bom;
10664: -- Standard call to check for call compatibility.
10665: IF NOT FND_API.Compatible_API_Call (l_api_version,
10666: p_api_version,
10667: l_api_name ,
10668: G_PKG_NAME)
11039: RAISE FND_API.G_EXC_ERROR;
11040: END IF;
11041: END IF;
11042: -- End of API body
11043: -- Standard check of p_commit
11044: IF FND_API.To_Boolean( p_commit ) THEN
11045: COMMIT WORK;
11046: END IF;
11047: -- Standard call to get message count and if count is get message info.
11043: -- Standard check of p_commit
11044: IF FND_API.To_Boolean( p_commit ) THEN
11045: COMMIT WORK;
11046: END IF;
11047: -- Standard call to get message count and if count is get message info.
11048: FND_MSG_PUB.Count_And_Get
11049: ( p_count => x_msg_count ,
11050: p_data => x_msg_data
11051: );
11108: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
11109:
11110: csi_utility_grp.check_ib_active;
11111:
11112: -- Standard call to check for call compatibility.
11113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
11114: p_api_version ,
11115: l_api_name ,
11116: g_pkg_name )
11175: IF FND_API.To_Boolean( p_commit ) THEN
11176: COMMIT WORK;
11177: END IF;
11178:
11179: -- Standard call to get message count and if count is get message info.
11180: FND_MSG_PUB.Count_And_Get
11181: (p_count => x_msg_count ,
11182: p_data => x_msg_data );
11183:
11234: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
11235:
11236: csi_utility_grp.check_ib_active;
11237:
11238: -- Standard call to check for call compatibility.
11239: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
11240: p_api_version ,
11241: l_api_name ,
11242: g_pkg_name )
11304: IF FND_API.To_Boolean( p_commit ) THEN
11305: COMMIT WORK;
11306: END IF;
11307:
11308: -- Standard call to get message count and if count is get message info.
11309: FND_MSG_PUB.Count_And_Get
11310: (p_count => x_msg_count ,
11311: p_data => x_msg_data );
11312: