DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on OZF_AR_SETTLEMENT_PVT

Line 1: PACKAGE BODY OZF_AR_SETTLEMENT_PVT AS

1: PACKAGE BODY OZF_AR_SETTLEMENT_PVT AS
2: /* $Header: ozfvcapb.pls 120.11.12010000.4 2010/03/22 04:56:38 kpatro ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_AR_SETTLEMENT_PVT';
5: G_ITEMTYPE CONSTANT varchar2(30) := 'OZF_CSTL';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_AR_SETTLEMENT_PVT';

1: PACKAGE BODY OZF_AR_SETTLEMENT_PVT AS
2: /* $Header: ozfvcapb.pls 120.11.12010000.4 2010/03/22 04:56:38 kpatro ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_AR_SETTLEMENT_PVT';
5: G_ITEMTYPE CONSTANT varchar2(30) := 'OZF_CSTL';
6: ERROR EXCEPTION;
7:
8: --------------------------------------------------------------------------

Line 49: WF_CORE.CONTEXT ('OZF_AR_SETTLEMENT_PVT',

45: END IF;
46:
47: EXCEPTION
48: WHEN OTHERS THEN
49: WF_CORE.CONTEXT ('OZF_AR_SETTLEMENT_PVT',
50: 'set_org_context',
51: p_item_type,
52: p_item_key,
53: p_activity_id,

Line 120: -- OZF_AR_SETTLEMENT_PVT OZF_SET_REMINDER

116: -- - 'COMPLETE:'
117: --
118: -- USED BY ACTIVITIES
119: --
120: -- OZF_AR_SETTLEMENT_PVT OZF_SET_REMINDER
121: --
122: -- HISTORY
123: -- 04/05/2001 MCHANG CREATION.
124: --------------------------------------------------------------------------------

Line 157: 'OZF_AR_SETTLEMENT_PVT',

153: --
154: EXCEPTION
155: WHEN OTHERS THEN
156: WF_CORE.context(
157: 'OZF_AR_SETTLEMENT_PVT',
158: 'Set_Reminder',
159: itemtype,
160: itemkey,
161: to_char(actid),

Line 184: -- OZF_AR_SETTLEMENT_PVT OZF_INCOMPLETE_CLAIM

180: -- - 'COMPLETE:'
181: --
182: -- USED BY ACTIVITIES
183: --
184: -- OZF_AR_SETTLEMENT_PVT OZF_INCOMPLETE_CLAIM
185: --
186: -- HISTORY
187: -- 04/05/2001 MCHANG CREATION.
188: --------------------------------------------------------------------------------

Line 291: 'OZF_AR_SETTLEMENT_PVT'

287: ,p_process_name => 'Incomplete_Creation'
288: ,x_error_msg => l_error_msg
289: );
290: WF_CORE.context(
291: 'OZF_AR_SETTLEMENT_PVT'
292: ,'Incomplete_Creation'
293: ,itemtype
294: ,itemkey
295: ,actid

Line 301: 'OZF_AR_SETTLEMENT_PVT',

297: );
298: RAISE;
299: WHEN OTHERS THEN
300: WF_CORE.context(
301: 'OZF_AR_SETTLEMENT_PVT',
302: 'Incomplete_Creation',
303: itemtype,
304: itemkey,
305: to_char(actid),

Line 328: -- OZF_AR_SETTLEMENT_PVT OZF_RECEIVABLE_INSTRUCTION

324: -- - 'COMPLETE:'
325: --
326: -- USED BY ACTIVITIES
327: --
328: -- OZF_AR_SETTLEMENT_PVT OZF_RECEIVABLE_INSTRUCTION
329: --
330: -- HISTORY
331: -- 04/05/2001 MCHANG CREATION.
332: -- 10/30/2001 MCHNAG Hand 'CANCELLED' and 'REJECTED' deduction :

Line 777: 'OZF_AR_SETTLEMENT_PVT'

773: ,p_process_name => 'PREPARE_INSTRUCTIONS'
774: ,x_error_msg => l_error_msg
775: );
776: WF_CORE.context(
777: 'OZF_AR_SETTLEMENT_PVT'
778: ,'Prepare_Instructions'
779: ,itemtype
780: ,itemkey
781: ,actid

Line 793: 'OZF_AR_SETTLEMENT_PVT',

789: IF (csr_gl_code%ISOPEN) THEN
790: CLOSE csr_gl_code;
791: END IF;
792: WF_CORE.context(
793: 'OZF_AR_SETTLEMENT_PVT',
794: 'Prepare_Instructions',
795: itemtype,
796: itemkey,
797: to_char(actid),

Line 820: -- OZF_AR_SETTLEMENT_PVT OZF_UPDATE_DOCS

816: -- - 'COMPLETE:'
817: --
818: -- USED BY ACTIVITIES
819: --
820: -- OZF_AR_SETTLEMENT_PVT OZF_UPDATE_DOCS
821: --
822: -- HISTORY
823: -- 04/05/2001 MCHANG CREATION.
824: -- 03/04/2002 MCHANG Updated to populate Wriet_off number.(see BUG#2226663)

Line 1168: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',

1164: l_err_msg := l_msg_count||' '||l_msg_data;
1165: END IF;
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',
1169: 'Update_Docs'||'-'||'Update_Settlement_Docs',
1170: itemtype,
1171: itemkey,
1172: to_char(actid),

Line 1234: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',

1230: RETURN;
1231: END IF;
1232: EXCEPTION
1233: WHEN OTHERS THEN
1234: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',
1235: 'Update_Docs'||'-'||'Update_Claim',
1236: itemtype,
1237: itemkey,
1238: to_char(actid),

Line 1258: 'OZF_AR_SETTLEMENT_PVT',

1254: EXCEPTION
1255: WHEN OTHERS THEN
1256: ROLLBACK TO Update_Docs;
1257: WF_CORE.context(
1258: 'OZF_AR_SETTLEMENT_PVT',
1259: 'Update_Docs',
1260: itemtype,
1261: itemkey,
1262: to_char(actid),

Line 1284: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_SETTLE_DOC

1280: -- - 'COMPLETE:SUCCESS'
1281: --
1282: -- USED BY ACTIVITIES
1283: --
1284: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_SETTLE_DOC
1285: --
1286: -- HISTORY
1287: --------------------------------------------------------------------------------
1288: PROCEDURE Create_Settle_Doc(

Line 1437: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',

1433: RETURN;
1434: END IF;
1435: EXCEPTION
1436: WHEN OTHERS THEN
1437: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',
1438: 'Create_Settle_Doc'||'-'||'Create_Settlement_Doc',
1439: itemtype,
1440: itemkey,
1441: to_char(actid),

Line 1474: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',

1470: p_object_version_number => l_settlement_doc_rec.object_version_number
1471: );
1472: EXCEPTION
1473: WHEN OTHERS THEN
1474: WF_CORE.context( 'OZF_AR_SETTLEMENT_PVT',
1475: 'Create_Settle_Doc'||'-'||'Delete_Settlement_Doc',
1476: itemtype,
1477: itemkey,
1478: to_char(actid),

Line 1498: 'OZF_AR_SETTLEMENT_PVT',

1494: EXCEPTION
1495: WHEN OTHERS THEN
1496: ROLLBACK TO Create_Settle_Doc;
1497: WF_CORE.context(
1498: 'OZF_AR_SETTLEMENT_PVT',
1499: 'Create_Settle_Doc',
1500: itemtype,
1501: itemkey,
1502: to_char(actid),

Line 1525: -- OZF_AR_SETTLEMENT_PVT OZF_CLOSE_CLAIM

1521: -- - 'COMPLETE:'
1522: --
1523: -- USED BY ACTIVITIES
1524: --
1525: -- OZF_AR_SETTLEMENT_PVT OZF_CLOSE_CLAIM
1526: --
1527: -- HISTORY
1528: -- 04/05/2001 MCHANG CREATION.
1529: -- 11/15/2001 MCHANG Call OZF_SETTLEMENT_DOC_PVT.Update_Claim_From_Settlement()

Line 1673: 'OZF_AR_SETTLEMENT_PVT'

1669: ,p_process_name => 'CLOSE_CLAIM'
1670: ,x_error_msg => l_error_msg
1671: );
1672: WF_CORE.context(
1673: 'OZF_AR_SETTLEMENT_PVT'
1674: ,'CLOSE_CLAIM'
1675: ,itemtype
1676: ,itemkey
1677: ,actid

Line 1685: 'OZF_AR_SETTLEMENT_PVT',

1681: RAISE;
1682:
1683: WHEN OTHERS THEN
1684: WF_CORE.context(
1685: 'OZF_AR_SETTLEMENT_PVT',
1686: 'Close_Claim',
1687: itemtype,
1688: itemkey,
1689: to_char(actid),

Line 1711: -- OZF_AR_SETTLEMENT_PVT OZF_RESET_STATUS

1707: -- Resultout - 'COMPLETE:'
1708: --
1709: -- USED BY ACTIVITIES
1710: --
1711: -- OZF_AR_SETTLEMENT_PVT OZF_RESET_STATUS
1712: --
1713: -- HISTORY
1714: -- 04/05/2001 MCHANG CREATION.
1715: --------------------------------------------------------------------------------

Line 1830: 'OZF_AR_SETTLEMENT_PVT'

1826: ,p_process_name => 'RESET_STATUS'
1827: ,x_error_msg => l_error_msg
1828: );
1829: WF_CORE.context(
1830: 'OZF_AR_SETTLEMENT_PVT'
1831: ,'Reset_Status'
1832: ,itemtype
1833: ,itemkey
1834: ,actid

Line 1841: 'OZF_AR_SETTLEMENT_PVT',

1837: RAISE;
1838: WHEN OTHERS THEN
1839: ROLLBACK TO Reset_Status;
1840: WF_CORE.context(
1841: 'OZF_AR_SETTLEMENT_PVT',
1842: 'Reset_Status',
1843: itemtype,
1844: itemkey,
1845: to_char(actid),

Line 2500: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM

2496: -- - 'COMPLETE:NO'
2497: --
2498: -- USED BY ACTIVITIES
2499: --
2500: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM
2501: ---------------------------------------------------------------------------------
2502: PROCEDURE Check_Promo_Claim(
2503: itemtype IN VARCHAR2,
2504: itemkey IN VARCHAR2,

Line 2565: 'OZF_AR_SETTLEMENT_PVT',

2561: --
2562: EXCEPTION
2563: WHEN OTHERS THEN
2564: WF_CORE.context(
2565: 'OZF_AR_SETTLEMENT_PVT',
2566: 'Check_Promo_Claim',
2567: itemtype,
2568: itemkey,
2569: to_char(actid),

Line 2592: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_GL_ENTRIES

2588: -- - 'COMPLETE:ERROR'
2589: --
2590: -- USED BY ACTIVITIES
2591: --
2592: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_GL_ENTRIES
2593: ---------------------------------------------------------------------------------
2594: PROCEDURE Create_GL_Entries(
2595: itemtype IN VARCHAR2,
2596: itemkey IN VARCHAR2,

Line 2684: 'OZF_AR_SETTLEMENT_PVT'

2680: ,p_process_name => 'Create_GL_Entrie'
2681: ,x_error_msg => l_error_msg
2682: );
2683: WF_CORE.context(
2684: 'OZF_AR_SETTLEMENT_PVT'
2685: ,'Create_GL_Entries'
2686: ,itemtype
2687: ,itemkey
2688: ,actid

Line 2697: 'OZF_AR_SETTLEMENT_PVT',

2693:
2694: WHEN OTHERS THEN
2695: ROLLBACK TO Create_GL_Entries;
2696: WF_CORE.context(
2697: 'OZF_AR_SETTLEMENT_PVT',
2698: 'Create_GL_Entries',
2699: itemtype,
2700: itemkey,
2701: to_char(actid),

Line 2812: 'OZF_AR_SETTLEMENT_PVT'

2808: ,p_process_name => 'Revert_GL_Entries'
2809: ,x_error_msg => l_error_msg
2810: );
2811: WF_CORE.context(
2812: 'OZF_AR_SETTLEMENT_PVT'
2813: ,'Revert_GL_Entries'
2814: ,itemtype
2815: ,itemkey
2816: ,actid

Line 2824: 'OZF_AR_SETTLEMENT_PVT',

2820:
2821: WHEN OTHERS THEN
2822: ROLLBACK TO Revert_GL_Entries;
2823: WF_CORE.context(
2824: 'OZF_AR_SETTLEMENT_PVT',
2825: 'Revert_GL_Entries',
2826: itemtype,
2827: itemkey,
2828: to_char(actid),

Line 2851: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_PAYMENT

2847: -- - 'COMPLETE:ERROR'
2848: --
2849: -- USED BY ACTIVITIES
2850: --
2851: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_PAYMENT
2852: ---------------------------------------------------------------------------------
2853: PROCEDURE Create_Payment(
2854: itemtype IN VARCHAR2,
2855: itemkey IN VARCHAR2,

Line 3003: 'OZF_AR_SETTLEMENT_PVT'

2999: ,p_process_name => 'CREATE_PAYMENT'
3000: ,x_error_msg => l_error_msg
3001: );
3002: WF_CORE.context(
3003: 'OZF_AR_SETTLEMENT_PVT'
3004: ,'CREATE_PAYMENT'
3005: ,itemtype
3006: ,itemkey
3007: ,actid

Line 3015: 'OZF_AR_SETTLEMENT_PVT',

3011: RETURN;
3012: WHEN OTHERS THEN
3013: ROLLBACK TO create_payment;
3014: WF_CORE.context(
3015: 'OZF_AR_SETTLEMENT_PVT',
3016: 'Create_Payment',
3017: itemtype,
3018: itemkey,
3019: to_char(actid),

Line 3043: -- OZF_AR_SETTLEMENT_PVT CHECK_CLAIM_CLASS

3039: -- - 'COMPLETE:END'
3040: --
3041: -- USED BY ACTIVITIES
3042: --
3043: -- OZF_AR_SETTLEMENT_PVT CHECK_CLAIM_CLASS
3044: ---------------------------------------------------------------------------------
3045: PROCEDURE Check_Claim_Class(
3046: itemtype IN VARCHAR2,
3047: itemkey IN VARCHAR2,

Line 3087: 'OZF_AR_SETTLEMENT_PVT',

3083: --
3084: EXCEPTION
3085: WHEN OTHERS THEN
3086: WF_CORE.context(
3087: 'OZF_AR_SETTLEMENT_PVT',
3088: 'Check_Claim_Class',
3089: itemtype,
3090: itemkey,
3091: to_char(actid),

Line 3228: 'OZF_AR_SETTLEMENT_PVT',

3224: --
3225: EXCEPTION
3226: WHEN OTHERS THEN
3227: WF_CORE.context(
3228: 'OZF_AR_SETTLEMENT_PVT',
3229: 'CHECK_PAYMENT_METHOD',
3230: itemtype,
3231: itemkey,
3232: to_char(actid),

Line 3310: 'OZF_AR_SETTLEMENT_PVT',

3306: --
3307: EXCEPTION
3308: WHEN OTHERS THEN
3309: WF_CORE.context(
3310: 'OZF_AR_SETTLEMENT_PVT',
3311: 'Prepare_Docs',
3312: itemtype,
3313: itemkey,
3314: to_char(actid),

Line 3337: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM

3333: -- - 'COMPLETE:NO'
3334: --
3335: -- USED BY ACTIVITIES
3336: --
3337: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM
3338: ---------------------------------------------------------------------------------
3339: PROCEDURE Check_Auto_Setl_Process(
3340: itemtype IN VARCHAR2,
3341: itemkey IN VARCHAR2,

Line 3405: 'OZF_AR_SETTLEMENT_PVT',

3401: --
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: WF_CORE.context(
3405: 'OZF_AR_SETTLEMENT_PVT',
3406: 'Check_Auto_Setl_Process',
3407: itemtype,
3408: itemkey,
3409: to_char(actid),

Line 3415: END OZF_AR_SETTLEMENT_PVT;

3411: );
3412: RAISE;
3413: END Check_Auto_Setl_Process;
3414:
3415: END OZF_AR_SETTLEMENT_PVT;