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 3081: FROM ar_line_dist_interface_gt

3077: 'ED' ,DECODE(p_line_type,'LINE', NVL(ed_line_amount,0),
3078: 'TAX' , NVL(ed_tax_amount,0) ,0),
3079: 'UNED' ,DECODE(p_line_type,'LINE', NVL(uned_line_amount,0),
3080: 'TAX' , NVL(uned_tax_amount,0) ,0),0))
3081: FROM ar_line_dist_interface_gt
3082: WHERE customer_trx_id = p_customer_trx_id
3083: AND gt_id = p_gt_id;
3084: l_res NUMBER;
3085: BEGIN

Line 3107: FROM ar_line_dist_interface_gt

3103: CURSOR cu_element IS
3104: SELECT DECODE(p_activity,'APP' ,DECODE(line_type,'LINE',line_amount , 'TAX',tax_amount,NULL),
3105: 'ED' ,DECODE(line_type,'LINE',ed_line_amount , 'TAX',ed_tax_amount,NULL),
3106: 'UNED',DECODE(line_type,'LINE',uned_line_amount, 'TAX',uned_tax_amount,NULL),NULL)
3107: FROM ar_line_dist_interface_gt
3108: WHERE customer_trx_id = p_customer_trx_id
3109: AND customer_trx_line_id = p_customer_trx_line_id
3110: AND gt_id = p_gt_id
3111: AND line_type = p_line_type;

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

3130: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',
3131: x_return_status IN OUT NOCOPY VARCHAR2)
3132: IS
3133: CURSOR verif_amt IS
3134: SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3135: CASE WHEN p_line_flag = 'INTERFACE' THEN SUM(NVL(line_amount,0)) ELSE NULL END
3136: ,CASE WHEN p_tax_flag = 'INTERFACE' THEN SUM(NVL(tax_amount,0)) ELSE NULL END
3137: FROM ar_line_dist_interface_gt
3138: WHERE gt_id = p_gt_id

Line 3137: FROM ar_line_dist_interface_gt

3133: CURSOR verif_amt IS
3134: SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3135: CASE WHEN p_line_flag = 'INTERFACE' THEN SUM(NVL(line_amount,0)) ELSE NULL END
3136: ,CASE WHEN p_tax_flag = 'INTERFACE' THEN SUM(NVL(tax_amount,0)) ELSE NULL END
3137: FROM ar_line_dist_interface_gt
3138: WHERE gt_id = p_gt_id
3139: AND customer_trx_id = p_customer_trx.customer_trx_id
3140: AND source_table = 'ADJ';
3141:

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

3187: FETCH verif_amt INTO l_sum_line ,
3188: l_sum_tax ;
3189: CLOSE verif_amt;
3190:
3191: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3192: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3193:
3194: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3195: THEN

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

3188: l_sum_tax ;
3189: CLOSE verif_amt;
3190:
3191: arp_standard.debug(' sum line from ar_line_dist_interface_gt, l_sum_line :'||l_sum_line);
3192: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3193:
3194: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3195: THEN
3196: x_return_status := fnd_api.g_ret_sts_error;

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

3202:
3203:
3204: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3205: x_return_status := fnd_api.g_ret_sts_error;
3206: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3207: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3208: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3209: FND_MSG_PUB.ADD;
3210: END IF;

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

3204: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3205: x_return_status := fnd_api.g_ret_sts_error;
3206: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3207: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3208: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3209: FND_MSG_PUB.ADD;
3210: END IF;
3211:
3212: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN

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

3210: END IF;
3211:
3212: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3213: x_return_status := fnd_api.g_ret_sts_error;
3214: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3215: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3216: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3217: FND_MSG_PUB.ADD;
3218: END IF;

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

3212: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3213: x_return_status := fnd_api.g_ret_sts_error;
3214: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3215: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3216: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3217: FND_MSG_PUB.ADD;
3218: END IF;
3219:
3220: END IF;

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

3235: p_uned_tax_flag IN VARCHAR2 DEFAULT 'NORMAL',
3236: x_return_status IN OUT NOCOPY VARCHAR2)
3237: IS
3238: CURSOR verif_amt IS
3239: SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3240: CASE WHEN p_line_flag = 'INTERFACE' THEN SUM(NVL(line_amount,0)) ELSE NULL END
3241: ,CASE WHEN p_tax_flag = 'INTERFACE' THEN SUM(NVL(tax_amount,0)) ELSE NULL END
3242: ,CASE WHEN p_ed_line_flag = 'INTERFACE' THEN SUM(NVL(ed_line_amount,0)) ELSE NULL END
3243: ,CASE WHEN p_ed_tax_flag = 'INTERFACE' THEN SUM(NVL(ed_tax_amount,0)) ELSE NULL END

