APPS.CN_NOTIFY_ORDERS dependencies on CN_PROCESS_AUDITS_PKG

Line 162: cn_process_audits_pkg.insert_row

158:
159: cn_message_pkg.debug('notify: adjust: entering notify_line (lid = '||p_line_id||') ');
160: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_line (lid = '||p_line_id||') ');
161:
162: cn_process_audits_pkg.insert_row
163: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
164: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
165:
166: --Added as per MOAC OE Mandate

Line 280: cn_process_audits_pkg.insert_row

276:
277:
278: l_org_id := p_org_id;
279:
280: cn_process_audits_pkg.insert_row
281: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
282: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, p_org_id);
283: OPEN batch_size;
284: FETCH batch_size INTO l_sys_batch_size;

Line 369: cn_process_audits_pkg.insert_row

365:
366: cn_message_pkg.debug('notify: adjust: entering notify_affected_lines (lid = '||p_line_id||')');
367: fnd_file.put_line(fnd_file.Log, 'notify: adjust: entering notify_affected_lines (lid = '||p_line_id||')');
368:
369: cn_process_audits_pkg.insert_row
370: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
371: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, p_org_id);
372: --+
373: -- Examine the line (if any) to which the sales credit belonged

Line 1337: cn_process_audits_pkg.insert_row

1333: fnd_file.put_line(fnd_file.Log, 'notify: Get_Notice<<');
1334:
1335: l_proc_audit_id := NULL; -- Gets a value in the call below
1336:
1337: cn_process_audits_pkg.insert_row
1338: ( l_rowid, l_proc_audit_id, NULL, 'NOT', 'Notification run',
1339: NULL, NULL, NULL, NULL, NULL, SYSDATE, NULL, x_org_id);
1340:
1341: cn_periods_api.set_dates(x_start_period, x_end_period, x_org_id,

Line 1420: cn_process_audits_pkg.update_row(l_proc_audit_id, NULL, SYSDATE, 0,

1416: --dbms_output.put_line(' In CN_NOTIFY_ORDERS REGULAR_COL_NOTIFY ');
1417: --dbms_output.put_line(' l_trx_count '||l_trx_count);
1418:
1419:
1420: cn_process_audits_pkg.update_row(l_proc_audit_id, NULL, SYSDATE, 0,
1421: 'Finished notification run: Notified ' || l_trx_count || ' orders.');
1422:
1423: --DBMS_OUTPUT.put_line('parent_proc_audit_id '||parent_proc_audit_id);
1424:

Line 1455: cn_process_audits_pkg.update_row(l_proc_audit_id, NULL, SYSDATE, SQLCODE,

1451: cn_message_pkg.debug(SQLCODE||' '||SQLERRM);
1452: fnd_file.put_line(fnd_file.Log, SQLCODE||' '||SQLERRM);
1453:
1454: cn_debug.print_msg('notify_orders: in exception handler', 1);
1455: cn_process_audits_pkg.update_row(l_proc_audit_id, NULL, SYSDATE, SQLCODE,
1456: SQLERRM);
1457: cn_message_pkg.end_batch (l_proc_audit_id);
1458:
1459: app_exception.raise_exception;