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.GR_DISPATCH_HISTORY_PVT dependencies on FND_MSG_PUB

Line 7: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the

3:
4: PROCEDURE log_msg(p_msg_text IN VARCHAR2);
5:
6: /* Global variables */
7: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
8: -- msg level threshhold gobal
9: -- variable.
10: G_debug_level NUMBER := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
11: -- to decide to log a debug msg.

Line 10: G_debug_level NUMBER := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere

6: /* Global variables */
7: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
8: -- msg level threshhold gobal
9: -- variable.
10: G_debug_level NUMBER := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
11: -- to decide to log a debug msg.
12: G_PKG_NAME CONSTANT varchar2(30) := 'GR_DISPATCH_HISTORY_PVT';
13:
14: g_log_head CONSTANT VARCHAR2(50) := 'gr.plsql.'|| G_PKG_NAME || '.';

Line 251: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

247:
248: -- Validate organization
249: l_temp := INV_VALIDATE.organization(l_org);
250: IF (l_temp = INV_VALIDATE.F) THEN
251: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
252: log_msg('Organization id provided - organization validation failed.');
253: END IF;
254: RAISE INVALID_VALUE;
255: END IF; -- If organization id is valid

Line 263: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

259: --Validate the item
260:
261: -- M. Grosser 23-May-2005 Modified code for Inventory Convergence.
262: IF NOT (GR_VALIDATE.validate_item(p_organization_id, p_item, l_inventory_item_id)) THEN
263: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
264: log_msg('Item provided - item validation failed.');
265: END IF;
266: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM');
267: FND_MESSAGE.SET_TOKEN('ITEM',p_item);

Line 268: FND_MSG_PUB.Add;

264: log_msg('Item provided - item validation failed.');
265: END IF;
266: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM');
267: FND_MESSAGE.SET_TOKEN('ITEM',p_item);
268: FND_MSG_PUB.Add;
269: RAISE INVALID_VALUE;
270: END IF;
271:
272: l_item := p_item;

Line 278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

274: ELSE
275: --Validate the CAS #, return item
276: -- M. Grosser 23-May-2005 Modified code for Inventory Convergence.
277: IF NOT (GR_VALIDATE.validate_cas_number(p_organization_id, p_cas_number, l_item, l_inventory_item_id)) THEN
278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
279: log_msg('CAS Number provided - CAS Number validation failed.');
280: END IF;
281: FND_MESSAGE.SET_NAME('GR','GR_INVALID_CAS_NUMBER');
282: FND_MESSAGE.SET_TOKEN('CAS_NUMBER',p_cas_number);

Line 283: FND_MSG_PUB.Add;

279: log_msg('CAS Number provided - CAS Number validation failed.');
280: END IF;
281: FND_MESSAGE.SET_NAME('GR','GR_INVALID_CAS_NUMBER');
282: FND_MESSAGE.SET_TOKEN('CAS_NUMBER',p_cas_number);
283: FND_MSG_PUB.Add;
284: RAISE INVALID_VALUE;
285: END IF;
286:
287: END IF;

Line 295: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

291: -- Make sure that inventory item matches item if it is not NULL
292: IF ( (p_inventory_item_id is NOT NULL) AND
293: (p_inventory_item_id <> -1) AND
294: (p_inventory_item_id <> l_inventory_item_id)) THEN
295: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
296: log_msg('Inventory Item ID provided - No match to item provided.');
297: END IF;
298: FND_MESSAGE.SET_NAME('GR','GR_NO_ITEM_ID_MATCH');
299: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);

Line 301: FND_MSG_PUB.Add;

297: END IF;
298: FND_MESSAGE.SET_NAME('GR','GR_NO_ITEM_ID_MATCH');
299: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
300: FND_MESSAGE.SET_TOKEN('ITEM',l_item);
301: FND_MSG_PUB.Add;
302: RAISE INVALID_VALUE;
303:
304: END IF; -- ID matches item
305: -- M. Grosser 23-May-2005 End of changes

Line 316: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

312:
313: --If document id not found
314: IF c_val_document_id%NOTFOUND THEN
315: CLOSE c_val_document_id;
316: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
317: log_msg('Document ID provided - Document ID validation failed.');
318: END IF;
319: RAISE INVALID_DOCUMENT_ID;
320: END IF;

Line 362: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

358:
359: --If document category not found
360: IF c_val_document_category%NOTFOUND THEN
361: CLOSE c_val_document_category;
362: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
363: log_msg('Document Category provided - Document Category validation failed.');
364: END IF;
365: RAISE INVALID_DOCUMENT_CATEGORY;
366: END IF;

Line 372: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

368: CLOSE c_val_document_category;
369:
370: --Validate the dispatch_method
371: IF NOT(GR_VALIDATE.validate_dispatch_method_code(p_dispatch_method_code)) THEN
372: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
373: log_msg('Dispatch Method provided - Dispatch Method validation failed.');
374: END IF;
375: RAISE INVALID_DISPATCH_METHOD_CODE;
376: END IF;

Line 381: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

377:
378:
379: --Validate the disclosure code
380: IF NOT(GR_VALIDATE.validate_disclosure_code(p_disclosure_code)) THEN
381: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
382: log_msg('Disclosure Code provided - Disclosure Code validation failed.');
383: END IF;
384: RAISE INVALID_DISCLOSURE_CODE;
385: END IF;

Line 395: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

391:
392: --If document language is not found
393: IF c_val_language %NOTFOUND THEN
394: CLOSE c_val_language;
395: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
396: log_msg('Document Language provided - Document Language validation failed.');
397: END IF;
398: RAISE INVALID_DOCUMENT_LANGUAGE;
399: END IF;

Line 427: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

423: '', '', '', '', '', '', '', '', '', '',
424: '', '', '', '', '', '', '', '', '', '');
425: IF l_concurrent_id = 0 THEN
426: /* Java concurrent program failed, to print the attached document to an output file */
427: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
428: log_msg('Document upload to temp table failed.');
429: END IF;
430: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
431: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);

Line 432: FND_MSG_PUB.Add;

428: log_msg('Document upload to temp table failed.');
429: END IF;
430: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
431: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);
432: FND_MSG_PUB.Add;
433: RAISE FILE_ERROR;
434: ELSE
435: COMMIT;
436: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 436: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

432: FND_MSG_PUB.Add;
433: RAISE FILE_ERROR;
434: ELSE
435: COMMIT;
436: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
437: log_msg('Document upload concurrent program fired - concurrent_id:'||to_char(l_concurrent_id));
438: END IF;
439: l_ret_status := FND_CONCURRENT.WAIT_FOR_REQUEST(l_concurrent_id,
440: l_interval,

Line 456: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

452: --Get the handle to the File
453: OPEN c_get_file_data;
454: FETCH c_get_file_data INTO l_file_data;
455: IF c_get_file_data%NOTFOUND THEN
456: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
457: log_msg('Document cannot be read from temp table.');
458: END IF;
459: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
460: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);

Line 461: FND_MSG_PUB.Add;

457: log_msg('Document cannot be read from temp table.');
458: END IF;
459: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
460: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);
461: FND_MSG_PUB.Add;
462: RAISE FILE_ERROR;
463: END IF;
464: CLOSE c_get_file_data;
465:

Line 519: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

515: X_MSG_DATA => x_msg_data);
516:
517: IF (x_return_status = FND_API.G_RET_STS_ERROR)
518: THEN
519: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
520: log_msg('EDR Upload failed with expected error.');
521: END IF;
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

Line 525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

521: END IF;
522: RAISE FND_API.G_EXC_ERROR;
523: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
524: THEN
525: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
526: log_msg('EDR Upload failed with unexpected error.');
527: END IF;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;

Line 543: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

539:
540: --If it's not in the system, error out.
541: IF c_get_doc_id%NOTFOUND THEN
542: CLOSE c_get_doc_id;
543: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
544: log_msg('EDR Upload successful but doc id could not be fetched.');
545: END IF;
546: RAISE FILE_ERROR;
547: END IF;

Line 555: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

551: END IF; /*p_document_id is NOT NULL */
552:
553: --Check the date sent
554: IF p_date_sent IS NULL OR p_date_sent > SYSDATE THEN
555: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
556: log_msg('Date Sent provided : Date Sent validation failed.');
557: END IF;
558: RAISE INVALID_DATE_SENT;
559: END IF;

Line 563: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

559: END IF;
560:
561: --Check the creation source
562: IF p_creation_source NOT IN (0,1,2) THEN
563: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
564: log_msg('Creation Source provided : Creation Source validation failed.');
565: END IF;
566: RAISE INVALID_CREATION_SOURCE;
567: END IF;

Line 571: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

567: END IF;
568:
569: --Validate the recipient_id
570: IF NOT (GR_VALIDATE.validate_recipient_id(p_recipient_id)) THEN
571: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
572: log_msg('Recipient ID provided - Recipient ID validation failed.');
573: END IF;
574: RAISE INVALID_RECIPIENT_ID;
575: END IF;

Line 579: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

575: END IF;
576:
577: --Validate the recipient_site_id
578: IF NOT (GR_VALIDATE.validate_recipient_site_id(p_recipient_id,p_recipient_site_id)) THEN
579: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
580: log_msg('Recipient Site ID provided - Recipient Site ID validation failed.');
581: END IF;
582: RAISE INVALID_RECIPIENT_SITE_ID;
583: END IF;

Line 587: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

583: END IF;
584:
585: --Validate the dispatch_method
586: IF NOT (GR_VALIDATE.validate_dispatch_method_code(p_dispatch_method_code)) THEN
587: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
588: log_msg('Dispatch Method provided - Dispatch Method validation failed.');
589: END IF;
590: RAISE INVALID_DISPATCH_METHOD_CODE;
591: END IF;

Line 600: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

596:
597: --If user id not found
598: IF c_val_user_id%NOTFOUND THEN
599: CLOSE c_val_user_id;
600: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
601: log_msg('User ID provided - User ID validation failed.');
602: END IF;
603: RAISE INVALID_USER_ID;
604: END IF;

Line 715: FND_MSG_PUB.Count_And_Get (

711: EXCEPTION
712:
713: WHEN INVALID_VALUE THEN
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MSG_PUB.Count_And_Get (
716: p_count => x_msg_count,
717: p_data => x_msg_data );
718:
719: WHEN INVALID_USER_ID THEN

Line 722: FND_MSG_PUB.Add;

718:
719: WHEN INVALID_USER_ID THEN
720: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_USER_ID');
721: FND_MESSAGE.SET_TOKEN('USER_ID', p_user_id);
722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => x_msg_count,
726: p_data => x_msg_data );

Line 724: FND_MSG_PUB.Count_And_Get (

720: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_USER_ID');
721: FND_MESSAGE.SET_TOKEN('USER_ID', p_user_id);
722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => x_msg_count,
726: p_data => x_msg_data );
727:
728: WHEN INVALID_DOCUMENT_ID THEN

Line 731: FND_MSG_PUB.Add;

727:
728: WHEN INVALID_DOCUMENT_ID THEN
729: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_ID');
730: FND_MESSAGE.SET_TOKEN('DOCUMENT_ID', p_document_id);
731: FND_MSG_PUB.Add;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get (
734: p_count => x_msg_count,
735: p_data => x_msg_data );

Line 733: FND_MSG_PUB.Count_And_Get (

729: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_ID');
730: FND_MESSAGE.SET_TOKEN('DOCUMENT_ID', p_document_id);
731: FND_MSG_PUB.Add;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get (
734: p_count => x_msg_count,
735: p_data => x_msg_data );
736:
737: WHEN INVALID_DOCUMENT_CATEGORY THEN

Line 740: FND_MSG_PUB.Add;

736:
737: WHEN INVALID_DOCUMENT_CATEGORY THEN
738: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CATEGORY');
739: FND_MESSAGE.SET_TOKEN('DOC_CATEGORY', p_document_category);
740: FND_MSG_PUB.Add;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MSG_PUB.Count_And_Get (
743: p_count => x_msg_count,
744: p_data => x_msg_data );

Line 742: FND_MSG_PUB.Count_And_Get (

738: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CATEGORY');
739: FND_MESSAGE.SET_TOKEN('DOC_CATEGORY', p_document_category);
740: FND_MSG_PUB.Add;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MSG_PUB.Count_And_Get (
743: p_count => x_msg_count,
744: p_data => x_msg_data );
745:
746: WHEN INVALID_DISPATCH_METHOD_CODE THEN

Line 749: FND_MSG_PUB.Add;

745:
746: WHEN INVALID_DISPATCH_METHOD_CODE THEN
747: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
748: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
749: FND_MSG_PUB.Add;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get (
752: p_count => x_msg_count,
753: p_data => x_msg_data );

Line 751: FND_MSG_PUB.Count_And_Get (

747: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
748: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
749: FND_MSG_PUB.Add;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get (
752: p_count => x_msg_count,
753: p_data => x_msg_data );
754:
755: WHEN INVALID_DISCLOSURE_CODE THEN

Line 758: FND_MSG_PUB.Add;

754:
755: WHEN INVALID_DISCLOSURE_CODE THEN
756: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
757: FND_MESSAGE.SET_TOKEN('CODE', p_disclosure_code);
758: FND_MSG_PUB.Add;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MSG_PUB.Count_And_Get (
761: p_count => x_msg_count,
762: p_data => x_msg_data );

Line 760: FND_MSG_PUB.Count_And_Get (

756: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
757: FND_MESSAGE.SET_TOKEN('CODE', p_disclosure_code);
758: FND_MSG_PUB.Add;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MSG_PUB.Count_And_Get (
761: p_count => x_msg_count,
762: p_data => x_msg_data );
763:
764: WHEN INVALID_DOCUMENT_LANGUAGE THEN

Line 767: FND_MSG_PUB.Add;

763:
764: WHEN INVALID_DOCUMENT_LANGUAGE THEN
765: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_LANGUAGE');
766: FND_MESSAGE.SET_TOKEN('LANGUAGE', p_language);
767: FND_MSG_PUB.Add;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get (
770: p_count => x_msg_count,
771: p_data => x_msg_data );

Line 769: FND_MSG_PUB.Count_And_Get (

765: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_LANGUAGE');
766: FND_MESSAGE.SET_TOKEN('LANGUAGE', p_language);
767: FND_MSG_PUB.Add;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get (
770: p_count => x_msg_count,
771: p_data => x_msg_data );
772:
773: WHEN INVALID_DOCUMENT_VERSION THEN

Line 775: FND_MSG_PUB.Add;

771: p_data => x_msg_data );
772:
773: WHEN INVALID_DOCUMENT_VERSION THEN
774: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOC_VERSION');
775: FND_MSG_PUB.Add;
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get (
778: p_count => x_msg_count,
779: p_data => x_msg_data );

Line 777: FND_MSG_PUB.Count_And_Get (

773: WHEN INVALID_DOCUMENT_VERSION THEN
774: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOC_VERSION');
775: FND_MSG_PUB.Add;
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get (
778: p_count => x_msg_count,
779: p_data => x_msg_data );
780:
781: WHEN INVALID_DATE_SENT THEN

Line 784: FND_MSG_PUB.Add;

780:
781: WHEN INVALID_DATE_SENT THEN
782: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DATE_SENT');
783: FND_MESSAGE.SET_TOKEN('DATE_SENT', p_date_sent);
784: FND_MSG_PUB.Add;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.Count_And_Get (
787: p_count => x_msg_count,
788: p_data => x_msg_data );

Line 786: FND_MSG_PUB.Count_And_Get (

782: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DATE_SENT');
783: FND_MESSAGE.SET_TOKEN('DATE_SENT', p_date_sent);
784: FND_MSG_PUB.Add;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.Count_And_Get (
787: p_count => x_msg_count,
788: p_data => x_msg_data );
789:
790: WHEN INVALID_CREATION_SOURCE THEN

Line 793: FND_MSG_PUB.Add;

789:
790: WHEN INVALID_CREATION_SOURCE THEN
791: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CREATION_SOURCE');
792: FND_MESSAGE.SET_TOKEN('CREATION_SOURCE', p_creation_source);
793: FND_MSG_PUB.Add;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get (
796: p_count => x_msg_count,
797: p_data => x_msg_data );

Line 795: FND_MSG_PUB.Count_And_Get (

791: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CREATION_SOURCE');
792: FND_MESSAGE.SET_TOKEN('CREATION_SOURCE', p_creation_source);
793: FND_MSG_PUB.Add;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get (
796: p_count => x_msg_count,
797: p_data => x_msg_data );
798:
799: WHEN INVALID_RECIPIENT_ID THEN

Line 802: FND_MSG_PUB.Add;

798:
799: WHEN INVALID_RECIPIENT_ID THEN
800: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_ID');
801: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
802: FND_MSG_PUB.Add;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get (
805: p_count => x_msg_count,
806: p_data => x_msg_data );

Line 804: FND_MSG_PUB.Count_And_Get (

800: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_ID');
801: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
802: FND_MSG_PUB.Add;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get (
805: p_count => x_msg_count,
806: p_data => x_msg_data );
807:
808: WHEN INVALID_RECIPIENT_SITE_ID THEN

Line 811: FND_MSG_PUB.Add;

807:
808: WHEN INVALID_RECIPIENT_SITE_ID THEN
809: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE_ID');
810: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
811: FND_MSG_PUB.Add;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: FND_MSG_PUB.Count_And_Get (
814: p_count => x_msg_count,
815: p_data => x_msg_data );

Line 813: FND_MSG_PUB.Count_And_Get (

809: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE_ID');
810: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
811: FND_MSG_PUB.Add;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: FND_MSG_PUB.Count_And_Get (
814: p_count => x_msg_count,
815: p_data => x_msg_data );
816: WHEN FILE_ERROR THEN
817: FND_MESSAGE.SET_NAME('GR', 'GR_FILE_ERROR');

Line 819: FND_MSG_PUB.Add;

815: p_data => x_msg_data );
816: WHEN FILE_ERROR THEN
817: FND_MESSAGE.SET_NAME('GR', 'GR_FILE_ERROR');
818: FND_MESSAGE.SET_TOKEN('FILE', p_document_location||'/'||p_document_name);
819: FND_MSG_PUB.Add;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data );

Line 821: FND_MSG_PUB.Count_And_Get (

817: FND_MESSAGE.SET_NAME('GR', 'GR_FILE_ERROR');
818: FND_MESSAGE.SET_TOKEN('FILE', p_document_location||'/'||p_document_name);
819: FND_MSG_PUB.Add;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data );
824:
825: WHEN FND_API.G_EXC_ERROR THEN

Line 827: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,

823: p_data => x_msg_data );
824:
825: WHEN FND_API.G_EXC_ERROR THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
828: p_data => x_msg_data);
829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 832: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,

828: p_data => x_msg_data);
829:
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
833: p_data => x_msg_data);
834:
835: WHEN OTHERS THEN
836: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name, SQLERRM);

Line 836: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name, SQLERRM);

832: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count,
833: p_data => x_msg_data);
834:
835: WHEN OTHERS THEN
836: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name, SQLERRM);
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
839: p_data => x_msg_data );
840:

Line 838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

834:
835: WHEN OTHERS THEN
836: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name, SQLERRM);
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
839: p_data => x_msg_data );
840:
841: END CREATE_DISPATCH_HISTORY_REC;
842:

Line 914: FND_MSG_PUB.Add;

910: BEGIN
911:
912: FND_MESSAGE.SET_NAME('GR','GR_DEBUG_API');
913: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
914: FND_MSG_PUB.Add;
915:
916: END log_msg ;
917:
918: