DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on FND_GLOBAL

Line 593: -- || fnd_global.local_chr(10) ;

589: || RPAD(l_split_tbl(i).claim_number,30,' ') || ' , '
590: || TO_CHAR(l_split_tbl(i).amount_remaining)
591: || ')' ;
592:
593: -- || fnd_global.local_chr(10) ;
594: */
595: l_split_msg := SUBSTR(l_split_msg||'('
596: || RPAD(l_split_tbl(i).claim_number,30,' ') || ' , '
597: || RPAD(l_split_tbl(i).status,30,' ') || ' , '

Line 602: || FND_GLOBAL.local_chr(10), 1, 2000);

598: || TO_CHAR(l_split_tbl(i).amount) || ' , '
599: || TO_CHAR(l_split_tbl(i).amount_remaining) || ' , '
600: || TO_CHAR(l_split_tbl(i).amount_settled)
601: || ')'
602: || FND_GLOBAL.local_chr(10), 1, 2000);
603: END LOOP;
604: END IF;
605:
606: FND_MESSAGE.set_name('OZF', 'OZF_SETL_WF_SPLT_DETLS');

Line 696: TO_CHAR(l_line_detail_tbl(i).line_number)||FND_GLOBAL.local_chr(9)||' , '||

692: , l_line_detail_tbl(i).name;
693: CLOSE csr_line_trx_info;
694:
695: l_line_detail_msg := SUBSTR(l_line_detail_msg||'('||
696: TO_CHAR(l_line_detail_tbl(i).line_number)||FND_GLOBAL.local_chr(9)||' , '||
697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||
698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||

Line 697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||

693: CLOSE csr_line_trx_info;
694:
695: l_line_detail_msg := SUBSTR(l_line_detail_msg||'('||
696: TO_CHAR(l_line_detail_tbl(i).line_number)||FND_GLOBAL.local_chr(9)||' , '||
697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||
698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||

Line 698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||

694:
695: l_line_detail_msg := SUBSTR(l_line_detail_msg||'('||
696: TO_CHAR(l_line_detail_tbl(i).line_number)||FND_GLOBAL.local_chr(9)||' , '||
697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||
698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||

Line 699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||

695: l_line_detail_msg := SUBSTR(l_line_detail_msg||'('||
696: TO_CHAR(l_line_detail_tbl(i).line_number)||FND_GLOBAL.local_chr(9)||' , '||
697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||
698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||

Line 700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||

696: TO_CHAR(l_line_detail_tbl(i).line_number)||FND_GLOBAL.local_chr(9)||' , '||
697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||
698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||

Line 701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||

697: NVL(l_line_detail_tbl(i).type, ' ')||FND_GLOBAL.local_chr(9)||' , '||
698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||

Line 702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||

698: NVL(l_line_detail_tbl(i).name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||

Line 703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||

699: NVL(l_line_detail_tbl(i).product, ' ')||FND_GLOBAL.local_chr(9)||' , '||
700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||
707: FND_GLOBAL.local_chr(10), 1, 2000);

Line 704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||

700: NVL(l_line_detail_tbl(i).uom_name, ' ')||FND_GLOBAL.local_chr(9)||' , '||
701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||
707: FND_GLOBAL.local_chr(10), 1, 2000);
708: END LOOP;

Line 705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||

701: NVL(TO_CHAR(l_line_detail_tbl(i).quantity), ' ')||FND_GLOBAL.local_chr(9)||' , '||
702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||
707: FND_GLOBAL.local_chr(10), 1, 2000);
708: END LOOP;
709: END IF;

Line 706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||

702: NVL(TO_CHAR(l_line_detail_tbl(i).rate), ' ')||FND_GLOBAL.local_chr(9)||' , '||
703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||
707: FND_GLOBAL.local_chr(10), 1, 2000);
708: END LOOP;
709: END IF;
710:

Line 707: FND_GLOBAL.local_chr(10), 1, 2000);

703: NVL(TO_CHAR(l_line_detail_tbl(i).amount), ' ')||FND_GLOBAL.local_chr(9)||' , '||
704: NVL(l_line_detail_tbl(i).tax_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
705: NVL(l_line_detail_tbl(i).gl_code, ' ')||FND_GLOBAL.local_chr(9)||' , '||
706: NVL(l_line_detail_tbl(i).earnings_flag, ' ')||FND_GLOBAL.local_chr(9)||')'||
707: FND_GLOBAL.local_chr(10), 1, 2000);
708: END LOOP;
709: END IF;
710:
711: FND_MESSAGE.set_name('OZF', 'OZF_SETL_WF_LINE_DETLS');

Line 3145: fnd_global.local_chr(10);

3141: l_final_msg := l_final_msg ||
3142: l_msg_index ||
3143: ': ' ||
3144: l_msg_data ||
3145: fnd_global.local_chr(10);
3146: END LOOP ;
3147:
3148: x_error_msg := l_final_msg;
3149: