[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
817: -- Shiv Ragunat , 9/11/96 ,Modified the Date parameters to convert it
818: -- to DD-MON-YYYY format, so that the call succeeds for any
819: -- NLS date format.
820: --
821: /* Fix for Bug 5699734 - Wrong org being set because of FND_PROFILE.value('ORG_ID') */
822: /* Bug 5699734 - Changed logic for getting the org_id - Getting from ar_system_parameters would be more reliable */
823: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
824: IF PG_DEBUG in ('Y', 'C') THEN
825: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
819: -- NLS date format.
820: --
821: /* Fix for Bug 5699734 - Wrong org being set because of FND_PROFILE.value('ORG_ID') */
822: /* Bug 5699734 - Changed logic for getting the org_id - Getting from ar_system_parameters would be more reliable */
823: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
824: IF PG_DEBUG in ('Y', 'C') THEN
825: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
826: END IF;
827: SELECT org_id
1169: /* Automatic Receipt Creation process cannot submitted
1170: * if an active document sequence assignment does not exist
1171: * or the profile option Sequential Numbering is set to 'Not Used' */
1172:
1173: IF (fnd_profile.value('UNIQUE:SEQ_NUMBERS') in (NULL, 'N' )) THEN
1174:
1175: /* Cannot submit Automatic Receipt Creation process because the profile option
1176: * Sequential Numbering is set to Not Used. Please set this option to Always Used
1177: * or Partially Used, then resubmit. */
1224:
1225: END Val_Create_Auto_Batch_Submit;
1226: --
1227: BEGIN
1228: l_debug := fnd_profile.value('AFLOG_ENABLED');
1229: IF (l_debug <> 'Y') THEN
1230: l_debug := 'N';
1231: END IF;
1232: END ARP_PROCESS_BOE;