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 794: fnd_message.get_string('PON','PON_AUCTS_ATTR_DATATYPE'),

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

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

842: (
843: selected_batch_id,
844: selected_interface_line_id,
845: 'PON_AUC_ATTRIBUTES_INTERFACE',
846: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
847: 'PON_AUCTS_INV_PR_QT_VAL',
848: selected_display_target_flag
849: )
850:

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

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

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

896: (
897: selected_batch_id,
898: selected_interface_line_id,
899: 'PON_AUC_ATTRIBUTES_INTERFACE',
900: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
901: 'PON_AUCTS_INV_PR_QT_VAL',
902: selected_display_target_flag
903: )
904:

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

920: (
921: selected_batch_id,
922: selected_interface_line_id,
923: 'PON_AUC_ATTRIBUTES_INTERFACE',
924: fnd_message.get_string('PON','PON_AUCTS_TARGET_VALUE'),
925: 'PON_AUCTS_ATTR_SHOW_TARGET',
926: selected_value
927: )
928:

Line 977: 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')),

973: (
974: selected_batch_id,
975: selected_interface_line_id,
976: 'PON_AUC_ATTRIBUTES_INTERFACE',
977: 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')),
978: 'PON_FIELD_MUST_BE_ENTERED',
979: selected_attribute_name
980: )
981:

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

1026: (
1027: selected_batch_id,
1028: selected_interface_line_id,
1029: 'PON_AUC_ATTRIBUTES_INTERFACE',
1030: fnd_message.get_string('PON','PON_AUCTS_GROUP'),
1031: 'PON_AUCTS_INVALID_GROUP',
1032: selected_group_name
1033: )
1034:

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

1052: (
1053: selected_batch_id,
1054: selected_interface_line_id,
1055: 'PON_AUC_ATTRIBUTES_INTERFACE',
1056: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
1057: 'PON_AUC_INTERNAL_ATT_ERROR',
1058: fnd_message.get_string('PON','PON_CORE_NO')
1059: )
1060:

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

1054: selected_interface_line_id,
1055: 'PON_AUC_ATTRIBUTES_INTERFACE',
1056: fnd_message.get_string('PON','PON_AUCTS_ATTR_D_TARGET'),
1057: 'PON_AUC_INTERNAL_ATT_ERROR',
1058: fnd_message.get_string('PON','PON_CORE_NO')
1059: )
1060:
1061: SELECT
1062: pai.batch_id selected_batch_id,

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

1091: select
1092: pai1.batch_id,
1093: pai1.interface_line_id,
1094: 'PON_AUC_ATTRIBUTES_INTERFACE',
1095: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1096: 'PON_REQUIREMENT_DUPLICATE_ATT',
1097: pai1.attribute_name
1098: from pon_auc_attributes_interface pai1,
1099: pon_auc_attributes_interface pai2

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

1114: select
1115: pai1.batch_id,
1116: pai1.interface_line_id,
1117: 'PON_AUC_ATTRIBUTES_INTERFACE',
1118: fnd_message.get_string('PON','PON_AUCTS_ATTR'),
1119: 'PON_DUPLICATE_WARNING_ATTR',
1120: pai1.attribute_name
1121: from pon_auc_attributes_interface pai1,
1122: pon_auc_attributes_interface pai2

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

1140: select
1141: pai1.batch_id,
1142: pai1.interface_line_id,
1143: 'PON_AUC_ATTRIBUTES_INTERFACE',
1144: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1145: 'PON_REQUIREMENT_DUPLICATE_ATT',
1146: pai1.attribute_name
1147: from pon_auc_attributes_interface pai1,
1148: pon_auction_attributes paa

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

1417: (
1418: selected_batch_id,
1419: selected_interface_line_id,
1420: 'PON_AUC_PRICE_DIFFER_INT',
1421: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1422: 'PON_FIELD_MUST_BE_ENTERED',
1423: null
1424: )
1425:

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

1444: (
1445: selected_batch_id,
1446: selected_interface_line_id,
1447: 'PON_AUC_PRICE_DIFFER_INT',
1448: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1449: 'PON_TYPE_VALUE_INVALID',
1450: selected_price_type_name
1451: )
1452:

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

1475: SELECT
1476: papd.batch_id,
1477: papd.interface_line_id,
1478: 'PON_AUC_PRICE_DIFFER_INT',
1479: fnd_message.get_string('PON','PON_AUCTS_PRICE_TYPE'),
1480: 'PON_DUPLICATE_WARN_PRICE_TYPE',
1481: papd.price_type_name
1482: FROM pon_auc_price_differ_int papd,
1483: pon_auc_price_differ_int papd2