38: debug_message('SQL statement: '||l_sql);
39: EXECUTE IMMEDIATE l_sql INTO l_count;
40:
41: IF l_count = 0 THEN
42: RETURN FND_API.g_false;
43: ELSE
44: RETURN FND_API.g_true;
45: END IF;
46:
40:
41: IF l_count = 0 THEN
42: RETURN FND_API.g_false;
43: ELSE
44: RETURN FND_API.g_true;
45: END IF;
46:
47: END check_fk_exists;
48:
71: debug_message('SQL statement: '||l_sql);
72: EXECUTE IMMEDIATE l_sql INTO l_count;
73:
74: IF l_count = 0 THEN
75: RETURN FND_API.g_true;
76: ELSE
77: RETURN FND_API.g_false;
78: END IF;
79:
73:
74: IF l_count = 0 THEN
75: RETURN FND_API.g_true;
76: ELSE
77: RETURN FND_API.g_false;
78: END IF;
79:
80: END check_uniqueness;
81:
112: l_msg VARCHAR2(2000);
113: BEGIN
114: l_count := FND_MSG_PUB.count_msg;
115: FOR i IN 1 .. l_count LOOP
116: l_msg := FND_MSG_PUB.get(i, FND_API.g_false);
117: --DBMS_OUTPUT.put_line('(' || i || ') ' || l_msg);
118: END LOOP;
119: END display_messages;
120: