DBA Data[Home] [Help]

APPS.JAI_FBT_PAYMENT_P dependencies on FND_LOG

Line 48: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

44: ( p_fbt_payment IN jai_fbt_payment%ROWTYPE
45: )
46: IS
47: lv_procedure_name VARCHAR2(40):='Insert_Fbt_Payment';
48: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
50:
51: BEGIN
52: --logging for debug

Line 49: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

45: )
46: IS
47: lv_procedure_name VARCHAR2(40):='Insert_Fbt_Payment';
48: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
50:
51: BEGIN
52: --logging for debug
53: IF (ln_proc_level >= ln_dbg_level)

Line 55: FND_LOG.STRING( ln_proc_level

51: BEGIN
52: --logging for debug
53: IF (ln_proc_level >= ln_dbg_level)
54: THEN
55: FND_LOG.STRING( ln_proc_level
56: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
57: , 'Enter procedure'
58: );
59: END IF; --l_proc_level>=l_dbg_level

Line 116: FND_LOG.STRING( ln_proc_level

112:
113: --logging for debug
114: IF (ln_proc_level >= ln_dbg_level)
115: THEN
116: FND_LOG.STRING( ln_proc_level
117: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
118: , 'Exit procedure'
119: );
120: END IF; -- (ln_proc_level>=ln_dbg_level)

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

120: END IF; -- (ln_proc_level>=ln_dbg_level)
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
125: THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
127: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
128: , Sqlcode||Sqlerrm);

Line 126: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

122: EXCEPTION
123: WHEN OTHERS THEN
124: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
125: THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
127: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
128: , Sqlcode||Sqlerrm);
129: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
130: END Insert_Fbt_Payment;

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

125: THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
127: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
128: , Sqlcode||Sqlerrm);
129: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
130: END Insert_Fbt_Payment;
131:
132: --==========================================================================
133: -- PROCEDURE NAME:

Line 159: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

155: , p_inv_lines_interface IN inv_lines_interface_rec_type
156: )
157: IS
158: lv_procedure_name VARCHAR2(40):='Insert_Interface_Table';
159: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
160: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
161:
162: BEGIN
163: --logging for debug

Line 160: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

156: )
157: IS
158: lv_procedure_name VARCHAR2(40):='Insert_Interface_Table';
159: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
160: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
161:
162: BEGIN
163: --logging for debug
164: IF (ln_proc_level >= ln_dbg_level)

Line 166: FND_LOG.STRING( ln_proc_level

162: BEGIN
163: --logging for debug
164: IF (ln_proc_level >= ln_dbg_level)
165: THEN
166: FND_LOG.STRING( ln_proc_level
167: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
168: , 'Enter procedure'
169: );
170: END IF; --l_proc_level>=l_dbg_level

Line 246: FND_LOG.STRING( ln_proc_level

242: );
243: --logging for debug
244: IF (ln_proc_level >= ln_dbg_level)
245: THEN
246: FND_LOG.STRING( ln_proc_level
247: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
248: , 'Exit procedure'
249: );
250: END IF; -- (ln_proc_level>=ln_dbg_level)

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

250: END IF; -- (ln_proc_level>=ln_dbg_level)
251:
252: EXCEPTION
253: WHEN OTHERS THEN
254: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
255: THEN
256: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
257: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
258: , Sqlcode||Sqlerrm);

Line 256: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

252: EXCEPTION
253: WHEN OTHERS THEN
254: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
255: THEN
256: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
257: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
258: , Sqlcode||Sqlerrm);
259: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
260: END Insert_Interface_Table;

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

255: THEN
256: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
257: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
258: , Sqlcode||Sqlerrm);
259: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
260: END Insert_Interface_Table;
261:
262: --==========================================================================
263: -- PROCEDURE NAME:

Line 333: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

329: ld_status_date DATE :=TRUNC(FND_DATE.DISPLAYDT_TO_DATE(pv_status_date));
330: ln_fbt_payment_id NUMBER;
331:
332: lv_procedure_name VARCHAR2(40):='Fbt_Payment';
333: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
334: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
335:
336: CURSOR po_vendors_cur IS
337: SELECT

Line 334: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

330: ln_fbt_payment_id NUMBER;
331:
332: lv_procedure_name VARCHAR2(40):='Fbt_Payment';
333: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
334: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
335:
336: CURSOR po_vendors_cur IS
337: SELECT
338: -- pvsa.org_id,

Line 390: FND_LOG.STRING( ln_proc_level

386: BEGIN
387: --logging for debug
388: IF (ln_proc_level >= ln_dbg_level)
389: THEN
390: FND_LOG.STRING( ln_proc_level
391: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
392: , 'Enter procedure'
393: );
394: END IF; --l_proc_level>=l_dbg_level

Line 561: FND_LOG.STRING( ln_proc_level

557: COMMIT;
558: --logging for debug
559: IF (ln_proc_level >= ln_dbg_level)
560: THEN
561: FND_LOG.STRING( ln_proc_level
562: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
563: , 'Exit procedure'
564: );
565: END IF; -- (ln_proc_level>=ln_dbg_level)

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

569: WHEN OTHERS THEN
570: pv_retcode :=2;
571: pv_errbuf := Sqlerrm;
572: ROLLBACK;
573: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
574: THEN
575: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
576: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
577: , Sqlcode||Sqlerrm);

Line 575: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

571: pv_errbuf := Sqlerrm;
572: ROLLBACK;
573: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
574: THEN
575: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
576: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
577: , Sqlcode||Sqlerrm);
578: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
579: END Fbt_Payment;

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

574: THEN
575: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
576: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
577: , Sqlcode||Sqlerrm);
578: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
579: END Fbt_Payment;
580:
581: END JAI_FBT_PAYMENT_P;