DBA Data[Home] [Help]

APPS.CS_GET_REACTION_TIMES_PUB dependencies on FND_MESSAGE

Line 44: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

40: l_offset_mts,
41: l_offset_indicator;
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;

Line 45: FND_MESSAGE.Set_Token('VALUE','TIME ZONE');

41: l_offset_indicator;
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:

Line 105: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

101: l_offset_mts,
102: l_offset_indicator;
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;

Line 106: FND_MESSAGE.Set_Token('VALUE','TIME ZONE');

102: l_offset_indicator;
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:

Line 225: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

221:
222: -- DBMS_Output.Put_Line('Fetched cov. start and end');
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;

Line 226: FND_MESSAGE.Set_Token('VALUE','COVERAGE TIMES');

222: -- DBMS_Output.Put_Line('Fetched cov. start and end');
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:

Line 594: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

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
598: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

Line 595: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');

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
598: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
599: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');

Line 598: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

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;
602: ELSE

Line 599: FND_MESSAGE.Set_Token('VALUE','EXCEPTION COVERAGE');

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;
602: ELSE
603: l_coverage_id := p_coverage_id;

Line 637: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

633:
634:
635: IF Reaction_Times_id_csr%NOTFOUND THEN
636: CLOSE Reaction_Times_id_csr;
637: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
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);

Line 638: FND_MESSAGE.Set_Token('VALUE','REACTION TIMES ID');

634:
635: IF Reaction_Times_id_csr%NOTFOUND THEN
636: CLOSE Reaction_Times_id_csr;
637: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
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;

Line 678: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

674: l_coverage_txn_group_id ;
675:
676: IF Reaction_Times_csr%NOTFOUND THEN
677: CLOSE Reaction_Times_csr;
678: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
679: FND_MESSAGE.Set_Token('VALUE','REACTION TIMES');
680: TAPI_DEV_KIT.END_ACTIVITY(p_commit,
681: x_msg_count,
682: x_msg_data);

Line 679: FND_MESSAGE.Set_Token('VALUE','REACTION TIMES');

675:
676: IF Reaction_Times_csr%NOTFOUND THEN
677: CLOSE Reaction_Times_csr;
678: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
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;

Line 847: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

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
851: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

Line 848: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');

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
851: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');
852: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');

Line 851: FND_MESSAGE.Set_Name ('CS','CS_CONTRACTS_VALUE_NOT_FOUND');

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;
855:

Line 852: FND_MESSAGE.Set_Token('VALUE','NEXT DAY COVERAGE');

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;
855:
856: convert_to_mts(l_cov_start_time_hours,

Line 881: FND_MESSAGE.Set_Name ('CS',

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;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 883: FND_MESSAGE.Set_Token('VALUE','CONVERT TO GMT');

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;
885: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
886: FND_MESSAGE.Set_Name ('CS',
887: 'CS_CONTRACTS_VALUE_NOT_FOUND');

Line 886: 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;
890: END IF;

Line 888: 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;
890: END IF;
891: END If;
892:

Line 960: FND_MESSAGE.Set_Name ('CS',

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');
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 962: FND_MESSAGE.Set_Token('VALUE','

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');
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: ELSIF(x_return_status = FND_API.G_RET_STS_ERROR)
966: THEN

Line 967: FND_MESSAGE.Set_Name ('CS',

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',
970: 'NEXT DAY COVERAGE');
971: RAISE FND_API.G_EXC_ERROR;

Line 969: FND_MESSAGE.Set_Token('VALUE',

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',
970: 'NEXT DAY COVERAGE');
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973:

Line 1005: FND_MESSAGE.Set_Name ('CS',

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');
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1007: FND_MESSAGE.Set_Token('VALUE',

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');
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF (x_return_status =
1011: FND_API.G_RET_STS_ERROR) THEN

Line 1012: FND_MESSAGE.Set_Name ('CS',

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');
1016: RAISE FND_API.G_EXC_ERROR;

Line 1014: FND_MESSAGE.Set_Token('VALUE',

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');
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: END IF;