DBA Data[Home] [Help]

APPS.WSH_PO_INTEGRATION_GRP dependencies on FND_API

Line 88: IF NOT FND_API.compatible_api_call(

84: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
85: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.header_ids.COUNT',p_in_rec.header_ids.COUNT);
86: END IF;
87: --
88: IF NOT FND_API.compatible_api_call(
89: l_api_version_number,
90: p_api_version_number,
91: l_api_name,
92: G_PKG_NAME) THEN

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: l_api_version_number,
90: p_api_version_number,
91: l_api_name,
92: G_PKG_NAME) THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: IF FND_API.to_boolean(p_init_msg_list) THEN
97: FND_MSG_PUB.initialize;

Line 96: IF FND_API.to_boolean(p_init_msg_list) THEN

92: G_PKG_NAME) THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END IF;
95:
96: IF FND_API.to_boolean(p_init_msg_list) THEN
97: FND_MSG_PUB.initialize;
98: END IF;
99:
100:

Line 127: p_encoded => FND_API.G_FALSE);

123:
124: FND_MSG_PUB.Count_And_Get(
125: p_count => x_msg_count,
126: p_data => x_msg_data,
127: p_encoded => FND_API.G_FALSE);
128:
129: IF FND_API.TO_BOOLEAN(p_commit) THEN
130: COMMIT WORK;
131: END IF;

Line 129: IF FND_API.TO_BOOLEAN(p_commit) THEN

125: p_count => x_msg_count,
126: p_data => x_msg_data,
127: p_encoded => FND_API.G_FALSE);
128:
129: IF FND_API.TO_BOOLEAN(p_commit) THEN
130: COMMIT WORK;
131: END IF;
132:
133:

Line 234: IF NOT FND_API.compatible_api_call(

230: END IF;
231: --
232: SAVEPOINT PURGE_PVT;
233:
234: IF NOT FND_API.compatible_api_call(
235: l_api_version_number,
236: p_api_version_number,
237: l_api_name,
238: G_PKG_NAME) THEN

Line 239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

235: l_api_version_number,
236: p_api_version_number,
237: l_api_name,
238: G_PKG_NAME) THEN
239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: IF FND_API.to_boolean(p_init_msg_list) THEN
243: FND_MSG_PUB.initialize;

Line 242: IF FND_API.to_boolean(p_init_msg_list) THEN

238: G_PKG_NAME) THEN
239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
240: END IF;
241:
242: IF FND_API.to_boolean(p_init_msg_list) THEN
243: FND_MSG_PUB.initialize;
244: END IF;
245:
246:

Line 287: p_encoded => FND_API.G_FALSE);

283:
284: FND_MSG_PUB.Count_And_Get(
285: p_count => x_msg_count,
286: p_data => x_msg_data,
287: p_encoded => FND_API.G_FALSE);
288:
289: IF FND_API.TO_BOOLEAN(p_commit) THEN
290: COMMIT WORK;
291: END IF;

Line 289: IF FND_API.TO_BOOLEAN(p_commit) THEN

285: p_count => x_msg_count,
286: p_data => x_msg_data,
287: p_encoded => FND_API.G_FALSE);
288:
289: IF FND_API.TO_BOOLEAN(p_commit) THEN
290: COMMIT WORK;
291: END IF;
292:
293:

Line 363: IF NOT FND_API.compatible_api_call(

359: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
360: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
361: END IF;
362: --
363: IF NOT FND_API.compatible_api_call(
364: l_api_version_number,
365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME) THEN

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

364: l_api_version_number,
365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME) THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370: --
371: IF FND_API.to_boolean(p_init_msg_list) THEN
372: FND_MSG_PUB.initialize;

Line 371: IF FND_API.to_boolean(p_init_msg_list) THEN

367: G_PKG_NAME) THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370: --
371: IF FND_API.to_boolean(p_init_msg_list) THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374: --
375: FND_MSG_PUB.Count_And_Get(

Line 378: p_encoded => FND_API.G_FALSE);

374: --
375: FND_MSG_PUB.Count_And_Get(
376: p_count => x_msg_count,
377: p_data => x_msg_data,
378: p_encoded => FND_API.G_FALSE);
379: --
380: IF FND_API.TO_BOOLEAN(p_commit) THEN
381: COMMIT WORK;
382: END IF;

Line 380: IF FND_API.TO_BOOLEAN(p_commit) THEN

376: p_count => x_msg_count,
377: p_data => x_msg_data,
378: p_encoded => FND_API.G_FALSE);
379: --
380: IF FND_API.TO_BOOLEAN(p_commit) THEN
381: COMMIT WORK;
382: END IF;
383: --
384: IF l_debug_on THEN

Line 408: -- p_init_msg_list FND_API.G_TRUE to reset list

404: -- Pre-reqs : None
405: --
406: -- Parameters
407: -- p_api_version_number known api version error number
408: -- p_init_msg_list FND_API.G_TRUE to reset list
409: -- p_commit indicates whether to commit or not.
410: -- x_return_status return status
411: -- x_msg_count number of messages in the list
412: -- x_msg_data text of messages

Line 529: IF NOT FND_API.compatible_api_call(

525: WSH_DEBUG_SV.log(l_module_name,'p_commit',P_COMMIT);
526: WSH_DEBUG_SV.log(l_module_name,'Routing Response Number', p_in_rec.routingRespNum);
527: END IF;
528: --
529: IF NOT FND_API.compatible_api_call(
530: l_api_version_number,
531: p_api_version_number,
532: l_api_name,
533: G_PKG_NAME) THEN

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

530: l_api_version_number,
531: p_api_version_number,
532: l_api_name,
533: G_PKG_NAME) THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536: --
537: IF FND_API.to_boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;

Line 537: IF FND_API.to_boolean(p_init_msg_list) THEN

533: G_PKG_NAME) THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536: --
537: IF FND_API.to_boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540: --
541: -- Get last_update_date from WND and WTH

Line 606: p_encoded => FND_API.G_FALSE);

602: --
603: FND_MSG_PUB.Count_And_Get(
604: p_count => x_msg_count,
605: p_data => x_msg_data,
606: p_encoded => FND_API.G_FALSE);
607: --
608: IF l_debug_on THEN
609: wsh_debug_sv.log(l_module_name, 'l_changed', l_changed);
610: wsh_debug_sv.pop(l_module_name);

Line 615: WHEN FND_API.G_EXC_ERROR THEN

611: END IF;
612: --
613: EXCEPTION
614: --
615: WHEN FND_API.G_EXC_ERROR THEN
616: --
617: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
618: --
619: FND_MSG_PUB.Count_And_Get

Line 623: p_encoded => FND_API.G_FALSE

619: FND_MSG_PUB.Count_And_Get
620: (
621: p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => FND_API.G_FALSE
624: );
625: --
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

623: p_encoded => FND_API.G_FALSE
624: );
625: --
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
629: END IF;
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

624: );
625: --
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
629: END IF;
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: --

Line 631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

627: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
628: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
629: END IF;
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: --
633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
634: --
635: FND_MSG_PUB.Count_And_Get

Line 639: p_encoded => FND_API.G_FALSE

635: FND_MSG_PUB.Count_And_Get
636: (
637: p_count => x_msg_count,
638: p_data => x_msg_data,
639: p_encoded => FND_API.G_FALSE
640: );
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',

Line 643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',

639: p_encoded => FND_API.G_FALSE
640: );
641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',
644: WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
646: END IF;
647: --

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

641: --
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXP_ERROR',
644: WSH_DEBUG_SV.C_EXCEP_LEVEL);
645: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
646: END IF;
647: --
648: WHEN OTHERS THEN
649: --

