DBA Data[Home] [Help]

APPS.ZX_CHECK_REQUIRED_PARAMS_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 167: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)

163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165: l_count := 0;
166:
167: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
168: LOOP
169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL

Line 169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN

165: l_count := 0;
166:
167: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
168: LOOP
169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL

Line 170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL

166:
167: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
168: LOOP
169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL

Line 171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL

167: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
168: LOOP
169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL

Line 172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL

168: LOOP
169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL

Line 173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL

169: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL

Line 174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL

170: IF zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_trx_line_index) is NULL
171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL

Line 175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL

171: AND zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID(l_trx_line_index) is NULL
172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL

Line 176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL

172: AND zx_global_structures_pkg.trx_line_dist_tbl.POA_LOCATION_ID(l_trx_line_index) is NULL
173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL

Line 177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL

173: AND zx_global_structures_pkg.trx_line_dist_tbl.poo_location_id(l_trx_line_index) is NULL
174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL
181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL

Line 178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL

174: AND zx_global_structures_pkg.trx_line_dist_tbl.PAYING_LOCATION_ID(l_trx_line_index) is NULL
175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL
181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL
182: AND zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(l_trx_line_index) is NULL THEN

Line 179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL

175: AND zx_global_structures_pkg.trx_line_dist_tbl.OWN_HQ_LOCATION_ID(l_trx_line_index) is NULL
176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL
181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL
182: AND zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(l_trx_line_index) is NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;

Line 180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL

176: AND zx_global_structures_pkg.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID(l_trx_line_index) is NULL
177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL
181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL
182: AND zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(l_trx_line_index) is NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('ZX','ZX_LOCATION_MISSING');

Line 181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL

177: AND zx_global_structures_pkg.trx_line_dist_tbl.POC_LOCATION_ID(l_trx_line_index) is NULL
178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL
181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL
182: AND zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(l_trx_line_index) is NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('ZX','ZX_LOCATION_MISSING');
185: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;

Line 182: AND zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(l_trx_line_index) is NULL THEN

178: AND zx_global_structures_pkg.trx_line_dist_tbl.POI_LOCATION_ID(l_trx_line_index) is NULL
179: AND zx_global_structures_pkg.trx_line_dist_tbl.POD_LOCATION_ID(l_trx_line_index) is NULL
180: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_trx_line_index) is NULL
181: AND zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(l_trx_line_index) is NULL
182: AND zx_global_structures_pkg.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID(l_trx_line_index) is NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('ZX','ZX_LOCATION_MISSING');
185: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
186: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 198: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)

194: END IF;
195: END IF;
196: END LOOP;
197:
198: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
199: LOOP
200: IF p_event_class_rec.header_level_currency_flag is null THEN
201: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
202: IF zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(l_trx_line_index) is NULL and

Line 201: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN

197:
198: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
199: LOOP
200: IF p_event_class_rec.header_level_currency_flag is null THEN
201: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
202: IF zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(l_trx_line_index) is NULL and
203: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(l_trx_line_index) is NULL THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_INFO_REQD');

Line 202: IF zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(l_trx_line_index) is NULL and

198: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id.LAST,0)
199: LOOP
200: IF p_event_class_rec.header_level_currency_flag is null THEN
201: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
202: IF zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(l_trx_line_index) is NULL and
203: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(l_trx_line_index) is NULL THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_INFO_REQD');
206: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;

Line 203: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(l_trx_line_index) is NULL THEN

199: LOOP
200: IF p_event_class_rec.header_level_currency_flag is null THEN
201: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') THEN
202: IF zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE(l_trx_line_index) is NULL and
203: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(l_trx_line_index) is NULL THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ZX','ZX_CURRENCY_INFO_REQD');
206: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
207: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;

Line 222: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.LAST,0)

218: END LOOP;
219:
220: IF p_event_class_rec.tax_variance_calc_flag = 'Y' THEN
221: IF ZX_API_PUB.G_PUB_SRVC = 'CALCULATE_TAX' THEN
222: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.LAST,0)
223: LOOP
224: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') AND
225: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_trx_line_index) <> 'AMOUNT_MATCHED' AND
226: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(l_trx_line_index) is not null THEN

Line 224: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') AND

220: IF p_event_class_rec.tax_variance_calc_flag = 'Y' THEN
221: IF ZX_API_PUB.G_PUB_SRVC = 'CALCULATE_TAX' THEN
222: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.LAST,0)
223: LOOP
224: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') AND
225: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_trx_line_index) <> 'AMOUNT_MATCHED' AND
226: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(l_trx_line_index) is not null THEN
227: IF zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_trx_line_index) is NULL THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;

Line 225: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_trx_line_index) <> 'AMOUNT_MATCHED' AND

221: IF ZX_API_PUB.G_PUB_SRVC = 'CALCULATE_TAX' THEN
222: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.LAST,0)
223: LOOP
224: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') AND
225: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_trx_line_index) <> 'AMOUNT_MATCHED' AND
226: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(l_trx_line_index) is not null THEN
227: IF zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_trx_line_index) is NULL THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: FND_MESSAGE.SET_NAME('ZX','ZX_UNIT_PRICE_REQD');

Line 226: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(l_trx_line_index) is not null THEN

222: FOR l_trx_line_index IN 1 .. nvl(zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.LAST,0)
223: LOOP
224: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') AND
225: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_trx_line_index) <> 'AMOUNT_MATCHED' AND
226: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(l_trx_line_index) is not null THEN
227: IF zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_trx_line_index) is NULL THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: FND_MESSAGE.SET_NAME('ZX','ZX_UNIT_PRICE_REQD');
230: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;

Line 227: IF zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_trx_line_index) is NULL THEN

223: LOOP
224: IF zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_trx_line_index) not in ('CANCEL','DELETE') AND
225: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_trx_line_index) <> 'AMOUNT_MATCHED' AND
226: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_APPLICATION_ID(l_trx_line_index) is not null THEN
227: IF zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_trx_line_index) is NULL THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: FND_MESSAGE.SET_NAME('ZX','ZX_UNIT_PRICE_REQD');
230: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
231: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;