DBA Data[Home] [Help]

APPS.OZF_CLAIM_APPROVAL_PVT dependencies on FND_API

Line 66: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

62: AND TRUNC(NVL(end_date_active,SYSDATE + 1));
63:
64:
65: BEGIN
66: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
67:
68: -- The data Deletion is necessary if Claim is Resubmitted for Approval
69: -- Processign is only required for Earning and Performance
70:

Line 73: p_init_msg_list => FND_API.G_FALSE,

69: -- Processign is only required for Earning and Performance
70:
71: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
72: p_api_version_number => 1.0,
73: p_init_msg_list => FND_API.G_FALSE,
74: p_commit => FND_API.G_FALSE,
75: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
76: x_return_status => l_return_status,
77: x_msg_count => l_msg_count,

Line 74: p_commit => FND_API.G_FALSE,

70:
71: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
72: p_api_version_number => 1.0,
73: p_init_msg_list => FND_API.G_FALSE,
74: p_commit => FND_API.G_FALSE,
75: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
76: x_return_status => l_return_status,
77: x_msg_count => l_msg_count,
78: x_msg_data => l_msg_data,

Line 75: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

71: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
72: p_api_version_number => 1.0,
73: p_init_msg_list => FND_API.G_FALSE,
74: p_commit => FND_API.G_FALSE,
75: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
76: x_return_status => l_return_status,
77: x_msg_count => l_msg_count,
78: x_msg_data => l_msg_data,
79: p_object_id => p_activity_id,

Line 87: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

83: p_object_version_num => null,
84: p_approval_type => 'EARNING'
85: );
86:
87: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
88: x_return_status := Fnd_Api.G_RET_STS_ERROR;
89: RETURN;
90: END IF;
91:

Line 88: x_return_status := Fnd_Api.G_RET_STS_ERROR;

84: p_approval_type => 'EARNING'
85: );
86:
87: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
88: x_return_status := Fnd_Api.G_RET_STS_ERROR;
89: RETURN;
90: END IF;
91:
92: AMS_Appr_Hist_PVT.Delete_Appr_Hist(

Line 94: p_init_msg_list => FND_API.G_FALSE,

90: END IF;
91:
92: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
93: p_api_version_number => 1.0,
94: p_init_msg_list => FND_API.G_FALSE,
95: p_commit => FND_API.G_FALSE,
96: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
97: x_return_status => l_return_status,
98: x_msg_count => l_msg_count,

Line 95: p_commit => FND_API.G_FALSE,

91:
92: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
93: p_api_version_number => 1.0,
94: p_init_msg_list => FND_API.G_FALSE,
95: p_commit => FND_API.G_FALSE,
96: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
97: x_return_status => l_return_status,
98: x_msg_count => l_msg_count,
99: x_msg_data => l_msg_data,

Line 96: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

92: AMS_Appr_Hist_PVT.Delete_Appr_Hist(
93: p_api_version_number => 1.0,
94: p_init_msg_list => FND_API.G_FALSE,
95: p_commit => FND_API.G_FALSE,
96: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
97: x_return_status => l_return_status,
98: x_msg_count => l_msg_count,
99: x_msg_data => l_msg_data,
100: p_object_id => p_activity_id,

Line 108: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

104: p_object_version_num => null,
105: p_approval_type => 'PERFORMANCE'
106: );
107:
108: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
109: x_return_status := Fnd_Api.G_RET_STS_ERROR;
110: RETURN;
111: END IF;
112: --Populate the History Table with Approval Data for EARNING and PERFORMANCE

Line 109: x_return_status := Fnd_Api.G_RET_STS_ERROR;

105: p_approval_type => 'PERFORMANCE'
106: );
107:
108: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
109: x_return_status := Fnd_Api.G_RET_STS_ERROR;
110: RETURN;
111: END IF;
112: --Populate the History Table with Approval Data for EARNING and PERFORMANCE
113: l_appr_hist_rec.object_id := p_activity_id;

Line 126: IF OZF_Claim_Accrual_PVT.Earnings_Approval_Required(p_activity_id) = FND_API.g_true THEN

122: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
123:
124:
125:
126: IF OZF_Claim_Accrual_PVT.Earnings_Approval_Required(p_activity_id) = FND_API.g_true THEN
127: AMS_Gen_Approval_Pvt.Get_Approval_Rule(p_activity_id ,
128: 'CLAM',
129: 'EARNING',
130: null,

Line 149: p_init_msg_list => FND_API.G_FALSE,

145: l_appr_hist_rec.approver_id := l_obj_appr_id;
146:
147: AMS_Appr_Hist_PVT.Create_Appr_Hist(
148: p_api_version_number => 1.0,
149: p_init_msg_list => FND_API.G_FALSE,
150: p_commit => FND_API.G_FALSE,
151: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
152: x_return_status => l_return_status,
153: x_msg_count => l_msg_count,

Line 150: p_commit => FND_API.G_FALSE,

146:
147: AMS_Appr_Hist_PVT.Create_Appr_Hist(
148: p_api_version_number => 1.0,
149: p_init_msg_list => FND_API.G_FALSE,
150: p_commit => FND_API.G_FALSE,
151: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
152: x_return_status => l_return_status,
153: x_msg_count => l_msg_count,
154: x_msg_data => l_msg_data,

Line 151: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

147: AMS_Appr_Hist_PVT.Create_Appr_Hist(
148: p_api_version_number => 1.0,
149: p_init_msg_list => FND_API.G_FALSE,
150: p_commit => FND_API.G_FALSE,
151: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
152: x_return_status => l_return_status,
153: x_msg_count => l_msg_count,
154: x_msg_data => l_msg_data,
155: p_appr_hist_rec => l_appr_hist_rec

Line 158: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

154: x_msg_data => l_msg_data,
155: p_appr_hist_rec => l_appr_hist_rec
156: );
157:
158: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
159: x_return_status := Fnd_Api.G_RET_STS_ERROR;
160: RETURN;
161: END IF;
162:

Line 159: x_return_status := Fnd_Api.G_RET_STS_ERROR;

155: p_appr_hist_rec => l_appr_hist_rec
156: );
157:
158: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
159: x_return_status := Fnd_Api.G_RET_STS_ERROR;
160: RETURN;
161: END IF;
162:
163: END LOOP;

Line 170: IF OZF_Claim_Accrual_PVT.Perform_Approval_Required(p_activity_id) = FND_API.g_true THEN

166:
167: l_appr_hist_rec.approval_type := 'PERFORMANCE';
168: l_appr_hist_rec.sequence_num := 0;
169:
170: IF OZF_Claim_Accrual_PVT.Perform_Approval_Required(p_activity_id) = FND_API.g_true THEN
171: AMS_Gen_Approval_Pvt.Get_Approval_Rule(p_activity_id ,
172: 'CLAM',
173: 'PERFORMANCE',
174: null,

Line 193: p_init_msg_list => FND_API.G_FALSE,

189: l_appr_hist_rec.approver_id := l_obj_appr_id;
190:
191: AMS_Appr_Hist_PVT.Create_Appr_Hist(
192: p_api_version_number => 1.0,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_commit => FND_API.G_FALSE,
195: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
196: x_return_status => l_return_status,
197: x_msg_count => l_msg_count,

Line 194: p_commit => FND_API.G_FALSE,

190:
191: AMS_Appr_Hist_PVT.Create_Appr_Hist(
192: p_api_version_number => 1.0,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_commit => FND_API.G_FALSE,
195: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
196: x_return_status => l_return_status,
197: x_msg_count => l_msg_count,
198: x_msg_data => l_msg_data,

Line 195: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

191: AMS_Appr_Hist_PVT.Create_Appr_Hist(
192: p_api_version_number => 1.0,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_commit => FND_API.G_FALSE,
195: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
196: x_return_status => l_return_status,
197: x_msg_count => l_msg_count,
198: x_msg_data => l_msg_data,
199: p_appr_hist_rec => l_appr_hist_rec

Line 202: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

198: x_msg_data => l_msg_data,
199: p_appr_hist_rec => l_appr_hist_rec
200: );
201:
202: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
203: x_return_status := Fnd_Api.G_RET_STS_ERROR;
204: RETURN;
205: END IF;
206:

Line 203: x_return_status := Fnd_Api.G_RET_STS_ERROR;

199: p_appr_hist_rec => l_appr_hist_rec
200: );
201:
202: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
203: x_return_status := Fnd_Api.G_RET_STS_ERROR;
204: RETURN;
205: END IF;
206:
207: END LOOP;

Line 1777: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1773: p_requester_id => l_requester_id,
1774: x_return_status => l_return_status
1775: );
1776:
1777: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1778: RAISE FND_API.g_exc_unexpected_error;
1779: END IF;
1780: END IF;
1781:

Line 1778: RAISE FND_API.g_exc_unexpected_error;

1774: x_return_status => l_return_status
1775: );
1776:
1777: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1778: RAISE FND_API.g_exc_unexpected_error;
1779: END IF;
1780: END IF;
1781:
1782: EXCEPTION

Line 1793: RAISE FND_API.g_exc_unexpected_error;

1789: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1790: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1791: FND_MSG_PUB.Add;
1792: END IF;
1793: RAISE FND_API.g_exc_unexpected_error;
1794: END;
1795:
1796: AMS_GEN_APPROVAL_PVT.get_approval_details(
1797: p_activity_id => l_activity_id

Line 1806: IF l_return_status = fnd_api.g_ret_sts_success THEN

1802: ,x_approver_seq => l_approver_seq
1803: ,x_return_status => l_return_status
1804: );
1805:
1806: IF l_return_status = fnd_api.g_ret_sts_success THEN
1807: WF_ENGINE.setitemattrnumber(
1808: itemtype => itemtype
1809: ,itemkey => itemkey
1810: ,aname => 'AMS_APPROVAL_DETAIL_ID'

Line 1954: p_encoded => fnd_api.g_false

1950:
1951: resultout := 'COMPLETE:SUCCESS';
1952: ELSE
1953: FND_MSG_PUB.count_and_get(
1954: p_encoded => fnd_api.g_false
1955: ,p_count => l_msg_count
1956: ,p_data => l_msg_data
1957: );
1958:

Line 1976: -- RAISE FND_API.G_EXC_ERROR;

1972: ,itemkey
1973: ,actid
1974: ,l_error_msg
1975: );
1976: -- RAISE FND_API.G_EXC_ERROR;
1977: resultout := 'COMPLETE:ERROR';
1978: END IF;
1979: RETURN;
1980: END IF; -- end of RUN mode

Line 2000: WHEN fnd_api.g_exc_error THEN

1996: END IF;
1997: --
1998:
1999: EXCEPTION
2000: WHEN fnd_api.g_exc_error THEN
2001: WF_CORE.context(
2002: 'OZF_CLAIM_APPROVAL_PVT'
2003: ,'SET_CLAIM_ACTIVITY_DETAILS'
2004: ,itemtype

Line 2019: p_encoded => fnd_api.g_false

2015: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2016: FND_MSG_PUB.Add;
2017:
2018: FND_MSG_PUB.count_and_get (
2019: p_encoded => fnd_api.g_false
2020: ,p_count => l_msg_count
2021: ,p_data => l_msg_data
2022: );
2023: AMS_GEN_APPROVAL_PVT.handle_err(

Line 2089: x_return_status := FND_API.g_ret_sts_success;

2085: FROM ozf_claims
2086: WHERE claim_id = l_claim_id;
2087:
2088: BEGIN
2089: x_return_status := FND_API.g_ret_sts_success;
2090:
2091: OPEN claim_rec_csr(p_claim_id);
2092: FETCH claim_rec_csr INTO l_object_version_number,
2093: --l_new_status_id,

Line 2115: RAISE FND_API.g_exc_unexpected_error;

2111: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2112: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.g_exc_unexpected_error;
2116: END;
2117:
2118: ----------------------------
2119: -- Call Approval Workflow --

Line 2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2137: WHEN OTHERS THEN
2138: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2139: FND_MESSAGE.Set_Token('TEXT',l_full_name||' - '||p_approval_type||' : Error');
2140: FND_MSG_PUB.Add;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142:
2143: END Start_Approval_Process;
2144:
2145:

Line 2176: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2172: IS
2173: l_api_version CONSTANT NUMBER := 1.0;
2174: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claim_Status';
2175: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2176: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2177: l_msg_count NUMBER;
2178: l_msg_data VARCHAR2(4000);
2179: l_error_msg VARCHAR2(4000);
2180:

Line 2259: p_encoded => fnd_api.g_false

2255: ,aname => 'UPDATE_GEN_STATUS'
2256: ,avalue => l_update_status
2257: );
2258: FND_MSG_PUB.count_and_get (
2259: p_encoded => fnd_api.g_false
2260: ,p_count => l_msg_count
2261: ,p_data => l_msg_data
2262: );
2263: AMS_GEN_APPROVAL_PVT.handle_err(

Line 2321: IF OZF_Claim_Accrual_PVT.Perform_Approval_Required(l_claim_id) = FND_API.g_true THEN

2317: );
2318:
2319: IF l_update_status = 'APPROVED' AND
2320: l_approval_type = 'EARNING' THEN
2321: IF OZF_Claim_Accrual_PVT.Perform_Approval_Required(l_claim_id) = FND_API.g_true THEN
2322: -- Start Performance Approval
2323: Start_Approval_Process(
2324: p_claim_id => l_claim_id
2325: ,p_orig_status_id => l_orig_status_id

Line 2331: IF l_return_status = FND_API.g_ret_sts_success THEN

2327: ,p_reject_status_id => l_reject_status_id
2328: ,p_approval_type => 'PERFORMANCE'
2329: ,x_return_status => l_return_status
2330: );
2331: IF l_return_status = FND_API.g_ret_sts_success THEN
2332: resultout := 'COMPLETE:SUCCESS';
2333: RETURN;
2334: ELSE
2335: RAISE APPROVAL_RAISE_ERROR;

Line 2344: IF l_return_status = FND_API.g_ret_sts_error THEN

2340: ,x_msg_data => l_msg_data
2341: ,x_msg_count => l_msg_count
2342: ,x_approval_require => l_approval_require);
2343:
2344: IF l_return_status = FND_API.g_ret_sts_error THEN
2345: RAISE FND_API.g_exc_error;
2346: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2347: RAISE FND_API.g_exc_unexpected_error;
2348: END IF;

Line 2345: RAISE FND_API.g_exc_error;

2341: ,x_msg_count => l_msg_count
2342: ,x_approval_require => l_approval_require);
2343:
2344: IF l_return_status = FND_API.g_ret_sts_error THEN
2345: RAISE FND_API.g_exc_error;
2346: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2347: RAISE FND_API.g_exc_unexpected_error;
2348: END IF;
2349:

Line 2346: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2342: ,x_approval_require => l_approval_require);
2343:
2344: IF l_return_status = FND_API.g_ret_sts_error THEN
2345: RAISE FND_API.g_exc_error;
2346: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2347: RAISE FND_API.g_exc_unexpected_error;
2348: END IF;
2349:
2350: IF l_approval_require = 'Y' THEN

Line 2347: RAISE FND_API.g_exc_unexpected_error;

2343:
2344: IF l_return_status = FND_API.g_ret_sts_error THEN
2345: RAISE FND_API.g_exc_error;
2346: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2347: RAISE FND_API.g_exc_unexpected_error;
2348: END IF;
2349:
2350: IF l_approval_require = 'Y' THEN
2351: -- Start Performance Approval

Line 2362: IF l_return_status = FND_API.g_ret_sts_success THEN

2358: ,x_return_status => l_return_status
2359: );
2360:
2361:
2362: IF l_return_status = FND_API.g_ret_sts_success THEN
2363: resultout := 'COMPLETE:SUCCESS';
2364: RETURN;
2365: ELSE
2366: RAISE APPROVAL_RAISE_ERROR;

Line 2379: IF l_return_status = FND_API.g_ret_sts_error THEN

2375: ,x_msg_data => l_msg_data
2376: ,x_msg_count => l_msg_count
2377: ,x_approval_require => l_approval_require);
2378:
2379: IF l_return_status = FND_API.g_ret_sts_error THEN
2380: RAISE FND_API.g_exc_error;
2381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2382: RAISE FND_API.g_exc_unexpected_error;
2383: END IF;

Line 2380: RAISE FND_API.g_exc_error;

2376: ,x_msg_count => l_msg_count
2377: ,x_approval_require => l_approval_require);
2378:
2379: IF l_return_status = FND_API.g_ret_sts_error THEN
2380: RAISE FND_API.g_exc_error;
2381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2382: RAISE FND_API.g_exc_unexpected_error;
2383: END IF;
2384:

Line 2381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2377: ,x_approval_require => l_approval_require);
2378:
2379: IF l_return_status = FND_API.g_ret_sts_error THEN
2380: RAISE FND_API.g_exc_error;
2381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2382: RAISE FND_API.g_exc_unexpected_error;
2383: END IF;
2384:
2385: IF l_approval_require = 'Y' THEN

Line 2382: RAISE FND_API.g_exc_unexpected_error;

2378:
2379: IF l_return_status = FND_API.g_ret_sts_error THEN
2380: RAISE FND_API.g_exc_error;
2381: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2382: RAISE FND_API.g_exc_unexpected_error;
2383: END IF;
2384:
2385: IF l_approval_require = 'Y' THEN
2386: -- Start Performance Approval

Line 2397: IF l_return_status = FND_API.g_ret_sts_success THEN

2393: ,x_return_status => l_return_status
2394: );
2395:
2396:
2397: IF l_return_status = FND_API.g_ret_sts_success THEN
2398: resultout := 'COMPLETE:SUCCESS';
2399: RETURN;
2400: ELSE
2401: RAISE APPROVAL_RAISE_ERROR;

Line 2447: p_encoded => fnd_api.g_false

2443: FND_MESSAGE.set_token('APPROVED_AMOUNT',l_approved_amount, FALSE);
2444: FND_MESSAGE.set_token('CLAIM_AMOUNT',l_claim_amount_settled, FALSE);
2445: FND_MSG_PUB.ADD;
2446: FND_MSG_PUB.count_and_get (
2447: p_encoded => fnd_api.g_false
2448: ,p_count => l_msg_count
2449: ,p_data => l_msg_data
2450: );
2451: AMS_GEN_APPROVAL_PVT.handle_err(

Line 2556: ,p_init_msg_list => FND_API.g_false

2552:
2553: ELSE
2554: OZF_Claim_PVT.Update_Claim(
2555: p_api_version => l_api_version
2556: ,p_init_msg_list => FND_API.g_false
2557: ,p_commit => FND_API.g_false
2558: ,p_validation_level => FND_API.g_valid_level_full
2559: ,x_return_status => l_return_status
2560: ,x_msg_data => l_msg_data

Line 2557: ,p_commit => FND_API.g_false

2553: ELSE
2554: OZF_Claim_PVT.Update_Claim(
2555: p_api_version => l_api_version
2556: ,p_init_msg_list => FND_API.g_false
2557: ,p_commit => FND_API.g_false
2558: ,p_validation_level => FND_API.g_valid_level_full
2559: ,x_return_status => l_return_status
2560: ,x_msg_data => l_msg_data
2561: ,x_msg_count => l_msg_count

Line 2558: ,p_validation_level => FND_API.g_valid_level_full

2554: OZF_Claim_PVT.Update_Claim(
2555: p_api_version => l_api_version
2556: ,p_init_msg_list => FND_API.g_false
2557: ,p_commit => FND_API.g_false
2558: ,p_validation_level => FND_API.g_valid_level_full
2559: ,x_return_status => l_return_status
2560: ,x_msg_data => l_msg_data
2561: ,x_msg_count => l_msg_count
2562: ,p_claim => l_claim_rec

Line 2569: IF l_return_status = fnd_api.g_ret_sts_success THEN

2565: ,x_object_version_number => l_object_version_number
2566: );
2567: END IF;
2568:
2569: IF l_return_status = fnd_api.g_ret_sts_success THEN
2570: resultout := 'COMPLETE:SUCCESS';
2571: ELSE
2572: FND_MSG_PUB.count_and_get (
2573: p_encoded => fnd_api.g_false

Line 2573: p_encoded => fnd_api.g_false

2569: IF l_return_status = fnd_api.g_ret_sts_success THEN
2570: resultout := 'COMPLETE:SUCCESS';
2571: ELSE
2572: FND_MSG_PUB.count_and_get (
2573: p_encoded => fnd_api.g_false
2574: ,p_count => l_msg_count
2575: ,p_data => l_msg_data
2576: );
2577: AMS_GEN_APPROVAL_PVT.handle_err(

Line 2614: p_encoded => fnd_api.g_false

2610: RETURN;
2611: END IF;
2612:
2613: fnd_msg_pub.count_and_get(
2614: p_encoded => fnd_api.g_false
2615: ,p_count => l_msg_count
2616: ,p_data => l_msg_data
2617: );
2618:

Line 2638: p_encoded => fnd_api.g_false

2634: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
2635: FND_MSG_PUB.Add;
2636:
2637: fnd_msg_pub.count_and_get(
2638: p_encoded => fnd_api.g_false
2639: ,p_count => l_msg_count
2640: ,p_data => l_msg_data
2641: );
2642: resultout := 'COMPLETE:ERROR';