[Home] [Help]
PACKAGE: APPS.PSA_UTILS
Source
1 PACKAGE PSA_UTILS AUTHID CURRENT_USER as
2 /* $Header: PSAUTILS.pls 120.9 2010/11/26 09:29:31 gnrajago ship $ */
3
4 g_session_seq_id number;
5 g_msg_num number;
6
7 -- ==============================FND_LOG===================================--
8 /*=========================================================================+
9 | Procedure Name: |
10 | debug_unexpected_msg |
11 | |
12 | Description: |
13 | This procedure is for fnd logging and call this to log the seeded |
14 | message IGI_LOGGING_UNEXP_ERROR when no message is there in the |
15 | Unexpected(WHEN OTHERS THEN) Exception section |
16 | |
17 | History |
18 | 16-JAN-04 Harikiran Created |
19 +=========================================================================*/
20
21 PROCEDURE debug_unexpected_msg(p_full_path IN VARCHAR2);
22
23 /*=========================================================================+
24 | Procedure Name: |
25 | debug_other_msg |
26 | |
27 | Description: |
28 | This procedure is for fnd logging and call this to log messages |
29 | in all the other cases |
30 | |
31 | History |
32 | 16-JAN-04 Harikiran Created |
33 +=========================================================================*/
34
35 PROCEDURE debug_other_msg(p_level IN NUMBER,
36 p_full_path IN VARCHAR2,
37 p_remove_from_stack IN BOOLEAN);
38
39 /*=========================================================================+
40 | Procedure Name: |
41 | debug_other_string |
42 | |
43 | Description: |
44 | This procedure is for fnd logging and call this to log |
45 | Hard Coded String messages |
46 | |
47 | History |
48 | 16-JAN-04 Harikiran Created |
49 +=========================================================================*/
50
51 PROCEDURE debug_other_string(p_level IN NUMBER,
52 p_full_path IN VARCHAR2,
53 p_string IN VARCHAR2);
54
55 -- ==============================END==============================--
56 PROCEDURE debug_mesg (p_msg IN VARCHAR2 );
57
58 -- procedure to get the rfe ccid for passed ccid
59 Procedure PSA_Get_RFE_ccid(p_ccid in number,
60 rfe_ccid out nocopy number);
61 PROCEDURE undo_xla_accounting_for_inv
62 (
63 p_invoice_id IN NUMBER,
64 p_user_id IN fnd_user.user_id%TYPE,
65 p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
66 p_gl_date IN DATE,
67 p_tar_number IN VARCHAR2,
68 p_bug_number IN VARCHAR2,
69 p_mode in varchar2 default 'B',
70 p_start_deb_id OUT NOCOPY NUMBER,
71 p_end_deb_id OUT NOCOPY NUMBER
72 );
73
74 PROCEDURE validate_user_name
75 (
76 p_user_name IN VARCHAR2,
77 p_user_id OUT NOCOPY NUMBER
78 );
79 PROCEDURE validate_user_id
80 (
81 p_user_id IN NUMBER
82 );
83 PROCEDURE validate_resp_id
84 (
85 p_user_id IN NUMBER,
86 p_resp_id IN NUMBER,
87 p_appl_id IN NUMBER
88 );
89 PROCEDURE validate_invoice_id
90 (
91 p_user_id IN NUMBER,
92 p_resp_id IN NUMBER,
93 p_invoice_id IN NUMBER,
94 p_invoice_num OUT NOCOPY ap_invoices_all.invoice_num%TYPE,
95 p_org_id OUT NOCOPY NUMBER,
96 p_ledger_id OUT NOCOPY NUMBER
97 );
98 PROCEDURE validate_gl_date
99 (
100 p_gl_date IN DATE,
101 p_ledger_id IN NUMBER
102 );
103 PROCEDURE validate_tar_number
104 (
105 p_tar_number IN VARCHAR2
106 );
107 PROCEDURE validate_bug_number
108 (
109 p_bug_number IN VARCHAR2
110 );
111 PROCEDURE validate_po_header_id
112 (
113 p_user_id IN NUMBER,
114 p_resp_id IN NUMBER,
115 p_po_header_id IN NUMBER,
116 p_po_num OUT NOCOPY ap_invoices_all.invoice_num%TYPE,
117 p_org_id OUT NOCOPY NUMBER,
118 p_ledger_id OUT NOCOPY NUMBER
119 );
120 PROCEDURE undo_xla_accounting_for_po
121 (
122 p_po_header_id IN NUMBER,
123 p_user_id IN fnd_user.user_id%TYPE,
124 p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
125 p_gl_date IN DATE,
126 p_tar_number IN VARCHAR2,
127 p_bug_number IN VARCHAR2,
128 p_start_deb_id OUT NOCOPY NUMBER,
129 p_end_deb_id OUT NOCOPY NUMBER
130 );
131 PROCEDURE redo_xla_accounting_for_po
132 (
133 p_po_header_id IN NUMBER,
134 p_user_id IN fnd_user.user_id%TYPE,
135 p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
136 p_tar_number IN VARCHAR2,
137 p_bug_number IN VARCHAR2,
138 p_start_deb_id OUT NOCOPY NUMBER,
139 p_end_deb_id OUT NOCOPY NUMBER
140 );
141
142 END ;