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.WSH_DOCUMENT_PVT dependencies on FND_API

Line 292: RAISE FND_API.G_EXC_ERROR;

288: THEN
289: CLOSE delivery_leg_csr;
290: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
291: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: CLOSE delivery_leg_csr;
295: --
296: -- Debug Statements

Line 348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

344: -----------------------------------------------------------------------------
345:
346: FUNCTION Get_Sequence_Type
347: ( p_api_version IN NUMBER
348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
349: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
350: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
351: , x_return_status OUT NOCOPY VARCHAR2
352: , x_msg_count OUT NOCOPY NUMBER

Line 349: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

345:
346: FUNCTION Get_Sequence_Type
347: ( p_api_version IN NUMBER
348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
349: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
350: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
351: , x_return_status OUT NOCOPY VARCHAR2
352: , x_msg_count OUT NOCOPY NUMBER
353: , x_msg_data OUT NOCOPY VARCHAR2

Line 350: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

346: FUNCTION Get_Sequence_Type
347: ( p_api_version IN NUMBER
348: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
349: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
350: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
351: , x_return_status OUT NOCOPY VARCHAR2
352: , x_msg_count OUT NOCOPY NUMBER
353: , x_msg_data OUT NOCOPY VARCHAR2
354: , p_application_id IN NUMBER

Line 432: IF NOT FND_API.Compatible_API_Call ( l_api_version,

428: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_CODE',P_DOCUMENT_CODE);
429: WSH_DEBUG_SV.log(l_module_name,'P_LOCATION_ID',P_LOCATION_ID);
430: END IF;
431: --
432: IF NOT FND_API.Compatible_API_Call ( l_api_version,
433: p_api_version,
434: l_api_name,
435: g_pkg_name ) THEN
436: RAISE FND_API.g_exc_unexpected_error;

Line 436: RAISE FND_API.g_exc_unexpected_error;

432: IF NOT FND_API.Compatible_API_Call ( l_api_version,
433: p_api_version,
434: l_api_name,
435: g_pkg_name ) THEN
436: RAISE FND_API.g_exc_unexpected_error;
437: END IF;
438:
439: -- initialize message list if p_init_msg_list is set to TRUE.
440:

Line 441: IF FND_API.to_boolean( p_init_msg_list ) THEN

437: END IF;
438:
439: -- initialize message list if p_init_msg_list is set to TRUE.
440:
441: IF FND_API.to_boolean( p_init_msg_list ) THEN
442: FND_MSG_PUB.initialize;
443: END IF;
444:
445: -- initialize API return status to success

Line 455: RAISE FND_API.G_EXC_ERROR;

451: THEN
452: CLOSE type_csr;
453: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');
454: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457: -- call FND API to get the sequence type information
458: l_seq_return := FND_SEQNUM.get_seq_info
459: ( app_id => p_application_id

Line 457: -- call FND API to get the sequence type information

453: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');
454: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457: -- call FND API to get the sequence type information
458: l_seq_return := FND_SEQNUM.get_seq_info
459: ( app_id => p_application_id
460: , cat_code => type_rec.category_code
461: , sob_id => p_ledger_id -- LE Uptake

Line 486: WHEN FND_API.g_exc_error THEN

482: --
483: RETURN l_type;
484: EXCEPTION
485:
486: WHEN FND_API.g_exc_error THEN
487: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
488: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
489: p_data => x_msg_data );
490: --

Line 494: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

490: --
491: -- Debug Statements
492: --
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
496: END IF;
497: --
498: RETURN null;

Line 495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

491: -- Debug Statements
492: --
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
495: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
496: END IF;
497: --
498: RETURN null;
499:

Line 500: WHEN FND_API.g_exc_unexpected_error THEN

496: END IF;
497: --
498: RETURN null;
499:
500: WHEN FND_API.g_exc_unexpected_error THEN
501: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
502: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
503: p_data => x_msg_data );
504: --

Line 508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

504: --
505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: RETURN null;

Line 509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

505: -- Debug Statements
506: --
507: IF l_debug_on THEN
508: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
510: END IF;
511: --
512: RETURN null;
513:

Line 569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

565: ------------------------------------------------------------------------------
566:
567: FUNCTION Is_Final
568: ( p_api_version IN NUMBER
569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
572: , x_return_status OUT NOCOPY VARCHAR2
573: , x_msg_count OUT NOCOPY NUMBER

Line 570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

566:
567: FUNCTION Is_Final
568: ( p_api_version IN NUMBER
569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
572: , x_return_status OUT NOCOPY VARCHAR2
573: , x_msg_count OUT NOCOPY NUMBER
574: , x_msg_data OUT NOCOPY VARCHAR2

Line 571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

567: FUNCTION Is_Final
568: ( p_api_version IN NUMBER
569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
572: , x_return_status OUT NOCOPY VARCHAR2
573: , x_msg_count OUT NOCOPY NUMBER
574: , x_msg_data OUT NOCOPY VARCHAR2
575: , p_delivery_id IN NUMBER

Line 617: IF NOT FND_API.Compatible_API_Call ( l_api_version,

613: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
614: WSH_DEBUG_SV.log(l_module_name,'P_DOCUMENT_TYPE',P_DOCUMENT_TYPE);
615: END IF;
616: --
617: IF NOT FND_API.Compatible_API_Call ( l_api_version,
618: p_api_version,
619: l_api_name,
620: g_pkg_name ) THEN
621: RAISE FND_API.g_exc_unexpected_error;

Line 621: RAISE FND_API.g_exc_unexpected_error;

617: IF NOT FND_API.Compatible_API_Call ( l_api_version,
618: p_api_version,
619: l_api_name,
620: g_pkg_name ) THEN
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
623:
624: -- initialize message list if p_init_msg_list is set to TRUE.
625: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 625: IF FND_API.to_boolean( p_init_msg_list ) THEN

621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
623:
624: -- initialize message list if p_init_msg_list is set to TRUE.
625: IF FND_API.to_boolean( p_init_msg_list ) THEN
626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: -- initialize API return status to success

Line 633: l_isfinal := FND_API.G_false;

629: -- initialize API return status to success
630: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
631:
632: -- initially l_isfinal=FALSE, means no document is not final
633: l_isfinal := FND_API.G_false;
634:
635: -- if p_consolidate_option is CONSOLIDATE or BOTH, we need to check
636: -- the parent delivery first
637: SELECT doc.final_print_date

Line 645: l_isfinal := FND_API.g_true;

641: AND doc.entity_name='WSH_NEW_DELIVERIES'
642: AND doc.document_type=p_document_type;
643: IF l_temp_date IS NOT NULL
644: THEN
645: l_isfinal := FND_API.g_true;
646: END IF;
647: --
648: -- Debug Statements
649: --

Line 659: WHEN FND_API.g_exc_error THEN

655: RETURN l_isfinal;
656:
657: EXCEPTION
658:
659: WHEN FND_API.g_exc_error THEN
660: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
661: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
662: p_data => x_msg_data );
663: --

Line 667: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

663: --
664: -- Debug Statements
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
668: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
669: END IF;
670: --
671: RETURN null;

Line 668: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

664: -- Debug Statements
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
668: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
669: END IF;
670: --
671: RETURN null;
672:

Line 673: WHEN FND_API.g_exc_unexpected_error THEN

669: END IF;
670: --
671: RETURN null;
672:
673: WHEN FND_API.g_exc_unexpected_error THEN
674: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
675: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
676: p_data => x_msg_data );
677: --

Line 681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

677: --
678: -- Debug Statements
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
683: END IF;
684: --
685: RETURN null;

Line 682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

678: -- Debug Statements
679: --
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
682: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
683: END IF;
684: --
685: RETURN null;
686:

Line 742: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

738: ------------------------------------------------------------------------------
739:
740: PROCEDURE Set_Final_Print_Date
741: ( p_api_version IN NUMBER
742: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
743: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
744: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
745: , x_return_status OUT NOCOPY VARCHAR2
746: , x_msg_count OUT NOCOPY NUMBER

Line 743: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

739:
740: PROCEDURE Set_Final_Print_Date
741: ( p_api_version IN NUMBER
742: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
743: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
744: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
745: , x_return_status OUT NOCOPY VARCHAR2
746: , x_msg_count OUT NOCOPY NUMBER
747: , x_msg_data OUT NOCOPY VARCHAR2

Line 744: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

740: PROCEDURE Set_Final_Print_Date
741: ( p_api_version IN NUMBER
742: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
743: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
744: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
745: , x_return_status OUT NOCOPY VARCHAR2
746: , x_msg_count OUT NOCOPY NUMBER
747: , x_msg_data OUT NOCOPY VARCHAR2
748: , p_delivery_id IN NUMBER

Line 792: IF NOT FND_API.Compatible_API_Call ( l_api_version,

788: --
789: SAVEPOINT WSH_Document_PVT;
790:
791: -- standard call to check for call compatibility.
792: IF NOT FND_API.Compatible_API_Call ( l_api_version,
793: p_api_version,
794: l_api_name,
795: g_pkg_name ) THEN
796: RAISE FND_API.g_exc_unexpected_error;

Line 796: RAISE FND_API.g_exc_unexpected_error;

792: IF NOT FND_API.Compatible_API_Call ( l_api_version,
793: p_api_version,
794: l_api_name,
795: g_pkg_name ) THEN
796: RAISE FND_API.g_exc_unexpected_error;
797: END IF;
798:
799: -- initialize message list if p_init_msg_list is set to TRUE.
800: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 800: IF FND_API.to_boolean( p_init_msg_list ) THEN

796: RAISE FND_API.g_exc_unexpected_error;
797: END IF;
798:
799: -- initialize message list if p_init_msg_list is set to TRUE.
800: IF FND_API.to_boolean( p_init_msg_list ) THEN
801: FND_MSG_PUB.initialize;
802: END IF;
803:
804: -- initialize API return status to success

Line 823: IF FND_API.to_boolean( p_commit ) THEN

819: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
820: p_data => x_msg_data);
821:
822: -- Standard check of p_commit.
823: IF FND_API.to_boolean( p_commit ) THEN
824: COMMIT WORK;
825: END IF;
826:
827: --

Line 836: WHEN FND_API.g_exc_error THEN

832: END IF;
833: --
834: EXCEPTION
835:
836: WHEN FND_API.g_exc_error THEN
837:
838: ROLLBACK to WSH_Document_PVT;
839: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
840: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

Line 847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

843: --
844: -- Debug Statements
845: --
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
849: END IF;
850: --
851: WHEN FND_API.g_exc_unexpected_error THEN

Line 848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

844: -- Debug Statements
845: --
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
849: END IF;
850: --
851: WHEN FND_API.g_exc_unexpected_error THEN
852:

Line 851: WHEN FND_API.g_exc_unexpected_error THEN

847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
849: END IF;
850: --
851: WHEN FND_API.g_exc_unexpected_error THEN
852:
853: ROLLBACK to WSH_Document_PVT;
854: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
855: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,

Line 861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

857: --
858: -- Debug Statements
859: --
860: IF l_debug_on THEN
861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
863: END IF;
864: --
865: WHEN others THEN

Line 862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

858: -- Debug Statements
859: --
860: IF l_debug_on THEN
861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
863: END IF;
864: --
865: WHEN others THEN
866:

Line 972: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

968: -----------------------------------------------------------------------------
969:
970: PROCEDURE Create_Document
971: ( p_api_version IN NUMBER
972: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
973: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
974: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
975: , x_return_status OUT NOCOPY VARCHAR2
976: , x_msg_count OUT NOCOPY NUMBER

Line 973: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

969:
970: PROCEDURE Create_Document
971: ( p_api_version IN NUMBER
972: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
973: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
974: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
975: , x_return_status OUT NOCOPY VARCHAR2
976: , x_msg_count OUT NOCOPY NUMBER
977: , x_msg_data OUT NOCOPY VARCHAR2

Line 974: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

970: PROCEDURE Create_Document
971: ( p_api_version IN NUMBER
972: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
973: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
974: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
975: , x_return_status OUT NOCOPY VARCHAR2
976: , x_msg_count OUT NOCOPY NUMBER
977: , x_msg_data OUT NOCOPY VARCHAR2
978: , p_entity_name IN VARCHAR2 DEFAULT NULL

Line 1152: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1148: --
1149: SAVEPOINT WSH_Document_PVT;
1150:
1151: -- standard call to check for call compatibility.
1152: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1153: p_api_version,
1154: l_api_name,
1155: g_pkg_name ) THEN
1156: RAISE FND_API.g_exc_unexpected_error;

Line 1156: RAISE FND_API.g_exc_unexpected_error;

1152: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1153: p_api_version,
1154: l_api_name,
1155: g_pkg_name ) THEN
1156: RAISE FND_API.g_exc_unexpected_error;
1157: END IF;
1158:
1159: -- initialize message list if p_init_msg_list is set to TRUE.
1160:

Line 1161: IF FND_API.to_boolean( p_init_msg_list ) THEN

1157: END IF;
1158:
1159: -- initialize message list if p_init_msg_list is set to TRUE.
1160:
1161: IF FND_API.to_boolean( p_init_msg_list ) THEN
1162: FND_MSG_PUB.initialize;
1163: END IF;
1164:
1165: -- initialize API return status to success

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: THEN
1171: CLOSE category_csr;
1172: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_CATEGORY_MISSING');
1173: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176: l_doc_sequence_category_id := category_rec.doc_sequence_category_id;
1177: CLOSE category_csr;
1178:

Line 1189: RAISE FND_API.G_EXC_ERROR;

1185: IF assignment_csr%NOTFOUND THEN
1186: CLOSE assignment_csr;
1187: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_ASSIGNMENT_MISSING');
1188: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1189: RAISE FND_API.G_EXC_ERROR;
1190: END IF;
1191: l_doc_sequence_id := assignment_rec.doc_sequence_id;
1192: CLOSE assignment_csr;
1193:

Line 1234: RAISE FND_API.G_EXC_ERROR;

1230: THEN
1231: CLOSE delivery_csr;
1232: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
1233: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1234: RAISE FND_API.G_EXC_ERROR;
1235: END IF;
1236: CLOSE delivery_csr;
1237:
1238: ---------------------------------------------------------------

Line 1257: RAISE FND_API.G_EXC_ERROR;

1253:
1254: IF NOT l_delivery_id_tab.EXISTS(1) THEN
1255: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
1256: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260:
1261: FOR ctr IN 1..l_delivery_id_tab.count LOOP

Line 1323: -- call the FND API to get a new number for each delivery --

1319: END IF;
1320:
1321: -------------------------------------------------------------------------
1322: -- if the sequence type is automatic --
1323: -- call the FND API to get a new number for each delivery --
1324: -- if the sequence type is manual --
1325: -- if this is a parent delivery --
1326: -- call the FND API to validate the number given by the user --
1327: -- if this is a child delivery --

Line 1326: -- call the FND API to validate the number given by the user --

1322: -- if the sequence type is automatic --
1323: -- call the FND API to get a new number for each delivery --
1324: -- if the sequence type is manual --
1325: -- if this is a parent delivery --
1326: -- call the FND API to validate the number given by the user --
1327: -- if this is a child delivery --
1328: -- use the same number given by the user for all child deliveries --
1329: -------------------------------------------------------------------------
1330: -- 2695602: Added type = 'G' below for handling Gapless Sequences

Line 1351: RAISE FND_API.G_EXC_ERROR;

1347: IF NVL(l_sequence_number,0) = 0
1348: THEN
1349: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_SEQ_ERROR');
1350: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354: /* l_document_number := LTRIM(RTRIM(category_rec.prefix)) ||
1355: category_rec.delimiter ||

Line 1549: -- call the FND API to get a new number --

1545: END IF;
1546:
1547: -------------------------------------------------------------------------
1548: -- if the sequence type is automatic or Gapless --
1549: -- call the FND API to get a new number --
1550: -- if the sequence type is manual --
1551: -- use the number given by the user --
1552: -------------------------------------------------------------------------
1553:

Line 1572: RAISE FND_API.G_EXC_ERROR;

1568: IF NVL(l_sequence_number,0) = 0
1569: THEN
1570: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_SEQ_ERROR');
1571: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;
1574:
1575: IF category_rec.prefix is not NULL THEN
1576: l_prefix:= LTRIM(RTRIM(category_rec.prefix))||category_rec.delimiter;

Line 1665: IF FND_API.to_boolean( p_commit ) THEN

1661: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1662: p_data => x_msg_data);
1663:
1664: -- Standard check of p_commit.
1665: IF FND_API.to_boolean( p_commit ) THEN
1666: COMMIT WORK;
1667: END IF;
1668:
1669:

Line 1702: WHEN FND_API.g_exc_error THEN

1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock delivery leg for update');
1700: END IF;
1701:
1702: WHEN FND_API.g_exc_error THEN
1703: --Bug 4284167 (FP Bug 4149501)
1704: IF (get_lock_on_leg%ISOPEN) THEN
1705: CLOSE get_lock_on_leg;
1706: END IF;

Line 1716: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1712: --
1713: -- Debug Statements
1714: --
1715: IF l_debug_on THEN
1716: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1718: END IF;
1719: --
1720: WHEN FND_API.g_exc_unexpected_error THEN

Line 1717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1713: -- Debug Statements
1714: --
1715: IF l_debug_on THEN
1716: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1718: END IF;
1719: --
1720: WHEN FND_API.g_exc_unexpected_error THEN
1721: --Bug 4284167 (FP Bug 4149501)

Line 1720: WHEN FND_API.g_exc_unexpected_error THEN

1716: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1717: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1718: END IF;
1719: --
1720: WHEN FND_API.g_exc_unexpected_error THEN
1721: --Bug 4284167 (FP Bug 4149501)
1722: IF (get_lock_on_leg%ISOPEN) THEN
1723: CLOSE get_lock_on_leg;
1724: END IF;

Line 1734: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1730: --
1731: -- Debug Statements
1732: --
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1735: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1736: END IF;
1737: --
1738: WHEN others THEN

Line 1735: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1731: -- Debug Statements
1732: --
1733: IF l_debug_on THEN
1734: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1735: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1736: END IF;
1737: --
1738: WHEN others THEN
1739: --Bug 4284167 (FP Bug 4149501)

Line 1837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

1833: -----------------------------------------------------------------------------
1834:
1835: PROCEDURE Update_Document
1836: ( p_api_version IN NUMBER
1837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1838: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1839: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
1840: , x_return_status OUT NOCOPY VARCHAR2
1841: , x_msg_count OUT NOCOPY NUMBER

Line 1838: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

1834:
1835: PROCEDURE Update_Document
1836: ( p_api_version IN NUMBER
1837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1838: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1839: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
1840: , x_return_status OUT NOCOPY VARCHAR2
1841: , x_msg_count OUT NOCOPY NUMBER
1842: , x_msg_data OUT NOCOPY VARCHAR2

Line 1839: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

1835: PROCEDURE Update_Document
1836: ( p_api_version IN NUMBER
1837: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
1838: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
1839: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
1840: , x_return_status OUT NOCOPY VARCHAR2
1841: , x_msg_count OUT NOCOPY NUMBER
1842: , x_msg_data OUT NOCOPY VARCHAR2
1843: , p_entity_name IN VARCHAR2 DEFAULT NULL

Line 1927: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1923: --
1924: SAVEPOINT WSH_Document_PVT;
1925:
1926: -- standard call to check for call compatibility.
1927: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1928: p_api_version,
1929: l_api_name,
1930: g_pkg_name ) THEN
1931: RAISE FND_API.g_exc_unexpected_error;

Line 1931: RAISE FND_API.g_exc_unexpected_error;

1927: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1928: p_api_version,
1929: l_api_name,
1930: g_pkg_name ) THEN
1931: RAISE FND_API.g_exc_unexpected_error;
1932: END IF;
1933:
1934: -- initialize message list if p_init_msg_list is set to TRUE.
1935:

Line 1936: IF FND_API.to_boolean( p_init_msg_list ) THEN

1932: END IF;
1933:
1934: -- initialize message list if p_init_msg_list is set to TRUE.
1935:
1936: IF FND_API.to_boolean( p_init_msg_list ) THEN
1937: FND_MSG_PUB.initialize;
1938: END IF;
1939:
1940: -- initialize API return status to success

Line 1992: RAISE FND_API.G_EXC_ERROR;

1988:
1989: IF NOT l_delivery_id_tab.EXISTS(1) THEN
1990: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
1991: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
1992: RAISE FND_API.G_EXC_ERROR;
1993: END IF;
1994:
1995: FOR ctr IN 1..l_delivery_id_tab.count LOOP
1996:

Line 2027: RAISE FND_API.G_EXC_ERROR;

2023: IF old_values_csr%NOTFOUND THEN
2024: CLOSE old_values_csr;
2025: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2026: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2027: RAISE FND_API.G_EXC_ERROR;
2028: END IF;
2029:
2030: -- if the document is cancelled, raise error
2031: IF old_values_rec.status = 'CANCELLED' THEN

Line 2034: RAISE FND_API.G_EXC_ERROR;

2030: -- if the document is cancelled, raise error
2031: IF old_values_rec.status = 'CANCELLED' THEN
2032: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2033: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036:
2037: -- need to change this update within loop to a bulk update later.
2038: -- probably use temporary tables with a join

Line 2057: IF FND_API.to_boolean( p_commit ) THEN

2053: -- get message count and the message itself (if only one message)
2054: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2055: p_data => x_msg_data);
2056: -- Standard check of p_commit.
2057: IF FND_API.to_boolean( p_commit ) THEN
2058: COMMIT WORK;
2059: END IF;
2060: --
2061: -- Debug Statements

Line 2069: WHEN FND_API.g_exc_error THEN

2065: END IF;
2066: --
2067: EXCEPTION
2068:
2069: WHEN FND_API.g_exc_error THEN
2070: ROLLBACK to WSH_Document_PVT;
2071: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2072: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2073: p_data => x_msg_data );

Line 2079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2075: --
2076: -- Debug Statements
2077: --
2078: IF l_debug_on THEN
2079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2081: END IF;
2082: --
2083: WHEN FND_API.g_exc_unexpected_error THEN

Line 2080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2076: -- Debug Statements
2077: --
2078: IF l_debug_on THEN
2079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2081: END IF;
2082: --
2083: WHEN FND_API.g_exc_unexpected_error THEN
2084: ROLLBACK to WSH_Document_PVT;

Line 2083: WHEN FND_API.g_exc_unexpected_error THEN

2079: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2080: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2081: END IF;
2082: --
2083: WHEN FND_API.g_exc_unexpected_error THEN
2084: ROLLBACK to WSH_Document_PVT;
2085: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2086: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2087: p_data => x_msg_data );

Line 2093: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2089: --
2090: -- Debug Statements
2091: --
2092: IF l_debug_on THEN
2093: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2095: END IF;
2096: --
2097: WHEN others THEN

Line 2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2090: -- Debug Statements
2091: --
2092: IF l_debug_on THEN
2093: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2095: END IF;
2096: --
2097: WHEN others THEN
2098: ROLLBACK to WSH_Document_PVT;

Line 2155: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

2151:
2152:
2153: PROCEDURE Cancel_Document
2154: ( p_api_version IN NUMBER
2155: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2156: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2157: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2158: , x_return_status OUT NOCOPY VARCHAR2
2159: , x_msg_count OUT NOCOPY NUMBER

Line 2156: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

2152:
2153: PROCEDURE Cancel_Document
2154: ( p_api_version IN NUMBER
2155: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2156: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2157: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2158: , x_return_status OUT NOCOPY VARCHAR2
2159: , x_msg_count OUT NOCOPY NUMBER
2160: , x_msg_data OUT NOCOPY VARCHAR2

Line 2157: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

2153: PROCEDURE Cancel_Document
2154: ( p_api_version IN NUMBER
2155: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2156: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2157: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2158: , x_return_status OUT NOCOPY VARCHAR2
2159: , x_msg_count OUT NOCOPY NUMBER
2160: , x_msg_data OUT NOCOPY VARCHAR2
2161: , p_entity_name IN VARCHAR2 DEFAULT NULL

Line 2249: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2245: --
2246: SAVEPOINT WSH_Document_PVT;
2247:
2248: -- standard call to check for call compatibility.
2249: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2250: p_api_version,
2251: l_api_name,
2252: g_pkg_name ) THEN
2253: RAISE FND_API.g_exc_unexpected_error;

Line 2253: RAISE FND_API.g_exc_unexpected_error;

2249: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2250: p_api_version,
2251: l_api_name,
2252: g_pkg_name ) THEN
2253: RAISE FND_API.g_exc_unexpected_error;
2254: END IF;
2255:
2256: -- initialize message list if p_init_msg_list is set to TRUE.
2257:

Line 2258: IF FND_API.to_boolean( p_init_msg_list ) THEN

2254: END IF;
2255:
2256: -- initialize message list if p_init_msg_list is set to TRUE.
2257:
2258: IF FND_API.to_boolean( p_init_msg_list ) THEN
2259: FND_MSG_PUB.initialize;
2260: END IF;
2261:
2262: -- initialize API return status to success

Line 2317: RAISE FND_API.G_EXC_ERROR;

2313:
2314: IF NOT l_delivery_id_tab.EXISTS(1) THEN
2315: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2316: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2317: RAISE FND_API.G_EXC_ERROR;
2318: END IF;
2319:
2320: FOR ctr IN 1..l_delivery_id_tab.count LOOP
2321:

Line 2352: RAISE FND_API.G_EXC_ERROR;

2348: IF status_csr%NOTFOUND THEN
2349: CLOSE status_csr;
2350: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2351: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2352: RAISE FND_API.G_EXC_ERROR;
2353: END IF;
2354:
2355: UPDATE wsh_document_instances
2356: SET status = 'CANCELLED'

Line 2385: IF FND_API.to_boolean( p_commit ) THEN

2381: -- get message count and the message itself (if only one message)
2382: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2383: p_data => x_msg_data);
2384: -- Standard check of p_commit.
2385: IF FND_API.to_boolean( p_commit ) THEN
2386: COMMIT WORK;
2387: END IF;
2388: --
2389: -- Debug Statements

Line 2397: WHEN FND_API.g_exc_error THEN

2393: END IF;
2394: --
2395: EXCEPTION
2396:
2397: WHEN FND_API.g_exc_error THEN
2398: ROLLBACK to WSH_Document_PVT;
2399: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2400: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2401: p_data => x_msg_data );

Line 2407: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2403: --
2404: -- Debug Statements
2405: --
2406: IF l_debug_on THEN
2407: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2408: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2409: END IF;
2410: --
2411: WHEN FND_API.g_exc_unexpected_error THEN

Line 2408: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2404: -- Debug Statements
2405: --
2406: IF l_debug_on THEN
2407: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2408: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2409: END IF;
2410: --
2411: WHEN FND_API.g_exc_unexpected_error THEN
2412: ROLLBACK to WSH_Document_PVT;

Line 2411: WHEN FND_API.g_exc_unexpected_error THEN

2407: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2408: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2409: END IF;
2410: --
2411: WHEN FND_API.g_exc_unexpected_error THEN
2412: ROLLBACK to WSH_Document_PVT;
2413: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2414: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2415: p_data => x_msg_data );

Line 2421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2417: --
2418: -- Debug Statements
2419: --
2420: IF l_debug_on THEN
2421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2423: END IF;
2424: --
2425: WHEN others THEN

Line 2422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2418: -- Debug Statements
2419: --
2420: IF l_debug_on THEN
2421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2423: END IF;
2424: --
2425: WHEN others THEN
2426: ROLLBACK to WSH_Document_PVT;

Line 2482: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

2478:
2479:
2480: PROCEDURE Open_Document
2481: ( p_api_version IN NUMBER
2482: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2483: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2484: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2485: , x_return_status OUT NOCOPY VARCHAR2
2486: , x_msg_count OUT NOCOPY NUMBER

Line 2483: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

2479:
2480: PROCEDURE Open_Document
2481: ( p_api_version IN NUMBER
2482: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2483: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2484: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2485: , x_return_status OUT NOCOPY VARCHAR2
2486: , x_msg_count OUT NOCOPY NUMBER
2487: , x_msg_data OUT NOCOPY VARCHAR2

Line 2484: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

2480: PROCEDURE Open_Document
2481: ( p_api_version IN NUMBER
2482: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2483: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2484: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2485: , x_return_status OUT NOCOPY VARCHAR2
2486: , x_msg_count OUT NOCOPY NUMBER
2487: , x_msg_data OUT NOCOPY VARCHAR2
2488: , p_entity_name IN VARCHAR2 DEFAULT NULL

Line 2568: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2564: --
2565: SAVEPOINT WSH_Document_PVT;
2566:
2567: -- standard call to check for call compatibility.
2568: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2569: p_api_version,
2570: l_api_name,
2571: g_pkg_name ) THEN
2572: RAISE FND_API.g_exc_unexpected_error;

Line 2572: RAISE FND_API.g_exc_unexpected_error;

2568: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2569: p_api_version,
2570: l_api_name,
2571: g_pkg_name ) THEN
2572: RAISE FND_API.g_exc_unexpected_error;
2573: END IF;
2574:
2575: -- initialize message list if p_init_msg_list is set to TRUE.
2576:

Line 2577: IF FND_API.to_boolean( p_init_msg_list ) THEN

2573: END IF;
2574:
2575: -- initialize message list if p_init_msg_list is set to TRUE.
2576:
2577: IF FND_API.to_boolean( p_init_msg_list ) THEN
2578: FND_MSG_PUB.initialize;
2579: END IF;
2580:
2581: -- initialize API return status to success

Line 2633: RAISE FND_API.G_EXC_ERROR;

2629:
2630: IF NOT l_delivery_id_tab.EXISTS(1) THEN
2631: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2632: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;
2635:
2636: FOR ctr IN 1..l_delivery_id_tab.count LOOP
2637:

Line 2668: RAISE FND_API.G_EXC_ERROR;

2664: IF status_csr%NOTFOUND THEN
2665: CLOSE status_csr;
2666: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2667: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2668: RAISE FND_API.G_EXC_ERROR;
2669: END IF;
2670:
2671: UPDATE wsh_document_instances
2672: SET status = 'OPEN'

Line 2688: IF FND_API.to_boolean( p_commit ) THEN

2684: -- get message count and the message itself (if only one message)
2685: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2686: p_data => x_msg_data);
2687: -- Standard check of p_commit.
2688: IF FND_API.to_boolean( p_commit ) THEN
2689: COMMIT WORK;
2690: END IF;
2691: --
2692: -- Debug Statements

Line 2700: WHEN FND_API.g_exc_error THEN

2696: END IF;
2697: --
2698: EXCEPTION
2699:
2700: WHEN FND_API.g_exc_error THEN
2701: ROLLBACK to WSH_Document_PVT;
2702: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
2703: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2704: p_data => x_msg_data );

Line 2710: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2706: --
2707: -- Debug Statements
2708: --
2709: IF l_debug_on THEN
2710: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2712: END IF;
2713: --
2714: WHEN FND_API.g_exc_unexpected_error THEN

Line 2711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2707: -- Debug Statements
2708: --
2709: IF l_debug_on THEN
2710: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2712: END IF;
2713: --
2714: WHEN FND_API.g_exc_unexpected_error THEN
2715: ROLLBACK to WSH_Document_PVT;

Line 2714: WHEN FND_API.g_exc_unexpected_error THEN

2710: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2712: END IF;
2713: --
2714: WHEN FND_API.g_exc_unexpected_error THEN
2715: ROLLBACK to WSH_Document_PVT;
2716: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2717: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
2718: p_data => x_msg_data );

Line 2724: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2720: --
2721: -- Debug Statements
2722: --
2723: IF l_debug_on THEN
2724: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2726: END IF;
2727: --
2728: WHEN others THEN

Line 2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2721: -- Debug Statements
2722: --
2723: IF l_debug_on THEN
2724: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2726: END IF;
2727: --
2728: WHEN others THEN
2729: ROLLBACK to WSH_Document_PVT;

Line 2786: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

2782:
2783:
2784: PROCEDURE Complete_Document
2785: ( p_api_version IN NUMBER
2786: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2787: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2788: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2789: , x_return_status OUT NOCOPY VARCHAR2
2790: , x_msg_count OUT NOCOPY NUMBER

Line 2787: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

2783:
2784: PROCEDURE Complete_Document
2785: ( p_api_version IN NUMBER
2786: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2787: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2788: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2789: , x_return_status OUT NOCOPY VARCHAR2
2790: , x_msg_count OUT NOCOPY NUMBER
2791: , x_msg_data OUT NOCOPY VARCHAR2

Line 2788: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

2784: PROCEDURE Complete_Document
2785: ( p_api_version IN NUMBER
2786: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
2787: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
2788: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
2789: , x_return_status OUT NOCOPY VARCHAR2
2790: , x_msg_count OUT NOCOPY NUMBER
2791: , x_msg_data OUT NOCOPY VARCHAR2
2792: , p_entity_name IN VARCHAR2 DEFAULT NULL

Line 2872: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2868: --
2869: SAVEPOINT WSH_Document_PVT;
2870:
2871: -- standard call to check for call compatibility.
2872: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2873: p_api_version,
2874: l_api_name,
2875: g_pkg_name ) THEN
2876: RAISE FND_API.g_exc_unexpected_error;

Line 2876: RAISE FND_API.g_exc_unexpected_error;

2872: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2873: p_api_version,
2874: l_api_name,
2875: g_pkg_name ) THEN
2876: RAISE FND_API.g_exc_unexpected_error;
2877: END IF;
2878:
2879: -- initialize message list if p_init_msg_list is set to TRUE.
2880:

Line 2881: IF FND_API.to_boolean( p_init_msg_list ) THEN

2877: END IF;
2878:
2879: -- initialize message list if p_init_msg_list is set to TRUE.
2880:
2881: IF FND_API.to_boolean( p_init_msg_list ) THEN
2882: FND_MSG_PUB.initialize;
2883: END IF;
2884:
2885: -- initialize API return status to success

Line 2937: RAISE FND_API.G_EXC_ERROR;

2933:
2934: IF NOT l_delivery_id_tab.EXISTS(1) THEN
2935: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_INVALID_DELIVERY');
2936: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2937: RAISE FND_API.G_EXC_ERROR;
2938: END IF;
2939:
2940: FOR ctr IN 1..l_delivery_id_tab.count LOOP
2941:

Line 2972: RAISE FND_API.G_EXC_ERROR;

2968: IF status_csr%NOTFOUND THEN
2969: CLOSE status_csr;
2970: FND_MESSAGE.set_name ('WSH', 'WSH_DOC_MISSING');
2971: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.g_ret_sts_error);
2972: RAISE FND_API.G_EXC_ERROR;
2973: END IF;
2974:
2975: UPDATE wsh_document_instances
2976: SET status = 'COMPLETE'

Line 2992: IF FND_API.to_boolean( p_commit ) THEN

2988: -- get message count and the message itself (if only one message)
2989: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2990: p_data => x_msg_data);
2991: -- Standard check of p_commit.
2992: IF FND_API.to_boolean( p_commit ) THEN
2993: COMMIT WORK;
2994: END IF;
2995: --
2996: -- Debug Statements

Line 3004: WHEN FND_API.g_exc_error THEN

3000: END IF;
3001: --
3002: EXCEPTION
3003:
3004: WHEN FND_API.g_exc_error THEN
3005: ROLLBACK to WSH_Document_PVT;
3006: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3007: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3008: p_data => x_msg_data );

Line 3014: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3010: --
3011: -- Debug Statements
3012: --
3013: IF l_debug_on THEN
3014: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3016: END IF;
3017: --
3018: WHEN FND_API.g_exc_unexpected_error THEN

Line 3015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3011: -- Debug Statements
3012: --
3013: IF l_debug_on THEN
3014: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3016: END IF;
3017: --
3018: WHEN FND_API.g_exc_unexpected_error THEN
3019: ROLLBACK to WSH_Document_PVT;

Line 3018: WHEN FND_API.g_exc_unexpected_error THEN

3014: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3016: END IF;
3017: --
3018: WHEN FND_API.g_exc_unexpected_error THEN
3019: ROLLBACK to WSH_Document_PVT;
3020: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3021: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3022: p_data => x_msg_data );

Line 3028: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3024: --
3025: -- Debug Statements
3026: --
3027: IF l_debug_on THEN
3028: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3029: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3030: END IF;
3031: --
3032: WHEN others THEN

Line 3029: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3025: -- Debug Statements
3026: --
3027: IF l_debug_on THEN
3028: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3029: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3030: END IF;
3031: --
3032: WHEN others THEN
3033: ROLLBACK to WSH_Document_PVT;

Line 3096: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

3092: ------------------------------------------------------------------------------
3093:
3094: PROCEDURE Print_Document
3095: ( p_api_version IN NUMBER
3096: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3097: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3098: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3099: , x_return_status OUT NOCOPY VARCHAR2
3100: , x_msg_count OUT NOCOPY NUMBER

Line 3097: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

3093:
3094: PROCEDURE Print_Document
3095: ( p_api_version IN NUMBER
3096: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3097: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3098: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3099: , x_return_status OUT NOCOPY VARCHAR2
3100: , x_msg_count OUT NOCOPY NUMBER
3101: , x_msg_data OUT NOCOPY VARCHAR2

Line 3098: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

3094: PROCEDURE Print_Document
3095: ( p_api_version IN NUMBER
3096: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3097: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3098: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3099: , x_return_status OUT NOCOPY VARCHAR2
3100: , x_msg_count OUT NOCOPY NUMBER
3101: , x_msg_data OUT NOCOPY VARCHAR2
3102: , p_delivery_id IN NUMBER

Line 3158: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3154: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_CARRIER',P_FREIGHT_CARRIER);
3155: WSH_DEBUG_SV.log(l_module_name,'P_WAREHOUSE_ID',P_WAREHOUSE_ID);
3156: END IF;
3157: --
3158: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3159: p_api_version,
3160: l_api_name,
3161: g_pkg_name ) THEN
3162: RAISE FND_API.g_exc_unexpected_error;

Line 3162: RAISE FND_API.g_exc_unexpected_error;

3158: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3159: p_api_version,
3160: l_api_name,
3161: g_pkg_name ) THEN
3162: RAISE FND_API.g_exc_unexpected_error;
3163: END IF;
3164:
3165: -- initialize message list if p_init_msg_list is set to TRUE.
3166:

Line 3167: IF FND_API.to_boolean( p_init_msg_list ) THEN

3163: END IF;
3164:
3165: -- initialize message list if p_init_msg_list is set to TRUE.
3166:
3167: IF FND_API.to_boolean( p_init_msg_list ) THEN
3168: FND_MSG_PUB.initialize;
3169: END IF;
3170:
3171: -- initialize API return status to success

Line 3220: WHEN FND_API.g_exc_error THEN

3216: END IF;
3217: --
3218: EXCEPTION
3219:
3220: WHEN FND_API.g_exc_error THEN
3221: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3222: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3223: p_data => x_msg_data );
3224:

Line 3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3225: --
3226: -- Debug Statements
3227: --
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.g_exc_unexpected_error THEN

Line 3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3226: -- Debug Statements
3227: --
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.g_exc_unexpected_error THEN
3234: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 3233: WHEN FND_API.g_exc_unexpected_error THEN

3229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3231: END IF;
3232: --
3233: WHEN FND_API.g_exc_unexpected_error THEN
3234: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3235: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3236: p_data => x_msg_data );
3237: --

Line 3241: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3237: --
3238: -- Debug Statements
3239: --
3240: IF l_debug_on THEN
3241: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3243: END IF;
3244: --
3245: WHEN others THEN

Line 3242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3238: -- Debug Statements
3239: --
3240: IF l_debug_on THEN
3241: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3242: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3243: END IF;
3244: --
3245: WHEN others THEN
3246: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');

Line 3298: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

3294: ------------------------------------------------------------------------------
3295:
3296: FUNCTION Get_CumQty
3297: ( p_api_version IN NUMBER
3298: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3299: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3300: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3301: , x_return_status OUT NOCOPY VARCHAR2
3302: , x_msg_count OUT NOCOPY NUMBER

Line 3299: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

3295:
3296: FUNCTION Get_CumQty
3297: ( p_api_version IN NUMBER
3298: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3299: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3300: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3301: , x_return_status OUT NOCOPY VARCHAR2
3302: , x_msg_count OUT NOCOPY NUMBER
3303: , x_msg_data OUT NOCOPY VARCHAR2

Line 3300: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

3296: FUNCTION Get_CumQty
3297: ( p_api_version IN NUMBER
3298: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3299: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3300: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3301: , x_return_status OUT NOCOPY VARCHAR2
3302: , x_msg_count OUT NOCOPY NUMBER
3303: , x_msg_data OUT NOCOPY VARCHAR2
3304: , p_customer_id IN NUMBER

Line 3359: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3355: WSH_DEBUG_SV.log(l_module_name,'P_CUSTOMER_ID',P_CUSTOMER_ID);
3356: WSH_DEBUG_SV.log(l_module_name,'P_OE_ORDER_LINE_ID',P_OE_ORDER_LINE_ID);
3357: END IF;
3358: --
3359: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3360: p_api_version,
3361: l_api_name,
3362: g_pkg_name ) THEN
3363: RAISE FND_API.g_exc_unexpected_error;

Line 3363: RAISE FND_API.g_exc_unexpected_error;

3359: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3360: p_api_version,
3361: l_api_name,
3362: g_pkg_name ) THEN
3363: RAISE FND_API.g_exc_unexpected_error;
3364: END IF;
3365:
3366: -- initialize message list if p_init_msg_list is set to TRUE.
3367: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 3367: IF FND_API.to_boolean( p_init_msg_list ) THEN

3363: RAISE FND_API.g_exc_unexpected_error;
3364: END IF;
3365:
3366: -- initialize message list if p_init_msg_list is set to TRUE.
3367: IF FND_API.to_boolean( p_init_msg_list ) THEN
3368: FND_MSG_PUB.initialize;
3369: END IF;
3370:
3371: -- initialize API return status to success

Line 3416: RAISE FND_API.g_exc_error;

3412: and bsu.cust_acct_site_ID = bs.cust_acct_site_ID;
3413:
3414: IF SQL%NOTFOUND or SQL%ROWCOUNT > 1
3415: THEN
3416: RAISE FND_API.g_exc_error;
3417: END IF;
3418:
3419: -- 1711448, Added this API to get CUM Start Date
3420: --

Line 3487: WHEN FND_API.g_exc_error THEN

3483: RETURN l_cum_qty;
3484:
3485: EXCEPTION
3486:
3487: WHEN FND_API.g_exc_error THEN
3488: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3489: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3490: p_data => x_msg_data );
3491: --

Line 3495: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3491: --
3492: -- Debug Statements
3493: --
3494: IF l_debug_on THEN
3495: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3497: END IF;
3498: --
3499: RETURN null;

Line 3496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3492: -- Debug Statements
3493: --
3494: IF l_debug_on THEN
3495: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3497: END IF;
3498: --
3499: RETURN null;
3500:

Line 3501: WHEN FND_API.g_exc_unexpected_error THEN

3497: END IF;
3498: --
3499: RETURN null;
3500:
3501: WHEN FND_API.g_exc_unexpected_error THEN
3502: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3503: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3504: p_data => x_msg_data );
3505: --

Line 3509: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3505: --
3506: -- Debug Statements
3507: --
3508: IF l_debug_on THEN
3509: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3511: END IF;
3512: --
3513: RETURN null;

Line 3510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3506: -- Debug Statements
3507: --
3508: IF l_debug_on THEN
3509: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3511: END IF;
3512: --
3513: RETURN null;
3514:

Line 3569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

3565: ------------------------------------------------------------------------------
3566:
3567: PROCEDURE Cancel_All_Documents
3568: ( p_api_version IN NUMBER
3569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3572: , x_return_status OUT NOCOPY VARCHAR2
3573: , x_msg_count OUT NOCOPY NUMBER

Line 3570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

3566:
3567: PROCEDURE Cancel_All_Documents
3568: ( p_api_version IN NUMBER
3569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3572: , x_return_status OUT NOCOPY VARCHAR2
3573: , x_msg_count OUT NOCOPY NUMBER
3574: , x_msg_data OUT NOCOPY VARCHAR2

Line 3571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

3567: PROCEDURE Cancel_All_Documents
3568: ( p_api_version IN NUMBER
3569: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3570: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3571: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3572: , x_return_status OUT NOCOPY VARCHAR2
3573: , x_msg_count OUT NOCOPY NUMBER
3574: , x_msg_data OUT NOCOPY VARCHAR2
3575: , p_entity_name IN VARCHAR2

Line 3613: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3609: --
3610: SAVEPOINT WSH_Document_PVT;
3611:
3612: -- standard call to check for call compatibility.
3613: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3614: p_api_version,
3615: l_api_name,
3616: g_pkg_name ) THEN
3617: RAISE FND_API.g_exc_unexpected_error;

Line 3617: RAISE FND_API.g_exc_unexpected_error;

3613: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3614: p_api_version,
3615: l_api_name,
3616: g_pkg_name ) THEN
3617: RAISE FND_API.g_exc_unexpected_error;
3618: END IF;
3619:
3620: -- initialize message list if p_init_msg_list is set to TRUE.
3621: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 3621: IF FND_API.to_boolean( p_init_msg_list ) THEN

3617: RAISE FND_API.g_exc_unexpected_error;
3618: END IF;
3619:
3620: -- initialize message list if p_init_msg_list is set to TRUE.
3621: IF FND_API.to_boolean( p_init_msg_list ) THEN
3622: FND_MSG_PUB.initialize;
3623: END IF;
3624:
3625: -- initialize API return status to success

Line 3641: IF FND_API.to_boolean( p_commit ) THEN

3637: -- get message count and the message itself (if only one message)
3638: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3639: p_data => x_msg_data);
3640: -- Standard check of p_commit.
3641: IF FND_API.to_boolean( p_commit ) THEN
3642: COMMIT WORK;
3643: END IF;
3644: --
3645: -- Debug Statements

Line 3653: WHEN FND_API.g_exc_error THEN

3649: END IF;
3650: --
3651: EXCEPTION
3652:
3653: WHEN FND_API.g_exc_error THEN
3654: ROLLBACK to WSH_Document_PVT;
3655: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3656: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3657: p_data => x_msg_data );

Line 3663: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3659: --
3660: -- Debug Statements
3661: --
3662: IF l_debug_on THEN
3663: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3665: END IF;
3666: --
3667: WHEN FND_API.g_exc_unexpected_error THEN

Line 3664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3660: -- Debug Statements
3661: --
3662: IF l_debug_on THEN
3663: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3665: END IF;
3666: --
3667: WHEN FND_API.g_exc_unexpected_error THEN
3668: ROLLBACK to WSH_Document_PVT;

Line 3667: WHEN FND_API.g_exc_unexpected_error THEN

3663: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3665: END IF;
3666: --
3667: WHEN FND_API.g_exc_unexpected_error THEN
3668: ROLLBACK to WSH_Document_PVT;
3669: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3670: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3671: p_data => x_msg_data );

Line 3677: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3673: --
3674: -- Debug Statements
3675: --
3676: IF l_debug_on THEN
3677: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3678: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3679: END IF;
3680: --
3681: WHEN others THEN

Line 3678: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3674: -- Debug Statements
3675: --
3676: IF l_debug_on THEN
3677: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3678: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3679: END IF;
3680: --
3681: WHEN others THEN
3682: ROLLBACK to WSH_Document_PVT;

Line 3735: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false

3731: ------------------------------------------------------------------------------
3732:
3733: PROCEDURE Get_All_Documents
3734: ( p_api_version IN NUMBER
3735: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3736: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3737: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3738: , x_return_status OUT NOCOPY VARCHAR2
3739: , x_msg_count OUT NOCOPY NUMBER

Line 3736: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false

3732:
3733: PROCEDURE Get_All_Documents
3734: ( p_api_version IN NUMBER
3735: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3736: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3737: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3738: , x_return_status OUT NOCOPY VARCHAR2
3739: , x_msg_count OUT NOCOPY NUMBER
3740: , x_msg_data OUT NOCOPY VARCHAR2

Line 3737: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full

3733: PROCEDURE Get_All_Documents
3734: ( p_api_version IN NUMBER
3735: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
3736: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
3737: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
3738: , x_return_status OUT NOCOPY VARCHAR2
3739: , x_msg_count OUT NOCOPY NUMBER
3740: , x_msg_data OUT NOCOPY VARCHAR2
3741: , p_entity_name IN VARCHAR2

Line 3817: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3813: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_NAME',P_ENTITY_NAME);
3814: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
3815: END IF;
3816: --
3817: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3818: p_api_version,
3819: l_api_name,
3820: g_pkg_name ) THEN
3821: RAISE FND_API.g_exc_unexpected_error;

Line 3821: RAISE FND_API.g_exc_unexpected_error;

3817: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3818: p_api_version,
3819: l_api_name,
3820: g_pkg_name ) THEN
3821: RAISE FND_API.g_exc_unexpected_error;
3822: END IF;
3823:
3824: -- initialize message list if p_init_msg_list is set to TRUE.
3825: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 3825: IF FND_API.to_boolean( p_init_msg_list ) THEN

3821: RAISE FND_API.g_exc_unexpected_error;
3822: END IF;
3823:
3824: -- initialize message list if p_init_msg_list is set to TRUE.
3825: IF FND_API.to_boolean( p_init_msg_list ) THEN
3826: FND_MSG_PUB.initialize;
3827: END IF;
3828:
3829: -- initialize API return status to success

Line 3888: IF FND_API.to_boolean( p_commit ) THEN

3884: -- get message count and the message itself (if only one message)
3885: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3886: p_data => x_msg_data);
3887: -- Standard check of p_commit.
3888: IF FND_API.to_boolean( p_commit ) THEN
3889: COMMIT WORK;
3890: END IF;
3891: --
3892: -- Debug Statements

Line 3901: WHEN FND_API.g_exc_error THEN

3897: END IF;
3898: --
3899: EXCEPTION
3900:
3901: WHEN FND_API.g_exc_error THEN
3902: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
3903: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3904: p_data => x_msg_data );
3905:

Line 3910: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3906: --
3907: -- Debug Statements
3908: --
3909: IF l_debug_on THEN
3910: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3912: END IF;
3913: --
3914: WHEN FND_API.g_exc_unexpected_error THEN

Line 3911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3907: -- Debug Statements
3908: --
3909: IF l_debug_on THEN
3910: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3912: END IF;
3913: --
3914: WHEN FND_API.g_exc_unexpected_error THEN
3915: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

Line 3914: WHEN FND_API.g_exc_unexpected_error THEN

3910: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3912: END IF;
3913: --
3914: WHEN FND_API.g_exc_unexpected_error THEN
3915: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
3916: FND_MSG_PUB.count_and_get ( p_count => x_msg_count,
3917: p_data => x_msg_data );
3918:

Line 3923: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3919: --
3920: -- Debug Statements
3921: --
3922: IF l_debug_on THEN
3923: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3925: END IF;
3926: --
3927: WHEN others THEN

Line 3924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3920: -- Debug Statements
3921: --
3922: IF l_debug_on THEN
3923: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3924: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3925: END IF;
3926: --
3927: WHEN others THEN
3928: FND_MESSAGE.set_name ('WSH','WSH_UNEXP_ERROR');