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.CE_BANK_PUB dependencies on FND_MSG_PUB

Line 29: fnd_msg_pub.add;

25: IF (p_param_value IS NULL)
26: THEN
27: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
28: fnd_message.set_token('PARAM', p_param_name);
29: fnd_msg_pub.add;
30: IF l_DEBUG in ('Y', 'C') THEN
31: cep_standard.debug(p_param_name|| ' is a required parameter.');
32: END IF;
33: RAISE fnd_api.g_exc_error;

Line 68: fnd_msg_pub.add;

64: OPEN c_country;
65: FETCH c_country INTO l_country;
66: IF c_country%NOTFOUND THEN
67: fnd_message.set_name('CE', 'CE_API_NO_BANK');
68: fnd_msg_pub.add;
69: x_return_status := fnd_api.g_ret_sts_error;
70: END IF;
71: CLOSE c_country;
72:

Line 138: fnd_msg_pub.add;

134: OPEN c_bank;
135: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
136: IF c_bank%NOTFOUND THEN
137: fnd_message.set_name('CE', 'CE_API_NO_BANK');
138: fnd_msg_pub.add;
139: x_return_status := fnd_api.g_ret_sts_error;
140: END IF;
141: CLOSE c_bank;
142:

Line 237: fnd_msg_pub.initialize;

233: END IF;
234:
235: -- initialize message list
236: IF fnd_api.to_boolean(p_init_msg_list) THEN
237: fnd_msg_pub.initialize;
238: END IF;
239:
240: -- initialize API return status to success.
241: x_return_status := fnd_api.g_ret_sts_success;

Line 325: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

321: RAISE fnd_api.g_exc_error;
322: END IF;
323:
324: -- get message count and if count is 1, get message info.
325: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328:
329: IF l_DEBUG in ('Y', 'C') THEN

Line 337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

333: EXCEPTION
334: WHEN fnd_api.g_exc_error THEN
335: ROLLBACK TO create_bank;
336: x_return_status := fnd_api.g_ret_sts_error;
337: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
338: p_count => x_msg_count,
339: p_data => x_msg_data);
340:
341: IF l_DEBUG in ('Y', 'C') THEN

Line 348: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

344:
345: WHEN fnd_api.g_exc_unexpected_error THEN
346: ROLLBACK TO create_bank;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
349: p_count => x_msg_count,
350: p_data => x_msg_data);
351:
352: IF l_DEBUG in ('Y', 'C') THEN

Line 361: fnd_msg_pub.add;

357: ROLLBACK TO create_bank;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
360: fnd_message.set_token('ERROR',SQLERRM);
361: fnd_msg_pub.add;
362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:

Line 362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
360: fnd_message.set_token('ERROR',SQLERRM);
361: fnd_msg_pub.add;
362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:
366: IF l_DEBUG in ('Y', 'C') THEN

Line 467: fnd_msg_pub.initialize;

463: END IF;
464:
465: -- initialize message list
466: IF fnd_api.to_boolean(p_init_msg_list) THEN
467: fnd_msg_pub.initialize;
468: END IF;
469:
470: -- initialize API return status to success.
471: x_return_status := fnd_api.g_ret_sts_success;

Line 563: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

559: RAISE fnd_api.g_exc_error;
560: END IF;
561:
562: -- get message count and if count is 1, get message info.
563: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
564: p_count => x_msg_count,
565: p_data => x_msg_data);
566:
567: IF l_DEBUG in ('Y', 'C') THEN

Line 575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

571: EXCEPTION
572: WHEN fnd_api.g_exc_error THEN
573: ROLLBACK TO update_bank;
574: x_return_status := fnd_api.g_ret_sts_error;
575: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
576: p_count => x_msg_count,
577: p_data => x_msg_data);
578:
579: IF l_DEBUG in ('Y', 'C') THEN

Line 586: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

582:
583: WHEN fnd_api.g_exc_unexpected_error THEN
584: ROLLBACK TO update_bank;
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
587: p_count => x_msg_count,
588: p_data => x_msg_data);
589:
590: IF l_DEBUG in ('Y', 'C') THEN

Line 599: fnd_msg_pub.add;

595: ROLLBACK TO update_bank;
596: x_return_status := fnd_api.g_ret_sts_unexp_error;
597: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
598: fnd_message.set_token('ERROR',SQLERRM);
599: fnd_msg_pub.add;
600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
601: p_count => x_msg_count,
602: p_data => x_msg_data);
603:

Line 600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

596: x_return_status := fnd_api.g_ret_sts_unexp_error;
597: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
598: fnd_message.set_token('ERROR',SQLERRM);
599: fnd_msg_pub.add;
600: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
601: p_count => x_msg_count,
602: p_data => x_msg_data);
603:
604: IF l_DEBUG in ('Y', 'C') THEN

Line 695: fnd_msg_pub.initialize;

691: END IF;
692:
693: -- initialize message list
694: IF fnd_api.to_boolean(p_init_msg_list) THEN
695: fnd_msg_pub.initialize;
696: END IF;
697:
698: -- initialize API return status to success.
699: x_return_status := fnd_api.g_ret_sts_success;

Line 713: fnd_msg_pub.add;

709: OPEN c_bank;
710: FETCH c_bank INTO l_bank_end;
711: IF c_bank%NOTFOUND THEN
712: fnd_message.set_name('CE', 'CE_API_NO_BANK');
713: fnd_msg_pub.add;
714: x_return_status := fnd_api.g_ret_sts_error;
715: CLOSE c_bank;
716: RAISE fnd_api.g_exc_error;
717: END IF;

Line 726: fnd_msg_pub.add;

722: OPEN c_branch(branch_id_rec.subject_id);
723: FETCH c_branch INTO l_branch_end, l_branch_ovn;
724: IF c_branch%NOTFOUND THEN
725: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
726: fnd_msg_pub.add;
727: x_return_status := fnd_api.g_ret_sts_error;
728: CLOSE c_branch;
729: RAISE fnd_api.g_exc_error;
730: END IF;

Line 758: fnd_msg_pub.add;

754: OPEN c_bank_ovn;
755: FETCH c_bank_ovn INTO l_bank_ovn;
756: IF c_bank_ovn%NOTFOUND THEN
757: fnd_message.set_name('CE', 'CE_API_NO_BANK');
758: fnd_msg_pub.add;
759: x_return_status := fnd_api.g_ret_sts_error;
760: CLOSE c_bank_ovn;
761: RAISE fnd_api.g_exc_error;
762: END IF;

Line 774: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

770: RAISE fnd_api.g_exc_error;
771: END IF;
772:
773: -- get message count and if count is 1, get message info.
774: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
775: p_count => x_msg_count,
776: p_data => x_msg_data);
777:
778: IF l_DEBUG in ('Y', 'C') THEN

Line 786: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

782: EXCEPTION
783: WHEN fnd_api.g_exc_error THEN
784: ROLLBACK TO set_bank_end_date;
785: x_return_status := fnd_api.g_ret_sts_error;
786: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
787: p_count => x_msg_count,
788: p_data => x_msg_data);
789:
790: IF l_DEBUG in ('Y', 'C') THEN

Line 797: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

793:
794: WHEN fnd_api.g_exc_unexpected_error THEN
795: ROLLBACK TO set_bank_end_date;
796: x_return_status := fnd_api.g_ret_sts_unexp_error;
797: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data);
800:
801: IF l_DEBUG in ('Y', 'C') THEN

Line 810: fnd_msg_pub.add;

806: ROLLBACK TO set_bank_end_date;
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
809: fnd_message.set_token('ERROR',SQLERRM);
810: fnd_msg_pub.add;
811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
812: p_count => x_msg_count,
813: p_data => x_msg_data);
814:

Line 811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
809: fnd_message.set_token('ERROR',SQLERRM);
810: fnd_msg_pub.add;
811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
812: p_count => x_msg_count,
813: p_data => x_msg_data);
814:
815: IF l_DEBUG in ('Y', 'C') THEN

Line 1037: fnd_msg_pub.initialize;

1033: END IF;
1034:
1035: -- initialize message list
1036: IF fnd_api.to_boolean(p_init_msg_list) THEN
1037: fnd_msg_pub.initialize;
1038: END IF;
1039:
1040: -- initialize API return status to success.
1041: x_return_status := fnd_api.g_ret_sts_success;

Line 1059: fnd_msg_pub.add;

1055: OPEN c_bank;
1056: FETCH c_bank INTO l_bank_name, l_bank_number;
1057: IF c_bank%NOTFOUND THEN
1058: fnd_message.set_name('CE', 'CE_API_NO_BANK');
1059: fnd_msg_pub.add;
1060: x_return_status := fnd_api.g_ret_sts_error;
1061: RAISE fnd_api.g_exc_error;
1062: END IF;
1063: CLOSE c_bank;

Line 1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1192: END IF;
1193: END IF;
1194:
1195: -- get message count and if count is 1, get message info.
1196: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: IF l_DEBUG in ('Y', 'C') THEN

Line 1208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1204: EXCEPTION
1205: WHEN fnd_api.g_exc_error THEN
1206: ROLLBACK TO create_bank_branch;
1207: x_return_status := fnd_api.g_ret_sts_error;
1208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1209: p_count => x_msg_count,
1210: p_data => x_msg_data);
1211:
1212: IF l_DEBUG in ('Y', 'C') THEN

Line 1219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1215:
1216: WHEN fnd_api.g_exc_unexpected_error THEN
1217: ROLLBACK TO create_bank_branch;
1218: x_return_status := fnd_api.g_ret_sts_unexp_error;
1219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1220: p_count => x_msg_count,
1221: p_data => x_msg_data);
1222:
1223: IF l_DEBUG in ('Y', 'C') THEN

Line 1232: fnd_msg_pub.add;

1228: ROLLBACK TO create_bank_branch;
1229: x_return_status := fnd_api.g_ret_sts_unexp_error;
1230: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1231: fnd_message.set_token('ERROR',SQLERRM);
1232: fnd_msg_pub.add;
1233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1234: p_count => x_msg_count,
1235: p_data => x_msg_data);
1236:

Line 1233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1229: x_return_status := fnd_api.g_ret_sts_unexp_error;
1230: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1231: fnd_message.set_token('ERROR',SQLERRM);
1232: fnd_msg_pub.add;
1233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1234: p_count => x_msg_count,
1235: p_data => x_msg_data);
1236:
1237: IF l_DEBUG in ('Y', 'C') THEN

Line 1364: fnd_msg_pub.initialize;

1360: END IF;
1361:
1362: -- initialize message list
1363: IF fnd_api.to_boolean(p_init_msg_list) THEN
1364: fnd_msg_pub.initialize;
1365: END IF;
1366:
1367: -- initialize API return status to success.
1368: x_return_status := fnd_api.g_ret_sts_success;

Line 1519: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1515: RAISE fnd_api.g_exc_error;
1516: END IF;
1517:
1518: -- get message count and if count is 1, get message info.
1519: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1520: p_count => x_msg_count,
1521: p_data => x_msg_data);
1522:
1523: IF l_DEBUG in ('Y', 'C') THEN

Line 1531: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1527: EXCEPTION
1528: WHEN fnd_api.g_exc_error THEN
1529: ROLLBACK TO update_bank_branch;
1530: x_return_status := fnd_api.g_ret_sts_error;
1531: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1532: p_count => x_msg_count,
1533: p_data => x_msg_data);
1534:
1535: IF l_DEBUG in ('Y', 'C') THEN

Line 1542: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1538:
1539: WHEN fnd_api.g_exc_unexpected_error THEN
1540: ROLLBACK TO update_bank_branch;
1541: x_return_status := fnd_api.g_ret_sts_unexp_error;
1542: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: IF l_DEBUG in ('Y', 'C') THEN

Line 1555: fnd_msg_pub.add;

1551: ROLLBACK TO update_bank_branch;
1552: x_return_status := fnd_api.g_ret_sts_unexp_error;
1553: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1554: fnd_message.set_token('ERROR',SQLERRM);
1555: fnd_msg_pub.add;
1556: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559:

Line 1556: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1552: x_return_status := fnd_api.g_ret_sts_unexp_error;
1553: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1554: fnd_message.set_token('ERROR',SQLERRM);
1555: fnd_msg_pub.add;
1556: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559:
1560: IF l_DEBUG in ('Y', 'C') THEN

Line 1685: fnd_msg_pub.initialize;

1681: END IF;
1682:
1683: -- initialize message list
1684: IF fnd_api.to_boolean(p_init_msg_list) THEN
1685: fnd_msg_pub.initialize;
1686: END IF;
1687:
1688: -- initialize API return status to success.
1689: x_return_status := fnd_api.g_ret_sts_success;

Line 1706: fnd_msg_pub.add;

1702: OPEN c_branch_end;
1703: FETCH c_branch_end INTO l_branch_end;
1704: IF c_branch_end%NOTFOUND THEN
1705: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
1706: fnd_msg_pub.add;
1707: x_return_status := fnd_api.g_ret_sts_error;
1708: RAISE fnd_api.g_exc_error;
1709: END IF;
1710: CLOSE c_branch_end;

Line 1717: fnd_msg_pub.add;

1713: OPEN c_bank_id;
1714: FETCH c_bank_id INTO l_bank_id;
1715: IF c_bank_id%NOTFOUND THEN
1716: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
1717: fnd_msg_pub.add;
1718: x_return_status := fnd_api.g_ret_sts_error;
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721: CLOSE c_bank_id;

Line 1728: fnd_msg_pub.add;

1724: OPEN c_bank (l_bank_id);
1725: FETCH c_bank INTO l_bank_end, l_bank_ovn;
1726: IF c_bank%NOTFOUND THEN
1727: fnd_message.set_name('CE', 'CE_API_NO_BANK');
1728: fnd_msg_pub.add;
1729: x_return_status := fnd_api.g_ret_sts_error;
1730: RAISE fnd_api.g_exc_error;
1731: END IF;
1732: CLOSE c_bank;

Line 1818: fnd_msg_pub.add;

1814: OPEN c_branch_party_ovn;
1815: FETCH c_branch_party_ovn INTO l_branch_party_ovn;
1816: IF c_branch_party_ovn%NOTFOUND THEN
1817: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
1818: fnd_msg_pub.add;
1819: x_return_status := fnd_api.g_ret_sts_error;
1820: CLOSE c_branch_party_ovn;
1821: RAISE fnd_api.g_exc_error;
1822: END IF;

Line 1852: fnd_msg_pub.count_and_get(

1848: RAISE fnd_api.g_exc_error;
1849: END IF;
1850:
1851: -- get message count and if count is 1, get message info.
1852: fnd_msg_pub.count_and_get(
1853: p_encoded => fnd_api.g_false,
1854: p_count => x_msg_count,
1855: p_data => x_msg_data);
1856:

Line 1865: fnd_msg_pub.count_and_get(

1861: EXCEPTION
1862: WHEN fnd_api.g_exc_error THEN
1863: ROLLBACK TO set_bank_branch_end_date;
1864: x_return_status := fnd_api.g_ret_sts_error;
1865: fnd_msg_pub.count_and_get(
1866: p_encoded => fnd_api.g_false,
1867: p_count => x_msg_count,
1868: p_data => x_msg_data);
1869:

Line 1877: fnd_msg_pub.count_and_get(

1873:
1874: WHEN fnd_api.g_exc_unexpected_error THEN
1875: ROLLBACK TO set_bank_branch_end_date;
1876: x_return_status := fnd_api.g_ret_sts_unexp_error;
1877: fnd_msg_pub.count_and_get(
1878: p_encoded => fnd_api.g_false,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881:

Line 1891: fnd_msg_pub.add;

1887: ROLLBACK TO set_bank_branch_end_date;
1888: x_return_status := fnd_api.g_ret_sts_unexp_error;
1889: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1890: fnd_message.set_token('ERROR',SQLERRM);
1891: fnd_msg_pub.add;
1892: fnd_msg_pub.count_and_get(
1893: p_encoded => fnd_api.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);

Line 1892: fnd_msg_pub.count_and_get(

1888: x_return_status := fnd_api.g_ret_sts_unexp_error;
1889: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1890: fnd_message.set_token('ERROR',SQLERRM);
1891: fnd_msg_pub.add;
1892: fnd_msg_pub.count_and_get(
1893: p_encoded => fnd_api.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:

Line 2101: fnd_msg_pub.initialize;

2097: END IF;
2098:
2099: -- initialize message list
2100: IF fnd_api.to_boolean(p_init_msg_list) THEN
2101: fnd_msg_pub.initialize;
2102: END IF;
2103:
2104: -- initialize API return status to success.
2105: x_return_status := fnd_api.g_ret_sts_success;

Line 2175: fnd_msg_pub.add;

2171: OPEN c_branch;
2172: FETCH c_branch INTO l_branch_number;
2173: IF c_branch%NOTFOUND THEN
2174: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
2175: fnd_msg_pub.add;
2176: x_return_status := fnd_api.g_ret_sts_error;
2177: RAISE fnd_api.g_exc_error;
2178: END IF;
2179: CLOSE c_branch;

Line 2499: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2495: end if;
2496: -- Bug 14350260 End
2497:
2498: -- get message count and if count is 1, get message info.
2499: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2500: p_count => x_msg_count,
2501: p_data => x_msg_data);
2502:
2503: IF l_DEBUG in ('Y', 'C') THEN

Line 2511: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2507: EXCEPTION
2508: WHEN fnd_api.g_exc_error THEN
2509: ROLLBACK TO create_bank_acct;
2510: x_return_status := fnd_api.g_ret_sts_error;
2511: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2512: p_count => x_msg_count,
2513: p_data => x_msg_data);
2514:
2515: IF l_DEBUG in ('Y', 'C') THEN

Line 2522: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2518:
2519: WHEN fnd_api.g_exc_unexpected_error THEN
2520: ROLLBACK TO create_bank_acct;
2521: x_return_status := fnd_api.g_ret_sts_unexp_error;
2522: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2523: p_count => x_msg_count,
2524: p_data => x_msg_data);
2525:
2526: IF l_DEBUG in ('Y', 'C') THEN

Line 2535: fnd_msg_pub.add;

2531: ROLLBACK TO create_bank_acct;
2532: x_return_status := fnd_api.g_ret_sts_unexp_error;
2533: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2534: fnd_message.set_token('ERROR',SQLERRM);
2535: fnd_msg_pub.add;
2536: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data);
2539:

Line 2536: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2532: x_return_status := fnd_api.g_ret_sts_unexp_error;
2533: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2534: fnd_message.set_token('ERROR',SQLERRM);
2535: fnd_msg_pub.add;
2536: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2537: p_count => x_msg_count,
2538: p_data => x_msg_data);
2539:
2540: IF l_DEBUG in ('Y', 'C') THEN

Line 2677: fnd_msg_pub.initialize;

2673: END IF;
2674:
2675: -- initialize message list
2676: IF fnd_api.to_boolean(p_init_msg_list) THEN
2677: fnd_msg_pub.initialize;
2678: END IF;
2679:
2680: -- initialize API return status to success.
2681: x_return_status := fnd_api.g_ret_sts_success;

Line 2696: fnd_msg_pub.add;

2692: OPEN c_bank_account;
2693: FETCH c_bank_account INTO l_bank_acct_rec_master;
2694: IF c_bank_account%NOTFOUND THEN
2695: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2696: fnd_msg_pub.add;
2697: x_return_status := fnd_api.g_ret_sts_error;
2698: CLOSE c_bank_account;
2699: RAISE fnd_api.g_exc_error;
2700: END IF;

Line 2753: fnd_msg_pub.add;

2749:
2750: -- Validate Multi-Currency Allowed or not bug 8407297
2751: if l_currency_code <> l_bank_acct_rec_master.currency_code then
2752: fnd_message.set_name('CE', 'CE_BANK_MULTICURRENCY');
2753: fnd_msg_pub.add;
2754: x_return_status := fnd_api.g_ret_sts_error;
2755: RAISE fnd_api.g_exc_error;
2756: end if;
2757: end if;

Line 2777: fnd_msg_pub.add;

2773: OPEN c_branch_id;
2774: FETCH c_branch_id INTO l_branch_id;
2775: IF c_branch_id%NOTFOUND THEN
2776: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2777: fnd_msg_pub.add;
2778: x_return_status := fnd_api.g_ret_sts_error;
2779: CLOSE c_branch_id;
2780: RAISE fnd_api.g_exc_error;
2781: END IF;

Line 2830: fnd_msg_pub.add;

2826: OPEN c_branch_num(l_branch_id);
2827: FETCH c_branch_num INTO l_branch_number;
2828: IF c_branch_num%NOTFOUND THEN
2829: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
2830: fnd_msg_pub.add;
2831: x_return_status := fnd_api.g_ret_sts_error;
2832: CLOSE c_branch_num;
2833: RAISE fnd_api.g_exc_error;
2834: END IF;

Line 2886: fnd_msg_pub.add;

2882: OPEN c_ovn;
2883: FETCH c_ovn INTO l_old_ovn;
2884: IF c_ovn%NOTFOUND THEN
2885: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2886: fnd_msg_pub.add;
2887: x_return_status := fnd_api.g_ret_sts_error;
2888: CLOSE c_ovn;
2889: RAISE fnd_api.g_exc_error;
2890: END IF;

Line 2896: fnd_msg_pub.add;

2892:
2893: IF l_old_ovn > p_object_version_number THEN
2894: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
2895: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');
2896: fnd_msg_pub.add;
2897: x_return_status := fnd_api.g_ret_sts_error;
2898: RAISE fnd_api.g_exc_error;
2899: END IF;
2900:

Line 2991: fnd_msg_pub.add;

2987: xtr_bank_account_reference = p_acct_rec.xtr_bank_account_reference
2988: WHERE bank_account_id = p_acct_rec.bank_account_id;
2989: IF (SQL%NOTFOUND) THEN
2990: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2991: fnd_msg_pub.add;
2992: x_return_status := fnd_api.g_ret_sts_error;
2993: RAISE fnd_api.g_exc_error;
2994: END IF;
2995: p_object_version_number := l_old_ovn + 1;

Line 2998: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2994: END IF;
2995: p_object_version_number := l_old_ovn + 1;
2996:
2997: -- get message count and if count is 1, get message info.
2998: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2999: p_count => x_msg_count,
3000: p_data => x_msg_data);
3001:
3002: IF l_DEBUG in ('Y', 'C') THEN

Line 3010: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3006: EXCEPTION
3007: WHEN fnd_api.g_exc_error THEN
3008: ROLLBACK TO update_bank_acct;
3009: x_return_status := fnd_api.g_ret_sts_error;
3010: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3011: p_count => x_msg_count,
3012: p_data => x_msg_data);
3013:
3014: IF l_DEBUG in ('Y', 'C') THEN

Line 3021: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3017:
3018: WHEN fnd_api.g_exc_unexpected_error THEN
3019: ROLLBACK TO update_bank_acct;
3020: x_return_status := fnd_api.g_ret_sts_unexp_error;
3021: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3022: p_count => x_msg_count,
3023: p_data => x_msg_data);
3024:
3025: IF l_DEBUG in ('Y', 'C') THEN

Line 3034: fnd_msg_pub.add;

3030: ROLLBACK TO udpate_bank_acct;
3031: x_return_status := fnd_api.g_ret_sts_unexp_error;
3032: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3033: fnd_message.set_token('ERROR',SQLERRM);
3034: fnd_msg_pub.add;
3035: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3036: p_count => x_msg_count,
3037: p_data => x_msg_data);
3038:

Line 3035: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3031: x_return_status := fnd_api.g_ret_sts_unexp_error;
3032: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3033: fnd_message.set_token('ERROR',SQLERRM);
3034: fnd_msg_pub.add;
3035: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3036: p_count => x_msg_count,
3037: p_data => x_msg_data);
3038:
3039: IF l_DEBUG in ('Y', 'C') THEN

Line 3078: fnd_msg_pub.initialize;

3074: END IF;
3075:
3076: -- initialize message list
3077: IF fnd_api.to_boolean(p_init_msg_list) THEN
3078: fnd_msg_pub.initialize;
3079: END IF;
3080:
3081: -- initialize API return status to success.
3082: x_return_status := fnd_api.g_ret_sts_success;

Line 3099: fnd_msg_pub.add;

3095: IF ((p_acct_use_rec.ap_use_enable_flag = 'Y' or
3096: p_acct_use_rec.ar_use_enable_flag = 'Y') and
3097: p_acct_use_rec.asset_code_combination_id is null) THEN -- bug 7671686
3098: fnd_message.set_name('CE', 'CE_API_CASH_CCID_REQUIRED');
3099: fnd_msg_pub.add;
3100: x_return_status := fnd_api.g_ret_sts_error;
3101: RAISE fnd_api.g_exc_error;
3102: END IF;
3103:

Line 3344: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3340: End If;
3341: CLOSE c_gl_ccid_rowid;
3342:
3343: -- get message count and if count is 1, get message info.
3344: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3345: p_count => x_msg_count,
3346: p_data => x_msg_data);
3347:
3348: IF l_DEBUG in ('Y', 'C') THEN

Line 3356: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3352: EXCEPTION
3353: WHEN fnd_api.g_exc_error THEN
3354: ROLLBACK TO create_bank_acct_use;
3355: x_return_status := fnd_api.g_ret_sts_error;
3356: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3357: p_count => x_msg_count,
3358: p_data => x_msg_data);
3359:
3360: IF l_DEBUG in ('Y', 'C') THEN

Line 3367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3363:
3364: WHEN fnd_api.g_exc_unexpected_error THEN
3365: ROLLBACK TO create_bank_acct_use;
3366: x_return_status := fnd_api.g_ret_sts_unexp_error;
3367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3368: p_count => x_msg_count,
3369: p_data => x_msg_data);
3370:
3371: IF l_DEBUG in ('Y', 'C') THEN

Line 3380: fnd_msg_pub.add;

3376: ROLLBACK TO create_bank_acct_use;
3377: x_return_status := fnd_api.g_ret_sts_unexp_error;
3378: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3379: fnd_message.set_token('ERROR',SQLERRM);
3380: fnd_msg_pub.add;
3381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3382: p_count => x_msg_count,
3383: p_data => x_msg_data);
3384:

Line 3381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3377: x_return_status := fnd_api.g_ret_sts_unexp_error;
3378: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3379: fnd_message.set_token('ERROR',SQLERRM);
3380: fnd_msg_pub.add;
3381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3382: p_count => x_msg_count,
3383: p_data => x_msg_data);
3384:
3385: IF l_DEBUG in ('Y', 'C') THEN

Line 3435: fnd_msg_pub.initialize;

3431: END IF;
3432:
3433: -- initialize message list
3434: IF fnd_api.to_boolean(p_init_msg_list) THEN
3435: fnd_msg_pub.initialize;
3436: END IF;
3437:
3438: -- initialize API return status to success.
3439: x_return_status := fnd_api.g_ret_sts_success;

Line 3447: fnd_msg_pub.add;

3443: OPEN c_acct_org;
3444: FETCH c_acct_org INTO l_acct_id, l_org_id, l_le_id;
3445: IF c_acct_org%NOTFOUND THEN
3446: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');
3447: fnd_msg_pub.add;
3448: x_return_status := fnd_api.g_ret_sts_error;
3449: CLOSE c_acct_org;
3450: RAISE fnd_api.g_exc_error;
3451: END IF;

Line 3473: fnd_msg_pub.add;

3469: IF ((p_acct_use_rec.ap_use_enable_flag = 'Y' or
3470: p_acct_use_rec.ar_use_enable_flag = 'Y') and
3471: p_acct_use_rec.asset_code_combination_id is null) THEN -- bug 7671686
3472: fnd_message.set_name('CE', 'CE_API_CASH_CCID_REQUIRED');
3473: fnd_msg_pub.add;
3474: x_return_status := fnd_api.g_ret_sts_error;
3475: RAISE fnd_api.g_exc_error;
3476: END IF;
3477:

Line 3526: fnd_msg_pub.add;

3522: OPEN c_use_ovn;
3523: FETCH c_use_ovn INTO l_old_use_ovn;
3524: IF c_use_ovn%NOTFOUND THEN
3525: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');
3526: fnd_msg_pub.add;
3527: x_return_status := fnd_api.g_ret_sts_error;
3528: CLOSE c_use_ovn;
3529: RAISE fnd_api.g_exc_error;
3530: END IF;

Line 3536: fnd_msg_pub.add;

3532:
3533: IF l_old_use_ovn > p_use_ovn THEN
3534: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3535: fnd_message.set_token('TABLE', 'CE_BANK_ACCT_USES_ALL');
3536: fnd_msg_pub.add;
3537: x_return_status := fnd_api.g_ret_sts_error;
3538: RAISE fnd_api.g_exc_error;
3539: END IF;
3540:

Line 3549: fnd_msg_pub.add;

3545:
3546: IF l_old_ccid_ovn is not null AND l_old_ccid_ovn > p_ccid_ovn THEN
3547: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3548: fnd_message.set_token('TABLE', 'CE_GL_ACCOUNTS_CCID');
3549: fnd_msg_pub.add;
3550: x_return_status := fnd_api.g_ret_sts_error;
3551: RAISE fnd_api.g_exc_error;
3552: END IF;
3553:

Line 3598: fnd_msg_pub.add;

3594: object_version_number = l_old_use_ovn + 1
3595: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3596: IF (SQL%NOTFOUND) THEN
3597: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');
3598: fnd_msg_pub.add;
3599: x_return_status := fnd_api.g_ret_sts_error;
3600: RAISE fnd_api.g_exc_error;
3601: END IF;
3602: p_use_ovn := l_old_use_ovn + 1;

Line 3639: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3635: p_ccid_ovn := l_old_ccid_ovn + 1;
3636: END IF;
3637:
3638: -- get message count and if count is 1, get message info.
3639: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3640: p_count => x_msg_count,
3641: p_data => x_msg_data);
3642:
3643: IF l_DEBUG in ('Y', 'C') THEN

Line 3651: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3647: EXCEPTION
3648: WHEN fnd_api.g_exc_error THEN
3649: ROLLBACK TO update_bank_acct_use;
3650: x_return_status := fnd_api.g_ret_sts_error;
3651: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3652: p_count => x_msg_count,
3653: p_data => x_msg_data);
3654:
3655: IF l_DEBUG in ('Y', 'C') THEN

Line 3662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3658:
3659: WHEN fnd_api.g_exc_unexpected_error THEN
3660: ROLLBACK TO update_bank_acct_use;
3661: x_return_status := fnd_api.g_ret_sts_unexp_error;
3662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3663: p_count => x_msg_count,
3664: p_data => x_msg_data);
3665:
3666: IF l_DEBUG in ('Y', 'C') THEN

Line 3675: fnd_msg_pub.add;

3671: ROLLBACK TO udpate_bank_acct_use;
3672: x_return_status := fnd_api.g_ret_sts_unexp_error;
3673: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3674: fnd_message.set_token('ERROR',SQLERRM);
3675: fnd_msg_pub.add;
3676: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3677: p_count => x_msg_count,
3678: p_data => x_msg_data);
3679:

Line 3676: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3672: x_return_status := fnd_api.g_ret_sts_unexp_error;
3673: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3674: fnd_message.set_token('ERROR',SQLERRM);
3675: fnd_msg_pub.add;
3676: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3677: p_count => x_msg_count,
3678: p_data => x_msg_data);
3679:
3680: IF l_DEBUG in ('Y', 'C') THEN

Line 3737: fnd_msg_pub.initialize;

3733: END IF;
3734:
3735: -- initialize message list
3736: IF fnd_api.to_boolean(p_init_msg_list) THEN
3737: fnd_msg_pub.initialize;
3738: END IF;
3739:
3740: -- initialize API return status to success.
3741: x_return_status := fnd_api.g_ret_sts_success;

Line 3756: fnd_msg_pub.add;

3752: WHERE bank_account_id = p_bank_acct_id;
3753: EXCEPTION
3754: WHEN NO_DATA_FOUND THEN
3755: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
3756: fnd_msg_pub.add;
3757: x_return_status := fnd_api.g_ret_sts_error;
3758: RAISE fnd_api.g_exc_error;
3759: END;
3760:

Line 3764: fnd_msg_pub.add;

3760:
3761: IF l_old_ovn > p_object_version_number THEN
3762: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3763: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');
3764: fnd_msg_pub.add;
3765: x_return_status := fnd_api.g_ret_sts_error;
3766: RAISE fnd_api.g_exc_error;
3767: END IF;
3768:

Line 3778: fnd_msg_pub.add;

3774:
3775: -- check to see row udpated
3776: IF (SQL%NOTFOUND) THEN
3777: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
3778: fnd_msg_pub.add;
3779: x_return_status := fnd_api.g_ret_sts_error;
3780: RAISE fnd_api.g_exc_error;
3781: END IF;
3782:

Line 3785: fnd_msg_pub.count_and_get(

3781: END IF;
3782:
3783: p_object_version_number := l_old_ovn + 1;
3784: -- get message count and if count is 1, get message info.
3785: fnd_msg_pub.count_and_get(
3786: p_encoded => fnd_api.g_false,
3787: p_count => x_msg_count,
3788: p_data => x_msg_data);
3789:

Line 3798: fnd_msg_pub.count_and_get(

3794: EXCEPTION
3795: WHEN fnd_api.g_exc_error THEN
3796: ROLLBACK TO set_bank_acct_end_date;
3797: x_return_status := fnd_api.g_ret_sts_error;
3798: fnd_msg_pub.count_and_get(
3799: p_encoded => fnd_api.g_false,
3800: p_count => x_msg_count,
3801: p_data => x_msg_data);
3802:

Line 3810: fnd_msg_pub.count_and_get(

3806:
3807: WHEN fnd_api.g_exc_unexpected_error THEN
3808: ROLLBACK TO set_bank_acct_end_date;
3809: x_return_status := fnd_api.g_ret_sts_unexp_error;
3810: fnd_msg_pub.count_and_get(
3811: p_encoded => fnd_api.g_false,
3812: p_count => x_msg_count,
3813: p_data => x_msg_data);
3814:

Line 3824: fnd_msg_pub.add;

3820: ROLLBACK TO set_bank_acct_end_date;
3821: x_return_status := fnd_api.g_ret_sts_unexp_error;
3822: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3823: fnd_message.set_token('ERROR',SQLERRM);
3824: fnd_msg_pub.add;
3825: fnd_msg_pub.count_and_get(
3826: p_encoded => fnd_api.g_false,
3827: p_count => x_msg_count,
3828: p_data => x_msg_data);

Line 3825: fnd_msg_pub.count_and_get(

3821: x_return_status := fnd_api.g_ret_sts_unexp_error;
3822: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3823: fnd_message.set_token('ERROR',SQLERRM);
3824: fnd_msg_pub.add;
3825: fnd_msg_pub.count_and_get(
3826: p_encoded => fnd_api.g_false,
3827: p_count => x_msg_count,
3828: p_data => x_msg_data);
3829: