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 OE_DEBUG_PUB

Line 14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

10: ( p_user_id OUT NOCOPY NUMBER)
11:
12: IS
13: --
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: --
16: BEGIN
17: p_user_id := NVL(FND_GLOBAL.USER_ID, -1);
18:

Line 38: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

34: )
35: IS
36: l_dummy VARCHAR2(30) DEFAULT NULL;
37: --
38: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
39: --
40: BEGIN
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 61: oe_debug_pub.add( 'INVALID HOLD ID' ) ;

57: EXCEPTION
58:
59: WHEN NO_DATA_FOUND THEN
60: IF l_debug_level > 0 THEN
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;

Line 75: oe_debug_pub.add( 'INVALID ENTITY CODE' ) ;

71: -- Validate Entity Code
72:
73: IF p_entity_code NOT IN ('C','S','I','O') THEN
74: IF l_debug_level > 0 THEN
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;

Line 124: oe_debug_pub.add( 'INVALID ENTITY ID' ) ;

120:
121: EXCEPTION
122: WHEN NO_DATA_FOUND THEN
123: IF l_debug_level > 0 THEN
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;

Line 144: oe_debug_pub.add( 'INVALID SECOND ENTITY CODE' ) ;

140: IF p_entity_code2 is not NULL THEN
141:
142: IF p_entity_code2 NOT IN ('C','S','I','O') THEN
143: IF l_debug_level > 0 THEN
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;

Line 193: oe_debug_pub.add( 'INVALID SECOND ENTITY ID' ) ;

189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN
192: IF l_debug_level > 0 THEN
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;

Line 241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

237: l_user_id NUMBER;
238: l_count NUMBER;
239: l_org_id NUMBER;
240: --
241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
242: --
243: BEGIN
244:
245: IF l_debug_level > 0 THEN

Line 246: oe_debug_pub.add( 'IN OE_HOLD_SOURCES_PVT.CREATE_HOLD_SOURCE' ) ;

242: --
243: BEGIN
244:
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( 'IN OE_HOLD_SOURCES_PVT.CREATE_HOLD_SOURCE' ) ;
247: END IF;
248: SAVEPOINT Create_Hold_Source;
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 269: oe_debug_pub.add( 'CALLING VALIDATEHOLDSOURCE' ) ;

265:
266: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
267:
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'CALLING VALIDATEHOLDSOURCE' ) ;
270: END IF;
271: -- Validation of input arguments
272: ValidateHoldSource
273: ( p_hold_id => p_hold_source_rec.hold_id

Line 284: oe_debug_pub.add( 'VALIDATION NOT SUCCESSFUL' ) ;

280:
281: --dbms_output.put_line ('ValidateHoldSource->x_return_status->' || x_return_status );
282: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'VALIDATION NOT SUCCESSFUL' ) ;
285: END IF;
286: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
287: RAISE FND_API.G_EXC_ERROR;
288: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 309: oe_debug_pub.add( 'DUPLICATE HOLD SOURCE' ) ;

305:
306: IF l_count > 0 THEN
307: --dbms_output.put_line ('Duplicate Hold Source');
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;

Line 471: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

467: nvl(p_entity_code2, 'NO_ENTITY_CODE2')
468: AND nvl(HS.HOLD_ENTITY_ID2, -99) =
469: nvl(p_entity_id2, -99);
470: --
471: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
472: --
473: BEGIN
474:
475: SAVEPOINT release_hold_source;

Line 617: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

613: AND line_id IS NULL
614: AND hold_release_id IS NULL
615: );
616: --
617: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
618: --
619: BEGIN
620:
621: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

694: WHERE line_id = p_line_id
695: AND hold_release_id IS NULL
696: );
697:
698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
699: BEGIN
700:
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702:

Line 739: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

735: --l_hold_entity_code VARCHAR2(1);
736: l_dummy VARCHAR2(30);
737: l_user_id NUMBER;
738: --
739: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
740: --
741: BEGIN
742:
743: IF l_debug_level > 0 THEN

Line 744: oe_debug_pub.add( 'IN INSERT_HOLD_RELEASE' ) ;

740: --
741: BEGIN
742:
743: IF l_debug_level > 0 THEN
744: oe_debug_pub.add( 'IN INSERT_HOLD_RELEASE' ) ;
745: END IF;
746:
747: SAVEPOINT insert_hold_release;
748:

Line 790: oe_debug_pub.add( 'BEFORE INSERT' ) ;

786: --WHERE hold_source_id = p_hold_release_rec.hold_source_id;
787:
788:
789: IF l_debug_level > 0 THEN
790: oe_debug_pub.add( 'BEFORE INSERT' ) ;
791: END IF;
792:
793:
794: SELECT OE_HOLD_RELEASES_S.NEXTVAL

Line 868: oe_debug_pub.add( 'AFTER INSERT' ) ;

864: , p_hold_release_rec.ATTRIBUTE15
865: );
866:
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'AFTER INSERT' ) ;
869: END IF;
870: EXCEPTION
871: WHEN FND_API.G_EXC_ERROR THEN
872: x_return_status := FND_API.G_RET_STS_ERROR;

Line 950: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

946: -- AND item_key = to_char(l.line_id)
947: -- AND l.header_id = p_entity_id)
948: -- );
949: -- --
950: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
951: --
952: BEGIN
953:
954: -- x_return_status := FND_API.G_RET_STS_SUCCESS;