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.ARP_PROCESS_DET_PKG dependencies on AR_LINE_DIST_INTERFACE_GT

Line 3143: FROM ar_line_dist_interface_gt

3139: 'ED' ,DECODE(p_line_type,'LINE', NVL(ed_line_amount,0),
3140: 'TAX' , NVL(ed_tax_amount,0) ,0),
3141: 'UNED' ,DECODE(p_line_type,'LINE', NVL(uned_line_amount,0),
3142: 'TAX' , NVL(uned_tax_amount,0) ,0),0))
3143: FROM ar_line_dist_interface_gt
3144: WHERE customer_trx_id = p_customer_trx_id
3145: AND gt_id = p_gt_id;
3146: l_res NUMBER;
3147: BEGIN

Line 3169: FROM ar_line_dist_interface_gt

3165: CURSOR cu_element IS
3166: SELECT DECODE(p_activity,'APP' ,DECODE(line_type,'LINE',line_amount , 'TAX',tax_amount,NULL),
3167: 'ED' ,DECODE(line_type,'LINE',ed_line_amount , 'TAX',ed_tax_amount,NULL),
3168: 'UNED',DECODE(line_type,'LINE',uned_line_amount, 'TAX',uned_tax_amount,NULL),NULL)
3169: FROM ar_line_dist_interface_gt
3170: WHERE customer_trx_id = p_customer_trx_id
3171: AND customer_trx_line_id = p_customer_trx_line_id
3172: AND gt_id = p_gt_id
3173: AND line_type = p_line_type;

Line 3196: SELECT /+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)/

3192: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',
3193: x_return_status IN OUT NOCOPY VARCHAR2)
3194: IS
3195: CURSOR verif_amt IS
3196: SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3197: CASE WHEN p_line_flag = 'INTERFACE' THEN SUM(NVL(line_amount,0)) ELSE NULL END
3198: ,CASE WHEN p_tax_flag = 'INTERFACE' THEN SUM(NVL(tax_amount,0)) ELSE NULL END
3199: FROM ar_line_dist_interface_gt
3200: WHERE gt_id = p_gt_id

Line 3199: FROM ar_line_dist_interface_gt

3195: CURSOR verif_amt IS
3196: SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3197: CASE WHEN p_line_flag = 'INTERFACE' THEN SUM(NVL(line_amount,0)) ELSE NULL END
3198: ,CASE WHEN p_tax_flag = 'INTERFACE' THEN SUM(NVL(tax_amount,0)) ELSE NULL END
3199: FROM ar_line_dist_interface_gt
3200: WHERE gt_id = p_gt_id
3201: AND customer_trx_id = p_customer_trx.customer_trx_id
3202: AND source_table = 'ADJ';
3203:

Line 3253: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);

3249: FETCH verif_amt INTO l_sum_line ,
3250: l_sum_tax ;
3251: CLOSE verif_amt;
3252:
3253: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3254: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3255:
3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN

Line 3254: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);

3250: l_sum_tax ;
3251: CLOSE verif_amt;
3252:
3253: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3254: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3255:
3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN
3258: x_return_status := fnd_api.g_ret_sts_error;

Line 3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');

3264:
3265:
3266: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3267: x_return_status := fnd_api.g_ret_sts_error;
3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3271: FND_MSG_PUB.ADD;
3272: END IF;

Line 3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');

3266: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3267: x_return_status := fnd_api.g_ret_sts_error;
3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3271: FND_MSG_PUB.ADD;
3272: END IF;
3273:
3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN

Line 3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');

3272: END IF;
3273:
3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3279: FND_MSG_PUB.ADD;
3280: END IF;

Line 3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');

3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3279: FND_MSG_PUB.ADD;
3280: END IF;
3281:
3282: END IF;

Line 3301: SELECT /+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)/

3297: p_uned_tax_flag IN VARCHAR2 DEFAULT 'NORMAL',
3298: x_return_status IN OUT NOCOPY VARCHAR2)
3299: IS
3300: CURSOR verif_amt IS
3301: SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3302: CASE WHEN p_line_flag = 'INTERFACE' THEN SUM(NVL(line_amount,0)) ELSE NULL END
3303: ,CASE WHEN p_tax_flag = 'INTERFACE' THEN SUM(NVL(tax_amount,0)) ELSE NULL END
3304: ,CASE WHEN p_ed_line_flag = 'INTERFACE' THEN SUM(NVL(ed_line_amount,0)) ELSE NULL END
3305: ,CASE WHEN p_ed_tax_flag = 'INTERFACE' THEN SUM(NVL(ed_tax_amount,0)) ELSE NULL END

Line 3308: FROM ar_line_dist_interface_gt

3304: ,CASE WHEN p_ed_line_flag = 'INTERFACE' THEN SUM(NVL(ed_line_amount,0)) ELSE NULL END
3305: ,CASE WHEN p_ed_tax_flag = 'INTERFACE' THEN SUM(NVL(ed_tax_amount,0)) ELSE NULL END
3306: ,CASE WHEN p_uned_line_flag = 'INTERFACE' THEN SUM(NVL(uned_line_amount,0)) ELSE NULL END
3307: ,CASE WHEN p_uned_tax_flag = 'INTERFACE' THEN SUM(NVL(uned_tax_amount,0)) ELSE NULL END
3308: FROM ar_line_dist_interface_gt
3309: WHERE gt_id = p_gt_id
3310: AND customer_trx_id = p_customer_trx.customer_trx_id
3311: AND source_table = 'RA';
3312:

Line 3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');

3372: l_sum_uned_line ,
3373: l_sum_uned_tax ;
3374: CLOSE verif_amt;
3375:
3376: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3377: arp_standard.debug(' l_sum_line :'||l_sum_line);
3378: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3379: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3380: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);

Line 3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');

3403:
3404:
3405: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3406: x_return_status := fnd_api.g_ret_sts_error;
3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3410: FND_MSG_PUB.ADD;
3411: END IF;

Line 3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');

3405: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3406: x_return_status := fnd_api.g_ret_sts_error;
3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3410: FND_MSG_PUB.ADD;
3411: END IF;
3412:
3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN

Line 3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');

3411: END IF;
3412:
3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3414: x_return_status := fnd_api.g_ret_sts_error;
3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3418: FND_MSG_PUB.ADD;
3419: END IF;

Line 3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');

3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3414: x_return_status := fnd_api.g_ret_sts_error;
3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3418: FND_MSG_PUB.ADD;
3419: END IF;
3420:
3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN

Line 3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');

3419: END IF;
3420:
3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3426: FND_MSG_PUB.ADD;
3427: END IF;

Line 3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');

3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3426: FND_MSG_PUB.ADD;
3427: END IF;
3428:
3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN

Line 3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');

3427: END IF;
3428:
3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3430: x_return_status := fnd_api.g_ret_sts_error;
3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3434: FND_MSG_PUB.ADD;
3435: END IF;

Line 3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');

3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3430: x_return_status := fnd_api.g_ret_sts_error;
3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3434: FND_MSG_PUB.ADD;
3435: END IF;
3436:
3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN

Line 3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');

3435: END IF;
3436:
3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3438: x_return_status := fnd_api.g_ret_sts_error;
3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3442: FND_MSG_PUB.ADD;
3443: END IF;

Line 3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');

3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3438: x_return_status := fnd_api.g_ret_sts_error;
3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3442: FND_MSG_PUB.ADD;
3443: END IF;
3444:
3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN

Line 3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');

3443: END IF;
3444:
3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3446: x_return_status := fnd_api.g_ret_sts_error;
3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3450: FND_MSG_PUB.ADD;
3451: END IF;

Line 3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');

3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3446: x_return_status := fnd_api.g_ret_sts_error;
3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3450: FND_MSG_PUB.ADD;
3451: END IF;
3452:
3453: END IF;