130: AND P.CATEGORY_SET_ID = p_prod_cat_set_id;
131: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intc.create_interest_code';
132:
133: BEGIN
134: -- Standard Start of API SavePoint
135: SAVEPOINT create_interest_code_PUB;
136:
137: FND_MSG_PUB.DELETE_MSG;
138:
140: IF FND_API.to_Boolean( p_init_msg_list ) THEN
141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call (l_api_version,
146: p_api_version_number,
147: l_api_name,
148: G_PKG_NAME )
559: l_prod_cat_id
560: );
561:
562:
563: -- Standard check of p_commit.
564: IF FND_API.To_Boolean( p_commit ) THEN
565: COMMIT WORK;
566: END IF;
567:
564: IF FND_API.To_Boolean( p_commit ) THEN
565: COMMIT WORK;
566: END IF;
567:
568: -- Standard call to get message count and if count is 1,
569: -- get message info.
570: FND_MSG_PUB.Count_And_Get(
571: p_count => x_msg_count,
572: p_data => x_msg_data
787: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intc.update_interest_code';
788:
789: BEGIN
790:
791: -- Standard STart of API SavePoint
792: SAVEPOINT update_interest_code_PUB;
793:
794: FND_MSG_PUB.DELETE_MSG;
795:
797: IF FND_API.to_Boolean( p_init_msg_list ) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: -- Standard call to check for call compatibility.
802: IF NOT FND_API.Compatible_API_Call (l_api_version,
803: p_api_version_number,
804: l_api_name,
805: G_PKG_NAME )
1228:
1229: -- Close Cursors
1230: CLOSE lock_row_for_update ;
1231:
1232: -- Standard check of p_commit.
1233: IF FND_API.To_Boolean( p_commit ) THEN
1234: COMMIT WORK;
1235: END IF;
1236:
1233: IF FND_API.To_Boolean( p_commit ) THEN
1234: COMMIT WORK;
1235: END IF;
1236:
1237: -- Standard call to get message count and if count is 1,
1238: -- get message info.
1239: FND_MSG_PUB.Count_And_Get(
1240: p_count => x_msg_count,
1241: p_data => x_msg_data