1099: --
1100: --set the application context.
1101: --
1102: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1103: mo_global.init('AR');
1104: mo_global.set_policy_context('S',l_org_id);
1105: --
1106: -- Acquire locks on the payment schedule record so that
1107: -- the record is not changed while this subscription is
1100: --set the application context.
1101: --
1102: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1103: mo_global.init('AR');
1104: mo_global.set_policy_context('S',l_org_id);
1105: --
1106: -- Acquire locks on the payment schedule record so that
1107: -- the record is not changed while this subscription is
1108: -- executed.
1404: --
1405: --set the application context.
1406: --
1407: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1408: mo_global.init('AR');
1409: mo_global.set_policy_context('S',l_org_id);
1410: --
1411: -- No need to acquire locks on the payment schedule record
1412: -- because it would not exist in the database as the Incomplete
1405: --set the application context.
1406: --
1407: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1408: mo_global.init('AR');
1409: mo_global.set_policy_context('S',l_org_id);
1410: --
1411: -- No need to acquire locks on the payment schedule record
1412: -- because it would not exist in the database as the Incomplete
1413: -- event deletes the payment schedules.
1656: --
1657: --set the application context.
1658: --
1659: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1660: mo_global.init('AR');
1661: mo_global.set_policy_context('S',l_org_id);
1662: --Stamp the history record for the modification.
1663: /*bug#5484606-------------------------------------------------------------------+
1664: |cuddagir Added Exception Handling for update statement and moved the logic for |
1657: --set the application context.
1658: --
1659: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1660: mo_global.init('AR');
1661: mo_global.set_policy_context('S',l_org_id);
1662: --Stamp the history record for the modification.
1663: /*bug#5484606-------------------------------------------------------------------+
1664: |cuddagir Added Exception Handling for update statement and moved the logic for |
1665: |setting the flag inside the exception handling. |
1897: --
1898: --set the application context.
1899: --
1900: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1901: mo_global.init('AR');
1902: mo_global.set_policy_context('S',l_org_id);
1903: --
1904: -- Acquire locks on the payment schedule record so that
1905: -- the record is not changed while this subscription is
1898: --set the application context.
1899: --
1900: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1901: mo_global.init('AR');
1902: mo_global.set_policy_context('S',l_org_id);
1903: --
1904: -- Acquire locks on the payment schedule record so that
1905: -- the record is not changed while this subscription is
1906: -- executed.
2252: --
2253: --set the application context.
2254: --
2255: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2256: mo_global.init('AR');
2257: mo_global.set_policy_context('S',l_org_id);
2258:
2259: --
2260: -- No need to acquire locks on the payment schedule record
2253: --set the application context.
2254: --
2255: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2256: mo_global.init('AR');
2257: mo_global.set_policy_context('S',l_org_id);
2258:
2259: --
2260: -- No need to acquire locks on the payment schedule record
2261: -- because it would not exist in the database as the Incomplete
2461: --
2462: --set the application context.
2463: --
2464: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2465: mo_global.init('AR');
2466: mo_global.set_policy_context('S',l_org_id);
2467:
2468: --
2469: -- Acquire locks on the payment schedule record so that
2462: --set the application context.
2463: --
2464: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2465: mo_global.init('AR');
2466: mo_global.set_policy_context('S',l_org_id);
2467:
2468: --
2469: -- Acquire locks on the payment schedule record so that
2470: -- the record is not changed while this subscription is
2713: --
2714: --set the application context.
2715: --
2716: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2717: mo_global.init('AR');
2718: mo_global.set_policy_context('S',l_org_id);
2719: --
2720: -- No need to acquire locks on the payment schedule record
2721: -- because it would not exist in the database as the Incomplete
2714: --set the application context.
2715: --
2716: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2717: mo_global.init('AR');
2718: mo_global.set_policy_context('S',l_org_id);
2719: --
2720: -- No need to acquire locks on the payment schedule record
2721: -- because it would not exist in the database as the Incomplete
2722: -- event deletes the payment schedules.
2901: --
2902: --set the application context.
2903: --
2904: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2905: mo_global.init('AR');
2906: mo_global.set_policy_context('S',l_org_id);
2907:
2908: --
2909: -- Acquire locks on the payment schedule record so that
2902: --set the application context.
2903: --
2904: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2905: mo_global.init('AR');
2906: mo_global.set_policy_context('S',l_org_id);
2907:
2908: --
2909: -- Acquire locks on the payment schedule record so that
2910: -- the record is not changed while this subscription is
3155: --
3156: --set the application context.
3157: --
3158: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3159: mo_global.init('AR');
3160: mo_global.set_policy_context('S',l_org_id);
3161:
3162: --
3163: -- No need to acquire locks on the payment schedule record
3156: --set the application context.
3157: --
3158: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3159: mo_global.init('AR');
3160: mo_global.set_policy_context('S',l_org_id);
3161:
3162: --
3163: -- No need to acquire locks on the payment schedule record
3164: -- because it would not exist in the database as the Incomplete
3346: --
3347: --set the application context.
3348: --
3349: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3350: mo_global.init('AR');
3351: mo_global.set_policy_context('S',l_org_id);
3352: --
3353: -- Acquire locks on the payment schedule record so that
3354: -- the record is not changed while this subscription is
3347: --set the application context.
3348: --
3349: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3350: mo_global.init('AR');
3351: mo_global.set_policy_context('S',l_org_id);
3352: --
3353: -- Acquire locks on the payment schedule record so that
3354: -- the record is not changed while this subscription is
3355: -- executed.
3678: --
3679: --set the application context.
3680: --
3681: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3682: mo_global.init('AR');
3683: mo_global.set_policy_context('S',l_org_id);
3684:
3685: --we would stamp the complete_flag on the ar_trx_summary_hist
3686: --for any records for this cash receipt. They could be due to
3679: --set the application context.
3680: --
3681: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3682: mo_global.init('AR');
3683: mo_global.set_policy_context('S',l_org_id);
3684:
3685: --we would stamp the complete_flag on the ar_trx_summary_hist
3686: --for any records for this cash receipt. They could be due to
3687: -- receipt deletion or modification.
3953: --
3954: --set the application context.
3955: --
3956: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3957: mo_global.init('AR');
3958: mo_global.set_policy_context('S',l_org_id);
3959:
3960: UPDATE ar_trx_summary_hist
3961: set complete_flag = 'Y',
3954: --set the application context.
3955: --
3956: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
3957: mo_global.init('AR');
3958: mo_global.set_policy_context('S',l_org_id);
3959:
3960: UPDATE ar_trx_summary_hist
3961: set complete_flag = 'Y',
3962: LAST_UPDATE_DATE = sysdate,
4139: --
4140: --set the application context.
4141: --
4142: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4143: mo_global.init('AR');
4144: mo_global.set_policy_context('S',l_org_id);
4145:
4146: OPEN get_receipt_hist(l_history_id);
4147: FETCH get_receipt_hist INTO l_hist_rec;
4140: --set the application context.
4141: --
4142: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4143: mo_global.init('AR');
4144: mo_global.set_policy_context('S',l_org_id);
4145:
4146: OPEN get_receipt_hist(l_history_id);
4147: FETCH get_receipt_hist INTO l_hist_rec;
4148:
4875: --
4876: --set the application context.
4877: --
4878: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4879: mo_global.init('AR');
4880: mo_global.set_policy_context('S',l_org_id);
4881:
4882: UPDATE ar_trx_summary_hist
4883: SET complete_flag = 'Y',
4876: --set the application context.
4877: --
4878: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
4879: mo_global.init('AR');
4880: mo_global.set_policy_context('S',l_org_id);
4881:
4882: UPDATE ar_trx_summary_hist
4883: SET complete_flag = 'Y',
4884: LAST_UPDATE_DATE = sysdate,
5051: --
5052: --set the application context.
5053: --
5054: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5055: mo_global.init('AR');
5056: mo_global.set_policy_context('S',l_org_id);
5057:
5058: select to_date(l_due_date_str, 'J')
5059: into l_trx_due_date
5052: --set the application context.
5053: --
5054: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5055: mo_global.init('AR');
5056: mo_global.set_policy_context('S',l_org_id);
5057:
5058: select to_date(l_due_date_str, 'J')
5059: into l_trx_due_date
5060: from dual;
5256: --
5257: --set the application context.
5258: --
5259: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5260: mo_global.init('AR');
5261: mo_global.set_policy_context('S',l_org_id);
5262:
5263: select to_date(l_due_date_str, 'J')
5264: into l_trx_due_date
5257: --set the application context.
5258: --
5259: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5260: mo_global.init('AR');
5261: mo_global.set_policy_context('S',l_org_id);
5262:
5263: select to_date(l_due_date_str, 'J')
5264: into l_trx_due_date
5265: from dual;
5486: --
5487: --set the application context.
5488: --
5489: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5490: mo_global.init('AR');
5491: mo_global.set_policy_context('S',l_org_id);
5492:
5493: select to_date(l_due_date_str, 'J')
5494: into l_trx_due_date
5487: --set the application context.
5488: --
5489: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5490: mo_global.init('AR');
5491: mo_global.set_policy_context('S',l_org_id);
5492:
5493: select to_date(l_due_date_str, 'J')
5494: into l_trx_due_date
5495: from dual;
5780: --
5781: --set the application context.
5782: --
5783: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5784: mo_global.init('AR');
5785: mo_global.set_policy_context('S',l_org_id);
5786:
5787: select to_date(l_due_date_str, 'J')
5788: into l_trx_due_date
5781: --set the application context.
5782: --
5783: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
5784: mo_global.init('AR');
5785: mo_global.set_policy_context('S',l_org_id);
5786:
5787: select to_date(l_due_date_str, 'J')
5788: into l_trx_due_date
5789: from dual;
6175: --
6176: --set the application context.
6177: --
6178: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6179: mo_global.init('AR');
6180: mo_global.set_policy_context('S',l_org_id);
6181:
6182: Update_summary_for_request_id(l_request_id);
6183: IF pg_debug = 'Y'
6176: --set the application context.
6177: --
6178: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6179: mo_global.init('AR');
6180: mo_global.set_policy_context('S',l_org_id);
6181:
6182: Update_summary_for_request_id(l_request_id);
6183: IF pg_debug = 'Y'
6184: THEN
6239: --
6240: --set the application context.
6241: --
6242: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6243: mo_global.init('AR');
6244: mo_global.set_policy_context('S',l_org_id);
6245:
6246: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6247: IF pg_debug = 'Y'
6240: --set the application context.
6241: --
6242: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6243: mo_global.init('AR');
6244: mo_global.set_policy_context('S',l_org_id);
6245:
6246: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6247: IF pg_debug = 'Y'
6248: THEN
6330: --
6331: --set the application context.
6332: --
6333: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6334: mo_global.init('AR');
6335: mo_global.set_policy_context('S',l_org_id);
6336:
6337: OPEN get_adj(l_request_id);
6338:
6331: --set the application context.
6332: --
6333: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6334: mo_global.init('AR');
6335: mo_global.set_policy_context('S',l_org_id);
6336:
6337: OPEN get_adj(l_request_id);
6338:
6339: LOOP
6440: --
6441: --set the application context.
6442: --
6443: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6444: mo_global.init('AR');
6445: mo_global.set_policy_context('S',l_org_id);
6446:
6447: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6448: IF pg_debug = 'Y'
6441: --set the application context.
6442: --
6443: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6444: mo_global.init('AR');
6445: mo_global.set_policy_context('S',l_org_id);
6446:
6447: Update_rcpt_app_info_for_req(l_request_id, l_org_id);
6448: IF pg_debug = 'Y'
6449: THEN
6553: --
6554: --set the application context.
6555: --
6556: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6557: mo_global.init('AR');
6558: mo_global.set_policy_context('S',l_org_id);
6559:
6560: OPEN get_adj_details (l_adjustment_id);
6561:
6554: --set the application context.
6555: --
6556: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6557: mo_global.init('AR');
6558: mo_global.set_policy_context('S',l_org_id);
6559:
6560: OPEN get_adj_details (l_adjustment_id);
6561:
6562: FETCH get_adj_details
6708: --
6709: --set the application context.
6710: --
6711: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6712: mo_global.init('AR');
6713: mo_global.set_policy_context('S',l_org_id);
6714:
6715: OPEN get_adj_details (l_adjustment_id);
6716: FETCH get_adj_details
6709: --set the application context.
6710: --
6711: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6712: mo_global.init('AR');
6713: mo_global.set_policy_context('S',l_org_id);
6714:
6715: OPEN get_adj_details (l_adjustment_id);
6716: FETCH get_adj_details
6717: INTO l_amount,
6839: --
6840: --set the application context.
6841: --
6842: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6843: mo_global.init('AR');
6844: mo_global.set_policy_context('S',l_org_id);
6845:
6846: Update_summary_for_request_id(l_request_id);
6847:
6840: --set the application context.
6841: --
6842: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
6843: mo_global.init('AR');
6844: mo_global.set_policy_context('S',l_org_id);
6845:
6846: Update_summary_for_request_id(l_request_id);
6847:
6848: IF pg_debug = 'Y'