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

Line 28: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);

24:
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_COMMON_PVT';
26: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvscb.pls';
27:
28: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
29: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
30: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
31: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
32:

Line 29: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);

25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_COMMON_PVT';
26: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvscb.pls';
27:
28: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
29: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
30: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
31: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
32:
33: G_CHBK_UTIL_TYPE CONSTANT VARCHAR2(30) := 'CHARGEBACK';

Line 30: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);

26: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvscb.pls';
27:
28: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
29: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
30: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
31: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
32:
33: G_CHBK_UTIL_TYPE CONSTANT VARCHAR2(30) := 'CHARGEBACK';
34: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';

Line 31: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);

27:
28: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_high);
29: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_debug_low);
30: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_unexp_error);
31: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.g_msg_lvl_error);
32:
33: G_CHBK_UTIL_TYPE CONSTANT VARCHAR2(30) := 'CHARGEBACK';
34: G_SPP_UTIL_TYPE CONSTANT VARCHAR2(30) :='UTILIZED';
35: G_TP_ACCRUAL_UTIL_TYPE CONSTANT VARCHAR2(30) :='ADJUSTMENT';

Line 138: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: WHEN OTHERS THEN
137: IF OZF_UNEXP_ERROR THEN
138: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
139: END IF;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: END Insert_Resale_Log;
142:

Line 221: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: WHEN OTHERS THEN
220: IF OZF_UNEXP_ERROR THEN
221: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
222: END IF;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: END Bulk_Insert_Resale_Log;
225:

Line 375: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: WHEN OTHERS THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: IF OZF_UNEXP_ERROR THEN
375: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
376: END IF;
377: END Log_Null_Values;
378:
379: ---------------------------------------------------------------------

Line 533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: IF OZF_UNEXP_ERROR THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: END Log_Invalid_Values;
536:
537: ---------------------------------------------------------------------

Line 586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

582: AND c.resale_id_type = 'IFACE');
583: EXCEPTION
584: WHEN OTHERS THEN
585: IF OZF_UNEXP_ERROR THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: END;
590: --

Line 601: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: WHEN OTHERS THEN
600: IF OZF_UNEXP_ERROR THEN
601: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
602: END IF;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: END Bulk_Dispute_Line;
605:

Line 695: FND_MSG_PUB.initialize;

691: END IF;
692:
693: --Initialize message if p_init_msg_list IS TRUE.
694: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
695: FND_MSG_PUB.initialize;
696: END IF;
697:
698: -- Debug Message
699: IF OZF_DEBUG_HIGH_ON THEN

