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.11.12020000.2 2012/12/10 13:45:51 shnatu 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: --Kasridha: Added for Component Maintenance Planning

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: --Kasridha: Added for Component Maintenance Planning
11: G_CMP_TECH_MYWO CONSTANT VARCHAR2(30) := 'AHL_CMP_TECH_MYWO';

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: --Kasridha: Added for Component Maintenance Planning
11: G_CMP_TECH_MYWO CONSTANT VARCHAR2(30) := 'AHL_CMP_TECH_MYWO';
12:

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

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

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

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

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

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

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_init_msg_list:' || p_init_msg_list );
157:
158: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
159: 'p_commit:' || p_commit );
160:
161: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
162: 'p_validation_level:' || p_validation_level);

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_commit:' || p_commit );
160:
161: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
162: 'p_validation_level:' || p_validation_level);
163:
164: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
165: 'p_module_type:' || p_module_type );

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_validation_level:' || p_validation_level);
163:
164: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
165: 'p_module_type:' || p_module_type );
166:
167: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
168: 'p_employee_num:' || p_employee_num);

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_module_type:' || p_module_type );
166:
167: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
168: 'p_employee_num:' || p_employee_num);
169:
170: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
171: 'p_employee_id:' || p_employee_id);

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_num:' || p_employee_num);
169:
170: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
171: 'p_employee_id:' || p_employee_id);
172:
173: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
174: 'p_workorder_name:' || p_workorder_name);

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_employee_id:' || p_employee_id);
172:
173: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
174: 'p_workorder_name:' || p_workorder_name);
175:
176: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
177: 'p_workorder_id:' || p_workorder_id);

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_name:' || p_workorder_name);
175:
176: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
177: 'p_workorder_id:' || p_workorder_id);
178:
179: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
180: 'p_org_code:' || p_org_code);

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_workorder_id:' || p_workorder_id);
178:
179: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
180: 'p_org_code:' || p_org_code);
181:
182: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
183: 'p_operation_seq_num:' || p_operation_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_org_code:' || p_org_code);
181:
182: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
183: 'p_operation_seq_num:' || p_operation_seq_num);
184:
185: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
186: 'p_resource_seq_num:' || p_resource_seq_num);

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_operation_seq_num:' || p_operation_seq_num);
184:
185: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
186: 'p_resource_seq_num:' || p_resource_seq_num);
187:
188: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Login.Dump',
189: 'p_resource_id:' || p_resource_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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_init_msg_list:' || p_init_msg_list );
1529:
1530: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1531: 'p_commit:' || p_commit );
1532:
1533: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1534: 'p_validation_level:' || p_validation_level);

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_commit:' || p_commit );
1532:
1533: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1534: 'p_validation_level:' || p_validation_level);
1535:
1536: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1537: 'p_module_type:' || p_module_type );

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_validation_level:' || p_validation_level);
1535:
1536: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1537: 'p_module_type:' || p_module_type );
1538:
1539: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1540: 'p_employee_num:' || p_employee_num);

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_module_type:' || p_module_type );
1538:
1539: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1540: 'p_employee_num:' || p_employee_num);
1541:
1542: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1543: 'p_employee_id:' || p_employee_id);

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_num:' || p_employee_num);
1541:
1542: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1543: 'p_employee_id:' || p_employee_id);
1544:
1545: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1546: 'p_workorder_name:' || p_workorder_name);

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_employee_id:' || p_employee_id);
1544:
1545: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1546: 'p_workorder_name:' || p_workorder_name);
1547:
1548: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1549: 'p_workorder_id:' || p_workorder_id);

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_name:' || p_workorder_name);
1547:
1548: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1549: 'p_workorder_id:' || p_workorder_id);
1550:
1551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1552: 'p_org_code:' || p_org_code);

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_workorder_id:' || p_workorder_id);
1550:
1551: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1552: 'p_org_code:' || p_org_code);
1553:
1554: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1555: 'p_operation_seq_num:' || p_operation_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_org_code:' || p_org_code);
1553:
1554: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1555: 'p_operation_seq_num:' || p_operation_seq_num);
1556:
1557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1558: 'p_resource_seq_num:' || p_resource_seq_num);

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_operation_seq_num:' || p_operation_seq_num);
1556:
1557: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1558: 'p_resource_seq_num:' || p_resource_seq_num);
1559:
1560: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Process_Workorder_Logout.Dump',
1561: 'p_resource_id:' || p_resource_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2055: END IF; -- p_resource_id <> ..
2056: END IF; -- l_login_level = 'R' ..
2057:
2058: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2059: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2060: 'After check for resource login');
2061: END IF;
2062:
2063: -- Check Unit locked.

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

2073: RAISE FND_API.G_EXC_ERROR;
2074: END IF;
2075:
2076: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2077: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2078: 'After Unit locked check');
2079: END IF;
2080:
2081: -- Process for posting resource txns.

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

2088: IF (l_login_level = 'R') THEN
2089:
2090: -- debug check point.
2091: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2092: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2093: '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);
2094: END IF;
2095:
2096: -- Commented out user_role condn to fix bug 5015149.

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

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

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

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

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

2248: END IF; -- l_login_level = 'W'
2249:
2250: -- debug check point.
2251: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2252: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2253: 'Count on resource txns table:' || l_prd_res_txn_tbl.count);
2254: END IF;
2255:
2256: -- Call resource txns api.

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

2259: l_qty := ROUND(((sysdate - l_login_date) * 24) / l_prd_res_txn_tbl.COUNT, 3);
2260:
2261: -- debug check point.
2262: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2263: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2264: 'Hours per resource:' || l_qty);
2265: END IF;
2266:
2267: FOR i IN l_prd_res_txn_tbl.FIRST..l_prd_res_txn_tbl.LAST LOOP

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

2268: l_prd_res_txn_tbl(i).qty := l_qty;
2269:
2270: -- debug check point.
2271: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2272: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2273: 'Hours per resource:' || l_qty);
2274: END IF;
2275:
2276: END LOOP;

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

2284: p_x_prd_resrc_txn_tbl => l_prd_res_txn_tbl);
2285:
2286: -- debug check point.
2287: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2288: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Workorder_Logout',
2289: 'After call to resource txns: return status:' || l_return_status);
2290: END IF;
2291:
2292: -- Raise errors if exceptions occur

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

2330: BEGIN
2331:
2332: -- log debug message.
2333: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2334: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.Start',
2335: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Get_User_Role');
2336: END IF;
2337: --Kasridha: Added for Component Maintenance Planning
2338: -- Treat component Technician role similar to technician role

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

2349: END IF;
2350:
2351: -- log debug message.
2352: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2353: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_User_Role.End',
2354: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.Get_User_Role');
2355: END IF;
2356:
2357: RETURN l_user_role;

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

2503: BEGIN
2504:
2505: -- log debug message.
2506: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2507: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Start',
2508: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login');
2509: END IF;
2510:
2511: -- Dump Input parameters.

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

2509: END IF;
2510:
2511: -- Dump Input parameters.
2512: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2513: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Dump',
2514: 'p_employee_id: ' || p_employee_id );
2515:
2516: END IF;
2517:

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

2555: CLOSE get_emp_name;
2556:
2557: -- Dump output parameters.
2558: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2560: 'x_workorder_id:' || x_workorder_id);
2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2562: 'x_workorder_number:' || x_workorder_number);
2563: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

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

2557: -- Dump output parameters.
2558: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2560: 'x_workorder_id:' || x_workorder_id);
2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2562: 'x_workorder_number:' || x_workorder_number);
2563: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2564: 'x_operation_seq_num:' || x_operation_seq_num);
2565: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

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

2559: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2560: 'x_workorder_id:' || x_workorder_id);
2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2562: 'x_workorder_number:' || x_workorder_number);
2563: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2564: 'x_operation_seq_num:' || x_operation_seq_num);
2565: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2566: 'x_resource_id:' || x_resource_id);
2567: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

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

2561: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2562: 'x_workorder_number:' || x_workorder_number);
2563: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2564: 'x_operation_seq_num:' || x_operation_seq_num);
2565: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2566: 'x_resource_id:' || x_resource_id);
2567: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2568: 'x_resource_seq_num:' || x_resource_seq_num);
2569: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',

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

2563: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2564: 'x_operation_seq_num:' || x_operation_seq_num);
2565: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2566: 'x_resource_id:' || x_resource_id);
2567: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2568: 'x_resource_seq_num:' || x_resource_seq_num);
2569: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2570: 'x_employee_name:' || x_employee_name);
2571: END IF;

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

2565: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2566: 'x_resource_id:' || x_resource_id);
2567: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2568: 'x_resource_seq_num:' || x_resource_seq_num);
2569: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.Output_Dump',
2570: 'x_employee_name:' || x_employee_name);
2571: END IF;
2572:
2573: -- log debug message.

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

2571: END IF;
2572:
2573: -- log debug message.
2574: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2575: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login.End',
2576: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.Get_Current_Emp_Login');
2577: END IF;
2578:
2579: EXCEPTION

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

2880: BEGIN
2881:
2882: -- log debug message.
2883: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
2884: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Start',
2885: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed');
2886: END IF;
2887:
2888: -- Dump Input parameters.

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

2886: END IF;
2887:
2888: -- Dump Input parameters.
2889: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_employee_id:' || p_employee_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_workorder_id:' || p_workorder_id);
2894: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

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

2888: -- Dump Input parameters.
2889: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_employee_id:' || p_employee_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_workorder_id:' || p_workorder_id);
2894: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2895: 'p_operation_seq_num:' || p_operation_seq_num);
2896: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

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

2890: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2891: 'p_employee_id:' || p_employee_id);
2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_workorder_id:' || p_workorder_id);
2894: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2895: 'p_operation_seq_num:' || p_operation_seq_num);
2896: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2897: 'p_resource_seq_num:' || p_resource_seq_num);
2898: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

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

2892: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2893: 'p_workorder_id:' || p_workorder_id);
2894: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2895: 'p_operation_seq_num:' || p_operation_seq_num);
2896: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2897: 'p_resource_seq_num:' || p_resource_seq_num);
2898: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2899: 'p_resource_id:' || p_resource_id);
2900: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',

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

2894: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2895: 'p_operation_seq_num:' || p_operation_seq_num);
2896: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2897: 'p_resource_seq_num:' || p_resource_seq_num);
2898: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2899: 'p_resource_id:' || p_resource_id);
2900: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2901: 'p_fnd_function_name:' || p_fnd_function_name);
2902:

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

2896: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2897: 'p_resource_seq_num:' || p_resource_seq_num);
2898: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2899: 'p_resource_id:' || p_resource_id);
2900: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.Input_Dump',
2901: 'p_fnd_function_name:' || p_fnd_function_name);
2902:
2903: END IF;
2904:

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

2911: END IF;
2912:
2913: -- Debug Checkpoint.
2914: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2915: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2916: 'After Login enabled check');
2917: END IF;
2918:
2919: -- Check required parameters.

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

2924: END IF;
2925:
2926: -- Debug Checkpoint.
2927: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2928: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2929: 'After required parameters check');
2930: END IF;
2931:
2932: -- Validate Workorder.

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

2949: END IF;
2950:
2951: -- Debug Checkpoint.
2952: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2953: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2954: 'After validate workorder');
2955: END IF;
2956:
2957: -- Default employee if input is null.

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

2972: END IF;
2973:
2974: -- Debug Checkpoint.
2975: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
2976: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
2977: 'After validating workorder and employee');
2978: END IF;
2979:
2980: -- Check if user already logged in.

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

3002: END IF;
3003:
3004: -- Debug Checkpoint.
3005: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3006: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3007: 'After login check successful');
3008: END IF;
3009:
3010: -- Check Unit locked.

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

3033: END IF;
3034:
3035: -- Debug Checkpoint.
3036: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3037: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3038: 'After unit lock check, user role check.. starting qualification checks for function:' ||
3039: l_fnd_function_name);
3040: END IF;
3041:

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

3043: IF (p_operation_seq_num IS NULL) THEN
3044:
3045: -- Debug Checkpoint.
3046: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3047: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3048: 'Workorder Login validations');
3049: END IF;
3050:
3051: -- validate if any operation is complete.

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

3114: IF (p_operation_seq_num IS NOT NULL) THEN
3115:
3116: -- Debug Checkpoint.
3117: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3118: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3119: 'Starting Workorder-Operation status validations');
3120: END IF;
3121:
3122: -- Validate operation seq num.

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

3140: -- Login into operation only.
3141:
3142: -- Debug Checkpoint.
3143: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3144: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3145: 'Workorder-Operation Login qualification validations');
3146: END IF;
3147:
3148:

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

3184: ELSE -- login into operation + resource.
3185:
3186: -- Debug Checkpoint.
3187: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3188: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3189: 'Starting Workorder-Operation-Resource validations');
3190: END IF;
3191:
3192: -- Get resource ID if resource seq num is input and resource_id is NULL.

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

3244: END IF; -- operation_seq_num is not null.
3245:
3246: -- Debug Checkpoint.
3247: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
3248: fnd_log.string(G_DEBUG_STMT, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed',
3249: 'Successfully completed all qualification validations ...');
3250: END IF;
3251:
3252: -- log debug message.

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

3250: END IF;
3251:
3252: -- log debug message.
3253: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3254: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed.End',
3255: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.Is_Login_Allowed');
3256: END IF;
3257:
3258: -- Set login allowed flag.

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

3292:
3293:
3294: -- log debug message.
3295: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3296: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_wo_login_info.Start',
3297: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.get_wo_login_info');
3298: END IF;
3299:
3300: IF p_x_wos.COUNT > 0 THEN

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

3309: END IF;
3310:
3311: -- log debug message.
3312: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3313: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_wo_login_info.End',
3314: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.get_wo_login_info');
3315: END IF;
3316:
3317: END get_wo_login_info;

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

3328: BEGIN
3329:
3330: -- log debug message.
3331: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3332: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info.Start',
3333: 'At Start of procedure AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info');
3334: END IF;
3335:
3336: IF p_x_op_res.COUNT > 0 AND p_workorder_id IS NOT NULL

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

3348: END IF;
3349:
3350: -- log debug message.
3351: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
3352: fnd_log.string(G_DEBUG_PROC, 'ahl.plsql.AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info.End',
3353: 'At End of procedure AHL_PRD_WO_LOGIN_PVT.get_op_res_login_info');
3354: END IF;
3355:
3356: END get_op_res_login_info;