[Home] [Help]
17:
18: -- This call is temporarily commented out
19:
20:
21: IF FND_FLEX_DESCVAL.Validate_Desccols
22: ( appl_short_name => 'ONT'
23: , desc_flex_name => p_flex_name
24: )
25: THEN
28:
29: -- Prepare the encoded message by setting it on the message
30: -- dictionary stack. Then, add it to the API message list.
31:
32: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
33:
34: OE_MSG_PUB.Add;
35:
36: -- Derive return status.
34: OE_MSG_PUB.Add;
35:
36: -- Derive return status.
37:
38: IF FND_FLEX_DESCVAL.value_error OR
39: FND_FLEX_DESCVAL.unsupported_error
40: THEN
41:
42: -- In case of an expected error return FALSE
35:
36: -- Derive return status.
37:
38: IF FND_FLEX_DESCVAL.value_error OR
39: FND_FLEX_DESCVAL.unsupported_error
40: THEN
41:
42: -- In case of an expected error return FALSE
43:
14179: l_column_value := p_attribute1;
14180:
14181: END IF;
14182:
14183: FND_FLEX_DESCVAL.Set_Column_Value
14184: ( column_name => 'ATTRIBUTE1'
14185: , column_value => l_column_value);
14186:
14187:
14193:
14194: l_column_value := p_attribute2;
14195:
14196: END IF;
14197: FND_FLEX_DESCVAL.Set_Column_Value
14198: ( column_name => 'ATTRIBUTE2'
14199: , column_value => l_column_value);
14200:
14201: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
14206:
14207: l_column_value := p_attribute3;
14208:
14209: END IF;
14210: FND_FLEX_DESCVAL.Set_Column_Value
14211: ( column_name => 'ATTRIBUTE3'
14212: , column_value => l_column_value);
14213:
14214: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
14219:
14220: l_column_value := p_attribute4;
14221:
14222: END IF;
14223: FND_FLEX_DESCVAL.Set_Column_Value
14224: ( column_name => 'ATTRIBUTE4'
14225: , column_value => l_column_value);
14226:
14227: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
14232:
14233: l_column_value := p_attribute5;
14234:
14235: END IF;
14236: FND_FLEX_DESCVAL.Set_Column_Value
14237: ( column_name => 'ATTRIBUTE5'
14238: , column_value => l_column_value);
14239:
14240: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
14245:
14246: l_column_value := p_attribute6;
14247:
14248: END IF;
14249: FND_FLEX_DESCVAL.Set_Column_Value
14250: ( column_name => 'ATTRIBUTE6'
14251: , column_value => l_column_value);
14252:
14253: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
14258:
14259: l_column_value := p_attribute7;
14260:
14261: END IF;
14262: FND_FLEX_DESCVAL.Set_Column_Value
14263: ( column_name => 'ATTRIBUTE7'
14264: , column_value => l_column_value);
14265:
14266: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
14271:
14272: l_column_value := p_attribute8;
14273:
14274: END IF;
14275: FND_FLEX_DESCVAL.Set_Column_Value
14276: ( column_name => 'ATTRIBUTE8'
14277: , column_value => l_column_value);
14278:
14279: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
14284:
14285: l_column_value := p_attribute9;
14286:
14287: END IF;
14288: FND_FLEX_DESCVAL.Set_Column_Value
14289: ( column_name => 'ATTRIBUTE9'
14290: , column_value => l_column_value);
14291:
14292: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
14297:
14298: l_column_value := p_attribute10;
14299:
14300: END IF;
14301: FND_FLEX_DESCVAL.Set_Column_Value
14302: ( column_name => 'ATTRIBUTE10'
14303: , column_value => l_column_value);
14304:
14305: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
14310:
14311: l_column_value := p_attribute11;
14312:
14313: END IF;
14314: FND_FLEX_DESCVAL.Set_Column_Value
14315: ( column_name => 'ATTRIBUTE11'
14316: , column_value => l_column_value);
14317:
14318: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
14323:
14324: l_column_value := p_attribute12;
14325:
14326: END IF;
14327: FND_FLEX_DESCVAL.Set_Column_Value
14328: ( column_name => 'ATTRIBUTE12'
14329: , column_value => l_column_value);
14330:
14331: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
14336:
14337: l_column_value := p_attribute13;
14338:
14339: END IF;
14340: FND_FLEX_DESCVAL.Set_Column_Value
14341: ( column_name => 'ATTRIBUTE13'
14342: , column_value => l_column_value);
14343:
14344: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
14349:
14350: l_column_value := p_attribute14;
14351:
14352: END IF;
14353: FND_FLEX_DESCVAL.Set_Column_Value
14354: ( column_name => 'ATTRIBUTE14'
14355: , column_value => l_column_value);
14356:
14357: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
14362:
14363: l_column_value := p_attribute15;
14364:
14365: END IF;
14366: FND_FLEX_DESCVAL.Set_Column_Value
14367: ( column_name => 'ATTRIBUTE15'
14368: , column_value => l_column_value);
14369:
14370: IF p_attribute16 = FND_API.G_MISS_CHAR THEN -- For bug 2184255
14375:
14376: l_column_value := p_attribute16;
14377:
14378: END IF;
14379: FND_FLEX_DESCVAL.Set_Column_Value
14380: ( column_name => 'ATTRIBUTE16'
14381: , column_value => l_column_value);
14382:
14383: IF p_attribute17 = FND_API.G_MISS_CHAR THEN
14388:
14389: l_column_value := p_attribute17;
14390:
14391: END IF;
14392: FND_FLEX_DESCVAL.Set_Column_Value
14393: ( column_name => 'ATTRIBUTE17'
14394: , column_value => l_column_value);
14395:
14396: IF p_attribute18 = FND_API.G_MISS_CHAR THEN
14401:
14402: l_column_value := p_attribute18;
14403:
14404: END IF;
14405: FND_FLEX_DESCVAL.Set_Column_Value
14406: ( column_name => 'ATTRIBUTE18'
14407: , column_value => l_column_value);
14408:
14409: IF p_attribute19 = FND_API.G_MISS_CHAR THEN
14414:
14415: l_column_value := p_attribute19;
14416:
14417: END IF;
14418: FND_FLEX_DESCVAL.Set_Column_Value
14419: ( column_name => 'ATTRIBUTE19'
14420: , column_value => l_column_value);
14421:
14422: IF p_attribute20 = FND_API.G_MISS_CHAR THEN
14427:
14428: l_column_value := p_attribute20;
14429:
14430: END IF;
14431: FND_FLEX_DESCVAL.Set_Column_Value
14432: ( column_name => 'ATTRIBUTE20'
14433: , column_value => l_column_value); -- End bug 2184255
14434:
14435: IF p_context = FND_API.G_MISS_CHAR THEN
14440:
14441: l_column_value := p_context;
14442:
14443: END IF;
14444: FND_FLEX_DESCVAL.Set_Context_Value
14445: ( context_value => l_column_value);
14446:
14447: IF NOT OE_CNCL_Validate.Desc_Flex('OE_HEADER_ATTRIBUTES') THEN
14448: RETURN FALSE;
14536: l_column_value := p_attribute1;
14537:
14538: END IF;
14539:
14540: FND_FLEX_DESCVAL.Set_Column_Value
14541: ( column_name => 'GLOBAL_ATTRIBUTE1'
14542: , column_value => l_column_value);
14543:
14544:
14550:
14551: l_column_value := p_attribute2;
14552:
14553: END IF;
14554: FND_FLEX_DESCVAL.Set_Column_Value
14555: ( column_name => 'GLOBAL_ATTRIBUTE2'
14556: , column_value => l_column_value);
14557:
14558: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
14563:
14564: l_column_value := p_attribute3;
14565:
14566: END IF;
14567: FND_FLEX_DESCVAL.Set_Column_Value
14568: ( column_name => 'GLOBAL_ATTRIBUTE3'
14569: , column_value => l_column_value);
14570:
14571: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
14576:
14577: l_column_value := p_attribute4;
14578:
14579: END IF;
14580: FND_FLEX_DESCVAL.Set_Column_Value
14581: ( column_name => 'GLOBAL_ATTRIBUTE4'
14582: , column_value => l_column_value);
14583:
14584: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
14589:
14590: l_column_value := p_attribute5;
14591:
14592: END IF;
14593: FND_FLEX_DESCVAL.Set_Column_Value
14594: ( column_name => 'GLOBAL_ATTRIBUTE5'
14595: , column_value => l_column_value);
14596:
14597: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
14602:
14603: l_column_value := p_attribute6;
14604:
14605: END IF;
14606: FND_FLEX_DESCVAL.Set_Column_Value
14607: ( column_name => 'GLOBAL_ATTRIBUTE6'
14608: , column_value => l_column_value);
14609:
14610: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
14615:
14616: l_column_value := p_attribute7;
14617:
14618: END IF;
14619: FND_FLEX_DESCVAL.Set_Column_Value
14620: ( column_name => 'GLOBAL_ATTRIBUTE7'
14621: , column_value => l_column_value);
14622:
14623: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
14628:
14629: l_column_value := p_attribute8;
14630:
14631: END IF;
14632: FND_FLEX_DESCVAL.Set_Column_Value
14633: ( column_name => 'GLOBAL_ATTRIBUTE8'
14634: , column_value => l_column_value);
14635:
14636: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
14641:
14642: l_column_value := p_attribute9;
14643:
14644: END IF;
14645: FND_FLEX_DESCVAL.Set_Column_Value
14646: ( column_name => 'GLOBAL_ATTRIBUTE9'
14647: , column_value => l_column_value);
14648:
14649: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
14654:
14655: l_column_value := p_attribute10;
14656:
14657: END IF;
14658: FND_FLEX_DESCVAL.Set_Column_Value
14659: ( column_name => 'GLOBAL_ATTRIBUTE10'
14660: , column_value => l_column_value);
14661:
14662: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
14667:
14668: l_column_value := p_attribute11;
14669:
14670: END IF;
14671: FND_FLEX_DESCVAL.Set_Column_Value
14672: ( column_name => 'GLOBAL_ATTRIBUTE11'
14673: , column_value => l_column_value);
14674:
14675: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
14680:
14681: l_column_value := p_attribute12;
14682:
14683: END IF;
14684: FND_FLEX_DESCVAL.Set_Column_Value
14685: ( column_name => 'GLOBAL_ATTRIBUTE12'
14686: , column_value => l_column_value);
14687:
14688: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
14693:
14694: l_column_value := p_attribute13;
14695:
14696: END IF;
14697: FND_FLEX_DESCVAL.Set_Column_Value
14698: ( column_name => 'GLOBAL_ATTRIBUTE13'
14699: , column_value => l_column_value);
14700:
14701: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
14706:
14707: l_column_value := p_attribute14;
14708:
14709: END IF;
14710: FND_FLEX_DESCVAL.Set_Column_Value
14711: ( column_name => 'GLOBAL_ATTRIBUTE14'
14712: , column_value => l_column_value);
14713:
14714: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
14719:
14720: l_column_value := p_attribute15;
14721:
14722: END IF;
14723: FND_FLEX_DESCVAL.Set_Column_Value
14724: ( column_name => 'GLOBAL_ATTRIBUTE15'
14725: , column_value => l_column_value);
14726:
14727: IF p_attribute16 = FND_API.G_MISS_CHAR THEN
14733: l_column_value := p_attribute16;
14734:
14735: END IF;
14736:
14737: FND_FLEX_DESCVAL.Set_Column_Value
14738: ( column_name => 'GLOBAL_ATTRIBUTE16'
14739: , column_value => l_column_value);
14740:
14741: IF p_attribute17 = FND_API.G_MISS_CHAR THEN
14746:
14747: l_column_value := p_attribute17;
14748:
14749: END IF;
14750: FND_FLEX_DESCVAL.Set_Column_Value
14751: ( column_name => 'GLOBAL_ATTRIBUTE17'
14752: , column_value => l_column_value);
14753:
14754: IF p_attribute18 = FND_API.G_MISS_CHAR THEN
14759:
14760: l_column_value := p_attribute18;
14761:
14762: END IF;
14763: FND_FLEX_DESCVAL.Set_Column_Value
14764: ( column_name => 'GLOBAL_ATTRIBUTE18'
14765: , column_value => l_column_value);
14766:
14767: IF p_attribute19 = FND_API.G_MISS_CHAR THEN
14772:
14773: l_column_value := p_attribute19;
14774:
14775: END IF;
14776: FND_FLEX_DESCVAL.Set_Column_Value
14777: ( column_name => 'GLOBAL_ATTRIBUTE19'
14778: , column_value => l_column_value);
14779:
14780: IF p_attribute20 = FND_API.G_MISS_CHAR THEN
14785:
14786: l_column_value := p_attribute20;
14787:
14788: END IF;
14789: FND_FLEX_DESCVAL.Set_Column_Value
14790: ( column_name => 'GLOBAL_ATTRIBUTE20'
14791: , column_value => l_column_value);
14792:
14793: IF p_context = FND_API.G_MISS_CHAR THEN
14798:
14799: l_column_value := p_context;
14800:
14801: END IF;
14802: FND_FLEX_DESCVAL.Set_Context_Value
14803: ( context_value => l_column_value);
14804:
14805: IF NOT OE_CNCL_Validate.Desc_Flex('OE_HEADER_GLOBAL_ATTRIBUTE') THEN
14806: RETURN FALSE;
14880: l_column_value := p_attribute1;
14881:
14882: END IF;
14883:
14884: FND_FLEX_DESCVAL.Set_Column_Value
14885: ( column_name => 'TP_ATTRIBUTE1'
14886: , column_value => l_column_value);
14887:
14888:
14894:
14895: l_column_value := p_attribute2;
14896:
14897: END IF;
14898: FND_FLEX_DESCVAL.Set_Column_Value
14899: ( column_name => 'TP_ATTRIBUTE2'
14900: , column_value => l_column_value);
14901:
14902: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
14907:
14908: l_column_value := p_attribute3;
14909:
14910: END IF;
14911: FND_FLEX_DESCVAL.Set_Column_Value
14912: ( column_name => 'TP_ATTRIBUTE3'
14913: , column_value => l_column_value);
14914:
14915: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
14920:
14921: l_column_value := p_attribute4;
14922:
14923: END IF;
14924: FND_FLEX_DESCVAL.Set_Column_Value
14925: ( column_name => 'TP_ATTRIBUTE4'
14926: , column_value => l_column_value);
14927:
14928: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
14933:
14934: l_column_value := p_attribute5;
14935:
14936: END IF;
14937: FND_FLEX_DESCVAL.Set_Column_Value
14938: ( column_name => 'TP_ATTRIBUTE5'
14939: , column_value => l_column_value);
14940:
14941: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
14946:
14947: l_column_value := p_attribute6;
14948:
14949: END IF;
14950: FND_FLEX_DESCVAL.Set_Column_Value
14951: ( column_name => 'TP_ATTRIBUTE6'
14952: , column_value => l_column_value);
14953:
14954: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
14959:
14960: l_column_value := p_attribute7;
14961:
14962: END IF;
14963: FND_FLEX_DESCVAL.Set_Column_Value
14964: ( column_name => 'TP_ATTRIBUTE7'
14965: , column_value => l_column_value);
14966:
14967: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
14972:
14973: l_column_value := p_attribute8;
14974:
14975: END IF;
14976: FND_FLEX_DESCVAL.Set_Column_Value
14977: ( column_name => 'TP_ATTRIBUTE8'
14978: , column_value => l_column_value);
14979:
14980: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
14985:
14986: l_column_value := p_attribute9;
14987:
14988: END IF;
14989: FND_FLEX_DESCVAL.Set_Column_Value
14990: ( column_name => 'TP_ATTRIBUTE9'
14991: , column_value => l_column_value);
14992:
14993: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
14998:
14999: l_column_value := p_attribute10;
15000:
15001: END IF;
15002: FND_FLEX_DESCVAL.Set_Column_Value
15003: ( column_name => 'TP_ATTRIBUTE10'
15004: , column_value => l_column_value);
15005:
15006: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
15011:
15012: l_column_value := p_attribute11;
15013:
15014: END IF;
15015: FND_FLEX_DESCVAL.Set_Column_Value
15016: ( column_name => 'TP_ATTRIBUTE11'
15017: , column_value => l_column_value);
15018:
15019: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
15024:
15025: l_column_value := p_attribute12;
15026:
15027: END IF;
15028: FND_FLEX_DESCVAL.Set_Column_Value
15029: ( column_name => 'TP_ATTRIBUTE12'
15030: , column_value => l_column_value);
15031:
15032: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
15037:
15038: l_column_value := p_attribute13;
15039:
15040: END IF;
15041: FND_FLEX_DESCVAL.Set_Column_Value
15042: ( column_name => 'TP_ATTRIBUTE13'
15043: , column_value => l_column_value);
15044:
15045: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
15050:
15051: l_column_value := p_attribute14;
15052:
15053: END IF;
15054: FND_FLEX_DESCVAL.Set_Column_Value
15055: ( column_name => 'TP_ATTRIBUTE14'
15056: , column_value => l_column_value);
15057:
15058: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
15063:
15064: l_column_value := p_attribute15;
15065:
15066: END IF;
15067: FND_FLEX_DESCVAL.Set_Column_Value
15068: ( column_name => 'TP_ATTRIBUTE15'
15069: , column_value => l_column_value);
15070:
15071:
15077:
15078: l_column_value := p_context;
15079:
15080: END IF;
15081: FND_FLEX_DESCVAL.Set_Context_Value
15082: ( context_value => l_column_value);
15083:
15084: IF NOT OE_CNCL_Validate.Desc_Flex('OE_HEADER_TP_ATTRIBUTES') THEN
15085: RETURN FALSE;
15174: l_column_value := p_attribute1;
15175:
15176: END IF;
15177:
15178: FND_FLEX_DESCVAL.Set_Column_Value
15179: ( column_name => 'ATTRIBUTE1'
15180: , column_value => l_column_value);
15181:
15182:
15188:
15189: l_column_value := p_attribute2;
15190:
15191: END IF;
15192: FND_FLEX_DESCVAL.Set_Column_Value
15193: ( column_name => 'ATTRIBUTE2'
15194: , column_value => l_column_value);
15195:
15196: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
15201:
15202: l_column_value := p_attribute3;
15203:
15204: END IF;
15205: FND_FLEX_DESCVAL.Set_Column_Value
15206: ( column_name => 'ATTRIBUTE3'
15207: , column_value => l_column_value);
15208:
15209: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
15214:
15215: l_column_value := p_attribute4;
15216:
15217: END IF;
15218: FND_FLEX_DESCVAL.Set_Column_Value
15219: ( column_name => 'ATTRIBUTE4'
15220: , column_value => l_column_value);
15221:
15222: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
15227:
15228: l_column_value := p_attribute5;
15229:
15230: END IF;
15231: FND_FLEX_DESCVAL.Set_Column_Value
15232: ( column_name => 'ATTRIBUTE5'
15233: , column_value => l_column_value);
15234:
15235: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
15240:
15241: l_column_value := p_attribute6;
15242:
15243: END IF;
15244: FND_FLEX_DESCVAL.Set_Column_Value
15245: ( column_name => 'ATTRIBUTE6'
15246: , column_value => l_column_value);
15247:
15248: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
15253:
15254: l_column_value := p_attribute7;
15255:
15256: END IF;
15257: FND_FLEX_DESCVAL.Set_Column_Value
15258: ( column_name => 'ATTRIBUTE7'
15259: , column_value => l_column_value);
15260:
15261: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
15266:
15267: l_column_value := p_attribute8;
15268:
15269: END IF;
15270: FND_FLEX_DESCVAL.Set_Column_Value
15271: ( column_name => 'ATTRIBUTE8'
15272: , column_value => l_column_value);
15273:
15274: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
15279:
15280: l_column_value := p_attribute9;
15281:
15282: END IF;
15283: FND_FLEX_DESCVAL.Set_Column_Value
15284: ( column_name => 'ATTRIBUTE9'
15285: , column_value => l_column_value);
15286:
15287: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
15292:
15293: l_column_value := p_attribute10;
15294:
15295: END IF;
15296: FND_FLEX_DESCVAL.Set_Column_Value
15297: ( column_name => 'ATTRIBUTE10'
15298: , column_value => l_column_value);
15299:
15300: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
15305:
15306: l_column_value := p_attribute11;
15307:
15308: END IF;
15309: FND_FLEX_DESCVAL.Set_Column_Value
15310: ( column_name => 'ATTRIBUTE11'
15311: , column_value => l_column_value);
15312:
15313: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
15318:
15319: l_column_value := p_attribute12;
15320:
15321: END IF;
15322: FND_FLEX_DESCVAL.Set_Column_Value
15323: ( column_name => 'ATTRIBUTE12'
15324: , column_value => l_column_value);
15325:
15326: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
15331:
15332: l_column_value := p_attribute13;
15333:
15334: END IF;
15335: FND_FLEX_DESCVAL.Set_Column_Value
15336: ( column_name => 'ATTRIBUTE13'
15337: , column_value => l_column_value);
15338:
15339: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
15344:
15345: l_column_value := p_attribute14;
15346:
15347: END IF;
15348: FND_FLEX_DESCVAL.Set_Column_Value
15349: ( column_name => 'ATTRIBUTE14'
15350: , column_value => l_column_value);
15351:
15352: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
15357:
15358: l_column_value := p_attribute15;
15359:
15360: END IF;
15361: FND_FLEX_DESCVAL.Set_Column_Value
15362: ( column_name => 'ATTRIBUTE15'
15363: , column_value => l_column_value);
15364:
15365: IF p_attribute16 = FND_API.G_MISS_CHAR THEN -- For bug 2184255
15370:
15371: l_column_value := p_attribute16;
15372:
15373: END IF;
15374: FND_FLEX_DESCVAL.Set_Column_Value
15375: ( column_name => 'ATTRIBUTE16'
15376: , column_value => l_column_value);
15377:
15378: IF p_attribute17 = FND_API.G_MISS_CHAR THEN
15383:
15384: l_column_value := p_attribute17;
15385:
15386: END IF;
15387: FND_FLEX_DESCVAL.Set_Column_Value
15388: ( column_name => 'ATTRIBUTE17'
15389: , column_value => l_column_value);
15390:
15391: IF p_attribute18 = FND_API.G_MISS_CHAR THEN
15396:
15397: l_column_value := p_attribute18;
15398:
15399: END IF;
15400: FND_FLEX_DESCVAL.Set_Column_Value
15401: ( column_name => 'ATTRIBUTE18'
15402: , column_value => l_column_value);
15403:
15404: IF p_attribute19 = FND_API.G_MISS_CHAR THEN
15409:
15410: l_column_value := p_attribute19;
15411:
15412: END IF;
15413: FND_FLEX_DESCVAL.Set_Column_Value
15414: ( column_name => 'ATTRIBUTE19'
15415: , column_value => l_column_value);
15416:
15417: IF p_attribute20 = FND_API.G_MISS_CHAR THEN
15422:
15423: l_column_value := p_attribute20;
15424:
15425: END IF;
15426: FND_FLEX_DESCVAL.Set_Column_Value
15427: ( column_name => 'ATTRIBUTE20'
15428: , column_value => l_column_value); --End bug 2184255
15429:
15430: IF p_context = FND_API.G_MISS_CHAR THEN
15435:
15436: l_column_value := p_context;
15437:
15438: END IF;
15439: FND_FLEX_DESCVAL.Set_Context_Value
15440: ( context_value => l_column_value);
15441:
15442: IF NOT OE_CNCL_Validate.Desc_Flex('OE_LINE_ATTRIBUTES') THEN
15443: RETURN FALSE;
15531: l_column_value := p_attribute1;
15532:
15533: END IF;
15534:
15535: FND_FLEX_DESCVAL.Set_Column_Value
15536: ( column_name => 'GLOBAL_ATTRIBUTE1'
15537: , column_value => l_column_value);
15538:
15539:
15545:
15546: l_column_value := p_attribute2;
15547:
15548: END IF;
15549: FND_FLEX_DESCVAL.Set_Column_Value
15550: ( column_name => 'GLOBAL_ATTRIBUTE2'
15551: , column_value => l_column_value);
15552:
15553: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
15558:
15559: l_column_value := p_attribute3;
15560:
15561: END IF;
15562: FND_FLEX_DESCVAL.Set_Column_Value
15563: ( column_name => 'GLOBAL_ATTRIBUTE3'
15564: , column_value => l_column_value);
15565:
15566: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
15571:
15572: l_column_value := p_attribute4;
15573:
15574: END IF;
15575: FND_FLEX_DESCVAL.Set_Column_Value
15576: ( column_name => 'GLOBAL_ATTRIBUTE4'
15577: , column_value => l_column_value);
15578:
15579: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
15584:
15585: l_column_value := p_attribute5;
15586:
15587: END IF;
15588: FND_FLEX_DESCVAL.Set_Column_Value
15589: ( column_name => 'GLOBAL_ATTRIBUTE5'
15590: , column_value => l_column_value);
15591:
15592: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
15597:
15598: l_column_value := p_attribute6;
15599:
15600: END IF;
15601: FND_FLEX_DESCVAL.Set_Column_Value
15602: ( column_name => 'GLOBAL_ATTRIBUTE6'
15603: , column_value => l_column_value);
15604:
15605: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
15610:
15611: l_column_value := p_attribute7;
15612:
15613: END IF;
15614: FND_FLEX_DESCVAL.Set_Column_Value
15615: ( column_name => 'GLOBAL_ATTRIBUTE7'
15616: , column_value => l_column_value);
15617:
15618: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
15623:
15624: l_column_value := p_attribute8;
15625:
15626: END IF;
15627: FND_FLEX_DESCVAL.Set_Column_Value
15628: ( column_name => 'GLOBAL_ATTRIBUTE8'
15629: , column_value => l_column_value);
15630:
15631: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
15636:
15637: l_column_value := p_attribute9;
15638:
15639: END IF;
15640: FND_FLEX_DESCVAL.Set_Column_Value
15641: ( column_name => 'GLOBAL_ATTRIBUTE9'
15642: , column_value => l_column_value);
15643:
15644: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
15649:
15650: l_column_value := p_attribute10;
15651:
15652: END IF;
15653: FND_FLEX_DESCVAL.Set_Column_Value
15654: ( column_name => 'GLOBAL_ATTRIBUTE10'
15655: , column_value => l_column_value);
15656:
15657: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
15662:
15663: l_column_value := p_attribute11;
15664:
15665: END IF;
15666: FND_FLEX_DESCVAL.Set_Column_Value
15667: ( column_name => 'GLOBAL_ATTRIBUTE11'
15668: , column_value => l_column_value);
15669:
15670: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
15675:
15676: l_column_value := p_attribute12;
15677:
15678: END IF;
15679: FND_FLEX_DESCVAL.Set_Column_Value
15680: ( column_name => 'GLOBAL_ATTRIBUTE12'
15681: , column_value => l_column_value);
15682:
15683: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
15688:
15689: l_column_value := p_attribute13;
15690:
15691: END IF;
15692: FND_FLEX_DESCVAL.Set_Column_Value
15693: ( column_name => 'GLOBAL_ATTRIBUTE13'
15694: , column_value => l_column_value);
15695:
15696: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
15701:
15702: l_column_value := p_attribute14;
15703:
15704: END IF;
15705: FND_FLEX_DESCVAL.Set_Column_Value
15706: ( column_name => 'GLOBAL_ATTRIBUTE14'
15707: , column_value => l_column_value);
15708:
15709: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
15714:
15715: l_column_value := p_attribute15;
15716:
15717: END IF;
15718: FND_FLEX_DESCVAL.Set_Column_Value
15719: ( column_name => 'GLOBAL_ATTRIBUTE15'
15720: , column_value => l_column_value);
15721:
15722: IF p_attribute16 = FND_API.G_MISS_CHAR THEN
15728: l_column_value := p_attribute16;
15729:
15730: END IF;
15731:
15732: FND_FLEX_DESCVAL.Set_Column_Value
15733: ( column_name => 'GLOBAL_ATTRIBUTE16'
15734: , column_value => l_column_value);
15735:
15736: IF p_attribute17 = FND_API.G_MISS_CHAR THEN
15741:
15742: l_column_value := p_attribute17;
15743:
15744: END IF;
15745: FND_FLEX_DESCVAL.Set_Column_Value
15746: ( column_name => 'GLOBAL_ATTRIBUTE17'
15747: , column_value => l_column_value);
15748:
15749: IF p_attribute18 = FND_API.G_MISS_CHAR THEN
15754:
15755: l_column_value := p_attribute18;
15756:
15757: END IF;
15758: FND_FLEX_DESCVAL.Set_Column_Value
15759: ( column_name => 'GLOBAL_ATTRIBUTE18'
15760: , column_value => l_column_value);
15761:
15762: IF p_attribute19 = FND_API.G_MISS_CHAR THEN
15767:
15768: l_column_value := p_attribute19;
15769:
15770: END IF;
15771: FND_FLEX_DESCVAL.Set_Column_Value
15772: ( column_name => 'GLOBAL_ATTRIBUTE19'
15773: , column_value => l_column_value);
15774:
15775: IF p_attribute20 = FND_API.G_MISS_CHAR THEN
15780:
15781: l_column_value := p_attribute20;
15782:
15783: END IF;
15784: FND_FLEX_DESCVAL.Set_Column_Value
15785: ( column_name => 'GLOBAL_ATTRIBUTE20'
15786: , column_value => l_column_value);
15787:
15788: IF p_context = FND_API.G_MISS_CHAR THEN
15793:
15794: l_column_value := p_context;
15795:
15796: END IF;
15797: FND_FLEX_DESCVAL.Set_Context_Value
15798: ( context_value => l_column_value);
15799: /* commenting this code due to bug# 993103
15800: IF NOT OE_CNCL_Validate.Desc_Flex('OE_LINE_GLOBAL_ATTRIBUTE') THEN
15801:
15868: l_column_value := p_attribute1;
15869:
15870: END IF;
15871:
15872: FND_FLEX_DESCVAL.Set_Column_Value
15873: ( column_name => 'PRICING_ATTRIBUTE1'
15874: , column_value => l_column_value);
15875:
15876:
15882:
15883: l_column_value := p_attribute2;
15884:
15885: END IF;
15886: FND_FLEX_DESCVAL.Set_Column_Value
15887: ( column_name => 'PRICING_ATTRIBUTE2'
15888: , column_value => l_column_value);
15889:
15890: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
15895:
15896: l_column_value := p_attribute3;
15897:
15898: END IF;
15899: FND_FLEX_DESCVAL.Set_Column_Value
15900: ( column_name => 'PRICING_ATTRIBUTE3'
15901: , column_value => l_column_value);
15902:
15903: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
15908:
15909: l_column_value := p_attribute4;
15910:
15911: END IF;
15912: FND_FLEX_DESCVAL.Set_Column_Value
15913: ( column_name => 'PRICING_ATTRIBUTE4'
15914: , column_value => l_column_value);
15915:
15916: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
15921:
15922: l_column_value := p_attribute5;
15923:
15924: END IF;
15925: FND_FLEX_DESCVAL.Set_Column_Value
15926: ( column_name => 'PRICING_ATTRIBUTE5'
15927: , column_value => l_column_value);
15928:
15929: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
15934:
15935: l_column_value := p_attribute6;
15936:
15937: END IF;
15938: FND_FLEX_DESCVAL.Set_Column_Value
15939: ( column_name => 'PRICING_ATTRIBUTE6'
15940: , column_value => l_column_value);
15941:
15942: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
15947:
15948: l_column_value := p_attribute7;
15949:
15950: END IF;
15951: FND_FLEX_DESCVAL.Set_Column_Value
15952: ( column_name => 'PRICING_ATTRIBUTE7'
15953: , column_value => l_column_value);
15954:
15955: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
15960:
15961: l_column_value := p_attribute8;
15962:
15963: END IF;
15964: FND_FLEX_DESCVAL.Set_Column_Value
15965: ( column_name => 'PRICING_ATTRIBUTE8'
15966: , column_value => l_column_value);
15967:
15968: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
15973:
15974: l_column_value := p_attribute9;
15975:
15976: END IF;
15977: FND_FLEX_DESCVAL.Set_Column_Value
15978: ( column_name => 'PRICING_ATTRIBUTE9'
15979: , column_value => l_column_value);
15980:
15981: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
15986:
15987: l_column_value := p_attribute10;
15988:
15989: END IF;
15990: FND_FLEX_DESCVAL.Set_Column_Value
15991: ( column_name => 'PRICING_ATTRIBUTE10'
15992: , column_value => l_column_value);
15993:
15994:
16000:
16001: l_column_value := p_context;
16002:
16003: END IF;
16004: FND_FLEX_DESCVAL.Set_Context_Value
16005: ( context_value => l_column_value);
16006:
16007: IF NOT OE_CNCL_Validate.Desc_Flex('OE_LINE_PRICING_ATTRIBUTE') THEN
16008: RETURN FALSE;
16119: l_column_value := p_attribute1;
16120:
16121: END IF;
16122:
16123: FND_FLEX_DESCVAL.Set_Column_Value
16124: ( column_name => 'INDUSTRY_ATTRIBUTE1'
16125: , column_value => l_column_value);
16126:
16127:
16133:
16134: l_column_value := p_attribute2;
16135:
16136: END IF;
16137: FND_FLEX_DESCVAL.Set_Column_Value
16138: ( column_name => 'INDUSTRY_ATTRIBUTE2'
16139: , column_value => l_column_value);
16140:
16141: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
16146:
16147: l_column_value := p_attribute3;
16148:
16149: END IF;
16150: FND_FLEX_DESCVAL.Set_Column_Value
16151: ( column_name => 'INDUSTRY_ATTRIBUTE3'
16152: , column_value => l_column_value);
16153:
16154: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
16159:
16160: l_column_value := p_attribute4;
16161:
16162: END IF;
16163: FND_FLEX_DESCVAL.Set_Column_Value
16164: ( column_name => 'INDUSTRY_ATTRIBUTE4'
16165: , column_value => l_column_value);
16166:
16167: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
16172:
16173: l_column_value := p_attribute5;
16174:
16175: END IF;
16176: FND_FLEX_DESCVAL.Set_Column_Value
16177: ( column_name => 'INDUSTRY_ATTRIBUTE5'
16178: , column_value => l_column_value);
16179:
16180: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
16185:
16186: l_column_value := p_attribute6;
16187:
16188: END IF;
16189: FND_FLEX_DESCVAL.Set_Column_Value
16190: ( column_name => 'INDUSTRY_ATTRIBUTE6'
16191: , column_value => l_column_value);
16192:
16193: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
16198:
16199: l_column_value := p_attribute7;
16200:
16201: END IF;
16202: FND_FLEX_DESCVAL.Set_Column_Value
16203: ( column_name => 'INDUSTRY_ATTRIBUTE7'
16204: , column_value => l_column_value);
16205:
16206: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
16211:
16212: l_column_value := p_attribute8;
16213:
16214: END IF;
16215: FND_FLEX_DESCVAL.Set_Column_Value
16216: ( column_name => 'INDUSTRY_ATTRIBUTE8'
16217: , column_value => l_column_value);
16218:
16219: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
16224:
16225: l_column_value := p_attribute9;
16226:
16227: END IF;
16228: FND_FLEX_DESCVAL.Set_Column_Value
16229: ( column_name => 'INDUSTRY_ATTRIBUTE9'
16230: , column_value => l_column_value);
16231:
16232: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
16237:
16238: l_column_value := p_attribute10;
16239:
16240: END IF;
16241: FND_FLEX_DESCVAL.Set_Column_Value
16242: ( column_name => 'INDUSTRY_ATTRIBUTE10'
16243: , column_value => l_column_value);
16244:
16245: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
16250:
16251: l_column_value := p_attribute11;
16252:
16253: END IF;
16254: FND_FLEX_DESCVAL.Set_Column_Value
16255: ( column_name => 'INDUSTRY_ATTRIBUTE11'
16256: , column_value => l_column_value);
16257:
16258: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
16263:
16264: l_column_value := p_attribute12;
16265:
16266: END IF;
16267: FND_FLEX_DESCVAL.Set_Column_Value
16268: ( column_name => 'INDUSTRY_ATTRIBUTE12'
16269: , column_value => l_column_value);
16270:
16271: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
16276:
16277: l_column_value := p_attribute13;
16278:
16279: END IF;
16280: FND_FLEX_DESCVAL.Set_Column_Value
16281: ( column_name => 'INDUSTRY_ATTRIBUTE13'
16282: , column_value => l_column_value);
16283:
16284: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
16289:
16290: l_column_value := p_attribute14;
16291:
16292: END IF;
16293: FND_FLEX_DESCVAL.Set_Column_Value
16294: ( column_name => 'INDUSTRY_ATTRIBUTE14'
16295: , column_value => l_column_value);
16296:
16297: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
16302:
16303: l_column_value := p_attribute15;
16304:
16305: END IF;
16306: FND_FLEX_DESCVAL.Set_Column_Value
16307: ( column_name => 'INDUSTRY_ATTRIBUTE15'
16308: , column_value => l_column_value);
16309:
16310: IF p_attribute16 = FND_API.G_MISS_CHAR THEN
16315:
16316: l_column_value := p_attribute16;
16317:
16318: END IF;
16319: FND_FLEX_DESCVAL.Set_Column_Value
16320: ( column_name => 'INDUSTRY_ATTRIBUTE16'
16321: , column_value => l_column_value);
16322:
16323: IF p_attribute17 = FND_API.G_MISS_CHAR THEN
16328:
16329: l_column_value := p_attribute17;
16330:
16331: END IF;
16332: FND_FLEX_DESCVAL.Set_Column_Value
16333: ( column_name => 'INDUSTRY_ATTRIBUTE17'
16334: , column_value => l_column_value);
16335:
16336: IF p_attribute18 = FND_API.G_MISS_CHAR THEN
16341:
16342: l_column_value := p_attribute18;
16343:
16344: END IF;
16345: FND_FLEX_DESCVAL.Set_Column_Value
16346: ( column_name => 'INDUSTRY_ATTRIBUTE18'
16347: , column_value => l_column_value);
16348:
16349: IF p_attribute19 = FND_API.G_MISS_CHAR THEN
16354:
16355: l_column_value := p_attribute19;
16356:
16357: END IF;
16358: FND_FLEX_DESCVAL.Set_Column_Value
16359: ( column_name => 'INDUSTRY_ATTRIBUTE19'
16360: , column_value => l_column_value);
16361:
16362: IF p_attribute20 = FND_API.G_MISS_CHAR THEN
16367:
16368: l_column_value := p_attribute20;
16369:
16370: END IF;
16371: FND_FLEX_DESCVAL.Set_Column_Value
16372: ( column_name => 'INDUSTRY_ATTRIBUTE20'
16373: , column_value => l_column_value);
16374:
16375: IF p_attribute21 = FND_API.G_MISS_CHAR THEN
16380:
16381: l_column_value := p_attribute21;
16382:
16383: END IF;
16384: FND_FLEX_DESCVAL.Set_Column_Value
16385: ( column_name => 'INDUSTRY_ATTRIBUTE21'
16386: , column_value => l_column_value);
16387:
16388: IF p_attribute22 = FND_API.G_MISS_CHAR THEN
16393:
16394: l_column_value := p_attribute22;
16395:
16396: END IF;
16397: FND_FLEX_DESCVAL.Set_Column_Value
16398: ( column_name => 'INDUSTRY_ATTRIBUTE22'
16399: , column_value => l_column_value);
16400:
16401: IF p_attribute23 = FND_API.G_MISS_CHAR THEN
16406:
16407: l_column_value := p_attribute23;
16408:
16409: END IF;
16410: FND_FLEX_DESCVAL.Set_Column_Value
16411: ( column_name => 'INDUSTRY_ATTRIBUTE23'
16412: , column_value => l_column_value);
16413:
16414: IF p_attribute24 = FND_API.G_MISS_CHAR THEN
16419:
16420: l_column_value := p_attribute24;
16421:
16422: END IF;
16423: FND_FLEX_DESCVAL.Set_Column_Value
16424: ( column_name => 'INDUSTRY_ATTRIBUTE24'
16425: , column_value => l_column_value);
16426:
16427: IF p_attribute25 = FND_API.G_MISS_CHAR THEN
16432:
16433: l_column_value := p_attribute25;
16434:
16435: END IF;
16436: FND_FLEX_DESCVAL.Set_Column_Value
16437: ( column_name => 'INDUSTRY_ATTRIBUTE25'
16438: , column_value => l_column_value);
16439:
16440: IF p_attribute26 = FND_API.G_MISS_CHAR THEN
16445:
16446: l_column_value := p_attribute26;
16447:
16448: END IF;
16449: FND_FLEX_DESCVAL.Set_Column_Value
16450: ( column_name => 'INDUSTRY_ATTRIBUTE26'
16451: , column_value => l_column_value);
16452:
16453: IF p_attribute27 = FND_API.G_MISS_CHAR THEN
16458:
16459: l_column_value := p_attribute27;
16460:
16461: END IF;
16462: FND_FLEX_DESCVAL.Set_Column_Value
16463: ( column_name => 'INDUSTRY_ATTRIBUTE27'
16464: , column_value => l_column_value);
16465:
16466: IF p_attribute28 = FND_API.G_MISS_CHAR THEN
16471:
16472: l_column_value := p_attribute28;
16473:
16474: END IF;
16475: FND_FLEX_DESCVAL.Set_Column_Value
16476: ( column_name => 'INDUSTRY_ATTRIBUTE28'
16477: , column_value => l_column_value);
16478:
16479: IF p_attribute29 = FND_API.G_MISS_CHAR THEN
16484:
16485: l_column_value := p_attribute29;
16486:
16487: END IF;
16488: FND_FLEX_DESCVAL.Set_Column_Value
16489: ( column_name => 'INDUSTRY_ATTRIBUTE29'
16490: , column_value => l_column_value);
16491:
16492: IF p_attribute30 = FND_API.G_MISS_CHAR THEN
16497:
16498: l_column_value := p_attribute30;
16499:
16500: END IF;
16501: FND_FLEX_DESCVAL.Set_Column_Value
16502: ( column_name => 'INDUSTRY_ATTRIBUTE30'
16503: , column_value => l_column_value);
16504:
16505:
16512:
16513: l_column_value := p_context;
16514:
16515: END IF;
16516: FND_FLEX_DESCVAL.Set_Context_Value
16517: ( context_value => l_column_value);
16518:
16519: IF NOT OE_CNCL_Validate.Desc_Flex('OE_LINE_INDUSTRY_ATTRIBUTE') THEN
16520: RETURN FALSE;
16600: l_column_value := p_attribute1;
16601:
16602: END IF;
16603:
16604: FND_FLEX_DESCVAL.Set_Column_Value
16605: ( column_name => 'TP_ATTRIBUTE1'
16606: , column_value => l_column_value);
16607:
16608:
16614:
16615: l_column_value := p_attribute2;
16616:
16617: END IF;
16618: FND_FLEX_DESCVAL.Set_Column_Value
16619: ( column_name => 'TP_ATTRIBUTE2'
16620: , column_value => l_column_value);
16621:
16622: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
16627:
16628: l_column_value := p_attribute3;
16629:
16630: END IF;
16631: FND_FLEX_DESCVAL.Set_Column_Value
16632: ( column_name => 'TP_ATTRIBUTE3'
16633: , column_value => l_column_value);
16634:
16635: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
16640:
16641: l_column_value := p_attribute4;
16642:
16643: END IF;
16644: FND_FLEX_DESCVAL.Set_Column_Value
16645: ( column_name => 'TP_ATTRIBUTE4'
16646: , column_value => l_column_value);
16647:
16648: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
16653:
16654: l_column_value := p_attribute5;
16655:
16656: END IF;
16657: FND_FLEX_DESCVAL.Set_Column_Value
16658: ( column_name => 'TP_ATTRIBUTE5'
16659: , column_value => l_column_value);
16660:
16661: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
16666:
16667: l_column_value := p_attribute6;
16668:
16669: END IF;
16670: FND_FLEX_DESCVAL.Set_Column_Value
16671: ( column_name => 'TP_ATTRIBUTE6'
16672: , column_value => l_column_value);
16673:
16674: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
16679:
16680: l_column_value := p_attribute7;
16681:
16682: END IF;
16683: FND_FLEX_DESCVAL.Set_Column_Value
16684: ( column_name => 'TP_ATTRIBUTE7'
16685: , column_value => l_column_value);
16686:
16687: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
16692:
16693: l_column_value := p_attribute8;
16694:
16695: END IF;
16696: FND_FLEX_DESCVAL.Set_Column_Value
16697: ( column_name => 'TP_ATTRIBUTE8'
16698: , column_value => l_column_value);
16699:
16700: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
16705:
16706: l_column_value := p_attribute9;
16707:
16708: END IF;
16709: FND_FLEX_DESCVAL.Set_Column_Value
16710: ( column_name => 'TP_ATTRIBUTE9'
16711: , column_value => l_column_value);
16712:
16713: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
16718:
16719: l_column_value := p_attribute10;
16720:
16721: END IF;
16722: FND_FLEX_DESCVAL.Set_Column_Value
16723: ( column_name => 'TP_ATTRIBUTE10'
16724: , column_value => l_column_value);
16725:
16726: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
16731:
16732: l_column_value := p_attribute11;
16733:
16734: END IF;
16735: FND_FLEX_DESCVAL.Set_Column_Value
16736: ( column_name => 'TP_ATTRIBUTE11'
16737: , column_value => l_column_value);
16738:
16739: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
16744:
16745: l_column_value := p_attribute12;
16746:
16747: END IF;
16748: FND_FLEX_DESCVAL.Set_Column_Value
16749: ( column_name => 'TP_ATTRIBUTE12'
16750: , column_value => l_column_value);
16751:
16752: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
16757:
16758: l_column_value := p_attribute13;
16759:
16760: END IF;
16761: FND_FLEX_DESCVAL.Set_Column_Value
16762: ( column_name => 'TP_ATTRIBUTE13'
16763: , column_value => l_column_value);
16764:
16765: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
16770:
16771: l_column_value := p_attribute14;
16772:
16773: END IF;
16774: FND_FLEX_DESCVAL.Set_Column_Value
16775: ( column_name => 'TP_ATTRIBUTE14'
16776: , column_value => l_column_value);
16777:
16778: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
16783:
16784: l_column_value := p_attribute15;
16785:
16786: END IF;
16787: FND_FLEX_DESCVAL.Set_Column_Value
16788: ( column_name => 'TP_ATTRIBUTE15'
16789: , column_value => l_column_value);
16790:
16791:
16798:
16799: l_column_value := p_context;
16800:
16801: END IF;
16802: FND_FLEX_DESCVAL.Set_Context_Value
16803: ( context_value => l_column_value);
16804:
16805: IF NOT OE_CNCL_Validate.Desc_Flex('OE_LINE_TP_ATTRIBUTES') THEN
16806: RETURN FALSE;
16886: l_column_value := p_attribute1;
16887:
16888: END IF;
16889:
16890: FND_FLEX_DESCVAL.Set_Column_Value
16891: ( column_name => 'RETURN_ATTRIBUTE1'
16892: , column_value => l_column_value);
16893:
16894:
16900:
16901: l_column_value := p_attribute2;
16902:
16903: END IF;
16904: FND_FLEX_DESCVAL.Set_Column_Value
16905: ( column_name => 'RETURN_ATTRIBUTE2'
16906: , column_value => l_column_value);
16907:
16908: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
16913:
16914: l_column_value := p_attribute3;
16915:
16916: END IF;
16917: FND_FLEX_DESCVAL.Set_Column_Value
16918: ( column_name => 'RETURN_ATTRIBUTE3'
16919: , column_value => l_column_value);
16920:
16921: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
16926:
16927: l_column_value := p_attribute4;
16928:
16929: END IF;
16930: FND_FLEX_DESCVAL.Set_Column_Value
16931: ( column_name => 'RETURN_ATTRIBUTE4'
16932: , column_value => l_column_value);
16933:
16934: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
16939:
16940: l_column_value := p_attribute5;
16941:
16942: END IF;
16943: FND_FLEX_DESCVAL.Set_Column_Value
16944: ( column_name => 'RETURN_ATTRIBUTE5'
16945: , column_value => l_column_value);
16946:
16947: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
16952:
16953: l_column_value := p_attribute6;
16954:
16955: END IF;
16956: FND_FLEX_DESCVAL.Set_Column_Value
16957: ( column_name => 'RETURN_ATTRIBUTE6'
16958: , column_value => l_column_value);
16959:
16960: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
16965:
16966: l_column_value := p_attribute7;
16967:
16968: END IF;
16969: FND_FLEX_DESCVAL.Set_Column_Value
16970: ( column_name => 'RETURN_ATTRIBUTE7'
16971: , column_value => l_column_value);
16972:
16973: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
16978:
16979: l_column_value := p_attribute8;
16980:
16981: END IF;
16982: FND_FLEX_DESCVAL.Set_Column_Value
16983: ( column_name => 'RETURN_ATTRIBUTE8'
16984: , column_value => l_column_value);
16985:
16986: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
16991:
16992: l_column_value := p_attribute9;
16993:
16994: END IF;
16995: FND_FLEX_DESCVAL.Set_Column_Value
16996: ( column_name => 'RETURN_ATTRIBUTE9'
16997: , column_value => l_column_value);
16998:
16999: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
17004:
17005: l_column_value := p_attribute10;
17006:
17007: END IF;
17008: FND_FLEX_DESCVAL.Set_Column_Value
17009: ( column_name => 'RETURN_ATTRIBUTE10'
17010: , column_value => l_column_value);
17011:
17012: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
17017:
17018: l_column_value := p_attribute11;
17019:
17020: END IF;
17021: FND_FLEX_DESCVAL.Set_Column_Value
17022: ( column_name => 'RETURN_ATTRIBUTE11'
17023: , column_value => l_column_value);
17024:
17025: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
17030:
17031: l_column_value := p_attribute12;
17032:
17033: END IF;
17034: FND_FLEX_DESCVAL.Set_Column_Value
17035: ( column_name => 'RETURN_ATTRIBUTE12'
17036: , column_value => l_column_value);
17037:
17038: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
17043:
17044: l_column_value := p_attribute13;
17045:
17046: END IF;
17047: FND_FLEX_DESCVAL.Set_Column_Value
17048: ( column_name => 'RETURN_ATTRIBUTE13'
17049: , column_value => l_column_value);
17050:
17051: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
17056:
17057: l_column_value := p_attribute14;
17058:
17059: END IF;
17060: FND_FLEX_DESCVAL.Set_Column_Value
17061: ( column_name => 'RETURN_ATTRIBUTE14'
17062: , column_value => l_column_value);
17063:
17064: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
17069:
17070: l_column_value := p_attribute15;
17071:
17072: END IF;
17073: FND_FLEX_DESCVAL.Set_Column_Value
17074: ( column_name => 'RETURN_ATTRIBUTE15'
17075: , column_value => l_column_value);
17076:
17077: IF p_context = FND_API.G_MISS_CHAR THEN
17083: l_column_value := p_context;
17084:
17085: END IF;
17086:
17087: FND_FLEX_DESCVAL.Set_Context_Value
17088: ( context_value => l_column_value);
17089:
17090:
17091: /* Remove after fixing :block.field_name stuff
17174: l_column_value := p_attribute1;
17175:
17176: END IF;
17177:
17178: FND_FLEX_DESCVAL.Set_Column_Value
17179: ( column_name => 'ATTRIBUTE1'
17180: , column_value => l_column_value);
17181:
17182:
17188:
17189: l_column_value := p_attribute2;
17190:
17191: END IF;
17192: FND_FLEX_DESCVAL.Set_Column_Value
17193: ( column_name => 'ATTRIBUTE2'
17194: , column_value => l_column_value);
17195:
17196: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
17201:
17202: l_column_value := p_attribute3;
17203:
17204: END IF;
17205: FND_FLEX_DESCVAL.Set_Column_Value
17206: ( column_name => 'ATTRIBUTE3'
17207: , column_value => l_column_value);
17208:
17209: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
17214:
17215: l_column_value := p_attribute4;
17216:
17217: END IF;
17218: FND_FLEX_DESCVAL.Set_Column_Value
17219: ( column_name => 'ATTRIBUTE4'
17220: , column_value => l_column_value);
17221:
17222: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
17227:
17228: l_column_value := p_attribute5;
17229:
17230: END IF;
17231: FND_FLEX_DESCVAL.Set_Column_Value
17232: ( column_name => 'ATTRIBUTE5'
17233: , column_value => l_column_value);
17234:
17235: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
17240:
17241: l_column_value := p_attribute6;
17242:
17243: END IF;
17244: FND_FLEX_DESCVAL.Set_Column_Value
17245: ( column_name => 'ATTRIBUTE6'
17246: , column_value => l_column_value);
17247:
17248: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
17253:
17254: l_column_value := p_attribute7;
17255:
17256: END IF;
17257: FND_FLEX_DESCVAL.Set_Column_Value
17258: ( column_name => 'ATTRIBUTE7'
17259: , column_value => l_column_value);
17260:
17261: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
17266:
17267: l_column_value := p_attribute8;
17268:
17269: END IF;
17270: FND_FLEX_DESCVAL.Set_Column_Value
17271: ( column_name => 'ATTRIBUTE8'
17272: , column_value => l_column_value);
17273:
17274: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
17279:
17280: l_column_value := p_attribute9;
17281:
17282: END IF;
17283: FND_FLEX_DESCVAL.Set_Column_Value
17284: ( column_name => 'ATTRIBUTE9'
17285: , column_value => l_column_value);
17286:
17287: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
17292:
17293: l_column_value := p_attribute10;
17294:
17295: END IF;
17296: FND_FLEX_DESCVAL.Set_Column_Value
17297: ( column_name => 'ATTRIBUTE10'
17298: , column_value => l_column_value);
17299:
17300: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
17305:
17306: l_column_value := p_attribute11;
17307:
17308: END IF;
17309: FND_FLEX_DESCVAL.Set_Column_Value
17310: ( column_name => 'ATTRIBUTE11'
17311: , column_value => l_column_value);
17312:
17313: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
17318:
17319: l_column_value := p_attribute12;
17320:
17321: END IF;
17322: FND_FLEX_DESCVAL.Set_Column_Value
17323: ( column_name => 'ATTRIBUTE12'
17324: , column_value => l_column_value);
17325:
17326: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
17331:
17332: l_column_value := p_attribute13;
17333:
17334: END IF;
17335: FND_FLEX_DESCVAL.Set_Column_Value
17336: ( column_name => 'ATTRIBUTE13'
17337: , column_value => l_column_value);
17338:
17339: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
17344:
17345: l_column_value := p_attribute14;
17346:
17347: END IF;
17348: FND_FLEX_DESCVAL.Set_Column_Value
17349: ( column_name => 'ATTRIBUTE14'
17350: , column_value => l_column_value);
17351:
17352: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
17357:
17358: l_column_value := p_attribute15;
17359:
17360: END IF;
17361: FND_FLEX_DESCVAL.Set_Column_Value
17362: ( column_name => 'ATTRIBUTE15'
17363: , column_value => l_column_value);
17364:
17365: IF p_context = FND_API.G_MISS_CHAR THEN
17370:
17371: l_column_value := p_context;
17372:
17373: END IF;
17374: FND_FLEX_DESCVAL.Set_Context_Value
17375: ( context_value => l_column_value);
17376:
17377: IF NOT OE_CNCL_Validate.Desc_Flex('OE_PRICE_ADJUSTMENT') THEN
17378: RETURN FALSE;
17458: l_column_value := p_attribute1;
17459:
17460: END IF;
17461:
17462: FND_FLEX_DESCVAL.Set_Column_Value
17463: ( column_name => 'ATTRIBUTE1'
17464: , column_value => l_column_value);
17465:
17466:
17472:
17473: l_column_value := p_attribute2;
17474:
17475: END IF;
17476: FND_FLEX_DESCVAL.Set_Column_Value
17477: ( column_name => 'ATTRIBUTE2'
17478: , column_value => l_column_value);
17479:
17480: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
17485:
17486: l_column_value := p_attribute3;
17487:
17488: END IF;
17489: FND_FLEX_DESCVAL.Set_Column_Value
17490: ( column_name => 'ATTRIBUTE3'
17491: , column_value => l_column_value);
17492:
17493: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
17498:
17499: l_column_value := p_attribute4;
17500:
17501: END IF;
17502: FND_FLEX_DESCVAL.Set_Column_Value
17503: ( column_name => 'ATTRIBUTE4'
17504: , column_value => l_column_value);
17505:
17506: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
17511:
17512: l_column_value := p_attribute5;
17513:
17514: END IF;
17515: FND_FLEX_DESCVAL.Set_Column_Value
17516: ( column_name => 'ATTRIBUTE5'
17517: , column_value => l_column_value);
17518:
17519: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
17524:
17525: l_column_value := p_attribute6;
17526:
17527: END IF;
17528: FND_FLEX_DESCVAL.Set_Column_Value
17529: ( column_name => 'ATTRIBUTE6'
17530: , column_value => l_column_value);
17531:
17532: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
17537:
17538: l_column_value := p_attribute7;
17539:
17540: END IF;
17541: FND_FLEX_DESCVAL.Set_Column_Value
17542: ( column_name => 'ATTRIBUTE7'
17543: , column_value => l_column_value);
17544:
17545: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
17550:
17551: l_column_value := p_attribute8;
17552:
17553: END IF;
17554: FND_FLEX_DESCVAL.Set_Column_Value
17555: ( column_name => 'ATTRIBUTE8'
17556: , column_value => l_column_value);
17557:
17558: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
17563:
17564: l_column_value := p_attribute9;
17565:
17566: END IF;
17567: FND_FLEX_DESCVAL.Set_Column_Value
17568: ( column_name => 'ATTRIBUTE9'
17569: , column_value => l_column_value);
17570:
17571: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
17576:
17577: l_column_value := p_attribute10;
17578:
17579: END IF;
17580: FND_FLEX_DESCVAL.Set_Column_Value
17581: ( column_name => 'ATTRIBUTE10'
17582: , column_value => l_column_value);
17583:
17584: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
17589:
17590: l_column_value := p_attribute11;
17591:
17592: END IF;
17593: FND_FLEX_DESCVAL.Set_Column_Value
17594: ( column_name => 'ATTRIBUTE11'
17595: , column_value => l_column_value);
17596:
17597: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
17602:
17603: l_column_value := p_attribute12;
17604:
17605: END IF;
17606: FND_FLEX_DESCVAL.Set_Column_Value
17607: ( column_name => 'ATTRIBUTE12'
17608: , column_value => l_column_value);
17609:
17610: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
17615:
17616: l_column_value := p_attribute13;
17617:
17618: END IF;
17619: FND_FLEX_DESCVAL.Set_Column_Value
17620: ( column_name => 'ATTRIBUTE13'
17621: , column_value => l_column_value);
17622:
17623: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
17628:
17629: l_column_value := p_attribute14;
17630:
17631: END IF;
17632: FND_FLEX_DESCVAL.Set_Column_Value
17633: ( column_name => 'ATTRIBUTE14'
17634: , column_value => l_column_value);
17635:
17636: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
17641:
17642: l_column_value := p_attribute15;
17643:
17644: END IF;
17645: FND_FLEX_DESCVAL.Set_Column_Value
17646: ( column_name => 'ATTRIBUTE15'
17647: , column_value => l_column_value);
17648:
17649: IF p_context = FND_API.G_MISS_CHAR THEN
17654:
17655: l_column_value := p_context;
17656:
17657: END IF;
17658: FND_FLEX_DESCVAL.Set_Context_Value
17659: ( context_value => l_column_value);
17660:
17661: IF NOT OE_CNCL_Validate.Desc_Flex('OE_SALES_CREDITS_ATTRIBUTES') THEN
17662: RETURN FALSE;