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

Line 29: x_return_status := fnd_api.g_ret_sts_success;

25: l_lkup_meaning cn_lookups.meaning%TYPE;
26: l_loading_status VARCHAR2 (80);
27: BEGIN
28: -- Initialize API return status to success
29: x_return_status := fnd_api.g_ret_sts_success;
30: x_loading_status := p_loading_status;
31: --+
32: -- Check Miss And Null Parameters.
33: --+

Line 41: ) = fnd_api.g_true

37: p_obj_name => l_lkup_meaning,
38: p_loading_status => x_loading_status,
39: x_loading_status => l_loading_status
40: )
41: ) = fnd_api.g_true
42: )
43: THEN
44: RAISE fnd_api.g_exc_error;
45: END IF;

Line 44: RAISE fnd_api.g_exc_error;

40: )
41: ) = fnd_api.g_true
42: )
43: THEN
44: RAISE fnd_api.g_exc_error;
45: END IF;
46:
47: l_lkup_meaning := cn_api.get_lkup_meaning ('', 'PM_OBJECT_TYPE');
48:

Line 54: ) = fnd_api.g_true

50: p_obj_name => l_lkup_meaning,
51: p_loading_status => x_loading_status,
52: x_loading_status => l_loading_status
53: )
54: ) = fnd_api.g_true
55: )
56: THEN
57: RAISE fnd_api.g_exc_error;
58: END IF;

Line 57: RAISE fnd_api.g_exc_error;

53: )
54: ) = fnd_api.g_true
55: )
56: THEN
57: RAISE fnd_api.g_exc_error;
58: END IF;
59:
60: -- Quota ID
61: x_quota_id := cn_chk_plan_element_pkg.get_quota_id (LTRIM (RTRIM (p_quota_name)), p_org_id);

Line 72: RAISE fnd_api.g_exc_error;

68: THEN
69: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
70: fnd_message.set_token ('PE_NAME', p_quota_name);
71: fnd_msg_pub.ADD;
72: RAISE fnd_api.g_exc_error;
73: END IF;
74: END IF;
75: END IF;
76:

Line 92: RAISE fnd_api.g_exc_error;

88: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
89: fnd_msg_pub.ADD;
90: END IF;
91:
92: RAISE fnd_api.g_exc_error;
93: END IF;
94: ELSE
95: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
96: THEN

Line 101: RAISE fnd_api.g_exc_error;

97: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
98: fnd_msg_pub.ADD;
99: END IF;
100:
101: RAISE fnd_api.g_exc_error;
102: END IF;
103:
104: IF x_quota_rule_id IS NULL
105: THEN

Line 112: RAISE fnd_api.g_exc_error;

108: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
109: fnd_msg_pub.ADD;
110: END IF;
111:
112: RAISE fnd_api.g_exc_error;
113: END IF;
114: -- End Check Valid Quotas.
115: END check_valid_quotas;
116:

Line 125: -- Default = FND_API.G_FALSE

121: -- Pre-reqs : None.
122: -- Parameters :
123: -- IN : p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional
125: -- Default = FND_API.G_FALSE
126: -- p_commit IN VARCHAR2 Optional
127: -- Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional
129: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 127: -- Default = FND_API.G_FALSE

123: -- IN : p_api_version IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional
125: -- Default = FND_API.G_FALSE
126: -- p_commit IN VARCHAR2 Optional
127: -- Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional
129: -- Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_trx_factor IN trx_factor_rec_type
131: -- OUT : x_return_status OUT VARCHAR2(1)

Line 129: -- Default = FND_API.G_VALID_LEVEL_FULL

125: -- Default = FND_API.G_FALSE
126: -- p_commit IN VARCHAR2 Optional
127: -- Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional
129: -- Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_trx_factor IN trx_factor_rec_type
131: -- OUT : x_return_status OUT VARCHAR2(1)
132: -- x_msg_count OUT NUMBER
133: -- x_msg_data OUT VARCHAR2(2000)

Line 141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

137: --
138: -- End of comments
139: PROCEDURE create_trx_factor (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142: p_commit IN VARCHAR2 := fnd_api.g_false,
143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
145: x_return_status OUT NOCOPY VARCHAR2,

Line 142: p_commit IN VARCHAR2 := fnd_api.g_false,

138: -- End of comments
139: PROCEDURE create_trx_factor (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142: p_commit IN VARCHAR2 := fnd_api.g_false,
143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

Line 143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

139: PROCEDURE create_trx_factor (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142: p_commit IN VARCHAR2 := fnd_api.g_false,
143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2

Line 158: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

154: -- Standard Start of API savepoint
155: SAVEPOINT create_trx_factor;
156:
157: -- Standard call to check for call compatibility.
158: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
159: THEN
160: RAISE fnd_api.g_exc_unexpected_error;
161: END IF;
162:

Line 160: RAISE fnd_api.g_exc_unexpected_error;

156:
157: -- Standard call to check for call compatibility.
158: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
159: THEN
160: RAISE fnd_api.g_exc_unexpected_error;
161: END IF;
162:
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF fnd_api.to_boolean (p_init_msg_list)

Line 164: IF fnd_api.to_boolean (p_init_msg_list)

160: RAISE fnd_api.g_exc_unexpected_error;
161: END IF;
162:
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF fnd_api.to_boolean (p_init_msg_list)
165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168:

Line 170: x_return_status := fnd_api.g_ret_sts_success;

166: fnd_msg_pub.initialize;
167: END IF;
168:
169: -- Initialize API return status to success
170: x_return_status := fnd_api.g_ret_sts_success;
171: -- API body
172:
173: -- This will never be used
174: RAISE fnd_api.g_exc_unexpected_error;

Line 174: RAISE fnd_api.g_exc_unexpected_error;

170: x_return_status := fnd_api.g_ret_sts_success;
171: -- API body
172:
173: -- This will never be used
174: RAISE fnd_api.g_exc_unexpected_error;
175:
176: -- End of API body.
177: -- Standard check of p_commit.
178: IF fnd_api.to_boolean (p_commit)

Line 178: IF fnd_api.to_boolean (p_commit)

174: RAISE fnd_api.g_exc_unexpected_error;
175:
176: -- End of API body.
177: -- Standard check of p_commit.
178: IF fnd_api.to_boolean (p_commit)
179: THEN
180: COMMIT WORK;
181: END IF;
182:

Line 184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

180: COMMIT WORK;
181: END IF;
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
185: EXCEPTION
186: WHEN fnd_api.g_exc_error
187: THEN
188: ROLLBACK TO create_trx_factor;

Line 186: WHEN fnd_api.g_exc_error

182:
183: -- Standard call to get message count and if count is 1, get message info.
184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
185: EXCEPTION
186: WHEN fnd_api.g_exc_error
187: THEN
188: ROLLBACK TO create_trx_factor;
189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 189: x_return_status := fnd_api.g_ret_sts_error;

185: EXCEPTION
186: WHEN fnd_api.g_exc_error
187: THEN
188: ROLLBACK TO create_trx_factor;
189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;

Line 190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

186: WHEN fnd_api.g_exc_error
187: THEN
188: ROLLBACK TO create_trx_factor;
189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 191: WHEN fnd_api.g_exc_unexpected_error

187: THEN
188: ROLLBACK TO create_trx_factor;
189: x_return_status := fnd_api.g_ret_sts_error;
190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 194: x_return_status := fnd_api.g_ret_sts_unexp_error;

190: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
196: WHEN OTHERS
197: THEN
198: ROLLBACK TO create_trx_factor;

Line 195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

191: WHEN fnd_api.g_exc_unexpected_error
192: THEN
193: ROLLBACK TO create_trx_factor;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
196: WHEN OTHERS
197: THEN
198: ROLLBACK TO create_trx_factor;
199: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 199: x_return_status := fnd_api.g_ret_sts_unexp_error;

195: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
196: WHEN OTHERS
197: THEN
198: ROLLBACK TO create_trx_factor;
199: x_return_status := fnd_api.g_ret_sts_unexp_error;
200:
201: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
202: THEN
203: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 206: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

202: THEN
203: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
204: END IF;
205:
206: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
207: END create_trx_factor;
208:
209: -- Start of comments
210: -- API name : Validate_Trx_Factor

Line 217: -- Default = FND_API.G_FALSE

213: -- Pre-reqs : None.
214: -- Parameters :
215: -- IN : p_api_version IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional
217: -- Default = FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Optional
219: -- Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional
221: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 219: -- Default = FND_API.G_FALSE

215: -- IN : p_api_version IN NUMBER Required
216: -- p_init_msg_list IN VARCHAR2 Optional
217: -- Default = FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Optional
219: -- Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional
221: -- Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_trx_factor IN trx_factor_rec_type
223: -- OUT : x_return_status OUT VARCHAR2(1)

Line 221: -- Default = FND_API.G_VALID_LEVEL_FULL

217: -- Default = FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Optional
219: -- Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional
221: -- Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_trx_factor IN trx_factor_rec_type
223: -- OUT : x_return_status OUT VARCHAR2(1)
224: -- x_msg_count OUT NUMBER
225: -- x_msg_data OUT VARCHAR2(2000)

Line 233: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

229: --
230: -- End of comments
231: PROCEDURE validate_trx_factor (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
234: p_commit IN VARCHAR2 := fnd_api.g_false,
235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
236: p_action IN VARCHAR2,
237: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,

Line 234: p_commit IN VARCHAR2 := fnd_api.g_false,

230: -- End of comments
231: PROCEDURE validate_trx_factor (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
234: p_commit IN VARCHAR2 := fnd_api.g_false,
235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
236: p_action IN VARCHAR2,
237: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
238: p_old_trx_factor IN trx_factor_rec_type := g_miss_trx_factor_rec,

Line 235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

231: PROCEDURE validate_trx_factor (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
234: p_commit IN VARCHAR2 := fnd_api.g_false,
235: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
236: p_action IN VARCHAR2,
237: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
238: p_old_trx_factor IN trx_factor_rec_type := g_miss_trx_factor_rec,
239: x_return_status OUT NOCOPY VARCHAR2,

Line 253: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

249: -- Standard Start of API savepoint
250: SAVEPOINT validate_trx_factor;
251:
252: -- Standard call to check for call compatibility.
253: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
254: THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:

Line 255: RAISE fnd_api.g_exc_unexpected_error;

251:
252: -- Standard call to check for call compatibility.
253: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
254: THEN
255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF fnd_api.to_boolean (p_init_msg_list)

Line 259: IF fnd_api.to_boolean (p_init_msg_list)

255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF fnd_api.to_boolean (p_init_msg_list)
260: THEN
261: fnd_msg_pub.initialize;
262: END IF;
263:

Line 265: x_return_status := fnd_api.g_ret_sts_success;

261: fnd_msg_pub.initialize;
262: END IF;
263:
264: -- Initialize API return status to success
265: x_return_status := fnd_api.g_ret_sts_success;
266:
267: -- 1. name can not be null
268: IF (p_trx_factor.trx_type IS NOT NULL)
269: THEN

Line 284: RAISE fnd_api.g_exc_error;

280: THEN
281: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXISTS');
282: fnd_message.set_token ('TRANSACTION_TYPE', p_trx_factor.trx_type);
283: fnd_msg_pub.ADD;
284: RAISE fnd_api.g_exc_error;
285: END;
286: END IF;
287: ELSE
288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 297: RAISE fnd_api.g_exc_error;

293: fnd_message.set_token ('INPUT_NAME',cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'));
294: fnd_msg_pub.ADD;
295: END IF;
296: END IF ;
297: RAISE fnd_api.g_exc_error;
298: END IF;
299:
300: IF p_trx_factor.event_factor IS NULL
301: THEN

Line 308: RAISE fnd_api.g_exc_error;

304: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
305: fnd_message.set_token ('INPUT_NAME',cn_api.get_lkup_meaning ('EVENT_FACTOR', 'PE_OBJECT_TYPE'));
306: fnd_msg_pub.ADD;
307: END IF;
308: RAISE fnd_api.g_exc_error;
309: END IF ;
310:
311: IF p_trx_factor.quota_id IS NULL
312: THEN

Line 320: RAISE fnd_api.g_exc_error;

316: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'), 'PE'));
317: fnd_msg_pub.ADD;
318: END IF;
319:
320: RAISE fnd_api.g_exc_error;
321: END IF;
322:
323: IF p_trx_factor.revenue_class_id IS NULL
324: THEN

Line 330: RAISE fnd_api.g_exc_error;

326: THEN
327: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
328: fnd_msg_pub.ADD;
329: END IF;
330: RAISE fnd_api.g_exc_error;
331: END IF;
332:
333: IF p_trx_factor.quota_rule_id IS NULL
334: THEN

Line 341: RAISE fnd_api.g_exc_error;

337: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
338: fnd_msg_pub.ADD;
339: END IF;
340:
341: RAISE fnd_api.g_exc_error;
342: END IF;
343:
344: IF p_action = 'UPDATE'
345: THEN

Line 355: RAISE fnd_api.g_exc_error;

351: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('TRX_TYPE', 'PE_OBJECT_TYPE'), 'TRX_TYPE'));
352: fnd_msg_pub.ADD;
353: END IF;
354:
355: RAISE fnd_api.g_exc_error;
356: END IF;
357:
358: IF p_trx_factor.quota_id <> p_old_trx_factor.quota_id
359: THEN

Line 367: RAISE fnd_api.g_exc_error;

363: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'), 'PE'));
364: fnd_msg_pub.ADD;
365: END IF;
366:
367: RAISE fnd_api.g_exc_error;
368: END IF;
369:
370: IF p_trx_factor.quota_rule_id <> p_old_trx_factor.quota_rule_id
371: THEN

Line 379: RAISE fnd_api.g_exc_error;

375: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('RC_ASSIGN', 'PE_OBJECT_TYPE'), 'RC_ASSIGN'));
376: fnd_msg_pub.ADD;
377: END IF;
378:
379: RAISE fnd_api.g_exc_error;
380: END IF;
381:
382: IF p_trx_factor.revenue_class_id <> p_old_trx_factor.revenue_class_id
383: THEN

Line 391: RAISE fnd_api.g_exc_error;

387: fnd_message.set_token ('FIELD_NAME', NVL (cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'), 'TRX_TYPE'));
388: fnd_msg_pub.ADD;
389: END IF;
390:
391: RAISE fnd_api.g_exc_error;
392: END IF;
393: END IF;
394:
395: SELECT COUNT (*)

Line 417: RAISE fnd_api.g_exc_error;

413: fnd_message.set_token ('INPUT5', ' ');
414: fnd_msg_pub.ADD;
415: END IF;
416:
417: RAISE fnd_api.g_exc_error;
418: END IF;
419:
420: -- 2. trx type must be unique
421: SELECT COUNT (1)

Line 437: RAISE fnd_api.g_exc_error;

433: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
434: fnd_msg_pub.ADD;
435: END IF;
436:
437: RAISE fnd_api.g_exc_error;
438: END IF;
439:
440: --DBMS_OUTPUT.PUT_LINE('OrgId:'||p_trx_factor.org_id||'|'||p_trx_factor.quota_id) ;
441: IF NOT cn_plan_element_pvt.is_valid_org(p_trx_factor.org_id, p_trx_factor.quota_id)

Line 443: RAISE fnd_api.g_exc_error;

439:
440: --DBMS_OUTPUT.PUT_LINE('OrgId:'||p_trx_factor.org_id||'|'||p_trx_factor.quota_id) ;
441: IF NOT cn_plan_element_pvt.is_valid_org(p_trx_factor.org_id, p_trx_factor.quota_id)
442: THEN
443: RAISE fnd_api.g_exc_error;
444: END IF ;
445:
446: -- 1. check object version number
447: IF p_old_trx_factor.object_version_number <> NVL (p_trx_factor.object_version_number, -1)

Line 451: RAISE fnd_api.g_exc_error;

447: IF p_old_trx_factor.object_version_number <> NVL (p_trx_factor.object_version_number, -1)
448: THEN
449: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
450: fnd_msg_pub.ADD;
451: RAISE fnd_api.g_exc_error;
452: END IF;
453:
454: -- Standard call to get message count and if count is 1, get message info.
455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

451: RAISE fnd_api.g_exc_error;
452: END IF;
453:
454: -- Standard call to get message count and if count is 1, get message info.
455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
456: EXCEPTION
457: WHEN fnd_api.g_exc_error
458: THEN
459: ROLLBACK TO validate_trx_factor;

Line 457: WHEN fnd_api.g_exc_error

453:
454: -- Standard call to get message count and if count is 1, get message info.
455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
456: EXCEPTION
457: WHEN fnd_api.g_exc_error
458: THEN
459: ROLLBACK TO validate_trx_factor;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456: EXCEPTION
457: WHEN fnd_api.g_exc_error
458: THEN
459: ROLLBACK TO validate_trx_factor;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;

Line 461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

457: WHEN fnd_api.g_exc_error
458: THEN
459: ROLLBACK TO validate_trx_factor;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 462: WHEN fnd_api.g_exc_unexpected_error

458: THEN
459: ROLLBACK TO validate_trx_factor;
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 465: x_return_status := fnd_api.g_ret_sts_unexp_error;

461: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
467: WHEN OTHERS
468: THEN
469: ROLLBACK TO validate_trx_factor;

Line 466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

462: WHEN fnd_api.g_exc_unexpected_error
463: THEN
464: ROLLBACK TO validate_trx_factor;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
467: WHEN OTHERS
468: THEN
469: ROLLBACK TO validate_trx_factor;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 470: x_return_status := fnd_api.g_ret_sts_unexp_error;

466: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
467: WHEN OTHERS
468: THEN
469: ROLLBACK TO validate_trx_factor;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471:
472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
473: THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

473: THEN
474: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
475: END IF;
476:
477: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
478: END validate_trx_factor;
479:
480: -- Start of comments
481: -- API name : Update_Trx_Factor

Line 488: -- Default = FND_API.G_FALSE

484: -- Pre-reqs : None.
485: -- Parameters :
486: -- IN : p_api_version IN NUMBER Required
487: -- p_init_msg_list IN VARCHAR2 Optional
488: -- Default = FND_API.G_FALSE
489: -- p_commit IN VARCHAR2 Optional
490: -- Default = FND_API.G_FALSE
491: -- p_validation_level IN NUMBER Optional
492: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 490: -- Default = FND_API.G_FALSE

486: -- IN : p_api_version IN NUMBER Required
487: -- p_init_msg_list IN VARCHAR2 Optional
488: -- Default = FND_API.G_FALSE
489: -- p_commit IN VARCHAR2 Optional
490: -- Default = FND_API.G_FALSE
491: -- p_validation_level IN NUMBER Optional
492: -- Default = FND_API.G_VALID_LEVEL_FULL
493: -- p_trx_factor IN trx_factor_rec_type
494: -- OUT : x_return_status OUT VARCHAR2(1)

Line 492: -- Default = FND_API.G_VALID_LEVEL_FULL

488: -- Default = FND_API.G_FALSE
489: -- p_commit IN VARCHAR2 Optional
490: -- Default = FND_API.G_FALSE
491: -- p_validation_level IN NUMBER Optional
492: -- Default = FND_API.G_VALID_LEVEL_FULL
493: -- p_trx_factor IN trx_factor_rec_type
494: -- OUT : x_return_status OUT VARCHAR2(1)
495: -- x_msg_count OUT NUMBER
496: -- x_msg_data OUT VARCHAR2(2000)

Line 503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

499: --
500: -- End of comments
501: PROCEDURE update_trx_factor (
502: p_api_version IN NUMBER,
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
504: p_commit IN VARCHAR2 := fnd_api.g_false,
505: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
506: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
507: x_return_status OUT NOCOPY VARCHAR2,

Line 504: p_commit IN VARCHAR2 := fnd_api.g_false,

500: -- End of comments
501: PROCEDURE update_trx_factor (
502: p_api_version IN NUMBER,
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
504: p_commit IN VARCHAR2 := fnd_api.g_false,
505: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
506: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_count OUT NOCOPY NUMBER,

Line 505: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

501: PROCEDURE update_trx_factor (
502: p_api_version IN NUMBER,
503: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
504: p_commit IN VARCHAR2 := fnd_api.g_false,
505: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
506: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_count OUT NOCOPY NUMBER,
509: x_msg_data OUT NOCOPY VARCHAR2

Line 545: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

541: -- Standard Start of API savepoint
542: SAVEPOINT update_trx_factor;
543:
544: -- Standard call to check for call compatibility.
545: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
546: THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF;
549:

Line 547: RAISE fnd_api.g_exc_unexpected_error;

543:
544: -- Standard call to check for call compatibility.
545: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
546: THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF;
549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF fnd_api.to_boolean (p_init_msg_list)

Line 551: IF fnd_api.to_boolean (p_init_msg_list)

547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF;
549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF fnd_api.to_boolean (p_init_msg_list)
552: THEN
553: fnd_msg_pub.initialize;
554: END IF;
555:

Line 557: x_return_status := fnd_api.g_ret_sts_success;

553: fnd_msg_pub.initialize;
554: END IF;
555:
556: -- Initialize API return status to success
557: x_return_status := fnd_api.g_ret_sts_success;
558:
559: OPEN trx_factor_csr (p_trx_factor.trx_factor_id);
560:
561: FETCH trx_factor_csr

Line 573: RAISE fnd_api.g_exc_error;

569: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('TRX_FACTOR', 'PE_OBJECT_TYPE'), 'TRX_FACTOR'));
570: fnd_msg_pub.ADD;
571: END IF;
572:
573: RAISE fnd_api.g_exc_error;
574: END IF;
575:
576: CLOSE trx_factor_csr;
577:

Line 599: IF (x_return_status <> fnd_api.g_ret_sts_success)

595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data
597: );
598:
599: IF (x_return_status <> fnd_api.g_ret_sts_success)
600: THEN
601: RAISE fnd_api.g_exc_error;
602: END IF;
603:

Line 601: RAISE fnd_api.g_exc_error;

597: );
598:
599: IF (x_return_status <> fnd_api.g_ret_sts_success)
600: THEN
601: RAISE fnd_api.g_exc_error;
602: END IF;
603:
604: -- update the record
605: -- org_id depends on the plan elements org_id

Line 657: IF (x_return_status <> fnd_api.g_ret_sts_success)

653: x_jtf_note_id => l_note_id -- returned
654: );
655: END IF;
656:
657: IF (x_return_status <> fnd_api.g_ret_sts_success)
658: THEN
659: RAISE fnd_api.g_exc_error;
660: END IF;
661:

Line 659: RAISE fnd_api.g_exc_error;

655: END IF;
656:
657: IF (x_return_status <> fnd_api.g_ret_sts_success)
658: THEN
659: RAISE fnd_api.g_exc_error;
660: END IF;
661:
662: -- End of API body.
663: -- Standard check of p_commit.

Line 664: IF fnd_api.to_boolean (p_commit)

660: END IF;
661:
662: -- End of API body.
663: -- Standard check of p_commit.
664: IF fnd_api.to_boolean (p_commit)
665: THEN
666: COMMIT WORK;
667: END IF;
668:

Line 670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

666: COMMIT WORK;
667: END IF;
668:
669: -- Standard call to get message count and if count is 1, get message info.
670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
671: EXCEPTION
672: WHEN fnd_api.g_exc_error
673: THEN
674: ROLLBACK TO update_trx_factor;

Line 672: WHEN fnd_api.g_exc_error

668:
669: -- Standard call to get message count and if count is 1, get message info.
670: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
671: EXCEPTION
672: WHEN fnd_api.g_exc_error
673: THEN
674: ROLLBACK TO update_trx_factor;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 675: x_return_status := fnd_api.g_ret_sts_error;

671: EXCEPTION
672: WHEN fnd_api.g_exc_error
673: THEN
674: ROLLBACK TO update_trx_factor;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;

Line 676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

672: WHEN fnd_api.g_exc_error
673: THEN
674: ROLLBACK TO update_trx_factor;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;
680: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 677: WHEN fnd_api.g_exc_unexpected_error

673: THEN
674: ROLLBACK TO update_trx_factor;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 680: x_return_status := fnd_api.g_ret_sts_unexp_error;

676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
682: WHEN OTHERS
683: THEN
684: ROLLBACK TO update_trx_factor;

Line 681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

677: WHEN fnd_api.g_exc_unexpected_error
678: THEN
679: ROLLBACK TO update_trx_factor;
680: x_return_status := fnd_api.g_ret_sts_unexp_error;
681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
682: WHEN OTHERS
683: THEN
684: ROLLBACK TO update_trx_factor;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 685: x_return_status := fnd_api.g_ret_sts_unexp_error;

681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
682: WHEN OTHERS
683: THEN
684: ROLLBACK TO update_trx_factor;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686:
687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
688: THEN
689: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 692: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

688: THEN
689: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
690: END IF;
691:
692: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
693: END update_trx_factor;
694:
695: -- Start of comments
696: -- API name : update_trx_factors

Line 703: -- Default = FND_API.G_FALSE

699: -- Pre-reqs : None.
700: -- Parameters :
701: -- IN : p_api_version IN NUMBER Required
702: -- p_init_msg_list IN VARCHAR2 Optional
703: -- Default = FND_API.G_FALSE
704: -- p_commit IN VARCHAR2 Optional
705: -- Default = FND_API.G_FALSE
706: -- p_validation_level IN NUMBER Optional
707: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 705: -- Default = FND_API.G_FALSE

701: -- IN : p_api_version IN NUMBER Required
702: -- p_init_msg_list IN VARCHAR2 Optional
703: -- Default = FND_API.G_FALSE
704: -- p_commit IN VARCHAR2 Optional
705: -- Default = FND_API.G_FALSE
706: -- p_validation_level IN NUMBER Optional
707: -- Default = FND_API.G_VALID_LEVEL_FULL
708: -- p_trx_factor IN trx_factor_rec_type
709: -- OUT : x_return_status OUT VARCHAR2(1)

Line 707: -- Default = FND_API.G_VALID_LEVEL_FULL

703: -- Default = FND_API.G_FALSE
704: -- p_commit IN VARCHAR2 Optional
705: -- Default = FND_API.G_FALSE
706: -- p_validation_level IN NUMBER Optional
707: -- Default = FND_API.G_VALID_LEVEL_FULL
708: -- p_trx_factor IN trx_factor_rec_type
709: -- OUT : x_return_status OUT VARCHAR2(1)
710: -- x_msg_count OUT NUMBER
711: -- x_msg_data OUT VARCHAR2(2000)

Line 719: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

715: --
716: -- End of comments
717: PROCEDURE update_trx_factors (
718: p_api_version IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
720: p_commit IN VARCHAR2 := fnd_api.g_false,
721: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
722: p_org_id IN NUMBER,
723: p_quota_name IN VARCHAR2,

Line 720: p_commit IN VARCHAR2 := fnd_api.g_false,

716: -- End of comments
717: PROCEDURE update_trx_factors (
718: p_api_version IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
720: p_commit IN VARCHAR2 := fnd_api.g_false,
721: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
722: p_org_id IN NUMBER,
723: p_quota_name IN VARCHAR2,
724: p_revenue_class_name IN VARCHAR2 := NULL,

Line 721: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

717: PROCEDURE update_trx_factors (
718: p_api_version IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
720: p_commit IN VARCHAR2 := fnd_api.g_false,
721: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
722: p_org_id IN NUMBER,
723: p_quota_name IN VARCHAR2,
724: p_revenue_class_name IN VARCHAR2 := NULL,
725: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type,

Line 750: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

746:
747: --+
748: -- Standard call to check for call compatibility.
749: --+
750: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
751: THEN
752: RAISE fnd_api.g_exc_unexpected_error;
753: END IF;
754:

Line 752: RAISE fnd_api.g_exc_unexpected_error;

748: -- Standard call to check for call compatibility.
749: --+
750: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
751: THEN
752: RAISE fnd_api.g_exc_unexpected_error;
753: END IF;
754:
755: --+
756: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 758: IF fnd_api.to_boolean (p_init_msg_list)

754:
755: --+
756: -- Initialize message list if p_init_msg_list is set to TRUE.
757: -- +
758: IF fnd_api.to_boolean (p_init_msg_list)
759: THEN
760: fnd_msg_pub.initialize;
761: END IF;
762:

Line 766: x_return_status := fnd_api.g_ret_sts_success;

762:
763: -- +
764: -- Initialize API return status to success
765: --+
766: x_return_status := fnd_api.g_ret_sts_success;
767:
768: IF p_trx_factor_rec_tbl.COUNT > 0
769: THEN
770: -- API body

Line 780: ) = fnd_api.g_true

776: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
777: p_loading_status => x_loading_status,
778: x_loading_status => l_loading_status
779: )
780: ) = fnd_api.g_true
781: )
782: THEN
783: RAISE fnd_api.g_exc_error;
784: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,

Line 783: RAISE fnd_api.g_exc_error;

779: )
780: ) = fnd_api.g_true
781: )
782: THEN
783: RAISE fnd_api.g_exc_error;
784: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,
785: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
786: p_loading_status => x_loading_status,
787: x_loading_status => l_loading_status

Line 789: ) = fnd_api.g_true

785: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
786: p_loading_status => x_loading_status,
787: x_loading_status => l_loading_status
788: )
789: ) = fnd_api.g_true
790: )
791: THEN
792: RAISE fnd_api.g_exc_error;
793: END IF;

Line 792: RAISE fnd_api.g_exc_error;

788: )
789: ) = fnd_api.g_true
790: )
791: THEN
792: RAISE fnd_api.g_exc_error;
793: END IF;
794:
795: -- Get the Quota ID
796: l_quota_id := cn_chk_plan_element_pkg.get_quota_id (LTRIM (RTRIM (p_quota_name)), p_org_id);

Line 809: RAISE fnd_api.g_exc_error;

805: fnd_msg_pub.ADD;
806: END IF;
807:
808: x_loading_status := 'CN_PLN_NOT_EXIST';
809: RAISE fnd_api.g_exc_error;
810: END IF;
811:
812: -- if revenue class is not given, check for all
813: IF p_revenue_class_name IS NULL

Line 873: RAISE fnd_api.g_exc_error;

869: fnd_message.set_token ('OBJ_NAME', NVL (cn_api.get_lkup_meaning ('TRX_FACTOR', 'PE_OBJECT_TYPE'), 'TRX_FACTOR'));
870: fnd_msg_pub.ADD;
871: END IF;
872:
873: RAISE fnd_api.g_exc_error;
874: END;
875:
876: IF RTRIM (LTRIM (p_trx_factor_rec_tbl (i).rev_class_name)) = l_rev_class_name
877: THEN