Line 785: IF NOT FND_API.compatible_api_call(

781: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.po_shipment_line_id_tbl.count',p_in_rec.po_shipment_line_id_tbl.count);
782: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.ship_from_location_id',p_in_rec.ship_from_location_id);
783: END IF;
784: --
785: IF NOT FND_API.compatible_api_call(
786: l_api_version_number,
787: p_api_version_number,
788: l_api_name,
789: G_PKG_NAME) THEN

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: l_api_version_number,
787: p_api_version_number,
788: l_api_name,
789: G_PKG_NAME) THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792: --
793: IF FND_API.to_boolean(p_init_msg_list) THEN
794: FND_MSG_PUB.initialize;

Line 793: IF FND_API.to_boolean(p_init_msg_list) THEN

789: G_PKG_NAME) THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792: --
793: IF FND_API.to_boolean(p_init_msg_list) THEN
794: FND_MSG_PUB.initialize;
795: END IF;
796: --
797: x_out_rec.is_valid := TRUE;

Line 804: raise FND_API.G_EXC_ERROR;

800: THEN
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.logmsg(l_module_name,' Table count of Shipment Line IDs or PO Line IDs are not equal is/are Zero');
803: END IF;
804: raise FND_API.G_EXC_ERROR;
805: END IF;
806: --
807: IF p_in_rec.po_line_id_tbl.count <> p_in_rec.po_shipment_line_id_tbl.count THEN
808: IF l_debug_on THEN

Line 811: raise FND_API.G_EXC_ERROR;

807: IF p_in_rec.po_line_id_tbl.count <> p_in_rec.po_shipment_line_id_tbl.count THEN
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.logmsg(l_module_name,' Table count of Shipment Line IDs and PO Line IDs are not equal');
810: END IF;
811: raise FND_API.G_EXC_ERROR;
812: END IF;
813: --
814: --
815: OPEN valid_wsh_sf_loc_csr(p_in_rec.ship_from_location_id);

Line 832: RAISE FND_API.G_EXC_ERROR;

828: --
829: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_INVALID_WSH_LOC');
830: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
831: --
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: --
835: l_index := p_in_rec.po_line_id_tbl.FIRST;
836: WHILE l_index is not null LOOP

Line 860: RAISE FND_API.G_EXC_ERROR;

856: --
857: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_NO_OPEN_LINES');
858: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
859: --
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: CLOSE open_line_without_sf_csr;
863: END IF;
864: CLOSE open_line_with_sf_csr;

Line 872: p_encoded => FND_API.G_FALSE);

868:
869: FND_MSG_PUB.Count_And_Get(
870: p_count => x_msg_count,
871: p_data => x_msg_data,
872: p_encoded => FND_API.G_FALSE);
873:
874: IF FND_API.TO_BOOLEAN(p_commit) THEN
875: COMMIT WORK;
876: END IF;

Line 874: IF FND_API.TO_BOOLEAN(p_commit) THEN

870: p_count => x_msg_count,
871: p_data => x_msg_data,
872: p_encoded => FND_API.G_FALSE);
873:
874: IF FND_API.TO_BOOLEAN(p_commit) THEN
875: COMMIT WORK;
876: END IF;
877: --
878: -- Debug Statements

Line 886: WHEN FND_API.G_EXC_ERROR THEN

882: END IF;
883: --
884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
887: --
888: x_out_rec.is_valid := FALSE;
889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
890: --

Line 895: p_encoded => FND_API.G_FALSE

891: FND_MSG_PUB.Count_And_Get
892: (
893: p_count => x_msg_count,
894: p_data => x_msg_data,
895: p_encoded => FND_API.G_FALSE
896: );
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

895: p_encoded => FND_API.G_FALSE
896: );
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
900: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
901: END IF;
902: --
903: WHEN OTHERS THEN

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

896: );
897: --
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
900: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
901: END IF;
902: --
903: WHEN OTHERS THEN
904: --