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.OE_HOLD_SOURCES_PVT dependencies on FND_MSG_PUB

Line 65: FND_MSG_PUB.ADD;

61: oe_debug_pub.add( 'INVALID HOLD ID' ) ;
62: END IF;
63: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ID');
64: FND_MESSAGE.SET_TOKEN('HOLD_ID',p_hold_id);
65: FND_MSG_PUB.ADD;
66: x_return_status := FND_API.G_RET_STS_ERROR;
67:
68: END; -- Validate Hold ID
69:

Line 79: FND_MSG_PUB.ADD;

75: oe_debug_pub.add( 'INVALID ENTITY CODE' ) ;
76: END IF;
77: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
78: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code);
79: FND_MSG_PUB.ADD;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: END IF; -- Validate Entity Code
82:
83: -- Validate Entity ID

Line 128: FND_MSG_PUB.ADD;

124: oe_debug_pub.add( 'INVALID ENTITY ID' ) ;
125: END IF;
126: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
127: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
128: FND_MSG_PUB.ADD;
129: RAISE FND_API.G_EXC_ERROR;
130: -- too many rows maybe raised if the same entity id
131: -- e.g. an item exists in two orgs.
132: WHEN TOO_MANY_ROWS THEN

Line 148: FND_MSG_PUB.ADD;

144: oe_debug_pub.add( 'INVALID SECOND ENTITY CODE' ) ;
145: END IF;
146: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CODE');
147: FND_MESSAGE.SET_TOKEN('ENTITY_CODE',p_entity_code2);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF; -- Validate Entity Code
151:
152: -- Validate Entity ID

Line 197: FND_MSG_PUB.ADD;

193: oe_debug_pub.add( 'INVALID SECOND ENTITY ID' ) ;
194: END IF;
195: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_ID');
196: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id2);
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: -- too many rows maybe raised if the same entity id
200: -- e.g. an item exists in two orgs.
201: WHEN TOO_MANY_ROWS THEN

Line 213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: WHEN OTHERS THEN
213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
214: FND_MSG_PUB.Add_Exc_Msg
215: (G_PKG_NAME
216: ,'ValidateHoldSource');
217: END IF;

Line 214: FND_MSG_PUB.Add_Exc_Msg

210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: WHEN OTHERS THEN
213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
214: FND_MSG_PUB.Add_Exc_Msg
215: (G_PKG_NAME
216: ,'ValidateHoldSource');
217: END IF;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 312: FND_MSG_PUB.ADD;

308: IF l_debug_level > 0 THEN
309: oe_debug_pub.add( 'DUPLICATE HOLD SOURCE' ) ;
310: END IF;
311: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD_SOURCE');
312: FND_MSG_PUB.ADD;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:
316: END IF; -- End of VALIDATION

Line 409: FND_MSG_PUB.Count_And_Get

405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO Create_Hold_Source;
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: FND_MSG_PUB.Count_And_Get
410: ( p_count => x_msg_count
411: , p_data => x_msg_data
412: );
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 416: FND_MSG_PUB.Count_And_Get

412: );
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO Create_Hold_Source;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count
418: , p_data => x_msg_data
419: );
420: WHEN OTHERS THEN

Line 423: IF FND_MSG_PUB.Check_Msg_Level

419: );
420: WHEN OTHERS THEN
421: ROLLBACK TO Create_Hold_Source;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME

Line 424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

420: WHEN OTHERS THEN
421: ROLLBACK TO Create_Hold_Source;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME
428: , l_api_name

Line 426: FND_MSG_PUB.Add_Exc_Msg

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: IF FND_MSG_PUB.Check_Msg_Level
424: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME
428: , l_api_name
429: );
430: END IF;

Line 431: FND_MSG_PUB.Count_And_Get

427: ( G_PKG_NAME
428: , l_api_name
429: );
430: END IF;
431: FND_MSG_PUB.Count_And_Get
432: ( p_count => x_msg_count
433: , p_data => x_msg_data
434: );
435: END Create_Hold_Source;

Line 493: FND_MSG_PUB.ADD;

489: OPEN hold_source;
490: FETCH hold_source INTO l_hold_release_rec.hold_source_id;
491: IF (hold_source%NOTFOUND) THEN
492: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
493: FND_MSG_PUB.ADD;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: CLOSE hold_source;
497:

Line 551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

547: ROLLBACK TO release_hold_source;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: WHEN OTHERS THEN
550: ROLLBACK TO release_hold_source;
551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: FND_MSG_PUB.Add_Exc_Msg
553: (G_PKG_NAME
554: ,'Release_Hold_Source');
555: END IF;

Line 552: FND_MSG_PUB.Add_Exc_Msg

548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: WHEN OTHERS THEN
550: ROLLBACK TO release_hold_source;
551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: FND_MSG_PUB.Add_Exc_Msg
553: (G_PKG_NAME
554: ,'Release_Hold_Source');
555: END IF;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

630: END LOOP;
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
635: FND_MSG_PUB.Add_Exc_Msg
636: (G_PKG_NAME
637: ,'Query_Hold_Source');
638: END IF;

Line 635: FND_MSG_PUB.Add_Exc_Msg

631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
635: FND_MSG_PUB.Add_Exc_Msg
636: (G_PKG_NAME
637: ,'Query_Hold_Source');
638: END IF;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

710: END LOOP;
711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
715: FND_MSG_PUB.Add_Exc_Msg
716: (G_PKG_NAME
717: ,'Query_Hold_Source');
718: END IF;

Line 715: FND_MSG_PUB.Add_Exc_Msg

711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
715: FND_MSG_PUB.Add_Exc_Msg
716: (G_PKG_NAME
717: ,'Query_Hold_Source');
718: END IF;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 774: FND_MSG_PUB.ADD;

770:
771: WHEN NO_DATA_FOUND THEN
772: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_REASON_CODE');
773: FND_MESSAGE.SET_TOKEN('REASON_CODE',p_hold_release_rec.release_reason_code);
774: FND_MSG_PUB.ADD;
775: RAISE FND_API.G_EXC_ERROR;
776:
777: END; -- Validate Reason Code
778:

Line 878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: ROLLBACK TO insert_hold_release;
877: WHEN OTHERS THEN
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME
881: ,'Insert_Hold_Release');
882: END IF;

Line 879: FND_MSG_PUB.Add_Exc_Msg

875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: ROLLBACK TO insert_hold_release;
877: WHEN OTHERS THEN
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
879: FND_MSG_PUB.Add_Exc_Msg
880: (G_PKG_NAME
881: ,'Insert_Hold_Release');
882: END IF;
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1037: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: ROLLBACK TO release_hold_source_wf;
1037: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1038: FND_MSG_PUB.Add_Exc_Msg
1039: (G_PKG_NAME
1040: ,'Release_Hold_Source_WF');
1041: END IF;

Line 1038: FND_MSG_PUB.Add_Exc_Msg

1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: ROLLBACK TO release_hold_source_wf;
1037: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1038: FND_MSG_PUB.Add_Exc_Msg
1039: (G_PKG_NAME
1040: ,'Release_Hold_Source_WF');
1041: END IF;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;