APPS.INVPVHDR dependencies on FND_FLEX_KEYVAL

Line 408: --3360280:KFV validation using fnd_flex_keyval

404: --2967569 : Required Segments check
405: l_segment_required NUMBER(10):=0;
406: l_required_flag varchar2(1) := 'Y';
407:
408: --3360280:KFV validation using fnd_flex_keyval
409: l_valid_segments BOOLEAN := FALSE;
410: l_item_number mtl_system_items_interface.item_number%TYPE;
411: l_deliminator_count NUMBER(10) := 0;
412: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

Line 604: --Start 3360280:KFV validation using fnd_flex_keyval

600: end if;
601:
602: end loop; /* Finished populating the bindvals1() plsql table*/
603:
604: --Start 3360280:KFV validation using fnd_flex_keyval
605: --bug8478315, if cr.item_number contains only segment delimiters, re-populate item_number
606: if cr.item_number IS NULL or cr.item_number = g_null_item_number then
607: dumm_status := INVPUOPI.mtl_pr_parse_item_segments
608: (p_row_id => cr.rowid

Line 649: or not fnd_flex_keyval.validate_segs expects item number

645: end if;
646:
647: --Start 3610290: Item number should have deliminator
648: /*If one+ segments are enabled irrespective of required
649: or not fnd_flex_keyval.validate_segs expects item number
650: to be passed in segment1.segment..*/
651:
652: l_deliminator_count := 0;
653: IF totalsegs > 1 THEN

Line 664: l_valid_segments := fnd_flex_keyval.validate_segs

660: END LOOP;
661: END IF;
662: --End 3610290: Item number should have deliminator
663:
664: l_valid_segments := fnd_flex_keyval.validate_segs
665: (operation =>'CHECK_SEGMENTS',
666: appl_short_name => 'INV',
667: key_flex_code => 'MSTK',
668: structure_number => 101,

Line 682: substr(FND_FLEX_KEYVAL.error_message,1,239),

678: prog_appid,
679: prog_id,
680: request_id,
681: cr.TRANSACTION_ID,
682: substr(FND_FLEX_KEYVAL.error_message,1,239),
683: 'ITEM_NUMBER',
684: 'MTL_SYSTEM_ITEMS_INTERFACE',
685: 'INV_IOI_ERR_SEG_FFK_CK_FAIL',--bug 11894684, replace INV_IOI_ERR
686: err_text);

Line 692: IF l_item_number <> fnd_flex_keyval.concatenated_ids THEN --bug 9172582, from FND team's suggestion, we use 'fnd_flex_keyval.concatenated_ids' instead of 'fnd_flex_keyval.concatenated_values'

688: raise LOGGING_ERR;
689: end if;
690: ELSE
691: --Bug: 5200023 Added the ELSE BLOCK
692: IF l_item_number <> fnd_flex_keyval.concatenated_ids THEN --bug 9172582, from FND team's suggestion, we use 'fnd_flex_keyval.concatenated_ids' instead of 'fnd_flex_keyval.concatenated_values'
693:
694: /*Following Condition is added for Bug 8588151.This Condition is set because When ItemNumber is
695: not having the Escape Char for \ It happens when we do item updation from WebADI.*/
696: IF NOT (InStr(l_item_number,'\') <>0 AND

Line 697: (Translate(fnd_flex_keyval.concatenated_values,'#\','\') = Translate(l_item_number,'#\','\'))) THEN

693:
694: /*Following Condition is added for Bug 8588151.This Condition is set because When ItemNumber is
695: not having the Escape Char for \ It happens when we do item updation from WebADI.*/
696: IF NOT (InStr(l_item_number,'\') <>0 AND
697: (Translate(fnd_flex_keyval.concatenated_values,'#\','\') = Translate(l_item_number,'#\','\'))) THEN
698: status := 1;
699: FND_MESSAGE.SET_NAME ('INV', 'INV_ITEM_SEGMENTS_INVALID');
700: FND_MESSAGE.SET_TOKEN ('ITEM_NUMBER', l_item_number);
701: error_msg := FND_MESSAGE.GET;

Line 722: --End 3360280:KFV validation using fnd_flex_keyval

718: end if;
719: END IF;
720: END IF;
721: END IF;
722: --End 3360280:KFV validation using fnd_flex_keyval
723:
724:
725: /*
726: ** For any two items have the same key segment values,