493: lv_reference_26 := substr(pv_reference_26,1,240);
494:
495:
496: IF gv_debug='Y' THEN
497: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside create_gl_entry Procedure' );
498: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_1 is ' || lv_reference_1 );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
494:
495:
496: IF gv_debug='Y' THEN
497: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside create_gl_entry Procedure' );
498: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_1 is ' || lv_reference_1 );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
495:
496: IF gv_debug='Y' THEN
497: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside create_gl_entry Procedure' );
498: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_1 is ' || lv_reference_1 );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
496: IF gv_debug='Y' THEN
497: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside create_gl_entry Procedure' );
498: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_1 is ' || lv_reference_1 );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
497: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside create_gl_entry Procedure' );
498: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_1 is ' || lv_reference_1 );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
498: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_1 is ' || lv_reference_1 );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
499: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || lv_reference_10 );
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
500: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || lv_reference_23 );
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_credit_amount is ' || pn_credit_amount);
501: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || lv_reference_24 );
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_credit_amount is ' || pn_credit_amount);
509: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_debit_amount is ' || pn_debit_amount);
502: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || lv_reference_25 );
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_credit_amount is ' || pn_credit_amount);
509: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_debit_amount is ' || pn_debit_amount);
510: END IF;
503: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_26 is ' || lv_reference_26 );
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_credit_amount is ' || pn_credit_amount);
509: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_debit_amount is ' || pn_debit_amount);
510: END IF;
511:
504: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_reference_27 is ' || lv_reference_27 );
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_credit_amount is ' || pn_credit_amount);
509: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_debit_amount is ' || pn_debit_amount);
510: END IF;
511:
512: IF pd_accounting_date is null
505: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_set_of_books_id is ' || ln_set_of_books_id );
506: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of v_organization_code is ' || lv_organization_code );
507: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_organization_id is ' || pn_organization_id);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_credit_amount is ' || pn_credit_amount);
509: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.4 The Value of p_debit_amount is ' || pn_debit_amount);
510: END IF;
511:
512: IF pd_accounting_date is null
513: THEN
579: to_char(pn_organization_id) /* p_reference_27 */
580: );
581: END IF;
582: IF gv_debug='Y' THEN
583: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********End of create_gl_entry Procedure' );
584: END IF;
585:
586: EXCEPTION
587: when others then
585:
586: EXCEPTION
587: when others then
588: IF gv_debug='Y' THEN
589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error is raised in create_gl_entry procedure ' || sqlerrm );
590: END IF;
591: raise_application_error(-20106,'Error is raised in create_gl_entry procedure ' || sqlerrm);
592:
593: END create_gl_entry;