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.PO_MSG_MAPPING_UTL dependencies on PO_VAL_CONSTANTS

Line 150: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_null) :=

146: l_msg_tsfm_list MSG_MAPPING_LIST;
147:
148: BEGIN
149:
150: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_null) :=
151: create_msg_record('PO_CAT_SVC_NO_JOB', 'JOB_NAME', c_job_name, 0);
152: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg) :=
153: create_msg_record('PO_CAT_SVC_CANNOT_CROSS_BG', 'JOB_NAME', c_job_name, 0);
154: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_business_group_id_valid) :=

Line 152: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg) :=

148: BEGIN
149:
150: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_null) :=
151: create_msg_record('PO_CAT_SVC_NO_JOB', 'JOB_NAME', c_job_name, 0);
152: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg) :=
153: create_msg_record('PO_CAT_SVC_CANNOT_CROSS_BG', 'JOB_NAME', c_job_name, 0);
154: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_business_group_id_valid) :=
155: create_msg_record('PO_CAT_SVC_INVALID_BG', 'JOB_NAME', c_job_name, 0);
156: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_not_null) :=

Line 154: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_business_group_id_valid) :=

150: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_null) :=
151: create_msg_record('PO_CAT_SVC_NO_JOB', 'JOB_NAME', c_job_name, 0);
152: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg) :=
153: create_msg_record('PO_CAT_SVC_CANNOT_CROSS_BG', 'JOB_NAME', c_job_name, 0);
154: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_business_group_id_valid) :=
155: create_msg_record('PO_CAT_SVC_INVALID_BG', 'JOB_NAME', c_job_name, 0);
156: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_not_null) :=
157: create_msg_record('PO_CAT_SVC_MUST_JOB', 'JOB_NAME', c_job_name, 0);
158: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid) :=

Line 156: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_not_null) :=

152: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_bg_id_not_cross_bg) :=
153: create_msg_record('PO_CAT_SVC_CANNOT_CROSS_BG', 'JOB_NAME', c_job_name, 0);
154: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_business_group_id_valid) :=
155: create_msg_record('PO_CAT_SVC_INVALID_BG', 'JOB_NAME', c_job_name, 0);
156: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_not_null) :=
157: create_msg_record('PO_CAT_SVC_MUST_JOB', 'JOB_NAME', c_job_name, 0);
158: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid) :=
159: create_msg_record('PO_CAT_SVC_INVALID_JOB', 'JOB_NAME', c_job_name, 1, g_APP_PO, 'BG_NAME', c_job_business_group_name);
160: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid_cat) :=

Line 158: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid) :=

154: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_business_group_id_valid) :=
155: create_msg_record('PO_CAT_SVC_INVALID_BG', 'JOB_NAME', c_job_name, 0);
156: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_not_null) :=
157: create_msg_record('PO_CAT_SVC_MUST_JOB', 'JOB_NAME', c_job_name, 0);
158: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid) :=
159: create_msg_record('PO_CAT_SVC_INVALID_JOB', 'JOB_NAME', c_job_name, 1, g_APP_PO, 'BG_NAME', c_job_business_group_name);
160: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid_cat) :=
161: create_msg_record('PO_PDOI_SVC_INVALID_JOB_CAT', 'JOB_NAME', c_job_name, 0);
162: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_valid) :=

Line 160: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid_cat) :=

156: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_not_null) :=
157: create_msg_record('PO_CAT_SVC_MUST_JOB', 'JOB_NAME', c_job_name, 0);
158: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid) :=
159: create_msg_record('PO_CAT_SVC_INVALID_JOB', 'JOB_NAME', c_job_name, 1, g_APP_PO, 'BG_NAME', c_job_business_group_name);
160: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid_cat) :=
161: create_msg_record('PO_PDOI_SVC_INVALID_JOB_CAT', 'JOB_NAME', c_job_name, 0);
162: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_valid) :=
163: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
164: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_valid) :=

Line 162: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_valid) :=

158: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid) :=
159: create_msg_record('PO_CAT_SVC_INVALID_JOB', 'JOB_NAME', c_job_name, 1, g_APP_PO, 'BG_NAME', c_job_business_group_name);
160: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid_cat) :=
161: create_msg_record('PO_PDOI_SVC_INVALID_JOB_CAT', 'JOB_NAME', c_job_name, 0);
162: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_valid) :=
163: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
164: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_valid) :=
165: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
166: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_null) :=

Line 164: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_valid) :=

160: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_id_valid_cat) :=
161: create_msg_record('PO_PDOI_SVC_INVALID_JOB_CAT', 'JOB_NAME', c_job_name, 0);
162: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_valid) :=
163: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
164: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_valid) :=
165: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
166: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_null) :=
167: create_msg_record('PO_CAT_SVC_NO_UOM', 'UOM_CODE', c_uom_code, 0);
168: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null) :=

Line 166: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_null) :=

162: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_valid) :=
163: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
164: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_valid) :=
165: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
166: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_null) :=
167: create_msg_record('PO_CAT_SVC_NO_UOM', 'UOM_CODE', c_uom_code, 0);
168: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null) :=
169: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
170: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_not_null) :=

Line 168: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null) :=

164: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_valid) :=
165: create_msg_record('PO_CAT_INACTIVE_VALUE', 'UOM_CODE', c_uom_code, 0);
166: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_null) :=
167: create_msg_record('PO_CAT_SVC_NO_UOM', 'UOM_CODE', c_uom_code, 0);
168: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null) :=
169: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
170: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_not_null) :=
171: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
172: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid) :=

Line 170: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_not_null) :=

166: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_null) :=
167: create_msg_record('PO_CAT_SVC_NO_UOM', 'UOM_CODE', c_uom_code, 0);
168: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null) :=
169: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
170: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_not_null) :=
171: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
172: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid) :=
173: create_msg_record('PO_PDOI_SVC_INVALID_UOM', 'UOM_CODE', c_uom_code, 0);
174: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type) :=

Line 172: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid) :=

168: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_not_null) :=
169: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
170: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_not_null) :=
171: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
172: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid) :=
173: create_msg_record('PO_PDOI_SVC_INVALID_UOM', 'UOM_CODE', c_uom_code, 0);
174: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type) :=
175: create_msg_record('PO_CAT_INVALID_LINE_TYPE_UOM', 'UOM_CODE', c_uom_code, 0);
176: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_item) :=

Line 174: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type) :=

170: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_update_not_null) :=
171: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UOM_CODE', c_uom_code, 0);
172: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid) :=
173: create_msg_record('PO_PDOI_SVC_INVALID_UOM', 'UOM_CODE', c_uom_code, 0);
174: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type) :=
175: create_msg_record('PO_CAT_INVALID_LINE_TYPE_UOM', 'UOM_CODE', c_uom_code, 0);
176: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_item) :=
177: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'UOM_CODE', c_uom_code, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
178: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_amount_blanket) :=

Line 176: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_item) :=

172: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_svc_valid) :=
173: create_msg_record('PO_PDOI_SVC_INVALID_UOM', 'UOM_CODE', c_uom_code, 0);
174: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type) :=
175: create_msg_record('PO_CAT_INVALID_LINE_TYPE_UOM', 'UOM_CODE', c_uom_code, 0);
176: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_item) :=
177: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'UOM_CODE', c_uom_code, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
178: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_amount_blanket) :=
179: create_msg_record('PO_CAT_SVC_BLKT_NO_AMT', 'AMOUNT', c_amount, 0);
180: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_null) :=

Line 178: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_amount_blanket) :=

174: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type) :=
175: create_msg_record('PO_CAT_INVALID_LINE_TYPE_UOM', 'UOM_CODE', c_uom_code, 0);
176: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_item) :=
177: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'UOM_CODE', c_uom_code, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
178: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_amount_blanket) :=
179: create_msg_record('PO_CAT_SVC_BLKT_NO_AMT', 'AMOUNT', c_amount, 0);
180: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_null) :=
181: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
182: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_not_null) :=

Line 180: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_null) :=

176: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_meas_lookup_item) :=
177: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'UOM_CODE', c_uom_code, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
178: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_amount_blanket) :=
179: create_msg_record('PO_CAT_SVC_BLKT_NO_AMT', 'AMOUNT', c_amount, 0);
180: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_null) :=
181: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
182: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_not_null) :=
183: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
184: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_null) :=

Line 182: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_not_null) :=

178: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_amount_blanket) :=
179: create_msg_record('PO_CAT_SVC_BLKT_NO_AMT', 'AMOUNT', c_amount, 0);
180: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_null) :=
181: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
182: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_not_null) :=
183: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
184: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_null) :=
185: create_msg_record('PO_PDOI_SVC_NO_PRICE', 'UNIT_PRICE', c_unit_price, 0);
186: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_not_null) :=

Line 184: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_null) :=

180: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_null) :=
181: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
182: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_not_null) :=
183: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
184: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_null) :=
185: create_msg_record('PO_PDOI_SVC_NO_PRICE', 'UNIT_PRICE', c_unit_price, 0);
186: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_not_null) :=
187: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
188: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_not_null) :=

Line 186: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_not_null) :=

182: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_not_null) :=
183: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'ITEM_DESCRIPTION', c_item_desc, 0);
184: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_null) :=
185: create_msg_record('PO_PDOI_SVC_NO_PRICE', 'UNIT_PRICE', c_unit_price, 0);
186: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_not_null) :=
187: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
188: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_not_null) :=
189: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
190: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_ge_zero) :=

Line 188: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_not_null) :=

184: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_null) :=
185: create_msg_record('PO_PDOI_SVC_NO_PRICE', 'UNIT_PRICE', c_unit_price, 0);
186: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_not_null) :=
187: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
188: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_not_null) :=
189: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
190: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_ge_zero) :=
191: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
192: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_ge_zero) :=

Line 190: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_ge_zero) :=

186: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_not_null) :=
187: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
188: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_not_null) :=
189: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
190: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_ge_zero) :=
191: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
192: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_ge_zero) :=
193: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
194: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_line_type) :=

Line 192: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_ge_zero) :=

188: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_not_null) :=
189: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'UNIT_PRICE', c_unit_price, 0);
190: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_ge_zero) :=
191: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
192: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_ge_zero) :=
193: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
194: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_line_type) :=
195: create_msg_record('PO_CAT_INV_LINE_TYPE_PRICE', 'UNIT_PRICE', c_unit_price, 0);
196: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_not_null) :=

Line 194: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_line_type) :=

190: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_ge_zero) :=
191: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
192: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_ge_zero) :=
193: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
194: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_line_type) :=
195: create_msg_record('PO_CAT_INV_LINE_TYPE_PRICE', 'UNIT_PRICE', c_unit_price, 0);
196: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_not_null) :=
197: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
198: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_null) :=

Line 196: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_not_null) :=

192: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_update_ge_zero) :=
193: create_msg_record('PO_CAT_LT_ZERO', 'UNIT_PRICE', c_unit_price, 0);
194: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_line_type) :=
195: create_msg_record('PO_CAT_INV_LINE_TYPE_PRICE', 'UNIT_PRICE', c_unit_price, 0);
196: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_not_null) :=
197: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
198: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_null) :=
199: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
200: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_item) :=

Line 198: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_null) :=

194: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_unit_price_line_type) :=
195: create_msg_record('PO_CAT_INV_LINE_TYPE_PRICE', 'UNIT_PRICE', c_unit_price, 0);
196: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_not_null) :=
197: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
198: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_null) :=
199: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
200: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_item) :=
201: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'CATEGORY', c_category, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
202: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_valid) :=

Line 200: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_item) :=

196: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_not_null) :=
197: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
198: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_null) :=
199: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
200: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_item) :=
201: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'CATEGORY', c_category, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
202: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_valid) :=
203: create_msg_record('PO_CAT_INACTIVE_VALUE', 'CATEGORY', c_category, 0);
204: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_not_null) :=

Line 202: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_valid) :=

198: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_null) :=
199: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'CATEGORY', c_category, 0);
200: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_item) :=
201: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'CATEGORY', c_category, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
202: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_valid) :=
203: create_msg_record('PO_CAT_INACTIVE_VALUE', 'CATEGORY', c_category, 0);
204: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_not_null) :=
205: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_TYPE', c_line_type, 0);
206: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_valid) :=

Line 204: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_not_null) :=

200: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_item) :=
201: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'CATEGORY', c_category, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
202: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_valid) :=
203: create_msg_record('PO_CAT_INACTIVE_VALUE', 'CATEGORY', c_category, 0);
204: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_not_null) :=
205: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_TYPE', c_line_type, 0);
206: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_valid) :=
207: create_msg_record('PO_CAT_INVALID_LINE_TYPE', 'LINE_TYPE', c_line_type, 0);
208: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_num_not_null) :=

Line 206: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_valid) :=

202: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_id_valid) :=
203: create_msg_record('PO_CAT_INACTIVE_VALUE', 'CATEGORY', c_category, 0);
204: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_not_null) :=
205: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_TYPE', c_line_type, 0);
206: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_valid) :=
207: create_msg_record('PO_CAT_INVALID_LINE_TYPE', 'LINE_TYPE', c_line_type, 0);
208: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_num_not_null) :=
209: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_NUM', c_line_num, 0);
210: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_quantity_ge_zero) := create_msg_record('PO_CAT_LT_ZERO', 'QUANTITY', c_quantity, 0);

Line 208: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_num_not_null) :=

204: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_not_null) :=
205: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_TYPE', c_line_type, 0);
206: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_valid) :=
207: create_msg_record('PO_CAT_INVALID_LINE_TYPE', 'LINE_TYPE', c_line_type, 0);
208: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_num_not_null) :=
209: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_NUM', c_line_num, 0);
210: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_quantity_ge_zero) := create_msg_record('PO_CAT_LT_ZERO', 'QUANTITY', c_quantity, 0);
211: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
212: create_msg_record('PO_PDOI_SVC_PB_NO_QTY', 'QUANTITY', c_quantity, 0);

