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.AS_INTEREST_CODES_PUB dependencies on FND_MSG_PUB

Line 137: FND_MSG_PUB.DELETE_MSG;

133: BEGIN
134: -- Standard Start of API SavePoint
135: SAVEPOINT create_interest_code_PUB;
136:
137: FND_MSG_PUB.DELETE_MSG;
138:
139: -- Initialize message list if p_init_msg_list is set to TRUE.
140: IF FND_API.to_Boolean( p_init_msg_list ) THEN
141: FND_MSG_PUB.initialize;

Line 141: FND_MSG_PUB.initialize;

137: FND_MSG_PUB.DELETE_MSG;
138:
139: -- Initialize message list if p_init_msg_list is set to TRUE.
140: IF FND_API.to_Boolean( p_init_msg_list ) THEN
141: FND_MSG_PUB.initialize;
142: END IF;
143:
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 164: FND_MSG_PUB.Add;

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:
168: IF p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM

Line 173: FND_MSG_PUB.Add;

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:
177: IF p_interest_code_rec.master_enabled_flag NOT IN ('N','Y')

Line 183: FND_MSG_PUB.Add;

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:
187: -- Check for Who columns to see if they values passed is G_MISS

Line 434: FND_MSG_PUB.Add;

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;
438: CLOSE as_int_code_cur;

Line 448: FND_MSG_PUB.Add;

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;
452: CLOSE as_int_type_cur;

Line 467: FND_MSG_PUB.Add;

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;
471: CLOSE as_int_codes_vl_cur;

Line 484: FND_MSG_PUB.Add;

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;
488: CLOSE as_int_codes_vl_1_cur;

Line 518: fnd_msg_pub.add;

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:
522: -- Insert a New Interest Code into table

Line 570: FND_MSG_PUB.Count_And_Get(

566: END IF;
567:
568: -- Standard call to get message count and if count is 1,
569: -- get message info.
570: FND_MSG_PUB.Count_And_Get(
571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );
574: EXCEPTION

Line 580: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

576: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
577: P_MODULE => l_module
578: ,P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
581: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
582: ,X_MSG_COUNT => X_MSG_COUNT
583: ,X_MSG_DATA => X_MSG_DATA
584: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

587: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
588: P_MODULE => l_module
589: ,P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME
591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
592: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
593: ,X_MSG_COUNT => X_MSG_COUNT
594: ,X_MSG_DATA => X_MSG_DATA
595: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 794: FND_MSG_PUB.DELETE_MSG;

790:
791: -- Standard STart of API SavePoint
792: SAVEPOINT update_interest_code_PUB;
793:
794: FND_MSG_PUB.DELETE_MSG;
795:
796: -- Initialize message list if p_init_msg_list is set to TRUE.
797: IF FND_API.to_Boolean( p_init_msg_list ) THEN
798: FND_MSG_PUB.initialize;

Line 798: FND_MSG_PUB.initialize;

794: FND_MSG_PUB.DELETE_MSG;
795:
796: -- Initialize message list if p_init_msg_list is set to TRUE.
797: IF FND_API.to_Boolean( p_init_msg_list ) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: -- Standard call to check for call compatibility.
802: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 822: FND_MSG_PUB.Add;

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:
826: IF (p_interest_code_rec.interest_type_id = FND_API.G_MISS_NUM )

Line 831: FND_MSG_PUB.Add;

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);
835: FETCH validate_interest_type_cur INTO l_count;

Line 934: FND_MSG_PUB.Add;

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
938: x_parent_interest_code_id := p_interest_code_rec.parent_interest_code_id;

Line 950: FND_MSG_PUB.Add;

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;
954: END IF;

Line 1127: FND_MSG_PUB.Add;

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;
1131: CLOSE as_int_codes_vl_cur;

Line 1145: FND_MSG_PUB.Add;

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;
1149: CLOSE as_int_codes_vl_1_cur;

Line 1168: fnd_msg_pub.add;

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:
1172: -- Lock the row for update. Check to see if the fetched value is same still.

Line 1188: fnd_msg_pub.add;

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:
1192: -- Update the Row using the API

Line 1239: FND_MSG_PUB.Count_And_Get(

1235: END IF;
1236:
1237: -- Standard call to get message count and if count is 1,
1238: -- get message info.
1239: FND_MSG_PUB.Count_And_Get(
1240: p_count => x_msg_count,
1241: p_data => x_msg_data
1242: );
1243:

Line 1250: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1247: P_MODULE => l_module
1248: ,P_API_NAME => L_API_NAME
1249: ,P_PKG_NAME => G_PKG_NAME
1250: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1251: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1252: ,X_MSG_COUNT => X_MSG_COUNT
1253: ,X_MSG_DATA => X_MSG_DATA
1254: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1257: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1258: P_MODULE => l_module
1259: ,P_API_NAME => L_API_NAME
1260: ,P_PKG_NAME => G_PKG_NAME
1261: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1262: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1263: ,X_MSG_COUNT => X_MSG_COUNT
1264: ,X_MSG_DATA => X_MSG_DATA
1265: ,X_RETURN_STATUS => X_RETURN_STATUS);