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 (
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,
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
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;
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:
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;
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:
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;
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:
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;
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;
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:
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;
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;
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;
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);
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;
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:
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;
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;
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;
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);
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;
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: ---------------------------------------------------------------------