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.EGO_ITEM_STATUSES_PUB dependencies on FND_API

Line 44: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

40: , p_attribute13 IN VARCHAR2
41: , p_attribute14 IN VARCHAR2
42: , p_attribute15 IN VARCHAR2
43: , p_attribute_category IN VARCHAR2
44: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
45: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_errorcode OUT NOCOPY NUMBER
48: , x_msg_count OUT NOCOPY NUMBER

Line 45: , p_commit IN VARCHAR2 := fnd_api.g_FALSE

41: , p_attribute14 IN VARCHAR2
42: , p_attribute15 IN VARCHAR2
43: , p_attribute_category IN VARCHAR2
44: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
45: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_errorcode OUT NOCOPY NUMBER
48: , x_msg_count OUT NOCOPY NUMBER
49: , x_msg_data OUT NOCOPY VARCHAR2

Line 69: IF NOT FND_API.Compatible_API_Call (l_api_version,

65:
66: -- Standard Start of API savepoint
67: SAVEPOINT Create_Item_Status_PUB;
68:
69: IF NOT FND_API.Compatible_API_Call (l_api_version,
70: p_api_version,
71: l_api_name,
72: G_PKG_NAME)
73: THEN

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: p_api_version,
71: l_api_name,
72: G_PKG_NAME)
73: THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76: -- Initialize API message list if necessary.
77: -- Initialize message list if p_init_msg_list is set to TRUE.
78: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 78: IF FND_API.to_Boolean(p_init_msg_list) THEN

74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76: -- Initialize API message list if necessary.
77: -- Initialize message list if p_init_msg_list is set to TRUE.
78: IF FND_API.to_Boolean(p_init_msg_list) THEN
79: FND_MSG_PUB.initialize;
80: END IF;
81:
82: ------------------------------

Line 190: IF FND_API.To_Boolean(p_commit) THEN

186: */
187: ------------------------------
188:
189: -- Standard check of p_commit
190: IF FND_API.To_Boolean(p_commit) THEN
191: COMMIT WORK;
192: END IF;
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 194: x_return_status := FND_API.G_RET_STS_SUCCESS;

190: IF FND_API.To_Boolean(p_commit) THEN
191: COMMIT WORK;
192: END IF;
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: ------------------------------
197:
198: -- Standard call to get message count and if count is 1,

Line 214: WHEN FND_API.G_EXC_ERROR THEN

210:
211: --------------------------------------------------
212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO Create_Item_Status_PUB;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count,

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO Create_Item_Status_PUB;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: FND_MSG_PUB.Count_And_Get
218: ( p_count => x_msg_count,
219: p_data => x_msg_data
220: );

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

222: x_msg_data := 'Executing - ' || G_PKG_NAME || '.' || l_api_name || ' ' || SQLERRM;
223:
224: WHEN G_DUPLICATE_EXCEPTION THEN
225: ROLLBACK TO Create_Item_Status_PUB;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,
229: p_data => x_msg_data
230: );

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: );
231:
232: x_msg_data := 'EGO_ITEM_STATUS_CODE_EXISTS';
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Create_Item_Status_PUB;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: x_msg_data := 'EGO_ITEM_STATUS_CODE_EXISTS';
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO Create_Item_Status_PUB;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data
240: );

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

240: );
241: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
242: WHEN OTHERS THEN
243: ROLLBACK TO Create_Item_Status_PUB;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: IF FND_MSG_PUB.Check_Msg_Level
246: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
247: THEN
248: FND_MSG_PUB.Add_Exc_Msg

Line 287: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

283: , p_attribute13 IN VARCHAR2
284: , p_attribute14 IN VARCHAR2
285: , p_attribute15 IN VARCHAR2
286: , p_attribute_category IN VARCHAR2
287: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
288: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
289: , x_return_status OUT NOCOPY VARCHAR2
290: , x_errorcode OUT NOCOPY NUMBER
291: , x_msg_count OUT NOCOPY NUMBER

Line 288: , p_commit IN VARCHAR2 := fnd_api.g_FALSE

284: , p_attribute14 IN VARCHAR2
285: , p_attribute15 IN VARCHAR2
286: , p_attribute_category IN VARCHAR2
287: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
288: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
289: , x_return_status OUT NOCOPY VARCHAR2
290: , x_errorcode OUT NOCOPY NUMBER
291: , x_msg_count OUT NOCOPY NUMBER
292: , x_msg_data OUT NOCOPY VARCHAR2

Line 312: IF NOT FND_API.Compatible_API_Call (l_api_version,

308:
309: -- Standard Start of API savepoint
310: SAVEPOINT Update_Item_Status_PUB;
311:
312: IF NOT FND_API.Compatible_API_Call (l_api_version,
313: p_api_version,
314: l_api_name,
315: G_PKG_NAME)
316: THEN

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: p_api_version,
314: l_api_name,
315: G_PKG_NAME)
316: THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: -- Initialize API message list if necessary.
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 321: IF FND_API.to_Boolean(p_init_msg_list) THEN

317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: -- Initialize API message list if necessary.
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean(p_init_msg_list) THEN
322: FND_MSG_PUB.initialize;
323: END IF;
324:
325: ------------------------------

Line 385: IF FND_API.To_Boolean(p_commit) THEN

381: */
382: ------------------------------
383:
384: -- Standard check of p_commit
385: IF FND_API.To_Boolean(p_commit) THEN
386: COMMIT WORK;
387: END IF;
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 389: x_return_status := FND_API.G_RET_STS_SUCCESS;

385: IF FND_API.To_Boolean(p_commit) THEN
386: COMMIT WORK;
387: END IF;
388:
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: ------------------------------
392:
393: -- Standard call to get message count and if count is 1,

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

408: EXCEPTION
409:
410: WHEN OTHERS THEN
411: ROLLBACK TO Update_Item_Status_PUB;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
413: IF FND_MSG_PUB.Check_Msg_Level
414: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
415: THEN
416: FND_MSG_PUB.Add_Exc_Msg

Line 436: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

432: p_api_version IN NUMBER
433: , p_item_status_code IN VARCHAR2
434: , p_attribute_name IN VARCHAR2
435: , p_attribute_value IN VARCHAR2
436: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
437: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
438: , x_return_status OUT NOCOPY VARCHAR2
439: , x_errorcode OUT NOCOPY NUMBER
440: , x_msg_count OUT NOCOPY NUMBER

Line 437: , p_commit IN VARCHAR2 := fnd_api.g_FALSE

433: , p_item_status_code IN VARCHAR2
434: , p_attribute_name IN VARCHAR2
435: , p_attribute_value IN VARCHAR2
436: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
437: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
438: , x_return_status OUT NOCOPY VARCHAR2
439: , x_errorcode OUT NOCOPY NUMBER
440: , x_msg_count OUT NOCOPY NUMBER
441: , x_msg_data OUT NOCOPY VARCHAR2

Line 461: IF NOT FND_API.Compatible_API_Call (l_api_version,

457:
458: -- Standard Start of API savepoint
459: SAVEPOINT Create_Item_Stat_Attr_Vals_Pub;
460:
461: IF NOT FND_API.Compatible_API_Call (l_api_version,
462: p_api_version,
463: l_api_name,
464: G_PKG_NAME)
465: THEN

Line 466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

462: p_api_version,
463: l_api_name,
464: G_PKG_NAME)
465: THEN
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: END IF;
468: -- Initialize API message list if necessary.
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 470: IF FND_API.to_Boolean(p_init_msg_list) THEN

466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
467: END IF;
468: -- Initialize API message list if necessary.
469: -- Initialize message list if p_init_msg_list is set to TRUE.
470: IF FND_API.to_Boolean(p_init_msg_list) THEN
471: FND_MSG_PUB.initialize;
472: END IF;
473:
474: ------------------------------

Line 516: IF FND_API.To_Boolean(p_commit) THEN

512:
513: ------------------------------
514:
515: -- Standard check of p_commit
516: IF FND_API.To_Boolean(p_commit) THEN
517: COMMIT WORK;
518: END IF;
519:
520: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 520: x_return_status := FND_API.G_RET_STS_SUCCESS;

516: IF FND_API.To_Boolean(p_commit) THEN
517: COMMIT WORK;
518: END IF;
519:
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: ------------------------------
523:
524: -- Standard call to get message count and if count is 1,

Line 540: WHEN FND_API.G_EXC_ERROR THEN

536:
537: --------------------------------------------------
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_count => x_msg_count,

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_And_Get
544: ( p_count => x_msg_count,
545: p_data => x_msg_data
546: );

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: x_msg_data := 'Executing - ' || G_PKG_NAME || '.' || l_api_name || ' ' || SQLERRM;
549:
550: WHEN G_DUPLICATE_EXCEPTION THEN
551: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data
556: );

Line 560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

556: );
557:
558: x_msg_data := 'EGO_ITEM_STAT_ATTR_VAL_EXISTS';
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

558: x_msg_data := 'EGO_ITEM_STAT_ATTR_VAL_EXISTS';
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data
566: );

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

566: );
567: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
568: WHEN OTHERS THEN
569: ROLLBACK TO Create_Item_Stat_Attr_Vals_Pub;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg

Line 595: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

591: p_api_version IN NUMBER
592: , p_item_status_code IN VARCHAR2
593: , p_attribute_name IN VARCHAR2
594: , p_attribute_value IN VARCHAR2
595: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
596: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
597: , x_return_status OUT NOCOPY VARCHAR2
598: , x_errorcode OUT NOCOPY NUMBER
599: , x_msg_count OUT NOCOPY NUMBER

Line 596: , p_commit IN VARCHAR2 := fnd_api.g_FALSE

592: , p_item_status_code IN VARCHAR2
593: , p_attribute_name IN VARCHAR2
594: , p_attribute_value IN VARCHAR2
595: , p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
596: , p_commit IN VARCHAR2 := fnd_api.g_FALSE
597: , x_return_status OUT NOCOPY VARCHAR2
598: , x_errorcode OUT NOCOPY NUMBER
599: , x_msg_count OUT NOCOPY NUMBER
600: , x_msg_data OUT NOCOPY VARCHAR2

Line 619: IF NOT FND_API.Compatible_API_Call (l_api_version,

615:
616: -- Standard Start of API savepoint
617: SAVEPOINT Update_Item_Stat_Attr_Vals_Pub;
618:
619: IF NOT FND_API.Compatible_API_Call (l_api_version,
620: p_api_version,
621: l_api_name,
622: G_PKG_NAME)
623: THEN

Line 624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

620: p_api_version,
621: l_api_name,
622: G_PKG_NAME)
623: THEN
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626: -- Initialize API message list if necessary.
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 628: IF FND_API.to_Boolean(p_init_msg_list) THEN

624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626: -- Initialize API message list if necessary.
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean(p_init_msg_list) THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: ------------------------------

Line 647: IF FND_API.To_Boolean(p_commit) THEN

643:
644: ------------------------------
645:
646: -- Standard check of p_commit
647: IF FND_API.To_Boolean(p_commit) THEN
648: COMMIT WORK;
649: END IF;
650:
651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 651: x_return_status := FND_API.G_RET_STS_SUCCESS;

647: IF FND_API.To_Boolean(p_commit) THEN
648: COMMIT WORK;
649: END IF;
650:
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
652:
653: ------------------------------
654:
655: -- Standard call to get message count and if count is 1,

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

670: EXCEPTION
671:
672: WHEN OTHERS THEN
673: ROLLBACK TO Update_Item_Stat_Attr_Vals_Pub;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg