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 37: fnd_message.set_name('CE', 'CE_API_NO_BANK');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1958: p_acct_rec.bank_account_name = null or
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;

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

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

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

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

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

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

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

2392: p_acct_rec.bank_account_name = null or
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;

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

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

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

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

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

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

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

2530: END IF;
2531: CLOSE c_ovn;
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;

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

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

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

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

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

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

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

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

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

2718: IF (p_acct_use_rec.bank_account_id = null or
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;

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

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

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

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

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

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

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

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

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

3096: -- first check all required params
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;

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

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

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

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

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

3168: END IF;
3169: CLOSE c_use_ovn;
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;

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

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

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

3181: FETCH c_ccid_ovn INTO l_old_ccid_ovn;
3182: CLOSE c_ccid_ovn;
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;

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

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

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

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

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

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

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

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