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 38: fnd_msg_pub.add;

34: OPEN c_country;
35: FETCH c_country INTO l_country;
36: IF c_country%NOTFOUND THEN
37: fnd_message.set_name('CE', 'CE_API_NO_BANK');
38: fnd_msg_pub.add;
39: x_return_status := fnd_api.g_ret_sts_error;
40: END IF;
41: CLOSE c_country;
42:

Line 108: fnd_msg_pub.add;

104: OPEN c_bank;
105: FETCH c_bank INTO x_bank_id, x_country_code, x_bank_name, x_bank_number;
106: IF c_bank%NOTFOUND THEN
107: fnd_message.set_name('CE', 'CE_API_NO_BANK');
108: fnd_msg_pub.add;
109: x_return_status := fnd_api.g_ret_sts_error;
110: END IF;
111: CLOSE c_bank;
112:

Line 207: fnd_msg_pub.initialize;

203: END IF;
204:
205: -- initialize message list
206: IF fnd_api.to_boolean(p_init_msg_list) THEN
207: fnd_msg_pub.initialize;
208: END IF;
209:
210: -- initialize API return status to success.
211: x_return_status := fnd_api.g_ret_sts_success;

Line 217: fnd_msg_pub.add;

213: -- first check all required params
214: IF (p_country_code IS NULL or
215: p_bank_name IS NULL) THEN
216: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
217: fnd_msg_pub.add;
218: x_return_status := fnd_api.g_ret_sts_error;
219: RAISE fnd_api.g_exc_error;
220: END IF;
221:

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

295: RAISE fnd_api.g_exc_error;
296: END IF;
297:
298: -- get message count and if count is 1, get message info.
299: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data);
302:
303: IF l_DEBUG in ('Y', 'C') THEN

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

307: EXCEPTION
308: WHEN fnd_api.g_exc_error THEN
309: ROLLBACK TO create_bank;
310: x_return_status := fnd_api.g_ret_sts_error;
311: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
312: p_count => x_msg_count,
313: p_data => x_msg_data);
314:
315: IF l_DEBUG in ('Y', 'C') THEN

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

318:
319: WHEN fnd_api.g_exc_unexpected_error THEN
320: ROLLBACK TO create_bank;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325:
326: IF l_DEBUG in ('Y', 'C') THEN

Line 335: fnd_msg_pub.add;

331: ROLLBACK TO create_bank;
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
334: fnd_message.set_token('ERROR',SQLERRM);
335: fnd_msg_pub.add;
336: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
337: p_count => x_msg_count,
338: p_data => x_msg_data);
339:

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

332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
334: fnd_message.set_token('ERROR',SQLERRM);
335: fnd_msg_pub.add;
336: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
337: p_count => x_msg_count,
338: p_data => x_msg_data);
339:
340: IF l_DEBUG in ('Y', 'C') THEN

Line 437: fnd_msg_pub.initialize;

433: END IF;
434:
435: -- initialize message list
436: IF fnd_api.to_boolean(p_init_msg_list) THEN
437: fnd_msg_pub.initialize;
438: END IF;
439:
440: -- initialize API return status to success.
441: x_return_status := fnd_api.g_ret_sts_success;

Line 447: fnd_msg_pub.add;

443: -- first check all required params
444: IF (p_bank_id IS NULL or
445: p_bank_name IS NULL) THEN
446: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
447: fnd_msg_pub.add;
448: x_return_status := fnd_api.g_ret_sts_error;
449: RAISE fnd_api.g_exc_error;
450: END IF;
451:

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

531: RAISE fnd_api.g_exc_error;
532: END IF;
533:
534: -- get message count and if count is 1, get message info.
535: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: IF l_DEBUG in ('Y', 'C') THEN

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

543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN
545: ROLLBACK TO update_bank;
546: x_return_status := fnd_api.g_ret_sts_error;
547: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: IF l_DEBUG in ('Y', 'C') THEN

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

554:
555: WHEN fnd_api.g_exc_unexpected_error THEN
556: ROLLBACK TO update_bank;
557: x_return_status := fnd_api.g_ret_sts_unexp_error;
558: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
559: p_count => x_msg_count,
560: p_data => x_msg_data);
561:
562: IF l_DEBUG in ('Y', 'C') THEN

Line 571: fnd_msg_pub.add;

567: ROLLBACK TO update_bank;
568: x_return_status := fnd_api.g_ret_sts_unexp_error;
569: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
570: fnd_message.set_token('ERROR',SQLERRM);
571: fnd_msg_pub.add;
572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
573: p_count => x_msg_count,
574: p_data => x_msg_data);
575:

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

568: x_return_status := fnd_api.g_ret_sts_unexp_error;
569: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
570: fnd_message.set_token('ERROR',SQLERRM);
571: fnd_msg_pub.add;
572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
573: p_count => x_msg_count,
574: p_data => x_msg_data);
575:
576: IF l_DEBUG in ('Y', 'C') THEN

Line 667: fnd_msg_pub.initialize;

663: END IF;
664:
665: -- initialize message list
666: IF fnd_api.to_boolean(p_init_msg_list) THEN
667: fnd_msg_pub.initialize;
668: END IF;
669:
670: -- initialize API return status to success.
671: x_return_status := fnd_api.g_ret_sts_success;

Line 677: fnd_msg_pub.add;

673: -- first check all required params
674: IF (p_bank_id = null or
675: p_object_version_number = null) THEN
676: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
677: fnd_msg_pub.add;
678: x_return_status := fnd_api.g_ret_sts_error;
679: RAISE fnd_api.g_exc_error;
680: END IF;
681:

Line 689: fnd_msg_pub.add;

685: OPEN c_bank;
686: FETCH c_bank INTO l_bank_end;
687: IF c_bank%NOTFOUND THEN
688: fnd_message.set_name('CE', 'CE_API_NO_BANK');
689: fnd_msg_pub.add;
690: x_return_status := fnd_api.g_ret_sts_error;
691: CLOSE c_bank;
692: RAISE fnd_api.g_exc_error;
693: END IF;

Line 702: fnd_msg_pub.add;

698: OPEN c_branch(branch_id_rec.subject_id);
699: FETCH c_branch INTO l_branch_end, l_branch_ovn;
700: IF c_branch%NOTFOUND THEN
701: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
702: fnd_msg_pub.add;
703: x_return_status := fnd_api.g_ret_sts_error;
704: CLOSE c_branch;
705: RAISE fnd_api.g_exc_error;
706: END IF;

Line 734: fnd_msg_pub.add;

730: OPEN c_bank_ovn;
731: FETCH c_bank_ovn INTO l_bank_ovn;
732: IF c_bank_ovn%NOTFOUND THEN
733: fnd_message.set_name('CE', 'CE_API_NO_BANK');
734: fnd_msg_pub.add;
735: x_return_status := fnd_api.g_ret_sts_error;
736: CLOSE c_bank_ovn;
737: RAISE fnd_api.g_exc_error;
738: END IF;

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

746: RAISE fnd_api.g_exc_error;
747: END IF;
748:
749: -- get message count and if count is 1, get message info.
750: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
751: p_count => x_msg_count,
752: p_data => x_msg_data);
753:
754: IF l_DEBUG in ('Y', 'C') THEN

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

758: EXCEPTION
759: WHEN fnd_api.g_exc_error THEN
760: ROLLBACK TO set_bank_end_date;
761: x_return_status := fnd_api.g_ret_sts_error;
762: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
763: p_count => x_msg_count,
764: p_data => x_msg_data);
765:
766: IF l_DEBUG in ('Y', 'C') THEN

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

769:
770: WHEN fnd_api.g_exc_unexpected_error THEN
771: ROLLBACK TO set_bank_end_date;
772: x_return_status := fnd_api.g_ret_sts_unexp_error;
773: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
774: p_count => x_msg_count,
775: p_data => x_msg_data);
776:
777: IF l_DEBUG in ('Y', 'C') THEN

Line 786: fnd_msg_pub.add;

782: ROLLBACK TO set_bank_end_date;
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
785: fnd_message.set_token('ERROR',SQLERRM);
786: fnd_msg_pub.add;
787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790:

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

783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
785: fnd_message.set_token('ERROR',SQLERRM);
786: fnd_msg_pub.add;
787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790:
791: IF l_DEBUG in ('Y', 'C') THEN

Line 1009: fnd_msg_pub.initialize;

1005: END IF;
1006:
1007: -- initialize message list
1008: IF fnd_api.to_boolean(p_init_msg_list) THEN
1009: fnd_msg_pub.initialize;
1010: END IF;
1011:
1012: -- initialize API return status to success.
1013: x_return_status := fnd_api.g_ret_sts_success;

Line 1019: fnd_msg_pub.add;

1015: -- first check all required params
1016: IF (p_bank_id IS NULL or
1017: p_branch_name IS NULL) THEN
1018: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
1019: fnd_msg_pub.add;
1020: x_return_status := fnd_api.g_ret_sts_error;
1021: RAISE fnd_api.g_exc_error;
1022: END IF;
1023:

Line 1035: fnd_msg_pub.add;

1031: OPEN c_bank;
1032: FETCH c_bank INTO l_bank_name, l_bank_number;
1033: IF c_bank%NOTFOUND THEN
1034: fnd_message.set_name('CE', 'CE_API_NO_BANK');
1035: fnd_msg_pub.add;
1036: x_return_status := fnd_api.g_ret_sts_error;
1037: RAISE fnd_api.g_exc_error;
1038: END IF;
1039: CLOSE c_bank;

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

1139: END IF;
1140: END IF;
1141:
1142: -- get message count and if count is 1, get message info.
1143: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data);
1146:
1147: IF l_DEBUG in ('Y', 'C') THEN

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

1151: EXCEPTION
1152: WHEN fnd_api.g_exc_error THEN
1153: ROLLBACK TO create_bank_branch;
1154: x_return_status := fnd_api.g_ret_sts_error;
1155: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1156: p_count => x_msg_count,
1157: p_data => x_msg_data);
1158:
1159: IF l_DEBUG in ('Y', 'C') THEN

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

1162:
1163: WHEN fnd_api.g_exc_unexpected_error THEN
1164: ROLLBACK TO create_bank_branch;
1165: x_return_status := fnd_api.g_ret_sts_unexp_error;
1166: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1167: p_count => x_msg_count,
1168: p_data => x_msg_data);
1169:
1170: IF l_DEBUG in ('Y', 'C') THEN

Line 1179: fnd_msg_pub.add;

1175: ROLLBACK TO create_bank_branch;
1176: x_return_status := fnd_api.g_ret_sts_unexp_error;
1177: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1178: fnd_message.set_token('ERROR',SQLERRM);
1179: fnd_msg_pub.add;
1180: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1181: p_count => x_msg_count,
1182: p_data => x_msg_data);
1183:

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

1176: x_return_status := fnd_api.g_ret_sts_unexp_error;
1177: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1178: fnd_message.set_token('ERROR',SQLERRM);
1179: fnd_msg_pub.add;
1180: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1181: p_count => x_msg_count,
1182: p_data => x_msg_data);
1183:
1184: IF l_DEBUG in ('Y', 'C') THEN

Line 1307: fnd_msg_pub.initialize;

1303: END IF;
1304:
1305: -- initialize message list
1306: IF fnd_api.to_boolean(p_init_msg_list) THEN
1307: fnd_msg_pub.initialize;
1308: END IF;
1309:
1310: -- initialize API return status to success.
1311: x_return_status := fnd_api.g_ret_sts_success;

Line 1317: fnd_msg_pub.add;

1313: -- first check all required params
1314: IF (p_branch_id IS NULL or
1315: p_branch_name IS NULL ) THEN
1316: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
1317: fnd_msg_pub.add;
1318: x_return_status := fnd_api.g_ret_sts_error;
1319: RAISE fnd_api.g_exc_error;
1320: END IF;
1321:

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

1432: RAISE fnd_api.g_exc_error;
1433: END IF;
1434:
1435: -- get message count and if count is 1, get message info.
1436: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1437: p_count => x_msg_count,
1438: p_data => x_msg_data);
1439:
1440: IF l_DEBUG in ('Y', 'C') THEN

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

1444: EXCEPTION
1445: WHEN fnd_api.g_exc_error THEN
1446: ROLLBACK TO update_bank_branch;
1447: x_return_status := fnd_api.g_ret_sts_error;
1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1449: p_count => x_msg_count,
1450: p_data => x_msg_data);
1451:
1452: IF l_DEBUG in ('Y', 'C') THEN

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

1455:
1456: WHEN fnd_api.g_exc_unexpected_error THEN
1457: ROLLBACK TO update_bank_branch;
1458: x_return_status := fnd_api.g_ret_sts_unexp_error;
1459: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1460: p_count => x_msg_count,
1461: p_data => x_msg_data);
1462:
1463: IF l_DEBUG in ('Y', 'C') THEN

Line 1472: fnd_msg_pub.add;

1468: ROLLBACK TO update_bank_branch;
1469: x_return_status := fnd_api.g_ret_sts_unexp_error;
1470: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1471: fnd_message.set_token('ERROR',SQLERRM);
1472: fnd_msg_pub.add;
1473: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476:

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

1469: x_return_status := fnd_api.g_ret_sts_unexp_error;
1470: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1471: fnd_message.set_token('ERROR',SQLERRM);
1472: fnd_msg_pub.add;
1473: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476:
1477: IF l_DEBUG in ('Y', 'C') THEN

Line 1586: fnd_msg_pub.initialize;

1582: END IF;
1583:
1584: -- initialize message list
1585: IF fnd_api.to_boolean(p_init_msg_list) THEN
1586: fnd_msg_pub.initialize;
1587: END IF;
1588:
1589: -- initialize API return status to success.
1590: x_return_status := fnd_api.g_ret_sts_success;

Line 1596: fnd_msg_pub.add;

1592: -- first check all required params
1593: IF (p_branch_id = null or
1594: p_object_version_number = null) THEN
1595: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
1596: fnd_msg_pub.add;
1597: x_return_status := fnd_api.g_ret_sts_error;
1598: RAISE fnd_api.g_exc_error;
1599: END IF;
1600:

Line 1611: fnd_msg_pub.add;

1607: OPEN c_branch_end;
1608: FETCH c_branch_end INTO l_branch_end;
1609: IF c_branch_end%NOTFOUND THEN
1610: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
1611: fnd_msg_pub.add;
1612: x_return_status := fnd_api.g_ret_sts_error;
1613: RAISE fnd_api.g_exc_error;
1614: END IF;
1615: CLOSE c_branch_end;

Line 1622: fnd_msg_pub.add;

1618: OPEN c_bank_id;
1619: FETCH c_bank_id INTO l_bank_id;
1620: IF c_bank_id%NOTFOUND THEN
1621: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
1622: fnd_msg_pub.add;
1623: x_return_status := fnd_api.g_ret_sts_error;
1624: RAISE fnd_api.g_exc_error;
1625: END IF;
1626: CLOSE c_bank_id;

Line 1633: fnd_msg_pub.add;

1629: OPEN c_bank (l_bank_id);
1630: FETCH c_bank INTO l_bank_end, l_bank_ovn;
1631: IF c_bank%NOTFOUND THEN
1632: fnd_message.set_name('CE', 'CE_API_NO_BANK');
1633: fnd_msg_pub.add;
1634: x_return_status := fnd_api.g_ret_sts_error;
1635: RAISE fnd_api.g_exc_error;
1636: END IF;
1637: CLOSE c_bank;

Line 1690: fnd_msg_pub.add;

1686: OPEN c_branch_party_ovn;
1687: FETCH c_branch_party_ovn INTO l_branch_party_ovn;
1688: IF c_branch_party_ovn%NOTFOUND THEN
1689: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
1690: fnd_msg_pub.add;
1691: x_return_status := fnd_api.g_ret_sts_error;
1692: CLOSE c_branch_party_ovn;
1693: RAISE fnd_api.g_exc_error;
1694: END IF;

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

1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714:
1715: -- get message count and if count is 1, get message info.
1716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: IF l_DEBUG in ('Y', 'C') THEN

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

1724: EXCEPTION
1725: WHEN fnd_api.g_exc_error THEN
1726: ROLLBACK TO set_bank_branch_end_date;
1727: x_return_status := fnd_api.g_ret_sts_error;
1728: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:
1732: IF l_DEBUG in ('Y', 'C') THEN

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

1735:
1736: WHEN fnd_api.g_exc_unexpected_error THEN
1737: ROLLBACK TO set_bank_branch_end_date;
1738: x_return_status := fnd_api.g_ret_sts_unexp_error;
1739: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data);
1742:
1743: IF l_DEBUG in ('Y', 'C') THEN

Line 1752: fnd_msg_pub.add;

1748: ROLLBACK TO set_bank_branch_end_date;
1749: x_return_status := fnd_api.g_ret_sts_unexp_error;
1750: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1751: fnd_message.set_token('ERROR',SQLERRM);
1752: fnd_msg_pub.add;
1753: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data);
1756:

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

1749: x_return_status := fnd_api.g_ret_sts_unexp_error;
1750: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
1751: fnd_message.set_token('ERROR',SQLERRM);
1752: fnd_msg_pub.add;
1753: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data);
1756:
1757: IF l_DEBUG in ('Y', 'C') THEN

Line 1950: fnd_msg_pub.initialize;

1946: END IF;
1947:
1948: -- initialize message list
1949: IF fnd_api.to_boolean(p_init_msg_list) THEN
1950: fnd_msg_pub.initialize;
1951: END IF;
1952:
1953: -- initialize API return status to success.
1954: x_return_status := fnd_api.g_ret_sts_success;

Line 1963: fnd_msg_pub.add;

1959: p_acct_rec.bank_account_num = null or
1960: p_acct_rec.account_owner_org_id = null or
1961: p_acct_rec.account_classification = null ) THEN
1962: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
1963: fnd_msg_pub.add;
1964: x_return_status := fnd_api.g_ret_sts_error;
1965: RAISE fnd_api.g_exc_error;
1966: END IF;
1967:

Line 2027: fnd_msg_pub.add;

2023: OPEN c_branch;
2024: FETCH c_branch INTO l_branch_number;
2025: IF c_branch%NOTFOUND THEN
2026: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
2027: fnd_msg_pub.add;
2028: x_return_status := fnd_api.g_ret_sts_error;
2029: RAISE fnd_api.g_exc_error;
2030: END IF;
2031: CLOSE c_branch;

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

2260: End If;
2261: CLOSE c_acct_rowid;
2262:
2263: -- get message count and if count is 1, get message info.
2264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2265: p_count => x_msg_count,
2266: p_data => x_msg_data);
2267:
2268: IF l_DEBUG in ('Y', 'C') THEN

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

2272: EXCEPTION
2273: WHEN fnd_api.g_exc_error THEN
2274: ROLLBACK TO create_bank_acct;
2275: x_return_status := fnd_api.g_ret_sts_error;
2276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2277: p_count => x_msg_count,
2278: p_data => x_msg_data);
2279:
2280: IF l_DEBUG in ('Y', 'C') THEN

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

2283:
2284: WHEN fnd_api.g_exc_unexpected_error THEN
2285: ROLLBACK TO create_bank_acct;
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2288: p_count => x_msg_count,
2289: p_data => x_msg_data);
2290:
2291: IF l_DEBUG in ('Y', 'C') THEN

Line 2300: fnd_msg_pub.add;

2296: ROLLBACK TO create_bank_acct;
2297: x_return_status := fnd_api.g_ret_sts_unexp_error;
2298: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2299: fnd_message.set_token('ERROR',SQLERRM);
2300: fnd_msg_pub.add;
2301: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data);
2304:

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

2297: x_return_status := fnd_api.g_ret_sts_unexp_error;
2298: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2299: fnd_message.set_token('ERROR',SQLERRM);
2300: fnd_msg_pub.add;
2301: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data);
2304:
2305: IF l_DEBUG in ('Y', 'C') THEN

Line 2384: fnd_msg_pub.initialize;

2380: END IF;
2381:
2382: -- initialize message list
2383: IF fnd_api.to_boolean(p_init_msg_list) THEN
2384: fnd_msg_pub.initialize;
2385: END IF;
2386:
2387: -- initialize API return status to success.
2388: x_return_status := fnd_api.g_ret_sts_success;

Line 2397: fnd_msg_pub.add;

2393: p_acct_rec.bank_account_num = null or
2394: p_acct_rec.account_classification = null or
2395: p_object_version_number = null) THEN
2396: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
2397: fnd_msg_pub.add;
2398: x_return_status := fnd_api.g_ret_sts_error;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;
2401:

Line 2417: fnd_msg_pub.add;

2413: OPEN c_branch_id;
2414: FETCH c_branch_id INTO l_branch_id;
2415: IF c_branch_id%NOTFOUND THEN
2416: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2417: fnd_msg_pub.add;
2418: x_return_status := fnd_api.g_ret_sts_error;
2419: CLOSE c_branch_id;
2420: RAISE fnd_api.g_exc_error;
2421: END IF;

Line 2470: fnd_msg_pub.add;

2466: OPEN c_branch_num(l_branch_id);
2467: FETCH c_branch_num INTO l_branch_number;
2468: IF c_branch_num%NOTFOUND THEN
2469: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');
2470: fnd_msg_pub.add;
2471: x_return_status := fnd_api.g_ret_sts_error;
2472: CLOSE c_branch_num;
2473: RAISE fnd_api.g_exc_error;
2474: END IF;

Line 2526: fnd_msg_pub.add;

2522: OPEN c_ovn;
2523: FETCH c_ovn INTO l_old_ovn;
2524: IF c_ovn%NOTFOUND THEN
2525: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2526: fnd_msg_pub.add;
2527: x_return_status := fnd_api.g_ret_sts_error;
2528: CLOSE c_ovn;
2529: RAISE fnd_api.g_exc_error;
2530: END IF;

Line 2536: fnd_msg_pub.add;

2532:
2533: IF l_old_ovn > p_object_version_number THEN
2534: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
2535: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');
2536: fnd_msg_pub.add;
2537: x_return_status := fnd_api.g_ret_sts_error;
2538: RAISE fnd_api.g_exc_error;
2539: END IF;
2540:

Line 2623: fnd_msg_pub.add;

2619: xtr_bank_account_reference = p_acct_rec.xtr_bank_account_reference
2620: WHERE bank_account_id = p_acct_rec.bank_account_id;
2621: IF (SQL%NOTFOUND) THEN
2622: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');
2623: fnd_msg_pub.add;
2624: x_return_status := fnd_api.g_ret_sts_error;
2625: RAISE fnd_api.g_exc_error;
2626: END IF;
2627: p_object_version_number := l_old_ovn + 1;

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

2626: END IF;
2627: p_object_version_number := l_old_ovn + 1;
2628:
2629: -- get message count and if count is 1, get message info.
2630: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2631: p_count => x_msg_count,
2632: p_data => x_msg_data);
2633:
2634: IF l_DEBUG in ('Y', 'C') THEN

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

2638: EXCEPTION
2639: WHEN fnd_api.g_exc_error THEN
2640: ROLLBACK TO update_bank_acct;
2641: x_return_status := fnd_api.g_ret_sts_error;
2642: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2643: p_count => x_msg_count,
2644: p_data => x_msg_data);
2645:
2646: IF l_DEBUG in ('Y', 'C') THEN

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

2649:
2650: WHEN fnd_api.g_exc_unexpected_error THEN
2651: ROLLBACK TO update_bank_acct;
2652: x_return_status := fnd_api.g_ret_sts_unexp_error;
2653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2654: p_count => x_msg_count,
2655: p_data => x_msg_data);
2656:
2657: IF l_DEBUG in ('Y', 'C') THEN

Line 2666: fnd_msg_pub.add;

2662: ROLLBACK TO udpate_bank_acct;
2663: x_return_status := fnd_api.g_ret_sts_unexp_error;
2664: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2665: fnd_message.set_token('ERROR',SQLERRM);
2666: fnd_msg_pub.add;
2667: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2668: p_count => x_msg_count,
2669: p_data => x_msg_data);
2670:

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

2663: x_return_status := fnd_api.g_ret_sts_unexp_error;
2664: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
2665: fnd_message.set_token('ERROR',SQLERRM);
2666: fnd_msg_pub.add;
2667: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2668: p_count => x_msg_count,
2669: p_data => x_msg_data);
2670:
2671: IF l_DEBUG in ('Y', 'C') THEN

Line 2711: fnd_msg_pub.initialize;

2707: END IF;
2708:
2709: -- initialize message list
2710: IF fnd_api.to_boolean(p_init_msg_list) THEN
2711: fnd_msg_pub.initialize;
2712: END IF;
2713:
2714: -- initialize API return status to success.
2715: x_return_status := fnd_api.g_ret_sts_success;

Line 2723: fnd_msg_pub.add;

2719: P_acct_use_rec.org_type = null or
2720: (p_acct_use_rec.legal_entity_id = null and
2721: p_acct_use_rec.org_id = null) ) THEN
2722: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
2723: fnd_msg_pub.add;
2724: x_return_status := fnd_api.g_ret_sts_error;
2725: RAISE fnd_api.g_exc_error;
2726: END IF;
2727:

Line 2733: fnd_msg_pub.add;

2729: IF ((p_acct_use_rec.ap_use_enable_flag = 'Y' or
2730: p_acct_use_rec.ar_use_enable_flag = 'Y') and
2731: p_acct_use_rec.asset_code_combination_id = null) THEN
2732: fnd_message.set_name('CE', 'CE_API_CASH_CCID_REQUIRED');
2733: fnd_msg_pub.add;
2734: x_return_status := fnd_api.g_ret_sts_error;
2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2737:

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

2974: End If;
2975: CLOSE c_gl_ccid_rowid;
2976:
2977: -- get message count and if count is 1, get message info.
2978: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2979: p_count => x_msg_count,
2980: p_data => x_msg_data);
2981:
2982: IF l_DEBUG in ('Y', 'C') THEN

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

2986: EXCEPTION
2987: WHEN fnd_api.g_exc_error THEN
2988: ROLLBACK TO create_bank_acct_use;
2989: x_return_status := fnd_api.g_ret_sts_error;
2990: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2991: p_count => x_msg_count,
2992: p_data => x_msg_data);
2993:
2994: IF l_DEBUG in ('Y', 'C') THEN

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

2997:
2998: WHEN fnd_api.g_exc_unexpected_error THEN
2999: ROLLBACK TO create_bank_acct_use;
3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3002: p_count => x_msg_count,
3003: p_data => x_msg_data);
3004:
3005: IF l_DEBUG in ('Y', 'C') THEN

Line 3014: fnd_msg_pub.add;

3010: ROLLBACK TO create_bank_acct_use;
3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3013: fnd_message.set_token('ERROR',SQLERRM);
3014: fnd_msg_pub.add;
3015: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3016: p_count => x_msg_count,
3017: p_data => x_msg_data);
3018:

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

3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3013: fnd_message.set_token('ERROR',SQLERRM);
3014: fnd_msg_pub.add;
3015: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3016: p_count => x_msg_count,
3017: p_data => x_msg_data);
3018:
3019: IF l_DEBUG in ('Y', 'C') THEN

Line 3069: fnd_msg_pub.initialize;

3065: END IF;
3066:
3067: -- initialize message list
3068: IF fnd_api.to_boolean(p_init_msg_list) THEN
3069: fnd_msg_pub.initialize;
3070: END IF;
3071:
3072: -- initialize API return status to success.
3073: x_return_status := fnd_api.g_ret_sts_success;

Line 3081: fnd_msg_pub.add;

3077: OPEN c_acct_org;
3078: FETCH c_acct_org INTO l_acct_id, l_org_id, l_le_id;
3079: IF c_acct_org%NOTFOUND THEN
3080: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');
3081: fnd_msg_pub.add;
3082: x_return_status := fnd_api.g_ret_sts_error;
3083: CLOSE c_acct_org;
3084: RAISE fnd_api.g_exc_error;
3085: END IF;

Line 3101: fnd_msg_pub.add;

3097: IF (p_acct_use_rec.bank_acct_use_id = null or
3098: p_use_ovn = null or
3099: p_ccid_ovn = null) THEN
3100: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');
3101: fnd_msg_pub.add;
3102: x_return_status := fnd_api.g_ret_sts_error;
3103: RAISE fnd_api.g_exc_error;
3104: END IF;
3105:

Line 3111: fnd_msg_pub.add;

3107: IF ((p_acct_use_rec.ap_use_enable_flag = 'Y' or
3108: p_acct_use_rec.ar_use_enable_flag = 'Y') and
3109: p_acct_use_rec.asset_code_combination_id = null) THEN
3110: fnd_message.set_name('CE', 'CE_API_CASH_CCID_REQUIRED');
3111: fnd_msg_pub.add;
3112: x_return_status := fnd_api.g_ret_sts_error;
3113: RAISE fnd_api.g_exc_error;
3114: END IF;
3115:

Line 3164: fnd_msg_pub.add;

3160: OPEN c_use_ovn;
3161: FETCH c_use_ovn INTO l_old_use_ovn;
3162: IF c_use_ovn%NOTFOUND THEN
3163: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');
3164: fnd_msg_pub.add;
3165: x_return_status := fnd_api.g_ret_sts_error;
3166: CLOSE c_use_ovn;
3167: RAISE fnd_api.g_exc_error;
3168: END IF;

Line 3174: fnd_msg_pub.add;

3170:
3171: IF l_old_use_ovn > p_use_ovn THEN
3172: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3173: fnd_message.set_token('TABLE', 'CE_BANK_ACCT_USES_ALL');
3174: fnd_msg_pub.add;
3175: x_return_status := fnd_api.g_ret_sts_error;
3176: RAISE fnd_api.g_exc_error;
3177: END IF;
3178:

Line 3187: fnd_msg_pub.add;

3183:
3184: IF l_old_ccid_ovn is not null AND l_old_ccid_ovn > p_ccid_ovn THEN
3185: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');
3186: fnd_message.set_token('TABLE', 'CE_GL_ACCOUNTS_CCID');
3187: fnd_msg_pub.add;
3188: x_return_status := fnd_api.g_ret_sts_error;
3189: RAISE fnd_api.g_exc_error;
3190: END IF;
3191:

Line 3236: fnd_msg_pub.add;

3232: object_version_number = l_old_use_ovn + 1
3233: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3234: IF (SQL%NOTFOUND) THEN
3235: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');
3236: fnd_msg_pub.add;
3237: x_return_status := fnd_api.g_ret_sts_error;
3238: RAISE fnd_api.g_exc_error;
3239: END IF;
3240: p_use_ovn := l_old_use_ovn + 1;

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

3273: p_ccid_ovn := l_old_ccid_ovn + 1;
3274: END IF;
3275:
3276: -- get message count and if count is 1, get message info.
3277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3278: p_count => x_msg_count,
3279: p_data => x_msg_data);
3280:
3281: IF l_DEBUG in ('Y', 'C') THEN

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

3285: EXCEPTION
3286: WHEN fnd_api.g_exc_error THEN
3287: ROLLBACK TO update_bank_acct_use;
3288: x_return_status := fnd_api.g_ret_sts_error;
3289: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3290: p_count => x_msg_count,
3291: p_data => x_msg_data);
3292:
3293: IF l_DEBUG in ('Y', 'C') THEN

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

3296:
3297: WHEN fnd_api.g_exc_unexpected_error THEN
3298: ROLLBACK TO update_bank_acct_use;
3299: x_return_status := fnd_api.g_ret_sts_unexp_error;
3300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3301: p_count => x_msg_count,
3302: p_data => x_msg_data);
3303:
3304: IF l_DEBUG in ('Y', 'C') THEN

Line 3313: fnd_msg_pub.add;

3309: ROLLBACK TO udpate_bank_acct_use;
3310: x_return_status := fnd_api.g_ret_sts_unexp_error;
3311: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3312: fnd_message.set_token('ERROR',SQLERRM);
3313: fnd_msg_pub.add;
3314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3315: p_count => x_msg_count,
3316: p_data => x_msg_data);
3317:

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

3310: x_return_status := fnd_api.g_ret_sts_unexp_error;
3311: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');
3312: fnd_message.set_token('ERROR',SQLERRM);
3313: fnd_msg_pub.add;
3314: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3315: p_count => x_msg_count,
3316: p_data => x_msg_data);
3317:
3318: IF l_DEBUG in ('Y', 'C') THEN