DBA Data[Home] [Help]

APPS.GR_REG_PRINT_DOC dependencies on FND_MESSAGE

Line 128: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');

124:
125: BEGIN
126:
127: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
128: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
129: l_bind_var_msds := FND_MESSAGE.GET;
130:
131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
132: l_bind_var_safety := FND_MESSAGE.GET;

Line 129: l_bind_var_msds := FND_MESSAGE.GET;

125: BEGIN
126:
127: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
128: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
129: l_bind_var_msds := FND_MESSAGE.GET;
130:
131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
132: l_bind_var_safety := FND_MESSAGE.GET;
133:

Line 131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');

127: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
128: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
129: l_bind_var_msds := FND_MESSAGE.GET;
130:
131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
132: l_bind_var_safety := FND_MESSAGE.GET;
133:
134: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
135: l_bind_var_hazard := FND_MESSAGE.GET;

Line 132: l_bind_var_safety := FND_MESSAGE.GET;

128: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
129: l_bind_var_msds := FND_MESSAGE.GET;
130:
131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
132: l_bind_var_safety := FND_MESSAGE.GET;
133:
134: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
135: l_bind_var_hazard := FND_MESSAGE.GET;
136:

Line 134: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');

130:
131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
132: l_bind_var_safety := FND_MESSAGE.GET;
133:
134: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
135: l_bind_var_hazard := FND_MESSAGE.GET;
136:
137: /* Get the Delivery Details for the delivery Id */
138: OPEN c_get_delivery_details;

Line 135: l_bind_var_hazard := FND_MESSAGE.GET;

131: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
132: l_bind_var_safety := FND_MESSAGE.GET;
133:
134: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
135: l_bind_var_hazard := FND_MESSAGE.GET;
136:
137: /* Get the Delivery Details for the delivery Id */
138: OPEN c_get_delivery_details;
139: FETCH c_get_delivery_details into LocalDeliverydetail;

Line 154: FND_MESSAGE.SET_NAME('GR','GR_SHIPPING_ATTACHMENT_ERROR');

150: x_return_status => l_return_status,
151: x_msg_data => l_msg_data );
152:
153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: FND_MESSAGE.SET_NAME('GR','GR_SHIPPING_ATTACHMENT_ERROR');
155: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
156: l_msg_data := FND_MESSAGE.GET;
157: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
158: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 155: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);

151: x_msg_data => l_msg_data );
152:
153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: FND_MESSAGE.SET_NAME('GR','GR_SHIPPING_ATTACHMENT_ERROR');
155: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
156: l_msg_data := FND_MESSAGE.GET;
157: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
158: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
159: END IF;

Line 156: l_msg_data := FND_MESSAGE.GET;

152:
153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: FND_MESSAGE.SET_NAME('GR','GR_SHIPPING_ATTACHMENT_ERROR');
155: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
156: l_msg_data := FND_MESSAGE.GET;
157: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
158: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
159: END IF;
160:

Line 167: FND_MESSAGE.SET_NAME('GR','GR_SHIP_CONFIRM_TEXT');

163:
164: /* Delivery Details exists */
165: WHILE c_get_delivery_details%FOUND LOOP
166: /* Post the log with the Delivery Id for which the Shipping Report is executed */
167: FND_MESSAGE.SET_NAME('GR','GR_SHIP_CONFIRM_TEXT');
168: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
169: l_msg_data := FND_MESSAGE.GET;
170: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
171: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 168: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);

164: /* Delivery Details exists */
165: WHILE c_get_delivery_details%FOUND LOOP
166: /* Post the log with the Delivery Id for which the Shipping Report is executed */
167: FND_MESSAGE.SET_NAME('GR','GR_SHIP_CONFIRM_TEXT');
168: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
169: l_msg_data := FND_MESSAGE.GET;
170: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
171: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
172: /* Get the attached documents for a delivery detail line */

Line 169: l_msg_data := FND_MESSAGE.GET;

165: WHILE c_get_delivery_details%FOUND LOOP
166: /* Post the log with the Delivery Id for which the Shipping Report is executed */
167: FND_MESSAGE.SET_NAME('GR','GR_SHIP_CONFIRM_TEXT');
168: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
169: l_msg_data := FND_MESSAGE.GET;
170: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
171: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
172: /* Get the attached documents for a delivery detail line */
173: OPEN c_get_attch_doc_details;

Line 179: FND_MESSAGE.SET_NAME('GR','GR_NO_ATTACHED_DOC_TEXT');

175: /* If attached documents exists or not */
176: IF c_get_attch_doc_details%NOTFOUND THEN
177: /* No attached documents exists for the delivery detail line, post the log with the information */
178: Close c_get_attch_doc_details;
179: FND_MESSAGE.SET_NAME('GR','GR_NO_ATTACHED_DOC_TEXT');
180: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
181: l_msg_data := FND_MESSAGE.GET;
182: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
183: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 180: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);

176: IF c_get_attch_doc_details%NOTFOUND THEN
177: /* No attached documents exists for the delivery detail line, post the log with the information */
178: Close c_get_attch_doc_details;
179: FND_MESSAGE.SET_NAME('GR','GR_NO_ATTACHED_DOC_TEXT');
180: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
181: l_msg_data := FND_MESSAGE.GET;
182: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
183: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
184: ELSE

Line 181: l_msg_data := FND_MESSAGE.GET;

177: /* No attached documents exists for the delivery detail line, post the log with the information */
178: Close c_get_attch_doc_details;
179: FND_MESSAGE.SET_NAME('GR','GR_NO_ATTACHED_DOC_TEXT');
180: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
181: l_msg_data := FND_MESSAGE.GET;
182: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
183: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
184: ELSE
185: /* Attached documents exists for the delivery detail line */

Line 204: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_SHIP');

200: '', '', '', '', '', '', '', '', '', '');
201:
202: IF l_concurrent_id = 0 THEN
203: /* Java concurrent program failed, to print the attached document to an output file */
204: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_SHIP');
205: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);
206: l_msg_data := FND_MESSAGE.GET;
207: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
208: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 205: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);

201:
202: IF l_concurrent_id = 0 THEN
203: /* Java concurrent program failed, to print the attached document to an output file */
204: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_SHIP');
205: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);
206: l_msg_data := FND_MESSAGE.GET;
207: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
208: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
209: ELSE

Line 206: l_msg_data := FND_MESSAGE.GET;

202: IF l_concurrent_id = 0 THEN
203: /* Java concurrent program failed, to print the attached document to an output file */
204: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_SHIP');
205: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);
206: l_msg_data := FND_MESSAGE.GET;
207: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
208: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
209: ELSE
210:

Line 212: FND_MESSAGE.SET_NAME('GR','GR_REG_DOC_PRINT_TEXT');

208: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
209: ELSE
210:
211: /* Java concurrent program was succesfull, therefore, post the information with regard to the delivery details and the attached documents to the log */
212: FND_MESSAGE.SET_NAME('GR','GR_REG_DOC_PRINT_TEXT');
213: l_msg_data := FND_MESSAGE.GET;
214: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
215: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
216: /* Post the Delivery Detail ID to the log for which the document was printed */

Line 213: l_msg_data := FND_MESSAGE.GET;

209: ELSE
210:
211: /* Java concurrent program was succesfull, therefore, post the information with regard to the delivery details and the attached documents to the log */
212: FND_MESSAGE.SET_NAME('GR','GR_REG_DOC_PRINT_TEXT');
213: l_msg_data := FND_MESSAGE.GET;
214: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
215: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
216: /* Post the Delivery Detail ID to the log for which the document was printed */
217: FND_MESSAGE.SET_NAME('GR','GR_DELIVERY_DETAIL_ID_TEXT');

Line 217: FND_MESSAGE.SET_NAME('GR','GR_DELIVERY_DETAIL_ID_TEXT');

213: l_msg_data := FND_MESSAGE.GET;
214: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
215: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
216: /* Post the Delivery Detail ID to the log for which the document was printed */
217: FND_MESSAGE.SET_NAME('GR','GR_DELIVERY_DETAIL_ID_TEXT');
218: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
219: l_msg_data := FND_MESSAGE.GET;
220: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
221: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 218: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);

214: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
215: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
216: /* Post the Delivery Detail ID to the log for which the document was printed */
217: FND_MESSAGE.SET_NAME('GR','GR_DELIVERY_DETAIL_ID_TEXT');
218: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
219: l_msg_data := FND_MESSAGE.GET;
220: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
221: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
222:

Line 219: l_msg_data := FND_MESSAGE.GET;

215: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
216: /* Post the Delivery Detail ID to the log for which the document was printed */
217: FND_MESSAGE.SET_NAME('GR','GR_DELIVERY_DETAIL_ID_TEXT');
218: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID', LocalDeliverydetail.delivery_detail_id, FALSE);
219: l_msg_data := FND_MESSAGE.GET;
220: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
221: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
222:
223: /* Post the Delivery Detail ID to the log for which the document was printed */

Line 224: FND_MESSAGE.SET_NAME('GR','GR_ORDER_ID_TEXT');

220: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
221: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
222:
223: /* Post the Delivery Detail ID to the log for which the document was printed */
224: FND_MESSAGE.SET_NAME('GR','GR_ORDER_ID_TEXT');
225: FND_MESSAGE.SET_TOKEN('ORDER_ID', LocalDeliverydetail.Source_Header_id, FALSE);
226: l_msg_data := FND_MESSAGE.GET;
227: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 225: FND_MESSAGE.SET_TOKEN('ORDER_ID', LocalDeliverydetail.Source_Header_id, FALSE);

221: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
222:
223: /* Post the Delivery Detail ID to the log for which the document was printed */
224: FND_MESSAGE.SET_NAME('GR','GR_ORDER_ID_TEXT');
225: FND_MESSAGE.SET_TOKEN('ORDER_ID', LocalDeliverydetail.Source_Header_id, FALSE);
226: l_msg_data := FND_MESSAGE.GET;
227: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229:

Line 226: l_msg_data := FND_MESSAGE.GET;

222:
223: /* Post the Delivery Detail ID to the log for which the document was printed */
224: FND_MESSAGE.SET_NAME('GR','GR_ORDER_ID_TEXT');
225: FND_MESSAGE.SET_TOKEN('ORDER_ID', LocalDeliverydetail.Source_Header_id, FALSE);
226: l_msg_data := FND_MESSAGE.GET;
227: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229:
230: /* Post the Sales Order Line ID to the log for which the document was printed */

Line 231: FND_MESSAGE.SET_NAME('GR','GR_ORDER_LINE_ID_TEXT');

227: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229:
230: /* Post the Sales Order Line ID to the log for which the document was printed */
231: FND_MESSAGE.SET_NAME('GR','GR_ORDER_LINE_ID_TEXT');
232: FND_MESSAGE.SET_TOKEN('ORDER_LINE_ID', LocalDeliverydetail.Source_Line_id, FALSE);
233: l_msg_data := FND_MESSAGE.GET;
234: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
235: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 232: FND_MESSAGE.SET_TOKEN('ORDER_LINE_ID', LocalDeliverydetail.Source_Line_id, FALSE);

228: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
229:
230: /* Post the Sales Order Line ID to the log for which the document was printed */
231: FND_MESSAGE.SET_NAME('GR','GR_ORDER_LINE_ID_TEXT');
232: FND_MESSAGE.SET_TOKEN('ORDER_LINE_ID', LocalDeliverydetail.Source_Line_id, FALSE);
233: l_msg_data := FND_MESSAGE.GET;
234: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
235: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
236:

Line 233: l_msg_data := FND_MESSAGE.GET;

229:
230: /* Post the Sales Order Line ID to the log for which the document was printed */
231: FND_MESSAGE.SET_NAME('GR','GR_ORDER_LINE_ID_TEXT');
232: FND_MESSAGE.SET_TOKEN('ORDER_LINE_ID', LocalDeliverydetail.Source_Line_id, FALSE);
233: l_msg_data := FND_MESSAGE.GET;
234: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
235: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
236:
237: /* Post the Sales Order Number to the log for which the document was printed */

Line 238: FND_MESSAGE.SET_NAME('GR','GR_ORD_NUMBER_TEXT');

234: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
235: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
236:
237: /* Post the Sales Order Number to the log for which the document was printed */
238: FND_MESSAGE.SET_NAME('GR','GR_ORD_NUMBER_TEXT');
239: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', LocalDeliverydetail.Source_Header_Number, FALSE);
240: l_msg_data := FND_MESSAGE.GET;
241: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
242: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 239: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', LocalDeliverydetail.Source_Header_Number, FALSE);

235: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
236:
237: /* Post the Sales Order Number to the log for which the document was printed */
238: FND_MESSAGE.SET_NAME('GR','GR_ORD_NUMBER_TEXT');
239: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', LocalDeliverydetail.Source_Header_Number, FALSE);
240: l_msg_data := FND_MESSAGE.GET;
241: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
242: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
243:

Line 240: l_msg_data := FND_MESSAGE.GET;

236:
237: /* Post the Sales Order Number to the log for which the document was printed */
238: FND_MESSAGE.SET_NAME('GR','GR_ORD_NUMBER_TEXT');
239: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER', LocalDeliverydetail.Source_Header_Number, FALSE);
240: l_msg_data := FND_MESSAGE.GET;
241: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
242: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
243:
244: /* Post the Sales Order Line Number to the log for which the document was printed */

Line 245: FND_MESSAGE.SET_NAME('GR','GR_ORD_LINE_NO_TEXT');

241: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
242: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
243:
244: /* Post the Sales Order Line Number to the log for which the document was printed */
245: FND_MESSAGE.SET_NAME('GR','GR_ORD_LINE_NO_TEXT');
246: FND_MESSAGE.SET_TOKEN('ORDER_LINE_NO', LocalDeliverydetail.Source_Line_Number, FALSE);
247: l_msg_data := FND_MESSAGE.GET;
248: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
249: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 246: FND_MESSAGE.SET_TOKEN('ORDER_LINE_NO', LocalDeliverydetail.Source_Line_Number, FALSE);

242: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
243:
244: /* Post the Sales Order Line Number to the log for which the document was printed */
245: FND_MESSAGE.SET_NAME('GR','GR_ORD_LINE_NO_TEXT');
246: FND_MESSAGE.SET_TOKEN('ORDER_LINE_NO', LocalDeliverydetail.Source_Line_Number, FALSE);
247: l_msg_data := FND_MESSAGE.GET;
248: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
249: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
250:

Line 247: l_msg_data := FND_MESSAGE.GET;

243:
244: /* Post the Sales Order Line Number to the log for which the document was printed */
245: FND_MESSAGE.SET_NAME('GR','GR_ORD_LINE_NO_TEXT');
246: FND_MESSAGE.SET_TOKEN('ORDER_LINE_NO', LocalDeliverydetail.Source_Line_Number, FALSE);
247: l_msg_data := FND_MESSAGE.GET;
248: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
249: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
250:
251: /* Post the Category Description to the log for which the document was printed */

Line 252: FND_MESSAGE.SET_NAME('GR','GR_CATEGORY_DESC_TEXT');

248: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
249: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
250:
251: /* Post the Category Description to the log for which the document was printed */
252: FND_MESSAGE.SET_NAME('GR','GR_CATEGORY_DESC_TEXT');
253: FND_MESSAGE.SET_TOKEN('CATEGORY_DESC', LocalAttachDocDetail.category_description, FALSE);
254: l_msg_data := FND_MESSAGE.GET;
255: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
256: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 253: FND_MESSAGE.SET_TOKEN('CATEGORY_DESC', LocalAttachDocDetail.category_description, FALSE);

249: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
250:
251: /* Post the Category Description to the log for which the document was printed */
252: FND_MESSAGE.SET_NAME('GR','GR_CATEGORY_DESC_TEXT');
253: FND_MESSAGE.SET_TOKEN('CATEGORY_DESC', LocalAttachDocDetail.category_description, FALSE);
254: l_msg_data := FND_MESSAGE.GET;
255: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
256: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
257:

Line 254: l_msg_data := FND_MESSAGE.GET;

250:
251: /* Post the Category Description to the log for which the document was printed */
252: FND_MESSAGE.SET_NAME('GR','GR_CATEGORY_DESC_TEXT');
253: FND_MESSAGE.SET_TOKEN('CATEGORY_DESC', LocalAttachDocDetail.category_description, FALSE);
254: l_msg_data := FND_MESSAGE.GET;
255: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
256: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
257:
258: /* Post the File Name to the log for which the document was printed */

Line 259: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');

255: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
256: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
257:
258: /* Post the File Name to the log for which the document was printed */
259: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');
260: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);
261: l_msg_data := FND_MESSAGE.GET;
262: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
263: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 260: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);

256: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
257:
258: /* Post the File Name to the log for which the document was printed */
259: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');
260: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);
261: l_msg_data := FND_MESSAGE.GET;
262: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
263: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
264:

Line 261: l_msg_data := FND_MESSAGE.GET;

257:
258: /* Post the File Name to the log for which the document was printed */
259: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');
260: FND_MESSAGE.SET_TOKEN('FILE_NAME', LocalAttachDocDetail.file_name, FALSE);
261: l_msg_data := FND_MESSAGE.GET;
262: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
263: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
264:
265: /* Post the Concurrent request id for the java concurrent program to the log for which the document was printed */

Line 267: FND_MESSAGE.SET_NAME('GR','GR_DOC_CONC_REQ_ID_TEXT');

263: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
264:
265: /* Post the Concurrent request id for the java concurrent program to the log for which the document was printed */
266: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
267: FND_MESSAGE.SET_NAME('GR','GR_DOC_CONC_REQ_ID_TEXT');
268: FND_MESSAGE.SET_TOKEN('DOC_CONC_REQ_ID', l_concurrent_id, FALSE);
269: l_msg_data := FND_MESSAGE.GET;
270: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
271: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 268: FND_MESSAGE.SET_TOKEN('DOC_CONC_REQ_ID', l_concurrent_id, FALSE);

