DBA Data[Home] [Help]

APPS.AS_INTEREST_TYPES_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.initialize;

94: SAVEPOINT create_interest_type_PUB;
95:
96: -- Initialize message list if p_init_msg_list is set to TRUE.
97: IF FND_API.to_Boolean( p_init_msg_list ) THEN
98: FND_MSG_PUB.initialize;
99: END IF;
100:
101:
102: -- Standard call to check for call compatibility.

Line 238: FND_MSG_PUB.Add;

234: -- Check if Required Values have been passed
235: IF ( l_master_enabled_flag NOT IN ('N','Y') ) THEN
236: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
237: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',l_master_enabled_flag);
238: FND_MSG_PUB.Add;
239: END IF;
240:
241: IF ( l_interest_type = FND_API.G_MISS_CHAR
242: OR TRIM(l_interest_type) IS NULL) THEN

Line 245: FND_MSG_PUB.Add;

241: IF ( l_interest_type = FND_API.G_MISS_CHAR
242: OR TRIM(l_interest_type) IS NULL) THEN
243: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE');
244: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE',l_interest_type);
245: FND_MSG_PUB.Add;
246: END IF;
247:
248: IF ( l_company_classification_flag NOT IN ('N','Y') ) THEN
249: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_COMP_CLAS_FLAG');

Line 251: FND_MSG_PUB.Add;

247:
248: IF ( l_company_classification_flag NOT IN ('N','Y') ) THEN
249: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_COMP_CLAS_FLAG');
250: FND_MESSAGE.SET_TOKEN('COMPANY_CLASSIFICATION_FLAG',l_company_classification_flag);
251: FND_MSG_PUB.Add;
252: END IF;
253:
254: IF ( l_contact_interest_flag NOT IN ('N','Y') ) THEN
255: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_CONT_INT_FLAG');

Line 257: FND_MSG_PUB.Add;

253:
254: IF ( l_contact_interest_flag NOT IN ('N','Y') ) THEN
255: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_CONT_INT_FLAG');
256: FND_MESSAGE.SET_TOKEN('CONTACT_INTEREST_FLAG',l_contact_interest_flag);
257: FND_MSG_PUB.Add;
258: END IF;
259:
260: IF ( l_lead_classification_flag NOT IN ('N','Y') ) THEN
261: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_LEAD_CLAS_FLAG');

Line 263: FND_MSG_PUB.Add;

259:
260: IF ( l_lead_classification_flag NOT IN ('N','Y') ) THEN
261: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_LEAD_CLAS_FLAG');
262: FND_MESSAGE.SET_TOKEN('LEAD_CLASSIFICATION_FLAG',l_lead_classification_flag);
263: FND_MSG_PUB.Add;
264: END IF;
265:
266: IF ( l_expected_purchase_flag NOT IN ('N','Y') ) THEN
267: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_EXP_PURC_FLAG');

Line 269: FND_MSG_PUB.Add;

265:
266: IF ( l_expected_purchase_flag NOT IN ('N','Y') ) THEN
267: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_EXP_PURC_FLAG');
268: FND_MESSAGE.SET_TOKEN('EXPECTED_PURCHASE_FLAG',l_expected_purchase_flag);
269: FND_MSG_PUB.Add;
270: END IF;
271:
272: IF ( l_current_environment_flag NOT IN ('N','Y') ) THEN
273: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_CURR_ENVT_FLAG');

Line 275: FND_MSG_PUB.Add;

271:
272: IF ( l_current_environment_flag NOT IN ('N','Y') ) THEN
273: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_CURR_ENVT_FLAG');
274: FND_MESSAGE.SET_TOKEN('CURRENT_ENVIRONMENT_FLAG',l_current_environment_flag);
275: FND_MSG_PUB.Add;
276: END IF;
277:
278: IF ( l_enabled_flag NOT IN ('N','Y') ) THEN
279: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_ENABLED_FLAG');

Line 281: FND_MSG_PUB.Add;

277:
278: IF ( l_enabled_flag NOT IN ('N','Y') ) THEN
279: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_ENABLED_FLAG');
280: FND_MESSAGE.SET_TOKEN('ENABLED_FLAG',l_enabled_flag);
281: FND_MSG_PUB.Add;
282: END IF;
283:
284: IF ( l_org_id = FND_API.G_MISS_NUM
285: OR TRIM(l_org_id) IS NULL ) THEN

Line 288: FND_MSG_PUB.Add;

284: IF ( l_org_id = FND_API.G_MISS_NUM
285: OR TRIM(l_org_id) IS NULL ) THEN
286: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_ORG_ID');
287: FND_MESSAGE.SET_TOKEN('ORG_ID',l_org_id);
288: FND_MSG_PUB.Add;
289: END IF;
290:
291: -- Raise exception if error
292: IF (FND_MSG_PUB.COUNT_MSG > 0)

Line 292: IF (FND_MSG_PUB.COUNT_MSG > 0)

288: FND_MSG_PUB.Add;
289: END IF;
290:
291: -- Raise exception if error
292: IF (FND_MSG_PUB.COUNT_MSG > 0)
293: THEN
294: RAISE fnd_api.g_exc_error;
295: END IF;
296:

Line 304: fnd_msg_pub.add;

300: IF (interest_dup_cur%FOUND)
301: THEN
302: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
303: --FND_MESSAGE.SET_NAME ( 'AS' , 'AS_DUPLICATE_INTEREST_TYPE');
304: fnd_msg_pub.add;
305: CLOSE interest_dup_cur;
306: RAISE fnd_api.g_exc_error;
307: ELSE
308: -- get nextval for interest type id

Line 335: fnd_msg_pub.add;

331: end if;
332:
333: if (l_prod_cat_not_found = 'Y') THEN
334: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');
335: fnd_msg_pub.add;
336: RAISE fnd_api.g_exc_error;
337: end if;
338:
339: -- Insert a New Interest Type into table

Line 371: FND_MSG_PUB.Count_And_Get(

367:
368: -- Standard call to get message count and if count is 1,
369: -- get message info.
370:
371: FND_MSG_PUB.Count_And_Get(
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375:

Line 382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

378: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
379: P_MODULE => l_module
380: ,P_API_NAME => L_API_NAME
381: ,P_PKG_NAME => G_PKG_NAME
382: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
383: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
384: ,X_MSG_COUNT => X_MSG_COUNT
385: ,X_MSG_DATA => X_MSG_DATA
386: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

389: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
390: P_MODULE => l_module
391: ,P_API_NAME => L_API_NAME
392: ,P_PKG_NAME => G_PKG_NAME
393: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
394: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
395: ,X_MSG_COUNT => X_MSG_COUNT
396: ,X_MSG_DATA => X_MSG_DATA
397: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 527: FND_MSG_PUB.initialize;

523: SAVEPOINT update_interest_type_PUB;
524:
525: -- Initialize message list if p_init_msg_list is set to TRUE.
526: IF FND_API.to_Boolean( p_init_msg_list ) THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:
530: -- Standard call to check for call compatibility.
531: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 550: FND_MSG_PUB.Add;

546: OR TRIM(p_interest_type_rec.interest_type_id) IS NULL THEN
547: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_INT_TYPE_ID');
548: FND_MESSAGE.SET_TOKEN('INTEREST_TYPE_ID',
549: p_interest_type_rec.interest_type_id);
550: FND_MSG_PUB.Add;
551: END IF;
552:
553:
554: -- Check if the values are passed, if the g_miss values are passed then

Line 734: FND_MSG_PUB.Add;

730: IF x_master_enabled_flag NOT IN ('N','Y')
731: THEN
732: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_MAST_ENAB_FLAG');
733: FND_MESSAGE.SET_TOKEN('MASTER_ENABLED_FLAG',p_interest_type_rec.master_enabled_flag);
734: FND_MSG_PUB.Add;
735: END IF;
736:
737: IF x_contact_interest_flag NOT IN ('N','Y')
738: THEN

Line 741: FND_MSG_PUB.Add;

737: IF x_contact_interest_flag NOT IN ('N','Y')
738: THEN
739: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_CONT_INT_FLAG');
740: FND_MESSAGE.SET_TOKEN('CONTACT_INTEREST_FLAG',p_interest_type_rec.contact_interest_flag);
741: FND_MSG_PUB.Add;
742: END IF;
743:
744: IF x_company_classification_flag NOT IN ('N','Y')
745: THEN

Line 748: FND_MSG_PUB.Add;

744: IF x_company_classification_flag NOT IN ('N','Y')
745: THEN
746: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_COMP_CLAS_FLAG');
747: FND_MESSAGE.SET_TOKEN('COMPANY_CLASSIFICAITON_FLAG',p_interest_type_rec.company_classification_flag);
748: FND_MSG_PUB.Add;
749: END IF;
750:
751: IF x_lead_classification_flag NOT IN ('N','Y')
752: THEN

Line 755: FND_MSG_PUB.Add;

751: IF x_lead_classification_flag NOT IN ('N','Y')
752: THEN
753: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_LEAD_CLAS_FLAG');
754: FND_MESSAGE.SET_TOKEN('LEAD_CLASSIFICATION_FLAG',p_interest_type_rec.lead_classification_flag);
755: FND_MSG_PUB.Add;
756: END IF;
757:
758:
759: IF x_expected_purchase_flag NOT IN ('N','Y')

Line 763: FND_MSG_PUB.Add;

759: IF x_expected_purchase_flag NOT IN ('N','Y')
760: THEN
761: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_EXP_PURC_FLAG');
762: FND_MESSAGE.SET_TOKEN('EXPECTED_PURCHASE_FLAG',p_interest_type_rec.expected_purchase_flag);
763: FND_MSG_PUB.Add;
764: END IF;
765:
766:
767: IF x_current_environment_flag NOT IN ('N','Y')

Line 771: FND_MSG_PUB.Add;

767: IF x_current_environment_flag NOT IN ('N','Y')
768: THEN
769: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_CURR_ENVT_FLAG');
770: FND_MESSAGE.SET_TOKEN('CURRENT_ENVIRONMENT_FLAG',p_interest_type_rec.current_environment_flag);
771: FND_MSG_PUB.Add;
772: END IF;
773:
774:
775: IF x_enabled_flag NOT IN ('N','Y')

Line 779: FND_MSG_PUB.Add;

775: IF x_enabled_flag NOT IN ('N','Y')
776: THEN
777: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_ENABLED_FLAG');
778: FND_MESSAGE.SET_TOKEN('ENABLED_FLAG',p_interest_type_rec.enabled_flag);
779: FND_MSG_PUB.Add;
780: END IF;
781:
782: IF x_org_id = FND_API.G_MISS_NUM
783: THEN

Line 786: FND_MSG_PUB.Add;

782: IF x_org_id = FND_API.G_MISS_NUM
783: THEN
784: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_ORG_ID');
785: FND_MESSAGE.SET_TOKEN('ORG_ID',p_interest_type_rec.org_id);
786: FND_MSG_PUB.Add;
787: END IF;
788:
789: IF (FND_MSG_PUB.COUNT_MSG > 0)
790: THEN

Line 789: IF (FND_MSG_PUB.COUNT_MSG > 0)

785: FND_MESSAGE.SET_TOKEN('ORG_ID',p_interest_type_rec.org_id);
786: FND_MSG_PUB.Add;
787: END IF;
788:
789: IF (FND_MSG_PUB.COUNT_MSG > 0)
790: THEN
791: RAISE fnd_api.g_exc_error;
792: END IF;
793:

Line 801: FND_MSG_PUB.Add;

797: FETCH as_int_type_cur INTO l_count;
798: IF as_int_type_cur%FOUND
799: THEN
800: FND_MESSAGE.SET_NAME('ASF', 'ASF_ADM_DUPLICATE');
801: FND_MSG_PUB.Add;
802: CLOSE as_int_type_cur;
803: RAISE FND_API.G_EXC_ERROR;
804: END IF;
805: CLOSE as_int_type_cur;

Line 823: fnd_msg_pub.add;

819: end if;
820:
821: if (l_prod_cat_not_found = 'Y') THEN
822: FND_MESSAGE.SET_NAME ( 'AS' , 'AS_INVALID_PRODUCT_CATEGORY');
823: fnd_msg_pub.add;
824: RAISE fnd_api.g_exc_error;
825: end if;
826:
827: -- Lock the row for update. Check to see if the fetched value is same still.

Line 843: fnd_msg_pub.add;

839: IF l_last_update_date <> l_current_last_update_date
840: THEN
841: fnd_message.set_name('AS', 'API_RECORD_CHANGED');
842: FND_MESSAGE.Set_Token('INFO', 'interest_type', FALSE); -- ??
843: fnd_msg_pub.add;
844: RAISE fnd_api.g_exc_unexpected_error;
845: END IF;
846:
847: -- update Interest Type ID in the table

Line 876: FND_MSG_PUB.Count_And_Get(

872: END IF;
873:
874: -- Standard call to get message count and if count is 1, get
875: -- message info.
876: FND_MSG_PUB.Count_And_Get(
877: p_count => x_msg_count,
878: p_data => x_msg_data
879: );
880: EXCEPTION

Line 886: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

882: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
883: P_MODULE => l_module
884: ,P_API_NAME => L_API_NAME
885: ,P_PKG_NAME => G_PKG_NAME
886: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
887: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
888: ,X_MSG_COUNT => X_MSG_COUNT
889: ,X_MSG_DATA => X_MSG_DATA
890: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

893: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
894: P_MODULE => l_module
895: ,P_API_NAME => L_API_NAME
896: ,P_PKG_NAME => G_PKG_NAME
897: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
898: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
899: ,X_MSG_COUNT => X_MSG_COUNT
900: ,X_MSG_DATA => X_MSG_DATA
901: ,X_RETURN_STATUS => X_RETURN_STATUS);