APPS.OKL_PRCTIMEOUT_PVT dependencies on OKL_API

Line 11: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

7: l_api_name CONSTANT VARCHAR2(40) := 'OKL_PRCTIMEOUT_PVT';
8: l_api_version CONSTANT NUMBER := 1.0;
9: p_api_version CONSTANT NUMBER := 1.0;
10:
11: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12: l_init_msg_list VARCHAR2(1);
13: l_msg_count NUMBER;
14: l_msg_data VARCHAR2(2000);
15: lp_sifv_rec sifv_rec_type;

Line 35: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

31:
32: BEGIN
33:
34: x_retcode := 0;
35: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
36: ,G_PKG_NAME
37: ,l_init_msg_list
38: ,l_api_version
39: ,p_api_version

Line 43: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

39: ,p_api_version
40: ,'_PVT'
41: ,l_return_status);
42:
43: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
44: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
45: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');

Line 45: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

41: ,l_return_status);
42:
43: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
44: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
45: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;

Line 46: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

42:
43: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
44: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
45: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;
50: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');

Line 48: RAISE Okl_Api.G_EXCEPTION_ERROR;

44: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error in Start Activity');
45: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
46: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in Start Activity');
48: RAISE Okl_Api.G_EXCEPTION_ERROR;
49: END IF;
50: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Activity Successful');
51: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
52:

Line 80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

76: x_msg_count => l_msg_count,
77: x_msg_data => l_msg_data,
78: p_sifv_rec => lp_sifv_rec,
79: x_sifv_rec => lx_sifv_rec );
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Unexpected Error ');
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
84: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Expected Error ');

Line 82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

78: p_sifv_rec => lp_sifv_rec,
79: x_sifv_rec => lx_sifv_rec );
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Unexpected Error ');
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
84: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Expected Error ');
85: RAISE OKL_API.G_EXCEPTION_ERROR;
86: END IF;

Line 83: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

79: x_sifv_rec => lx_sifv_rec );
80: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
81: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Unexpected Error ');
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
84: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Expected Error ');
85: RAISE OKL_API.G_EXCEPTION_ERROR;
86: END IF;
87: --srsreeni Bug6011651 starts.Updates to ERROR when the processing fails

Line 85: RAISE OKL_API.G_EXCEPTION_ERROR;

81: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Unexpected Error ');
82: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
83: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
84: FND_FILE.PUT_LINE(FND_FILE.LOG, l_return_Status || 'Expected Error ');
85: RAISE OKL_API.G_EXCEPTION_ERROR;
86: END IF;
87: --srsreeni Bug6011651 starts.Updates to ERROR when the processing fails
88: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
89: p_api_version => l_api_version,

Line 97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

93: x_msg_data => l_msg_data,
94: p_khr_id => l_okl_prctimeout_rec.khr_id,
95: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
96: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;

Line 98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

94: p_khr_id => l_okl_prctimeout_rec.khr_id,
95: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
96: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;
102:

Line 99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

95: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
96: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;
102:
103: --srsreeni Bug6011651 ends

Line 100: RAISE OKL_API.G_EXCEPTION_ERROR;

96: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;
102:
103: --srsreeni Bug6011651 ends
104:

Line 119: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'None of the Records are updated.');
116: END IF;
117:
118:
119: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End Activity Successful');
121: x_retcode := 0;
122:
123:

Line 128: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

124: EXCEPTION
125: WHEN G_EXCEPTION_ERROR THEN
126: x_retcode := 2;
127:
128: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
129: ,g_pkg_name
130: ,'Okl_Api.G_RET_STS_ERROR'
131: ,l_msg_count
132: ,l_msg_data

Line 130: ,'Okl_Api.G_RET_STS_ERROR'

126: x_retcode := 2;
127:
128: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
129: ,g_pkg_name
130: ,'Okl_Api.G_RET_STS_ERROR'
131: ,l_msg_count
132: ,l_msg_data
133: ,'_PVT');
134:

Line 151: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

147: IF l_okl_prctimeout_csr%ISOPEN THEN
148: CLOSE l_okl_prctimeout_csr;
149: END IF;
150:
151: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
152: ,g_pkg_name
153: ,'Okl_Api.G_RET_STS_UNEXP_ERROR'
154: ,l_msg_count
155: ,l_msg_data

Line 153: ,'Okl_Api.G_RET_STS_UNEXP_ERROR'

149: END IF;
150:
151: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
152: ,g_pkg_name
153: ,'Okl_Api.G_RET_STS_UNEXP_ERROR'
154: ,l_msg_count
155: ,l_msg_data
156: ,'_PVT');
157: -- print the error message in the log file

Line 174: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

170: IF l_okl_prctimeout_csr%ISOPEN THEN
171: CLOSE l_okl_prctimeout_csr;
172: END IF;
173:
174: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
175: ,g_pkg_name
176: ,'OTHERS'
177: ,l_msg_count
178: ,l_msg_data