DBA Data[Home] [Help]

APPS.OKL_SETUPPQYVALUES_PUB dependencies on OKC_API

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

40: -- PROCEDURE insert_pqyvalues
41: -- Public wrapper for insert_pqyvalues process api
42: ---------------------------------------------------------------------------
43: PROCEDURE insert_pqyvalues(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_pqyv_rec IN pqyv_rec_type,

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

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

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

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

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

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

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

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

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

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

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

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

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