DBA Data[Home] [Help]

APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on FND_MSG_PUB

Line 145: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

141: -- if you have more cursors, add cursor closing statements here as shown above
142: --
143:
144: x_return_status := G_RET_STS_ERROR ;
145: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
146: p_count => x_msg_count,
147: p_data => x_msg_data );
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 164: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

160: -- if you have more cursors, add close cursor statements here as shown above
161: --
162:
163: x_return_status := G_RET_STS_UNEXP_ERROR ;
164: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
165:
166: WHEN OTHERS THEN
167: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 181: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

177: -- if you have more cursors, add close cursor statements here as shown above
178: --
179:
180: x_return_status := G_RET_STS_UNEXP_ERROR ;
181: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
182:
183: END GET_OE_HEADER_VALUES;
184:
185:

Line 256: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

252: END IF;
253:
254:
255: x_return_status := G_RET_STS_ERROR ;
256: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
257: p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 271: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

267: CLOSE l_price_update_csr;
268: END IF;
269:
270: x_return_status := G_RET_STS_UNEXP_ERROR ;
271: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
272:
273: WHEN OTHERS THEN
274: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
275: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 284: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

280: CLOSE l_price_update_csr;
281: END IF;
282:
283: x_return_status := G_RET_STS_UNEXP_ERROR ;
284: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
285:
286: END GET_PRICE_UPDATE_TOLERANCE;
287:
288: PROCEDURE GET_QUOTE_SALES_SUPPLEMENT (

Line 407: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

403: END IF;
404:
405:
406: x_return_status := G_RET_STS_ERROR ;
407: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
408: p_count => x_msg_count,
409: p_data => x_msg_data );
410:
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 418: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

414: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
415: END IF;
416:
417: x_return_status := G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
419:
420: WHEN OTHERS THEN
421:
422: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 429: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

425: END IF;
426:
427:
428: x_return_status := G_RET_STS_UNEXP_ERROR ;
429: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
430:
431: END GET_QUOTE_SALES_SUPPLEMENT;
432:
433: PROCEDURE GET_SHIP_WAREHOUSE (

Line 500: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

496: END IF;
497:
498:
499: x_return_status := G_RET_STS_ERROR ;
500: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
501: p_count => x_msg_count,
502: p_data => x_msg_data );
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 515: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

511: CLOSE l_ship_warehouse_csr;
512: END IF;
513:
514: x_return_status := G_RET_STS_UNEXP_ERROR ;
515: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
516:
517: WHEN OTHERS THEN
518: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 528: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

524: CLOSE l_ship_warehouse_csr;
525: END IF;
526:
527: x_return_status := G_RET_STS_UNEXP_ERROR ;
528: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
529:
530: END GET_SHIP_WAREHOUSE;
531:
532: PROCEDURE GET_SOURCING_UOM (

Line 616: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

612: END IF;
613:
614:
615: x_return_status := G_RET_STS_ERROR ;
616: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
617: p_count => x_msg_count,
618: p_data => x_msg_data );
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 636: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

632: END IF;
633:
634:
635: x_return_status := G_RET_STS_UNEXP_ERROR ;
636: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
637:
638: WHEN OTHERS THEN
639: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
640: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 653: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

649: CLOSE l_quote_uom_code_csr;
650: END IF;
651:
652: x_return_status := G_RET_STS_UNEXP_ERROR ;
653: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
654:
655: END GET_SOURCING_UOM;
656:
657: PROCEDURE GET_PO_UOM (

Line 731: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

727: END IF;
728:
729:
730: x_return_status := G_RET_STS_ERROR ;
731: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
732: p_count => x_msg_count,
733: p_data => x_msg_data );
734:
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 746: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

742: CLOSE l_uom_code_csr;
743: END IF;
744:
745: x_return_status := G_RET_STS_UNEXP_ERROR ;
746: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
747:
748: WHEN OTHERS THEN
749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 759: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

755: CLOSE l_uom_code_csr;
756: END IF;
757:
758: x_return_status := G_RET_STS_UNEXP_ERROR ;
759: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
760:
761: END GET_PO_UOM;
762:
763: PROCEDURE GET_RELEASE_RATIO (

Line 830: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

826: END IF;
827:
828:
829: x_return_status := G_RET_STS_ERROR ;
830: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
831: p_count => x_msg_count,
832: p_data => x_msg_data );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

841: CLOSE l_release_ratio_csr;
842: END IF;
843:
844: x_return_status := G_RET_STS_UNEXP_ERROR ;
845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
846:
847: WHEN OTHERS THEN
848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 858: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

854: CLOSE l_release_ratio_csr;
855: END IF;
856:
857: x_return_status := G_RET_STS_UNEXP_ERROR ;
858: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
859:
860: END GET_RELEASE_RATIO;
861:
862: PROCEDURE GET_BLANKET_AMOUNT_RANGE (

Line 931: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

927: END IF;
928:
929:
930: x_return_status := G_RET_STS_ERROR ;
931: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
932: p_count => x_msg_count,
933: p_data => x_msg_data );
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 946: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

942: CLOSE l_blanket_amount_range_csr;
943: END IF;
944:
945: x_return_status := G_RET_STS_UNEXP_ERROR ;
946: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
947:
948: WHEN OTHERS THEN
949: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
950: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 959: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

955: CLOSE l_blanket_amount_range_csr;
956: END IF;
957:
958: x_return_status := G_RET_STS_UNEXP_ERROR ;
959: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
960:
961: END GET_BLANKET_AMOUNT_RANGE;
962:
963: PROCEDURE GET_DFF_PO (

Line 1030: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

1026: END IF;
1027:
1028:
1029: x_return_status := G_RET_STS_ERROR ;
1030: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
1031: p_count => x_msg_count,
1032: p_data => x_msg_data );
1033:
1034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1041: CLOSE l_attribute4_val_csr;
1042: END IF;
1043:
1044: x_return_status := G_RET_STS_UNEXP_ERROR ;
1045: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1046:
1047: WHEN OTHERS THEN
1048: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1049: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 1058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1054: CLOSE l_attribute4_val_csr;
1055: END IF;
1056:
1057: x_return_status := G_RET_STS_UNEXP_ERROR ;
1058: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1059:
1060: END GET_DFF_PO;
1061:
1062: PROCEDURE GET_DFF_SA (

Line 1141: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',

1137: END IF;
1138:
1139:
1140: x_return_status := G_RET_STS_ERROR ;
1141: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
1142: p_count => x_msg_count,
1143: p_data => x_msg_data );
1144:
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1156: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1152: CLOSE l_attribute4_val_csr;
1153: END IF;
1154:
1155: x_return_status := G_RET_STS_UNEXP_ERROR ;
1156: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1157:
1158: WHEN OTHERS THEN
1159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

Line 1169: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1165: CLOSE l_attribute4_val_csr;
1166: END IF;
1167:
1168: x_return_status := G_RET_STS_UNEXP_ERROR ;
1169: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1170:
1171: END GET_DFF_SA;
1172:
1173: END OKC_XPRT_CUSTOM_PACKAGE;