DBA Data[Home] [Help]

APPS.CSI_GENERIC_GRP dependencies on FND_MSG_PUB

Line 127: fnd_msg_pub.initialize;

123:
124:
125: IF fnd_api.to_boolean( p_init_msg_list )
126: THEN
127: fnd_msg_pub.initialize;
128: END IF;
129:
130: x_return_status := fnd_api.g_ret_sts_success;
131:

Line 287: fnd_msg_pub.count_and_get

283: THEN
284: COMMIT WORK;
285: END IF;
286:
287: fnd_msg_pub.count_and_get
288: ( p_count => x_msg_count,
289: p_data => x_msg_data
290: );
291:

Line 296: fnd_msg_pub.count_and_get

292: EXCEPTION
293: WHEN fnd_api.g_exc_error THEN
294: ROLLBACK TO Create_extended_attrib_grp;
295: x_return_status := fnd_api.g_ret_sts_error ;
296: fnd_msg_pub.count_and_get
297: (p_count => x_msg_count ,
298: p_data => x_msg_data
299: );
300:

Line 304: fnd_msg_pub.count_and_get

300:
301: WHEN fnd_api.g_exc_unexpected_error THEN
302: ROLLBACK TO Create_extended_attrib_grp;
303: x_return_status := fnd_api.g_ret_sts_unexp_error ;
304: fnd_msg_pub.count_and_get
305: (p_count => x_msg_count ,
306: p_data => x_msg_data
307: );
308:

Line 312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

308:
309: WHEN OTHERS THEN
310: ROLLBACK TO Create_extended_attrib_grp;
311: x_return_status := fnd_api.g_ret_sts_unexp_error ;
312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
313: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
314: END IF;
315: fnd_msg_pub.count_and_get
316: (p_count => x_msg_count ,

Line 313: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

309: WHEN OTHERS THEN
310: ROLLBACK TO Create_extended_attrib_grp;
311: x_return_status := fnd_api.g_ret_sts_unexp_error ;
312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
313: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
314: END IF;
315: fnd_msg_pub.count_and_get
316: (p_count => x_msg_count ,
317: p_data => x_msg_data

Line 315: fnd_msg_pub.count_and_get

311: x_return_status := fnd_api.g_ret_sts_unexp_error ;
312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
313: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
314: END IF;
315: fnd_msg_pub.count_and_get
316: (p_count => x_msg_count ,
317: p_data => x_msg_data
318: );
319:

Line 383: fnd_msg_pub.initialize;

379: l_ext_lookup_type VARCHAR2(30):= 'CSI_IEA_LEVEL_CODE';
380: BEGIN
381: IF fnd_api.to_boolean( p_init_msg_list )
382: THEN
383: fnd_msg_pub.initialize;
384: END IF;
385: x_return_status := fnd_api.g_ret_sts_success;
386:
387: IF p_validation_mode='CREATE' THEN

Line 409: fnd_msg_pub.add;

405: AND p_ext_attrib_rec.instance_id <> fnd_api.g_miss_num)
406: )
407: THEN
408: fnd_message.set_name('CSI', 'CSI_PASS_NULL_PARAMS');
409: fnd_msg_pub.add;
410: x_return_status := fnd_api.g_ret_sts_error;
411: END IF;
412: END IF; --End if Global
413:

Line 425: fnd_msg_pub.add;

421: AND p_ext_attrib_rec.instance_id <> fnd_api.g_miss_num)
422: )
423: THEN
424: fnd_message.set_name('CSI', 'CSI_PASS_CAT_PARAMS');
425: fnd_msg_pub.add;
426: x_return_status := fnd_api.g_ret_sts_error;
427: ELSIF ( (p_ext_attrib_rec.item_category_id IS NULL)
428: OR (p_ext_attrib_rec.item_category_id = fnd_api.g_miss_num) )
429: THEN

Line 431: fnd_msg_pub.add;

427: ELSIF ( (p_ext_attrib_rec.item_category_id IS NULL)
428: OR (p_ext_attrib_rec.item_category_id = fnd_api.g_miss_num) )
429: THEN
430: fnd_message.set_name('CSI', 'CSI_MISSING_CAT_PARAMETER');
431: fnd_msg_pub.add;
432: x_return_status := fnd_api.g_ret_sts_error;
433: ELSE
434: l_dummy := NULL;
435: BEGIN

Line 446: fnd_msg_pub.add;

442: EXCEPTION
443: WHEN NO_DATA_FOUND THEN
444: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETER');
445: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.item_category_id);
446: fnd_msg_pub.add;
447: x_return_status := fnd_api.g_ret_sts_error;
448: END;
449: END IF;
450: END IF; --End If Category

Line 461: fnd_msg_pub.add;

457: AND p_ext_attrib_rec.instance_id <> fnd_api.g_miss_num)
458: )
459: THEN
460: fnd_message.set_name('CSI', 'CSI_PASS_ITEM_PARAMS');
461: fnd_msg_pub.add;
462: x_return_status := fnd_api.g_ret_sts_error;
463: ELSIF ( (p_ext_attrib_rec.inventory_item_id IS NULL
464: OR p_ext_attrib_rec.inventory_item_id = fnd_api.g_miss_num)
465: OR (p_ext_attrib_rec.master_organization_id IS NULL

Line 469: fnd_msg_pub.add;

465: OR (p_ext_attrib_rec.master_organization_id IS NULL
466: OR p_ext_attrib_rec.master_organization_id = fnd_api.g_miss_num) )
467: THEN
468: fnd_message.set_name('CSI', 'CSI_MISSING_ITEM_PARAMETER');
469: fnd_msg_pub.add;
470: x_return_status := fnd_api.g_ret_sts_error;
471: ELSE
472: l_dummy := NULL;
473: BEGIN

Line 482: fnd_msg_pub.add;

478: AND inventory_item_id = p_ext_attrib_rec.inventory_item_id;
479: EXCEPTION
480: WHEN NO_DATA_FOUND THEN
481: fnd_message.set_name('CSI', 'CSI_INVALID_ITEM_PARAMETER');
482: fnd_msg_pub.add;
483: x_return_status := fnd_api.g_ret_sts_error;
484: END;
485: END IF;
486: END IF; --End If Item

Line 499: fnd_msg_pub.add;

495: AND p_ext_attrib_rec.item_category_id <> fnd_api.g_miss_num)
496: )
497: THEN
498: fnd_message.set_name('CSI', 'CSI_PASS_INS_PARAMS');
499: fnd_msg_pub.add;
500: x_return_status := fnd_api.g_ret_sts_error;
501: ELSIF ( (p_ext_attrib_rec.instance_id IS NULL
502: OR p_ext_attrib_rec.instance_id = fnd_api.g_miss_num) )
503: THEN

Line 505: fnd_msg_pub.add;

501: ELSIF ( (p_ext_attrib_rec.instance_id IS NULL
502: OR p_ext_attrib_rec.instance_id = fnd_api.g_miss_num) )
503: THEN
504: fnd_message.set_name('CSI', 'CSI_MISSING_INS_PARAMETER');
505: fnd_msg_pub.add;
506: x_return_status := fnd_api.g_ret_sts_error;
507: ELSE
508: l_dummy := NULL;
509: BEGIN

Line 518: fnd_msg_pub.add;

514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: fnd_message.set_name('CSI', 'CSI_INVALID_INS_PARAMETER');
517: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.instance_id);
518: fnd_msg_pub.add;
519: x_return_status := fnd_api.g_ret_sts_error;
520: END;
521: END IF;
522: END IF; -- end if instance

Line 527: fnd_msg_pub.add;

523: EXCEPTION
524: WHEN no_data_found THEN
525: fnd_message.set_name('CSI', 'CSI_INVALID_AL_PARAMETER');
526: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.attribute_level);
527: fnd_msg_pub.add;
528: x_return_status := fnd_api.g_ret_sts_error;
529: END;--End for csi_lookups
530: ELSE -- Else if p_ext_attrib_rec.attribute_level IS NULL
531: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');

Line 533: fnd_msg_pub.add;

529: END;--End for csi_lookups
530: ELSE -- Else if p_ext_attrib_rec.attribute_level IS NULL
531: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');
532: fnd_message.set_token('PARAMETER','ATTRIBUTE_LEVEL');
533: fnd_msg_pub.add;
534: x_return_status := fnd_api.g_ret_sts_error;
535: END IF;--End if p_ext_attrib_rec.attribute_level IS NOT NULL
536: END IF; --End if p_validation_mode='CREATE'
537:

Line 538: fnd_msg_pub.count_and_get

534: x_return_status := fnd_api.g_ret_sts_error;
535: END IF;--End if p_ext_attrib_rec.attribute_level IS NOT NULL
536: END IF; --End if p_validation_mode='CREATE'
537:
538: fnd_msg_pub.count_and_get
539: ( p_count => x_msg_count,
540: p_data => x_msg_data
541: );
542: END;

Line 558: fnd_msg_pub.initialize;

554: l_attrib_lookup_type VARCHAR2(30):= 'CSI_EXTEND_ATTRIB_POOL';
555: BEGIN
556: IF fnd_api.to_boolean( p_init_msg_list )
557: THEN
558: fnd_msg_pub.initialize;
559: END IF;
560: x_return_status := fnd_api.g_ret_sts_success;
561:
562: IF p_validation_mode='CREATE' THEN

Line 574: fnd_msg_pub.add;

570: EXCEPTION
571: WHEN NO_DATA_FOUND THEN
572: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETER');
573: fnd_message.set_token('PARAMETER',p_attribute_code);
574: fnd_msg_pub.add;
575: x_return_status := fnd_api.g_ret_sts_error;
576: END;
577: ELSE
578: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');

Line 580: fnd_msg_pub.add;

576: END;
577: ELSE
578: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');
579: fnd_message.set_token('PARAMETER','ATTRIBUTE_CODE');
580: fnd_msg_pub.add;
581: x_return_status := fnd_api.g_ret_sts_error;
582: END IF;
583: END IF;
584: END;

Line 600: fnd_msg_pub.initialize;

596: l_cat_lookup_type VARCHAR2(30) := 'CSI_IEA_CATEGORY';
597: BEGIN
598: IF fnd_api.to_boolean( p_init_msg_list )
599: THEN
600: fnd_msg_pub.initialize;
601: END IF;
602: x_return_status := fnd_api.g_ret_sts_success;
603:
604: IF p_validation_mode='CREATE' THEN

Line 616: fnd_msg_pub.add;

612: EXCEPTION
613: WHEN NO_DATA_FOUND THEN
614: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETER');
615: fnd_message.set_token('PARAMETER',p_attribute_category);
616: fnd_msg_pub.add;
617: x_return_status := fnd_api.g_ret_sts_error;
618: END;
619: END IF;
620: END IF;

Line 636: fnd_msg_pub.initialize;

632: l_dummy VARCHAR2(1);
633: BEGIN
634: IF fnd_api.to_boolean( p_init_msg_list )
635: THEN
636: fnd_msg_pub.initialize;
637: END IF;
638: x_return_status := fnd_api.g_ret_sts_success;
639:
640: IF p_validation_mode='CREATE' THEN

Line 644: fnd_msg_pub.add;

640: IF p_validation_mode='CREATE' THEN
641: IF ( (p_attribute_name IS NULL) OR (p_attribute_name = fnd_api.g_miss_char) ) THEN
642: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');
643: fnd_message.set_token('PARAMETER','ATTRIBUTE_NAME');
644: fnd_msg_pub.add;
645: x_return_status := fnd_api.g_ret_sts_error;
646: END IF;
647: END IF;
648: END;