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.EAM_PROCESS_FAILURE_ENTRY_PUB dependencies on EAM_PROCESS_FAILURE_ENTRY_PUB

Line 1: PACKAGE BODY EAM_Process_Failure_Entry_PUB AS

1: PACKAGE BODY EAM_Process_Failure_Entry_PUB AS
2: /* $Header: EAMPFENB.pls 120.1.12010000.2 2009/04/20 05:43:51 vchidura ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_Process_Failure_Entry_PUB';
4:
5: /**************************************************************************

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_Process_Failure_Entry_PUB';

1: PACKAGE BODY EAM_Process_Failure_Entry_PUB AS
2: /* $Header: EAMPFENB.pls 120.1.12010000.2 2009/04/20 05:43:51 vchidura ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_Process_Failure_Entry_PUB';
4:
5: /**************************************************************************
6: -- Start of comments
7: -- API name : Process_Failure_Entry

Line 19: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

15: -- Default = FND_API.G_FALSE
16: -- p_commit IN VARCHAR2 Optional
17: -- Default = FND_API.G_FALSE
18: -- p_eam_failure_entry_record IN
19: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
20: -- p_eam_failure_codes_tbl IN
21: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
22: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
23: -- x_msg_count OUT NOCOPY NUMBER

Line 21: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

17: -- Default = FND_API.G_FALSE
18: -- p_eam_failure_entry_record IN
19: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
20: -- p_eam_failure_codes_tbl IN
21: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
22: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
23: -- x_msg_count OUT NOCOPY NUMBER
24: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
25: -- x_eam_failure_entry_record OUT NOCOPY

Line 26: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

22: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
23: -- x_msg_count OUT NOCOPY NUMBER
24: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
25: -- x_eam_failure_entry_record OUT NOCOPY
26: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
27: -- x_eam_failure_codes_tbl OUT NOCOPY
28: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
29: -- Version : Current version 1.0.
30: -- Initial version 1.0

Line 28: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

24: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
25: -- x_eam_failure_entry_record OUT NOCOPY
26: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
27: -- x_eam_failure_codes_tbl OUT NOCOPY
28: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
29: -- Version : Current version 1.0.
30: -- Initial version 1.0
31: -- End of comments
32: ***************************************************************************/

Line 38: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

34: PROCEDURE Process_Failure_Entry
35: ( p_api_version IN NUMBER := 1.0
36: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
37: , p_commit IN VARCHAR2 := FND_API.G_FALSE
38: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
39: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
40: , x_return_status OUT NOCOPY VARCHAR2
41: , x_msg_count OUT NOCOPY NUMBER
42: , x_msg_data OUT NOCOPY VARCHAR2

Line 39: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

35: ( p_api_version IN NUMBER := 1.0
36: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
37: , p_commit IN VARCHAR2 := FND_API.G_FALSE
38: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
39: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
40: , x_return_status OUT NOCOPY VARCHAR2
41: , x_msg_count OUT NOCOPY NUMBER
42: , x_msg_data OUT NOCOPY VARCHAR2
43: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

Line 43: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

39: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
40: , x_return_status OUT NOCOPY VARCHAR2
41: , x_msg_count OUT NOCOPY NUMBER
42: , x_msg_data OUT NOCOPY VARCHAR2
43: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
44: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
45: ) IS
46:
47: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';

Line 44: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

40: , x_return_status OUT NOCOPY VARCHAR2
41: , x_msg_count OUT NOCOPY NUMBER
42: , x_msg_data OUT NOCOPY VARCHAR2
43: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
44: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
45: ) IS
46:
47: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
48: l_api_version CONSTANT NUMBER := 1.0;

Line 50: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;

46:
47: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
48: l_api_version CONSTANT NUMBER := 1.0;
49:
50: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
51: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
52:
53: l_out_msg_count NUMBER ;
54: l_out_msg_data VARCHAR2(4000);

Line 51: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;

47: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
48: l_api_version CONSTANT NUMBER := 1.0;
49:
50: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
51: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
52:
53: l_out_msg_count NUMBER ;
54: l_out_msg_data VARCHAR2(4000);
55: l_out_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;

Line 55: l_out_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;

51: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
52:
53: l_out_msg_count NUMBER ;
54: l_out_msg_data VARCHAR2(4000);
55: l_out_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
56: l_out_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
57:
58:
59: l_object_type NUMBER;

Line 56: l_out_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;

52:
53: l_out_msg_count NUMBER ;
54: l_out_msg_data VARCHAR2(4000);
55: l_out_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ;
56: l_out_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
57:
58:
59: l_object_type NUMBER;
60: l_object_id NUMBER;

Line 116: IF (( l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE

112:
113: /*******************************
114: Following Validations Are for 11510 Design.
115: ********************************/
116: IF (( l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
117: AND l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE)
118: OR l_eam_failure_entry_record.transaction_type IS NULL
119: )
120: THEN

Line 117: AND l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE)

113: /*******************************
114: Following Validations Are for 11510 Design.
115: ********************************/
116: IF (( l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
117: AND l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE)
118: OR l_eam_failure_entry_record.transaction_type IS NULL
119: )
120: THEN
121: /* Invalid Transaction Type */

Line 131: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE

127: FND_MESSAGE.SET_NAME ('EAM', 'EAM_MULTIPLE_CHILD');
128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF ( l_eam_failure_codes_tbl.count = 1
131: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
132: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE
133: )
134: THEN
135: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');

Line 132: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE

128: FND_MSG_PUB.Add;
129: RAISE FND_API.G_EXC_ERROR;
130: ELSIF ( l_eam_failure_codes_tbl.count = 1
131: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
132: AND l_eam_failure_codes_tbl(1).transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE
133: )
134: THEN
135: FND_MESSAGE.SET_NAME ('EAM', 'EAM_FA_INVALID_TXN_TYPE');
136: FND_MSG_PUB.Add;

Line 149: IF l_eam_failure_entry_record.transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_CREATE THEN

145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148:
149: IF l_eam_failure_entry_record.transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_CREATE THEN
150:
151: IF l_eam_failure_entry_record.source_type = 1
152: THEN
153:

Line 316: ELSIF l_eam_failure_entry_record.transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_UPDATE THEN

312: END IF;
313:
314: END IF;
315:
316: ELSIF l_eam_failure_entry_record.transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
317:
318: IF l_eam_failure_entry_record.failure_id IS NULL THEN
319:
320: IF ( l_eam_failure_entry_record.source_type = 1

Line 639: IF l_eam_failure_codes_tbl(i).transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_UPDATE THEN

635:
636: FOR i in 1..l_eam_failure_codes_tbl.count
637: LOOP
638:
639: IF l_eam_failure_codes_tbl(i).transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
640:
641: l_eam_failure_codes_tbl(i).failure_id := l_eam_failure_entry_record.failure_id;
642:
643: IF l_eam_failure_codes_tbl(i).failure_entry_id IS NULL

Line 708: ELSIF l_eam_failure_codes_tbl(i).transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_CREATE THEN

704: ELSIF l_eam_failure_codes_tbl(i).comments IS NULL THEN
705: l_eam_failure_codes_tbl(i).comments := l_comments;
706: END IF;
707:
708: ELSIF l_eam_failure_codes_tbl(i).transaction_type = EAM_Process_Failure_Entry_PUB.G_FE_CREATE THEN
709:
710: l_eam_failure_codes_tbl(i).failure_id := l_eam_failure_entry_record.failure_id;
711:
712: END IF;

Line 907: END EAM_Process_Failure_Entry_PUB;

903: );
904: END;
905:
906:
907: END EAM_Process_Failure_Entry_PUB;