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_WBS_RULES_PVT dependencies on FND_LOG

Line 15: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

11: G_CREATION_DATE DATE := SYSDATE;
12: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
13:
14: -- Log constants and variables
15: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
16: l_log_statement NUMBER := fnd_log.level_statement;
17: l_log_procedure NUMBER := fnd_log.level_procedure;
18:
19: -- Constants specific to WBS

Line 16: l_log_statement NUMBER := fnd_log.level_statement;

12: G_CREATED_BY NUMBER(15) := FND_GLOBAL.user_id;
13:
14: -- Log constants and variables
15: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
16: l_log_statement NUMBER := fnd_log.level_statement;
17: l_log_procedure NUMBER := fnd_log.level_procedure;
18:
19: -- Constants specific to WBS
20: G_SCH_WO VARCHAR2(30) := 'Schedule Workorders with ';

Line 17: l_log_procedure NUMBER := fnd_log.level_procedure;

13:
14: -- Log constants and variables
15: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
16: l_log_statement NUMBER := fnd_log.level_statement;
17: l_log_procedure NUMBER := fnd_log.level_procedure;
18:
19: -- Constants specific to WBS
20: G_SCH_WO VARCHAR2(30) := 'Schedule Workorders with ';
21: G_BEF_WO VARCHAR2(30) := ' Before Workorders with ';

Line 43: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of function');

39: l_rule_stmt VARCHAR2(500) := NULL;
40:
41: BEGIN
42: IF (l_log_procedure >= l_log_current_level) THEN
43: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of function');
44: END IF;
45:
46: -- Adding Route
47: IF(p_route_num is NOT NULL) THEN

Line 79: FND_LOG.string(l_log_statement, L_DEBUG, 'l_rule_stmt = ' || l_rule_stmt);

75: END IF;
76: END IF;
77:
78: IF (l_log_statement >= l_log_current_level) THEN
79: FND_LOG.string(l_log_statement, L_DEBUG, 'l_rule_stmt = ' || l_rule_stmt);
80: END IF;
81:
82: IF (l_log_procedure >= l_log_current_level) THEN
83: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of function');

Line 83: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of function');

79: FND_LOG.string(l_log_statement, L_DEBUG, 'l_rule_stmt = ' || l_rule_stmt);
80: END IF;
81:
82: IF (l_log_procedure >= l_log_current_level) THEN
83: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of function');
84: END IF;
85:
86: RETURN l_rule_stmt;
87: END formulate_rule_stmt;

Line 158: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

154: L_DUMMY_COUNT NUMBER;
155:
156: BEGIN
157: IF (l_log_procedure >= l_log_current_level) THEN
158: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
159: END IF;
160:
161: --Check if Route is same on both sides of the Rule
162: IF(L_PRE_ROUTE = L_POST_ROUTE) THEN

Line 169: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Same Route on both Sides');

165: FND_MSG_PUB.add;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167:
168: IF (l_log_statement >= l_log_current_level) THEN
169: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Same Route on both Sides');
170: END IF;
171: END IF;
172:
173: L_RULE_PRE_PART := formulate_rule_stmt(L_PRE_ROUTE, L_PRE_ROUTE_TYPE_MEANING, L_PRE_SYSTEM_CODE, L_PRE_PROCESS_MEANING);

Line 183: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Incomplete Rule');

179: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
180: FND_MSG_PUB.add;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: IF (l_log_statement >= l_log_current_level) THEN
183: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Incomplete Rule');
184: END IF;
185: END IF;
186:
187: --Check if both part of the rule is exactly same

Line 194: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Both part are same');

190: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
191: FND_MSG_PUB.add;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: IF (l_log_statement >= l_log_current_level) THEN
194: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Both part are same');
195: END IF;
196: END IF;
197:
198: --Check if same set of attributes are used on both sides

Line 206: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

202: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
203: FND_MSG_PUB.add;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (l_log_statement >= l_log_current_level) THEN
206: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');
207: END IF;
208:
209: ELSIF ((L_PRE_ROUTE_TYPE_CODE IS NULL AND L_POST_ROUTE_TYPE_CODE IS NOT NULL)
210: OR (L_PRE_ROUTE_TYPE_CODE IS NOT NULL AND L_POST_ROUTE_TYPE_CODE IS NULL)) THEN

Line 216: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

212: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
213: FND_MSG_PUB.add;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: IF (l_log_statement >= l_log_current_level) THEN
216: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');
217: END IF;
218:
219: ELSIF ((L_PRE_SYSTEM_CODE IS NULL AND L_POST_SYSTEM_CODE IS NOT NULL)
220: OR (L_PRE_SYSTEM_CODE IS NOT NULL AND L_POST_SYSTEM_CODE IS NULL)) THEN

Line 226: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

222: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: IF (l_log_statement >= l_log_current_level) THEN
226: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');
227: END IF;
228:
229: ELSIF ((L_PRE_PROCESS_CODE IS NULL AND L_POST_PROCESS_CODE IS NOT NULL)
230: OR (L_PRE_PROCESS_CODE IS NOT NULL AND L_POST_PROCESS_CODE IS NULL)) THEN

Line 236: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

232: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF (l_log_statement >= l_log_current_level) THEN
236: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');
237: END IF;
238: END IF;
239:
240: --Check for the existence of all attributes in DB

Line 253: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreRoute');

249: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
250: FND_MSG_PUB.add;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: IF (l_log_statement >= l_log_current_level) THEN
253: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreRoute');
254: END IF;
255: END IF;
256: END IF;
257:

Line 269: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreRouteType');

265: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
266: FND_MSG_PUB.add;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: IF (l_log_statement >= l_log_current_level) THEN
269: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreRouteType');
270: END IF;
271: END IF;
272: END IF;
273:

Line 285: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreSystem');

281: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
282: FND_MSG_PUB.add;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: IF (l_log_statement >= l_log_current_level) THEN
285: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreSystem');
286: END IF;
287: END IF;
288: END IF;
289:

Line 301: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreProcess');

297: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
298: FND_MSG_PUB.add;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: IF (l_log_statement >= l_log_current_level) THEN
301: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreProcess');
302: END IF;
303: END IF;
304: END IF;
305:

Line 317: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostRoute');

313: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
314: FND_MSG_PUB.add;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: IF (l_log_statement >= l_log_current_level) THEN
317: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostRoute');
318: END IF;
319: END IF;
320: END IF;
321:

Line 333: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostRouteType');

329: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
330: FND_MSG_PUB.add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: IF (l_log_statement >= l_log_current_level) THEN
333: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostRouteType');
334: END IF;
335: END IF;
336: END IF;
337:

Line 349: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostSystem');

345: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
346: FND_MSG_PUB.add;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: IF (l_log_statement >= l_log_current_level) THEN
349: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostSystem');
350: END IF;
351: END IF;
352: END IF;
353:

Line 365: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostProcess');

361: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
362: FND_MSG_PUB.add;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF (l_log_statement >= l_log_current_level) THEN
365: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostProcess');
366: END IF;
367: END IF;
368: END IF;
369: --End of individual attribute validation---------------------------------

Line 381: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Duplicate Rule');

377: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
378: FND_MSG_PUB.add;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: IF (l_log_statement >= l_log_current_level) THEN
381: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Duplicate Rule');
382: END IF;
383: END IF;
384:
385: --Check for inverse rule

Line 395: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'Inverse of Existing Rule');

391: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
392: FND_MSG_PUB.add;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: IF (l_log_statement >= l_log_current_level) THEN
395: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'Inverse of Existing Rule');
396: END IF;
397: END IF;
398:
399: --If validations are over, write rule text into the Record type, so that insertion/updation is easier

Line 405: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');

401: p_x_wbs_rules_rec.RULE_TEXT := G_SCH_WO || L_RULE_PRE_PART || G_BEF_WO || L_RULE_POST_PART;
402: END IF;
403:
404: IF (l_log_procedure >= l_log_current_level) THEN
405: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
406: END IF;
407: END validate_rule;
408:
409:

Line 443: FND_LOG.string(l_log_statement, L_DEBUG, 'validate_cyclic_routes: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In l_cyclic_loop block' || ' x_msg_count ' || x_msg_count );

439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data);
442: IF (l_log_statement >= l_log_current_level) THEN
443: FND_LOG.string(l_log_statement, L_DEBUG, 'validate_cyclic_routes: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In l_cyclic_loop block' || ' x_msg_count ' || x_msg_count );
444: END IF;
445: WHEN OTHERS THEN
446: ROLLBACK TO update_rule_sp;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 455: FND_LOG.string(l_log_statement, L_DEBUG, 'validate_cyclic_routes: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );

451: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,
453: p_data => x_msg_data);
454: IF (l_log_statement >= l_log_current_level) THEN
455: FND_LOG.string(l_log_statement, L_DEBUG, 'validate_cyclic_routes: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );
456: END IF;
457:
458: END validate_cyclic_routes;
459:

Line 488: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

484: -- Standard Start of API savepoint
485: SAVEPOINT create_rule_sp;
486:
487: IF (l_log_procedure >= l_log_current_level) THEN
488: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 510: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': x_return_status after call to validate_rule' || x_return_status);

506: --Perform all validations through the helper API
507: validate_rule(p_x_wbs_rules_rec, x_return_status);
508:
509: IF (l_log_statement >= l_log_current_level) THEN
510: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': x_return_status after call to validate_rule' || x_return_status);
511: END IF;
512:
513: --If Return Status is successful, then Insert the Rule
514: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 516: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to insert rule');

512:
513: --If Return Status is successful, then Insert the Rule
514: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
515: IF (l_log_statement >= l_log_current_level) THEN
516: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to insert rule');
517: END IF;
518:
519: INSERT INTO AHL_WBS_RULES
520: (

Line 587: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');

583: p_count => x_msg_count,
584: p_data => x_msg_data);
585:
586: IF (l_log_procedure >= l_log_current_level) THEN
587: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
588: END IF;
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN

Line 598: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_ERROR block' || ' x_msg_count ' || x_msg_count );

594: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597: IF (l_log_statement >= l_log_current_level) THEN
598: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_ERROR block' || ' x_msg_count ' || x_msg_count );
599: END IF;
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602: ROLLBACK TO create_rule_sp;

Line 608: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_UNEXPECTED_ERROR block' || ' x_msg_count ' || x_msg_count );

604: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
605: p_count => x_msg_count,
606: p_data => x_msg_data);
607: IF (l_log_statement >= l_log_current_level) THEN
608: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_UNEXPECTED_ERROR block' || ' x_msg_count ' || x_msg_count );
609: END IF;
610:
611: WHEN OTHERS THEN
612: ROLLBACK TO create_rule_sp;

Line 621: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );

617: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,
619: p_data => x_msg_data);
620: IF (l_log_statement >= l_log_current_level) THEN
621: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );
622: END IF;
623: END create_rule;
624:
625:

Line 654: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

650: -- Standard Start of API savepoint
651: SAVEPOINT update_rule_sp;
652:
653: IF (l_log_procedure >= l_log_current_level) THEN
654: FND_LOG.string(l_log_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
655: END IF;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 676: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': x_return_status after call to validate_rule' || x_return_status);

672: --Perform all validations through the helper API
673: validate_rule(p_x_wbs_rules_rec, x_return_status);
674:
675: IF (l_log_statement >= l_log_current_level) THEN
676: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': x_return_status after call to validate_rule' || x_return_status);
677: END IF;
678:
679: --If Return Status is successful, then Update the Rule
680: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 682: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to update rule');

678:
679: --If Return Status is successful, then Update the Rule
680: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
681: IF (l_log_statement >= l_log_current_level) THEN
682: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': About to update rule');
683: END IF;
684:
685: UPDATE AHL_WBS_RULES
686: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 727: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');

723: p_count => x_msg_count,
724: p_data => x_msg_data);
725:
726: IF (l_log_procedure >= l_log_current_level) THEN
727: FND_LOG.string(l_log_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
728: END IF;
729:
730: EXCEPTION
731: WHEN FND_API.G_EXC_ERROR THEN

Line 738: FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_ERROR block' || ' x_msg_count ' || x_msg_count );

734: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
735: p_count => x_msg_count,
736: p_data => x_msg_data);
737: IF (l_log_statement >= l_log_current_level) THEN
738: FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_ERROR block' || ' x_msg_count ' || x_msg_count );
739: END IF;
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO update_rule_sp;

Line 748: FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_UNEXPECTED_ERROR block' || ' x_msg_count ' || x_msg_count );

744: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
745: p_count => x_msg_count,
746: p_data => x_msg_data);
747: IF (l_log_statement >= l_log_current_level) THEN
748: FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In G_EXC_UNEXPECTED_ERROR block' || ' x_msg_count ' || x_msg_count );
749: END IF;
750:
751: WHEN OTHERS THEN
752: ROLLBACK TO update_rule_sp;

Line 761: FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );

757: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data);
760: IF (l_log_statement >= l_log_current_level) THEN
761: FND_LOG.string(l_log_statement, L_DEBUG, 'Update Rule: rule_id-' || p_x_wbs_rules_rec.rule_id || 'In OTHERS block' || ' x_msg_count ' || x_msg_count );
762: END IF;
763: END update_rule;
764:
765: