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_FLEX_KEYVAL

Line 1276: l_success := fnd_flex_keyval.validate_segs(

1272: l_trim_str VARCHAR2(2000) ;
1273: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1274:
1275: BEGIN
1276: l_success := fnd_flex_keyval.validate_segs(
1277: operation => 'CHECK_SEGMENTS',
1278: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
1279: key_flex_code => G_CAT_FLEX_CODE,
1280: structure_number => p_structure_id,

Line 1286: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR

1282: );
1283: --Bug: 2445444 modified If condition
1284: IF (l_success OR
1285: ( NOT l_success AND
1286: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1287: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1288: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN
1289: NULL;
1290: ELSE

Line 1287: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR

1283: --Bug: 2445444 modified If condition
1284: IF (l_success OR
1285: ( NOT l_success AND
1286: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1287: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
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;

Line 1288: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN

1284: IF (l_success OR
1285: ( NOT l_success AND
1286: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1287: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
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');

Line 1291: l_trim_str := FND_FLEX_KEYVAL.error_message;

1287: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
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

Line 1453: l_success := fnd_flex_keyval.validate_segs(

1449: mdebug('# of segs : '||to_char(l_n_segments));
1450: mdebug('Concat segs : '||l_concat_segs);
1451: END IF;
1452:
1453: l_success := fnd_flex_keyval.validate_segs(
1454: operation => 'FIND_COMBINATION',
1455: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
1456: key_flex_code => G_CAT_FLEX_CODE,
1457: structure_number => l_structure_id,

Line 1463: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR

1459: );
1460: --Bug: 2445444 modified If condition
1461: IF (l_success OR
1462: ( NOT l_success AND
1463: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1464: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1465: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0
1466: )
1467: AND (p_operation = G_UPDATE))) THEN

Line 1464: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR

1460: --Bug: 2445444 modified If condition
1461: IF (l_success OR
1462: ( NOT l_success AND
1463: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1464: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1465: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0
1466: )
1467: AND (p_operation = G_UPDATE))) THEN
1468: IF (p_operation = G_INSERT) THEN

Line 1465: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0

1461: IF (l_success OR
1462: ( NOT l_success AND
1463: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1464: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1465: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0
1466: )
1467: AND (p_operation = G_UPDATE))) THEN
1468: IF (p_operation = G_INSERT) THEN
1469:

Line 1474: mdebug('CCID already exists => '|| To_char(FND_FLEX_KEYVAL.combination_id));

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;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477:
1478: ELSIF (p_operation = G_UPDATE) THEN

Line 1479: IF (FND_FLEX_KEYVAL.combination_id <>

1475: END IF;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;

Line 1491: mdebug('Updating CCID/Category_Id => '|| To_char(FND_FLEX_KEYVAL.combination_id));

1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: ELSE
1489: ValueSet_Validate(l_structure_id, l_concat_segs);
1490: IF (l_debug = 1) THEN
1491: mdebug('Updating CCID/Category_Id => '|| To_char(FND_FLEX_KEYVAL.combination_id));
1492: END IF;
1493: END IF;
1494: ELSE -- neither insert nor update
1495: NULL;

Line 1508: comb. exists through fnd_flex_keyval.validate_segs(FIND_COMB..)

1504: /* -------------------------------------------------------
1505: The COMBINATION need not be created using this.
1506: Calling procedure will take care of inserting record.
1507: Since the COMBINATION_ID is Category_Id, just verifying if the
1508: comb. exists through fnd_flex_keyval.validate_segs(FIND_COMB..)
1509: call and inserting directly in database through Table Handler
1510: would be enough. The folllowing could be used as alternative.
1511:
1512: l_success := fnd_flex_keyval.validate_segs(

Line 1512: l_success := fnd_flex_keyval.validate_segs(

1508: comb. exists through fnd_flex_keyval.validate_segs(FIND_COMB..)
1509: call and inserting directly in database through Table Handler
1510: would be enough. The folllowing could be used as alternative.
1511:
1512: l_success := fnd_flex_keyval.validate_segs(
1513: operation => 'CREATE_COMBINATION',
1514: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
1515: key_flex_code => G_CAT_FLEX_CODE,
1516: structure_number => l_structure_id,

Line 1520: mdebug('The CCID : '||To_char(FND_FLEX_KEYVAL.combination_id));

1516: structure_number => l_structure_id,
1517: concat_segments => l_concat_segs
1518: );
1519: IF (l_debug = 1) THEN
1520: mdebug('The CCID : '||To_char(FND_FLEX_KEYVAL.combination_id));
1521: mdebug('Error : '||FND_FLEX_KEYVAL.error_message);
1522: END IF;
1523: --------------------------------------------------------- */
1524:

Line 1521: mdebug('Error : '||FND_FLEX_KEYVAL.error_message);

1517: concat_segments => l_concat_segs
1518: );
1519: IF (l_debug = 1) THEN
1520: mdebug('The CCID : '||To_char(FND_FLEX_KEYVAL.combination_id));
1521: mdebug('Error : '||FND_FLEX_KEYVAL.error_message);
1522: END IF;
1523: --------------------------------------------------------- */
1524:
1525: ELSIF (p_operation = G_UPDATE) THEN

Line 1538: --mdebug('Error : '||FND_FLEX_KEYVAL.error_message);

1534: NULL;
1535: END IF;
1536: END IF;
1537:
1538: --mdebug('Error : '||FND_FLEX_KEYVAL.error_message);
1539: END Flex_Validate;
1540:
1541: -- 1. Create_Category
1542: ----------------------------------------------------------------------------