APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3469: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3476: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3483: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3490: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3497: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3504: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3511: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3518: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3525: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3532: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3539: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 3546: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3554: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3560: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3566: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

Line 3722: ERRBUF := FND_MESSAGE.get;

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

Line 3723: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3727: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3737: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3746: ERRBUF := FND_MESSAGE.get;

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

Line 3747: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3754: ERRBUF := FND_MESSAGE.get;

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

Line 3755: l_log_message := FND_MESSAGE.get;

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

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

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

Line 3762: ERRBUF := FND_MESSAGE.get;

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

Line 3763: l_log_message := FND_MESSAGE.get;

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

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

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

Line 4382: ERRBUF := FND_MESSAGE.get;

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

Line 4383: l_log_message := FND_MESSAGE.get;

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

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

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

Line 4559: ERRBUF := FND_MESSAGE.get;

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

Line 4560: l_log_message := FND_MESSAGE.get;

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

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

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

Line 4828: ERRBUF := FND_MESSAGE.get;

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

Line 4829: l_log_message := FND_MESSAGE.get;

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

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

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

Line 4866: ERRBUF := FND_MESSAGE.get;

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

Line 4867: l_log_message := FND_MESSAGE.get;

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

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

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

Line 4910: ERRBUF := FND_MESSAGE.get;

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

Line 4911: l_log_message := FND_MESSAGE.get;

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

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

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

Line 5086: ERRBUF := FND_MESSAGE.get;

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

Line 5087: l_log_message := FND_MESSAGE.get;

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

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

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

Line 5336: ERRBUF := FND_MESSAGE.get;

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

Line 5337: l_log_message := FND_MESSAGE.get;

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

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

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

Line 5560: ERRBUF := FND_MESSAGE.get;

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

Line 5561: l_log_message := FND_MESSAGE.get;

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

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

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

Line 5686: ERRBUF := FND_MESSAGE.get;

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

Line 5687: l_log_message := FND_MESSAGE.get;

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

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

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

Line 5811: ERRBUF := FND_MESSAGE.get;

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

Line 5812: l_log_message := FND_MESSAGE.get;

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

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

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

Line 5929: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5936: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5943: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5950: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5957: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5964: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5971: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5978: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5985: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5992: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 5999: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 6006: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 6013: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 6020: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 6027: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

Line 6034: l_log_message := FND_MESSAGE.get;

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

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

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

Line 6041: l_log_message := FND_MESSAGE.get;

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

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

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

Line 6048: l_log_message := FND_MESSAGE.get;

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

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

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

Line 6054: l_log_message := FND_MESSAGE.get;

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

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

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

Line 6061: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

Line 6080: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

Line 6102: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

Line 6132: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

Line 6153: l_log_message := FND_MESSAGE.get;

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

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

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

Line 6160: l_trans_var1 := FND_MESSAGE.get;

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

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

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

Line 6168: l_out_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

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

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

Line 6350: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

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

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

Line 6408: FND_MESSAGE.set_token('NEW_QTY',

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

Line 6410: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

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

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

Line 6452: l_log_message := FND_MESSAGE.get;

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

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

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

Line 6487: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

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

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

Line 6521: FND_MESSAGE.set_token('NEW_QTY',

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

Line 6523: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

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

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

Line 6565: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

Line 6581: l_log_message := FND_MESSAGE.get;

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

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

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

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

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

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

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

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

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

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

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

Line 6951: l_log_message := FND_MESSAGE.get;

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

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

7129: END IF;
7130: IF p_spread_qty = 3 THEN
7131: RETURN;
7132: END IF;
7133: FND_MESSAGE.set_name('MRP','EC_FROM');
7134: l_trans_var1 := FND_MESSAGE.get;
7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');

Line 7134: l_trans_var1 := FND_MESSAGE.get;

7130: IF p_spread_qty = 3 THEN
7131: RETURN;
7132: END IF;
7133: FND_MESSAGE.set_name('MRP','EC_FROM');
7134: l_trans_var1 := FND_MESSAGE.get;
7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;

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

7131: RETURN;
7132: END IF;
7133: FND_MESSAGE.set_name('MRP','EC_FROM');
7134: l_trans_var1 := FND_MESSAGE.get;
7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;
7139: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');

Line 7136: l_trans_var2 := FND_MESSAGE.get;

7132: END IF;
7133: FND_MESSAGE.set_name('MRP','EC_FROM');
7134: l_trans_var1 := FND_MESSAGE.get;
7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;
7139: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7140: l_trans_var4 := FND_MESSAGE.get;

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

7133: FND_MESSAGE.set_name('MRP','EC_FROM');
7134: l_trans_var1 := FND_MESSAGE.get;
7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;
7139: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7140: l_trans_var4 := FND_MESSAGE.get;
7141:

Line 7138: l_trans_var3 := FND_MESSAGE.get;

7134: l_trans_var1 := FND_MESSAGE.get;
7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;
7139: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7140: l_trans_var4 := FND_MESSAGE.get;
7141:
7142: l_out_message := ' ' ||

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

7135: FND_MESSAGE.set_name('MRP','EC_TO');
7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;
7139: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7140: l_trans_var4 := FND_MESSAGE.get;
7141:
7142: l_out_message := ' ' ||
7143: rpad(substr(l_trans_var1,1,8),38) || ' ' ||

Line 7140: l_trans_var4 := FND_MESSAGE.get;

7136: l_trans_var2 := FND_MESSAGE.get;
7137: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7138: l_trans_var3 := FND_MESSAGE.get;
7139: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7140: l_trans_var4 := FND_MESSAGE.get;
7141:
7142: l_out_message := ' ' ||
7143: rpad(substr(l_trans_var1,1,8),38) || ' ' ||
7144: rpad(substr(l_trans_var2,1,9),9) || ' ' ||

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

7145: rpad(substr(l_trans_var3,1,8),8) || ' ' ||
7146: rpad(substr(l_trans_var4,1,8),8);
7147: MRP_UTIL.MRP_OUT(l_out_message);
7148:
7149: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7150: l_trans_var1 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');

Line 7150: l_trans_var1 := FND_MESSAGE.get;

7146: rpad(substr(l_trans_var4,1,8),8);
7147: MRP_UTIL.MRP_OUT(l_out_message);
7148:
7149: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7150: l_trans_var1 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;

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

7147: MRP_UTIL.MRP_OUT(l_out_message);
7148:
7149: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7150: l_trans_var1 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');

Line 7152: l_trans_var2 := FND_MESSAGE.get;

7148:
7149: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7150: l_trans_var1 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7156: l_trans_var4 := FND_MESSAGE.get;

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

7149: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7150: l_trans_var1 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7156: l_trans_var4 := FND_MESSAGE.get;
7157:

Line 7154: l_trans_var3 := FND_MESSAGE.get;

7150: l_trans_var1 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7156: l_trans_var4 := FND_MESSAGE.get;
7157:
7158: l_out_message := ' ' ||

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

7151: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7156: l_trans_var4 := FND_MESSAGE.get;
7157:
7158: l_out_message := ' ' ||
7159: rpad(substr(l_trans_var1,1,8),8) || ' ' ||

Line 7156: l_trans_var4 := FND_MESSAGE.get;

7152: l_trans_var2 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7154: l_trans_var3 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7156: l_trans_var4 := FND_MESSAGE.get;
7157:
7158: l_out_message := ' ' ||
7159: rpad(substr(l_trans_var1,1,8),8) || ' ' ||
7160: rpad(substr(l_trans_var1,1,9),9) || ' ' ||

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

7166: rpad(substr(l_trans_var4,1,8),8);
7167:
7168: MRP_UTIL.MRP_OUT(l_out_message);
7169:
7170: FND_MESSAGE.set_name('MRP','EC_LINE');
7171: l_trans_var1 := FND_MESSAGE.get;
7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');

Line 7171: l_trans_var1 := FND_MESSAGE.get;

7167:
7168: MRP_UTIL.MRP_OUT(l_out_message);
7169:
7170: FND_MESSAGE.set_name('MRP','EC_LINE');
7171: l_trans_var1 := FND_MESSAGE.get;
7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;

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

7168: MRP_UTIL.MRP_OUT(l_out_message);
7169:
7170: FND_MESSAGE.set_name('MRP','EC_LINE');
7171: l_trans_var1 := FND_MESSAGE.get;
7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');

Line 7173: l_trans_var2 := FND_MESSAGE.get;

7169:
7170: FND_MESSAGE.set_name('MRP','EC_LINE');
7171: l_trans_var1 := FND_MESSAGE.get;
7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;

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

7170: FND_MESSAGE.set_name('MRP','EC_LINE');
7171: l_trans_var1 := FND_MESSAGE.get;
7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');

Line 7175: l_trans_var3 := FND_MESSAGE.get;

7171: l_trans_var1 := FND_MESSAGE.get;
7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;

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

7172: FND_MESSAGE.set_name('MRP','EC_ITEM');
7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;
7180: FND_MESSAGE.set_name('MRP','EC_VARIANCE');

Line 7177: l_trans_var4 := FND_MESSAGE.get;

7173: l_trans_var2 := FND_MESSAGE.get;
7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;
7180: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7181: l_trans_var6 := FND_MESSAGE.get;

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

7174: FND_MESSAGE.set_name('MRP','EC_GROUP');
7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;
7180: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7181: l_trans_var6 := FND_MESSAGE.get;
7182:

Line 7179: l_trans_var5 := FND_MESSAGE.get;

7175: l_trans_var3 := FND_MESSAGE.get;
7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;
7180: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7181: l_trans_var6 := FND_MESSAGE.get;
7182:
7183: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||

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

7176: FND_MESSAGE.set_name('MRP','EC_DATE');
7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;
7180: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7181: l_trans_var6 := FND_MESSAGE.get;
7182:
7183: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7184: rpad(substr(l_trans_var2,1,14),14) || ' ' ||

Line 7181: l_trans_var6 := FND_MESSAGE.get;

7177: l_trans_var4 := FND_MESSAGE.get;
7178: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7179: l_trans_var5 := FND_MESSAGE.get;
7180: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7181: l_trans_var6 := FND_MESSAGE.get;
7182:
7183: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7184: rpad(substr(l_trans_var2,1,14),14) || ' ' ||
7185: rpad(substr(l_trans_var3,1,8),8) || ' ' ||

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

7246:
7247: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7248: MRP_UTIL.MRP_OUT(l_out_message);
7249:
7250: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7251: l_out_message := FND_MESSAGE.get;
7252:
7253: l_out_message := rpad(substr(l_out_message,1,8),8) || ' '||
7254: lpad(l_planned_total,9) || ' ' ||

Line 7251: l_out_message := FND_MESSAGE.get;

7247: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7248: MRP_UTIL.MRP_OUT(l_out_message);
7249:
7250: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7251: l_out_message := FND_MESSAGE.get;
7252:
7253: l_out_message := rpad(substr(l_out_message,1,8),8) || ' '||
7254: lpad(l_planned_total,9) || ' ' ||
7255: lpad(l_completed_total,9) || ' ' || lpad(l_variance1_total,8) ||

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

7263: MRP_UTIL.MRP_OUT(l_out_message);
7264: END IF;
7265:
7266: IF REPORT_CURSOR%NOTFOUND THEN
7267: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');
7268: l_out_message := FND_MESSAGE.get;
7269: MRP_UTIL.MRP_OUT(l_out_message);
7270: EXIT;
7271: END IF;

Line 7268: l_out_message := FND_MESSAGE.get;

7264: END IF;
7265:
7266: IF REPORT_CURSOR%NOTFOUND THEN
7267: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');
7268: l_out_message := FND_MESSAGE.get;
7269: MRP_UTIL.MRP_OUT(l_out_message);
7270: EXIT;
7271: END IF;
7272:

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

7304: ROLLBACK;
7305: IF RETCODE <> 1 THEN
7306: RETCODE := G_ERROR;
7307: END IF;
7308: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7309: ERRBUF := FND_MESSAGE.get;
7310: l_log_message := FND_MESSAGE.get;
7311: MRP_UTIL.MRP_LOG(l_log_message);
7312: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 7309: ERRBUF := FND_MESSAGE.get;

7305: IF RETCODE <> 1 THEN
7306: RETCODE := G_ERROR;
7307: END IF;
7308: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7309: ERRBUF := FND_MESSAGE.get;
7310: l_log_message := FND_MESSAGE.get;
7311: MRP_UTIL.MRP_LOG(l_log_message);
7312: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7313: MRP_UTIL.MRP_LOG(l_log_message);

Line 7310: l_log_message := FND_MESSAGE.get;

7306: RETCODE := G_ERROR;
7307: END IF;
7308: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7309: ERRBUF := FND_MESSAGE.get;
7310: l_log_message := FND_MESSAGE.get;
7311: MRP_UTIL.MRP_LOG(l_log_message);
7312: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7313: MRP_UTIL.MRP_LOG(l_log_message);
7314:

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

7314:
7315: WHEN unexpected_error THEN
7316: ROLLBACK;
7317: RETCODE := G_ERROR;
7318: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7319: ERRBUF := FND_MESSAGE.get;
7320: l_log_message := FND_MESSAGE.get;
7321: MRP_UTIL.MRP_LOG(l_log_message);
7322: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 7319: ERRBUF := FND_MESSAGE.get;

7315: WHEN unexpected_error THEN
7316: ROLLBACK;
7317: RETCODE := G_ERROR;
7318: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7319: ERRBUF := FND_MESSAGE.get;
7320: l_log_message := FND_MESSAGE.get;
7321: MRP_UTIL.MRP_LOG(l_log_message);
7322: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7323: MRP_UTIL.MRP_LOG(l_log_message);

Line 7320: l_log_message := FND_MESSAGE.get;

7316: ROLLBACK;
7317: RETCODE := G_ERROR;
7318: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7319: ERRBUF := FND_MESSAGE.get;
7320: l_log_message := FND_MESSAGE.get;
7321: MRP_UTIL.MRP_LOG(l_log_message);
7322: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7323: MRP_UTIL.MRP_LOG(l_log_message);
7324:

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

7324:
7325: WHEN OTHERS THEN
7326: ROLLBACK;
7327: RETCODE := G_ERROR;
7328: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7329: ERRBUF := FND_MESSAGE.get;
7330: l_log_message := FND_MESSAGE.get;
7331: MRP_UTIL.MRP_LOG(l_log_message);
7332: l_log_message := 'Unexpected SQL Error: '||sqlerrm;

Line 7329: ERRBUF := FND_MESSAGE.get;

7325: WHEN OTHERS THEN
7326: ROLLBACK;
7327: RETCODE := G_ERROR;
7328: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7329: ERRBUF := FND_MESSAGE.get;
7330: l_log_message := FND_MESSAGE.get;
7331: MRP_UTIL.MRP_LOG(l_log_message);
7332: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7333: MRP_UTIL.MRP_LOG(l_log_message);

Line 7330: l_log_message := FND_MESSAGE.get;

7326: ROLLBACK;
7327: RETCODE := G_ERROR;
7328: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7329: ERRBUF := FND_MESSAGE.get;
7330: l_log_message := FND_MESSAGE.get;
7331: MRP_UTIL.MRP_LOG(l_log_message);
7332: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7333: MRP_UTIL.MRP_LOG(l_log_message);
7334:

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

7604: ELSIF l_error_code = 9996 THEN --Bug 10282308. No Exception when it's already being exploded in another session.
7605: NULL;
7606: ELSIF l_error_code <> 0 THEN
7607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7608: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7609: FND_MSG_PUB.Add;
7610: END IF;
7611: RAISE FND_API.G_EXC_ERROR;
7612: END IF;