DBA Data[Home] [Help]

APPS.ARP_RW_BATCHES_PKG dependencies on ARP_DEBUG

Line 1341: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()+');

1337: l_org_id := NULL;
1338: l_default_org_id := fnd_profile.value('DEFAULT_ORG_ID');
1339: l_defaulted_flag := 'N';
1340: IF PG_DEBUG IN ('Y', 'C') THEN
1341: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()+');
1342: arp_debug.debug(' default_org_id: ' || l_default_org_id);
1343: arp_debug.debug(' p_batch_source_name: ' || p_batch_source_name);
1344: END IF;
1345: /* Fetch Data from Default Batch Source */

Line 1342: arp_debug.debug(' default_org_id: ' || l_default_org_id);

1338: l_default_org_id := fnd_profile.value('DEFAULT_ORG_ID');
1339: l_defaulted_flag := 'N';
1340: IF PG_DEBUG IN ('Y', 'C') THEN
1341: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()+');
1342: arp_debug.debug(' default_org_id: ' || l_default_org_id);
1343: arp_debug.debug(' p_batch_source_name: ' || p_batch_source_name);
1344: END IF;
1345: /* Fetch Data from Default Batch Source */
1346: BEGIN

Line 1343: arp_debug.debug(' p_batch_source_name: ' || p_batch_source_name);

1339: l_defaulted_flag := 'N';
1340: IF PG_DEBUG IN ('Y', 'C') THEN
1341: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()+');
1342: arp_debug.debug(' default_org_id: ' || l_default_org_id);
1343: arp_debug.debug(' p_batch_source_name: ' || p_batch_source_name);
1344: END IF;
1345: /* Fetch Data from Default Batch Source */
1346: BEGIN
1347: --Bug fix 5647335 starts

Line 1374: arp_debug.debug(' l_batch_source_id: ' || l_batch_source_id);

1370: p_batch_source_name:=NULL;
1371: l_rec_class_id:=NULL;
1372: END IF;
1373: IF PG_DEBUG IN ('Y', 'C') THEN
1374: arp_debug.debug(' l_batch_source_id: ' || l_batch_source_id);
1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);
1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);
1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);
1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);

Line 1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);

1371: l_rec_class_id:=NULL;
1372: END IF;
1373: IF PG_DEBUG IN ('Y', 'C') THEN
1374: arp_debug.debug(' l_batch_source_id: ' || l_batch_source_id);
1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);
1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);
1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);
1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);
1379: arp_debug.debug(' l_org_id: ' || l_org_id);

Line 1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);

1372: END IF;
1373: IF PG_DEBUG IN ('Y', 'C') THEN
1374: arp_debug.debug(' l_batch_source_id: ' || l_batch_source_id);
1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);
1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);
1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);
1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);
1379: arp_debug.debug(' l_org_id: ' || l_org_id);
1380: END IF;

Line 1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);

1373: IF PG_DEBUG IN ('Y', 'C') THEN
1374: arp_debug.debug(' l_batch_source_id: ' || l_batch_source_id);
1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);
1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);
1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);
1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);
1379: arp_debug.debug(' l_org_id: ' || l_org_id);
1380: END IF;
1381: --Bug fix 5647335 ends

Line 1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);

1374: arp_debug.debug(' l_batch_source_id: ' || l_batch_source_id);
1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);
1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);
1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);
1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);
1379: arp_debug.debug(' l_org_id: ' || l_org_id);
1380: END IF;
1381: --Bug fix 5647335 ends
1382: --Commenting out sql query as part of bug fix 5647335

Line 1379: arp_debug.debug(' l_org_id: ' || l_org_id);

1375: arp_debug.debug(' l_batch_number: ' || l_batch_number);
1376: arp_debug.debug(' l_rec_class_id: ' || l_rec_class_id);
1377: arp_debug.debug(' l_bank_account_id: ' || l_bank_account_id);
1378: arp_debug.debug(' l_pay_method_id: ' || l_pay_method_id);
1379: arp_debug.debug(' l_org_id: ' || l_org_id);
1380: END IF;
1381: --Bug fix 5647335 ends
1382: --Commenting out sql query as part of bug fix 5647335
1383: /*SELECT bs.batch_source_id,

Line 1608: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()-');

1604: p_bank_branch_id :=l_bank_branch_id;
1605: p_override_remit_flag :=l_override_remit_flag;
1606: END IF;
1607: IF PG_DEBUG IN ('Y', 'C') THEN
1608: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()-');
1609: END IF;
1610:
1611: END default_batch_source_pay_mthds;
1612:

Line 1627: arp_debug.debug('arp_rw_batches_pkg.request_lock()+');

1623: v_result NUMBER;
1624:
1625: BEGIN
1626: IF PG_DEBUG IN ('Y', 'C') THEN
1627: arp_debug.debug('arp_rw_batches_pkg.request_lock()+');
1628: arp_debug.debug('p_batch_id '||p_batch_id);
1629: END IF;
1630:
1631: l_lock_name := 'AR_RECEIPTS_BATCH_'||p_batch_id;

Line 1628: arp_debug.debug('p_batch_id '||p_batch_id);

1624:
1625: BEGIN
1626: IF PG_DEBUG IN ('Y', 'C') THEN
1627: arp_debug.debug('arp_rw_batches_pkg.request_lock()+');
1628: arp_debug.debug('p_batch_id '||p_batch_id);
1629: END IF;
1630:
1631: l_lock_name := 'AR_RECEIPTS_BATCH_'||p_batch_id;
1632:

Line 1649: arp_debug.debug('v_result '||v_result);

1645: WHEN 5 THEN x_message := 'illegal lockhandle';
1646: END CASE;
1647:
1648: IF PG_DEBUG IN ('Y', 'C') THEN
1649: arp_debug.debug('v_result '||v_result);
1650: arp_debug.debug('arp_rw_batches_pkg.request_lock()-');
1651: END IF;
1652:
1653: IF v_result IN (0,4) THEN

Line 1650: arp_debug.debug('arp_rw_batches_pkg.request_lock()-');

1646: END CASE;
1647:
1648: IF PG_DEBUG IN ('Y', 'C') THEN
1649: arp_debug.debug('v_result '||v_result);
1650: arp_debug.debug('arp_rw_batches_pkg.request_lock()-');
1651: END IF;
1652:
1653: IF v_result IN (0,4) THEN
1654: RETURN TRUE;

Line 1672: arp_debug.debug('arp_rw_batches_pkg.release_lock()+');

1668: l_lock_handle VARCHAR2(256);
1669: v_result NUMBER;
1670: BEGIN
1671: IF PG_DEBUG IN ('Y', 'C') THEN
1672: arp_debug.debug('arp_rw_batches_pkg.release_lock()+');
1673: arp_debug.debug('p_batch_id '||p_batch_id);
1674: END IF;
1675:
1676: l_lock_name := 'AR_RECEIPTS_BATCH_'||p_batch_id;

Line 1673: arp_debug.debug('p_batch_id '||p_batch_id);

1669: v_result NUMBER;
1670: BEGIN
1671: IF PG_DEBUG IN ('Y', 'C') THEN
1672: arp_debug.debug('arp_rw_batches_pkg.release_lock()+');
1673: arp_debug.debug('p_batch_id '||p_batch_id);
1674: END IF;
1675:
1676: l_lock_name := 'AR_RECEIPTS_BATCH_'||p_batch_id;
1677:

Line 1691: arp_debug.debug('v_result '||v_result);

1687: WHEN 5 THEN x_message := 'illegal lockhandle';
1688: END CASE;
1689:
1690: IF PG_DEBUG IN ('Y', 'C') THEN
1691: arp_debug.debug('v_result '||v_result);
1692: arp_debug.debug('arp_rw_batches_pkg.release_lock()-');
1693: END IF;
1694:
1695: IF v_result = 0 THEN

Line 1692: arp_debug.debug('arp_rw_batches_pkg.release_lock()-');

1688: END CASE;
1689:
1690: IF PG_DEBUG IN ('Y', 'C') THEN
1691: arp_debug.debug('v_result '||v_result);
1692: arp_debug.debug('arp_rw_batches_pkg.release_lock()-');
1693: END IF;
1694:
1695: IF v_result = 0 THEN
1696: RETURN TRUE;