49: l_title1 VARCHAR2(2000);
50: l_add VARCHAR2(100);
51: l_remove VARCHAR2(100);
52: BEGIN
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
50: l_add VARCHAR2(100);
51: l_remove VARCHAR2(100);
52: BEGIN
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
52: BEGIN
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
88: l_temp_msg := fnd_message.get;
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
88: l_temp_msg := fnd_message.get;
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
88: l_temp_msg := fnd_message.get;
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
93: l_temp_msg := fnd_message.get;
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
93: l_temp_msg := fnd_message.get;
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');
93: l_temp_msg := fnd_message.get;
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');
98: l_temp_msg := fnd_message.get;
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');
98: l_temp_msg := fnd_message.get;
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
98: l_temp_msg := fnd_message.get;
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
103: l_temp_msg := fnd_message.get;
104: IF (length(l_temp_msg) >= 20) THEN
105: l_title1 := substr(l_temp_msg,1,20) || ' ';
106: ELSE
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
103: l_temp_msg := fnd_message.get;
104: IF (length(l_temp_msg) >= 20) THEN
105: l_title1 := substr(l_temp_msg,1,20) || ' ';
106: ELSE
107: l_title1 := RPAD(l_temp_msg,20,' ')||' ';
105: l_title1 := substr(l_temp_msg,1,20) || ' ';
106: ELSE
107: l_title1 := RPAD(l_temp_msg,20,' ')||' ';
108: END IF;
109: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
110: l_temp_msg := fnd_message.get;
111: IF (length(l_temp_msg) >= 40) THEN
112: l_title1 := l_title1 || substr(l_temp_msg,1,40);
113: ELSE
106: ELSE
107: l_title1 := RPAD(l_temp_msg,20,' ')||' ';
108: END IF;
109: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
110: l_temp_msg := fnd_message.get;
111: IF (length(l_temp_msg) >= 40) THEN
112: l_title1 := l_title1 || substr(l_temp_msg,1,40);
113: ELSE
114: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
112: l_title1 := l_title1 || substr(l_temp_msg,1,40);
113: ELSE
114: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
115: END IF;
116: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
117: l_temp_msg := fnd_message.get;
118: IF (length(l_temp_msg) >= 7) THEN
119: l_title1 := l_title1 || substr(l_temp_msg,1,7);
120: ELSE
113: ELSE
114: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
115: END IF;
116: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
117: l_temp_msg := fnd_message.get;
118: IF (length(l_temp_msg) >= 7) THEN
119: l_title1 := l_title1 || substr(l_temp_msg,1,7);
120: ELSE
121: l_title1 := l_title1 || RPAD(l_temp_msg,7,' ')||' ';
119: l_title1 := l_title1 || substr(l_temp_msg,1,7);
120: ELSE
121: l_title1 := l_title1 || RPAD(l_temp_msg,7,' ')||' ';
122: END IF;
123: fnd_message.set_name('IBE','IBE_PRMT_SECTION_NAME_G');
124: l_temp_msg := fnd_message.get;
125: IF (length(l_temp_msg) >= 40) THEN
126: l_title1 := l_title1 || substr(l_temp_msg,1,40);
127: ELSE
120: ELSE
121: l_title1 := l_title1 || RPAD(l_temp_msg,7,' ')||' ';
122: END IF;
123: fnd_message.set_name('IBE','IBE_PRMT_SECTION_NAME_G');
124: l_temp_msg := fnd_message.get;
125: IF (length(l_temp_msg) >= 40) THEN
126: l_title1 := l_title1 || substr(l_temp_msg,1,40);
127: ELSE
128: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
126: l_title1 := l_title1 || substr(l_temp_msg,1,40);
127: ELSE
128: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
129: END IF;
130: fnd_message.set_name('IBE','IBE_PRMT_SECTION_CODE');
131: l_temp_msg := fnd_message.get;
132: l_title1 := l_title1 || l_temp_msg;
133: printOutput(l_title1);
134: -- printOutput('Product Number '||
127: ELSE
128: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
129: END IF;
130: fnd_message.set_name('IBE','IBE_PRMT_SECTION_CODE');
131: l_temp_msg := fnd_message.get;
132: l_title1 := l_title1 || l_temp_msg;
133: printOutput(l_title1);
134: -- printOutput('Product Number '||
135: -- 'Product Name '||