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);
67:
68: cn_periods_api.set_dates(x_start_period,
69: x_end_period,
70: x_org_id,
251: AND org_id = x_org_id; --MOAC Changes made by Ashley
252:
253: END LOOP; -- end FOR adj IN adj_cursor LOOP
254:
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.');
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,
285: SQLERRM);
286:
287: app_exception.raise_exception;
288:
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);
334:
335: FOR nt IN neg_trx_line_cursor LOOP
336:
337: FOR na IN neg_api_cursor(nt.trx_line_id) LOOP
358: -- collected_flag = 'N'
359:
360: END LOOP;
361:
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.');
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,
391: SQLERRM);
392:
393: app_exception.raise_exception;
394: