APPS.OKL_VP_AGRMNT_APPROVAL_PVT dependencies on FND_LOG

Line 29: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_AGRMNT_APPROVAL_PVT.SUBMIT_OA_FOR_APPROVAL';

25: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
26: l_approval_process VARCHAR2(30);
27: l_api_version CONSTANT NUMBER DEFAULT 1.0;
28: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_OA_FOR_APPROVAL';
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;

Line 38: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVAAB.pls call submit_oa_for_approval');

34:
35: l_debug_enabled := okl_debug_pub.check_log_enabled;
36:
37: IF(l_debug_enabled='Y') THEN
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(

Line 80: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

76: ,p_chr_id => p_chr_id
77: );
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'

Line 106: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

102: ,p_chr_id => p_chr_id
103: );
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'

Line 124: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

120: ,x_msg_data => x_msg_data
121: ,p_chr_id => p_chr_id);
122: -- write to log
123: IF(NVL(l_debug_enabled,'N')='Y') THEN
124: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
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'

Line 139: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVAAB.pls call submit_oa_for_approval');

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;
141:
142: EXCEPTION
143: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 189: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_AGRMNT_APPROVAL_PVT.SUBMIT_PA_FOR_APPROVAL';

185: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
186: l_approval_process fnd_lookups.lookup_code%TYPE;
187: l_api_version CONSTANT NUMBER DEFAULT 1.0;
188: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_PA_FOR_APPROVAL';
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;

Line 198: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVAAB.pls call submit_pa_for_approval');

194:
195: l_debug_enabled := okl_debug_pub.check_log_enabled;
196:
197: IF(l_debug_enabled='Y') THEN
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(

Line 240: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

236: ,p_chr_id => p_chr_id
237: );
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'

Line 266: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

262: ,p_chr_id => p_chr_id
263: );
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'

Line 285: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

281: ,x_msg_data => x_msg_data
282: ,p_chr_id => p_chr_id);
283: -- write to log
284: IF(NVL(l_debug_enabled,'N')='Y') THEN
285: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
286: l_module,
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'

Line 301: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVAAB.pls call submit_pa_for_approval');

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;
303:
304: EXCEPTION
305: WHEN OKL_API.G_EXCEPTION_ERROR THEN