DBA Data[Home] [Help]

APPS.OKL_CS_LEASE_RENEWAL_PUB dependencies on OKL_API

Line 22: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,

18:
19:
20: PROCEDURE calculate(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26: p_trqv_tbl IN okl_trx_requests_pub.trqv_tbl_type,

Line 53: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

49: x_msg_data => l_msg_data,
50: p_trqv_tbl => p_trqv_tbl,
51: x_trqv_tbl => x_trqv_tbl);
52:
53: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: END IF;

Line 54: RAISE OKL_API.G_EXCEPTION_ERROR;

50: p_trqv_tbl => p_trqv_tbl,
51: x_trqv_tbl => x_trqv_tbl);
52:
53: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: END IF;
58:

Line 55: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

51: x_trqv_tbl => x_trqv_tbl);
52:
53: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: END IF;
58:
59: ------------ End Call to Private Process API--------------

Line 56: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

52:
53: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
56: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: END IF;
58:
59: ------------ End Call to Private Process API--------------
60:

Line 71: WHEN OKL_API.G_EXCEPTION_ERROR THEN

67: x_return_status := l_return_status;
68:
69: EXCEPTION
70:
71: WHEN OKL_API.G_EXCEPTION_ERROR THEN
72: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
74: p_data => x_msg_data);
75:

Line 72: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

68:
69: EXCEPTION
70:
71: WHEN OKL_API.G_EXCEPTION_ERROR THEN
72: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
74: p_data => x_msg_data);
75:
76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

72: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
74: p_data => x_msg_data);
75:
76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);
80:

Line 77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

73: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
74: p_data => x_msg_data);
75:
76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);
80:
81: WHEN OTHERS THEN

Line 82: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

78: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
79: p_data => x_msg_data);
80:
81: WHEN OTHERS THEN
82: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
83: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_lease_renewal_pub','calculate');
84: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
85: p_data => x_msg_data);
86:

Line 91: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,

87: END calculate;
88:
89: PROCEDURE create_working_copy(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
92: p_commit IN VARCHAR2 := OKL_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,

Line 92: p_commit IN VARCHAR2 := OKL_API.G_FALSE,

88:
89: PROCEDURE create_working_copy(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
92: p_commit IN VARCHAR2 := OKL_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_chr_id IN NUMBER,

Line 123: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

119: p_chr_id => p_chr_id,
120: x_chr_id => x_chr_id);
121:
122:
123: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;

Line 124: RAISE OKL_API.G_EXCEPTION_ERROR;

120: x_chr_id => x_chr_id);
121:
122:
123: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
128:

Line 125: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

121:
122:
123: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
128:
129: ------------ End Call to Private Process API--------------

Line 126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

122:
123: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_ERROR;
125: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: END IF;
128:
129: ------------ End Call to Private Process API--------------
130:

Line 141: WHEN OKL_API.G_EXCEPTION_ERROR THEN

137: x_return_status := l_return_status;
138:
139: EXCEPTION
140:
141: WHEN OKL_API.G_EXCEPTION_ERROR THEN
142: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
144: p_data => x_msg_data);
145:

Line 142: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

138:
139: EXCEPTION
140:
141: WHEN OKL_API.G_EXCEPTION_ERROR THEN
142: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
144: p_data => x_msg_data);
145:
146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

142: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
144: p_data => x_msg_data);
145:
146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
147: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
149: p_data => x_msg_data);
150:

Line 147: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

143: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
144: p_data => x_msg_data);
145:
146: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
147: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
149: p_data => x_msg_data);
150:
151: WHEN OTHERS THEN

Line 152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

148: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
149: p_data => x_msg_data);
150:
151: WHEN OTHERS THEN
152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_lease_renewal_pub','create_working_copy');
154: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156:

Line 192: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

188: x_msg_data => l_msg_data,
189: p_trqv_rec => p_trqv_rec,
190: x_trqv_rec => x_trqv_rec);
191:
192: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_ERROR;
194: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
196: END IF;

Line 193: RAISE OKL_API.G_EXCEPTION_ERROR;

189: p_trqv_rec => p_trqv_rec,
190: x_trqv_rec => x_trqv_rec);
191:
192: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_ERROR;
194: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
196: END IF;
197:

Line 194: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

190: x_trqv_rec => x_trqv_rec);
191:
192: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_ERROR;
194: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
196: END IF;
197:
198: ------------ End Call to Private Process API--------------

Line 195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

191:
192: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_ERROR;
194: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
196: END IF;
197:
198: ------------ End Call to Private Process API--------------
199:

Line 210: WHEN OKL_API.G_EXCEPTION_ERROR THEN

206: x_return_status := l_return_status;
207:
208: EXCEPTION
209:
210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
213: p_data => x_msg_data);
214:

Line 211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

207:
208: EXCEPTION
209:
210: WHEN OKL_API.G_EXCEPTION_ERROR THEN
211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
218: p_data => x_msg_data);
219:

Line 216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

212: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
216: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
218: p_data => x_msg_data);
219:
220: WHEN OTHERS THEN

Line 221: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

217: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
218: p_data => x_msg_data);
219:
220: WHEN OTHERS THEN
221: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.ADD_EXC_MSG('okl_cs_lease_renewal_pub','update_lrnw_request');
223: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
224: p_data => x_msg_data);
225: