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.AHL_PRD_WO_LOGIN_PVT dependencies on FND_LOG

Line 6: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2: /* $Header: AHLVLGNB.pls 120.8 2008/02/29 01:58:57 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_WO_Login_PVT';
5:
6: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9:
10: ------------------------------

Line 7: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_WO_Login_PVT';
5:
6: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9:
10: ------------------------------
11: -- Declare Local Procedures --

Line 8: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_WO_Login_PVT';
5:
6: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9:
10: ------------------------------
11: -- Declare Local Procedures --
12: ------------------------------

Line 125: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login.begin',

121: BEGIN
122:
123: -- log debug message.
124: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
125: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login.begin',
126: 'At the start of PLSQL procedure' );
127: END IF;
128:
129: -- Standard call to check for api compatibility

Line 149: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

145:
146:
147: -- Dump Input parameters.
148: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
149: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
150: 'p_api_version: ' || p_api_version );
151:
152: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
153: 'p_init_msg_list:' || p_init_msg_list );

Line 152: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

148: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
149: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
150: 'p_api_version: ' || p_api_version );
151:
152: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
153: 'p_init_msg_list:' || p_init_msg_list );
154:
155: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
156: 'p_commit:' || p_commit );

Line 155: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

151:
152: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
153: 'p_init_msg_list:' || p_init_msg_list );
154:
155: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
156: 'p_commit:' || p_commit );
157:
158: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
159: 'p_validation_level:' || p_validation_level);

Line 158: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

154:
155: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
156: 'p_commit:' || p_commit );
157:
158: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
159: 'p_validation_level:' || p_validation_level);
160:
161: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
162: 'p_module_type:' || p_module_type );

Line 161: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

157:
158: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
159: 'p_validation_level:' || p_validation_level);
160:
161: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
162: 'p_module_type:' || p_module_type );
163:
164: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
165: 'p_employee_num:' || p_employee_num);

Line 164: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

160:
161: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
162: 'p_module_type:' || p_module_type );
163:
164: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
165: 'p_employee_num:' || p_employee_num);
166:
167: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
168: 'p_employee_id:' || p_employee_id);

Line 167: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

163:
164: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
165: 'p_employee_num:' || p_employee_num);
166:
167: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
168: 'p_employee_id:' || p_employee_id);
169:
170: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
171: 'p_workorder_name:' || p_workorder_name);

Line 170: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

166:
167: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
168: 'p_employee_id:' || p_employee_id);
169:
170: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
171: 'p_workorder_name:' || p_workorder_name);
172:
173: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
174: 'p_workorder_id:' || p_workorder_id);

Line 173: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

169:
170: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
171: 'p_workorder_name:' || p_workorder_name);
172:
173: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
174: 'p_workorder_id:' || p_workorder_id);
175:
176: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
177: 'p_org_code:' || p_org_code);

Line 176: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

172:
173: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
174: 'p_workorder_id:' || p_workorder_id);
175:
176: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
177: 'p_org_code:' || p_org_code);
178:
179: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
180: 'p_operation_seq_num:' || p_operation_seq_num);

Line 179: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

175:
176: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
177: 'p_org_code:' || p_org_code);
178:
179: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
180: 'p_operation_seq_num:' || p_operation_seq_num);
181:
182: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
183: 'p_resource_seq_num:' || p_resource_seq_num);

Line 182: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

178:
179: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
180: 'p_operation_seq_num:' || p_operation_seq_num);
181:
182: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
183: 'p_resource_seq_num:' || p_resource_seq_num);
184:
185: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
186: 'p_resource_id:' || p_resource_id);

Line 185: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',

181:
182: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
183: 'p_resource_seq_num:' || p_resource_seq_num);
184:
185: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
186: 'p_resource_id:' || p_resource_id);
187: END IF;
188:
189: -- Check if login/logout enabled.

Line 210: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

206: l_resource_seq_num := p_resource_seq_num;
207: l_resource_id := p_resource_id;
208:
209: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
210: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
211: 'Before call to ConvertWO_Value_to_IDs' );
212: END IF;
213:
214: -- Convert Values to IDs.

Line 226: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

222: p_x_resource_id => l_resource_id,
223: x_return_status => x_return_status);
224:
225: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
226: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
227: 'After call to ConvertWO_Value_to_IDs: return status' || x_return_status );
228: END IF;
229:
230: -- Raise errors if exceptions occur

Line 238: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

234: RAISE FND_API.G_EXC_ERROR;
235: END IF;
236:
237: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
238: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
239: 'After call to ConvertWO_Value_to_IDs: return status' || x_return_status );
240: END IF;
241:
242:

Line 275: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

271: l_employee_id := p_employee_id;
272: END IF;
273:
274: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
275: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
276: 'Check Emp and Role:' || l_employee_id || ':' || l_user_role);
277: END IF;
278:
279: -- process based on input parameters.

Line 283: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

279: -- process based on input parameters.
280: IF (l_resource_id IS NOT NULL OR l_resource_seq_num IS NOT NULL) THEN
281:
282: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
283: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
284: 'Processing for Resource login');
285: END IF;
286: -- Process resource Login
287: Process_RES_Login (p_employee_id => l_employee_id,

Line 297: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

293: p_user_role => l_user_role,
294: x_return_status => x_return_status);
295:
296: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
297: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
298: 'After call to Process_RES_Login: return status' || x_return_status );
299:
300: END IF;
301:

Line 307: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

303:
304: -- Process for operation login.
305:
306: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
307: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
308: 'Processing for Operation login');
309: END IF;
310:
311: Process_OP_Login (p_employee_id => l_employee_id,

Line 319: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

315: p_user_role => l_user_role,
316: x_return_status => x_return_status);
317:
318: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
319: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
320: 'After call to Process_OP_Login: return status' || x_return_status );
321: END IF;
322:
323:

Line 328: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

324: ELSE
325: -- Process for workorder login.
326:
327: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
328: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
329: 'Processing for Workorder login');
330: END IF;
331:
332: Process_WO_Login (p_employee_id => l_employee_id,

Line 339: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',

335: p_user_role => l_user_role,
336: x_return_status => x_return_status);
337:
338: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
339: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Login',
340: 'After call to Process_WO_Login: return status' || x_return_status );
341: END IF;
342:
343:

Line 368: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.End',

364: );
365:
366: -- log debug message.
367: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
368: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.End',
369: 'Exiting Procedure' );
370: END IF;
371:
372: --

Line 579: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Start',

575: BEGIN
576:
577: -- log debug message.
578: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
579: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Start',
580: 'At the Start of procedure AHL_PRD_WO_LOGIN_PVT.Process_RES_Login');
581: END IF;
582:
583: -- Dump of input parameters.

Line 585: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

581: END IF;
582:
583: -- Dump of input parameters.
584: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
585: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
586: 'p_employee_id:' || p_employee_id);
587: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
588: 'p_workorder_id:' || p_workorder_id);
589: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

Line 587: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

583: -- Dump of input parameters.
584: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
585: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
586: 'p_employee_id:' || p_employee_id);
587: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
588: 'p_workorder_id:' || p_workorder_id);
589: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
590: 'p_operation_seq_num:' || p_operation_seq_num);
591: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

Line 589: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

585: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
586: 'p_employee_id:' || p_employee_id);
587: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
588: 'p_workorder_id:' || p_workorder_id);
589: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
590: 'p_operation_seq_num:' || p_operation_seq_num);
591: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
592: 'p_resource_seq_num:' || p_resource_seq_num);
593: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

Line 591: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

587: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
588: 'p_workorder_id:' || p_workorder_id);
589: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
590: 'p_operation_seq_num:' || p_operation_seq_num);
591: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
592: 'p_resource_seq_num:' || p_resource_seq_num);
593: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
594: 'p_resource_id:' || p_resource_id);
595: END IF;

Line 593: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',

589: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
590: 'p_operation_seq_num:' || p_operation_seq_num);
591: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
592: 'p_resource_seq_num:' || p_resource_seq_num);
593: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.Input_Dump',
594: 'p_resource_id:' || p_resource_id);
595: END IF;
596:
597: -- Initialize Procedure return status to success

Line 630: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

626:
627: END IF; -- p_operation_seq_num IS NOT NULL
628:
629: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
630: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
631: 'After locking rows');
632: END IF;
633:
634: -- Call procedure to check if login allowed or not.

Line 643: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

639: p_resource_id => p_resource_id,
640: p_fnd_function_name => p_user_role);
641:
642: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
643: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
644: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);
645: END IF;
646:
647: -- Error out based on login allowed flag.

Line 668: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

664: END IF;
665:
666:
667: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
668: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
669: 'Start login processing for Operation-Resource');
670: END IF;
671:
672: -- process for technician and transit tech roles.

Line 689: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

685: l_dept_id, l_resource_seq_num;
686: IF (c_qualified_req%FOUND) THEN
687:
688: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
689: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
690: 'Processing for..resource:operation:resource_seq:' || p_resource_id || ':' || p_operation_seq_num
691: || ':' || p_resource_seq_num);
692: END IF;
693:

Line 700: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

696: FETCH c_assignment_details INTO l_assignment_id, l_object_ver_num;
697: IF (c_assignment_details%NOTFOUND) THEN
698:
699: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
700: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
701: 'Assignment not found ..');
702: END IF;
703:
704: -- Create assignment record.

Line 728: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

724:
725: ELSE --c_assignment_details%NOTFOUND
726:
727: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
728: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
729: 'Assignment found ..');
730: END IF;
731:
732: END IF; -- c_assignment_details%NOTFOUND

Line 738: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

734:
735: ELSE -- c_qualified_req%FOUND
736:
737: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
738: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
739: 'Error - Resource is not found');
740: END IF;
741:
742: CLOSE c_qualified_req;

Line 757: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

753: -- Call Assignment Create API.
754: IF (l_resrc_assign_cre_tbl.COUNT > 0) THEN
755:
756: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
757: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
758: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
759: END IF;
760:
761: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

Line 773: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

769:
770:
771:
772: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
773: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
774: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);
775: END IF;
776:
777: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 788: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',

784:
785: -- END IF; -- techinician user role check.
786:
787: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
788: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login',
789: 'Inserting into ahl_work_login_times.');
790: END IF;
791:
792: -- insert login date and time.

Line 827: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.End',

823: );
824:
825: -- log debug message.
826: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
827: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_RES_Login.End',
828: 'At the End of procedure AHL_PRD_WO_LOGIN_PVT.Process_RES_Login');
829: END IF;
830:
831:

Line 940: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Start',

936: BEGIN
937:
938: -- log debug message.
939: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
940: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Start',
941: 'At the Start of procedure AHL_PRD_WO_LOGIN_PVT.Process_OP_Login');
942: END IF;
943:
944: -- Dump of input parameters.

Line 946: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',

942: END IF;
943:
944: -- Dump of input parameters.
945: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
946: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
947: 'p_employee_id:' || p_employee_id);
948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
949: 'p_workorder_id:' || p_workorder_id);
950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',

Line 948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',

944: -- Dump of input parameters.
945: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
946: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
947: 'p_employee_id:' || p_employee_id);
948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
949: 'p_workorder_id:' || p_workorder_id);
950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
951: 'p_operation_seq_num:' || p_operation_seq_num);
952: END IF;

Line 950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',

946: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
947: 'p_employee_id:' || p_employee_id);
948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
949: 'p_workorder_id:' || p_workorder_id);
950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.Input_Dump',
951: 'p_operation_seq_num:' || p_operation_seq_num);
952: END IF;
953:
954: -- Initialize Procedure return status to success

Line 992: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

988: RAISE FND_API.G_EXC_ERROR;
989: END IF; -- p_operation_seq_num IS NOT NULL
990:
991: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
992: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
993: 'After locking rows');
994: END IF;
995:
996: -- Call procedure to check if login allowed or not.

Line 1003: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_login',

999: p_operation_seq_num => p_operation_seq_num,
1000: p_fnd_function_name => p_user_role);
1001:
1002: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1003: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_login',
1004: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);
1005: END IF;
1006:
1007: -- Error out based on login allowed flag.

Line 1024: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

1020:
1021: -- initialize login
1022: -- Create assignments and login records based on login type.
1023: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1024: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1025: 'Processing for Operation:' || p_operation_seq_num);
1026: END IF;
1027:
1028: -- Loop through all resources for an operation.

Line 1038: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

1034: FETCH c_assignment_details INTO l_assignment_id, l_object_ver_num;
1035: IF (c_assignment_details%NOTFOUND) THEN
1036:
1037: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1038: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1039: 'Assignment found ..');
1040: END IF;
1041: -- Create assignment record.
1042: l_assignment_rec := l_initial_assign_rec;

Line 1067: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

1063:
1064: ELSE -- (c_assignment_details%NOTFOUND)
1065:
1066: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1067: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1068: 'Assignment found..');
1069: END IF;
1070:
1071: END IF; -- c_assignment_details%NOTFOUND

Line 1079: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

1075: -- Call Assignment Create API.
1076: IF (l_resrc_assign_cre_tbl.COUNT > 0) THEN
1077:
1078: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1079: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1080: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
1081: END IF;
1082:
1083: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

Line 1095: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

1091:
1092:
1093:
1094: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1095: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1096: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);
1097: END IF;
1098:
1099: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1111: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',

1107: -- END IF; -- p_user_role.
1108:
1109: -- insert login date and time.
1110: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1111: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login',
1112: 'Before inserting into ahl_work_login_times');
1113: END IF;
1114: insert into ahl_work_login_times(
1115: work_login_time_id,

Line 1147: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.End',

1143: fnd_global.login_id);
1144:
1145: -- log debug message.
1146: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1147: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_OP_Login.End',
1148: 'At the End of procedure AHL_PRD_WO_LOGIN_PVT.Process_OP_Login');
1149: END IF;
1150:
1151:

Line 1255: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Start',

1251: BEGIN
1252:
1253: -- log debug message.
1254: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1255: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Start',
1256: 'At the Start of procedure AHL_PRD_WO_LOGIN_PVT.Process_WO_Login');
1257: END IF;
1258:
1259: -- Dump of input parameters.

Line 1261: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Input_Dump',

1257: END IF;
1258:
1259: -- Dump of input parameters.
1260: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1261: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Input_Dump',
1262: 'p_employee_id:' || p_employee_id);
1263: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Input_Dump',
1264: 'p_workorder_id:' || p_workorder_id);
1265: END IF;

Line 1263: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Input_Dump',

1259: -- Dump of input parameters.
1260: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1261: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Input_Dump',
1262: 'p_employee_id:' || p_employee_id);
1263: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.Input_Dump',
1264: 'p_workorder_id:' || p_workorder_id);
1265: END IF;
1266:
1267: -- Initialize Procedure return status to success

Line 1285: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1281: FETCH c_lock_wo_all_ops INTO l_oper_status;
1282: CLOSE c_lock_wo_all_ops;
1283:
1284: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1285: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1286: 'After locking rows');
1287: END IF;
1288:
1289: -- Call procedure to check if login allowed or not.

Line 1295: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1291: p_workorder_id => p_workorder_id,
1292: p_fnd_function_name => p_user_role);
1293:
1294: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1295: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1296: 'After call to Is_Login_Allowed procedure:l_login_allowed_flag:' || l_login_allowed_flag);
1297: END IF;
1298:
1299: -- Error out based on login allowed flag.

Line 1315: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1311: l_initial_assign_rec.login_date := sysdate;
1312:
1313: -- Create assignments and login records.
1314: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1315: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1316: 'Processing for workorderID:' || p_workorder_id);
1317: END IF;
1318:
1319: -- login into workorder.

Line 1328: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1324: FETCH c_assignment_details INTO l_assignment_id, l_object_ver_num;
1325: IF (c_assignment_details%NOTFOUND) THEN
1326:
1327: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1328: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1329: 'Assignment not found ..');
1330: END IF;
1331: -- Create assignment record.
1332: l_assignment_rec := l_initial_assign_rec;

Line 1357: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1353:
1354: ELSE
1355:
1356: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1357: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1358: 'Assignment found ..');
1359: END IF;
1360:
1361: END IF; -- c_assignment_details%NOTFOUND

Line 1370: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1366: -- Call Assignment Create API.
1367: IF (l_resrc_assign_cre_tbl.COUNT > 0) THEN
1368:
1369: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1370: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1371: 'Before calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:tbl count:' || l_resrc_assign_cre_tbl.count);
1372: END IF;
1373:
1374: AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign (

Line 1386: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1382:
1383:
1384:
1385: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1386: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1387: 'After calling Create AHL_PP_RESRC_ASSIGN_PVT.Process_Resrc_Assign:x_return_status:' || x_return_status);
1388: END IF;
1389:
1390: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1401: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',

1397:
1398: -- END IF; -- p_user_role.
1399:
1400: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1401: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login',
1402: 'Before inserting into ahl_work_login_times');
1403: END IF;
1404:
1405: -- insert login date and time.

Line 1439: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.End',

1435: fnd_global.login_id);
1436:
1437: -- log debug message.
1438: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1439: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Login.End',
1440: 'At the End of procedure AHL_PRD_WO_LOGIN_PVT.Process_WO_Login');
1441: END IF;
1442:
1443:

Line 1496: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout.begin',

1492: BEGIN
1493:
1494: -- log debug message.
1495: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1496: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout.begin',
1497: 'At the start of PLSQL procedure' );
1498: END IF;
1499:
1500:

Line 1521: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1517:
1518:
1519: -- Dump Input parameters.
1520: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1521: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1522: 'p_api_version: ' || p_api_version );
1523:
1524: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1525: 'p_init_msg_list:' || p_init_msg_list );

Line 1524: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1520: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1521: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1522: 'p_api_version: ' || p_api_version );
1523:
1524: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1525: 'p_init_msg_list:' || p_init_msg_list );
1526:
1527: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1528: 'p_commit:' || p_commit );

Line 1527: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1523:
1524: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1525: 'p_init_msg_list:' || p_init_msg_list );
1526:
1527: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1528: 'p_commit:' || p_commit );
1529:
1530: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1531: 'p_validation_level:' || p_validation_level);

Line 1530: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1526:
1527: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1528: 'p_commit:' || p_commit );
1529:
1530: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1531: 'p_validation_level:' || p_validation_level);
1532:
1533: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1534: 'p_module_type:' || p_module_type );

Line 1533: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1529:
1530: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1531: 'p_validation_level:' || p_validation_level);
1532:
1533: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1534: 'p_module_type:' || p_module_type );
1535:
1536: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1537: 'p_employee_num:' || p_employee_num);

Line 1536: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1532:
1533: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1534: 'p_module_type:' || p_module_type );
1535:
1536: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1537: 'p_employee_num:' || p_employee_num);
1538:
1539: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1540: 'p_employee_id:' || p_employee_id);

Line 1539: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1535:
1536: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1537: 'p_employee_num:' || p_employee_num);
1538:
1539: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1540: 'p_employee_id:' || p_employee_id);
1541:
1542: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1543: 'p_workorder_name:' || p_workorder_name);

Line 1542: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1538:
1539: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1540: 'p_employee_id:' || p_employee_id);
1541:
1542: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1543: 'p_workorder_name:' || p_workorder_name);
1544:
1545: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1546: 'p_workorder_id:' || p_workorder_id);

Line 1545: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1541:
1542: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1543: 'p_workorder_name:' || p_workorder_name);
1544:
1545: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1546: 'p_workorder_id:' || p_workorder_id);
1547:
1548: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1549: 'p_org_code:' || p_org_code);

Line 1548: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1544:
1545: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1546: 'p_workorder_id:' || p_workorder_id);
1547:
1548: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1549: 'p_org_code:' || p_org_code);
1550:
1551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1552: 'p_operation_seq_num:' || p_operation_seq_num);

Line 1551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1547:
1548: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1549: 'p_org_code:' || p_org_code);
1550:
1551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1552: 'p_operation_seq_num:' || p_operation_seq_num);
1553:
1554: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1555: 'p_resource_seq_num:' || p_resource_seq_num);

Line 1554: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1550:
1551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1552: 'p_operation_seq_num:' || p_operation_seq_num);
1553:
1554: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1555: 'p_resource_seq_num:' || p_resource_seq_num);
1556:
1557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1558: 'p_resource_id:' || p_resource_id);

Line 1557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',

1553:
1554: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1555: 'p_resource_seq_num:' || p_resource_seq_num);
1556:
1557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1558: 'p_resource_id:' || p_resource_id);
1559: END IF;
1560:
1561:

Line 1585: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

1581: l_resource_seq_num := p_resource_seq_num;
1582: l_resource_id := p_resource_id;
1583:
1584: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1585: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
1586: 'Before call to ConvertWO_Value_to_IDs' );
1587: END IF;
1588:
1589: -- Convert Values to IDs.

Line 1601: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

1597: p_x_resource_id => l_resource_id,
1598: x_return_status => x_return_status);
1599:
1600: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1601: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
1602: 'After call to ConvertWO_Value_to_IDs: return status' || x_return_status );
1603: END IF;
1604:
1605: -- Raise error if exception occurs

Line 1632: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout',

1628: END IF;
1629:
1630: -- debug checkpoint.
1631: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1632: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout',
1633: 'Check Emp and Role:' || l_employee_id || ':' || l_user_role);
1634: END IF;
1635:
1636: -- Process WO Logout

Line 1646: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

1642: p_user_role => l_user_role,
1643: x_return_status => x_return_status);
1644:
1645: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1646: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
1647: 'After call to Process_WO_Logout: return status' || x_return_status );
1648: END IF;
1649:
1650:

Line 1672: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout.End',

1668: );
1669:
1670: -- log debug message.
1671: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1672: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout.End',
1673: 'Exiting Procedure' );
1674: END IF;
1675:
1676: --

Line 1942: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Start',

1938: BEGIN
1939:
1940: -- log debug message.
1941: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
1942: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Start',
1943: 'At the Start of procedure AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout');
1944: END IF;
1945:
1946: -- Dump of input parameters.

Line 1948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

1944: END IF;
1945:
1946: -- Dump of input parameters.
1947: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1949: 'p_employee_id:' || p_employee_id);
1950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1951: 'p_workorder_id:' || p_workorder_id);
1952: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

Line 1950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

1946: -- Dump of input parameters.
1947: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1949: 'p_employee_id:' || p_employee_id);
1950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1951: 'p_workorder_id:' || p_workorder_id);
1952: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1953: 'p_operation_seq_num:' || p_operation_seq_num);
1954: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

Line 1952: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

1948: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1949: 'p_employee_id:' || p_employee_id);
1950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1951: 'p_workorder_id:' || p_workorder_id);
1952: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1953: 'p_operation_seq_num:' || p_operation_seq_num);
1954: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1955: 'p_resource_seq_num:' || p_resource_seq_num);
1956: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

Line 1954: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

1950: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1951: 'p_workorder_id:' || p_workorder_id);
1952: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1953: 'p_operation_seq_num:' || p_operation_seq_num);
1954: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1955: 'p_resource_seq_num:' || p_resource_seq_num);
1956: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1957: 'p_resource_id:' || p_resource_id);
1958: END IF;

Line 1956: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',

1952: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1953: 'p_operation_seq_num:' || p_operation_seq_num);
1954: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1955: 'p_resource_seq_num:' || p_resource_seq_num);
1956: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_WO_Logout.Input_Dump',
1957: 'p_resource_id:' || p_resource_id);
1958: END IF;
1959:
1960: -- Initialize Procedure return status to success

Line 1998: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996:
1997: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1998: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
1999: 'After check for employee login');
2000: END IF;
2001:
2002: -- For 'R' and 'O' logins, operation_seq_num is mandatory.

Line 2015: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2011: RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013:
2014: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2015: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2016: 'After check for operation login');
2017: END IF;
2018:
2019: -- For 'R' login, resource is mandatory.

Line 2053: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2049: END IF; -- p_resource_id <> ..
2050: END IF; -- l_login_level = 'R' ..
2051:
2052: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2053: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2054: 'After check for resource login');
2055: END IF;
2056:
2057: -- Check Unit locked.

Line 2071: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2067: RAISE FND_API.G_EXC_ERROR;
2068: END IF;
2069:
2070: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2071: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2072: 'After Unit locked check');
2073: END IF;
2074:
2075: -- Process for posting resource txns.

Line 2086: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2082: IF (l_login_level = 'R') THEN
2083:
2084: -- debug check point.
2085: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2086: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2087: 'processing resource txns for RES login:Emp:WE:OP:RES' || p_employee_id || ':'|| l_wip_entity_id || ':' || l_operation_seq_num || ':' || l_resource_seq_num);
2088: END IF;
2089:
2090: -- Commented out user_role condn to fix bug 5015149.

Line 2141: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2137: IF (l_login_level = 'O') THEN
2138:
2139: -- debug check point.
2140: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2141: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2142: 'processing resource txns for OP login:Emp:WE:OP:' || p_employee_id || ':'|| l_wip_entity_id || ':' || l_operation_seq_num);
2143: END IF;
2144:
2145: -- Commented out user_role condn to fix bug 5015149.

Line 2195: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2191: IF (l_login_level = 'W') THEN
2192:
2193: -- debug check point.
2194: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2195: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2196: 'processing resource txns for WO login:Emp:WE:' || p_employee_id || ':'|| l_wip_entity_id );
2197: END IF;
2198:
2199: -- Commented out user_role condn to fix bug 5015149.

Line 2246: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2242: END IF; -- l_login_level = 'W'
2243:
2244: -- debug check point.
2245: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2246: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2247: 'Count on resource txns table:' || l_prd_res_txn_tbl.count);
2248: END IF;
2249:
2250: -- Call resource txns api.

Line 2257: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2253: l_qty := ROUND(((sysdate - l_login_date) * 24) / l_prd_res_txn_tbl.COUNT, 3);
2254:
2255: -- debug check point.
2256: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2257: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2258: 'Hours per resource:' || l_qty);
2259: END IF;
2260:
2261: FOR i IN l_prd_res_txn_tbl.FIRST..l_prd_res_txn_tbl.LAST LOOP

Line 2266: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2262: l_prd_res_txn_tbl(i).qty := l_qty;
2263:
2264: -- debug check point.
2265: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2266: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2267: 'Hours per resource:' || l_qty);
2268: END IF;
2269:
2270: END LOOP;

Line 2282: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',

2278: p_x_prd_resrc_txn_tbl => l_prd_res_txn_tbl);
2279:
2280: -- debug check point.
2281: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2282: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2283: 'After call to resource txns: return status:' || l_return_status);
2284: END IF;
2285:
2286: -- Raise errors if exceptions occur

Line 2328: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.Start',

2324: BEGIN
2325:
2326: -- log debug message.
2327: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2328: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.Start',
2329: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Get_User_Role');
2330: END IF;
2331:
2332: IF (FND_FUNCTION.TEST(AHL_PRD_UTIL_PKG.G_TECH_MYWO)) THEN

Line 2345: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.End',

2341: END IF;
2342:
2343: -- log debug message.
2344: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2345: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.End',
2346: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.Get_User_Role');
2347: END IF;
2348:
2349: RETURN l_user_role;

Line 2499: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Start',

2495: BEGIN
2496:
2497: -- log debug message.
2498: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2499: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Start',
2500: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login');
2501: END IF;
2502:
2503: -- Dump Input parameters.

Line 2505: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Dump',

2501: END IF;
2502:
2503: -- Dump Input parameters.
2504: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2505: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Dump',
2506: 'p_employee_id: ' || p_employee_id );
2507:
2508: END IF;
2509:

Line 2551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

2547: CLOSE get_emp_name;
2548:
2549: -- Dump output parameters.
2550: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2552: 'x_workorder_id:' || x_workorder_id);
2553: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2554: 'x_workorder_number:' || x_workorder_number);
2555: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

Line 2553: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

2549: -- Dump output parameters.
2550: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2552: 'x_workorder_id:' || x_workorder_id);
2553: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2554: 'x_workorder_number:' || x_workorder_number);
2555: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2556: 'x_operation_seq_num:' || x_operation_seq_num);
2557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

Line 2555: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

2551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2552: 'x_workorder_id:' || x_workorder_id);
2553: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2554: 'x_workorder_number:' || x_workorder_number);
2555: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2556: 'x_operation_seq_num:' || x_operation_seq_num);
2557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2558: 'x_resource_id:' || x_resource_id);
2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

Line 2557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

2553: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2554: 'x_workorder_number:' || x_workorder_number);
2555: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2556: 'x_operation_seq_num:' || x_operation_seq_num);
2557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2558: 'x_resource_id:' || x_resource_id);
2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2560: 'x_resource_seq_num:' || x_resource_seq_num);
2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

Line 2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

2555: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2556: 'x_operation_seq_num:' || x_operation_seq_num);
2557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2558: 'x_resource_id:' || x_resource_id);
2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2560: 'x_resource_seq_num:' || x_resource_seq_num);
2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2562: 'x_employee_name:' || x_employee_name);
2563: END IF;

Line 2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

2557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2558: 'x_resource_id:' || x_resource_id);
2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2560: 'x_resource_seq_num:' || x_resource_seq_num);
2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2562: 'x_employee_name:' || x_employee_name);
2563: END IF;
2564:
2565: -- log debug message.

Line 2567: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.End',

2563: END IF;
2564:
2565: -- log debug message.
2566: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2567: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.End',
2568: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login');
2569: END IF;
2570:
2571: EXCEPTION

Line 2876: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Start',

2872: BEGIN
2873:
2874: -- log debug message.
2875: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2876: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Start',
2877: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed');
2878: END IF;
2879:
2880: -- Dump Input parameters.

Line 2882: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

2878: END IF;
2879:
2880: -- Dump Input parameters.
2881: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2882: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2883: 'p_employee_id:' || p_employee_id);
2884: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2885: 'p_workorder_id:' || p_workorder_id);
2886: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

Line 2884: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

2880: -- Dump Input parameters.
2881: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2882: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2883: 'p_employee_id:' || p_employee_id);
2884: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2885: 'p_workorder_id:' || p_workorder_id);
2886: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2887: 'p_operation_seq_num:' || p_operation_seq_num);
2888: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

Line 2886: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

2882: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2883: 'p_employee_id:' || p_employee_id);
2884: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2885: 'p_workorder_id:' || p_workorder_id);
2886: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2887: 'p_operation_seq_num:' || p_operation_seq_num);
2888: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2889: 'p_resource_seq_num:' || p_resource_seq_num);
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

Line 2888: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

2884: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2885: 'p_workorder_id:' || p_workorder_id);
2886: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2887: 'p_operation_seq_num:' || p_operation_seq_num);
2888: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2889: 'p_resource_seq_num:' || p_resource_seq_num);
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_resource_id:' || p_resource_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

Line 2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

2886: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2887: 'p_operation_seq_num:' || p_operation_seq_num);
2888: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2889: 'p_resource_seq_num:' || p_resource_seq_num);
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_resource_id:' || p_resource_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_fnd_function_name:' || p_fnd_function_name);
2894:

Line 2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

2888: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2889: 'p_resource_seq_num:' || p_resource_seq_num);
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_resource_id:' || p_resource_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_fnd_function_name:' || p_fnd_function_name);
2894:
2895: END IF;
2896:

Line 2907: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

2903: END IF;
2904:
2905: -- Debug Checkpoint.
2906: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2907: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2908: 'After Login enabled check');
2909: END IF;
2910:
2911: -- Check required parameters.

Line 2920: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

2916: END IF;
2917:
2918: -- Debug Checkpoint.
2919: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2920: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2921: 'After required parameters check');
2922: END IF;
2923:
2924: -- Validate Workorder.

Line 2945: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

2941: END IF;
2942:
2943: -- Debug Checkpoint.
2944: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2945: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2946: 'After validate workorder');
2947: END IF;
2948:
2949: -- Default employee if input is null.

Line 2968: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

2964: END IF;
2965:
2966: -- Debug Checkpoint.
2967: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2968: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2969: 'After validating workorder and employee');
2970: END IF;
2971:
2972: -- Check if user already logged in.

Line 2998: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

2994: END IF;
2995:
2996: -- Debug Checkpoint.
2997: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2998: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2999: 'After login check successful');
3000: END IF;
3001:
3002: -- Check Unit locked.

Line 3029: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

3025: END IF;
3026:
3027: -- Debug Checkpoint.
3028: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3029: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3030: 'After unit lock check, user role check.. starting qualification checks for function:' ||
3031: l_fnd_function_name);
3032: END IF;
3033:

Line 3039: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

3035: IF (p_operation_seq_num IS NULL) THEN
3036:
3037: -- Debug Checkpoint.
3038: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3039: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3040: 'Workorder Login validations');
3041: END IF;
3042:
3043: -- validate if any operation is complete.

Line 3110: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

3106: IF (p_operation_seq_num IS NOT NULL) THEN
3107:
3108: -- Debug Checkpoint.
3109: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3110: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3111: 'Starting Workorder-Operation status validations');
3112: END IF;
3113:
3114: -- Validate operation seq num.

Line 3136: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

3132: -- Login into operation only.
3133:
3134: -- Debug Checkpoint.
3135: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3136: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3137: 'Workorder-Operation Login qualification validations');
3138: END IF;
3139:
3140:

Line 3180: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

3176: ELSE -- login into operation + resource.
3177:
3178: -- Debug Checkpoint.
3179: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3180: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3181: 'Starting Workorder-Operation-Resource validations');
3182: END IF;
3183:
3184: -- Get resource ID if resource seq num is input and resource_id is NULL.

Line 3240: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',

3236: END IF; -- operation_seq_num is not null.
3237:
3238: -- Debug Checkpoint.
3239: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3240: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3241: 'Successfully completed all qualification validations ...');
3242: END IF;
3243:
3244: -- log debug message.

Line 3246: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.End',

3242: END IF;
3243:
3244: -- log debug message.
3245: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3246: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.End',
3247: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed');
3248: END IF;
3249:
3250: -- Set login allowed flag.

Line 3288: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_wo_login_info.Start',

3284:
3285:
3286: -- log debug message.
3287: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3288: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_wo_login_info.Start',
3289: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.get_wo_login_info');
3290: END IF;
3291:
3292: IF p_x_wos.COUNT > 0 THEN

Line 3305: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_wo_login_info.End',

3301: END IF;
3302:
3303: -- log debug message.
3304: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3305: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_wo_login_info.End',
3306: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.get_wo_login_info');
3307: END IF;
3308:
3309: END get_wo_login_info;

Line 3324: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info.Start',

3320: BEGIN
3321:
3322: -- log debug message.
3323: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3324: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info.Start',
3325: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info');
3326: END IF;
3327:
3328: IF p_x_op_res.COUNT > 0 AND p_workorder_id IS NOT NULL

Line 3344: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info.End',

3340: END IF;
3341:
3342: -- log debug message.
3343: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3344: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info.End',
3345: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info');
3346: END IF;
3347:
3348: END get_op_res_login_info;