DBA Data[Home] [Help]

APPS.CE_VALIDATE_BANKINFO_UPG dependencies on FND_API

Line 543: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

539: X_CD IN varchar2,
540: X_BANK_NUMBER IN varchar2,
541: X_BRANCH_NUMBER IN varchar2,
542: X_ACCOUNT_NUMBER IN varchar2) AS
543: --p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544: --x_msg_count OUT NOCOPY NUMBER,
545: --x_msg_data OUT NOCOPY VARCHAR2) AS
546: --X_VALUE_OUT OUT NOCOPY varchar2) AS
547:

Line 571: IF FND_API.to_Boolean(p_init_msg_list) THEN

567: END IF;
568: */
569: /* removed 9/2/03
570: -- Initialize message list if p_init_msg_list is set to TRUE.
571: IF FND_API.to_Boolean(p_init_msg_list) THEN
572: FND_MSG_PUB.initialize;
573: END IF;
574: */
575: /* We must validate the Check Digit*/

Line 674: p_encoded => FND_API.G_FALSE,

670: END IF;
671:
672: /* 9/2/03
673: FND_MSG_PUB.Count_And_Get(
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_msg_count,
676: p_data => x_msg_data);
677: */
678: IF l_DEBUG in ('Y', 'C') THEN

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

717: X_BRANCH_NAME_ALT IN varchar2,
718: X_BANK_ID IN NUMBER,
719: --X_BRANCH_ID IN NUMBER,
720: X_VALIDATION_TYPE IN varchar2 := 'ALL',
721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
722: x_msg_count OUT NOCOPY NUMBER,
723: x_msg_data OUT NOCOPY VARCHAR2,
724: X_VALUE_OUT OUT NOCOPY varchar2,
725: x_message_name_all OUT NOCOPY varchar2)

Line 754: IF FND_API.to_Boolean(p_init_msg_list) THEN

750:
751: X_VALUE_OUT := X_BRANCH_NUMBER;
752:
753: -- Initialize message list if p_init_msg_list is set to TRUE.
754: IF FND_API.to_Boolean(p_init_msg_list) THEN
755: FND_MSG_PUB.initialize;
756: END IF;
757:
758: IF l_DEBUG in ('Y', 'C') THEN

Line 962: p_encoded => FND_API.G_FALSE,

958: --cep_standard.debug('x_msg_count= '|| x_msg_count);
959: --cep_standard.debug('x_msg_data= '|| x_msg_data);
960:
961: FND_MSG_PUB.Count_And_Get(
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data);
965:
966: --cep_standard.debug('call FND_MSG_PUB.Count_Msg');

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

1030: X_SECONDARY_ACCOUNT_REFERENCE IN varchar2,
1031: X_ACCOUNT_NAME IN varchar2,
1032: X_CD IN varchar2,
1033: X_VALIDATION_TYPE IN varchar2 := 'ALL',
1034: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1035: x_msg_count OUT NOCOPY NUMBER,
1036: x_msg_data OUT NOCOPY VARCHAR2,
1037: X_VALUE_OUT OUT NOCOPY varchar2,
1038: x_message_name_all OUT NOCOPY varchar2)

Line 1065: IF FND_API.to_Boolean(p_init_msg_list) THEN

1061: X_VALUE_OUT := X_ACCOUNT_NUMBER;
1062:
1063: -- Initialize message list if p_init_msg_list is set to TRUE.
1064:
1065: IF FND_API.to_Boolean(p_init_msg_list) THEN
1066: FND_MSG_PUB.initialize;
1067: END IF;
1068:
1069: IF l_DEBUG in ('Y', 'C') THEN

Line 1309: p_encoded => FND_API.G_FALSE,

1305: END IF;
1306: */
1307:
1308: FND_MSG_PUB.Count_And_Get(
1309: p_encoded => FND_API.G_FALSE,
1310: p_count => x_msg_count,
1311: p_data => x_msg_data);
1312:
1313: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

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

1367: X_BANK_NAME_ALT IN varchar2,
1368: X_TAX_PAYER_ID IN varchar2,
1369: --X_BANK_ID IN NUMBER,
1370: X_VALIDATION_TYPE IN varchar2 := 'ALL',
1371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: X_VALUE_OUT OUT NOCOPY varchar2,
1375: x_message_name_all OUT NOCOPY varchar2 ) AS

Line 1400: IF FND_API.to_Boolean(p_init_msg_list) THEN

1396: COUNTRY_NAME := X_COUNTRY_NAME;
1397: X_VALUE_OUT := X_BANK_NUMBER;
1398:
1399: -- Initialize message list if p_init_msg_list is set to TRUE.
1400: IF FND_API.to_Boolean(p_init_msg_list) THEN
1401: FND_MSG_PUB.initialize;
1402: END IF;
1403:
1404: IF l_DEBUG in ('Y', 'C') THEN

Line 1561: p_encoded => FND_API.G_FALSE,

1557: /** country unique check for bank **/
1558:
1559:
1560: FND_MSG_PUB.Count_And_Get(
1561: p_encoded => FND_API.G_FALSE,
1562: p_count => x_msg_count,
1563: p_data => x_msg_data);
1564:
1565: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

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

8085: --------------------------------------------------------------------- */
8086:
8087: procedure CE_VALIDATE_MISC_EFT_NUM(X_COUNTRY_NAME in varchar2,
8088: X_EFT_NUMBER in varchar2,
8089: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8090: x_msg_count OUT NOCOPY NUMBER,
8091: x_msg_data OUT NOCOPY VARCHAR2,
8092: x_return_status IN OUT NOCOPY VARCHAR2)
8093: AS

Line 8131: x_return_status := fnd_api.g_ret_sts_success;

8127: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM');
8128: END IF;
8129:
8130: -- initialize API return status to success.
8131: x_return_status := fnd_api.g_ret_sts_success;
8132:
8133: COUNTRY_NAME := X_COUNTRY_NAME;
8134:
8135: IF l_DEBUG in ('Y', 'C') THEN

Line 8140: IF FND_API.to_Boolean(p_init_msg_list) THEN

8136: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM - COUNTRY_NAME: '|| COUNTRY_NAME);
8137: END IF;
8138:
8139: -- Initialize message list if p_init_msg_list is set to TRUE.
8140: IF FND_API.to_Boolean(p_init_msg_list) THEN
8141: FND_MSG_PUB.initialize;
8142: END IF;
8143:
8144: IF l_DEBUG in ('Y', 'C') THEN

Line 8183: p_encoded => FND_API.G_FALSE,

8179: END IF; -- end of country_name
8180:
8181:
8182: FND_MSG_PUB.Count_And_Get(
8183: p_encoded => FND_API.G_FALSE,
8184: p_count => x_msg_count,
8185: p_data => x_msg_data);
8186:
8187: IF x_msg_count > 0 THEN

Line 8188: x_return_status := fnd_api.g_ret_sts_error;

8184: p_count => x_msg_count,
8185: p_data => x_msg_data);
8186:
8187: IF x_msg_count > 0 THEN
8188: x_return_status := fnd_api.g_ret_sts_error;
8189: END IF;
8190:
8191: IF l_DEBUG in ('Y', 'C') THEN
8192: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_misc_eft_num - P_COUNT: '|| x_msg_count||

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

8211:
8212: procedure CE_VALIDATE_MISC_ACCT_HLDR_ALT(X_COUNTRY_NAME in varchar2,
8213: X_ACCOUNT_HOLDER_ALT in varchar2,
8214: X_ACCOUNT_CLASSIFICATION in varchar2,
8215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8216: x_msg_count OUT NOCOPY NUMBER,
8217: x_msg_data OUT NOCOPY VARCHAR2,
8218: x_return_status IN OUT NOCOPY VARCHAR2)
8219: AS

Line 8248: x_return_status := fnd_api.g_ret_sts_success;

8244: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT');
8245: END IF;
8246:
8247: -- initialize API return status to success.
8248: x_return_status := fnd_api.g_ret_sts_success;
8249:
8250: COUNTRY_NAME := X_COUNTRY_NAME;
8251:
8252: IF l_DEBUG in ('Y', 'C') THEN

Line 8257: IF FND_API.to_Boolean(p_init_msg_list) THEN

8253: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT - COUNTRY_NAME: '|| COUNTRY_NAME);
8254: END IF;
8255:
8256: -- Initialize message list if p_init_msg_list is set to TRUE.
8257: IF FND_API.to_Boolean(p_init_msg_list) THEN
8258: FND_MSG_PUB.initialize;
8259: END IF;
8260:
8261: IF l_DEBUG in ('Y', 'C') THEN

Line 8282: p_encoded => FND_API.G_FALSE,

8278: END IF; -- end of country_name
8279:
8280:
8281: FND_MSG_PUB.Count_And_Get(
8282: p_encoded => FND_API.G_FALSE,
8283: p_count => x_msg_count,
8284: p_data => x_msg_data);
8285:
8286: IF x_msg_count > 0 THEN

Line 8287: x_return_status := fnd_api.g_ret_sts_error;

8283: p_count => x_msg_count,
8284: p_data => x_msg_data);
8285:
8286: IF x_msg_count > 0 THEN
8287: x_return_status := fnd_api.g_ret_sts_error;
8288: END IF;
8289:
8290: IF l_DEBUG in ('Y', 'C') THEN
8291: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_misc_acct_hldr_alt - P_COUNT: '|| x_msg_count||