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.OKL_TRNS_ACC_DSTRS_PUB dependencies on OKC_API

Line 18: x_return_status := OKC_API.G_RET_STS_SUCCESS;

14: p_tabv_rec IN tabv_rec_type
15: ) IS
16: l_dummy VARCHAR2(1) ;
17: BEGIN
18: x_return_status := OKC_API.G_RET_STS_SUCCESS;
19: IF (p_tabv_rec.ae_line_type IS NULL) OR (p_tabv_rec.ae_line_type = OKC_API.G_MISS_CHAR) THEN
20: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
21: p_msg_name => g_required_value,
22: p_token1 => g_col_name_token,

Line 19: IF (p_tabv_rec.ae_line_type IS NULL) OR (p_tabv_rec.ae_line_type = OKC_API.G_MISS_CHAR) THEN

15: ) IS
16: l_dummy VARCHAR2(1) ;
17: BEGIN
18: x_return_status := OKC_API.G_RET_STS_SUCCESS;
19: IF (p_tabv_rec.ae_line_type IS NULL) OR (p_tabv_rec.ae_line_type = OKC_API.G_MISS_CHAR) THEN
20: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
21: p_msg_name => g_required_value,
22: p_token1 => g_col_name_token,
23: p_token1_value => 'AE_LINE_TYPE');

Line 20: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

16: l_dummy VARCHAR2(1) ;
17: BEGIN
18: x_return_status := OKC_API.G_RET_STS_SUCCESS;
19: IF (p_tabv_rec.ae_line_type IS NULL) OR (p_tabv_rec.ae_line_type = OKC_API.G_MISS_CHAR) THEN
20: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
21: p_msg_name => g_required_value,
22: p_token1 => g_col_name_token,
23: p_token1_value => 'AE_LINE_TYPE');
24:

Line 25: x_return_status := OKC_API.G_RET_STS_ERROR;

21: p_msg_name => g_required_value,
22: p_token1 => g_col_name_token,
23: p_token1_value => 'AE_LINE_TYPE');
24:
25: x_return_status := OKC_API.G_RET_STS_ERROR;
26: RAISE G_EXCEPTION_HALT_VALIDATION;
27: END IF;
28: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
29: (p_lookup_type => 'OKL_ACCOUNTING_LINE_TYPE',

Line 32: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

28: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
29: (p_lookup_type => 'OKL_ACCOUNTING_LINE_TYPE',
30: p_lookup_code => p_tabv_rec.ae_line_type);
31: IF l_dummy = okl_api.g_false THEN
32: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
33: p_msg_name => g_invalid_value,
34: p_token1 => g_col_name_token,
35: p_token1_value => 'ae_line_type');
36: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 36: x_return_status := Okc_Api.G_RET_STS_ERROR;

32: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
33: p_msg_name => g_invalid_value,
34: p_token1 => g_col_name_token,
35: p_token1_value => 'ae_line_type');
36: x_return_status := Okc_Api.G_RET_STS_ERROR;
37: RAISE G_EXCEPTION_HALT_VALIDATION;
38: END IF;
39: EXCEPTION
40: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 43: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

39: EXCEPTION
40: WHEN G_EXCEPTION_HALT_VALIDATION THEN
41: NULL;
42: WHEN OTHERS THEN
43: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
44: p_msg_name => g_required_value,
45: p_token1 => g_sqlcode_token,
46: p_token1_value => SQLCODE,
47: p_token2 => g_sqlerrm_token,

Line 49: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

45: p_token1 => g_sqlcode_token,
46: p_token1_value => SQLCODE,
47: p_token2 => g_sqlerrm_token,
48: p_token2_value => SQLERRM);
49: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
50: END validate_ae_line_type;
51:
52: ---------------------------------------------------------------------------
53: -- PROCEDURE validate_cr_dr_flag

Line 60: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;

56: x_return_status OUT NOCOPY VARCHAR2,
57: p_tabv_rec IN tabv_rec_type
58: ) IS
59:
60: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
61: l_app_id NUMBER := 101;
62: l_view_app_id NUMBER := 101;
63: BEGIN
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 64: x_return_status := OKC_API.G_RET_STS_SUCCESS;

60: l_dummy VARCHAR2(1) := OKC_API.G_FALSE;
61: l_app_id NUMBER := 101;
62: l_view_app_id NUMBER := 101;
63: BEGIN
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;
65: IF (p_tabv_rec.cr_dr_flag IS NULL) OR (p_tabv_rec.cr_dr_flag = OKC_API.G_MISS_CHAR) THEN
66: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
67: p_msg_name => g_required_value,
68: p_token1 => g_col_name_token,

Line 65: IF (p_tabv_rec.cr_dr_flag IS NULL) OR (p_tabv_rec.cr_dr_flag = OKC_API.G_MISS_CHAR) THEN

61: l_app_id NUMBER := 101;
62: l_view_app_id NUMBER := 101;
63: BEGIN
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;
65: IF (p_tabv_rec.cr_dr_flag IS NULL) OR (p_tabv_rec.cr_dr_flag = OKC_API.G_MISS_CHAR) THEN
66: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
67: p_msg_name => g_required_value,
68: p_token1 => g_col_name_token,
69: p_token1_value => 'cr_dr_flag');

Line 66: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

62: l_view_app_id NUMBER := 101;
63: BEGIN
64: x_return_status := OKC_API.G_RET_STS_SUCCESS;
65: IF (p_tabv_rec.cr_dr_flag IS NULL) OR (p_tabv_rec.cr_dr_flag = OKC_API.G_MISS_CHAR) THEN
66: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
67: p_msg_name => g_required_value,
68: p_token1 => g_col_name_token,
69: p_token1_value => 'cr_dr_flag');
70:

Line 71: x_return_status := OKC_API.G_RET_STS_ERROR;

67: p_msg_name => g_required_value,
68: p_token1 => g_col_name_token,
69: p_token1_value => 'cr_dr_flag');
70:
71: x_return_status := OKC_API.G_RET_STS_ERROR;
72: RAISE G_EXCEPTION_HALT_VALIDATION;
73: END IF;
74: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
75: (p_lookup_type => 'CR_DR',

Line 80: IF (l_dummy = okc_api.G_FALSE) THEN

76: p_lookup_code => p_tabv_rec.cr_dr_flag,
77: p_app_id => l_app_id,
78: p_view_app_id => l_view_app_id);
79:
80: IF (l_dummy = okc_api.G_FALSE) THEN
81: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
82: p_msg_name => g_invalid_value,
83: p_token1 => g_col_name_token,
84: p_token1_value => 'cr_dr_flag');

Line 81: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

77: p_app_id => l_app_id,
78: p_view_app_id => l_view_app_id);
79:
80: IF (l_dummy = okc_api.G_FALSE) THEN
81: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
82: p_msg_name => g_invalid_value,
83: p_token1 => g_col_name_token,
84: p_token1_value => 'cr_dr_flag');
85: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 85: x_return_status := Okc_Api.G_RET_STS_ERROR;

81: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
82: p_msg_name => g_invalid_value,
83: p_token1 => g_col_name_token,
84: p_token1_value => 'cr_dr_flag');
85: x_return_status := Okc_Api.G_RET_STS_ERROR;
86: RAISE G_EXCEPTION_HALT_VALIDATION;
87: END IF;
88: EXCEPTION
89: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 92: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

88: EXCEPTION
89: WHEN G_EXCEPTION_HALT_VALIDATION THEN
90: NULL;
91: WHEN OTHERS THEN
92: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
93: p_msg_name => g_required_value,
94: p_token1 => g_sqlcode_token,
95: p_token1_value => SQLCODE,
96: p_token2 => g_sqlerrm_token,

Line 98: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

