DBA Data[Home] [Help]

APPS.CN_RAM_ADJUSTMENTS_PKG dependencies on CN_MESSAGE_PKG

Line 62: cn_message_pkg.debug('identify RAM adjustments>>');

58: IF (debug_pipe IS NOT NULL) THEN
59: cn_debug.init_pipe(debug_pipe, debug_level);
60: END IF;
61: cn_debug.print_msg('>>identify RAM adjustments', 1);
62: cn_message_pkg.debug('identify RAM adjustments>>');
63: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments>>');
64:
65: x_proc_audit_id := NULL; -- Will get a value in the call below
66: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,'RAMADJ', 'Identify RAM adjustments', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);

Line 74: cn_message_pkg.debug('identify RAM adjustments: identifing adjustments for transactions from '||x_start_date ||' to '||x_end_date ||'.');

70: x_org_id,
71: x_start_date,
72: x_end_date);
73:
74: cn_message_pkg.debug('identify RAM adjustments: identifing adjustments for transactions from '||x_start_date ||' to '||x_end_date ||'.');
75: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identifing adjustments for transactions from '||x_start_date ||' to '||x_end_date ||'.');
76:
77: OPEN batch_size;
78: FETCH batch_size INTO l_sys_batch_size;

Line 259: cn_message_pkg.debug('identify RAM adjustments: no RAM adjustments was found.');

255: cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0,
256: 'identify RAM adjustments: completed. ' || x_trx_identified_count || ' transactions identified.');
257:
258: IF ( x_trx_identified_count = 0 ) THEN
259: cn_message_pkg.debug('identify RAM adjustments: no RAM adjustments was found.');
260: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: no RAM adjustments was found.');
261: END IF;
262:
263: COMMIT; -- commit after identify process

Line 265: cn_message_pkg.debug('identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');

261: END IF;
262:
263: COMMIT; -- commit after identify process
264:
265: cn_message_pkg.debug('identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
266: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
267:
268: cn_debug.print_msg('< 269: cn_message_pkg.debug('identify RAM adjustments<<');

Line 269: cn_message_pkg.debug('identify RAM adjustments<<');

265: cn_message_pkg.debug('identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
266: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: identify process completed. ' || x_trx_identified_count || ' transactions identified.');
267:
268: cn_debug.print_msg('< 269: cn_message_pkg.debug('identify RAM adjustments<<');
270: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments<<');
271:
272:
273:

Line 277: cn_message_pkg.debug('identify RAM adjustments: in exception handler');

273:
274: EXCEPTION
275: WHEN OTHERS THEN ROLLBACK;
276:
277: cn_message_pkg.debug('identify RAM adjustments: in exception handler');
278: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: in exception handler');
279:
280: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
281: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

Line 280: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);

276:
277: cn_message_pkg.debug('identify RAM adjustments: in exception handler');
278: fnd_file.put_line(fnd_file.Log, 'identify RAM adjustments: in exception handler');
279:
280: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
281: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
282:
283: cn_debug.print_msg('identify RAM adjustments: in exception handler', 1);
284: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,

Line 329: cn_message_pkg.debug('negate process>>');

325: IF (debug_pipe IS NOT NULL) THEN
326: cn_debug.init_pipe(debug_pipe, debug_level);
327: END IF;
328: cn_debug.print_msg('>>negate process', 1);
329: cn_message_pkg.debug('negate process>>');
330: fnd_file.put_line(fnd_file.Log, 'negate process>>');
331:
332: x_proc_audit_id := NULL; -- Will get a value in the call below
333: cn_process_audits_pkg.insert_row(x_rowid, x_proc_audit_id, NULL,'RAMADJ', 'negate process', NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);

Line 366: cn_message_pkg.debug('negate process: No OIC transaction was negated.');

362: cn_process_audits_pkg.update_row(x_proc_audit_id, NULL, SYSDATE, 0,
363: 'negate process: completed. ' || x_api_negated_count || ' OIC transactions negated.');
364:
365: IF ( x_api_negated_count = 0 ) THEN
366: cn_message_pkg.debug('negate process: No OIC transaction was negated.');
367: fnd_file.put_line(fnd_file.Log, 'negate process: No OIC transaction was negated.');
368: END IF;
369:
370: -- COMMIT; commit will be called when the re-collection is done.

Line 372: cn_message_pkg.debug('negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');

368: END IF;
369:
370: -- COMMIT; commit will be called when the re-collection is done.
371:
372: cn_message_pkg.debug('negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
373: fnd_file.put_line(fnd_file.Log, 'negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
374:
375: cn_debug.print_msg('< 376: cn_message_pkg.debug('negate process<<');

Line 376: cn_message_pkg.debug('negate process<<');

372: cn_message_pkg.debug('negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
373: fnd_file.put_line(fnd_file.Log, 'negate process: negate process completed. ' || x_api_negated_count || ' OIC transactions negated.');
374:
375: cn_debug.print_msg('< 376: cn_message_pkg.debug('negate process<<');
377: fnd_file.put_line(fnd_file.Log, 'negate process<<');
378:
379:
380: EXCEPTION

Line 383: cn_message_pkg.debug('negate process: in exception handler');

379:
380: EXCEPTION
381: WHEN OTHERS THEN ROLLBACK;
382:
383: cn_message_pkg.debug('negate process: in exception handler');
384: fnd_file.put_line(fnd_file.Log, 'negate process: in exception handler');
385:
386: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
387: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);

Line 386: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);

382:
383: cn_message_pkg.debug('negate process: in exception handler');
384: fnd_file.put_line(fnd_file.Log, 'negate process: in exception handler');
385:
386: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
387: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
388:
389: cn_debug.print_msg('negate process: in exception handler', 1);
390: cn_process_audits_pkg.update_row(X_proc_audit_id, NULL, SYSDATE, SQLCODE,