DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on FND_MESSAGE

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

143: -- log_message
144: --
145: -- PURPOSE
146: -- Writes a message to the log file if this level and module is enabled
147: -- The message gets set previously with FND_MESSAGE.SET_NAME,
148: -- SET_TOKEN, etc.
149: -- The message is popped off the message dictionary stack, if POP_MESSAGE
150: -- is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
151: -- displayed to the user later.

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

149: -- The message is popped off the message dictionary stack, if POP_MESSAGE
150: -- is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
151: -- displayed to the user later.
152: -- Example usage:
153: -- FND_MESSAGE.SET_NAME(...); -- Set message
154: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message
155: -- FND_LOG.MESSAGE(..., FALSE); -- Log message
156: -- FND_MESSAGE.ERROR; -- Display message
157: --

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

150: -- is TRUE. Pass FALSE for POP_MESSAGE if the message will also be
151: -- displayed to the user later.
152: -- Example usage:
153: -- FND_MESSAGE.SET_NAME(...); -- Set message
154: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message
155: -- FND_LOG.MESSAGE(..., FALSE); -- Log message
156: -- FND_MESSAGE.ERROR; -- Display message
157: --
158: -- HISTORY

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

152: -- Example usage:
153: -- FND_MESSAGE.SET_NAME(...); -- Set message
154: -- FND_MESSAGE.SET_TOKEN(...); -- Set token in message
155: -- FND_LOG.MESSAGE(..., FALSE); -- Log message
156: -- FND_MESSAGE.ERROR; -- Display message
157: --
158: -- HISTORY
159: -- 01-Oct-2003 huili Create.
160: --======================================================================

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

167: BEGIN
168: IF ( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FND_LOG.MESSAGE(p_log_level, p_module_name, p_pop_message);
170: IF p_RCS_ID IS NOT NULL THEN
171: FND_MESSAGE.SET_TOKEN(G_RCS_ID, p_RCS_ID);
172: END IF;
173: END IF;
174: END log_message;
175:

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

511: p_message_level IN NUMBER := NULL
512: )
513: IS
514: BEGIN
515: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
516: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
517: FND_MSG_PUB.add;
518: END debug_message;
519:

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

512: )
513: IS
514: BEGIN
515: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
516: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
517: FND_MSG_PUB.add;
518: END debug_message;
519:
520:

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

532: )
533: IS
534: BEGIN
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
536: FND_MESSAGE.set_name('OZF', p_message_name);
537: IF p_token_name IS NOT NULL THEN
538: FND_MESSAGE.set_token(p_token_name, p_token_value);
539: END IF;
540: FND_MSG_PUB.add;

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

534: BEGIN
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
536: FND_MESSAGE.set_name('OZF', p_message_name);
537: IF p_token_name IS NOT NULL THEN
538: FND_MESSAGE.set_token(p_token_name, p_token_value);
539: END IF;
540: FND_MSG_PUB.add;
541: END IF;
542: END error_message;

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

1009: );
1010: EXCEPTION
1011: WHEN GL_Currency_API.NO_RATE THEN
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
1014: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1015: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1016: FND_MSG_PUB.Add;
1017: END IF;

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

1010: EXCEPTION
1011: WHEN GL_Currency_API.NO_RATE THEN
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
1014: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1015: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1016: FND_MSG_PUB.Add;
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_ERROR;

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

1011: WHEN GL_Currency_API.NO_RATE THEN
1012: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1013: FND_MESSAGE.Set_Name ('OZF', 'OZF_NO_RATE');
1014: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1015: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1016: FND_MSG_PUB.Add;
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: WHEN GL_Currency_API.INVALID_CURRENCY THEN

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

1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: WHEN GL_Currency_API.INVALID_CURRENCY THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
1022: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1023: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1024: FND_MSG_PUB.Add;
1025: END IF;

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

1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: WHEN GL_Currency_API.INVALID_CURRENCY THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
1022: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1023: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1024: FND_MSG_PUB.Add;
1025: END IF;
1026: x_return_status := FND_API.G_RET_STS_ERROR;

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

1019: WHEN GL_Currency_API.INVALID_CURRENCY THEN
1020: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1021: FND_MESSAGE.Set_Name ('OZF', 'OZF_INVALID_CURR');
1022: FND_MESSAGE.Set_Token ('CURRENCY_FROM', p_from_currency);
1023: FND_MESSAGE.Set_Token ('CURRENCY_TO', p_to_currency);
1024: FND_MSG_PUB.Add;
1025: END IF;
1026: x_return_status := FND_API.G_RET_STS_ERROR;
1027: END Convert_Currency;

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

1308: IF l_eq_pos = 0 AND l_not_pos = 0 THEN
1309: -- Could not find either an = or an <>
1310: -- operator.
1311: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1312: FND_MESSAGE.set_name('OZF', 'OZF_UTIL_NO_WHERE_OPERATOR');
1313: FND_MSG_PUB.add;
1314: RAISE FND_API.g_exc_unexpected_error;
1315: END IF;
1316: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN

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

2036: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
2037:
2038: IF l_org_id IS NULL THEN
2039: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2040: fnd_message.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
2041: fnd_msg_pub.add;
2042: END IF;
2043: RAISE fnd_api.g_exc_error;
2044: END IF;

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

2047: FETCH c_get_gl_info INTO l_sob, l_to_currency;
2048:
2049: IF c_get_gl_info%NOTFOUND THEN
2050: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2051: fnd_message.set_name('OZF', 'OZF_GL_SOB_NOTFOUND');
2052: fnd_msg_pub.add;
2053: END IF;
2054:
2055: RAISE fnd_api.g_exc_error;

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

2082: WHEN fnd_api.g_exc_error THEN
2083: x_return_status := fnd_api.g_ret_sts_error;
2084: WHEN gl_currency_api.no_rate THEN
2085: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2086: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2087: fnd_msg_pub.add;
2088: END IF;
2089:
2090: x_return_status := fnd_api.g_ret_sts_error;

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

2089:
2090: x_return_status := fnd_api.g_ret_sts_error;
2091: WHEN gl_currency_api.invalid_currency THEN
2092: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2093: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2094: fnd_msg_pub.add;
2095: END IF;
2096:
2097: x_return_status := fnd_api.g_ret_sts_error;

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

2230: END IF;
2231:
2232: IF l_conversion_type IS NULL THEN
2233: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2234: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
2235: fnd_msg_pub.add;
2236: END IF;
2237:
2238: x_return_status := fnd_api.g_ret_sts_error;

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

2242: 'CONVERSION_TYPE'
2243: ,l_conversion_type) = fnd_api.g_false
2244: THEN
2245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2246: fnd_message.set_name('OZF', 'OZF_WRONG_CONVERSION_TYPE');
2247: fnd_msg_pub.add;
2248: END IF;
2249: x_return_status := fnd_api.g_ret_sts_error;
2250: RETURN;

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

2261: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
2262:
2263: IF l_org_id IS NULL THEN
2264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2265: fnd_message.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
2266: fnd_msg_pub.add;
2267: END IF;
2268:
2269: RAISE fnd_api.g_exc_error;

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

2281: FETCH c_get_gl_info INTO x_set_of_books_id, x_fc_currency_code;
2282:
2283: IF c_get_gl_info%NOTFOUND THEN
2284: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2285: fnd_message.set_name('OZF', 'OZF_GL_SOB_NOTFOUND');
2286: fnd_msg_pub.add;
2287: END IF;
2288:
2289: RAISE fnd_api.g_exc_error;

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

2311: WHEN fnd_api.g_exc_error THEN
2312: x_return_status := fnd_api.g_ret_sts_error;
2313: WHEN gl_currency_api.no_rate THEN
2314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2315: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2316: fnd_msg_pub.add;
2317: END IF;
2318:
2319: x_return_status := fnd_api.g_ret_sts_error;

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

2318:
2319: x_return_status := fnd_api.g_ret_sts_error;
2320: WHEN gl_currency_api.invalid_currency THEN
2321: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2322: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2323: fnd_msg_pub.add;
2324: END IF;
2325:
2326: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

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

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

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

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

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

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

2527: WHEN OTHERS THEN
2528: x_return_status := fnd_api.g_ret_sts_unexp_error;
2529:
2530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2531: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2532: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2533: fnd_message.set_token('ERRNO', sqlcode);
2534: fnd_message.set_token('REASON', sqlerrm);
2535: END IF;

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

2528: x_return_status := fnd_api.g_ret_sts_unexp_error;
2529:
2530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2531: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2532: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2533: fnd_message.set_token('ERRNO', sqlcode);
2534: fnd_message.set_token('REASON', sqlerrm);
2535: END IF;
2536:

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

2529:
2530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2531: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2532: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2533: fnd_message.set_token('ERRNO', sqlcode);
2534: fnd_message.set_token('REASON', sqlerrm);
2535: END IF;
2536:
2537: END get_object_org_ledger;

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

2530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2531: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2532: fnd_message.set_token('ROUTINE', 'OZF_UTLITY_PVT');
2533: fnd_message.set_token('ERRNO', sqlcode);
2534: fnd_message.set_token('REASON', sqlerrm);
2535: END IF;
2536:
2537: END get_object_org_ledger;
2538:

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

2595: END IF;
2596:
2597: IF l_conversion_type IS NULL THEN
2598: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2599: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
2600: fnd_msg_pub.add;
2601: END IF;
2602:
2603: x_return_status := fnd_api.g_ret_sts_error;

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

2607: 'CONVERSION_TYPE'
2608: ,l_conversion_type) = fnd_api.g_false
2609: THEN
2610: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2611: fnd_message.set_name('OZF', 'OZF_WRONG_CONVERSION_TYPE');
2612: fnd_msg_pub.add;
2613: END IF;
2614: x_return_status := fnd_api.g_ret_sts_error;
2615: RETURN;

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

2642: WHEN fnd_api.g_exc_error THEN
2643: x_return_status := fnd_api.g_ret_sts_error;
2644: WHEN gl_currency_api.no_rate THEN
2645: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2646: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2647: fnd_msg_pub.add;
2648: END IF;
2649:
2650: x_return_status := fnd_api.g_ret_sts_error;

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

2649:
2650: x_return_status := fnd_api.g_ret_sts_error;
2651: WHEN gl_currency_api.invalid_currency THEN
2652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2653: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2654: fnd_msg_pub.add;
2655: END IF;
2656:
2657: x_return_status := fnd_api.g_ret_sts_error;

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

2716: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2717: -- Conversion type cannot be null in profile
2718: IF l_conversion_type IS NULL THEN
2719: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2720: fnd_message.set_name('OZF', 'OZF_NO_EXCHANGE_TYPE');
2721: fnd_msg_pub.add;
2722: END IF;
2723: x_return_status := fnd_api.g_ret_sts_error;
2724: RETURN;

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

2751:
2752: EXCEPTION
2753: WHEN gl_currency_api.no_rate THEN
2754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2755: fnd_message.set_name('OZF', 'OZF_NO_RATE');
2756: fnd_msg_pub.add;
2757: END IF;
2758:
2759: x_return_status := fnd_api.g_ret_sts_error;

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

2758:
2759: x_return_status := fnd_api.g_ret_sts_error;
2760: WHEN gl_currency_api.invalid_currency THEN
2761: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2762: fnd_message.set_name('OZF', 'OZF_INVALID_CURR');
2763: fnd_msg_pub.add;
2764: END IF;
2765:
2766: x_return_status := fnd_api.g_ret_sts_error;