DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on FND_MESSAGE

Line 566: fnd_message.set_name ('GMD', 'GMD_SPVL_REPLACE_MESG');

562:
563: -- Making new line entry and prompting users about MSNR request
564: fnd_file.new_line (fnd_file.LOG, 1);
565: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
566: fnd_message.set_name ('GMD', 'GMD_SPVL_REPLACE_MESG');
567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);
568: fnd_message.set_token ('NAME', get_object_rec.object_name);
569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);

Line 567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);

563: -- Making new line entry and prompting users about MSNR request
564: fnd_file.new_line (fnd_file.LOG, 1);
565: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
566: fnd_message.set_name ('GMD', 'GMD_SPVL_REPLACE_MESG');
567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);
568: fnd_message.set_token ('NAME', get_object_rec.object_name);
569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);
571: fnd_file.put (fnd_file.LOG, fnd_message.get);

Line 568: fnd_message.set_token ('NAME', get_object_rec.object_name);

564: fnd_file.new_line (fnd_file.LOG, 1);
565: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
566: fnd_message.set_name ('GMD', 'GMD_SPVL_REPLACE_MESG');
567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);
568: fnd_message.set_token ('NAME', get_object_rec.object_name);
569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);
571: fnd_file.put (fnd_file.LOG, fnd_message.get);
572: fnd_file.new_line (fnd_file.LOG, 1);

Line 569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);

565: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
566: fnd_message.set_name ('GMD', 'GMD_SPVL_REPLACE_MESG');
567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);
568: fnd_message.set_token ('NAME', get_object_rec.object_name);
569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);
571: fnd_file.put (fnd_file.LOG, fnd_message.get);
572: fnd_file.new_line (fnd_file.LOG, 1);
573: --FND_FILE.PUT(FND_FILE.OUTPUT,FND_MESSAGE.GET);

Line 570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);

566: fnd_message.set_name ('GMD', 'GMD_SPVL_REPLACE_MESG');
567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);
568: fnd_message.set_token ('NAME', get_object_rec.object_name);
569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);
571: fnd_file.put (fnd_file.LOG, fnd_message.get);
572: fnd_file.new_line (fnd_file.LOG, 1);
573: --FND_FILE.PUT(FND_FILE.OUTPUT,FND_MESSAGE.GET);
574: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 571: fnd_file.put (fnd_file.LOG, fnd_message.get);

567: fnd_message.set_token ('OBJECT_TYPE', get_object_rec.object_type);
568: fnd_message.set_token ('NAME', get_object_rec.object_name);
569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);
571: fnd_file.put (fnd_file.LOG, fnd_message.get);
572: fnd_file.new_line (fnd_file.LOG, 1);
573: --FND_FILE.PUT(FND_FILE.OUTPUT,FND_MESSAGE.GET);
574: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
575:

Line 573: --FND_FILE.PUT(FND_FILE.OUTPUT,FND_MESSAGE.GET);

569: fnd_message.set_token ('VERSION', get_object_rec.object_vers);
570: fnd_message.set_token ('REPLACE_TYPE', get_object_rec.replace_type);
571: fnd_file.put (fnd_file.LOG, fnd_message.get);
572: fnd_file.new_line (fnd_file.LOG, 1);
573: --FND_FILE.PUT(FND_FILE.OUTPUT,FND_MESSAGE.GET);
574: --FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
575:
576: IF pobject_type = 'SPECIFICATION' THEN
577: /* REPLACE TYPE could be on of the following

Line 702: --FND_MESSAGE.SET_NAME('gmd', 'GMD_ITEM_ORG_NOT_FOUND');

698: FETCH cur_check_item_org into item_org_rec;
699: CLOSE cur_check_item_org;
700:
701: IF item_org_rec.organization_id IS NULL THEN
702: --FND_MESSAGE.SET_NAME('gmd', 'GMD_ITEM_ORG_NOT_FOUND');
703: --FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
704: --FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
705: --FND_MSG_PUB.ADD;
706: default_log ( ' Item is not assigned to the organization ');

Line 703: --FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));

699: CLOSE cur_check_item_org;
700:
701: IF item_org_rec.organization_id IS NULL THEN
702: --FND_MESSAGE.SET_NAME('gmd', 'GMD_ITEM_ORG_NOT_FOUND');
703: --FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
704: --FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
705: --FND_MSG_PUB.ADD;
706: default_log ( ' Item is not assigned to the organization ');
707: RAISE NO_UPDATE_EXCEPTION;

Line 704: --FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));

700:
701: IF item_org_rec.organization_id IS NULL THEN
702: --FND_MESSAGE.SET_NAME('gmd', 'GMD_ITEM_ORG_NOT_FOUND');
703: --FND_MESSAGE.SET_TOKEN('ITEM',get_item_no(get_object_rec.new_name));
704: --FND_MESSAGE.SET_TOKEN('ORGN',get_orgn_code(l_orgn_id));
705: --FND_MSG_PUB.ADD;
706: default_log ( ' Item is not assigned to the organization ');
707: RAISE NO_UPDATE_EXCEPTION;
708: END IF;

Line 1443: fnd_message.set_name ('GMD', 'GMD_CONC_NO_ROW_FOUND');

1439: END IF;
1440:
1441: -- There were no row selected for replace raise an error
1442: IF (l_rowcount = 0) THEN
1443: fnd_message.set_name ('GMD', 'GMD_CONC_NO_ROW_FOUND');
1444: RAISE NO_REPLACE_EXCEPTION;
1445: END IF;
1446:
1447: DEBUG ( g_pkg_name

Line 1475: fnd_file.put (fnd_file.LOG, fnd_message.get);

1471: || ' Error text is '
1472: || l_error_text);
1473: END IF;
1474:
1475: fnd_file.put (fnd_file.LOG, fnd_message.get);
1476: fnd_file.new_line (fnd_file.LOG, 1);
1477: -- outer excepption handles all error that occur prior to or after
1478: -- Mass updates (or within LOOP above)
1479: WHEN OTHERS THEN

Line 1484: fnd_message.set_name ('GMD', 'GMD_CONC_UPDATE_OBJECT_FAILED');

1480: --ret_code := 2;
1481: --err_buf := NULL;
1482: l_retval := fnd_concurrent.set_completion_status ('WARNING', SQLERRM);
1483: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1484: fnd_message.set_name ('GMD', 'GMD_CONC_UPDATE_OBJECT_FAILED');
1485: fnd_message.set_token ('REPLACE_TYPE', preplace_type);
1486:
1487: IF (preplace_type = 'INGREDIENT') THEN
1488: fnd_message.set_token ('REPLACE_VALUE', pnew_name);

Line 1485: fnd_message.set_token ('REPLACE_TYPE', preplace_type);

1481: --err_buf := NULL;
1482: l_retval := fnd_concurrent.set_completion_status ('WARNING', SQLERRM);
1483: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1484: fnd_message.set_name ('GMD', 'GMD_CONC_UPDATE_OBJECT_FAILED');
1485: fnd_message.set_token ('REPLACE_TYPE', preplace_type);
1486:
1487: IF (preplace_type = 'INGREDIENT') THEN
1488: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1489: ELSE

Line 1488: fnd_message.set_token ('REPLACE_VALUE', pnew_name);

1484: fnd_message.set_name ('GMD', 'GMD_CONC_UPDATE_OBJECT_FAILED');
1485: fnd_message.set_token ('REPLACE_TYPE', preplace_type);
1486:
1487: IF (preplace_type = 'INGREDIENT') THEN
1488: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1489: ELSE
1490: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1491: END IF;
1492:

Line 1490: fnd_message.set_token ('REPLACE_VALUE', pnew_name);

1486:
1487: IF (preplace_type = 'INGREDIENT') THEN
1488: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1489: ELSE
1490: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1491: END IF;
1492:
1493: fnd_message.set_token ('OBJECT_TYPE', pobject_type);
1494: fnd_message.set_token ('ERRMSG', SQLERRM);

Line 1493: fnd_message.set_token ('OBJECT_TYPE', pobject_type);

1489: ELSE
1490: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1491: END IF;
1492:
1493: fnd_message.set_token ('OBJECT_TYPE', pobject_type);
1494: fnd_message.set_token ('ERRMSG', SQLERRM);
1495: fnd_file.put (fnd_file.LOG, fnd_message.get);
1496: fnd_file.new_line (fnd_file.LOG, 1);
1497: END mass_replace_oper_spec_val;

Line 1494: fnd_message.set_token ('ERRMSG', SQLERRM);

1490: fnd_message.set_token ('REPLACE_VALUE', pnew_name);
1491: END IF;
1492:
1493: fnd_message.set_token ('OBJECT_TYPE', pobject_type);
1494: fnd_message.set_token ('ERRMSG', SQLERRM);
1495: fnd_file.put (fnd_file.LOG, fnd_message.get);
1496: fnd_file.new_line (fnd_file.LOG, 1);
1497: END mass_replace_oper_spec_val;
1498:

Line 1495: fnd_file.put (fnd_file.LOG, fnd_message.get);

1491: END IF;
1492:
1493: fnd_message.set_token ('OBJECT_TYPE', pobject_type);
1494: fnd_message.set_token ('ERRMSG', SQLERRM);
1495: fnd_file.put (fnd_file.LOG, fnd_message.get);
1496: fnd_file.new_line (fnd_file.LOG, 1);
1497: END mass_replace_oper_spec_val;
1498:
1499: /* PROCEDURE default_spectest_from_test