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 258: IF p_pa_debug_mode = 'Y' THEN

254:
255:
256:
257: x_err_code := 0;
258: IF p_pa_debug_mode = 'Y' THEN
259: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');
260: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
261: END IF;
262:

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

255:
256:
257: x_err_code := 0;
258: IF p_pa_debug_mode = 'Y' THEN
259: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');
260: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
261: END IF;
262:
263: FOR f1_rec in funding_amount (l_funding_level) loop /*Bug 8718600*/

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

256:
257: x_err_code := 0;
258: IF p_pa_debug_mode = 'Y' THEN
259: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_LINE');
260: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
261: END IF;
262:
263: FOR f1_rec in funding_amount (l_funding_level) loop /*Bug 8718600*/
264:

Line 265: IF P_PA_DEBUG_MODE = 'Y' THEN

261: END IF;
262:
263: FOR f1_rec in funding_amount (l_funding_level) loop /*Bug 8718600*/
264:
265: IF P_PA_DEBUG_MODE = 'Y' THEN
266: pa_debug.g_err_stage:= 'In the loop of funding_amount';
267: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
268: END IF;
269:

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

262:
263: FOR f1_rec in funding_amount (l_funding_level) loop /*Bug 8718600*/
264:
265: IF P_PA_DEBUG_MODE = 'Y' THEN
266: pa_debug.g_err_stage:= 'In the loop of funding_amount';
267: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
268: END IF;
269:
270: if f1_rec.task_id is not null then

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

263: FOR f1_rec in funding_amount (l_funding_level) loop /*Bug 8718600*/
264:
265: IF P_PA_DEBUG_MODE = 'Y' THEN
266: pa_debug.g_err_stage:= 'In the loop of funding_amount';
267: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
268: END IF;
269:
270: if f1_rec.task_id is not null then
271:

Line 299: IF P_PA_DEBUG_MODE = 'Y' THEN

295: l_task_id := 0;
296:
297: end if;
298:
299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_debug.g_err_stage:= 'start date - '||l_start_date;
301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

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

296:
297: end if;
298:
299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_debug.g_err_stage:= 'start date - '||l_start_date;
301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
304: pa_debug.g_err_stage:= 'task id - '||l_task_id;

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

297: end if;
298:
299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_debug.g_err_stage:= 'start date - '||l_start_date;
301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
304: pa_debug.g_err_stage:= 'task id - '||l_task_id;
305: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

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

298:
299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_debug.g_err_stage:= 'start date - '||l_start_date;
301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
304: pa_debug.g_err_stage:= 'task id - '||l_task_id;
305: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
306: END IF;

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

299: IF P_PA_DEBUG_MODE = 'Y' THEN
300: pa_debug.g_err_stage:= 'start date - '||l_start_date;
301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
304: pa_debug.g_err_stage:= 'task id - '||l_task_id;
305: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
306: END IF;
307:

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

300: pa_debug.g_err_stage:= 'start date - '||l_start_date;
301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
304: pa_debug.g_err_stage:= 'task id - '||l_task_id;
305: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
306: END IF;
307:
308: --dbms_output.put_line ('call util crt line');

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

301: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
302: pa_debug.g_err_stage:= 'end date - '||l_end_date;
303: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
304: pa_debug.g_err_stage:= 'task id - '||l_task_id;
305: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
306: END IF;
307:
308: --dbms_output.put_line ('call util crt line');
309: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 309: IF P_PA_DEBUG_MODE = 'Y' THEN

305: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
306: END IF;
307:
308: --dbms_output.put_line ('call util crt line');
309: IF P_PA_DEBUG_MODE = 'Y' THEN
310: pa_debug.g_err_stage:= 'Calling budget_utils create_line';
311: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
312: END IF;
313: pa_budget_utils.create_line

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

306: END IF;
307:
308: --dbms_output.put_line ('call util crt line');
309: IF P_PA_DEBUG_MODE = 'Y' THEN
310: pa_debug.g_err_stage:= 'Calling budget_utils create_line';
311: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
312: END IF;
313: pa_budget_utils.create_line
314: (x_budget_version_id => p_budget_version_id

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

307:
308: --dbms_output.put_line ('call util crt line');
309: IF P_PA_DEBUG_MODE = 'Y' THEN
310: pa_debug.g_err_stage:= 'Calling budget_utils create_line';
311: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
312: END IF;
313: pa_budget_utils.create_line
314: (x_budget_version_id => p_budget_version_id
315: ,x_project_id => p_project_id

Line 352: IF P_PA_DEBUG_MODE = 'Y' THEN

348: ,x_err_code => l_err_code
349: ,x_err_stage => l_err_stage
350: ,x_err_stack => l_err_stack);
351:
352: IF P_PA_DEBUG_MODE = 'Y' THEN
353: pa_debug.g_err_stage:= 'After budget_utils create_line';
354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

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

349: ,x_err_stage => l_err_stage
350: ,x_err_stack => l_err_stack);
351:
352: IF P_PA_DEBUG_MODE = 'Y' THEN
353: pa_debug.g_err_stage:= 'After budget_utils create_line';
354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
357: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;

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

350: ,x_err_stack => l_err_stack);
351:
352: IF P_PA_DEBUG_MODE = 'Y' THEN
353: pa_debug.g_err_stage:= 'After budget_utils create_line';
354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
357: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
358: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);

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

351:
352: IF P_PA_DEBUG_MODE = 'Y' THEN
353: pa_debug.g_err_stage:= 'After budget_utils create_line';
354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
357: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
358: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
359: END IF;

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

352: IF P_PA_DEBUG_MODE = 'Y' THEN
353: pa_debug.g_err_stage:= 'After budget_utils create_line';
354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
357: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
358: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
359: END IF;
360:

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

353: pa_debug.g_err_stage:= 'After budget_utils create_line';
354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
357: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
358: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
359: END IF;
360:
361:

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

354: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
355: pa_debug.g_err_stage:= 'error code - '||l_err_code;
356: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
357: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
358: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL1);
359: END IF;
360:
361:
362: if l_err_code <> 0 then

Line 373: IF P_PA_DEBUG_MODE = 'Y' THEN

369: end if;
370:
371: END LOOP;
372:
373: IF P_PA_DEBUG_MODE = 'Y' THEN
374: pa_debug.g_err_stage:= 'End of create_line procedure';
375: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
376: END IF;
377:

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

370:
371: END LOOP;
372:
373: IF P_PA_DEBUG_MODE = 'Y' THEN
374: pa_debug.g_err_stage:= 'End of create_line procedure';
375: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
376: END IF;
377:
378: pa_debug.reset_err_stack;

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

371: END LOOP;
372:
373: IF P_PA_DEBUG_MODE = 'Y' THEN
374: pa_debug.g_err_stage:= 'End of create_line procedure';
375: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
376: END IF;
377:
378: pa_debug.reset_err_stack;
379:

Line 378: pa_debug.reset_err_stack;

374: pa_debug.g_err_stage:= 'End of create_line procedure';
375: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
376: END IF;
377:
378: pa_debug.reset_err_stack;
379:
380: EXCEPTION
381: WHEN OTHERS THEN
382:

Line 386: IF P_PA_DEBUG_MODE = 'Y' THEN

382:
383: x_err_code := SQLCODE;
384: x_status := substr(SQLERRM,1,50);
385:
386: IF P_PA_DEBUG_MODE = 'Y' THEN
387: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
388: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
389: END IF;
390: pa_debug.reset_err_stack;

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

383: x_err_code := SQLCODE;
384: x_status := substr(SQLERRM,1,50);
385:
386: IF P_PA_DEBUG_MODE = 'Y' THEN
387: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
388: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
389: END IF;
390: pa_debug.reset_err_stack;
391: END create_line;

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

384: x_status := substr(SQLERRM,1,50);
385:
386: IF P_PA_DEBUG_MODE = 'Y' THEN
387: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
388: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
389: END IF;
390: pa_debug.reset_err_stack;
391: END create_line;
392:

Line 390: pa_debug.reset_err_stack;

386: IF P_PA_DEBUG_MODE = 'Y' THEN
387: pa_debug.g_err_stage:= 'In exception of create_line - '||x_status;
388: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
389: END IF;
390: pa_debug.reset_err_stack;
391: END create_line;
392:
393:
394:

Line 507: IF p_pa_debug_mode = 'Y' THEN

503:
504: savepoint temp_pt;
505: x_err_code := 0;
506:
507: IF p_pa_debug_mode = 'Y' THEN
508: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');
509: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
510: END IF;
511:

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

504: savepoint temp_pt;
505: x_err_code := 0;
506:
507: IF p_pa_debug_mode = 'Y' THEN
508: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');
509: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
510: END IF;
511:
512: OPEN res_info;

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

505: x_err_code := 0;
506:
507: IF p_pa_debug_mode = 'Y' THEN
508: pa_debug.set_err_stack('PA_BASELINE_FUNDING_PKG.CREATE_BUDGET_BASELINE');
509: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
510: END IF;
511:
512: OPEN res_info;
513: FETCH res_info INTO res_info_rec;

Line 572: IF P_PA_DEBUG_MODE = 'Y' THEN

568: x_msg_data => l_msg_data
569: );
570:
571: IF l_plan_type_id is NULL THEN
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'No Plan type ID';
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: END IF;
576:

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

569: );
570:
571: IF l_plan_type_id is NULL THEN
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'No Plan type ID';
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: END IF;
576:
577: /* Added for fp - end*/

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

570:
571: IF l_plan_type_id is NULL THEN
572: IF P_PA_DEBUG_MODE = 'Y' THEN
573: pa_debug.g_err_stage:= 'No Plan type ID';
574: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
575: END IF;
576:
577: /* Added for fp - end*/
578: --dbms_output.put_line ('calling create_draft ' );

Line 591: IF P_PA_DEBUG_MODE = 'Y' THEN

587:
588: x_err_code := l_err_code;
589: x_status := l_status;
590: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
591: IF P_PA_DEBUG_MODE = 'Y' THEN
592: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

588: x_err_code := l_err_code;
589: x_status := l_status;
590: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
591: IF P_PA_DEBUG_MODE = 'Y' THEN
592: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
596: pa_debug.g_err_stage:= 'error status - '||l_status;

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

589: x_status := l_status;
590: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
591: IF P_PA_DEBUG_MODE = 'Y' THEN
592: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
596: pa_debug.g_err_stage:= 'error status - '||l_status;
597: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

590: --dbms_output.put_line ('after calling create_draft -' || x_err_code);
591: IF P_PA_DEBUG_MODE = 'Y' THEN
592: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
596: pa_debug.g_err_stage:= 'error status - '||l_status;
597: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
598: END IF;

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

591: IF P_PA_DEBUG_MODE = 'Y' THEN
592: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
596: pa_debug.g_err_stage:= 'error status - '||l_status;
597: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
598: END IF;
599:

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

592: pa_debug.g_err_stage:= 'After create_draft, budget version id is - '||l_budget_version_id;
593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
596: pa_debug.g_err_stage:= 'error status - '||l_status;
597: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
598: END IF;
599:
600: /* END IF; */

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

593: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
594: pa_debug.g_err_stage:= 'error code - '||l_err_code;
595: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
596: pa_debug.g_err_stage:= 'error status - '||l_status;
597: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
598: END IF;
599:
600: /* END IF; */
601:

Line 617: IF P_PA_DEBUG_MODE = 'Y' THEN

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

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

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

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

615: x_status := l_status;
616:
617: IF P_PA_DEBUG_MODE = 'Y' THEN
618: pa_debug.g_err_stage:= 'After create_line';
619: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
620: pa_debug.g_err_stage:= 'error code - '||l_err_code;
621: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
622: pa_debug.g_err_stage:= 'error status - '||l_status;
623: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

616:
617: IF P_PA_DEBUG_MODE = 'Y' THEN
618: pa_debug.g_err_stage:= 'After create_line';
619: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
620: pa_debug.g_err_stage:= 'error code - '||l_err_code;
621: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
622: pa_debug.g_err_stage:= 'error status - '||l_status;
623: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
624: END IF;

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

617: IF P_PA_DEBUG_MODE = 'Y' THEN
618: pa_debug.g_err_stage:= 'After create_line';
619: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
620: pa_debug.g_err_stage:= 'error code - '||l_err_code;
621: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
622: pa_debug.g_err_stage:= 'error status - '||l_status;
623: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
624: END IF;
625: /*

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

618: pa_debug.g_err_stage:= 'After create_line';
619: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
620: pa_debug.g_err_stage:= 'error code - '||l_err_code;
621: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
622: pa_debug.g_err_stage:= 'error status - '||l_status;
623: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
624: END IF;
625: /*
626: ELSE

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

619: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
620: pa_debug.g_err_stage:= 'error code - '||l_err_code;
621: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
622: pa_debug.g_err_stage:= 'error status - '||l_status;
623: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
624: END IF;
625: /*
626: ELSE
627: x_status := l_status;

Line 631: IF P_PA_DEBUG_MODE = 'Y' THEN

627: x_status := l_status;
628: */
629: --dbms_output.put_line ('err 2 - ' || x_err_code);
630: --dbms_output.put_line ('stat 2 - ' || x_status);
631: IF P_PA_DEBUG_MODE = 'Y' THEN
632: pa_debug.g_err_stage:= 'After create_line - 1';
633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

628: */
629: --dbms_output.put_line ('err 2 - ' || x_err_code);
630: --dbms_output.put_line ('stat 2 - ' || x_status);
631: IF P_PA_DEBUG_MODE = 'Y' THEN
632: pa_debug.g_err_stage:= 'After create_line - 1';
633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
636: pa_debug.g_err_stage:= 'error status - '||l_status;

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

629: --dbms_output.put_line ('err 2 - ' || x_err_code);
630: --dbms_output.put_line ('stat 2 - ' || x_status);
631: IF P_PA_DEBUG_MODE = 'Y' THEN
632: pa_debug.g_err_stage:= 'After create_line - 1';
633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
636: pa_debug.g_err_stage:= 'error status - '||l_status;
637: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

630: --dbms_output.put_line ('stat 2 - ' || x_status);
631: IF P_PA_DEBUG_MODE = 'Y' THEN
632: pa_debug.g_err_stage:= 'After create_line - 1';
633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
636: pa_debug.g_err_stage:= 'error status - '||l_status;
637: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
638: END IF;

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

631: IF P_PA_DEBUG_MODE = 'Y' THEN
632: pa_debug.g_err_stage:= 'After create_line - 1';
633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
636: pa_debug.g_err_stage:= 'error status - '||l_status;
637: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
638: END IF;
639:

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

632: pa_debug.g_err_stage:= 'After create_line - 1';
633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
636: pa_debug.g_err_stage:= 'error status - '||l_status;
637: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
638: END IF;
639:
640: END IF;

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

633: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
634: pa_debug.g_err_stage:= 'error code - '||l_err_code;
635: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
636: pa_debug.g_err_stage:= 'error status - '||l_status;
637: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
638: END IF;
639:
640: END IF;
641: /* Added for fp */

Line 730: IF P_PA_DEBUG_MODE = 'Y' THEN

726:
727: END IF; /* x_err_code 1 */
728: /* Added for fp - end*/
729:
730: IF P_PA_DEBUG_MODE = 'Y' THEN
731: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

727: END IF; /* x_err_code 1 */
728: /* Added for fp - end*/
729:
730: IF P_PA_DEBUG_MODE = 'Y' THEN
731: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;

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

728: /* Added for fp - end*/
729:
730: IF P_PA_DEBUG_MODE = 'Y' THEN
731: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

729:
730: IF P_PA_DEBUG_MODE = 'Y' THEN
731: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: END IF;

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

730: IF P_PA_DEBUG_MODE = 'Y' THEN
731: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: END IF;
738:

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

731: pa_debug.g_err_stage:= 'After the Fin Plan Type check';
732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: END IF;
738:
739: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then

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

732: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
733: pa_debug.g_err_stage:= 'error code is - '||x_err_code;
734: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: END IF;
738:
739: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
740: IF l_plan_type_id is NULL THEN /* For bug 4198840*/

Line 742: IF P_PA_DEBUG_MODE = 'Y' THEN

738:
739: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
740: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
741: --dbms_output.put_line ('calling summerize ' );
742: IF P_PA_DEBUG_MODE = 'Y' THEN
743: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
744: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
745: END IF;
746:

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

739: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
740: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
741: --dbms_output.put_line ('calling summerize ' );
742: IF P_PA_DEBUG_MODE = 'Y' THEN
743: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
744: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
745: END IF;
746:
747: pa_budget_utils.summerize_project_totals (

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

740: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
741: --dbms_output.put_line ('calling summerize ' );
742: IF P_PA_DEBUG_MODE = 'Y' THEN
743: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
744: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
745: END IF;
746:
747: pa_budget_utils.summerize_project_totals (
748: x_budget_version_id => l_budget_version_id,

Line 753: IF P_PA_DEBUG_MODE = 'Y' THEN

749: x_err_code => l_err_code,
750: x_err_stage => l_err_stage,
751: x_err_stack => l_err_stack);
752:
753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
755: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
756: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
757: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

750: x_err_stage => l_err_stage,
751: x_err_stack => l_err_stack);
752:
753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
755: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
756: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
757: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
758: END IF;

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

751: x_err_stack => l_err_stack);
752:
753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
755: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
756: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
757: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
758: END IF;
759: x_err_code := l_err_code;

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

752:
753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
755: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
756: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
757: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
758: END IF;
759: x_err_code := l_err_code;
760: x_status := l_err_stage;

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

753: IF P_PA_DEBUG_MODE = 'Y' THEN
754: pa_debug.g_err_stage:= 'After summerize, error code - '||l_err_code;
755: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
756: pa_debug.g_err_stage:= 'After summerize, error stage - '||l_err_stage;
757: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
758: END IF;
759: x_err_code := l_err_code;
760: x_status := l_err_stage;
761: /*

Line 765: IF P_PA_DEBUG_MODE = 'Y' THEN

761: /*
762: ELSE
763: x_status := l_status;
764: */
765: IF P_PA_DEBUG_MODE = 'Y' THEN
766: pa_debug.g_err_stage:= 'Error status - '||l_status;
767: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
768: END IF;
769: --dbms_output.put_line ('err 3 - ' || x_err_code);

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

762: ELSE
763: x_status := l_status;
764: */
765: IF P_PA_DEBUG_MODE = 'Y' THEN
766: pa_debug.g_err_stage:= 'Error status - '||l_status;
767: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
768: END IF;
769: --dbms_output.put_line ('err 3 - ' || x_err_code);
770: --dbms_output.put_line ('stat 3 - ' || x_status);

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

763: x_status := l_status;
764: */
765: IF P_PA_DEBUG_MODE = 'Y' THEN
766: pa_debug.g_err_stage:= 'Error status - '||l_status;
767: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
768: END IF;
769: --dbms_output.put_line ('err 3 - ' || x_err_code);
770: --dbms_output.put_line ('stat 3 - ' || x_status);
771: END IF; --For bug 4198840

Line 777: IF P_PA_DEBUG_MODE = 'Y' THEN

773:
774:
775: IF x_err_code = 0 and l_plan_type_id IS NULL then
776: --dbms_output.put_line ('calling baseline ' );
777: IF P_PA_DEBUG_MODE = 'Y' THEN
778: pa_debug.g_err_stage:= 'Calling budget_core.baseline';
779: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
780: END IF;
781:

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

774:
775: IF x_err_code = 0 and l_plan_type_id IS NULL then
776: --dbms_output.put_line ('calling baseline ' );
777: IF P_PA_DEBUG_MODE = 'Y' THEN
778: pa_debug.g_err_stage:= 'Calling budget_core.baseline';
779: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
780: END IF;
781:
782: --Start Bug 9740299

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

775: IF x_err_code = 0 and l_plan_type_id IS NULL then
776: --dbms_output.put_line ('calling baseline ' );
777: IF P_PA_DEBUG_MODE = 'Y' THEN
778: pa_debug.g_err_stage:= 'Calling budget_core.baseline';
779: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
780: END IF;
781:
782: --Start Bug 9740299
783: select nvl(max(version_number), 0)

Line 807: IF P_PA_DEBUG_MODE = 'Y' THEN

803: x_err_stack => l_err_stack);
804:
805: x_err_code := l_err_code;
806: x_status := l_err_stage;
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
809: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
810: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
811: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

804:
805: x_err_code := l_err_code;
806: x_status := l_err_stage;
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
809: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
810: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
811: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
812: END IF;

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

805: x_err_code := l_err_code;
806: x_status := l_err_stage;
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
809: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
810: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
811: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
812: END IF;
813: /*

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

806: x_status := l_err_stage;
807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
809: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
810: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
811: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
812: END IF;
813: /*
814:

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

807: IF P_PA_DEBUG_MODE = 'Y' THEN
808: pa_debug.g_err_stage:= 'After baseline, error code - '||l_err_code;
809: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
810: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
811: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
812: END IF;
813: /*
814:
815: ELSE

Line 816: IF P_PA_DEBUG_MODE = 'Y' THEN

812: END IF;
813: /*
814:
815: ELSE
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
819: END IF;
820: x_status := l_err_stage;

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

813: /*
814:
815: ELSE
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
819: END IF;
820: x_status := l_err_stage;
821: */

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

814:
815: ELSE
816: IF P_PA_DEBUG_MODE = 'Y' THEN
817: pa_debug.g_err_stage:= 'error stage - '||l_err_stage;
818: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
819: END IF;
820: x_status := l_err_stage;
821: */
822: --dbms_output.put_line ('stat 4 - ' || x_status);

Line 826: IF P_PA_DEBUG_MODE = 'Y' THEN

822: --dbms_output.put_line ('stat 4 - ' || x_status);
823:
824: END IF;
825:
826: IF P_PA_DEBUG_MODE = 'Y' THEN
827: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
828: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
829: pa_debug.g_err_stage:= 'return status - '||l_return_status;
830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

823:
824: END IF;
825:
826: IF P_PA_DEBUG_MODE = 'Y' THEN
827: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
828: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
829: pa_debug.g_err_stage:= 'return status - '||l_return_status;
830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
831: END IF;

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

824: END IF;
825:
826: IF P_PA_DEBUG_MODE = 'Y' THEN
827: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
828: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
829: pa_debug.g_err_stage:= 'return status - '||l_return_status;
830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
831: END IF;
832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

825:
826: IF P_PA_DEBUG_MODE = 'Y' THEN
827: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
828: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
829: pa_debug.g_err_stage:= 'return status - '||l_return_status;
830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
831: END IF;
832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: rollback to temp_pt;

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

826: IF P_PA_DEBUG_MODE = 'Y' THEN
827: pa_debug.g_err_stage:= 'x_err_code - '||x_err_code;
828: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
829: pa_debug.g_err_stage:= 'return status - '||l_return_status;
830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
831: END IF;
832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: rollback to temp_pt;
834: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 834: IF P_PA_DEBUG_MODE = 'Y' THEN

830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
831: END IF;
832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: rollback to temp_pt;
834: IF P_PA_DEBUG_MODE = 'Y' THEN
835: pa_debug.g_err_stage:= 'Rolling back';
836: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
837: END IF;
838: --dbms_output.put_line ('stat 5 - ' || x_status);

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

831: END IF;
832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: rollback to temp_pt;
834: IF P_PA_DEBUG_MODE = 'Y' THEN
835: pa_debug.g_err_stage:= 'Rolling back';
836: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
837: END IF;
838: --dbms_output.put_line ('stat 5 - ' || x_status);
839: end if;

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

832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: rollback to temp_pt;
834: IF P_PA_DEBUG_MODE = 'Y' THEN
835: pa_debug.g_err_stage:= 'Rolling back';
836: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
837: END IF;
838: --dbms_output.put_line ('stat 5 - ' || x_status);
839: end if;
840: pa_debug.reset_err_stack;

Line 840: pa_debug.reset_err_stack;

836: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
837: END IF;
838: --dbms_output.put_line ('stat 5 - ' || x_status);
839: end if;
840: pa_debug.reset_err_stack;
841:
842: EXCEPTION
843: WHEN OTHERS THEN
844:

Line 845: IF P_PA_DEBUG_MODE = 'Y' THEN

841:
842: EXCEPTION
843: WHEN OTHERS THEN
844:
845: IF P_PA_DEBUG_MODE = 'Y' THEN
846: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';
847: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
848: END IF;
849: x_err_code := SQLCODE;

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

842: EXCEPTION
843: WHEN OTHERS THEN
844:
845: IF P_PA_DEBUG_MODE = 'Y' THEN
846: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';
847: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
848: END IF;
849: x_err_code := SQLCODE;
850: x_status := substr(SQLERRM,1,50);

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

843: WHEN OTHERS THEN
844:
845: IF P_PA_DEBUG_MODE = 'Y' THEN
846: pa_debug.g_err_stage:= 'In exception of create_budget_baseline';
847: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
848: END IF;
849: x_err_code := SQLCODE;
850: x_status := substr(SQLERRM,1,50);
851: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 851: IF P_PA_DEBUG_MODE = 'Y' THEN

847: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
848: END IF;
849: x_err_code := SQLCODE;
850: x_status := substr(SQLERRM,1,50);
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.g_err_stage:= 'error code - '||x_err_code;
853: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
854: pa_debug.g_err_stage:= 'status - '||x_status;
855: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

848: END IF;
849: x_err_code := SQLCODE;
850: x_status := substr(SQLERRM,1,50);
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.g_err_stage:= 'error code - '||x_err_code;
853: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
854: pa_debug.g_err_stage:= 'status - '||x_status;
855: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
856: END IF;

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

849: x_err_code := SQLCODE;
850: x_status := substr(SQLERRM,1,50);
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.g_err_stage:= 'error code - '||x_err_code;
853: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
854: pa_debug.g_err_stage:= 'status - '||x_status;
855: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
856: END IF;
857:

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

850: x_status := substr(SQLERRM,1,50);
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.g_err_stage:= 'error code - '||x_err_code;
853: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
854: pa_debug.g_err_stage:= 'status - '||x_status;
855: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
856: END IF;
857:
858: END create_budget_baseline;

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

851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.g_err_stage:= 'error code - '||x_err_code;
853: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
854: pa_debug.g_err_stage:= 'status - '||x_status;
855: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
856: END IF;
857:
858: END create_budget_baseline;
859: