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 833: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_REMIT_AMOUNT');

829: END IF;
830: ELSIF (p_remit_total_low IS NULL) OR
831: (p_remit_total_high IS NULL) OR
832: (p_remit_total_high < p_remit_total_low) THEN
833: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_REMIT_AMOUNT');
834: APP_EXCEPTION.raise_exception;
835: END IF;
836:
837: -- maturity date

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

841: END IF;
842: ELSIF (p_maturity_date_low IS NULL) OR
843: (p_maturity_date_high IS NULL) OR
844: (p_maturity_date_high < p_maturity_date_low) THEN
845: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_DUE_DATE');
846: APP_EXCEPTION.raise_exception;
847: END IF;
848:
849: -- BR number

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

853: END IF;
854: ELSIF (p_br_number_low IS NULL) OR
855: (p_br_number_high IS NULL) OR
856: (p_br_number_high < p_br_number_low) THEN
857: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_NUMBER');
858: APP_EXCEPTION.raise_exception;
859: END IF;
860:
861: -- BR amount

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

865: END IF;
866: ELSIF (p_br_amount_low IS NULL) OR
867: (p_br_amount_high IS NULL) OR
868: (p_br_amount_high < p_br_amount_low) THEN
869: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_BR_AMOUNT');
870: APP_EXCEPTION.raise_exception;
871: END IF;
872:
873: -- Drawee number

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

877: END IF;
878: ELSIF (p_drawee_number_low IS NULL) OR
879: (p_drawee_number_high IS NULL) OR
880: (p_drawee_number_high < p_drawee_number_low) THEN
881: FND_MESSAGE.set_name('AR','AR_BR_BAD_PARAM_DRAWEE_NUMBER');
882: APP_EXCEPTION.raise_exception;
883: END IF;
884:
885: -- parameter unsigned_flag

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

884:
885: -- parameter unsigned_flag
886: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN
887: l_field := 'p_unsigned_flag';
888: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
889: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
890: FND_MESSAGE.set_token('PARAMETER', l_field);
891: APP_EXCEPTION.raise_exception;
892: END IF;

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

885: -- parameter unsigned_flag
886: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN
887: l_field := 'p_unsigned_flag';
888: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
889: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
890: FND_MESSAGE.set_token('PARAMETER', l_field);
891: APP_EXCEPTION.raise_exception;
892: END IF;
893:

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

886: IF (NVL(p_unsigned_flag,'T') NOT IN ('Y','N')) THEN
887: l_field := 'p_unsigned_flag';
888: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
889: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
890: FND_MESSAGE.set_token('PARAMETER', l_field);
891: APP_EXCEPTION.raise_exception;
892: END IF;
893:
894: -- parameter signed_flag

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

920:
921: -- parameter br_order
922: IF (NVL(p_br_order,'T') NOT IN ('ASC','DESC')) THEN
923: l_field := 'p_br_order';
924: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
925: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
926: FND_MESSAGE.set_token('PARAMETER', l_field);
927: APP_EXCEPTION.raise_exception;
928: END IF;

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

921: -- parameter br_order
922: IF (NVL(p_br_order,'T') NOT IN ('ASC','DESC')) THEN
923: l_field := 'p_br_order';
924: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
925: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
926: FND_MESSAGE.set_token('PARAMETER', l_field);
927: APP_EXCEPTION.raise_exception;
928: END IF;
929:

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

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

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

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

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

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

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

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

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

944: ELSIF p_br_sort_criteria NOT IN ('PS.TRX_NUMBER',
945: 'PS.AMOUNT_DUE_REMAINING',
946: 'TRX_TYPE.NAME') THEN
947: l_field := 'p_br_sort_criteria';
948: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
949: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
950: FND_MESSAGE.set_token('PARAMETER', l_field);
951: APP_EXCEPTION.raise_exception;
952: END IF;

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

945: 'PS.AMOUNT_DUE_REMAINING',
946: 'TRX_TYPE.NAME') THEN
947: l_field := 'p_br_sort_criteria';
948: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
949: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
950: FND_MESSAGE.set_token('PARAMETER', l_field);
951: APP_EXCEPTION.raise_exception;
952: END IF;
953:

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

946: 'TRX_TYPE.NAME') THEN
947: l_field := 'p_br_sort_criteria';
948: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
949: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
950: FND_MESSAGE.set_token('PARAMETER', l_field);
951: APP_EXCEPTION.raise_exception;
952: END IF;
953:
954: -- parameter drawee sort criteria

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

965: 'BRANCH.BANK_NAME',
966: 'BRANCH.BANK_BRANCH_NAME',
967: 'BRANCH.CITY') THEN
968: l_field := 'p_drawee_sort_criteria';
969: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
970: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
971: FND_MESSAGE.set_token('PARAMETER', l_field);
972: APP_EXCEPTION.raise_exception;
973: END IF;

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

966: 'BRANCH.BANK_BRANCH_NAME',
967: 'BRANCH.CITY') THEN
968: l_field := 'p_drawee_sort_criteria';
969: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
970: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
971: FND_MESSAGE.set_token('PARAMETER', l_field);
972: APP_EXCEPTION.raise_exception;
973: END IF;
974:

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

967: 'BRANCH.CITY') THEN
968: l_field := 'p_drawee_sort_criteria';
969: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
970: FND_MESSAGE.set_token('PROCEDURE','validate_br_search_criteria');
971: FND_MESSAGE.set_token('PARAMETER', l_field);
972: APP_EXCEPTION.raise_exception;
973: END IF;
974:
975: IF PG_DEBUG in ('Y', 'C') THEN

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

1194:
1195: -- the flag action value is S for 'Select' or D for 'Deselect' or E for 'Erase'
1196: IF (p_action_flag NOT IN ('S','D','E')) THEN
1197: l_field := 'p_action_flag';
1198: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1199: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1200: FND_MESSAGE.set_token('PARAMETER', l_field);
1201: APP_EXCEPTION.raise_exception;
1202: END IF;

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

1195: -- the flag action value is S for 'Select' or D for 'Deselect' or E for 'Erase'
1196: IF (p_action_flag NOT IN ('S','D','E')) THEN
1197: l_field := 'p_action_flag';
1198: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1199: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1200: FND_MESSAGE.set_token('PARAMETER', l_field);
1201: APP_EXCEPTION.raise_exception;
1202: END IF;
1203:

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

1196: IF (p_action_flag NOT IN ('S','D','E')) THEN
1197: l_field := 'p_action_flag';
1198: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1199: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1200: FND_MESSAGE.set_token('PARAMETER', l_field);
1201: APP_EXCEPTION.raise_exception;
1202: END IF;
1203:
1204: -- the batch id isn't NULL ??

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

1203:
1204: -- the batch id isn't NULL ??
1205: IF (p_batch_id IS NULL) THEN
1206: l_field := 'p_batch_id';
1207: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1208: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1209: FND_MESSAGE.set_token('PARAMETER', l_field);
1210: APP_EXCEPTION.raise_exception;
1211: END IF;

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

1204: -- the batch id isn't NULL ??
1205: IF (p_batch_id IS NULL) THEN
1206: l_field := 'p_batch_id';
1207: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1208: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1209: FND_MESSAGE.set_token('PARAMETER', l_field);
1210: APP_EXCEPTION.raise_exception;
1211: END IF;
1212:

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

1205: IF (p_batch_id IS NULL) THEN
1206: l_field := 'p_batch_id';
1207: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1208: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1209: FND_MESSAGE.set_token('PARAMETER', l_field);
1210: APP_EXCEPTION.raise_exception;
1211: END IF;
1212:
1213: -- fetch the remittance batch row

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

1216: l_control_amount := l_batch_rec.control_amount;
1217:
1218: -- The remittance has been approved; no changes are allowed
1219: IF (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1220: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_UPDATE_REMIT');
1221: APP_EXCEPTION.raise_exception;
1222: END IF;
1223:
1224: -- the payment schedule isn't NULL ??

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

1223:
1224: -- the payment schedule isn't NULL ??
1225: IF (p_ps_id IS NULL) THEN
1226: l_field := 'p_ps_id';
1227: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1228: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1229: FND_MESSAGE.set_token('PARAMETER', l_field);
1230: APP_EXCEPTION.raise_exception;
1231: END IF;

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

1224: -- the payment schedule isn't NULL ??
1225: IF (p_ps_id IS NULL) THEN
1226: l_field := 'p_ps_id';
1227: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1228: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1229: FND_MESSAGE.set_token('PARAMETER', l_field);
1230: APP_EXCEPTION.raise_exception;
1231: END IF;
1232:

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

1225: IF (p_ps_id IS NULL) THEN
1226: l_field := 'p_ps_id';
1227: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1228: FND_MESSAGE.set_token('PROCEDURE','add_or_rm_br_to_remit');
1229: FND_MESSAGE.set_token('PARAMETER', l_field);
1230: APP_EXCEPTION.raise_exception;
1231: END IF;
1232:
1233: -- fetch the assigned trx payment schedule row

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

1409: -- validations
1410: --------------------------------------------------
1411: IF p_create_flag <> 'Y' THEN
1412: l_field := 'p_create_flag';
1413: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1414: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1415: FND_MESSAGE.set_token('PARAMETER', l_field);
1416: APP_EXCEPTION.raise_exception;
1417: END IF;

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

1410: --------------------------------------------------
1411: IF p_create_flag <> 'Y' THEN
1412: l_field := 'p_create_flag';
1413: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1414: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1415: FND_MESSAGE.set_token('PARAMETER', l_field);
1416: APP_EXCEPTION.raise_exception;
1417: END IF;
1418:

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

1411: IF p_create_flag <> 'Y' THEN
1412: l_field := 'p_create_flag';
1413: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1414: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1415: FND_MESSAGE.set_token('PARAMETER', l_field);
1416: APP_EXCEPTION.raise_exception;
1417: END IF;
1418:
1419:

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

1418:
1419:
1420: IF p_approve_flag NOT IN ('Y','N') THEN
1421: l_field := 'p_approve_flag';
1422: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1423: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1424: FND_MESSAGE.set_token('PARAMETER', l_field);
1425: APP_EXCEPTION.raise_exception;
1426: END IF;

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

1419:
1420: IF p_approve_flag NOT IN ('Y','N') THEN
1421: l_field := 'p_approve_flag';
1422: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1423: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1424: FND_MESSAGE.set_token('PARAMETER', l_field);
1425: APP_EXCEPTION.raise_exception;
1426: END IF;
1427:

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

1420: IF p_approve_flag NOT IN ('Y','N') THEN
1421: l_field := 'p_approve_flag';
1422: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1423: FND_MESSAGE.set_token('PROCEDURE','create_remit_batch_conc_req');
1424: FND_MESSAGE.set_token('PARAMETER', l_field);
1425: APP_EXCEPTION.raise_exception;
1426: END IF;
1427:
1428: IF p_format_flag NOT IN ('Y','N') THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1508: argument34 =>p_drawee_order,
1509: argument35 =>p_physical_bill);
1510:
1511: IF (l_request_id = 0) THEN
1512: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1513: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1514: APP_EXCEPTION.raise_exception;
1515: ELSE
1516: IF PG_DEBUG in ('Y', 'C') THEN

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

1509: argument35 =>p_physical_bill);
1510:
1511: IF (l_request_id = 0) THEN
1512: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1513: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1514: APP_EXCEPTION.raise_exception;
1515: ELSE
1516: IF PG_DEBUG in ('Y', 'C') THEN
1517: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

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

1639: -- validations
1640: --------------------------------------------------
1641: IF p_approve_flag NOT IN ('Y','N') THEN
1642: l_field := 'p_approve_flag';
1643: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1644: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1645: FND_MESSAGE.set_token('PARAMETER', l_field);
1646: APP_EXCEPTION.raise_exception;
1647: END IF;

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

1640: --------------------------------------------------
1641: IF p_approve_flag NOT IN ('Y','N') THEN
1642: l_field := 'p_approve_flag';
1643: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1644: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1645: FND_MESSAGE.set_token('PARAMETER', l_field);
1646: APP_EXCEPTION.raise_exception;
1647: END IF;
1648:

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

1641: IF p_approve_flag NOT IN ('Y','N') THEN
1642: l_field := 'p_approve_flag';
1643: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1644: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1645: FND_MESSAGE.set_token('PARAMETER', l_field);
1646: APP_EXCEPTION.raise_exception;
1647: END IF;
1648:
1649: IF p_format_flag NOT IN ('Y','N') THEN

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

1647: END IF;
1648:
1649: IF p_format_flag NOT IN ('Y','N') THEN
1650: l_field := 'p_format_flag';
1651: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
1652: FND_MESSAGE.set_token('PROCEDURE','maintain_remit_batch_conc_req');
1653: FND_MESSAGE.set_token('PARAMETER', l_field);
1654: APP_EXCEPTION.raise_exception;
1655: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1686: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1687:
1688: -- Validation
1689: IF (p_cancel_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL','STARTED_CANCELLATION')) THEN
1690: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');
1691: APP_EXCEPTION.raise_exception;
1692: END IF;
1693:
1694: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN

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

1691: APP_EXCEPTION.raise_exception;
1692: END IF;
1693:
1694: IF (p_approve_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL')) THEN
1695: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');
1696: APP_EXCEPTION.raise_exception;
1697: END IF;
1698:
1699: --MOAC changes

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

1742: argument34 =>'',
1743: argument35 =>p_physical_bill);
1744:
1745: IF (l_request_id = 0) THEN
1746: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1747: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1748: APP_EXCEPTION.raise_exception;
1749: ELSE
1750: IF PG_DEBUG in ('Y', 'C') THEN

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

1743: argument35 =>p_physical_bill);
1744:
1745: IF (l_request_id = 0) THEN
1746: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1747: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1748: APP_EXCEPTION.raise_exception;
1749: ELSE
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));