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

Line 27: p_eam_failure_entry_record IN EAM_Process_Failure_Entry_PUB.EAM_Failure_Entry_Record_Typ

23: /* Procedure to Validate the Failure Information Header Recrod */
24:
25: PROCEDURE Validate_Failure_Entry_Record
26: (
27: p_eam_failure_entry_record IN EAM_Process_Failure_Entry_PUB.EAM_Failure_Entry_Record_Typ
28: , x_reason_failed OUT NOCOPY VARCHAR2
29: , x_token_name OUT NOCOPY VARCHAR2
30: , x_token_value OUT NOCOPY VARCHAR2
31: , x_return_status OUT NOCOPY BOOLEAN

Line 34: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Entry_Record_Typ;

30: , x_token_value OUT NOCOPY VARCHAR2
31: , x_return_status OUT NOCOPY BOOLEAN
32: ) IS
33:
34: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Entry_Record_Typ;
35: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Tbl_Typ;
36: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Typ;
37:
38: l_inventory_item_id NUMBER;

Line 35: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Tbl_Typ;

31: , x_return_status OUT NOCOPY BOOLEAN
32: ) IS
33:
34: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Entry_Record_Typ;
35: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Tbl_Typ;
36: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Typ;
37:
38: l_inventory_item_id NUMBER;
39: l_organization_id NUMBER;

Line 36: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Typ;

32: ) IS
33:
34: l_eam_failure_entry_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Entry_Record_Typ;
35: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Tbl_Typ;
36: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.Eam_Failure_Codes_Typ;
37:
38: l_inventory_item_id NUMBER;
39: l_organization_id NUMBER;
40:

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

70: l_eam_failure_entry_record := p_eam_failure_entry_record;
71:
72: l_failure_exists := 0;
73:
74: IF ( l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
75: AND l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE
76: )
77: THEN
78: /* Invalid Transaction Type */

Line 75: AND l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE

71:
72: l_failure_exists := 0;
73:
74: IF ( l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_CREATE
75: AND l_eam_failure_entry_record.transaction_type <> Eam_Process_Failure_Entry_PUB.G_FE_UPDATE
76: )
77: THEN
78: /* Invalid Transaction Type */
79: x_reason_failed := 'EAM_FA_INVALID_TXN_TYPE';

Line 93: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE

89: x_return_status := false;
90: return ;
91: END IF;
92:
93: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE
94: THEN
95:
96: IF ( l_eam_failure_entry_record.source_id IS NULL
97: OR l_eam_failure_entry_record.source_type IS NULL

Line 186: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN

182: x_return_status := false;
183: return ;
184: END IF;
185:
186: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
187:
188: /* Failure Date is Already Validated on top of the API for both Create/ Update */
189:
190: SELECT COUNT(1)

Line 214: p_eam_failure_codes_tbl_typ IN Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ

210: /* Procedure to Validate the Child Failure Information Record Table.
211: */
212: PROCEDURE Validate_Failure_Codes
213: (
214: p_eam_failure_codes_tbl_typ IN Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ
215: , x_reason_failed OUT NOCOPY VARCHAR2
216: , x_token_name OUT NOCOPY VARCHAR2
217: , x_token_value OUT NOCOPY VARCHAR2
218: , x_return_status OUT NOCOPY BOOLEAN

Line 221: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;

217: , x_token_value OUT NOCOPY VARCHAR2
218: , x_return_status OUT NOCOPY BOOLEAN
219: ) IS
220:
221: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
222: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.eam_failure_codes_typ;
223:
224: l_valid_header_record NUMBER;
225: l_valid_failure_code NUMBER;

Line 222: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.eam_failure_codes_typ;

218: , x_return_status OUT NOCOPY BOOLEAN
219: ) IS
220:
221: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ;
222: l_eam_failure_codes_record Eam_Process_Failure_Entry_PUB.eam_failure_codes_typ;
223:
224: l_valid_header_record NUMBER;
225: l_valid_failure_code NUMBER;
226: l_valid_cause_code NUMBER;

Line 256: IF l_eam_failure_codes_record.transaction_type IN (Eam_Process_Failure_Entry_PUB.G_FE_CREATE, Eam_Process_Failure_Entry_PUB.G_FE_UPDATE) THEN

252: LOOP
253:
254: l_eam_failure_codes_record := l_eam_failure_codes_tbl(i);
255:
256: IF l_eam_failure_codes_record.transaction_type IN (Eam_Process_Failure_Entry_PUB.G_FE_CREATE, Eam_Process_Failure_Entry_PUB.G_FE_UPDATE) THEN
257:
258: SELECT count(1)
259: INTO l_valid_header_record
260: FROM eam_asset_failures eaf

Line 269: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN

265: x_return_status := false;
266: return ;
267: END IF;
268:
269: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
270: BEGIN
271: SELECT failure_code, cause_code, resolution_code
272: INTO l_old_failure_code, l_old_cause_code, l_old_resolution_code
273: FROM eam_asset_failure_codes

Line 312: ELSIF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN

308: END IF;
309:
310: END IF;
311:
312: ELSIF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
313:
314: IF ( l_eam_failure_codes_record.failure_code IS NULL
315: AND l_eam_failure_codes_record.cause_code IS NULL
316: AND l_eam_failure_codes_record.resolution_code IS NULL

Line 529: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

525: -- Default = FND_API.G_FALSE
526: -- p_commit IN VARCHAR2 Optional
527: -- Default = FND_API.G_FALSE
528: -- p_eam_failure_entry_record IN
529: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
530: -- p_eam_failure_codes_tbl IN
531: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
532: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
533: -- x_msg_count OUT NOCOPY NUMBER

Line 531: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

527: -- Default = FND_API.G_FALSE
528: -- p_eam_failure_entry_record IN
529: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
530: -- p_eam_failure_codes_tbl IN
531: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
532: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
533: -- x_msg_count OUT NOCOPY NUMBER
534: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
535: -- x_eam_failure_entry_record OUT NOCOPY

Line 536: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

532: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
533: -- x_msg_count OUT NOCOPY NUMBER
534: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
535: -- x_eam_failure_entry_record OUT NOCOPY
536: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
537: -- x_eam_failure_codes_tbl OUT NOCOPY
538: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
539: -- Version : Current version 1.0.
540: -- Initial version 1.0

Line 538: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

534: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
535: -- x_eam_failure_entry_record OUT NOCOPY
536: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
537: -- x_eam_failure_codes_tbl OUT NOCOPY
538: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
539: -- Version : Current version 1.0.
540: -- Initial version 1.0
541: -- End of comments
542: ***************************************************************************/

Line 548: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

544: PROCEDURE Process_Failure_Entry
545: ( p_api_version IN NUMBER := 1.0
546: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
547: , p_commit IN VARCHAR2 := FND_API.G_FALSE
548: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
549: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_msg_count OUT NOCOPY NUMBER
552: , x_msg_data OUT NOCOPY VARCHAR2

Line 549: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

545: ( p_api_version IN NUMBER := 1.0
546: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
547: , p_commit IN VARCHAR2 := FND_API.G_FALSE
548: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
549: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_msg_count OUT NOCOPY NUMBER
552: , x_msg_data OUT NOCOPY VARCHAR2
553: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

Line 553: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

549: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_msg_count OUT NOCOPY NUMBER
552: , x_msg_data OUT NOCOPY VARCHAR2
553: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
554: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
555: ) IS
556:
557: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';

Line 554: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_msg_count OUT NOCOPY NUMBER
552: , x_msg_data OUT NOCOPY VARCHAR2
553: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
554: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
555: ) IS
556:
557: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
558: l_api_version CONSTANT NUMBER := 1.0;

Line 560: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;

556:
557: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
558: l_api_version CONSTANT NUMBER := 1.0;
559:
560: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
561: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
562: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
563:
564: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;

Line 561: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;

557: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
558: l_api_version CONSTANT NUMBER := 1.0;
559:
560: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
561: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
562: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
563:
564: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;
565:

Line 562: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;

558: l_api_version CONSTANT NUMBER := 1.0;
559:
560: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
561: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
562: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
563:
564: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;
565:
566: l_failure_id NUMBER;

Line 618: ELSIF l_eam_failure_entry_record.transaction_type IN (Eam_Process_Failure_Entry_PUB.G_FE_CREATE, Eam_Process_Failure_Entry_PUB.G_FE_UPDATE) THEN

614:
615: IF l_eam_failure_entry_record.transaction_type IS NULL THEN
616: --Don't validate the header record
617: NULL;
618: ELSIF l_eam_failure_entry_record.transaction_type IN (Eam_Process_Failure_Entry_PUB.G_FE_CREATE, Eam_Process_Failure_Entry_PUB.G_FE_UPDATE) THEN
619: /* dbms_output.put_line('Befor Validate_failure_entry_record'); */
620: l_return_status := true;
621: validate_failure_entry_record(
622: p_eam_failure_entry_record => l_eam_failure_entry_record

Line 659: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN

655: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures00'); */
656:
657: IF l_eam_failure_entry_record.transaction_type IS NOT NULL THEN
658:
659: IF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
660: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failures0'); */
661: SELECT eam_asset_failures_s.nextval
662: INTO l_failure_id
663: FROM DUAL;

Line 706: IF l_eam_failure_codes_tbl(i).transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN

702: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failures'); */
703:
704: FOR i IN 1..l_eam_failure_codes_tbl.count
705: LOOP
706: IF l_eam_failure_codes_tbl(i).transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
707: l_eam_failure_codes_tbl(i).failure_id := l_failure_id;
708: END IF;
709: END LOOP;
710:

Line 711: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN

707: l_eam_failure_codes_tbl(i).failure_id := l_failure_id;
708: END IF;
709: END LOOP;
710:
711: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
712: /* dbms_output.put_line('Just Before Updating the data into eam_asset_failures'); */
713: UPDATE eam_asset_failures
714: SET failure_date = l_eam_failure_entry_record.failure_date
715: /* ,source_typ = l_eam_failure_entry_record.source_typ

Line 802: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN

798: END;
799: END IF;
800: l_eam_failure_codes_record.combination_id := l_combination_id;
801:
802: IF l_eam_failure_codes_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_CREATE THEN
803:
804: /* dbms_output.put_line('Just Before Inserting the data into eam_asset_failure_codes'); */
805:
806: SELECT eam_asset_failure_codes_s.nextval

Line 843: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN

839: FND_GLOBAL.user_id
840: );
841: /* dbms_output.put_line('Just After Inserting the data into eam_asset_failure_codes'); */
842:
843: ELSIF l_eam_failure_entry_record.transaction_type = Eam_Process_Failure_Entry_PUB.G_FE_UPDATE THEN
844:
845: UPDATE eam_asset_failure_codes
846: SET failure_code = l_eam_failure_codes_record.failure_code
847: ,cause_code = l_eam_failure_codes_record.cause_code