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

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

149: -- *********************************************************************
150: -- This insert_row is used by the OA Framework Ledger page
151: PROCEDURE insert_row(
152: p_api_version IN NUMBER := 1.0,
153: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
154: p_commit IN VARCHAR2 := fnd_api.g_false,
155: p_validate_only IN VARCHAR2 := fnd_api.g_true,
156: p_record_version_number IN NUMBER := NULL,
157: x_return_status OUT NOCOPY VARCHAR2,

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

150: -- This insert_row is used by the OA Framework Ledger page
151: PROCEDURE insert_row(
152: p_api_version IN NUMBER := 1.0,
153: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
154: p_commit IN VARCHAR2 := fnd_api.g_false,
155: p_validate_only IN VARCHAR2 := fnd_api.g_true,
156: p_record_version_number IN NUMBER := NULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,

Line 155: p_validate_only IN VARCHAR2 := fnd_api.g_true,

151: PROCEDURE insert_row(
152: p_api_version IN NUMBER := 1.0,
153: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
154: p_commit IN VARCHAR2 := fnd_api.g_false,
155: p_validate_only IN VARCHAR2 := fnd_api.g_true,
156: p_record_version_number IN NUMBER := NULL,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,

Line 280: IF p_commit = fnd_api.g_true THEN

276: select completion_status_code
277: from gl_ledger_configurations
278: where configuration_id = x_configuration_id;
279: BEGIN
280: IF p_commit = fnd_api.g_true THEN
281: SAVEPOINT complete_workorder;
282: END IF;
283:
284: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

Line 284: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

280: IF p_commit = fnd_api.g_true THEN
281: SAVEPOINT complete_workorder;
282: END IF;
283:
284: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
285: l_api_name, g_pkg_name) THEN
286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:

Line 286: RAISE fnd_api.g_exc_unexpected_error;

282: END IF;
283:
284: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
285: l_api_name, g_pkg_name) THEN
286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:
289: IF fnd_api.to_boolean(p_init_msg_list) THEN
290: fnd_msg_pub.initialize;

Line 289: IF fnd_api.to_boolean(p_init_msg_list) THEN

285: l_api_name, g_pkg_name) THEN
286: RAISE fnd_api.g_exc_unexpected_error;
287: END IF;
288:
289: IF fnd_api.to_boolean(p_init_msg_list) THEN
290: fnd_msg_pub.initialize;
291: END IF;
292:
293: x_return_status := fnd_api.g_ret_sts_success;

Line 293: x_return_status := fnd_api.g_ret_sts_success;

289: IF fnd_api.to_boolean(p_init_msg_list) THEN
290: fnd_msg_pub.initialize;
291: END IF;
292:
293: x_return_status := fnd_api.g_ret_sts_success;
294:
295: -- Default the first period of the ledger to the second period in the calendar.
296: OPEN first_ledger_period;
297: LOOP

Line 395: x_return_status := fnd_api.g_ret_sts_unexp_error;

391: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,
392: -- 'Invalid period_average_rate_type');
393: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PAVE_RATETYPE');
394: fnd_msg_pub.ADD;
395: x_return_status := fnd_api.g_ret_sts_unexp_error;
396: END;
397: END IF;
398:
399: IF x_period_end_rate_type IS NOT NULL THEN

Line 411: x_return_status := fnd_api.g_ret_sts_unexp_error;

407: EXCEPTION
408: WHEN NO_DATA_FOUND THEN
409: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PEND_RATETYPE');
410: fnd_msg_pub.ADD;
411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412: END;
413: END IF;
414:
415: /* IF x_sla_accounting_method_code IS NOT NULL THEN

Line 426: x_return_status := fnd_api.g_ret_sts_unexp_error;

422: EXCEPTION
423: WHEN NO_DATA_FOUND THEN
424: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_JE_DESC');
425: fnd_msg_pub.ADD;
426: x_return_status := fnd_api.g_ret_sts_unexp_error;
427: END;
428: END IF;*/
429:
430: IF x_criteria_set_id IS NOT NULL THEN

Line 441: x_return_status := fnd_api.g_ret_sts_unexp_error;

437: WHEN NO_DATA_FOUND THEN
438: fnd_message.set_name('SQLGL',
439: 'GL_ASF_LGR_JE_REVERSAL_INVALID');
440: fnd_msg_pub.ADD;
441: x_return_status := fnd_api.g_ret_sts_unexp_error;
442: END;
443: END IF;
444:
445: IF(x_ledger_category_code = 'ALC') THEN

Line 554: x_return_status := fnd_api.g_ret_sts_unexp_error;

550:
551: --RAISE NO_DATA_FOUND;
552: --The following new style is used for transferring error message back to OA FWK page
553: fnd_msg_pub.ADD;
554: x_return_status := fnd_api.g_ret_sts_unexp_error;
555: END IF;
556:
557: CLOSE c;
558:

Line 579: x_return_status := fnd_api.g_ret_sts_unexp_error;

575: x_creation_date, x_created_by);
576: EXCEPTION
577: WHEN OTHERS THEN
578: fnd_msg_pub.ADD;
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: IF sqlerrm is not null
581: then
582: fnd_message.set_name('SQLGL', 'DB-ERROR');
583: fnd_message.set_token ('Message ', sqlerrm);

Line 646: x_return_status := fnd_api.g_ret_sts_unexp_error;

642: x_msg_count := fnd_msg_pub.count_msg;
643: x_msg_data := fnd_message.get;
644:
645: IF x_msg_count > 0 THEN
646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647: RAISE fnd_api.g_exc_error;
648: END IF;
649: EXCEPTION
650: WHEN fnd_api.g_exc_unexpected_error THEN

Line 647: RAISE fnd_api.g_exc_error;

643: x_msg_data := fnd_message.get;
644:
645: IF x_msg_count > 0 THEN
646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647: RAISE fnd_api.g_exc_error;
648: END IF;
649: EXCEPTION
650: WHEN fnd_api.g_exc_unexpected_error THEN
651: IF p_commit = fnd_api.g_true THEN

Line 650: WHEN fnd_api.g_exc_unexpected_error THEN

646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647: RAISE fnd_api.g_exc_error;
648: END IF;
649: EXCEPTION
650: WHEN fnd_api.g_exc_unexpected_error THEN
651: IF p_commit = fnd_api.g_true THEN
652: ROLLBACK TO complete_workorder;
653: END IF;
654:

Line 651: IF p_commit = fnd_api.g_true THEN

647: RAISE fnd_api.g_exc_error;
648: END IF;
649: EXCEPTION
650: WHEN fnd_api.g_exc_unexpected_error THEN
651: IF p_commit = fnd_api.g_true THEN
652: ROLLBACK TO complete_workorder;
653: END IF;
654:
655: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

Line 657: x_return_status := fnd_api.g_ret_sts_unexp_error;

653: END IF;
654:
655: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
656: p_procedure_name => l_api_name);
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: WHEN fnd_api.g_exc_error THEN
659: IF p_commit = fnd_api.g_true THEN
660: ROLLBACK TO complete_workorder;
661: END IF;

Line 658: WHEN fnd_api.g_exc_error THEN

654:
655: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
656: p_procedure_name => l_api_name);
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: WHEN fnd_api.g_exc_error THEN
659: IF p_commit = fnd_api.g_true THEN
660: ROLLBACK TO complete_workorder;
661: END IF;
662:

Line 659: IF p_commit = fnd_api.g_true THEN

655: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
656: p_procedure_name => l_api_name);
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: WHEN fnd_api.g_exc_error THEN
659: IF p_commit = fnd_api.g_true THEN
660: ROLLBACK TO complete_workorder;
661: END IF;
662:
663: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

Line 665: x_return_status := fnd_api.g_ret_sts_unexp_error;

661: END IF;
662:
663: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
664: p_procedure_name => l_api_name);
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: WHEN OTHERS THEN
667: IF p_commit = fnd_api.g_true THEN
668: ROLLBACK TO complete_workorder;
669: END IF;

Line 667: IF p_commit = fnd_api.g_true THEN

663: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
664: p_procedure_name => l_api_name);
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: WHEN OTHERS THEN
667: IF p_commit = fnd_api.g_true THEN
668: ROLLBACK TO complete_workorder;
669: END IF;
670:
671: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

Line 673: x_return_status := fnd_api.g_ret_sts_unexp_error;

669: END IF;
670:
671: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
672: p_procedure_name => l_api_name);
673: x_return_status := fnd_api.g_ret_sts_unexp_error;
674: END insert_row;
675:
676: -- **********************************************************************
677: -- This update_row is used by the OA Framework Ledger page

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

676: -- **********************************************************************
677: -- This update_row is used by the OA Framework Ledger page
678: PROCEDURE update_row(
679: p_api_version IN NUMBER := 1.0,
680: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
681: p_commit IN VARCHAR2 := fnd_api.g_false,
682: p_validate_only IN VARCHAR2 := fnd_api.g_true,
683: p_record_version_number IN NUMBER := NULL,
684: x_return_status OUT NOCOPY VARCHAR2,

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

677: -- This update_row is used by the OA Framework Ledger page
678: PROCEDURE update_row(
679: p_api_version IN NUMBER := 1.0,
680: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
681: p_commit IN VARCHAR2 := fnd_api.g_false,
682: p_validate_only IN VARCHAR2 := fnd_api.g_true,
683: p_record_version_number IN NUMBER := NULL,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,

Line 682: p_validate_only IN VARCHAR2 := fnd_api.g_true,

678: PROCEDURE update_row(
679: p_api_version IN NUMBER := 1.0,
680: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
681: p_commit IN VARCHAR2 := fnd_api.g_false,
682: p_validate_only IN VARCHAR2 := fnd_api.g_true,
683: p_record_version_number IN NUMBER := NULL,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,

Line 848: IF p_commit = fnd_api.g_true THEN

844: l_period_avg_rt_changed VARCHAR2(1) :='N';
845: l_period_end_rt_changed VARCHAR2(1) :='N';
846: temp NUMBER;
847: BEGIN
848: IF p_commit = fnd_api.g_true THEN
849: SAVEPOINT complete_workorder;
850: END IF;
851:
852: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

Line 852: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

848: IF p_commit = fnd_api.g_true THEN
849: SAVEPOINT complete_workorder;
850: END IF;
851:
852: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
853: l_api_name, g_pkg_name) THEN
854: RAISE fnd_api.g_exc_unexpected_error;
855: END IF;
856:

Line 854: RAISE fnd_api.g_exc_unexpected_error;

850: END IF;
851:
852: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
853: l_api_name, g_pkg_name) THEN
854: RAISE fnd_api.g_exc_unexpected_error;
855: END IF;
856:
857: IF fnd_api.to_boolean(p_init_msg_list) THEN
858: fnd_msg_pub.initialize;

Line 857: IF fnd_api.to_boolean(p_init_msg_list) THEN

853: l_api_name, g_pkg_name) THEN
854: RAISE fnd_api.g_exc_unexpected_error;
855: END IF;
856:
857: IF fnd_api.to_boolean(p_init_msg_list) THEN
858: fnd_msg_pub.initialize;
859: END IF;
860:
861: x_return_status := fnd_api.g_ret_sts_success;

Line 861: x_return_status := fnd_api.g_ret_sts_success;

857: IF fnd_api.to_boolean(p_init_msg_list) THEN
858: fnd_msg_pub.initialize;
859: END IF;
860:
861: x_return_status := fnd_api.g_ret_sts_success;
862:
863: -- Ledger API checks
864: OPEN c;
865: FETCH c

Line 983: x_return_status := fnd_api.g_ret_sts_unexp_error;

979: EXCEPTION
980: WHEN NO_DATA_FOUND THEN
981: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PAVE_RATETYPE');
982: fnd_msg_pub.ADD;
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: END;
985: END IF;
986:
987: IF x_period_end_rate_type IS NOT NULL THEN

Line 999: x_return_status := fnd_api.g_ret_sts_unexp_error;

995: EXCEPTION
996: WHEN NO_DATA_FOUND THEN
997: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_PEND_RATETYPE');
998: fnd_msg_pub.ADD;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000: END;
1001: END IF;
1002:
1003: IF x_sla_accounting_method_code IS NOT NULL THEN

Line 1014: x_return_status := fnd_api.g_ret_sts_unexp_error;

1010: EXCEPTION
1011: WHEN NO_DATA_FOUND THEN
1012: fnd_message.set_name('SQLGL', 'GL_ASF_LGR_NEED_JE_DESC');
1013: fnd_msg_pub.ADD;
1014: x_return_status := fnd_api.g_ret_sts_unexp_error;
1015: END;
1016: END IF;
1017:
1018: IF x_criteria_set_id IS NOT NULL THEN

Line 1029: x_return_status := fnd_api.g_ret_sts_unexp_error;

1025: WHEN NO_DATA_FOUND THEN
1026: fnd_message.set_name('SQLGL',
1027: 'GL_ASF_LGR_JE_REVERSAL_INVALID');
1028: fnd_msg_pub.ADD;
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: END;
1031: END IF;
1032:
1033: ----- temporary validation ends

Line 1374: x_return_status := fnd_api.g_ret_sts_unexp_error;

1370: -- Bug fix 3265048: Move this check before updating ALC ledgers
1371: IF (SQL%NOTFOUND) THEN
1372: --RAISE NO_DATA_FOUND;
1373: fnd_msg_pub.ADD;
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1375: END IF;
1376:
1377: IF ( ( (x_current_sla_actg_method_code IS NULL)
1378: AND (x_sla_accounting_method_code IS NOT NULL))

Line 1643: x_return_status := fnd_api.g_ret_sts_unexp_error;

1639:
1640: x_msg_count := fnd_msg_pub.count_msg;
1641:
1642: IF x_msg_count > 0 THEN
1643: x_return_status := fnd_api.g_ret_sts_unexp_error;
1644: RAISE fnd_api.g_exc_error;
1645: END IF;
1646: EXCEPTION
1647: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1644: RAISE fnd_api.g_exc_error;

1640: x_msg_count := fnd_msg_pub.count_msg;
1641:
1642: IF x_msg_count > 0 THEN
1643: x_return_status := fnd_api.g_ret_sts_unexp_error;
1644: RAISE fnd_api.g_exc_error;
1645: END IF;
1646: EXCEPTION
1647: WHEN fnd_api.g_exc_unexpected_error THEN
1648: IF p_commit = fnd_api.g_true THEN

Line 1647: WHEN fnd_api.g_exc_unexpected_error THEN

1643: x_return_status := fnd_api.g_ret_sts_unexp_error;
1644: RAISE fnd_api.g_exc_error;
1645: END IF;
1646: EXCEPTION
1647: WHEN fnd_api.g_exc_unexpected_error THEN
1648: IF p_commit = fnd_api.g_true THEN
1649: ROLLBACK TO complete_workorder;
1650: END IF;
1651:

Line 1648: IF p_commit = fnd_api.g_true THEN

1644: RAISE fnd_api.g_exc_error;
1645: END IF;
1646: EXCEPTION
1647: WHEN fnd_api.g_exc_unexpected_error THEN
1648: IF p_commit = fnd_api.g_true THEN
1649: ROLLBACK TO complete_workorder;
1650: END IF;
1651:
1652: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

Line 1654: x_return_status := fnd_api.g_ret_sts_unexp_error;

1650: END IF;
1651:
1652: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1653: p_procedure_name => l_api_name);
1654: x_return_status := fnd_api.g_ret_sts_unexp_error;
1655: WHEN fnd_api.g_exc_error THEN
1656: IF p_commit = fnd_api.g_true THEN
1657: ROLLBACK TO complete_workorder;
1658: END IF;

Line 1655: WHEN fnd_api.g_exc_error THEN

1651:
1652: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1653: p_procedure_name => l_api_name);
1654: x_return_status := fnd_api.g_ret_sts_unexp_error;
1655: WHEN fnd_api.g_exc_error THEN
1656: IF p_commit = fnd_api.g_true THEN
1657: ROLLBACK TO complete_workorder;
1658: END IF;
1659:

Line 1656: IF p_commit = fnd_api.g_true THEN

1652: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1653: p_procedure_name => l_api_name);
1654: x_return_status := fnd_api.g_ret_sts_unexp_error;
1655: WHEN fnd_api.g_exc_error THEN
1656: IF p_commit = fnd_api.g_true THEN
1657: ROLLBACK TO complete_workorder;
1658: END IF;
1659:
1660: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

Line 1662: x_return_status := fnd_api.g_ret_sts_unexp_error;

1658: END IF;
1659:
1660: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1661: p_procedure_name => l_api_name);
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: WHEN OTHERS THEN
1664: IF p_commit = fnd_api.g_true THEN
1665: ROLLBACK TO complete_workorder;
1666: END IF;

Line 1664: IF p_commit = fnd_api.g_true THEN

1660: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1661: p_procedure_name => l_api_name);
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: WHEN OTHERS THEN
1664: IF p_commit = fnd_api.g_true THEN
1665: ROLLBACK TO complete_workorder;
1666: END IF;
1667:
1668: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,

Line 1670: x_return_status := fnd_api.g_ret_sts_unexp_error;

1666: END IF;
1667:
1668: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name,
1669: p_procedure_name => l_api_name);
1670: x_return_status := fnd_api.g_ret_sts_unexp_error;
1671: END update_row;
1672:
1673: -- **********************************************************************
1674: PROCEDURE check_unique_name(