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

APPS.OKC_XPRT_CZ_INT_PVT dependencies on FND_FILE

Line 82: fnd_file.put_line(FND_FILE.LOG,' ');

78: 'p_rp_folder_id : '||p_rp_folder_id);
79: END IF;
80:
81: -- Put the parameters in log file
82: fnd_file.put_line(FND_FILE.LOG,' ');
83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);

Line 83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

79: END IF;
80:
81: -- Put the parameters in log file
82: fnd_file.put_line(FND_FILE.LOG,' ');
83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);

Line 84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');

80:
81: -- Put the parameters in log file
82: fnd_file.put_line(FND_FILE.LOG,' ');
83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

81: -- Put the parameters in log file
82: fnd_file.put_line(FND_FILE.LOG,' ');
83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);

82: fnd_file.put_line(FND_FILE.LOG,' ');
83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
90: fnd_file.put_line(FND_FILE.LOG,' ');

Line 87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);

83: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
90: fnd_file.put_line(FND_FILE.LOG,' ');
91:

Line 88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

84: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.import_generic with parameters');
85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
90: fnd_file.put_line(FND_FILE.LOG,' ');
91:
92: -- Call the CZ Generic Import API

Line 89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

85: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
90: fnd_file.put_line(FND_FILE.LOG,' ');
91:
92: -- Call the CZ Generic Import API
93: CZ_CONTRACTS_API_GRP.import_generic

Line 90: fnd_file.put_line(FND_FILE.LOG,' ');

86: fnd_file.put_line(FND_FILE.LOG,'p_run_id: '||p_run_id);
87: fnd_file.put_line(FND_FILE.LOG,'p_rp_folder_id: '||p_rp_folder_id);
88: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
89: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
90: fnd_file.put_line(FND_FILE.LOG,' ');
91:
92: -- Call the CZ Generic Import API
93: CZ_CONTRACTS_API_GRP.import_generic
94: (

Line 122: fnd_file.put_line(FND_FILE.LOG,' ');

118: ' ********************************************************');
119: END IF;
120:
121: -- Put the parameters in log file
122: fnd_file.put_line(FND_FILE.LOG,' ');
123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);

Line 123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

119: END IF;
120:
121: -- Put the parameters in log file
122: fnd_file.put_line(FND_FILE.LOG,' ');
123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');

120:
121: -- Put the parameters in log file
122: fnd_file.put_line(FND_FILE.LOG,' ');
123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);

121: -- Put the parameters in log file
122: fnd_file.put_line(FND_FILE.LOG,' ');
123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
129: fnd_file.put_line(FND_FILE.LOG,' ');

Line 126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);

122: fnd_file.put_line(FND_FILE.LOG,' ');
123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
129: fnd_file.put_line(FND_FILE.LOG,' ');
130:

Line 127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

123: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
129: fnd_file.put_line(FND_FILE.LOG,' ');
130:
131:

Line 128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

124: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.import_generic');
125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
129: fnd_file.put_line(FND_FILE.LOG,' ');
130:
131:
132: IF l_cz_return_status = G_CZ_STATUS_SUCCESS THEN

Line 129: fnd_file.put_line(FND_FILE.LOG,' ');

125: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
126: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
127: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
128: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
129: fnd_file.put_line(FND_FILE.LOG,' ');
130:
131:
132: IF l_cz_return_status = G_CZ_STATUS_SUCCESS THEN
133: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 235: fnd_file.put_line(FND_FILE.LOG,' ');

231: ' ********************************************************');
232: END IF;
233:
234: -- Put the parameters in log file
235: fnd_file.put_line(FND_FILE.LOG,' ');
236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);

Line 236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

232: END IF;
233:
234: -- Put the parameters in log file
235: fnd_file.put_line(FND_FILE.LOG,' ');
236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);

Line 237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');

233:
234: -- Put the parameters in log file
235: fnd_file.put_line(FND_FILE.LOG,' ');
236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

234: -- Put the parameters in log file
235: fnd_file.put_line(FND_FILE.LOG,' ');
236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);

235: fnd_file.put_line(FND_FILE.LOG,' ');
236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
243: fnd_file.put_line(FND_FILE.LOG,' ');

Line 240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);

236: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
243: fnd_file.put_line(FND_FILE.LOG,' ');
244:

Line 241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

237: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_rp_folder with parameters');
238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
243: fnd_file.put_line(FND_FILE.LOG,' ');
244:
245:

Line 242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

238: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
243: fnd_file.put_line(FND_FILE.LOG,' ');
244:
245:
246: -- Call the CZ Generic Import API

Line 243: fnd_file.put_line(FND_FILE.LOG,' ');

239: fnd_file.put_line(FND_FILE.LOG,'p_encl_folder_id: '||p_encl_folder_id);
240: fnd_file.put_line(FND_FILE.LOG,'p_new_folder_name: '||p_new_folder_name);
241: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
242: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
243: fnd_file.put_line(FND_FILE.LOG,' ');
244:
245:
246: -- Call the CZ Generic Import API
247: CZ_CONTRACTS_API_GRP.create_rp_folder

Line 281: fnd_file.put_line(FND_FILE.LOG,' ');

277: ' ********************************************************');
278: END IF;
279:
280: -- Put the parameters in log file
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);

Line 282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

278: END IF;
279:
280: -- Put the parameters in log file
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');

279:
280: -- Put the parameters in log file
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);

280: -- Put the parameters in log file
281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
288: fnd_file.put_line(FND_FILE.LOG,' ');

Line 285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);

281: fnd_file.put_line(FND_FILE.LOG,' ');
282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289:

Line 286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

282: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289:
290:

Line 287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

283: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_rp_folder');
284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289:
290:
291: -- For the above call , l_cz_return_status is a string 'S' , 'E' or 'U'

Line 288: fnd_file.put_line(FND_FILE.LOG,' ');

284: fnd_file.put_line(FND_FILE.LOG,'x_status: '||l_cz_return_status);
285: fnd_file.put_line(FND_FILE.LOG,'x_new_folder_id: '||x_new_folder_id);
286: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
287: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
288: fnd_file.put_line(FND_FILE.LOG,' ');
289:
290:
291: -- For the above call , l_cz_return_status is a string 'S' , 'E' or 'U'
292: -- so directly assing the same to x_return_status

Line 371: fnd_file.put_line(FND_FILE.LOG,' ');

367: 'p_ui_def_id : '||p_ui_def_id);
368: END IF;
369:
370: -- Put the parameters in log file
371: fnd_file.put_line(FND_FILE.LOG,' ');
372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);

Line 372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

368: END IF;
369:
370: -- Put the parameters in log file
371: fnd_file.put_line(FND_FILE.LOG,' ');
372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');

369:
370: -- Put the parameters in log file
371: fnd_file.put_line(FND_FILE.LOG,' ');
372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

370: -- Put the parameters in log file
371: fnd_file.put_line(FND_FILE.LOG,' ');
372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
378: fnd_file.put_line(FND_FILE.LOG,' ');

Line 375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);

371: fnd_file.put_line(FND_FILE.LOG,' ');
372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
378: fnd_file.put_line(FND_FILE.LOG,' ');
379:

Line 376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

372: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
378: fnd_file.put_line(FND_FILE.LOG,' ');
379:
380: -- Call the CZ delete_ui_def API

Line 377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

373: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_ui_def with parameters');
374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
378: fnd_file.put_line(FND_FILE.LOG,' ');
379:
380: -- Call the CZ delete_ui_def API
381: CZ_contracts_api_grp.delete_ui_def

Line 378: fnd_file.put_line(FND_FILE.LOG,' ');

374: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
375: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
376: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
377: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
378: fnd_file.put_line(FND_FILE.LOG,' ');
379:
380: -- Call the CZ delete_ui_def API
381: CZ_contracts_api_grp.delete_ui_def
382: (

Line 408: fnd_file.put_line(FND_FILE.LOG,' ');

404: ' ********************************************************');
405: END IF;
406:
407: -- Put the parameters in log file
408: fnd_file.put_line(FND_FILE.LOG,' ');
409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

Line 409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

405: END IF;
406:
407: -- Put the parameters in log file
408: fnd_file.put_line(FND_FILE.LOG,' ');
409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

Line 410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');

406:
407: -- Put the parameters in log file
408: fnd_file.put_line(FND_FILE.LOG,' ');
409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

407: -- Put the parameters in log file
408: fnd_file.put_line(FND_FILE.LOG,' ');
409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

408: fnd_file.put_line(FND_FILE.LOG,' ');
409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
416: fnd_file.put_line(FND_FILE.LOG,' ');

Line 413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

409: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
416: fnd_file.put_line(FND_FILE.LOG,' ');
417:

Line 414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

410: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_ui_def');
411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
416: fnd_file.put_line(FND_FILE.LOG,' ');
417:
418:

Line 415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

411: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
416: fnd_file.put_line(FND_FILE.LOG,' ');
417:
418:
419: -- Standard call to get message count and if count is 1, get message info.

Line 416: fnd_file.put_line(FND_FILE.LOG,' ');

412: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
413: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
414: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
415: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
416: fnd_file.put_line(FND_FILE.LOG,' ');
417:
418:
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 );

Line 508: fnd_file.put_line(FND_FILE.LOG,' ');

504: 'p_create_empty_ui : '||p_create_empty_ui);
505: END IF;
506:
507: -- Put the parameters in log file
508: fnd_file.put_line(FND_FILE.LOG,' ');
509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);

Line 509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

505: END IF;
506:
507: -- Put the parameters in log file
508: fnd_file.put_line(FND_FILE.LOG,' ');
509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);

Line 510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');

506:
507: -- Put the parameters in log file
508: fnd_file.put_line(FND_FILE.LOG,' ');
509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);

Line 511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

507: -- Put the parameters in log file
508: fnd_file.put_line(FND_FILE.LOG,' ');
509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);

Line 512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);

508: fnd_file.put_line(FND_FILE.LOG,' ');
509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);

509: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);

510: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_jrad_ui with parameters');
511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
518: fnd_file.put_line(FND_FILE.LOG,' ');

Line 515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);

511: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
518: fnd_file.put_line(FND_FILE.LOG,' ');
519:

Line 516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

512: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
518: fnd_file.put_line(FND_FILE.LOG,' ');
519:
520: -- Call the CZ create_jrad_ui API

Line 517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

513: fnd_file.put_line(FND_FILE.LOG,'p_show_all_nodes: '||p_show_all_nodes);
514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
518: fnd_file.put_line(FND_FILE.LOG,' ');
519:
520: -- Call the CZ create_jrad_ui API
521: CZ_CONTRACTS_API_GRP.create_jrad_ui

Line 518: fnd_file.put_line(FND_FILE.LOG,' ');

514: fnd_file.put_line(FND_FILE.LOG,'p_master_template_id: '||p_master_template_id);
515: fnd_file.put_line(FND_FILE.LOG,'p_create_empty_ui: '||p_create_empty_ui);
516: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
517: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
518: fnd_file.put_line(FND_FILE.LOG,' ');
519:
520: -- Call the CZ create_jrad_ui API
521: CZ_CONTRACTS_API_GRP.create_jrad_ui
522: (

Line 554: fnd_file.put_line(FND_FILE.LOG,' ');

550: ' ********************************************************');
551: END IF;
552:
553: -- Put the parameters in log file
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);

Line 555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

551: END IF;
552:
553: -- Put the parameters in log file
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

Line 556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');

552:
553: -- Put the parameters in log file
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

Line 557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

553: -- Put the parameters in log file
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);

554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

555: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
563: fnd_file.put_line(FND_FILE.LOG,' ');

Line 560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

556: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_jrad_ui');
557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
563: fnd_file.put_line(FND_FILE.LOG,' ');
564:

Line 561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

557: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
563: fnd_file.put_line(FND_FILE.LOG,' ');
564:
565: -- Standard call to get message count and if count is 1, get message info.

Line 562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

558: fnd_file.put_line(FND_FILE.LOG,'x_ui_def_id: '||x_ui_def_id);
559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
563: fnd_file.put_line(FND_FILE.LOG,' ');
564:
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 );

Line 563: fnd_file.put_line(FND_FILE.LOG,' ');

559: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
560: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
561: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
562: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
563: fnd_file.put_line(FND_FILE.LOG,' ');
564:
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:

Line 657: fnd_file.put_line(FND_FILE.LOG,' ');

653: 'p_devl_project_id : '||p_devl_project_id);
654: END IF;
655:
656: -- Put the parameters in log file
657: fnd_file.put_line(FND_FILE.LOG,' ');
658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);

Line 658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

654: END IF;
655:
656: -- Put the parameters in log file
657: fnd_file.put_line(FND_FILE.LOG,' ');
658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');

655:
656: -- Put the parameters in log file
657: fnd_file.put_line(FND_FILE.LOG,' ');
658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

656: -- Put the parameters in log file
657: fnd_file.put_line(FND_FILE.LOG,' ');
658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
664: fnd_file.put_line(FND_FILE.LOG,' ');

Line 661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);

657: fnd_file.put_line(FND_FILE.LOG,' ');
658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
664: fnd_file.put_line(FND_FILE.LOG,' ');
665:

Line 662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

658: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
664: fnd_file.put_line(FND_FILE.LOG,' ');
665:
666: -- Call the CZ Generic Import API

Line 663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

659: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.generate_logic with parameters');
660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
664: fnd_file.put_line(FND_FILE.LOG,' ');
665:
666: -- Call the CZ Generic Import API
667: /*

Line 664: fnd_file.put_line(FND_FILE.LOG,' ');

660: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
661: fnd_file.put_line(FND_FILE.LOG,'p_devl_project_id: '||p_devl_project_id);
662: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
663: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
664: fnd_file.put_line(FND_FILE.LOG,' ');
665:
666: -- Call the CZ Generic Import API
667: /*
668: CZ will return Success for generate_logic if there were warnings

Line 703: fnd_file.put_line(FND_FILE.LOG,' ');

699: ' ********************************************************');
700: END IF;
701:
702: -- Put the parameters in log file
703: fnd_file.put_line(FND_FILE.LOG,' ');
704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);

Line 704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

700: END IF;
701:
702: -- Put the parameters in log file
703: fnd_file.put_line(FND_FILE.LOG,' ');
704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');

701:
702: -- Put the parameters in log file
703: fnd_file.put_line(FND_FILE.LOG,' ');
704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);

702: -- Put the parameters in log file
703: fnd_file.put_line(FND_FILE.LOG,' ');
704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
710: fnd_file.put_line(FND_FILE.LOG,' ');

Line 707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);

703: fnd_file.put_line(FND_FILE.LOG,' ');
704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
710: fnd_file.put_line(FND_FILE.LOG,' ');
711:

Line 708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

704: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
710: fnd_file.put_line(FND_FILE.LOG,' ');
711:
712:

Line 709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

705: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.generate_logic');
706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
710: fnd_file.put_line(FND_FILE.LOG,' ');
711:
712:
713: -- bug 4081597 If any errors happens put details in logfile

Line 710: fnd_file.put_line(FND_FILE.LOG,' ');

706: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
707: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
708: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
709: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
710: fnd_file.put_line(FND_FILE.LOG,' ');
711:
712:
713: -- bug 4081597 If any errors happens put details in logfile
714: IF (x_return_status = G_RET_STS_UNEXP_ERROR) OR (x_return_status = G_RET_STS_ERROR) THEN

Line 718: fnd_file.put_line(FND_FILE.LOG,' ');

714: IF (x_return_status = G_RET_STS_UNEXP_ERROR) OR (x_return_status = G_RET_STS_ERROR) THEN
715: FOR csr_db_logs_rec IN csr_db_logs(p_run_id => x_run_id)
716: LOOP
717: l_rec_number := l_rec_number +1;
718: fnd_file.put_line(FND_FILE.LOG,' ');
719: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);

Line 719: fnd_file.put_line(FND_FILE.LOG,'* Record : '||l_rec_number||' ');

715: FOR csr_db_logs_rec IN csr_db_logs(p_run_id => x_run_id)
716: LOOP
717: l_rec_number := l_rec_number +1;
718: fnd_file.put_line(FND_FILE.LOG,' ');
719: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
723: fnd_file.put_line(FND_FILE.LOG,' ');

Line 720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);

716: LOOP
717: l_rec_number := l_rec_number +1;
718: fnd_file.put_line(FND_FILE.LOG,' ');
719: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
723: fnd_file.put_line(FND_FILE.LOG,' ');
724: fnd_file.put_line(FND_FILE.LOG,' ');

Line 721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);

717: l_rec_number := l_rec_number +1;
718: fnd_file.put_line(FND_FILE.LOG,' ');
719: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
723: fnd_file.put_line(FND_FILE.LOG,' ');
724: fnd_file.put_line(FND_FILE.LOG,' ');
725: END LOOP;

Line 722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);

718: fnd_file.put_line(FND_FILE.LOG,' ');
719: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
723: fnd_file.put_line(FND_FILE.LOG,' ');
724: fnd_file.put_line(FND_FILE.LOG,' ');
725: END LOOP;
726: END IF;

Line 723: fnd_file.put_line(FND_FILE.LOG,' ');

719: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
723: fnd_file.put_line(FND_FILE.LOG,' ');
724: fnd_file.put_line(FND_FILE.LOG,' ');
725: END LOOP;
726: END IF;
727:

Line 724: fnd_file.put_line(FND_FILE.LOG,' ');

720: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
721: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
722: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
723: fnd_file.put_line(FND_FILE.LOG,' ');
724: fnd_file.put_line(FND_FILE.LOG,' ');
725: END LOOP;
726: END IF;
727:
728:

Line 809: fnd_file.put_line(FND_FILE.LOG,' ');

805: 'p_publication_id : '||p_publication_id);
806: END IF;
807:
808: -- Put the parameters in log file
809: fnd_file.put_line(FND_FILE.LOG,' ');
810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);

Line 810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

806: END IF;
807:
808: -- Put the parameters in log file
809: fnd_file.put_line(FND_FILE.LOG,' ');
810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');

807:
808: -- Put the parameters in log file
809: fnd_file.put_line(FND_FILE.LOG,' ');
810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

808: -- Put the parameters in log file
809: fnd_file.put_line(FND_FILE.LOG,' ');
810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
816: fnd_file.put_line(FND_FILE.LOG,' ');

Line 813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);

809: fnd_file.put_line(FND_FILE.LOG,' ');
810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
816: fnd_file.put_line(FND_FILE.LOG,' ');
817:

Line 814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

810: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
816: fnd_file.put_line(FND_FILE.LOG,' ');
817:
818: -- Initialize the CZ parameter values

Line 815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

811: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.delete_publication with parameters');
812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
816: fnd_file.put_line(FND_FILE.LOG,' ');
817:
818: -- Initialize the CZ parameter values
819:

Line 816: fnd_file.put_line(FND_FILE.LOG,' ');

812: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
813: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
814: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
815: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
816: fnd_file.put_line(FND_FILE.LOG,' ');
817:
818: -- Initialize the CZ parameter values
819:
820: CZ_CONTRACTS_API_GRP.delete_publication

Line 852: fnd_file.put_line(FND_FILE.LOG,' ');

848: ' ********************************************************');
849: END IF;
850:
851: -- Put the parameters in log file
852: fnd_file.put_line(FND_FILE.LOG,' ');
853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

Line 853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

849: END IF;
850:
851: -- Put the parameters in log file
852: fnd_file.put_line(FND_FILE.LOG,' ');
853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

Line 854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');

850:
851: -- Put the parameters in log file
852: fnd_file.put_line(FND_FILE.LOG,' ');
853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

851: -- Put the parameters in log file
852: fnd_file.put_line(FND_FILE.LOG,' ');
853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

852: fnd_file.put_line(FND_FILE.LOG,' ');
853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
860: fnd_file.put_line(FND_FILE.LOG,' ');

Line 857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

853: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
860: fnd_file.put_line(FND_FILE.LOG,' ');
861:

Line 858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

854: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.delete_publication');
855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
860: fnd_file.put_line(FND_FILE.LOG,' ');
861:
862: -- Standard call to get message count and if count is 1, get message info.

Line 859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

855: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
860: fnd_file.put_line(FND_FILE.LOG,' ');
861:
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 );

Line 860: fnd_file.put_line(FND_FILE.LOG,' ');

856: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
857: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
858: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
859: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
860: fnd_file.put_line(FND_FILE.LOG,' ');
861:
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:

Line 1030: fnd_file.put_line(FND_FILE.LOG,' ');

1026: 'p_end_date : '||l_end_date);
1027: END IF;
1028:
1029: -- Put the parameters in log file
1030: fnd_file.put_line(FND_FILE.LOG,' ');
1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);

Line 1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1027: END IF;
1028:
1029: -- Put the parameters in log file
1030: fnd_file.put_line(FND_FILE.LOG,' ');
1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);

Line 1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');

1028:
1029: -- Put the parameters in log file
1030: fnd_file.put_line(FND_FILE.LOG,' ');
1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);

Line 1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

1029: -- Put the parameters in log file
1030: fnd_file.put_line(FND_FILE.LOG,' ');
1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);

Line 1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);

1030: fnd_file.put_line(FND_FILE.LOG,' ');
1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');

Line 1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);

1031: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');

Line 1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);

1032: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.create_publication_request with parameters');
1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);

Line 1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);

1033: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);

Line 1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');

1034: fnd_file.put_line(FND_FILE.LOG,'p_model_id: '||p_devl_project_id);
1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');

1035: fnd_file.put_line(FND_FILE.LOG,'p_ui_def_id: '||p_ui_def_id);
1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);

1036: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1044: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);

1037: fnd_file.put_line(FND_FILE.LOG,'p_server_id: '||l_server_id);
1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1044: fnd_file.put_line(FND_FILE.LOG,' ');
1045:

Line 1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

1038: fnd_file.put_line(FND_FILE.LOG,'l_appl_id_tbl(1) : 510');
1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1044: fnd_file.put_line(FND_FILE.LOG,' ');
1045:
1046: -- Add code for initialization of applicability parameters

Line 1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1039: fnd_file.put_line(FND_FILE.LOG,'l_usg_id_tbl(1) : -1');
1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1044: fnd_file.put_line(FND_FILE.LOG,' ');
1045:
1046: -- Add code for initialization of applicability parameters
1047:

Line 1044: fnd_file.put_line(FND_FILE.LOG,' ');

1040: fnd_file.put_line(FND_FILE.LOG,'p_start_date: '||l_start_date);
1041: fnd_file.put_line(FND_FILE.LOG,'p_end_date: '||l_end_date);
1042: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1043: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1044: fnd_file.put_line(FND_FILE.LOG,' ');
1045:
1046: -- Add code for initialization of applicability parameters
1047:
1048: -- Call the CZ Generic Import API

Line 1092: fnd_file.put_line(FND_FILE.LOG,' ');

1088: ' ********************************************************');
1089: END IF;
1090:
1091: -- Put the parameters in log file
1092: fnd_file.put_line(FND_FILE.LOG,' ');
1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);

Line 1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1089: END IF;
1090:
1091: -- Put the parameters in log file
1092: fnd_file.put_line(FND_FILE.LOG,' ');
1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

Line 1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');

1090:
1091: -- Put the parameters in log file
1092: fnd_file.put_line(FND_FILE.LOG,' ');
1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

Line 1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1091: -- Put the parameters in log file
1092: fnd_file.put_line(FND_FILE.LOG,' ');
1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);

1092: fnd_file.put_line(FND_FILE.LOG,' ');
1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

1093: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1101: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

1094: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.create_publication_request');
1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1101: fnd_file.put_line(FND_FILE.LOG,' ');
1102:

Line 1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

1095: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1101: fnd_file.put_line(FND_FILE.LOG,' ');
1102:
1103:

Line 1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1096: fnd_file.put_line(FND_FILE.LOG,'x_publication_id: '||x_publication_id);
1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1101: fnd_file.put_line(FND_FILE.LOG,' ');
1102:
1103:
1104: -- Standard call to get message count and if count is 1, get message info.

Line 1101: fnd_file.put_line(FND_FILE.LOG,' ');

1097: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1098: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1099: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1100: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1101: fnd_file.put_line(FND_FILE.LOG,' ');
1102:
1103:
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 );

Line 1735: fnd_file.put_line(FND_FILE.LOG,' ');

1731: 'p_disabledate : '||l_disabledate);
1732: END IF;
1733:
1734: -- Put the parameters in log file
1735: fnd_file.put_line(FND_FILE.LOG,' ');
1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);

Line 1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1732: END IF;
1733:
1734: -- Put the parameters in log file
1735: fnd_file.put_line(FND_FILE.LOG,' ');
1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);

Line 1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');

1733:
1734: -- Put the parameters in log file
1735: fnd_file.put_line(FND_FILE.LOG,' ');
1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');

Line 1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

1734: -- Put the parameters in log file
1735: fnd_file.put_line(FND_FILE.LOG,' ');
1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');

Line 1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);

1735: fnd_file.put_line(FND_FILE.LOG,' ');
1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);

Line 1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);

1736: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);

Line 1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');

1737: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.edit_publication with parameters');
1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');

1738: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);

1739: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1747: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);

1740: fnd_file.put_line(FND_FILE.LOG,'p_publication_mode: '||p_publication_mode);
1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1747: fnd_file.put_line(FND_FILE.LOG,' ');
1748:

Line 1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

1741: fnd_file.put_line(FND_FILE.LOG,'p_applicationId: 510 ');
1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1747: fnd_file.put_line(FND_FILE.LOG,' ');
1748:
1749: -- Initialize the CZ parameter values

Line 1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1742: fnd_file.put_line(FND_FILE.LOG,'p_usageId: -1 ');
1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1747: fnd_file.put_line(FND_FILE.LOG,' ');
1748:
1749: -- Initialize the CZ parameter values
1750:

Line 1747: fnd_file.put_line(FND_FILE.LOG,' ');

1743: fnd_file.put_line(FND_FILE.LOG,'p_startdate: '||l_startdate);
1744: fnd_file.put_line(FND_FILE.LOG,'p_disabledate: '||l_disabledate);
1745: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1746: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1747: fnd_file.put_line(FND_FILE.LOG,' ');
1748:
1749: -- Initialize the CZ parameter values
1750:
1751:

Line 1791: fnd_file.put_line(FND_FILE.LOG,' ');

1787: ' ********************************************************');
1788: END IF;
1789:
1790: -- Put the parameters in log file
1791: fnd_file.put_line(FND_FILE.LOG,' ');
1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

Line 1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1788: END IF;
1789:
1790: -- Put the parameters in log file
1791: fnd_file.put_line(FND_FILE.LOG,' ');
1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

Line 1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');

1789:
1790: -- Put the parameters in log file
1791: fnd_file.put_line(FND_FILE.LOG,' ');
1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1790: -- Put the parameters in log file
1791: fnd_file.put_line(FND_FILE.LOG,' ');
1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);

1791: fnd_file.put_line(FND_FILE.LOG,' ');
1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1799: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

1792: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1799: fnd_file.put_line(FND_FILE.LOG,' ');
1800:

Line 1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

1793: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.edit_publication');
1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1799: fnd_file.put_line(FND_FILE.LOG,' ');
1800:
1801:

Line 1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1794: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1799: fnd_file.put_line(FND_FILE.LOG,' ');
1800:
1801:
1802:

Line 1799: fnd_file.put_line(FND_FILE.LOG,' ');

1795: fnd_file.put_line(FND_FILE.LOG,'x_msg_count: '||x_msg_count);
1796: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
1797: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1798: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1799: fnd_file.put_line(FND_FILE.LOG,' ');
1800:
1801:
1802:
1803: -- Standard call to get message count and if count is 1, get message info.

Line 1893: fnd_file.put_line(FND_FILE.LOG,' ');

1889: 'p_devl_project_id : '||p_publication_id);
1890: END IF;
1891:
1892: -- Put the parameters in log file
1893: fnd_file.put_line(FND_FILE.LOG,' ');
1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);

Line 1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1890: END IF;
1891:
1892: -- Put the parameters in log file
1893: fnd_file.put_line(FND_FILE.LOG,' ');
1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');

1891:
1892: -- Put the parameters in log file
1893: fnd_file.put_line(FND_FILE.LOG,' ');
1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);

1892: -- Put the parameters in log file
1893: fnd_file.put_line(FND_FILE.LOG,' ');
1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1900: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);

1893: fnd_file.put_line(FND_FILE.LOG,' ');
1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1900: fnd_file.put_line(FND_FILE.LOG,' ');
1901:

Line 1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

1894: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1900: fnd_file.put_line(FND_FILE.LOG,' ');
1901:
1902: -- Call the CZ Generic Import API

Line 1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1895: fnd_file.put_line(FND_FILE.LOG,'Calling CZ_CONTRACTS_API_GRP.publish_model with parameters');
1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1900: fnd_file.put_line(FND_FILE.LOG,' ');
1901:
1902: -- Call the CZ Generic Import API
1903: /*

Line 1900: fnd_file.put_line(FND_FILE.LOG,' ');

1896: fnd_file.put_line(FND_FILE.LOG,'p_api_version: '||l_api_version);
1897: fnd_file.put_line(FND_FILE.LOG,'p_publication_id: '||p_publication_id);
1898: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1899: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1900: fnd_file.put_line(FND_FILE.LOG,' ');
1901:
1902: -- Call the CZ Generic Import API
1903: /*
1904: CZ will return Success for publish_model if there were warnings

Line 1939: fnd_file.put_line(FND_FILE.LOG,' ');

1935: ' ********************************************************');
1936: END IF;
1937:
1938: -- Put the parameters in log file
1939: fnd_file.put_line(FND_FILE.LOG,' ');
1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);

Line 1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1936: END IF;
1937:
1938: -- Put the parameters in log file
1939: fnd_file.put_line(FND_FILE.LOG,' ');
1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

Line 1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');

1937:
1938: -- Put the parameters in log file
1939: fnd_file.put_line(FND_FILE.LOG,' ');
1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

Line 1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);

1938: -- Put the parameters in log file
1939: fnd_file.put_line(FND_FILE.LOG,' ');
1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1946: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);

1939: fnd_file.put_line(FND_FILE.LOG,' ');
1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947:

Line 1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));

1940: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947:
1948: -- bug 4081597 If any errors happens put details in logfile

Line 1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');

1941: fnd_file.put_line(FND_FILE.LOG,'After calling CZ_CONTRACTS_API_GRP.publish_model');
1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947:
1948: -- bug 4081597 If any errors happens put details in logfile
1949: IF (x_return_status = G_RET_STS_UNEXP_ERROR) OR (x_return_status = G_RET_STS_ERROR) THEN

Line 1946: fnd_file.put_line(FND_FILE.LOG,' ');

1942: fnd_file.put_line(FND_FILE.LOG,'x_status: '||x_return_status);
1943: fnd_file.put_line(FND_FILE.LOG,'x_run_id: '||x_run_id);
1944: fnd_file.put_line(FND_FILE.LOG,'Current Time : '||to_char(sysdate,'dd mm yyyy HH:MI:SS'));
1945: fnd_file.put_line(FND_FILE.LOG,'*********************************************** ');
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947:
1948: -- bug 4081597 If any errors happens put details in logfile
1949: IF (x_return_status = G_RET_STS_UNEXP_ERROR) OR (x_return_status = G_RET_STS_ERROR) THEN
1950: FOR csr_db_logs_rec IN csr_db_logs(p_run_id => x_run_id)

Line 1953: fnd_file.put_line(FND_FILE.LOG,' ');

1949: IF (x_return_status = G_RET_STS_UNEXP_ERROR) OR (x_return_status = G_RET_STS_ERROR) THEN
1950: FOR csr_db_logs_rec IN csr_db_logs(p_run_id => x_run_id)
1951: LOOP
1952: l_rec_number := l_rec_number +1;
1953: fnd_file.put_line(FND_FILE.LOG,' ');
1954: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);

Line 1954: fnd_file.put_line(FND_FILE.LOG,'* Record : '||l_rec_number||' ');

1950: FOR csr_db_logs_rec IN csr_db_logs(p_run_id => x_run_id)
1951: LOOP
1952: l_rec_number := l_rec_number +1;
1953: fnd_file.put_line(FND_FILE.LOG,' ');
1954: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
1958: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);

1951: LOOP
1952: l_rec_number := l_rec_number +1;
1953: fnd_file.put_line(FND_FILE.LOG,' ');
1954: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
1958: fnd_file.put_line(FND_FILE.LOG,' ');
1959: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);

1952: l_rec_number := l_rec_number +1;
1953: fnd_file.put_line(FND_FILE.LOG,' ');
1954: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
1958: fnd_file.put_line(FND_FILE.LOG,' ');
1959: fnd_file.put_line(FND_FILE.LOG,' ');
1960: END LOOP;

Line 1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);

1953: fnd_file.put_line(FND_FILE.LOG,' ');
1954: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
1958: fnd_file.put_line(FND_FILE.LOG,' ');
1959: fnd_file.put_line(FND_FILE.LOG,' ');
1960: END LOOP;
1961: END IF;

Line 1958: fnd_file.put_line(FND_FILE.LOG,' ');

1954: fnd_file.put_line(FND_FILE.LOG,'*************** Record : '||l_rec_number||' **************');
1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
1958: fnd_file.put_line(FND_FILE.LOG,' ');
1959: fnd_file.put_line(FND_FILE.LOG,' ');
1960: END LOOP;
1961: END IF;
1962:

Line 1959: fnd_file.put_line(FND_FILE.LOG,' ');

1955: fnd_file.put_line(FND_FILE.LOG,'Logtime : '||csr_db_logs_rec.logtime);
1956: fnd_file.put_line(FND_FILE.LOG,'Caller : '||csr_db_logs_rec.caller);
1957: fnd_file.put_line(FND_FILE.LOG,'Message : '||csr_db_logs_rec.message);
1958: fnd_file.put_line(FND_FILE.LOG,' ');
1959: fnd_file.put_line(FND_FILE.LOG,' ');
1960: END LOOP;
1961: END IF;
1962:
1963: