DBA Data[Home] [Help]

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FND_MESSAGE

Line 2589: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_CHANGED');

2585:
2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2587: THEN
2588:
2589: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_CHANGED');
2590: FND_MSG_PUB.Add;
2591:
2592: END IF;
2593:

Line 2606: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_DELETED');

2602:
2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:
2606: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_DELETED');
2607: FND_MSG_PUB.Add;
2608:
2609: END IF;
2610: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 2618: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_ALREADY_LOCKED');

2614:
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2616: THEN
2617:
2618: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_ALREADY_LOCKED');
2619: FND_MSG_PUB.Add;
2620:
2621: END IF;
2622: WHEN OTHERS THEN

Line 2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2755:
2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2757: THEN
2758:
2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
2761: FND_MSG_PUB.Add;
2762:
2763: END IF;

Line 2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');

2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2757: THEN
2758:
2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
2761: FND_MSG_PUB.Add;
2762:
2763: END IF;
2764:

Line 2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2785:
2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2787: THEN
2788:
2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
2791: FND_MSG_PUB.Add;
2792:
2793: END IF;

Line 2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');

2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2787: THEN
2788:
2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
2791: FND_MSG_PUB.Add;
2792:
2793: END IF;
2794:

Line 2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2815:
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2821: FND_MSG_PUB.Add;
2822:
2823: END IF;

Line 2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2821: FND_MSG_PUB.Add;
2822:
2823: END IF;
2824:

Line 2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2845:
2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2847: THEN
2848:
2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
2851: FND_MSG_PUB.Add;
2852:
2853: END IF;

Line 2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');

2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2847: THEN
2848:
2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
2851: FND_MSG_PUB.Add;
2852:
2853: END IF;
2854:

Line 2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2875:
2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2877: THEN
2878:
2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2881: FND_MSG_PUB.Add;
2882:
2883: END IF;

Line 2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');

2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2877: THEN
2878:
2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2881: FND_MSG_PUB.Add;
2882:
2883: END IF;
2884:

Line 2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2905:
2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2907: THEN
2908:
2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
2911: FND_MSG_PUB.Add;
2912:
2913: END IF;

Line 2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');

2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2907: THEN
2908:
2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
2911: FND_MSG_PUB.Add;
2912:
2913: END IF;
2914:

Line 2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2935:
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2937: THEN
2938:
2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2941: FND_MSG_PUB.Add;
2942:
2943: END IF;

Line 2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');

2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2937: THEN
2938:
2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2941: FND_MSG_PUB.Add;
2942:
2943: END IF;
2944:

Line 2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');

2965:
2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2967: THEN
2968:
2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
2971: FND_MSG_PUB.Add;
2972:
2973: END IF;

Line 2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');

2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2967: THEN
2968:
2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
2971: FND_MSG_PUB.Add;
2972:
2973: END IF;
2974:

Line 3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');

3461: fnd_date.canonical_to_date(p_end_date));
3462: --end of fix bug#3170105
3463:
3464: -- Print report parameters
3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3466: l_log_message := FND_MESSAGE.get;

3462: --end of fix bug#3170105
3463:
3464: -- Print report parameters
3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');

Line 3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;

Line 3470: FND_MESSAGE.set_token('NUMBER','1');

3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);

Line 3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');

3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:

Line 3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));

3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3473: l_log_message := FND_MESSAGE.get;

3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');

Line 3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;

Line 3477: FND_MESSAGE.set_token('NUMBER','2');

3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);

Line 3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');

3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:

Line 3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105

3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3480: l_log_message := FND_MESSAGE.get;

3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');

Line 3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;

Line 3484: FND_MESSAGE.set_token('NUMBER','3');

3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);

Line 3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');

3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:

Line 3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105

3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3487: l_log_message := FND_MESSAGE.get;

3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');

Line 3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;

Line 3491: FND_MESSAGE.set_token('NUMBER','4');

3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);

Line 3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');

3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:

Line 3493: FND_MESSAGE.set_token('VALUE',p_from_line);

3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3494: l_log_message := FND_MESSAGE.get;

3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');

Line 3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;

Line 3498: FND_MESSAGE.set_token('NUMBER','5');

3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);

Line 3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');

3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:

Line 3500: FND_MESSAGE.set_token('VALUE',p_to_line);

3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3501: l_log_message := FND_MESSAGE.get;

3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');

Line 3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;

Line 3505: FND_MESSAGE.set_token('NUMBER','6');

3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);

Line 3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');

3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:

Line 3507: FND_MESSAGE.set_token('VALUE',p_from_item);

3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3508: l_log_message := FND_MESSAGE.get;

3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');

Line 3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;

Line 3512: FND_MESSAGE.set_token('NUMBER','7');

3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);

Line 3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');

3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:

Line 3514: FND_MESSAGE.set_token('VALUE',p_to_item);

3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3515: l_log_message := FND_MESSAGE.get;

3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');

Line 3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;

Line 3519: FND_MESSAGE.set_token('NUMBER','8');

3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);

Line 3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');

3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:

Line 3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));

3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3522: l_log_message := FND_MESSAGE.get;

3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');

Line 3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;

Line 3526: FND_MESSAGE.set_token('NUMBER','9');

3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);

Line 3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');

3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:

Line 3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));

3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3529: l_log_message := FND_MESSAGE.get;

3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');

Line 3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;

Line 3533: FND_MESSAGE.set_token('NUMBER','10');

3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);

Line 3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');

3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:

Line 3535: FND_MESSAGE.set_token('VALUE',p_from_category);

3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 3536: l_log_message := FND_MESSAGE.get;

3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');

Line 3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;

Line 3540: FND_MESSAGE.set_token('NUMBER','11');

3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);

Line 3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');

3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3545:

Line 3542: FND_MESSAGE.set_token('VALUE',p_to_category);

3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3545:
3546: -- Check for mandatory parameters and issue an error message

Line 3543: l_log_message := FND_MESSAGE.get;

3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3545:
3546: -- Check for mandatory parameters and issue an error message
3547: -- Check for mandatory parameters and issue an error message

Line 3550: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');

3546: -- Check for mandatory parameters and issue an error message
3547: -- Check for mandatory parameters and issue an error message
3548: -- if NULL. If line, item or category are null, assume all.
3549: IF p_organization_id IS NULL THEN
3550: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
3551: l_log_message := FND_MESSAGE.get;
3552: MRP_UTIL.MRP_LOG(l_log_message);
3553: RAISE expected_error;
3554: END IF;

Line 3551: l_log_message := FND_MESSAGE.get;

3547: -- Check for mandatory parameters and issue an error message
3548: -- if NULL. If line, item or category are null, assume all.
3549: IF p_organization_id IS NULL THEN
3550: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
3551: l_log_message := FND_MESSAGE.get;
3552: MRP_UTIL.MRP_LOG(l_log_message);
3553: RAISE expected_error;
3554: END IF;
3555: IF p_start_date IS NULL THEN

Line 3556: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');

3552: MRP_UTIL.MRP_LOG(l_log_message);
3553: RAISE expected_error;
3554: END IF;
3555: IF p_start_date IS NULL THEN
3556: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
3557: l_log_message := FND_MESSAGE.get;
3558: MRP_UTIL.MRP_LOG(l_log_message);
3559: RAISE expected_error;
3560: END IF;

Line 3557: l_log_message := FND_MESSAGE.get;

3553: RAISE expected_error;
3554: END IF;
3555: IF p_start_date IS NULL THEN
3556: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
3557: l_log_message := FND_MESSAGE.get;
3558: MRP_UTIL.MRP_LOG(l_log_message);
3559: RAISE expected_error;
3560: END IF;
3561: IF p_end_date IS NULL THEN

Line 3562: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');

3558: MRP_UTIL.MRP_LOG(l_log_message);
3559: RAISE expected_error;
3560: END IF;
3561: IF p_end_date IS NULL THEN
3562: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
3563: l_log_message := FND_MESSAGE.get;
3564: MRP_UTIL.MRP_LOG(l_log_message);
3565: RAISE expected_error;
3566: END IF;

Line 3563: l_log_message := FND_MESSAGE.get;

3559: RAISE expected_error;
3560: END IF;
3561: IF p_end_date IS NULL THEN
3562: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
3563: l_log_message := FND_MESSAGE.get;
3564: MRP_UTIL.MRP_LOG(l_log_message);
3565: RAISE expected_error;
3566: END IF;
3567:

Line 3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');

3713:
3714: -- close the cursor
3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);

Line 3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);

3714: -- close the cursor
3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:

Line 3719: ERRBUF := FND_MESSAGE.get;

3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');

Line 3720: l_log_message := FND_MESSAGE.get;

3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3724: l_log_message := FND_MESSAGE.get;

Line 3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');

3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3724: l_log_message := FND_MESSAGE.get;
3725: MRP_UTIL.MRP_LOG(l_log_message);
3726:
3727: RETCODE := G_SUCCESS;

Line 3724: l_log_message := FND_MESSAGE.get;

3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3724: l_log_message := FND_MESSAGE.get;
3725: MRP_UTIL.MRP_LOG(l_log_message);
3726:
3727: RETCODE := G_SUCCESS;
3728:

Line 3733: FND_MESSAGE.set_name('MRP','MRP_NO_FLOW_DELETED');

3729: EXCEPTION
3730: WHEN NO_DATA_FOUND THEN
3731: ROLLBACK;
3732: RETCODE := G_WARNING;
3733: FND_MESSAGE.set_name('MRP','MRP_NO_FLOW_DELETED');
3734: l_log_message := FND_MESSAGE.get;
3735: MRP_UTIL.MRP_LOG(l_log_message);
3736:
3737: WHEN expected_error THEN

Line 3734: l_log_message := FND_MESSAGE.get;

3730: WHEN NO_DATA_FOUND THEN
3731: ROLLBACK;
3732: RETCODE := G_WARNING;
3733: FND_MESSAGE.set_name('MRP','MRP_NO_FLOW_DELETED');
3734: l_log_message := FND_MESSAGE.get;
3735: MRP_UTIL.MRP_LOG(l_log_message);
3736:
3737: WHEN expected_error THEN
3738: ROLLBACK;

Line 3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');

3738: ROLLBACK;
3739: IF RETCODE <> 1 THEN
3740: RETCODE := G_ERROR;
3741: END IF;
3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3743: ERRBUF := FND_MESSAGE.get;
3744: l_log_message := FND_MESSAGE.get;
3745: MRP_UTIL.MRP_LOG(l_log_message);
3746:

Line 3743: ERRBUF := FND_MESSAGE.get;

3739: IF RETCODE <> 1 THEN
3740: RETCODE := G_ERROR;
3741: END IF;
3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3743: ERRBUF := FND_MESSAGE.get;
3744: l_log_message := FND_MESSAGE.get;
3745: MRP_UTIL.MRP_LOG(l_log_message);
3746:
3747: WHEN unexpected_error THEN

Line 3744: l_log_message := FND_MESSAGE.get;

3740: RETCODE := G_ERROR;
3741: END IF;
3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3743: ERRBUF := FND_MESSAGE.get;
3744: l_log_message := FND_MESSAGE.get;
3745: MRP_UTIL.MRP_LOG(l_log_message);
3746:
3747: WHEN unexpected_error THEN
3748: ROLLBACK;

Line 3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');

3746:
3747: WHEN unexpected_error THEN
3748: ROLLBACK;
3749: RETCODE := G_ERROR;
3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3751: ERRBUF := FND_MESSAGE.get;
3752: l_log_message := FND_MESSAGE.get;
3753: MRP_UTIL.MRP_LOG(l_log_message);
3754:

Line 3751: ERRBUF := FND_MESSAGE.get;

3747: WHEN unexpected_error THEN
3748: ROLLBACK;
3749: RETCODE := G_ERROR;
3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3751: ERRBUF := FND_MESSAGE.get;
3752: l_log_message := FND_MESSAGE.get;
3753: MRP_UTIL.MRP_LOG(l_log_message);
3754:
3755: WHEN OTHERS THEN

Line 3752: l_log_message := FND_MESSAGE.get;

3748: ROLLBACK;
3749: RETCODE := G_ERROR;
3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3751: ERRBUF := FND_MESSAGE.get;
3752: l_log_message := FND_MESSAGE.get;
3753: MRP_UTIL.MRP_LOG(l_log_message);
3754:
3755: WHEN OTHERS THEN
3756: ROLLBACK;

Line 3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');

3754:
3755: WHEN OTHERS THEN
3756: ROLLBACK;
3757: RETCODE := G_ERROR;
3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3759: ERRBUF := FND_MESSAGE.get;
3760: l_log_message := FND_MESSAGE.get;
3761: MRP_UTIL.MRP_LOG(l_log_message);
3762: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 3759: ERRBUF := FND_MESSAGE.get;

3755: WHEN OTHERS THEN
3756: ROLLBACK;
3757: RETCODE := G_ERROR;
3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3759: ERRBUF := FND_MESSAGE.get;
3760: l_log_message := FND_MESSAGE.get;
3761: MRP_UTIL.MRP_LOG(l_log_message);
3762: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
3763: MRP_UTIL.MRP_LOG(l_log_message);

Line 3760: l_log_message := FND_MESSAGE.get;

3756: ROLLBACK;
3757: RETCODE := G_ERROR;
3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3759: ERRBUF := FND_MESSAGE.get;
3760: l_log_message := FND_MESSAGE.get;
3761: MRP_UTIL.MRP_LOG(l_log_message);
3762: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
3763: MRP_UTIL.MRP_LOG(l_log_message);
3764:

Line 4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');

4374: return(l_cursor_name);
4375: EXCEPTION
4376: WHEN NO_DATA_FOUND THEN
4377: RETCODE := G_ERROR;
4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4379: ERRBUF := FND_MESSAGE.get;
4380: l_log_message := FND_MESSAGE.get;
4381: MRP_UTIL.MRP_LOG(l_log_message);
4382: RETURN NULL;

Line 4379: ERRBUF := FND_MESSAGE.get;

4375: EXCEPTION
4376: WHEN NO_DATA_FOUND THEN
4377: RETCODE := G_ERROR;
4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4379: ERRBUF := FND_MESSAGE.get;
4380: l_log_message := FND_MESSAGE.get;
4381: MRP_UTIL.MRP_LOG(l_log_message);
4382: RETURN NULL;
4383:

Line 4380: l_log_message := FND_MESSAGE.get;

4376: WHEN NO_DATA_FOUND THEN
4377: RETCODE := G_ERROR;
4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4379: ERRBUF := FND_MESSAGE.get;
4380: l_log_message := FND_MESSAGE.get;
4381: MRP_UTIL.MRP_LOG(l_log_message);
4382: RETURN NULL;
4383:
4384: WHEN OTHERS THEN

Line 4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');

4551:
4552: WHEN NO_DATA_FOUND THEN
4553:
4554: RETCODE := G_ERROR;
4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4556: ERRBUF := FND_MESSAGE.get;
4557: l_log_message := FND_MESSAGE.get;
4558: MRP_UTIL.MRP_LOG(l_log_message);
4559:

Line 4556: ERRBUF := FND_MESSAGE.get;

4552: WHEN NO_DATA_FOUND THEN
4553:
4554: RETCODE := G_ERROR;
4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4556: ERRBUF := FND_MESSAGE.get;
4557: l_log_message := FND_MESSAGE.get;
4558: MRP_UTIL.MRP_LOG(l_log_message);
4559:
4560: RETURN NULL;

Line 4557: l_log_message := FND_MESSAGE.get;

4553:
4554: RETCODE := G_ERROR;
4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4556: ERRBUF := FND_MESSAGE.get;
4557: l_log_message := FND_MESSAGE.get;
4558: MRP_UTIL.MRP_LOG(l_log_message);
4559:
4560: RETURN NULL;
4561:

Line 4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');

4820:
4821: WHEN NO_DATA_FOUND THEN
4822:
4823: RETCODE := G_ERROR;
4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4825: ERRBUF := FND_MESSAGE.get;
4826: l_log_message := FND_MESSAGE.get;
4827: MRP_UTIL.MRP_LOG(l_log_message);
4828:

Line 4825: ERRBUF := FND_MESSAGE.get;

4821: WHEN NO_DATA_FOUND THEN
4822:
4823: RETCODE := G_ERROR;
4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4825: ERRBUF := FND_MESSAGE.get;
4826: l_log_message := FND_MESSAGE.get;
4827: MRP_UTIL.MRP_LOG(l_log_message);
4828:
4829: RETURN NULL;

Line 4826: l_log_message := FND_MESSAGE.get;

4822:
4823: RETCODE := G_ERROR;
4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4825: ERRBUF := FND_MESSAGE.get;
4826: l_log_message := FND_MESSAGE.get;
4827: MRP_UTIL.MRP_LOG(l_log_message);
4828:
4829: RETURN NULL;
4830:

Line 4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');

4858:
4859: WHEN NO_DATA_FOUND THEN
4860:
4861: RETCODE := G_ERROR;
4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4863: ERRBUF := FND_MESSAGE.get;
4864: l_log_message := FND_MESSAGE.get;
4865: MRP_UTIL.MRP_LOG(l_log_message);
4866:

Line 4863: ERRBUF := FND_MESSAGE.get;

4859: WHEN NO_DATA_FOUND THEN
4860:
4861: RETCODE := G_ERROR;
4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4863: ERRBUF := FND_MESSAGE.get;
4864: l_log_message := FND_MESSAGE.get;
4865: MRP_UTIL.MRP_LOG(l_log_message);
4866:
4867: RETURN FALSE;

Line 4864: l_log_message := FND_MESSAGE.get;

4860:
4861: RETCODE := G_ERROR;
4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4863: ERRBUF := FND_MESSAGE.get;
4864: l_log_message := FND_MESSAGE.get;
4865: MRP_UTIL.MRP_LOG(l_log_message);
4866:
4867: RETURN FALSE;
4868:

Line 4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');

4902:
4903: WHEN NO_DATA_FOUND THEN
4904:
4905: RETCODE := G_ERROR;
4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4907: ERRBUF := FND_MESSAGE.get;
4908: l_log_message := FND_MESSAGE.get;
4909: MRP_UTIL.MRP_LOG(l_log_message);
4910:

Line 4907: ERRBUF := FND_MESSAGE.get;

4903: WHEN NO_DATA_FOUND THEN
4904:
4905: RETCODE := G_ERROR;
4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4907: ERRBUF := FND_MESSAGE.get;
4908: l_log_message := FND_MESSAGE.get;
4909: MRP_UTIL.MRP_LOG(l_log_message);
4910:
4911: RETURN FALSE;

Line 4908: l_log_message := FND_MESSAGE.get;

4904:
4905: RETCODE := G_ERROR;
4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4907: ERRBUF := FND_MESSAGE.get;
4908: l_log_message := FND_MESSAGE.get;
4909: MRP_UTIL.MRP_LOG(l_log_message);
4910:
4911: RETURN FALSE;
4912:

Line 5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');

5078:
5079: WHEN NO_DATA_FOUND THEN
5080:
5081: RETCODE := G_ERROR;
5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
5083: ERRBUF := FND_MESSAGE.get;
5084: l_log_message := FND_MESSAGE.get;
5085: MRP_UTIL.MRP_LOG(l_log_message);
5086:

Line 5083: ERRBUF := FND_MESSAGE.get;

5079: WHEN NO_DATA_FOUND THEN
5080:
5081: RETCODE := G_ERROR;
5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
5083: ERRBUF := FND_MESSAGE.get;
5084: l_log_message := FND_MESSAGE.get;
5085: MRP_UTIL.MRP_LOG(l_log_message);
5086:
5087: RETURN NULL;

Line 5084: l_log_message := FND_MESSAGE.get;

5080:
5081: RETCODE := G_ERROR;
5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
5083: ERRBUF := FND_MESSAGE.get;
5084: l_log_message := FND_MESSAGE.get;
5085: MRP_UTIL.MRP_LOG(l_log_message);
5086:
5087: RETURN NULL;
5088:

Line 5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

5328:
5329: WHEN OTHERS THEN
5330: ROLLBACK;
5331: RETCODE := G_ERROR;
5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5333: ERRBUF := FND_MESSAGE.get;
5334: l_log_message := FND_MESSAGE.get;
5335: MRP_UTIL.MRP_LOG(l_log_message);
5336: l_log_message := 'Problem with initialize_report procedure';

Line 5333: ERRBUF := FND_MESSAGE.get;

5329: WHEN OTHERS THEN
5330: ROLLBACK;
5331: RETCODE := G_ERROR;
5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5333: ERRBUF := FND_MESSAGE.get;
5334: l_log_message := FND_MESSAGE.get;
5335: MRP_UTIL.MRP_LOG(l_log_message);
5336: l_log_message := 'Problem with initialize_report procedure';
5337: MRP_UTIL.MRP_LOG(l_log_message);

Line 5334: l_log_message := FND_MESSAGE.get;

5330: ROLLBACK;
5331: RETCODE := G_ERROR;
5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5333: ERRBUF := FND_MESSAGE.get;
5334: l_log_message := FND_MESSAGE.get;
5335: MRP_UTIL.MRP_LOG(l_log_message);
5336: l_log_message := 'Problem with initialize_report procedure';
5337: MRP_UTIL.MRP_LOG(l_log_message);
5338: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

5552:
5553: WHEN OTHERS THEN
5554: ROLLBACK;
5555: RETCODE := G_ERROR;
5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5557: ERRBUF := FND_MESSAGE.get;
5558: l_log_message := FND_MESSAGE.get;
5559: MRP_UTIL.MRP_LOG(l_log_message);
5560: l_log_message := 'Problem with initialize_report procedure';

Line 5557: ERRBUF := FND_MESSAGE.get;

5553: WHEN OTHERS THEN
5554: ROLLBACK;
5555: RETCODE := G_ERROR;
5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5557: ERRBUF := FND_MESSAGE.get;
5558: l_log_message := FND_MESSAGE.get;
5559: MRP_UTIL.MRP_LOG(l_log_message);
5560: l_log_message := 'Problem with initialize_report procedure';
5561: MRP_UTIL.MRP_LOG(l_log_message);

Line 5558: l_log_message := FND_MESSAGE.get;

5554: ROLLBACK;
5555: RETCODE := G_ERROR;
5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5557: ERRBUF := FND_MESSAGE.get;
5558: l_log_message := FND_MESSAGE.get;
5559: MRP_UTIL.MRP_LOG(l_log_message);
5560: l_log_message := 'Problem with initialize_report procedure';
5561: MRP_UTIL.MRP_LOG(l_log_message);
5562: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

5678: NULL;
5679: WHEN OTHERS THEN
5680: ROLLBACK;
5681: RETCODE := G_ERROR;
5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5683: ERRBUF := FND_MESSAGE.get;
5684: l_log_message := FND_MESSAGE.get;
5685: MRP_UTIL.MRP_LOG(l_log_message);
5686: l_log_message := 'Problem in report_update_WD procedure';

Line 5683: ERRBUF := FND_MESSAGE.get;

5679: WHEN OTHERS THEN
5680: ROLLBACK;
5681: RETCODE := G_ERROR;
5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5683: ERRBUF := FND_MESSAGE.get;
5684: l_log_message := FND_MESSAGE.get;
5685: MRP_UTIL.MRP_LOG(l_log_message);
5686: l_log_message := 'Problem in report_update_WD procedure';
5687: MRP_UTIL.MRP_LOG(l_log_message);

Line 5684: l_log_message := FND_MESSAGE.get;

5680: ROLLBACK;
5681: RETCODE := G_ERROR;
5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5683: ERRBUF := FND_MESSAGE.get;
5684: l_log_message := FND_MESSAGE.get;
5685: MRP_UTIL.MRP_LOG(l_log_message);
5686: l_log_message := 'Problem in report_update_WD procedure';
5687: MRP_UTIL.MRP_LOG(l_log_message);
5688: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

5803: WHEN OTHERS THEN
5804:
5805: ROLLBACK;
5806: RETCODE := G_ERROR;
5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5808: ERRBUF := FND_MESSAGE.get;
5809: l_log_message := FND_MESSAGE.get;
5810: MRP_UTIL.MRP_LOG(l_log_message);
5811: l_log_message := 'Problem in report_update_WOD procedure';

Line 5808: ERRBUF := FND_MESSAGE.get;

5804:
5805: ROLLBACK;
5806: RETCODE := G_ERROR;
5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5808: ERRBUF := FND_MESSAGE.get;
5809: l_log_message := FND_MESSAGE.get;
5810: MRP_UTIL.MRP_LOG(l_log_message);
5811: l_log_message := 'Problem in report_update_WOD procedure';
5812: MRP_UTIL.MRP_LOG(l_log_message);

Line 5809: l_log_message := FND_MESSAGE.get;

5805: ROLLBACK;
5806: RETCODE := G_ERROR;
5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5808: ERRBUF := FND_MESSAGE.get;
5809: l_log_message := FND_MESSAGE.get;
5810: MRP_UTIL.MRP_LOG(l_log_message);
5811: l_log_message := 'Problem in report_update_WOD procedure';
5812: MRP_UTIL.MRP_LOG(l_log_message);
5813: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');

5921: l_to_start_time := to_char(l_to_start_date,'SSSSS');
5922: l_to_end_time := to_char(l_to_end_date,'SSSSS');
5923:
5924: -- Print the parameters
5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5926: l_log_message := FND_MESSAGE.get;

5922: l_to_end_time := to_char(l_to_end_date,'SSSSS');
5923:
5924: -- Print the parameters
5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');

Line 5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;

Line 5930: FND_MESSAGE.set_token('NUMBER','1');

5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);

Line 5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');

5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:

Line 5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));

5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5933: l_log_message := FND_MESSAGE.get;

5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');

Line 5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;

Line 5937: FND_MESSAGE.set_token('NUMBER','2');

5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);

Line 5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');

5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:

Line 5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));

5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5940: l_log_message := FND_MESSAGE.get;

5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');

Line 5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;

Line 5944: FND_MESSAGE.set_token('NUMBER','3');

5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);

Line 5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');

5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:

Line 5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105

5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5947: l_log_message := FND_MESSAGE.get;

5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');

Line 5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;

Line 5951: FND_MESSAGE.set_token('NUMBER','4');

5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);

Line 5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');

5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:

Line 5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105

5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5954: l_log_message := FND_MESSAGE.get;

5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');

Line 5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;

Line 5958: FND_MESSAGE.set_token('NUMBER','5');

5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);

Line 5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');

5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:

Line 5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105

5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5961: l_log_message := FND_MESSAGE.get;

5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');

Line 5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;

Line 5965: FND_MESSAGE.set_token('NUMBER','6');

5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);

Line 5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');

5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:

Line 5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105

5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5968: l_log_message := FND_MESSAGE.get;

5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');

Line 5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;

Line 5972: FND_MESSAGE.set_token('NUMBER','7');

5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);

Line 5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');

5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:

Line 5974: FND_MESSAGE.set_token('VALUE',p_from_line);

5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5975: l_log_message := FND_MESSAGE.get;

5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');

Line 5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;

Line 5979: FND_MESSAGE.set_token('NUMBER','8');

5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);

Line 5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');

5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:

Line 5981: FND_MESSAGE.set_token('VALUE',p_to_line);

5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5982: l_log_message := FND_MESSAGE.get;

5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');

Line 5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;

Line 5986: FND_MESSAGE.set_token('NUMBER','9');

5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);

Line 5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');

5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:

Line 5988: FND_MESSAGE.set_token('VALUE',p_from_item);

5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5989: l_log_message := FND_MESSAGE.get;

5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');

Line 5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;

Line 5993: FND_MESSAGE.set_token('NUMBER','10');

5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);

Line 5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');

5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:

Line 5995: FND_MESSAGE.set_token('VALUE',p_to_item);

5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 5996: l_log_message := FND_MESSAGE.get;

5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');

Line 5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;

Line 6000: FND_MESSAGE.set_token('NUMBER','11');

5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);

Line 6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');

5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:

Line 6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));

5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 6003: l_log_message := FND_MESSAGE.get;

5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');

Line 6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;

Line 6007: FND_MESSAGE.set_token('NUMBER','12');

6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);

Line 6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');

6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:

Line 6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));

6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 6010: l_log_message := FND_MESSAGE.get;

6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');

Line 6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;

Line 6014: FND_MESSAGE.set_token('NUMBER','13');

6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);

Line 6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');

6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:

Line 6016: FND_MESSAGE.set_token('VALUE',p_from_category);

6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 6017: l_log_message := FND_MESSAGE.get;

6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');

Line 6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;

Line 6021: FND_MESSAGE.set_token('NUMBER','14');

6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);

Line 6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');

6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:

Line 6023: FND_MESSAGE.set_token('VALUE',p_to_category);

6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

Line 6024: l_log_message := FND_MESSAGE.get;

6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');

Line 6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');

6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;

Line 6028: FND_MESSAGE.set_token('NUMBER','15');

6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);

Line 6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');

6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6033:

Line 6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));

6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6033:
6034: -- Check for mandatory parameters and issue an error message

Line 6031: l_log_message := FND_MESSAGE.get;

6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6033:
6034: -- Check for mandatory parameters and issue an error message
6035: -- if NULL. If line, item or category are null, assume all.

Line 6037: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');

6033:
6034: -- Check for mandatory parameters and issue an error message
6035: -- if NULL. If line, item or category are null, assume all.
6036: IF p_organization_id IS NULL THEN
6037: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
6038: l_log_message := FND_MESSAGE.get;
6039: MRP_UTIL.MRP_LOG(l_log_message);
6040: RAISE expected_error;
6041: END IF;

Line 6038: l_log_message := FND_MESSAGE.get;

6034: -- Check for mandatory parameters and issue an error message
6035: -- if NULL. If line, item or category are null, assume all.
6036: IF p_organization_id IS NULL THEN
6037: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
6038: l_log_message := FND_MESSAGE.get;
6039: MRP_UTIL.MRP_LOG(l_log_message);
6040: RAISE expected_error;
6041: END IF;
6042: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND

Line 6044: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');

6040: RAISE expected_error;
6041: END IF;
6042: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND
6043: (p_spread_qty <> 3) THEN
6044: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
6045: l_log_message := FND_MESSAGE.get;
6046: MRP_UTIL.MRP_LOG(l_log_message);
6047: RAISE expected_error;
6048: END IF;

Line 6045: l_log_message := FND_MESSAGE.get;

6041: END IF;
6042: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND
6043: (p_spread_qty <> 3) THEN
6044: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
6045: l_log_message := FND_MESSAGE.get;
6046: MRP_UTIL.MRP_LOG(l_log_message);
6047: RAISE expected_error;
6048: END IF;
6049: IF p_from_end_date IS NULL AND (p_spread_qty <> 3) THEN

Line 6050: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');

6046: MRP_UTIL.MRP_LOG(l_log_message);
6047: RAISE expected_error;
6048: END IF;
6049: IF p_from_end_date IS NULL AND (p_spread_qty <> 3) THEN
6050: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6051: l_log_message := FND_MESSAGE.get;
6052: MRP_UTIL.MRP_LOG(l_log_message);
6053: RAISE expected_error;
6054: END IF;

Line 6051: l_log_message := FND_MESSAGE.get;

6047: RAISE expected_error;
6048: END IF;
6049: IF p_from_end_date IS NULL AND (p_spread_qty <> 3) THEN
6050: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6051: l_log_message := FND_MESSAGE.get;
6052: MRP_UTIL.MRP_LOG(l_log_message);
6053: RAISE expected_error;
6054: END IF;
6055:

Line 6057: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');

