[Home] [Help]
66: -- read the profile OKL: Operating Agreement Approval Process
67: l_approval_process := fnd_profile.value('OKL_VP_OA_APPROVAL_PROCESS');
68: IF(NVL(l_approval_process,'NONE')='NONE')THEN
69: -- since no option is set at the profile, approve the operating agreement by default
70: okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
71: ,p_init_msg_list => p_init_msg_list
72: ,x_return_status => x_return_status
73: ,x_msg_count => x_msg_count
74: ,x_msg_data => x_msg_data
78: -- write to log
79: IF(NVL(l_debug_enabled,'N')='Y') THEN
80: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
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;
92: x_status_code := G_ACTIVE_STS_CODE;
93: ELSIF(l_approval_process IN ('AME','WF'))THEN
94: -- for the case of workflow or Approvals Management profile option, the agreement is set to status
95: -- G_PENDING_STS_CODE
96: okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
97: ,p_init_msg_list => p_init_msg_list
98: ,x_return_status => x_return_status
99: ,x_msg_count => x_msg_count
100: ,x_msg_data => x_msg_data
104: -- write to log
105: IF(NVL(l_debug_enabled,'N')='Y') THEN
106: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
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;
226: -- read the profile OKL: Program Agreement Approval Process
227: l_approval_process := fnd_profile.value('OKL_VP_PA_APPROVAL_PROCESS');
228: IF(NVL(l_approval_process,'NONE')='NONE')THEN
229: -- since no option is set at the profile, approve the operating agreement by default
230: okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
231: ,p_init_msg_list => p_init_msg_list
232: ,x_return_status => x_return_status
233: ,x_msg_count => x_msg_count
234: ,x_msg_data => x_msg_data
238: -- write to log
239: IF(NVL(l_debug_enabled,'N')='Y') THEN
240: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
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;
252: x_status_code := G_ACTIVE_STS_CODE;
253: ELSIF(l_approval_process IN ('AME','WF'))THEN
254: -- for the case of workflow or Approvals Management profile option, the agreement is set to status
255: -- G_PENDING_STS_CODE
256: okl_contract_status_pub.update_contract_status(p_api_version => p_api_version
257: ,p_init_msg_list => p_init_msg_list
258: ,x_return_status => x_return_status
259: ,x_msg_count => x_msg_count
260: ,x_msg_data => x_msg_data
264: -- write to log
265: IF(NVL(l_debug_enabled,'N')='Y') THEN
266: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
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;