94: p_token1 => g_sqlcode_token,
95: p_token1_value => SQLCODE,
96: p_token2 => g_sqlerrm_token,
97: p_token2_value => SQLERRM);
98: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
99: END validate_cr_dr_flag;
100: ---------------------------------------------------------------------------
101: -- PROCEDURE validate_ccid
102: ---------------------------------------------------------------------------

Line 109: x_return_status := OKC_API.G_RET_STS_SUCCESS;

105: p_tabv_rec IN tabv_rec_type
106: ) IS
107: l_dummy VARCHAR2(1) := okl_api.g_false;
108: BEGIN
109: x_return_status := OKC_API.G_RET_STS_SUCCESS;
110: IF (p_tabv_rec.code_combination_id IS NULL) OR (p_tabv_rec.code_combination_id = OKC_API.G_MISS_NUM) THEN
111: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
112: p_msg_name => g_required_value,
113: p_token1 => g_col_name_token,

Line 110: IF (p_tabv_rec.code_combination_id IS NULL) OR (p_tabv_rec.code_combination_id = OKC_API.G_MISS_NUM) THEN

106: ) IS
107: l_dummy VARCHAR2(1) := okl_api.g_false;
108: BEGIN
109: x_return_status := OKC_API.G_RET_STS_SUCCESS;
110: IF (p_tabv_rec.code_combination_id IS NULL) OR (p_tabv_rec.code_combination_id = OKC_API.G_MISS_NUM) THEN
111: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
112: p_msg_name => g_required_value,
113: p_token1 => g_col_name_token,
114: p_token1_value => 'ACCOUNT');

Line 111: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

107: l_dummy VARCHAR2(1) := okl_api.g_false;
108: BEGIN
109: x_return_status := OKC_API.G_RET_STS_SUCCESS;
110: IF (p_tabv_rec.code_combination_id IS NULL) OR (p_tabv_rec.code_combination_id = OKC_API.G_MISS_NUM) THEN
111: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
112: p_msg_name => g_required_value,
113: p_token1 => g_col_name_token,
114: p_token1_value => 'ACCOUNT');
115:

Line 116: x_return_status := OKC_API.G_RET_STS_ERROR;

112: p_msg_name => g_required_value,
113: p_token1 => g_col_name_token,
114: p_token1_value => 'ACCOUNT');
115:
116: x_return_status := OKC_API.G_RET_STS_ERROR;
117: RAISE G_EXCEPTION_HALT_VALIDATION;
118: END IF;
119: EXCEPTION
120: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 123: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

119: EXCEPTION
120: WHEN G_EXCEPTION_HALT_VALIDATION THEN
121: NULL;
122: WHEN OTHERS THEN
123: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
124: p_msg_name => g_required_value,
125: p_token1 => g_sqlcode_token,
126: p_token1_value => SQLCODE,
127: p_token2 => g_sqlerrm_token,

Line 129: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

125: p_token1 => g_sqlcode_token,
126: p_token1_value => SQLCODE,
127: p_token2 => g_sqlerrm_token,
128: p_token2_value => SQLERRM);
129: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
130: END validate_ccid;
131: ---------------------------------------------------------------------------
132: -- FUNCTION validate_Attributes_for_ats
133: ---------------------------------------------------------------------------

Line 137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

133: ---------------------------------------------------------------------------
134: FUNCTION validate_Attributes_for_ats (
135: p_tabv_rec IN tabv_rec_type
136: ) RETURN VARCHAR2 IS
137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
138: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: BEGIN
140: validate_ccid(x_return_status, p_tabv_rec);
141: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

Line 138: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

134: FUNCTION validate_Attributes_for_ats (
135: p_tabv_rec IN tabv_rec_type
136: ) RETURN VARCHAR2 IS
137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
138: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: BEGIN
140: validate_ccid(x_return_status, p_tabv_rec);
141: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
142: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 141: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
138: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: BEGIN
140: validate_ccid(x_return_status, p_tabv_rec);
141: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
142: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
143: l_return_status := x_return_Status;
144: RAISE G_EXCEPTION_HALT_VALIDATION;
145: ELSE

Line 142: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

138: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
139: BEGIN
140: validate_ccid(x_return_status, p_tabv_rec);
141: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
142: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
143: l_return_status := x_return_Status;
144: RAISE G_EXCEPTION_HALT_VALIDATION;
145: ELSE
146: l_return_status := x_return_status;

Line 150: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

146: l_return_status := x_return_status;
147: END IF;
148: END IF;
149: validate_cr_dr_flag(x_return_status, p_tabv_rec);
150: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
151: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
152: l_return_status := x_return_Status;
153: RAISE G_EXCEPTION_HALT_VALIDATION;
154: ELSE

Line 151: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

147: END IF;
148: END IF;
149: validate_cr_dr_flag(x_return_status, p_tabv_rec);
150: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
151: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
152: l_return_status := x_return_Status;
153: RAISE G_EXCEPTION_HALT_VALIDATION;
154: ELSE
155: l_return_status := x_return_status;

Line 159: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

155: l_return_status := x_return_status;
156: END IF;
157: END IF;
158: validate_ae_line_type(x_return_status, p_tabv_rec);
159: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
160: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
161: l_return_status := x_return_Status;
162: RAISE G_EXCEPTION_HALT_VALIDATION;
163: ELSE

Line 160: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

156: END IF;
157: END IF;
158: validate_ae_line_type(x_return_status, p_tabv_rec);
159: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
160: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
161: l_return_status := x_return_Status;
162: RAISE G_EXCEPTION_HALT_VALIDATION;
163: ELSE
164: l_return_status := x_return_status;

Line 176: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

172: RETURN (l_return_status);
173:
174: WHEN OTHERS THEN
175: -- store SQL error message on message stack for caller
176: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
177: p_msg_name => g_unexpected_error,
178: p_token1 => g_sqlcode_token,
179: p_token1_value => SQLCODE,
180: p_token2 => g_sqlerrm_token,

Line 183: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

179: p_token1_value => SQLCODE,
180: p_token2 => g_sqlerrm_token,
181: p_token2_value => SQLERRM);
182: -- notify caller of an UNEXPECTED error
183: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
184: RETURN(l_return_status);
185: END validate_Attributes_for_ats;
186:
187: ---------------------------------------------------------------------------

Line 193: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

189: ---------------------------------------------------------------------------
190:
191: PROCEDURE insert_trns_acc_dstrs(
192: p_api_version IN NUMBER
193: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
194: ,x_return_status OUT NOCOPY VARCHAR2
195: ,x_msg_count OUT NOCOPY NUMBER
196: ,x_msg_data OUT NOCOPY VARCHAR2
197: ,p_tabv_rec IN tabv_rec_type

Line 217: IF(p_tabv_rec.template_id IS NOT NULL AND p_tabv_rec.template_id <> Okc_Api.G_MISS_NUM) THEN

213: x_return_status := FND_API.G_RET_STS_SUCCESS;
214: SAVEPOINT insert_trns_acc_dstrs;
215: l_tabv_rec := p_tabv_rec;
216: -- Added as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 start
217: IF(p_tabv_rec.template_id IS NOT NULL AND p_tabv_rec.template_id <> Okc_Api.G_MISS_NUM) THEN
218: IF(p_tabv_rec.accounting_template_name IS NULL OR p_tabv_rec.accounting_template_name = OKC_API.G_MISS_CHAR) THEN
219: OPEN acc_temp_name_csr(p_tabv_rec.template_id);
220: FETCH acc_temp_name_csr INTO l_tabv_rec.accounting_template_name;
221: l_row_notfound := acc_temp_name_csr%NOTFOUND;

Line 218: IF(p_tabv_rec.accounting_template_name IS NULL OR p_tabv_rec.accounting_template_name = OKC_API.G_MISS_CHAR) THEN

214: SAVEPOINT insert_trns_acc_dstrs;
215: l_tabv_rec := p_tabv_rec;
216: -- Added as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 start
217: IF(p_tabv_rec.template_id IS NOT NULL AND p_tabv_rec.template_id <> Okc_Api.G_MISS_NUM) THEN
218: IF(p_tabv_rec.accounting_template_name IS NULL OR p_tabv_rec.accounting_template_name = OKC_API.G_MISS_CHAR) THEN
219: OPEN acc_temp_name_csr(p_tabv_rec.template_id);
220: FETCH acc_temp_name_csr INTO l_tabv_rec.accounting_template_name;
221: l_row_notfound := acc_temp_name_csr%NOTFOUND;
222: IF (l_row_notfound) THEN

Line 223: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');

219: OPEN acc_temp_name_csr(p_tabv_rec.template_id);
220: FETCH acc_temp_name_csr INTO l_tabv_rec.accounting_template_name;
221: l_row_notfound := acc_temp_name_csr%NOTFOUND;
222: IF (l_row_notfound) THEN
223: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TEMPLATE_ID');
224: RAISE item_not_found_error;
225: END IF;
226: CLOSE acc_temp_name_csr;
227:

Line 233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

229: END IF;
230: l_acct_der := okl_Accounting_util.get_account_derivation;
231: IF(l_acct_der='ATS') THEN
232: l_return_status := validate_Attributes_for_ats(p_tabv_rec);
233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
236: RAISE OKC_API.G_EXCEPTION_ERROR;
237: END IF;

Line 234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

230: l_acct_der := okl_Accounting_util.get_account_derivation;
231: IF(l_acct_der='ATS') THEN
232: l_return_status := validate_Attributes_for_ats(p_tabv_rec);
233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
236: RAISE OKC_API.G_EXCEPTION_ERROR;
237: END IF;
238: END IF;

Line 235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

231: IF(l_acct_der='ATS') THEN
232: l_return_status := validate_Attributes_for_ats(p_tabv_rec);
233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
236: RAISE OKC_API.G_EXCEPTION_ERROR;
237: END IF;
238: END IF;
239:

Line 236: RAISE OKC_API.G_EXCEPTION_ERROR;

232: l_return_status := validate_Attributes_for_ats(p_tabv_rec);
233: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
234: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
236: RAISE OKC_API.G_EXCEPTION_ERROR;
237: END IF;
238: END IF;
239:
240: -- Added as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 end

Line 268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

264: WHEN FND_API.G_EXC_ERROR THEN
265: ROLLBACK TO insert_trns_acc_dstrs;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267:
268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
269: ,p_count => x_msg_count
270: ,p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO insert_trns_acc_dstrs;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
276: ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278:
279: WHEN OTHERS THEN

Line 282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

278:
279: WHEN OTHERS THEN
280: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
281: -- store SQL error message on message stack for caller
282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
283: ,p_count => x_msg_count
284: ,p_data => x_msg_data);
285: -- notify caller of an UNEXPECTED error
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 292: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

288:
289:
290: PROCEDURE insert_trns_acc_dstrs(
291: p_api_version IN NUMBER
292: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
293: ,x_return_status OUT NOCOPY VARCHAR2
294: ,x_msg_count OUT NOCOPY NUMBER
295: ,x_msg_data OUT NOCOPY VARCHAR2
296: ,p_tabv_tbl IN tabv_tbl_type

Line 362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO insert_trns_acc_dstrs;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:
362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
363: ,p_count => x_msg_count
364: ,p_data => x_msg_data);
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 369: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO insert_trns_acc_dstrs;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
370: ,p_count => x_msg_count
371: ,p_data => x_msg_data);
372:
373: WHEN OTHERS THEN

Line 376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

372:
373: WHEN OTHERS THEN
374: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
375: -- store SQL error message on message stack for caller
376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
377: ,p_count => x_msg_count
378: ,p_data => x_msg_data);
379: -- notify caller of an UNEXPECTED error
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 385: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

381: END insert_trns_acc_dstrs;
382:
383: PROCEDURE lock_trns_acc_dstrs(
384: p_api_version IN NUMBER
385: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_count OUT NOCOPY NUMBER
388: ,x_msg_data OUT NOCOPY VARCHAR2
389: ,p_tabv_rec IN tabv_rec_type

Line 420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO lock_trns_acc_dstrs;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419:
420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
421: ,p_count => x_msg_count
422: ,p_data => x_msg_data);
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO lock_trns_acc_dstrs;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
428: ,p_count => x_msg_count
429: ,p_data => x_msg_data);
430:
431: WHEN OTHERS THEN

Line 434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

430:
431: WHEN OTHERS THEN
432: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');
433: -- store SQL error message on message stack for caller
434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: -- notify caller of an UNEXPECTED error
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 443: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

439: END lock_trns_acc_dstrs;
440:
441: PROCEDURE lock_trns_acc_dstrs(
442: p_api_version IN NUMBER
443: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
444: ,x_return_status OUT NOCOPY VARCHAR2
445: ,x_msg_count OUT NOCOPY NUMBER
446: ,x_msg_data OUT NOCOPY VARCHAR2
447: ,p_tabv_tbl IN tabv_tbl_type

Line 500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO lock_trns_acc_dstrs;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499:
500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
501: ,p_count => x_msg_count
502: ,p_data => x_msg_data);
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO lock_trns_acc_dstrs;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
508: ,p_count => x_msg_count
509: ,p_data => x_msg_data);
510:
511: WHEN OTHERS THEN

Line 514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

510:
511: WHEN OTHERS THEN
512: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');
513: -- store SQL error message on message stack for caller
514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
517: -- notify caller of an UNEXPECTED error
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 523: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

519: END lock_trns_acc_dstrs;
520:
521: PROCEDURE update_trns_acc_dstrs(
522: p_api_version IN NUMBER
523: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
524: ,x_return_status OUT NOCOPY VARCHAR2
525: ,x_msg_count OUT NOCOPY NUMBER
526: ,x_msg_data OUT NOCOPY VARCHAR2
527: ,p_tabv_rec IN tabv_rec_type

Line 568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

564: WHEN FND_API.G_EXC_ERROR THEN
565: ROLLBACK TO update_trns_acc_dstrs;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
569: ,p_count => x_msg_count
570: ,p_data => x_msg_data);
571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 575: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO update_trns_acc_dstrs;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
576: ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578:
579: WHEN OTHERS THEN

Line 582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

578:
579: WHEN OTHERS THEN
580: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
581: -- store SQL error message on message stack for caller
582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data);
585: -- notify caller of an UNEXPECTED error
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 592: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

588:
589:
590: PROCEDURE update_trns_acc_dstrs(
591: p_api_version IN NUMBER
592: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
593: ,x_return_status OUT NOCOPY VARCHAR2
594: ,x_msg_count OUT NOCOPY NUMBER
595: ,x_msg_data OUT NOCOPY VARCHAR2
596: ,p_tabv_tbl IN tabv_tbl_type

Line 662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

658: WHEN FND_API.G_EXC_ERROR THEN
659: ROLLBACK TO update_trns_acc_dstrs;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661:
662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
663: ,p_count => x_msg_count
664: ,p_data => x_msg_data);
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 669: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO update_trns_acc_dstrs;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
670: ,p_count => x_msg_count
671: ,p_data => x_msg_data);
672:
673: WHEN OTHERS THEN

Line 676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

672:
673: WHEN OTHERS THEN
674: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
675: -- store SQL error message on message stack for caller
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: -- notify caller of an UNEXPECTED error
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 685: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

681: END update_trns_acc_dstrs;
682:
683: PROCEDURE delete_trns_acc_dstrs(
684: p_api_version IN NUMBER
685: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
686: ,x_return_status OUT NOCOPY VARCHAR2
687: ,x_msg_count OUT NOCOPY NUMBER
688: ,x_msg_data OUT NOCOPY VARCHAR2
689: ,p_tabv_rec IN tabv_rec_type

Line 762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO delete_trns_acc_dstrs;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761:
762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
763: ,p_count => x_msg_count
764: ,p_data => x_msg_data);
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO delete_trns_acc_dstrs;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
770: ,p_count => x_msg_count
771: ,p_data => x_msg_data);
772:
773: WHEN OTHERS THEN

Line 776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

772:
773: WHEN OTHERS THEN
774: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
775: -- store SQL error message on message stack for caller
776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
777: ,p_count => x_msg_count
778: ,p_data => x_msg_data);
779: -- notify caller of an UNEXPECTED error
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 786: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

782:
783:
784: PROCEDURE delete_trns_acc_dstrs(
785: p_api_version IN NUMBER
786: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
787: ,x_return_status OUT NOCOPY VARCHAR2
788: ,x_msg_count OUT NOCOPY NUMBER
789: ,x_msg_data OUT NOCOPY VARCHAR2
790: ,p_tabv_tbl IN tabv_tbl_type

Line 851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

847: WHEN FND_API.G_EXC_ERROR THEN
848: ROLLBACK TO delete_trns_acc_dstrs;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 858: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: ROLLBACK TO delete_trns_acc_dstrs;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
859: ,p_count => x_msg_count
860: ,p_data => x_msg_data);
861:
862: WHEN OTHERS THEN

Line 865: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

861:
862: WHEN OTHERS THEN
863: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
864: -- store SQL error message on message stack for caller
865: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
866: ,p_count => x_msg_count
867: ,p_data => x_msg_data);
868: -- notify caller of an UNEXPECTED error
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 874: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

870: END delete_trns_acc_dstrs;
871:
872: PROCEDURE validate_trns_acc_dstrs(
873: p_api_version IN NUMBER
874: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
875: ,x_return_status OUT NOCOPY VARCHAR2
876: ,x_msg_count OUT NOCOPY NUMBER
877: ,x_msg_data OUT NOCOPY VARCHAR2
878: ,p_tabv_rec IN tabv_rec_type

Line 914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO validate_trns_acc_dstrs;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
915: ,p_count => x_msg_count
916: ,p_data => x_msg_data);
917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 921: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO validate_trns_acc_dstrs;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
922: ,p_count => x_msg_count
923: ,p_data => x_msg_data);
924:
925: WHEN OTHERS THEN

Line 928: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

924:
925: WHEN OTHERS THEN
926: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');
927: -- store SQL error message on message stack for caller
928: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
929: ,p_count => x_msg_count
930: ,p_data => x_msg_data);
931: -- notify caller of an UNEXPECTED error
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 938: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

934:
935:
936: PROCEDURE validate_trns_acc_dstrs(
937: p_api_version IN NUMBER
938: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
939: ,x_return_status OUT NOCOPY VARCHAR2
940: ,x_msg_count OUT NOCOPY NUMBER
941: ,x_msg_data OUT NOCOPY VARCHAR2
942: ,p_tabv_tbl IN tabv_tbl_type

Line 1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1000: WHEN FND_API.G_EXC_ERROR THEN
1001: ROLLBACK TO validate_trns_acc_dstrs;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003:
1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1005: ,p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1011: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO validate_trns_acc_dstrs;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014:
1015: WHEN OTHERS THEN

Line 1018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1014:
1015: WHEN OTHERS THEN
1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');
1017: -- store SQL error message on message stack for caller
1018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1019: ,p_count => x_msg_count
1020: ,p_data => x_msg_data);
1021: -- notify caller of an UNEXPECTED error
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;