DBA Data[Home] [Help]

APPS.OKL_SETUPOPTVALUES_PUB dependencies on OKC_API

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

40: -- PROCEDURE insert_optvalues
41: -- Public wrapper for insert_optvalues process api
42: ---------------------------------------------------------------------------
43: PROCEDURE insert_optvalues(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_optv_rec IN optv_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_SETUPOPTVALUES_PUB','insert_optvalues');
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_optvalues;
118:

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

120: -- PROCEDURE update_optvalues
121: -- Public wrapper for update_optvalues process api
122: ---------------------------------------------------------------------------
123: PROCEDURE update_optvalues(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_optv_rec IN optv_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_SETUPOPTVALUES_PUB','update_optvalues');
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_optvalues;
198: