DBA Data[Home] [Help]

APPS.JAI_CMN_RG_MASTER_ORG_PKG dependencies on FND_FILE

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

317:
318: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
319:
320: if v_debug_flag = 'Y' THEN
321: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
322: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
323: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
324: end if;
325:

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

318: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
319:
320: if v_debug_flag = 'Y' THEN
321: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
322: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
323: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
324: end if;
325:
326: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

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

319:
320: if v_debug_flag = 'Y' THEN
321: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
322: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
323: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
324: end if;
325:
326: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
327: FETCH master_ec_code_cur INTO v_ec_code;

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

327: FETCH master_ec_code_cur INTO v_ec_code;
328: CLOSE master_ec_code_cur;
329:
330: if v_debug_flag = 'Y' THEN
331: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
332: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
333: end if;
334:
335: For rg23_reg_rec IN rg23_part_i_register_id_cur(v_ec_code)

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

328: CLOSE master_ec_code_cur;
329:
330: if v_debug_flag = 'Y' THEN
331: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
332: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
333: end if;
334:
335: For rg23_reg_rec IN rg23_part_i_register_id_cur(v_ec_code)
336: Loop

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

338: FETCH rg23_part_i_cur INTO rg23_rec;
339: CLOSE rg23_part_i_cur;
340:
341: if v_debug_flag = 'Y' THEN
342: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rg23_reg_rec.register_id);
343: end if;
344:
345: /*Bug 9550254 - Start*/
346: /*

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

354: rg23_rec.fin_year,rg23_rec.register_type,v_previous_serial_no);
355: /*Bug 9550254 - End*/
356:
357: if v_debug_flag = 'Y' THEN
358: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
359: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
360: end if;
361:
362: IF nvl(v_previous_serial_no, 0) = 0 -- Bug 9550254 - Added NVL

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

355: /*Bug 9550254 - End*/
356:
357: if v_debug_flag = 'Y' THEN
358: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
359: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
360: end if;
361:
362: IF nvl(v_previous_serial_no, 0) = 0 -- Bug 9550254 - Added NVL
363: THEN

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

379: v_closing_balance_qty := nvl(v_opening_balance_qty,0) + nvl(v_transaction_quantity,0);
380: END IF;
381:
382: if v_debug_flag = 'Y' THEN
383: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance_qty is ' || v_opening_balance_qty);
384: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance_qty is ' || v_closing_balance_qty);
385: end if;
386: lv_remarks := substr(rg23_rec.remarks,1,100); /*Added by nprashar for bug # 13649626*/
387: lv_remarks := substr(lv_remarks||' - Master Org',1,120); /*Added by nprashar for bug # 13649626*/

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

380: END IF;
381:
382: if v_debug_flag = 'Y' THEN
383: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance_qty is ' || v_opening_balance_qty);
384: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance_qty is ' || v_closing_balance_qty);
385: end if;
386: lv_remarks := substr(rg23_rec.remarks,1,100); /*Added by nprashar for bug # 13649626*/
387: lv_remarks := substr(lv_remarks||' - Master Org',1,120); /*Added by nprashar for bug # 13649626*/
388:

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

513:
514: End Loop;
515:
516: if v_debug_flag = 'Y' THEN
517: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
518: end if;
519:
520: --Exception added by Nagaraj.s for Bug2708516
521: Exception

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

645: --------------------------------------------------------------------------------------------*/
646: v_debug_flag := 'Y'; -- File.Sql.35 by Brathod
647:
648: if v_debug_flag = 'Y' THEN
649: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
650: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
651: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
652: end if;
653: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

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

646: v_debug_flag := 'Y'; -- File.Sql.35 by Brathod
647:
648: if v_debug_flag = 'Y' THEN
649: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
650: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
651: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
652: end if;
653: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
654: FETCH master_ec_code_cur INTO v_ec_code;

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

647:
648: if v_debug_flag = 'Y' THEN
649: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
650: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
651: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
652: end if;
653: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
654: FETCH master_ec_code_cur INTO v_ec_code;
655: CLOSE master_ec_code_cur;

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

654: FETCH master_ec_code_cur INTO v_ec_code;
655: CLOSE master_ec_code_cur;
656:
657: if v_debug_flag = 'Y' THEN
658: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
659: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
660: end if;
661:
662: For rg23_reg_rec IN rg23_part_ii_register_id_cur(v_ec_code)

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

655: CLOSE master_ec_code_cur;
656:
657: if v_debug_flag = 'Y' THEN
658: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
659: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
660: end if;
661:
662: For rg23_reg_rec IN rg23_part_ii_register_id_cur(v_ec_code)
663: Loop

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

666: FETCH rg23_part_ii_cur INTO rg23_rec;
667: CLOSE rg23_part_ii_cur;
668:
669: if v_debug_flag = 'Y' THEN
670: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rg23_reg_rec.register_id);
671: end if;
672:
673: OPEN serial_no_cur(p_organization_id, nvl(p_location_id,0), rg23_rec.fin_year, rg23_rec.register_type);
674: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;

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

674: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
675: CLOSE serial_no_cur;
676:
677: if v_debug_flag = 'Y' THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
679: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
680: end if;
681:
682: IF v_previous_serial_no = 0

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

675: CLOSE serial_no_cur;
676:
677: if v_debug_flag = 'Y' THEN
678: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
679: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
680: end if;
681:
682: IF v_previous_serial_no = 0
683: THEN

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

692: v_opening_balance := v_closing_balance;
693: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
694: END IF;
695: if v_debug_flag = 'Y' THEN
696: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
697: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
698: end if;
699:
700: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

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

693: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
694: END IF;
695: if v_debug_flag = 'Y' THEN
696: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
697: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
698: end if;
699:
700: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,
701: fin_year,

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

786: rg23_rec.additional_cvd_amt,
787: rg23_rec.cr_additional_cvd,
788: rg23_rec.dr_additional_cvd );
789: if v_debug_flag = 'Y' THEN
790: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
791: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
792: end if;
793:
794: UPDATE JAI_CMN_RG_23AC_II_TRXS

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

787: rg23_rec.cr_additional_cvd,
788: rg23_rec.dr_additional_cvd );
789: if v_debug_flag = 'Y' THEN
790: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.9 After Insert into JAI_CMN_RG_23AC_II_TRXS table');
791: FND_FILE.PUT_LINE(FND_FILE.LOG, '2.0 After the Register id is Processed' );
792: end if;
793:
794: UPDATE JAI_CMN_RG_23AC_II_TRXS
795: SET posted_flag = 'Y',

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

805: and source_type = 1
806: )
807: LOOP
808: if v_debug_flag = 'Y' THEN
809: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . Before calling other taxes ');
810: end if;
811: jai_cmn_rg_master_org_pkg.insert_rg23_others
812: (errbuf => lv_buffer,
813: retcode => lv_retcode,

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

815: p_tax_type => tax_types_rec.tax_type,
816: p_register_id => rg23_rec.register_id ) ;
817:
818: if v_debug_flag = 'Y' THEN
819: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with status = ' || lv_retcode);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with error = ' || lv_buffer);
821: end if;
822:
823:

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

816: p_register_id => rg23_rec.register_id ) ;
817:
818: if v_debug_flag = 'Y' THEN
819: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with status = ' || lv_retcode);
820: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.812 . After calling other taxes with error = ' || lv_buffer);
821: end if;
822:
823:
824:

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

824:
825:
826: if nvl(lv_retcode,'0') <> '0' then /* if not success then get out the loop */
827: if v_debug_flag = 'Y' THEN
828: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.80 . Error is ' || lv_buffer || ' Halting the processing ... ');
829: end if;
830: ERRBUF := lv_buffer ;
831: goto errhandling_block; /* Halt the processing and no more records would get processed. */
832: end if;

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

834:
835: -- ended by hjujjuru for #Bug 4106667
836:
837: if v_debug_flag = 'Y' THEN
838: FND_FILE.PUT_LINE(FND_FILE.LOG, '*******************************************************************');
839: end if;
840:
841: End Loop;
842:

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

853: FETCH c_final_balance_rg23 INTO v_rg23c_final_balance;
854: CLOSE c_final_balance_rg23;
855:
856: if v_debug_flag = 'Y' THEN
857: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);
858: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);
859: end if;
860: UPDATE JAI_CMN_RG_BALANCES
861: SET RG23A_BALANCE = v_rg23a_final_balance, RG23C_BALANCE=v_rg23c_final_balance

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

854: CLOSE c_final_balance_rg23;
855:
856: if v_debug_flag = 'Y' THEN
857: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_rg23a_final_balance is ' || v_rg23a_final_balance);
858: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_rg23c_final_balance is ' || v_rg23c_final_balance);
859: end if;
860: UPDATE JAI_CMN_RG_BALANCES
861: SET RG23A_BALANCE = v_rg23a_final_balance, RG23C_BALANCE=v_rg23c_final_balance
862: where organization_id=p_organization_id

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

862: where organization_id=p_organization_id
863: and location_id =p_location_id;
864: --Ends here.....
865: if v_debug_flag = 'Y' THEN
866: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
867: end if;
868: --Exception added by Nagaraj.s for Bug263674
869:
870: retcode := '0';

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

873: <>
874: Rollback; /* Rolling back because there was some problem */
875: RETCODE := '2';
876: if v_debug_flag = 'Y' THEN
877: FND_FILE.PUT_LINE(FND_FILE.LOG, 'in the err handling block ' || lv_buffer );
878: end if;
879: Exception
880: WHEN OTHERS THEN
881:

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

881:
882: RETCODE := '2' ;
883: RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
884: if v_debug_flag = 'Y' THEN
885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
886: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
887: end if;
888: End consolidate_rg23_part_ii;
889:

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

882: RETCODE := '2' ;
883: RAISE_APPLICATION_ERROR(-20001,'This Concurrent Program has ended in an Error ' || SQLERRM);
884: if v_debug_flag = 'Y' THEN
885: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
886: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception !!!! ' || SQLERRM );
887: end if;
888: End consolidate_rg23_part_ii;
889:
890: PROCEDURE consolidate_pla

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

1018: --------------------------------------------------------------------------------------------*/
1019:
1020: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1021: if v_debug_flag = 'Y' THEN
1022: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
1023: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
1025: end if;
1026:

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

1019:
1020: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1021: if v_debug_flag = 'Y' THEN
1022: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
1023: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
1025: end if;
1026:
1027: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

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

1020: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1021: if v_debug_flag = 'Y' THEN
1022: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** START OF LOG FILE ****************************************');
1023: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 The Organization Id is ' || p_organization_id);
1024: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.1 The Location Id is ' || p_location_id);
1025: end if;
1026:
1027: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));
1028: FETCH master_ec_code_cur INTO v_ec_code;

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

1028: FETCH master_ec_code_cur INTO v_ec_code;
1029: CLOSE master_ec_code_cur;
1030:
1031: if v_debug_flag = 'Y' THEN
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
1034: end if;
1035:
1036: For pla_reg_rec IN pla_register_id_cur(v_ec_code)

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

1029: CLOSE master_ec_code_cur;
1030:
1031: if v_debug_flag = 'Y' THEN
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 The EC Code is ' || v_ec_code);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.3 ************** Before the Main Loop ********************');
1034: end if;
1035:
1036: For pla_reg_rec IN pla_register_id_cur(v_ec_code)
1037: Loop

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

1039: FETCH pla_cur INTO pla_rec;
1040: CLOSE pla_cur;
1041:
1042: if v_debug_flag = 'Y' THEN
1043: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || pla_reg_rec.register_id);
1044: end if;
1045:
1046: OPEN serial_no_cur(p_organization_id, nvl(p_location_id,0), pla_rec.fin_year /*, pla_rec.register_type*/ );
1047: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;

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

1047: FETCH serial_no_cur INTO v_previous_serial_no, v_serial_no;
1048: CLOSE serial_no_cur;
1049:
1050: if v_debug_flag = 'Y' THEN
1051: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
1053: end if;
1054:
1055: IF v_previous_serial_no = 0

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

1048: CLOSE serial_no_cur;
1049:
1050: if v_debug_flag = 'Y' THEN
1051: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 The v_previous_serial_no is ' || v_previous_serial_no);
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.6 The v_serial_no is ' || v_serial_no);
1053: end if;
1054:
1055: IF v_previous_serial_no = 0
1056: THEN

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

1066: v_opening_balance := v_closing_balance;
1067: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
1068: END IF;
1069: if v_debug_flag = 'Y' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
1072: end if;
1073: INSERT INTO JAI_CMN_RG_PLA_TRXS (register_id,
1074: fin_year,

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

1067: v_closing_balance := nvl(v_opening_balance,0) + nvl(v_transaction_balance,0);
1068: END IF;
1069: if v_debug_flag = 'Y' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.7 The v_opening_balance is ' || v_opening_balance);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.8 The v_closing_balance is ' || v_closing_balance);
1072: end if;
1073: INSERT INTO JAI_CMN_RG_PLA_TRXS (register_id,
1074: fin_year,
1075: slno,

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

1183: );
1184:
1185: if nvl(lv_retcode,'0') <> '0' then /* if not success then get out the loop */
1186: if v_debug_flag = 'Y' THEN
1187: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.80 . Error is ' || lv_buffer || ' Halting the processing ... ');
1188: end if;
1189: ERRBUF := lv_buffer ;
1190: goto errhandling_block; /* Halt the processing and no more records would get processed. */
1191: end if;

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

1196:
1197: End Loop;
1198:
1199: if v_debug_flag = 'Y' THEN
1200: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.81 The v_record_count is ' || v_record_count);
1201: end if;
1202:
1203: if v_record_count >0 then --3335814
1204: --Added by Nagaraj.s for Bug2708514

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

1212: FETCH c_final_balance_pla INTO v_pla_balance;
1213: CLOSE c_final_balance_pla;
1214:
1215: if v_debug_flag = 'Y' THEN
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1218: end if;
1219:
1220: --This is for Updation of RG Balances table

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

1213: CLOSE c_final_balance_pla;
1214:
1215: if v_debug_flag = 'Y' THEN
1216: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.82 The v_fin_active_year is ' || v_fin_active_year);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.83 The pla balance that is updated in JAI_CMN_RG_BALANCES is ' || v_pla_balance);
1218: end if;
1219:
1220: --This is for Updation of RG Balances table
1221: UPDATE JAI_CMN_RG_BALANCES

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

1225: end if; --end if for v_record_count.
1226:
1227: --Ends here.....
1228: if v_debug_flag = 'Y' THEN
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
1230: end if;
1231:
1232: retcode := '0';
1233: ERRBUF := NULL;

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

1353:
1354: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1355:
1356: if v_debug_flag = 'Y' THEN
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, '********* START OF LOG FILE - '||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' *********');
1358: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 organization->' || p_organization_id||', Location->' || p_location_id);
1359: end if;
1360:
1361: v_statement_id := '1';

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

1354: v_debug_flag :='Y'; -- File.Sql.35 by Brathod
1355:
1356: if v_debug_flag = 'Y' THEN
1357: FND_FILE.PUT_LINE(FND_FILE.LOG, '********* START OF LOG FILE - '||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' *********');
1358: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.0 organization->' || p_organization_id||', Location->' || p_location_id);
1359: end if;
1360:
1361: v_statement_id := '1';
1362: OPEN master_ec_code_cur(p_organization_id, nvl(p_location_id,0));

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

1363: FETCH master_ec_code_cur INTO v_ec_code;
1364: CLOSE master_ec_code_cur;
1365:
1366: if v_debug_flag = 'Y' THEN
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.2 Before the Main Loop, EC Code->' || v_ec_code);
1368: end if;
1369:
1370: FOR rgi_reg_rec IN rgi_register_id_cur(v_ec_code) LOOP
1371:

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

1372: v_regid_being_processed := rgi_reg_rec.register_id;
1373:
1374: v_statement_id := '2';
1375: if v_debug_flag = 'Y' THEN
1376: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.4 The Register Id is ' || rgi_reg_rec.register_id);
1377: end if;
1378:
1379: v_statement_id := '2a';
1380:

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

1427:
1428: v_prev_item_id := rgi_rec.inventory_item_id;
1429:
1430: IF v_debug_flag = 'Y' THEN
1431: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.5 ChildItem->' || rgi_rec.inventory_item_id
1432: ||', v_fin_year->' || v_fin_year
1433: ||', v_serial_no->' || v_serial_no
1434: ||', bal_pac->' || v_balance_packed||', bal_loo->' || v_balance_loose||', man_qty->' || v_manu_qty);
1435: END IF;

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

1466:
1467: v_serial_no := v_serial_no + 1; /*Bug 9550254*/
1468:
1469: IF v_debug_flag = 'Y' THEN
1470: FND_FILE.PUT_LINE(FND_FILE.LOG, '1.51 v_fin_year->' || v_fin_year||', bal_loo->' || v_balance_loose
1471: ||', serial_no->' || v_serial_no);
1472: END IF;
1473:
1474: v_statement_id := '8';

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

1592:
1593: END LOOP;
1594:
1595: if v_debug_flag = 'Y' THEN
1596: FND_FILE.PUT_LINE(FND_FILE.LOG, '*************************** END OF LOG FILE ****************************************');
1597: end if;
1598:
1599: --Exception added by Nagaraj.s for Bug2708518
1600: Exception

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

1599: --Exception added by Nagaraj.s for Bug2708518
1600: Exception
1601: WHEN OTHERS THEN
1602:
1603: FND_FILE.PUT_LINE(FND_FILE.LOG, '######### Error at: v_regid_being_processed->'||v_regid_being_processed
1604: ||', statement_id->'||v_statement_id
1605: ||', SQLERRM->'||SQLERRM
1606: );
1607: