19: PROCEDURE print_report_title IS
20: c_text_files VARCHAR2(200);
21: BEGIN
22: fnd_file.put_line(fnd_file.output, ' ');
23: fnd_message.set_name('SQLGL', 'CRM0023');
24: c_text_files :=
25: RPAD(fnd_message.get || ' '
26: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
27: 36, ' ');
21: BEGIN
22: fnd_file.put_line(fnd_file.output, ' ');
23: fnd_message.set_name('SQLGL', 'CRM0023');
24: c_text_files :=
25: RPAD(fnd_message.get || ' '
26: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
27: 36, ' ');
28: fnd_message.set_name('SQLGL', 'CRM0025');
29: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
24: c_text_files :=
25: RPAD(fnd_message.get || ' '
26: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
27: 36, ' ');
28: fnd_message.set_name('SQLGL', 'CRM0025');
29: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
30: fnd_message.set_name('SQLGL', 'CRM0024');
31: c_text_files :=
32: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
25: RPAD(fnd_message.get || ' '
26: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
27: 36, ' ');
28: fnd_message.set_name('SQLGL', 'CRM0025');
29: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
30: fnd_message.set_name('SQLGL', 'CRM0024');
31: c_text_files :=
32: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
33: fnd_file.put_line(fnd_file.output, c_text_files);
26: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
27: 36, ' ');
28: fnd_message.set_name('SQLGL', 'CRM0025');
29: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
30: fnd_message.set_name('SQLGL', 'CRM0024');
31: c_text_files :=
32: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
33: fnd_file.put_line(fnd_file.output, c_text_files);
34: page_line_count := page_line_count + 2;
28: fnd_message.set_name('SQLGL', 'CRM0025');
29: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
30: fnd_message.set_name('SQLGL', 'CRM0024');
31: c_text_files :=
32: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
33: fnd_file.put_line(fnd_file.output, c_text_files);
34: page_line_count := page_line_count + 2;
35: END print_report_title;
36:
39: c_text_files VARCHAR2(200);
40: BEGIN
41: fnd_file.put_line(fnd_file.output, ' ');
42: fnd_file.put_line(fnd_file.output, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0026');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
41: fnd_file.put_line(fnd_file.output, ' ');
42: fnd_file.put_line(fnd_file.output, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0026');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
52: fnd_message.set_name('SQLGL', 'CRM0034');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
53: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
54: fnd_message.set_name('SQLGL', 'CRM0035');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
55: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
56: fnd_message.set_name('SQLGL', 'CRM0036');
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
64: fnd_file.put_line(fnd_file.output, c_text_files);
57: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
64: fnd_file.put_line(fnd_file.output, c_text_files);
65: fnd_file.put_line(fnd_file.output,
58: fnd_message.set_name('SQLGL', 'CRM0037');
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
64: fnd_file.put_line(fnd_file.output, c_text_files);
65: fnd_file.put_line(fnd_file.output,
66: LPAD(' ', 31, '-') || LPAD(' ', 15, '-')
59: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
64: fnd_file.put_line(fnd_file.output, c_text_files);
65: fnd_file.put_line(fnd_file.output,
66: LPAD(' ', 31, '-') || LPAD(' ', 15, '-')
67: || LPAD(' ', 15, '-') || LPAD(' ', 16, '-')
75: c_text_files VARCHAR2(200);
76: BEGIN
77: fnd_file.put_line(fnd_file.output, ' ');
78: fnd_file.put_line(fnd_file.output, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0027');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
77: fnd_file.put_line(fnd_file.output, ' ');
78: fnd_file.put_line(fnd_file.output, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0027');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
88: fnd_message.set_name('SQLGL', 'CRM0035');
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
96: fnd_file.put_line(fnd_file.output, c_text_files);
89: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
96: fnd_file.put_line(fnd_file.output, c_text_files);
97: fnd_file.put_line(fnd_file.output,
90: fnd_message.set_name('SQLGL', 'CRM0036');
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
96: fnd_file.put_line(fnd_file.output, c_text_files);
97: fnd_file.put_line(fnd_file.output,
98: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
91: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
96: fnd_file.put_line(fnd_file.output, c_text_files);
97: fnd_file.put_line(fnd_file.output,
98: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
99: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
106: c_text_files VARCHAR2(200);
107: BEGIN
108: fnd_file.put_line(fnd_file.output, ' ');
109: fnd_file.put_line(fnd_file.output, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0028');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
108: fnd_file.put_line(fnd_file.output, ' ');
109: fnd_file.put_line(fnd_file.output, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0028');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
119: fnd_message.set_name('SQLGL', 'CRM0035');
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
127: fnd_file.put_line(fnd_file.output, c_text_files);
120: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
127: fnd_file.put_line(fnd_file.output, c_text_files);
128: fnd_file.put_line(fnd_file.output,
121: fnd_message.set_name('SQLGL', 'CRM0036');
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
127: fnd_file.put_line(fnd_file.output, c_text_files);
128: fnd_file.put_line(fnd_file.output,
129: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
122: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
127: fnd_file.put_line(fnd_file.output, c_text_files);
128: fnd_file.put_line(fnd_file.output,
129: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
130: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
137: c_text_files VARCHAR2(200);
138: BEGIN
139: fnd_file.put_line(fnd_file.output, ' ');
140: fnd_file.put_line(fnd_file.output, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0029');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
139: fnd_file.put_line(fnd_file.output, ' ');
140: fnd_file.put_line(fnd_file.output, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0029');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
150: fnd_message.set_name('SQLGL', 'CRM0035');
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
158: fnd_file.put_line(fnd_file.output, c_text_files);
151: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
158: fnd_file.put_line(fnd_file.output, c_text_files);
159: fnd_file.put_line(fnd_file.output,
152: fnd_message.set_name('SQLGL', 'CRM0036');
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
158: fnd_file.put_line(fnd_file.output, c_text_files);
159: fnd_file.put_line(fnd_file.output,
160: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
153: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
158: fnd_file.put_line(fnd_file.output, c_text_files);
159: fnd_file.put_line(fnd_file.output,
160: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
161: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
168: c_text_files VARCHAR2(200);
169: BEGIN
170: fnd_file.put_line(fnd_file.output, ' ');
171: fnd_file.put_line(fnd_file.output, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0030');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
170: fnd_file.put_line(fnd_file.output, ' ');
171: fnd_file.put_line(fnd_file.output, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0030');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
181: fnd_message.set_name('SQLGL', 'CRM0035');
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
189: fnd_file.put_line(fnd_file.output, c_text_files);
182: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
189: fnd_file.put_line(fnd_file.output, c_text_files);
190: fnd_file.put_line(fnd_file.output,
183: fnd_message.set_name('SQLGL', 'CRM0036');
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
189: fnd_file.put_line(fnd_file.output, c_text_files);
190: fnd_file.put_line(fnd_file.output,
191: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
184: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
189: fnd_file.put_line(fnd_file.output, c_text_files);
190: fnd_file.put_line(fnd_file.output,
191: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
192: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
199: c_text_files VARCHAR2(200);
200: BEGIN
201: fnd_file.put_line(fnd_file.output, ' ');
202: fnd_file.put_line(fnd_file.output, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0031');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
201: fnd_file.put_line(fnd_file.output, ' ');
202: fnd_file.put_line(fnd_file.output, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0031');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
216: fnd_file.put_line(fnd_file.output, c_text_files);
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
216: fnd_file.put_line(fnd_file.output, c_text_files);
217: fnd_file.put_line(fnd_file.output,
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
216: fnd_file.put_line(fnd_file.output, c_text_files);
217: fnd_file.put_line(fnd_file.output,
218: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
216: fnd_file.put_line(fnd_file.output, c_text_files);
217: fnd_file.put_line(fnd_file.output,
218: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
219: || LPAD(' ', 16, '-') || LPAD('-', 16, '-'));
224: PROCEDURE print_validation_failure_codes IS
225: BEGIN
226: fnd_file.put_line(fnd_file.output, ' ');
227: fnd_file.put_line(fnd_file.output, ' ');
228: fnd_message.set_name('SQLGL', 'CRM0022');
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
226: fnd_file.put_line(fnd_file.output, ' ');
227: fnd_file.put_line(fnd_file.output, ' ');
228: fnd_message.set_name('SQLGL', 'CRM0022');
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
266: END print_validation_failure_codes;
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
266: END print_validation_failure_codes;
267:
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
266: END print_validation_failure_codes;
267:
268: -------------------------------------------------------------------
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
266: END print_validation_failure_codes;
267:
268: -------------------------------------------------------------------
269: PROCEDURE insert_cross_rate_set(