DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PUB dependencies on OKC_API

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: -- PROCEDURE insert_products
128: -- Public wrapper for insert_products process api
129: ---------------------------------------------------------------------------
130: PROCEDURE insert_products(p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_pdtv_rec IN pdtv_rec_type,

Line 189: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

185: -- notify caller of an UNEXPECTED error
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
188: -- store SQL error message on message stack for caller
189: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

195: -- notify caller of an UNEXPECTED error
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197:
198: -- store SQL error message on message stack for caller
199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data);
202:
203: WHEN OTHERS THEN

Line 209: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPRODUCTS_PUB','insert_products');
207:
208: -- store SQL error message on message stack for caller
209: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
210: p_count => x_msg_count,
211: p_data => x_msg_data);
212: END insert_products;
213:

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

215: -- PROCEDURE update_products
216: -- Public wrapper for update_products process api
217: ---------------------------------------------------------------------------
218: PROCEDURE update_products(p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_pdtv_rec IN pdtv_rec_type,

Line 278: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

274: -- notify caller of an UNEXPECTED error
275: x_return_status := FND_API.G_RET_STS_ERROR;
276:
277: -- store SQL error message on message stack for caller
278: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data);
281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 288: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

284: -- notify caller of an UNEXPECTED error
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286:
287: -- store SQL error message on message stack for caller
288: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291:
292: WHEN OTHERS THEN

Line 298: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPRODUCTS_PUB','update_products');
296:
297: -- store SQL error message on message stack for caller
298: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
299: p_count => x_msg_count,
300: p_data => x_msg_data);
301: END update_products;
302: