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

Line 111: fnd_message.get_string('PON', 'PON_AUC_PRICE_ELEMENT_NAME'),

107: (
108: selected_batch_id,
109: selected_interface_line_id,
110: 'PON_AUC_PRICE_ELEMENTS_INT',
111: fnd_message.get_string('PON', 'PON_AUC_PRICE_ELEMENT_NAME'),
112: 'PON_AUC_CANNOT_UPLOAD_LP_PF',
113: sel_price_element_type_name
114: )
115:

Line 136: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),

132: (
133: selected_batch_id,
134: selected_interface_line_id,
135: 'PON_AUC_PRICE_ELEMENTS_INT',
136: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
137: 'PON_AUC_PE_INVALID_VALUE',
138: sel_price_element_type_name
139: )
140:

Line 161: fnd_message.get_string('PON','PON_AUC_PRICING_BASIS'),

157: (
158: selected_batch_id,
159: selected_interface_line_id,
160: 'PON_AUC_PRICE_ELEMENTS_INT',
161: fnd_message.get_string('PON','PON_AUC_PRICING_BASIS'),
162: 'PON_AUC_BASIS_INVAID_VALUE',
163: selected_pricing_basis_name
164: )
165:

Line 232: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),

228: (
229: selected_batch_id,
230: selected_interface_line_id,
231: 'PON_AUC_PRICE_ELEMENTS_INT',
232: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
233: 'PON_AUC_INVALID_PRECISION',
234: selected_value
235: )
236:

Line 258: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),

254: (
255: selected_batch_id,
256: selected_interface_line_id,
257: 'PON_AUC_PRICE_ELEMENTS_INT',
258: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
259: 'PON_AUC_INVALID_PRECISION_AU'||l_message_suffix,
260: selected_value
261: )
262:

Line 283: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),

279: (
280: selected_batch_id,
281: selected_interface_line_id,
282: 'PON_AUC_PRICE_ELEMENTS_INT',
283: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
284: 'PON_AUC_POSITIVE_OR_ZERO',
285: selected_value
286: )
287:

Line 308: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

304: (
305: selected_batch_id,
306: selected_interface_line_id,
307: 'PON_AUC_PRICE_ELEMENTS_INT',
308: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
309: 'PON_AUCTS_INV_PR_QT_VAL',
310: selected_display_target_flag
311: )
312:

Line 335: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),

331: (
332: selected_batch_id,
333: selected_interface_line_id,
334: 'PON_AUC_PRICE_ELEMENTS_INT',
335: fnd_message.get_string('PON','PON_AUC_TARGET_VALUE'),
336: 'PON_AUC_POSITIVE_OR_ZERO',
337: selected_value
338: )
339:

Line 363: fnd_message.get_string('PON','PON_AUC_PRICING_BASIS'),

359: (
360: selected_batch_id,
361: selected_interface_line_id,
362: 'PON_AUC_PRICE_ELEMENTS_INT',
363: fnd_message.get_string('PON','PON_AUC_PRICING_BASIS'),
364: 'PON_AUC_CANNOT_UPLOAD_PF_2',
365: selected_pricing_basis_name
366: )
367:

Line 388: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),

384: (
385: selected_batch_id,
386: selected_interface_line_id,
387: 'PON_AUC_PRICE_ELEMENTS_INT',
388: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
389: 'PON_AUC_AUCTION_INA_PES_SP',
390: sel_price_element_type_name
391: )
392:

Line 432: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),

428: select
429: pape1.batch_id,
430: pape1.interface_line_id,
431: 'PON_AUC_PRICE_ELEMENTS_INT',
432: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
433: 'PON_DUPLICATE_WARNING_PRICE',
434: pape1.price_element_type_name
435: from pon_auc_price_elements_int pape1,
436: pon_auc_price_elements_int pape2

Line 458: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),

454: select
455: int_pe.batch_id,
456: int_pe.interface_line_id,
457: 'PON_AUC_PRICE_ELEMENTS_INT',
458: fnd_message.get_string('PON','PON_AUC_PRICE_ELEMENT_NAME'),
459: 'PON_AUC_CANNOT_UPLOAD_PF_1',
460: int_pe.price_element_type_name
461: from
462: pon_price_elements auction_pe,

Line 544: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),

540: (
541: selected_batch_id,
542: selected_interface_line_id,
543: 'PON_AUC_ATTRIBUTES_INTERFACE',
544: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
545: 'PON_AUC_WEIGHT_RANGE',
546: selected_weight
547: )
548:

Line 571: fnd_message.get_string('PON','PON_AUC_SCORE'),

567: (
568: selected_batch_id,
569: selected_interface_line_id,
570: 'PON_AUC_ATTRIBUTES_INTERFACE',
571: fnd_message.get_string('PON','PON_AUC_SCORE'),
572: 'PON_AUCTS_DISP_ATTR_NO_SCORES',
573: selected_ATTR_MAX_SCORE
574: )
575:

Line 597: fnd_message.get_string('PON','PON_AUC_SCORE'),

593: (
594: selected_batch_id,
595: selected_interface_line_id,
596: 'PON_AUC_ATTRIBUTES_INTERFACE',
597: fnd_message.get_string('PON','PON_AUC_SCORE'),
598: 'PON_AUC_INVALID_MAXSCORE_RANGE',
599: selected_ATTR_MAX_SCORE
600: )
601:

Line 684: -- need to compare apple with apple, response type values are from fnd messages

680:
681: -- Populate data
682: -- RESPONSE_TYPE
683: -- bug 3373002
684: -- need to compare apple with apple, response type values are from fnd messages
685: -- so also validate against messages, not lookups.
686: IF ( p_attr_type_header ) THEN
687: update pon_auc_attributes_interface pai
688: set response_type = decode(response_type_name,

Line 689: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',

685: -- so also validate against messages, not lookups.
686: IF ( p_attr_type_header ) THEN
687: update pon_auc_attributes_interface pai
688: set response_type = decode(response_type_name,
689: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
690: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
691: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
692: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
693: null)

Line 690: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',

686: IF ( p_attr_type_header ) THEN
687: update pon_auc_attributes_interface pai
688: set response_type = decode(response_type_name,
689: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
690: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
691: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
692: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
693: null)
694: where pai.batch_id = p_batch_id

Line 691: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

687: update pon_auc_attributes_interface pai
688: set response_type = decode(response_type_name,
689: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
690: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
691: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
692: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
693: null)
694: where pai.batch_id = p_batch_id
695: and pai.response_type_name is not null;

Line 692: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',

688: set response_type = decode(response_type_name,
689: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
690: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
691: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
692: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
693: null)
694: where pai.batch_id = p_batch_id
695: and pai.response_type_name is not null;
696: ELSE

Line 699: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',

695: and pai.response_type_name is not null;
696: ELSE
697: update pon_auc_attributes_interface pai
698: set response_type = decode(response_type_name,
699: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
700: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
701: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
702: null)
703: where pai.batch_id = p_batch_id

Line 700: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',

696: ELSE
697: update pon_auc_attributes_interface pai
698: set response_type = decode(response_type_name,
699: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
700: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
701: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
702: null)
703: where pai.batch_id = p_batch_id
704: and pai.response_type_name is not null;

Line 701: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

697: update pon_auc_attributes_interface pai
698: set response_type = decode(response_type_name,
699: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
700: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
701: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
702: null)
703: where pai.batch_id = p_batch_id
704: and pai.response_type_name is not null;
705: END IF;

Line 797: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),

793: (
794: selected_batch_id,
795: selected_interface_line_id,
796: 'PON_AUC_ATTRIBUTES_INTERFACE',
797: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
798: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
799: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
800: selected_datatype
801: )

Line 849: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

845: (
846: selected_batch_id,
847: selected_interface_line_id,
848: 'PON_AUC_ATTRIBUTES_INTERFACE',
849: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
850: 'PON_AUCTS_INV_PR_QT_VAL',
851: selected_display_target_flag
852: )
853:

Line 878: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),

874: (
875: selected_batch_id,
876: selected_interface_line_id,
877: 'PON_AUC_ATTRIBUTES_INTERFACE',
878: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
879: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
880: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
881: selected_datatype
882: )

Line 903: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

899: (
900: selected_batch_id,
901: selected_interface_line_id,
902: 'PON_AUC_ATTRIBUTES_INTERFACE',
903: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
904: 'PON_AUCTS_INV_PR_QT_VAL',
905: selected_display_target_flag
906: )
907:

Line 927: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),

923: (
924: selected_batch_id,
925: selected_interface_line_id,
926: 'PON_AUC_ATTRIBUTES_INTERFACE',
927: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),
928: 'PON_AUCTS_ATTR_SHOW_TARGET',
929: selected_value
930: )
931:

Line 980: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP', fnd_message.get_string('PON','PON_AUCTS_ATTR'), fnd_message.get_string('PON', 'PON_AUC_REQUIREMENT')),

976: (
977: selected_batch_id,
978: selected_interface_line_id,
979: 'PON_AUC_ATTRIBUTES_INTERFACE',
980: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP', fnd_message.get_string('PON','PON_AUCTS_ATTR'), fnd_message.get_string('PON', 'PON_AUC_REQUIREMENT')),
981: 'PON_FIELD_MUST_BE_ENTERED',
982: selected_attribute_name
983: )
984:

Line 1034: fnd_message.get_string('PON','PON_AUCTS_GROUP'),

1030: (
1031: selected_batch_id,
1032: selected_interface_line_id,
1033: 'PON_AUC_ATTRIBUTES_INTERFACE',
1034: fnd_message.get_string('PON','PON_AUCTS_GROUP'),
1035: 'PON_AUCTS_INVALID_GROUP',
1036: selected_group_name
1037: )
1038:

Line 1060: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

1056: (
1057: selected_batch_id,
1058: selected_interface_line_id,
1059: 'PON_AUC_ATTRIBUTES_INTERFACE',
1060: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
1061: 'PON_AUC_INTERNAL_ATT_ERROR',
1062: fnd_message.get_string('PON','PON_CORE_NO')
1063: )
1064:

Line 1062: fnd_message.get_string('PON','PON_CORE_NO')

1058: selected_interface_line_id,
1059: 'PON_AUC_ATTRIBUTES_INTERFACE',
1060: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
1061: 'PON_AUC_INTERNAL_ATT_ERROR',
1062: fnd_message.get_string('PON','PON_CORE_NO')
1063: )
1064:
1065: SELECT
1066: pai.batch_id selected_batch_id,

Line 1100: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),

1096: select
1097: pai1.batch_id,
1098: pai1.interface_line_id,
1099: 'PON_AUC_ATTRIBUTES_INTERFACE',
1100: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1101: 'PON_REQUIREMENT_DUPLICATE_ATT',
1102: pai1.attribute_name
1103: from pon_auc_attributes_interface pai1,
1104: pon_auc_attributes_interface pai2

Line 1123: fnd_message.get_string('PON','PON_AUCTS_ATTR'),

1119: select
1120: pai1.batch_id,
1121: pai1.interface_line_id,
1122: 'PON_AUC_ATTRIBUTES_INTERFACE',
1123: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1124: 'PON_DUPLICATE_WARNING_ATTR',
1125: pai1.attribute_name
1126: from pon_auc_attributes_interface pai1,
1127: pon_auc_attributes_interface pai2

Line 1149: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),

1145: select
1146: pai1.batch_id,
1147: pai1.interface_line_id,
1148: 'PON_AUC_ATTRIBUTES_INTERFACE',
1149: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1150: 'PON_REQUIREMENT_DUPLICATE_ATT',
1151: pai1.attribute_name
1152: from pon_auc_attributes_interface pai1,
1153: pon_auction_attributes paa

Line 1426: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),

1422: (
1423: selected_batch_id,
1424: selected_interface_line_id,
1425: 'PON_AUC_PRICE_DIFFER_INT',
1426: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1427: 'PON_FIELD_MUST_BE_ENTERED',
1428: null
1429: )
1430:

Line 1453: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),

1449: (
1450: selected_batch_id,
1451: selected_interface_line_id,
1452: 'PON_AUC_PRICE_DIFFER_INT',
1453: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1454: 'PON_TYPE_VALUE_INVALID',
1455: selected_price_type_name
1456: )
1457:

Line 1484: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),

1480: SELECT
1481: papd.batch_id,
1482: papd.interface_line_id,
1483: 'PON_AUC_PRICE_DIFFER_INT',
1484: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1485: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1486: papd.price_type_name
1487: FROM pon_auc_price_differ_int papd,
1488: pon_auc_price_differ_int papd2

Line 1894: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),

1890: (
1891: selected_batch_id,
1892: selected_interface_line_id,
1893: 'PON_AUC_ATTRIBUTES_INTERFACE',
1894: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
1895: 'PON_AUC_WEIGHT_RANGE',
1896: selected_weight
1897: )
1898:

Line 1922: fnd_message.get_string('PON','PON_AUC_SCORE'),

1918: (
1919: selected_batch_id,
1920: selected_interface_line_id,
1921: 'PON_AUC_ATTRIBUTES_INTERFACE',
1922: fnd_message.get_string('PON','PON_AUC_SCORE'),
1923: 'PON_AUCTS_DISP_ATTR_NO_SCORES',
1924: selected_ATTR_MAX_SCORE
1925: )
1926:

Line 1949: fnd_message.get_string('PON','PON_AUC_SCORE'),

1945: (
1946: selected_batch_id,
1947: selected_interface_line_id,
1948: 'PON_AUC_ATTRIBUTES_INTERFACE',
1949: fnd_message.get_string('PON','PON_AUC_SCORE'),
1950: 'PON_AUC_INVALID_MAXSCORE_RANGE',
1951: selected_ATTR_MAX_SCORE
1952: )
1953:

Line 2029: -- need to compare apple with apple, response type values are from fnd messages

2025:
2026: -- Populate data
2027: -- RESPONSE_TYPE
2028: -- bug 3373002
2029: -- need to compare apple with apple, response type values are from fnd messages
2030: -- so also validate against messages, not lookups.
2031: IF ( p_attr_type_header ) THEN
2032: update pon_auc_attributes_interface pai
2033: set response_type = decode(response_type_name,

Line 2034: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',

2030: -- so also validate against messages, not lookups.
2031: IF ( p_attr_type_header ) THEN
2032: update pon_auc_attributes_interface pai
2033: set response_type = decode(response_type_name,
2034: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2035: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2036: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2037: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
2038: null)

Line 2035: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',

2031: IF ( p_attr_type_header ) THEN
2032: update pon_auc_attributes_interface pai
2033: set response_type = decode(response_type_name,
2034: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2035: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2036: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2037: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
2038: null)
2039: where pai.batch_id = p_batch_id

Line 2036: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

2032: update pon_auc_attributes_interface pai
2033: set response_type = decode(response_type_name,
2034: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2035: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2036: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2037: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
2038: null)
2039: where pai.batch_id = p_batch_id
2040: and pai.response_type_name is not null;

Line 2037: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',

2033: set response_type = decode(response_type_name,
2034: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2035: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2036: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2037: fnd_message.get_string('PON','PON_AUCTS_INTERNAL'), 'INTERNAL',
2038: null)
2039: where pai.batch_id = p_batch_id
2040: and pai.response_type_name is not null;
2041: ELSE

Line 2044: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',

2040: and pai.response_type_name is not null;
2041: ELSE
2042: update pon_auc_attributes_interface pai
2043: set response_type = decode(response_type_name,
2044: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2045: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2046: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2047: null)
2048: where pai.batch_id = p_batch_id

Line 2045: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',

2041: ELSE
2042: update pon_auc_attributes_interface pai
2043: set response_type = decode(response_type_name,
2044: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2045: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2046: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2047: null)
2048: where pai.batch_id = p_batch_id
2049: and pai.response_type_name is not null;

Line 2046: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',

2042: update pon_auc_attributes_interface pai
2043: set response_type = decode(response_type_name,
2044: fnd_message.get_string('PON','PON_AUCTS_REQUIRED'), 'REQUIRED',
2045: fnd_message.get_string('PON','PON_AUCTS_OPTIONAL'), 'OPTIONAL',
2046: fnd_message.get_string('PON','PON_AUCTS_DISPLAY_ONLY'), 'DISPLAY_ONLY',
2047: null)
2048: where pai.batch_id = p_batch_id
2049: and pai.response_type_name is not null;
2050: END IF;

Line 2143: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),

2139: (
2140: selected_batch_id,
2141: selected_interface_line_id,
2142: 'PON_AUC_ATTRIBUTES_INTERFACE',
2143: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
2144: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
2145: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
2146: selected_datatype
2147: )

Line 2197: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

2193: (
2194: selected_batch_id,
2195: selected_interface_line_id,
2196: 'PON_AUC_ATTRIBUTES_INTERFACE',
2197: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2198: 'PON_AUCTS_INV_PR_QT_VAL',
2199: selected_display_target_flag
2200: )
2201:

Line 2227: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),

2223: (
2224: selected_batch_id,
2225: selected_interface_line_id,
2226: 'PON_AUC_ATTRIBUTES_INTERFACE',
2227: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),
2228: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP',
2229: 'PON_AUCTS_ATTR_INVALID_TYPE', 'PON_AUCTS_REQ_INVALID_TYPE'),
2230: selected_datatype
2231: )

Line 2253: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

2249: (
2250: selected_batch_id,
2251: selected_interface_line_id,
2252: 'PON_AUC_ATTRIBUTES_INTERFACE',
2253: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2254: 'PON_AUCTS_INV_PR_QT_VAL',
2255: selected_display_target_flag
2256: )
2257:

Line 2278: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),

2274: (
2275: selected_batch_id,
2276: selected_interface_line_id,
2277: 'PON_AUC_ATTRIBUTES_INTERFACE',
2278: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),
2279: 'PON_AUCTS_ATTR_SHOW_TARGET',
2280: selected_value
2281: )
2282:

Line 2333: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP', fnd_message.get_string('PON','PON_AUCTS_ATTR'), fnd_message.get_string('PON', 'PON_AUC_REQUIREMENT')),

2329: (
2330: selected_batch_id,
2331: selected_interface_line_id,
2332: 'PON_AUC_ATTRIBUTES_INTERFACE',
2333: decode(l_group_pref_name, 'LINE_ATTR_DEFAULT_GROUP', fnd_message.get_string('PON','PON_AUCTS_ATTR'), fnd_message.get_string('PON', 'PON_AUC_REQUIREMENT')),
2334: 'PON_FIELD_MUST_BE_ENTERED',
2335: selected_attribute_name
2336: )
2337:

Line 2389: fnd_message.get_string('PON','PON_AUCTS_GROUP'),

2385: (
2386: selected_batch_id,
2387: selected_interface_line_id,
2388: 'PON_AUC_ATTRIBUTES_INTERFACE',
2389: fnd_message.get_string('PON','PON_AUCTS_GROUP'),
2390: 'PON_AUCTS_INVALID_GROUP',
2391: selected_group_name
2392: )
2393:

Line 2416: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),

2412: (
2413: selected_batch_id,
2414: selected_interface_line_id,
2415: 'PON_AUC_ATTRIBUTES_INTERFACE',
2416: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2417: 'PON_AUC_INTERNAL_ATT_ERROR',
2418: fnd_message.get_string('PON','PON_CORE_NO')
2419: )
2420: -- Bug 16801089

Line 2418: fnd_message.get_string('PON','PON_CORE_NO')

2414: selected_interface_line_id,
2415: 'PON_AUC_ATTRIBUTES_INTERFACE',
2416: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
2417: 'PON_AUC_INTERNAL_ATT_ERROR',
2418: fnd_message.get_string('PON','PON_CORE_NO')
2419: )
2420: -- Bug 16801089
2421: -- Adding New Validation for Weight
2422: when

Line 2442: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),

2438: (
2439: selected_batch_id,
2440: selected_interface_line_id,
2441: 'PON_AUC_ATTRIBUTES_INTERFACE',
2442: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
2443: 'PON_AUC_INVALID_WEIGHT',
2444: fnd_message.get_string('PON','PON_CORE_NO')
2445: )
2446:

Line 2444: fnd_message.get_string('PON','PON_CORE_NO')

2440: selected_interface_line_id,
2441: 'PON_AUC_ATTRIBUTES_INTERFACE',
2442: fnd_message.get_string('PON','PON_AUCTS_ATTR_WEIGHT'),
2443: 'PON_AUC_INVALID_WEIGHT',
2444: fnd_message.get_string('PON','PON_CORE_NO')
2445: )
2446:
2447: SELECT
2448: pai.batch_id selected_batch_id,

Line 2485: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),

2481: select
2482: pai1.batch_id,
2483: pai1.interface_line_id,
2484: 'PON_AUC_ATTRIBUTES_INTERFACE',
2485: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2486: 'PON_REQUIREMENT_DUPLICATE_ATT',
2487: pai1.attribute_name
2488: from pon_auc_attributes_interface pai1,
2489: pon_auc_attributes_interface pai2

Line 2509: fnd_message.get_string('PON','PON_AUCTS_ATTR'),

2505: select
2506: pai1.batch_id,
2507: pai1.interface_line_id,
2508: 'PON_AUC_ATTRIBUTES_INTERFACE',
2509: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
2510: 'PON_DUPLICATE_WARNING_ATTR',
2511: pai1.attribute_name
2512: from pon_auc_attributes_interface pai1,
2513: pon_auc_attributes_interface pai2

Line 2536: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),

2532: select
2533: pai1.batch_id,
2534: pai1.interface_line_id,
2535: 'PON_AUC_ATTRIBUTES_INTERFACE',
2536: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2537: 'PON_REQUIREMENT_DUPLICATE_ATT',
2538: pai1.attribute_name
2539: from pon_auc_attributes_interface pai1,
2540: pon_auction_attributes paa

Line 2692: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),'PON_REQUIREMENT_ERR_7',p_in_rec.l_DATATYPE

2688: IF(p_in_rec.l_DATATYPE = 'URL') THEN
2689: IF(p_in_rec.l_SCORING_TYPE='LOV' OR p_in_rec.l_SCORING_TYPE='RANGE') THEN
2690: insert_error_interface
2691: (
2692: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),'PON_REQUIREMENT_ERR_7',p_in_rec.l_DATATYPE
2693: );
2694: x_return_status := 'N';
2695: END IF;
2696: IF(p_in_rec.l_SCORING_METHOD='AUTOMATIC') THEN

Line 2699: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),'PON_REQUIREMENT_ERR_8',p_in_rec.l_DATATYPE

2695: END IF;
2696: IF(p_in_rec.l_SCORING_METHOD='AUTOMATIC') THEN
2697: insert_error_interface
2698: (
2699: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),'PON_REQUIREMENT_ERR_8',p_in_rec.l_DATATYPE
2700: );
2701: x_return_status := 'N';
2702: END IF;
2703: END IF;

Line 2724: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_REQUIREMENT_ERR_14',p_in_rec.l_SCORING_METHOD

2720: END IF;
2721: IF(p_in_rec.l_ATTR_MAX_SCORE = NULL OR p_in_rec.l_ATTR_MAX_SCORE = 0) THEN
2722: insert_error_interface
2723: (
2724: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_REQUIREMENT_ERR_14',p_in_rec.l_SCORING_METHOD
2725: );
2726: x_return_status := 'N';
2727: END IF;
2728: END IF;

Line 2737: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_REQUIREMENT_ERR_11',p_in_rec.l_SCORING_METHOD

2733: EXCEPTION
2734: WHEN No_Data_Found THEN
2735: insert_error_interface
2736: (
2737: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_REQUIREMENT_ERR_11',p_in_rec.l_SCORING_METHOD
2738: );
2739: x_return_status := 'N';
2740: END;
2741: /* Text datatype cannot have range scoring type and date/num datatype cannot have LOV scoring type */

Line 2745: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_DATA_SCORE_MISMATCH',p_in_rec.l_SCORING_TYPE

2741: /* Text datatype cannot have range scoring type and date/num datatype cannot have LOV scoring type */
2742: IF((p_in_rec.l_SCORING_TYPE <>'LOV' AND p_in_rec.l_DATATYPE = 'TXT') OR (p_in_rec.l_SCORING_TYPE<>'RANGE' AND (p_in_rec.l_DATATYPE = 'NUM' OR p_in_rec.l_DATATYPE = 'DAT'))) THEN
2743: insert_error_interface
2744: (
2745: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_DATA_SCORE_MISMATCH',p_in_rec.l_SCORING_TYPE
2746: );
2747: x_return_status := 'N';
2748: END IF;
2749: END IF;

Line 2756: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_REQUIREMENT_ERR_12',p_in_rec.l_KNOCKOUT_SCORE

2752: IF(p_in_rec.l_KNOCKOUT_SCORE IS NOT NULL) THEN
2753: IF(p_in_rec.l_ATTR_MAX_SCORE IS NULL OR p_in_rec.l_KNOCKOUT_SCORE > p_in_rec.l_ATTR_MAX_SCORE OR p_in_rec.l_KNOCKOUT_SCORE< 0) THEN
2754: insert_error_interface
2755: (
2756: p_in_rec.l_BATCH_ID,p_in_rec.l_INTERFACE_LINE_ID,l_TABLE_NAME,fnd_message.get_string('PON','PON_AUC_SCORE'),'PON_REQUIREMENT_ERR_12',p_in_rec.l_KNOCKOUT_SCORE
2757: );
2758: x_return_status := 'N';
2759: END IF;
2760: END IF;