Line 210: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_quantity_ge_zero) := create_msg_record('PO_CAT_LT_ZERO', 'QUANTITY', c_quantity, 0);

206: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_id_valid) :=
207: create_msg_record('PO_CAT_INVALID_LINE_TYPE', 'LINE_TYPE', c_line_type, 0);
208: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_num_not_null) :=
209: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_NUM', c_line_num, 0);
210: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_quantity_ge_zero) := create_msg_record('PO_CAT_LT_ZERO', 'QUANTITY', c_quantity, 0);
211: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
212: create_msg_record('PO_PDOI_SVC_PB_NO_QTY', 'QUANTITY', c_quantity, 0);
213: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_valid) :=
214: create_msg_record('PO_CAT_INVALID_ITEM', 'ITEM', c_item, 0);

Line 211: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=

207: create_msg_record('PO_CAT_INVALID_LINE_TYPE', 'LINE_TYPE', c_line_type, 0);
208: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_num_not_null) :=
209: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_NUM', c_line_num, 0);
210: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_quantity_ge_zero) := create_msg_record('PO_CAT_LT_ZERO', 'QUANTITY', c_quantity, 0);
211: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
212: create_msg_record('PO_PDOI_SVC_PB_NO_QTY', 'QUANTITY', c_quantity, 0);
213: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_valid) :=
214: create_msg_record('PO_CAT_INVALID_ITEM', 'ITEM', c_item, 0);
215: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_op_valid) :=

Line 213: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_valid) :=

209: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'LINE_NUM', c_line_num, 0);
210: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_quantity_ge_zero) := create_msg_record('PO_CAT_LT_ZERO', 'QUANTITY', c_quantity, 0);
211: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
212: create_msg_record('PO_PDOI_SVC_PB_NO_QTY', 'QUANTITY', c_quantity, 0);
213: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_valid) :=
214: create_msg_record('PO_CAT_INVALID_ITEM', 'ITEM', c_item, 0);
215: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_op_valid) :=
216: create_msg_record('PO_CAT_INVALID_OP_ITEM', 'ITEM', c_item, 0);
217: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_null) :=

Line 215: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_op_valid) :=

211: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
212: create_msg_record('PO_PDOI_SVC_PB_NO_QTY', 'QUANTITY', c_quantity, 0);
213: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_valid) :=
214: create_msg_record('PO_CAT_INVALID_ITEM', 'ITEM', c_item, 0);
215: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_op_valid) :=
216: create_msg_record('PO_CAT_INVALID_OP_ITEM', 'ITEM', c_item, 0);
217: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_null) :=
218: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM', c_item, 0);
219: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_not_null) :=

Line 217: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_null) :=

213: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_valid) :=
214: create_msg_record('PO_CAT_INVALID_ITEM', 'ITEM', c_item, 0);
215: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_op_valid) :=
216: create_msg_record('PO_CAT_INVALID_OP_ITEM', 'ITEM', c_item, 0);
217: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_null) :=
218: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM', c_item, 0);
219: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_not_null) :=
220: create_msg_record('PO_CAT_ITEM_NOT_NULL', 'ITEM', c_item, 0);
221: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_null) :=

Line 219: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_not_null) :=

215: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_op_valid) :=
216: create_msg_record('PO_CAT_INVALID_OP_ITEM', 'ITEM', c_item, 0);
217: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_null) :=
218: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM', c_item, 0);
219: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_not_null) :=
220: create_msg_record('PO_CAT_ITEM_NOT_NULL', 'ITEM', c_item, 0);
221: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_null) :=
222: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM_REVISION', c_item_revision, 0);
223: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_item) :=

Line 221: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_null) :=

217: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_null) :=
218: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM', c_item, 0);
219: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_not_null) :=
220: create_msg_record('PO_CAT_ITEM_NOT_NULL', 'ITEM', c_item, 0);
221: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_null) :=
222: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM_REVISION', c_item_revision, 0);
223: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_item) :=
224: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'ITEM_REVISION', c_item_revision, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
225: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_temp_labor) :=

Line 223: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_item) :=

219: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_id_not_null) :=
220: create_msg_record('PO_CAT_ITEM_NOT_NULL', 'ITEM', c_item, 0);
221: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_null) :=
222: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM_REVISION', c_item_revision, 0);
223: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_item) :=
224: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'ITEM_REVISION', c_item_revision, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
225: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_temp_labor) :=
226: create_msg_record('PO_PDOI_SVC_NO_LOCAL_BLANKET', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
227: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_op) :=

Line 225: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_temp_labor) :=

