eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MST_RELEASE dependencies on FND_MESSAGE

Line 137: fnd_message.set_name('MST',p_seeded_string);

133: function get_seeded_message(p_seeded_string in varchar2)
134: return varchar2 is
135: l_Message_Text varchar2(1000);
136: begin
137: fnd_message.set_name('MST',p_seeded_string);
138: l_Message_Text := fnd_message.get;
139: return l_Message_Text;
140: exception
141: when others then

Line 138: l_Message_Text := fnd_message.get;

134: return varchar2 is
135: l_Message_Text varchar2(1000);
136: begin
137: fnd_message.set_name('MST',p_seeded_string);
138: l_Message_Text := fnd_message.get;
139: return l_Message_Text;
140: exception
141: when others then
142: return null;

Line 151: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_1');

147: begin
148: if g_log_statistics = 1 then
149:
150: print_info(g_log_must_message,'*****************************************************************************************************************');
151: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_1');
152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));
153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));

Line 152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));

148: if g_log_statistics = 1 then
149:
150: print_info(g_log_must_message,'*****************************************************************************************************************');
151: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_1');
152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));
153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));
156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));

Line 153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));

149:
150: print_info(g_log_must_message,'*****************************************************************************************************************');
151: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_1');
152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));
153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));
156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));
157: l_Message_Text := fnd_message.get;

Line 154: fnd_message.set_token('N3',to_char(g_cnt_group_released));

150: print_info(g_log_must_message,'*****************************************************************************************************************');
151: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_1');
152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));
153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));
156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));
157: l_Message_Text := fnd_message.get;
158: print_info(g_log_must_message,l_Message_Text);

Line 155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));

151: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_1');
152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));
153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));
156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));
157: l_Message_Text := fnd_message.get;
158: print_info(g_log_must_message,l_Message_Text);
159:

Line 156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));

152: fnd_message.set_token('N1',to_char(g_cnt_group_released+g_cnt_group_failed+g_cnt_group_not_attempted));
153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));
156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));
157: l_Message_Text := fnd_message.get;
158: print_info(g_log_must_message,l_Message_Text);
159:
160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');

Line 157: l_Message_Text := fnd_message.get;

153: fnd_message.set_token('N2',to_char(g_cnt_group_released+g_cnt_group_failed));
154: fnd_message.set_token('N3',to_char(g_cnt_group_released));
155: fnd_message.set_token('N4',to_char(g_cnt_group_failed));
156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));
157: l_Message_Text := fnd_message.get;
158: print_info(g_log_must_message,l_Message_Text);
159:
160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');
161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));

Line 160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');

156: fnd_message.set_token('N5',to_char(g_cnt_group_not_attempted));
157: l_Message_Text := fnd_message.get;
158: print_info(g_log_must_message,l_Message_Text);
159:
160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');
161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));
162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));

Line 161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));

157: l_Message_Text := fnd_message.get;
158: print_info(g_log_must_message,l_Message_Text);
159:
160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');
161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));
162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));
165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));

Line 162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));

158: print_info(g_log_must_message,l_Message_Text);
159:
160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');
161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));
162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));
165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));
166: l_Message_Text := fnd_message.get;

Line 163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));

159:
160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');
161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));
162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));
165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));
166: l_Message_Text := fnd_message.get;
167: print_info(g_log_must_message,l_Message_Text);

Line 164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));

160: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_2');
161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));
162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));
165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));
166: l_Message_Text := fnd_message.get;
167: print_info(g_log_must_message,l_Message_Text);
168:

Line 165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));

161: fnd_message.set_token('N1',to_char(g_cnt_trip_released+g_cnt_trip_failed+g_cnt_trip_not_attempted));
162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));
165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));
166: l_Message_Text := fnd_message.get;
167: print_info(g_log_must_message,l_Message_Text);
168:
169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');

Line 166: l_Message_Text := fnd_message.get;

162: fnd_message.set_token('N2',to_char(g_cnt_trip_released+g_cnt_trip_failed));
163: fnd_message.set_token('N3',to_char(g_cnt_trip_released));
164: fnd_message.set_token('N4',to_char(g_cnt_trip_failed));
165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));
166: l_Message_Text := fnd_message.get;
167: print_info(g_log_must_message,l_Message_Text);
168:
169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');

Line 169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');

165: fnd_message.set_token('N5',to_char(g_cnt_trip_not_attempted));
166: l_Message_Text := fnd_message.get;
167: print_info(g_log_must_message,l_Message_Text);
168:
169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');
171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));

Line 170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');

166: l_Message_Text := fnd_message.get;
167: print_info(g_log_must_message,l_Message_Text);
168:
169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');
171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));

Line 171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));

167: print_info(g_log_must_message,l_Message_Text);
168:
169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');
171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));
175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));

Line 172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));

168:
169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');
171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));
175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));
176: l_Message_Text := fnd_message.get;

Line 173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));

169: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');
171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));
175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));
176: l_Message_Text := fnd_message.get;
177: print_info(g_log_must_message,l_Message_Text);

Line 174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));

170: fnd_message.set_token('MODEOFTRANSPORT',g_str_truck_tl||' ');
171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));
175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));
176: l_Message_Text := fnd_message.get;
177: print_info(g_log_must_message,l_Message_Text);
178:

Line 175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));

171: fnd_message.set_token('N1',to_char(g_cnt_truck_released+g_cnt_truck_failed+g_cnt_truck_not_attempted));
172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));
175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));
176: l_Message_Text := fnd_message.get;
177: print_info(g_log_must_message,l_Message_Text);
178:
179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');

Line 176: l_Message_Text := fnd_message.get;

172: fnd_message.set_token('N2',to_char(g_cnt_truck_released+g_cnt_truck_failed));
173: fnd_message.set_token('N3',to_char(g_cnt_truck_released));
174: fnd_message.set_token('N4',to_char(g_cnt_truck_failed));
175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));
176: l_Message_Text := fnd_message.get;
177: print_info(g_log_must_message,l_Message_Text);
178:
179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');

Line 179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');

175: fnd_message.set_token('N5',to_char(g_cnt_truck_not_attempted));
176: l_Message_Text := fnd_message.get;
177: print_info(g_log_must_message,l_Message_Text);
178:
179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');
181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));

Line 180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');

176: l_Message_Text := fnd_message.get;
177: print_info(g_log_must_message,l_Message_Text);
178:
179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');
181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));

Line 181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));

177: print_info(g_log_must_message,l_Message_Text);
178:
179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');
181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));
185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));

Line 182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));

178:
179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');
181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));
185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));
186: l_Message_Text := fnd_message.get;

Line 183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));

179: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');
181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));
185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));
186: l_Message_Text := fnd_message.get;
187: print_info(g_log_must_message,l_Message_Text);

Line 184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));

180: fnd_message.set_token('MODEOFTRANSPORT',g_str_ltl_tl||' ');
181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));
185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));
186: l_Message_Text := fnd_message.get;
187: print_info(g_log_must_message,l_Message_Text);
188:

Line 185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));

181: fnd_message.set_token('N1',to_char(g_cnt_ltl_released+g_cnt_ltl_failed+g_cnt_ltl_not_attempted));
182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));
185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));
186: l_Message_Text := fnd_message.get;
187: print_info(g_log_must_message,l_Message_Text);
188:
189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');

Line 186: l_Message_Text := fnd_message.get;

182: fnd_message.set_token('N2',to_char(g_cnt_ltl_released+g_cnt_ltl_failed));
183: fnd_message.set_token('N3',to_char(g_cnt_ltl_released));
184: fnd_message.set_token('N4',to_char(g_cnt_ltl_failed));
185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));
186: l_Message_Text := fnd_message.get;
187: print_info(g_log_must_message,l_Message_Text);
188:
189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);

Line 189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');

185: fnd_message.set_token('N5',to_char(g_cnt_ltl_not_attempted));
186: l_Message_Text := fnd_message.get;
187: print_info(g_log_must_message,l_Message_Text);
188:
189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);
191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));

Line 190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);

186: l_Message_Text := fnd_message.get;
187: print_info(g_log_must_message,l_Message_Text);
188:
189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);
191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));

Line 191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));

187: print_info(g_log_must_message,l_Message_Text);
188:
189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);
191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));
195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));

Line 192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));

188:
189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);
191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));
195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));
196: l_Message_Text := fnd_message.get;

Line 193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));

189: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_50');
190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);
191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));
195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));
196: l_Message_Text := fnd_message.get;
197: print_info(g_log_must_message,l_Message_Text);

Line 194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));

190: fnd_message.set_token('MODEOFTRANSPORT',g_str_parcel_tl);
191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));
195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));
196: l_Message_Text := fnd_message.get;
197: print_info(g_log_must_message,l_Message_Text);
198:

Line 195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));

191: fnd_message.set_token('N1',to_char(g_cnt_parcel_released+g_cnt_parcel_failed+g_cnt_parcel_not_attempted));
192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));
195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));
196: l_Message_Text := fnd_message.get;
197: print_info(g_log_must_message,l_Message_Text);
198:
199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');

Line 196: l_Message_Text := fnd_message.get;

192: fnd_message.set_token('N2',to_char(g_cnt_parcel_released+g_cnt_parcel_failed));
193: fnd_message.set_token('N3',to_char(g_cnt_parcel_released));
194: fnd_message.set_token('N4',to_char(g_cnt_parcel_failed));
195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));
196: l_Message_Text := fnd_message.get;
197: print_info(g_log_must_message,l_Message_Text);
198:
199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');
200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));

Line 199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');

195: fnd_message.set_token('N5',to_char(g_cnt_parcel_not_attempted));
196: l_Message_Text := fnd_message.get;
197: print_info(g_log_must_message,l_Message_Text);
198:
199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');
200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));
201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));

Line 200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));

196: l_Message_Text := fnd_message.get;
197: print_info(g_log_must_message,l_Message_Text);
198:
199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');
200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));
201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));
204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));

Line 201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));

197: print_info(g_log_must_message,l_Message_Text);
198:
199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');
200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));
201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));
204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));
205: l_Message_Text := fnd_message.get;

Line 202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));

198:
199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');
200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));
201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));
204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));
205: l_Message_Text := fnd_message.get;
206: print_info(g_log_must_message,l_Message_Text);

Line 203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));

199: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_3');
200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));
201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));
204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));
205: l_Message_Text := fnd_message.get;
206: print_info(g_log_must_message,l_Message_Text);
207:

Line 204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));

200: fnd_message.set_token('N1',to_char(g_cnt_cm_selected));
201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));
204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));
205: l_Message_Text := fnd_message.get;
206: print_info(g_log_must_message,l_Message_Text);
207:
208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');

Line 205: l_Message_Text := fnd_message.get;

201: fnd_message.set_token('N2',to_char(g_cnt_cm_released+g_cnt_cm_failed));
202: fnd_message.set_token('N3',to_char(g_cnt_cm_released));
203: fnd_message.set_token('N4',to_char(g_cnt_cm_failed));
204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));
205: l_Message_Text := fnd_message.get;
206: print_info(g_log_must_message,l_Message_Text);
207:
208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');
209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));

Line 208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');

204: fnd_message.set_token('N5',to_char(g_cnt_cm_selected-g_cnt_cm_released-g_cnt_cm_failed));
205: l_Message_Text := fnd_message.get;
206: print_info(g_log_must_message,l_Message_Text);
207:
208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');
209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));
210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));

Line 209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));

205: l_Message_Text := fnd_message.get;
206: print_info(g_log_must_message,l_Message_Text);
207:
208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');
209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));
210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));
213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));

Line 210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));

206: print_info(g_log_must_message,l_Message_Text);
207:
208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');
209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));
210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));
213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));
214: l_Message_Text := fnd_message.get;

Line 211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));

207:
208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');
209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));
210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));
213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));
214: l_Message_Text := fnd_message.get;
215: print_info(g_log_must_message,l_Message_Text);

Line 212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));

208: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_49');
209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));
210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));
213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));
214: l_Message_Text := fnd_message.get;
215: print_info(g_log_must_message,l_Message_Text);
216: print_info(g_log_must_message,'*****************************************************************************************************************');

Line 213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));

209: fnd_message.set_token('N1',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed+g_cnt_deadhead_not_attempted));
210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));
213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));
214: l_Message_Text := fnd_message.get;
215: print_info(g_log_must_message,l_Message_Text);
216: print_info(g_log_must_message,'*****************************************************************************************************************');
217: end if;

Line 214: l_Message_Text := fnd_message.get;

210: fnd_message.set_token('N2',to_char(g_cnt_deadhead_released+g_cnt_deadhead_failed));
211: fnd_message.set_token('N3',to_char(g_cnt_deadhead_released));
212: fnd_message.set_token('N4',to_char(g_cnt_deadhead_failed));
213: fnd_message.set_token('N5',to_char(g_cnt_deadhead_not_attempted));
214: l_Message_Text := fnd_message.get;
215: print_info(g_log_must_message,l_Message_Text);
216: print_info(g_log_must_message,'*****************************************************************************************************************');
217: end if;
218: --print_info(g_log_must_message,'Note :');

Line 293: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_25');

289: end if;
290: if g_cnt_group_failed > 0 then
291: if g_cnt_trip_not_attempted < 1 then
292: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. All Trips attempted.');
293: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_25');
294: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
295: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
296: l_Message_Text := fnd_message.get;
297: set_concurrent_status('WARNING', l_Message_Text);

Line 294: fnd_message.set_token('N1',to_char(g_cnt_group_failed));

290: if g_cnt_group_failed > 0 then
291: if g_cnt_trip_not_attempted < 1 then
292: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. All Trips attempted.');
293: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_25');
294: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
295: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
296: l_Message_Text := fnd_message.get;
297: set_concurrent_status('WARNING', l_Message_Text);
298: else

Line 295: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));

291: if g_cnt_trip_not_attempted < 1 then
292: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. All Trips attempted.');
293: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_25');
294: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
295: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
296: l_Message_Text := fnd_message.get;
297: set_concurrent_status('WARNING', l_Message_Text);
298: else
299: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. '||g_cnt_trip_not_attempted||' Trips not attempted to release.');

Line 296: l_Message_Text := fnd_message.get;

292: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. All Trips attempted.');
293: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_25');
294: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
295: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
296: l_Message_Text := fnd_message.get;
297: set_concurrent_status('WARNING', l_Message_Text);
298: else
299: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. '||g_cnt_trip_not_attempted||' Trips not attempted to release.');
300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');

Line 300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');

296: l_Message_Text := fnd_message.get;
297: set_concurrent_status('WARNING', l_Message_Text);
298: else
299: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. '||g_cnt_trip_not_attempted||' Trips not attempted to release.');
300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');
301: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
302: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
303: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
304: l_Message_Text := fnd_message.get;

Line 301: fnd_message.set_token('N1',to_char(g_cnt_group_failed));

297: set_concurrent_status('WARNING', l_Message_Text);
298: else
299: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. '||g_cnt_trip_not_attempted||' Trips not attempted to release.');
300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');
301: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
302: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
303: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
304: l_Message_Text := fnd_message.get;
305: set_concurrent_status('WARNING', l_Message_Text);

Line 302: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));

298: else
299: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. '||g_cnt_trip_not_attempted||' Trips not attempted to release.');
300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');
301: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
302: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
303: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
304: l_Message_Text := fnd_message.get;
305: set_concurrent_status('WARNING', l_Message_Text);
306: end if;

Line 303: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));

299: --set_concurrent_status('WARNING', g_cnt_group_failed ||' Groups failed. '|| g_cnt_trip_failed ||' Trips failed. '||g_cnt_trip_not_attempted||' Trips not attempted to release.');
300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');
301: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
302: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
303: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
304: l_Message_Text := fnd_message.get;
305: set_concurrent_status('WARNING', l_Message_Text);
306: end if;
307: elsif g_cnt_trip_not_attempted > 0 then

Line 304: l_Message_Text := fnd_message.get;

300: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_26');
301: fnd_message.set_token('N1',to_char(g_cnt_group_failed));
302: fnd_message.set_token('N2',to_char(g_cnt_trip_failed));
303: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
304: l_Message_Text := fnd_message.get;
305: set_concurrent_status('WARNING', l_Message_Text);
306: end if;
307: elsif g_cnt_trip_not_attempted > 0 then
308: --set_concurrent_status('WARNING', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released. '||g_cnt_trip_not_attempted||' Trips not attempted to release.' );

Line 309: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_27');

305: set_concurrent_status('WARNING', l_Message_Text);
306: end if;
307: elsif g_cnt_trip_not_attempted > 0 then
308: --set_concurrent_status('WARNING', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released. '||g_cnt_trip_not_attempted||' Trips not attempted to release.' );
309: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_27');
310: fnd_message.set_token('N1',to_char(g_cnt_group_released));
311: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
312: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
313: l_Message_Text := fnd_message.get;

Line 310: fnd_message.set_token('N1',to_char(g_cnt_group_released));

306: end if;
307: elsif g_cnt_trip_not_attempted > 0 then
308: --set_concurrent_status('WARNING', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released. '||g_cnt_trip_not_attempted||' Trips not attempted to release.' );
309: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_27');
310: fnd_message.set_token('N1',to_char(g_cnt_group_released));
311: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
312: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
313: l_Message_Text := fnd_message.get;
314: set_concurrent_status('WARNING', l_Message_Text);

Line 311: fnd_message.set_token('N2',to_char(g_cnt_trip_released));

307: elsif g_cnt_trip_not_attempted > 0 then
308: --set_concurrent_status('WARNING', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released. '||g_cnt_trip_not_attempted||' Trips not attempted to release.' );
309: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_27');
310: fnd_message.set_token('N1',to_char(g_cnt_group_released));
311: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
312: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
313: l_Message_Text := fnd_message.get;
314: set_concurrent_status('WARNING', l_Message_Text);
315: else

Line 312: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));

308: --set_concurrent_status('WARNING', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released. '||g_cnt_trip_not_attempted||' Trips not attempted to release.' );
309: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_27');
310: fnd_message.set_token('N1',to_char(g_cnt_group_released));
311: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
312: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
313: l_Message_Text := fnd_message.get;
314: set_concurrent_status('WARNING', l_Message_Text);
315: else
316: --set_concurrent_status('NORMAL', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released.');

Line 313: l_Message_Text := fnd_message.get;

309: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_27');
310: fnd_message.set_token('N1',to_char(g_cnt_group_released));
311: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
312: fnd_message.set_token('N3',to_char(g_cnt_trip_not_attempted));
313: l_Message_Text := fnd_message.get;
314: set_concurrent_status('WARNING', l_Message_Text);
315: else
316: --set_concurrent_status('NORMAL', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released.');
317: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_28');

Line 317: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_28');

313: l_Message_Text := fnd_message.get;
314: set_concurrent_status('WARNING', l_Message_Text);
315: else
316: --set_concurrent_status('NORMAL', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released.');
317: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_28');
318: fnd_message.set_token('N1',to_char(g_cnt_group_released));
319: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
320: l_Message_Text := fnd_message.get;
321: set_concurrent_status('NORMAL', l_Message_Text);

Line 318: fnd_message.set_token('N1',to_char(g_cnt_group_released));

314: set_concurrent_status('WARNING', l_Message_Text);
315: else
316: --set_concurrent_status('NORMAL', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released.');
317: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_28');
318: fnd_message.set_token('N1',to_char(g_cnt_group_released));
319: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
320: l_Message_Text := fnd_message.get;
321: set_concurrent_status('NORMAL', l_Message_Text);
322: end if;

Line 319: fnd_message.set_token('N2',to_char(g_cnt_trip_released));

315: else
316: --set_concurrent_status('NORMAL', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released.');
317: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_28');
318: fnd_message.set_token('N1',to_char(g_cnt_group_released));
319: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
320: l_Message_Text := fnd_message.get;
321: set_concurrent_status('NORMAL', l_Message_Text);
322: end if;
323: end log_statistics;

Line 320: l_Message_Text := fnd_message.get;

316: --set_concurrent_status('NORMAL', g_cnt_group_released ||' Groups released. '|| g_cnt_trip_released ||' Trips released.');
317: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_28');
318: fnd_message.set_token('N1',to_char(g_cnt_group_released));
319: fnd_message.set_token('N2',to_char(g_cnt_trip_released));
320: l_Message_Text := fnd_message.get;
321: set_concurrent_status('NORMAL', l_Message_Text);
322: end if;
323: end log_statistics;
324:

Line 375: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_29');

371: fetch cur_trip_info bulk collect into l_trip_info_tab;
372: close cur_trip_info;
373:
374: if nvl(l_trip_info_tab.last,0) > 0 then
375: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_29');
376: fnd_message.set_token('N1',to_char(l_trip_info_tab.last));
377: l_Message_Text := fnd_message.get;
378: print_info(g_log_must_message,l_Message_Text);
379: for i in 1..l_trip_info_tab.last loop

Line 376: fnd_message.set_token('N1',to_char(l_trip_info_tab.last));

372: close cur_trip_info;
373:
374: if nvl(l_trip_info_tab.last,0) > 0 then
375: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_29');
376: fnd_message.set_token('N1',to_char(l_trip_info_tab.last));
377: l_Message_Text := fnd_message.get;
378: print_info(g_log_must_message,l_Message_Text);
379: for i in 1..l_trip_info_tab.last loop
380: print_info(p_log_data,l_trip_info_tab(i)||' '||p_status);

Line 377: l_Message_Text := fnd_message.get;

373:
374: if nvl(l_trip_info_tab.last,0) > 0 then
375: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_29');
376: fnd_message.set_token('N1',to_char(l_trip_info_tab.last));
377: l_Message_Text := fnd_message.get;
378: print_info(g_log_must_message,l_Message_Text);
379: for i in 1..l_trip_info_tab.last loop
380: print_info(p_log_data,l_trip_info_tab(i)||' '||p_status);
381: end loop;

Line 571: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_30');

567:
568: if nvl(l_trip_id_tab.last,0) >= 1 then
569: for i in 1..l_trip_id_tab.last loop
570: --print_info(g_log_must_message,'Trip '||l_trip_number_tab(i)||' was out of scope so can not be released directly');
571: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_30');
572: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
573: l_Message_Text := fnd_message.get;
574: print_info(g_log_must_message,l_Message_Text);
575: end loop;

Line 572: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');

568: if nvl(l_trip_id_tab.last,0) >= 1 then
569: for i in 1..l_trip_id_tab.last loop
570: --print_info(g_log_must_message,'Trip '||l_trip_number_tab(i)||' was out of scope so can not be released directly');
571: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_30');
572: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
573: l_Message_Text := fnd_message.get;
574: print_info(g_log_must_message,l_Message_Text);
575: end loop;
576: print_info(g_log_must_message,'');

Line 573: l_Message_Text := fnd_message.get;

569: for i in 1..l_trip_id_tab.last loop
570: --print_info(g_log_must_message,'Trip '||l_trip_number_tab(i)||' was out of scope so can not be released directly');
571: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_30');
572: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
573: l_Message_Text := fnd_message.get;
574: print_info(g_log_must_message,l_Message_Text);
575: end loop;
576: print_info(g_log_must_message,'');
577:

Line 594: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_31');

590:
591: if nvl(l_trip_id_tab.last,0) >= 1 then
592: for i in 1..l_trip_id_tab.last loop
593: --print_info(g_log_must_message,'Trip '||l_trip_number_tab(i)||' was an empty trip and not part of continuous move. So can not be released.');
594: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_31');
595: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
596: l_Message_Text := fnd_message.get;
597: print_info(g_log_must_message,l_Message_Text);
598: end loop;

Line 595: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');

591: if nvl(l_trip_id_tab.last,0) >= 1 then
592: for i in 1..l_trip_id_tab.last loop
593: --print_info(g_log_must_message,'Trip '||l_trip_number_tab(i)||' was an empty trip and not part of continuous move. So can not be released.');
594: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_31');
595: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
596: l_Message_Text := fnd_message.get;
597: print_info(g_log_must_message,l_Message_Text);
598: end loop;
599: print_info(g_log_must_message,'');

Line 596: l_Message_Text := fnd_message.get;

592: for i in 1..l_trip_id_tab.last loop
593: --print_info(g_log_must_message,'Trip '||l_trip_number_tab(i)||' was an empty trip and not part of continuous move. So can not be released.');
594: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_31');
595: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
596: l_Message_Text := fnd_message.get;
597: print_info(g_log_must_message,l_Message_Text);
598: end loop;
599: print_info(g_log_must_message,'');
600:

Line 997: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_32');

993: and mrt.group_id = l_group_id_tab(i);
994:
995: for i in 1..l_trip_number_tab.last loop
996: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as departure date of this trip has been passed');
997: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_32');
998: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
999: l_Message_Text := fnd_message.get;
1000: print_info(g_log_must_message,l_Message_Text);
1001: end loop;

Line 998: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');

994:
995: for i in 1..l_trip_number_tab.last loop
996: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as departure date of this trip has been passed');
997: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_32');
998: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
999: l_Message_Text := fnd_message.get;
1000: print_info(g_log_must_message,l_Message_Text);
1001: end loop;
1002: print_info(g_log_must_message,'');

Line 999: l_Message_Text := fnd_message.get;

995: for i in 1..l_trip_number_tab.last loop
996: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as departure date of this trip has been passed');
997: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_32');
998: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
999: l_Message_Text := fnd_message.get;
1000: print_info(g_log_must_message,l_Message_Text);
1001: end loop;
1002: print_info(g_log_must_message,'');
1003: end if;

Line 1079: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_33');

1075: if p_release_mode = 1 then
1076: l_group_id_tobedeleted_tab(nvl(l_group_id_tobedeleted_tab.last,0) + 1) := l_group_id_tab(i);
1077: l_previous_group_id := l_group_id_tab(i);
1078: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as this trip has restricted exception.');
1079: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_33');
1080: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
1081: l_Message_Text := fnd_message.get;
1082: print_info(g_log_must_message,l_Message_Text);
1083: end if;

Line 1080: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');

1076: l_group_id_tobedeleted_tab(nvl(l_group_id_tobedeleted_tab.last,0) + 1) := l_group_id_tab(i);
1077: l_previous_group_id := l_group_id_tab(i);
1078: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as this trip has restricted exception.');
1079: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_33');
1080: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
1081: l_Message_Text := fnd_message.get;
1082: print_info(g_log_must_message,l_Message_Text);
1083: end if;
1084: end if;

Line 1081: l_Message_Text := fnd_message.get;

1077: l_previous_group_id := l_group_id_tab(i);
1078: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as this trip has restricted exception.');
1079: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_33');
1080: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
1081: l_Message_Text := fnd_message.get;
1082: print_info(g_log_must_message,l_Message_Text);
1083: end if;
1084: end if;
1085: close cur_excep;

Line 1145: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_34');

1141: if l_previous_group_id <> l_group_id_tab(i) then
1142: l_group_id_tobedeleted_tab(nvl(l_group_id_tobedeleted_tab.last,0) + 1) := l_group_id_tab(i);
1143: l_previous_group_id := l_group_id_tab(i);
1144: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as this trip does not obey rule set');
1145: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_34');
1146: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
1147: l_Message_Text := fnd_message.get;
1148: print_info(g_log_must_message,l_Message_Text);
1149: end if;

Line 1146: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');

1142: l_group_id_tobedeleted_tab(nvl(l_group_id_tobedeleted_tab.last,0) + 1) := l_group_id_tab(i);
1143: l_previous_group_id := l_group_id_tab(i);
1144: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as this trip does not obey rule set');
1145: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_34');
1146: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
1147: l_Message_Text := fnd_message.get;
1148: print_info(g_log_must_message,l_Message_Text);
1149: end if;
1150: end loop;

Line 1147: l_Message_Text := fnd_message.get;

1143: l_previous_group_id := l_group_id_tab(i);
1144: --print_info(g_log_must_message,'Group of trip '||l_trip_number_tab(i)||' is not being released as this trip does not obey rule set');
1145: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_34');
1146: fnd_message.set_token('N1',to_char(l_trip_number_tab(i))||' [ '||l_mode_of_transport_tl_tab(i)||' ]');
1147: l_Message_Text := fnd_message.get;
1148: print_info(g_log_must_message,l_Message_Text);
1149: end if;
1150: end loop;
1151:

Line 2624: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_35');

2620: fetch cur_log_error bulk collect into l_message_tab;
2621: close cur_log_error;
2622: if nvl(l_message_tab.last,0) > 0 then
2623: --print_info(g_log_must_message,'Group '||p_group_tab(i)||' failed');
2624: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_35');
2625: fnd_message.set_token('N1',to_char(p_group_tab(i)));
2626: l_Message_Text := fnd_message.get;
2627: print_info(g_log_must_message,l_Message_Text);
2628: for j in 1..l_message_tab.last loop

Line 2625: fnd_message.set_token('N1',to_char(p_group_tab(i)));

2621: close cur_log_error;
2622: if nvl(l_message_tab.last,0) > 0 then
2623: --print_info(g_log_must_message,'Group '||p_group_tab(i)||' failed');
2624: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_35');
2625: fnd_message.set_token('N1',to_char(p_group_tab(i)));
2626: l_Message_Text := fnd_message.get;
2627: print_info(g_log_must_message,l_Message_Text);
2628: for j in 1..l_message_tab.last loop
2629: print_info(g_log_must_message,' '||l_message_tab(j));

Line 2626: l_Message_Text := fnd_message.get;

2622: if nvl(l_message_tab.last,0) > 0 then
2623: --print_info(g_log_must_message,'Group '||p_group_tab(i)||' failed');
2624: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_35');
2625: fnd_message.set_token('N1',to_char(p_group_tab(i)));
2626: l_Message_Text := fnd_message.get;
2627: print_info(g_log_must_message,l_Message_Text);
2628: for j in 1..l_message_tab.last loop
2629: print_info(g_log_must_message,' '||l_message_tab(j));
2630: end loop;

Line 2635: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_36');

2631: log_group_trip_data(g_log_failed_data,p_group_tab(i),'[ failed ]');
2632: end if;
2633: else
2634: --print_info(g_log_released_data,'Group '||p_group_tab(i)||' released');
2635: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_36');
2636: fnd_message.set_token('N1',to_char(p_group_tab(i)));
2637: l_Message_Text := fnd_message.get;
2638: print_info(g_log_must_message,l_Message_Text);
2639: log_group_trip_data(g_log_released_data,p_group_tab(i),'[ released ]');

Line 2636: fnd_message.set_token('N1',to_char(p_group_tab(i)));

2632: end if;
2633: else
2634: --print_info(g_log_released_data,'Group '||p_group_tab(i)||' released');
2635: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_36');
2636: fnd_message.set_token('N1',to_char(p_group_tab(i)));
2637: l_Message_Text := fnd_message.get;
2638: print_info(g_log_must_message,l_Message_Text);
2639: log_group_trip_data(g_log_released_data,p_group_tab(i),'[ released ]');
2640: end if;

Line 2637: l_Message_Text := fnd_message.get;

2633: else
2634: --print_info(g_log_released_data,'Group '||p_group_tab(i)||' released');
2635: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_36');
2636: fnd_message.set_token('N1',to_char(p_group_tab(i)));
2637: l_Message_Text := fnd_message.get;
2638: print_info(g_log_must_message,l_Message_Text);
2639: log_group_trip_data(g_log_released_data,p_group_tab(i),'[ released ]');
2640: end if;
2641: end loop;

Line 2948: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_53');

2944:
2945: if nvl(l_planned_flag_tab.last,0) >= 1 then
2946: for i in 1..l_planned_flag_tab.last loop
2947: if l_planned_flag_tab(i) = -1111 then
2948: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_53');
2949: elsif l_planned_flag_tab(i) = -2222 then
2950: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_54');
2951: elsif l_planned_flag_tab(i) = -3333 then
2952: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_55');

Line 2950: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_54');

2946: for i in 1..l_planned_flag_tab.last loop
2947: if l_planned_flag_tab(i) = -1111 then
2948: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_53');
2949: elsif l_planned_flag_tab(i) = -2222 then
2950: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_54');
2951: elsif l_planned_flag_tab(i) = -3333 then
2952: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_55');
2953: elsif l_planned_flag_tab(i) = -4444 then
2954: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_56');

Line 2952: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_55');

2948: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_53');
2949: elsif l_planned_flag_tab(i) = -2222 then
2950: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_54');
2951: elsif l_planned_flag_tab(i) = -3333 then
2952: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_55');
2953: elsif l_planned_flag_tab(i) = -4444 then
2954: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_56');
2955: elsif l_planned_flag_tab(i) = -5555 then
2956: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_57');

Line 2954: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_56');

2950: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_54');
2951: elsif l_planned_flag_tab(i) = -3333 then
2952: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_55');
2953: elsif l_planned_flag_tab(i) = -4444 then
2954: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_56');
2955: elsif l_planned_flag_tab(i) = -5555 then
2956: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_57');
2957: end if;
2958: fnd_message.set_token('N1',to_char(l_count_tab(i)));

Line 2956: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_57');

2952: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_55');
2953: elsif l_planned_flag_tab(i) = -4444 then
2954: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_56');
2955: elsif l_planned_flag_tab(i) = -5555 then
2956: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_57');
2957: end if;
2958: fnd_message.set_token('N1',to_char(l_count_tab(i)));
2959: l_Message_Text := fnd_message.get;
2960: print_info(g_log_must_message,l_Message_Text);

Line 2958: fnd_message.set_token('N1',to_char(l_count_tab(i)));

2954: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_56');
2955: elsif l_planned_flag_tab(i) = -5555 then
2956: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_57');
2957: end if;
2958: fnd_message.set_token('N1',to_char(l_count_tab(i)));
2959: l_Message_Text := fnd_message.get;
2960: print_info(g_log_must_message,l_Message_Text);
2961: print_info(g_log_must_message,'');
2962: end loop;

Line 2959: l_Message_Text := fnd_message.get;

2955: elsif l_planned_flag_tab(i) = -5555 then
2956: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_57');
2957: end if;
2958: fnd_message.set_token('N1',to_char(l_count_tab(i)));
2959: l_Message_Text := fnd_message.get;
2960: print_info(g_log_must_message,l_Message_Text);
2961: print_info(g_log_must_message,'');
2962: end loop;
2963: end if;

Line 3627: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_41');

3623: --print_info(g_log_must_message,'do_house_keeping : Program started');
3624: print_info(g_log_must_message,get_seeded_message('MST_REL_BK_MESSAGE_40'));
3625: print_info(g_log_must_message,'');
3626: --print_info(g_log_must_message,g_delete_record_count||' number of records will be deleted in one loop');
3627: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_41');
3628: fnd_message.set_token('N1',to_char(g_delete_record_count));
3629: l_Message_Text := fnd_message.get;
3630: print_info(g_log_must_message,l_Message_Text);
3631: --print_info(g_log_must_message,'Total number of loops for one delete attempt are '||g_delete_record_count_loop);

Line 3628: fnd_message.set_token('N1',to_char(g_delete_record_count));

3624: print_info(g_log_must_message,get_seeded_message('MST_REL_BK_MESSAGE_40'));
3625: print_info(g_log_must_message,'');
3626: --print_info(g_log_must_message,g_delete_record_count||' number of records will be deleted in one loop');
3627: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_41');
3628: fnd_message.set_token('N1',to_char(g_delete_record_count));
3629: l_Message_Text := fnd_message.get;
3630: print_info(g_log_must_message,l_Message_Text);
3631: --print_info(g_log_must_message,'Total number of loops for one delete attempt are '||g_delete_record_count_loop);
3632: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_42');

Line 3629: l_Message_Text := fnd_message.get;

3625: print_info(g_log_must_message,'');
3626: --print_info(g_log_must_message,g_delete_record_count||' number of records will be deleted in one loop');
3627: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_41');
3628: fnd_message.set_token('N1',to_char(g_delete_record_count));
3629: l_Message_Text := fnd_message.get;
3630: print_info(g_log_must_message,l_Message_Text);
3631: --print_info(g_log_must_message,'Total number of loops for one delete attempt are '||g_delete_record_count_loop);
3632: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_42');
3633: fnd_message.set_token('N1',to_char(g_delete_record_count_loop));

Line 3632: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_42');

3628: fnd_message.set_token('N1',to_char(g_delete_record_count));
3629: l_Message_Text := fnd_message.get;
3630: print_info(g_log_must_message,l_Message_Text);
3631: --print_info(g_log_must_message,'Total number of loops for one delete attempt are '||g_delete_record_count_loop);
3632: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_42');
3633: fnd_message.set_token('N1',to_char(g_delete_record_count_loop));
3634: l_Message_Text := fnd_message.get;
3635: print_info(g_log_must_message,l_Message_Text);
3636: print_info(g_log_must_message,'');

Line 3633: fnd_message.set_token('N1',to_char(g_delete_record_count_loop));

3629: l_Message_Text := fnd_message.get;
3630: print_info(g_log_must_message,l_Message_Text);
3631: --print_info(g_log_must_message,'Total number of loops for one delete attempt are '||g_delete_record_count_loop);
3632: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_42');
3633: fnd_message.set_token('N1',to_char(g_delete_record_count_loop));
3634: l_Message_Text := fnd_message.get;
3635: print_info(g_log_must_message,l_Message_Text);
3636: print_info(g_log_must_message,'');
3637:

Line 3634: l_Message_Text := fnd_message.get;

3630: print_info(g_log_must_message,l_Message_Text);
3631: --print_info(g_log_must_message,'Total number of loops for one delete attempt are '||g_delete_record_count_loop);
3632: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_42');
3633: fnd_message.set_token('N1',to_char(g_delete_record_count_loop));
3634: l_Message_Text := fnd_message.get;
3635: print_info(g_log_must_message,l_Message_Text);
3636: print_info(g_log_must_message,'');
3637:
3638: if g_truncate_mrt = 1 then

Line 3641: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_43');

3637:
3638: if g_truncate_mrt = 1 then
3639: truncate_mst_table('mst_release_temp');
3640: --print_info(g_log_must_message,'mst_release_temp truncated.');
3641: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_43');
3642: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3643: l_Message_Text := fnd_message.get;
3644: print_info(g_log_must_message,l_Message_Text);
3645: else -- delete from table

Line 3642: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');

3638: if g_truncate_mrt = 1 then
3639: truncate_mst_table('mst_release_temp');
3640: --print_info(g_log_must_message,'mst_release_temp truncated.');
3641: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_43');
3642: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3643: l_Message_Text := fnd_message.get;
3644: print_info(g_log_must_message,l_Message_Text);
3645: else -- delete from table
3646: for i in 1..g_delete_record_count_loop loop

Line 3643: l_Message_Text := fnd_message.get;

3639: truncate_mst_table('mst_release_temp');
3640: --print_info(g_log_must_message,'mst_release_temp truncated.');
3641: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_43');
3642: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3643: l_Message_Text := fnd_message.get;
3644: print_info(g_log_must_message,l_Message_Text);
3645: else -- delete from table
3646: for i in 1..g_delete_record_count_loop loop
3647: delete from mst_release_temp

Line 3650: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3646: for i in 1..g_delete_record_count_loop loop
3647: delete from mst_release_temp
3648: where rownum < g_delete_record_count;
3649: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from mst_release_temp.');
3650: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3651: fnd_message.set_token('N1',to_char(sql%rowcount));
3652: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3653: l_Message_Text := fnd_message.get;
3654: print_info(g_log_must_message,l_Message_Text);

Line 3651: fnd_message.set_token('N1',to_char(sql%rowcount));

3647: delete from mst_release_temp
3648: where rownum < g_delete_record_count;
3649: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from mst_release_temp.');
3650: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3651: fnd_message.set_token('N1',to_char(sql%rowcount));
3652: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3653: l_Message_Text := fnd_message.get;
3654: print_info(g_log_must_message,l_Message_Text);
3655: commit;

Line 3652: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');

3648: where rownum < g_delete_record_count;
3649: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from mst_release_temp.');
3650: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3651: fnd_message.set_token('N1',to_char(sql%rowcount));
3652: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3653: l_Message_Text := fnd_message.get;
3654: print_info(g_log_must_message,l_Message_Text);
3655: commit;
3656: end loop;

Line 3653: l_Message_Text := fnd_message.get;

3649: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from mst_release_temp.');
3650: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3651: fnd_message.set_token('N1',to_char(sql%rowcount));
3652: fnd_message.set_token('TABLE_NAME','MST_RELEASE_TEMP');
3653: l_Message_Text := fnd_message.get;
3654: print_info(g_log_must_message,l_Message_Text);
3655: commit;
3656: end loop;
3657: end if;

Line 3665: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3661: delete from wsh_trips_interface
3662: where interface_action_code = g_tp_release_code
3663: and rownum < g_delete_record_count;
3664: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trips_interface.');
3665: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3666: fnd_message.set_token('N1',to_char(sql%rowcount));
3667: fnd_message.set_token('TABLE_NAME','WSH_TRIPS_INTERFACE');
3668: l_Message_Text := fnd_message.get;
3669: print_info(g_log_must_message,l_Message_Text);

Line 3666: fnd_message.set_token('N1',to_char(sql%rowcount));

3662: where interface_action_code = g_tp_release_code
3663: and rownum < g_delete_record_count;
3664: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trips_interface.');
3665: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3666: fnd_message.set_token('N1',to_char(sql%rowcount));
3667: fnd_message.set_token('TABLE_NAME','WSH_TRIPS_INTERFACE');
3668: l_Message_Text := fnd_message.get;
3669: print_info(g_log_must_message,l_Message_Text);
3670: commit;

Line 3667: fnd_message.set_token('TABLE_NAME','WSH_TRIPS_INTERFACE');

3663: and rownum < g_delete_record_count;
3664: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trips_interface.');
3665: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3666: fnd_message.set_token('N1',to_char(sql%rowcount));
3667: fnd_message.set_token('TABLE_NAME','WSH_TRIPS_INTERFACE');
3668: l_Message_Text := fnd_message.get;
3669: print_info(g_log_must_message,l_Message_Text);
3670: commit;
3671: end loop;

Line 3668: l_Message_Text := fnd_message.get;

3664: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trips_interface.');
3665: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3666: fnd_message.set_token('N1',to_char(sql%rowcount));
3667: fnd_message.set_token('TABLE_NAME','WSH_TRIPS_INTERFACE');
3668: l_Message_Text := fnd_message.get;
3669: print_info(g_log_must_message,l_Message_Text);
3670: commit;
3671: end loop;
3672: print_info(g_log_must_message,'');

Line 3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3675: delete from fte_moves_interface
3676: where interface_action_code = g_tp_release_code
3677: and rownum < g_delete_record_count;
3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3680: fnd_message.set_token('N1',to_char(sql%rowcount));
3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');
3682: l_Message_Text := fnd_message.get;
3683: print_info(g_log_must_message,l_Message_Text);

Line 3680: fnd_message.set_token('N1',to_char(sql%rowcount));

3676: where interface_action_code = g_tp_release_code
3677: and rownum < g_delete_record_count;
3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3680: fnd_message.set_token('N1',to_char(sql%rowcount));
3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');
3682: l_Message_Text := fnd_message.get;
3683: print_info(g_log_must_message,l_Message_Text);
3684: commit;

Line 3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');

3677: and rownum < g_delete_record_count;
3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3680: fnd_message.set_token('N1',to_char(sql%rowcount));
3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');
3682: l_Message_Text := fnd_message.get;
3683: print_info(g_log_must_message,l_Message_Text);
3684: commit;
3685: end loop;

Line 3682: l_Message_Text := fnd_message.get;

3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3680: fnd_message.set_token('N1',to_char(sql%rowcount));
3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');
3682: l_Message_Text := fnd_message.get;
3683: print_info(g_log_must_message,l_Message_Text);
3684: commit;
3685: end loop;
3686: print_info(g_log_must_message,'');

Line 3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3689: delete from fte_trip_moves_interface
3690: where interface_action_code = g_tp_release_code
3691: and rownum < g_delete_record_count;
3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3694: fnd_message.set_token('N1',to_char(sql%rowcount));
3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');
3696: l_Message_Text := fnd_message.get;
3697: print_info(g_log_must_message,l_Message_Text);

Line 3694: fnd_message.set_token('N1',to_char(sql%rowcount));

3690: where interface_action_code = g_tp_release_code
3691: and rownum < g_delete_record_count;
3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3694: fnd_message.set_token('N1',to_char(sql%rowcount));
3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');
3696: l_Message_Text := fnd_message.get;
3697: print_info(g_log_must_message,l_Message_Text);
3698: commit;

Line 3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');

3691: and rownum < g_delete_record_count;
3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3694: fnd_message.set_token('N1',to_char(sql%rowcount));
3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');
3696: l_Message_Text := fnd_message.get;
3697: print_info(g_log_must_message,l_Message_Text);
3698: commit;
3699: end loop;

Line 3696: l_Message_Text := fnd_message.get;

3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3694: fnd_message.set_token('N1',to_char(sql%rowcount));
3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');
3696: l_Message_Text := fnd_message.get;
3697: print_info(g_log_must_message,l_Message_Text);
3698: commit;
3699: end loop;
3700: print_info(g_log_must_message,'');

Line 3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3703: delete from wsh_trip_stops_interface
3704: where interface_action_code = g_tp_release_code
3705: and rownum < g_delete_record_count;
3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3708: fnd_message.set_token('N1',to_char(sql%rowcount));
3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');
3710: l_Message_Text := fnd_message.get;
3711: print_info(g_log_must_message,l_Message_Text);

Line 3708: fnd_message.set_token('N1',to_char(sql%rowcount));

3704: where interface_action_code = g_tp_release_code
3705: and rownum < g_delete_record_count;
3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3708: fnd_message.set_token('N1',to_char(sql%rowcount));
3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');
3710: l_Message_Text := fnd_message.get;
3711: print_info(g_log_must_message,l_Message_Text);
3712: commit;

Line 3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');

3705: and rownum < g_delete_record_count;
3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3708: fnd_message.set_token('N1',to_char(sql%rowcount));
3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');
3710: l_Message_Text := fnd_message.get;
3711: print_info(g_log_must_message,l_Message_Text);
3712: commit;
3713: end loop;

Line 3710: l_Message_Text := fnd_message.get;

3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3708: fnd_message.set_token('N1',to_char(sql%rowcount));
3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');
3710: l_Message_Text := fnd_message.get;
3711: print_info(g_log_must_message,l_Message_Text);
3712: commit;
3713: end loop;
3714: print_info(g_log_must_message,'');

Line 3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3717: delete from wsh_new_del_interface
3718: where interface_action_code = g_tp_release_code
3719: and rownum < g_delete_record_count;
3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3722: fnd_message.set_token('N1',to_char(sql%rowcount));
3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');
3724: l_Message_Text := fnd_message.get;
3725: print_info(g_log_must_message,l_Message_Text);

Line 3722: fnd_message.set_token('N1',to_char(sql%rowcount));

3718: where interface_action_code = g_tp_release_code
3719: and rownum < g_delete_record_count;
3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3722: fnd_message.set_token('N1',to_char(sql%rowcount));
3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');
3724: l_Message_Text := fnd_message.get;
3725: print_info(g_log_must_message,l_Message_Text);
3726: commit;

Line 3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');

3719: and rownum < g_delete_record_count;
3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3722: fnd_message.set_token('N1',to_char(sql%rowcount));
3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');
3724: l_Message_Text := fnd_message.get;
3725: print_info(g_log_must_message,l_Message_Text);
3726: commit;
3727: end loop;

Line 3724: l_Message_Text := fnd_message.get;

3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3722: fnd_message.set_token('N1',to_char(sql%rowcount));
3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');
3724: l_Message_Text := fnd_message.get;
3725: print_info(g_log_must_message,l_Message_Text);
3726: commit;
3727: end loop;
3728: print_info(g_log_must_message,'');

Line 3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3731: delete from wsh_del_legs_interface
3732: where interface_action_code = g_tp_release_code
3733: and rownum < g_delete_record_count;
3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3736: fnd_message.set_token('N1',to_char(sql%rowcount));
3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');
3738: l_Message_Text := fnd_message.get;
3739: print_info(g_log_must_message,l_Message_Text);

Line 3736: fnd_message.set_token('N1',to_char(sql%rowcount));

3732: where interface_action_code = g_tp_release_code
3733: and rownum < g_delete_record_count;
3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3736: fnd_message.set_token('N1',to_char(sql%rowcount));
3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');
3738: l_Message_Text := fnd_message.get;
3739: print_info(g_log_must_message,l_Message_Text);
3740: commit;

Line 3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');

3733: and rownum < g_delete_record_count;
3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3736: fnd_message.set_token('N1',to_char(sql%rowcount));
3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');
3738: l_Message_Text := fnd_message.get;
3739: print_info(g_log_must_message,l_Message_Text);
3740: commit;
3741: end loop;

Line 3738: l_Message_Text := fnd_message.get;

3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3736: fnd_message.set_token('N1',to_char(sql%rowcount));
3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');
3738: l_Message_Text := fnd_message.get;
3739: print_info(g_log_must_message,l_Message_Text);
3740: commit;
3741: end loop;
3742: print_info(g_log_must_message,'');

Line 3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3745: delete from wsh_del_assgn_interface
3746: where interface_action_code = g_tp_release_code
3747: and rownum < g_delete_record_count;
3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3750: fnd_message.set_token('N1',to_char(sql%rowcount));
3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');
3752: l_Message_Text := fnd_message.get;
3753: print_info(g_log_must_message,l_Message_Text);

Line 3750: fnd_message.set_token('N1',to_char(sql%rowcount));

3746: where interface_action_code = g_tp_release_code
3747: and rownum < g_delete_record_count;
3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3750: fnd_message.set_token('N1',to_char(sql%rowcount));
3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');
3752: l_Message_Text := fnd_message.get;
3753: print_info(g_log_must_message,l_Message_Text);
3754: commit;

Line 3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');

3747: and rownum < g_delete_record_count;
3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3750: fnd_message.set_token('N1',to_char(sql%rowcount));
3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');
3752: l_Message_Text := fnd_message.get;
3753: print_info(g_log_must_message,l_Message_Text);
3754: commit;
3755: end loop;

Line 3752: l_Message_Text := fnd_message.get;

3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3750: fnd_message.set_token('N1',to_char(sql%rowcount));
3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');
3752: l_Message_Text := fnd_message.get;
3753: print_info(g_log_must_message,l_Message_Text);
3754: commit;
3755: end loop;
3756: print_info(g_log_must_message,'');

Line 3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3759: delete from wsh_del_details_interface
3760: where interface_action_code = g_tp_release_code
3761: and rownum < g_delete_record_count;
3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3764: fnd_message.set_token('N1',to_char(sql%rowcount));
3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');
3766: l_Message_Text := fnd_message.get;
3767: print_info(g_log_must_message,l_Message_Text);

Line 3764: fnd_message.set_token('N1',to_char(sql%rowcount));

3760: where interface_action_code = g_tp_release_code
3761: and rownum < g_delete_record_count;
3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3764: fnd_message.set_token('N1',to_char(sql%rowcount));
3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');
3766: l_Message_Text := fnd_message.get;
3767: print_info(g_log_must_message,l_Message_Text);
3768: commit;

Line 3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');

3761: and rownum < g_delete_record_count;
3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3764: fnd_message.set_token('N1',to_char(sql%rowcount));
3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');
3766: l_Message_Text := fnd_message.get;
3767: print_info(g_log_must_message,l_Message_Text);
3768: commit;
3769: end loop;

Line 3766: l_Message_Text := fnd_message.get;

3762: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_details_interface.');
3763: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3764: fnd_message.set_token('N1',to_char(sql%rowcount));
3765: fnd_message.set_token('TABLE_NAME','WSH_DEL_DETAILS_INTERFACE');
3766: l_Message_Text := fnd_message.get;
3767: print_info(g_log_must_message,l_Message_Text);
3768: commit;
3769: end loop;
3770: print_info(g_log_must_message,'');

Line 3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

3773: delete from wsh_interface_errors
3774: where interface_action_code = g_tp_release_code
3775: and rownum < g_delete_record_count;
3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3778: fnd_message.set_token('N1',to_char(sql%rowcount));
3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');
3780: l_Message_Text := fnd_message.get;
3781: print_info(g_log_must_message,l_Message_Text);

Line 3778: fnd_message.set_token('N1',to_char(sql%rowcount));

3774: where interface_action_code = g_tp_release_code
3775: and rownum < g_delete_record_count;
3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3778: fnd_message.set_token('N1',to_char(sql%rowcount));
3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');
3780: l_Message_Text := fnd_message.get;
3781: print_info(g_log_must_message,l_Message_Text);
3782: commit;

Line 3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');

3775: and rownum < g_delete_record_count;
3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3778: fnd_message.set_token('N1',to_char(sql%rowcount));
3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');
3780: l_Message_Text := fnd_message.get;
3781: print_info(g_log_must_message,l_Message_Text);
3782: commit;
3783: end loop;

Line 3780: l_Message_Text := fnd_message.get;

3776: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_interface_errors.');
3777: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3778: fnd_message.set_token('N1',to_char(sql%rowcount));
3779: fnd_message.set_token('TABLE_NAME','WSH_INTERFACE_ERRORS');
3780: l_Message_Text := fnd_message.get;
3781: print_info(g_log_must_message,l_Message_Text);
3782: commit;
3783: end loop;
3784: print_info(g_log_must_message,'');

Line 3896: l_errbuf := fnd_message.get;

3892: l_CP_name := 'MSTRELPL';
3893: end if;
3894: p_request_id := fnd_request.submit_request('MST', l_CP_name, NULL, NULL, NULL, p_plan_id, p_release_id, p_release_mode);
3895: if p_request_id = 0 then
3896: l_errbuf := fnd_message.get;
3897: else
3898: commit;
3899: end if;
3900: end submit_release_request;