DBA Data[Home] [Help]

APPS.CE_VALIDATE_BANKINFO dependencies on FND_API

Line 70: IF FND_API.to_Boolean(p_init_msg_list) THEN

66: IF l_DEBUG in ('Y', 'C') THEN
67: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bic');
68: END IF;
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: -- initialize API return status to success.
74: x_return_status := fnd_api.g_ret_sts_success;

Line 74: x_return_status := fnd_api.g_ret_sts_success;

70: IF FND_API.to_Boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: -- initialize API return status to success.
74: x_return_status := fnd_api.g_ret_sts_success;
75:
76: l_bic := upper(X_BIC_CODE) ;
77:
78: If length(l_bic) IN ( 8,11 ) Then

Line 85: x_return_status := fnd_api.g_ret_sts_error;

81:
82: if to_number(l_string) > 0 Then
83: fnd_message.set_name('CE', 'CE_INVALID_BIC_CODE');
84: fnd_msg_pub.add;
85: x_return_status := fnd_api.g_ret_sts_error;
86: End If ;
87: Else
88: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');
89: fnd_msg_pub.add;

Line 90: x_return_status := fnd_api.g_ret_sts_error;

86: End If ;
87: Else
88: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');
89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_error;
91: End If ;
92:
93: FND_MSG_PUB.Count_And_Get(
94: p_encoded => FND_API.G_FALSE,

Line 94: p_encoded => FND_API.G_FALSE,

90: x_return_status := fnd_api.g_ret_sts_error;
91: End If ;
92:
93: FND_MSG_PUB.Count_And_Get(
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data);
97:
98: end CE_VALIDATE_BIC;

Line 1004: x_return_status := fnd_api.g_ret_sts_success;

1000: IF l_DEBUG in ('Y', 'C') THEN
1001: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_cd');
1002: END IF;
1003: -- initialize API return status to success.
1004: x_return_status := fnd_api.g_ret_sts_success;
1005:
1006: COUNTRY_NAME := X_COUNTRY_NAME;
1007:
1008: --X_VALUE_OUT := X_CD;

Line 1017: IF FND_API.to_Boolean(p_init_msg_list) THEN

1013: 'CE_VALIDATE_BANKINFO.ce_validate_cd - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean(p_init_msg_list) THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: /* We must validate the Check Digit

Line 1131: p_encoded => FND_API.G_FALSE,

1127:
1128: End If ; -- End Bug 6632733
1129:
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134:
1135: IF x_msg_count > 0 THEN

Line 1136: x_return_status := fnd_api.g_ret_sts_error;

1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134:
1135: IF x_msg_count > 0 THEN
1136: x_return_status := fnd_api.g_ret_sts_error;
1137: END IF;
1138:
1139: IF l_DEBUG in ('Y', 'C') THEN
1140: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_cd - P_COUNT: '|| x_msg_count||

Line 1202: x_return_status := fnd_api.g_ret_sts_success;

1198: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_branch');
1199: END IF;
1200:
1201: -- initialize API return status to success.
1202: x_return_status := fnd_api.g_ret_sts_success;
1203:
1204: COUNTRY_NAME := X_COUNTRY_NAME;
1205:
1206: X_VALUE_OUT := X_BRANCH_NUMBER;

Line 1214: IF FND_API.to_Boolean(p_init_msg_list) THEN

1210: ', X_VALUE_OUT: '|| X_VALUE_OUT);
1211: END IF;
1212:
1213: -- Initialize message list if p_init_msg_list is set to TRUE.
1214: IF FND_API.to_Boolean(p_init_msg_list) THEN
1215: FND_MSG_PUB.initialize;
1216: END IF;
1217:
1218: IF l_DEBUG in ('Y', 'C') THEN

Line 1408: p_encoded => FND_API.G_FALSE,

1404: cep_standard.debug('UNIQUE VALIDATION CHECK for branch end' );
1405: END IF;
1406:
1407: FND_MSG_PUB.Count_And_Get(
1408: p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:
1412: IF x_msg_count > 0 THEN

Line 1413: x_return_status := fnd_api.g_ret_sts_error;

1409: p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:
1412: IF x_msg_count > 0 THEN
1413: x_return_status := fnd_api.g_ret_sts_error;
1414: END IF;
1415:
1416: IF l_DEBUG in ('Y', 'C') THEN
1417: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_branch - P_COUNT: '|| x_msg_count||

Line 1472: x_return_status := fnd_api.g_ret_sts_success;

1468: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_branch_unique');
1469: END IF;
1470:
1471: -- initialize API return status to success.
1472: x_return_status := fnd_api.g_ret_sts_success;
1473:
1474: COUNTRY_NAME := X_COUNTRY_NAME;
1475:
1476: X_VALUE_OUT := X_BRANCH_NUMBER;

Line 1484: IF FND_API.to_Boolean(p_init_msg_list) THEN

1480: ', X_VALUE_OUT: '|| X_VALUE_OUT);
1481: END IF;
1482:
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1484: IF FND_API.to_Boolean(p_init_msg_list) THEN
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487:
1488: /** UNIQUE VALIDATION CHECK for branch **/

Line 1545: p_encoded => FND_API.G_FALSE,

1541: /** end country unique check for branch **/
1542:
1543:
1544: FND_MSG_PUB.Count_And_Get(
1545: p_encoded => FND_API.G_FALSE,
1546: p_count => x_msg_count,
1547: p_data => x_msg_data);
1548:
1549: IF x_msg_count > 0 THEN

Line 1550: x_return_status := fnd_api.g_ret_sts_error;

1546: p_count => x_msg_count,
1547: p_data => x_msg_data);
1548:
1549: IF x_msg_count > 0 THEN
1550: x_return_status := fnd_api.g_ret_sts_error;
1551: END IF;
1552:
1553: IF l_DEBUG in ('Y', 'C') THEN
1554: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_unique - P_COUNT: '|| x_msg_count||

Line 1610: x_return_status := fnd_api.g_ret_sts_success;

1606: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_branch_validate');
1607: END IF;
1608:
1609: -- initialize API return status to success.
1610: x_return_status := fnd_api.g_ret_sts_success;
1611:
1612: COUNTRY_NAME := X_COUNTRY_NAME;
1613:
1614: X_VALUE_OUT := X_BRANCH_NUMBER;

Line 1622: IF FND_API.to_Boolean(p_init_msg_list) THEN

1618: ', X_VALUE_OUT: '|| X_VALUE_OUT);
1619: END IF;
1620:
1621: -- Initialize message list if p_init_msg_list is set to TRUE.
1622: IF FND_API.to_Boolean(p_init_msg_list) THEN
1623: FND_MSG_PUB.initialize;
1624: END IF;
1625:
1626: /* We must validate the Bank Branch Number */

Line 1753: p_encoded => FND_API.G_FALSE,

1749:
1750: END IF;
1751:
1752: FND_MSG_PUB.Count_And_Get(
1753: p_encoded => FND_API.G_FALSE,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data);
1756:
1757: IF x_msg_count > 0 THEN

Line 1758: x_return_status := fnd_api.g_ret_sts_error;

1754: p_count => x_msg_count,
1755: p_data => x_msg_data);
1756:
1757: IF x_msg_count > 0 THEN
1758: x_return_status := fnd_api.g_ret_sts_error;
1759: END IF;
1760:
1761: IF l_DEBUG in ('Y', 'C') THEN
1762: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_validate - P_COUNT: '|| x_msg_count||

Line 1993: x_return_status := fnd_api.g_ret_sts_success;

1989: IF l_DEBUG in ('Y', 'C') THEN
1990: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');
1991: END IF;
1992: -- initialize API return status to success.
1993: x_return_status := fnd_api.g_ret_sts_success;
1994:
1995: COUNTRY_NAME := X_COUNTRY_NAME;
1996: X_ELECTRONIC_ACCT_NUM := X_ACCOUNT_NUMBER;
1997:

Line 2004: IF FND_API.to_Boolean(p_init_msg_list) THEN

2000: ', X_ELECTRONIC_ACCT_NUM: '|| X_ELECTRONIC_ACCT_NUM);
2001: END IF;
2002:
2003: -- Initialize message list if p_init_msg_list is set to TRUE.
2004: IF FND_API.to_Boolean(p_init_msg_list) THEN
2005: FND_MSG_PUB.initialize;
2006: END IF;
2007:
2008: IF l_DEBUG in ('Y', 'C') THEN

Line 2048: p_encoded => FND_API.G_FALSE,

2044: );
2045: END IF;
2046:
2047: FND_MSG_PUB.Count_And_Get(
2048: p_encoded => FND_API.G_FALSE,
2049: p_count => x_msg_count,
2050: p_data => x_msg_data);
2051:
2052: IF x_msg_count > 0 THEN

Line 2053: x_return_status := fnd_api.g_ret_sts_error;

2049: p_count => x_msg_count,
2050: p_data => x_msg_data);
2051:
2052: IF x_msg_count > 0 THEN
2053: x_return_status := fnd_api.g_ret_sts_error;
2054: END IF;
2055:
2056: IF l_DEBUG in ('Y', 'C') THEN
2057: cep_standard.debug('P_COUNT: '|| x_msg_count||

Line 2121: x_return_status := fnd_api.g_ret_sts_success;

2117: IF l_DEBUG in ('Y', 'C') THEN
2118: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_account');
2119: END IF;
2120: -- initialize API return status to success.
2121: x_return_status := fnd_api.g_ret_sts_success;
2122:
2123: COUNTRY_NAME := X_COUNTRY_NAME;
2124: X_VALUE_OUT := X_ACCOUNT_NUMBER;
2125: X_ELECTRONIC_ACCT_NUM := X_ACCOUNT_NUMBER;

Line 2133: IF FND_API.to_Boolean(p_init_msg_list) THEN

2129: ', X_VALUE_OUT: '|| X_VALUE_OUT);
2130: END IF;
2131:
2132: -- Initialize message list if p_init_msg_list is set to TRUE.
2133: IF FND_API.to_Boolean(p_init_msg_list) THEN
2134: FND_MSG_PUB.initialize;
2135: END IF;
2136:
2137: IF l_DEBUG in ('Y', 'C') THEN

Line 2377: p_encoded => FND_API.G_FALSE,

2373: END IF;
2374:
2375:
2376: FND_MSG_PUB.Count_And_Get(
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:
2381: IF x_msg_count > 0 THEN

Line 2382: x_return_status := fnd_api.g_ret_sts_error;

2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:
2381: IF x_msg_count > 0 THEN
2382: x_return_status := fnd_api.g_ret_sts_error;
2383: END IF;
2384:
2385: IF l_DEBUG in ('Y', 'C') THEN
2386: cep_standard.debug('CE_VALIDATE_ACCOUNT: P_COUNT: '|| x_msg_count||

Line 2444: x_return_status := fnd_api.g_ret_sts_success;

2440: IF l_DEBUG in ('Y', 'C') THEN
2441: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_account_unique');
2442: END IF;
2443: -- initialize API return status to success.
2444: x_return_status := fnd_api.g_ret_sts_success;
2445:
2446: COUNTRY_NAME := X_COUNTRY_NAME;
2447: X_VALUE_OUT := X_ACCOUNT_NUMBER;
2448:

Line 2455: IF FND_API.to_Boolean(p_init_msg_list) THEN

2451: ', X_VALUE_OUT: '|| X_VALUE_OUT);
2452: END IF;
2453:
2454: -- Initialize message list if p_init_msg_list is set to TRUE.
2455: IF FND_API.to_Boolean(p_init_msg_list) THEN
2456: FND_MSG_PUB.initialize;
2457: END IF;
2458:
2459: IF l_DEBUG in ('Y', 'C') THEN

Line 2502: p_encoded => FND_API.G_FALSE,

2498: cep_standard.debug(' UNIQUE_VALIDATION CHECK for account end ');
2499: END IF;
2500:
2501: FND_MSG_PUB.Count_And_Get(
2502: p_encoded => FND_API.G_FALSE,
2503: p_count => x_msg_count,
2504: p_data => x_msg_data);
2505:
2506: IF x_msg_count > 0 THEN

Line 2507: x_return_status := fnd_api.g_ret_sts_error;

2503: p_count => x_msg_count,
2504: p_data => x_msg_data);
2505:
2506: IF x_msg_count > 0 THEN
2507: x_return_status := fnd_api.g_ret_sts_error;
2508: END IF;
2509:
2510: IF l_DEBUG in ('Y', 'C') THEN
2511: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique - P_COUNT: '|| x_msg_count||

Line 2574: x_return_status := fnd_api.g_ret_sts_success;

2570: IF l_DEBUG in ('Y', 'C') THEN
2571: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_account_validate');
2572: END IF;
2573: -- initialize API return status to success.
2574: x_return_status := fnd_api.g_ret_sts_success;
2575:
2576: COUNTRY_NAME := X_COUNTRY_NAME;
2577: X_VALUE_OUT := X_ACCOUNT_NUMBER;
2578: X_ELECTRONIC_ACCT_NUM := X_ACCOUNT_NUMBER;

Line 2586: --IF FND_API.to_Boolean(p_init_msg_list) THEN

2582: ', X_VALUE_OUT: '|| X_VALUE_OUT);
2583: END IF;
2584:
2585: -- Initialize message list if p_init_msg_list is set to TRUE.
2586: --IF FND_API.to_Boolean(p_init_msg_list) THEN
2587: FND_MSG_PUB.initialize;
2588: --END IF;
2589:
2590: IF l_DEBUG in ('Y', 'C') THEN

Line 2782: p_encoded => FND_API.G_FALSE,

2778:
2779:
2780:
2781: FND_MSG_PUB.Count_And_Get(
2782: p_encoded => FND_API.G_FALSE,
2783: p_count => x_msg_count,
2784: p_data => x_msg_data);
2785:
2786: IF x_msg_count > 0 THEN

Line 2787: x_return_status := fnd_api.g_ret_sts_error;

2783: p_count => x_msg_count,
2784: p_data => x_msg_data);
2785:
2786: IF x_msg_count > 0 THEN
2787: x_return_status := fnd_api.g_ret_sts_error;
2788: END IF;
2789:
2790: IF l_DEBUG in ('Y', 'C') THEN
2791: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_validate - P_COUNT: '|| x_msg_count||

Line 2847: x_return_status := fnd_api.g_ret_sts_success;

2843: IF l_DEBUG in ('Y', 'C') THEN
2844: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bank');
2845: END IF;
2846: -- initialize API return status to success.
2847: x_return_status := fnd_api.g_ret_sts_success;
2848:
2849: COUNTRY_NAME := X_COUNTRY_NAME;
2850: X_VALUE_OUT := X_BANK_NUMBER;
2851:

Line 2859: IF FND_API.to_Boolean(p_init_msg_list) THEN

2855: END IF;
2856:
2857:
2858: -- Initialize message list if p_init_msg_list is set to TRUE.
2859: IF FND_API.to_Boolean(p_init_msg_list) THEN
2860: FND_MSG_PUB.initialize;
2861: END IF;
2862:
2863: IF l_DEBUG in ('Y', 'C') THEN

Line 3001: p_encoded => FND_API.G_FALSE,

2997: cep_standard.debug('CE_VALIDATE_CD: ' || 'UNIQUE VALIDATION CHECK for bank end' );
2998: END IF;
2999:
3000: FND_MSG_PUB.Count_And_Get(
3001: p_encoded => FND_API.G_FALSE,
3002: p_count => x_msg_count,
3003: p_data => x_msg_data);
3004:
3005: IF x_msg_count > 0 THEN

Line 3006: x_return_status := fnd_api.g_ret_sts_error;

3002: p_count => x_msg_count,
3003: p_data => x_msg_data);
3004:
3005: IF x_msg_count > 0 THEN
3006: x_return_status := fnd_api.g_ret_sts_error;
3007: END IF;
3008:
3009: IF l_DEBUG in ('Y', 'C') THEN
3010: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank - P_COUNT: '|| x_msg_count||

Line 3063: x_return_status := fnd_api.g_ret_sts_success;

3059: IF l_DEBUG in ('Y', 'C') THEN
3060: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_bank_unique');
3061: END IF;
3062: -- initialize API return status to success.
3063: x_return_status := fnd_api.g_ret_sts_success;
3064:
3065: COUNTRY_NAME := X_COUNTRY_NAME;
3066: X_VALUE_OUT := X_BANK_NUMBER;
3067:

Line 3075: IF FND_API.to_Boolean(p_init_msg_list) THEN

3071: END IF;
3072:
3073:
3074: -- Initialize message list if p_init_msg_list is set to TRUE.
3075: IF FND_API.to_Boolean(p_init_msg_list) THEN
3076: FND_MSG_PUB.initialize;
3077: END IF;
3078:
3079: IF l_DEBUG in ('Y', 'C') THEN

Line 3107: p_encoded => FND_API.G_FALSE,

3103: cep_standard.debug('CE_VALIDATE_CD: ' || 'UNIQUE VALIDATION CHECK for bank end' );
3104: END IF;
3105:
3106: FND_MSG_PUB.Count_And_Get(
3107: p_encoded => FND_API.G_FALSE,
3108: p_count => x_msg_count,
3109: p_data => x_msg_data);
3110:
3111: IF x_msg_count > 0 THEN

Line 3112: x_return_status := fnd_api.g_ret_sts_error;

3108: p_count => x_msg_count,
3109: p_data => x_msg_data);
3110:
3111: IF x_msg_count > 0 THEN
3112: x_return_status := fnd_api.g_ret_sts_error;
3113: END IF;
3114:
3115: IF l_DEBUG in ('Y', 'C') THEN
3116: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique - P_COUNT: '|| x_msg_count||

Line 3170: x_return_status := fnd_api.g_ret_sts_success;

3166: IF l_DEBUG in ('Y', 'C') THEN
3167: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bank');
3168: END IF;
3169: -- initialize API return status to success.
3170: x_return_status := fnd_api.g_ret_sts_success;
3171:
3172: COUNTRY_NAME := X_COUNTRY_NAME;
3173: X_VALUE_OUT := X_BANK_NUMBER;
3174:

Line 3182: IF FND_API.to_Boolean(p_init_msg_list) THEN

3178: END IF;
3179:
3180:
3181: -- Initialize message list if p_init_msg_list is set to TRUE.
3182: IF FND_API.to_Boolean(p_init_msg_list) THEN
3183: FND_MSG_PUB.initialize;
3184: END IF;
3185:
3186: IF l_DEBUG in ('Y', 'C') THEN

Line 3295: p_encoded => FND_API.G_FALSE,

3291:
3292: END IF; /** country check for bank **/
3293:
3294: FND_MSG_PUB.Count_And_Get(
3295: p_encoded => FND_API.G_FALSE,
3296: p_count => x_msg_count,
3297: p_data => x_msg_data);
3298:
3299: IF x_msg_count > 0 THEN

Line 3300: x_return_status := fnd_api.g_ret_sts_error;

3296: p_count => x_msg_count,
3297: p_data => x_msg_data);
3298:
3299: IF x_msg_count > 0 THEN
3300: x_return_status := fnd_api.g_ret_sts_error;
3301: END IF;
3302:
3303: IF l_DEBUG in ('Y', 'C') THEN
3304: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate - P_COUNT: '|| x_msg_count||

Line 7669: x_return_status := fnd_api.g_ret_sts_success;

7665: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM');
7666: END IF;
7667:
7668: -- initialize API return status to success.
7669: x_return_status := fnd_api.g_ret_sts_success;
7670:
7671: COUNTRY_NAME := X_COUNTRY_NAME;
7672:
7673: IF l_DEBUG in ('Y', 'C') THEN

Line 7678: IF FND_API.to_Boolean(p_init_msg_list) THEN

7674: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM - COUNTRY_NAME: '|| COUNTRY_NAME);
7675: END IF;
7676:
7677: -- Initialize message list if p_init_msg_list is set to TRUE.
7678: IF FND_API.to_Boolean(p_init_msg_list) THEN
7679: FND_MSG_PUB.initialize;
7680: END IF;
7681:
7682: IF l_DEBUG in ('Y', 'C') THEN

Line 7721: p_encoded => FND_API.G_FALSE,

7717: END IF; -- end of country_name
7718:
7719:
7720: FND_MSG_PUB.Count_And_Get(
7721: p_encoded => FND_API.G_FALSE,
7722: p_count => x_msg_count,
7723: p_data => x_msg_data);
7724:
7725: IF x_msg_count > 0 THEN

Line 7726: x_return_status := fnd_api.g_ret_sts_error;

7722: p_count => x_msg_count,
7723: p_data => x_msg_data);
7724:
7725: IF x_msg_count > 0 THEN
7726: x_return_status := fnd_api.g_ret_sts_error;
7727: END IF;
7728:
7729: IF l_DEBUG in ('Y', 'C') THEN
7730: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_misc_eft_num - P_COUNT: '|| x_msg_count||

Line 7788: x_return_status := fnd_api.g_ret_sts_success;

7784: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT');
7785: END IF;
7786:
7787: -- initialize API return status to success.
7788: x_return_status := fnd_api.g_ret_sts_success;
7789:
7790: COUNTRY_NAME := X_COUNTRY_NAME;
7791:
7792: IF l_DEBUG in ('Y', 'C') THEN

Line 7797: IF FND_API.to_Boolean(p_init_msg_list) THEN

7793: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT - COUNTRY_NAME: '|| COUNTRY_NAME);
7794: END IF;
7795:
7796: -- Initialize message list if p_init_msg_list is set to TRUE.
7797: IF FND_API.to_Boolean(p_init_msg_list) THEN
7798: FND_MSG_PUB.initialize;
7799: END IF;
7800:
7801: IF l_DEBUG in ('Y', 'C') THEN

Line 7822: p_encoded => FND_API.G_FALSE,

7818: END IF; -- end of country_name
7819:
7820:
7821: FND_MSG_PUB.Count_And_Get(
7822: p_encoded => FND_API.G_FALSE,
7823: p_count => x_msg_count,
7824: p_data => x_msg_data);
7825:
7826: IF x_msg_count > 0 THEN

Line 7827: x_return_status := fnd_api.g_ret_sts_error;

7823: p_count => x_msg_count,
7824: p_data => x_msg_data);
7825:
7826: IF x_msg_count > 0 THEN
7827: x_return_status := fnd_api.g_ret_sts_error;
7828: END IF;
7829:
7830: IF l_DEBUG in ('Y', 'C') THEN
7831: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_misc_acct_hldr_alt - P_COUNT: '|| x_msg_count||

Line 7936: x_return_status := fnd_api.g_ret_sts_success;

7932: cep_standard.debug('>>CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');
7933: END IF;
7934:
7935: -- initialize API return status to success.
7936: x_return_status := fnd_api.g_ret_sts_success;
7937:
7938: COUNTRY_NAME := X_COUNTRY_NAME;
7939:
7940: X_VALUE_OUT := X_BRANCH_NUMBER;

Line 7948: IF FND_API.to_Boolean(p_init_msg_list) THEN

7944: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7945: END IF;
7946:
7947: -- Initialize message list if p_init_msg_list is set to TRUE.
7948: IF FND_API.to_Boolean(p_init_msg_list) THEN
7949: FND_MSG_PUB.initialize;
7950: END IF;
7951:
7952: IF l_DEBUG in ('Y', 'C') THEN

Line 8010: p_encoded => FND_API.G_FALSE,

8006: fail_mandatory;
8007: END IF;
8008:
8009: FND_MSG_PUB.Count_And_Get(
8010: p_encoded => FND_API.G_FALSE,
8011: p_count => x_msg_count,
8012: p_data => x_msg_data);
8013:
8014: IF x_msg_count > 0 THEN

Line 8015: x_return_status := fnd_api.g_ret_sts_error;

8011: p_count => x_msg_count,
8012: p_data => x_msg_data);
8013:
8014: IF x_msg_count > 0 THEN
8015: x_return_status := fnd_api.g_ret_sts_error;
8016: END IF;
8017:
8018: IF l_DEBUG in ('Y', 'C') THEN
8019: cep_standard.debug('P_COUNT: '|| x_msg_count||