221: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_null) :=
222: create_msg_record('PO_CAT_COLUMN_NULL', 'ITEM_REVISION', c_item_revision, 0);
223: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_item) :=
224: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'ITEM_REVISION', c_item_revision, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
225: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_temp_labor) :=
226: create_msg_record('PO_PDOI_SVC_NO_LOCAL_BLANKET', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
227: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_op) :=
228: create_msg_record('PO_PDOI_GA_OSP_NA', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
229: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_price_break_not_allowed) :=

Line 227: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_op) :=

223: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_revision_item) :=
224: create_msg_record('PO_CAT_ITEM_RELATED_INFO', 'ITEM_REVISION', c_item_revision, 1, g_APP_PO, 'ITEM_DESC', c_item_desc);
225: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_temp_labor) :=
226: create_msg_record('PO_PDOI_SVC_NO_LOCAL_BLANKET', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
227: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_op) :=
228: create_msg_record('PO_PDOI_GA_OSP_NA', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
229: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_price_break_not_allowed) :=
230: create_msg_record('PO_PDOI_PRICE_BRK_AMT_BASED_LN', NULL, NULL, 0);
231: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_negotiated_by_preparer) :=

Line 229: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_price_break_not_allowed) :=

225: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_temp_labor) :=
226: create_msg_record('PO_PDOI_SVC_NO_LOCAL_BLANKET', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
227: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_op) :=
228: create_msg_record('PO_PDOI_GA_OSP_NA', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
229: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_price_break_not_allowed) :=
230: create_msg_record('PO_PDOI_PRICE_BRK_AMT_BASED_LN', NULL, NULL, 0);
231: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_negotiated_by_preparer) :=
232: create_msg_record('PO_CAT_INVALID_FLAG_VALUE', 'NEGOTIATED_BY_PREPARER_FLAG', c_negotiated_flag, 0);
233: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_not_null) :=

Line 231: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_negotiated_by_preparer) :=

227: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ga_flag_op) :=
228: create_msg_record('PO_PDOI_GA_OSP_NA', 'GLOBAL_AGREEMENT_FLAG', c_ga_flag, 0);
229: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_price_break_not_allowed) :=
230: create_msg_record('PO_PDOI_PRICE_BRK_AMT_BASED_LN', NULL, NULL, 0);
231: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_negotiated_by_preparer) :=
232: create_msg_record('PO_CAT_INVALID_FLAG_VALUE', 'NEGOTIATED_BY_PREPARER_FLAG', c_negotiated_flag, 0);
233: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_not_null) :=
234: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'PRICE_DISCOUNT', c_price_discount, 0);
235: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_valid) :=

Line 233: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_not_null) :=

229: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_price_break_not_allowed) :=
230: create_msg_record('PO_PDOI_PRICE_BRK_AMT_BASED_LN', NULL, NULL, 0);
231: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_negotiated_by_preparer) :=
232: create_msg_record('PO_CAT_INVALID_FLAG_VALUE', 'NEGOTIATED_BY_PREPARER_FLAG', c_negotiated_flag, 0);
233: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_not_null) :=
234: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'PRICE_DISCOUNT', c_price_discount, 0);
235: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_valid) :=
236: create_msg_record('PO_CAT_INVALID_DISCOUNT', 'PRICE_DISCOUNT', c_price_discount, 0);
237: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_id_valid) :=

Line 235: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_valid) :=

231: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_negotiated_by_preparer) :=
232: create_msg_record('PO_CAT_INVALID_FLAG_VALUE', 'NEGOTIATED_BY_PREPARER_FLAG', c_negotiated_flag, 0);
233: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_not_null) :=
234: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'PRICE_DISCOUNT', c_price_discount, 0);
235: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_valid) :=
236: create_msg_record('PO_CAT_INVALID_DISCOUNT', 'PRICE_DISCOUNT', c_price_discount, 0);
237: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_id_valid) :=
238: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
239: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_cat_id_update_valid) :=

Line 237: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_id_valid) :=

233: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_not_null) :=
234: create_msg_record('PO_CAT_COLUMN_NOT_NULL', 'PRICE_DISCOUNT', c_price_discount, 0);
235: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_valid) :=
236: create_msg_record('PO_CAT_INVALID_DISCOUNT', 'PRICE_DISCOUNT', c_price_discount, 0);
237: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_id_valid) :=
238: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
239: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_cat_id_update_valid) :=
240: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
241: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_updatable) :=

Line 239: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_cat_id_update_valid) :=

235: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_price_discount_valid) :=
236: create_msg_record('PO_CAT_INVALID_DISCOUNT', 'PRICE_DISCOUNT', c_price_discount, 0);
237: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_id_valid) :=
238: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
239: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_cat_id_update_valid) :=
240: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
241: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_updatable) :=
242: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
243: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_unupdatable) :=

Line 241: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_updatable) :=

237: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_id_valid) :=
238: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
239: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_cat_id_update_valid) :=
240: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
241: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_updatable) :=
242: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
243: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_unupdatable) :=
244: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
245: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_not_to_exceed_price_valid) :=

Line 243: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_unupdatable) :=

239: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_cat_id_update_valid) :=
240: create_msg_record('PO_CAT_INACTIVE_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0);
241: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_updatable) :=
242: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
243: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_unupdatable) :=
244: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
245: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_not_to_exceed_price_valid) :=
246: create_msg_record('PO_CAT_INVALID_PRICE', 'UNIT_PRICE', c_unit_price, 0);
247: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid) :=

Line 245: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_not_to_exceed_price_valid) :=

241: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_not_updatable) :=
242: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
243: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_unupdatable) :=
244: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
245: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_not_to_exceed_price_valid) :=
246: create_msg_record('PO_CAT_INVALID_PRICE', 'UNIT_PRICE', c_unit_price, 0);
247: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid) :=
248: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0);
249: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_organization_id) :=

Line 247: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid) :=

243: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_desc_update_unupdatable) :=
244: create_msg_record('PO_CAT_DIFF_ITEM_DESC', 'ITEM_DESCRIPTION', c_item_desc, 0);
245: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_not_to_exceed_price_valid) :=
246: create_msg_record('PO_CAT_INVALID_PRICE', 'UNIT_PRICE', c_unit_price, 0);
247: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid) :=
248: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0);
249: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_organization_id) :=
250: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0);
251: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_line_type) :=

Line 249: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_organization_id) :=

245: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_not_to_exceed_price_valid) :=
246: create_msg_record('PO_CAT_INVALID_PRICE', 'UNIT_PRICE', c_unit_price, 0);
247: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid) :=
248: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0);
249: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_organization_id) :=
250: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0);
251: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_line_type) :=
252: create_msg_record('PO_CAT_LINE_TYPE_ID_STYLE', 'LINE_TYPE', c_line_type, 0);
253: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_updatable) :=

Line 251: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_line_type) :=

247: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_ship_to_loc_id_valid) :=
248: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0);
249: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_organization_id) :=
250: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0);
251: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_line_type) :=
252: create_msg_record('PO_CAT_LINE_TYPE_ID_STYLE', 'LINE_TYPE', c_line_type, 0);
253: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_updatable) :=
254: create_msg_record('PO_CAT_NO_PO_CAT_UPDATE', 'CATEGORY', c_category, 0);
255: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_style_related_info) :=

Line 253: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_updatable) :=

249: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_organization_id) :=
250: create_msg_record('PO_CAT_INACTIVE_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0);
251: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_line_type) :=
252: create_msg_record('PO_CAT_LINE_TYPE_ID_STYLE', 'LINE_TYPE', c_line_type, 0);
253: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_updatable) :=
254: create_msg_record('PO_CAT_NO_PO_CAT_UPDATE', 'CATEGORY', c_category, 0);
255: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_style_related_info) :=
256: create_msg_record('PO_CAT_PRICE_BREAK_STYLE', NULL, NULL, 0); -- bug5262146
257: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_purchase_basis) :=

Line 255: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_style_related_info) :=

251: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_line_type) :=
252: create_msg_record('PO_CAT_LINE_TYPE_ID_STYLE', 'LINE_TYPE', c_line_type, 0);
253: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_updatable) :=
254: create_msg_record('PO_CAT_NO_PO_CAT_UPDATE', 'CATEGORY', c_category, 0);
255: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_style_related_info) :=
256: create_msg_record('PO_CAT_PRICE_BREAK_STYLE', NULL, NULL, 0); -- bug5262146
257: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_purchase_basis) :=
258: create_msg_record('PO_CAT_PURCHASE_BASIS_STYLE', 'LINE_TYPE', c_line_type, 0);
259: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=

Line 257: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_purchase_basis) :=

253: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_cat_id_update_not_updatable) :=
254: create_msg_record('PO_CAT_NO_PO_CAT_UPDATE', 'CATEGORY', c_category, 0);
255: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_style_related_info) :=
256: create_msg_record('PO_CAT_PRICE_BREAK_STYLE', NULL, NULL, 0); -- bug5262146
257: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_purchase_basis) :=
258: create_msg_record('PO_CAT_PURCHASE_BASIS_STYLE', 'LINE_TYPE', c_line_type, 0);
259: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
260: create_msg_record('PO_CAT_SVC_PB_NO_QTY', 'LINE_TYPE', c_line_type, 0);
261: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_rate_type_no_usr) :=

Line 259: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=

255: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_style_related_info) :=
256: create_msg_record('PO_CAT_PRICE_BREAK_STYLE', NULL, NULL, 0); -- bug5262146
257: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_purchase_basis) :=
258: create_msg_record('PO_CAT_PURCHASE_BASIS_STYLE', 'LINE_TYPE', c_line_type, 0);
259: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
260: create_msg_record('PO_CAT_SVC_PB_NO_QTY', 'LINE_TYPE', c_line_type, 0);
261: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_rate_type_no_usr) :=
262: create_msg_record('PO_CAT_SVC_RATE_TYPE_NO_USR', 'LINE_TYPE', c_line_type, 0);
263: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_derv) :=

Line 261: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_rate_type_no_usr) :=

257: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_style_on_purchase_basis) :=
258: create_msg_record('PO_CAT_PURCHASE_BASIS_STYLE', 'LINE_TYPE', c_line_type, 0);
259: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
260: create_msg_record('PO_CAT_SVC_PB_NO_QTY', 'LINE_TYPE', c_line_type, 0);
261: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_rate_type_no_usr) :=
262: create_msg_record('PO_CAT_SVC_RATE_TYPE_NO_USR', 'LINE_TYPE', c_line_type, 0);
263: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_derv) :=
264: create_msg_record('ICX_CAT_INVALID_VALUE', 'LINE_TYPE', c_line_type, 0, g_APP_ICX);
265: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_derv) :=

Line 263: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_derv) :=

259: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_loc_quantity) :=
260: create_msg_record('PO_CAT_SVC_PB_NO_QTY', 'LINE_TYPE', c_line_type, 0);
261: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_rate_type_no_usr) :=
262: create_msg_record('PO_CAT_SVC_RATE_TYPE_NO_USR', 'LINE_TYPE', c_line_type, 0);
263: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_derv) :=
264: create_msg_record('ICX_CAT_INVALID_VALUE', 'LINE_TYPE', c_line_type, 0, g_APP_ICX);
265: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_derv) :=
266: create_msg_record('ICX_CAT_INVALID_VALUE', 'CATEGORY', c_category, 0, g_APP_ICX);
267: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_derv) :=

Line 265: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_derv) :=

261: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_rate_type_no_usr) :=
262: create_msg_record('PO_CAT_SVC_RATE_TYPE_NO_USR', 'LINE_TYPE', c_line_type, 0);
263: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_derv) :=
264: create_msg_record('ICX_CAT_INVALID_VALUE', 'LINE_TYPE', c_line_type, 0, g_APP_ICX);
265: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_derv) :=
266: create_msg_record('ICX_CAT_INVALID_VALUE', 'CATEGORY', c_category, 0, g_APP_ICX);
267: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_derv) :=
268: create_msg_record('ICX_CAT_INVALID_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0, g_APP_ICX);
269: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_name_derv) :=

Line 267: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_derv) :=

263: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_type_derv) :=
264: create_msg_record('ICX_CAT_INVALID_VALUE', 'LINE_TYPE', c_line_type, 0, g_APP_ICX);
265: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_derv) :=
266: create_msg_record('ICX_CAT_INVALID_VALUE', 'CATEGORY', c_category, 0, g_APP_ICX);
267: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_derv) :=
268: create_msg_record('ICX_CAT_INVALID_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0, g_APP_ICX);
269: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_name_derv) :=
270: create_msg_record('ICX_CAT_INVALID_VALUE', 'JOB_NAME', c_job_name, 0, g_APP_ICX);
271: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_code_derv) :=

Line 269: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_name_derv) :=

265: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_category_derv) :=
266: create_msg_record('ICX_CAT_INVALID_VALUE', 'CATEGORY', c_category, 0, g_APP_ICX);
267: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_derv) :=
268: create_msg_record('ICX_CAT_INVALID_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0, g_APP_ICX);
269: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_name_derv) :=
270: create_msg_record('ICX_CAT_INVALID_VALUE', 'JOB_NAME', c_job_name, 0, g_APP_ICX);
271: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_code_derv) :=
272: create_msg_record('ICX_CAT_INVALID_VALUE', 'UOM_CODE', c_uom_code, 0, g_APP_ICX);
273: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_derv) :=

Line 271: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_code_derv) :=

267: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ip_category_derv) :=
268: create_msg_record('ICX_CAT_INVALID_VALUE', 'IP_CATEGORY_NAME', c_ip_category, 0, g_APP_ICX);
269: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_name_derv) :=
270: create_msg_record('ICX_CAT_INVALID_VALUE', 'JOB_NAME', c_job_name, 0, g_APP_ICX);
271: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_code_derv) :=
272: create_msg_record('ICX_CAT_INVALID_VALUE', 'UOM_CODE', c_uom_code, 0, g_APP_ICX);
273: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_derv) :=
274: create_msg_record('ICX_CAT_INVALID_VALUE', 'ITEM', c_item, 0, g_APP_ICX);
275: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_org_code_derv) :=

Line 273: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_derv) :=

269: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_job_name_derv) :=
270: create_msg_record('ICX_CAT_INVALID_VALUE', 'JOB_NAME', c_job_name, 0, g_APP_ICX);
271: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_code_derv) :=
272: create_msg_record('ICX_CAT_INVALID_VALUE', 'UOM_CODE', c_uom_code, 0, g_APP_ICX);
273: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_derv) :=
274: create_msg_record('ICX_CAT_INVALID_VALUE', 'ITEM', c_item, 0, g_APP_ICX);
275: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_org_code_derv) :=
276: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0, g_APP_ICX);
277: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_location_derv) :=

Line 275: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_org_code_derv) :=

271: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_uom_code_derv) :=
272: create_msg_record('ICX_CAT_INVALID_VALUE', 'UOM_CODE', c_uom_code, 0, g_APP_ICX);
273: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_derv) :=
274: create_msg_record('ICX_CAT_INVALID_VALUE', 'ITEM', c_item, 0, g_APP_ICX);
275: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_org_code_derv) :=
276: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0, g_APP_ICX);
277: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_location_derv) :=
278: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0, g_APP_ICX);
279: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_part_num_derv) :=

Line 277: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_location_derv) :=

273: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_item_derv) :=
274: create_msg_record('ICX_CAT_INVALID_VALUE', 'ITEM', c_item, 0, g_APP_ICX);
275: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_org_code_derv) :=
276: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0, g_APP_ICX);
277: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_location_derv) :=
278: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0, g_APP_ICX);
279: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_part_num_derv) :=
280: create_msg_record('PO_CAT_DERV_PART_NUM_ERROR', 'ITEM', c_item, 0);
281: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_rec_valid) :=

Line 279: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_part_num_derv) :=

275: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_org_code_derv) :=
276: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_ORGANIZATION_CODE', c_ship_to_organization_code, 0, g_APP_ICX);
277: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_location_derv) :=
278: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0, g_APP_ICX);
279: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_part_num_derv) :=
280: create_msg_record('PO_CAT_DERV_PART_NUM_ERROR', 'ITEM', c_item, 0);
281: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_rec_valid) :=
282: create_msg_record('PO_CAT_INVALID_INTER_LINE_REC', NULL, NULL, 0);
283: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_language) :=

Line 281: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_rec_valid) :=

277: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_ship_to_location_derv) :=
278: create_msg_record('ICX_CAT_INVALID_VALUE', 'SHIP_TO_LOCATION', c_loc_ship_to_location, 0, g_APP_ICX);
279: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_part_num_derv) :=
280: create_msg_record('PO_CAT_DERV_PART_NUM_ERROR', 'ITEM', c_item, 0);
281: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_rec_valid) :=
282: create_msg_record('PO_CAT_INVALID_INTER_LINE_REC', NULL, NULL, 0);
283: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_language) :=
284: create_msg_record('PO_PDOI_NO_TLP_IN_CREATE_LANG', 'CREATED_LANGUAGE', c_created_language, 0);
285: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_dates_cumulative_failed) :=

Line 283: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_language) :=

279: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_part_num_derv) :=
280: create_msg_record('PO_CAT_DERV_PART_NUM_ERROR', 'ITEM', c_item, 0);
281: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_rec_valid) :=
282: create_msg_record('PO_CAT_INVALID_INTER_LINE_REC', NULL, NULL, 0);
283: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_language) :=
284: create_msg_record('PO_PDOI_NO_TLP_IN_CREATE_LANG', 'CREATED_LANGUAGE', c_created_language, 0);
285: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_dates_cumulative_failed) :=
286: create_msg_record('PO_CAT_CUMULATIVE_FAILED', NULL, NULL, 0); -- bug5262146
287:

Line 285: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_dates_cumulative_failed) :=

281: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_line_rec_valid) :=
282: create_msg_record('PO_CAT_INVALID_INTER_LINE_REC', NULL, NULL, 0);
283: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_language) :=
284: create_msg_record('PO_PDOI_NO_TLP_IN_CREATE_LANG', 'CREATED_LANGUAGE', c_created_language, 0);
285: l_msg_tsfm_list(PO_VAL_CONSTANTS.c_dates_cumulative_failed) :=
286: create_msg_record('PO_CAT_CUMULATIVE_FAILED', NULL, NULL, 0); -- bug5262146
287:
288: g_msg_tsfm_context_list (l_context) := l_msg_tsfm_list;
289: