DBA Data[Home] [Help]

APPS.FV_TREASURY_PAYMENTS_PKG dependencies on FV_UTILITY

Line 53: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

49: g_treasury_conf_id := TO_NUMBER(p_treas_conf_id);
50:
51:
52: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
53: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
54: 'Treasury Confirmation Id = '||g_treasury_conf_id);
55: END IF;
56:
57: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

54: 'Treasury Confirmation Id = '||g_treasury_conf_id);
55: END IF;
56:
57: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
58: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
59: 'Org Id = '|| g_org_id);
60: END IF;
61:
62:

Line 88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

84: commit;
85: x_retcode := 2;
86: x_errbuf := 'The Treasury Confirmation journal category has not been seeded';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
89: 'p_button_name = '||p_button_name);
90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
91: 'Treasury Confirmation Id = '||g_treasury_conf_id);
92: END IF;

Line 90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

86: x_errbuf := 'The Treasury Confirmation journal category has not been seeded';
87: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
89: 'p_button_name = '||p_button_name);
90: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
91: 'Treasury Confirmation Id = '||g_treasury_conf_id);
92: END IF;
93: Return;
94: END IF;

Line 122: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

118: FROM fv_operating_units
119: where org_id = g_org_id ;
120:
121: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
123: 'dit flag = '||l_dit_flag);
124: END IF;
125: g_dit_flag := l_dit_flag;
126:

Line 132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

128: x_retcode := 0;
129: x_errbuf := 'Disbursement in transit checkbox is disabled in Define Federal Options form'||
130: '-no accounting created for Treasury Confirmation ';
131: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
133: 'No Accounting created for Treasury Confirmation -'||
134: 'disbursement in transit checkbox is disabled in Define Federal Options form');
135: END IF;
136: END IF;

Line 142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

138:
139:
140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

140:
141: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

142: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
143: 'g_payment_instr_id = '||g_payment_instr_id);
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
149: 'g_org_id = '||g_org_id);
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
145: 'g_accounting_date = '||g_accounting_date);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
149: 'g_org_id = '||g_org_id);
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
151: 'g_checkrun_name = '||g_checkrun_name);
152: END IF;

Line 150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
147: 'g_ledger_id = '||g_ledger_id);
148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
149: 'g_org_id = '||g_org_id);
150: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
151: 'g_checkrun_name = '||g_checkrun_name);
152: END IF;
153: EXCEPTION
154: WHEN OTHERS THEN

Line 158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

154: WHEN OTHERS THEN
155: x_retcode := 2;
156: x_errbuf := 'The Treasury Confirmation rows are not available';
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
159: 'p_button_name = '||p_button_name);
160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
161: 'Treasury Confirmation Id = '||g_treasury_conf_id);
162: END IF;

Line 160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

156: x_errbuf := 'The Treasury Confirmation rows are not available';
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
159: 'p_button_name = '||p_button_name);
160: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
161: 'Treasury Confirmation Id = '||g_treasury_conf_id);
162: END IF;
163: END;
164:

Line 179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

175: commit;
176: RETURN;
177: END IF;
178:
179: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
180: 'Button='||p_button_name);
181:
182: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

180: 'Button='||p_button_name);
181:
182: IF p_button_name = 'TREASURY_CONFIRMATION.CONFIRM' THEN
183: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
185: 'Confirmation Process begins');
186: END IF;
187: do_confirm_process(x_status_code,x_return_status);
188: x_retcode := x_status_code;

Line 196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

192: SET confirmation_status_flag = 'Y'
193: WHERE treasury_confirmation_id = g_treasury_conf_id;
194:
195: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
197: 'The Confirm Process is Successful');
198: END IF;
199: ELSE
200:

Line 210: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

206: SET confirmation_status_flag = 'N'
207: WHERE treasury_confirmation_id = g_treasury_conf_id;
208:
209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
210: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
211: 'The Confirm Process has failed.');
212: END IF;
213:
214: END IF;

Line 218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

214: END IF;
215:
216: ELSIF p_button_name = 'TREASURY_CONFIRMATION.BACK_OUT' THEN
217: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
219: 'Backout Process begins');
220: END IF;
221: if g_dit_flag = 'Y' THEN
222:

Line 237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

233: SET confirmation_status_flag = 'B'
234: WHERE treasury_confirmation_id = g_treasury_conf_id;
235:
236: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
238: 'The Backout Process is Successful');
239: END IF;
240: ELSE
241: ROLLBACK TO FV_TREAS;

Line 249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

245: SET confirmation_status_flag = 'Y'
246: WHERE treasury_confirmation_id = g_treasury_conf_id;
247:
248: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
250: 'The Backout Process has failed.');
251: END IF;
252:
253: END IF;

Line 256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

252:
253: END IF;
254: ELSE
255: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
257: 'No Treasury Confirmation process');
258: END IF;
259: RETURN;
260: END IF;

Line 267: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_errmsg);

263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: g_errmsg := SQLERRM;
267: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_errmsg);
268: RAISE;
269: END Main;
270:
271: PROCEDURE DO_CONFIRM_PROCESS (x_status_code OUT NOCOPY VARCHAR2

Line 344: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

340: WHERE payment_instruction_id = g_payment_instr_id
341: AND org_id = g_org_id;
342:
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
345: 'l_checkrun_name = '||l_checkrun_name);
346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN

Line 350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

346: END IF;
347: EXCEPTION
348: WHEN OTHERS THEN
349: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
351: 'No Upgrade entries');
352: END IF;
353: l_checkrun_name := NULL;
354: END;

Line 425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

421:
422: l_diff := l_end_doc - l_begin_doc + 1;
423:
424: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
426: 'l_diff is ' || l_diff);
427: END IF;
428:
429: FOR i IN 1.. l_diff

Line 432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

428:
429: FOR i IN 1.. l_diff
430: LOOP
431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
433: 'l_row_num:'||l_row_num);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
435: 'l_check_tbl(l_row_num).check_id:'||
436: l_check_tbl(l_row_num).check_id);

Line 434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

430: LOOP
431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
433: 'l_row_num:'||l_row_num);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
435: 'l_check_tbl(l_row_num).check_id:'||
436: l_check_tbl(l_row_num).check_id);
437: END IF;
438:

Line 460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

456: FETCH cur_corr_treas_pay_num INTO l_corr_treas_pay_num, l_offset_check_id;
457: EXIT WHEN cur_corr_treas_pay_num%NOTFOUND;
458:
459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
461: 'In corrected treasury pay number loop');
462: END IF;
463:
464: IF l_corr_treas_pay_num IS NOT NULL THEN

Line 484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

480:
481:
482: IF x_status_code= 'SUCCESS' THEN
483:
484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
485: 'Treasury Confirmation Successful. Checking for Voided Checks');
486:
487: SELECT COUNT(ac.check_id) INTO l_void_count
488: FROM ap_checks_all ac

Line 499: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

495:
496: IF l_void_count <> 0 THEN
497:
498:
499: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
500: 'Voided Checks = ' || l_void_count);
501:
502:
503: INSERT INTO fv_voided_checks

Line 547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

543: WHERE treasury_confirmation_id = g_treasury_conf_id;
544:
545: commit;
546:
547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
548: 'Calling Create treasury payment for Voided Checks');
549:
550: create_treasury_payment_event(l_calling_sequence,
551: 'TREASURY_VOID',

Line 557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

553: x_status_code,
554: x_return_status);
555:
556:
557: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
558: 'After Create treasury payment for Voided Checks');
559:
560: BEGIN
561:

Line 565: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

561:
562: IF (x_status_code = 'SUCCESS') THEN
563:
564:
565: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
566: 'Create treasury payment for Voided Checks is Successful');
567:
568: UPDATE fv_voided_checks
569: SET processed_flag = 'P'

Line 586: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||

582: END IF;
583:
584: EXCEPTION
585: WHEN OTHERS THEN
586: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
587: 'Error in Creating Void Accounting ',SQLERRM);
588: END;
589:
590:

Line 660: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||

656: ORDER BY period_year,period_num ASC ;
657:
658: EXCEPTION
659: WHEN others THEN
660: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
661: 'Error in getting next Open Period',SQLERRM);
662: RETURN;
663:
664: END;

Line 742: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

738: l_calling_sequence := p_calling_sequence || ' -> FV_TREASURY_PAYMENTS_PKG.CREATE_TREASURY_PAYMENT_EVENT';
739: l_module_name := g_module_name||'Create_Treasury_Payment_Event';
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
743: 'Calling Sequence: '||p_calling_sequence);
744: END IF;
745:
746: --Set the reference info value based on event type

Line 944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name ,

940:
941: IF l_retcode <> 0 THEN
942: l_api_message := 'Error Accounting for Events in SLA';
943: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name ,
945: l_api_message);
946: END IF;
947: x_status_code := 'FAILURE';
948: RAISE FND_API.g_exc_error;

Line 988: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'Start Of Void');

984:
985: treas_conf_rec cur_treas_conf%ROWTYPE;
986:
987: BEGIN
988: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'Start Of Void');
989:
990: l_module_name := g_module_name || 'Void';
991: l_calling_sequence := 'FV_TREASURY_PAYMENTS_PKG.Void_Payments';
992: l_reference1 := 'Void';

Line 1000: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');

996: MO_UTILS.get_ledger_info(g_org_id, g_ledger_id, l_ledger_name);
997: END IF;
998:
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'INSERT INTO fv_voided_checks');
1001: END IF;
1002:
1003: BEGIN
1004: INSERT INTO fv_voided_checks

Line 1044: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks1',l_err_stage);

1040: WHEN OTHERS THEN
1041: l_err_code := SQLCODE;
1042: l_err_stage := SQLERRM;
1043: X_retcode:=2;
1044: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||' insert fv_voided_checks1',l_err_stage);
1045: END;
1046:
1047: l_status_code:='SUCCESS';
1048:

Line 1101: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||

1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: l_err_code := SQLCODE;
1100: l_err_stage := SQLERRM;
1101: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||
1102: 'update fv_voided_checks1',l_err_stage);
1103: END;
1104: ELSE
1105: l_status_code:='SUCCESS';

Line 1128: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);

1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: l_err_code := SQLCODE;
1127: l_err_stage := SQLERRM;
1128: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);
1129: END;
1130: */
1131:
1132: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');

Line 1132: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');

1128: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'update fv_voided_checks1',l_err_stage);
1129: END;
1130: */
1131:
1132: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'End Of Void');
1133: X_retcode:=0;
1134: END Void;
1135:
1136: