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 533: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

529: -- Default = FND_API.G_FALSE
530: -- p_commit IN VARCHAR2 Optional
531: -- Default = FND_API.G_FALSE
532: -- p_eam_failure_entry_record IN
533: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
534: -- p_eam_failure_codes_tbl IN
535: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
536: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
537: -- x_msg_count OUT NOCOPY NUMBER

Line 535: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

531: -- Default = FND_API.G_FALSE
532: -- p_eam_failure_entry_record IN
533: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
534: -- p_eam_failure_codes_tbl IN
535: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
536: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
537: -- x_msg_count OUT NOCOPY NUMBER
538: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
539: -- x_eam_failure_entry_record OUT NOCOPY

Line 540: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

536: -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
537: -- x_msg_count OUT NOCOPY NUMBER
538: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
539: -- x_eam_failure_entry_record OUT NOCOPY
540: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
541: -- x_eam_failure_codes_tbl OUT NOCOPY
542: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
543: -- Version : Current version 1.0.
544: -- Initial version 1.0

Line 542: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

538: -- x_msg_data OUT NOCOPY VARCHAR2(2000)
539: -- x_eam_failure_entry_record OUT NOCOPY
540: -- Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
541: -- x_eam_failure_codes_tbl OUT NOCOPY
542: -- Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
543: -- Version : Current version 1.0.
544: -- Initial version 1.0
545: -- End of comments
546: ***************************************************************************/

Line 552: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

548: PROCEDURE Process_Failure_Entry
549: ( p_api_version IN NUMBER := 1.0
550: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
551: , p_commit IN VARCHAR2 := FND_API.G_FALSE
552: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
553: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
554: , x_return_status OUT NOCOPY VARCHAR2
555: , x_msg_count OUT NOCOPY NUMBER
556: , x_msg_data OUT NOCOPY VARCHAR2

Line 553: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

549: ( p_api_version IN NUMBER := 1.0
550: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
551: , p_commit IN VARCHAR2 := FND_API.G_FALSE
552: , p_eam_failure_entry_record IN Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ
553: , p_eam_failure_codes_tbl IN Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ
554: , x_return_status OUT NOCOPY VARCHAR2
555: , x_msg_count OUT NOCOPY NUMBER
556: , x_msg_data OUT NOCOPY VARCHAR2
557: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

Line 557: , x_eam_failure_entry_record OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_entry_record_typ

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

Line 558: , x_eam_failure_codes_tbl OUT NOCOPY Eam_Process_Failure_Entry_PUB.eam_failure_codes_tbl_typ

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

Line 564: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;

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

Line 565: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;

561: l_api_name CONSTANT VARCHAR2(30) := 'Process_Failure_Entry';
562: l_api_version CONSTANT NUMBER := 1.0;
563:
564: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
565: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
566: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
567:
568: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;
569:

Line 566: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;

562: l_api_version CONSTANT NUMBER := 1.0;
563:
564: l_eam_failure_entry_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Entry_Record_Typ;
565: l_eam_failure_codes_tbl Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Tbl_Typ;
566: l_eam_failure_codes_record Eam_Process_Failure_Entry_Pub.Eam_Failure_Codes_Typ;
567:
568: l_eam_asset_failure_codes_rec Eam_Asset_Failure_Codes%ROWTYPE;
569:
570: l_failure_id NUMBER;

Line 622: 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

618:
619: IF l_eam_failure_entry_record.transaction_type IS NULL THEN
620: --Don't validate the header record
621: NULL;
622: 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
623: /* dbms_output.put_line('Befor Validate_failure_entry_record'); */
624: l_return_status := true;
625: validate_failure_entry_record(
626: p_eam_failure_entry_record => l_eam_failure_entry_record

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

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

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

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

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

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

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

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

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

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