DBA Data[Home] [Help]

APPS.AMW_UTILITY_PVT dependencies on FND_MSG_PUB

Line 37: AMW_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

33: -- clause, return a tuple of column name and column value.
34: -- HISTORY
35: -- 4/20/2003 mpande Created.
36: ---------------------------------------------------------------------
37: AMW_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38: AMW_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39: AMW_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40:
41: PROCEDURE bind_parse (

Line 38: AMW_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

34: -- HISTORY
35: -- 4/20/2003 mpande Created.
36: ---------------------------------------------------------------------
37: AMW_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38: AMW_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39: AMW_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40:
41: PROCEDURE bind_parse (
42: p_string IN VARCHAR2,

Line 39: AMW_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

35: -- 4/20/2003 mpande Created.
36: ---------------------------------------------------------------------
37: AMW_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38: AMW_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39: AMW_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40:
41: PROCEDURE bind_parse (
42: p_string IN VARCHAR2,
43: x_col_val_tbl OUT NOCOPY col_val_tbl

Line 316: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN

312: p_message_level IN NUMBER := NULL
313: )
314: IS
315: BEGIN
316: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
317: FND_MESSAGE.set_name('AMW', 'AMW_API_DEBUG_MESSAGE');
318: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
319: FND_MSG_PUB.add;
320: END IF;

Line 319: FND_MSG_PUB.add;

315: BEGIN
316: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH) THEN
317: FND_MESSAGE.set_name('AMW', 'AMW_API_DEBUG_MESSAGE');
318: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
319: FND_MSG_PUB.add;
320: END IF;
321: END debug_message;
322:
323:

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

334: P_token_value VARCHAR2 := NULL
335: )
336: IS
337: BEGIN
338: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
339: FND_MESSAGE.set_name('AMW', p_message_name);
340: IF p_token_name IS NOT NULL THEN
341: FND_MESSAGE.set_token(p_token_name, p_token_value, TRUE);
342: END IF;

Line 343: FND_MSG_PUB.add;

339: FND_MESSAGE.set_name('AMW', p_message_name);
340: IF p_token_name IS NOT NULL THEN
341: FND_MESSAGE.set_token(p_token_name, p_token_value, TRUE);
342: END IF;
343: FND_MSG_PUB.add;
344: END IF;
345: END error_message;
346:
347:

Line 360: l_count := FND_MSG_PUB.count_msg;

356: IS
357: l_count NUMBER;
358: l_msg VARCHAR2(2000);
359: BEGIN
360: l_count := FND_MSG_PUB.count_msg;
361: FOR i IN 1 .. l_count LOOP
362: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);
363: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
364: END LOOP;

Line 362: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);

358: l_msg VARCHAR2(2000);
359: BEGIN
360: l_count := FND_MSG_PUB.count_msg;
361: FOR i IN 1 .. l_count LOOP
362: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);
363: -- DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
364: END LOOP;
365: END display_messages;
366:

Line 418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

414: -----------------------------------
415: IF l_eq_pos = 0 AND l_not_pos = 0 THEN
416: -- Could not find either an = or an <>
417: -- operator.
418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
419: FND_MESSAGE.set_name('AMW', 'AMW_UTIL_NO_WHERE_OPERATOR');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;

Line 420: FND_MSG_PUB.add;

416: -- Could not find either an = or an <>
417: -- operator.
418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
419: FND_MESSAGE.set_name('AMW', 'AMW_UTIL_NO_WHERE_OPERATOR');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423: ELSIF l_eq_pos > 0 AND l_not_pos = 0 THEN
424: l_curr_pos := l_eq_pos;

Line 491: FND_MSG_PUB.Add;

487:
488: IF x_role_name is null then
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.Set_Name('AMW','AMW_APPR_INVALID_ROLE');
491: FND_MSG_PUB.Add;
492: END IF;
493: END Get_person_Role;
494:
495:

Line 733: FND_MSG_PUB.initialize;

729: begin
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735: IF FND_GLOBAL.User_Id IS NULL THEN
736: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
737: RAISE FND_API.G_EXC_ERROR;

Line 747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

743:
744: WHEN FND_API.G_EXC_ERROR THEN
745: ROLLBACK;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
753:
754: WHEN OTHERS THEN
755: ROLLBACK;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

753:
754: WHEN OTHERS THEN
755: ROLLBACK;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
758: THEN
759: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
760: END IF;
761: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

755: ROLLBACK;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
758: THEN
759: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
760: END IF;
761: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
762:
763: end wait_for_req;

Line 761: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

757: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
758: THEN
759: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
760: END IF;
761: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
762:
763: end wait_for_req;
764:
765:

Line 1022: FND_MSG_PUB.initialize;

1018: begin
1019:
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1022: FND_MSG_PUB.initialize;
1023: END IF;
1024: IF FND_GLOBAL.User_Id IS NULL THEN
1025: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1026: RAISE FND_API.G_EXC_ERROR;

Line 1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1058:
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: ROLLBACK;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1068:
1069: WHEN OTHERS THEN
1070: ROLLBACK;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1068:
1069: WHEN OTHERS THEN
1070: ROLLBACK;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1075: END IF;
1076: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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

1070: ROLLBACK;
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1075: END IF;
1076: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1077:
1078: end isUserProcessOwner;

Line 1076: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

1072: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1073: THEN
1074: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1075: END IF;
1076: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1077:
1078: end isUserProcessOwner;
1079:
1080: ---------------------------------------------------------------------