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_BR_REMIT dependencies on FND_MESSAGE

Line 269: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_REMIT');

265: arp_util.debug('create_remit_batch: ' || 'Remittance total amount :'|| TOTAL_AMOUNT);
266: END IF;
267: ELSE
268: -- NO BR have been selected -> the remittance batch row isn't inserted in the table AR_BATCHES
269: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_REMIT');
270: APP_EXCEPTION.raise_exception;
271: END IF;
272:
273: p_batch_id := l_batch_id;

Line 432: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_RECREATE_REMIT');

428: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
429:
430: -- The action Create is enabled only if the batch status is STARTED_CREATION
431: IF l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION') THEN
432: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_RECREATE_REMIT');
433: APP_EXCEPTION.raise_exception;
434: END IF;
435:
436: -- BR search criteria validation

Line 844: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_REMIT_AMOUNT');

840: END IF;
841: ELSIF (p_remit_total_low IS NULL) OR
842: (p_remit_total_high IS NULL) OR
843: (p_remit_total_high < p_remit_total_low) THEN
844: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_REMIT_AMOUNT');
845: APP_EXCEPTION.raise_exception;
846: END IF;
847:
848: -- maturity date

Line 856: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_DUE_DATE');

852: END IF;
853: ELSIF (p_maturity_date_low IS NULL) OR
854: (p_maturity_date_high IS NULL) OR
855: (p_maturity_date_high < p_maturity_date_low) THEN
856: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_DUE_DATE');
857: APP_EXCEPTION.raise_exception;
858: END IF;
859:
860: -- BR number

Line 868: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_NUMBER');

864: END IF;
865: ELSIF (p_br_number_low IS NULL) OR
866: (p_br_number_high IS NULL) OR
867: (p_br_number_high < p_br_number_low) THEN
868: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_NUMBER');
869: APP_EXCEPTION.raise_exception;
870: END IF;
871:
872: -- BR amount

Line 880: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_AMOUNT');

876: END IF;
877: ELSIF (p_br_amount_low IS NULL) OR
878: (p_br_amount_high IS NULL) OR
879: (p_br_amount_high < p_br_amount_low) THEN
880: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_AMOUNT');
881: APP_EXCEPTION.raise_exception;
882: END IF;
883:
884: -- Drawee number

Line 892: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_DRAWEE_NUMBER');

888: END IF;
889: ELSIF (p_drawee_number_low IS NULL) OR
890: (p_drawee_number_high IS NULL) OR
891: (p_drawee_number_high < p_drawee_number_low) THEN
892: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_DRAWEE_NUMBER');
893: APP_EXCEPTION.raise_exception;
894: END IF;
895:
896: -- parameter unsigned_flag

Line 899: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

895:
896: -- parameter unsigned_flag
897: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN
898: l_field := 'p_unsigned_flag';
899: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
900: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
901: FND_MESSAGE.set_token('PARAMETER', l_field);
902: APP_EXCEPTION.raise_exception;
903: END IF;

Line 900: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

896: -- parameter unsigned_flag
897: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN
898: l_field := 'p_unsigned_flag';
899: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
900: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
901: FND_MESSAGE.set_token('PARAMETER', l_field);
902: APP_EXCEPTION.raise_exception;
903: END IF;
904:

Line 901: FND_MESSAGE.set_token('PARAMETER', l_field);

897: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN
898: l_field := 'p_unsigned_flag';
899: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
900: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
901: FND_MESSAGE.set_token('PARAMETER', l_field);
902: APP_EXCEPTION.raise_exception;
903: END IF;
904:
905: -- parameter signed_flag

Line 908: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

904:
905: -- parameter signed_flag
906: IF (NVL(p_signed_flag,'T') NOT IN ('Y','N')) THEN
907: l_field := 'p_signed_flag';
908: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
909: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
910: FND_MESSAGE.set_token('PARAMETER', l_field);
911: APP_EXCEPTION.raise_exception;
912: END IF;

Line 909: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

905: -- parameter signed_flag
906: IF (NVL(p_signed_flag,'T') NOT IN ('Y','N')) THEN
907: l_field := 'p_signed_flag';
908: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
909: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
910: FND_MESSAGE.set_token('PARAMETER', l_field);
911: APP_EXCEPTION.raise_exception;
912: END IF;
913:

Line 910: FND_MESSAGE.set_token('PARAMETER', l_field);

906: IF (NVL(p_signed_flag,'T') NOT IN ('Y','N')) THEN
907: l_field := 'p_signed_flag';
908: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
909: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
910: FND_MESSAGE.set_token('PARAMETER', l_field);
911: APP_EXCEPTION.raise_exception;
912: END IF;
913:
914: -- parameter drawee_issued_flag

Line 917: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

913:
914: -- parameter drawee_issued_flag
915: IF (NVL(p_drawee_issued_flag,'T') NOT IN ('Y','N')) THEN
916: l_field := 'p_drawee_issued_flag';
917: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
918: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
919: FND_MESSAGE.set_token('PARAMETER', l_field);
920: APP_EXCEPTION.raise_exception;
921: END IF;

Line 918: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

914: -- parameter drawee_issued_flag
915: IF (NVL(p_drawee_issued_flag,'T') NOT IN ('Y','N')) THEN
916: l_field := 'p_drawee_issued_flag';
917: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
918: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
919: FND_MESSAGE.set_token('PARAMETER', l_field);
920: APP_EXCEPTION.raise_exception;
921: END IF;
922:

Line 919: FND_MESSAGE.set_token('PARAMETER', l_field);

915: IF (NVL(p_drawee_issued_flag,'T') NOT IN ('Y','N')) THEN
916: l_field := 'p_drawee_issued_flag';
917: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
918: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
919: FND_MESSAGE.set_token('PARAMETER', l_field);
920: APP_EXCEPTION.raise_exception;
921: END IF;
922:
923: -- parameter include_unpaid_flag

Line 926: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

922:
923: -- parameter include_unpaid_flag
924: IF (NVL(p_include_unpaid_flag,'T') NOT IN ('Y','N')) THEN
925: l_field := 'p_include_unpaid_flag';
926: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
927: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
928: FND_MESSAGE.set_token('PARAMETER', l_field);
929: APP_EXCEPTION.raise_exception;
930: END IF;

Line 927: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

923: -- parameter include_unpaid_flag
924: IF (NVL(p_include_unpaid_flag,'T') NOT IN ('Y','N')) THEN
925: l_field := 'p_include_unpaid_flag';
926: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
927: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
928: FND_MESSAGE.set_token('PARAMETER', l_field);
929: APP_EXCEPTION.raise_exception;
930: END IF;
931:

Line 928: FND_MESSAGE.set_token('PARAMETER', l_field);

924: IF (NVL(p_include_unpaid_flag,'T') NOT IN ('Y','N')) THEN
925: l_field := 'p_include_unpaid_flag';
926: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
927: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
928: FND_MESSAGE.set_token('PARAMETER', l_field);
929: APP_EXCEPTION.raise_exception;
930: END IF;
931:
932: -- parameter br_order

Line 935: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

931:
932: -- parameter br_order
933: IF (NVL(p_br_order,'T') NOT IN ('ASC','DESC')) THEN
934: l_field := 'p_br_order';
935: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
936: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
937: FND_MESSAGE.set_token('PARAMETER', l_field);
938: APP_EXCEPTION.raise_exception;
939: END IF;

Line 936: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

932: -- parameter br_order
933: IF (NVL(p_br_order,'T') NOT IN ('ASC','DESC')) THEN
934: l_field := 'p_br_order';
935: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
936: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
937: FND_MESSAGE.set_token('PARAMETER', l_field);
938: APP_EXCEPTION.raise_exception;
939: END IF;
940:

Line 937: FND_MESSAGE.set_token('PARAMETER', l_field);

933: IF (NVL(p_br_order,'T') NOT IN ('ASC','DESC')) THEN
934: l_field := 'p_br_order';
935: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
936: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
937: FND_MESSAGE.set_token('PARAMETER', l_field);
938: APP_EXCEPTION.raise_exception;
939: END IF;
940:
941: -- parameter drawee_order

Line 944: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

940:
941: -- parameter drawee_order
942: IF (NVL(p_drawee_order,'T') NOT IN ('ASC','DESC')) THEN
943: l_field := 'p_drawee_order';
944: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
945: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
946: FND_MESSAGE.set_token('PARAMETER', l_field);
947: APP_EXCEPTION.raise_exception;
948: END IF;

Line 945: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

941: -- parameter drawee_order
942: IF (NVL(p_drawee_order,'T') NOT IN ('ASC','DESC')) THEN
943: l_field := 'p_drawee_order';
944: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
945: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
946: FND_MESSAGE.set_token('PARAMETER', l_field);
947: APP_EXCEPTION.raise_exception;
948: END IF;
949:

Line 946: FND_MESSAGE.set_token('PARAMETER', l_field);

942: IF (NVL(p_drawee_order,'T') NOT IN ('ASC','DESC')) THEN
943: l_field := 'p_drawee_order';
944: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
945: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
946: FND_MESSAGE.set_token('PARAMETER', l_field);
947: APP_EXCEPTION.raise_exception;
948: END IF;
949:
950: -- parameter BR sort criteria

Line 959: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

955: ELSIF p_br_sort_criteria NOT IN ('PS.TRX_NUMBER',
956: 'PS.AMOUNT_DUE_REMAINING',
957: 'TRX_TYPE.NAME') THEN
958: l_field := 'p_br_sort_criteria';
959: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
960: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
961: FND_MESSAGE.set_token('PARAMETER', l_field);
962: APP_EXCEPTION.raise_exception;
963: END IF;

Line 960: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

956: 'PS.AMOUNT_DUE_REMAINING',
957: 'TRX_TYPE.NAME') THEN
958: l_field := 'p_br_sort_criteria';
959: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
960: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
961: FND_MESSAGE.set_token('PARAMETER', l_field);
962: APP_EXCEPTION.raise_exception;
963: END IF;
964:

Line 961: FND_MESSAGE.set_token('PARAMETER', l_field);

957: 'TRX_TYPE.NAME') THEN
958: l_field := 'p_br_sort_criteria';
959: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
960: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
961: FND_MESSAGE.set_token('PARAMETER', l_field);
962: APP_EXCEPTION.raise_exception;
963: END IF;
964:
965: -- parameter drawee sort criteria

Line 980: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

976: 'BRANCH.BANK_NAME',
977: 'BRANCH.BANK_BRANCH_NAME',
978: 'BRANCH.CITY') THEN
979: l_field := 'p_drawee_sort_criteria';
980: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
981: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
982: FND_MESSAGE.set_token('PARAMETER', l_field);
983: APP_EXCEPTION.raise_exception;
984: END IF;

Line 981: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');

977: 'BRANCH.BANK_BRANCH_NAME',
978: 'BRANCH.CITY') THEN
979: l_field := 'p_drawee_sort_criteria';
980: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
981: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
982: FND_MESSAGE.set_token('PARAMETER', l_field);
983: APP_EXCEPTION.raise_exception;
984: END IF;
985:

Line 982: FND_MESSAGE.set_token('PARAMETER', l_field);

978: 'BRANCH.CITY') THEN
979: l_field := 'p_drawee_sort_criteria';
980: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
981: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
982: FND_MESSAGE.set_token('PARAMETER', l_field);
983: APP_EXCEPTION.raise_exception;
984: END IF;
985:
986: IF PG_DEBUG in ('Y', 'C') THEN

Line 1209: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1205:
1206: -- the flag action value is S for 'Select' or D for 'Deselect' or E for 'Erase'
1207: IF (p_action_flag NOT IN ('S','D','E')) THEN
1208: l_field := 'p_action_flag';
1209: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1210: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1211: FND_MESSAGE.set_token('PARAMETER', l_field);
1212: APP_EXCEPTION.raise_exception;
1213: END IF;

Line 1210: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');

1206: -- the flag action value is S for 'Select' or D for 'Deselect' or E for 'Erase'
1207: IF (p_action_flag NOT IN ('S','D','E')) THEN
1208: l_field := 'p_action_flag';
1209: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1210: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1211: FND_MESSAGE.set_token('PARAMETER', l_field);
1212: APP_EXCEPTION.raise_exception;
1213: END IF;
1214:

Line 1211: FND_MESSAGE.set_token('PARAMETER', l_field);

1207: IF (p_action_flag NOT IN ('S','D','E')) THEN
1208: l_field := 'p_action_flag';
1209: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1210: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1211: FND_MESSAGE.set_token('PARAMETER', l_field);
1212: APP_EXCEPTION.raise_exception;
1213: END IF;
1214:
1215: -- the batch id isn't NULL ??

Line 1218: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1214:
1215: -- the batch id isn't NULL ??
1216: IF (p_batch_id IS NULL) THEN
1217: l_field := 'p_batch_id';
1218: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1219: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1220: FND_MESSAGE.set_token('PARAMETER', l_field);
1221: APP_EXCEPTION.raise_exception;
1222: END IF;

Line 1219: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');

1215: -- the batch id isn't NULL ??
1216: IF (p_batch_id IS NULL) THEN
1217: l_field := 'p_batch_id';
1218: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1219: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1220: FND_MESSAGE.set_token('PARAMETER', l_field);
1221: APP_EXCEPTION.raise_exception;
1222: END IF;
1223:

Line 1220: FND_MESSAGE.set_token('PARAMETER', l_field);

1216: IF (p_batch_id IS NULL) THEN
1217: l_field := 'p_batch_id';
1218: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1219: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1220: FND_MESSAGE.set_token('PARAMETER', l_field);
1221: APP_EXCEPTION.raise_exception;
1222: END IF;
1223:
1224: -- fetch the remittance batch row

Line 1231: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_UPDATE_REMIT');

1227: l_control_amount := l_batch_rec.control_amount;
1228:
1229: -- The remittance has been approved; no changes are allowed
1230: IF (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1231: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_UPDATE_REMIT');
1232: APP_EXCEPTION.raise_exception;
1233: END IF;
1234:
1235: -- the payment schedule isn't NULL ??

Line 1238: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1234:
1235: -- the payment schedule isn't NULL ??
1236: IF (p_ps_id IS NULL) THEN
1237: l_field := 'p_ps_id';
1238: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1239: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1240: FND_MESSAGE.set_token('PARAMETER', l_field);
1241: APP_EXCEPTION.raise_exception;
1242: END IF;

Line 1239: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');

1235: -- the payment schedule isn't NULL ??
1236: IF (p_ps_id IS NULL) THEN
1237: l_field := 'p_ps_id';
1238: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1239: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1240: FND_MESSAGE.set_token('PARAMETER', l_field);
1241: APP_EXCEPTION.raise_exception;
1242: END IF;
1243:

Line 1240: FND_MESSAGE.set_token('PARAMETER', l_field);

1236: IF (p_ps_id IS NULL) THEN
1237: l_field := 'p_ps_id';
1238: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1239: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1240: FND_MESSAGE.set_token('PARAMETER', l_field);
1241: APP_EXCEPTION.raise_exception;
1242: END IF;
1243:
1244: -- fetch the assigned trx payment schedule row

Line 1424: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1420: -- validations
1421: --------------------------------------------------
1422: IF p_create_flag <> 'Y' THEN
1423: l_field := 'p_create_flag';
1424: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1425: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1426: FND_MESSAGE.set_token('PARAMETER', l_field);
1427: APP_EXCEPTION.raise_exception;
1428: END IF;

Line 1425: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');

1421: --------------------------------------------------
1422: IF p_create_flag <> 'Y' THEN
1423: l_field := 'p_create_flag';
1424: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1425: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1426: FND_MESSAGE.set_token('PARAMETER', l_field);
1427: APP_EXCEPTION.raise_exception;
1428: END IF;
1429:

Line 1426: FND_MESSAGE.set_token('PARAMETER', l_field);

1422: IF p_create_flag <> 'Y' THEN
1423: l_field := 'p_create_flag';
1424: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1425: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1426: FND_MESSAGE.set_token('PARAMETER', l_field);
1427: APP_EXCEPTION.raise_exception;
1428: END IF;
1429:
1430:

Line 1433: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1429:
1430:
1431: IF p_approve_flag NOT IN ('Y','N') THEN
1432: l_field := 'p_approve_flag';
1433: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1434: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1435: FND_MESSAGE.set_token('PARAMETER', l_field);
1436: APP_EXCEPTION.raise_exception;
1437: END IF;

Line 1434: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');

1430:
1431: IF p_approve_flag NOT IN ('Y','N') THEN
1432: l_field := 'p_approve_flag';
1433: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1434: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1435: FND_MESSAGE.set_token('PARAMETER', l_field);
1436: APP_EXCEPTION.raise_exception;
1437: END IF;
1438:

Line 1435: FND_MESSAGE.set_token('PARAMETER', l_field);

1431: IF p_approve_flag NOT IN ('Y','N') THEN
1432: l_field := 'p_approve_flag';
1433: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1434: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1435: FND_MESSAGE.set_token('PARAMETER', l_field);
1436: APP_EXCEPTION.raise_exception;
1437: END IF;
1438:
1439: IF p_format_flag NOT IN ('Y','N') THEN

Line 1441: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1437: END IF;
1438:
1439: IF p_format_flag NOT IN ('Y','N') THEN
1440: l_field := 'p_format_flag';
1441: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1442: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1443: FND_MESSAGE.set_token('PARAMETER', l_field);
1444: APP_EXCEPTION.raise_exception;
1445: END IF;

Line 1442: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');

1438:
1439: IF p_format_flag NOT IN ('Y','N') THEN
1440: l_field := 'p_format_flag';
1441: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1442: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1443: FND_MESSAGE.set_token('PARAMETER', l_field);
1444: APP_EXCEPTION.raise_exception;
1445: END IF;
1446:

Line 1443: FND_MESSAGE.set_token('PARAMETER', l_field);

1439: IF p_format_flag NOT IN ('Y','N') THEN
1440: l_field := 'p_format_flag';
1441: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1442: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1443: FND_MESSAGE.set_token('PARAMETER', l_field);
1444: APP_EXCEPTION.raise_exception;
1445: END IF;
1446:
1447: IF p_print_flag NOT IN ('Y','N') THEN

Line 1449: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1445: END IF;
1446:
1447: IF p_print_flag NOT IN ('Y','N') THEN
1448: l_field := 'p_print_flag';
1449: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1450: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1451: FND_MESSAGE.set_token('PARAMETER', l_field);
1452: APP_EXCEPTION.raise_exception;
1453: END IF;

Line 1450: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');

1446:
1447: IF p_print_flag NOT IN ('Y','N') THEN
1448: l_field := 'p_print_flag';
1449: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1450: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1451: FND_MESSAGE.set_token('PARAMETER', l_field);
1452: APP_EXCEPTION.raise_exception;
1453: END IF;
1454:

Line 1451: FND_MESSAGE.set_token('PARAMETER', l_field);

1447: IF p_print_flag NOT IN ('Y','N') THEN
1448: l_field := 'p_print_flag';
1449: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1450: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1451: FND_MESSAGE.set_token('PARAMETER', l_field);
1452: APP_EXCEPTION.raise_exception;
1453: END IF;
1454:
1455: IF p_cancel_flag NOT IN ('Y','N') THEN

Line 1457: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1453: END IF;
1454:
1455: IF p_cancel_flag NOT IN ('Y','N') THEN
1456: l_field := 'p_cancel_flag';
1457: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1458: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1459: FND_MESSAGE.set_token('PARAMETER', l_field);
1460: APP_EXCEPTION.raise_exception;
1461: END IF;

Line 1458: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');

1454:
1455: IF p_cancel_flag NOT IN ('Y','N') THEN
1456: l_field := 'p_cancel_flag';
1457: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1458: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1459: FND_MESSAGE.set_token('PARAMETER', l_field);
1460: APP_EXCEPTION.raise_exception;
1461: END IF;
1462:

Line 1459: FND_MESSAGE.set_token('PARAMETER', l_field);

1455: IF p_cancel_flag NOT IN ('Y','N') THEN
1456: l_field := 'p_cancel_flag';
1457: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1458: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1459: FND_MESSAGE.set_token('PARAMETER', l_field);
1460: APP_EXCEPTION.raise_exception;
1461: END IF;
1462:
1463: IF p_print_bills_flag NOT IN ('Y','N') THEN

Line 1465: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1461: END IF;
1462:
1463: IF p_print_bills_flag NOT IN ('Y','N') THEN
1464: l_field := 'p_print_bills_flag';
1465: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1466: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1467: FND_MESSAGE.set_token('PARAMETER', l_field);
1468: APP_EXCEPTION.raise_exception;
1469: END IF;

Line 1466: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');

1462:
1463: IF p_print_bills_flag NOT IN ('Y','N') THEN
1464: l_field := 'p_print_bills_flag';
1465: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1466: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1467: FND_MESSAGE.set_token('PARAMETER', l_field);
1468: APP_EXCEPTION.raise_exception;
1469: END IF;
1470:

Line 1467: FND_MESSAGE.set_token('PARAMETER', l_field);

1463: IF p_print_bills_flag NOT IN ('Y','N') THEN
1464: l_field := 'p_print_bills_flag';
1465: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1466: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1467: FND_MESSAGE.set_token('PARAMETER', l_field);
1468: APP_EXCEPTION.raise_exception;
1469: END IF;
1470:
1471: select org_id into l_org_id

Line 1523: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');

1519: argument34 =>p_drawee_order,
1520: argument35 =>p_physical_bill);
1521:
1522: IF (l_request_id = 0) THEN
1523: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1524: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1525: APP_EXCEPTION.raise_exception;
1526: ELSE
1527: IF PG_DEBUG in ('Y', 'C') THEN

Line 1524: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1520: argument35 =>p_physical_bill);
1521:
1522: IF (l_request_id = 0) THEN
1523: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1524: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1525: APP_EXCEPTION.raise_exception;
1526: ELSE
1527: IF PG_DEBUG in ('Y', 'C') THEN
1528: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

Line 1654: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1650: -- validations
1651: --------------------------------------------------
1652: IF p_approve_flag NOT IN ('Y','N') THEN
1653: l_field := 'p_approve_flag';
1654: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1655: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1656: FND_MESSAGE.set_token('PARAMETER', l_field);
1657: APP_EXCEPTION.raise_exception;
1658: END IF;

Line 1655: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');

1651: --------------------------------------------------
1652: IF p_approve_flag NOT IN ('Y','N') THEN
1653: l_field := 'p_approve_flag';
1654: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1655: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1656: FND_MESSAGE.set_token('PARAMETER', l_field);
1657: APP_EXCEPTION.raise_exception;
1658: END IF;
1659:

Line 1656: FND_MESSAGE.set_token('PARAMETER', l_field);

1652: IF p_approve_flag NOT IN ('Y','N') THEN
1653: l_field := 'p_approve_flag';
1654: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1655: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1656: FND_MESSAGE.set_token('PARAMETER', l_field);
1657: APP_EXCEPTION.raise_exception;
1658: END IF;
1659:
1660: IF p_format_flag NOT IN ('Y','N') THEN

Line 1662: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1658: END IF;
1659:
1660: IF p_format_flag NOT IN ('Y','N') THEN
1661: l_field := 'p_format_flag';
1662: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1663: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1664: FND_MESSAGE.set_token('PARAMETER', l_field);
1665: APP_EXCEPTION.raise_exception;
1666: END IF;

Line 1663: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');

1659:
1660: IF p_format_flag NOT IN ('Y','N') THEN
1661: l_field := 'p_format_flag';
1662: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1663: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1664: FND_MESSAGE.set_token('PARAMETER', l_field);
1665: APP_EXCEPTION.raise_exception;
1666: END IF;
1667:

Line 1664: FND_MESSAGE.set_token('PARAMETER', l_field);

1660: IF p_format_flag NOT IN ('Y','N') THEN
1661: l_field := 'p_format_flag';
1662: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1663: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1664: FND_MESSAGE.set_token('PARAMETER', l_field);
1665: APP_EXCEPTION.raise_exception;
1666: END IF;
1667:
1668: IF p_print_flag NOT IN ('Y','N') THEN

Line 1670: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1666: END IF;
1667:
1668: IF p_print_flag NOT IN ('Y','N') THEN
1669: l_field := 'p_print_flag';
1670: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1671: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1672: FND_MESSAGE.set_token('PARAMETER', l_field);
1673: APP_EXCEPTION.raise_exception;
1674: END IF;