6053: RAISE expected_error;
6054: END IF;
6055:
6056: IF p_to_end_date IS NULL AND (p_spread_qty = 1) THEN
6057: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6058: l_log_message := FND_MESSAGE.get;
6059: MRP_UTIL.MRP_LOG(l_log_message);
6060: RAISE expected_error;
6061: END IF;

Line 6058: l_log_message := FND_MESSAGE.get;

6054: END IF;
6055:
6056: IF p_to_end_date IS NULL AND (p_spread_qty = 1) THEN
6057: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6058: l_log_message := FND_MESSAGE.get;
6059: MRP_UTIL.MRP_LOG(l_log_message);
6060: RAISE expected_error;
6061: END IF;
6062:

Line 6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');

6070: /************** Commented - Bug 2213859 *********************
6071: l_from_end_date := mrp_calendar.next_work_day(p_organization_id,
6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);

Line 6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);

6071: l_from_end_date := mrp_calendar.next_work_day(p_organization_id,
6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6079: END IF;

Line 6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);

6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6079: END IF;
6080: ******************** Comment ends ***********************/

Line 6077: l_log_message := FND_MESSAGE.get;

6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6079: END IF;
6080: ******************** Comment ends ***********************/
6081: END IF;

Line 6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');

6092: instead of l_to_end_date
6093: **/
6094: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_start_date) AND
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);

Line 6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));

6093: **/
6094: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_start_date) AND
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6101: END IF;

Line 6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));

6094: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_start_date) AND
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6101: END IF;
6102:

Line 6099: l_log_message := FND_MESSAGE.get;

6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6101: END IF;
6102:
6103: --bug 3832684: need it also for Spread Evenly wo Details

Line 6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');

6122: --TZ BOM Calendar bug 3832684
6123: l_temp_date := flm_timezone.calendar_to_server(l_temp_date,l_to_end_time);
6124:
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;

Line 6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);

6123: l_temp_date := flm_timezone.calendar_to_server(l_temp_date,l_to_end_time);
6124:
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6131: MRP_UTIL.MRP_LOG(l_log_message);

Line 6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);

6124:
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6131: MRP_UTIL.MRP_LOG(l_log_message);
6132: END IF;

Line 6129: l_log_message := FND_MESSAGE.get;

6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6131: MRP_UTIL.MRP_LOG(l_log_message);
6132: END IF;
6133: --end of fix bug#3170105

Line 6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');

6143: l_to_start_date := mrp_calendar.next_work_day(p_organization_id,
6144: 1, to_date(p_to_start_date, 'YYYY/MM/DD'));
6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);

Line 6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);

6144: 1, to_date(p_to_start_date, 'YYYY/MM/DD'));
6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6152: END IF;

Line 6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);

6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6152: END IF;
6153: END IF;

Line 6150: l_log_message := FND_MESSAGE.get;

6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6152: END IF;
6153: END IF;
6154: ****************************************************************************/

Line 6156: FND_MESSAGE.set_name('MRP','EC_DATE');

6152: END IF;
6153: END IF;
6154: ****************************************************************************/
6155:
6156: FND_MESSAGE.set_name('MRP','EC_DATE');
6157: l_trans_var1 := FND_MESSAGE.get;
6158: SELECT to_char(sysdate)
6159: INTO l_trans_var2
6160: FROM dual;

Line 6157: l_trans_var1 := FND_MESSAGE.get;

6153: END IF;
6154: ****************************************************************************/
6155:
6156: FND_MESSAGE.set_name('MRP','EC_DATE');
6157: l_trans_var1 := FND_MESSAGE.get;
6158: SELECT to_char(sysdate)
6159: INTO l_trans_var2
6160: FROM dual;
6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;

Line 6164: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');

6160: FROM dual;
6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6162: MRP_UTIL.MRP_OUT(l_out_message);
6163:
6164: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');
6165: l_out_message := FND_MESSAGE.get;
6166: MRP_UTIL.MRP_OUT(' '||l_out_message);
6167:
6168: /*-----------------------------------------------------+

Line 6165: l_out_message := FND_MESSAGE.get;

6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6162: MRP_UTIL.MRP_OUT(l_out_message);
6163:
6164: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');
6165: l_out_message := FND_MESSAGE.get;
6166: MRP_UTIL.MRP_OUT(' '||l_out_message);
6167:
6168: /*-----------------------------------------------------+
6169: | Do setup for report by inserting existing records |

Line 6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');

6338:
6339: IF p_output = 2 THEN
6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);

Line 6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);

6339: IF p_output = 2 THEN
6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;

Line 6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);

6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);

Line 6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);

6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE

Line 6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);

6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE
6350: IF l_msg_count > 0 THEN

Line 6347: l_log_message := FND_MESSAGE.get;

6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE
6350: IF l_msg_count > 0 THEN
6351: FOR i in 1..l_msg_count LOOP

Line 6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');

6396: +-----------------------------*/
6397: Update_Quantity(l_wip_entity_id,
6398: l_update_variance);
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);

Line 6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);

6397: Update_Quantity(l_wip_entity_id,
6398: l_update_variance);
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',

Line 6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);

6398: l_update_variance);
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));

Line 6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);

6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;

Line 6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);

6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6408: MRP_UTIL.MRP_LOG(l_log_message);

Line 6405: FND_MESSAGE.set_token('NEW_QTY',

6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6408: MRP_UTIL.MRP_LOG(l_log_message);
6409: END IF;

Line 6407: l_log_message := FND_MESSAGE.get;

6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6408: MRP_UTIL.MRP_LOG(l_log_message);
6409: END IF;
6410: l_update_variance := 0;
6411: ELSIF -(l_update_variance) >= (l_planned_quantity -

Line 6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');

6440: END IF;
6441:
6442: END IF;
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);

Line 6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);

6441:
6442: END IF;
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;

Line 6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);

6442: END IF;
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);

Line 6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);

6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6451: END IF;

Line 6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);

6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6451: END IF;
6452: l_update_variance := l_update_variance +

Line 6449: l_log_message := FND_MESSAGE.get;

6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6451: END IF;
6452: l_update_variance := l_update_variance +
6453: (l_planned_quantity-l_quantity_completed);

Line 6483: FND_MESSAGE.set_name('MRP','MRP_ROLL_SECOND_LOOP');

6479: | then generate an error message to the log |
6480: +---------------------------------------------------------*/
6481: IF l_update_variance < 0 THEN
6482: -- Log what's going on
6483: FND_MESSAGE.set_name('MRP','MRP_ROLL_SECOND_LOOP');
6484: l_log_message := FND_MESSAGE.get;
6485: MRP_UTIL.MRP_LOG(l_log_message);
6486:
6487: OPEN C5(fs_report_rec.line_id, fs_report_rec.primary_item_id,

Line 6484: l_log_message := FND_MESSAGE.get;

6480: +---------------------------------------------------------*/
6481: IF l_update_variance < 0 THEN
6482: -- Log what's going on
6483: FND_MESSAGE.set_name('MRP','MRP_ROLL_SECOND_LOOP');
6484: l_log_message := FND_MESSAGE.get;
6485: MRP_UTIL.MRP_LOG(l_log_message);
6486:
6487: OPEN C5(fs_report_rec.line_id, fs_report_rec.primary_item_id,
6488: l_to_start_date, l_to_end_date); --fix bug#3170105

Line 6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');

6509: Update_Quantity(l_wip_entity_id,
6510: l_update_variance);
6511:
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);

Line 6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);

6510: l_update_variance);
6511:
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',

Line 6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);

6511:
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));

Line 6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);

6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;

Line 6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);

6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6521: END IF;

Line 6518: FND_MESSAGE.set_token('NEW_QTY',

6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6521: END IF;
6522: l_update_variance := 0;

Line 6520: l_log_message := FND_MESSAGE.get;

6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6521: END IF;
6522: l_update_variance := 0;
6523: ELSIF -(l_update_variance) >= (l_planned_quantity -
6524: l_quantity_completed) THEN

Line 6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');

6553: END IF;
6554: END IF;
6555:
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);

Line 6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);

6554: END IF;
6555:
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;

Line 6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);

6555:
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);

Line 6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);

6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6564: END IF;

Line 6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);

6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6564: END IF;
6565: l_update_variance := l_update_variance +

Line 6562: l_log_message := FND_MESSAGE.get;

6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6564: END IF;
6565: l_update_variance := l_update_variance +
6566: (l_planned_quantity-l_quantity_completed);

Line 6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');

6572: | If l_update_variance is still less than zero, print a |
6573: | message to the log. |
6574: +-------------------------------------------------------*/
6575: IF l_update_variance < 0 THEN
6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');
6577: FND_MESSAGE.set_token('QTY',l_update_variance);
6578: l_log_message := FND_MESSAGE.get;
6579: MRP_UTIL.MRP_LOG(l_log_message);
6580: RETCODE := G_WARNING;

Line 6577: FND_MESSAGE.set_token('QTY',l_update_variance);

6573: | message to the log. |
6574: +-------------------------------------------------------*/
6575: IF l_update_variance < 0 THEN
6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');
6577: FND_MESSAGE.set_token('QTY',l_update_variance);
6578: l_log_message := FND_MESSAGE.get;
6579: MRP_UTIL.MRP_LOG(l_log_message);
6580: RETCODE := G_WARNING;
6581: l_update_variance := 0;

Line 6578: l_log_message := FND_MESSAGE.get;

6574: +-------------------------------------------------------*/
6575: IF l_update_variance < 0 THEN
6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');
6577: FND_MESSAGE.set_token('QTY',l_update_variance);
6578: l_log_message := FND_MESSAGE.get;
6579: MRP_UTIL.MRP_LOG(l_log_message);
6580: RETCODE := G_WARNING;
6581: l_update_variance := 0;
6582: END IF;

Line 6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');

6939:
6940: IF p_output = 2 THEN
6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);

Line 6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);

6940: IF p_output = 2 THEN
6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;

Line 6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);

6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);

Line 6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);

6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE

Line 6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);

6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE
6951: IF l_msg_count > 0 THEN

Line 6948: l_log_message := FND_MESSAGE.get;

6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE
6951: IF l_msg_count > 0 THEN
6952: FOR i in 1..l_msg_count LOOP

Line 7108: FND_MESSAGE.set_name('MRP','EC_FROM');

7104: END IF;
7105: IF p_spread_qty = 3 THEN
7106: RETURN;
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');

Line 7109: l_trans_var1 := FND_MESSAGE.get;

7105: IF p_spread_qty = 3 THEN
7106: RETURN;
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;

Line 7110: FND_MESSAGE.set_name('MRP','EC_TO');

7106: RETURN;
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');

Line 7111: l_trans_var2 := FND_MESSAGE.get;

7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;

Line 7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');

7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:

Line 7113: l_trans_var3 := FND_MESSAGE.get;

7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7117: l_out_message := ' ' ||

Line 7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');

7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7117: l_out_message := ' ' ||
7118: rpad(substr(l_trans_var1,1,8),38) || ' ' ||

Line 7115: l_trans_var4 := FND_MESSAGE.get;

7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7117: l_out_message := ' ' ||
7118: rpad(substr(l_trans_var1,1,8),38) || ' ' ||
7119: rpad(substr(l_trans_var2,1,9),9) || ' ' ||

Line 7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');

7120: rpad(substr(l_trans_var3,1,8),8) || ' ' ||
7121: rpad(substr(l_trans_var4,1,8),8);
7122: MRP_UTIL.MRP_OUT(l_out_message);
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');

Line 7125: l_trans_var1 := FND_MESSAGE.get;

7121: rpad(substr(l_trans_var4,1,8),8);
7122: MRP_UTIL.MRP_OUT(l_out_message);
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;

Line 7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');

7122: MRP_UTIL.MRP_OUT(l_out_message);
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');

Line 7127: l_trans_var2 := FND_MESSAGE.get;

7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;

Line 7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');

7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:

Line 7129: l_trans_var3 := FND_MESSAGE.get;

7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7133: l_out_message := ' ' ||

Line 7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');

7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7133: l_out_message := ' ' ||
7134: rpad(substr(l_trans_var1,1,8),8) || ' ' ||

Line 7131: l_trans_var4 := FND_MESSAGE.get;

7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7133: l_out_message := ' ' ||
7134: rpad(substr(l_trans_var1,1,8),8) || ' ' ||
7135: rpad(substr(l_trans_var1,1,9),9) || ' ' ||

Line 7145: FND_MESSAGE.set_name('MRP','EC_LINE');

7141: rpad(substr(l_trans_var4,1,8),8);
7142:
7143: MRP_UTIL.MRP_OUT(l_out_message);
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');

Line 7146: l_trans_var1 := FND_MESSAGE.get;

7142:
7143: MRP_UTIL.MRP_OUT(l_out_message);
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;

Line 7147: FND_MESSAGE.set_name('MRP','EC_ITEM');

7143: MRP_UTIL.MRP_OUT(l_out_message);
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');

Line 7148: l_trans_var2 := FND_MESSAGE.get;

7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;

Line 7149: FND_MESSAGE.set_name('MRP','EC_GROUP');

7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');

Line 7150: l_trans_var3 := FND_MESSAGE.get;

7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;

Line 7151: FND_MESSAGE.set_name('MRP','EC_DATE');

7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');

Line 7152: l_trans_var4 := FND_MESSAGE.get;

7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;

Line 7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');

7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:

Line 7154: l_trans_var5 := FND_MESSAGE.get;

7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7158: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||

Line 7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');

7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7158: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7159: rpad(substr(l_trans_var2,1,14),14) || ' ' ||

Line 7156: l_trans_var6 := FND_MESSAGE.get;

7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7158: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7159: rpad(substr(l_trans_var2,1,14),14) || ' ' ||
7160: rpad(substr(l_trans_var3,1,8),8) || ' ' ||

Line 7225: FND_MESSAGE.set_name('MRP','EC_TOTAL');

7221:
7222: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7223: MRP_UTIL.MRP_OUT(l_out_message);
7224:
7225: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7226: l_out_message := FND_MESSAGE.get;
7227:
7228: l_out_message := rpad(substr(l_out_message,1,8),8) || ' '||
7229: lpad(l_planned_total,9) || ' ' ||

Line 7226: l_out_message := FND_MESSAGE.get;

7222: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7223: MRP_UTIL.MRP_OUT(l_out_message);
7224:
7225: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7226: l_out_message := FND_MESSAGE.get;
7227:
7228: l_out_message := rpad(substr(l_out_message,1,8),8) || ' '||
7229: lpad(l_planned_total,9) || ' ' ||
7230: lpad(l_completed_total,9) || ' ' || lpad(l_variance1_total,8) ||

Line 7242: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');

7238: MRP_UTIL.MRP_OUT(l_out_message);
7239: END IF;
7240:
7241: IF REPORT_CURSOR%NOTFOUND THEN
7242: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');
7243: l_out_message := FND_MESSAGE.get;
7244: MRP_UTIL.MRP_OUT(l_out_message);
7245: EXIT;
7246: END IF;

Line 7243: l_out_message := FND_MESSAGE.get;

7239: END IF;
7240:
7241: IF REPORT_CURSOR%NOTFOUND THEN
7242: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');
7243: l_out_message := FND_MESSAGE.get;
7244: MRP_UTIL.MRP_OUT(l_out_message);
7245: EXIT;
7246: END IF;
7247:

Line 7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

7279: ROLLBACK;
7280: IF RETCODE <> 1 THEN
7281: RETCODE := G_ERROR;
7282: END IF;
7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7284: ERRBUF := FND_MESSAGE.get;
7285: l_log_message := FND_MESSAGE.get;
7286: MRP_UTIL.MRP_LOG(l_log_message);
7287: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 7284: ERRBUF := FND_MESSAGE.get;

7280: IF RETCODE <> 1 THEN
7281: RETCODE := G_ERROR;
7282: END IF;
7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7284: ERRBUF := FND_MESSAGE.get;
7285: l_log_message := FND_MESSAGE.get;
7286: MRP_UTIL.MRP_LOG(l_log_message);
7287: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7288: MRP_UTIL.MRP_LOG(l_log_message);

Line 7285: l_log_message := FND_MESSAGE.get;

7281: RETCODE := G_ERROR;
7282: END IF;
7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7284: ERRBUF := FND_MESSAGE.get;
7285: l_log_message := FND_MESSAGE.get;
7286: MRP_UTIL.MRP_LOG(l_log_message);
7287: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7288: MRP_UTIL.MRP_LOG(l_log_message);
7289:

Line 7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

7289:
7290: WHEN unexpected_error THEN
7291: ROLLBACK;
7292: RETCODE := G_ERROR;
7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7294: ERRBUF := FND_MESSAGE.get;
7295: l_log_message := FND_MESSAGE.get;
7296: MRP_UTIL.MRP_LOG(l_log_message);
7297: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 7294: ERRBUF := FND_MESSAGE.get;

7290: WHEN unexpected_error THEN
7291: ROLLBACK;
7292: RETCODE := G_ERROR;
7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7294: ERRBUF := FND_MESSAGE.get;
7295: l_log_message := FND_MESSAGE.get;
7296: MRP_UTIL.MRP_LOG(l_log_message);
7297: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7298: MRP_UTIL.MRP_LOG(l_log_message);

Line 7295: l_log_message := FND_MESSAGE.get;

7291: ROLLBACK;
7292: RETCODE := G_ERROR;
7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7294: ERRBUF := FND_MESSAGE.get;
7295: l_log_message := FND_MESSAGE.get;
7296: MRP_UTIL.MRP_LOG(l_log_message);
7297: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7298: MRP_UTIL.MRP_LOG(l_log_message);
7299:

Line 7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');

7299:
7300: WHEN OTHERS THEN
7301: ROLLBACK;
7302: RETCODE := G_ERROR;
7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7304: ERRBUF := FND_MESSAGE.get;
7305: l_log_message := FND_MESSAGE.get;
7306: MRP_UTIL.MRP_LOG(l_log_message);
7307: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 7304: ERRBUF := FND_MESSAGE.get;

7300: WHEN OTHERS THEN
7301: ROLLBACK;
7302: RETCODE := G_ERROR;
7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7304: ERRBUF := FND_MESSAGE.get;
7305: l_log_message := FND_MESSAGE.get;
7306: MRP_UTIL.MRP_LOG(l_log_message);
7307: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7308: MRP_UTIL.MRP_LOG(l_log_message);

Line 7305: l_log_message := FND_MESSAGE.get;

7301: ROLLBACK;
7302: RETCODE := G_ERROR;
7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7304: ERRBUF := FND_MESSAGE.get;
7305: l_log_message := FND_MESSAGE.get;
7306: MRP_UTIL.MRP_LOG(l_log_message);
7307: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7308: MRP_UTIL.MRP_LOG(l_log_message);
7309:

Line 7581: FND_MESSAGE.SET_NAME('BOM',l_error_msg);

7577: -- Do nothing, there was just no bill to explode
7578: NULL;
7579: ELSIF l_error_code <> 0 THEN
7580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7581: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7582: FND_MSG_PUB.Add;
7583: END IF;
7584: RAISE FND_API.G_EXC_ERROR;
7585: END IF;