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_MESSAGE

Line 27: fnd_message.set_name('CE', 'CE_API_REQUIRED_PARAM');

23: ) AS
24: BEGIN
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.');

Line 28: fnd_message.set_token('PARAM', p_param_name);

24: BEGIN
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;

Line 67: fnd_message.set_name('CE', 'CE_API_NO_BANK');

63:
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;

Line 137: fnd_message.set_name('CE', 'CE_API_NO_BANK');

133:
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;

Line 359: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

355:
356: WHEN OTHERS THEN
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,

Line 360: fnd_message.set_token('ERROR',SQLERRM);

356: WHEN OTHERS THEN
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);

Line 597: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

593:
594: WHEN OTHERS THEN
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,

Line 598: fnd_message.set_token('ERROR',SQLERRM);

594: WHEN OTHERS THEN
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);

Line 712: fnd_message.set_name('CE', 'CE_API_NO_BANK');

708: -- set children's end dates.
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;

Line 725: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');

721: FOR branch_id_rec IN c_branch_id LOOP
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;

Line 757: fnd_message.set_name('CE', 'CE_API_NO_BANK');

753:
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;

Line 808: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

804:
805: WHEN OTHERS THEN
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,

Line 809: fnd_message.set_token('ERROR',SQLERRM);

805: WHEN OTHERS THEN
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);

Line 1058: fnd_message.set_name('CE', 'CE_API_NO_BANK');

1054:
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;

Line 1230: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

1226:
1227: WHEN OTHERS THEN
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,

Line 1231: fnd_message.set_token('ERROR',SQLERRM);

1227: WHEN OTHERS THEN
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);

Line 1553: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

1549:
1550: WHEN OTHERS THEN
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,

Line 1554: fnd_message.set_token('ERROR',SQLERRM);

1550: WHEN OTHERS THEN
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);

Line 1705: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');

1701: -- old branch end date
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;

Line 1716: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');

1712: -- find bank_id of this branch's bank
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;

Line 1727: fnd_message.set_name('CE', 'CE_API_NO_BANK');

1723: -- bank's end date
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;

Line 1817: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');

1813:
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;

Line 1889: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

1885:
1886: WHEN OTHERS THEN
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,

Line 1890: fnd_message.set_token('ERROR',SQLERRM);

1886: WHEN OTHERS THEN
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,

Line 2174: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');

2170: -- find branch number
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;

Line 2533: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

2529:
2530: WHEN OTHERS THEN
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,

Line 2534: fnd_message.set_token('ERROR',SQLERRM);

2530: WHEN OTHERS THEN
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);

Line 2695: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

2691: --Bug 8407297
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;

Line 2752: fnd_message.set_name('CE', 'CE_BANK_MULTICURRENCY');

2748: legal_entity_id = l_bank_acct_rec_master.account_owner_org_id;
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;

Line 2776: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

2772: -- validate account name
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;

Line 2829: fnd_message.set_name('CE', 'CE_API_NO_BRANCH');

2825: -- find branch number
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;

Line 2885: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

2881: -- check object version number to make sure the record has not been updated
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;

Line 2894: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');

2890: END IF;
2891: CLOSE c_ovn;
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;

Line 2895: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');

2891: CLOSE c_ovn;
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;

Line 2990: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

2986: object_version_number = l_old_ovn + 1,
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;

Line 3032: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

3028:
3029: WHEN OTHERS THEN
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,

Line 3033: fnd_message.set_token('ERROR',SQLERRM);

3029: WHEN OTHERS THEN
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);

Line 3098: fnd_message.set_name('CE', 'CE_API_CASH_CCID_REQUIRED');

3094: -- GL Cash Account is required if the account use is Payables or Receivables
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;

Line 3378: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

3374:
3375: WHEN OTHERS THEN
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,

Line 3379: fnd_message.set_token('ERROR',SQLERRM);

3375: WHEN OTHERS THEN
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);

Line 3446: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');

3442: -- find them using the bank_acct_use_id
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;

Line 3472: fnd_message.set_name('CE', 'CE_API_CASH_CCID_REQUIRED');

3468: -- GL Cash Account is required if the account use is Payables or Receivables
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;

Line 3525: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');

3521: -- check object version number to make sure the record has not been updated
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;

Line 3534: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');

3530: END IF;
3531: CLOSE c_use_ovn;
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;

Line 3535: fnd_message.set_token('TABLE', 'CE_BANK_ACCT_USES_ALL');

3531: CLOSE c_use_ovn;
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;

Line 3547: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');

3543: FETCH c_ccid_ovn INTO l_old_ccid_ovn;
3544: CLOSE c_ccid_ovn;
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;

Line 3548: fnd_message.set_token('TABLE', 'CE_GL_ACCOUNTS_CCID');

3544: CLOSE c_ccid_ovn;
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;

Line 3597: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');

3593: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
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;

Line 3673: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

3669:
3670: WHEN OTHERS THEN
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,

Line 3674: fnd_message.set_token('ERROR',SQLERRM);

3670: WHEN OTHERS THEN
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);

Line 3755: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

3751: FROM ce_bank_accounts
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;

Line 3762: fnd_message.set_name('CE', 'CE_API_RECORD_CHANGED');

3758: RAISE fnd_api.g_exc_error;
3759: END;
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;

Line 3763: fnd_message.set_token('TABLE', 'CE_BANK_ACCOUNTS');

3759: END;
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;

Line 3777: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT');

3773: WHERE bank_account_id = p_bank_acct_id;
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;

Line 3822: fnd_message.set_name('CE', 'CE_API_OTHERS_EXCEP');

3818:
3819: WHEN OTHERS THEN
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,

Line 3823: fnd_message.set_token('ERROR',SQLERRM);

3819: WHEN OTHERS THEN
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,