10: PROCEDURE print_report_title IS
11: c_text_files VARCHAR2(200);
12: BEGIN
13: fnd_file.put_line(fnd_file.output, ' ');
14: fnd_message.set_name('SQLGL', 'CRM0023');
15: c_text_files :=
16: RPAD(fnd_message.get || ' '
17: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
18: 36, ' ');
12: BEGIN
13: fnd_file.put_line(fnd_file.output, ' ');
14: fnd_message.set_name('SQLGL', 'CRM0023');
15: c_text_files :=
16: RPAD(fnd_message.get || ' '
17: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
18: 36, ' ');
19: fnd_message.set_name('SQLGL', 'CRM0025');
20: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
15: c_text_files :=
16: RPAD(fnd_message.get || ' '
17: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
18: 36, ' ');
19: fnd_message.set_name('SQLGL', 'CRM0025');
20: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
21: fnd_message.set_name('SQLGL', 'CRM0024');
22: c_text_files :=
23: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
16: RPAD(fnd_message.get || ' '
17: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
18: 36, ' ');
19: fnd_message.set_name('SQLGL', 'CRM0025');
20: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
21: fnd_message.set_name('SQLGL', 'CRM0024');
22: c_text_files :=
23: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
24: fnd_file.put_line(fnd_file.output, c_text_files);
17: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),
18: 36, ' ');
19: fnd_message.set_name('SQLGL', 'CRM0025');
20: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
21: fnd_message.set_name('SQLGL', 'CRM0024');
22: c_text_files :=
23: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
24: fnd_file.put_line(fnd_file.output, c_text_files);
25: page_line_count := page_line_count + 2;
19: fnd_message.set_name('SQLGL', 'CRM0025');
20: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
21: fnd_message.set_name('SQLGL', 'CRM0024');
22: c_text_files :=
23: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
24: fnd_file.put_line(fnd_file.output, c_text_files);
25: page_line_count := page_line_count + 2;
26: END print_report_title;
27:
30: c_text_files VARCHAR2(200);
31: BEGIN
32: fnd_file.put_line(fnd_file.output, ' ');
33: fnd_file.put_line(fnd_file.output, ' ');
34: fnd_message.set_name('SQLGL', 'CRM0026');
35: fnd_file.put_line(fnd_file.output,
36: LPAD(' ', 45, '=') || fnd_message.get
37: || RPAD(' ', 45, '='));
38: fnd_file.put_line(fnd_file.output, ' ');
32: fnd_file.put_line(fnd_file.output, ' ');
33: fnd_file.put_line(fnd_file.output, ' ');
34: fnd_message.set_name('SQLGL', 'CRM0026');
35: fnd_file.put_line(fnd_file.output,
36: LPAD(' ', 45, '=') || fnd_message.get
37: || RPAD(' ', 45, '='));
38: fnd_file.put_line(fnd_file.output, ' ');
39: fnd_message.set_name('SQLGL', 'CRM0032');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
35: fnd_file.put_line(fnd_file.output,
36: LPAD(' ', 45, '=') || fnd_message.get
37: || RPAD(' ', 45, '='));
38: fnd_file.put_line(fnd_file.output, ' ');
39: fnd_message.set_name('SQLGL', 'CRM0032');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
36: LPAD(' ', 45, '=') || fnd_message.get
37: || RPAD(' ', 45, '='));
38: fnd_file.put_line(fnd_file.output, ' ');
39: fnd_message.set_name('SQLGL', 'CRM0032');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
37: || RPAD(' ', 45, '='));
38: fnd_file.put_line(fnd_file.output, ' ');
39: fnd_message.set_name('SQLGL', 'CRM0032');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
38: fnd_file.put_line(fnd_file.output, ' ');
39: fnd_message.set_name('SQLGL', 'CRM0032');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
39: fnd_message.set_name('SQLGL', 'CRM0032');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
40: c_text_files := RPAD(fnd_message.get, 31, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
41: fnd_message.set_name('SQLGL', 'CRM0033');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
42: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0034');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
44: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
45: fnd_message.set_name('SQLGL', 'CRM0035');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
53: fnd_message.set_name('SQLGL', 'CRM0039');
46: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
53: fnd_message.set_name('SQLGL', 'CRM0039');
54: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
47: fnd_message.set_name('SQLGL', 'CRM0036');
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
53: fnd_message.set_name('SQLGL', 'CRM0039');
54: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
55: fnd_file.put_line(fnd_file.output, c_text_files);
48: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
53: fnd_message.set_name('SQLGL', 'CRM0039');
54: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
55: fnd_file.put_line(fnd_file.output, c_text_files);
56: fnd_file.put_line(fnd_file.output,
49: fnd_message.set_name('SQLGL', 'CRM0037');
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
53: fnd_message.set_name('SQLGL', 'CRM0039');
54: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
55: fnd_file.put_line(fnd_file.output, c_text_files);
56: fnd_file.put_line(fnd_file.output,
57: LPAD(' ', 31, '-') || LPAD(' ', 15, '-')
50: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
51: fnd_message.set_name('SQLGL', 'CRM0038');
52: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
53: fnd_message.set_name('SQLGL', 'CRM0039');
54: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
55: fnd_file.put_line(fnd_file.output, c_text_files);
56: fnd_file.put_line(fnd_file.output,
57: LPAD(' ', 31, '-') || LPAD(' ', 15, '-')
58: || LPAD(' ', 15, '-') || LPAD(' ', 16, '-')
66: c_text_files VARCHAR2(200);
67: BEGIN
68: fnd_file.put_line(fnd_file.output, ' ');
69: fnd_file.put_line(fnd_file.output, ' ');
70: fnd_message.set_name('SQLGL', 'CRM0027');
71: fnd_file.put_line(fnd_file.output,
72: LPAD(' ', 45, '=') || fnd_message.get
73: || RPAD(' ', 46, '='));
74: fnd_file.put_line(fnd_file.output, ' ');
68: fnd_file.put_line(fnd_file.output, ' ');
69: fnd_file.put_line(fnd_file.output, ' ');
70: fnd_message.set_name('SQLGL', 'CRM0027');
71: fnd_file.put_line(fnd_file.output,
72: LPAD(' ', 45, '=') || fnd_message.get
73: || RPAD(' ', 46, '='));
74: fnd_file.put_line(fnd_file.output, ' ');
75: fnd_message.set_name('SQLGL', 'CRM0032');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
71: fnd_file.put_line(fnd_file.output,
72: LPAD(' ', 45, '=') || fnd_message.get
73: || RPAD(' ', 46, '='));
74: fnd_file.put_line(fnd_file.output, ' ');
75: fnd_message.set_name('SQLGL', 'CRM0032');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
72: LPAD(' ', 45, '=') || fnd_message.get
73: || RPAD(' ', 46, '='));
74: fnd_file.put_line(fnd_file.output, ' ');
75: fnd_message.set_name('SQLGL', 'CRM0032');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
73: || RPAD(' ', 46, '='));
74: fnd_file.put_line(fnd_file.output, ' ');
75: fnd_message.set_name('SQLGL', 'CRM0032');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
74: fnd_file.put_line(fnd_file.output, ' ');
75: fnd_message.set_name('SQLGL', 'CRM0032');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
75: fnd_message.set_name('SQLGL', 'CRM0032');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
76: c_text_files := RPAD(fnd_message.get, 31, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
77: fnd_message.set_name('SQLGL', 'CRM0040');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
85: fnd_message.set_name('SQLGL', 'CRM0041');
78: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
85: fnd_message.set_name('SQLGL', 'CRM0041');
86: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0035');
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
85: fnd_message.set_name('SQLGL', 'CRM0041');
86: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
87: fnd_file.put_line(fnd_file.output, c_text_files);
80: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
85: fnd_message.set_name('SQLGL', 'CRM0041');
86: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
87: fnd_file.put_line(fnd_file.output, c_text_files);
88: fnd_file.put_line(fnd_file.output,
81: fnd_message.set_name('SQLGL', 'CRM0036');
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
85: fnd_message.set_name('SQLGL', 'CRM0041');
86: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
87: fnd_file.put_line(fnd_file.output, c_text_files);
88: fnd_file.put_line(fnd_file.output,
89: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
82: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
83: fnd_message.set_name('SQLGL', 'CRM0037');
84: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
85: fnd_message.set_name('SQLGL', 'CRM0041');
86: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
87: fnd_file.put_line(fnd_file.output, c_text_files);
88: fnd_file.put_line(fnd_file.output,
89: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
90: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
97: c_text_files VARCHAR2(200);
98: BEGIN
99: fnd_file.put_line(fnd_file.output, ' ');
100: fnd_file.put_line(fnd_file.output, ' ');
101: fnd_message.set_name('SQLGL', 'CRM0028');
102: fnd_file.put_line(fnd_file.output,
103: LPAD(' ', 45, '=') || fnd_message.get
104: || RPAD(' ', 46, '='));
105: fnd_file.put_line(fnd_file.output, ' ');
99: fnd_file.put_line(fnd_file.output, ' ');
100: fnd_file.put_line(fnd_file.output, ' ');
101: fnd_message.set_name('SQLGL', 'CRM0028');
102: fnd_file.put_line(fnd_file.output,
103: LPAD(' ', 45, '=') || fnd_message.get
104: || RPAD(' ', 46, '='));
105: fnd_file.put_line(fnd_file.output, ' ');
106: fnd_message.set_name('SQLGL', 'CRM0032');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
102: fnd_file.put_line(fnd_file.output,
103: LPAD(' ', 45, '=') || fnd_message.get
104: || RPAD(' ', 46, '='));
105: fnd_file.put_line(fnd_file.output, ' ');
106: fnd_message.set_name('SQLGL', 'CRM0032');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
103: LPAD(' ', 45, '=') || fnd_message.get
104: || RPAD(' ', 46, '='));
105: fnd_file.put_line(fnd_file.output, ' ');
106: fnd_message.set_name('SQLGL', 'CRM0032');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
104: || RPAD(' ', 46, '='));
105: fnd_file.put_line(fnd_file.output, ' ');
106: fnd_message.set_name('SQLGL', 'CRM0032');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
105: fnd_file.put_line(fnd_file.output, ' ');
106: fnd_message.set_name('SQLGL', 'CRM0032');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
106: fnd_message.set_name('SQLGL', 'CRM0032');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
107: c_text_files := RPAD(fnd_message.get, 31, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
108: fnd_message.set_name('SQLGL', 'CRM0040');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
116: fnd_message.set_name('SQLGL', 'CRM0041');
109: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
116: fnd_message.set_name('SQLGL', 'CRM0041');
117: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0035');
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
116: fnd_message.set_name('SQLGL', 'CRM0041');
117: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
118: fnd_file.put_line(fnd_file.output, c_text_files);
111: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
116: fnd_message.set_name('SQLGL', 'CRM0041');
117: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
118: fnd_file.put_line(fnd_file.output, c_text_files);
119: fnd_file.put_line(fnd_file.output,
112: fnd_message.set_name('SQLGL', 'CRM0036');
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
116: fnd_message.set_name('SQLGL', 'CRM0041');
117: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
118: fnd_file.put_line(fnd_file.output, c_text_files);
119: fnd_file.put_line(fnd_file.output,
120: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
113: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
114: fnd_message.set_name('SQLGL', 'CRM0037');
115: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
116: fnd_message.set_name('SQLGL', 'CRM0041');
117: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
118: fnd_file.put_line(fnd_file.output, c_text_files);
119: fnd_file.put_line(fnd_file.output,
120: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
121: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
128: c_text_files VARCHAR2(200);
129: BEGIN
130: fnd_file.put_line(fnd_file.output, ' ');
131: fnd_file.put_line(fnd_file.output, ' ');
132: fnd_message.set_name('SQLGL', 'CRM0029');
133: fnd_file.put_line(fnd_file.output,
134: LPAD(' ', 43, '=') || fnd_message.get
135: || RPAD(' ', 44, '='));
136: fnd_file.put_line(fnd_file.output, ' ');
130: fnd_file.put_line(fnd_file.output, ' ');
131: fnd_file.put_line(fnd_file.output, ' ');
132: fnd_message.set_name('SQLGL', 'CRM0029');
133: fnd_file.put_line(fnd_file.output,
134: LPAD(' ', 43, '=') || fnd_message.get
135: || RPAD(' ', 44, '='));
136: fnd_file.put_line(fnd_file.output, ' ');
137: fnd_message.set_name('SQLGL', 'CRM0032');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
133: fnd_file.put_line(fnd_file.output,
134: LPAD(' ', 43, '=') || fnd_message.get
135: || RPAD(' ', 44, '='));
136: fnd_file.put_line(fnd_file.output, ' ');
137: fnd_message.set_name('SQLGL', 'CRM0032');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
134: LPAD(' ', 43, '=') || fnd_message.get
135: || RPAD(' ', 44, '='));
136: fnd_file.put_line(fnd_file.output, ' ');
137: fnd_message.set_name('SQLGL', 'CRM0032');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
135: || RPAD(' ', 44, '='));
136: fnd_file.put_line(fnd_file.output, ' ');
137: fnd_message.set_name('SQLGL', 'CRM0032');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
136: fnd_file.put_line(fnd_file.output, ' ');
137: fnd_message.set_name('SQLGL', 'CRM0032');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
137: fnd_message.set_name('SQLGL', 'CRM0032');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
138: c_text_files := RPAD(fnd_message.get, 31, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
139: fnd_message.set_name('SQLGL', 'CRM0040');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
147: fnd_message.set_name('SQLGL', 'CRM0041');
140: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
147: fnd_message.set_name('SQLGL', 'CRM0041');
148: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0035');
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
147: fnd_message.set_name('SQLGL', 'CRM0041');
148: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
149: fnd_file.put_line(fnd_file.output, c_text_files);
142: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
147: fnd_message.set_name('SQLGL', 'CRM0041');
148: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
149: fnd_file.put_line(fnd_file.output, c_text_files);
150: fnd_file.put_line(fnd_file.output,
143: fnd_message.set_name('SQLGL', 'CRM0036');
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
147: fnd_message.set_name('SQLGL', 'CRM0041');
148: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
149: fnd_file.put_line(fnd_file.output, c_text_files);
150: fnd_file.put_line(fnd_file.output,
151: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
144: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
145: fnd_message.set_name('SQLGL', 'CRM0037');
146: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
147: fnd_message.set_name('SQLGL', 'CRM0041');
148: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
149: fnd_file.put_line(fnd_file.output, c_text_files);
150: fnd_file.put_line(fnd_file.output,
151: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
152: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
159: c_text_files VARCHAR2(200);
160: BEGIN
161: fnd_file.put_line(fnd_file.output, ' ');
162: fnd_file.put_line(fnd_file.output, ' ');
163: fnd_message.set_name('SQLGL', 'CRM0030');
164: fnd_file.put_line(fnd_file.output,
165: LPAD(' ', 43, '=') || fnd_message.get
166: || RPAD(' ', 44, '='));
167: fnd_file.put_line(fnd_file.output, ' ');
161: fnd_file.put_line(fnd_file.output, ' ');
162: fnd_file.put_line(fnd_file.output, ' ');
163: fnd_message.set_name('SQLGL', 'CRM0030');
164: fnd_file.put_line(fnd_file.output,
165: LPAD(' ', 43, '=') || fnd_message.get
166: || RPAD(' ', 44, '='));
167: fnd_file.put_line(fnd_file.output, ' ');
168: fnd_message.set_name('SQLGL', 'CRM0032');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
164: fnd_file.put_line(fnd_file.output,
165: LPAD(' ', 43, '=') || fnd_message.get
166: || RPAD(' ', 44, '='));
167: fnd_file.put_line(fnd_file.output, ' ');
168: fnd_message.set_name('SQLGL', 'CRM0032');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
165: LPAD(' ', 43, '=') || fnd_message.get
166: || RPAD(' ', 44, '='));
167: fnd_file.put_line(fnd_file.output, ' ');
168: fnd_message.set_name('SQLGL', 'CRM0032');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
166: || RPAD(' ', 44, '='));
167: fnd_file.put_line(fnd_file.output, ' ');
168: fnd_message.set_name('SQLGL', 'CRM0032');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
167: fnd_file.put_line(fnd_file.output, ' ');
168: fnd_message.set_name('SQLGL', 'CRM0032');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
168: fnd_message.set_name('SQLGL', 'CRM0032');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
169: c_text_files := RPAD(fnd_message.get, 31, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
170: fnd_message.set_name('SQLGL', 'CRM0040');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
178: fnd_message.set_name('SQLGL', 'CRM0041');
171: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
178: fnd_message.set_name('SQLGL', 'CRM0041');
179: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0035');
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
178: fnd_message.set_name('SQLGL', 'CRM0041');
179: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
180: fnd_file.put_line(fnd_file.output, c_text_files);
173: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
178: fnd_message.set_name('SQLGL', 'CRM0041');
179: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
180: fnd_file.put_line(fnd_file.output, c_text_files);
181: fnd_file.put_line(fnd_file.output,
174: fnd_message.set_name('SQLGL', 'CRM0036');
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
178: fnd_message.set_name('SQLGL', 'CRM0041');
179: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
180: fnd_file.put_line(fnd_file.output, c_text_files);
181: fnd_file.put_line(fnd_file.output,
182: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
175: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
176: fnd_message.set_name('SQLGL', 'CRM0037');
177: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
178: fnd_message.set_name('SQLGL', 'CRM0041');
179: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
180: fnd_file.put_line(fnd_file.output, c_text_files);
181: fnd_file.put_line(fnd_file.output,
182: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
183: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
190: c_text_files VARCHAR2(200);
191: BEGIN
192: fnd_file.put_line(fnd_file.output, ' ');
193: fnd_file.put_line(fnd_file.output, ' ');
194: fnd_message.set_name('SQLGL', 'CRM0031');
195: fnd_file.put_line(fnd_file.output,
196: LPAD(' ', 51, '=') || fnd_message.get
197: || RPAD(' ', 51, '='));
198: fnd_file.put_line(fnd_file.output, ' ');
192: fnd_file.put_line(fnd_file.output, ' ');
193: fnd_file.put_line(fnd_file.output, ' ');
194: fnd_message.set_name('SQLGL', 'CRM0031');
195: fnd_file.put_line(fnd_file.output,
196: LPAD(' ', 51, '=') || fnd_message.get
197: || RPAD(' ', 51, '='));
198: fnd_file.put_line(fnd_file.output, ' ');
199: fnd_message.set_name('SQLGL', 'CRM0032');
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
195: fnd_file.put_line(fnd_file.output,
196: LPAD(' ', 51, '=') || fnd_message.get
197: || RPAD(' ', 51, '='));
198: fnd_file.put_line(fnd_file.output, ' ');
199: fnd_message.set_name('SQLGL', 'CRM0032');
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
196: LPAD(' ', 51, '=') || fnd_message.get
197: || RPAD(' ', 51, '='));
198: fnd_file.put_line(fnd_file.output, ' ');
199: fnd_message.set_name('SQLGL', 'CRM0032');
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
197: || RPAD(' ', 51, '='));
198: fnd_file.put_line(fnd_file.output, ' ');
199: fnd_message.set_name('SQLGL', 'CRM0032');
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
205: fnd_message.set_name('SQLGL', 'CRM0043');
198: fnd_file.put_line(fnd_file.output, ' ');
199: fnd_message.set_name('SQLGL', 'CRM0032');
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
205: fnd_message.set_name('SQLGL', 'CRM0043');
206: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
199: fnd_message.set_name('SQLGL', 'CRM0032');
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
205: fnd_message.set_name('SQLGL', 'CRM0043');
206: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
207: fnd_file.put_line(fnd_file.output, c_text_files);
200: c_text_files := RPAD(fnd_message.get, 31, ' ');
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
205: fnd_message.set_name('SQLGL', 'CRM0043');
206: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
207: fnd_file.put_line(fnd_file.output, c_text_files);
208: fnd_file.put_line(fnd_file.output,
201: fnd_message.set_name('SQLGL', 'CRM0040');
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
205: fnd_message.set_name('SQLGL', 'CRM0043');
206: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
207: fnd_file.put_line(fnd_file.output, c_text_files);
208: fnd_file.put_line(fnd_file.output,
209: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
202: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0042');
204: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
205: fnd_message.set_name('SQLGL', 'CRM0043');
206: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
207: fnd_file.put_line(fnd_file.output, c_text_files);
208: fnd_file.put_line(fnd_file.output,
209: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
210: || LPAD(' ', 16, '-') || LPAD('-', 16, '-'));
215: PROCEDURE print_validation_failure_codes IS
216: BEGIN
217: fnd_file.put_line(fnd_file.output, ' ');
218: fnd_file.put_line(fnd_file.output, ' ');
219: fnd_message.set_name('SQLGL', 'CRM0022');
220: fnd_file.put_line(fnd_file.output,
221: LPAD(' ', 61, '=') || fnd_message.get
222: || RPAD(' ', 61, '='));
223: fnd_file.put_line(fnd_file.output, ' ');
217: fnd_file.put_line(fnd_file.output, ' ');
218: fnd_file.put_line(fnd_file.output, ' ');
219: fnd_message.set_name('SQLGL', 'CRM0022');
220: fnd_file.put_line(fnd_file.output,
221: LPAD(' ', 61, '=') || fnd_message.get
222: || RPAD(' ', 61, '='));
223: fnd_file.put_line(fnd_file.output, ' ');
224: fnd_message.set_name('SQLGL', 'CRM0021');
225: fnd_file.put_line(fnd_file.output, fnd_message.get);
220: fnd_file.put_line(fnd_file.output,
221: LPAD(' ', 61, '=') || fnd_message.get
222: || RPAD(' ', 61, '='));
223: fnd_file.put_line(fnd_file.output, ' ');
224: fnd_message.set_name('SQLGL', 'CRM0021');
225: fnd_file.put_line(fnd_file.output, fnd_message.get);
226: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
221: LPAD(' ', 61, '=') || fnd_message.get
222: || RPAD(' ', 61, '='));
223: fnd_file.put_line(fnd_file.output, ' ');
224: fnd_message.set_name('SQLGL', 'CRM0021');
225: fnd_file.put_line(fnd_file.output, fnd_message.get);
226: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
223: fnd_file.put_line(fnd_file.output, ' ');
224: fnd_message.set_name('SQLGL', 'CRM0021');
225: fnd_file.put_line(fnd_file.output, fnd_message.get);
226: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
224: fnd_message.set_name('SQLGL', 'CRM0021');
225: fnd_file.put_line(fnd_file.output, fnd_message.get);
226: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
225: fnd_file.put_line(fnd_file.output, fnd_message.get);
226: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
226: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
227: fnd_message.set_name('SQLGL', 'CRM0007');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
228: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
229: fnd_message.set_name('SQLGL', 'CRM0008');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
230: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
231: fnd_message.set_name('SQLGL', 'CRM0009');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
232: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
233: fnd_message.set_name('SQLGL', 'CRM0010');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
234: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
235: fnd_message.set_name('SQLGL', 'CRM0011');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
236: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
237: fnd_message.set_name('SQLGL', 'CRM0012');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
238: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
239: fnd_message.set_name('SQLGL', 'CRM0013');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
240: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
241: fnd_message.set_name('SQLGL', 'CRM0014');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
242: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
243: fnd_message.set_name('SQLGL', 'CRM0015');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
244: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
245: fnd_message.set_name('SQLGL', 'CRM0016');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
246: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
247: fnd_message.set_name('SQLGL', 'CRM0017');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
255: fnd_message.set_name('SQLGL', 'CRM0044');
248: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
255: fnd_message.set_name('SQLGL', 'CRM0044');
256: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
249: fnd_message.set_name('SQLGL', 'CRM0018');
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
255: fnd_message.set_name('SQLGL', 'CRM0044');
256: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
257: END print_validation_failure_codes;
250: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
255: fnd_message.set_name('SQLGL', 'CRM0044');
256: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
257: END print_validation_failure_codes;
258:
251: fnd_message.set_name('SQLGL', 'CRM0019');
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
255: fnd_message.set_name('SQLGL', 'CRM0044');
256: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
257: END print_validation_failure_codes;
258:
259: -------------------------------------------------------------------
252: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
253: fnd_message.set_name('SQLGL', 'CRM0020');
254: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
255: fnd_message.set_name('SQLGL', 'CRM0044');
256: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
257: END print_validation_failure_codes;
258:
259: -------------------------------------------------------------------
260: PROCEDURE insert_cross_rate_set(