[Home] [Help]
5975: l_eam_item_type NUMBER;
5976: --
5977: BEGIN
5978:
5979: -- Standard Start of API savepoint
5980: -- SAVEPOINT create_item_instance;
5981:
5982: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5983: csi_utility_grp.check_ib_active;
5981:
5982: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5983: csi_utility_grp.check_ib_active;
5984:
5985: -- Standard call to check for call compatibility.
5986: IF NOT FND_API.Compatible_API_Call (l_api_version,
5987: p_api_version,
5988: l_api_name ,
5989: G_PKG_NAME )
6063: IF p_instance_tbl.EXISTS(inst_tab_row) THEN
6064: FND_MSG_PUB.initialize;
6065: csi_gen_utility_pvt.dump_instance_rec(p_instance_tbl(inst_tab_row));
6066:
6067: -- Standard Start of API savepoint
6068: SAVEPOINT create_item_instance;
6069: l_iface_id := p_instance_tbl(inst_tab_row).interface_id;
6070: l_iface_error_text := NULL;
6071: l_intf_id_array(inst_tab_row) := p_instance_tbl(inst_tab_row).interface_id;
7618: x_return_status := FND_API.G_RET_STS_SUCCESS;
7619: --
7620: END IF; --end of instance_tbl count check
7621: -- End of API body
7622: -- Standard check of p_commit.
7623: IF FND_API.To_Boolean( p_commit ) THEN
7624: COMMIT WORK;
7625: END IF;
7626: /***** srramakr commented for bug # 3304439
7630: END IF;
7631: -- End disable trace
7632: ****/
7633:
7634: -- Standard call to get message count and if count is get message info.
7635: FND_MSG_PUB.Count_And_Get
7636: (p_count => x_msg_count ,
7637: p_data => x_msg_data
7638: );
7974: where instance_party_id=p_ins_pty_id
7975: and relationship_type_code<>'OWNER';
7976:
7977: BEGIN
7978: -- Standard Start of API savepoint
7979: SAVEPOINT update_item_instance;
7980:
7981: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
7982:
7981: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
7982:
7983: csi_utility_grp.check_ib_active;
7984:
7985: -- Standard call to check for call compatibility.
7986: IF NOT FND_API.Compatible_API_Call (l_api_version,
7987: p_api_version,
7988: l_api_name ,
7989: G_PKG_NAME )
9175: --
9176: p_grp_upd_error_tbl := l_grp_upd_error_tbl;
9177: --
9178: -- End of API body
9179: -- Standard check of p_commit.
9180: IF FND_API.To_Boolean( p_commit ) THEN
9181: COMMIT WORK;
9182: END IF;
9183: /***** srramakr commented for bug # 3304439
9186: dbms_session.set_sql_trace(FALSE);
9187: END IF;
9188: -- End disable trace
9189: ****/
9190: -- Standard call to get message count and if count is get message info.
9191: FND_MSG_PUB.Count_And_Get
9192: (p_count => x_msg_count ,
9193: p_data => x_msg_data
9194: );
9261: l_batch_type VARCHAR2(50);
9262: l_batch_id NUMBER;
9263: --
9264: BEGIN
9265: -- Standard Start of API savepoint
9266: SAVEPOINT expire_item_instance;
9267:
9268: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
9269:
9268: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
9269:
9270: csi_utility_grp.check_ib_active;
9271:
9272: -- Standard call to check for call compatibility.
9273: IF NOT FND_API.Compatible_API_Call (l_api_version,
9274: p_api_version,
9275: l_api_name ,
9276: G_PKG_NAME )
9420: END IF;
9421: --
9422: p_grp_error_tbl := l_grp_error_tbl;
9423: -- End of API body
9424: -- Standard check of p_commit.
9425: IF FND_API.To_Boolean( p_commit ) THEN
9426: COMMIT WORK;
9427: END IF;
9428:
9432: dbms_session.set_sql_trace(FALSE);
9433: END IF;
9434: -- End disable trace
9435: ****/
9436: -- Standard call to get message count and if count is get message info.
9437: FND_MSG_PUB.Count_And_Get
9438: (p_count => x_msg_count ,
9439: p_data => x_msg_data );
9440:
9498: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
9499: BEGIN
9500: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
9501: csi_utility_grp.check_ib_active;
9502: -- Standard call to check for call compatibility.
9503: IF NOT FND_API.Compatible_API_Call (l_api_version,
9504: p_api_version,
9505: l_api_name,
9506: G_PKG_NAME
9563: exit;
9564: End;
9565: END LOOP;
9566: -- End of API body
9567: -- Standard call to get message count and if count is get message info.
9568: FND_MSG_PUB.Count_And_Get
9569: (p_count => x_msg_count ,
9570: p_data => x_msg_data
9571: );
10102: l_party_ctr NUMBER;
10103: l_ctr NUMBER;
10104: --
10105: BEGIN
10106: -- Standard Start of API savepoint
10107: SAVEPOINT explode_bom;
10108: -- Standard call to check for call compatibility.
10109: IF NOT FND_API.Compatible_API_Call (l_api_version,
10110: p_api_version,
10104: --
10105: BEGIN
10106: -- Standard Start of API savepoint
10107: SAVEPOINT explode_bom;
10108: -- Standard call to check for call compatibility.
10109: IF NOT FND_API.Compatible_API_Call (l_api_version,
10110: p_api_version,
10111: l_api_name ,
10112: G_PKG_NAME)
10464: RAISE FND_API.G_EXC_ERROR;
10465: END IF;
10466: END IF;
10467: -- End of API body
10468: -- Standard check of p_commit
10469: IF FND_API.To_Boolean( p_commit ) THEN
10470: COMMIT WORK;
10471: END IF;
10472: -- Standard call to get message count and if count is get message info.
10468: -- Standard check of p_commit
10469: IF FND_API.To_Boolean( p_commit ) THEN
10470: COMMIT WORK;
10471: END IF;
10472: -- Standard call to get message count and if count is get message info.
10473: FND_MSG_PUB.Count_And_Get
10474: ( p_count => x_msg_count ,
10475: p_data => x_msg_data
10476: );
10533: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
10534:
10535: csi_utility_grp.check_ib_active;
10536:
10537: -- Standard call to check for call compatibility.
10538: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
10539: p_api_version ,
10540: l_api_name ,
10541: g_pkg_name )
10600: IF FND_API.To_Boolean( p_commit ) THEN
10601: COMMIT WORK;
10602: END IF;
10603:
10604: -- Standard call to get message count and if count is get message info.
10605: FND_MSG_PUB.Count_And_Get
10606: (p_count => x_msg_count ,
10607: p_data => x_msg_data );
10608:
10659: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
10660:
10661: csi_utility_grp.check_ib_active;
10662:
10663: -- Standard call to check for call compatibility.
10664: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
10665: p_api_version ,
10666: l_api_name ,
10667: g_pkg_name )
10729: IF FND_API.To_Boolean( p_commit ) THEN
10730: COMMIT WORK;
10731: END IF;
10732:
10733: -- Standard call to get message count and if count is get message info.
10734: FND_MSG_PUB.Count_And_Get
10735: (p_count => x_msg_count ,
10736: p_data => x_msg_data );
10737: