4955: --Bug 6411356
4956: --below code added to set the current nls character setting
4957: --before submitting a child requests.
4958: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
4959: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
4960:
4961: x_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
4962: 'IBY',
4963: 'IBYBUILD',
4957: --before submitting a child requests.
4958: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
4959: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
4960:
4961: x_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
4962: 'IBY',
4963: 'IBYBUILD',
4964: '',
4965: '',
5115: --Bug 6411356
5116: --below code added to set the current nls character setting
5117: --before submitting a child requests.
5118: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
5119: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
5120:
5121:
5122: x_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
5123: 'IBY',
5118: fnd_profile.get('ICX_NUMERIC_CHARACTERS',l_icx_numeric_characters);
5119: l_bool_val:= FND_REQUEST.SET_OPTIONS( numeric_characters => l_icx_numeric_characters);
5120:
5121:
5122: x_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
5123: 'IBY',
5124: 'IBYREPICP',
5125: '',
5126: '',
8526: * Fix for bug 5407120:
8527: *
8528: * Before kicking off reports / formats make sure that
8529: * the numeric characters delimiter is correctly set
8530: * by using FND_REQUEST.SET_OPTIONS(..).
8531: *
8532: * The argument provided to this method is based on
8533: * the lookup ICX_NUMERIC_CHARACTERS.
8534: *
8537: *
8538: * E.g., $10000.52 would be displayed as $10.000,52 for
8539: * PL territory and this causes problems to XML publisher.
8540: */
8541: l_bool_val := FND_REQUEST.SET_OPTIONS(
8542: numeric_characters => l_icx_numeric_characters
8543: );
8544:
8545: l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
8541: l_bool_val := FND_REQUEST.SET_OPTIONS(
8542: numeric_characters => l_icx_numeric_characters
8543: );
8544:
8545: l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
8546: 'IBY',
8547: 'IBY_FD_FINAL_PMT_REGISTER',
8548: '',
8549: '',
8584: * Launch the Separate Remittance Advice report.
8585: */
8586: IF (UPPER(l_auto_sra_submit_flag) = 'Y') THEN
8587:
8588: l_bool_val := FND_REQUEST.SET_OPTIONS(
8589: numeric_characters => l_icx_numeric_characters
8590: );
8591:
8592: l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
8588: l_bool_val := FND_REQUEST.SET_OPTIONS(
8589: numeric_characters => l_icx_numeric_characters
8590: );
8591:
8592: l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
8593: 'IBY',
8594: 'IBY_FD_SRA_FORMAT',
8595: '',
8596: '',
8632: * Launch the Positive Pay program.
8633: */
8634: IF (p_submit_postive_pay = TRUE AND l_pos_pay_format IS NOT NULL) THEN
8635:
8636: l_bool_val := FND_REQUEST.SET_OPTIONS(
8637: numeric_characters => l_icx_numeric_characters
8638: );
8639:
8640: l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
8636: l_bool_val := FND_REQUEST.SET_OPTIONS(
8637: numeric_characters => l_icx_numeric_characters
8638: );
8639:
8640: l_conc_req_id := FND_REQUEST.SUBMIT_REQUEST(
8641: 'IBY',
8642: 'IBY_FD_POS_PAY_FORMAT',
8643: '',
8644: '',