eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BASELINE_FUNDING_PKG dependencies on PA_DEBUG

Line 26: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

22: | x_msg_data OUT Error message |
23: | ================================================================================== |
24: +----------------------------------------------------------------------------------------*/
25:
26: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
27: g_module_name VARCHAR2(100) := 'pa.plsql.PA_BASELINE_FUNDING_PKG';
28:
29: PROCEDURE create_draft (
30: p_project_id IN NUMBER,

Line 69: IF p_pa_debug_mode = 'Y' THEN

65: lx_budget_version_id := x_budget_version_id;
66:
67:
68: x_err_code := 0;
69: IF p_pa_debug_mode = 'Y' THEN
70: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_DRAFT');
71: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
72: END IF;
73:

Line 70: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_DRAFT');

66:
67:
68: x_err_code := 0;
69: IF p_pa_debug_mode = 'Y' THEN
70: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_DRAFT');
71: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
72: END IF;
73:
74: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 71: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

67:
68: x_err_code := 0;
69: IF p_pa_debug_mode = 'Y' THEN
70: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_DRAFT');
71: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
72: END IF;
73:
74: IF P_PA_DEBUG_MODE = 'Y' THEN
75: pa_debug.g_err_stage:= 'Calling check_funding_level';

Line 74: IF P_PA_DEBUG_MODE = 'Y' THEN

70: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_DRAFT');
71: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
72: END IF;
73:
74: IF P_PA_DEBUG_MODE = 'Y' THEN
75: pa_debug.g_err_stage:= 'Calling check_funding_level';
76: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
77: END IF;
78:

Line 75: pa_debug.g_err_stage:= 'Calling check_funding_level';

71: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
72: END IF;
73:
74: IF P_PA_DEBUG_MODE = 'Y' THEN
75: pa_debug.g_err_stage:= 'Calling check_funding_level';
76: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
77: END IF;
78:
79: pa_billing_core.check_funding_level (

Line 76: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

72: END IF;
73:
74: IF P_PA_DEBUG_MODE = 'Y' THEN
75: pa_debug.g_err_stage:= 'Calling check_funding_level';
76: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
77: END IF;
78:
79: pa_billing_core.check_funding_level (
80: x_project_id => p_project_id,

Line 86: IF P_PA_DEBUG_MODE = 'Y' THEN

82: x_err_code => l_err_code,
83: x_err_stage => l_err_stage,
84: x_err_stack => l_err_stack);
85:
86: IF P_PA_DEBUG_MODE = 'Y' THEN
87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;
88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;

83: x_err_stage => l_err_stage,
84: x_err_stack => l_err_stack);
85:
86: IF P_PA_DEBUG_MODE = 'Y' THEN
87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;
88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

Line 88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

84: x_err_stack => l_err_stack);
85:
86: IF P_PA_DEBUG_MODE = 'Y' THEN
87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;
88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
92: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 89: pa_debug.g_err_stage:= 'error code - '||l_err_code;

85:
86: IF P_PA_DEBUG_MODE = 'Y' THEN
87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;
88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
92: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
93: END IF;

Line 90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

86: IF P_PA_DEBUG_MODE = 'Y' THEN
87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;
88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
92: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
93: END IF;
94:

Line 91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

87: pa_debug.g_err_stage:= 'After check_funding_level, funding level - '||l_funding_level;
88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
92: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
93: END IF;
94:
95: IF l_err_code <> 0 then

Line 92: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

88: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
89: pa_debug.g_err_stage:= 'error code - '||l_err_code;
90: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
91: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
92: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
93: END IF;
94:
95: IF l_err_code <> 0 then
96: x_err_code := l_err_code;

Line 109: IF P_PA_DEBUG_MODE = 'Y' THEN

105: ELSIF l_funding_level = 'T' then
106: l_budget_entry_method_code := 'PA_TASKLVL_BASELINE';
107: END IF;
108:
109: IF P_PA_DEBUG_MODE = 'Y' THEN
110: pa_debug.g_err_stage:= 'Calling budget_utils create_draft';
111: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
112: END IF;
113:

Line 110: pa_debug.g_err_stage:= 'Calling budget_utils create_draft';

106: l_budget_entry_method_code := 'PA_TASKLVL_BASELINE';
107: END IF;
108:
109: IF P_PA_DEBUG_MODE = 'Y' THEN
110: pa_debug.g_err_stage:= 'Calling budget_utils create_draft';
111: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
112: END IF;
113:
114: pa_budget_utils.create_draft

Line 111: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

107: END IF;
108:
109: IF P_PA_DEBUG_MODE = 'Y' THEN
110: pa_debug.g_err_stage:= 'Calling budget_utils create_draft';
111: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
112: END IF;
113:
114: pa_budget_utils.create_draft
115: (x_project_id => p_project_id

Line 145: IF P_PA_DEBUG_MODE = 'Y' THEN

141: ,x_err_stack => l_err_stack);
142:
143: x_err_code := l_err_code;
144:
145: IF P_PA_DEBUG_MODE = 'Y' THEN
146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;
147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;

142:
143: x_err_code := l_err_code;
144:
145: IF P_PA_DEBUG_MODE = 'Y' THEN
146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;
147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;

Line 147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

143: x_err_code := l_err_code;
144:
145: IF P_PA_DEBUG_MODE = 'Y' THEN
146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;
147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;
151: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;

144:
145: IF P_PA_DEBUG_MODE = 'Y' THEN
146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;
147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;
151: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
152: END IF;

Line 149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

145: IF P_PA_DEBUG_MODE = 'Y' THEN
146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;
147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;
151: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
152: END IF;
153:

Line 150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;

146: pa_debug.g_err_stage:= 'After create_draft , budget version id - '||l_budget_version_id;
147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;
151: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
152: END IF;
153:
154: IF x_err_code <> 0 THEN

Line 151: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

147: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
148: pa_debug.g_err_stage:= 'error code is -'||l_err_code;
149: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
150: pa_debug.g_err_stage:= 'error code is -'||l_err_stage;
151: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
152: END IF;
153:
154: IF x_err_code <> 0 THEN
155:

Line 164: IF P_PA_DEBUG_MODE = 'Y' THEN

160: END IF ;
161:
162: IF x_err_code = 0 then
163:
164: IF P_PA_DEBUG_MODE = 'Y' THEN
165: pa_debug.g_err_stage:= 'Error Code is 0';
166: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
167: END IF;
168:

Line 165: pa_debug.g_err_stage:= 'Error Code is 0';

161:
162: IF x_err_code = 0 then
163:
164: IF P_PA_DEBUG_MODE = 'Y' THEN
165: pa_debug.g_err_stage:= 'Error Code is 0';
166: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
167: END IF;
168:
169: OPEN budget_version;

Line 166: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

162: IF x_err_code = 0 then
163:
164: IF P_PA_DEBUG_MODE = 'Y' THEN
165: pa_debug.g_err_stage:= 'Error Code is 0';
166: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
167: END IF;
168:
169: OPEN budget_version;
170: FETCH budget_version into l_budget_version_id;

Line 173: IF P_PA_DEBUG_MODE = 'Y' THEN

169: OPEN budget_version;
170: FETCH budget_version into l_budget_version_id;
171: CLOSE budget_version;
172:
173: IF P_PA_DEBUG_MODE = 'Y' THEN
174: pa_debug.g_err_stage:= 'Budget version ID in the table - '||l_budget_version_id;
175: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
176: END IF;
177: x_budget_version_id := l_budget_version_id;

Line 174: pa_debug.g_err_stage:= 'Budget version ID in the table - '||l_budget_version_id;

170: FETCH budget_version into l_budget_version_id;
171: CLOSE budget_version;
172:
173: IF P_PA_DEBUG_MODE = 'Y' THEN
174: pa_debug.g_err_stage:= 'Budget version ID in the table - '||l_budget_version_id;
175: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
176: END IF;
177: x_budget_version_id := l_budget_version_id;
178:

Line 175: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

171: CLOSE budget_version;
172:
173: IF P_PA_DEBUG_MODE = 'Y' THEN
174: pa_debug.g_err_stage:= 'Budget version ID in the table - '||l_budget_version_id;
175: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
176: END IF;
177: x_budget_version_id := l_budget_version_id;
178:
179: END IF;

Line 181: IF P_PA_DEBUG_MODE = 'Y' THEN

177: x_budget_version_id := l_budget_version_id;
178:
179: END IF;
180:
181: IF P_PA_DEBUG_MODE = 'Y' THEN
182: pa_debug.g_err_stage:= 'x_budget_version_id = '||x_budget_version_id;
183: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
184: END IF;
185:

Line 182: pa_debug.g_err_stage:= 'x_budget_version_id = '||x_budget_version_id;

178:
179: END IF;
180:
181: IF P_PA_DEBUG_MODE = 'Y' THEN
182: pa_debug.g_err_stage:= 'x_budget_version_id = '||x_budget_version_id;
183: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
184: END IF;
185:
186: pa_debug.reset_err_stack;

Line 183: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

179: END IF;
180:
181: IF P_PA_DEBUG_MODE = 'Y' THEN
182: pa_debug.g_err_stage:= 'x_budget_version_id = '||x_budget_version_id;
183: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
184: END IF;
185:
186: pa_debug.reset_err_stack;
187:

Line 186: pa_debug.reset_err_stack;

182: pa_debug.g_err_stage:= 'x_budget_version_id = '||x_budget_version_id;
183: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
184: END IF;
185:
186: pa_debug.reset_err_stack;
187:
188: EXCEPTION
189:
190: WHEN OTHERS THEN

Line 200: IF P_PA_DEBUG_MODE = 'Y' THEN

196: /* ATG Changes */
197:
198: x_budget_version_id := lx_budget_version_id;
199:
200: IF P_PA_DEBUG_MODE = 'Y' THEN
201: pa_debug.g_err_stage:= 'Exception in create_draft, error - '||x_status;
202: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
203: END IF;
204: pa_debug.reset_err_stack;

Line 201: pa_debug.g_err_stage:= 'Exception in create_draft, error - '||x_status;

197:
198: x_budget_version_id := lx_budget_version_id;
199:
200: IF P_PA_DEBUG_MODE = 'Y' THEN
201: pa_debug.g_err_stage:= 'Exception in create_draft, error - '||x_status;
202: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
203: END IF;
204: pa_debug.reset_err_stack;
205: END create_draft;

Line 202: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

198: x_budget_version_id := lx_budget_version_id;
199:
200: IF P_PA_DEBUG_MODE = 'Y' THEN
201: pa_debug.g_err_stage:= 'Exception in create_draft, error - '||x_status;
202: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
203: END IF;
204: pa_debug.reset_err_stack;
205: END create_draft;
206:

Line 204: pa_debug.reset_err_stack;

200: IF P_PA_DEBUG_MODE = 'Y' THEN
201: pa_debug.g_err_stage:= 'Exception in create_draft, error - '||x_status;
202: pa_debug.write('create_draft: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
203: END IF;
204: pa_debug.reset_err_stack;
205: END create_draft;
206:
207:
208: PROCEDURE create_line (

Line 247: IF p_pa_debug_mode = 'Y' THEN

243: BEGIN
244:
245:
246: x_err_code := 0;
247: IF p_pa_debug_mode = 'Y' THEN
248: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');
249: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
250: END IF;
251:

Line 248: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');

244:
245:
246: x_err_code := 0;
247: IF p_pa_debug_mode = 'Y' THEN
248: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');
249: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
250: END IF;
251:
252: FOR f1_rec in funding_amount loop

Line 249: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

245:
246: x_err_code := 0;
247: IF p_pa_debug_mode = 'Y' THEN
248: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');
249: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
250: END IF;
251:
252: FOR f1_rec in funding_amount loop
253:

Line 254: IF P_PA_DEBUG_MODE = 'Y' THEN

250: END IF;
251:
252: FOR f1_rec in funding_amount loop
253:
254: IF P_PA_DEBUG_MODE = 'Y' THEN
255: pa_debug.g_err_stage:= 'In the loop of funding_amount';
256: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
257: END IF;
258:

Line 255: pa_debug.g_err_stage:= 'In the loop of funding_amount';

251:
252: FOR f1_rec in funding_amount loop
253:
254: IF P_PA_DEBUG_MODE = 'Y' THEN
255: pa_debug.g_err_stage:= 'In the loop of funding_amount';
256: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
257: END IF;
258:
259: if f1_rec.task_id is not null then

Line 256: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

252: FOR f1_rec in funding_amount loop
253:
254: IF P_PA_DEBUG_MODE = 'Y' THEN
255: pa_debug.g_err_stage:= 'In the loop of funding_amount';
256: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
257: END IF;
258:
259: if f1_rec.task_id is not null then
260:

Line 288: IF P_PA_DEBUG_MODE = 'Y' THEN

284: l_task_id := 0;
285:
286: end if;
287:
288: IF P_PA_DEBUG_MODE = 'Y' THEN
289: pa_debug.g_err_stage:= 'start date - '||l_start_date;
290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

Line 289: pa_debug.g_err_stage:= 'start date - '||l_start_date;

285:
286: end if;
287:
288: IF P_PA_DEBUG_MODE = 'Y' THEN
289: pa_debug.g_err_stage:= 'start date - '||l_start_date;
290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
293: pa_debug.g_err_stage:= 'task id - '||l_task_id;

Line 290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

286: end if;
287:
288: IF P_PA_DEBUG_MODE = 'Y' THEN
289: pa_debug.g_err_stage:= 'start date - '||l_start_date;
290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
293: pa_debug.g_err_stage:= 'task id - '||l_task_id;
294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

Line 291: pa_debug.g_err_stage:= 'end date - '||l_end_date;

287:
288: IF P_PA_DEBUG_MODE = 'Y' THEN
289: pa_debug.g_err_stage:= 'start date - '||l_start_date;
290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
293: pa_debug.g_err_stage:= 'task id - '||l_task_id;
294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
295: END IF;

Line 292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

288: IF P_PA_DEBUG_MODE = 'Y' THEN
289: pa_debug.g_err_stage:= 'start date - '||l_start_date;
290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
293: pa_debug.g_err_stage:= 'task id - '||l_task_id;
294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
295: END IF;
296:

Line 293: pa_debug.g_err_stage:= 'task id - '||l_task_id;

289: pa_debug.g_err_stage:= 'start date - '||l_start_date;
290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
293: pa_debug.g_err_stage:= 'task id - '||l_task_id;
294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
295: END IF;
296:
297: --dbms_output.put_line ('call util crt line');

Line 294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

290: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
291: pa_debug.g_err_stage:= 'end date - '||l_end_date;
292: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
293: pa_debug.g_err_stage:= 'task id - '||l_task_id;
294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
295: END IF;
296:
297: --dbms_output.put_line ('call util crt line');
298: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 298: IF P_PA_DEBUG_MODE = 'Y' THEN

294: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
295: END IF;
296:
297: --dbms_output.put_line ('call util crt line');
298: IF P_PA_DEBUG_MODE = 'Y' THEN
299: pa_debug.g_err_stage:= 'Calling budget_utils create_line';
300: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
301: END IF;
302: pa_budget_utils.create_line

Line 299: pa_debug.g_err_stage:= 'Calling budget_utils create_line';

295: END IF;
296:
297: --dbms_output.put_line ('call util crt line');
298: IF P_PA_DEBUG_MODE = 'Y' THEN
299: pa_debug.g_err_stage:= 'Calling budget_utils create_line';
300: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
301: END IF;
302: pa_budget_utils.create_line
303: (x_budget_version_id => p_budget_version_id

Line 300: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

296:
297: --dbms_output.put_line ('call util crt line');
298: IF P_PA_DEBUG_MODE = 'Y' THEN
299: pa_debug.g_err_stage:= 'Calling budget_utils create_line';
300: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
301: END IF;
302: pa_budget_utils.create_line
303: (x_budget_version_id => p_budget_version_id
304: ,x_project_id => p_project_id

Line 341: IF P_PA_DEBUG_MODE = 'Y' THEN

337: ,x_err_code => l_err_code
338: ,x_err_stage => l_err_stage
339: ,x_err_stack => l_err_stack);
340:
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.g_err_stage:= 'After budget_utils create_line';
343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

Line 342: pa_debug.g_err_stage:= 'After budget_utils create_line';

338: ,x_err_stage => l_err_stage
339: ,x_err_stack => l_err_stack);
340:
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.g_err_stage:= 'After budget_utils create_line';
343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

Line 343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

339: ,x_err_stack => l_err_stack);
340:
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.g_err_stage:= 'After budget_utils create_line';
343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
347: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

Line 344: pa_debug.g_err_stage:= 'error code - '||l_err_code;

340:
341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.g_err_stage:= 'After budget_utils create_line';
343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
347: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
348: END IF;

Line 345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

341: IF P_PA_DEBUG_MODE = 'Y' THEN
342: pa_debug.g_err_stage:= 'After budget_utils create_line';
343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
347: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
348: END IF;
349:

Line 346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

342: pa_debug.g_err_stage:= 'After budget_utils create_line';
343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
347: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
348: END IF;
349:
350:

Line 347: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

343: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
344: pa_debug.g_err_stage:= 'error code - '||l_err_code;
345: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
346: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
347: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
348: END IF;
349:
350:
351: if l_err_code <> 0 then

Line 362: IF P_PA_DEBUG_MODE = 'Y' THEN

358: end if;
359:
360: END LOOP;
361:
362: IF P_PA_DEBUG_MODE = 'Y' THEN
363: pa_debug.g_err_stage:= 'End of create_line procedure';
364: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
365: END IF;
366:

Line 363: pa_debug.g_err_stage:= 'End of create_line procedure';

359:
360: END LOOP;
361:
362: IF P_PA_DEBUG_MODE = 'Y' THEN
363: pa_debug.g_err_stage:= 'End of create_line procedure';
364: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
365: END IF;
366:
367: pa_debug.reset_err_stack;

Line 364: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

360: END LOOP;
361:
362: IF P_PA_DEBUG_MODE = 'Y' THEN
363: pa_debug.g_err_stage:= 'End of create_line procedure';
364: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
365: END IF;
366:
367: pa_debug.reset_err_stack;
368:

Line 367: pa_debug.reset_err_stack;

363: pa_debug.g_err_stage:= 'End of create_line procedure';
364: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
365: END IF;
366:
367: pa_debug.reset_err_stack;
368:
369: EXCEPTION
370: WHEN OTHERS THEN
371:

Line 375: IF P_PA_DEBUG_MODE = 'Y' THEN

371:
372: x_err_code := SQLCODE;
373: x_status := substr(SQLERRM,1,50);
374:
375: IF P_PA_DEBUG_MODE = 'Y' THEN
376: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
377: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
378: END IF;
379: pa_debug.reset_err_stack;

Line 376: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;

372: x_err_code := SQLCODE;
373: x_status := substr(SQLERRM,1,50);
374:
375: IF P_PA_DEBUG_MODE = 'Y' THEN
376: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
377: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
378: END IF;
379: pa_debug.reset_err_stack;
380: END create_line;

Line 377: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

373: x_status := substr(SQLERRM,1,50);
374:
375: IF P_PA_DEBUG_MODE = 'Y' THEN
376: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
377: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
378: END IF;
379: pa_debug.reset_err_stack;
380: END create_line;
381:

Line 379: pa_debug.reset_err_stack;

375: IF P_PA_DEBUG_MODE = 'Y' THEN
376: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
377: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
378: END IF;
379: pa_debug.reset_err_stack;
380: END create_line;
381:
382:
383:

Line 488: IF p_pa_debug_mode = 'Y' THEN

484:
485: savepoint temp_pt;
486: x_err_code := 0;
487:
488: IF p_pa_debug_mode = 'Y' THEN
489: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');
490: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
491: END IF;
492:

Line 489: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');

485: savepoint temp_pt;
486: x_err_code := 0;
487:
488: IF p_pa_debug_mode = 'Y' THEN
489: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');
490: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
491: END IF;
492:
493: OPEN res_info;

Line 490: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

486: x_err_code := 0;
487:
488: IF p_pa_debug_mode = 'Y' THEN
489: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');
490: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
491: END IF;
492:
493: OPEN res_info;
494: FETCH res_info INTO res_info_rec;

Line 553: IF P_PA_DEBUG_MODE = 'Y' THEN

549: x_msg_data => l_msg_data
550: );
551:
552: IF l_plan_type_id is NULL THEN
553: IF P_PA_DEBUG_MODE = 'Y' THEN
554: pa_debug.g_err_stage:= 'No Plan type ID';
555: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
556: END IF;
557:

Line 554: pa_debug.g_err_stage:= 'No Plan type ID';

550: );
551:
552: IF l_plan_type_id is NULL THEN
553: IF P_PA_DEBUG_MODE = 'Y' THEN
554: pa_debug.g_err_stage:= 'No Plan type ID';
555: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
556: END IF;
557:
558: /* Added for fp - end*/

Line 555: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

551:
552: IF l_plan_type_id is NULL THEN
553: IF P_PA_DEBUG_MODE = 'Y' THEN
554: pa_debug.g_err_stage:= 'No Plan type ID';
555: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
556: END IF;
557:
558: /* Added for fp - end*/
559: --dbms_output.put_line ('calling create_draft ' );

Line 572: IF P_PA_DEBUG_MODE = 'Y' THEN

568:
569: x_err_code := l_err_code;
570: x_status := l_status;
571: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;

569: x_err_code := l_err_code;
570: x_status := l_status;
571: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
577: pa_debug.g_err_stage:= 'error status - '||l_status;

Line 574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

570: x_status := l_status;
571: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
577: pa_debug.g_err_stage:= 'error status - '||l_status;
578: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 575: pa_debug.g_err_stage:= 'error code - '||l_err_code;

571: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
577: pa_debug.g_err_stage:= 'error status - '||l_status;
578: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
579: END IF;

Line 576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
577: pa_debug.g_err_stage:= 'error status - '||l_status;
578: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
579: END IF;
580:

Line 577: pa_debug.g_err_stage:= 'error status - '||l_status;

573: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
577: pa_debug.g_err_stage:= 'error status - '||l_status;
578: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
579: END IF;
580:
581: /* END IF; */

Line 578: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: pa_debug.g_err_stage:= 'error code - '||l_err_code;
576: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
577: pa_debug.g_err_stage:= 'error status - '||l_status;
578: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
579: END IF;
580:
581: /* END IF; */
582:

Line 598: IF P_PA_DEBUG_MODE = 'Y' THEN

594:
595: x_err_code := l_err_code;
596: x_status := l_status;
597:
598: IF P_PA_DEBUG_MODE = 'Y' THEN
599: pa_debug.g_err_stage:= 'After create_line';
600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 599: pa_debug.g_err_stage:= 'After create_line';

595: x_err_code := l_err_code;
596: x_status := l_status;
597:
598: IF P_PA_DEBUG_MODE = 'Y' THEN
599: pa_debug.g_err_stage:= 'After create_line';
600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
603: pa_debug.g_err_stage:= 'error status - '||l_status;

Line 600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

596: x_status := l_status;
597:
598: IF P_PA_DEBUG_MODE = 'Y' THEN
599: pa_debug.g_err_stage:= 'After create_line';
600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
603: pa_debug.g_err_stage:= 'error status - '||l_status;
604: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 601: pa_debug.g_err_stage:= 'error code - '||l_err_code;

597:
598: IF P_PA_DEBUG_MODE = 'Y' THEN
599: pa_debug.g_err_stage:= 'After create_line';
600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
603: pa_debug.g_err_stage:= 'error status - '||l_status;
604: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
605: END IF;

Line 602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

598: IF P_PA_DEBUG_MODE = 'Y' THEN
599: pa_debug.g_err_stage:= 'After create_line';
600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
603: pa_debug.g_err_stage:= 'error status - '||l_status;
604: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
605: END IF;
606: /*

Line 603: pa_debug.g_err_stage:= 'error status - '||l_status;

599: pa_debug.g_err_stage:= 'After create_line';
600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
603: pa_debug.g_err_stage:= 'error status - '||l_status;
604: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
605: END IF;
606: /*
607: ELSE

Line 604: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

600: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
601: pa_debug.g_err_stage:= 'error code - '||l_err_code;
602: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
603: pa_debug.g_err_stage:= 'error status - '||l_status;
604: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
605: END IF;
606: /*
607: ELSE
608: x_status := l_status;

Line 612: IF P_PA_DEBUG_MODE = 'Y' THEN

608: x_status := l_status;
609: */
610: --dbms_output.put_line ('err 2 - ' || x_err_code);
611: --dbms_output.put_line ('stat 2 - ' || x_status);
612: IF P_PA_DEBUG_MODE = 'Y' THEN
613: pa_debug.g_err_stage:= 'After create_line - 1';
614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 613: pa_debug.g_err_stage:= 'After create_line - 1';

609: */
610: --dbms_output.put_line ('err 2 - ' || x_err_code);
611: --dbms_output.put_line ('stat 2 - ' || x_status);
612: IF P_PA_DEBUG_MODE = 'Y' THEN
613: pa_debug.g_err_stage:= 'After create_line - 1';
614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: pa_debug.g_err_stage:= 'error status - '||l_status;

Line 614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

610: --dbms_output.put_line ('err 2 - ' || x_err_code);
611: --dbms_output.put_line ('stat 2 - ' || x_status);
612: IF P_PA_DEBUG_MODE = 'Y' THEN
613: pa_debug.g_err_stage:= 'After create_line - 1';
614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: pa_debug.g_err_stage:= 'error status - '||l_status;
618: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 615: pa_debug.g_err_stage:= 'error code - '||l_err_code;

611: --dbms_output.put_line ('stat 2 - ' || x_status);
612: IF P_PA_DEBUG_MODE = 'Y' THEN
613: pa_debug.g_err_stage:= 'After create_line - 1';
614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: pa_debug.g_err_stage:= 'error status - '||l_status;
618: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
619: END IF;

Line 616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

612: IF P_PA_DEBUG_MODE = 'Y' THEN
613: pa_debug.g_err_stage:= 'After create_line - 1';
614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: pa_debug.g_err_stage:= 'error status - '||l_status;
618: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
619: END IF;
620:

Line 617: pa_debug.g_err_stage:= 'error status - '||l_status;

613: pa_debug.g_err_stage:= 'After create_line - 1';
614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: pa_debug.g_err_stage:= 'error status - '||l_status;
618: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
619: END IF;
620:
621: END IF;

Line 618: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

614: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
615: pa_debug.g_err_stage:= 'error code - '||l_err_code;
616: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
617: pa_debug.g_err_stage:= 'error status - '||l_status;
618: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
619: END IF;
620:
621: END IF;
622: /* Added for fp */

Line 711: IF P_PA_DEBUG_MODE = 'Y' THEN

707:
708: END IF; /* x_err_code 1 */
709: /* Added for fp - end*/
710:
711: IF P_PA_DEBUG_MODE = 'Y' THEN
712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';

708: END IF; /* x_err_code 1 */
709: /* Added for fp - end*/
710:
711: IF P_PA_DEBUG_MODE = 'Y' THEN
712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;

Line 713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

709: /* Added for fp - end*/
710:
711: IF P_PA_DEBUG_MODE = 'Y' THEN
712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
717: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;

710:
711: IF P_PA_DEBUG_MODE = 'Y' THEN
712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
717: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
718: END IF;

Line 715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

711: IF P_PA_DEBUG_MODE = 'Y' THEN
712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
717: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
718: END IF;
719:

Line 716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;

712: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
717: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
718: END IF;
719:
720: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then

Line 717: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

713: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
714: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
715: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
716: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
717: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
718: END IF;
719:
720: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
721: IF l_plan_type_id is NULL THEN /* For bug 4198840*/

Line 723: IF P_PA_DEBUG_MODE = 'Y' THEN

719:
720: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
721: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
722: --dbms_output.put_line ('calling summerize ' );
723: IF P_PA_DEBUG_MODE = 'Y' THEN
724: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
725: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
726: END IF;
727:

Line 724: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';

720: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
721: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
722: --dbms_output.put_line ('calling summerize ' );
723: IF P_PA_DEBUG_MODE = 'Y' THEN
724: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
725: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
726: END IF;
727:
728: pa_budget_utils.summerize_project_totals (

Line 725: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

721: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
722: --dbms_output.put_line ('calling summerize ' );
723: IF P_PA_DEBUG_MODE = 'Y' THEN
724: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
725: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
726: END IF;
727:
728: pa_budget_utils.summerize_project_totals (
729: x_budget_version_id => l_budget_version_id,

Line 734: IF P_PA_DEBUG_MODE = 'Y' THEN

730: x_err_code => l_err_code,
731: x_err_stage => l_err_stage,
732: x_err_stack => l_err_stack);
733:
734: IF P_PA_DEBUG_MODE = 'Y' THEN
735: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
738: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 735: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;

731: x_err_stage => l_err_stage,
732: x_err_stack => l_err_stack);
733:
734: IF P_PA_DEBUG_MODE = 'Y' THEN
735: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
738: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
739: END IF;

Line 736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

732: x_err_stack => l_err_stack);
733:
734: IF P_PA_DEBUG_MODE = 'Y' THEN
735: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
738: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
739: END IF;
740: x_err_code := l_err_code;

Line 737: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;

733:
734: IF P_PA_DEBUG_MODE = 'Y' THEN
735: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
738: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
739: END IF;
740: x_err_code := l_err_code;
741: x_status := l_err_stage;

Line 738: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

734: IF P_PA_DEBUG_MODE = 'Y' THEN
735: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
738: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
739: END IF;
740: x_err_code := l_err_code;
741: x_status := l_err_stage;
742: /*

Line 746: IF P_PA_DEBUG_MODE = 'Y' THEN

742: /*
743: ELSE
744: x_status := l_status;
745: */
746: IF P_PA_DEBUG_MODE = 'Y' THEN
747: pa_debug.g_err_stage:= 'Error status - '||l_status;
748: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
749: END IF;
750: --dbms_output.put_line ('err 3 - ' || x_err_code);

Line 747: pa_debug.g_err_stage:= 'Error status - '||l_status;

743: ELSE
744: x_status := l_status;
745: */
746: IF P_PA_DEBUG_MODE = 'Y' THEN
747: pa_debug.g_err_stage:= 'Error status - '||l_status;
748: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
749: END IF;
750: --dbms_output.put_line ('err 3 - ' || x_err_code);
751: --dbms_output.put_line ('stat 3 - ' || x_status);

Line 748: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

744: x_status := l_status;
745: */
746: IF P_PA_DEBUG_MODE = 'Y' THEN
747: pa_debug.g_err_stage:= 'Error status - '||l_status;
748: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
749: END IF;
750: --dbms_output.put_line ('err 3 - ' || x_err_code);
751: --dbms_output.put_line ('stat 3 - ' || x_status);
752: END IF; --For bug 4198840

Line 758: IF P_PA_DEBUG_MODE = 'Y' THEN

754:
755:
756: IF x_err_code = 0 and l_plan_type_id IS NULL then
757: --dbms_output.put_line ('calling baseline ' );
758: IF P_PA_DEBUG_MODE = 'Y' THEN
759: pa_debug.g_err_stage:= 'Calling budget_core.baseline';
760: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
761: END IF;
762: pa_budget_core.baseline(

Line 759: pa_debug.g_err_stage:= 'Calling budget_core.baseline';

755:
756: IF x_err_code = 0 and l_plan_type_id IS NULL then
757: --dbms_output.put_line ('calling baseline ' );
758: IF P_PA_DEBUG_MODE = 'Y' THEN
759: pa_debug.g_err_stage:= 'Calling budget_core.baseline';
760: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
761: END IF;
762: pa_budget_core.baseline(
763: x_draft_version_id => l_budget_version_id,

Line 760: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

756: IF x_err_code = 0 and l_plan_type_id IS NULL then
757: --dbms_output.put_line ('calling baseline ' );
758: IF P_PA_DEBUG_MODE = 'Y' THEN
759: pa_debug.g_err_stage:= 'Calling budget_core.baseline';
760: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
761: END IF;
762: pa_budget_core.baseline(
763: x_draft_version_id => l_budget_version_id,
764: x_mark_as_original => 'Y',

Line 772: IF P_PA_DEBUG_MODE = 'Y' THEN

768: x_err_stack => l_err_stack);
769:
770: x_err_code := l_err_code;
771: x_status := l_err_stage;
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
774: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
775: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
776: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 773: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;

769:
770: x_err_code := l_err_code;
771: x_status := l_err_stage;
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
774: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
775: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
776: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
777: END IF;

Line 774: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

770: x_err_code := l_err_code;
771: x_status := l_err_stage;
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
774: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
775: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
776: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
777: END IF;
778: /*

Line 775: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

771: x_status := l_err_stage;
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
774: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
775: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
776: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
777: END IF;
778: /*
779:

Line 776: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
774: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
775: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
776: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
777: END IF;
778: /*
779:
780: ELSE

Line 781: IF P_PA_DEBUG_MODE = 'Y' THEN

777: END IF;
778: /*
779:
780: ELSE
781: IF P_PA_DEBUG_MODE = 'Y' THEN
782: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
783: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
784: END IF;
785: x_status := l_err_stage;

Line 782: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

778: /*
779:
780: ELSE
781: IF P_PA_DEBUG_MODE = 'Y' THEN
782: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
783: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
784: END IF;
785: x_status := l_err_stage;
786: */

Line 783: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

779:
780: ELSE
781: IF P_PA_DEBUG_MODE = 'Y' THEN
782: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
783: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
784: END IF;
785: x_status := l_err_stage;
786: */
787: --dbms_output.put_line ('stat 4 - ' || x_status);

Line 791: IF P_PA_DEBUG_MODE = 'Y' THEN

787: --dbms_output.put_line ('stat 4 - ' || x_status);
788:
789: END IF;
790:
791: IF P_PA_DEBUG_MODE = 'Y' THEN
792: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
793: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
794: pa_debug.g_err_stage:= 'return status - '||l_return_status;
795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 792: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;

788:
789: END IF;
790:
791: IF P_PA_DEBUG_MODE = 'Y' THEN
792: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
793: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
794: pa_debug.g_err_stage:= 'return status - '||l_return_status;
795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
796: END IF;

Line 793: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

789: END IF;
790:
791: IF P_PA_DEBUG_MODE = 'Y' THEN
792: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
793: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
794: pa_debug.g_err_stage:= 'return status - '||l_return_status;
795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
796: END IF;
797: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 794: pa_debug.g_err_stage:= 'return status - '||l_return_status;

790:
791: IF P_PA_DEBUG_MODE = 'Y' THEN
792: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
793: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
794: pa_debug.g_err_stage:= 'return status - '||l_return_status;
795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
796: END IF;
797: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: rollback to temp_pt;

Line 795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

791: IF P_PA_DEBUG_MODE = 'Y' THEN
792: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
793: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
794: pa_debug.g_err_stage:= 'return status - '||l_return_status;
795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
796: END IF;
797: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: rollback to temp_pt;
799: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 799: IF P_PA_DEBUG_MODE = 'Y' THEN

795: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
796: END IF;
797: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: rollback to temp_pt;
799: IF P_PA_DEBUG_MODE = 'Y' THEN
800: pa_debug.g_err_stage:= 'Rolling back';
801: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
802: END IF;
803: --dbms_output.put_line ('stat 5 - ' || x_status);

Line 800: pa_debug.g_err_stage:= 'Rolling back';

796: END IF;
797: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: rollback to temp_pt;
799: IF P_PA_DEBUG_MODE = 'Y' THEN
800: pa_debug.g_err_stage:= 'Rolling back';
801: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
802: END IF;
803: --dbms_output.put_line ('stat 5 - ' || x_status);
804: end if;

Line 801: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

797: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: rollback to temp_pt;
799: IF P_PA_DEBUG_MODE = 'Y' THEN
800: pa_debug.g_err_stage:= 'Rolling back';
801: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
802: END IF;
803: --dbms_output.put_line ('stat 5 - ' || x_status);
804: end if;
805: pa_debug.reset_err_stack;

Line 805: pa_debug.reset_err_stack;

801: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
802: END IF;
803: --dbms_output.put_line ('stat 5 - ' || x_status);
804: end if;
805: pa_debug.reset_err_stack;
806:
807: EXCEPTION
808: WHEN OTHERS THEN
809:

Line 810: IF P_PA_DEBUG_MODE = 'Y' THEN

806:
807: EXCEPTION
808: WHEN OTHERS THEN
809:
810: IF P_PA_DEBUG_MODE = 'Y' THEN
811: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';
812: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
813: END IF;
814: x_err_code := SQLCODE;

Line 811: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';

807: EXCEPTION
808: WHEN OTHERS THEN
809:
810: IF P_PA_DEBUG_MODE = 'Y' THEN
811: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';
812: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
813: END IF;
814: x_err_code := SQLCODE;
815: x_status := substr(SQLERRM,1,50);

Line 812: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

808: WHEN OTHERS THEN
809:
810: IF P_PA_DEBUG_MODE = 'Y' THEN
811: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';
812: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
813: END IF;
814: x_err_code := SQLCODE;
815: x_status := substr(SQLERRM,1,50);
816: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 816: IF P_PA_DEBUG_MODE = 'Y' THEN

812: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
813: END IF;
814: x_err_code := SQLCODE;
815: x_status := substr(SQLERRM,1,50);
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error code - '||x_err_code;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
819: pa_debug.g_err_stage:= 'status - '||x_status;
820: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 817: pa_debug.g_err_stage:= 'error code - '||x_err_code;

813: END IF;
814: x_err_code := SQLCODE;
815: x_status := substr(SQLERRM,1,50);
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error code - '||x_err_code;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
819: pa_debug.g_err_stage:= 'status - '||x_status;
820: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
821: END IF;

Line 818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

814: x_err_code := SQLCODE;
815: x_status := substr(SQLERRM,1,50);
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error code - '||x_err_code;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
819: pa_debug.g_err_stage:= 'status - '||x_status;
820: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
821: END IF;
822:

Line 819: pa_debug.g_err_stage:= 'status - '||x_status;

815: x_status := substr(SQLERRM,1,50);
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error code - '||x_err_code;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
819: pa_debug.g_err_stage:= 'status - '||x_status;
820: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
821: END IF;
822:
823: END create_budget_baseline;

Line 820: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error code - '||x_err_code;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
819: pa_debug.g_err_stage:= 'status - '||x_status;
820: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
821: END IF;
822:
823: END create_budget_baseline;
824: