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.CS_GET_REACTION_TIMES_PUB dependencies on FND_API

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42:
43: IF GMT_csr%NOTFOUND THEN
44: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
45: FND_MESSAGE.Set_Token('VALUE','TIME ZONE');
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48: CLOSE GMT_csr;
49:
50: -- DBMS_Output.Put_Line('Offset Hours='|| to_char(l_offset_hours));

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103:
104: IF GMT_csr%NOTFOUND THEN
105: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
106: FND_MESSAGE.Set_Token('VALUE','TIME ZONE');
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109: CLOSE GMT_csr;
110:
111: Convert_to_Mts (l_offset_hours,

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223:
224: IF Coverage_Time_csr%NOTFOUND THEN
225: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
226: FND_MESSAGE.Set_Token('VALUE','COVERAGE TIMES');
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: END IF;
229: CLOSE Coverage_Time_csr;
230:
231: -- DBMS_Output.Put_Line('End of Get Next days coverage');

Line 279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

275: --End of comments
276:
277: PROCEDURE Get_Reaction_Times (
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_coverage_id IN NUMBER,
282: p_business_process_id IN NUMBER,
283: p_start_date_time IN DATE,

Line 280: p_commit IN VARCHAR2 := FND_API.G_FALSE,

276:
277: PROCEDURE Get_Reaction_Times (
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_commit IN VARCHAR2 := FND_API.G_FALSE,
281: p_coverage_id IN NUMBER,
282: p_business_process_id IN NUMBER,
283: p_start_date_time IN DATE,
284: p_call_time_zone_id IN NUMBER,

Line 539: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

535:
536:
537: l_api_name CONSTANT VARCHAR2(30) := 'Get_Reaction_Times';
538: l_api_version CONSTANT NUMBER := 1;
539: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
540: l_start_time DATE;
541: l_end_time DATE;
542: l_end_time_all_mts NUMBER;
543: l_start_time_all_mts NUMBER;

Line 579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

575: p_api_version,
576: p_init_msg_list,
577: '_pub',
578: x_return_status);
579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: IF (NVL(p_exception_coverage_flag,'N') = 'Y') THEN

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

576: p_init_msg_list,
577: '_pub',
578: x_return_status);
579: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582:
583: IF (NVL(p_exception_coverage_flag,'N') = 'Y') THEN
584: CS_GET_COVERAGE_VALUES_PUB.Get_Exception_Coverage(

Line 586: FND_API.G_FALSE,

582:
583: IF (NVL(p_exception_coverage_flag,'N') = 'Y') THEN
584: CS_GET_COVERAGE_VALUES_PUB.Get_Exception_Coverage(
585: 1,
586: FND_API.G_FALSE,
587: FND_API.G_FALSE,
588: p_coverage_id,
589: l_coverage_id,
590: x_return_status,

Line 587: FND_API.G_FALSE,

583: IF (NVL(p_exception_coverage_flag,'N') = 'Y') THEN
584: CS_GET_COVERAGE_VALUES_PUB.Get_Exception_Coverage(
585: 1,
586: FND_API.G_FALSE,
587: FND_API.G_FALSE,
588: p_coverage_id,
589: l_coverage_id,
590: x_return_status,
591: x_msg_count,

Line 593: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

589: l_coverage_id,
590: x_return_status,
591: x_msg_count,
592: x_msg_data);
593: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
594: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
595: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

592: x_msg_data);
593: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
594: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
595: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
598: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
599: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
600: RAISE FND_API.G_EXC_ERROR;

Line 597: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

593: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
594: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
595: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
598: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
599: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
600: RAISE FND_API.G_EXC_ERROR;
601: END IF;

Line 600: RAISE FND_API.G_EXC_ERROR;

596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
598: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
599: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');
600: RAISE FND_API.G_EXC_ERROR;
601: END IF;
602: ELSE
603: l_coverage_id := p_coverage_id;
604: END IF;

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: FND_MESSAGE.Set_Token('VALUE','REACTION TIMES ID');
639: TAPI_DEV_KIT.END_ACTIVITY(p_commit,
640: x_msg_count,
641: x_msg_data);
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: RETURN;
644: END IF;
645: CLOSE Reaction_Times_id_csr;
646: ELSE

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: FND_MESSAGE.Set_Token('VALUE','REACTION TIMES');
680: TAPI_DEV_KIT.END_ACTIVITY(p_commit,
681: x_msg_count,
682: x_msg_data);
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: RETURN;
685: END IF;
686: CLOSE Reaction_Times_csr;
687: END IF;

Line 846: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

842: x_msg_data);
843:
844: l_end_date_time := l_end_date_time + 1;
845:
846: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
847: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
848: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

845:
846: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
847: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
848: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
851: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
852: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');
853: RAISE FND_API.G_EXC_ERROR;

Line 850: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

846: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
847: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
848: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
851: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
852: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;

Line 853: RAISE FND_API.G_EXC_ERROR;

849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
851: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
852: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855:
856: convert_to_mts(l_cov_start_time_hours,
857: l_cov_start_time_mts,

Line 880: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

876: l_end_date_time,
877: x_return_status,
878: x_msg_count,
879: x_msg_data);
880: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
881: FND_MESSAGE.Set_Name ('CS',
882: 'CS_CONTRACTS_VALUE_NOT_FOUND');
883: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

880: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
881: FND_MESSAGE.Set_Name ('CS',
882: 'CS_CONTRACTS_VALUE_NOT_FOUND');
883: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: FND_MESSAGE.Set_Name ('CS',
887: 'CS_CONTRACTS_VALUE_NOT_FOUND');
888: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');

Line 885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

881: FND_MESSAGE.Set_Name ('CS',
882: 'CS_CONTRACTS_VALUE_NOT_FOUND');
883: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: FND_MESSAGE.Set_Name ('CS',
887: 'CS_CONTRACTS_VALUE_NOT_FOUND');
888: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');
889: RAISE FND_API.G_EXC_ERROR;

Line 889: RAISE FND_API.G_EXC_ERROR;

885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: FND_MESSAGE.Set_Name ('CS',
887: 'CS_CONTRACTS_VALUE_NOT_FOUND');
888: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: END If;
892:
893: l_start_time_all_mts := l_cov_start_time_all_mts;

Line 959: FND_API.G_RET_STS_UNEXP_ERROR) THEN

955: to_char(l_end_date_time, 'DD-MON-RR HH24:MI'));
956: **/
957:
958: IF (x_return_status =
959: FND_API.G_RET_STS_UNEXP_ERROR) THEN
960: FND_MESSAGE.Set_Name ('CS',
961: 'CS_CONTRACTS_VALUE_NOT_FOUND');
962: FND_MESSAGE.Set_Token('VALUE','
963: NEXT DAY COVERAGE');

Line 964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

960: FND_MESSAGE.Set_Name ('CS',
961: 'CS_CONTRACTS_VALUE_NOT_FOUND');
962: FND_MESSAGE.Set_Token('VALUE','
963: NEXT DAY COVERAGE');
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)
966: THEN
967: FND_MESSAGE.Set_Name ('CS',
968: 'CS_CONTRACTS_VALUE_NOT_FOUND');

Line 965: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)

961: 'CS_CONTRACTS_VALUE_NOT_FOUND');
962: FND_MESSAGE.Set_Token('VALUE','
963: NEXT DAY COVERAGE');
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)
966: THEN
967: FND_MESSAGE.Set_Name ('CS',
968: 'CS_CONTRACTS_VALUE_NOT_FOUND');
969: FND_MESSAGE.Set_Token('VALUE',

Line 971: RAISE FND_API.G_EXC_ERROR;

967: FND_MESSAGE.Set_Name ('CS',
968: 'CS_CONTRACTS_VALUE_NOT_FOUND');
969: FND_MESSAGE.Set_Token('VALUE',
970: 'NEXT DAY COVERAGE');
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973:
974: -- DBMS_Output.Put_Line('Converting to mts cov. start time');
975:

Line 1004: FND_API.G_RET_STS_UNEXP_ERROR) THEN

1000: x_msg_count,
1001: x_msg_data);
1002:
1003: IF (x_return_status =
1004: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1005: FND_MESSAGE.Set_Name ('CS',
1006: 'CS_CONTRACTS_VALUE_NOT_FOUND');
1007: FND_MESSAGE.Set_Token('VALUE',
1008: 'CONVERT TO GMT');

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: FND_MESSAGE.Set_Name ('CS',
1006: 'CS_CONTRACTS_VALUE_NOT_FOUND');
1007: FND_MESSAGE.Set_Token('VALUE',
1008: 'CONVERT TO GMT');
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF (x_return_status =
1011: FND_API.G_RET_STS_ERROR) THEN
1012: FND_MESSAGE.Set_Name ('CS',
1013: 'CS_CONTRACTS_VALUE_NOT_FOUND');

Line 1011: FND_API.G_RET_STS_ERROR) THEN

1007: FND_MESSAGE.Set_Token('VALUE',
1008: 'CONVERT TO GMT');
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF (x_return_status =
1011: FND_API.G_RET_STS_ERROR) THEN
1012: FND_MESSAGE.Set_Name ('CS',
1013: 'CS_CONTRACTS_VALUE_NOT_FOUND');
1014: FND_MESSAGE.Set_Token('VALUE',
1015: 'CONVERT TO GMT');

Line 1016: RAISE FND_API.G_EXC_ERROR;

1012: FND_MESSAGE.Set_Name ('CS',
1013: 'CS_CONTRACTS_VALUE_NOT_FOUND');
1014: FND_MESSAGE.Set_Token('VALUE',
1015: 'CONVERT TO GMT');
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: END IF;
1019: l_cov_diff := l_cov_end_time_all_mts
1020: - l_cov_start_time_all_mts;

Line 1114: x_return_status := FND_API.G_RET_STS_SUCCESS;

1110:
1111: TAPI_DEV_KIT.END_ACTIVITY(p_commit,
1112: x_msg_count,
1113: x_msg_data);
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: EXCEPTION
1117:
1118: WHEN FND_API.G_EXC_ERROR THEN

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: EXCEPTION
1117:
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,
1122: 'FND_API.G_RET_STS_ERROR',

Line 1122: 'FND_API.G_RET_STS_ERROR',

1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,
1122: 'FND_API.G_RET_STS_ERROR',
1123: x_msg_count,
1124: x_msg_data,
1125: '_pub');
1126: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1123: x_msg_count,
1124: x_msg_data,
1125: '_pub');
1126: APP_EXCEPTION.RAISE_EXCEPTION;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1129: (l_api_name,
1130: G_PKG_NAME,
1131: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1131: 'FND_API.G_RET_STS_UNEXP_ERROR',

1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1129: (l_api_name,
1130: G_PKG_NAME,
1131: 'FND_API.G_RET_STS_UNEXP_ERROR',
1132: x_msg_count,
1133: x_msg_data,
1134: '_pub');
1135: APP_EXCEPTION.RAISE_EXCEPTION;