DBA Data[Home] [Help]

APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_X_USER_EXCEP_GEN

Line 1: PACKAGE BODY MSC_X_USER_EXCEP_GEN AS

1: PACKAGE BODY MSC_X_USER_EXCEP_GEN AS
2: /* $Header: MSCUDERB.pls 120.6 2007/07/19 08:36:24 vsiyer ship $ */
3:
4:
5:

Line 301: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

297: role =>l_user_name,
298: msg_type=> p_item_type ,
299: msg_name => v_msg_name ,
300: context => pItemKey,
301: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
302: );
303:
304: if v_debug then
305: log_message('Buyer: Notification sent to user='||l_user_name);

Line 331: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

327: role =>l_user_name,
328: msg_type=> p_item_type ,
329: msg_name => v_msg_name ,
330: context => pItemKey,
331: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
332: );
333:
334: if v_debug then
335: log_message('Buyer: Notification sent to user='||l_user_name);

Line 346: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.SendNtfToBuyer',SQLERRM);

342: -- added exception handler
343: Exception when others then
344: log_message('Buyer: EXCEPTION ::'||sqlerrm);
345: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
346: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.SendNtfToBuyer',SQLERRM);
347: end if;
348:
349:
350:

Line 459: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

455: role =>l_user_name,
456: msg_type=> p_item_type ,
457: msg_name => v_msg_name ,
458: context => pItemKey,
459: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
460: );
461:
462: if v_debug then
463: log_message('Supplier Contact: Notification sent to user='||l_user_name);

Line 477: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

473: role =>l_user_name,
474: msg_type=> p_item_type ,
475: msg_name => v_msg_name ,
476: context => pItemKey,
477: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
478: );
479:
480: if v_debug then
481: log_message('Supplier Contact: Notification sent to user='||l_user_name);

Line 492: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.SendNtfToSupplierContact',SQLERRM);

488: -- added exception handler
489: Exception when others then
490: log_message('Supplier Contact: EXCEPTION ::'||sqlerrm);
491: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
492: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.SendNtfToSupplierContact',SQLERRM);
493: end if;
494:
495: end SendNtfToSupplierContact;
496:

Line 1656: vExceptionGroupName := MSC_X_USER_EXCEP_GEN.GET_MESSAGE_GROUP(-99);

1652: numberCounter := 0;
1653: varchar2Counter := 0;
1654: vTotalNumberOfFetches := 0;
1655:
1656: vExceptionGroupName := MSC_X_USER_EXCEP_GEN.GET_MESSAGE_GROUP(-99);
1657:
1658: if v_notification_text is not null then
1659: v_notificationToken1 := getNotificationToken(v_notification_text, 1);
1660: v_notificationToken2 := getNotificationToken(v_notification_text,2);

Line 3078: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

3074: msg_type=> p_item_type ,
3075: msg_name => v_msg_name ,
3076: context => pItemKey,
3077: DUE_DATE => sysdate+ 7,
3078: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
3079: );
3080: end if;
3081: end if;
3082:

Line 3195: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

3191: role =>l_user_name,
3192: msg_type=> p_item_type ,
3193: msg_name => v_msg_name ,
3194: context => pItemKey,
3195: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
3196: );
3197: if v_debug then
3198: log_message('Planner Code: Notification sent to user='||l_user_name);
3199: end if;

Line 3224: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'

3220: role =>l_user_name,
3221: msg_type=> p_item_type ,
3222: msg_name => v_msg_name ,
3223: context => pItemKey,
3224: callback => 'MSC_X_USER_EXCEP_GEN.setMesgAttribute'
3225: );
3226: if v_debug then
3227: log_message('Planner Code: Notification sent to user='||l_user_name);
3228: end if;

Line 3237: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.SendNtfToPlannerCode',SQLERRM);

3233: -- added exception handler
3234: Exception when others then
3235: log_message('Planner Code: EXCEPTION ::'||sqlerrm);
3236: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3237: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.SendNtfToPlannerCode',SQLERRM);
3238: END IF;
3239:
3240: end SendNtfToPlannerCode;
3241:

Line 3268: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.setMesgAttribute',SQLERRM);

3264:
3265: -- added exception handler
3266: exception when others then
3267: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3268: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_X_USER_EXCEP_GEN.setMesgAttribute',SQLERRM);
3269: END IF;
3270:
3271: end;
3272:

Line 4090: END MSC_X_USER_EXCEP_GEN;

4086: commit;
4087: close getExceptions;
4088: end;
4089:
4090: END MSC_X_USER_EXCEP_GEN;