DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on FND_MESSAGE

Line 130: -- The message gets set previously with FND_MESSAGE.SET_NAME,

126: -- log_message
127: --
128: -- PURPOSE
129: -- Writes a message to the log file if this level and module is enabled
130: -- The message gets set previously with FND_MESSAGE.SET_NAME,
131: -- SET_TOKEN, etc.
132: -- The message is popped off the message dictionary stack, if POP_MESSAGE
133: -- is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
134: -- displayed to the user later.

Line 136: -- FND_MESSAGE.SET_NAME(...); -- Set message

132: -- The message is popped off the message dictionary stack, if POP_MESSAGE
133: -- is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
134: -- displayed to the user later.
135: -- Example usage:
136: -- FND_MESSAGE.SET_NAME(...); -- Set message
137: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message
138: -- FND_LOG.MESSAGE(..., FALSE); -- Log message
139: -- FND_MESSAGE.ERROR; -- Display message
140: --

Line 137: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message

133: -- is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
134: -- displayed to the user later.
135: -- Example usage:
136: -- FND_MESSAGE.SET_NAME(...); -- Set message
137: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message
138: -- FND_LOG.MESSAGE(..., FALSE); -- Log message
139: -- FND_MESSAGE.ERROR; -- Display message
140: --
141: -- HISTORY

Line 139: -- FND_MESSAGE.ERROR; -- Display message

135: -- Example usage:
136: -- FND_MESSAGE.SET_NAME(...); -- Set message
137: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message
138: -- FND_LOG.MESSAGE(..., FALSE); -- Log message
139: -- FND_MESSAGE.ERROR; -- Display message
140: --
141: -- HISTORY
142: -- 01-Oct-2003 huili Create.
143: --======================================================================

Line 154: FND_MESSAGE.SET_TOKEN(G_RCS_ID, p_RCS_ID);

150: BEGIN
151: IF ( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.MESSAGE(p_log_level, p_module_name, p_pop_message);
153: IF p_RCS_ID IS NOT NULL THEN
154: FND_MESSAGE.SET_TOKEN(G_RCS_ID, p_RCS_ID);
155: END IF;
156: END IF;
157: END log_message;
158:

Line 498: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');

494: p_message_level IN NUMBER := NULL
495: )
496: IS
497: BEGIN
498: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
499: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
500: FND_MSG_PUB.add;
501: END debug_message;
502:

Line 499: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));

495: )
496: IS
497: BEGIN
498: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
499: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
500: FND_MSG_PUB.add;
501: END debug_message;
502:
503:

Line 519: FND_MESSAGE.set_name('OZF', p_message_name);

515: )
516: IS
517: BEGIN
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
519: FND_MESSAGE.set_name('OZF', p_message_name);
520: IF p_token_name IS NOT NULL THEN
521: FND_MESSAGE.set_token(p_token_name, p_token_value);
522: END IF;
523: FND_MSG_PUB.add;

Line 521: FND_MESSAGE.set_token(p_token_name, p_token_value);

517: BEGIN
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
519: FND_MESSAGE.set_name('OZF', p_message_name);
520: IF p_token_name IS NOT NULL THEN
521: FND_MESSAGE.set_token(p_token_name, p_token_value);
522: END IF;
523: FND_MSG_PUB.add;
524: END IF;
525: END error_message;

Line 988: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');

984: );
985: EXCEPTION
986: WHEN GL_Currency_API.NO_RATE THEN
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
988: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
989: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
990: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
991: FND_MSG_PUB.Add;
992: END IF;

Line 989: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);

985: EXCEPTION
986: WHEN GL_Currency_API.NO_RATE THEN
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
988: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
989: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
990: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
991: FND_MSG_PUB.Add;
992: END IF;
993: x_return_status := FND_API.G_RET_STS_ERROR;

Line 990: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);

986: WHEN GL_Currency_API.NO_RATE THEN
987: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
988: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
989: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
990: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
991: FND_MSG_PUB.Add;
992: END IF;
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN GL_Currency_API.INVALID_CURRENCY THEN

Line 996: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');

992: END IF;
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN GL_Currency_API.INVALID_CURRENCY THEN
995: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
996: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
997: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
998: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
999: FND_MSG_PUB.Add;
1000: END IF;

Line 997: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);

993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN GL_Currency_API.INVALID_CURRENCY THEN
995: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
996: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
997: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
998: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
999: FND_MSG_PUB.Add;
1000: END IF;
1001: x_return_status := FND_API.G_RET_STS_ERROR;

Line 998: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);

994: WHEN GL_Currency_API.INVALID_CURRENCY THEN
995: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
996: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
997: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
998: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
999: FND_MSG_PUB.Add;
1000: END IF;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: END Convert_Currency;

Line 1287: FND_MESSAGE.set_name('OZF', 'OZF_UTIL_NO_WHERE_OPERATOR');

1283: IF l_eq_pos = 0 AND l_not_pos = 0 THEN
1284: -- Could not find either an = or an <>
1285: -- operator.
1286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1287: FND_MESSAGE.set_name('OZF', 'OZF_UTIL_NO_WHERE_OPERATOR');
1288: FND_MSG_PUB.add;
1289: RAISE FND_API.g_exc_unexpected_error;
1290: END IF;
1291: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN

Line 2014: fnd_message.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');

2010: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
2011:
2012: IF l_org_id IS NULL THEN
2013: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2014: fnd_message.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
2015: fnd_msg_pub.add;
2016: END IF;
2017: RAISE fnd_api.g_exc_error;
2018: END IF;

Line 2025: fnd_message.set_name('OZF', 'OZF_GL_SOB_NOTFOUND');

2021: FETCH c_get_gl_info INTO l_sob, l_to_currency;
2022:
2023: IF c_get_gl_info%NOTFOUND THEN
2024: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2025: fnd_message.set_name('OZF', 'OZF_GL_SOB_NOTFOUND');
2026: fnd_msg_pub.add;
2027: END IF;
2028:
2029: RAISE fnd_api.g_exc_error;

Line 2053: fnd_message.set_name('OZF', 'OZF_NO_RATE');

2049: WHEN fnd_api.g_exc_error THEN
2050: x_return_status := fnd_api.g_ret_sts_error;
2051: WHEN gl_currency_api.no_rate THEN
2052: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2053: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2054: fnd_msg_pub.add;
2055: END IF;
2056:
2057: x_return_status := fnd_api.g_ret_sts_error;

Line 2060: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');

2056:
2057: x_return_status := fnd_api.g_ret_sts_error;
2058: WHEN gl_currency_api.invalid_currency THEN
2059: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2060: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2061: fnd_msg_pub.add;
2062: END IF;
2063:
2064: x_return_status := fnd_api.g_ret_sts_error;

Line 2201: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');

2197: END IF;
2198:
2199: IF l_conversion_type IS NULL THEN
2200: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2201: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
2202: fnd_msg_pub.add;
2203: END IF;
2204:
2205: x_return_status := fnd_api.g_ret_sts_error;

Line 2213: fnd_message.set_name('OZF', 'OZF_WRONG_CONVERSION_TYPE');

2209: 'CONVERSION_TYPE'
2210: ,l_conversion_type) = fnd_api.g_false
2211: THEN
2212: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2213: fnd_message.set_name('OZF', 'OZF_WRONG_CONVERSION_TYPE');
2214: fnd_msg_pub.add;
2215: END IF;
2216: x_return_status := fnd_api.g_ret_sts_error;
2217: RETURN;

Line 2232: fnd_message.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');

2228: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
2229:
2230: IF l_org_id IS NULL THEN
2231: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2232: fnd_message.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
2233: fnd_msg_pub.add;
2234: END IF;
2235:
2236: RAISE fnd_api.g_exc_error;

Line 2252: fnd_message.set_name('OZF', 'OZF_GL_SOB_NOTFOUND');

2248: FETCH c_get_gl_info INTO x_set_of_books_id, x_fc_currency_code;
2249:
2250: IF c_get_gl_info%NOTFOUND THEN
2251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2252: fnd_message.set_name('OZF', 'OZF_GL_SOB_NOTFOUND');
2253: fnd_msg_pub.add;
2254: END IF;
2255:
2256: RAISE fnd_api.g_exc_error;

Line 2282: fnd_message.set_name('OZF', 'OZF_NO_RATE');

2278: WHEN fnd_api.g_exc_error THEN
2279: x_return_status := fnd_api.g_ret_sts_error;
2280: WHEN gl_currency_api.no_rate THEN
2281: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2282: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2283: fnd_msg_pub.add;
2284: END IF;
2285:
2286: x_return_status := fnd_api.g_ret_sts_error;

Line 2289: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');

2285:
2286: x_return_status := fnd_api.g_ret_sts_error;
2287: WHEN gl_currency_api.invalid_currency THEN
2288: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2289: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2290: fnd_msg_pub.add;
2291: END IF;
2292:
2293: x_return_status := fnd_api.g_ret_sts_error;

Line 2380: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2376: WHEN OTHERS THEN
2377: x_return_status := fnd_api.g_ret_sts_unexp_error;
2378:
2379: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2380: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2381: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2382: fnd_message.set_token('ERRNO', sqlcode);
2383: fnd_message.set_token('REASON', sqlerrm);
2384: END IF;

Line 2381: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');

2377: x_return_status := fnd_api.g_ret_sts_unexp_error;
2378:
2379: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2380: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2381: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2382: fnd_message.set_token('ERRNO', sqlcode);
2383: fnd_message.set_token('REASON', sqlerrm);
2384: END IF;
2385:

Line 2382: fnd_message.set_token('ERRNO', sqlcode);

2378:
2379: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2380: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2381: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2382: fnd_message.set_token('ERRNO', sqlcode);
2383: fnd_message.set_token('REASON', sqlerrm);
2384: END IF;
2385:
2386: END get_fund_ledger;

Line 2383: fnd_message.set_token('REASON', sqlerrm);

2379: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2380: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2381: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2382: fnd_message.set_token('ERRNO', sqlcode);
2383: fnd_message.set_token('REASON', sqlerrm);
2384: END IF;
2385:
2386: END get_fund_ledger;
2387:

Line 2525: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2521: WHEN OTHERS THEN
2522: x_return_status := fnd_api.g_ret_sts_unexp_error;
2523:
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2525: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2526: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2527: fnd_message.set_token('ERRNO', sqlcode);
2528: fnd_message.set_token('REASON', sqlerrm);
2529: END IF;

Line 2526: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');

2522: x_return_status := fnd_api.g_ret_sts_unexp_error;
2523:
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2525: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2526: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2527: fnd_message.set_token('ERRNO', sqlcode);
2528: fnd_message.set_token('REASON', sqlerrm);
2529: END IF;
2530:

Line 2527: fnd_message.set_token('ERRNO', sqlcode);

2523:
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2525: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2526: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2527: fnd_message.set_token('ERRNO', sqlcode);
2528: fnd_message.set_token('REASON', sqlerrm);
2529: END IF;
2530:
2531: END get_object_org_ledger;

Line 2528: fnd_message.set_token('REASON', sqlerrm);

2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2525: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2526: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2527: fnd_message.set_token('ERRNO', sqlcode);
2528: fnd_message.set_token('REASON', sqlerrm);
2529: END IF;
2530:
2531: END get_object_org_ledger;
2532:

Line 2585: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');

2581: END IF;
2582:
2583: IF l_conversion_type IS NULL THEN
2584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2585: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
2586: fnd_msg_pub.add;
2587: END IF;
2588:
2589: x_return_status := fnd_api.g_ret_sts_error;

Line 2597: fnd_message.set_name('OZF', 'OZF_WRONG_CONVERSION_TYPE');

2593: 'CONVERSION_TYPE'
2594: ,l_conversion_type) = fnd_api.g_false
2595: THEN
2596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2597: fnd_message.set_name('OZF', 'OZF_WRONG_CONVERSION_TYPE');
2598: fnd_msg_pub.add;
2599: END IF;
2600: x_return_status := fnd_api.g_ret_sts_error;
2601: RETURN;

Line 2632: fnd_message.set_name('OZF', 'OZF_NO_RATE');

2628: WHEN fnd_api.g_exc_error THEN
2629: x_return_status := fnd_api.g_ret_sts_error;
2630: WHEN gl_currency_api.no_rate THEN
2631: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2632: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2633: fnd_msg_pub.add;
2634: END IF;
2635:
2636: x_return_status := fnd_api.g_ret_sts_error;

Line 2639: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');

2635:
2636: x_return_status := fnd_api.g_ret_sts_error;
2637: WHEN gl_currency_api.invalid_currency THEN
2638: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2639: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2640: fnd_msg_pub.add;
2641: END IF;
2642:
2643: x_return_status := fnd_api.g_ret_sts_error;

Line 2705: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');

2701: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2702: -- Conversion type cannot be null in profile
2703: IF l_conversion_type IS NULL THEN
2704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2705: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
2706: fnd_msg_pub.add;
2707: END IF;
2708: x_return_status := fnd_api.g_ret_sts_error;
2709: RETURN;

Line 2733: fnd_message.set_name('OZF', 'OZF_NO_RATE');

2729:
2730: EXCEPTION
2731: WHEN gl_currency_api.no_rate THEN
2732: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2733: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2734: fnd_msg_pub.add;
2735: END IF;
2736:
2737: x_return_status := fnd_api.g_ret_sts_error;

Line 2740: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');

2736:
2737: x_return_status := fnd_api.g_ret_sts_error;
2738: WHEN gl_currency_api.invalid_currency THEN
2739: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2740: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2741: fnd_msg_pub.add;
2742: END IF;
2743:
2744: x_return_status := fnd_api.g_ret_sts_error;