DBA Data[Home] [Help]

APPS.AS_INTEREST_CODES_PUB dependencies on FND_MESSAGE

Line 162: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');

158: -- Check if Required Values have been passed
159: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR
160: OR TRIM(p_interest_code_rec.code) IS NULL
161: THEN
162: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
163: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);
164: FND_MSG_PUB.Add;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;

Line 163: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);

159: IF p_interest_code_rec.code = FND_API.G_MISS_CHAR
160: OR TRIM(p_interest_code_rec.code) IS NULL
161: THEN
162: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
163: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);
164: FND_MSG_PUB.Add;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:

Line 171: FND_MESSAGE.SET_NAME ( 'ASF' , 'ASF_MISSING_INTEREST_TYPE');

167:
168: IF p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM
169: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL
170: THEN
171: FND_MESSAGE.SET_NAME ( 'ASF' , 'ASF_MISSING_INTEREST_TYPE');
172: --FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
173: FND_MSG_PUB.Add;
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;

Line 172: --FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);

168: IF p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM
169: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL
170: THEN
171: FND_MESSAGE.SET_NAME ( 'ASF' , 'ASF_MISSING_INTEREST_TYPE');
172: --FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
173: FND_MSG_PUB.Add;
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:

Line 181: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');

177: IF p_interest_code_rec.master_enabled_flag NOT IN ('N','Y')
178: OR TRIM(p_interest_code_rec.master_enabled_flag) IS NULL
179: OR p_interest_code_rec.master_enabled_flag = FND_API.G_MISS_CHAR
180: THEN
181: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
182: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',p_interest_code_rec.master_enabled_flag);
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;

Line 182: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',p_interest_code_rec.master_enabled_flag);

178: OR TRIM(p_interest_code_rec.master_enabled_flag) IS NULL
179: OR p_interest_code_rec.master_enabled_flag = FND_API.G_MISS_CHAR
180: THEN
181: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
182: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',p_interest_code_rec.master_enabled_flag);
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:

Line 432: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');

428: OPEN as_int_code_cur(p_interest_code_rec.parent_interest_code_id);
429: FETCH as_int_code_cur INTO l_count;
430: IF (as_int_code_cur%NOTFOUND)
431: THEN
432: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');
433: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);
434: FND_MSG_PUB.Add;
435: CLOSE as_int_code_cur;
436: RAISE FND_API.G_EXC_ERROR;

Line 433: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);

429: FETCH as_int_code_cur INTO l_count;
430: IF (as_int_code_cur%NOTFOUND)
431: THEN
432: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');
433: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);
434: FND_MSG_PUB.Add;
435: CLOSE as_int_code_cur;
436: RAISE FND_API.G_EXC_ERROR;
437: END IF;

Line 446: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');

442: OPEN as_int_type_cur(p_interest_code_rec.interest_type_id);
443: FETCH as_int_type_cur INTO l_count;
444: IF (as_int_type_cur%NOTFOUND)
445: THEN
446: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
447: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
448: FND_MSG_PUB.Add;
449: CLOSE as_int_type_cur;
450: RAISE FND_API.G_EXC_ERROR;

Line 447: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);

443: FETCH as_int_type_cur INTO l_count;
444: IF (as_int_type_cur%NOTFOUND)
445: THEN
446: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
447: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
448: FND_MSG_PUB.Add;
449: CLOSE as_int_type_cur;
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;

Line 466: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');

462: OPEN as_int_codes_vl_cur(TRIM(NLS_UPPER(p_interest_code_rec.code)),p_interest_code_rec.interest_type_id);
463: FETCH as_int_codes_vl_cur INTO l_count;
464: IF as_int_codes_vl_cur%FOUND
465: THEN
466: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
467: FND_MSG_PUB.Add;
468: CLOSE as_int_codes_vl_cur;
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;

Line 483: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');

479: OPEN as_int_codes_vl_1_cur(TRIM(NLS_UPPER(p_interest_code_rec.code)),p_interest_code_rec.interest_type_id,p_interest_code_rec.parent_interest_code_id);
480: FETCH as_int_codes_vl_1_cur INTO l_count;
481: IF as_int_codes_vl_1_cur%FOUND
482: THEN
483: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
484: FND_MSG_PUB.Add;
485: CLOSE as_int_codes_vl_1_cur;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;

Line 517: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');

513: l_prod_cat_not_found := 'Y';
514: end if;
515:
516: if (l_prod_cat_not_found = 'Y') THEN
517: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');
518: fnd_msg_pub.add;
519: RAISE fnd_api.g_exc_error;
520: end if;
521:

Line 820: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');

816:
817: IF (p_interest_code_rec.interest_code_id = FND_API.G_MISS_NUM)
818: OR TRIM(p_interest_code_rec.interest_code_id) IS NULL
819: THEN
820: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
821: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);
822: FND_MSG_PUB.Add;
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;

Line 821: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);

817: IF (p_interest_code_rec.interest_code_id = FND_API.G_MISS_NUM)
818: OR TRIM(p_interest_code_rec.interest_code_id) IS NULL
819: THEN
820: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_CODE');
821: --FND_MESSAGE.SET_TOKEN('INTEREST_CODE',p_interest_code_rec.code);
822: FND_MSG_PUB.Add;
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;
825:

Line 829: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');

825:
826: IF (p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM )
827: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL
828: THEN
829: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
830: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
831: FND_MSG_PUB.Add;
832: RAISE FND_API.G_EXC_ERROR;
833: ELSE

Line 830: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);

826: IF (p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM )
827: OR TRIM(p_interest_code_rec.interest_type_id) IS NULL
828: THEN
829: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
830: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',p_interest_code_rec.interest_type_id);
831: FND_MSG_PUB.Add;
832: RAISE FND_API.G_EXC_ERROR;
833: ELSE
834: OPEN validate_interest_type_cur(p_interest_code_rec.interest_type_id);

Line 932: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');

928: FETCH validate_parent_int_code_cur INTO l_count;
929: IF validate_parent_int_code_cur%NOTFOUND
930: THEN
931:
932: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');
933: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);
934: FND_MSG_PUB.Add;
935: CLOSE validate_parent_int_code_cur;
936: RAISE FND_API.G_EXC_ERROR;

Line 933: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);

929: IF validate_parent_int_code_cur%NOTFOUND
930: THEN
931:
932: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PAR_INT_CODE_ID');
933: FND_MESSAGE.SET_TOKEN('PARENT_INTEREST_CODE_ID',p_interest_code_rec.parent_interest_code_id);
934: FND_MSG_PUB.Add;
935: CLOSE validate_parent_int_code_cur;
936: RAISE FND_API.G_EXC_ERROR;
937: ELSE

Line 949: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');

945: x_master_enabled_flag := l_master_enabled_flag;
946: ELSE
947: -- make sure master enabled flag is valid
948: IF p_interest_code_rec.master_enabled_flag NOT IN ('N','Y') THEN
949: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
950: FND_MSG_PUB.Add;
951: RAISE FND_API.G_EXC_ERROR;
952: ELSE
953: x_master_enabled_flag := p_interest_code_rec.master_enabled_flag;

Line 1126: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');

1122: OPEN as_int_codes_vl_cur(p_interest_code_rec.interest_code_id,TRIM(NLS_UPPER(x_code)),p_interest_code_rec.interest_type_id);
1123: FETCH as_int_codes_vl_cur INTO l_count_ids;
1124: IF as_int_codes_vl_cur%FOUND
1125: THEN
1126: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
1127: FND_MSG_PUB.Add;
1128: CLOSE as_int_codes_vl_cur;
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;

Line 1144: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');

1140: FETCH as_int_codes_vl_1_cur INTO l_count_ids;
1141:
1142: IF as_int_codes_vl_1_cur%FOUND
1143: THEN
1144: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
1145: FND_MSG_PUB.Add;
1146: CLOSE as_int_codes_vl_1_cur;
1147: RAISE FND_API.G_EXC_ERROR;
1148: END IF;

Line 1167: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');

1163: l_prod_cat_not_found := 'Y';
1164: end if;
1165:
1166: if (l_prod_cat_not_found = 'Y') THEN
1167: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');
1168: fnd_msg_pub.add;
1169: RAISE fnd_api.g_exc_error;
1170: end if;
1171:

Line 1186: fnd_message.set_name('AS', 'API_RECORD_CHANGED');

1182: END IF;
1183:
1184: IF l_last_update_date <> l_current_last_update_date
1185: THEN
1186: fnd_message.set_name('AS', 'API_RECORD_CHANGED');
1187: FND_MESSAGE.Set_Token('INFO', 'interest_code', FALSE); -- ??
1188: fnd_msg_pub.add;
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: END IF;

Line 1187: FND_MESSAGE.Set_Token('INFO', 'interest_code', FALSE); -- ??

1183:
1184: IF l_last_update_date <> l_current_last_update_date
1185: THEN
1186: fnd_message.set_name('AS', 'API_RECORD_CHANGED');
1187: FND_MESSAGE.Set_Token('INFO', 'interest_code', FALSE); -- ??
1188: fnd_msg_pub.add;
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: END IF;
1191: