[Home] [Help]
3: l_debug VARCHAR2(30);
4:
5: /* ------------ Private procedures used by the package --------------------- */
6:
7: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
8: /* Bug fix 3927024 */
9: l_actual_amount_total NUMBER;
10: l_actual_count_total NUMBER;
11: l_batch_id NUMBER;
404: /* Bug 5699734 - Changed the logic of getting the org_id - Getting from ar_system_parameters is more reliable */
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
407: END IF;
408: -- l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
409: SELECT org_id
410: INTO l_org_id
411: FROM ar_system_parameters;
412: --l_org_id := nvl(mo_global.get_current_org_id, mo_utils.get_default_org_id);
527: -- Call the concurrent program
528: --
529: /* Additional Fix identified as a part of Bug 5699734 */
530: /* Bug 5699734 - Changed logic to get org_id - Getting from ar_system_parameters would be more reliable */
531: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
534: END IF;
535: SELECT org_id
645: -- Call the concurrent program
646: --
647: /* Additional Fix identified as a part of Bug 5699734*/
648: /* Bug 5699734 - Changed the logic of getting org_id - Getting from ar_system_parameters would be more reliable */
649: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
650: IF PG_DEBUG in ('Y', 'C') THEN
651: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
652: END IF;
653: SELECT org_id
816: -- Shiv Ragunat , 9/11/96 ,Modified the Date parameters to convert it
817: -- to DD-MON-YYYY format, so that the call succeeds for any
818: -- NLS date format.
819: --
820: /* Fix for Bug 5699734 - Wrong org being set because of FND_PROFILE.value('ORG_ID') */
821: /* Bug 5699734 - Changed logic for getting the org_id - Getting from ar_system_parameters would be more reliable */
822: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
823: IF PG_DEBUG in ('Y', 'C') THEN
824: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
818: -- NLS date format.
819: --
820: /* Fix for Bug 5699734 - Wrong org being set because of FND_PROFILE.value('ORG_ID') */
821: /* Bug 5699734 - Changed logic for getting the org_id - Getting from ar_system_parameters would be more reliable */
822: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
823: IF PG_DEBUG in ('Y', 'C') THEN
824: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
825: END IF;
826: SELECT org_id
1136: /* Automatic Receipt Creation process cannot submitted
1137: * if an active document sequence assignment does not exist
1138: * or the profile option Sequential Numbering is set to 'Not Used' */
1139:
1140: IF (fnd_profile.value('UNIQUE:SEQ_NUMBERS') in (NULL, 'N' )) THEN
1141:
1142: /* Cannot submit Automatic Receipt Creation process because the profile option
1143: * Sequential Numbering is set to Not Used. Please set this option to Always Used
1144: * or Partially Used, then resubmit. */
1191:
1192: END Val_Create_Auto_Batch_Submit;
1193: --
1194: BEGIN
1195: l_debug := fnd_profile.value('AFLOG_ENABLED');
1196: IF (l_debug <> 'Y') THEN
1197: l_debug := 'N';
1198: END IF;
1199: END ARP_PROCESS_BOE;