49: SAVEPOINT Generate_JCG_XML_PRE_CUHK;
50:
51: x_return_status:=FND_API.G_RET_STS_SUCCESS;
52:
53: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
54: fnd_log.string
55: (
56: fnd_log.level_procedure,
57: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
50:
51: x_return_status:=FND_API.G_RET_STS_SUCCESS;
52:
53: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
54: fnd_log.string
55: (
56: fnd_log.level_procedure,
57: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
58: 'At the start of Generate_JCG_XML_PRE'
52:
53: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
54: fnd_log.string
55: (
56: fnd_log.level_procedure,
57: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
58: 'At the start of Generate_JCG_XML_PRE'
59: );
60:
64: -- for pre processing
65: --
66: --
67:
68: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
69:
70: fnd_log.string
71: (
72: fnd_log.level_procedure,
66: --
67:
68: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
69:
70: fnd_log.string
71: (
72: fnd_log.level_procedure,
73: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
74: 'x_return_status:' || x_return_status
68: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
69:
70: fnd_log.string
71: (
72: fnd_log.level_procedure,
73: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
74: 'x_return_status:' || x_return_status
75: );
76:
73: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
74: 'x_return_status:' || x_return_status
75: );
76:
77: fnd_log.string
78: (
79: fnd_log.level_procedure,
80: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
81: 'At the end of Generate_JCG_XML_PRE'
75: );
76:
77: fnd_log.string
78: (
79: fnd_log.level_procedure,
80: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
81: 'At the end of Generate_JCG_XML_PRE'
82: );
83:
193:
194: BEGIN
195: SAVEPOINT Generate_JCG_XML_POST_CUHK;
196:
197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
198:
199: fnd_log.string
200: (
201: fnd_log.level_procedure,
195: SAVEPOINT Generate_JCG_XML_POST_CUHK;
196:
197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
198:
199: fnd_log.string
200: (
201: fnd_log.level_procedure,
202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
203: 'At the start of Generate_JCG_XML_POST'
197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
198:
199: fnd_log.string
200: (
201: fnd_log.level_procedure,
202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
203: 'At the start of Generate_JCG_XML_POST'
204: );
205:
202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
203: 'At the start of Generate_JCG_XML_POST'
204: );
205:
206: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
207: 'Input p_object_type:' || p_object_type);
208: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
209: 'Input p_object_id:' || p_object_id);
210: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
204: );
205:
206: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
207: 'Input p_object_type:' || p_object_type);
208: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
209: 'Input p_object_id:' || p_object_id);
210: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
211: 'Input p_split_flag:' || p_split_flag);
212: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
206: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
207: 'Input p_object_type:' || p_object_type);
208: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
209: 'Input p_object_id:' || p_object_id);
210: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
211: 'Input p_split_flag:' || p_split_flag);
212: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
213: 'Input p_jcg_wrkpkg_location:' || p_jcg_wrkpkg_location);
214:
208: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
209: 'Input p_object_id:' || p_object_id);
210: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
211: 'Input p_split_flag:' || p_split_flag);
212: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
213: 'Input p_jcg_wrkpkg_location:' || p_jcg_wrkpkg_location);
214:
215: END IF;
216:
232: --
233: --
234: -- end custom code
235:
236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
237:
238: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
239: 'Output x_return_status:' || x_return_status);
240: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
234: -- end custom code
235:
236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
237:
238: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
239: 'Output x_return_status:' || x_return_status);
240: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
241: 'Output x_jcg_wrkpkg_file:' || x_jcg_wrkpkg_file);
242: fnd_log.string
236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
237:
238: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
239: 'Output x_return_status:' || x_return_status);
240: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
241: 'Output x_jcg_wrkpkg_file:' || x_jcg_wrkpkg_file);
242: fnd_log.string
243: (
244: fnd_log.level_procedure,
238: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
239: 'Output x_return_status:' || x_return_status);
240: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
241: 'Output x_jcg_wrkpkg_file:' || x_jcg_wrkpkg_file);
242: fnd_log.string
243: (
244: fnd_log.level_procedure,
245: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
246: 'At the end of Generate_JCG_XML_POST'
240: fnd_log.string (fnd_log.level_procedure, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
241: 'Output x_jcg_wrkpkg_file:' || x_jcg_wrkpkg_file);
242: fnd_log.string
243: (
244: fnd_log.level_procedure,
245: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.end',
246: 'At the end of Generate_JCG_XML_POST'
247: );
248: END IF;