APPS.OKC_XPRT_CZ_INT_PVT dependencies on FND_LOG

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_CZ_INT_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 48: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

44:
45: BEGIN
46:
47: -- start debug log
48: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
50: G_MODULE||l_api_name,
51: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
52: END IF;

Line 49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

45: BEGIN
46:
47: -- start debug log
48: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
49: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
50: G_MODULE||l_api_name,
51: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
52: END IF;
53:

Line 63: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

59: -- Initialize API return status to success
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: -- debug log
63: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
65: G_MODULE||l_api_name,
66: ' ********************************************************');
67: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: -- debug log
63: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
65: G_MODULE||l_api_name,
66: ' ********************************************************');
67: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
68: G_MODULE||l_api_name,

Line 67: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

63: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
64: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
65: G_MODULE||l_api_name,
66: ' ********************************************************');
67: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
68: G_MODULE||l_api_name,
69: 'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
70: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
71: G_MODULE||l_api_name,

Line 70: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

66: ' ********************************************************');
67: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
68: G_MODULE||l_api_name,
69: 'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
70: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
71: G_MODULE||l_api_name,
72: 'p_api_version : '||l_api_version);
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
74: G_MODULE||l_api_name,

Line 73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

69: 'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
70: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
71: G_MODULE||l_api_name,
72: 'p_api_version : '||l_api_version);
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
74: G_MODULE||l_api_name,
75: 'p_run_id : '||p_run_id);
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
77: G_MODULE||l_api_name,

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

72: 'p_api_version : '||l_api_version);
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
74: G_MODULE||l_api_name,
75: 'p_run_id : '||p_run_id);
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
77: G_MODULE||l_api_name,
78: 'p_rp_folder_id : '||p_rp_folder_id);
79: END IF;
80:

Line 103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

99: x_status => l_cz_return_status
100: );
101:
102: -- debug log
103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
105: G_MODULE||l_api_name,
106: ' ********************************************************');
107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

100: );
101:
102: -- debug log
103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
105: G_MODULE||l_api_name,
106: ' ********************************************************');
107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
108: G_MODULE||l_api_name,

Line 107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
105: G_MODULE||l_api_name,
106: ' ********************************************************');
107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
108: G_MODULE||l_api_name,
109: 'After Calling CZ_CONTRACTS_API_GRP.import_generic ');
110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
111: G_MODULE||l_api_name,

Line 110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

106: ' ********************************************************');
107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
108: G_MODULE||l_api_name,
109: 'After Calling CZ_CONTRACTS_API_GRP.import_generic ');
110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
111: G_MODULE||l_api_name,
112: 'x_status : '||l_cz_return_status);
113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
114: G_MODULE||l_api_name,

Line 113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

109: 'After Calling CZ_CONTRACTS_API_GRP.import_generic ');
110: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
111: G_MODULE||l_api_name,
112: 'x_status : '||l_cz_return_status);
113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
114: G_MODULE||l_api_name,
115: 'x_run_id : '||x_run_id);
116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
117: G_MODULE||l_api_name,

Line 116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

112: 'x_status : '||l_cz_return_status);
113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
114: G_MODULE||l_api_name,
115: 'x_run_id : '||x_run_id);
116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
117: G_MODULE||l_api_name,
118: ' ********************************************************');
119: END IF;
120:

Line 151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

147: -- Standard call to get message count and if count is 1, get message info.
148: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
149:
150: -- end debug log
151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
153: G_MODULE||l_api_name,
154: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
155: END IF;

Line 152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

148: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
149:
150: -- end debug log
151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
153: G_MODULE||l_api_name,
154: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
155: END IF;
156:

Line 159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

155: END IF;
156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
161: G_MODULE||l_api_name,
162: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
163: END IF;

Line 160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

156:
157: EXCEPTION
158: WHEN OTHERS THEN
159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
161: G_MODULE||l_api_name,
162: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
163: END IF;
164: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

194:
195: BEGIN
196:
197: -- start debug log
198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
200: G_MODULE||l_api_name,
201: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
202: END IF;

Line 199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

195: BEGIN
196:
197: -- start debug log
198: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
200: G_MODULE||l_api_name,
201: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
202: END IF;
203:

Line 213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

209: -- Initialize API return status to success
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211:
212: -- debug log
213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
215: G_MODULE||l_api_name,
216: ' ********************************************************');
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211:
212: -- debug log
213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
215: G_MODULE||l_api_name,
216: ' ********************************************************');
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,

Line 217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
215: G_MODULE||l_api_name,
216: ' ********************************************************');
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,
219: 'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
221: G_MODULE||l_api_name,

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

216: ' ********************************************************');
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,
219: 'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
221: G_MODULE||l_api_name,
222: 'p_api_version : '||l_api_version);
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: G_MODULE||l_api_name,

Line 223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

219: 'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
221: G_MODULE||l_api_name,
222: 'p_api_version : '||l_api_version);
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: G_MODULE||l_api_name,
225: 'p_encl_folder_id : '||p_encl_folder_id);
226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
227: G_MODULE||l_api_name,

Line 226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

222: 'p_api_version : '||l_api_version);
223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
224: G_MODULE||l_api_name,
225: 'p_encl_folder_id : '||p_encl_folder_id);
226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
227: G_MODULE||l_api_name,
228: 'p_new_folder_name : '||p_new_folder_name);
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
230: G_MODULE||l_api_name,

Line 229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

225: 'p_encl_folder_id : '||p_encl_folder_id);
226: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
227: G_MODULE||l_api_name,
228: 'p_new_folder_name : '||p_new_folder_name);
229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
230: G_MODULE||l_api_name,
231: ' ********************************************************');
232: END IF;
233:

Line 262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

258: );
259:
260:
261: -- debug log
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
264: G_MODULE||l_api_name,
265: ' ********************************************************');
266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

259:
260:
261: -- debug log
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
264: G_MODULE||l_api_name,
265: ' ********************************************************');
266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
267: G_MODULE||l_api_name,

Line 266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
264: G_MODULE||l_api_name,
265: ' ********************************************************');
266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
267: G_MODULE||l_api_name,
268: 'After Calling CZ_CONTRACTS_API_GRP.create_rp_folder');
269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
270: G_MODULE||l_api_name,

Line 269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

265: ' ********************************************************');
266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
267: G_MODULE||l_api_name,
268: 'After Calling CZ_CONTRACTS_API_GRP.create_rp_folder');
269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
270: G_MODULE||l_api_name,
271: 'x_new_folder_id : '||x_new_folder_id);
272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
273: G_MODULE||l_api_name,

Line 272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

268: 'After Calling CZ_CONTRACTS_API_GRP.create_rp_folder');
269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
270: G_MODULE||l_api_name,
271: 'x_new_folder_id : '||x_new_folder_id);
272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
273: G_MODULE||l_api_name,
274: 'x_return_status : '||l_cz_return_status);
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
276: G_MODULE||l_api_name,

Line 275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

271: 'x_new_folder_id : '||x_new_folder_id);
272: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
273: G_MODULE||l_api_name,
274: 'x_return_status : '||l_cz_return_status);
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
276: G_MODULE||l_api_name,
277: ' ********************************************************');
278: END IF;
279:

Line 299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

295: -- Standard call to get message count and if count is 1, get message info.
296: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
297:
298: -- end debug log
299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
301: G_MODULE||l_api_name,
302: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
303: END IF;

Line 300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

296: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
297:
298: -- end debug log
299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
301: G_MODULE||l_api_name,
302: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
303: END IF;
304:

Line 307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

303: END IF;
304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
309: G_MODULE||l_api_name,
310: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
311: END IF;

Line 308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
309: G_MODULE||l_api_name,
310: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
311: END IF;
312: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

336:
337: BEGIN
338:
339: -- start debug log
340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
342: G_MODULE||l_api_name,
343: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
344: END IF;

Line 341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

337: BEGIN
338:
339: -- start debug log
340: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
341: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
342: G_MODULE||l_api_name,
343: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
344: END IF;
345:

Line 355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

351: -- Initialize API return status to success
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: -- debug log
355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
357: G_MODULE||l_api_name,
358: ' ********************************************************');
359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353:
354: -- debug log
355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
357: G_MODULE||l_api_name,
358: ' ********************************************************');
359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
360: G_MODULE||l_api_name,

Line 359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
357: G_MODULE||l_api_name,
358: ' ********************************************************');
359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
360: G_MODULE||l_api_name,
361: 'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
363: G_MODULE||l_api_name,

Line 362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

358: ' ********************************************************');
359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
360: G_MODULE||l_api_name,
361: 'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
363: G_MODULE||l_api_name,
364: 'p_api_version : '||l_api_version);
365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
366: G_MODULE||l_api_name,

Line 365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

361: 'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
363: G_MODULE||l_api_name,
364: 'p_api_version : '||l_api_version);
365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
366: G_MODULE||l_api_name,
367: 'p_ui_def_id : '||p_ui_def_id);
368: END IF;
369:

Line 392: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

388: );
389:
390:
391: -- debug log
392: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
394: G_MODULE||l_api_name,
395: ' ********************************************************');
396: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

389:
390:
391: -- debug log
392: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
394: G_MODULE||l_api_name,
395: ' ********************************************************');
396: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
397: G_MODULE||l_api_name,

Line 396: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

392: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
394: G_MODULE||l_api_name,
395: ' ********************************************************');
396: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
397: G_MODULE||l_api_name,
398: 'After Calling CZ_CONTRACTS_API_GRP.delete_ui_def ');
399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
400: G_MODULE||l_api_name,

Line 399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

395: ' ********************************************************');
396: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
397: G_MODULE||l_api_name,
398: 'After Calling CZ_CONTRACTS_API_GRP.delete_ui_def ');
399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
400: G_MODULE||l_api_name,
401: 'x_return_status : '||x_return_status);
402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
403: G_MODULE||l_api_name,

Line 402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

398: 'After Calling CZ_CONTRACTS_API_GRP.delete_ui_def ');
399: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
400: G_MODULE||l_api_name,
401: 'x_return_status : '||x_return_status);
402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
403: G_MODULE||l_api_name,
404: ' ********************************************************');
405: END IF;
406:

Line 423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

419: -- Standard call to get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
421:
422: -- end debug log
423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE||l_api_name,
426: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
427: END IF;

Line 424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
421:
422: -- end debug log
423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE||l_api_name,
426: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
427: END IF;
428:

Line 432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

428:
429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
434: G_MODULE||l_api_name,
435: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
436: END IF;

Line 433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
434: G_MODULE||l_api_name,
435: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
436: END IF;
437: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

464:
465: BEGIN
466:
467: -- start debug log
468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
470: G_MODULE||l_api_name,
471: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
472: END IF;

Line 469: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

465: BEGIN
466:
467: -- start debug log
468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
470: G_MODULE||l_api_name,
471: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
472: END IF;
473:

Line 483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

479: -- Initialize API return status to success
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482: -- debug log
483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
485: G_MODULE||l_api_name,
486: ' ********************************************************');
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481:
482: -- debug log
483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
485: G_MODULE||l_api_name,
486: ' ********************************************************');
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
488: G_MODULE||l_api_name,

Line 487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

483: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
485: G_MODULE||l_api_name,
486: ' ********************************************************');
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
488: G_MODULE||l_api_name,
489: 'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
491: G_MODULE||l_api_name,

Line 490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

486: ' ********************************************************');
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
488: G_MODULE||l_api_name,
489: 'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
491: G_MODULE||l_api_name,
492: 'p_api_version : '||l_api_version);
493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
494: G_MODULE||l_api_name,

Line 493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

489: 'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
491: G_MODULE||l_api_name,
492: 'p_api_version : '||l_api_version);
493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
494: G_MODULE||l_api_name,
495: 'p_devl_project_id : '||p_devl_project_id);
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
497: G_MODULE||l_api_name,

Line 496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

492: 'p_api_version : '||l_api_version);
493: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
494: G_MODULE||l_api_name,
495: 'p_devl_project_id : '||p_devl_project_id);
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
497: G_MODULE||l_api_name,
498: 'p_show_all_nodes : '||p_show_all_nodes);
499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
500: G_MODULE||l_api_name,

Line 499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

495: 'p_devl_project_id : '||p_devl_project_id);
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
497: G_MODULE||l_api_name,
498: 'p_show_all_nodes : '||p_show_all_nodes);
499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
500: G_MODULE||l_api_name,
501: 'p_master_template_id : '||p_master_template_id);
502: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
503: G_MODULE||l_api_name,

Line 502: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

498: 'p_show_all_nodes : '||p_show_all_nodes);
499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
500: G_MODULE||l_api_name,
501: 'p_master_template_id : '||p_master_template_id);
502: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
503: G_MODULE||l_api_name,
504: 'p_create_empty_ui : '||p_create_empty_ui);
505: END IF;
506:

Line 535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

531: x_msg_data => x_msg_data
532: );
533:
534: -- debug log
535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
537: G_MODULE||l_api_name,
538: ' ********************************************************');
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

532: );
533:
534: -- debug log
535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
537: G_MODULE||l_api_name,
538: ' ********************************************************');
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
540: G_MODULE||l_api_name,

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
537: G_MODULE||l_api_name,
538: ' ********************************************************');
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
540: G_MODULE||l_api_name,
541: 'After Calling CZ_CONTRACTS_API_GRP.create_jrad_ui ');
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE||l_api_name,

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

538: ' ********************************************************');
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
540: G_MODULE||l_api_name,
541: 'After Calling CZ_CONTRACTS_API_GRP.create_jrad_ui ');
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE||l_api_name,
544: 'x_return_status : '||x_return_status);
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE||l_api_name,

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

541: 'After Calling CZ_CONTRACTS_API_GRP.create_jrad_ui ');
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE||l_api_name,
544: 'x_return_status : '||x_return_status);
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE||l_api_name,
547: 'x_ui_def_id : '||x_ui_def_id);
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
549: G_MODULE||l_api_name,

Line 548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

544: 'x_return_status : '||x_return_status);
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE||l_api_name,
547: 'x_ui_def_id : '||x_ui_def_id);
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
549: G_MODULE||l_api_name,
550: ' ********************************************************');
551: END IF;
552:

Line 569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

565: -- Standard call to get message count and if count is 1, get message info.
566: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
567:
568: -- end debug log
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
571: G_MODULE||l_api_name,
572: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
573: END IF;

Line 570: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

566: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
567:
568: -- end debug log
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
571: G_MODULE||l_api_name,
572: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
573: END IF;
574:

Line 579: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

575:
576:
577: EXCEPTION
578: WHEN OTHERS THEN
579: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
580: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
581: G_MODULE||l_api_name,
582: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
583: END IF;

Line 580: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

576:
577: EXCEPTION
578: WHEN OTHERS THEN
579: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
580: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
581: G_MODULE||l_api_name,
582: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
583: END IF;
584: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

618:
619: BEGIN
620:
621: -- start debug log
622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
624: G_MODULE||l_api_name,
625: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
626: END IF;

Line 623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

619: BEGIN
620:
621: -- start debug log
622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
624: G_MODULE||l_api_name,
625: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
626: END IF;
627:

Line 641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

637: -- Initialize API return status to success
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: -- debug log
641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: ' ********************************************************');
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639:
640: -- debug log
641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: ' ********************************************************');
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: ' ********************************************************');
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,
647: 'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
649: G_MODULE||l_api_name,

Line 648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

644: ' ********************************************************');
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,
647: 'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
649: G_MODULE||l_api_name,
650: 'p_api_version : '||l_api_version);
651: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
652: G_MODULE||l_api_name,

Line 651: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

647: 'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
649: G_MODULE||l_api_name,
650: 'p_api_version : '||l_api_version);
651: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
652: G_MODULE||l_api_name,
653: 'p_devl_project_id : '||p_devl_project_id);
654: END IF;
655:

Line 684: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

680:
681: );
682:
683: -- debug log
684: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
686: G_MODULE||l_api_name,
687: ' ********************************************************');
688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

681: );
682:
683: -- debug log
684: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
686: G_MODULE||l_api_name,
687: ' ********************************************************');
688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
689: G_MODULE||l_api_name,

Line 688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

684: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
686: G_MODULE||l_api_name,
687: ' ********************************************************');
688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
689: G_MODULE||l_api_name,
690: 'After Calling CZ_CONTRACTS_API_GRP.generate_logic ');
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
692: G_MODULE||l_api_name,

Line 691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

687: ' ********************************************************');
688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
689: G_MODULE||l_api_name,
690: 'After Calling CZ_CONTRACTS_API_GRP.generate_logic ');
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
692: G_MODULE||l_api_name,
693: 'x_status : '||x_return_status);
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
695: G_MODULE||l_api_name,

Line 694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

690: 'After Calling CZ_CONTRACTS_API_GRP.generate_logic ');
691: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
692: G_MODULE||l_api_name,
693: 'x_status : '||x_return_status);
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
695: G_MODULE||l_api_name,
696: 'x_run_id : '||x_run_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
698: G_MODULE||l_api_name,

Line 697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

693: 'x_status : '||x_return_status);
694: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
695: G_MODULE||l_api_name,
696: 'x_run_id : '||x_run_id);
697: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
698: G_MODULE||l_api_name,
699: ' ********************************************************');
700: END IF;
701:

Line 733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

729: -- Standard call to get message count and if count is 1, get message info.
730: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
731:
732: -- end debug log
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
735: G_MODULE||l_api_name,
736: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
737: END IF;

Line 734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

730: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
731:
732: -- end debug log
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
735: G_MODULE||l_api_name,
736: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
737: END IF;
738:

Line 741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

737: END IF;
738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
743: G_MODULE||l_api_name,
744: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
745: END IF;

Line 742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
743: G_MODULE||l_api_name,
744: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
745: END IF;
746: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

770:
771: BEGIN
772:
773: -- start debug log
774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
776: G_MODULE||l_api_name,
777: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
778: END IF;

Line 775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

771: BEGIN
772:
773: -- start debug log
774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
776: G_MODULE||l_api_name,
777: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
778: END IF;
779:

Line 793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

789: -- Initialize API return status to success
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: -- debug log
793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
795: G_MODULE||l_api_name,
796: ' ********************************************************');
797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: -- debug log
793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
795: G_MODULE||l_api_name,
796: ' ********************************************************');
797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
798: G_MODULE||l_api_name,

Line 797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
795: G_MODULE||l_api_name,
796: ' ********************************************************');
797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
798: G_MODULE||l_api_name,
799: 'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
801: G_MODULE||l_api_name,

Line 800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

796: ' ********************************************************');
797: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
798: G_MODULE||l_api_name,
799: 'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
801: G_MODULE||l_api_name,
802: 'p_api_version : '||l_api_version);
803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
804: G_MODULE||l_api_name,

Line 803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

799: 'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
801: G_MODULE||l_api_name,
802: 'p_api_version : '||l_api_version);
803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
804: G_MODULE||l_api_name,
805: 'p_publication_id : '||p_publication_id);
806: END IF;
807:

Line 830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

826: x_msg_data => x_msg_data
827: );
828:
829: -- debug log
830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
832: G_MODULE||l_api_name,
833: ' ********************************************************');
834: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

827: );
828:
829: -- debug log
830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
832: G_MODULE||l_api_name,
833: ' ********************************************************');
834: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
835: G_MODULE||l_api_name,

Line 834: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
832: G_MODULE||l_api_name,
833: ' ********************************************************');
834: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
835: G_MODULE||l_api_name,
836: 'After Calling CZ_CONTRACTS_API_GRP.delete_publication ');
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
838: G_MODULE||l_api_name,

Line 837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

833: ' ********************************************************');
834: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
835: G_MODULE||l_api_name,
836: 'After Calling CZ_CONTRACTS_API_GRP.delete_publication ');
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
838: G_MODULE||l_api_name,
839: 'x_return_status : '||x_return_status);
840: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
841: G_MODULE||l_api_name,

Line 840: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

836: 'After Calling CZ_CONTRACTS_API_GRP.delete_publication ');
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
838: G_MODULE||l_api_name,
839: 'x_return_status : '||x_return_status);
840: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
841: G_MODULE||l_api_name,
842: 'x_msg_count : '||x_msg_count);
843: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
844: G_MODULE||l_api_name,

Line 843: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

839: 'x_return_status : '||x_return_status);
840: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
841: G_MODULE||l_api_name,
842: 'x_msg_count : '||x_msg_count);
843: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
844: G_MODULE||l_api_name,
845: 'x_msg_data : '||x_msg_data);
846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
847: G_MODULE||l_api_name,

Line 846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

842: 'x_msg_count : '||x_msg_count);
843: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
844: G_MODULE||l_api_name,
845: 'x_msg_data : '||x_msg_data);
846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
847: G_MODULE||l_api_name,
848: ' ********************************************************');
849: END IF;
850:

Line 866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
864:
865: -- end debug log
866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
868: G_MODULE||l_api_name,
869: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
870: END IF;

Line 867: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

863: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
864:
865: -- end debug log
866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
868: G_MODULE||l_api_name,
869: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
870: END IF;
871:

Line 874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

870: END IF;
871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
875: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
876: G_MODULE||l_api_name,
877: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
878: END IF;

Line 875: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
875: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
876: G_MODULE||l_api_name,
877: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
878: END IF;
879: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

926:
927: BEGIN
928:
929: -- start debug log
930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
932: G_MODULE||l_api_name,
933: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
934: END IF;

Line 931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

927: BEGIN
928:
929: -- start debug log
930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
932: G_MODULE||l_api_name,
933: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
934: END IF;
935:

Line 993: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

989: END LOOP;
990: CLOSE csr_get_publication_dtl;
991:
992: -- debug log
993: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
995: G_MODULE||l_api_name,
996: ' ********************************************************');
997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

990: CLOSE csr_get_publication_dtl;
991:
992: -- debug log
993: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
995: G_MODULE||l_api_name,
996: ' ********************************************************');
997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
998: G_MODULE||l_api_name,

Line 997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

993: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
995: G_MODULE||l_api_name,
996: ' ********************************************************');
997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
998: G_MODULE||l_api_name,
999: 'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1001: G_MODULE||l_api_name,

Line 1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

996: ' ********************************************************');
997: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
998: G_MODULE||l_api_name,
999: 'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1001: G_MODULE||l_api_name,
1002: 'p_api_version : '||l_api_version);
1003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1004: G_MODULE||l_api_name,

Line 1003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

999: 'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1000: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1001: G_MODULE||l_api_name,
1002: 'p_api_version : '||l_api_version);
1003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1004: G_MODULE||l_api_name,
1005: 'p_model_id : '||p_devl_project_id);
1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1007: G_MODULE||l_api_name,

Line 1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1002: 'p_api_version : '||l_api_version);
1003: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1004: G_MODULE||l_api_name,
1005: 'p_model_id : '||p_devl_project_id);
1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1007: G_MODULE||l_api_name,
1008: 'p_ui_def_id : '||p_ui_def_id);
1009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1010: G_MODULE||l_api_name,

Line 1009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1005: 'p_model_id : '||p_devl_project_id);
1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1007: G_MODULE||l_api_name,
1008: 'p_ui_def_id : '||p_ui_def_id);
1009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1010: G_MODULE||l_api_name,
1011: 'p_publication_mode : '||p_publication_mode);
1012: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1013: G_MODULE||l_api_name,

Line 1012: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1008: 'p_ui_def_id : '||p_ui_def_id);
1009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1010: G_MODULE||l_api_name,
1011: 'p_publication_mode : '||p_publication_mode);
1012: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1013: G_MODULE||l_api_name,
1014: 'p_server_id : '||l_server_id);
1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1016: G_MODULE||l_api_name,

Line 1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1011: 'p_publication_mode : '||p_publication_mode);
1012: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1013: G_MODULE||l_api_name,
1014: 'p_server_id : '||l_server_id);
1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1016: G_MODULE||l_api_name,
1017: 'l_appl_id_tbl(1) : 510');
1018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1019: G_MODULE||l_api_name,

Line 1018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1014: 'p_server_id : '||l_server_id);
1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1016: G_MODULE||l_api_name,
1017: 'l_appl_id_tbl(1) : 510');
1018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1019: G_MODULE||l_api_name,
1020: 'l_usg_id_tbl(1) : -1');
1021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1022: G_MODULE||l_api_name,

Line 1021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1017: 'l_appl_id_tbl(1) : 510');
1018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1019: G_MODULE||l_api_name,
1020: 'l_usg_id_tbl(1) : -1');
1021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1022: G_MODULE||l_api_name,
1023: 'p_start_date : '||l_start_date);
1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1025: G_MODULE||l_api_name,

Line 1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1020: 'l_usg_id_tbl(1) : -1');
1021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1022: G_MODULE||l_api_name,
1023: 'p_start_date : '||l_start_date);
1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1025: G_MODULE||l_api_name,
1026: 'p_end_date : '||l_end_date);
1027: END IF;
1028:

Line 1067: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1063: x_msg_count => x_msg_count,
1064: x_msg_data => x_msg_data
1065: );
1066: -- debug log
1067: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1068: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1069: G_MODULE||l_api_name,
1070: ' ********************************************************');
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1068: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1064: x_msg_data => x_msg_data
1065: );
1066: -- debug log
1067: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1068: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1069: G_MODULE||l_api_name,
1070: ' ********************************************************');
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1072: G_MODULE||l_api_name,

Line 1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1067: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1068: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1069: G_MODULE||l_api_name,
1070: ' ********************************************************');
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1072: G_MODULE||l_api_name,
1073: 'After Calling CZ_CONTRACTS_API_GRP.create_publication_request ');
1074: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1075: G_MODULE||l_api_name,

Line 1074: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1070: ' ********************************************************');
1071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1072: G_MODULE||l_api_name,
1073: 'After Calling CZ_CONTRACTS_API_GRP.create_publication_request ');
1074: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1075: G_MODULE||l_api_name,
1076: 'x_publication_id : '||x_publication_id);
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1078: G_MODULE||l_api_name,

Line 1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1073: 'After Calling CZ_CONTRACTS_API_GRP.create_publication_request ');
1074: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1075: G_MODULE||l_api_name,
1076: 'x_publication_id : '||x_publication_id);
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1078: G_MODULE||l_api_name,
1079: 'x_return_status : '||x_return_status);
1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1081: G_MODULE||l_api_name,

Line 1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1076: 'x_publication_id : '||x_publication_id);
1077: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1078: G_MODULE||l_api_name,
1079: 'x_return_status : '||x_return_status);
1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1081: G_MODULE||l_api_name,
1082: 'x_msg_count : '||x_msg_count);
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1084: G_MODULE||l_api_name,

Line 1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1079: 'x_return_status : '||x_return_status);
1080: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1081: G_MODULE||l_api_name,
1082: 'x_msg_count : '||x_msg_count);
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1084: G_MODULE||l_api_name,
1085: 'x_msg_data : '||x_msg_data);
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1087: G_MODULE||l_api_name,

Line 1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1082: 'x_msg_count : '||x_msg_count);
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1084: G_MODULE||l_api_name,
1085: 'x_msg_data : '||x_msg_data);
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1087: G_MODULE||l_api_name,
1088: ' ********************************************************');
1089: END IF;
1090:

Line 1108: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1104: -- Standard call to get message count and if count is 1, get message info.
1105: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1106:
1107: -- end debug log
1108: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1109: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1110: G_MODULE||l_api_name,
1111: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1112: END IF;

Line 1109: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1105: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1106:
1107: -- end debug log
1108: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1109: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1110: G_MODULE||l_api_name,
1111: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1112: END IF;
1113:

Line 1116: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1112: END IF;
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1118: G_MODULE||l_api_name,
1119: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1120: END IF;

Line 1117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1118: G_MODULE||l_api_name,
1119: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1120: END IF;
1121: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1164: --
1165: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1166:
1167: -- start debug log
1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1170: G_MODULE||l_api_name,
1171: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1165: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1166:
1167: -- start debug log
1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1170: G_MODULE||l_api_name,
1171: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1173: G_MODULE||l_api_name,

Line 1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1168: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1170: G_MODULE||l_api_name,
1171: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1173: G_MODULE||l_api_name,
1174: '100: Parameters ');
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1176: G_MODULE||l_api_name,

Line 1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1171: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1173: G_MODULE||l_api_name,
1174: '100: Parameters ');
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1176: G_MODULE||l_api_name,
1177: '100: p_api_version : '||p_api_version);
1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1179: G_MODULE||l_api_name,

Line 1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1174: '100: Parameters ');
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1176: G_MODULE||l_api_name,
1177: '100: p_api_version : '||p_api_version);
1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1179: G_MODULE||l_api_name,
1180: '100: p_init_msg_list : '||p_init_msg_list);
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1182: G_MODULE||l_api_name,

Line 1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1177: '100: p_api_version : '||p_api_version);
1178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1179: G_MODULE||l_api_name,
1180: '100: p_init_msg_list : '||p_init_msg_list);
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1182: G_MODULE||l_api_name,
1183: '100: p_config_header_id : '||p_config_header_id);
1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1185: G_MODULE||l_api_name,

Line 1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1180: '100: p_init_msg_list : '||p_init_msg_list);
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1182: G_MODULE||l_api_name,
1183: '100: p_config_header_id : '||p_config_header_id);
1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1185: G_MODULE||l_api_name,
1186: '100: p_config_rev_nbr : '||p_config_rev_nbr);
1187: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1188: G_MODULE||l_api_name,

Line 1187: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1183: '100: p_config_header_id : '||p_config_header_id);
1184: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1185: G_MODULE||l_api_name,
1186: '100: p_config_rev_nbr : '||p_config_rev_nbr);
1187: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1188: G_MODULE||l_api_name,
1189: '100: p_new_config_flag : '||p_new_config_flag);
1190: END IF;
1191:

Line 1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1230: x_new_config_header_id := l_x_config_header_id;
1231: x_new_config_rev_nbr := l_x_config_rev_nbr;
1232:
1233: -- end debug log
1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1236: G_MODULE||l_api_name,
1237: '1000: x_new_config_header_id : '||l_x_config_header_id);
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1231: x_new_config_rev_nbr := l_x_config_rev_nbr;
1232:
1233: -- end debug log
1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1236: G_MODULE||l_api_name,
1237: '1000: x_new_config_header_id : '||l_x_config_header_id);
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1239: G_MODULE||l_api_name,

Line 1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1236: G_MODULE||l_api_name,
1237: '1000: x_new_config_header_id : '||l_x_config_header_id);
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1239: G_MODULE||l_api_name,
1240: '1000: x_new_config_rev_nbr : '||l_x_config_rev_nbr);
1241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1242: G_MODULE||l_api_name,

Line 1241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1237: '1000: x_new_config_header_id : '||l_x_config_header_id);
1238: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1239: G_MODULE||l_api_name,
1240: '1000: x_new_config_rev_nbr : '||l_x_config_rev_nbr);
1241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1242: G_MODULE||l_api_name,
1243: '1000: x_return_status : '||x_return_status);
1244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1245: G_MODULE||l_api_name,

Line 1244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1240: '1000: x_new_config_rev_nbr : '||l_x_config_rev_nbr);
1241: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1242: G_MODULE||l_api_name,
1243: '1000: x_return_status : '||x_return_status);
1244: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1245: G_MODULE||l_api_name,
1246: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1247: END IF;
1248:

Line 1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1312: -- Check Debug Value
1313: --
1314: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1315: -- start debug log
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1318: G_MODULE||l_api_name,
1319: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1313: --
1314: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1315: -- start debug log
1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1318: G_MODULE||l_api_name,
1319: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1321: G_MODULE||l_api_name,

Line 1320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1318: G_MODULE||l_api_name,
1319: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1321: G_MODULE||l_api_name,
1322: '100: Parameters ');
1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1324: G_MODULE||l_api_name,

Line 1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1319: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1321: G_MODULE||l_api_name,
1322: '100: Parameters ');
1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1324: G_MODULE||l_api_name,
1325: '100: p_api_version : '||p_api_version);
1326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1327: G_MODULE||l_api_name,

Line 1326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1322: '100: Parameters ');
1323: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1324: G_MODULE||l_api_name,
1325: '100: p_api_version : '||p_api_version);
1326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1327: G_MODULE||l_api_name,
1328: '100: p_init_msg_list : '||p_init_msg_list);
1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1330: G_MODULE||l_api_name,

Line 1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1325: '100: p_api_version : '||p_api_version);
1326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1327: G_MODULE||l_api_name,
1328: '100: p_init_msg_list : '||p_init_msg_list);
1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1330: G_MODULE||l_api_name,
1331: '100: p_config_header_id : '||p_config_header_id);
1332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1333: G_MODULE||l_api_name,

Line 1332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1328: '100: p_init_msg_list : '||p_init_msg_list);
1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1330: G_MODULE||l_api_name,
1331: '100: p_config_header_id : '||p_config_header_id);
1332: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1333: G_MODULE||l_api_name,
1334: '100: p_config_rev_nbr : '||p_config_rev_nbr);
1335: END IF;
1336:

Line 1361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1357: END IF;
1358:
1359:
1360: -- end debug log
1361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1363: G_MODULE||l_api_name,
1364: '1000: x_return_status : '||x_return_status);
1365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1358:
1359:
1360: -- end debug log
1361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1363: G_MODULE||l_api_name,
1364: '1000: x_return_status : '||x_return_status);
1365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1366: G_MODULE||l_api_name,

Line 1365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1363: G_MODULE||l_api_name,
1364: '1000: x_return_status : '||x_return_status);
1365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1366: G_MODULE||l_api_name,
1367: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1368: END IF;
1369:

Line 1453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1449: --
1450: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1451:
1452: -- start debug log
1453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1455: G_MODULE||l_api_name,
1456: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1450: l_package_procedure := G_PKG_NAME || '.' || l_api_name;
1451:
1452: -- start debug log
1453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1455: G_MODULE||l_api_name,
1456: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1458: G_MODULE||l_api_name,

Line 1457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1453: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1454: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1455: G_MODULE||l_api_name,
1456: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1458: G_MODULE||l_api_name,
1459: '100: Parameters ');
1460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1461: G_MODULE||l_api_name,

Line 1460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1456: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1457: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1458: G_MODULE||l_api_name,
1459: '100: Parameters ');
1460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1461: G_MODULE||l_api_name,
1462: '100: p_api_version : '||p_api_version);
1463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1464: G_MODULE||l_api_name,

Line 1463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1459: '100: Parameters ');
1460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1461: G_MODULE||l_api_name,
1462: '100: p_api_version : '||p_api_version);
1463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1464: G_MODULE||l_api_name,
1465: '100: p_init_msg_list : '||p_init_msg_list);
1466: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1467: G_MODULE||l_api_name,

Line 1466: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1462: '100: p_api_version : '||p_api_version);
1463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1464: G_MODULE||l_api_name,
1465: '100: p_init_msg_list : '||p_init_msg_list);
1466: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1467: G_MODULE||l_api_name,
1468: '100: p_cz_xml_init_msg : '||p_cz_xml_init_msg);
1469: END IF;
1470:

Line 1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1486: p_validation_type => CZ_API_PUB.VALIDATE_ORDER);
1487:
1488:
1489: -- debug log
1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1492: G_MODULE||l_api_name,
1493: '100: validation_status : '||l_x_validation_status);
1494: END IF;

Line 1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1487:
1488:
1489: -- debug log
1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1492: G_MODULE||l_api_name,
1493: '100: validation_status : '||l_x_validation_status);
1494: END IF;
1495:

Line 1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1499: THEN
1500: l_rec_index := l_cfg_output_pieces.FIRST;
1501: LOOP
1502: -- debug log
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1505: G_MODULE||l_api_name,
1506: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1,255))));
1507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1500: l_rec_index := l_cfg_output_pieces.FIRST;
1501: LOOP
1502: -- debug log
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1505: G_MODULE||l_api_name,
1506: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1,255))));
1507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1508: G_MODULE||l_api_name,

Line 1507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1505: G_MODULE||l_api_name,
1506: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1,255))));
1507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1508: G_MODULE||l_api_name,
1509: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),256,255))));
1510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1511: G_MODULE||l_api_name,

Line 1510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1506: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1,255))));
1507: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1508: G_MODULE||l_api_name,
1509: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),256,255))));
1510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1511: G_MODULE||l_api_name,
1512: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),512,255))));
1513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1514: G_MODULE||l_api_name,

Line 1513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1509: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),256,255))));
1510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1511: G_MODULE||l_api_name,
1512: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),512,255))));
1513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1514: G_MODULE||l_api_name,
1515: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),768,255))));
1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1517: G_MODULE||l_api_name,

Line 1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1512: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),512,255))));
1513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1514: G_MODULE||l_api_name,
1515: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),768,255))));
1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1517: G_MODULE||l_api_name,
1518: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1024,255))));
1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1520: G_MODULE||l_api_name,

Line 1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1515: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),768,255))));
1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1517: G_MODULE||l_api_name,
1518: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1024,255))));
1519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1520: G_MODULE||l_api_name,
1521: '100: cz terminate msg = '||ltrim(rtrim(substr(l_cfg_output_pieces(l_rec_index),1280,255))));
1522: END IF; -- debug log
1523:

Line 1586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1582: x_cz_xml_terminate_msg := l_long_xml;
1583:
1584:
1585: -- end debug log
1586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1588: G_MODULE||l_api_name,
1589: '1000: x_return_status : '||x_return_status);
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1583:
1584:
1585: -- end debug log
1586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1588: G_MODULE||l_api_name,
1589: '1000: x_return_status : '||x_return_status);
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1591: G_MODULE||l_api_name,

Line 1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1588: G_MODULE||l_api_name,
1589: '1000: x_return_status : '||x_return_status);
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1591: G_MODULE||l_api_name,
1592: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1593: END IF;
1594:

Line 1673: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1669:
1670: BEGIN
1671:
1672: -- start debug log
1673: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1674: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1675: G_MODULE||l_api_name,
1676: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1677: END IF;

Line 1674: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1670: BEGIN
1671:
1672: -- start debug log
1673: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1674: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1675: G_MODULE||l_api_name,
1676: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1677: END IF;
1678:

Line 1704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1700: l_startdate := G_CZ_EPOCH_BEGIN; -- Need to change to CZ_CONTRACTS_API_GRP once available
1701: l_disabledate := G_CZ_EPOCH_END; -- Need to change to CZ_CONTRACTS_API_GRP once available
1702:
1703: -- debug log
1704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1706: G_MODULE||l_api_name,
1707: ' ********************************************************');
1708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1701: l_disabledate := G_CZ_EPOCH_END; -- Need to change to CZ_CONTRACTS_API_GRP once available
1702:
1703: -- debug log
1704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1706: G_MODULE||l_api_name,
1707: ' ********************************************************');
1708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1709: G_MODULE||l_api_name,

Line 1708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1706: G_MODULE||l_api_name,
1707: ' ********************************************************');
1708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1709: G_MODULE||l_api_name,
1710: 'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1712: G_MODULE||l_api_name,

Line 1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1707: ' ********************************************************');
1708: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1709: G_MODULE||l_api_name,
1710: 'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1712: G_MODULE||l_api_name,
1713: 'p_api_version : '||l_api_version);
1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1715: G_MODULE||l_api_name,

Line 1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1710: 'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1712: G_MODULE||l_api_name,
1713: 'p_api_version : '||l_api_version);
1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1715: G_MODULE||l_api_name,
1716: 'p_publication_id : '||p_publication_id);
1717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1718: G_MODULE||l_api_name,

Line 1717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1713: 'p_api_version : '||l_api_version);
1714: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1715: G_MODULE||l_api_name,
1716: 'p_publication_id : '||p_publication_id);
1717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1718: G_MODULE||l_api_name,
1719: 'p_publication_mode : '||p_publication_mode);
1720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1721: G_MODULE||l_api_name,

Line 1720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1716: 'p_publication_id : '||p_publication_id);
1717: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1718: G_MODULE||l_api_name,
1719: 'p_publication_mode : '||p_publication_mode);
1720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1721: G_MODULE||l_api_name,
1722: 'p_applicationId(1) : 510');
1723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1724: G_MODULE||l_api_name,

Line 1723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1719: 'p_publication_mode : '||p_publication_mode);
1720: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1721: G_MODULE||l_api_name,
1722: 'p_applicationId(1) : 510');
1723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1724: G_MODULE||l_api_name,
1725: 'p_usageId(1) : -1');
1726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1727: G_MODULE||l_api_name,

Line 1726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1722: 'p_applicationId(1) : 510');
1723: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1724: G_MODULE||l_api_name,
1725: 'p_usageId(1) : -1');
1726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1727: G_MODULE||l_api_name,
1728: 'p_startdate : '||l_startdate);
1729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1730: G_MODULE||l_api_name,

Line 1729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1725: 'p_usageId(1) : -1');
1726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1727: G_MODULE||l_api_name,
1728: 'p_startdate : '||l_startdate);
1729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1730: G_MODULE||l_api_name,
1731: 'p_disabledate : '||l_disabledate);
1732: END IF;
1733:

Line 1769: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1765: );
1766:
1767:
1768: -- debug log
1769: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1771: G_MODULE||l_api_name,
1772: ' ********************************************************');
1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1766:
1767:
1768: -- debug log
1769: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1771: G_MODULE||l_api_name,
1772: ' ********************************************************');
1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1774: G_MODULE||l_api_name,

Line 1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1769: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1771: G_MODULE||l_api_name,
1772: ' ********************************************************');
1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1774: G_MODULE||l_api_name,
1775: 'After Calling CZ_CONTRACTS_API_GRP.edit_publication ');
1776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1777: G_MODULE||l_api_name,

Line 1776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1772: ' ********************************************************');
1773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1774: G_MODULE||l_api_name,
1775: 'After Calling CZ_CONTRACTS_API_GRP.edit_publication ');
1776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1777: G_MODULE||l_api_name,
1778: 'x_return_status : '||x_return_status);
1779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1780: G_MODULE||l_api_name,

Line 1779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1775: 'After Calling CZ_CONTRACTS_API_GRP.edit_publication ');
1776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1777: G_MODULE||l_api_name,
1778: 'x_return_status : '||x_return_status);
1779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1780: G_MODULE||l_api_name,
1781: 'x_msg_count : '||x_msg_count);
1782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1783: G_MODULE||l_api_name,

Line 1782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1778: 'x_return_status : '||x_return_status);
1779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1780: G_MODULE||l_api_name,
1781: 'x_msg_count : '||x_msg_count);
1782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1783: G_MODULE||l_api_name,
1784: 'x_msg_data : '||x_msg_data);
1785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1786: G_MODULE||l_api_name,

Line 1785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1781: 'x_msg_count : '||x_msg_count);
1782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1783: G_MODULE||l_api_name,
1784: 'x_msg_data : '||x_msg_data);
1785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1786: G_MODULE||l_api_name,
1787: ' ********************************************************');
1788: END IF;
1789:

Line 1807: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1803: -- Standard call to get message count and if count is 1, get message info.
1804: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1805:
1806: -- end debug log
1807: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1809: G_MODULE||l_api_name,
1810: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1811: END IF;

Line 1808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1804: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1805:
1806: -- end debug log
1807: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1809: G_MODULE||l_api_name,
1810: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1811: END IF;
1812:

Line 1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1811: END IF;
1812:
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1817: G_MODULE||l_api_name,
1818: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1819: END IF;

Line 1816: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1812:
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1817: G_MODULE||l_api_name,
1818: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1819: END IF;
1820: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1854:
1855: BEGIN
1856:
1857: -- start debug log
1858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1860: G_MODULE||l_api_name,
1861: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1862: END IF;

Line 1859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1855: BEGIN
1856:
1857: -- start debug log
1858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1860: G_MODULE||l_api_name,
1861: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1862: END IF;
1863:

Line 1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1873: -- Initialize API return status to success
1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875:
1876: -- debug log
1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1879: G_MODULE||l_api_name,
1880: ' ********************************************************');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1874: x_return_status := FND_API.G_RET_STS_SUCCESS;
1875:
1876: -- debug log
1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1879: G_MODULE||l_api_name,
1880: ' ********************************************************');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1882: G_MODULE||l_api_name,

Line 1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1879: G_MODULE||l_api_name,
1880: ' ********************************************************');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1882: G_MODULE||l_api_name,
1883: 'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1885: G_MODULE||l_api_name,

Line 1884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1880: ' ********************************************************');
1881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1882: G_MODULE||l_api_name,
1883: 'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1885: G_MODULE||l_api_name,
1886: 'p_api_version : '||l_api_version);
1887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1888: G_MODULE||l_api_name,

Line 1887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1883: 'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1884: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1885: G_MODULE||l_api_name,
1886: 'p_api_version : '||l_api_version);
1887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1888: G_MODULE||l_api_name,
1889: 'p_devl_project_id : '||p_publication_id);
1890: END IF;
1891:

Line 1920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1916:
1917: );
1918:
1919: -- debug log
1920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1922: G_MODULE||l_api_name,
1923: ' ********************************************************');
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1917: );
1918:
1919: -- debug log
1920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1922: G_MODULE||l_api_name,
1923: ' ********************************************************');
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1925: G_MODULE||l_api_name,

Line 1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1922: G_MODULE||l_api_name,
1923: ' ********************************************************');
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1925: G_MODULE||l_api_name,
1926: 'After Calling CZ_CONTRACTS_API_GRP.publish_model ');
1927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1928: G_MODULE||l_api_name,

Line 1927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1923: ' ********************************************************');
1924: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1925: G_MODULE||l_api_name,
1926: 'After Calling CZ_CONTRACTS_API_GRP.publish_model ');
1927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1928: G_MODULE||l_api_name,
1929: 'x_status : '||x_return_status);
1930: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1931: G_MODULE||l_api_name,

Line 1930: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1926: 'After Calling CZ_CONTRACTS_API_GRP.publish_model ');
1927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1928: G_MODULE||l_api_name,
1929: 'x_status : '||x_return_status);
1930: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1931: G_MODULE||l_api_name,
1932: 'x_run_id : '||x_run_id);
1933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1934: G_MODULE||l_api_name,

Line 1933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1929: 'x_status : '||x_return_status);
1930: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1931: G_MODULE||l_api_name,
1932: 'x_run_id : '||x_run_id);
1933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1934: G_MODULE||l_api_name,
1935: ' ********************************************************');
1936: END IF;
1937:

Line 1968: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1964: -- Standard call to get message count and if count is 1, get message info.
1965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1966:
1967: -- end debug log
1968: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1970: G_MODULE||l_api_name,
1971: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1972: END IF;

Line 1969: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1965: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1966:
1967: -- end debug log
1968: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1969: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1970: G_MODULE||l_api_name,
1971: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1972: END IF;
1973:

Line 1976: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1972: END IF;
1973:
1974: EXCEPTION
1975: WHEN OTHERS THEN
1976: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1978: G_MODULE||l_api_name,
1979: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1980: END IF;

Line 1977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1973:
1974: EXCEPTION
1975: WHEN OTHERS THEN
1976: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1977: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1978: G_MODULE||l_api_name,
1979: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1980: END IF;
1981: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2009:
2010: BEGIN
2011:
2012: -- start debug log
2013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2015: G_MODULE||l_api_name,
2016: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2017: END IF;

Line 2014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2010: BEGIN
2011:
2012: -- start debug log
2013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2015: G_MODULE||l_api_name,
2016: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2017: END IF;
2018:

Line 2032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2028: -- Initialize API return status to success
2029: x_return_status := FND_API.G_RET_STS_SUCCESS;
2030:
2031: -- debug log
2032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2034: G_MODULE||l_api_name,
2035: ' ********************************************************');
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2029: x_return_status := FND_API.G_RET_STS_SUCCESS;
2030:
2031: -- debug log
2032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2034: G_MODULE||l_api_name,
2035: ' ********************************************************');
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2037: G_MODULE||l_api_name,

Line 2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2034: G_MODULE||l_api_name,
2035: ' ********************************************************');
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2037: G_MODULE||l_api_name,
2038: 'Calling CZ_CF_API.publication_for_product with parameters');
2039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2040: G_MODULE||l_api_name,

Line 2039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2035: ' ********************************************************');
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2037: G_MODULE||l_api_name,
2038: 'Calling CZ_CF_API.publication_for_product with parameters');
2039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2040: G_MODULE||l_api_name,
2041: 'p_api_version : '||l_api_version);
2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2043: G_MODULE||l_api_name,

Line 2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2038: 'Calling CZ_CF_API.publication_for_product with parameters');
2039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2040: G_MODULE||l_api_name,
2041: 'p_api_version : '||l_api_version);
2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2043: G_MODULE||l_api_name,
2044: 'p_product_key : '||p_product_key);
2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2046: G_MODULE||l_api_name,

Line 2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2041: 'p_api_version : '||l_api_version);
2042: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2043: G_MODULE||l_api_name,
2044: 'p_product_key : '||p_product_key);
2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2046: G_MODULE||l_api_name,
2047: 'p_usage_name : '||p_usage_name);
2048: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2049: G_MODULE||l_api_name,

Line 2048: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2044: 'p_product_key : '||p_product_key);
2045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2046: G_MODULE||l_api_name,
2047: 'p_usage_name : '||p_usage_name);
2048: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2049: G_MODULE||l_api_name,
2050: 'p_publication_mode : '||p_publication_mode);
2051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2052: G_MODULE||l_api_name,

Line 2051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2047: 'p_usage_name : '||p_usage_name);
2048: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2049: G_MODULE||l_api_name,
2050: 'p_publication_mode : '||p_publication_mode);
2051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2052: G_MODULE||l_api_name,
2053: 'p_effective_date : '||p_effective_date);
2054: END IF;
2055:

Line 2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2064: );
2065:
2066:
2067: -- debug log
2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2070: G_MODULE||l_api_name,
2071: ' ********************************************************');
2072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2065:
2066:
2067: -- debug log
2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2070: G_MODULE||l_api_name,
2071: ' ********************************************************');
2072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2073: G_MODULE||l_api_name,

Line 2072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2068: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2070: G_MODULE||l_api_name,
2071: ' ********************************************************');
2072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2073: G_MODULE||l_api_name,
2074: 'After Calling CZ_CF_API.publication_for_product with parameters');
2075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2076: G_MODULE||l_api_name,

Line 2075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2071: ' ********************************************************');
2072: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2073: G_MODULE||l_api_name,
2074: 'After Calling CZ_CF_API.publication_for_product with parameters');
2075: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2076: G_MODULE||l_api_name,
2077: 'x_publication_id : '||x_publication_id);
2078: END IF;
2079:

Line 2086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2082: -- Standard call to get message count and if count is 1, get message info.
2083: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2084:
2085: -- end debug log
2086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2088: G_MODULE||l_api_name,
2089: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2090: END IF;

Line 2087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2083: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2084:
2085: -- end debug log
2086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2088: G_MODULE||l_api_name,
2089: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2090: END IF;
2091:

Line 2094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2090: END IF;
2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2096: G_MODULE||l_api_name,
2097: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2098: END IF;

Line 2095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2096: G_MODULE||l_api_name,
2097: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2098: END IF;
2099: x_return_status := G_RET_STS_UNEXP_ERROR ;