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.AR_GTA_CONSOLIDATE_PROC dependencies on FND_MESSAGE

Line 592: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');

588: AND jgtla.org_id = l_org_id;--Yao Zhang add for bug#8770356
589: EXCEPTION
590: WHEN no_data_found THEN
591: --AR_GTA_SYS_CONFIG_MISSING
592: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');
593: l_error_string := fnd_message.get();
594: -- output error
595: fnd_file.put_line(fnd_file.output, '
596:

Line 593: l_error_string := fnd_message.get();

589: EXCEPTION
590: WHEN no_data_found THEN
591: --AR_GTA_SYS_CONFIG_MISSING
592: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');
593: l_error_string := fnd_message.get();
594: -- output error
595: fnd_file.put_line(fnd_file.output, '
596:
597: Y

Line 676: fnd_message.set_name('AR'

672: THEN
673: IF(l_consolidation_gl_period<>l_csldted_inv.trx_header.RA_GL_PERIOD)
674: THEN
675: l_result_flag:='W';
676: fnd_message.set_name('AR'
677: ,'AR_GTA_CON_DIF_PERIOD');
678: l_error_string:=fnd_message.get();
679: END IF;
680: --consolidation_gl_date should be the latest date of consolidated invoice

Line 678: l_error_string:=fnd_message.get();

674: THEN
675: l_result_flag:='W';
676: fnd_message.set_name('AR'
677: ,'AR_GTA_CON_DIF_PERIOD');
678: l_error_string:=fnd_message.get();
679: END IF;
680: --consolidation_gl_date should be the latest date of consolidated invoice
681: --consolidation_gl_period should be the latest gl_period of consolidated invoice
682: IF(l_consolidation_gl_date< l_csldted_inv.trx_header.ra_gl_date)

Line 695: fnd_message.set_name('AR'

691: --yao add begin for bug#8882568
692: IF l_csldted_inv_status_flag='1'
693: THEN
694: l_result_flag:='E';
695: fnd_message.set_name('AR'
696: ,'AR_GTA_INV_STATUS_INVALID');
697: l_error_string:=fnd_message.get();
698: --yao add end for bug#8882568
699: ELSIF l_csldted_invs.COUNT<=1

Line 697: l_error_string:=fnd_message.get();

693: THEN
694: l_result_flag:='E';
695: fnd_message.set_name('AR'
696: ,'AR_GTA_INV_STATUS_INVALID');
697: l_error_string:=fnd_message.get();
698: --yao add end for bug#8882568
699: ELSIF l_csldted_invs.COUNT<=1
700: THEN
701: l_result_flag:='E';

Line 702: fnd_message.set_name('AR'

698: --yao add end for bug#8882568
699: ELSIF l_csldted_invs.COUNT<=1
700: THEN
701: l_result_flag:='E';
702: fnd_message.set_name('AR'
703: ,'AR_GTA_FAIL_ONLY_ONE_INV_C');
704: l_error_string:=fnd_message.get();
705: ELSIF ABS(l_sum_amount)>l_max_amount
706: THEN

Line 704: l_error_string:=fnd_message.get();

700: THEN
701: l_result_flag:='E';
702: fnd_message.set_name('AR'
703: ,'AR_GTA_FAIL_ONLY_ONE_INV_C');
704: l_error_string:=fnd_message.get();
705: ELSIF ABS(l_sum_amount)>l_max_amount
706: THEN
707: l_result_flag:='E';
708: fnd_message.set_name('AR'

Line 708: fnd_message.set_name('AR'

704: l_error_string:=fnd_message.get();
705: ELSIF ABS(l_sum_amount)>l_max_amount
706: THEN
707: l_result_flag:='E';
708: fnd_message.set_name('AR'
709: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
710: l_error_string:=fnd_message.get();
711: ELSIF(l_consol_sign_flag=0 AND l_sum_amount<=0)
712: THEN

Line 710: l_error_string:=fnd_message.get();

706: THEN
707: l_result_flag:='E';
708: fnd_message.set_name('AR'
709: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
710: l_error_string:=fnd_message.get();
711: ELSIF(l_consol_sign_flag=0 AND l_sum_amount<=0)
712: THEN
713: l_result_flag:='E';
714: fnd_message.set_name('AR'

Line 714: fnd_message.set_name('AR'

710: l_error_string:=fnd_message.get();
711: ELSIF(l_consol_sign_flag=0 AND l_sum_amount<=0)
712: THEN
713: l_result_flag:='E';
714: fnd_message.set_name('AR'
715: ,'AR_GTA_CON_FAIL_NEGTIVE');
716: l_error_string:=fnd_message.get();
717: ELSE--ABS(l_sum_amount)>l_max_amount OR (l_consol_sign_flag=0 AND l_sum_amount<0) and
718: --l_csldted_invs.COUNT<=1 create consolidation invoice

Line 716: l_error_string:=fnd_message.get();

712: THEN
713: l_result_flag:='E';
714: fnd_message.set_name('AR'
715: ,'AR_GTA_CON_FAIL_NEGTIVE');
716: l_error_string:=fnd_message.get();
717: ELSE--ABS(l_sum_amount)>l_max_amount OR (l_consol_sign_flag=0 AND l_sum_amount<0) and
718: --l_csldted_invs.COUNT<=1 create consolidation invoice
719: l_csldted_invs_index:=l_csldted_invs.FIRST;
720:

Line 895: fnd_message.set_name('AR'

891: l_csldtion_discount_line_num:=l_csldtion_discount_line_num+1;
892: --Yao add for bug#8915838
893: ELSE
894: l_result_flag:='E';
895: fnd_message.set_name('AR'
896: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
897: l_error_string:=fnd_message.get();
898: EXIT;
899: END IF;

Line 897: l_error_string:=fnd_message.get();

893: ELSE
894: l_result_flag:='E';
895: fnd_message.set_name('AR'
896: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
897: l_error_string:=fnd_message.get();
898: EXIT;
899: END IF;
900: --add end for bug#8930324
901: --Yao add for bug#8915838 end

Line 944: fnd_message.set_name('AR'

940: l_csldtion_discount_line_num:=l_csldtion_discount_line_num+1;
941: --Yao add for bug#8915838
942: ELSE
943: l_result_flag:='E';
944: fnd_message.set_name('AR'
945: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
946: l_error_string:=fnd_message.get();
947: EXIT;
948: END IF;

Line 946: l_error_string:=fnd_message.get();

942: ELSE
943: l_result_flag:='E';
944: fnd_message.set_name('AR'
945: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
946: l_error_string:=fnd_message.get();
947: EXIT;
948: END IF;
949: --add end for bug#8930324
950: --Yao add for bug#8915838 end

Line 1010: fnd_message.set_name('AR'

1006: AND (l_csldtion_line_count+l_csldtion_discount_line_num)=l_max_line
1007: AND l_sales_list_flag='N')
1008: THEN
1009: l_result_flag:='E';
1010: fnd_message.set_name('AR'
1011: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
1012: l_error_string:=fnd_message.get();
1013: --Yao add for bug#8915838 end
1014: EXIT;--l_consol_inv_lines_index*/

Line 1012: l_error_string:=fnd_message.get();

1008: THEN
1009: l_result_flag:='E';
1010: fnd_message.set_name('AR'
1011: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
1012: l_error_string:=fnd_message.get();
1013: --Yao add for bug#8915838 end
1014: EXIT;--l_consol_inv_lines_index*/
1015: --Yao comment end for bug#8946609
1016:

Line 1021: fnd_message.set_name('AR'

1017: END IF;--l_csldtion_inv_lines_index IS NULL AND (l_csldtion_line_count+l_csldtion_discount_line_num) 1018: --Yao comment begin for bug#8946609
1019: /*ELSE--(l_csldted_line_count 1020: l_result_flag:='E';
1021: fnd_message.set_name('AR'
1022: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
1023: l_error_string:=fnd_message.get();
1024: EXIT;--l_consol_inv_lines_index
1025: END IF;--(l_csldted_line_count

Line 1023: l_error_string:=fnd_message.get();

1019: /*ELSE--(l_csldted_line_count 1020: l_result_flag:='E';
1021: fnd_message.set_name('AR'
1022: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
1023: l_error_string:=fnd_message.get();
1024: EXIT;--l_consol_inv_lines_index
1025: END IF;--(l_csldted_line_count 1026: --Yao comment end for bug#8946609
1027: l_csldted_inv_lines_index:=l_csldted_inv_lines.NEXT(l_csldted_inv_lines_index);

Line 1147: fnd_message.set_name('AR', 'AR_GTA_CON_AR_DIFF_UOM');

1143: l_diff_uoms_flag := l_diff_uoms_flag + 1;
1144: END IF;
1145: IF l_diff_uoms_flag > 1 THEN
1146: l_result_flag := 'E';
1147: fnd_message.set_name('AR', 'AR_GTA_CON_AR_DIFF_UOM');
1148: l_error_string := fnd_message.get();
1149: EXIT;
1150: ELSIF l_diff_uoms_flag = 1 AND (l_csldtion_type(l_csldtion_inv_lines_index1) IN
1151: ('INV', 'MIX')) THEN

Line 1148: l_error_string := fnd_message.get();

1144: END IF;
1145: IF l_diff_uoms_flag > 1 THEN
1146: l_result_flag := 'E';
1147: fnd_message.set_name('AR', 'AR_GTA_CON_AR_DIFF_UOM');
1148: l_error_string := fnd_message.get();
1149: EXIT;
1150: ELSIF l_diff_uoms_flag = 1 AND (l_csldtion_type(l_csldtion_inv_lines_index1) IN
1151: ('INV', 'MIX')) THEN
1152: l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).quantity := nvl(l_csldtion_inv_line.quantity,

Line 1272: fnd_message.set_name('AR'

1268: ELSIF (l_csldtion_line_sign_flag=1 AND l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).amount<0)
1269: OR (l_csldtion_line_sign_flag=-1 AND l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).amount>0)
1270: THEN
1271: l_result_flag:='E';
1272: fnd_message.set_name('AR'
1273: ,'AR_GTA_CON_NEG_INV_LINES');
1274: l_error_string:=fnd_message.get();
1275: EXIT;
1276: END IF;

Line 1274: l_error_string:=fnd_message.get();

1270: THEN
1271: l_result_flag:='E';
1272: fnd_message.set_name('AR'
1273: ,'AR_GTA_CON_NEG_INV_LINES');
1274: l_error_string:=fnd_message.get();
1275: EXIT;
1276: END IF;
1277: ELSE /*l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).quantity<>0
1278: AND l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).amount<>0*/

Line 1295: fnd_message.set_name('AR'

1291: AND l_csldtion_discount_line_num+l_csldtion_line_num>l_max_line
1292: AND l_sales_list_flag<>'Y'
1293: THEN
1294: l_result_flag:='E';
1295: fnd_message.set_name('AR'
1296: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
1297: l_error_string:=fnd_message.get();
1298: END IF;
1299: --Yao add end for bug#8946609

Line 1297: l_error_string:=fnd_message.get();

1293: THEN
1294: l_result_flag:='E';
1295: fnd_message.set_name('AR'
1296: ,'AR_GTA_FAIL_EXCEED_LIMMITS');
1297: l_error_string:=fnd_message.get();
1298: END IF;
1299: --Yao add end for bug#8946609
1300:
1301: