DBA Data[Home] [Help]

APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on FND_FILE

Line 313: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');

309:
310: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
311:
312: if v_debug_flag = 'Y' THEN
313: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
314: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
316: end if;
317:

Line 314: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);

310: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
311:
312: if v_debug_flag = 'Y' THEN
313: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
314: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
316: end if;
317:
318: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

Line 315: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);

311:
312: if v_debug_flag = 'Y' THEN
313: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
314: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
316: end if;
317:
318: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
319: FETCH master_ec_code_cur INTO v_ec_code;

Line 323: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);

319: FETCH master_ec_code_cur INTO v_ec_code;
320: CLOSE master_ec_code_cur;
321:
322: if v_debug_flag = 'Y' THEN
323: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
324: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
325: end if;
326:
327: For rg23_reg_rec IN rg23_part_i_register_id_cur(v_ec_code)

Line 324: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');

320: CLOSE master_ec_code_cur;
321:
322: if v_debug_flag = 'Y' THEN
323: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
324: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
325: end if;
326:
327: For rg23_reg_rec IN rg23_part_i_register_id_cur(v_ec_code)
328: Loop

Line 334: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rg23_reg_rec.register_id);

330: FETCH rg23_part_i_cur INTO rg23_rec;
331: CLOSE rg23_part_i_cur;
332:
333: if v_debug_flag = 'Y' THEN
334: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rg23_reg_rec.register_id);
335: end if;
336:
337: OPEN serial_no_cur(p_organization_id, nvl(p_location_id,0), rg23_rec.inventory_item_id, rg23_rec.fin_year,
338: rg23_rec.register_type);

Line 343: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);

339: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
340: CLOSE serial_no_cur;
341:
342: if v_debug_flag = 'Y' THEN
343: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
344: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
345: end if;
346:
347: IF v_previous_serial_no = 0

Line 344: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);

340: CLOSE serial_no_cur;
341:
342: if v_debug_flag = 'Y' THEN
343: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
344: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
345: end if;
346:
347: IF v_previous_serial_no = 0
348: THEN

Line 364: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance_qty is ' || v_opening_balance_qty);

360: v_closing_balance_qty := nvl(v_opening_balance_qty,0) + nvl(v_transaction_quantity,0);
361: END IF;
362:
363: if v_debug_flag = 'Y' THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance_qty is ' || v_opening_balance_qty);
365: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance_qty is ' || v_closing_balance_qty);
366: end if;
367: lv_remarks := rg23_rec.remarks || ' Master Org';--rchandan for bug#4428980
368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS

Line 365: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance_qty is ' || v_closing_balance_qty);

361: END IF;
362:
363: if v_debug_flag = 'Y' THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance_qty is ' || v_opening_balance_qty);
365: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance_qty is ' || v_closing_balance_qty);
366: end if;
367: lv_remarks := rg23_rec.remarks || ' Master Org';--rchandan for bug#4428980
368: INSERT INTO JAI_CMN_RG_23AC_I_TRXS
369: (register_id,

Line 494: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');

490:
491: End Loop;
492:
493: if v_debug_flag = 'Y' THEN
494: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
495: end if;
496:
497: --Exception added by Nagaraj.s for Bug2708516
498: Exception

Line 626: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');

622: --------------------------------------------------------------------------------------------*/
623: v_debug_flag := 'Y'; -- File.Sql.35 by Brathod
624:
625: if v_debug_flag = 'Y' THEN
626: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
627: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
628: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
629: end if;
630: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

Line 627: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);

623: v_debug_flag := 'Y'; -- File.Sql.35 by Brathod
624:
625: if v_debug_flag = 'Y' THEN
626: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
627: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
628: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
629: end if;
630: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
631: FETCH master_ec_code_cur INTO v_ec_code;

Line 628: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);

624:
625: if v_debug_flag = 'Y' THEN
626: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
627: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
628: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
629: end if;
630: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
631: FETCH master_ec_code_cur INTO v_ec_code;
632: CLOSE master_ec_code_cur;

Line 635: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);

631: FETCH master_ec_code_cur INTO v_ec_code;
632: CLOSE master_ec_code_cur;
633:
634: if v_debug_flag = 'Y' THEN
635: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
636: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
637: end if;
638:
639: For rg23_reg_rec IN rg23_part_ii_register_id_cur(v_ec_code)

Line 636: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');

632: CLOSE master_ec_code_cur;
633:
634: if v_debug_flag = 'Y' THEN
635: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
636: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
637: end if;
638:
639: For rg23_reg_rec IN rg23_part_ii_register_id_cur(v_ec_code)
640: Loop

Line 647: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rg23_reg_rec.register_id);

643: FETCH rg23_part_ii_cur INTO rg23_rec;
644: CLOSE rg23_part_ii_cur;
645:
646: if v_debug_flag = 'Y' THEN
647: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rg23_reg_rec.register_id);
648: end if;
649:
650: OPEN serial_no_cur(p_organization_id, nvl(p_location_id,0), rg23_rec.fin_year, rg23_rec.register_type);
651: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;

Line 655: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);

651: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
652: CLOSE serial_no_cur;
653:
654: if v_debug_flag = 'Y' THEN
655: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
656: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
657: end if;
658:
659: IF v_previous_serial_no = 0

Line 656: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);

652: CLOSE serial_no_cur;
653:
654: if v_debug_flag = 'Y' THEN
655: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
656: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
657: end if;
658:
659: IF v_previous_serial_no = 0
660: THEN

Line 673: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);

669: v_opening_balance := v_closing_balance;
670: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
671: END IF;
672: if v_debug_flag = 'Y' THEN
673: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
674: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
675: end if;
676:
677: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

Line 674: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);

670: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
671: END IF;
672: if v_debug_flag = 'Y' THEN
673: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
674: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
675: end if;
676:
677: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,
678: fin_year,

Line 759: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');

755: rg23_rec.last_update_login,
756: rg23_rec.other_tax_credit,
757: rg23_rec.other_tax_debit );
758: if v_debug_flag = 'Y' THEN
759: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
760: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
761: end if;
762:
763: UPDATE JAI_CMN_RG_23AC_II_TRXS

Line 760: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );

756: rg23_rec.other_tax_credit,
757: rg23_rec.other_tax_debit );
758: if v_debug_flag = 'Y' THEN
759: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
760: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
761: end if;
762:
763: UPDATE JAI_CMN_RG_23AC_II_TRXS
764: SET posted_flag = 'Y',

Line 778: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . Before calling other taxes ');

774: and source_type = 1
775: )
776: LOOP
777: if v_debug_flag = 'Y' THEN
778: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . Before calling other taxes ');
779: end if;
780: jai_cmn_rg_master_org_pkg.insert_rg23_others
781: (errbuf => lv_buffer,
782: retcode => lv_retcode,

Line 788: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with status = ' || lv_retcode);

784: p_tax_type => tax_types_rec.tax_type,
785: p_register_id => rg23_rec.register_id ) ;
786:
787: if v_debug_flag = 'Y' THEN
788: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with status = ' || lv_retcode);
789: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with error = ' || lv_buffer);
790: end if;
791:
792:

Line 789: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with error = ' || lv_buffer);

785: p_register_id => rg23_rec.register_id ) ;
786:
787: if v_debug_flag = 'Y' THEN
788: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with status = ' || lv_retcode);
789: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with error = ' || lv_buffer);
790: end if;
791:
792:
793:

Line 797: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.80 . Error is ' || lv_buffer || ' Halting the processing ... ');

793:
794:
795: if nvl(lv_retcode,'0') <> '0' then /* if not success then get out the loop */
796: if v_debug_flag = 'Y' THEN
797: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.80 . Error is ' || lv_buffer || ' Halting the processing ... ');
798: end if;
799: ERRBUF := lv_buffer ;
800: goto errhandling_block; /* Halt the processing and no more records would get processed. */
801: end if;

Line 807: FND_FILE.PUT_LINE(FND_FILE.LOG, '*******************************************************************');

803:
804: -- ended by hjujjuru for #Bug 4106667
805:
806: if v_debug_flag = 'Y' THEN
807: FND_FILE.PUT_LINE(FND_FILE.LOG, '*******************************************************************');
808: end if;
809:
810: End Loop;
811:

Line 826: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);

822: FETCH c_final_balance_rg23 INTO v_rg23c_final_balance;
823: CLOSE c_final_balance_rg23;
824:
825: if v_debug_flag = 'Y' THEN
826: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);
827: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);
828: end if;
829: UPDATE JAI_CMN_RG_BALANCES
830: SET RG23A_BALANCE = v_rg23a_final_balance, RG23C_BALANCE=v_rg23c_final_balance

Line 827: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);

823: CLOSE c_final_balance_rg23;
824:
825: if v_debug_flag = 'Y' THEN
826: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);
827: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);
828: end if;
829: UPDATE JAI_CMN_RG_BALANCES
830: SET RG23A_BALANCE = v_rg23a_final_balance, RG23C_BALANCE=v_rg23c_final_balance
831: where organization_id=p_organization_id

Line 835: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');

831: where organization_id=p_organization_id
832: and location_id =p_location_id;
833: --Ends here.....
834: if v_debug_flag = 'Y' THEN
835: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
836: end if;
837: --Exception added by Nagaraj.s for Bug263674
838:
839: retcode := '0';

Line 846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in the err handling block ' || lv_buffer );

842: <>
843: Rollback; /* Rolling back because there was some problem */
844: RETCODE := '2';
845: if v_debug_flag = 'Y' THEN
846: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in the err handling block ' || lv_buffer );
847: end if;
848: Exception
849: WHEN OTHERS THEN
850:

Line 854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );

850:
851: RETCODE := '2' ;
852: RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
853: if v_debug_flag = 'Y' THEN
854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
856: end if;
857: End consolidate_rg23_part_ii;
858:

Line 855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );

851: RETCODE := '2' ;
852: RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
853: if v_debug_flag = 'Y' THEN
854: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
855: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
856: end if;
857: End consolidate_rg23_part_ii;
858:
859: PROCEDURE consolidate_pla

Line 991: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');

987: --------------------------------------------------------------------------------------------*/
988:
989: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
990: if v_debug_flag = 'Y' THEN
991: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
992: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
993: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
994: end if;
995:

Line 992: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);

988:
989: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
990: if v_debug_flag = 'Y' THEN
991: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
992: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
993: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
994: end if;
995:
996: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

Line 993: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);

989: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
990: if v_debug_flag = 'Y' THEN
991: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
992: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
993: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
994: end if;
995:
996: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
997: FETCH master_ec_code_cur INTO v_ec_code;

Line 1001: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);

997: FETCH master_ec_code_cur INTO v_ec_code;
998: CLOSE master_ec_code_cur;
999:
1000: if v_debug_flag = 'Y' THEN
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
1002: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
1003: end if;
1004:
1005: For pla_reg_rec IN pla_register_id_cur(v_ec_code)

Line 1002: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');

998: CLOSE master_ec_code_cur;
999:
1000: if v_debug_flag = 'Y' THEN
1001: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
1002: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
1003: end if;
1004:
1005: For pla_reg_rec IN pla_register_id_cur(v_ec_code)
1006: Loop

Line 1012: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || pla_reg_rec.register_id);

1008: FETCH pla_cur INTO pla_rec;
1009: CLOSE pla_cur;
1010:
1011: if v_debug_flag = 'Y' THEN
1012: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || pla_reg_rec.register_id);
1013: end if;
1014:
1015: OPEN serial_no_cur(p_organization_id, nvl(p_location_id,0), pla_rec.fin_year /*, pla_rec.register_type*/ );
1016: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;

Line 1020: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);

1016: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
1017: CLOSE serial_no_cur;
1018:
1019: if v_debug_flag = 'Y' THEN
1020: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
1022: end if;
1023:
1024: IF v_previous_serial_no = 0

Line 1021: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);

1017: CLOSE serial_no_cur;
1018:
1019: if v_debug_flag = 'Y' THEN
1020: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
1021: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
1022: end if;
1023:
1024: IF v_previous_serial_no = 0
1025: THEN

Line 1039: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);

1035: v_opening_balance := v_closing_balance;
1036: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
1037: END IF;
1038: if v_debug_flag = 'Y' THEN
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
1041: end if;
1042: INSERT INTO JAI_CMN_RG_PLA_TRXS (register_id,
1043: fin_year,

Line 1040: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);

1036: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
1037: END IF;
1038: if v_debug_flag = 'Y' THEN
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
1041: end if;
1042: INSERT INTO JAI_CMN_RG_PLA_TRXS (register_id,
1043: fin_year,
1044: slno,

Line 1156: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.80 . Error is ' || lv_buffer || ' Halting the processing ... ');

1152: );
1153:
1154: if nvl(lv_retcode,'0') <> '0' then /* if not success then get out the loop */
1155: if v_debug_flag = 'Y' THEN
1156: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.80 . Error is ' || lv_buffer || ' Halting the processing ... ');
1157: end if;
1158: ERRBUF := lv_buffer ;
1159: goto errhandling_block; /* Halt the processing and no more records would get processed. */
1160: end if;

Line 1169: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.81 The v_record_count is ' || v_record_count);

1165:
1166: End Loop;
1167:
1168: if v_debug_flag = 'Y' THEN
1169: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.81 The v_record_count is ' || v_record_count);
1170: end if;
1171:
1172: if v_record_count >0 then --3335814
1173: --Added by Nagaraj.s for Bug2708514

Line 1185: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);

1181: FETCH c_final_balance_pla INTO v_pla_balance;
1182: CLOSE c_final_balance_pla;
1183:
1184: if v_debug_flag = 'Y' THEN
1185: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1187: end if;
1188:
1189: --This is for Updation of RG Balances table

Line 1186: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);

1182: CLOSE c_final_balance_pla;
1183:
1184: if v_debug_flag = 'Y' THEN
1185: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);
1186: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1187: end if;
1188:
1189: --This is for Updation of RG Balances table
1190: UPDATE JAI_CMN_RG_BALANCES

Line 1198: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');

1194: end if; --end if for v_record_count.
1195:
1196: --Ends here.....
1197: if v_debug_flag = 'Y' THEN
1198: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
1199: end if;
1200:
1201: retcode := '0';
1202: ERRBUF := NULL;

Line 1326: FND_FILE.PUT_LINE(FND_FILE.LOG, '********* START OF LOG FILE - '||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' *********');

1322:
1323: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1324:
1325: if v_debug_flag = 'Y' THEN
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, '********* START OF LOG FILE - '||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' *********');
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 organization->' || p_organization_id||', Location->' || p_location_id);
1328: end if;
1329:
1330: v_statement_id := '1';

Line 1327: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 organization->' || p_organization_id||', Location->' || p_location_id);

1323: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1324:
1325: if v_debug_flag = 'Y' THEN
1326: FND_FILE.PUT_LINE(FND_FILE.LOG, '********* START OF LOG FILE - '||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' *********');
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 organization->' || p_organization_id||', Location->' || p_location_id);
1328: end if;
1329:
1330: v_statement_id := '1';
1331: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

Line 1336: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 Before the Main Loop, EC Code->' || v_ec_code);

1332: FETCH master_ec_code_cur INTO v_ec_code;
1333: CLOSE master_ec_code_cur;
1334:
1335: if v_debug_flag = 'Y' THEN
1336: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 Before the Main Loop, EC Code->' || v_ec_code);
1337: end if;
1338:
1339: FOR rgi_reg_rec IN rgi_register_id_cur(v_ec_code) LOOP
1340:

Line 1345: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rgi_reg_rec.register_id);

1341: v_regid_being_processed := rgi_reg_rec.register_id;
1342:
1343: v_statement_id := '2';
1344: if v_debug_flag = 'Y' THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rgi_reg_rec.register_id);
1346: end if;
1347:
1348: v_statement_id := '2a';
1349:

Line 1388: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 ChildItem->' || rgi_rec.inventory_item_id

1384:
1385: v_prev_item_id := rgi_rec.inventory_item_id;
1386:
1387: IF v_debug_flag = 'Y' THEN
1388: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 ChildItem->' || rgi_rec.inventory_item_id
1389: ||', v_fin_year->' || v_fin_year
1390: ||', v_serial_no->' || v_serial_no
1391: ||', bal_pac->' || v_balance_packed||', bal_loo->' || v_balance_loose||', man_qty->' || v_manu_qty);
1392: END IF;

Line 1423: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.51 v_fin_year->' || v_fin_year||', bal_loo->' || v_balance_loose

1419: - nvl(rgi_rec.other_purpose_pay_ed_qty,0)
1420: + nvl(rgi_rec.manufactured_loose_qty,0);
1421:
1422: IF v_debug_flag = 'Y' THEN
1423: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.51 v_fin_year->' || v_fin_year||', bal_loo->' || v_balance_loose
1424: ||', serial_no->' || v_serial_no);
1425: END IF;
1426:
1427: v_statement_id := '8';

Line 1549: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');

1545:
1546: END LOOP;
1547:
1548: if v_debug_flag = 'Y' THEN
1549: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
1550: end if;
1551:
1552: --Exception added by Nagaraj.s for Bug2708518
1553: Exception

Line 1556: FND_FILE.PUT_LINE(FND_FILE.LOG, '######### Error at: v_regid_being_processed->'||v_regid_being_processed

1552: --Exception added by Nagaraj.s for Bug2708518
1553: Exception
1554: WHEN OTHERS THEN
1555:
1556: FND_FILE.PUT_LINE(FND_FILE.LOG, '######### Error at: v_regid_being_processed->'||v_regid_being_processed
1557: ||', statement_id->'||v_statement_id
1558: ||', SQLERRM->'||SQLERRM
1559: );
1560: