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.INV_ITEM_CATEGORY_PUB dependencies on FND_MESSAGE

Line 265: fnd_message.set_name('INV','INV_MISSING_REQUIRED_PARAMETER');

261: IF l_debug = 1 THEN
262: mdebug('Validate Params: Missing reqd parameter');
263: END IF;
264: l_valid := FALSE;
265: fnd_message.set_name('INV','INV_MISSING_REQUIRED_PARAMETER');
266: fnd_msg_pub.ADD;
267: RAISE fnd_api.g_EXC_ERROR;
268: END IF;
269: IF l_debug = 1 THEN

Line 280: fnd_message.set_name('INV','INV_SAME_CATEGORY_SETS');

276: l_valid := FALSE;
277: IF l_debug = 1 THEN
278: mdebug('Validate Params: Same Parent and Category Set Id');
279: END IF;
280: fnd_message.set_name('INV','INV_SAME_CATEGORY_SETS');
281: fnd_msg_pub.ADD;
282: RAISE fnd_api.g_EXC_ERROR;
283: END IF;
284: IF l_debug = 1 THEN

Line 301: fnd_message.set_name('INV','INV_INVALID_PARAMETER');

297: l_valid := FALSE;
298: IF l_debug = 1 THEN
299: mdebug('Validate Params: Invalid Category Id');
300: END IF;
301: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
302: fnd_message.set_token('PARAM_NAME', 'CATEGORY_ID');
303: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);
304: fnd_msg_pub.ADD;
305: RAISE fnd_api.g_EXC_ERROR;

Line 302: fnd_message.set_token('PARAM_NAME', 'CATEGORY_ID');

298: IF l_debug = 1 THEN
299: mdebug('Validate Params: Invalid Category Id');
300: END IF;
301: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
302: fnd_message.set_token('PARAM_NAME', 'CATEGORY_ID');
303: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);
304: fnd_msg_pub.ADD;
305: RAISE fnd_api.g_EXC_ERROR;
306: END IF;

Line 303: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);

299: mdebug('Validate Params: Invalid Category Id');
300: END IF;
301: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
302: fnd_message.set_token('PARAM_NAME', 'CATEGORY_ID');
303: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);
304: fnd_msg_pub.ADD;
305: RAISE fnd_api.g_EXC_ERROR;
306: END IF;
307: IF l_debug = 1 THEN

Line 324: fnd_message.set_name('INV','INV_CATEGORY_UNAVAIL_UPDATE');

320: l_valid := FALSE;
321: IF l_debug = 1 THEN
322: mdebug('Validate Params: Record not available for update');
323: END IF;
324: fnd_message.set_name('INV','INV_CATEGORY_UNAVAIL_UPDATE');
325: fnd_msg_pub.ADD;
326: RAISE fnd_api.g_EXC_ERROR;
327: END IF;
328: IF l_debug = 1 THEN

Line 350: fnd_message.set_name('INV','INV_CATEGORY_LOOPS_ERR');

346: l_valid := FALSE;
347: IF l_debug = 1 THEN
348: mdebug('Validate Params: You might create loops!! ');
349: END IF;
350: fnd_message.set_name('INV','INV_CATEGORY_LOOPS_ERR');
351: fnd_msg_pub.ADD;
352: RAISE fnd_api.g_EXC_ERROR;
353: END IF;
354: IF l_debug = 1 THEN

Line 373: -- fnd_message.set_name('INV','INV_MISSING_PARENT_CAT');

369: l_valid := TRUE;
370: IF l_debug = 1 THEN
371: mdebug('Validate Params: User wishes to create a leaf node ');
372: END IF;
373: -- fnd_message.set_name('INV','INV_MISSING_PARENT_CAT');
374: -- fnd_msg_pub.ADD;
375: -- RAISE fnd_api.g_EXC_ERROR;
376: ELSE
377: --

Line 387: fnd_message.set_name('INV','INV_INVALID_PARAMETER');

383: l_valid := FALSE;
384: IF l_debug = 1 THEN
385: mdebug('Validate Params: Invalid Parent Category Id');
386: END IF;
387: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
388: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');
389: fnd_message.set_token('PROGRAM_NAME',
390: G_PKG_NAME||'.'||p_calling_api);
391: fnd_msg_pub.ADD;

Line 388: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');

384: IF l_debug = 1 THEN
385: mdebug('Validate Params: Invalid Parent Category Id');
386: END IF;
387: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
388: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');
389: fnd_message.set_token('PROGRAM_NAME',
390: G_PKG_NAME||'.'||p_calling_api);
391: fnd_msg_pub.ADD;
392: RAISE fnd_api.g_EXC_ERROR;

Line 389: fnd_message.set_token('PROGRAM_NAME',

385: mdebug('Validate Params: Invalid Parent Category Id');
386: END IF;
387: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
388: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');
389: fnd_message.set_token('PROGRAM_NAME',
390: G_PKG_NAME||'.'||p_calling_api);
391: fnd_msg_pub.ADD;
392: RAISE fnd_api.g_EXC_ERROR;
393: END IF;

Line 433: fnd_message.set_name('INV','INV_INVALID_PARAMETER');

429: l_valid := FALSE;
430: IF l_debug = 1 THEN
431: mdebug('Validate Params: Items attached, cannot be parent ');
432: END IF;
433: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
434: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');
435: fnd_message.set_token('PROGRAM_NAME',
436: G_PKG_NAME||'.'||p_calling_api);
437: fnd_msg_pub.ADD;

Line 434: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');

430: IF l_debug = 1 THEN
431: mdebug('Validate Params: Items attached, cannot be parent ');
432: END IF;
433: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
434: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');
435: fnd_message.set_token('PROGRAM_NAME',
436: G_PKG_NAME||'.'||p_calling_api);
437: fnd_msg_pub.ADD;
438: END IF; -- l_count = 0

Line 435: fnd_message.set_token('PROGRAM_NAME',

431: mdebug('Validate Params: Items attached, cannot be parent ');
432: END IF;
433: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
434: fnd_message.set_token('PARAM_NAME', 'PARENT_CATEGORY_ID');
435: fnd_message.set_token('PROGRAM_NAME',
436: G_PKG_NAME||'.'||p_calling_api);
437: fnd_msg_pub.ADD;
438: END IF; -- l_count = 0
439: ELSE

Line 445: fnd_message.set_name('INV','INV_DEFAULT_CATEGORY_ADD_ERR');

441: l_valid := FALSE;
442: IF l_debug = 1 THEN
443: mdebug('Validate Params: Cannot take parent as default category id ');
444: END IF;
445: fnd_message.set_name('INV','INV_DEFAULT_CATEGORY_ADD_ERR');
446: fnd_msg_pub.ADD;
447: END IF; -- l_coount = 0
448: END IF; -- p_parent_category_id IS NULL
449: ELSE

Line 457: fnd_message.set_name('INV','INV_UNWANTED_PARENT_CAT');

453: l_valid := FALSE;
454: IF l_debug = 1 THEN
455: mdebug('Validate Params: Do not pass Parent Category Id ');
456: END IF;
457: fnd_message.set_name('INV','INV_UNWANTED_PARENT_CAT');
458: fnd_msg_pub.ADD;
459: ELSE
460: -- parent category_id should be NULL
461: IF l_debug = 1 THEN

Line 472: fnd_message.set_name('INV','INV_INVALID_PARAMETER');

468: l_valid := FALSE;
469: IF l_debug = 1 THEN
470: mdebug('Validate Params: Invalid Category Set Id');
471: END IF;
472: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
473: fnd_message.set_token('PARAM_NAME', 'CATEGORY_SET_ID');
474: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);
475: fnd_msg_pub.ADD;
476: END IF;

Line 473: fnd_message.set_token('PARAM_NAME', 'CATEGORY_SET_ID');

469: IF l_debug = 1 THEN
470: mdebug('Validate Params: Invalid Category Set Id');
471: END IF;
472: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
473: fnd_message.set_token('PARAM_NAME', 'CATEGORY_SET_ID');
474: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);
475: fnd_msg_pub.ADD;
476: END IF;
477: IF l_debug = 1 THEN

Line 474: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);

470: mdebug('Validate Params: Invalid Category Set Id');
471: END IF;
472: fnd_message.set_name('INV','INV_INVALID_PARAMETER');
473: fnd_message.set_token('PARAM_NAME', 'CATEGORY_SET_ID');
474: fnd_message.set_token('PROGRAM_NAME', G_PKG_NAME||'.'||p_calling_api);
475: fnd_msg_pub.ADD;
476: END IF;
477: IF l_debug = 1 THEN
478: mdebug('Validate Params: Returning without exceptions');

Line 692: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');

688: OPEN get_structure_id('PRODUCT_CATEGORIES');
689: FETCH get_structure_id INTO l_product_str_id;
690:
691: IF (get_structure_id%NOTFOUND) THEN
692: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
693: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
694: fnd_msg_pub.ADD;
695: IF (l_debug = 1) THEN
696: mdebug('ERR: No Product Categories structure');

Line 693: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');

689: FETCH get_structure_id INTO l_product_str_id;
690:
691: IF (get_structure_id%NOTFOUND) THEN
692: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
693: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
694: fnd_msg_pub.ADD;
695: IF (l_debug = 1) THEN
696: mdebug('ERR: No Product Categories structure');
697: END IF;

Line 723: fnd_message.set_name('INV','INV_FLEX_STRUCTURE_REQ');

719: IF (x_category_rec.structure_id = g_MISS_NUM OR
720: x_category_rec.structure_id IS NULL) AND
721: ( x_category_rec.structure_code = g_MISS_CHAR OR
722: x_category_rec.structure_code IS NULL) THEN
723: fnd_message.set_name('INV','INV_FLEX_STRUCTURE_REQ');
724: fnd_msg_pub.ADD;
725: IF (l_debug = 1) THEN
726: mdebug('Flex Structure Information needed');
727: END IF;

Line 742: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');

738: mdebug('Flex Structure: '||To_char(x_category_rec.structure_id));
739: END IF;
740:
741: IF (get_structure_id%NOTFOUND) THEN
742: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
743: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
744: fnd_msg_pub.ADD;
745: IF (l_debug = 1) THEN
746: mdebug('ERR: Invalid Flex Structure information provided');

Line 743: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');

739: END IF;
740:
741: IF (get_structure_id%NOTFOUND) THEN
742: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
743: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
744: fnd_msg_pub.ADD;
745: IF (l_debug = 1) THEN
746: mdebug('ERR: Invalid Flex Structure information provided');
747: END IF;

Line 759: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');

755: x_category_rec.structure_id IS NOT NULL) THEN
756: OPEN validate_structure_id(x_category_rec.structure_id);
757: FETCH validate_structure_id INTO l_flexstr_exists;
758: IF (validate_structure_id%NOTFOUND) THEN
759: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
760: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
761: fnd_msg_pub.ADD;
762: IF (l_debug = 1) THEN
763: mdebug('Invalid Flex Structure information provided');

Line 760: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');

756: OPEN validate_structure_id(x_category_rec.structure_id);
757: FETCH validate_structure_id INTO l_flexstr_exists;
758: IF (validate_structure_id%NOTFOUND) THEN
759: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
760: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
761: fnd_msg_pub.ADD;
762: IF (l_debug = 1) THEN
763: mdebug('Invalid Flex Structure information provided');
764: END IF;

Line 776: fnd_message.set_name('INV','INV_CAT_SUM_FLAG_ERR');

772:
773: /* Bug 5474569 Start */
774: if (l_product_str_id <> x_category_rec.structure_id and
775: nvl(x_category_rec.summary_flag, 'N' ) = 'Y' ) then
776: fnd_message.set_name('INV','INV_CAT_SUM_FLAG_ERR');
777: fnd_msg_pub.ADD;
778: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
779: end if;
780: /* Bug 5474569 End */

Line 959: fnd_message.set_name('INV','INV_NO_CATEGORY');

955: IF (p_operation = G_UPDATE) THEN
956:
957: IF (x_category_rec.category_id = g_MISS_NUM OR
958: x_category_rec.category_id IS NULL) THEN
959: fnd_message.set_name('INV','INV_NO_CATEGORY');
960: fnd_msg_pub.ADD;
961: IF (l_debug = 1) THEN
962: mdebug('Category Id needed for Update');
963: END IF;

Line 974: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');

970: x_category_rec.structure_code IS NULL) THEN
971: OPEN get_category_structure_id(x_category_rec.category_id);
972: FETCH get_category_structure_id INTO x_category_rec.structure_id;
973: IF (get_category_structure_id%NOTFOUND) THEN
974: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
975: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
976: fnd_msg_pub.ADD;
977: IF (l_debug = 1) THEN
978: mdebug('Invalid Flex Structure information provided');

Line 975: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');

971: OPEN get_category_structure_id(x_category_rec.category_id);
972: FETCH get_category_structure_id INTO x_category_rec.structure_id;
973: IF (get_category_structure_id%NOTFOUND) THEN
974: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
975: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
976: fnd_msg_pub.ADD;
977: IF (l_debug = 1) THEN
978: mdebug('Invalid Flex Structure information provided');
979: END IF;

Line 985: fnd_message.set_name('INV','INV_FLEX_STRUCTURE_REQ');

981: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
982: END IF;
983: CLOSE get_category_structure_id;
984: /*
985: fnd_message.set_name('INV','INV_FLEX_STRUCTURE_REQ');
986: fnd_msg_pub.ADD;
987: IF (l_debug = 1) THEN
988: mdebug('Flex Structure Information needed');
989: END IF;

Line 1001: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');

997: x_category_rec.structure_code IS NOT NULL) THEN
998: OPEN get_structure_id(x_category_rec.structure_code);
999: FETCH get_structure_id INTO x_category_rec.structure_id;
1000: IF (get_structure_id%NOTFOUND) THEN
1001: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
1002: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
1003: fnd_msg_pub.ADD;
1004: IF (l_debug = 1) THEN
1005: mdebug('Invalid Flex Structure information provided');

Line 1002: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');

998: OPEN get_structure_id(x_category_rec.structure_code);
999: FETCH get_structure_id INTO x_category_rec.structure_id;
1000: IF (get_structure_id%NOTFOUND) THEN
1001: fnd_message.set_name('INV','FLEX-NO MAIN KEY FLEX DEF');
1002: fnd_message.set_token('ROUTINE', 'Preprocess_Category_Rec');
1003: fnd_msg_pub.ADD;
1004: IF (l_debug = 1) THEN
1005: mdebug('Invalid Flex Structure information provided');
1006: END IF;

Line 1018: fnd_message.set_name('INV','INV_CAT_SUM_FLAG_ERR');

1014:
1015: /* Bug 5474569 Start */
1016: if (l_product_str_id <> x_category_rec.structure_id and
1017: nvl(x_category_rec.summary_flag, 'N' ) = 'Y' ) then
1018: fnd_message.set_name('INV','INV_CAT_SUM_FLAG_ERR');
1019: fnd_msg_pub.ADD;
1020: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
1021: end if;
1022: /* Bug 5474569 End */

Line 1073: fnd_message.set_name('INV','INV_VALID_CAT');

1069: l_category_rec.attribute14,
1070: l_category_rec.attribute15;
1071:
1072: IF (category_rec_cursor%NOTFOUND) THEN
1073: fnd_message.set_name('INV','INV_VALID_CAT');
1074: fnd_msg_pub.ADD;
1075: IF (l_debug = 1) THEN
1076: mdebug('Invalid Category Id provided');
1077: END IF;

Line 1292: fnd_message.set_name('FND','FLEX-SSV EXCEPTION');

1288: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN
1289: NULL;
1290: ELSE
1291: l_trim_str := FND_FLEX_KEYVAL.error_message;
1292: fnd_message.set_name('FND','FLEX-SSV EXCEPTION');
1293: fnd_message.set_token('MSG', 'Value set validation error in ValueSet_Validate()');
1294: fnd_msg_pub.ADD;
1295: IF (l_debug = 1) THEN
1296: mdebug('ValueSet Validation Error : '||l_trim_str);

Line 1293: fnd_message.set_token('MSG', 'Value set validation error in ValueSet_Validate()');

1289: NULL;
1290: ELSE
1291: l_trim_str := FND_FLEX_KEYVAL.error_message;
1292: fnd_message.set_name('FND','FLEX-SSV EXCEPTION');
1293: fnd_message.set_token('MSG', 'Value set validation error in ValueSet_Validate()');
1294: fnd_msg_pub.ADD;
1295: IF (l_debug = 1) THEN
1296: mdebug('ValueSet Validation Error : '||l_trim_str);
1297: END IF;

Line 1357: fnd_message.set_name('OFA','FA_BUDGET_NO_SEG_DELIM');

1353: l_delim := fnd_flex_ext.get_delimiter(G_INVENTORY_APP_SHORT_NAME,
1354: G_CAT_FLEX_CODE,
1355: l_structure_id);
1356: IF l_delim is NULL then
1357: fnd_message.set_name('OFA','FA_BUDGET_NO_SEG_DELIM');
1358: fnd_msg_pub.ADD;
1359: IF (l_debug = 1) THEN
1360: mdebug('Delimiter is NULL...Error');
1361: END IF;

Line 1470: fnd_message.set_name('INV','INV_NEW_ENT');

1466: )
1467: AND (p_operation = G_UPDATE))) THEN
1468: IF (p_operation = G_INSERT) THEN
1469:
1470: fnd_message.set_name('INV','INV_NEW_ENT');
1471: fnd_message.set_token('TOKEN', 'Category Segment Combination');
1472: fnd_msg_pub.ADD;
1473: IF (l_debug = 1) THEN
1474: mdebug('CCID already exists => '|| To_char(FND_FLEX_KEYVAL.combination_id));

Line 1471: fnd_message.set_token('TOKEN', 'Category Segment Combination');

1467: AND (p_operation = G_UPDATE))) THEN
1468: IF (p_operation = G_INSERT) THEN
1469:
1470: fnd_message.set_name('INV','INV_NEW_ENT');
1471: fnd_message.set_token('TOKEN', 'Category Segment Combination');
1472: fnd_msg_pub.ADD;
1473: IF (l_debug = 1) THEN
1474: mdebug('CCID already exists => '|| To_char(FND_FLEX_KEYVAL.combination_id));
1475: END IF;

Line 1481: fnd_message.set_name('INV','INV_NEW_ENT');

1477:
1478: ELSIF (p_operation = G_UPDATE) THEN
1479: IF (FND_FLEX_KEYVAL.combination_id <>
1480: p_category_rec.category_id) THEN
1481: fnd_message.set_name('INV','INV_NEW_ENT');
1482: fnd_message.set_token('TOKEN', 'Category segment combination. Specified Combination used by another Category.');
1483: fnd_msg_pub.ADD;
1484: IF (l_debug = 1) THEN
1485: mdebug( 'Code combination already used for another category');

Line 1482: fnd_message.set_token('TOKEN', 'Category segment combination. Specified Combination used by another Category.');

1478: ELSIF (p_operation = G_UPDATE) THEN
1479: IF (FND_FLEX_KEYVAL.combination_id <>
1480: p_category_rec.category_id) THEN
1481: fnd_message.set_name('INV','INV_NEW_ENT');
1482: fnd_message.set_token('TOKEN', 'Category segment combination. Specified Combination used by another Category.');
1483: fnd_msg_pub.ADD;
1484: IF (l_debug = 1) THEN
1485: mdebug( 'Code combination already used for another category');
1486: END IF;

Line 1526: fnd_message.set_name('INV','INV_VALID_CAT');

1522: END IF;
1523: --------------------------------------------------------- */
1524:
1525: ELSIF (p_operation = G_UPDATE) THEN
1526: fnd_message.set_name('INV','INV_VALID_CAT');
1527: fnd_msg_pub.ADD;
1528: IF (l_debug = 1) THEN
1529: mdebug('Trying to update a non-existant ROW');
1530: END IF;

Line 2045: fnd_message.set_name('INV','INV_VALID_CAT');

2041: WHERE category_id = p_category_id
2042: AND userenv('LANG') IN (language, source_lang) ;
2043:
2044: IF (sql%notfound) THEN
2045: fnd_message.set_name('INV','INV_VALID_CAT');
2046: fnd_msg_pub.ADD;
2047: IF (l_debug = 1) THEN
2048: mdebug('Trying to Update a non-existant Category.');
2049: END IF;

Line 2202: fnd_message.set_name('INV','INV_CATEGORY_ASSIGNED');

2198: END IF;
2199: END IF;
2200: CLOSE category_assignment_exists;
2201: IF (l_category_assignment_exists = 'x') THEN
2202: fnd_message.set_name('INV','INV_CATEGORY_ASSIGNED');
2203: fnd_msg_pub.ADD;
2204: IF (l_debug = 1) THEN
2205: mdebug('Cannot delete: Category part of a Category Assignment');
2206: END IF;

Line 2219: fnd_message.set_name('INV','INV_CATEGORY_DEFAULT');

2215: END IF;
2216: END IF;
2217: CLOSE default_category_exists;
2218: IF (l_default_category_exists = 'x') THEN
2219: fnd_message.set_name('INV','INV_CATEGORY_DEFAULT');
2220: fnd_msg_pub.ADD;
2221: IF (l_debug = 1) THEN
2222: mdebug('Cannot delete: Category specified is a default category to one of the Category Sets.');
2223: END IF;

Line 2236: fnd_message.set_name('INV','INV_CATEGORY_IN_USE');

2232: END IF;
2233: END IF;
2234: CLOSE valid_category_exists;
2235: IF (l_valid_category_exists = 'x') THEN
2236: fnd_message.set_name('INV','INV_CATEGORY_IN_USE');
2237: fnd_msg_pub.ADD;
2238: IF (l_debug = 1) THEN
2239: mdebug('Cannot delete: Category specified is part of a valid category set');
2240: END IF;

Line 2248: fnd_message.set_name('INV','INV_VALID_CAT');

2244: delete from mtl_categories_tl
2245: where category_id = p_category_id ;
2246:
2247: if (sql%notfound) then
2248: fnd_message.set_name('INV','INV_VALID_CAT');
2249: fnd_msg_pub.ADD;
2250: IF (l_debug = 1) THEN
2251: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_TL.');
2252: END IF;

Line 2260: fnd_message.set_name('INV','INV_VALID_CAT');

2256: delete from mtl_categories_b
2257: where category_id = p_category_id ;
2258:
2259: if (sql%notfound) then
2260: fnd_message.set_name('INV','INV_VALID_CAT');
2261: fnd_msg_pub.ADD;
2262: IF (l_debug = 1) THEN
2263: mdebug('Trying to delete non-existant Category Id from MTL_CATEGORIES_B.');
2264: END IF;

Line 2633: fnd_message.set_name('INV','INV_NOT_VALID_FLAG');

2629: IF (l_debug = 1) THEN
2630: mdebug('checking supplier enabled flag information provided'|| x_category_rec.supplier_enabled_flag);
2631: END IF;
2632: IF x_category_rec.supplier_enabled_flag NOT IN (g_YES,g_MISS_CHAR) THEN -- g_NO is modifed to g_YES for bug#6278190
2633: fnd_message.set_name('INV','INV_NOT_VALID_FLAG');
2634: fnd_message.set_token('COLUMN_NAME', 'SUPPLIER_ENABLED_FLAG');
2635: fnd_msg_pub.ADD;
2636: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
2637: IF (l_debug = 1) THEN

Line 2634: fnd_message.set_token('COLUMN_NAME', 'SUPPLIER_ENABLED_FLAG');

2630: mdebug('checking supplier enabled flag information provided'|| x_category_rec.supplier_enabled_flag);
2631: END IF;
2632: IF x_category_rec.supplier_enabled_flag NOT IN (g_YES,g_MISS_CHAR) THEN -- g_NO is modifed to g_YES for bug#6278190
2633: fnd_message.set_name('INV','INV_NOT_VALID_FLAG');
2634: fnd_message.set_token('COLUMN_NAME', 'SUPPLIER_ENABLED_FLAG');
2635: fnd_msg_pub.ADD;
2636: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
2637: IF (l_debug = 1) THEN
2638: mdebug('Invalid supplier enabled flag information provided');

Line 2646: fnd_message.set_name('INV','INV_NOT_VALID_FLAG');

2642: mdebug('checking web status flag information provided');
2643: END IF;
2644: /*Bug: 4494727 Commenting out the following IF condition
2645: IF x_category_rec.web_status NOT IN (g_YES,g_MISS_CHAR) THEN
2646: fnd_message.set_name('INV','INV_NOT_VALID_FLAG');
2647: fnd_message.set_token('COLUMN_NAME', 'WEB_STATUS');
2648: fnd_msg_pub.ADD;
2649: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
2650: IF (l_debug = 1) THEN

Line 2647: fnd_message.set_token('COLUMN_NAME', 'WEB_STATUS');

2643: END IF;
2644: /*Bug: 4494727 Commenting out the following IF condition
2645: IF x_category_rec.web_status NOT IN (g_YES,g_MISS_CHAR) THEN
2646: fnd_message.set_name('INV','INV_NOT_VALID_FLAG');
2647: fnd_message.set_token('COLUMN_NAME', 'WEB_STATUS');
2648: fnd_msg_pub.ADD;
2649: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
2650: IF (l_debug = 1) THEN
2651: mdebug('Invalid web status flag information provided');

Line 2661: fnd_message.set_name('INV','INV_NO_DEFAULT_CSET');

2657: THEN
2658: OPEN get_po_structure_id;
2659: FETCH get_po_structure_id INTO l_po_structure_id;
2660: IF (get_po_structure_id%NOTFOUND) THEN
2661: fnd_message.set_name('INV','INV_NO_DEFAULT_CSET');
2662: fnd_msg_pub.ADD;
2663: IF (l_debug = 1) THEN
2664: mdebug('No Default purchasing category set provided');
2665: END IF;

Line 2671: fnd_message.set_name('INV','INV_SUP_ENABLED_PO_CAT_ONLY');

2667: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
2668: ELSE
2669: IF (l_po_structure_id <> x_category_rec.structure_id) THEN
2670: IF (x_category_rec.supplier_enabled_flag = g_NO) THEN
2671: fnd_message.set_name('INV','INV_SUP_ENABLED_PO_CAT_ONLY');
2672: fnd_msg_pub.ADD;
2673: END IF;
2674: /*Bug: 4494727 Commenting out the following IF condition
2675: IF (x_category_rec.web_status = g_YES) THEN

Line 2676: fnd_message.set_name('INV','INV_CAT_ENABLED_PO_CAT_ONLY');

2672: fnd_msg_pub.ADD;
2673: END IF;
2674: /*Bug: 4494727 Commenting out the following IF condition
2675: IF (x_category_rec.web_status = g_YES) THEN
2676: fnd_message.set_name('INV','INV_CAT_ENABLED_PO_CAT_ONLY');
2677: fnd_msg_pub.ADD;
2678: END IF;
2679: */
2680: IF (l_debug = 1) THEN

Line 2958: fnd_message.set_name('INV','INV_CATEGORY_UNAVAIL_UPDATE');

2954: IF (SQL%NOTFOUND) THEN
2955: IF l_debug = 1 THEN
2956: mdebug('Update_Valid_Category: Record not available for update');
2957: END IF;
2958: fnd_message.set_name('INV','INV_CATEGORY_UNAVAIL_UPDATE');
2959: fnd_msg_pub.ADD;
2960: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
2961: END IF;
2962: ELSE

Line 3159: fnd_message.set_name('INV','INV_MISSING_REQUIRED_PARAMETER');

3155: IF (p_category_set_id IS NULL OR p_category_id IS NULL) THEN
3156: IF l_debug = 1 THEN
3157: mdebug('Delete_Valid_Category: Mandatory parameters missing');
3158: END IF;
3159: fnd_message.set_name('INV','INV_MISSING_REQUIRED_PARAMETER');
3160: fnd_msg_pub.ADD;
3161: RAISE fnd_api.G_EXC_ERROR;
3162: END IF;
3163:

Line 3170: fnd_message.set_name('INV','INV_CATEGORY_UNAVAIL_DELETE');

3166: ,x_hrchy_enabled => l_hrchy_enabled) THEN
3167: IF l_debug = 1 THEN
3168: mdebug('Delete_Valid_Category: Record not available for deletion');
3169: END IF;
3170: fnd_message.set_name('INV','INV_CATEGORY_UNAVAIL_DELETE');
3171: fnd_msg_pub.ADD;
3172: RAISE fnd_api.g_EXC_ERROR;
3173: END IF;
3174:

Line 3204: fnd_message.set_name('INV','INV_DELETE_DEF_CAT_ERR');

3200: FETCH c_get_cat_desc INTO l_description;
3201: IF c_get_cat_desc%NOTFOUND THEN
3202: l_description := NULL;
3203: END IF;
3204: fnd_message.set_name('INV','INV_DELETE_DEF_CAT_ERR');
3205: fnd_message.set_token('CATEGORY_NAME', l_description);
3206: fnd_msg_pub.ADD;
3207: RAISE fnd_api.G_EXC_ERROR;
3208: END IF;

Line 3205: fnd_message.set_token('CATEGORY_NAME', l_description);

3201: IF c_get_cat_desc%NOTFOUND THEN
3202: l_description := NULL;
3203: END IF;
3204: fnd_message.set_name('INV','INV_DELETE_DEF_CAT_ERR');
3205: fnd_message.set_token('CATEGORY_NAME', l_description);
3206: fnd_msg_pub.ADD;
3207: RAISE fnd_api.G_EXC_ERROR;
3208: END IF;
3209:

Line 3261: fnd_message.set_name('INV','INV_CATEGORY_ITEMS_EXIST');

3257: FETCH c_get_cat_desc INTO l_description;
3258: IF c_get_cat_desc%NOTFOUND THEN
3259: l_description := NULL;
3260: END IF;
3261: fnd_message.set_name('INV','INV_CATEGORY_ITEMS_EXIST');
3262: fnd_message.set_token('CATEGORY_NAME', l_description);
3263: fnd_msg_pub.ADD;
3264: RAISE FND_API.G_EXC_ERROR;
3265: END IF;

Line 3262: fnd_message.set_token('CATEGORY_NAME', l_description);

3258: IF c_get_cat_desc%NOTFOUND THEN
3259: l_description := NULL;
3260: END IF;
3261: fnd_message.set_name('INV','INV_CATEGORY_ITEMS_EXIST');
3262: fnd_message.set_token('CATEGORY_NAME', l_description);
3263: fnd_msg_pub.ADD;
3264: RAISE FND_API.G_EXC_ERROR;
3265: END IF;
3266: