DBA Data[Home] [Help]

APPS.OKL_SETUPDSFPARAMETERS_PUB dependencies on OKC_API

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

40: -- PROCEDURE insert_dsfparameters
41: -- Public wrapper for insert_dsfparameters process api
42: ---------------------------------------------------------------------------
43: PROCEDURE insert_dsfparameters(p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_dsfv_rec IN dsfv_rec_type,

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

90: -- notify caller of an UNEXPECTED error
91: x_return_status := FND_API.G_RET_STS_ERROR;
92:
93: -- store SQL error message on message stack for caller
94: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data);
97:
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

100: -- notify caller of an UNEXPECTED error
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102:
103: -- store SQL error message on message stack for caller
104: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data);
107:
108: WHEN OTHERS THEN

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

110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
112:
113: -- store SQL error message on message stack for caller
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data);
117: END insert_dsfparameters;
118:

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

120: -- PROCEDURE update_dsfparameters
121: -- Public wrapper for update_dsfparameters process api
122: ---------------------------------------------------------------------------
123: PROCEDURE update_dsfparameters(p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_dsfv_rec IN dsfv_rec_type,

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

170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:
173: -- store SQL error message on message stack for caller
174: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

180: -- notify caller of an UNEXPECTED error
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: -- store SQL error message on message stack for caller
184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data);
187:
188: WHEN OTHERS THEN

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

190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
192:
193: -- store SQL error message on message stack for caller
194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data);
197: END update_dsfparameters;
198:

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

241: -- notify caller of an UNEXPECTED error
242: x_return_status := FND_API.G_RET_STS_ERROR;
243:
244: -- store SQL error message on message stack for caller
245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
246: p_count => x_msg_count,
247: p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

251: -- notify caller of an UNEXPECTED error
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253:
254: -- store SQL error message on message stack for caller
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258:
259: WHEN OTHERS THEN

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

261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','delete_dsfparameters');
263:
264: -- store SQL error message on message stack for caller
265: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data);
268: END delete_dsfparameters;
269:

Line 276: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

272: -- PROCEDURE insert_dsfparameters
273: -- Public wrapper for insert_dsfparameters process api
274: ---------------------------------------------------------------------------
275: PROCEDURE insert_dsfparameters(p_api_version IN NUMBER,
276: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,
280: p_dsfv_rec IN dsfv_rec_type,

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

317: -- notify caller of an UNEXPECTED error
318: x_return_status := FND_API.G_RET_STS_ERROR;
319:
320: -- store SQL error message on message stack for caller
321: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

327: -- notify caller of an UNEXPECTED error
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329:
330: -- store SQL error message on message stack for caller
331: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
332: p_count => x_msg_count,
333: p_data => x_msg_data);
334:
335: WHEN OTHERS THEN

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

337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
339:
340: -- store SQL error message on message stack for caller
341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
342: p_count => x_msg_count,
343: p_data => x_msg_data);
344: END insert_dsfparameters;
345: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end

Line 353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

349: -- PROCEDURE update_dsfparameters
350: -- Public wrapper for update_dsfparameters process api
351: ---------------------------------------------------------------------------
352: PROCEDURE update_dsfparameters(p_api_version IN NUMBER,
353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_dsfv_rec IN dsfv_rec_type,

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

393: -- notify caller of an UNEXPECTED error
394: x_return_status := FND_API.G_RET_STS_ERROR;
395:
396: -- store SQL error message on message stack for caller
397: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data);
400:
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

403: -- notify caller of an UNEXPECTED error
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: -- store SQL error message on message stack for caller
407: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
408: p_count => x_msg_count,
409: p_data => x_msg_data);
410:
411: WHEN OTHERS THEN

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

413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
415:
416: -- store SQL error message on message stack for caller
417: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => x_msg_data);
420: END update_dsfparameters;
421: