DBA Data[Home] [Help]

APPS.OKL_VP_STS_PUB dependencies on OKC_API

Line 10: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

6: -- Public wrapper for STATUS PROCESS API
7: ---------------------------------------------------------------------------
8: PROCEDURE get_listof_new_statuses(
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_ste_code IN VARCHAR2,

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

58: -- notify caller of an UNEXPECTED error
59: x_return_status := FND_API.G_RET_STS_ERROR;
60:
61: -- store SQL error message on message stack for caller
62: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
63: p_count => x_msg_count,
64: p_data => x_msg_data);
65:
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 71: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,

67: -- notify caller of an UNEXPECTED error
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69:
70: -- store SQL error message on message stack for caller
71: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
72: p_count => x_msg_count,
73: p_data => x_msg_data);
74:
75: WHEN OTHERS THEN

Line 81: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,

77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.ADD_EXC_MSG('OKL_VP_STS_PUB','get_listof_new_statuses');
79:
80: -- store SQL error message on message stack for caller
81: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data);
84: END get_listof_new_statuses;
85:

Line 90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

86:
87:
88: PROCEDURE change_agreement_status(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_chr_id in number,

Line 139: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,

135: -- notify caller of an UNEXPECTED error
136: x_return_status := FND_API.G_RET_STS_ERROR;
137:
138: -- store SQL error message on message stack for caller
139: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
140: p_count => x_msg_count,
141: p_data => x_msg_data);
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 148: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,

144: -- notify caller of an UNEXPECTED error
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: -- store SQL error message on message stack for caller
148: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
149: p_count => x_msg_count,
150: p_data => x_msg_data);
151:
152: WHEN OTHERS THEN

Line 158: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,

154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: FND_MSG_PUB.ADD_EXC_MSG('OKL_VP_STS_PUB','get_listof_new_statuses');
156:
157: -- store SQL error message on message stack for caller
158: FND_MSG_PUB.count_and_get(p_encoded => OKC_API.G_FALSE,
159: p_count => x_msg_count,
160: p_data => x_msg_data);
161:
162: END change_agreement_status;