264:
265: /* Post the Concurrent request id for the java concurrent program to the log for which the document was printed */
266: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
267: FND_MESSAGE.SET_NAME('GR','GR_DOC_CONC_REQ_ID_TEXT');
268: FND_MESSAGE.SET_TOKEN('DOC_CONC_REQ_ID', l_concurrent_id, FALSE);
269: l_msg_data := FND_MESSAGE.GET;
270: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
271: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
272:

Line 269: l_msg_data := FND_MESSAGE.GET;

265: /* Post the Concurrent request id for the java concurrent program to the log for which the document was printed */
266: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
267: FND_MESSAGE.SET_NAME('GR','GR_DOC_CONC_REQ_ID_TEXT');
268: FND_MESSAGE.SET_TOKEN('DOC_CONC_REQ_ID', l_concurrent_id, FALSE);
269: l_msg_data := FND_MESSAGE.GET;
270: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
271: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
272:
273: /* Post the Entity Name to the log for which the document was printed */

Line 274: FND_MESSAGE.SET_NAME('GR','GR_ENTITY_NAME_TEXT');

270: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
271: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
272:
273: /* Post the Entity Name to the log for which the document was printed */
274: FND_MESSAGE.SET_NAME('GR','GR_ENTITY_NAME_TEXT');
275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', LocalAttachDocDetail.user_entity_name, FALSE);
276: l_msg_data := FND_MESSAGE.GET;
277: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
278: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', LocalAttachDocDetail.user_entity_name, FALSE);

271: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
272:
273: /* Post the Entity Name to the log for which the document was printed */
274: FND_MESSAGE.SET_NAME('GR','GR_ENTITY_NAME_TEXT');
275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', LocalAttachDocDetail.user_entity_name, FALSE);
276: l_msg_data := FND_MESSAGE.GET;
277: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
278: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
279:

Line 276: l_msg_data := FND_MESSAGE.GET;

272:
273: /* Post the Entity Name to the log for which the document was printed */
274: FND_MESSAGE.SET_NAME('GR','GR_ENTITY_NAME_TEXT');
275: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', LocalAttachDocDetail.user_entity_name, FALSE);
276: l_msg_data := FND_MESSAGE.GET;
277: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
278: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
279:
280: /* M.Grosser 12-Apr-2005 Added for 3rd Party Integration project */

Line 284: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM_ORG_ID');

280: /* M.Grosser 12-Apr-2005 Added for 3rd Party Integration project */
281: OPEN c_get_item_code(LocalDeliverydetail.organization_id,LocalDeliverydetail.inventory_item_id);
282: FETCH c_get_item_code into l_item_code;
283: IF c_get_item_code%NOTFOUND then
284: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM_ORG_ID');
285: FND_MESSAGE.SET_TOKEN('ITEM_ID', LocalDeliverydetail.INVENTORY_ITEM_ID, FALSE);
286: FND_MESSAGE.SET_TOKEN('ORGN_ID', LocalDeliverydetail.ORGANIZATION_ID, FALSE);
287: l_msg_data := FND_MESSAGE.GET;
288: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);

Line 285: FND_MESSAGE.SET_TOKEN('ITEM_ID', LocalDeliverydetail.INVENTORY_ITEM_ID, FALSE);

281: OPEN c_get_item_code(LocalDeliverydetail.organization_id,LocalDeliverydetail.inventory_item_id);
282: FETCH c_get_item_code into l_item_code;
283: IF c_get_item_code%NOTFOUND then
284: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM_ORG_ID');
285: FND_MESSAGE.SET_TOKEN('ITEM_ID', LocalDeliverydetail.INVENTORY_ITEM_ID, FALSE);
286: FND_MESSAGE.SET_TOKEN('ORGN_ID', LocalDeliverydetail.ORGANIZATION_ID, FALSE);
287: l_msg_data := FND_MESSAGE.GET;
288: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
289: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 286: FND_MESSAGE.SET_TOKEN('ORGN_ID', LocalDeliverydetail.ORGANIZATION_ID, FALSE);

282: FETCH c_get_item_code into l_item_code;
283: IF c_get_item_code%NOTFOUND then
284: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM_ORG_ID');
285: FND_MESSAGE.SET_TOKEN('ITEM_ID', LocalDeliverydetail.INVENTORY_ITEM_ID, FALSE);
286: FND_MESSAGE.SET_TOKEN('ORGN_ID', LocalDeliverydetail.ORGANIZATION_ID, FALSE);
287: l_msg_data := FND_MESSAGE.GET;
288: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
289: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
290: RETURN;

Line 287: l_msg_data := FND_MESSAGE.GET;

283: IF c_get_item_code%NOTFOUND then
284: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM_ORG_ID');
285: FND_MESSAGE.SET_TOKEN('ITEM_ID', LocalDeliverydetail.INVENTORY_ITEM_ID, FALSE);
286: FND_MESSAGE.SET_TOKEN('ORGN_ID', LocalDeliverydetail.ORGANIZATION_ID, FALSE);
287: l_msg_data := FND_MESSAGE.GET;
288: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
289: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
290: RETURN;
291: END IF;

Line 300: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE');

296: --
297: OPEN c_get_recipient_id(LocalDeliverydetail.ship_to_location_id);
298: FETCH c_get_recipient_id into l_recipient_id;
299: IF c_get_recipient_id%NOTFOUND then
300: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE');
301: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', LocalDeliverydetail.SHIP_TO_LOCATION_ID, FALSE);
302: l_msg_data := FND_MESSAGE.GET;
303: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
304: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 301: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', LocalDeliverydetail.SHIP_TO_LOCATION_ID, FALSE);

297: OPEN c_get_recipient_id(LocalDeliverydetail.ship_to_location_id);
298: FETCH c_get_recipient_id into l_recipient_id;
299: IF c_get_recipient_id%NOTFOUND then
300: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE');
301: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', LocalDeliverydetail.SHIP_TO_LOCATION_ID, FALSE);
302: l_msg_data := FND_MESSAGE.GET;
303: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
304: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
305: RETURN;

Line 302: l_msg_data := FND_MESSAGE.GET;

298: FETCH c_get_recipient_id into l_recipient_id;
299: IF c_get_recipient_id%NOTFOUND then
300: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE');
301: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', LocalDeliverydetail.SHIP_TO_LOCATION_ID, FALSE);
302: l_msg_data := FND_MESSAGE.GET;
303: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
304: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
305: RETURN;
306: END IF;

Line 310: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');

306: END IF;
307: CLOSE c_get_recipient_id;
308:
309:
310: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');
311: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);
312: l_msg_data := FND_MESSAGE.GET;
313: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
314: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 311: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);

307: CLOSE c_get_recipient_id;
308:
309:
310: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');
311: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);
312: l_msg_data := FND_MESSAGE.GET;
313: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
314: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
315: /* Call Update Dispatch History API with creation_source = 1 (Internal)*/

Line 312: l_msg_data := FND_MESSAGE.GET;

308:
309:
310: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');
311: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);
312: l_msg_data := FND_MESSAGE.GET;
313: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
314: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
315: /* Call Update Dispatch History API with creation_source = 1 (Internal)*/
316: GR_DISPATCH_HISTORY_PUB.create_dispatch_history (

Line 348: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');

344:
345: -- M. Grosser 13-Jun-2005 End of changes
346:
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');
349: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);
350: l_msg_data := FND_MESSAGE.GET;
351: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
352: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 349: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);

345: -- M. Grosser 13-Jun-2005 End of changes
346:
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');
349: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);
350: l_msg_data := FND_MESSAGE.GET;
351: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
352: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
353: FND_FILE.PUT(FND_FILE.LOG, l_error_msg);

Line 350: l_msg_data := FND_MESSAGE.GET;

346:
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');
349: FND_MESSAGE.SET_TOKEN('FILE_NAME',localAttachDocDetail.File_name, FALSE);
350: l_msg_data := FND_MESSAGE.GET;
351: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
352: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
353: FND_FILE.PUT(FND_FILE.LOG, l_error_msg);
354: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 370: FND_MESSAGE.SET_NAME('GR','GR_NO_DELIVERY_DETAILS');

366: END IF; /* c_get_delivery_details%NOTFOUND */
367:
368: EXCEPTION
369: WHEN No_Delivery_Details THEN
370: FND_MESSAGE.SET_NAME('GR','GR_NO_DELIVERY_DETAILS');
371: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
372: WHEN OTHERS THEN
373: l_code_block :='Print Shipping Doc ' || ' ' ||TO_CHAR(l_oracle_error);
374: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');

Line 371: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);

367:
368: EXCEPTION
369: WHEN No_Delivery_Details THEN
370: FND_MESSAGE.SET_NAME('GR','GR_NO_DELIVERY_DETAILS');
371: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
372: WHEN OTHERS THEN
373: l_code_block :='Print Shipping Doc ' || ' ' ||TO_CHAR(l_oracle_error);
374: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
375: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);

Line 374: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');

370: FND_MESSAGE.SET_NAME('GR','GR_NO_DELIVERY_DETAILS');
371: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
372: WHEN OTHERS THEN
373: l_code_block :='Print Shipping Doc ' || ' ' ||TO_CHAR(l_oracle_error);
374: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
375: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
376:
377: END print_shipping_doc;
378:

Line 375: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);

371: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id, FALSE);
372: WHEN OTHERS THEN
373: l_code_block :='Print Shipping Doc ' || ' ' ||TO_CHAR(l_oracle_error);
374: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
375: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
376:
377: END print_shipping_doc;
378:
379:

Line 534: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');

530:
531: BEGIN
532:
533: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
534: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
535: l_bind_var_msds := FND_MESSAGE.GET;
536:
537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
538: l_bind_var_safety := FND_MESSAGE.GET;

Line 535: l_bind_var_msds := FND_MESSAGE.GET;

531: BEGIN
532:
533: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
534: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
535: l_bind_var_msds := FND_MESSAGE.GET;
536:
537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
538: l_bind_var_safety := FND_MESSAGE.GET;
539:

Line 537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');

533: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
534: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
535: l_bind_var_msds := FND_MESSAGE.GET;
536:
537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
538: l_bind_var_safety := FND_MESSAGE.GET;
539:
540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
541: l_bind_var_hazard := FND_MESSAGE.GET;

Line 538: l_bind_var_safety := FND_MESSAGE.GET;

534: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
535: l_bind_var_msds := FND_MESSAGE.GET;
536:
537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
538: l_bind_var_safety := FND_MESSAGE.GET;
539:
540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
541: l_bind_var_hazard := FND_MESSAGE.GET;
542:

Line 540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');

536:
537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
538: l_bind_var_safety := FND_MESSAGE.GET;
539:
540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
541: l_bind_var_hazard := FND_MESSAGE.GET;
542:
543: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
544: l_bind_var_msds_rejected := FND_MESSAGE.GET;

Line 541: l_bind_var_hazard := FND_MESSAGE.GET;

537: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
538: l_bind_var_safety := FND_MESSAGE.GET;
539:
540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
541: l_bind_var_hazard := FND_MESSAGE.GET;
542:
543: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
544: l_bind_var_msds_rejected := FND_MESSAGE.GET;
545:

Line 543: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');

539:
540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
541: l_bind_var_hazard := FND_MESSAGE.GET;
542:
543: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
544: l_bind_var_msds_rejected := FND_MESSAGE.GET;
545:
546: l_user_id := NVL(FND_PROFILE.VALUE('USER_ID'),0);
547:

Line 544: l_bind_var_msds_rejected := FND_MESSAGE.GET;

540: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
541: l_bind_var_hazard := FND_MESSAGE.GET;
542:
543: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
544: l_bind_var_msds_rejected := FND_MESSAGE.GET;
545:
546: l_user_id := NVL(FND_PROFILE.VALUE('USER_ID'),0);
547:
548: OPEN c_get_delivery_details;

Line 586: FND_MESSAGE.SET_NAME('GR', 'GR_NO_TERRITORY_PROFILE');

582: OPEN c_get_country;
583: FETCH c_get_country into CountryRec;
584: CLOSE c_get_country;
585:
586: FND_MESSAGE.SET_NAME('GR', 'GR_NO_TERRITORY_PROFILE');
587: FND_MESSAGE.SET_TOKEN('COUNTRY', CountryRec.country, FALSE);
588: l_msg_data := FND_MESSAGE.GET;
589: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
590: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 587: FND_MESSAGE.SET_TOKEN('COUNTRY', CountryRec.country, FALSE);

583: FETCH c_get_country into CountryRec;
584: CLOSE c_get_country;
585:
586: FND_MESSAGE.SET_NAME('GR', 'GR_NO_TERRITORY_PROFILE');
587: FND_MESSAGE.SET_TOKEN('COUNTRY', CountryRec.country, FALSE);
588: l_msg_data := FND_MESSAGE.GET;
589: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
590: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
591:

Line 588: l_msg_data := FND_MESSAGE.GET;

584: CLOSE c_get_country;
585:
586: FND_MESSAGE.SET_NAME('GR', 'GR_NO_TERRITORY_PROFILE');
587: FND_MESSAGE.SET_TOKEN('COUNTRY', CountryRec.country, FALSE);
588: l_msg_data := FND_MESSAGE.GET;
589: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
590: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
591:
592: ELSE

Line 601: FND_MESSAGE.SET_NAME('GR', 'GR_NO_ATTACH_DOCUMENT');

597:
598: /*If no document meets that criteria */
599: IF c_latest_document%NOTFOUND THEN
600: /* Write no document found message to error log */
601: FND_MESSAGE.SET_NAME('GR', 'GR_NO_ATTACH_DOCUMENT');
602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);
603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);
604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);
605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);

Line 602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);

598: /*If no document meets that criteria */
599: IF c_latest_document%NOTFOUND THEN
600: /* Write no document found message to error log */
601: FND_MESSAGE.SET_NAME('GR', 'GR_NO_ATTACH_DOCUMENT');
602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);
603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);
604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);
605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);
606: l_msg_data := FND_MESSAGE.GET;

Line 603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);

599: IF c_latest_document%NOTFOUND THEN
600: /* Write no document found message to error log */
601: FND_MESSAGE.SET_NAME('GR', 'GR_NO_ATTACH_DOCUMENT');
602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);
603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);
604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);
605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);
606: l_msg_data := FND_MESSAGE.GET;
607: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);

Line 604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);

600: /* Write no document found message to error log */
601: FND_MESSAGE.SET_NAME('GR', 'GR_NO_ATTACH_DOCUMENT');
602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);
603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);
604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);
605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);
606: l_msg_data := FND_MESSAGE.GET;
607: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
608: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);

601: FND_MESSAGE.SET_NAME('GR', 'GR_NO_ATTACH_DOCUMENT');
602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);
603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);
604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);
605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);
606: l_msg_data := FND_MESSAGE.GET;
607: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
608: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
609:

Line 606: l_msg_data := FND_MESSAGE.GET;

602: FND_MESSAGE.SET_TOKEN('ITEM', l_item_code, FALSE);
603: FND_MESSAGE.SET_TOKEN('DOC_CODE', l_territory_details.document_code, FALSE);
604: FND_MESSAGE.SET_TOKEN('LANG', l_territory_details.language, FALSE);
605: FND_MESSAGE.SET_TOKEN('DISCLOSURE', l_territory_details.disclosure_code, FALSE);
606: l_msg_data := FND_MESSAGE.GET;
607: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
608: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
609:
610: ELSE

Line 712: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');

708:
709: EXCEPTION
710: WHEN OTHERS THEN
711: l_code_block :='Shipping Attachment :' ;
712: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
713: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
714: x_msg_data := FND_MESSAGE.GET;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: END;

Line 713: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);

709: EXCEPTION
710: WHEN OTHERS THEN
711: l_code_block :='Shipping Attachment :' ;
712: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
713: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
714: x_msg_data := FND_MESSAGE.GET;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: END;
717:

Line 714: x_msg_data := FND_MESSAGE.GET;

710: WHEN OTHERS THEN
711: l_code_block :='Shipping Attachment :' ;
712: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
713: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
714: x_msg_data := FND_MESSAGE.GET;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: END;
717:
718:

Line 833: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');

829:
830: BEGIN
831:
832: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
833: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
834: l_bind_var_msds := FND_MESSAGE.GET;
835:
836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
837: l_bind_var_safety := FND_MESSAGE.GET;

Line 834: l_bind_var_msds := FND_MESSAGE.GET;

830: BEGIN
831:
832: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
833: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
834: l_bind_var_msds := FND_MESSAGE.GET;
835:
836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
837: l_bind_var_safety := FND_MESSAGE.GET;
838:

Line 836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');

832: /* Bug 4912043 Populating the bind variables with the message text instead of hardcoding the text in the Query */
833: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
834: l_bind_var_msds := FND_MESSAGE.GET;
835:
836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
837: l_bind_var_safety := FND_MESSAGE.GET;
838:
839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
840: l_bind_var_hazard := FND_MESSAGE.GET;

Line 837: l_bind_var_safety := FND_MESSAGE.GET;

833: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS');
834: l_bind_var_msds := FND_MESSAGE.GET;
835:
836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
837: l_bind_var_safety := FND_MESSAGE.GET;
838:
839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
840: l_bind_var_hazard := FND_MESSAGE.GET;
841:

Line 839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');

835:
836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
837: l_bind_var_safety := FND_MESSAGE.GET;
838:
839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
840: l_bind_var_hazard := FND_MESSAGE.GET;
841:
842: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
843: l_bind_var_msds_rejected := FND_MESSAGE.GET;

Line 840: l_bind_var_hazard := FND_MESSAGE.GET;

836: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_SAFETY');
837: l_bind_var_safety := FND_MESSAGE.GET;
838:
839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
840: l_bind_var_hazard := FND_MESSAGE.GET;
841:
842: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
843: l_bind_var_msds_rejected := FND_MESSAGE.GET;
844:

Line 842: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');

838:
839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
840: l_bind_var_hazard := FND_MESSAGE.GET;
841:
842: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
843: l_bind_var_msds_rejected := FND_MESSAGE.GET;
844:
845: l_user_id := NVL(FND_PROFILE.VALUE('USER_ID'),0);
846:

Line 843: l_bind_var_msds_rejected := FND_MESSAGE.GET;

839: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_HAZARD');
840: l_bind_var_hazard := FND_MESSAGE.GET;
841:
842: FND_MESSAGE.SET_NAME('GR','GR_BIND_VAR_MSDS_REJECTED');
843: l_bind_var_msds_rejected := FND_MESSAGE.GET;
844:
845: l_user_id := NVL(FND_PROFILE.VALUE('USER_ID'),0);
846:
847: open C_get_organization_code(p_orgn_id);

Line 885: FND_MESSAGE.SET_NAME('GR','GR_ITEM_LANG_CATEGORY');

881: END IF; /* If recipient is found */
882: END IF; /* Updating dispatch history */
883: WHILE c_get_doc_info %FOUND LOOP
884: /* Post the File Name printed to the file */
885: FND_MESSAGE.SET_NAME('GR','GR_ITEM_LANG_CATEGORY');
886: FND_MESSAGE.SET_TOKEN('ITEM', DocumentRec.doc_attribute1,FALSE);
887: FND_MESSAGE.SET_TOKEN('LANG', DocumentRec.doc_attribute3,FALSE);
888: FND_MESSAGE.SET_TOKEN('CATEGORY',DocumentRec.doc_attribute_category,FALSE);
889: l_msg_data := FND_MESSAGE.GET;

Line 886: FND_MESSAGE.SET_TOKEN('ITEM', DocumentRec.doc_attribute1,FALSE);

882: END IF; /* Updating dispatch history */
883: WHILE c_get_doc_info %FOUND LOOP
884: /* Post the File Name printed to the file */
885: FND_MESSAGE.SET_NAME('GR','GR_ITEM_LANG_CATEGORY');
886: FND_MESSAGE.SET_TOKEN('ITEM', DocumentRec.doc_attribute1,FALSE);
887: FND_MESSAGE.SET_TOKEN('LANG', DocumentRec.doc_attribute3,FALSE);
888: FND_MESSAGE.SET_TOKEN('CATEGORY',DocumentRec.doc_attribute_category,FALSE);
889: l_msg_data := FND_MESSAGE.GET;
890: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);

Line 887: FND_MESSAGE.SET_TOKEN('LANG', DocumentRec.doc_attribute3,FALSE);

883: WHILE c_get_doc_info %FOUND LOOP
884: /* Post the File Name printed to the file */
885: FND_MESSAGE.SET_NAME('GR','GR_ITEM_LANG_CATEGORY');
886: FND_MESSAGE.SET_TOKEN('ITEM', DocumentRec.doc_attribute1,FALSE);
887: FND_MESSAGE.SET_TOKEN('LANG', DocumentRec.doc_attribute3,FALSE);
888: FND_MESSAGE.SET_TOKEN('CATEGORY',DocumentRec.doc_attribute_category,FALSE);
889: l_msg_data := FND_MESSAGE.GET;
890: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
891: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 888: FND_MESSAGE.SET_TOKEN('CATEGORY',DocumentRec.doc_attribute_category,FALSE);

884: /* Post the File Name printed to the file */
885: FND_MESSAGE.SET_NAME('GR','GR_ITEM_LANG_CATEGORY');
886: FND_MESSAGE.SET_TOKEN('ITEM', DocumentRec.doc_attribute1,FALSE);
887: FND_MESSAGE.SET_TOKEN('LANG', DocumentRec.doc_attribute3,FALSE);
888: FND_MESSAGE.SET_TOKEN('CATEGORY',DocumentRec.doc_attribute_category,FALSE);
889: l_msg_data := FND_MESSAGE.GET;
890: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
891: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
892: /* Post the File Name printed to the file */

Line 889: l_msg_data := FND_MESSAGE.GET;

885: FND_MESSAGE.SET_NAME('GR','GR_ITEM_LANG_CATEGORY');
886: FND_MESSAGE.SET_TOKEN('ITEM', DocumentRec.doc_attribute1,FALSE);
887: FND_MESSAGE.SET_TOKEN('LANG', DocumentRec.doc_attribute3,FALSE);
888: FND_MESSAGE.SET_TOKEN('CATEGORY',DocumentRec.doc_attribute_category,FALSE);
889: l_msg_data := FND_MESSAGE.GET;
890: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
891: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
892: /* Post the File Name printed to the file */
893: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');

Line 893: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');

889: l_msg_data := FND_MESSAGE.GET;
890: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
891: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
892: /* Post the File Name printed to the file */
893: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');
894: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
895: l_msg_data := FND_MESSAGE.GET;
896: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
897: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 894: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);

890: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
891: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
892: /* Post the File Name printed to the file */
893: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');
894: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
895: l_msg_data := FND_MESSAGE.GET;
896: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
897: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
898: l_concurrent_id :=

Line 895: l_msg_data := FND_MESSAGE.GET;

891: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
892: /* Post the File Name printed to the file */
893: FND_MESSAGE.SET_NAME('GR','GR_FILE_NAME_TEXT');
894: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
895: l_msg_data := FND_MESSAGE.GET;
896: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
897: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
898: l_concurrent_id :=
899: FND_REQUEST.SUBMIT_REQUEST

Line 913: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_DOC');

909: '', '', '', '', '', '', '', '', '', '',
910: '', '', '', '', '', '', '', '', '', '',
911: '', '', '', '', '', '', '', '', '', '');
912: IF l_concurrent_id = 0 THEN
913: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_DOC');
914: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
915: l_msg_data := FND_MESSAGE.GET;
916: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
917: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 914: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);

910: '', '', '', '', '', '', '', '', '', '',
911: '', '', '', '', '', '', '', '', '', '');
912: IF l_concurrent_id = 0 THEN
913: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_DOC');
914: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
915: l_msg_data := FND_MESSAGE.GET;
916: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
917: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
918: ELSE

Line 915: l_msg_data := FND_MESSAGE.GET;

911: '', '', '', '', '', '', '', '', '', '');
912: IF l_concurrent_id = 0 THEN
913: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_PRINT_DOC');
914: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
915: l_msg_data := FND_MESSAGE.GET;
916: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
917: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
918: ELSE
919: IF p_update_dispatch_history = 'Y' THEN

Line 921: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');

917: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
918: ELSE
919: IF p_update_dispatch_history = 'Y' THEN
920:
921: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');
922: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
923: l_msg_data := FND_MESSAGE.GET;
924: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 922: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);

918: ELSE
919: IF p_update_dispatch_history = 'Y' THEN
920:
921: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');
922: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
923: l_msg_data := FND_MESSAGE.GET;
924: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
926: GR_DISPATCH_HISTORY_PUB.create_dispatch_history (

Line 923: l_msg_data := FND_MESSAGE.GET;

919: IF p_update_dispatch_history = 'Y' THEN
920:
921: FND_MESSAGE.SET_NAME('GR', 'GR_CREATING_DISPATCH_HISTORY');
922: FND_MESSAGE.SET_TOKEN('FILE_NAME', DocumentRec.file_name,FALSE);
923: l_msg_data := FND_MESSAGE.GET;
924: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
925: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
926: GR_DISPATCH_HISTORY_PUB.create_dispatch_history (
927: p_api_version => 1.0,

Line 955: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');

951: x_return_status => l_return_status,
952: x_msg_count => l_msg_count,
953: x_msg_data => l_error_msg );
954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
955: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');
956: FND_MESSAGE.SET_TOKEN('FILE_NAME',DocumentRec.File_name, FALSE);
957: l_msg_data := FND_MESSAGE.GET;
958: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
959: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 956: FND_MESSAGE.SET_TOKEN('FILE_NAME',DocumentRec.File_name, FALSE);

952: x_msg_count => l_msg_count,
953: x_msg_data => l_error_msg );
954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
955: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');
956: FND_MESSAGE.SET_TOKEN('FILE_NAME',DocumentRec.File_name, FALSE);
957: l_msg_data := FND_MESSAGE.GET;
958: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
959: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
960: FND_FILE.PUT(FND_FILE.LOG, l_error_msg);

Line 957: l_msg_data := FND_MESSAGE.GET;

953: x_msg_data => l_error_msg );
954: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
955: FND_MESSAGE.SET_NAME('GR', 'GR_DISPATCH_HISTORY_FAILED');
956: FND_MESSAGE.SET_TOKEN('FILE_NAME',DocumentRec.File_name, FALSE);
957: l_msg_data := FND_MESSAGE.GET;
958: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
959: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
960: FND_FILE.PUT(FND_FILE.LOG, l_error_msg);
961: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 977: FND_MESSAGE.SET_NAME('GR','GR_NO_DOCUMENT_TO_PRINT');

973:
974:
975: EXCEPTION
976: WHEN No_Document_To_Print THEN
977: FND_MESSAGE.SET_NAME('GR','GR_NO_DOCUMENT_TO_PRINT');
978: l_msg_data := FND_MESSAGE.GET;
979: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
980: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
981:

Line 978: l_msg_data := FND_MESSAGE.GET;

974:
975: EXCEPTION
976: WHEN No_Document_To_Print THEN
977: FND_MESSAGE.SET_NAME('GR','GR_NO_DOCUMENT_TO_PRINT');
978: l_msg_data := FND_MESSAGE.GET;
979: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
980: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
981:
982: WHEN No_Recipient_Exists THEN

Line 983: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE_NUM');

979: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
980: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
981:
982: WHEN No_Recipient_Exists THEN
983: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE_NUM');
984: FND_MESSAGE.SET_TOKEN('SITE_NUM', P_Recipient_site , FALSE);
985: l_msg_data := FND_MESSAGE.GET;
986: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
987: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 984: FND_MESSAGE.SET_TOKEN('SITE_NUM', P_Recipient_site , FALSE);

980: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
981:
982: WHEN No_Recipient_Exists THEN
983: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE_NUM');
984: FND_MESSAGE.SET_TOKEN('SITE_NUM', P_Recipient_site , FALSE);
985: l_msg_data := FND_MESSAGE.GET;
986: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
987: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
988:

Line 985: l_msg_data := FND_MESSAGE.GET;

981:
982: WHEN No_Recipient_Exists THEN
983: FND_MESSAGE.SET_NAME('GR','GR_INVALID_RECIPIENT_SITE_NUM');
984: FND_MESSAGE.SET_TOKEN('SITE_NUM', P_Recipient_site , FALSE);
985: l_msg_data := FND_MESSAGE.GET;
986: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
987: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
988:
989: WHEN OTHERS THEN

Line 991: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');

987: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
988:
989: WHEN OTHERS THEN
990: l_code_block :='Print Regulatory Doc ' ;
991: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
992: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
993: l_msg_data := FND_MESSAGE.GET;
994: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
995: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

Line 992: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);

988:
989: WHEN OTHERS THEN
990: l_code_block :='Print Regulatory Doc ' ;
991: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
992: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
993: l_msg_data := FND_MESSAGE.GET;
994: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
995: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
996:

Line 993: l_msg_data := FND_MESSAGE.GET;

989: WHEN OTHERS THEN
990: l_code_block :='Print Regulatory Doc ' ;
991: FND_MESSAGE.SET_NAME('GR','GR_UNEXPECTED_ERROR');
992: FND_MESSAGE.SET_TOKEN('TEXT',l_code_block||sqlerrm, FALSE);
993: l_msg_data := FND_MESSAGE.GET;
994: FND_FILE.PUT(FND_FILE.LOG, l_msg_data);
995: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
996:
997: