DBA Data[Home] [Help]

APPS.PV_ATTR_VALIDATION_PUB dependencies on FND_MSG_PUB

Line 106: fnd_msg_pub.initialize;

102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( p_init_msg_list )
105: THEN
106: fnd_msg_pub.initialize;
107: END IF;
108:
109: -- Debug Message
110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

106: fnd_msg_pub.initialize;
107: END IF;
108:
109: -- Debug Message
110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
111: dEBUG('In ' || l_api_name );
112:
113: END IF;
114:

Line 121: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

117:
118: -- Getting partner contact details
119:
120:
121: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
122: DEBUG('User id ' || p_user_id );
123: END IF;
124:
125:

Line 132: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

128:
129: l_category := lc_user.category;
130: l_pt_contact_id := lc_user.source_id;
131:
132: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
133: DEBUG('Category ' || lc_user.category );
134: DEBUG('Source ' || lc_user.source_id );
135:
136: END IF;

Line 146: fnd_msg_pub.ADD;

142: IF l_category is null AND l_pt_contact_id is null THEN
143:
144: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
145: fnd_message.SET_TOKEN('TEXT' , 'No User exists for this resource id ');
146: fnd_msg_pub.ADD;
147:
148: raise FND_API.G_EXC_ERROR;
149:
150:

Line 185: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

181: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
182: raise FND_API.G_EXC_ERROR;
183: end if;
184:
185: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
186: Debug('Size of l_rs_details_tbl: ' || l_rs_details_tbl.count);
187: END IF;
188:
189: FOR lc_cursor IN lc_get_pt_details(p_entity_id)

Line 194: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

190: LOOP
191:
192: l_partner_name := lc_cursor.party_name;
193:
194: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
195: Debug('Partner Name: ' || l_partner_name);
196: END IF;
197:
198:

Line 206: fnd_msg_pub.ADD;

202: if l_rs_details_tbl.count = 0 then
203:
204: fnd_message.SET_NAME('PV', 'PV_NO_CM_DECISION_MAKER');
205: fnd_message.SET_TOKEN('P_PARTNER_NAME' , l_partner_name);
206: fnd_msg_pub.ADD;
207:
208: raise FND_API.G_EXC_ERROR;
209:
210: else

Line 219: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

215: loop
216:
217: l_username_tbl(i) := l_rs_details_tbl(i).user_name;
218:
219: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
220: Debug('User Name: ' || l_username_tbl(i));
221: END IF;
222:
223:

Line 234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

230: FOR lc_pt_contact IN lc_get_pt_contact(l_pt_contact_id)
231: LOOP
232:
233: l_partner_contact_name := lc_pt_contact.party_name;
234: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
235: Debug('Partner Contact Name: ' || l_partner_contact_name);
236: END IF;
237:
238:

Line 246: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

242: LOOP
243:
244: l_attribute_name := lc_cur.name;
245:
246: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
247: Debug('Attribute Name: ' || l_attribute_name);
248: END IF;
249:
250:

Line 275: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
276: Debug( 'Email is sent out successfully');
277: END IF;
278:
279: END IF;

Line 288: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

284: COMMIT WORK;
285: END IF;
286:
287: -- Standard call to get message count and if count is 1, get message info.
288: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291:
292: EXCEPTION

Line 296: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

292: EXCEPTION
293:
294: WHEN FND_API.G_EXC_ERROR THEN
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
297: p_count => x_msg_count,
298: p_data => x_msg_data);
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 301: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

297: p_count => x_msg_count,
298: p_data => x_msg_data);
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
302: p_count => x_msg_count,
303: p_data => x_msg_data);
304: WHEN OTHERS THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

302: p_count => x_msg_count,
303: p_data => x_msg_data);
304: WHEN OTHERS THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
307: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: END;

Line 307: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

303: p_data => x_msg_data);
304: WHEN OTHERS THEN
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
307: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310: END;
311:

Line 352: fnd_msg_pub.initialize;

348:
349: -- Initialize message list if p_init_msg_list is set to TRUE.
350: IF FND_API.to_Boolean( p_init_msg_list )
351: THEN
352: fnd_msg_pub.initialize;
353: END IF;
354:
355: -- Debug Message
356: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 356: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

352: fnd_msg_pub.initialize;
353: END IF;
354:
355: -- Debug Message
356: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
357: dEBUG('In ' || l_api_name );
358:
359: END IF;
360:

Line 380: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

376:
377: FOR i in 1 .. p_user_name_tbl.count
378: LOOP
379:
380: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
381: dEBUG( 'In Loop of p_user_name_tbl ');
382: END IF;
383:
384: l_role_list(i) := p_user_name_tbl(i);

Line 393: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

389: l_adhoc_role := 'PV_' || l_itemKey || '_' || '0';
390:
391: -- Debug Message
392:
393: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
394: Debug('Creating role : '|| l_adhoc_role || ' with members:--' );
395: END IF;
396:
397: FOR i in 1 .. l_role_list.count

Line 402: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

398: LOOP
399:
400:
401:
402: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
403: dEBUG( l_role_list(i) );
404: END IF;
405:
406: END LOOP;

Line 483: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

479: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
480: raise FND_API.G_EXC_ERROR;
481: end if;
482:
483: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
484: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
485: fnd_message.Set_token('TEXT', 'After Checkforerror');
486: fnd_msg_pub.Add;
487: END IF;

Line 486: fnd_msg_pub.Add;

482:
483: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
484: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
485: fnd_message.Set_token('TEXT', 'After Checkforerror');
486: fnd_msg_pub.Add;
487: END IF;
488: END IF;
489:
490: IF FND_API.To_Boolean ( p_commit ) THEN

Line 495: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

491: COMMIT WORK;
492: END IF;
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498: EXCEPTION
499:

Line 502: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

498: EXCEPTION
499:
500: WHEN FND_API.G_EXC_ERROR THEN
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
503: p_count => x_msg_count,
504: p_data => x_msg_data);
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 507: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

503: p_count => x_msg_count,
504: p_data => x_msg_data);
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
508: p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

508: p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
513: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
514: p_count => x_msg_count,
515: p_data => x_msg_data);
516: end StartWorkflow;

Line 513: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

509: p_data => x_msg_data);
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
513: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
514: p_count => x_msg_count,
515: p_data => x_msg_data);
516: end StartWorkflow;
517:

Line 527: FND_MSG_PUB.Add;

523:
524: BEGIN
525: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
526: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
527: FND_MSG_PUB.Add;
528: END Debug;
529:
530: END PV_ATTR_VALIDATION_PUB;