eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_AGRMNT_APPROVAL_PVT dependencies on OKL_API

Line 33: x_return_status := OKL_API.G_RET_STS_SUCCESS;

29: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_AGRMNT_APPROVAL_PVT.SUBMIT_OA_FOR_APPROVAL';
30: l_debug_enabled VARCHAR2(10);
31:
32: BEGIN
33: x_return_status := OKL_API.G_RET_STS_SUCCESS;
34:
35: l_debug_enabled := okl_debug_pub.check_log_enabled;
36:
37: IF(l_debug_enabled='Y') THEN

Line 42: x_return_status := OKL_API.START_ACTIVITY(

38: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVAAB.pls call submit_oa_for_approval');
39: END IF;
40:
41: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
42: x_return_status := OKL_API.START_ACTIVITY(
43: p_api_name => l_api_name
44: ,p_pkg_name => G_PKG_NAME
45: ,p_init_msg_list => p_init_msg_list
46: ,l_api_version => l_api_version

Line 51: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

47: ,p_api_version => p_api_version
48: ,p_api_type => g_api_type
49: ,x_return_status => x_return_status);
50: -- check if activity started successfully
51: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: END IF;

Line 52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

48: ,p_api_type => g_api_type
49: ,x_return_status => x_return_status);
50: -- check if activity started successfully
51: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: END IF;
56:

Line 53: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

49: ,x_return_status => x_return_status);
50: -- check if activity started successfully
51: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: END IF;
56:
57: -- basic validation. oa should be in status passed before it can be submitted for approval

Line 54: RAISE OKL_API.G_EXCEPTION_ERROR;

50: -- check if activity started successfully
51: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
54: RAISE OKL_API.G_EXCEPTION_ERROR;
55: END IF;
56:
57: -- basic validation. oa should be in status passed before it can be submitted for approval
58: OPEN c_get_oa_sts_csr (p_chr_id); FETCH c_get_oa_sts_csr INTO lv_oa_sts_code, lv_agreement_number;

Line 61: OKL_API.set_message(G_APP_NAME, G_AGR_NOT_PASSED_FOR_APPROVE,'AGR_NUMBER',lv_agreement_number);

57: -- basic validation. oa should be in status passed before it can be submitted for approval
58: OPEN c_get_oa_sts_csr (p_chr_id); FETCH c_get_oa_sts_csr INTO lv_oa_sts_code, lv_agreement_number;
59: CLOSE c_get_oa_sts_csr;
60: IF(lv_oa_sts_code <> G_PASSED_STS_CODE)THEN
61: OKL_API.set_message(G_APP_NAME, G_AGR_NOT_PASSED_FOR_APPROVE,'AGR_NUMBER',lv_agreement_number);
62: RAISE OKL_API.G_EXCEPTION_ERROR;
63: END IF;
64: -- now that the validation has passed, set the OUT status as PENDING, this is the default case
65: x_status_code := G_PENDING_STS_CODE;

Line 62: RAISE OKL_API.G_EXCEPTION_ERROR;

58: OPEN c_get_oa_sts_csr (p_chr_id); FETCH c_get_oa_sts_csr INTO lv_oa_sts_code, lv_agreement_number;
59: CLOSE c_get_oa_sts_csr;
60: IF(lv_oa_sts_code <> G_PASSED_STS_CODE)THEN
61: OKL_API.set_message(G_APP_NAME, G_AGR_NOT_PASSED_FOR_APPROVE,'AGR_NUMBER',lv_agreement_number);
62: RAISE OKL_API.G_EXCEPTION_ERROR;
63: END IF;
64: -- now that the validation has passed, set the OUT status as PENDING, this is the default case
65: x_status_code := G_PENDING_STS_CODE;
66: -- read the profile OKL: Operating Agreement Approval Process

Line 85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

81: l_module,
82: 'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
83: );
84: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;

Line 86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

82: 'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
83: );
84: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90: -- the approval process profile option is not set, since we are activating the agreement in this case,

Line 87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

83: );
84: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90: -- the approval process profile option is not set, since we are activating the agreement in this case,
91: -- the OUT variable should be populated accordingly.

Line 88: RAISE OKL_API.G_EXCEPTION_ERROR;

84: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
85: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90: -- the approval process profile option is not set, since we are activating the agreement in this case,
91: -- the OUT variable should be populated accordingly.
92: x_status_code := G_ACTIVE_STS_CODE;

Line 111: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

107: l_module,
108: 'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
109: );
110: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
111: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;

Line 112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

108: 'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
109: );
110: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
111: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: okl_vp_oa_wf.raise_oa_event_approval(p_api_version => p_api_version

Line 113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

109: );
110: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
111: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: okl_vp_oa_wf.raise_oa_event_approval(p_api_version => p_api_version
117: ,p_init_msg_list => p_init_msg_list

Line 114: RAISE OKL_API.G_EXCEPTION_ERROR;

110: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
111: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
114: RAISE OKL_API.G_EXCEPTION_ERROR;
115: END IF;
116: okl_vp_oa_wf.raise_oa_event_approval(p_api_version => p_api_version
117: ,p_init_msg_list => p_init_msg_list
118: ,x_return_status => x_return_status

Line 129: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

125: l_module,
126: 'okl_vp_oa_wf.raise_oa_event_approval returned with status '||x_return_status||' x_msg_data '||x_msg_data
127: );
128: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
129: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
131: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_ERROR;
133: END IF;

Line 130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

126: 'okl_vp_oa_wf.raise_oa_event_approval returned with status '||x_return_status||' x_msg_data '||x_msg_data
127: );
128: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
129: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
131: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_ERROR;
133: END IF;
134: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'

Line 131: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

127: );
128: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
129: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
131: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_ERROR;
133: END IF;
134: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'
135:

Line 132: RAISE OKL_API.G_EXCEPTION_ERROR;

128: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
129: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
130: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
131: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
132: RAISE OKL_API.G_EXCEPTION_ERROR;
133: END IF;
134: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'
135:
136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

132: RAISE OKL_API.G_EXCEPTION_ERROR;
133: END IF;
134: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'
135:
136: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
137:
138: IF(l_debug_enabled='Y') THEN
139: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVAAB.pls call submit_oa_for_approval');
140: END IF;

Line 143: WHEN OKL_API.G_EXCEPTION_ERROR THEN

139: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVAAB.pls call submit_oa_for_approval');
140: END IF;
141:
142: EXCEPTION
143: WHEN OKL_API.G_EXCEPTION_ERROR THEN
144: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
145: p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 144: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

140: END IF;
141:
142: EXCEPTION
143: WHEN OKL_API.G_EXCEPTION_ERROR THEN
144: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
145: p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
148: x_msg_count => x_msg_count,

Line 147: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

143: WHEN OKL_API.G_EXCEPTION_ERROR THEN
144: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
145: p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data,
150: p_api_type => g_api_type);
151:

Line 152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data,
150: p_api_type => g_api_type);
151:
152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
154: p_api_name => l_api_name,
155: p_pkg_name => G_PKG_NAME,
156: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

149: x_msg_data => x_msg_data,
150: p_api_type => g_api_type);
151:
152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
154: p_api_name => l_api_name,
155: p_pkg_name => G_PKG_NAME,
156: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
157: x_msg_count => x_msg_count,

Line 156: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

152: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
154: p_api_name => l_api_name,
155: p_pkg_name => G_PKG_NAME,
156: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
157: x_msg_count => x_msg_count,
158: x_msg_data => x_msg_data,
159: p_api_type => g_api_type);
160:

Line 162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

158: x_msg_data => x_msg_data,
159: p_api_type => g_api_type);
160:
161: WHEN OTHERS THEN
162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
163: p_api_name => l_api_name,
164: p_pkg_name => G_PKG_NAME,
165: p_exc_name => 'OTHERS',
166: x_msg_count => x_msg_count,

Line 193: x_return_status := OKL_API.G_RET_STS_SUCCESS;

189: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_AGRMNT_APPROVAL_PVT.SUBMIT_PA_FOR_APPROVAL';
190: l_debug_enabled VARCHAR2(10);
191:
192: BEGIN
193: x_return_status := OKL_API.G_RET_STS_SUCCESS;
194:
195: l_debug_enabled := okl_debug_pub.check_log_enabled;
196:
197: IF(l_debug_enabled='Y') THEN

Line 202: x_return_status := OKL_API.START_ACTIVITY(

198: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVAAB.pls call submit_pa_for_approval');
199: END IF;
200:
201: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
202: x_return_status := OKL_API.START_ACTIVITY(
203: p_api_name => l_api_name
204: ,p_pkg_name => G_PKG_NAME
205: ,p_init_msg_list => p_init_msg_list
206: ,l_api_version => l_api_version

Line 211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

207: ,p_api_version => p_api_version
208: ,p_api_type => g_api_type
209: ,x_return_status => x_return_status);
210: -- check if activity started successfully
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;

Line 212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

208: ,p_api_type => g_api_type
209: ,x_return_status => x_return_status);
210: -- check if activity started successfully
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:

Line 213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

209: ,x_return_status => x_return_status);
210: -- check if activity started successfully
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: -- basic validation. oa should be in status passed before it can be submitted for approval

Line 214: RAISE OKL_API.G_EXCEPTION_ERROR;

210: -- check if activity started successfully
211: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216:
217: -- basic validation. oa should be in status passed before it can be submitted for approval
218: OPEN c_get_pa_sts_csr (p_chr_id); FETCH c_get_pa_sts_csr INTO lv_pa_sts_code, lv_agreement_number;

Line 221: OKL_API.set_message(G_APP_NAME, G_AGR_NOT_PASSED_FOR_APPROVE,'AGR_NUMBER',lv_agreement_number);

217: -- basic validation. oa should be in status passed before it can be submitted for approval
218: OPEN c_get_pa_sts_csr (p_chr_id); FETCH c_get_pa_sts_csr INTO lv_pa_sts_code, lv_agreement_number;
219: CLOSE c_get_pa_sts_csr;
220: IF(lv_pa_sts_code <> G_PASSED_STS_CODE)THEN
221: OKL_API.set_message(G_APP_NAME, G_AGR_NOT_PASSED_FOR_APPROVE,'AGR_NUMBER',lv_agreement_number);
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
224: -- now that the validation has passed, set the OUT status as PENDING, this is the default case
225: x_status_code := G_PENDING_STS_CODE;

Line 222: RAISE OKL_API.G_EXCEPTION_ERROR;

218: OPEN c_get_pa_sts_csr (p_chr_id); FETCH c_get_pa_sts_csr INTO lv_pa_sts_code, lv_agreement_number;
219: CLOSE c_get_pa_sts_csr;
220: IF(lv_pa_sts_code <> G_PASSED_STS_CODE)THEN
221: OKL_API.set_message(G_APP_NAME, G_AGR_NOT_PASSED_FOR_APPROVE,'AGR_NUMBER',lv_agreement_number);
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
224: -- now that the validation has passed, set the OUT status as PENDING, this is the default case
225: x_status_code := G_PENDING_STS_CODE;
226: -- read the profile OKL: Program Agreement Approval Process

Line 245: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

241: l_module,
242: 'okl_contract_status_pub.update_contract_status returned with status '||x_return_status||' x_msg_data '||x_msg_data
243: );
244: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
245: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
248: RAISE OKL_API.G_EXCEPTION_ERROR;
249: END IF;

Line 246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

242: 'okl_contract_status_pub.update_contract_status returned with status '||x_return_status||' x_msg_data '||x_msg_data
243: );
244: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
245: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
248: RAISE OKL_API.G_EXCEPTION_ERROR;
249: END IF;
250: -- the approval process profile option is not set, since we are activating the agreement in this case,

Line 247: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

243: );
244: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
245: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
248: RAISE OKL_API.G_EXCEPTION_ERROR;
249: END IF;
250: -- the approval process profile option is not set, since we are activating the agreement in this case,
251: -- the OUT variable should be populated accordingly.

Line 248: RAISE OKL_API.G_EXCEPTION_ERROR;

244: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
245: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
247: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
248: RAISE OKL_API.G_EXCEPTION_ERROR;
249: END IF;
250: -- the approval process profile option is not set, since we are activating the agreement in this case,
251: -- the OUT variable should be populated accordingly.
252: x_status_code := G_ACTIVE_STS_CODE;

Line 271: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

267: l_module,
268: 'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
269: );
270: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
271: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
272: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
274: RAISE OKL_API.G_EXCEPTION_ERROR;
275: END IF;

Line 272: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

268: 'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
269: );
270: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
271: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
272: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
274: RAISE OKL_API.G_EXCEPTION_ERROR;
275: END IF;
276: x_status_code := G_PENDING_STS_CODE;

Line 273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

269: );
270: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
271: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
272: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
274: RAISE OKL_API.G_EXCEPTION_ERROR;
275: END IF;
276: x_status_code := G_PENDING_STS_CODE;
277: okl_vp_pa_wf.raise_pa_event_approval(p_api_version => p_api_version

Line 274: RAISE OKL_API.G_EXCEPTION_ERROR;

270: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
271: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
272: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
274: RAISE OKL_API.G_EXCEPTION_ERROR;
275: END IF;
276: x_status_code := G_PENDING_STS_CODE;
277: okl_vp_pa_wf.raise_pa_event_approval(p_api_version => p_api_version
278: ,p_init_msg_list => p_init_msg_list

Line 291: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

287: ' okl_vp_pa_wf.raise_pa_event_approval returned with status '||x_return_status||' x_msg_data '||x_msg_data
288: );
289: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
290:
291: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;

Line 292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

288: );
289: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
290:
291: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;
296: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'

Line 293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

289: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
290:
291: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;
296: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'
297:

Line 294: RAISE OKL_API.G_EXCEPTION_ERROR;

290:
291: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;
296: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'
297:
298: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 298: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;
296: END IF; -- end of NVL(l_approval_process,'NONE')='NONE'
297:
298: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
299:
300: IF(l_debug_enabled='Y') THEN
301: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVAAB.pls call submit_pa_for_approval');
302: END IF;

Line 305: WHEN OKL_API.G_EXCEPTION_ERROR THEN

301: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVAAB.pls call submit_pa_for_approval');
302: END IF;
303:
304: EXCEPTION
305: WHEN OKL_API.G_EXCEPTION_ERROR THEN
306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
307: p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

302: END IF;
303:
304: EXCEPTION
305: WHEN OKL_API.G_EXCEPTION_ERROR THEN
306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
307: p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
310: x_msg_count => x_msg_count,

Line 309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

305: WHEN OKL_API.G_EXCEPTION_ERROR THEN
306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
307: p_api_name => l_api_name,
308: p_pkg_name => G_PKG_NAME,
309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
310: x_msg_count => x_msg_count,
311: x_msg_data => x_msg_data,
312: p_api_type => g_api_type);
313:

Line 314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

310: x_msg_count => x_msg_count,
311: x_msg_data => x_msg_data,
312: p_api_type => g_api_type);
313:
314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
316: p_api_name => l_api_name,
317: p_pkg_name => G_PKG_NAME,
318: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

311: x_msg_data => x_msg_data,
312: p_api_type => g_api_type);
313:
314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
316: p_api_name => l_api_name,
317: p_pkg_name => G_PKG_NAME,
318: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
319: x_msg_count => x_msg_count,

Line 318: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
316: p_api_name => l_api_name,
317: p_pkg_name => G_PKG_NAME,
318: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
319: x_msg_count => x_msg_count,
320: x_msg_data => x_msg_data,
321: p_api_type => g_api_type);
322:

Line 324: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

320: x_msg_data => x_msg_data,
321: p_api_type => g_api_type);
322:
323: WHEN OTHERS THEN
324: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
325: p_api_name => l_api_name,
326: p_pkg_name => G_PKG_NAME,
327: p_exc_name => 'OTHERS',
328: x_msg_count => x_msg_count,