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 2006/05/15 01:10:25 azahmed 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 2006/05/15 01:10:25 azahmed 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 2499: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM

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

Line 2564: 'OZF_AR_SETTLEMENT_PVT',

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

Line 2591: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_GL_ENTRIES

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

Line 2685: 'OZF_AR_SETTLEMENT_PVT'

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

Line 2698: 'OZF_AR_SETTLEMENT_PVT',

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

Line 2796: 'OZF_AR_SETTLEMENT_PVT'

2792: ,p_process_name => 'Revert_GL_Entries'
2793: ,x_error_msg => l_error_msg
2794: );
2795: WF_CORE.context(
2796: 'OZF_AR_SETTLEMENT_PVT'
2797: ,'Revert_GL_Entries'
2798: ,itemtype
2799: ,itemkey
2800: ,actid

Line 2808: 'OZF_AR_SETTLEMENT_PVT',

2804:
2805: WHEN OTHERS THEN
2806: ROLLBACK TO Revert_GL_Entries;
2807: WF_CORE.context(
2808: 'OZF_AR_SETTLEMENT_PVT',
2809: 'Revert_GL_Entries',
2810: itemtype,
2811: itemkey,
2812: to_char(actid),

Line 2835: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_PAYMENT

2831: -- - 'COMPLETE:ERROR'
2832: --
2833: -- USED BY ACTIVITIES
2834: --
2835: -- OZF_AR_SETTLEMENT_PVT OZF_CREATE_PAYMENT
2836: ---------------------------------------------------------------------------------
2837: PROCEDURE Create_Payment(
2838: itemtype IN VARCHAR2,
2839: itemkey IN VARCHAR2,

Line 2987: 'OZF_AR_SETTLEMENT_PVT'

2983: ,p_process_name => 'CREATE_PAYMENT'
2984: ,x_error_msg => l_error_msg
2985: );
2986: WF_CORE.context(
2987: 'OZF_AR_SETTLEMENT_PVT'
2988: ,'CREATE_PAYMENT'
2989: ,itemtype
2990: ,itemkey
2991: ,actid

Line 2999: 'OZF_AR_SETTLEMENT_PVT',

2995: RETURN;
2996: WHEN OTHERS THEN
2997: ROLLBACK TO create_payment;
2998: WF_CORE.context(
2999: 'OZF_AR_SETTLEMENT_PVT',
3000: 'Create_Payment',
3001: itemtype,
3002: itemkey,
3003: to_char(actid),

Line 3027: -- OZF_AR_SETTLEMENT_PVT CHECK_CLAIM_CLASS

3023: -- - 'COMPLETE:END'
3024: --
3025: -- USED BY ACTIVITIES
3026: --
3027: -- OZF_AR_SETTLEMENT_PVT CHECK_CLAIM_CLASS
3028: ---------------------------------------------------------------------------------
3029: PROCEDURE Check_Claim_Class(
3030: itemtype IN VARCHAR2,
3031: itemkey IN VARCHAR2,

Line 3071: 'OZF_AR_SETTLEMENT_PVT',

3067: --
3068: EXCEPTION
3069: WHEN OTHERS THEN
3070: WF_CORE.context(
3071: 'OZF_AR_SETTLEMENT_PVT',
3072: 'Check_Claim_Class',
3073: itemtype,
3074: itemkey,
3075: to_char(actid),

Line 3212: 'OZF_AR_SETTLEMENT_PVT',

3208: --
3209: EXCEPTION
3210: WHEN OTHERS THEN
3211: WF_CORE.context(
3212: 'OZF_AR_SETTLEMENT_PVT',
3213: 'CHECK_PAYMENT_METHOD',
3214: itemtype,
3215: itemkey,
3216: to_char(actid),

Line 3294: 'OZF_AR_SETTLEMENT_PVT',

3290: --
3291: EXCEPTION
3292: WHEN OTHERS THEN
3293: WF_CORE.context(
3294: 'OZF_AR_SETTLEMENT_PVT',
3295: 'Prepare_Docs',
3296: itemtype,
3297: itemkey,
3298: to_char(actid),

Line 3321: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM

3317: -- - 'COMPLETE:NO'
3318: --
3319: -- USED BY ACTIVITIES
3320: --
3321: -- OZF_AR_SETTLEMENT_PVT OZF_CHECK_PROMO_CLAIM
3322: ---------------------------------------------------------------------------------
3323: PROCEDURE Check_Auto_Setl_Process(
3324: itemtype IN VARCHAR2,
3325: itemkey IN VARCHAR2,

Line 3389: 'OZF_AR_SETTLEMENT_PVT',

3385: --
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: WF_CORE.context(
3389: 'OZF_AR_SETTLEMENT_PVT',
3390: 'Check_Auto_Setl_Process',
3391: itemtype,
3392: itemkey,
3393: to_char(actid),

Line 3399: END OZF_AR_SETTLEMENT_PVT;

3395: );
3396: RAISE;
3397: END Check_Auto_Setl_Process;
3398:
3399: END OZF_AR_SETTLEMENT_PVT;