Line 888: IF (x_return_status <> fnd_api.g_ret_sts_success)

884: x_msg_count => x_msg_count,
885: x_msg_data => x_msg_data
886: );
887:
888: IF (x_return_status <> fnd_api.g_ret_sts_success)
889: THEN
890: RAISE fnd_api.g_exc_error;
891: END IF;
892: ELSE

Line 890: RAISE fnd_api.g_exc_error;

886: );
887:
888: IF (x_return_status <> fnd_api.g_ret_sts_success)
889: THEN
890: RAISE fnd_api.g_exc_error;
891: END IF;
892: ELSE
893: fnd_message.set_name ('CN', 'CN_INCONSISTENT_REV_CLASS');
894: fnd_msg_pub.ADD;

Line 895: RAISE fnd_api.g_exc_error;

891: END IF;
892: ELSE
893: fnd_message.set_name ('CN', 'CN_INCONSISTENT_REV_CLASS');
894: fnd_msg_pub.ADD;
895: RAISE fnd_api.g_exc_error;
896: END IF;
897: END LOOP;
898:
899: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,

Line 907: IF (x_return_status <> fnd_api.g_ret_sts_success)

903: x_loading_status => l_loading_status
904: );
905: x_loading_status := l_loading_status;
906:
907: IF (x_return_status <> fnd_api.g_ret_sts_success)
908: THEN
909: RAISE fnd_api.g_exc_error;
910: END IF;
911: END LOOP;

Line 909: RAISE fnd_api.g_exc_error;

905: x_loading_status := l_loading_status;
906:
907: IF (x_return_status <> fnd_api.g_ret_sts_success)
908: THEN
909: RAISE fnd_api.g_exc_error;
910: END IF;
911: END LOOP;
912: END IF;
913:

Line 917: IF fnd_api.to_boolean (p_commit)

913:
914: -- End of API body.
915: -- Standard check of p_commit.
916: --+
917: IF fnd_api.to_boolean (p_commit)
918: THEN
919: COMMIT WORK;
920: END IF;
921:

Line 925: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

921:
922: --+
923: -- Standard call to get message count and if count is 1, get message info.
924: --+
925: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
926: EXCEPTION
927: WHEN fnd_api.g_exc_error
928: THEN
929: ROLLBACK TO update_trx_factors;

Line 927: WHEN fnd_api.g_exc_error

923: -- Standard call to get message count and if count is 1, get message info.
924: --+
925: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
926: EXCEPTION
927: WHEN fnd_api.g_exc_error
928: THEN
929: ROLLBACK TO update_trx_factors;
930: x_return_status := fnd_api.g_ret_sts_error;
931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 930: x_return_status := fnd_api.g_ret_sts_error;

926: EXCEPTION
927: WHEN fnd_api.g_exc_error
928: THEN
929: ROLLBACK TO update_trx_factors;
930: x_return_status := fnd_api.g_ret_sts_error;
931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
932: WHEN fnd_api.g_exc_unexpected_error
933: THEN
934: ROLLBACK TO update_trx_factors;

Line 931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

927: WHEN fnd_api.g_exc_error
928: THEN
929: ROLLBACK TO update_trx_factors;
930: x_return_status := fnd_api.g_ret_sts_error;
931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
932: WHEN fnd_api.g_exc_unexpected_error
933: THEN
934: ROLLBACK TO update_trx_factors;
935: x_loading_status := 'UNEXPECTED_ERR';

Line 932: WHEN fnd_api.g_exc_unexpected_error

928: THEN
929: ROLLBACK TO update_trx_factors;
930: x_return_status := fnd_api.g_ret_sts_error;
931: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
932: WHEN fnd_api.g_exc_unexpected_error
933: THEN
934: ROLLBACK TO update_trx_factors;
935: x_loading_status := 'UNEXPECTED_ERR';
936: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 936: x_return_status := fnd_api.g_ret_sts_unexp_error;

932: WHEN fnd_api.g_exc_unexpected_error
933: THEN
934: ROLLBACK TO update_trx_factors;
935: x_loading_status := 'UNEXPECTED_ERR';
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
938: WHEN OTHERS
939: THEN
940: ROLLBACK TO update_trx_factors;

Line 937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

933: THEN
934: ROLLBACK TO update_trx_factors;
935: x_loading_status := 'UNEXPECTED_ERR';
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
938: WHEN OTHERS
939: THEN
940: ROLLBACK TO update_trx_factors;
941: x_loading_status := 'UNEXPECTED_ERR';

Line 942: x_return_status := fnd_api.g_ret_sts_unexp_error;

938: WHEN OTHERS
939: THEN
940: ROLLBACK TO update_trx_factors;
941: x_loading_status := 'UNEXPECTED_ERR';
942: x_return_status := fnd_api.g_ret_sts_unexp_error;
943:
944: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
945: THEN
946: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 949: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

945: THEN
946: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
947: END IF;
948:
949: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
950: END update_trx_factors;
951:
952: -- Start of comments
953: -- API name : Delete_Trx_Factor

Line 960: -- Default = FND_API.G_FALSE

956: -- Pre-reqs : None.
957: -- Parameters :
958: -- IN : p_api_version IN NUMBER Required
959: -- p_init_msg_list IN VARCHAR2 Optional
960: -- Default = FND_API.G_FALSE
961: -- p_commit IN VARCHAR2 Optional
962: -- Default = FND_API.G_FALSE
963: -- p_validation_level IN NUMBER Optional
964: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 962: -- Default = FND_API.G_FALSE

958: -- IN : p_api_version IN NUMBER Required
959: -- p_init_msg_list IN VARCHAR2 Optional
960: -- Default = FND_API.G_FALSE
961: -- p_commit IN VARCHAR2 Optional
962: -- Default = FND_API.G_FALSE
963: -- p_validation_level IN NUMBER Optional
964: -- Default = FND_API.G_VALID_LEVEL_FULL
965: -- p_trx_factor IN trx_factor_rec_type
966: -- OUT : x_return_status OUT VARCHAR2(1)

Line 964: -- Default = FND_API.G_VALID_LEVEL_FULL

960: -- Default = FND_API.G_FALSE
961: -- p_commit IN VARCHAR2 Optional
962: -- Default = FND_API.G_FALSE
963: -- p_validation_level IN NUMBER Optional
964: -- Default = FND_API.G_VALID_LEVEL_FULL
965: -- p_trx_factor IN trx_factor_rec_type
966: -- OUT : x_return_status OUT VARCHAR2(1)
967: -- x_msg_count OUT NUMBER
968: -- x_msg_data OUT VARCHAR2(2000)

Line 975: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

971: --
972: -- End of comments
973: PROCEDURE delete_trx_factor (
974: p_api_version IN NUMBER,
975: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
976: p_commit IN VARCHAR2 := fnd_api.g_false,
977: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
978: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
979: x_return_status OUT NOCOPY VARCHAR2,

Line 976: p_commit IN VARCHAR2 := fnd_api.g_false,

972: -- End of comments
973: PROCEDURE delete_trx_factor (
974: p_api_version IN NUMBER,
975: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
976: p_commit IN VARCHAR2 := fnd_api.g_false,
977: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
978: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,

Line 977: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

973: PROCEDURE delete_trx_factor (
974: p_api_version IN NUMBER,
975: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
976: p_commit IN VARCHAR2 := fnd_api.g_false,
977: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
978: p_trx_factor IN OUT NOCOPY trx_factor_rec_type,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,
981: x_msg_data OUT NOCOPY VARCHAR2

Line 992: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

988: -- Standard Start of API savepoint
989: SAVEPOINT delete_trx_factor;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
993: THEN
994: RAISE fnd_api.g_exc_unexpected_error;
995: END IF;
996:

Line 994: RAISE fnd_api.g_exc_unexpected_error;

990:
991: -- Standard call to check for call compatibility.
992: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
993: THEN
994: RAISE fnd_api.g_exc_unexpected_error;
995: END IF;
996:
997: -- Initialize message list if p_init_msg_list is set to TRUE.
998: IF fnd_api.to_boolean (p_init_msg_list)

Line 998: IF fnd_api.to_boolean (p_init_msg_list)

994: RAISE fnd_api.g_exc_unexpected_error;
995: END IF;
996:
997: -- Initialize message list if p_init_msg_list is set to TRUE.
998: IF fnd_api.to_boolean (p_init_msg_list)
999: THEN
1000: fnd_msg_pub.initialize;
1001: END IF;
1002:

Line 1004: x_return_status := fnd_api.g_ret_sts_success;

1000: fnd_msg_pub.initialize;
1001: END IF;
1002:
1003: -- Initialize API return status to success
1004: x_return_status := fnd_api.g_ret_sts_success;
1005: -- API body
1006:
1007: -- This will never be used
1008: RAISE fnd_api.g_exc_unexpected_error;

Line 1008: RAISE fnd_api.g_exc_unexpected_error;

1004: x_return_status := fnd_api.g_ret_sts_success;
1005: -- API body
1006:
1007: -- This will never be used
1008: RAISE fnd_api.g_exc_unexpected_error;
1009:
1010: -- End of API body.
1011: -- Standard check of p_commit.
1012: IF fnd_api.to_boolean (p_commit)

Line 1012: IF fnd_api.to_boolean (p_commit)

1008: RAISE fnd_api.g_exc_unexpected_error;
1009:
1010: -- End of API body.
1011: -- Standard check of p_commit.
1012: IF fnd_api.to_boolean (p_commit)
1013: THEN
1014: COMMIT WORK;
1015: END IF;
1016:

Line 1018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1014: COMMIT WORK;
1015: END IF;
1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1019: EXCEPTION
1020: WHEN fnd_api.g_exc_error
1021: THEN
1022: ROLLBACK TO delete_trx_factor;

Line 1020: WHEN fnd_api.g_exc_error

1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1019: EXCEPTION
1020: WHEN fnd_api.g_exc_error
1021: THEN
1022: ROLLBACK TO delete_trx_factor;
1023: x_return_status := fnd_api.g_ret_sts_error;
1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1023: x_return_status := fnd_api.g_ret_sts_error;

1019: EXCEPTION
1020: WHEN fnd_api.g_exc_error
1021: THEN
1022: ROLLBACK TO delete_trx_factor;
1023: x_return_status := fnd_api.g_ret_sts_error;
1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;

Line 1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1020: WHEN fnd_api.g_exc_error
1021: THEN
1022: ROLLBACK TO delete_trx_factor;
1023: x_return_status := fnd_api.g_ret_sts_error;
1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1025: WHEN fnd_api.g_exc_unexpected_error

1021: THEN
1022: ROLLBACK TO delete_trx_factor;
1023: x_return_status := fnd_api.g_ret_sts_error;
1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1028: x_return_status := fnd_api.g_ret_sts_unexp_error;

1024: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1030: WHEN OTHERS
1031: THEN
1032: ROLLBACK TO delete_trx_factor;

Line 1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1025: WHEN fnd_api.g_exc_unexpected_error
1026: THEN
1027: ROLLBACK TO delete_trx_factor;
1028: x_return_status := fnd_api.g_ret_sts_unexp_error;
1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1030: WHEN OTHERS
1031: THEN
1032: ROLLBACK TO delete_trx_factor;
1033: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1033: x_return_status := fnd_api.g_ret_sts_unexp_error;

1029: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1030: WHEN OTHERS
1031: THEN
1032: ROLLBACK TO delete_trx_factor;
1033: x_return_status := fnd_api.g_ret_sts_unexp_error;
1034:
1035: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1036: THEN
1037: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1040: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1036: THEN
1037: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1038: END IF;
1039:
1040: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1041: END delete_trx_factor;
1042:
1043: -- Start of comments
1044: -- API name : Get_Trx_Factor

Line 1051: -- Default = FND_API.G_FALSE

1047: -- Pre-reqs : None.
1048: -- Parameters :
1049: -- IN : p_api_version IN NUMBER Required
1050: -- p_init_msg_list IN VARCHAR2 Optional
1051: -- Default = FND_API.G_FALSE
1052: -- p_commit IN VARCHAR2 Optional
1053: -- Default = FND_API.G_FALSE
1054: -- p_validation_level IN NUMBER Optional
1055: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1053: -- Default = FND_API.G_FALSE

1049: -- IN : p_api_version IN NUMBER Required
1050: -- p_init_msg_list IN VARCHAR2 Optional
1051: -- Default = FND_API.G_FALSE
1052: -- p_commit IN VARCHAR2 Optional
1053: -- Default = FND_API.G_FALSE
1054: -- p_validation_level IN NUMBER Optional
1055: -- Default = FND_API.G_VALID_LEVEL_FULL
1056: -- p_quota_rule_id IN NUMBER
1057: -- OUT : x_return_status OUT VARCHAR2(1)

Line 1055: -- Default = FND_API.G_VALID_LEVEL_FULL

1051: -- Default = FND_API.G_FALSE
1052: -- p_commit IN VARCHAR2 Optional
1053: -- Default = FND_API.G_FALSE
1054: -- p_validation_level IN NUMBER Optional
1055: -- Default = FND_API.G_VALID_LEVEL_FULL
1056: -- p_quota_rule_id IN NUMBER
1057: -- OUT : x_return_status OUT VARCHAR2(1)
1058: -- x_msg_count OUT NUMBER
1059: -- x_msg_data OUT VARCHAR2(2000)

Line 1067: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1063: --
1064: -- End of comments
1065: PROCEDURE get_trx_factor (
1066: p_api_version IN NUMBER,
1067: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1068: p_commit IN VARCHAR2 := fnd_api.g_false,
1069: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1070: p_quota_rule_id IN NUMBER,
1071: x_trx_factor OUT NOCOPY trx_factor_tbl_type,

Line 1068: p_commit IN VARCHAR2 := fnd_api.g_false,

1064: -- End of comments
1065: PROCEDURE get_trx_factor (
1066: p_api_version IN NUMBER,
1067: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1068: p_commit IN VARCHAR2 := fnd_api.g_false,
1069: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1070: p_quota_rule_id IN NUMBER,
1071: x_trx_factor OUT NOCOPY trx_factor_tbl_type,
1072: x_return_status OUT NOCOPY VARCHAR2,

Line 1069: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1065: PROCEDURE get_trx_factor (
1066: p_api_version IN NUMBER,
1067: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1068: p_commit IN VARCHAR2 := fnd_api.g_false,
1069: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1070: p_quota_rule_id IN NUMBER,
1071: x_trx_factor OUT NOCOPY trx_factor_tbl_type,
1072: x_return_status OUT NOCOPY VARCHAR2,
1073: x_msg_count OUT NOCOPY NUMBER,

Line 1092: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1088: -- Standard Start of API savepoint
1089: SAVEPOINT get_trx_factor;
1090:
1091: -- Standard call to check for call compatibility.
1092: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1093: THEN
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;
1096:

Line 1094: RAISE fnd_api.g_exc_unexpected_error;

1090:
1091: -- Standard call to check for call compatibility.
1092: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1093: THEN
1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;
1096:
1097: -- Initialize message list if p_init_msg_list is set to TRUE.
1098: IF fnd_api.to_boolean (p_init_msg_list)

Line 1098: IF fnd_api.to_boolean (p_init_msg_list)

1094: RAISE fnd_api.g_exc_unexpected_error;
1095: END IF;
1096:
1097: -- Initialize message list if p_init_msg_list is set to TRUE.
1098: IF fnd_api.to_boolean (p_init_msg_list)
1099: THEN
1100: fnd_msg_pub.initialize;
1101: END IF;
1102:

Line 1104: x_return_status := fnd_api.g_ret_sts_success;

1100: fnd_msg_pub.initialize;
1101: END IF;
1102:
1103: -- Initialize API return status to success
1104: x_return_status := fnd_api.g_ret_sts_success;
1105: -- API body
1106: x_trx_factor := g_miss_trx_factor_rec_tb;
1107: l_counter := 0;
1108:

Line 1123: IF fnd_api.to_boolean (p_commit)

1119: END LOOP;
1120:
1121: -- End of API body.
1122: -- Standard check of p_commit.
1123: IF fnd_api.to_boolean (p_commit)
1124: THEN
1125: COMMIT WORK;
1126: END IF;
1127:

Line 1129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1125: COMMIT WORK;
1126: END IF;
1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1130: EXCEPTION
1131: WHEN fnd_api.g_exc_error
1132: THEN
1133: ROLLBACK TO get_trx_factor;

Line 1131: WHEN fnd_api.g_exc_error

1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1130: EXCEPTION
1131: WHEN fnd_api.g_exc_error
1132: THEN
1133: ROLLBACK TO get_trx_factor;
1134: x_return_status := fnd_api.g_ret_sts_error;
1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1134: x_return_status := fnd_api.g_ret_sts_error;

1130: EXCEPTION
1131: WHEN fnd_api.g_exc_error
1132: THEN
1133: ROLLBACK TO get_trx_factor;
1134: x_return_status := fnd_api.g_ret_sts_error;
1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;

Line 1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1131: WHEN fnd_api.g_exc_error
1132: THEN
1133: ROLLBACK TO get_trx_factor;
1134: x_return_status := fnd_api.g_ret_sts_error;
1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1136: WHEN fnd_api.g_exc_unexpected_error

1132: THEN
1133: ROLLBACK TO get_trx_factor;
1134: x_return_status := fnd_api.g_ret_sts_error;
1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;
1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1139: x_return_status := fnd_api.g_ret_sts_unexp_error;

1135: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;
1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1141: WHEN OTHERS
1142: THEN
1143: ROLLBACK TO get_trx_factor;

Line 1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1136: WHEN fnd_api.g_exc_unexpected_error
1137: THEN
1138: ROLLBACK TO get_trx_factor;
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;
1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1141: WHEN OTHERS
1142: THEN
1143: ROLLBACK TO get_trx_factor;
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1144: x_return_status := fnd_api.g_ret_sts_unexp_error;

1140: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1141: WHEN OTHERS
1142: THEN
1143: ROLLBACK TO get_trx_factor;
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;
1145:
1146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1147: THEN
1148: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1151: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1147: THEN
1148: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1149: END IF;
1150:
1151: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1152: END get_trx_factor;
1153: END cn_trx_factor_pvt;