164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
165:
166: l_log_level := translate_log_level(p_exception_level);
167: IF l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
168: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
169: FND_MSG_PUB.Add;
170: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
171: SET_LOG(p_module, p_exception_level);
172: END IF;
166: l_log_level := translate_log_level(p_exception_level);
167: IF l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
168: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
169: FND_MSG_PUB.Add;
170: FND_MESSAGE.Set_Name('AS', 'Error number ' || to_char(P_SQLCODE));
171: SET_LOG(p_module, p_exception_level);
172: END IF;
173:
174: -- ffang 090902, bug 2552070, this line is causing the problem and
197: or (p_col_choice is NOT NULL and p_col_name is NULL)
198: then
199: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
200: then
201: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
202: fnd_msg_pub.add;
203: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
204: SET_LOG('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
205: end if;
199: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
200: then
201: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
202: fnd_msg_pub.add;
203: fnd_message.set_name('AS', 'API_MISSING_ORDERBY_ELEMENT');
204: SET_LOG('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
205: end if;
206: raise fnd_api.g_exc_error;
207: end if;
222: return(l_col_name || ' DESC, ');
223: else
224: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
225: then
226: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;
229: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
230: fnd_message.set_token('PARAM',p_col_choice, false);
223: else
224: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
225: then
226: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;
229: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
230: fnd_message.set_token('PARAM',p_col_choice, false);
231: set_log('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
225: then
226: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;
229: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
230: fnd_message.set_token('PARAM',p_col_choice, false);
231: set_log('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
232: end if;
233: raise fnd_api.g_exc_error;
226: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
227: fnd_message.set_token('PARAM',p_col_choice, false);
228: fnd_msg_pub.add;
229: fnd_message.set_name('AS', 'API_INVALID_ORDERBY_CHOICE');
230: fnd_message.set_token('PARAM',p_col_choice, false);
231: set_log('as.plsql.utl.get_subOrderBy', fnd_msg_pub.g_msg_lvl_error);
232: end if;
233: raise fnd_api.g_exc_error;
234: return '';
261: G_PKG_NAME)
262: THEN
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
264: THEN
265: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;
268: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
269: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
262: THEN
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
264: THEN
265: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;
268: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
269: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
270: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
264: THEN
265: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;
268: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
269: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
270: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
271: END IF;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
266: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
267: FND_MSG_PUB.ADD;
268: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
269: FND_MESSAGE.Set_Token('ROW', 'TRANSLATE_ORDERBY', TRUE);
270: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
271: END IF;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
291: IF FND_GLOBAL.User_Id IS NULL
292: THEN
293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;
298: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
299: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
292: THEN
293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;
298: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
299: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
300: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;
298: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
299: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
300: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
301: END IF;
302: END IF;
295: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
296: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
297: FND_MSG_PUB.ADD;
298: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
299: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
300: SET_LOG('as.plsql.utl.Translate_OrderBy', fnd_msg_pub.g_msg_lvl_error);
301: END IF;
302: END IF;
303:
397: BEGIN
398: FOR l_count in 1..p_message_count LOOP
399:
400: l_temp_msg := fnd_msg_pub.get(fnd_msg_pub.g_next, fnd_api.g_true);
401: fnd_message.parse_encoded(l_temp_msg, l_appl_short_name, l_message_name);
402: OPEN Get_Appl_Id (l_appl_short_name);
403: FETCH Get_Appl_Id into l_id;
404: CLOSE Get_Appl_Id;
405:
464: --THEN
465: /*
466: l_length := length(p_msg);
467:
468: -- FND_MESSAGE doesn't allow message name to be over 30 chars
469: -- chop message name if length > 30
470: WHILE l_length > 30 LOOP
471: l_substring := substr(p_msg, l_start, 30);
472:
469: -- chop message name if length > 30
470: WHILE l_length > 30 LOOP
471: l_substring := substr(p_msg, l_start, 30);
472:
473: FND_MESSAGE.Set_Name('AS', l_substring);
474: -- FND_MESSAGE.Set_Name(p_app_name, l_substring);
475: l_start := l_start + 30;
476: l_length := l_length - 30;
477: FND_MSG_PUB.Add;
470: WHILE l_length > 30 LOOP
471: l_substring := substr(p_msg, l_start, 30);
472:
473: FND_MESSAGE.Set_Name('AS', l_substring);
474: -- FND_MESSAGE.Set_Name(p_app_name, l_substring);
475: l_start := l_start + 30;
476: l_length := l_length - 30;
477: FND_MSG_PUB.Add;
478: FND_MESSAGE.Set_Name('AS', l_substring);
474: -- FND_MESSAGE.Set_Name(p_app_name, l_substring);
475: l_start := l_start + 30;
476: l_length := l_length - 30;
477: FND_MSG_PUB.Add;
478: FND_MESSAGE.Set_Name('AS', l_substring);
479: SET_LOG(p_msg_level);
480: END LOOP;
481:
482: l_substring := substr(p_msg, l_start);
479: SET_LOG(p_msg_level);
480: END LOOP;
481:
482: l_substring := substr(p_msg, l_start);
483: FND_MESSAGE.Set_Name('AS', l_substring);
484: -- dbms_output.put_line('l_substring: ' || l_substring);
485: -- FND_MESSAGE.Set_Name(p_app_name, p_msg);
486: SET_LOG(p_msg_level);
487: FND_MESSAGE.Set_Name('AS', l_substring);
481:
482: l_substring := substr(p_msg, l_start);
483: FND_MESSAGE.Set_Name('AS', l_substring);
484: -- dbms_output.put_line('l_substring: ' || l_substring);
485: -- FND_MESSAGE.Set_Name(p_app_name, p_msg);
486: SET_LOG(p_msg_level);
487: FND_MESSAGE.Set_Name('AS', l_substring);
488: FND_MSG_PUB.Add;
489:
483: FND_MESSAGE.Set_Name('AS', l_substring);
484: -- dbms_output.put_line('l_substring: ' || l_substring);
485: -- FND_MESSAGE.Set_Name(p_app_name, p_msg);
486: SET_LOG(p_msg_level);
487: FND_MESSAGE.Set_Name('AS', l_substring);
488: FND_MSG_PUB.Add;
489:
490: */
491: l_log_level := translate_log_level(p_msg_level);
491: l_log_level := translate_log_level(p_msg_level);
492: IF l_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
493: l_length := length(p_msg);
494:
495: -- FND_MESSAGE doesn't allow application name to be over 30 chars
496: -- chop message name if length > 30
497: IF l_length > 30
498: THEN
499: l_substring := substr(p_msg, l_start, 30);
496: -- chop message name if length > 30
497: IF l_length > 30
498: THEN
499: l_substring := substr(p_msg, l_start, 30);
500: FND_MESSAGE.Set_Name('AS', l_substring);
501: -- FND_MESSAGE.Set_Name(l_substring, '');
502: ELSE
503: FND_MESSAGE.Set_Name('AS', p_msg);
504: -- FND_MESSAGE.Set_Name(p_msg, '');
497: IF l_length > 30
498: THEN
499: l_substring := substr(p_msg, l_start, 30);
500: FND_MESSAGE.Set_Name('AS', l_substring);
501: -- FND_MESSAGE.Set_Name(l_substring, '');
502: ELSE
503: FND_MESSAGE.Set_Name('AS', p_msg);
504: -- FND_MESSAGE.Set_Name(p_msg, '');
505: END IF;
499: l_substring := substr(p_msg, l_start, 30);
500: FND_MESSAGE.Set_Name('AS', l_substring);
501: -- FND_MESSAGE.Set_Name(l_substring, '');
502: ELSE
503: FND_MESSAGE.Set_Name('AS', p_msg);
504: -- FND_MESSAGE.Set_Name(p_msg, '');
505: END IF;
506: FND_MSG_PUB.Add;
507: IF l_length > 30
500: FND_MESSAGE.Set_Name('AS', l_substring);
501: -- FND_MESSAGE.Set_Name(l_substring, '');
502: ELSE
503: FND_MESSAGE.Set_Name('AS', p_msg);
504: -- FND_MESSAGE.Set_Name(p_msg, '');
505: END IF;
506: FND_MSG_PUB.Add;
507: IF l_length > 30
508: THEN
506: FND_MSG_PUB.Add;
507: IF l_length > 30
508: THEN
509: l_substring := substr(p_msg, l_start, 30);
510: FND_MESSAGE.Set_Name('AS', l_substring);
511: ELSE
512: FND_MESSAGE.Set_Name('AS', p_msg);
513: END IF;
514: SET_LOG(p_module, p_msg_level);
508: THEN
509: l_substring := substr(p_msg, l_start, 30);
510: FND_MESSAGE.Set_Name('AS', l_substring);
511: ELSE
512: FND_MESSAGE.Set_Name('AS', p_msg);
513: END IF;
514: SET_LOG(p_module, p_msg_level);
515: END IF;
516: --END IF;
535: IS
536: BEGIN
537: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
538: THEN
539: FND_MESSAGE.Set_Name('AS', p_msg_name);
540: FND_MSG_PUB.Add;
541: FND_MESSAGE.Set_Name('AS', p_msg_name);
542: SET_LOG(p_module, p_msg_level);
543: END IF;
537: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
538: THEN
539: FND_MESSAGE.Set_Name('AS', p_msg_name);
540: FND_MSG_PUB.Add;
541: FND_MESSAGE.Set_Name('AS', p_msg_name);
542: SET_LOG(p_module, p_msg_level);
543: END IF;
544: END Set_Message;
545:
568: IS
569: BEGIN
570: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
571: THEN
572: FND_MESSAGE.Set_Name('AS', p_msg_name);
573: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
574: FND_MSG_PUB.Add;
575: FND_MESSAGE.Set_Name('AS', p_msg_name);
576: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
569: BEGIN
570: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
571: THEN
572: FND_MESSAGE.Set_Name('AS', p_msg_name);
573: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
574: FND_MSG_PUB.Add;
575: FND_MESSAGE.Set_Name('AS', p_msg_name);
576: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
577: SET_LOG(p_module, p_msg_level);
571: THEN
572: FND_MESSAGE.Set_Name('AS', p_msg_name);
573: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
574: FND_MSG_PUB.Add;
575: FND_MESSAGE.Set_Name('AS', p_msg_name);
576: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
577: SET_LOG(p_module, p_msg_level);
578: END IF;
579: END Set_Message;
572: FND_MESSAGE.Set_Name('AS', p_msg_name);
573: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
574: FND_MSG_PUB.Add;
575: FND_MESSAGE.Set_Name('AS', p_msg_name);
576: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
577: SET_LOG(p_module, p_msg_level);
578: END IF;
579: END Set_Message;
580:
606: IS
607: BEGIN
608: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
609: THEN
610: FND_MESSAGE.Set_Name('AS', p_msg_name);
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
607: BEGIN
608: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
609: THEN
610: FND_MESSAGE.Set_Name('AS', p_msg_name);
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
615: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
608: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
609: THEN
610: FND_MESSAGE.Set_Name('AS', p_msg_name);
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
615: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
616: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
610: FND_MESSAGE.Set_Name('AS', p_msg_name);
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
615: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
616: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
617: SET_LOG(p_module, p_msg_level);
618: END IF;
611: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
615: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
616: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
617: SET_LOG(p_module, p_msg_level);
618: END IF;
619: END Set_Message;
612: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
613: FND_MSG_PUB.Add;
614: FND_MESSAGE.Set_Name('AS', p_msg_name);
615: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
616: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
617: SET_LOG(p_module, p_msg_level);
618: END IF;
619: END Set_Message;
620:
651: IS
652: BEGIN
653: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
654: THEN
655: FND_MESSAGE.Set_Name('AS', p_msg_name);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
652: BEGIN
653: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
654: THEN
655: FND_MESSAGE.Set_Name('AS', p_msg_name);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
653: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
654: THEN
655: FND_MESSAGE.Set_Name('AS', p_msg_name);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
654: THEN
655: FND_MESSAGE.Set_Name('AS', p_msg_name);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
662: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
656: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
662: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
663: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
664: SET_LOG(p_module, p_msg_level);
657: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
662: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
663: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
664: SET_LOG(p_module, p_msg_level);
665: END IF;
658: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
662: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
663: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
664: SET_LOG(p_module, p_msg_level);
665: END IF;
666: END Set_Message;
659: FND_MSG_PUB.Add;
660: FND_MESSAGE.Set_Name('AS', p_msg_name);
661: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
662: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
663: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
664: SET_LOG(p_module, p_msg_level);
665: END IF;
666: END Set_Message;
667:
718: IS
719: BEGIN
720: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
721: THEN
722: FND_MESSAGE.Set_Name('AS', p_msg_name);
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
719: BEGIN
720: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
721: THEN
722: FND_MESSAGE.Set_Name('AS', p_msg_name);
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
720: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level)
721: THEN
722: FND_MESSAGE.Set_Name('AS', p_msg_name);
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
721: THEN
722: FND_MESSAGE.Set_Name('AS', p_msg_name);
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
722: FND_MESSAGE.Set_Name('AS', p_msg_name);
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
723: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
724: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
725: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
726: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
727: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
728: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
729: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
737: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
730: FND_MSG_PUB.Add;
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
737: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
738: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
731: FND_MESSAGE.Set_Name('AS', p_msg_name);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
737: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
738: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
739: SET_LOG(p_module, p_msg_level);
732: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
737: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
738: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
739: SET_LOG(p_module, p_msg_level);
740: END IF;
733: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
737: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
738: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
739: SET_LOG(p_module, p_msg_level);
740: END IF;
741: END Set_Message;
734: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
735: FND_MESSAGE.Set_Token(p_token4, p_token4_value);
736: FND_MESSAGE.Set_Token(p_token5, p_token5_value);
737: FND_MESSAGE.Set_Token(p_token6, p_token6_value);
738: FND_MESSAGE.Set_Token(p_token7, p_token7_value);
739: SET_LOG(p_module, p_msg_level);
740: END IF;
741: END Set_Message;
742: