DBA Data[Home] [Help]

APPS.JTF_CTM_UTILITY_PVT dependencies on FND_MSG_PUB

Line 54: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

50:
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);

Line 59: FND_MSG_PUB.ADD;

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;
63:

Line 102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

98:
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;

Line 106: FND_MSG_PUB.ADD;

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;
110:

Line 127: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

123:
124: if (p_col_choice is NULL and p_col_name is NOT NULL)
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;

Line 130: fnd_msg_pub.add;

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;
134:

Line 149: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)

145: elsif (mod(p_col_choice, 10) = 0)
146: then
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;

Line 153: fnd_msg_pub.add;

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 '';
157: end if;

Line 189: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

185: p_api_version,
186: l_api_name,
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;

Line 193: FND_MSG_PUB.ADD;

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;
197:

Line 201: FND_MSG_PUB.initialize;

197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Initialize API return status to success
205: --

Line 244: FND_MSG_PUB.Count_And_Get

240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_ERROR ;
243:
244: FND_MSG_PUB.Count_And_Get
245: ( p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248:

Line 254: FND_MSG_PUB.Count_And_Get

250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251:
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253:
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data
257: );
258:

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

261:
262:
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
264:
265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
266: THEN
267: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
268: END IF;
269:

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

263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
264:
265: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
266: THEN
267: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
268: END IF;
269:
270: FND_MSG_PUB.Count_And_Get
271: ( p_count => x_msg_count,

Line 270: FND_MSG_PUB.Count_And_Get

266: THEN
267: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
268: END IF;
269:
270: FND_MSG_PUB.Count_And_Get
271: ( p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274:

Line 512: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);

508: and lng.language_id = x_lang_id;
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;

Line 527: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);

523: FETCH Get_Message_Num into l_message_num;
524: CLOSE Get_Message_Num;
525: END IF;
526:
527: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, fnd_api.g_true);
528:
529: IF NVL(l_message_num, 0) <> 0
530: THEN
531: l_temp_msg := 'APP-' || to_char(l_message_num) || ': ';

Line 539: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);

535:
536: IF l_count = 1
537: THEN
538: l_msg_list := l_msg_list || l_temp_msg ||
539: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
540: ELSE
541: l_msg_list := l_msg_list || l_temp_msg ||
542: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
543: END IF;

Line 542: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);

538: l_msg_list := l_msg_list || l_temp_msg ||
539: fnd_msg_pub.get(fnd_msg_pub.g_first, fnd_api.g_false);
540: ELSE
541: l_msg_list := l_msg_list || l_temp_msg ||
542: fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_false);
543: END IF;
544:
545: l_msg_list := l_msg_list || '';
546: