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_AND_ACCOUNT_VALIDATION dependencies on FND_API

Line 247: x_return_status := fnd_api.G_RET_STS_ERROR;

243: -- If bank exists add message to error queue
244: if l_bank_exist = 'Y' then
245: fnd_message.set_name('CE', 'CE_DUP_BANK_NAME');
246: fnd_msg_pub.add;
247: x_return_status := fnd_api.G_RET_STS_ERROR;
248: else
249: x_return_status := fnd_api.G_RET_STS_SUCCESS;
250: end if;
251: /********** Bug 6742860/6642215: code added ends **************/

Line 249: x_return_status := fnd_api.G_RET_STS_SUCCESS;

245: fnd_message.set_name('CE', 'CE_DUP_BANK_NAME');
246: fnd_msg_pub.add;
247: x_return_status := fnd_api.G_RET_STS_ERROR;
248: else
249: x_return_status := fnd_api.G_RET_STS_SUCCESS;
250: end if;
251: /********** Bug 6742860/6642215: code added ends **************/
252:
253: /********** Bug 6742860/6642215: Commented out existing validations

Line 328: --RAISE fnd_api.g_exc_error;

324: fnd_msg_pub.add;
325: end if;
326:
327: if l_bank_name_exist = 'Y' OR l_short_name_exist = 'Y' OR l_bank_number_exist='Y' then
328: --RAISE fnd_api.g_exc_error;
329: x_return_status := fnd_api.G_RET_STS_ERROR;
330: else
331: x_return_status := fnd_api.G_RET_STS_SUCCESS;
332: end if;

Line 329: x_return_status := fnd_api.G_RET_STS_ERROR;

325: end if;
326:
327: if l_bank_name_exist = 'Y' OR l_short_name_exist = 'Y' OR l_bank_number_exist='Y' then
328: --RAISE fnd_api.g_exc_error;
329: x_return_status := fnd_api.G_RET_STS_ERROR;
330: else
331: x_return_status := fnd_api.G_RET_STS_SUCCESS;
332: end if;
333: */

Line 331: x_return_status := fnd_api.G_RET_STS_SUCCESS;

327: if l_bank_name_exist = 'Y' OR l_short_name_exist = 'Y' OR l_bank_number_exist='Y' then
328: --RAISE fnd_api.g_exc_error;
329: x_return_status := fnd_api.G_RET_STS_ERROR;
330: else
331: x_return_status := fnd_api.G_RET_STS_SUCCESS;
332: end if;
333: */
334: /********** Bug 6742860/6642215: code commented ends **************/
335: EXCEPTION

Line 465: x_return_status := fnd_api.g_ret_sts_success;

461: BEGIN
462: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency (+)');
463:
464: -- initialize API return status to success.
465: x_return_status := fnd_api.g_ret_sts_success;
466:
467: OPEN c_currency;
468: FETCH c_currency INTO l_dummy;
469: IF c_currency%NOTFOUND THEN

Line 472: x_return_status := fnd_api.g_ret_sts_error;

468: FETCH c_currency INTO l_dummy;
469: IF c_currency%NOTFOUND THEN
470: fnd_message.set_name('CE', 'CE_BA_INVALID_CURRENCY');
471: fnd_msg_pub.add;
472: x_return_status := fnd_api.g_ret_sts_error;
473: END IF;
474: CLOSE c_currency;
475: END validate_currency;
476:

Line 515: x_return_status := fnd_api.g_ret_sts_success;

511: BEGIN
512: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name (+)');
513:
514: -- initialize API return status to success.
515: x_return_status := fnd_api.g_ret_sts_success;
516: /*
517: OPEN c_rowid;
518: FETCH c_rowid INTO l_rowid;
519: CLOSE c_rowid;

Line 526: x_return_status := fnd_api.g_ret_sts_error;

522: FETCH c_acct_name INTO l_dummy;
523: IF l_dummy = 'X' THEN
524: fnd_message.set_name('CE', 'CE_DUP_ACCT_NAME');
525: fnd_msg_pub.add;
526: x_return_status := fnd_api.g_ret_sts_error;
527: END IF;
528: CLOSE c_acct_name;
529:
530: EXCEPTION

Line 571: x_return_status := fnd_api.g_ret_sts_success;

567: BEGIN
568: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (+)');
569:
570: -- initialize API return status to success.
571: x_return_status := fnd_api.g_ret_sts_success;
572:
573: -- step 1: remove spaces from the left and right only for p_IBAN
574: -- spaces in the middle are not removed
575:

Line 591: x_return_status := fnd_api.g_ret_sts_error;

587: --
588: IF l_len > 34 THEN
589: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
590: fnd_msg_pub.add;
591: x_return_status := fnd_api.g_ret_sts_error;
592: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
593: END IF;
594:
595: -- step 3

Line 608: x_return_status := fnd_api.g_ret_sts_error;

604:
605: IF (TRANSLATE(l_str1_2, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '99999999999999999999999999') <> '99') THEN
606: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
607: fnd_msg_pub.add;
608: x_return_status := fnd_api.g_ret_sts_error;
609: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str1_2= '||l_str1_2);
610: END IF;
611:
612: IF (TRANSLATE(l_str3_4, '0123456789', '9999999999') <> '99') THEN

Line 615: x_return_status := fnd_api.g_ret_sts_error;

611:
612: IF (TRANSLATE(l_str3_4, '0123456789', '9999999999') <> '99') THEN
613: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
614: fnd_msg_pub.add;
615: x_return_status := fnd_api.g_ret_sts_error;
616: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str3_4= '||l_str3_4);
617: END IF;
618:
619: --

Line 625: x_return_status := fnd_api.g_ret_sts_error;

621: '999999999999999999999999999999999999')
622: <> RPAD(l_var, l_len, '9') THEN
623: fnd_message.set_name('CE', 'CE_INVALID_IBAN_FORMAT');
624: fnd_msg_pub.add;
625: x_return_status := fnd_api.g_ret_sts_error;
626: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_FORMAT');
627: ELSE
628: --
629: l_temp1 := SUBSTR(new_IBAN, 1, 4);

Line 651: x_return_status := fnd_api.g_ret_sts_error;

647: --
648: IF l_mod <> 1 THEN
649: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
650: fnd_msg_pub.add;
651: x_return_status := fnd_api.g_ret_sts_error;
652: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
653: ELSE
654: -- IF (new_IBAN <> p_IBAN) then Bug 6658562
655: cep_standard.debug('new_IBAN <> p_IBAN');

Line 694: x_return_status := fnd_api.g_ret_sts_success;

690:
691: BEGIN
692: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
693: -- initialize API return status to success.
694: x_return_status := fnd_api.g_ret_sts_success;
695:
696: cep_standard.debug('p_ap='||p_ap);
697: cep_standard.debug('p_ar='||p_ar);
698: cep_standard.debug('p_pay='||p_pay);

Line 708: x_return_status := fnd_api.g_ret_sts_error;

704: (p_pay IS NULL OR p_pay = 'N') AND
705: (p_xtr IS NULL OR p_xtr = 'N') THEN
706: fnd_message.set_name('CE', 'CE_NO_ACCOUNT_USE');
707: fnd_msg_pub.add;
708: x_return_status := fnd_api.g_ret_sts_error;
709: END IF;
710:
711:
712: EXCEPTION

Line 739: x_return_status := fnd_api.g_ret_sts_success;

735:
736: BEGIN
737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
738: -- initialize API return status to success.
739: x_return_status := fnd_api.g_ret_sts_success;
740: cep_standard.debug('p_short_account_name='||p_short_account_name);
741: cep_standard.debug('p_xtr='||p_xtr);
742:
743:

Line 747: x_return_status := fnd_api.g_ret_sts_error;

743:
744: IF (p_short_account_name IS NULL) AND (p_xtr IS NOT NULL) AND (p_xtr <> 'N') THEN
745: fnd_message.set_name('CE', 'CE_SHORT_ACCOUNT_NAME_REQUIRED');
746: fnd_msg_pub.add;
747: x_return_status := fnd_api.g_ret_sts_error;
748: END IF;
749:
750:
751: EXCEPTION

Line 777: x_return_status := fnd_api.g_ret_sts_success;

773:
774: BEGIN
775: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date (+)');
776: -- initialize API return status to success.
777: x_return_status := fnd_api.g_ret_sts_success;
778:
779:
780: IF (p_start_date is not NULL) AND (p_end_date is not NULL) THEN
781: IF p_start_date > p_end_date THEN

Line 784: x_return_status := fnd_api.g_ret_sts_error;

780: IF (p_start_date is not NULL) AND (p_end_date is not NULL) THEN
781: IF p_start_date > p_end_date THEN
782: fnd_message.set_name('CE', 'CE_EARLY_END_DATE');
783: fnd_msg_pub.add;
784: x_return_status := fnd_api.g_ret_sts_error;
785: END IF;
786: END IF;
787:
788:

Line 794: x_return_status := fnd_api.g_ret_sts_error;

790: WHEN OTHERS THEN
791: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
792: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');
793: fnd_msg_pub.add;
794: x_return_status := fnd_api.g_ret_sts_error;
795:
796: END validate_end_date;
797:
798: /*=======================================================================+

Line 1041: x_return_status := fnd_api.g_ret_sts_success;

1037:
1038: BEGIN
1039: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
1040: -- initialize API return status to success.
1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: cep_standard.debug('p_ap='||p_ap);
1044: cep_standard.debug('p_ar='||p_ar);
1045: cep_standard.debug('p_pay='||p_pay);

Line 1060: x_return_status := fnd_api.g_ret_sts_error;

1056: ((p_ar IS not NULL) and (p_ar <>'N')) or
1057: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1058: fnd_message.set_name('CE', 'CE_LE_ACCESS_ORG');
1059: fnd_msg_pub.add;
1060: x_return_status := fnd_api.g_ret_sts_error;
1061: ELSIF (p_org_type = 'BG') AND
1062: (((p_ap IS not NULL) and (p_ap <>'N')) or
1063: ((p_ar IS not NULL) and (p_ar <>'N')) or
1064: ((p_xtr IS not NULL) and (p_xtr <>'N'))) THEN

Line 1067: x_return_status := fnd_api.g_ret_sts_error;

1063: ((p_ar IS not NULL) and (p_ar <>'N')) or
1064: ((p_xtr IS not NULL) and (p_xtr <>'N'))) THEN
1065: fnd_message.set_name('CE', 'CE_BG_ACCESS_ORG');
1066: fnd_msg_pub.add;
1067: x_return_status := fnd_api.g_ret_sts_error;
1068: ELSIF (p_org_type = 'OU') AND
1069: (((p_xtr IS not NULL) and (p_xtr <>'N')) or
1070: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1071: fnd_message.set_name('CE', 'CE_OU_ACCESS_ORG');

Line 1073: x_return_status := fnd_api.g_ret_sts_error;

1069: (((p_xtr IS not NULL) and (p_xtr <>'N')) or
1070: ((p_pay IS not NULL) and (p_pay <>'N'))) THEN
1071: fnd_message.set_name('CE', 'CE_OU_ACCESS_ORG');
1072: fnd_msg_pub.add;
1073: x_return_status := fnd_api.g_ret_sts_error;
1074: ELSIF (p_org_type = 'BGOU') AND
1075: ((p_xtr IS not NULL) and (p_xtr <>'N')) THEN
1076: fnd_message.set_name('CE', 'CE_BGOU_ACCESS_ORG');
1077: fnd_msg_pub.add;

Line 1078: x_return_status := fnd_api.g_ret_sts_error;

1074: ELSIF (p_org_type = 'BGOU') AND
1075: ((p_xtr IS not NULL) and (p_xtr <>'N')) THEN
1076: fnd_message.set_name('CE', 'CE_BGOU_ACCESS_ORG');
1077: fnd_msg_pub.add;
1078: x_return_status := fnd_api.g_ret_sts_error;
1079: END IF;
1080:
1081: EXCEPTION
1082: WHEN OTHERS THEN

Line 1105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1101: | x_msg_data |
1102: | X_VALUE_OUT |
1103: +=======================================================================*/
1104: PROCEDURE VALIDATE_ALC(ALC_VALUE in varchar2,
1105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1106: x_msg_count OUT NOCOPY NUMBER,
1107: x_msg_data OUT NOCOPY VARCHAR2,
1108: X_VALUE_OUT OUT NOCOPY VARCHAR2,
1109: x_return_status IN OUT NOCOPY VARCHAR2 )

Line 1118: IF FND_API.to_Boolean(p_init_msg_list) THEN

1114:
1115: BEGIN
1116:
1117: -- Initialize message list if p_init_msg_list is set to TRUE.
1118: IF FND_API.to_Boolean(p_init_msg_list) THEN
1119: FND_MSG_PUB.initialize;
1120: END IF;
1121: -- initialize API return status to success.
1122: x_return_status := fnd_api.g_ret_sts_success;

Line 1122: x_return_status := fnd_api.g_ret_sts_success;

1118: IF FND_API.to_Boolean(p_init_msg_list) THEN
1119: FND_MSG_PUB.initialize;
1120: END IF;
1121: -- initialize API return status to success.
1122: x_return_status := fnd_api.g_ret_sts_success;
1123:
1124:
1125: IF (ALC_VALUE is not null) THEN
1126:

Line 1139: x_return_status := fnd_api.g_ret_sts_error;

1135: end if;
1136: else
1137: FND_MESSAGE.set_name('CE','CE_ALC_VALUE_TOO_LONG');
1138: fnd_msg_pub.add;
1139: x_return_status := fnd_api.g_ret_sts_error;
1140: END if;
1141: ELSE
1142: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');
1143: fnd_msg_pub.add;

Line 1144: x_return_status := fnd_api.g_ret_sts_error;

1140: END if;
1141: ELSE
1142: FND_MESSAGE.set_name('CE','CE_ALC_NUMERIC_VALUE_ONLY');
1143: fnd_msg_pub.add;
1144: x_return_status := fnd_api.g_ret_sts_error;
1145: END IF;
1146:
1147: END IF;
1148:

Line 1150: p_encoded => FND_API.G_FALSE,

1146:
1147: END IF;
1148:
1149: FND_MSG_PUB.Count_And_Get(
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data);
1153:
1154: EXCEPTION

Line 1201: x_return_status := fnd_api.g_ret_sts_error;

1197: FETCH c_country INTO l_dummy;
1198: IF c_country%NOTFOUND THEN
1199: fnd_message.set_name('CE', 'CE_API_INVALID_COUNTRY');
1200: fnd_msg_pub.add;
1201: x_return_status := fnd_api.g_ret_sts_error;
1202: END IF;
1203: CLOSE c_country;
1204:
1205: IF l_DEBUG in ('Y', 'C') THEN

Line 1246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1242: p_bank_acct_use_id IN number,
1243: p_org_id IN number,
1244: p_ap_def_settlement in VARCHAR2,
1245: p_xtr_def_settlement in VARCHAR2,
1246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1247: x_msg_count OUT NOCOPY NUMBER,
1248: x_msg_data OUT NOCOPY VARCHAR2,
1249: x_return_status IN OUT NOCOPY VARCHAR2) IS
1250: p_cur varchar2(5);

Line 1256: x_return_status := fnd_api.g_ret_sts_success;

1252: p_xtr_def number;
1253: BEGIN
1254: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1255: -- initialize API return status to success.
1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: -- Initialize message list if p_init_msg_list is set to TRUE.
1259: IF FND_API.to_Boolean(p_init_msg_list) THEN
1260: FND_MSG_PUB.initialize;

Line 1259: IF FND_API.to_Boolean(p_init_msg_list) THEN

1255: -- initialize API return status to success.
1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: -- Initialize message list if p_init_msg_list is set to TRUE.
1259: IF FND_API.to_Boolean(p_init_msg_list) THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262: IF l_DEBUG in ('Y', 'C') THEN
1263: cep_standard.debug(' P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 1316: p_encoded => FND_API.G_FALSE,

1312: fnd_msg_pub.add;
1313: END IF;
1314:
1315: FND_MSG_PUB.Count_And_Get(
1316: p_encoded => FND_API.G_FALSE,
1317: p_count => x_msg_count,
1318: p_data => x_msg_data);
1319:
1320: IF x_msg_count > 0 THEN

Line 1321: x_return_status := fnd_api.g_ret_sts_error;

1317: p_count => x_msg_count,
1318: p_data => x_msg_data);
1319:
1320: IF x_msg_count > 0 THEN
1321: x_return_status := fnd_api.g_ret_sts_error;
1322: END IF;
1323: --IF l_DEBUG in ('Y', 'C') THEN
1324: cep_standard.debug(' P_COUNT: '|| x_msg_count);
1325:

Line 1436: x_return_status := fnd_api.g_ret_sts_success;

1432: BEGIN
1433: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access(+)');
1434:
1435: -- initialize API return status to success.
1436: x_return_status := fnd_api.g_ret_sts_success;
1437:
1438: OPEN c_acct_access;
1439: FETCH c_acct_access INTO l_dummy;
1440: IF l_dummy = 'X' THEN

Line 1443: x_return_status := fnd_api.g_ret_sts_error;

1439: FETCH c_acct_access INTO l_dummy;
1440: IF l_dummy = 'X' THEN
1441: fnd_message.set_name('CE', 'CE_DUP_ACCT_ORG_ACCESS');
1442: fnd_msg_pub.add;
1443: x_return_status := fnd_api.g_ret_sts_error;
1444: END IF;
1445: CLOSE c_acct_access;
1446:
1447: EXCEPTION