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.ZX_CHECK_REQUIRED_PARAMS_PKG dependencies on ZX_API_PUB

Line 37: p_event_class_rec IN ZX_API_PUB.event_class_rec_type

33: * ===========================================================================*/
34:
35: PROCEDURE Check_trx_line_tbl
36: ( x_return_status OUT NOCOPY VARCHAR2,
37: p_event_class_rec IN ZX_API_PUB.event_class_rec_type
38: )
39: IS
40: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_LINE_TBL';
41: l_count NUMBER;

Line 42: l_context_info_rec ZX_API_PUB.context_info_rec_type;

38: )
39: IS
40: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_LINE_TBL';
41: l_count NUMBER;
42: l_context_info_rec ZX_API_PUB.context_info_rec_type;
43: l_message_locm VARCHAR2(240);
44: l_message_unitp VARCHAR2(240);
45:
46: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 153: p_event_class_rec IN ZX_API_PUB.event_class_rec_type

149: * ===========================================================================*/
150:
151: PROCEDURE Check_trx_lines
152: ( x_return_status OUT NOCOPY VARCHAR2,
153: p_event_class_rec IN ZX_API_PUB.event_class_rec_type
154: )
155: IS
156: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_LINE';
157: l_count NUMBER;

Line 158: l_context_info_rec ZX_API_PUB.context_info_rec_type;

154: )
155: IS
156: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_LINE';
157: l_count NUMBER;
158: l_context_info_rec ZX_API_PUB.context_info_rec_type;
159:
160: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
161:
162: BEGIN

Line 189: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

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;
187: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
188: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
189: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
190: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
191: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'At least one location is required');
192: END IF;
193: EXIT;

Line 210: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

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;
208: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
209: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
210: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
211: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
212: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Currency code and precision are required at line level');
213: END IF;
214: EXIT;

Line 221: IF ZX_API_PUB.G_PUB_SRVC = 'CALCULATE_TAX' THEN

217: END IF;
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

Line 234: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

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;
232: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
233: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
234: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
235: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
236: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unit price is required');
237: END IF;
238: EXIT;

Line 264: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type

260: * ===========================================================================*/
261:
262: PROCEDURE Check_trx_headers_tbl
263: ( x_return_status OUT NOCOPY VARCHAR2,
264: p_event_class_rec IN OUT NOCOPY ZX_API_PUB.event_class_rec_type
265: )
266: IS
267: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_HEADERS_TBL';
268: l_func_curr_code VARCHAR2(80);

Line 270: l_context_info_rec ZX_API_PUB.context_info_rec_type;

266: IS
267: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_HEADERS_TBL';
268: l_func_curr_code VARCHAR2(80);
269: l_count NUMBER;
270: l_context_info_rec ZX_API_PUB.context_info_rec_type;
271: l_message_pty VARCHAR2(2000);
272: l_message_curr VARCHAR2(2000);
273:
274: BEGIN

Line 280: IF ZX_API_PUB.G_PUB_SRVC <> 'DETERMINE_RECOVERY' THEN

276: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
277: END IF;
278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: IF ZX_API_PUB.G_PUB_SRVC <> 'DETERMINE_RECOVERY' THEN
281: IF ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB' THEN
282:
283: IF (p_event_class_rec.rounding_ship_to_party_id is NULL) AND
284: (p_event_class_rec.rounding_ship_from_party_id is NULL) AND

Line 281: IF ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB' THEN

277: END IF;
278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: IF ZX_API_PUB.G_PUB_SRVC <> 'DETERMINE_RECOVERY' THEN
281: IF ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB' THEN
282:
283: IF (p_event_class_rec.rounding_ship_to_party_id is NULL) AND
284: (p_event_class_rec.rounding_ship_from_party_id is NULL) AND
285: (p_event_class_rec.rounding_bill_to_party_id is NULL) AND

Line 293: --ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

289: --l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
290: --l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
291: --l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
292: --l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
293: --ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
294: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'At least one rounding party is required');
296: END IF;
297: END IF;

Line 298: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN

294: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
295: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'At least one rounding party is required');
296: END IF;
297: END IF;
298: ELSIF ZX_API_PUB.G_DATA_TRANSFER_MODE = 'TAB' THEN
299: l_message_pty := fnd_message.get_string('ZX','ZX_ROUND_PARTY_MISSING');
300: l_message_curr := fnd_message.get_string('ZX','ZX_CURRENCY_INFO_REQD');
301: INSERT ALL
302: WHEN (ZX_ROUND_PARTY_MISSING = 'Y') THEN

Line 372: END IF; -- ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB'

368: FROM
369: ZX_TRX_HEADERS_GT header
370: WHERE VALIDATION_CHECK_FLAG is null;
371:
372: END IF; -- ZX_API_PUB.G_DATA_TRANSFER_MODE <> 'TAB'
373:
374: /* Needs to be moved to service types package
375:
376: IF p_event_class_rec.trx_currency_code is not NULL AND

Line 382: ELSIF ZX_API_PUB.G_PUB_SRVC = 'DETERMINE_RECOVERY' THEN

378: p_event_class_rec.header_level_currency_flag := 'Y';
379: END IF;
380: */
381:
382: ELSIF ZX_API_PUB.G_PUB_SRVC = 'DETERMINE_RECOVERY' THEN
383: IF p_event_class_rec.tax_variance_calc_flag = 'Y' THEN
384: /* -----------------------------------------------------------------------------+
385: | If tax_variance_calc_flag is 'Y' then trx_line_quantity cannot be null |
386: + ----------------------------------------------------------------------------*/

Line 412: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

408: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
409: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
410: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
411: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
412: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
413: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
414: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Transaction line quantity is required');
415: END IF;
416: END IF;

Line 447: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

443: l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
444: l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
445: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
446: l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
447: ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
448: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Unit Price is required');
450: END IF;
451: END IF;

Line 457: -- moved this logic to ZX_API_PUB and execute it only once

453: /* ------------------------------------------------------------------------- -+
454: | If tax_variance_calc_flag is 'Y' then trx line dist qty cannot be null |
455: + ----------------------------------------------------------------------------*/
456: NULL;
457: -- moved this logic to ZX_API_PUB and execute it only once
458: -- BEGIN
459: -- SELECT /*+ INDEX (ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1)*/
460: -- 1
461: -- INTO l_count

Line 483: -- ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );

479: -- l_context_info_rec.APPLICATION_ID := p_event_class_rec.APPLICATION_ID;
480: -- l_context_info_rec.ENTITY_CODE := p_event_class_rec.ENTITY_CODE;
481: -- l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.EVENT_CLASS_CODE;
482: -- l_context_info_rec.TRX_ID := p_event_class_rec.TRX_ID;
483: -- ZX_API_PUB.add_msg( p_context_info_rec =>l_context_info_rec );
484: -- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
485: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Transaction line distribution quantity is required');
486: -- END IF;
487: -- END IF;

Line 514: p_trx_rec IN ZX_API_PUB.transaction_rec_type

510: * ===========================================================================*/
511:
512: PROCEDURE Check_trx_rec
513: ( x_return_status OUT NOCOPY VARCHAR2,
514: p_trx_rec IN ZX_API_PUB.transaction_rec_type
515: )
516: IS
517: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_REC';
518: l_count NUMBER;

Line 519: l_context_info_rec ZX_API_PUB.context_info_rec_type;

515: )
516: IS
517: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_TRX_REC';
518: l_count NUMBER;
519: l_context_info_rec ZX_API_PUB.context_info_rec_type;
520:
521: BEGIN
522: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

Line 584: p_trx_line_rec IN zx_api_pub.transaction_line_rec_type

580: * ============================================================================*/
581:
582: PROCEDURE Check_trx_line_rec
583: ( x_return_status OUT NOCOPY VARCHAR2,
584: p_trx_line_rec IN zx_api_pub.transaction_line_rec_type
585: ) IS
586: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_TRX_LINE_REC';
587: l_context_info_rec ZX_API_PUB.context_info_rec_type;
588:

Line 587: l_context_info_rec ZX_API_PUB.context_info_rec_type;

583: ( x_return_status OUT NOCOPY VARCHAR2,
584: p_trx_line_rec IN zx_api_pub.transaction_line_rec_type
585: ) IS
586: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_TRX_LINE_REC';
587: l_context_info_rec ZX_API_PUB.context_info_rec_type;
588:
589: BEGIN
590: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
591: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');