Line 3246: FROM ar_line_dist_interface_gt

3242: ,CASE WHEN p_ed_line_flag = 'INTERFACE' THEN SUM(NVL(ed_line_amount,0)) ELSE NULL END
3243: ,CASE WHEN p_ed_tax_flag = 'INTERFACE' THEN SUM(NVL(ed_tax_amount,0)) ELSE NULL END
3244: ,CASE WHEN p_uned_line_flag = 'INTERFACE' THEN SUM(NVL(uned_line_amount,0)) ELSE NULL END
3245: ,CASE WHEN p_uned_tax_flag = 'INTERFACE' THEN SUM(NVL(uned_tax_amount,0)) ELSE NULL END
3246: FROM ar_line_dist_interface_gt
3247: WHERE gt_id = p_gt_id
3248: AND customer_trx_id = p_customer_trx.customer_trx_id
3249: AND source_table = 'RA';
3250:

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

3310: l_sum_uned_line ,
3311: l_sum_uned_tax ;
3312: CLOSE verif_amt;
3313:
3314: arp_standard.debug('TABLE ar_line_dist_interface_gt ');
3315: arp_standard.debug(' l_sum_line :'||l_sum_line);
3316: arp_standard.debug(' l_sum_tax :'||l_sum_tax);
3317: arp_standard.debug(' l_sum_ed_line :'||l_sum_ed_line);
3318: arp_standard.debug(' l_sum_ed_tax :'||l_sum_ed_tax);

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

3341:
3342:
3343: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3344: x_return_status := fnd_api.g_ret_sts_error;
3345: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3346: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3347: 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');
3348: FND_MSG_PUB.ADD;
3349: END IF;

Line 3347: 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');

3343: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3344: x_return_status := fnd_api.g_ret_sts_error;
3345: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3346: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3347: 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');
3348: FND_MSG_PUB.ADD;
3349: END IF;
3350:
3351: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN

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

3349: END IF;
3350:
3351: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3352: x_return_status := fnd_api.g_ret_sts_error;
3353: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3354: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3355: 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');
3356: FND_MSG_PUB.ADD;
3357: END IF;

Line 3355: 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');

3351: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3352: x_return_status := fnd_api.g_ret_sts_error;
3353: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3354: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3355: 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');
3356: FND_MSG_PUB.ADD;
3357: END IF;
3358:
3359: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN

Line 3361: 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');

3357: END IF;
3358:
3359: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: 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');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: 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');
3364: FND_MSG_PUB.ADD;
3365: END IF;

Line 3363: 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');

3359: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: 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');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: 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');
3364: FND_MSG_PUB.ADD;
3365: END IF;
3366:
3367: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN

Line 3369: 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');

3365: END IF;
3366:
3367: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3368: x_return_status := fnd_api.g_ret_sts_error;
3369: 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');
3370: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3371: 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');
3372: FND_MSG_PUB.ADD;
3373: END IF;

Line 3371: 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');

3367: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3368: x_return_status := fnd_api.g_ret_sts_error;
3369: 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');
3370: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3371: 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');
3372: FND_MSG_PUB.ADD;
3373: END IF;
3374:
3375: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN

Line 3377: 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');

3373: END IF;
3374:
3375: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3376: x_return_status := fnd_api.g_ret_sts_error;
3377: 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');
3378: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3379: 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');
3380: FND_MSG_PUB.ADD;
3381: END IF;

Line 3379: 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');

3375: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3376: x_return_status := fnd_api.g_ret_sts_error;
3377: 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');
3378: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3379: 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');
3380: FND_MSG_PUB.ADD;
3381: END IF;
3382:
3383: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN

Line 3385: 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');

3381: END IF;
3382:
3383: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3384: x_return_status := fnd_api.g_ret_sts_error;
3385: 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');
3386: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3387: 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');
3388: FND_MSG_PUB.ADD;
3389: END IF;

Line 3387: 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');

3383: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3384: x_return_status := fnd_api.g_ret_sts_error;
3385: 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');
3386: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3387: 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');
3388: FND_MSG_PUB.ADD;
3389: END IF;
3390:
3391: END IF;