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_FAILURECODES_PVT dependencies on EAM_FAILURECODES_PUB

Line 26: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type)

22: -- to Setup_Code API
23: PROCEDURE Validate_Code
24: (p_mode IN VARCHAR2,
25: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
26: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type)
27: IS
28: l_code_exists NUMBER;
29: l_eff_end_date DATE;
30: l_code_in_use NUMBER;

Line 40: (EAM_FailureCodes_PUB.G_FAILURE_CODE,

36: Raise_Error ('EAM_FAILURECODE_MANDATORY', 'MAND_PARAM', 'code or code type');
37: END IF;
38:
39: IF (p_failurecode_rec.code_type NOT IN
40: (EAM_FailureCodes_PUB.G_FAILURE_CODE,
41: EAM_FailureCodes_PUB.G_CAUSE_CODE,
42: EAM_FailureCodes_PUB.G_RESOLUTION_CODE)) THEN
43: Raise_Error ('EAM_FAILURECODE_TYPE_INVALID','CODE_TYPE', p_failurecode_rec.code_type);
44: END IF;

Line 41: EAM_FailureCodes_PUB.G_CAUSE_CODE,

37: END IF;
38:
39: IF (p_failurecode_rec.code_type NOT IN
40: (EAM_FailureCodes_PUB.G_FAILURE_CODE,
41: EAM_FailureCodes_PUB.G_CAUSE_CODE,
42: EAM_FailureCodes_PUB.G_RESOLUTION_CODE)) THEN
43: Raise_Error ('EAM_FAILURECODE_TYPE_INVALID','CODE_TYPE', p_failurecode_rec.code_type);
44: END IF;
45:

Line 42: EAM_FailureCodes_PUB.G_RESOLUTION_CODE)) THEN

38:
39: IF (p_failurecode_rec.code_type NOT IN
40: (EAM_FailureCodes_PUB.G_FAILURE_CODE,
41: EAM_FailureCodes_PUB.G_CAUSE_CODE,
42: EAM_FailureCodes_PUB.G_RESOLUTION_CODE)) THEN
43: Raise_Error ('EAM_FAILURECODE_TYPE_INVALID','CODE_TYPE', p_failurecode_rec.code_type);
44: END IF;
45:
46: l_code_exists := 0;

Line 48: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN

44: END IF;
45:
46: l_code_exists := 0;
47: BEGIN
48: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
49: SELECT effective_end_date
50: INTO l_eff_end_date
51: FROM eam_failure_codes
52: WHERE failure_code = p_failurecode_rec.code;

Line 53: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

49: SELECT effective_end_date
50: INTO l_eff_end_date
51: FROM eam_failure_codes
52: WHERE failure_code = p_failurecode_rec.code;
53: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
54: SELECT effective_end_date
55: INTO l_eff_end_date
56: FROM eam_cause_codes
57: WHERE cause_code = p_failurecode_rec.code;

Line 58: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

54: SELECT effective_end_date
55: INTO l_eff_end_date
56: FROM eam_cause_codes
57: WHERE cause_code = p_failurecode_rec.code;
58: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
59: SELECT effective_end_date
60: INTO l_eff_end_date
61: FROM eam_resolution_codes
62: WHERE resolution_code = p_failurecode_rec.code;

Line 96: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN

92: END IF;
93:
94: l_code_in_use := 0;
95:
96: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
97: SELECT count(1)
98: INTO l_code_in_use
99: FROM eam_failure_combinations
100: WHERE failure_code = p_failurecode_rec.code

Line 102: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

98: INTO l_code_in_use
99: FROM eam_failure_combinations
100: WHERE failure_code = p_failurecode_rec.code
101: AND rownum < 2;
102: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
103: SELECT count(1)
104: INTO l_code_in_use
105: FROM eam_failure_combinations
106: WHERE cause_code = p_failurecode_rec.code

Line 108: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

104: INTO l_code_in_use
105: FROM eam_failure_combinations
106: WHERE cause_code = p_failurecode_rec.code
107: AND rownum < 2;
108: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
109: SELECT count(1)
110: INTO l_code_in_use
111: FROM eam_failure_combinations
112: WHERE resolution_code = p_failurecode_rec.code

Line 127: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,

123: -- to Setup_Combination API
124: PROCEDURE Validate_Combination
125: (p_mode IN VARCHAR2,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
127: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
128: x_set_id OUT NOCOPY NUMBER,
129: x_failure_exists OUT NOCOPY NUMBER,
130: x_cause_exists OUT NOCOPY NUMBER,
131: x_resolution_exists OUT NOCOPY NUMBER,

Line 336: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,

332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
335: p_mode IN VARCHAR2 ,
336: p_failurecode_rec IN EAM_FailureCodes_PUB.eam_failurecode_rec_type,
337: x_return_status OUT NOCOPY VARCHAR2 ,
338: x_msg_count OUT NOCOPY NUMBER ,
339: x_msg_data OUT NOCOPY VARCHAR2
340: )

Line 392: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN

388: l_code := p_failurecode_rec.code;
389:
390: IF (p_mode = 'C') THEN
391:
392: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
393:
394: -- Insert into eam failure codes
395: INSERT INTO eam_failure_codes
396: (failure_code ,

Line 412: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

408: SYSDATE,
409: SYSDATE,
410: fnd_global.user_id,
411: NULL);
412: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
413:
414: -- Insert into eam cause codes
415: INSERT INTO eam_cause_codes
416: (cause_code ,

Line 432: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

428: SYSDATE,
429: SYSDATE,
430: fnd_global.user_id,
431: NULL);
432: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
433:
434: -- Insert into eam resolution codes
435: INSERT INTO eam_resolution_codes
436: (resolution_code ,

Line 456: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN

452: END IF;
453:
454: ELSIF (p_mode = 'U') THEN
455:
456: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
457: OPEN lock_fc;
458: UPDATE eam_failure_codes
459: SET description = decode(p_failurecode_rec.description,
460: NULL,description,

Line 470: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

466: FND_API.G_MISS_DATE,NULL,
467: p_failurecode_rec.effective_end_date)
468: WHERE failure_code = l_code;
469: CLOSE lock_fc;
470: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
471: OPEN lock_cc;
472: UPDATE eam_cause_codes
473: SET description = decode(p_failurecode_rec.description,
474: NULL,description,

Line 484: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

480: FND_API.G_MISS_DATE,NULL,
481: p_failurecode_rec.effective_end_date)
482: WHERE cause_code = l_code;
483: CLOSE lock_cc;
484: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
485: OPEN lock_rc;
486: UPDATE eam_resolution_codes
487: SET description = decode(p_failurecode_rec.description,
488: NULL,description,

Line 502: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN

498: END IF;
499:
500: ELSIF (p_mode = 'D') THEN
501:
502: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
503: DELETE FROM eam_failure_codes
504: WHERE failure_code = l_code;
505: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
506: DELETE FROM eam_cause_codes

Line 505: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

501:
502: IF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
503: DELETE FROM eam_failure_codes
504: WHERE failure_code = l_code;
505: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
506: DELETE FROM eam_cause_codes
507: WHERE cause_code = l_code;
508: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
509: DELETE FROM eam_resolution_codes

Line 508: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

504: WHERE failure_code = l_code;
505: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
506: DELETE FROM eam_cause_codes
507: WHERE cause_code = l_code;
508: ELSIF (p_failurecode_rec.code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
509: DELETE FROM eam_resolution_codes
510: WHERE resolution_code = l_code;
511: END IF;
512:

Line 566: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,

562: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
563: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
564: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
565: p_mode IN VARCHAR2 ,
566: p_combination_rec IN EAM_FailureCodes_PUB.eam_combination_rec_type,
567: x_return_status OUT NOCOPY VARCHAR2 ,
568: x_msg_count OUT NOCOPY NUMBER ,
569: x_msg_data OUT NOCOPY VARCHAR2 ,
570: x_combination_id OUT NOCOPY NUMBER

Line 582: failure_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;

578: l_combination_id NUMBER;
579: l_failure_exists NUMBER;
580: l_cause_exists NUMBER;
581: l_resolution_exists NUMBER;
582: failure_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
583: cause_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
584: resolution_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
585: l_failure_code_status VARCHAR2(1);
586: l_cause_code_status VARCHAR2(1);

Line 583: cause_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;

579: l_failure_exists NUMBER;
580: l_cause_exists NUMBER;
581: l_resolution_exists NUMBER;
582: failure_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
583: cause_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
584: resolution_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
585: l_failure_code_status VARCHAR2(1);
586: l_cause_code_status VARCHAR2(1);
587: l_resolution_code_status VARCHAR2(1);

Line 584: resolution_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;

580: l_cause_exists NUMBER;
581: l_resolution_exists NUMBER;
582: failure_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
583: cause_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
584: resolution_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
585: l_failure_code_status VARCHAR2(1);
586: l_cause_code_status VARCHAR2(1);
587: l_resolution_code_status VARCHAR2(1);
588: l_msg_count NUMBER;

Line 650: failure_rec.code_type := EAM_FailureCodes_PUB.G_FAILURE_CODE;

646:
647: /** Commented since dynamic code creation is not allowed ** Bug#5070342
648: IF (l_failure_exists = 0) THEN
649: -- create failure code
650: failure_rec.code_type := EAM_FailureCodes_PUB.G_FAILURE_CODE;
651: failure_rec.code := p_combination_rec.failure_code;
652: failure_rec.description:= p_combination_rec.failure_description;
653: Setup_Code (p_api_version => 1.0,
654: p_init_msg_list => p_init_msg_list,

Line 667: cause_rec.code_type := EAM_FailureCodes_PUB.G_CAUSE_CODE;

663:
664: l_cause_code_status := FND_API.G_RET_STS_SUCCESS;
665: IF (l_cause_exists = 0) THEN
666: -- create cause code
667: cause_rec.code_type := EAM_FailureCodes_PUB.G_CAUSE_CODE;
668: cause_rec.code := p_combination_rec.cause_code;
669: cause_rec.description:= p_combination_rec.cause_description;
670: Setup_Code (p_api_version => 1.0,
671: p_init_msg_list => p_init_msg_list,

Line 684: resolution_rec.code_type := EAM_FailureCodes_PUB.G_RESOLUTION_CODE;

680:
681: l_resolution_code_status := FND_API.G_RET_STS_SUCCESS;
682: IF (l_resolution_exists = 0) THEN
683: -- create resolution code
684: resolution_rec.code_type := EAM_FailureCodes_PUB.G_RESOLUTION_CODE;
685: resolution_rec.code := p_combination_rec.resolution_code;
686: resolution_rec.description:= p_combination_rec.resolution_description;
687: Setup_Code (p_api_version => 1.0,
688: p_init_msg_list => p_init_msg_list,

Line 926: l_failurecode_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;

922: x_return_status OUT NOCOPY VARCHAR2,
923: x_msg_count OUT NOCOPY NUMBER ,
924: x_msg_data OUT NOCOPY VARCHAR2
925: ) IS
926: l_failurecode_rec EAM_FailureCodes_PUB.eam_failurecode_rec_type;
927: BEGIN
928: l_failurecode_rec.code_type := p_code_type;
929: l_failurecode_rec.code := p_code;
930: l_failurecode_rec.stored_last_upd_date := p_stored_last_upd_date;

Line 981: l_combination_rec EAM_FailureCodes_PUB.eam_combination_rec_type;

977: x_msg_count OUT NOCOPY NUMBER ,
978: x_msg_data OUT NOCOPY VARCHAR2,
979: x_combination_id OUT NOCOPY NUMBER
980: ) IS
981: l_combination_rec EAM_FailureCodes_PUB.eam_combination_rec_type;
982: BEGIN
983: l_combination_rec.set_id := p_set_id;
984: l_combination_rec.set_name := p_set_name;
985: l_combination_rec.failure_code := p_failure_code;

Line 1056: IF (p_code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN

1052:
1053: -- Initialize API return status to success
1054: x_return_status := FND_API.G_RET_STS_SUCCESS;
1055: BEGIN
1056: IF (p_code_type = EAM_FailureCodes_PUB.G_FAILURE_CODE) THEN
1057: OPEN lock_fc;
1058: FETCH lock_fc
1059: INTO l_description, l_end_date, l_last_update_date;
1060: l_rowcount := lock_fc%ROWCOUNT;

Line 1062: ELSIF (p_code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN

1058: FETCH lock_fc
1059: INTO l_description, l_end_date, l_last_update_date;
1060: l_rowcount := lock_fc%ROWCOUNT;
1061: CLOSE lock_fc;
1062: ELSIF (p_code_type = EAM_FailureCodes_PUB.G_CAUSE_CODE) THEN
1063: OPEN lock_cc;
1064: FETCH lock_cc
1065: INTO l_description, l_end_date, l_last_update_date;
1066: l_rowcount := lock_cc%ROWCOUNT;

Line 1068: ELSIF (p_code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN

1064: FETCH lock_cc
1065: INTO l_description, l_end_date, l_last_update_date;
1066: l_rowcount := lock_cc%ROWCOUNT;
1067: CLOSE lock_cc;
1068: ELSIF (p_code_type = EAM_FailureCodes_PUB.G_RESOLUTION_CODE) THEN
1069: OPEN lock_rc;
1070: FETCH lock_rc
1071: INTO l_description, l_end_date, l_last_update_date;
1072: l_rowcount := lock_rc%ROWCOUNT;