DBA Data[Home] [Help]

APPS.JAI_AP_TDS_OLD_PKG dependencies on FND_FILE

Line 431: Fnd_File.put_line(Fnd_File.LOG, 'The TDS invoice has already been cancelled');

427: FETCH for_payment_status INTO for_pay_status_tds_rec;
428: CLOSE for_payment_status;
429:
430: if for_pay_status_tds_rec.cancelled_date is not null then -- bug#3607133
431: Fnd_File.put_line(Fnd_File.LOG, 'The TDS invoice has already been cancelled');
432: end if;
433:
434: IF for_pay_status_tds_rec.payment_status_flag = 'N' THEN --1
435:

Line 654: Fnd_File.put_line(Fnd_File.LOG,

650: fetch c_get_cm_status into v_cancelled_date_cm;
651: close c_get_cm_status;
652:
653: if v_cancelled_date_cm is not null then
654: Fnd_File.put_line(Fnd_File.LOG,
655: 'Not generating cancelled invoice as the supplier CM is already cancelled');
656: v_flag := 'N';
657:
658: else

Line 1328: Fnd_File.put_line(Fnd_File.LOG,'Inside IF check_for_tds_invoice_o%FOUND');

1324:
1325:
1326:
1327: IF check_for_tds_invoice_o%FOUND THEN --2
1328: Fnd_File.put_line(Fnd_File.LOG,'Inside IF check_for_tds_invoice_o%FOUND');
1329: v_tds_invoice_num := check_tds_original_rec.tds_invoice_num;
1330: v_invoice_id := check_tds_original_rec.invoice_ID;
1331: v_invoice_amount := check_tds_original_rec.invoice_amount;
1332: v_amt_reversed := check_tds_original_rec.amt_reversed;

Line 1347: Fnd_File.put_line(Fnd_File.LOG,'Inside ELSIF check_for_tds_invoice_o%NOTFOUND');

1343:
1344: -- start the following else part is added on 08/08/2002 by Aparajita for bug # 2461706
1345: ELSIF check_for_tds_invoice_o%NOTFOUND THEN
1346:
1347: Fnd_File.put_line(Fnd_File.LOG,'Inside ELSIF check_for_tds_invoice_o%NOTFOUND');
1348:
1349: v_tds_invoice_num := check_tds_prepayment_rec.tds_invoice_num;
1350: v_invoice_id := check_tds_prepayment_rec.invoice_ID;
1351: v_invoice_amount := check_tds_prepayment_rec.invoice_amount;

Line 2161: fnd_file.put_line(fnd_file.log, 'Start of function f_return_inv_amount ');

2157:
2158:
2159: begin
2160:
2161: fnd_file.put_line(fnd_file.log, 'Start of function f_return_inv_amount ');
2162:
2163: v_distribution_cnt:=0;
2164:
2165: for c_rec in c_inv_distribution_details('PREPAY','JA.IN.APXINWKB.DISTRIBUTIONS') --rchandan for bug#4428980

Line 2242: fnd_file.put_line(fnd_file.log, 'Prepayment amount : ' || v_prepayment_amount);

2238: null;
2239:
2240: end loop; -- prepayment
2241:
2242: fnd_file.put_line(fnd_file.log, 'Prepayment amount : ' || v_prepayment_amount);
2243:
2244: -- set the prepaid amount and net amount.
2245: for v_loop_index in 1 .. v_distribution_cnt loop
2246:

Line 2282: fnd_file.put_line(fnd_file.log, 'End of function f_return_inv_amount. Return invoice amount :' || v_return_inv_amt);

2278: end if;
2279:
2280: end loop;
2281:
2282: fnd_file.put_line(fnd_file.log, 'End of function f_return_inv_amount. Return invoice amount :' || v_return_inv_amt);
2283: return v_return_inv_amt;
2284:
2285: exception
2286: when others then

Line 2287: fnd_file.put_line(fnd_file.log, 'Exception function f_return_inv_amount :' || sqlerrm);

2283: return v_return_inv_amt;
2284:
2285: exception
2286: when others then
2287: fnd_file.put_line(fnd_file.log, 'Exception function f_return_inv_amount :' || sqlerrm);
2288: return 0;
2289: end f_return_inv_amount;
2290:
2291: -- End function added by bug#3218881

Line 2349: procedure was raising a no data found exception. Added Fnd_File.put_line(Fnd_File.LOG,'') statements to generate log for this concurrent.

2345: to the request for approval, but that parameter was not getting used in the called object.
2346:
2347: 10 23-may-2002 Aparajita bug # 2385421
2348: RTN invoice and TDS CM not created on applying a prepayment to a tds invoice. The
2349: procedure was raising a no data found exception. Added Fnd_File.put_line(Fnd_File.LOG,'') statements to generate log for this concurrent.
2350:
2351: 11. 08-july-2002 Aparajita Bug # 2439034.
2352: Changes on the same line as that done for this bug in unapply prepayment, the
2353: object is jai_ap_tds_old_pkg.process_prepayment_unapply.

Line 2436: Fnd_File.put_line(Fnd_File.LOG,'Starting OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');

2432: debug_flag := 'N' ;
2433: v_Approved_Invoice_Flag := 'N';-- added by Aparajita on 29/07/2002 for bug # 2475416
2434: /* Ramananda for File.Sql.35*/
2435:
2436: Fnd_File.put_line(Fnd_File.LOG,'Starting OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
2437: fnd_file.put_line(fnd_file.log,'invoice_id ='||p_invoice_id);
2438: fnd_file.put_line(fnd_file.log,'invoice_distribution_id ='||p_invoice_distribution_id);
2439: fnd_file.put_line(fnd_file.log,'prepay_invoice_distribution_id ='||p_prepay_dist_id);
2440:

Line 2437: fnd_file.put_line(fnd_file.log,'invoice_id ='||p_invoice_id);

2433: v_Approved_Invoice_Flag := 'N';-- added by Aparajita on 29/07/2002 for bug # 2475416
2434: /* Ramananda for File.Sql.35*/
2435:
2436: Fnd_File.put_line(Fnd_File.LOG,'Starting OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
2437: fnd_file.put_line(fnd_file.log,'invoice_id ='||p_invoice_id);
2438: fnd_file.put_line(fnd_file.log,'invoice_distribution_id ='||p_invoice_distribution_id);
2439: fnd_file.put_line(fnd_file.log,'prepay_invoice_distribution_id ='||p_prepay_dist_id);
2440:
2441:

Line 2438: fnd_file.put_line(fnd_file.log,'invoice_distribution_id ='||p_invoice_distribution_id);

2434: /* Ramananda for File.Sql.35*/
2435:
2436: Fnd_File.put_line(Fnd_File.LOG,'Starting OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
2437: fnd_file.put_line(fnd_file.log,'invoice_id ='||p_invoice_id);
2438: fnd_file.put_line(fnd_file.log,'invoice_distribution_id ='||p_invoice_distribution_id);
2439: fnd_file.put_line(fnd_file.log,'prepay_invoice_distribution_id ='||p_prepay_dist_id);
2440:
2441:
2442: /*** --CHECK IF TDS INVOICE FOR PREPAYMENT INVOICE EXISTS.**************/

Line 2439: fnd_file.put_line(fnd_file.log,'prepay_invoice_distribution_id ='||p_prepay_dist_id);

2435:
2436: Fnd_File.put_line(Fnd_File.LOG,'Starting OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
2437: fnd_file.put_line(fnd_file.log,'invoice_id ='||p_invoice_id);
2438: fnd_file.put_line(fnd_file.log,'invoice_distribution_id ='||p_invoice_distribution_id);
2439: fnd_file.put_line(fnd_file.log,'prepay_invoice_distribution_id ='||p_prepay_dist_id);
2440:
2441:
2442: /*** --CHECK IF TDS INVOICE FOR PREPAYMENT INVOICE EXISTS.**************/
2443: OPEN check_for_tds_invoice(p_prepay_dist_id, p_attribute); -- replaced prepay_id with p_prepay_dist_id 25-09-00

Line 2459: Fnd_File.put_line(Fnd_File.LOG,

2455:
2456:
2457: -- Start added by Aparajita for bug # 2779968 on 10/02/2003
2458: if check_tds_prepayment_rec.invoice_id is null then
2459: Fnd_File.put_line(Fnd_File.LOG,
2460: 'Returning as TDS does not exist for the Prepayment invoice. No further processing is required ');
2461:
2462: Return;
2463: end if;

Line 2487: Fnd_File.put_line(Fnd_File.LOG,'END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P AS param = U');

2483: --OR p_param = 'U' THEN -- Condition added by Ajay Sharma on 10-May-01
2484:
2485: IF p_param = 'U' THEN --added on 31-Jan-2002
2486: x:= NULL;
2487: Fnd_File.put_line(Fnd_File.LOG,'END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P AS param = U');
2488: RETURN;
2489: END IF;
2490:
2491:

Line 2495: Fnd_File.put_line(Fnd_File.LOG,'Inside IF check_tds_prepayment_rec.invoice_id IS NOT NULL');

2491:
2492:
2493: IF check_tds_prepayment_rec.invoice_id IS NOT NULL THEN --1
2494:
2495: Fnd_File.put_line(Fnd_File.LOG,'Inside IF check_tds_prepayment_rec.invoice_id IS NOT NULL');
2496: v_stage:=2;
2497:
2498: --GET VENDOR ID BASED ON THE TAX-ID FOR THE PREPAYMENT INVOICE.
2499:

Line 2525: Fnd_File.put_line(Fnd_File.LOG,'Inside IF check_for_tds_invoice_o%FOUND');

2521:
2522:
2523: IF check_for_tds_invoice_o%FOUND THEN --2
2524: --added on 05-Feb-2002
2525: Fnd_File.put_line(Fnd_File.LOG,'Inside IF check_for_tds_invoice_o%FOUND');
2526: v_stage:=3;
2527: var_tds_invoice_num := check_tds_original_rec.tds_invoice_num;
2528: var_invoice_id := check_tds_original_rec.invoice_ID;
2529: var_tds_tax_id := check_tds_original_rec.tds_tax_id;

Line 2540: Fnd_File.put_line(Fnd_File.LOG,'Inside ELSIF check_for_tds_invoice_o%NOTFOUND');

2536: v_tds_cm_num := check_tds_original_rec.tds_invoice_num;
2537:
2538: ELSIF check_for_tds_invoice_o%NOTFOUND THEN
2539:
2540: Fnd_File.put_line(Fnd_File.LOG,'Inside ELSIF check_for_tds_invoice_o%NOTFOUND');
2541: v_stage:=4;
2542: var_tds_invoice_num := check_tds_prepayment_rec.tds_invoice_num;
2543: var_invoice_id := check_tds_prepayment_rec.invoice_ID;
2544: var_tds_tax_id := check_tds_prepayment_rec.tds_tax_id;

Line 2587: Fnd_File.put_line(Fnd_File.LOG,'calculating the proportionate tax TO be applied');

2583: CLOSE for_payment_amount;
2584:
2585: --CALCULATING THE PROPORTIONATE TAX TO BE APPLIED.
2586:
2587: Fnd_File.put_line(Fnd_File.LOG,'calculating the proportionate tax TO be applied');
2588: Fnd_File.put_line(Fnd_File.LOG,'p_amount = ' || p_amount);
2589: Fnd_File.put_line(Fnd_File.LOG,'for_prepay_payment_amount_rec.amount = ' || for_prepay_payment_amount_rec.amount);
2590: Fnd_File.put_line(Fnd_File.LOG,'check_tds_prepayment_rec.invoice_amount = ' || check_tds_prepayment_rec.invoice_amount);
2591:

Line 2588: Fnd_File.put_line(Fnd_File.LOG,'p_amount = ' || p_amount);

2584:
2585: --CALCULATING THE PROPORTIONATE TAX TO BE APPLIED.
2586:
2587: Fnd_File.put_line(Fnd_File.LOG,'calculating the proportionate tax TO be applied');
2588: Fnd_File.put_line(Fnd_File.LOG,'p_amount = ' || p_amount);
2589: Fnd_File.put_line(Fnd_File.LOG,'for_prepay_payment_amount_rec.amount = ' || for_prepay_payment_amount_rec.amount);
2590: Fnd_File.put_line(Fnd_File.LOG,'check_tds_prepayment_rec.invoice_amount = ' || check_tds_prepayment_rec.invoice_amount);
2591:
2592: v_stage:=5;

Line 2589: Fnd_File.put_line(Fnd_File.LOG,'for_prepay_payment_amount_rec.amount = ' || for_prepay_payment_amount_rec.amount);

2585: --CALCULATING THE PROPORTIONATE TAX TO BE APPLIED.
2586:
2587: Fnd_File.put_line(Fnd_File.LOG,'calculating the proportionate tax TO be applied');
2588: Fnd_File.put_line(Fnd_File.LOG,'p_amount = ' || p_amount);
2589: Fnd_File.put_line(Fnd_File.LOG,'for_prepay_payment_amount_rec.amount = ' || for_prepay_payment_amount_rec.amount);
2590: Fnd_File.put_line(Fnd_File.LOG,'check_tds_prepayment_rec.invoice_amount = ' || check_tds_prepayment_rec.invoice_amount);
2591:
2592: v_stage:=5;
2593:

Line 2590: Fnd_File.put_line(Fnd_File.LOG,'check_tds_prepayment_rec.invoice_amount = ' || check_tds_prepayment_rec.invoice_amount);

2586:
2587: Fnd_File.put_line(Fnd_File.LOG,'calculating the proportionate tax TO be applied');
2588: Fnd_File.put_line(Fnd_File.LOG,'p_amount = ' || p_amount);
2589: Fnd_File.put_line(Fnd_File.LOG,'for_prepay_payment_amount_rec.amount = ' || for_prepay_payment_amount_rec.amount);
2590: Fnd_File.put_line(Fnd_File.LOG,'check_tds_prepayment_rec.invoice_amount = ' || check_tds_prepayment_rec.invoice_amount);
2591:
2592: v_stage:=5;
2593:
2594: -- the following if commented by Aparajita for bug # 2647361

Line 2627: Fnd_File.put_line(Fnd_File.LOG,'inside case1 : payment_status_flag = N');

2623: AND for_payment_status_prepay_rec.payment_status_flag IN ('Y','N') --Added on 11-Dec-01
2624: AND for_vendor_id_original_rec.vendor_id = for_vendor_id_prepay_rec.vendor_id THEN
2625:
2626: ----------------CASE 1
2627: Fnd_File.put_line(Fnd_File.LOG,'inside case1 : payment_status_flag = N');
2628: v_stage:=6;
2629:
2630: OPEN for_std_invoice(for_pay_status_original_rec.invoice_id);
2631: FETCH for_std_invoice INTO for_std_invoice_tds_rec;

Line 2662: Fnd_File.put_line(Fnd_File.LOG,

2658: Open get_prepay_dist_date; -- bug 3112711 kpvs
2659: fetch get_prepay_dist_date into v_prepay_dist_date;
2660: close get_prepay_dist_date;
2661:
2662: Fnd_File.put_line(Fnd_File.LOG,
2663: 'BEFORE INSERTING INTO ap_invoices_interface 1 : CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX');
2664:
2665: v_stage:=7;
2666:

Line 2757: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 1 : CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED');

2753:
2754: -- following line added by Aparajita for bug # 2439034.
2755: v_ap_tds_cm_num := v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
2756:
2757: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 1 : CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED');
2758: v_stage:=8;
2759:
2760:
2761: /* Modified by Ramananda for bug# 4407184 ,start */

Line 2821: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');

2817: SELECT ap_invoices_interface_s.NEXTVAL
2818: INTO v_ap_invoices_interface_no
2819: FROM dual;
2820:
2821: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
2822: v_stage:=9;
2823:
2824: /* Modified by Ramananda for bug# 4407184 ,start */
2825:

Line 2914: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');

2910:
2911: -- following line added by Aparajita on 07/07/2002 for bug # 2439034
2912: v_ap_sup_inv_num := 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
2913:
2914: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
2915: v_stage:=10;
2916:
2917: /* Modified by Ramananda for bug# 4407184 , start */
2918: lv_standard_invoice_num := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;

Line 2981: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Payables OPEN INTERFACE Import concurrent request 1');

2977: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
2978: );
2979:
2980:
2981: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Payables OPEN INTERFACE Import concurrent request 1');
2982: v_stage:=11;
2983: result := Fnd_Request.set_mode(TRUE);
2984:
2985: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221

Line 3069: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Approval OF TDS AND CM concurrent request FOR invoice id '|| p_invoice_id);

3065: END;
3066:
3067: IF v_Approved_Invoice_Flag = 'Y' THEN
3068:
3069: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting the Approval OF TDS AND CM concurrent request FOR invoice id '|| p_invoice_id);
3070: v_stage:=12;
3071: result := Fnd_Request.set_mode(TRUE);
3072: req1_id := Fnd_Request.submit_request
3073: (

Line 3095: Fnd_File.put_line(Fnd_File.LOG,'Inside Case2 : payment_status_flag <> N ');

3091:
3092: IF for_pay_status_original_rec.payment_status_flag <> 'N'
3093: OR for_vendor_id_original_rec.vendor_id <> for_vendor_id_prepay_rec.vendor_id THEN
3094:
3095: Fnd_File.put_line(Fnd_File.LOG,'Inside Case2 : payment_status_flag <> N ');
3096: v_stage:=13;
3097: -- CASE 2
3098:
3099: OPEN for_std_invoice(for_payment_status_prepay_rec.invoice_id);

Line 3118: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 3:CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX');

3114: SELECT ap_invoices_interface_s.NEXTVAL
3115: INTO v_ap_invoices_interface_no
3116: FROM dual;
3117:
3118: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 3:CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX');
3119: v_stage:=14;
3120:
3121: /* Modified by Ramananda for bug# 4407184 ,start */
3122:

Line 3204: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 3 :CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED' );

3200:
3201: -- following line added by Aparajita for bug # 2439034.
3202: v_ap_tds_cm_num := for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
3203:
3204: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 3 :CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED' );
3205: v_stage:=14;
3206:
3207: /* Modified by Ramananda for bug# 4407184 , start */
3208: lv_credit_note_tds := 'CREDIT NOTE FOR TDS TAX AUTHORITY FOR TAX APPLIED BY '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id);

Line 3263: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');

3259: SELECT ap_invoices_interface_s.NEXTVAL
3260: INTO v_ap_invoices_interface_no
3261: FROM dual;
3262:
3263: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
3264: v_stage:=15;
3265:
3266: /* Modified by Ramananda for bug# 4407184 ,start */
3267:

Line 3354: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');

3350:
3351: -- following line added by Aparajita on 07/07/2002 for bug # 2439034
3352: v_ap_sup_inv_num := 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no);
3353:
3354: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoice_lines_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');
3355: v_stage:=15;
3356:
3357: /* Modified by Ramananda for bug# 4407184 , start */
3358: lv_standard_return_excess := 'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||TO_CHAR(p_invoice_id)||' OR '||TO_CHAR(p_invoice_distribution_id) ;

Line 3418: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Payables OPEN INTERFACE Import concurrent request 2');

3414: p_parent_inv_payment_priority => ln_prnt_pay_priority,
3415: p_parent_inv_exchange_rate => ln_prnt_exchange_rate
3416: );
3417:
3418: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Payables OPEN INTERFACE Import concurrent request 2');
3419: result := Fnd_Request.set_mode(TRUE);
3420:
3421: lv_batch_name := jai_ap_utils_pkg.get_tds_invoice_batch(p_invoice_id); --Ramananda for Bug#4584221
3422:

Line 3503: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Approval OF TDS AND CM concurrent request FOR invoice id ' || p_invoice_id);

3499:
3500: IF v_Approved_Invoice_Flag = 'Y' THEN
3501:
3502:
3503: Fnd_File.put_line(Fnd_File.LOG,'BEFORE submitting Approval OF TDS AND CM concurrent request FOR invoice id ' || p_invoice_id);
3504: v_stage:=16;
3505: result := Fnd_Request.set_mode(TRUE);
3506: req1_id := Fnd_Request.submit_request
3507: (

Line 3532: Fnd_File.put_line(Fnd_File.LOG,'SUCCESSFUL END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');

3528:
3529: --END IF;
3530:
3531: -- exception handler added by Aparajita on 22nd March 2002.
3532: Fnd_File.put_line(Fnd_File.LOG,'SUCCESSFUL END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
3533:
3534: EXCEPTION
3535:
3536: WHEN OTHERS THEN

Line 3559: Fnd_File.put_line(Fnd_File.LOG,'EXCEPTION END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');

3555: fnd_global.user_id, -- USER, -- Harshita for Bug 4866533
3556: -- added, Harshita for Bug 4866533
3557: fnd_global.user_id, sysdate
3558: );
3559: Fnd_File.put_line(Fnd_File.LOG,'EXCEPTION END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
3560: Fnd_File.put_line(Fnd_File.LOG,'Error message : ' || error_mesg);
3561:
3562: END process_prepayment_apply;
3563:

Line 3560: Fnd_File.put_line(Fnd_File.LOG,'Error message : ' || error_mesg);

3556: -- added, Harshita for Bug 4866533
3557: fnd_global.user_id, sysdate
3558: );
3559: Fnd_File.put_line(Fnd_File.LOG,'EXCEPTION END OF PROCEDURE Ja_In_Ap_Prepay_Invoice_P');
3560: Fnd_File.put_line(Fnd_File.LOG,'Error message : ' || error_mesg);
3561:
3562: END process_prepayment_apply;
3563:
3564: PROCEDURE approve_invoice

Line 3766: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');

3762: -- start added by Aparajita on 27/8/2002 for bug # 2518531.
3763: IF v_dev_phase = 'COMPLETE' THEN
3764:
3765: IF v_dev_status <> 'NORMAL' THEN
3766: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
3767: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);
3768: retcode := 1;
3769: errbuf := 'Exiting with warningr as parent request not completed with normal status';
3770: RETURN;

Line 3767: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);

3763: IF v_dev_phase = 'COMPLETE' THEN
3764:
3765: IF v_dev_status <> 'NORMAL' THEN
3766: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
3767: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || v_message);
3768: retcode := 1;
3769: errbuf := 'Exiting with warningr as parent request not completed with normal status';
3770: RETURN;
3771: END IF;