Line 1671: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');

1667:
1668: IF p_print_flag NOT IN ('Y','N') THEN
1669: l_field := 'p_print_flag';
1670: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1671: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1672: FND_MESSAGE.set_token('PARAMETER', l_field);
1673: APP_EXCEPTION.raise_exception;
1674: END IF;
1675:

Line 1672: FND_MESSAGE.set_token('PARAMETER', l_field);

1668: IF p_print_flag NOT IN ('Y','N') THEN
1669: l_field := 'p_print_flag';
1670: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1671: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1672: FND_MESSAGE.set_token('PARAMETER', l_field);
1673: APP_EXCEPTION.raise_exception;
1674: END IF;
1675:
1676: IF p_cancel_flag NOT IN ('Y','N') THEN

Line 1678: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1674: END IF;
1675:
1676: IF p_cancel_flag NOT IN ('Y','N') THEN
1677: l_field := 'p_cancel_flag';
1678: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1679: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1680: FND_MESSAGE.set_token('PARAMETER', l_field);
1681: APP_EXCEPTION.raise_exception;
1682: END IF;

Line 1679: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');

1675:
1676: IF p_cancel_flag NOT IN ('Y','N') THEN
1677: l_field := 'p_cancel_flag';
1678: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1679: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1680: FND_MESSAGE.set_token('PARAMETER', l_field);
1681: APP_EXCEPTION.raise_exception;
1682: END IF;
1683:

Line 1680: FND_MESSAGE.set_token('PARAMETER', l_field);

1676: IF p_cancel_flag NOT IN ('Y','N') THEN
1677: l_field := 'p_cancel_flag';
1678: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1679: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1680: FND_MESSAGE.set_token('PARAMETER', l_field);
1681: APP_EXCEPTION.raise_exception;
1682: END IF;
1683:
1684: IF p_print_bills_flag NOT IN ('Y','N') THEN

Line 1686: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

1682: END IF;
1683:
1684: IF p_print_bills_flag NOT IN ('Y','N') THEN
1685: l_field := 'p_print_bills_flag';
1686: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1687: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1688: FND_MESSAGE.set_token('PARAMETER', l_field);
1689: APP_EXCEPTION.raise_exception;
1690: END IF;

Line 1687: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');

1683:
1684: IF p_print_bills_flag NOT IN ('Y','N') THEN
1685: l_field := 'p_print_bills_flag';
1686: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1687: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1688: FND_MESSAGE.set_token('PARAMETER', l_field);
1689: APP_EXCEPTION.raise_exception;
1690: END IF;
1691:

Line 1688: FND_MESSAGE.set_token('PARAMETER', l_field);

1684: IF p_print_bills_flag NOT IN ('Y','N') THEN
1685: l_field := 'p_print_bills_flag';
1686: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1687: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1688: FND_MESSAGE.set_token('PARAMETER', l_field);
1689: APP_EXCEPTION.raise_exception;
1690: END IF;
1691:
1692: --MOAC changes

Line 1701: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');

1697: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1698:
1699: -- Validation
1700: IF (p_cancel_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL','STARTED_CANCELLATION')) THEN
1701: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');
1702: APP_EXCEPTION.raise_exception;
1703: END IF;
1704:
1705: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN

Line 1706: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');

1702: APP_EXCEPTION.raise_exception;
1703: END IF;
1704:
1705: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1706: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');
1707: APP_EXCEPTION.raise_exception;
1708: END IF;
1709:
1710: --MOAC changes

Line 1757: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');

1753: argument34 =>'',
1754: argument35 =>p_physical_bill);
1755:
1756: IF (l_request_id = 0) THEN
1757: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1758: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1759: APP_EXCEPTION.raise_exception;
1760: ELSE
1761: IF PG_DEBUG in ('Y', 'C') THEN

Line 1758: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1754: argument35 =>p_physical_bill);
1755:
1756: IF (l_request_id = 0) THEN
1757: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1758: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1759: APP_EXCEPTION.raise_exception;
1760: ELSE
1761: IF PG_DEBUG in ('Y', 'C') THEN
1762: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));