APPS.JA_CN_AP_VALIDATION_PKG dependencies on FND_LOG

Line 57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

53: RETURN VARCHAR2
54: IS
55: lv_supplier_name VARCHAR(30) := pv_supplier_name;
56: lv_procedure_name VARCHAR2(40) := 'Get_Supplier_Name';
57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
59:
60:
61: CURSOR customer_name_cur

Line 58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

54: IS
55: lv_supplier_name VARCHAR(30) := pv_supplier_name;
56: lv_procedure_name VARCHAR2(40) := 'Get_Supplier_Name';
57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
59:
60:
61: CURSOR customer_name_cur
62: (ln_invoice_id NUMBER)

Line 104: FND_LOG.STRING(ln_proc_level,

100: BEGIN
101: --logging for debug
102: IF (ln_proc_level >= ln_dbg_level)
103: THEN
104: FND_LOG.STRING(ln_proc_level,
105: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
106: '.begin',
107: 'Enter procedure');
108: END IF; --ln_proc_level>=ln_dbg_level

Line 126: FND_LOG.STRING(ln_proc_level,

122:
123: --logging for debug
124: IF (ln_proc_level >= ln_dbg_level)
125: THEN
126: FND_LOG.STRING(ln_proc_level,
127: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
128: 'Exit procedure');
129: END IF; -- (ln_proc_level>=ln_dbg_level)
130:

Line 175: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

171: ,pv_period_to IN VARCHAR2
172: )
173: IS
174: lv_procedure_name VARCHAR2(40) := 'Validate_Payables';
175: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
176: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
177:
178: L_XML_ITEM XMLTYPE;
179: L_XML_ROW_ITEMS XMLTYPE;

Line 176: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

172: )
173: IS
174: lv_procedure_name VARCHAR2(40) := 'Validate_Payables';
175: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
176: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
177:
178: L_XML_ITEM XMLTYPE;
179: L_XML_ROW_ITEMS XMLTYPE;
180: L_XML_ROW XMLTYPE;

Line 364: FND_LOG.STRING(ln_proc_level,

360: BEGIN
361: --logging for debug
362: IF (ln_proc_level >= ln_dbg_level)
363: THEN
364: FND_LOG.STRING(ln_proc_level,
365: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
366: '.begin',
367: 'Enter procedure');
368: -- logging the parameters

Line 369: FND_LOG.STRING(ln_proc_level,

365: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
366: '.begin',
367: 'Enter procedure');
368: -- logging the parameters
369: FND_LOG.STRING(ln_proc_level,
370: lv_procedure_name ||
371: '.parameters',
372: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
373: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 615: FND_LOG.STRING(ln_proc_level,

611:
612: --logging for debug
613: IF (ln_proc_level >= ln_dbg_level)
614: THEN
615: FND_LOG.STRING(ln_proc_level,
616: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
617: 'Exit procedure');
618: END IF; -- (ln_proc_level>=ln_dbg_level)
619:

Line 622: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

618: END IF; -- (ln_proc_level>=ln_dbg_level)
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
623: THEN
624: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
625: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
626: '.Other_Exception ',

Line 624: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

620: EXCEPTION
621: WHEN OTHERS THEN
622: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
623: THEN
624: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
625: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
626: '.Other_Exception ',
627: SQLCODE || SQLERRM);
628: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 628: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

624: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
625: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
626: '.Other_Exception ',
627: SQLCODE || SQLERRM);
628: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
629: pv_retcode := '2';
630: pv_errbuf := SQLCODE || SQLERRM;
631: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
632: