51: l_return_variable := FND_API.G_FALSE;
52:
53: /* Debug message */
54: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
55: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
56: FND_MESSAGE.Set_Token ('TABLE_NAME', p_fk_table_name);
57: FND_MESSAGE.Set_Token ('COLUMN_NAME', p_fk_col_name);
58: FND_MESSAGE.Set_Token ('VALUE', p_fk_value);
59: FND_MSG_PUB.ADD;
52:
53: /* Debug message */
54: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
55: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
56: FND_MESSAGE.Set_Token ('TABLE_NAME', p_fk_table_name);
57: FND_MESSAGE.Set_Token ('COLUMN_NAME', p_fk_col_name);
58: FND_MESSAGE.Set_Token ('VALUE', p_fk_value);
59: FND_MSG_PUB.ADD;
60: END IF;
53: /* Debug message */
54: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
55: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
56: FND_MESSAGE.Set_Token ('TABLE_NAME', p_fk_table_name);
57: FND_MESSAGE.Set_Token ('COLUMN_NAME', p_fk_col_name);
58: FND_MESSAGE.Set_Token ('VALUE', p_fk_value);
59: FND_MSG_PUB.ADD;
60: END IF;
61:
54: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
55: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
56: FND_MESSAGE.Set_Token ('TABLE_NAME', p_fk_table_name);
57: FND_MESSAGE.Set_Token ('COLUMN_NAME', p_fk_col_name);
58: FND_MESSAGE.Set_Token ('VALUE', p_fk_value);
59: FND_MSG_PUB.ADD;
60: END IF;
61:
62: END IF;
99: l_return_variable := FND_API.G_FALSE;
100:
101: -- Debug message
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
103: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_LOOKUP_CODE');
104: FND_MESSAGE.Set_Token ('LOOKUP_TYPE', p_lookup_type);
105: FND_MESSAGE.Set_Token ('LOOKUP_CODE', p_lookup_code);
106: FND_MSG_PUB.ADD;
107: END IF;
100:
101: -- Debug message
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
103: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_LOOKUP_CODE');
104: FND_MESSAGE.Set_Token ('LOOKUP_TYPE', p_lookup_type);
105: FND_MESSAGE.Set_Token ('LOOKUP_CODE', p_lookup_code);
106: FND_MSG_PUB.ADD;
107: END IF;
108:
101: -- Debug message
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
103: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_INVALID_LOOKUP_CODE');
104: FND_MESSAGE.Set_Token ('LOOKUP_TYPE', p_lookup_type);
105: FND_MESSAGE.Set_Token ('LOOKUP_CODE', p_lookup_code);
106: FND_MSG_PUB.ADD;
107: END IF;
108:
109: END IF;
125: or (p_col_choice is NOT NULL and p_col_name is NULL)
126: then
127: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
128: then
129: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
130: fnd_msg_pub.add;
131: end if;
132: raise fnd_api.g_exc_error;
133: end if;
147: return(l_col_name || ' DESC, ');
148: else
149: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
150: then
151: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
152: fnd_message.set_token('PARAM',p_col_choice, false);
153: fnd_msg_pub.add;
154: end if;
155: raise fnd_api.g_exc_error;
148: else
149: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
150: then
151: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
152: fnd_message.set_token('PARAM',p_col_choice, false);
153: fnd_msg_pub.add;
154: end if;
155: raise fnd_api.g_exc_error;
156: return '';
187: G_PKG_NAME)
188: THEN
189: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
190: THEN
191: FND_MESSAGE.Set_Name('JTF', 'API_UNEXP_ERROR_IN_PROCESSING');
192: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
193: FND_MSG_PUB.ADD;
194: END IF;
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: THEN
189: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
190: THEN
191: FND_MESSAGE.Set_Name('JTF', 'API_UNEXP_ERROR_IN_PROCESSING');
192: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
193: FND_MSG_PUB.ADD;
194: END IF;
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
509: BEGIN
510: FOR l_count in 1..p_message_count LOOP
511:
512: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
513: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
514: OPEN Get_Appl_Id (l_appl_short_name);
515: FETCH Get_Appl_Id into l_id;
516: CLOSE Get_Appl_Id;
517: