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 1284: l_success := fnd_flex_keyval.validate_segs(

1280: l_trim_str VARCHAR2(2000) ;
1281: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1282:
1283: BEGIN
1284: l_success := fnd_flex_keyval.validate_segs(
1285: operation => 'CHECK_SEGMENTS',
1286: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
1287: key_flex_code => G_CAT_FLEX_CODE,
1288: structure_number => p_structure_id,

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

1301:
1302: --Bug: 2445444 modified If condition
1303: IF (l_success OR
1304: ( NOT l_success AND p_operation = G_UPDATE AND -- added for 13850442
1305: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1306: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1307: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN
1308: NULL;
1309: ELSE

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

1302: --Bug: 2445444 modified If condition
1303: IF (l_success OR
1304: ( NOT l_success AND p_operation = G_UPDATE AND -- added for 13850442
1305: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1306: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1307: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN
1308: NULL;
1309: ELSE
1310: l_trim_str := FND_FLEX_KEYVAL.error_message;

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

1303: IF (l_success OR
1304: ( NOT l_success AND p_operation = G_UPDATE AND -- added for 13850442
1305: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1306: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1307: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN
1308: NULL;
1309: ELSE
1310: l_trim_str := FND_FLEX_KEYVAL.error_message;
1311: fnd_message.set_name('FND','FLEX-SSV EXCEPTION');

Line 1310: l_trim_str := FND_FLEX_KEYVAL.error_message;

1306: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1307: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')>0))) THEN
1308: NULL;
1309: ELSE
1310: l_trim_str := FND_FLEX_KEYVAL.error_message;
1311: fnd_message.set_name('FND','FLEX-SSV EXCEPTION');
1312: fnd_message.set_token('MSG', 'Value set validation error in ValueSet_Validate()');
1313: fnd_msg_pub.ADD;
1314: IF (l_debug = 1) THEN

Line 1472: l_success := fnd_flex_keyval.validate_segs(

1468: mdebug('# of segs : '||to_char(l_n_segments));
1469: mdebug('Concat segs : '||l_concat_segs);
1470: END IF;
1471:
1472: l_success := fnd_flex_keyval.validate_segs(
1473: operation => 'FIND_COMBINATION',
1474: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
1475: key_flex_code => G_CAT_FLEX_CODE,
1476: structure_number => l_structure_id,

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

1478: );
1479: --Bug: 2445444 modified If condition
1480: IF (l_success OR
1481: ( NOT l_success AND
1482: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1483: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1484: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0
1485: )
1486: AND (p_operation = G_UPDATE))) THEN

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

1479: --Bug: 2445444 modified If condition
1480: IF (l_success OR
1481: ( NOT l_success AND
1482: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1483: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1484: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0
1485: )
1486: AND (p_operation = G_UPDATE))) THEN
1487: IF (p_operation = G_INSERT) THEN

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

1480: IF (l_success OR
1481: ( NOT l_success AND
1482: (INSTR(FND_FLEX_KEYVAL.error_message,'has been disabled.')> 0 OR
1483: INSTR(FND_FLEX_KEYVAL.error_message,'has expired.')> 0 OR
1484: INSTR(FND_FLEX_KEYVAL.error_message,'This combination is disabled')> 0
1485: )
1486: AND (p_operation = G_UPDATE))) THEN
1487: IF (p_operation = G_INSERT) THEN
1488:

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

1489: fnd_message.set_name('INV','INV_NEW_ENT');
1490: fnd_message.set_token('TOKEN', 'Category Segment Combination');
1491: fnd_msg_pub.ADD;
1492: IF (l_debug = 1) THEN
1493: mdebug('CCID already exists => '|| To_char(FND_FLEX_KEYVAL.combination_id));
1494: END IF;
1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1496:
1497: ELSIF (p_operation = G_UPDATE) THEN

Line 1498: IF (FND_FLEX_KEYVAL.combination_id <>

1494: END IF;
1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1496:
1497: ELSIF (p_operation = G_UPDATE) THEN
1498: IF (FND_FLEX_KEYVAL.combination_id <>
1499: p_category_rec.category_id) THEN
1500: fnd_message.set_name('INV','INV_NEW_ENT');
1501: fnd_message.set_token('TOKEN', 'Category segment combination. Specified Combination used by another Category.');
1502: fnd_msg_pub.ADD;

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

1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1507: ELSE
1508: ValueSet_Validate(l_structure_id, l_concat_segs, p_operation); -- added p_operation for 13850442
1509: IF (l_debug = 1) THEN
1510: mdebug('Updating CCID/Category_Id => '|| To_char(FND_FLEX_KEYVAL.combination_id));
1511: END IF;
1512: END IF;
1513: ELSE -- neither insert nor update
1514: NULL;

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

1523: /* -------------------------------------------------------
1524: The COMBINATION need not be created using this.
1525: Calling procedure will take care of inserting record.
1526: Since the COMBINATION_ID is Category_Id, just verifying if the
1527: comb. exists through fnd_flex_keyval.validate_segs(FIND_COMB..)
1528: call and inserting directly in database through Table Handler
1529: would be enough. The folllowing could be used as alternative.
1530:
1531: l_success := fnd_flex_keyval.validate_segs(

Line 1531: l_success := fnd_flex_keyval.validate_segs(

1527: comb. exists through fnd_flex_keyval.validate_segs(FIND_COMB..)
1528: call and inserting directly in database through Table Handler
1529: would be enough. The folllowing could be used as alternative.
1530:
1531: l_success := fnd_flex_keyval.validate_segs(
1532: operation => 'CREATE_COMBINATION',
1533: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
1534: key_flex_code => G_CAT_FLEX_CODE,
1535: structure_number => l_structure_id,

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

1535: structure_number => l_structure_id,
1536: concat_segments => l_concat_segs
1537: );
1538: IF (l_debug = 1) THEN
1539: mdebug('The CCID : '||To_char(FND_FLEX_KEYVAL.combination_id));
1540: mdebug('Error : '||FND_FLEX_KEYVAL.error_message);
1541: END IF;
1542: --------------------------------------------------------- */
1543:

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

1536: concat_segments => l_concat_segs
1537: );
1538: IF (l_debug = 1) THEN
1539: mdebug('The CCID : '||To_char(FND_FLEX_KEYVAL.combination_id));
1540: mdebug('Error : '||FND_FLEX_KEYVAL.error_message);
1541: END IF;
1542: --------------------------------------------------------- */
1543:
1544: ELSIF (p_operation = G_UPDATE) THEN

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

1553: NULL;
1554: END IF;
1555: END IF;
1556:
1557: --mdebug('Error : '||FND_FLEX_KEYVAL.error_message);
1558: END Flex_Validate;
1559:
1560: -- 1. Create_Category
1561: ----------------------------------------------------------------------------

Line 3760: l_success := fnd_flex_keyval.validate_segs(

3756: mdebug('# of segs : '||to_char(l_n_segments));
3757: mdebug('Concat segs : '||l_concat_segs);
3758: END IF;
3759:
3760: l_success := fnd_flex_keyval.validate_segs(
3761: operation => 'FIND_COMBINATION',
3762: appl_short_name => G_INVENTORY_APP_SHORT_NAME,
3763: key_flex_code => G_CAT_FLEX_CODE,
3764: structure_number => l_structure_id,

Line 3769: x_category_id := FND_FLEX_KEYVAL.combination_id;

3765: concat_segments => l_concat_segs
3766: );
3767: IF l_success THEN
3768: x_return_status := FND_API.G_RET_STS_SUCCESS;
3769: x_category_id := FND_FLEX_KEYVAL.combination_id;
3770: ELSE
3771:
3772: x_msg_data := FND_FLEX_KEYVAL.error_message;
3773: FND_MESSAGE.Set_Name('FND','FLEX-NO DYNAMIC INSERTS');

Line 3772: x_msg_data := FND_FLEX_KEYVAL.error_message;

3768: x_return_status := FND_API.G_RET_STS_SUCCESS;
3769: x_category_id := FND_FLEX_KEYVAL.combination_id;
3770: ELSE
3771:
3772: x_msg_data := FND_FLEX_KEYVAL.error_message;
3773: FND_MESSAGE.Set_Name('FND','FLEX-NO DYNAMIC INSERTS');
3774: l_msg_text := FND_MESSAGE.Get();
3775:
3776: IF (INSTR(x_msg_data,l_msg_text) > 0) THEN