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

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

16: g_financing_pending CONSTANT VARCHAR2 (30) := 'PENDING';
17:
18: PROCEDURE update_status (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_miss_num,
23: p_tangible_id IN NUMBER,
24: p_credit_app_id IN NUMBER,

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

17:
18: PROCEDURE update_status (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_miss_num,
23: p_tangible_id IN NUMBER,
24: p_credit_app_id IN NUMBER,
25: p_new_status_category IN VARCHAR2,

Line 22: p_validation_level IN NUMBER := fnd_api.g_miss_num,

18: PROCEDURE update_status (
19: p_api_version IN NUMBER,
20: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21: p_commit IN VARCHAR2 := fnd_api.g_false,
22: p_validation_level IN NUMBER := fnd_api.g_miss_num,
23: p_tangible_id IN NUMBER,
24: p_credit_app_id IN NUMBER,
25: p_new_status_category IN VARCHAR2,
26: p_new_status IN VARCHAR2,

Line 27: p_last_update_date IN DATE := fnd_api.g_miss_date,

23: p_tangible_id IN NUMBER,
24: p_credit_app_id IN NUMBER,
25: p_new_status_category IN VARCHAR2,
26: p_new_status IN VARCHAR2,
27: p_last_update_date IN DATE := fnd_api.g_miss_date,
28: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
29: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
30: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31: ) IS

Line 95: IF NOT fnd_api.compatible_api_call (

91: -- Standard Start of API savepoint
92: SAVEPOINT update_status_pvt;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT fnd_api.compatible_api_call (
96: l_api_version,
97: p_api_version,
98: l_api_name,
99: g_pkg_name

Line 102: RAISE fnd_api.g_exc_unexpected_error;

98: l_api_name,
99: g_pkg_name
100: )
101: THEN
102: RAISE fnd_api.g_exc_unexpected_error;
103: END IF;
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF fnd_api.to_boolean (

Line 106: IF fnd_api.to_boolean (

102: RAISE fnd_api.g_exc_unexpected_error;
103: END IF;
104:
105: -- Initialize message list if p_init_msg_list is set to TRUE.
106: IF fnd_api.to_boolean (
107: p_init_msg_list
108: )
109: THEN
110: fnd_msg_pub.initialize;

Line 114: x_return_status := fnd_api.g_ret_sts_success;

110: fnd_msg_pub.initialize;
111: END IF;
112:
113: -- Initialize API return status to SUCCESS
114: x_return_status := fnd_api.g_ret_sts_success;
115:
116: --
117: -- API body
118: --

Line 141: RAISE fnd_api.g_exc_error;

137: );
138: fnd_msg_pub.ADD;
139: END IF;
140:
141: RAISE fnd_api.g_exc_error;
142: END IF;
143:
144: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
145: aso_debug_pub.ADD (

Line 236: RAISE fnd_api.g_exc_error;

232: );
233: fnd_msg_pub.ADD;
234: END IF;
235:
236: RAISE fnd_api.g_exc_error;
237: END IF;
238: ELSE
239: CLOSE c_financing_id;
240: END IF;

Line 279: IF p_last_update_date = fnd_api.g_miss_date

275: */
276: IF p_new_status_category = g_financing_pending
277: AND l_current_status_code <> 'FINANCING PENDING'
278: THEN
279: IF p_last_update_date = fnd_api.g_miss_date
280: OR p_last_update_date IS NULL
281: THEN
282: IF fnd_msg_pub.check_msg_level (
283: fnd_msg_pub.g_msg_lvl_error

Line 298: RAISE fnd_api.g_exc_error;

294: );
295: fnd_msg_pub.ADD;
296: END IF;
297:
298: RAISE fnd_api.g_exc_error;
299: ELSIF p_last_update_date <> l_qte_header_rec.last_update_date
300: THEN
301: IF fnd_msg_pub.check_msg_level (
302: fnd_msg_pub.g_msg_lvl_error

Line 317: RAISE fnd_api.g_exc_error;

313: );
314: fnd_msg_pub.ADD;
315: END IF;
316:
317: RAISE fnd_api.g_exc_error;
318: END IF;
319: END IF;
320:
321: IF p_new_status_category = g_financing_approved

Line 359: p_validation_level => fnd_api.g_valid_level_none,

355: aso_related_obj_pvt.create_related_obj (
356: p_api_version_number => 1.0,
357: p_init_msg_list => p_init_msg_list,
358: p_commit => p_commit,
359: p_validation_level => fnd_api.g_valid_level_none,
360: p_related_obj_rec => l_related_obj_rec,
361: x_related_object_id => l_related_obj_id,
362: x_return_status => x_return_status,
363: x_msg_count => x_msg_count,

Line 375: IF x_return_status <> fnd_api.g_ret_sts_success

371: 'Y'
372: );
373: END IF;
374:
375: IF x_return_status <> fnd_api.g_ret_sts_success
376: THEN
377: IF fnd_msg_pub.check_msg_level (
378: fnd_msg_pub.g_msg_lvl_error
379: )

Line 393: RAISE fnd_api.g_exc_error;

389: );
390: fnd_msg_pub.ADD;
391: END IF;
392:
393: RAISE fnd_api.g_exc_error;
394: END IF;
395: ELSIF l_credit_app_id <> p_credit_app_id
396: THEN
397: l_related_obj_rec.related_object_id := l_related_obj_id;

Line 402: p_validation_level => fnd_api.g_valid_level_none,

398: aso_related_obj_pvt.update_related_obj (
399: p_api_version_number => 1.0,
400: p_init_msg_list => p_init_msg_list,
401: p_commit => p_commit,
402: p_validation_level => fnd_api.g_valid_level_none,
403: p_related_obj_rec => l_related_obj_rec,
404: x_return_status => x_return_status,
405: x_msg_count => x_msg_count,
406: x_msg_data => x_msg_data

Line 417: IF x_return_status <> fnd_api.g_ret_sts_success

413: 'Y'
414: );
415: END IF;
416:
417: IF x_return_status <> fnd_api.g_ret_sts_success
418: THEN
419: IF fnd_msg_pub.check_msg_level (
420: fnd_msg_pub.g_msg_lvl_error
421: )

Line 435: RAISE fnd_api.g_exc_error;

431: );
432: fnd_msg_pub.ADD;
433: END IF;
434:
435: RAISE fnd_api.g_exc_error;
436: END IF;
437: END IF;
438:
439: OPEN c_qte_status_id (

Line 461: RAISE fnd_api.g_exc_error;

457: );
458: fnd_msg_pub.ADD;
459: END IF;
460:
461: RAISE fnd_api.g_exc_error;
462: END IF;
463:
464: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
465: aso_debug_pub.ADD (

Line 482: l_control_rec.auto_version_flag := fnd_api.g_true;

478: IF l_qte_header_rec.quote_status_id <> l_quote_status_id
479: THEN
480: l_qte_header_rec.quote_header_id := l_quote_header_id;
481: l_control_rec := aso_quote_pub.g_miss_control_rec;
482: l_control_rec.auto_version_flag := fnd_api.g_true;
483: aso_quote_pub.update_quote (
484: p_api_version_number => 1.0,
485: p_init_msg_list => fnd_api.g_false,
486: p_commit => fnd_api.g_false,

Line 485: p_init_msg_list => fnd_api.g_false,

481: l_control_rec := aso_quote_pub.g_miss_control_rec;
482: l_control_rec.auto_version_flag := fnd_api.g_true;
483: aso_quote_pub.update_quote (
484: p_api_version_number => 1.0,
485: p_init_msg_list => fnd_api.g_false,
486: p_commit => fnd_api.g_false,
487: p_qte_header_rec => l_qte_header_rec,
488: x_qte_header_rec => lx_qte_header_rec,
489: x_qte_line_tbl => lx_qte_line_tbl,

Line 486: p_commit => fnd_api.g_false,

482: l_control_rec.auto_version_flag := fnd_api.g_true;
483: aso_quote_pub.update_quote (
484: p_api_version_number => 1.0,
485: p_init_msg_list => fnd_api.g_false,
486: p_commit => fnd_api.g_false,
487: p_qte_header_rec => l_qte_header_rec,
488: x_qte_header_rec => lx_qte_header_rec,
489: x_qte_line_tbl => lx_qte_line_tbl,
490: x_qte_line_dtl_tbl => lx_qte_line_dtl_tbl,

Line 518: IF x_return_status <> fnd_api.g_ret_sts_success

514: 'Y'
515: );
516: END IF;
517:
518: IF x_return_status <> fnd_api.g_ret_sts_success
519: THEN
520: IF fnd_msg_pub.check_msg_level (
521: fnd_msg_pub.g_msg_lvl_error
522: )

Line 531: RAISE fnd_api.g_exc_error;

527: );
528: fnd_msg_pub.ADD;
529: END IF;
530:
531: RAISE fnd_api.g_exc_error;
532: END IF;
533: END IF;
534:
535: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 548: IF fnd_api.to_boolean (

544: -- End of API body.
545: --
546:
547: -- Standard check for p_commit
548: IF fnd_api.to_boolean (
549: p_commit
550: )
551: THEN
552: COMMIT WORK;

Line 566: WHEN fnd_api.g_exc_error

562: p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: EXCEPTION
566: WHEN fnd_api.g_exc_error
567: THEN
568: aso_utility_pvt.handle_exceptions (
569: p_api_name => l_api_name,
570: p_pkg_name => g_pkg_name,

Line 577: WHEN fnd_api.g_exc_unexpected_error

573: x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data,
575: x_return_status => x_return_status
576: );
577: WHEN fnd_api.g_exc_unexpected_error
578: THEN
579: aso_utility_pvt.handle_exceptions (
580: p_api_name => l_api_name,
581: p_pkg_name => g_pkg_name,