Line 839: FND_MSG_PUB.Count_and_Get (

835: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
836: END IF;
837:
838: --Standard call to get message count AND if count=1, get the message
839: FND_MSG_PUB.Count_and_Get (
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data
843: );

Line 849: FND_MSG_PUB.Count_and_Get (

845: WHEN FND_API.G_EXC_ERROR THEN
846: ROLLBACK TO Update_Batch_Calculations;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: -- Standard call to get message count AND IF count=1, get the message
849: FND_MSG_PUB.Count_and_Get (
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data
853: );

Line 858: FND_MSG_PUB.Count_and_Get (

854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: ROLLBACK TO Update_Batch_Calculations;
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: -- Standard call to get message count AND IF count=1, get the message
858: FND_MSG_PUB.Count_and_Get (
859: p_encoded => FND_API.G_FALSE,
860: p_count => x_msg_count,
861: p_data => x_msg_data
862: );

Line 867: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

863: WHEN OTHERS THEN
864: ROLLBACK TO Update_Batch_Calculations;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: IF OZF_UNEXP_ERROR THEN
867: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
868: END IF;
869: -- Standard call to get message count AND IF count=1, get the message
870: FND_MSG_PUB.Count_and_Get (
871: p_encoded => FND_API.G_FALSE,

Line 870: FND_MSG_PUB.Count_and_Get (

866: IF OZF_UNEXP_ERROR THEN
867: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
868: END IF;
869: -- Standard call to get message count AND IF count=1, get the message
870: FND_MSG_PUB.Count_and_Get (
871: p_encoded => FND_API.G_FALSE,
872: p_count => x_msg_count,
873: p_data => x_msg_data
874: );

Line 1102: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1098: WHERE resale_line_int_id = p_resale_line_int_rec.resale_line_int_id;
1099: EXCEPTION
1100: WHEN OTHERS THEN
1101: IF OZF_UNEXP_ERROR THEN
1102: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1103: END IF;
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END;
1106:

Line 1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1118: WHEN OTHERS THEN
1119: ROLLBACK TO Update_Line_Calculations;
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1121: IF OZF_UNEXP_ERROR THEN
1122: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1123: END IF;
1124: END Update_Line_Calculations;
1125:
1126: ---------------------------------------------------------------------

Line 1572: FND_MSG_PUB.initialize;

1568: END IF;
1569:
1570: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
1571: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
1572: FND_MSG_PUB.initialize;
1573: END IF;
1574:
1575: -- Debug Message
1576: IF OZF_DEBUG_HIGH_ON THEN

Line 1953: FND_MSG_PUB.Count_And_Get (

1949: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1950: END IF;
1951:
1952: --Standard call to get message count AND IF count=1, get the message
1953: FND_MSG_PUB.Count_And_Get (
1954: p_encoded => FND_API.G_FALSE,
1955: p_count => x_msg_count,
1956: p_data => x_msg_data
1957: );

Line 1962: FND_MSG_PUB.Count_And_Get (

1958: EXCEPTION
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: -- Standard call to get message count AND IF count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (
1963: p_encoded => FND_API.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => x_msg_data
1966: );

Line 1970: FND_MSG_PUB.Count_And_Get (

1966: );
1967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: -- Standard call to get message count AND IF count=1, get the message
1970: FND_MSG_PUB.Count_And_Get (
1971: p_encoded => FND_API.G_FALSE,
1972: p_count => x_msg_count,
1973: p_data => x_msg_data
1974: );

Line 1978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1974: );
1975: WHEN OTHERS THEN
1976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1977: IF OZF_UNEXP_ERROR THEN
1978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1979: END IF;
1980: -- Standard call to get message count AND IF count=1, get the message
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,

Line 1981: FND_MSG_PUB.Count_And_Get (

1977: IF OZF_UNEXP_ERROR THEN
1978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1979: END IF;
1980: -- Standard call to get message count AND IF count=1, get the message
1981: FND_MSG_PUB.Count_And_Get (
1982: p_encoded => FND_API.G_FALSE,
1983: p_count => x_msg_count,
1984: p_data => x_msg_data
1985: );

Line 2068: FND_MSG_PUB.initialize;

2064: END IF;
2065:
2066: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
2067: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
2068: FND_MSG_PUB.initialize;
2069: END IF;
2070:
2071: -- Debug Message
2072: IF OZF_DEBUG_HIGH_ON THEN

Line 2185: FND_MSG_PUB.Count_And_Get (

2181: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2182: END IF;
2183:
2184: --Standard call to get message count AND IF count=1, get the message
2185: FND_MSG_PUB.Count_And_Get (
2186: p_encoded => FND_API.G_FALSE,
2187: p_count => x_msg_count,
2188: p_data => x_msg_data
2189: );

Line 2196: FND_MSG_PUB.Count_And_Get (

2192: WHEN FND_API.G_EXC_ERROR THEN
2193: ROLLBACK TO Update_Duplicates;
2194: x_return_status := FND_API.G_RET_STS_ERROR;
2195: -- Standard call to get message count AND IF count=1, get the message
2196: FND_MSG_PUB.Count_And_Get (
2197: p_encoded => FND_API.G_FALSE,
2198: p_count => x_msg_count,
2199: p_data => x_msg_data
2200: );

Line 2205: FND_MSG_PUB.Count_And_Get (

2201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2202: ROLLBACK TO Update_Duplicates;
2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2204: -- Standard call to get message count AND IF count=1, get the message
2205: FND_MSG_PUB.Count_And_Get (
2206: p_encoded => FND_API.G_FALSE,
2207: p_count => x_msg_count,
2208: p_data => x_msg_data
2209: );

Line 2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2210: WHEN OTHERS THEN
2211: ROLLBACK TO Update_Duplicates;
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: IF OZF_UNEXP_ERROR THEN
2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2215: END IF;
2216: -- Standard call to get message count AND IF count=1, get the message
2217: FND_MSG_PUB.Count_And_Get (
2218: p_encoded => FND_API.G_FALSE,

Line 2217: FND_MSG_PUB.Count_And_Get (

2213: IF OZF_UNEXP_ERROR THEN
2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2215: END IF;
2216: -- Standard call to get message count AND IF count=1, get the message
2217: FND_MSG_PUB.Count_And_Get (
2218: p_encoded => FND_API.G_FALSE,
2219: p_count => x_msg_count,
2220: p_data => x_msg_data
2221: );

Line 2305: FND_MSG_PUB.initialize;

2301: END IF;
2302:
2303: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
2304: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
2305: FND_MSG_PUB.initialize;
2306: END IF;
2307:
2308: -- Debug Message
2309: IF OZF_DEBUG_HIGH_ON THEN

Line 2587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2583: WHERE resale_batch_id = p_resale_batch_id;
2584: EXCEPTION
2585: WHEN OTHERS THEN
2586: IF OZF_UNEXP_ERROR THEN
2587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2588: END IF;
2589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2590: END;
2591: END IF;

Line 2599: FND_MSG_PUB.Count_And_Get (

2595: OZF_UTILITY_PVT.debug_message(l_full_name||': END');
2596: END IF;
2597:
2598: --Standard call to get message count AND IF count=1, get the message
2599: FND_MSG_PUB.Count_And_Get (
2600: p_encoded => FND_API.G_FALSE,
2601: p_count => x_msg_count,
2602: p_data => x_msg_data
2603: );

Line 2609: FND_MSG_PUB.Count_And_Get (

2605: EXCEPTION
2606: WHEN FND_API.G_EXC_ERROR THEN
2607: x_return_status := FND_API.G_RET_STS_ERROR;
2608: -- Standard call to get message count AND IF count=1, get the message
2609: FND_MSG_PUB.Count_And_Get (
2610: p_encoded => FND_API.G_FALSE,
2611: p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );

Line 2617: FND_MSG_PUB.Count_And_Get (

2613: );
2614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2616: -- Standard call to get message count AND IF count=1, get the message
2617: FND_MSG_PUB.Count_And_Get (
2618: p_encoded => FND_API.G_FALSE,
2619: p_count => x_msg_count,
2620: p_data => x_msg_data
2621: );

Line 2625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2621: );
2622: WHEN OTHERS THEN
2623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2624: IF OZF_UNEXP_ERROR THEN
2625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2626: END IF;
2627: -- Standard call to get message count AND IF count=1, get the message
2628: FND_MSG_PUB.Count_And_Get (
2629: p_encoded => FND_API.G_FALSE,

Line 2628: FND_MSG_PUB.Count_And_Get (

2624: IF OZF_UNEXP_ERROR THEN
2625: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2626: END IF;
2627: -- Standard call to get message count AND IF count=1, get the message
2628: FND_MSG_PUB.Count_And_Get (
2629: p_encoded => FND_API.G_FALSE,
2630: p_count => x_msg_count,
2631: p_data => x_msg_data
2632: );

Line 2676: FND_MSG_PUB.initialize;

2672: END IF;
2673:
2674: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
2675: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
2676: FND_MSG_PUB.initialize;
2677: END IF;
2678:
2679: -- Debug Message
2680: IF OZF_DEBUG_HIGH_ON THEN

Line 2730: FND_MSG_PUB.Count_And_Get (

2726: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2727: END IF;
2728:
2729: --Standard call to get message count AND IF count=1, get the message
2730: FND_MSG_PUB.Count_And_Get (
2731: p_encoded => FND_API.G_FALSE,
2732: p_count => x_msg_count,
2733: p_data => x_msg_data
2734: );

Line 2739: FND_MSG_PUB.Count_And_Get (

2735: EXCEPTION
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: -- Standard call to get message count AND IF count=1, get the message
2739: FND_MSG_PUB.Count_And_Get (
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data
2743: );

Line 2747: FND_MSG_PUB.Count_And_Get (

2743: );
2744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2746: -- Standard call to get message count AND IF count=1, get the message
2747: FND_MSG_PUB.Count_And_Get (
2748: p_encoded => FND_API.G_FALSE,
2749: p_count => x_msg_count,
2750: p_data => x_msg_data
2751: );

Line 2755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2751: );
2752: WHEN OTHERS THEN
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754: IF OZF_UNEXP_ERROR THEN
2755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2756: END IF;
2757: -- Standard call to get message count AND IF count=1, get the message
2758: FND_MSG_PUB.Count_And_Get (
2759: p_encoded => FND_API.G_FALSE,

Line 2758: FND_MSG_PUB.Count_And_Get (

2754: IF OZF_UNEXP_ERROR THEN
2755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2756: END IF;
2757: -- Standard call to get message count AND IF count=1, get the message
2758: FND_MSG_PUB.Count_And_Get (
2759: p_encoded => FND_API.G_FALSE,
2760: p_count => x_msg_count,
2761: p_data => x_msg_data
2762: );

Line 3030: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3026: WHEN OTHERS THEN
3027: ROLLBACK TO IDSM_Create_Utiz_Rec;
3028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3029: IF OZF_UNEXP_ERROR THEN
3030: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3031: END IF;
3032: END Create_Utilization_record;
3033:
3034: -- For TPA Parallel Execution ER - 9614703 (+)

Line 3231: FND_MSG_PUB.initialize;

3227: END IF;
3228:
3229: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3230: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
3231: FND_MSG_PUB.initialize;
3232: END IF;
3233:
3234: -- Debug Message
3235: IF OZF_DEBUG_HIGH_ON THEN

Line 3325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3321: --
3322: EXCEPTION
3323: WHEN OTHERS THEN
3324: IF OZF_UNEXP_ERROR THEN
3325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3326: END IF;
3327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3328: END;
3329:

Line 3413: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3409:
3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: IF OZF_UNEXP_ERROR THEN
3413: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3414: END IF;
3415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3416: END;
3417: END IF;

Line 3425: FND_MSG_PUB.Count_And_Get (

3421: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3422: END IF;
3423:
3424: --Standard call to get message count AND IF count=1, get the message
3425: FND_MSG_PUB.Count_And_Get (
3426: p_encoded => FND_API.G_FALSE,
3427: p_count => x_msg_count,
3428: p_data => x_msg_data
3429: );

Line 3435: FND_MSG_PUB.Count_And_Get (

3431: WHEN FND_API.G_EXC_ERROR THEN
3432: ROLLBACK TO Create_Adj_And_Utilization;
3433: x_return_status := FND_API.G_RET_STS_ERROR;
3434: -- Standard call to get message count AND IF count=1, get the message
3435: FND_MSG_PUB.Count_And_Get (
3436: p_encoded => FND_API.G_FALSE,
3437: p_count => x_msg_count,
3438: p_data => x_msg_data
3439: );

Line 3444: FND_MSG_PUB.Count_And_Get (

3440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3441: ROLLBACK TO Create_Adj_And_Utilization;
3442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3443: -- Standard call to get message count AND IF count=1, get the message
3444: FND_MSG_PUB.Count_And_Get (
3445: p_encoded => FND_API.G_FALSE,
3446: p_count => x_msg_count,
3447: p_data => x_msg_data
3448: );

Line 3453: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3449: WHEN OTHERS THEN
3450: ROLLBACK TO Create_Adj_And_Utilization;
3451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452: IF OZF_UNEXP_ERROR THEN
3453: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3454: END IF;
3455: -- Standard call to get message count AND IF count=1, get the message
3456: FND_MSG_PUB.Count_And_Get (
3457: p_encoded => FND_API.G_FALSE,

Line 3456: FND_MSG_PUB.Count_And_Get (

3452: IF OZF_UNEXP_ERROR THEN
3453: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3454: END IF;
3455: -- Standard call to get message count AND IF count=1, get the message
3456: FND_MSG_PUB.Count_And_Get (
3457: p_encoded => FND_API.G_FALSE,
3458: p_count => x_msg_count,
3459: p_data => x_msg_data
3460: );

Line 3704: FND_MSG_PUB.initialize;

3700: END IF;
3701:
3702: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3703: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
3704: FND_MSG_PUB.initialize;
3705: END IF;
3706:
3707: -- Debug Message
3708: IF OZF_DEBUG_HIGH_ON THEN

Line 3989: FND_MSG_PUB.Count_And_Get (

3985: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3986: END IF;
3987:
3988: --Standard call to get message count AND IF count=1, get the message
3989: FND_MSG_PUB.Count_And_Get (
3990: p_encoded => FND_API.G_FALSE,
3991: p_count => x_msg_count,
3992: p_data => x_msg_data
3993: );

Line 3999: FND_MSG_PUB.Count_And_Get (

3995: WHEN FND_API.G_EXC_ERROR THEN
3996: ROLLBACK TO IDSM_Create_Utilization;
3997: x_return_status := FND_API.G_RET_STS_ERROR;
3998: -- Standard call to get message count AND IF count=1, get the message
3999: FND_MSG_PUB.Count_And_Get (
4000: p_encoded => FND_API.G_FALSE,
4001: p_count => x_msg_count,
4002: p_data => x_msg_data
4003: );

Line 4008: FND_MSG_PUB.Count_And_Get (

4004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4005: ROLLBACK TO IDSM_Create_Utilization;
4006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4007: -- Standard call to get message count AND IF count=1, get the message
4008: FND_MSG_PUB.Count_And_Get (
4009: p_encoded => FND_API.G_FALSE,
4010: p_count => x_msg_count,
4011: p_data => x_msg_data
4012: );

Line 4017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4013: WHEN OTHERS THEN
4014: ROLLBACK TO IDSM_Create_Utilization;
4015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4016: IF OZF_UNEXP_ERROR THEN
4017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4018: END IF;
4019: -- Standard call to get message count AND IF count=1, get the message
4020: FND_MSG_PUB.Count_And_Get (
4021: p_encoded => FND_API.G_FALSE,

Line 4020: FND_MSG_PUB.Count_And_Get (

4016: IF OZF_UNEXP_ERROR THEN
4017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4018: END IF;
4019: -- Standard call to get message count AND IF count=1, get the message
4020: FND_MSG_PUB.Count_And_Get (
4021: p_encoded => FND_API.G_FALSE,
4022: p_count => x_msg_count,
4023: p_data => x_msg_data
4024: );

Line 4108: FND_MSG_PUB.initialize;

4104: END IF;
4105:
4106: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4107: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4108: FND_MSG_PUB.initialize;
4109: END IF;
4110:
4111: -- Initialize API return status to sucess
4112: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4215: FND_MSG_PUB.Count_And_Get (

4211: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4212: END IF;
4213:
4214: --Standard call to get message count AND IF count=1, get the message
4215: FND_MSG_PUB.Count_And_Get (
4216: p_encoded => FND_API.G_FALSE,
4217: p_count => x_msg_count,
4218: p_data => x_msg_data
4219: );

Line 4225: FND_MSG_PUB.Count_And_Get (

4221: WHEN FND_API.G_EXC_ERROR THEN
4222: ROLLBACK TO Create_Sales_Transaction;
4223: x_return_status := FND_API.G_RET_STS_ERROR;
4224: -- Standard call to get message count AND IF count=1, get the message
4225: FND_MSG_PUB.Count_And_Get (
4226: p_encoded => FND_API.G_FALSE,
4227: p_count => x_msg_count,
4228: p_data => x_msg_data
4229: );

Line 4234: FND_MSG_PUB.Count_And_Get (

4230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4231: ROLLBACK TO Create_Sales_Transaction;
4232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4233: -- Standard call to get message count AND IF count=1, get the message
4234: FND_MSG_PUB.Count_And_Get (
4235: p_encoded => FND_API.G_FALSE,
4236: p_count => x_msg_count,
4237: p_data => x_msg_data
4238: );

Line 4243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4239: WHEN OTHERS THEN
4240: ROLLBACK TO Create_Sales_Transaction;
4241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4242: IF OZF_UNEXP_ERROR THEN
4243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4244: END IF;
4245: -- Standard call to get message count AND IF count=1, get the message
4246: FND_MSG_PUB.Count_And_Get (
4247: p_encoded => FND_API.G_FALSE,

Line 4246: FND_MSG_PUB.Count_And_Get (

4242: IF OZF_UNEXP_ERROR THEN
4243: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4244: END IF;
4245: -- Standard call to get message count AND IF count=1, get the message
4246: FND_MSG_PUB.Count_And_Get (
4247: p_encoded => FND_API.G_FALSE,
4248: p_count => x_msg_count,
4249: p_data => x_msg_data
4250: );

Line 4311: FND_MSG_PUB.initialize;

4307: END IF;
4308:
4309: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4310: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4311: FND_MSG_PUB.initialize;
4312: END IF;
4313:
4314: -- Initialize API return status to sucess
4315: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4426: FND_MSG_PUB.Count_And_Get (

4422: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4423: END IF;
4424:
4425: --Standard call to get message count AND IF count=1, get the message
4426: FND_MSG_PUB.Count_And_Get (
4427: p_encoded => FND_API.G_FALSE,
4428: p_count => x_msg_count,
4429: p_data => x_msg_data
4430: );

Line 4436: FND_MSG_PUB.Count_And_Get (

4432: WHEN FND_API.G_EXC_ERROR THEN
4433: ROLLBACK TO Insert_Resale_Header;
4434: x_return_status := FND_API.G_RET_STS_ERROR;
4435: -- Standard call to get message count AND IF count=1, get the message
4436: FND_MSG_PUB.Count_And_Get (
4437: p_encoded => FND_API.G_FALSE,
4438: p_count => x_msg_count,
4439: p_data => x_msg_data
4440: );

Line 4445: FND_MSG_PUB.Count_And_Get (

4441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4442: ROLLBACK TO Insert_Resale_Header;
4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4444: -- Standard call to get message count AND IF count=1, get the message
4445: FND_MSG_PUB.Count_And_Get (
4446: p_encoded => FND_API.G_FALSE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data
4449: );

Line 4454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4450: WHEN OTHERS THEN
4451: ROLLBACK TO Insert_Resale_Header;
4452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4453: IF OZF_UNEXP_ERROR THEN
4454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4455: END IF;
4456: -- Standard call to get message count AND IF count=1, get the message
4457: FND_MSG_PUB.Count_And_Get (
4458: p_encoded => FND_API.G_FALSE,

Line 4457: FND_MSG_PUB.Count_And_Get (

4453: IF OZF_UNEXP_ERROR THEN
4454: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4455: END IF;
4456: -- Standard call to get message count AND IF count=1, get the message
4457: FND_MSG_PUB.Count_And_Get (
4458: p_encoded => FND_API.G_FALSE,
4459: p_count => x_msg_count,
4460: p_data => x_msg_data
4461: );

Line 4524: FND_MSG_PUB.initialize;

4520: END IF;
4521:
4522: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4523: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4524: FND_MSG_PUB.initialize;
4525: END IF;
4526:
4527: -- Initialize API return status to sucess
4528: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4745: FND_MSG_PUB.Count_And_Get (

4741: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4742: END IF;
4743:
4744: --Standard call to get message count AND IF count=1, get the message
4745: FND_MSG_PUB.Count_And_Get (
4746: p_encoded => FND_API.G_FALSE,
4747: p_count => x_msg_count,
4748: p_data => x_msg_data
4749: );

Line 4756: FND_MSG_PUB.Count_And_Get (

4752: WHEN FND_API.G_EXC_ERROR THEN
4753: ROLLBACK TO Insert_Resale_Line;
4754: x_return_status := FND_API.G_RET_STS_ERROR;
4755: -- Standard call to get message count AND IF count=1, get the message
4756: FND_MSG_PUB.Count_And_Get (
4757: p_encoded => FND_API.G_FALSE,
4758: p_count => x_msg_count,
4759: p_data => x_msg_data
4760: );

Line 4765: FND_MSG_PUB.Count_And_Get (

4761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4762: ROLLBACK TO Insert_Resale_Line;
4763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4764: -- Standard call to get message count AND IF count=1, get the message
4765: FND_MSG_PUB.Count_And_Get (
4766: p_encoded => FND_API.G_FALSE,
4767: p_count => x_msg_count,
4768: p_data => x_msg_data
4769: );

Line 4774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4770: WHEN OTHERS THEN
4771: ROLLBACK TO Insert_Resale_Line;
4772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4773: IF OZF_UNEXP_ERROR THEN
4774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4775: END IF;
4776: -- Standard call to get message count AND IF count=1, get the message
4777: FND_MSG_PUB.Count_And_Get (
4778: p_encoded => FND_API.G_FALSE,

Line 4777: FND_MSG_PUB.Count_And_Get (

4773: IF OZF_UNEXP_ERROR THEN
4774: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4775: END IF;
4776: -- Standard call to get message count AND IF count=1, get the message
4777: FND_MSG_PUB.Count_And_Get (
4778: p_encoded => FND_API.G_FALSE,
4779: p_count => x_msg_count,
4780: p_data => x_msg_data
4781: );

Line 4842: FND_MSG_PUB.initialize;

4838: END IF;
4839:
4840: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4841: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4842: FND_MSG_PUB.initialize;
4843: END IF;
4844:
4845: -- Initialize API return status to sucess
4846: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4902: FND_MSG_PUB.Count_And_Get (

4898: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4899: END IF;
4900:
4901: --Standard call to get message count AND IF count=1, get the message
4902: FND_MSG_PUB.Count_And_Get (
4903: p_encoded => FND_API.G_FALSE,
4904: p_count => x_msg_count,
4905: p_data => x_msg_data
4906: );

Line 4912: FND_MSG_PUB.Count_And_Get (

4908: WHEN FND_API.G_EXC_ERROR THEN
4909: ROLLBACK TO Insert_Resale_Line_Mapping;
4910: x_return_status := FND_API.G_RET_STS_ERROR;
4911: -- Standard call to get message count AND IF count=1, get the message
4912: FND_MSG_PUB.Count_And_Get (
4913: p_encoded => FND_API.G_FALSE,
4914: p_count => x_msg_count,
4915: p_data => x_msg_data
4916: );

Line 4921: FND_MSG_PUB.Count_And_Get (

4917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4918: ROLLBACK TO Insert_Resale_Line_Mapping;
4919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4920: -- Standard call to get message count AND IF count=1, get the message
4921: FND_MSG_PUB.Count_And_Get (
4922: p_encoded => FND_API.G_FALSE,
4923: p_count => x_msg_count,
4924: p_data => x_msg_data
4925: );

Line 4930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4926: WHEN OTHERS THEN
4927: ROLLBACK TO Insert_Resale_Line_Mapping;
4928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4929: IF OZF_UNEXP_ERROR THEN
4930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4931: END IF;
4932: -- Standard call to get message count AND IF count=1, get the message
4933: FND_MSG_PUB.Count_And_Get (
4934: p_encoded => FND_API.G_FALSE,

Line 4933: FND_MSG_PUB.Count_And_Get (

4929: IF OZF_UNEXP_ERROR THEN
4930: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4931: END IF;
4932: -- Standard call to get message count AND IF count=1, get the message
4933: FND_MSG_PUB.Count_And_Get (
4934: p_encoded => FND_API.G_FALSE,
4935: p_count => x_msg_count,
4936: p_data => x_msg_data
4937: );

Line 4992: FND_MSG_PUB.initialize;

4988: END IF;
4989:
4990: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4991: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
4992: FND_MSG_PUB.initialize;
4993: END IF;
4994:
4995: -- Initialize API return status to sucess
4996: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5019: FND_MSG_PUB.Count_And_Get (

5015: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5016: END IF;
5017:
5018: --Standard call to get message count AND IF count=1, get the message
5019: FND_MSG_PUB.Count_And_Get (
5020: p_encoded => FND_API.G_FALSE,
5021: p_count => x_msg_count,
5022: p_data => x_msg_data
5023: );

Line 5029: FND_MSG_PUB.Count_And_Get (

5025: WHEN FND_API.G_EXC_ERROR THEN
5026: ROLLBACK TO Delete_Log;
5027: x_return_status := FND_API.G_RET_STS_ERROR;
5028: -- Standard call to get message count AND IF count=1, get the message
5029: FND_MSG_PUB.Count_And_Get (
5030: p_encoded => FND_API.G_FALSE,
5031: p_count => x_msg_count,
5032: p_data => x_msg_data
5033: );

Line 5038: FND_MSG_PUB.Count_And_Get (

5034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5035: ROLLBACK TO Delete_Log;
5036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5037: -- Standard call to get message count AND IF count=1, get the message
5038: FND_MSG_PUB.Count_And_Get (
5039: p_encoded => FND_API.G_FALSE,
5040: p_count => x_msg_count,
5041: p_data => x_msg_data
5042: );

Line 5047: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

5043: WHEN OTHERS THEN
5044: ROLLBACK TO Delete_Log;
5045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5046: IF OZF_UNEXP_ERROR THEN
5047: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5048: END IF;
5049: -- Standard call to get message count AND IF count=1, get the message
5050: FND_MSG_PUB.Count_And_Get (
5051: p_encoded => FND_API.G_FALSE,

Line 5050: FND_MSG_PUB.Count_And_Get (

5046: IF OZF_UNEXP_ERROR THEN
5047: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5048: END IF;
5049: -- Standard call to get message count AND IF count=1, get the message
5050: FND_MSG_PUB.Count_And_Get (
5051: p_encoded => FND_API.G_FALSE,
5052: p_count => x_msg_count,
5053: p_data => x_msg_data
5054: );

Line 5119: FND_MSG_PUB.initialize;

5115: END IF;
5116:
5117: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
5118: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
5119: FND_MSG_PUB.initialize;
5120: END IF;
5121:
5122: -- Debug Message
5123: IF OZF_DEBUG_HIGH_ON THEN

Line 5309: FND_MSG_PUB.Count_And_Get (

5305: IF OZF_DEBUG_HIGH_ON THEN
5306: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5307: END IF;
5308: --Standard call to get message count AND IF count=1, get the message
5309: FND_MSG_PUB.Count_And_Get (
5310: p_encoded => FND_API.G_FALSE,
5311: p_count => x_msg_count,
5312: p_data => x_msg_data);
5313:

Line 5318: FND_MSG_PUB.Count_And_Get (

5314: EXCEPTION
5315: WHEN FND_API.G_EXC_ERROR THEN
5316: x_return_status := FND_API.G_RET_STS_ERROR;
5317: -- Standard call to get message count and if count=1, get the message
5318: FND_MSG_PUB.Count_And_Get (
5319: p_encoded => FND_API.G_FALSE,
5320: p_count => x_msg_count,
5321: p_data => x_msg_data
5322: );

Line 5326: FND_MSG_PUB.Count_And_Get (

5322: );
5323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5325: -- Standard call to get message count and if count=1, get the message
5326: FND_MSG_PUB.Count_And_Get (
5327: p_encoded => FND_API.G_FALSE,
5328: p_count => x_msg_count,
5329: p_data => x_msg_data
5330: );

Line 5335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5331: WHEN OTHERS THEN
5332: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
5333:
5334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5336: THEN
5337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5338: END IF;
5339: -- Standard call to get message count and if count=1, get the message

Line 5337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

5333:
5334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5335: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5336: THEN
5337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5338: END IF;
5339: -- Standard call to get message count and if count=1, get the message
5340: FND_MSG_PUB.Count_And_Get (
5341: p_encoded => FND_API.G_FALSE,

Line 5340: FND_MSG_PUB.Count_And_Get (

5336: THEN
5337: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5338: END IF;
5339: -- Standard call to get message count and if count=1, get the message
5340: FND_MSG_PUB.Count_And_Get (
5341: p_encoded => FND_API.G_FALSE,
5342: p_count => x_msg_count,
5343: p_data => x_msg_data
5344: );

Line 5401: FND_MSG_PUB.initialize;

5397: END IF;
5398:
5399: --Initialize message list if p_init_msg_list is TRUE.
5400: IF FND_API.To_Boolean (p_init_msg_list) THEN
5401: FND_MSG_PUB.initialize;
5402: END IF;
5403:
5404: x_return_status := FND_API.G_RET_STS_SUCCESS;
5405:

Line 5408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

5404: x_return_status := FND_API.G_RET_STS_SUCCESS;
5405:
5406: IF p_caller_type = 'IFACE' AND
5407: p_resale_line_int_rec.resale_line_int_id IS NULL THEN
5408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5409: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_INT_RECD_NULL');
5410: FND_MSG_PUB.add;
5411: END IF;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5410: FND_MSG_PUB.add;

5406: IF p_caller_type = 'IFACE' AND
5407: p_resale_line_int_rec.resale_line_int_id IS NULL THEN
5408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5409: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_INT_RECD_NULL');
5410: FND_MSG_PUB.add;
5411: END IF;
5412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5413: END IF;
5414:

Line 5417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

5413: END IF;
5414:
5415: IF p_caller_type = 'RESALE' AND
5416: p_resale_line_rec.resale_line_id IS NULL THEN
5417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5418: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_RECD_NULL');
5419: FND_MSG_PUB.add;
5420: END IF;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5419: FND_MSG_PUB.add;

5415: IF p_caller_type = 'RESALE' AND
5416: p_resale_line_rec.resale_line_id IS NULL THEN
5417: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5418: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_RECD_NULL');
5419: FND_MSG_PUB.add;
5420: END IF;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: END IF;
5423:

Line 5548: FND_MSG_PUB.Count_And_Get (

5544: OZF_ORDER_PRICE_PVT.G_RESALE_LINE_REC.line_attribute15 := p_resale_line_rec.line_attribute15;
5545: END IF;
5546:
5547:
5548: FND_MSG_PUB.Count_And_Get (
5549: p_encoded => FND_API.G_FALSE,
5550: p_count => x_msg_count,
5551: p_data => x_msg_data
5552: );

Line 5561: FND_MSG_PUB.Count_And_Get (

5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: x_return_status := FND_API.G_RET_STS_ERROR;
5561: FND_MSG_PUB.Count_And_Get (
5562: p_encoded => FND_API.G_FALSE,
5563: p_count => x_msg_count,
5564: p_data => x_msg_data
5565: );

Line 5568: FND_MSG_PUB.Count_And_Get (

5564: p_data => x_msg_data
5565: );
5566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5568: FND_MSG_PUB.Count_And_Get (
5569: p_encoded => FND_API.G_FALSE,
5570: p_count => x_msg_count,
5571: p_data => x_msg_data
5572: );

Line 5575: FND_MSG_PUB.Count_And_Get (

5571: p_data => x_msg_data
5572: );
5573: WHEN OTHERS THEN
5574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5575: FND_MSG_PUB.Count_And_Get (
5576: p_encoded => FND_API.G_FALSE,
5577: p_count => x_msg_count,
5578: p_data => x_msg_data
5579: );

Line 5635: FND_MSG_PUB.initialize;

5631: END IF;
5632:
5633: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
5634: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
5635: FND_MSG_PUB.initialize;
5636: END IF;
5637:
5638: -- Debug Message
5639: IF OZF_DEBUG_HIGH_ON THEN

Line 5702: FND_MSG_PUB.Count_And_Get (

5698: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5699: END IF;
5700:
5701: --Standard call to get message count AND IF count=1, get the message
5702: FND_MSG_PUB.Count_And_Get (
5703: p_encoded => FND_API.G_FALSE,
5704: p_count => x_msg_count,
5705: p_data => x_msg_data);
5706:

Line 5712: FND_MSG_PUB.Count_And_Get (

5708: WHEN FND_API.G_EXC_ERROR THEN
5709: ROLLBACK TO Derive_Orig_Parties;
5710: x_return_status := FND_API.G_RET_STS_ERROR;
5711: -- Standard call to get message count and if count=1, get the message
5712: FND_MSG_PUB.Count_And_Get (
5713: p_encoded => FND_API.G_FALSE,
5714: p_count => x_msg_count,
5715: p_data => x_msg_data
5716: );

Line 5721: FND_MSG_PUB.Count_And_Get (

5717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5718: ROLLBACK TO Derive_Orig_Parties;
5719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5720: -- Standard call to get message count and if count=1, get the message
5721: FND_MSG_PUB.Count_And_Get (
5722: p_encoded => FND_API.G_FALSE,
5723: p_count => x_msg_count,
5724: p_data => x_msg_data
5725: );

Line 5732: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5728: IF OZF_DEBUG_LOW_ON THEN
5729: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
5730: END IF;
5731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5732: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5733: THEN
5734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5735: END IF;
5736: -- Standard call to get message count and if count=1, get the message

Line 5734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

5730: END IF;
5731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5732: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5733: THEN
5734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5735: END IF;
5736: -- Standard call to get message count and if count=1, get the message
5737: FND_MSG_PUB.Count_And_Get (
5738: p_encoded => FND_API.G_FALSE,

Line 5737: FND_MSG_PUB.Count_And_Get (

5733: THEN
5734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5735: END IF;
5736: -- Standard call to get message count and if count=1, get the message
5737: FND_MSG_PUB.Count_And_Get (
5738: p_encoded => FND_API.G_FALSE,
5739: p_count => x_msg_count,
5740: p_data => x_msg_data
5741: );

Line 5847: FND_MSG_PUB.initialize;

5843: END IF;
5844:
5845: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
5846: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
5847: FND_MSG_PUB.initialize;
5848: END IF;
5849:
5850: -- Debug Message
5851: IF OZF_DEBUG_HIGH_ON THEN

Line 5933: FND_MSG_PUB.Count_And_Get (

5929: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
5930: END IF;
5931:
5932: --Standard call to get message count AND IF count=1, get the message
5933: FND_MSG_PUB.Count_And_Get (
5934: p_encoded => FND_API.G_FALSE,
5935: p_count => x_msg_count,
5936: p_data => x_msg_data);
5937:

Line 5943: FND_MSG_PUB.Count_And_Get (

5939: WHEN FND_API.G_EXC_ERROR THEN
5940: ROLLBACK TO Derive_Bill_To_Party;
5941: x_return_status := FND_API.G_RET_STS_ERROR;
5942: -- Standard call to get message count and if count=1, get the message
5943: FND_MSG_PUB.Count_And_Get (
5944: p_encoded => FND_API.G_FALSE,
5945: p_count => x_msg_count,
5946: p_data => x_msg_data
5947: );

Line 5952: FND_MSG_PUB.Count_And_Get (

5948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5949: ROLLBACK TO Derive_Bill_To_Party;
5950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5951: -- Standard call to get message count and if count=1, get the message
5952: FND_MSG_PUB.Count_And_Get (
5953: p_encoded => FND_API.G_FALSE,
5954: p_count => x_msg_count,
5955: p_data => x_msg_data
5956: );

Line 5963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5959: IF OZF_DEBUG_LOW_ON THEN
5960: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
5961: END IF;
5962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5964: THEN
5965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5966: END IF;
5967: -- Standard call to get message count and if count=1, get the message

Line 5965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

5961: END IF;
5962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5963: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5964: THEN
5965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5966: END IF;
5967: -- Standard call to get message count and if count=1, get the message
5968: FND_MSG_PUB.Count_And_Get (
5969: p_encoded => FND_API.G_FALSE,

Line 5968: FND_MSG_PUB.Count_And_Get (

5964: THEN
5965: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5966: END IF;
5967: -- Standard call to get message count and if count=1, get the message
5968: FND_MSG_PUB.Count_And_Get (
5969: p_encoded => FND_API.G_FALSE,
5970: p_count => x_msg_count,
5971: p_data => x_msg_data
5972: );

Line 6121: FND_MSG_PUB.initialize;

6117: END IF;
6118:
6119: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
6120: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
6121: FND_MSG_PUB.initialize;
6122:
6123: END IF;
6124: -- Debug Message
6125: IF OZF_DEBUG_HIGH_ON THEN

Line 6245: FND_MSG_PUB.Count_And_Get (

6241: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
6242: END IF;
6243:
6244: --Standard call to get message count AND IF count=1, get the message
6245: FND_MSG_PUB.Count_And_Get (
6246: p_encoded => FND_API.G_FALSE,
6247: p_count => x_msg_count,
6248: p_data => x_msg_data);
6249:

Line 6255: FND_MSG_PUB.Count_And_Get (

6251: WHEN FND_API.G_EXC_ERROR THEN
6252: ROLLBACK TO Derive_Ship_To_Party;
6253: x_return_status := FND_API.G_RET_STS_ERROR;
6254: -- Standard call to get message count and if count=1, get the message
6255: FND_MSG_PUB.Count_And_Get (
6256: p_encoded => FND_API.G_FALSE,
6257: p_count => x_msg_count,
6258: p_data => x_msg_data
6259: );

Line 6264: FND_MSG_PUB.Count_And_Get (

6260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6261: ROLLBACK TO Derive_Ship_To_Party;
6262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6263: -- Standard call to get message count and if count=1, get the message
6264: FND_MSG_PUB.Count_And_Get (
6265: p_encoded => FND_API.G_FALSE,
6266: p_count => x_msg_count,
6267: p_data => x_msg_data
6268: );

Line 6275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6271: IF OZF_DEBUG_LOW_ON THEN
6272: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
6273: END IF;
6274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6276: THEN
6277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6278: END IF;
6279: -- Standard call to get message count and if count=1, get the message

Line 6277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

6273: END IF;
6274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6276: THEN
6277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6278: END IF;
6279: -- Standard call to get message count and if count=1, get the message
6280: FND_MSG_PUB.Count_And_Get (
6281: p_encoded => FND_API.G_FALSE,

Line 6280: FND_MSG_PUB.Count_And_Get (

6276: THEN
6277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6278: END IF;
6279: -- Standard call to get message count and if count=1, get the message
6280: FND_MSG_PUB.Count_And_Get (
6281: p_encoded => FND_API.G_FALSE,
6282: p_count => x_msg_count,
6283: p_data => x_msg_data
6284: );

Line 6389: FND_MSG_PUB.initialize;

6385: END IF;
6386:
6387: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
6388: IF FND_API.To_Boolean (p_init_msg_LIST) THEN
6389: FND_MSG_PUB.initialize;
6390: END IF;
6391:
6392: -- Debug Message
6393: IF OZF_DEBUG_HIGH_ON THEN

Line 6475: FND_MSG_PUB.Count_And_Get (

6471: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
6472: END IF;
6473:
6474: --Standard call to get message count AND IF count=1, get the message
6475: FND_MSG_PUB.Count_And_Get (
6476: p_encoded => FND_API.G_FALSE,
6477: p_count => x_msg_count,
6478: p_data => x_msg_data);
6479:

Line 6485: FND_MSG_PUB.Count_And_Get (

6481: WHEN FND_API.G_EXC_ERROR THEN
6482: ROLLBACK TO Derive_End_Cust_Party;
6483: x_return_status := FND_API.G_RET_STS_ERROR;
6484: -- Standard call to get message count and if count=1, get the message
6485: FND_MSG_PUB.Count_And_Get (
6486: p_encoded => FND_API.G_FALSE,
6487: p_count => x_msg_count,
6488: p_data => x_msg_data
6489: );

Line 6494: FND_MSG_PUB.Count_And_Get (

6490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6491: ROLLBACK TO Derive_End_Cust_Party;
6492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6493: -- Standard call to get message count and if count=1, get the message
6494: FND_MSG_PUB.Count_And_Get (
6495: p_encoded => FND_API.G_FALSE,
6496: p_count => x_msg_count,
6497: p_data => x_msg_data
6498: );

Line 6505: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6501: IF OZF_DEBUG_LOW_ON THEN
6502: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
6503: END IF;
6504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6505: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6506: THEN
6507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6508: END IF;
6509: -- Standard call to get message count and if count=1, get the message

Line 6507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

6503: END IF;
6504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6505: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6506: THEN
6507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6508: END IF;
6509: -- Standard call to get message count and if count=1, get the message
6510: FND_MSG_PUB.Count_And_Get (
6511: p_encoded => FND_API.G_FALSE,

Line 6510: FND_MSG_PUB.Count_And_Get (

6506: THEN
6507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
6508: END IF;
6509: -- Standard call to get message count and if count=1, get the message
6510: FND_MSG_PUB.Count_And_Get (
6511: p_encoded => FND_API.G_FALSE,
6512: p_count => x_msg_count,
6513: p_data => x_msg_data
6514: );

Line 7887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

7883: WHEN OTHERS THEN
7884: ROLLBACK TO update_main_tables;
7885: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7886: IF OZF_UNEXP_ERROR THEN
7887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
7888: END IF;
7889: ozf_utility_pvt.write_conc_log('Concurrent Program updating records to main tables failed');
7890: ozf_utility_pvt.write_conc_log('l_return_status := '||l_return_status);
7891: OZF_UTILITY_PVT.Write_Conc_Log;

Line 7972: FND_MSG_PUB.Add;

7968: -- Debug Message
7969: IF OZF_DEBUG_LOW_ON THEN
7970: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7971: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
7972: FND_MSG_PUB.Add;
7973: END IF;
7974:
7975: -- Initialize API return status to sucess
7976: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

7987: FETCH csr_get_sys_params INTO l_fc_currency_code,l_exchange_rate_type;
7988: CLOSE csr_get_sys_params;
7989:
7990: IF l_fc_currency_code IS NULL THEN
7991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7992: FND_MESSAGE.set_name('OZF', 'OZF_METR_INVALID_FUNC_CUR');
7993: --//Functional currency does not exist. Please enter another currency.
7994: FND_MSG_PUB.add;
7995: END IF;

Line 7994: FND_MSG_PUB.add;

7990: IF l_fc_currency_code IS NULL THEN
7991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
7992: FND_MESSAGE.set_name('OZF', 'OZF_METR_INVALID_FUNC_CUR');
7993: --//Functional currency does not exist. Please enter another currency.
7994: FND_MSG_PUB.add;
7995: END IF;
7996: p_resale_line_int_rec.dispute_code := 'OZF_METR_INVALID_FUNC_CUR';
7997: RAISE FND_API.G_EXC_ERROR;
7998: END IF;

Line 8005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

8001: ELSIF p_resale_line_int_rec.exchange_rate_type IS NOT NULL AND l_exchange_rate_type <> p_resale_line_int_rec.exchange_rate_type THEN
8002: l_exchange_rate_type := p_resale_line_int_rec.exchange_rate_type ;
8003: END IF;
8004: IF l_exchange_rate_type IS NULL THEN
8005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
8006: FND_MESSAGE.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
8007: --//System Error: Exchange rate not setup.
8008: FND_MSG_PUB.add;
8009: END IF;

Line 8008: FND_MSG_PUB.add;

8004: IF l_exchange_rate_type IS NULL THEN
8005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
8006: FND_MESSAGE.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
8007: --//System Error: Exchange rate not setup.
8008: FND_MSG_PUB.add;
8009: END IF;
8010: p_resale_line_int_rec.dispute_code := 'OZF_NO_EXCHANGE_TYPE';
8011: RAISE FND_API.G_EXC_ERROR;
8012: END IF;

Line 8115: FND_MSG_PUB.Add;

8111: -- Debug Message
8112: IF OZF_DEBUG_LOW_ON THEN
8113: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
8114: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
8115: FND_MSG_PUB.Add;
8116: END IF;
8117: --Standard call to get message count and if count=1, get the message
8118: FND_MSG_PUB.Count_And_Get (
8119: p_encoded => FND_API.G_FALSE,

Line 8118: FND_MSG_PUB.Count_And_Get (

8114: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
8115: FND_MSG_PUB.Add;
8116: END IF;
8117: --Standard call to get message count and if count=1, get the message
8118: FND_MSG_PUB.Count_And_Get (
8119: p_encoded => FND_API.G_FALSE,
8120: p_count => x_msg_count,
8121: p_data => x_msg_data
8122: );

Line 8129: FND_MSG_PUB.Count_And_Get (

8125: ozf_utility_pvt.write_conc_log('ERROR in Create Draft Utilization: '|| SQLERRM);
8126: ROLLBACK TO Create_Draft_Utilization;
8127: x_return_status := FND_API.G_RET_STS_ERROR;
8128: -- Standard call to get message count and if count=1, get the message
8129: FND_MSG_PUB.Count_And_Get (
8130: p_encoded => FND_API.G_FALSE,
8131: p_count => x_msg_count,
8132: p_data => x_msg_data
8133: );

Line 8139: FND_MSG_PUB.Count_And_Get (

8135: ozf_utility_pvt.write_conc_log('UNEXPECTED ERROR in Create Draft Utilization: '|| SQLERRM);
8136: ROLLBACK TO Create_Draft_Utilization;
8137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8138: -- Standard call to get message count and if count=1, get the message
8139: FND_MSG_PUB.Count_And_Get (
8140: p_encoded => FND_API.G_FALSE,
8141: p_count => x_msg_count,
8142: p_data => x_msg_data
8143: );

Line 8148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8144: WHEN OTHERS THEN
8145: ozf_utility_pvt.write_conc_log('OTHER ERROR in Create Draft Utilization: '|| SQLERRM);
8146: ROLLBACK TO Create_Draft_Utilization;
8147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8149: THEN
8150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8151: END IF;
8152: -- Standard call to get message count and if count=1, get the message

Line 8150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

8146: ROLLBACK TO Create_Draft_Utilization;
8147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8149: THEN
8150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8151: END IF;
8152: -- Standard call to get message count and if count=1, get the message
8153: FND_MSG_PUB.Count_And_Get (
8154: p_encoded => FND_API.G_FALSE,

Line 8153: FND_MSG_PUB.Count_And_Get (

8149: THEN
8150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
8151: END IF;
8152: -- Standard call to get message count and if count=1, get the message
8153: FND_MSG_PUB.Count_And_Get (
8154: p_encoded => FND_API.G_FALSE,
8155: p_count => x_msg_count,
8156: p_data => x_msg_data
8157: );