eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ATTR_VALIDATION_PUB dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

10:
11:
12: PROCEDURE attribute_validate(
13: p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
15: p_commit IN VARCHAR2 := FND_API.g_false,
16: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
17: p_attribute_id IN NUMBER,
18: p_entity IN VARCHAR2,

Line 15: p_commit IN VARCHAR2 := FND_API.g_false,

11:
12: PROCEDURE attribute_validate(
13: p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
15: p_commit IN VARCHAR2 := FND_API.g_false,
16: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
17: p_attribute_id IN NUMBER,
18: p_entity IN VARCHAR2,
19: p_entity_id IN VARCHAR2,

Line 16: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

12: PROCEDURE attribute_validate(
13: p_api_version_number IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
15: p_commit IN VARCHAR2 := FND_API.g_false,
16: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
17: p_attribute_id IN NUMBER,
18: p_entity IN VARCHAR2,
19: p_entity_id IN VARCHAR2,
20: p_user_id IN VARCHAR2,

Line 96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

92:
93:
94:
95: BEGIN
96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME) THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME) THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( p_init_msg_list )

Line 104: IF FND_API.to_Boolean( p_init_msg_list )

100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
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:

Line 148: raise FND_API.G_EXC_ERROR;

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:
151: -- If user is VENDOR then email notification will not sent out
152: -- Email notification has to sent only when the partner makes the

Line 181: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data
179: );
180:
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

Line 182: raise FND_API.G_EXC_ERROR;

178: x_msg_data => x_msg_data
179: );
180:
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);

Line 208: raise FND_API.G_EXC_ERROR;

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
211:
212: l_username_tbl.extend(l_rs_details_tbl.count);

Line 271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

267: x_msg_data => x_msg_data
268: );
269:
270:
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

Line 272: RAISE FND_API.G_EXC_ERROR;

268: );
269:
270:
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');

Line 283: IF FND_API.To_Boolean ( p_commit ) THEN

279: END IF;
280:
281: END IF;
282:
283: IF FND_API.To_Boolean ( p_commit ) THEN
284: COMMIT WORK;
285: END IF;
286:
287: -- Standard call to get message count and if count is 1, get message info.

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 294: WHEN FND_API.G_EXC_ERROR THEN

290: p_data => x_msg_data);
291:
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);

Line 295: x_return_status := FND_API.G_RET_STS_ERROR ;

291:
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

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 299: WHEN FND_API.G_EXC_UNEXPECTED_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 ;
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);

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_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 ;
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

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

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 316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

312:
313: procedure StartWorkflow
314: (
315: p_api_version_number IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_commit IN VARCHAR2 := FND_API.G_FALSE,
318: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
319: p_user_name_tbl IN JTF_VARCHAR2_TABLE_1000,
320: p_attribute_id IN VARCHAR2,

Line 317: p_commit IN VARCHAR2 := FND_API.G_FALSE,

313: procedure StartWorkflow
314: (
315: p_api_version_number IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_commit IN VARCHAR2 := FND_API.G_FALSE,
318: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
319: p_user_name_tbl IN JTF_VARCHAR2_TABLE_1000,
320: p_attribute_id IN VARCHAR2,
321: p_attribute_name IN VARCHAR2,

Line 318: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

314: (
315: p_api_version_number IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_commit IN VARCHAR2 := FND_API.G_FALSE,
318: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
319: p_user_name_tbl IN JTF_VARCHAR2_TABLE_1000,
320: p_attribute_id IN VARCHAR2,
321: p_attribute_name IN VARCHAR2,
322: p_partner_name IN VARCHAR2,

Line 342: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

338:
339:
340: begin
341: -- Standard call to check for call compatibility.
342: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
343: p_api_version_number,
344: l_api_name,
345: G_PKG_NAME) THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

342: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
343: p_api_version_number,
344: l_api_name,
345: G_PKG_NAME) THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:
349: -- Initialize message list if p_init_msg_list is set to TRUE.
350: IF FND_API.to_Boolean( p_init_msg_list )

Line 350: IF FND_API.to_Boolean( p_init_msg_list )

346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
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:

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS ;

357: dEBUG('In ' || l_api_name );
358:
359: END IF;
360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS ;
362:
363: -- check the profile value and return if the value is not Y
364:
365: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), 'Y');

Line 469: ,p_init_msg_list => FND_API.G_FALSE

465:
466: -- Call the following procedure to see whether workflow was able to send notification successfully.
467: PV_ASSIGN_UTIL_PVT.checkforErrors
468: (p_api_version_number => 1.0
469: ,p_init_msg_list => FND_API.G_FALSE
470: ,p_commit => FND_API.G_FALSE
471: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
472: ,p_itemtype => l_itemType
473: ,p_itemkey => l_itemKey

Line 470: ,p_commit => FND_API.G_FALSE

466: -- Call the following procedure to see whether workflow was able to send notification successfully.
467: PV_ASSIGN_UTIL_PVT.checkforErrors
468: (p_api_version_number => 1.0
469: ,p_init_msg_list => FND_API.G_FALSE
470: ,p_commit => FND_API.G_FALSE
471: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
472: ,p_itemtype => l_itemType
473: ,p_itemkey => l_itemKey
474: ,x_msg_count => x_msg_count

Line 471: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

467: PV_ASSIGN_UTIL_PVT.checkforErrors
468: (p_api_version_number => 1.0
469: ,p_init_msg_list => FND_API.G_FALSE
470: ,p_commit => FND_API.G_FALSE
471: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
472: ,p_itemtype => l_itemType
473: ,p_itemkey => l_itemKey
474: ,x_msg_count => x_msg_count
475: ,x_msg_data => x_msg_data

Line 479: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

475: ,x_msg_data => x_msg_data
476: ,x_return_status => x_return_status);
477:
478: -- Check the x_return_status. If its not successful throw an exception.
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

Line 480: raise FND_API.G_EXC_ERROR;

476: ,x_return_status => x_return_status);
477:
478: -- Check the x_return_status. If its not successful throw an exception.
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');

Line 490: IF FND_API.To_Boolean ( p_commit ) THEN

486: fnd_msg_pub.Add;
487: END IF;
488: END IF;
489:
490: IF FND_API.To_Boolean ( p_commit ) THEN
491: COMMIT WORK;
492: END IF;
493:
494: -- Standard call to get message count and if count is 1, get message info.

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 500: WHEN FND_API.G_EXC_ERROR THEN

496: p_count => x_msg_count,
497: p_data => x_msg_data);
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);

Line 501: x_return_status := FND_API.G_RET_STS_ERROR ;

497: p_data => x_msg_data);
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

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 505: WHEN FND_API.G_EXC_UNEXPECTED_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 ;
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);

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_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 ;
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

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

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: