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_MSG_PUB

Line 165: FND_MSG_PUB.add;

161: --Check if Route is same on both sides of the Rule
162: IF(L_PRE_ROUTE = L_POST_ROUTE) THEN
163: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_SAME_ROUTE' );
164: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
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');

Line 180: FND_MSG_PUB.add;

176: --Check if Rule is filled on both sides
177: IF (L_RULE_PRE_PART = '' OR L_RULE_POST_PART = '') THEN
178: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_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;

Line 191: FND_MSG_PUB.add;

187: --Check if both part of the rule is exactly same
188: IF(L_RULE_PRE_PART = L_RULE_POST_PART) THEN
189: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_PRE_POST_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;

Line 203: FND_MSG_PUB.add;

199: IF((L_PRE_ROUTE IS NULL AND L_POST_ROUTE IS NOT NULL)
200: OR (L_PRE_ROUTE IS NOT NULL AND L_POST_ROUTE IS NULL)) THEN
201: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
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;

Line 213: FND_MSG_PUB.add;

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
211: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
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;

Line 223: FND_MSG_PUB.add;

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
221: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
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;

Line 233: FND_MSG_PUB.add;

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
231: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
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;

Line 250: FND_MSG_PUB.add;

246: CLOSE CHK_ROUTE_NUM;
247: IF(L_DUMMY_COUNT < 1) THEN
248: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );
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;

Line 266: FND_MSG_PUB.add;

262: CLOSE CHK_ROUTE_TYPE;
263: IF(L_DUMMY_COUNT < 1) THEN
264: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );
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;

Line 282: FND_MSG_PUB.add;

278: CLOSE CHK_SYSTEM;
279: IF(L_DUMMY_COUNT < 1) THEN
280: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );
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;

Line 298: FND_MSG_PUB.add;

294: CLOSE CHK_PROCESS;
295: IF(L_DUMMY_COUNT < 1) THEN
296: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );
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;

Line 314: FND_MSG_PUB.add;

310: CLOSE CHK_ROUTE_NUM;
311: IF(L_DUMMY_COUNT < 1) THEN
312: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );
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;

Line 330: FND_MSG_PUB.add;

326: CLOSE CHK_ROUTE_TYPE;
327: IF(L_DUMMY_COUNT < 1) THEN
328: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );
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;

Line 346: FND_MSG_PUB.add;

342: CLOSE CHK_SYSTEM;
343: IF(L_DUMMY_COUNT < 1) THEN
344: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );
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;

Line 362: FND_MSG_PUB.add;

358: CLOSE CHK_PROCESS;
359: IF(L_DUMMY_COUNT < 1) THEN
360: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );
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;

Line 378: FND_MSG_PUB.add;

374: CLOSE CHK_DUP_RULE;
375: IF(L_DUMMY_COUNT > 0) THEN
376: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DUP_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;

Line 392: FND_MSG_PUB.add;

388: CLOSE CHK_DUP_RULE;
389: IF(L_DUMMY_COUNT > 0) THEN
390: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INVERSE_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;

Line 438: FND_MSG_PUB.add;

434: WHEN l_cyclic_loop THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_CYC_ROUTE' );
437: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
438: FND_MSG_PUB.add;
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

Line 439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_CYC_ROUTE' );
437: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
438: FND_MSG_PUB.add;
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 );

Line 448: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

444: END IF;
445: WHEN OTHERS THEN
446: ROLLBACK TO update_rule_sp;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
450: END IF;
451: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
452: p_count => x_msg_count,

Line 449: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);

445: WHEN OTHERS THEN
446: ROLLBACK TO update_rule_sp;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
450: END IF;
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);

Line 451: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
450: END IF;
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 );

Line 493: FND_MSG_PUB.initialize;

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
493: FND_MSG_PUB.initialize;
494: END IF;
495:
496: -- Initialize API return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 565: FND_MSG_PUB.add;

561:
562: IF ( SQL%ROWCOUNT = 0 ) THEN
563: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');
564: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
565: FND_MSG_PUB.add;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: ELSE
568: -- Check whether Routes form a cycle among the rules. Cannot perform this check before inserting
569: validate_cyclic_routes(p_x_wbs_rules_rec, x_return_status, x_msg_count, x_msg_data);

Line 582: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

578: COMMIT;
579: END IF;
580:
581: -- Count and Get messages
582: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data);
585:
586: IF (l_log_procedure >= l_log_current_level) THEN

Line 594: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: ROLLBACK TO create_rule_sp;
593: x_return_status := FND_API.G_RET_STS_ERROR;
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 );

Line 604: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602: ROLLBACK TO create_rule_sp;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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 );

Line 614: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

610:
611: WHEN OTHERS THEN
612: ROLLBACK TO create_rule_sp;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
616: END IF;
617: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
618: p_count => x_msg_count,

Line 615: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);

611: WHEN OTHERS THEN
612: ROLLBACK TO create_rule_sp;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
616: END IF;
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);

Line 617: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
615: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
616: END IF;
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 );

Line 659: FND_MSG_PUB.initialize;

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
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 705: FND_MSG_PUB.add;

701:
702: IF ( SQL%ROWCOUNT = 0 ) THEN
703: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');
704: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
705: FND_MSG_PUB.add;
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: ELSE
708: -- Check whether Routes form a cycle among the rules. Cannot perform this check before updating
709: validate_cyclic_routes(p_x_wbs_rules_rec, x_return_status, x_msg_count, x_msg_data);

Line 722: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

718: COMMIT;
719: END IF;
720:
721: -- Count and Get messages
722: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
723: p_count => x_msg_count,
724: p_data => x_msg_data);
725:
726: IF (l_log_procedure >= l_log_current_level) THEN

Line 734: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

730: EXCEPTION
731: WHEN FND_API.G_EXC_ERROR THEN
732: ROLLBACK TO update_rule_sp;
733: x_return_status := FND_API.G_RET_STS_ERROR;
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 );

Line 744: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO update_rule_sp;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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 );

Line 754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

750:
751: WHEN OTHERS THEN
752: ROLLBACK TO update_rule_sp;
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
755: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
756: END IF;
757: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,

Line 755: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);

751: WHEN OTHERS THEN
752: ROLLBACK TO update_rule_sp;
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
755: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
756: END IF;
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);

Line 757: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
755: FND_MSG_PUB.add_exc_msg (G_PKG_NAME, L_API_NAME);
756: END IF;
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 );