DBA Data[Home] [Help]

APPS.CSI_GENERIC_GRP dependencies on FND_MESSAGE

Line 408: fnd_message.set_name('CSI', 'CSI_PASS_NULL_PARAMS');

404: OR (p_ext_attrib_rec.instance_id IS NOT NULL
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

Line 424: fnd_message.set_name('CSI', 'CSI_PASS_CAT_PARAMS');

420: OR (p_ext_attrib_rec.instance_id IS NOT NULL
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) )

Line 430: fnd_message.set_name('CSI', 'CSI_MISSING_CAT_PARAMETER');

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
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;

Line 444: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETER');

440: AND category_set_id = ( SELECT category_set_id
441: FROM csi_install_parameters );
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;

Line 445: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.item_category_id);

441: FROM csi_install_parameters );
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;

Line 460: fnd_message.set_name('CSI', 'CSI_PASS_ITEM_PARAMS');

456: OR (p_ext_attrib_rec.instance_id IS NOT NULL
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)

Line 468: fnd_message.set_name('CSI', 'CSI_MISSING_ITEM_PARAMETER');

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
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;

Line 481: fnd_message.set_name('CSI', 'CSI_INVALID_ITEM_PARAMETER');

477: WHERE organization_id = p_ext_attrib_rec.master_organization_id
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;

Line 498: fnd_message.set_name('CSI', 'CSI_PASS_INS_PARAMS');

494: OR (p_ext_attrib_rec.item_category_id IS NOT NULL
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) )

Line 504: fnd_message.set_name('CSI', 'CSI_MISSING_INS_PARAMETER');

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
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;

Line 516: fnd_message.set_name('CSI', 'CSI_INVALID_INS_PARAMETER');

512: FROM csi_item_instances
513: WHERE instance_id = p_ext_attrib_rec.instance_id;
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;

Line 517: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.instance_id);

513: WHERE instance_id = p_ext_attrib_rec.instance_id;
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;

Line 525: fnd_message.set_name('CSI', 'CSI_INVALID_AL_PARAMETER');

521: END IF;
522: END IF; -- end if instance
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

Line 526: fnd_message.set_token('PARAMETER',p_ext_attrib_rec.attribute_level);

522: END IF; -- end if instance
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

Line 531: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');

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');
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

Line 532: fnd_message.set_token('PARAMETER','ATTRIBUTE_LEVEL');

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');
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'

Line 572: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETER');

568: WHERE lookup_type=l_attrib_lookup_type
569: AND lookup_code=p_attribute_code;
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;

Line 573: fnd_message.set_token('PARAMETER',p_attribute_code);

569: AND lookup_code=p_attribute_code;
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

Line 578: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');

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');
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;

Line 579: fnd_message.set_token('PARAMETER','ATTRIBUTE_CODE');

575: x_return_status := fnd_api.g_ret_sts_error;
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;

Line 614: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETER');

610: WHERE lookup_type= l_cat_lookup_type
611: AND lookup_code=p_attribute_category;
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;

Line 615: fnd_message.set_token('PARAMETER',p_attribute_category);

611: AND lookup_code=p_attribute_category;
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;

Line 642: fnd_message.set_name('CSI', 'CSI_MISSING_PARAMETER');

638: x_return_status := fnd_api.g_ret_sts_success;
639:
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;

Line 643: fnd_message.set_token('PARAMETER','ATTRIBUTE_NAME');

639:
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;