2585:
2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2587: THEN
2588:
2589: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_CHANGED');
2590: FND_MSG_PUB.Add;
2591:
2592: END IF;
2593:
2602:
2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:
2606: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_DELETED');
2607: FND_MSG_PUB.Add;
2608:
2609: END IF;
2610: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2614:
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2616: THEN
2617:
2618: FND_MESSAGE.SET_NAME('MRP','MRP_LOCK_ROW_ALREADY_LOCKED');
2619: FND_MSG_PUB.Add;
2620:
2621: END IF;
2622: WHEN OTHERS THEN
2755:
2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2757: THEN
2758:
2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
2761: FND_MSG_PUB.Add;
2762:
2763: END IF;
2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2757: THEN
2758:
2759: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2760: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','completion_locator');
2761: FND_MSG_PUB.Add;
2762:
2763: END IF;
2764:
2785:
2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2787: THEN
2788:
2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
2791: FND_MSG_PUB.Add;
2792:
2793: END IF;
2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2787: THEN
2788:
2789: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
2791: FND_MSG_PUB.Add;
2792:
2793: END IF;
2794:
2815:
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2821: FND_MSG_PUB.Add;
2822:
2823: END IF;
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2817: THEN
2818:
2819: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2821: FND_MSG_PUB.Add;
2822:
2823: END IF;
2824:
2845:
2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2847: THEN
2848:
2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
2851: FND_MSG_PUB.Add;
2852:
2853: END IF;
2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2847: THEN
2848:
2849: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_item');
2851: FND_MSG_PUB.Add;
2852:
2853: END IF;
2854:
2875:
2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2877: THEN
2878:
2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2881: FND_MSG_PUB.Add;
2882:
2883: END IF;
2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2877: THEN
2878:
2879: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2880: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
2881: FND_MSG_PUB.Add;
2882:
2883: END IF;
2884:
2905:
2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2907: THEN
2908:
2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
2911: FND_MSG_PUB.Add;
2912:
2913: END IF;
2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2907: THEN
2908:
2909: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','schedule_group');
2911: FND_MSG_PUB.Add;
2912:
2913: END IF;
2914:
2935:
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2937: THEN
2938:
2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2941: FND_MSG_PUB.Add;
2942:
2943: END IF;
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2937: THEN
2938:
2939: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
2941: FND_MSG_PUB.Add;
2942:
2943: END IF;
2944:
2965:
2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2967: THEN
2968:
2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
2971: FND_MSG_PUB.Add;
2972:
2973: END IF;
2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2967: THEN
2968:
2969: FND_MESSAGE.SET_NAME('MRP','MRP_BOTH_VAL_AND_ID_EXIST');
2970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','wip_entity');
2971: FND_MSG_PUB.Add;
2972:
2973: END IF;
2974:
3461: fnd_date.canonical_to_date(p_end_date));
3462: --end of fix bug#3170105
3463:
3464: -- Print report parameters
3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3462: --end of fix bug#3170105
3463:
3464: -- Print report parameters
3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3465: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3466: l_log_message := FND_MESSAGE.get;
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3467: MRP_UTIL.MRP_LOG(l_log_message);
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3468:
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3469: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3470: FND_MESSAGE.set_token('NUMBER','1');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3472: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3473: l_log_message := FND_MESSAGE.get;
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3474: MRP_UTIL.MRP_LOG(l_log_message);
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3475:
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3476: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3477: FND_MESSAGE.set_token('NUMBER','2');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3479: FND_MESSAGE.set_token('VALUE',to_char(l_start_date)); --fix bug#3170105
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3480: l_log_message := FND_MESSAGE.get;
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3481: MRP_UTIL.MRP_LOG(l_log_message);
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3482:
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3483: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3484: FND_MESSAGE.set_token('NUMBER','3');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3486: FND_MESSAGE.set_token('VALUE',to_char(l_end_date)); --fix bug#3170105
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3487: l_log_message := FND_MESSAGE.get;
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3488: MRP_UTIL.MRP_LOG(l_log_message);
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3489:
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3490: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3491: FND_MESSAGE.set_token('NUMBER','4');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3493: FND_MESSAGE.set_token('VALUE',p_from_line);
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3494: l_log_message := FND_MESSAGE.get;
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3495: MRP_UTIL.MRP_LOG(l_log_message);
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3496:
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3497: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3498: FND_MESSAGE.set_token('NUMBER','5');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3500: FND_MESSAGE.set_token('VALUE',p_to_line);
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3501: l_log_message := FND_MESSAGE.get;
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3502: MRP_UTIL.MRP_LOG(l_log_message);
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3503:
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3504: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3505: FND_MESSAGE.set_token('NUMBER','6');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3507: FND_MESSAGE.set_token('VALUE',p_from_item);
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3508: l_log_message := FND_MESSAGE.get;
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3509: MRP_UTIL.MRP_LOG(l_log_message);
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3510:
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3511: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3512: FND_MESSAGE.set_token('NUMBER','7');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3514: FND_MESSAGE.set_token('VALUE',p_to_item);
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3515: l_log_message := FND_MESSAGE.get;
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3516: MRP_UTIL.MRP_LOG(l_log_message);
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3517:
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3518: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3519: FND_MESSAGE.set_token('NUMBER','8');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3521: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3522: l_log_message := FND_MESSAGE.get;
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3523: MRP_UTIL.MRP_LOG(l_log_message);
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3524:
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3525: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3526: FND_MESSAGE.set_token('NUMBER','9');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3528: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3529: l_log_message := FND_MESSAGE.get;
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3530: MRP_UTIL.MRP_LOG(l_log_message);
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3531:
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3532: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3533: FND_MESSAGE.set_token('NUMBER','10');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3535: FND_MESSAGE.set_token('VALUE',p_from_category);
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3536: l_log_message := FND_MESSAGE.get;
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3537: MRP_UTIL.MRP_LOG(l_log_message);
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3545:
3538:
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3545:
3546: -- Check for mandatory parameters and issue an error message
3539: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
3540: FND_MESSAGE.set_token('NUMBER','11');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3542: FND_MESSAGE.set_token('VALUE',p_to_category);
3543: l_log_message := FND_MESSAGE.get;
3544: MRP_UTIL.MRP_LOG(l_log_message);
3545:
3546: -- Check for mandatory parameters and issue an error message
3547: -- Check for mandatory parameters and issue an error message
3546: -- Check for mandatory parameters and issue an error message
3547: -- Check for mandatory parameters and issue an error message
3548: -- if NULL. If line, item or category are null, assume all.
3549: IF p_organization_id IS NULL THEN
3550: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
3551: l_log_message := FND_MESSAGE.get;
3552: MRP_UTIL.MRP_LOG(l_log_message);
3553: RAISE expected_error;
3554: END IF;
3547: -- Check for mandatory parameters and issue an error message
3548: -- if NULL. If line, item or category are null, assume all.
3549: IF p_organization_id IS NULL THEN
3550: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
3551: l_log_message := FND_MESSAGE.get;
3552: MRP_UTIL.MRP_LOG(l_log_message);
3553: RAISE expected_error;
3554: END IF;
3555: IF p_start_date IS NULL THEN
3552: MRP_UTIL.MRP_LOG(l_log_message);
3553: RAISE expected_error;
3554: END IF;
3555: IF p_start_date IS NULL THEN
3556: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
3557: l_log_message := FND_MESSAGE.get;
3558: MRP_UTIL.MRP_LOG(l_log_message);
3559: RAISE expected_error;
3560: END IF;
3553: RAISE expected_error;
3554: END IF;
3555: IF p_start_date IS NULL THEN
3556: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
3557: l_log_message := FND_MESSAGE.get;
3558: MRP_UTIL.MRP_LOG(l_log_message);
3559: RAISE expected_error;
3560: END IF;
3561: IF p_end_date IS NULL THEN
3558: MRP_UTIL.MRP_LOG(l_log_message);
3559: RAISE expected_error;
3560: END IF;
3561: IF p_end_date IS NULL THEN
3562: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
3563: l_log_message := FND_MESSAGE.get;
3564: MRP_UTIL.MRP_LOG(l_log_message);
3565: RAISE expected_error;
3566: END IF;
3559: RAISE expected_error;
3560: END IF;
3561: IF p_end_date IS NULL THEN
3562: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
3563: l_log_message := FND_MESSAGE.get;
3564: MRP_UTIL.MRP_LOG(l_log_message);
3565: RAISE expected_error;
3566: END IF;
3567:
3713:
3714: -- close the cursor
3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3714: -- close the cursor
3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3724: l_log_message := FND_MESSAGE.get;
3719: ERRBUF := FND_MESSAGE.get;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3724: l_log_message := FND_MESSAGE.get;
3725: MRP_UTIL.MRP_LOG(l_log_message);
3726:
3727: RETCODE := G_SUCCESS;
3720: l_log_message := FND_MESSAGE.get;
3721: MRP_UTIL.MRP_LOG(l_log_message);
3722:
3723: FND_MESSAGE.set_name('MRP','MRP_FLOW_DELETE');
3724: l_log_message := FND_MESSAGE.get;
3725: MRP_UTIL.MRP_LOG(l_log_message);
3726:
3727: RETCODE := G_SUCCESS;
3728:
3729: EXCEPTION
3730: WHEN NO_DATA_FOUND THEN
3731: ROLLBACK;
3732: RETCODE := G_WARNING;
3733: FND_MESSAGE.set_name('MRP','MRP_NO_FLOW_DELETED');
3734: l_log_message := FND_MESSAGE.get;
3735: MRP_UTIL.MRP_LOG(l_log_message);
3736:
3737: WHEN expected_error THEN
3730: WHEN NO_DATA_FOUND THEN
3731: ROLLBACK;
3732: RETCODE := G_WARNING;
3733: FND_MESSAGE.set_name('MRP','MRP_NO_FLOW_DELETED');
3734: l_log_message := FND_MESSAGE.get;
3735: MRP_UTIL.MRP_LOG(l_log_message);
3736:
3737: WHEN expected_error THEN
3738: ROLLBACK;
3738: ROLLBACK;
3739: IF RETCODE <> 1 THEN
3740: RETCODE := G_ERROR;
3741: END IF;
3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3743: ERRBUF := FND_MESSAGE.get;
3744: l_log_message := FND_MESSAGE.get;
3745: MRP_UTIL.MRP_LOG(l_log_message);
3746:
3739: IF RETCODE <> 1 THEN
3740: RETCODE := G_ERROR;
3741: END IF;
3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3743: ERRBUF := FND_MESSAGE.get;
3744: l_log_message := FND_MESSAGE.get;
3745: MRP_UTIL.MRP_LOG(l_log_message);
3746:
3747: WHEN unexpected_error THEN
3740: RETCODE := G_ERROR;
3741: END IF;
3742: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3743: ERRBUF := FND_MESSAGE.get;
3744: l_log_message := FND_MESSAGE.get;
3745: MRP_UTIL.MRP_LOG(l_log_message);
3746:
3747: WHEN unexpected_error THEN
3748: ROLLBACK;
3746:
3747: WHEN unexpected_error THEN
3748: ROLLBACK;
3749: RETCODE := G_ERROR;
3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3751: ERRBUF := FND_MESSAGE.get;
3752: l_log_message := FND_MESSAGE.get;
3753: MRP_UTIL.MRP_LOG(l_log_message);
3754:
3747: WHEN unexpected_error THEN
3748: ROLLBACK;
3749: RETCODE := G_ERROR;
3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3751: ERRBUF := FND_MESSAGE.get;
3752: l_log_message := FND_MESSAGE.get;
3753: MRP_UTIL.MRP_LOG(l_log_message);
3754:
3755: WHEN OTHERS THEN
3748: ROLLBACK;
3749: RETCODE := G_ERROR;
3750: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3751: ERRBUF := FND_MESSAGE.get;
3752: l_log_message := FND_MESSAGE.get;
3753: MRP_UTIL.MRP_LOG(l_log_message);
3754:
3755: WHEN OTHERS THEN
3756: ROLLBACK;
3754:
3755: WHEN OTHERS THEN
3756: ROLLBACK;
3757: RETCODE := G_ERROR;
3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3759: ERRBUF := FND_MESSAGE.get;
3760: l_log_message := FND_MESSAGE.get;
3761: MRP_UTIL.MRP_LOG(l_log_message);
3762: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
3755: WHEN OTHERS THEN
3756: ROLLBACK;
3757: RETCODE := G_ERROR;
3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3759: ERRBUF := FND_MESSAGE.get;
3760: l_log_message := FND_MESSAGE.get;
3761: MRP_UTIL.MRP_LOG(l_log_message);
3762: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
3763: MRP_UTIL.MRP_LOG(l_log_message);
3756: ROLLBACK;
3757: RETCODE := G_ERROR;
3758: FND_MESSAGE.set_name('MRP','MRP_DELETE_FLOW_ERROR');
3759: ERRBUF := FND_MESSAGE.get;
3760: l_log_message := FND_MESSAGE.get;
3761: MRP_UTIL.MRP_LOG(l_log_message);
3762: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
3763: MRP_UTIL.MRP_LOG(l_log_message);
3764:
4374: return(l_cursor_name);
4375: EXCEPTION
4376: WHEN NO_DATA_FOUND THEN
4377: RETCODE := G_ERROR;
4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4379: ERRBUF := FND_MESSAGE.get;
4380: l_log_message := FND_MESSAGE.get;
4381: MRP_UTIL.MRP_LOG(l_log_message);
4382: RETURN NULL;
4375: EXCEPTION
4376: WHEN NO_DATA_FOUND THEN
4377: RETCODE := G_ERROR;
4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4379: ERRBUF := FND_MESSAGE.get;
4380: l_log_message := FND_MESSAGE.get;
4381: MRP_UTIL.MRP_LOG(l_log_message);
4382: RETURN NULL;
4383:
4376: WHEN NO_DATA_FOUND THEN
4377: RETCODE := G_ERROR;
4378: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4379: ERRBUF := FND_MESSAGE.get;
4380: l_log_message := FND_MESSAGE.get;
4381: MRP_UTIL.MRP_LOG(l_log_message);
4382: RETURN NULL;
4383:
4384: WHEN OTHERS THEN
4551:
4552: WHEN NO_DATA_FOUND THEN
4553:
4554: RETCODE := G_ERROR;
4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4556: ERRBUF := FND_MESSAGE.get;
4557: l_log_message := FND_MESSAGE.get;
4558: MRP_UTIL.MRP_LOG(l_log_message);
4559:
4552: WHEN NO_DATA_FOUND THEN
4553:
4554: RETCODE := G_ERROR;
4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4556: ERRBUF := FND_MESSAGE.get;
4557: l_log_message := FND_MESSAGE.get;
4558: MRP_UTIL.MRP_LOG(l_log_message);
4559:
4560: RETURN NULL;
4553:
4554: RETCODE := G_ERROR;
4555: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4556: ERRBUF := FND_MESSAGE.get;
4557: l_log_message := FND_MESSAGE.get;
4558: MRP_UTIL.MRP_LOG(l_log_message);
4559:
4560: RETURN NULL;
4561:
4820:
4821: WHEN NO_DATA_FOUND THEN
4822:
4823: RETCODE := G_ERROR;
4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4825: ERRBUF := FND_MESSAGE.get;
4826: l_log_message := FND_MESSAGE.get;
4827: MRP_UTIL.MRP_LOG(l_log_message);
4828:
4821: WHEN NO_DATA_FOUND THEN
4822:
4823: RETCODE := G_ERROR;
4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4825: ERRBUF := FND_MESSAGE.get;
4826: l_log_message := FND_MESSAGE.get;
4827: MRP_UTIL.MRP_LOG(l_log_message);
4828:
4829: RETURN NULL;
4822:
4823: RETCODE := G_ERROR;
4824: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4825: ERRBUF := FND_MESSAGE.get;
4826: l_log_message := FND_MESSAGE.get;
4827: MRP_UTIL.MRP_LOG(l_log_message);
4828:
4829: RETURN NULL;
4830:
4858:
4859: WHEN NO_DATA_FOUND THEN
4860:
4861: RETCODE := G_ERROR;
4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4863: ERRBUF := FND_MESSAGE.get;
4864: l_log_message := FND_MESSAGE.get;
4865: MRP_UTIL.MRP_LOG(l_log_message);
4866:
4859: WHEN NO_DATA_FOUND THEN
4860:
4861: RETCODE := G_ERROR;
4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4863: ERRBUF := FND_MESSAGE.get;
4864: l_log_message := FND_MESSAGE.get;
4865: MRP_UTIL.MRP_LOG(l_log_message);
4866:
4867: RETURN FALSE;
4860:
4861: RETCODE := G_ERROR;
4862: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4863: ERRBUF := FND_MESSAGE.get;
4864: l_log_message := FND_MESSAGE.get;
4865: MRP_UTIL.MRP_LOG(l_log_message);
4866:
4867: RETURN FALSE;
4868:
4902:
4903: WHEN NO_DATA_FOUND THEN
4904:
4905: RETCODE := G_ERROR;
4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4907: ERRBUF := FND_MESSAGE.get;
4908: l_log_message := FND_MESSAGE.get;
4909: MRP_UTIL.MRP_LOG(l_log_message);
4910:
4903: WHEN NO_DATA_FOUND THEN
4904:
4905: RETCODE := G_ERROR;
4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4907: ERRBUF := FND_MESSAGE.get;
4908: l_log_message := FND_MESSAGE.get;
4909: MRP_UTIL.MRP_LOG(l_log_message);
4910:
4911: RETURN FALSE;
4904:
4905: RETCODE := G_ERROR;
4906: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
4907: ERRBUF := FND_MESSAGE.get;
4908: l_log_message := FND_MESSAGE.get;
4909: MRP_UTIL.MRP_LOG(l_log_message);
4910:
4911: RETURN FALSE;
4912:
5078:
5079: WHEN NO_DATA_FOUND THEN
5080:
5081: RETCODE := G_ERROR;
5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
5083: ERRBUF := FND_MESSAGE.get;
5084: l_log_message := FND_MESSAGE.get;
5085: MRP_UTIL.MRP_LOG(l_log_message);
5086:
5079: WHEN NO_DATA_FOUND THEN
5080:
5081: RETCODE := G_ERROR;
5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
5083: ERRBUF := FND_MESSAGE.get;
5084: l_log_message := FND_MESSAGE.get;
5085: MRP_UTIL.MRP_LOG(l_log_message);
5086:
5087: RETURN NULL;
5080:
5081: RETCODE := G_ERROR;
5082: FND_MESSAGE.set_name('MRP','MRP_NO_ROLL_RECORDS');
5083: ERRBUF := FND_MESSAGE.get;
5084: l_log_message := FND_MESSAGE.get;
5085: MRP_UTIL.MRP_LOG(l_log_message);
5086:
5087: RETURN NULL;
5088:
5328:
5329: WHEN OTHERS THEN
5330: ROLLBACK;
5331: RETCODE := G_ERROR;
5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5333: ERRBUF := FND_MESSAGE.get;
5334: l_log_message := FND_MESSAGE.get;
5335: MRP_UTIL.MRP_LOG(l_log_message);
5336: l_log_message := 'Problem with initialize_report procedure';
5329: WHEN OTHERS THEN
5330: ROLLBACK;
5331: RETCODE := G_ERROR;
5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5333: ERRBUF := FND_MESSAGE.get;
5334: l_log_message := FND_MESSAGE.get;
5335: MRP_UTIL.MRP_LOG(l_log_message);
5336: l_log_message := 'Problem with initialize_report procedure';
5337: MRP_UTIL.MRP_LOG(l_log_message);
5330: ROLLBACK;
5331: RETCODE := G_ERROR;
5332: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5333: ERRBUF := FND_MESSAGE.get;
5334: l_log_message := FND_MESSAGE.get;
5335: MRP_UTIL.MRP_LOG(l_log_message);
5336: l_log_message := 'Problem with initialize_report procedure';
5337: MRP_UTIL.MRP_LOG(l_log_message);
5338: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5552:
5553: WHEN OTHERS THEN
5554: ROLLBACK;
5555: RETCODE := G_ERROR;
5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5557: ERRBUF := FND_MESSAGE.get;
5558: l_log_message := FND_MESSAGE.get;
5559: MRP_UTIL.MRP_LOG(l_log_message);
5560: l_log_message := 'Problem with initialize_report procedure';
5553: WHEN OTHERS THEN
5554: ROLLBACK;
5555: RETCODE := G_ERROR;
5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5557: ERRBUF := FND_MESSAGE.get;
5558: l_log_message := FND_MESSAGE.get;
5559: MRP_UTIL.MRP_LOG(l_log_message);
5560: l_log_message := 'Problem with initialize_report procedure';
5561: MRP_UTIL.MRP_LOG(l_log_message);
5554: ROLLBACK;
5555: RETCODE := G_ERROR;
5556: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5557: ERRBUF := FND_MESSAGE.get;
5558: l_log_message := FND_MESSAGE.get;
5559: MRP_UTIL.MRP_LOG(l_log_message);
5560: l_log_message := 'Problem with initialize_report procedure';
5561: MRP_UTIL.MRP_LOG(l_log_message);
5562: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5678: NULL;
5679: WHEN OTHERS THEN
5680: ROLLBACK;
5681: RETCODE := G_ERROR;
5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5683: ERRBUF := FND_MESSAGE.get;
5684: l_log_message := FND_MESSAGE.get;
5685: MRP_UTIL.MRP_LOG(l_log_message);
5686: l_log_message := 'Problem in report_update_WD procedure';
5679: WHEN OTHERS THEN
5680: ROLLBACK;
5681: RETCODE := G_ERROR;
5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5683: ERRBUF := FND_MESSAGE.get;
5684: l_log_message := FND_MESSAGE.get;
5685: MRP_UTIL.MRP_LOG(l_log_message);
5686: l_log_message := 'Problem in report_update_WD procedure';
5687: MRP_UTIL.MRP_LOG(l_log_message);
5680: ROLLBACK;
5681: RETCODE := G_ERROR;
5682: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5683: ERRBUF := FND_MESSAGE.get;
5684: l_log_message := FND_MESSAGE.get;
5685: MRP_UTIL.MRP_LOG(l_log_message);
5686: l_log_message := 'Problem in report_update_WD procedure';
5687: MRP_UTIL.MRP_LOG(l_log_message);
5688: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5803: WHEN OTHERS THEN
5804:
5805: ROLLBACK;
5806: RETCODE := G_ERROR;
5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5808: ERRBUF := FND_MESSAGE.get;
5809: l_log_message := FND_MESSAGE.get;
5810: MRP_UTIL.MRP_LOG(l_log_message);
5811: l_log_message := 'Problem in report_update_WOD procedure';
5804:
5805: ROLLBACK;
5806: RETCODE := G_ERROR;
5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5808: ERRBUF := FND_MESSAGE.get;
5809: l_log_message := FND_MESSAGE.get;
5810: MRP_UTIL.MRP_LOG(l_log_message);
5811: l_log_message := 'Problem in report_update_WOD procedure';
5812: MRP_UTIL.MRP_LOG(l_log_message);
5805: ROLLBACK;
5806: RETCODE := G_ERROR;
5807: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
5808: ERRBUF := FND_MESSAGE.get;
5809: l_log_message := FND_MESSAGE.get;
5810: MRP_UTIL.MRP_LOG(l_log_message);
5811: l_log_message := 'Problem in report_update_WOD procedure';
5812: MRP_UTIL.MRP_LOG(l_log_message);
5813: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5921: l_to_start_time := to_char(l_to_start_date,'SSSSS');
5922: l_to_end_time := to_char(l_to_end_date,'SSSSS');
5923:
5924: -- Print the parameters
5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5922: l_to_end_time := to_char(l_to_end_date,'SSSSS');
5923:
5924: -- Print the parameters
5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5925: FND_MESSAGE.set_name('MRP','EC_REPORT_PARAMETERS');
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5926: l_log_message := FND_MESSAGE.get;
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5927: MRP_UTIL.MRP_LOG(l_log_message);
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5928:
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5929: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5930: FND_MESSAGE.set_token('NUMBER','1');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5932: FND_MESSAGE.set_token('VALUE',to_char(p_organization_id));
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5933: l_log_message := FND_MESSAGE.get;
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5934: MRP_UTIL.MRP_LOG(l_log_message);
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5935:
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5936: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5937: FND_MESSAGE.set_token('NUMBER','2');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5939: FND_MESSAGE.set_token('VALUE',to_char(p_output));
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5940: l_log_message := FND_MESSAGE.get;
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5941: MRP_UTIL.MRP_LOG(l_log_message);
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5942:
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5943: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5944: FND_MESSAGE.set_token('NUMBER','3');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5946: FND_MESSAGE.set_token('VALUE',to_char(l_from_start_date)); --fix bug#3170105
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5947: l_log_message := FND_MESSAGE.get;
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5948: MRP_UTIL.MRP_LOG(l_log_message);
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5949:
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5950: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5951: FND_MESSAGE.set_token('NUMBER','4');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5953: FND_MESSAGE.set_token('VALUE',to_char(l_from_end_date)); --fix bug#3170105
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5954: l_log_message := FND_MESSAGE.get;
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5955: MRP_UTIL.MRP_LOG(l_log_message);
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5956:
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5957: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5958: FND_MESSAGE.set_token('NUMBER','5');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5960: FND_MESSAGE.set_token('VALUE',to_char(l_to_start_date)); --fix bug#3170105
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5961: l_log_message := FND_MESSAGE.get;
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5962: MRP_UTIL.MRP_LOG(l_log_message);
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5963:
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5964: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5965: FND_MESSAGE.set_token('NUMBER','6');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5967: FND_MESSAGE.set_token('VALUE',to_char(l_to_end_date)); --fix bug#3170105
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5968: l_log_message := FND_MESSAGE.get;
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5969: MRP_UTIL.MRP_LOG(l_log_message);
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5970:
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5971: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5972: FND_MESSAGE.set_token('NUMBER','7');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5974: FND_MESSAGE.set_token('VALUE',p_from_line);
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5975: l_log_message := FND_MESSAGE.get;
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5976: MRP_UTIL.MRP_LOG(l_log_message);
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5977:
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5978: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5979: FND_MESSAGE.set_token('NUMBER','8');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5981: FND_MESSAGE.set_token('VALUE',p_to_line);
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5982: l_log_message := FND_MESSAGE.get;
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5983: MRP_UTIL.MRP_LOG(l_log_message);
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5984:
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5985: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5986: FND_MESSAGE.set_token('NUMBER','9');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5988: FND_MESSAGE.set_token('VALUE',p_from_item);
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5989: l_log_message := FND_MESSAGE.get;
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5990: MRP_UTIL.MRP_LOG(l_log_message);
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5991:
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5992: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5993: FND_MESSAGE.set_token('NUMBER','10');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
5995: FND_MESSAGE.set_token('VALUE',p_to_item);
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
5996: l_log_message := FND_MESSAGE.get;
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
5997: MRP_UTIL.MRP_LOG(l_log_message);
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
5998:
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
5999: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6000: FND_MESSAGE.set_token('NUMBER','11');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6002: FND_MESSAGE.set_token('VALUE',to_char(p_category_set_id));
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6003: l_log_message := FND_MESSAGE.get;
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6004: MRP_UTIL.MRP_LOG(l_log_message);
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6005:
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6006: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6007: FND_MESSAGE.set_token('NUMBER','12');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6009: FND_MESSAGE.set_token('VALUE',to_char(p_category_structure_id));
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6010: l_log_message := FND_MESSAGE.get;
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6011: MRP_UTIL.MRP_LOG(l_log_message);
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6012:
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6013: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6014: FND_MESSAGE.set_token('NUMBER','13');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6016: FND_MESSAGE.set_token('VALUE',p_from_category);
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6017: l_log_message := FND_MESSAGE.get;
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6018: MRP_UTIL.MRP_LOG(l_log_message);
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6019:
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6020: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6021: FND_MESSAGE.set_token('NUMBER','14');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6023: FND_MESSAGE.set_token('VALUE',p_to_category);
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6024: l_log_message := FND_MESSAGE.get;
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6025: MRP_UTIL.MRP_LOG(l_log_message);
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6033:
6026:
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6033:
6034: -- Check for mandatory parameters and issue an error message
6027: FND_MESSAGE.set_name('MRP','MRCONC-ARGS INFO');
6028: FND_MESSAGE.set_token('NUMBER','15');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');
6030: FND_MESSAGE.set_token('VALUE',to_char(p_spread_qty));
6031: l_log_message := FND_MESSAGE.get;
6032: MRP_UTIL.MRP_LOG(l_log_message);
6033:
6034: -- Check for mandatory parameters and issue an error message
6035: -- if NULL. If line, item or category are null, assume all.
6033:
6034: -- Check for mandatory parameters and issue an error message
6035: -- if NULL. If line, item or category are null, assume all.
6036: IF p_organization_id IS NULL THEN
6037: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
6038: l_log_message := FND_MESSAGE.get;
6039: MRP_UTIL.MRP_LOG(l_log_message);
6040: RAISE expected_error;
6041: END IF;
6034: -- Check for mandatory parameters and issue an error message
6035: -- if NULL. If line, item or category are null, assume all.
6036: IF p_organization_id IS NULL THEN
6037: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
6038: l_log_message := FND_MESSAGE.get;
6039: MRP_UTIL.MRP_LOG(l_log_message);
6040: RAISE expected_error;
6041: END IF;
6042: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND
6040: RAISE expected_error;
6041: END IF;
6042: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND
6043: (p_spread_qty <> 3) THEN
6044: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
6045: l_log_message := FND_MESSAGE.get;
6046: MRP_UTIL.MRP_LOG(l_log_message);
6047: RAISE expected_error;
6048: END IF;
6041: END IF;
6042: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND
6043: (p_spread_qty <> 3) THEN
6044: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');
6045: l_log_message := FND_MESSAGE.get;
6046: MRP_UTIL.MRP_LOG(l_log_message);
6047: RAISE expected_error;
6048: END IF;
6049: IF p_from_end_date IS NULL AND (p_spread_qty <> 3) THEN
6046: MRP_UTIL.MRP_LOG(l_log_message);
6047: RAISE expected_error;
6048: END IF;
6049: IF p_from_end_date IS NULL AND (p_spread_qty <> 3) THEN
6050: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6051: l_log_message := FND_MESSAGE.get;
6052: MRP_UTIL.MRP_LOG(l_log_message);
6053: RAISE expected_error;
6054: END IF;
6047: RAISE expected_error;
6048: END IF;
6049: IF p_from_end_date IS NULL AND (p_spread_qty <> 3) THEN
6050: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6051: l_log_message := FND_MESSAGE.get;
6052: MRP_UTIL.MRP_LOG(l_log_message);
6053: RAISE expected_error;
6054: END IF;
6055:
6053: RAISE expected_error;
6054: END IF;
6055:
6056: IF p_to_end_date IS NULL AND (p_spread_qty = 1) THEN
6057: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6058: l_log_message := FND_MESSAGE.get;
6059: MRP_UTIL.MRP_LOG(l_log_message);
6060: RAISE expected_error;
6061: END IF;
6054: END IF;
6055:
6056: IF p_to_end_date IS NULL AND (p_spread_qty = 1) THEN
6057: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6058: l_log_message := FND_MESSAGE.get;
6059: MRP_UTIL.MRP_LOG(l_log_message);
6060: RAISE expected_error;
6061: END IF;
6062:
6070: /************** Commented - Bug 2213859 *********************
6071: l_from_end_date := mrp_calendar.next_work_day(p_organization_id,
6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6071: l_from_end_date := mrp_calendar.next_work_day(p_organization_id,
6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6079: END IF;
6072: 1, to_date(p_from_end_date, 'YYYY/MM/DD'));
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6079: END IF;
6080: ******************** Comment ends ***********************/
6073: IF to_date(p_from_end_date, 'YYYY/MM/DD') <> l_from_end_date THEN
6074: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6075: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6076: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6077: l_log_message := FND_MESSAGE.get;
6078: MRP_UTIL.MRP_LOG(l_log_message);
6079: END IF;
6080: ******************** Comment ends ***********************/
6081: END IF;
6092: instead of l_to_end_date
6093: **/
6094: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_start_date) AND
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6093: **/
6094: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_start_date) AND
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6101: END IF;
6094: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_start_date) AND
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6101: END IF;
6102:
6095: (p_spread_qty = 2 ) THEN
6096: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6097: FND_MESSAGE.set_token('ORIG_DATE',to_char(l_to_start_date));
6098: FND_MESSAGE.set_token('NEW_DATE',to_char(l_temp_date));
6099: l_log_message := FND_MESSAGE.get;
6100: MRP_UTIL.MRP_LOG(l_log_message);
6101: END IF;
6102:
6103: --bug 3832684: need it also for Spread Evenly wo Details
6122: --TZ BOM Calendar bug 3832684
6123: l_temp_date := flm_timezone.calendar_to_server(l_temp_date,l_to_end_time);
6124:
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6123: l_temp_date := flm_timezone.calendar_to_server(l_temp_date,l_to_end_time);
6124:
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6131: MRP_UTIL.MRP_LOG(l_log_message);
6124:
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6131: MRP_UTIL.MRP_LOG(l_log_message);
6132: END IF;
6125: IF flm_timezone.server_to_calendar(l_temp_date) <> flm_timezone.server_to_calendar(l_to_end_date) THEN
6126: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6127: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6128: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6129: l_log_message := FND_MESSAGE.get;
6130: l_to_end_date := l_temp_date;
6131: MRP_UTIL.MRP_LOG(l_log_message);
6132: END IF;
6133: --end of fix bug#3170105
6143: l_to_start_date := mrp_calendar.next_work_day(p_organization_id,
6144: 1, to_date(p_to_start_date, 'YYYY/MM/DD'));
6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6144: 1, to_date(p_to_start_date, 'YYYY/MM/DD'));
6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6152: END IF;
6145: IF to_date(p_to_start_date, 'YYYY/MM/DD') <> l_to_end_date AND
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6152: END IF;
6153: END IF;
6146: (p_spread_qty = 2 ) THEN
6147: FND_MESSAGE.set_name('MRP','MRP_TO_DATE_CHANGED');
6148: FND_MESSAGE.set_token('ORIG_DATE',p_to_start_date);
6149: FND_MESSAGE.set_token('NEW_DATE',l_to_start_date);
6150: l_log_message := FND_MESSAGE.get;
6151: MRP_UTIL.MRP_LOG(l_log_message);
6152: END IF;
6153: END IF;
6154: ****************************************************************************/
6152: END IF;
6153: END IF;
6154: ****************************************************************************/
6155:
6156: FND_MESSAGE.set_name('MRP','EC_DATE');
6157: l_trans_var1 := FND_MESSAGE.get;
6158: SELECT to_char(sysdate)
6159: INTO l_trans_var2
6160: FROM dual;
6153: END IF;
6154: ****************************************************************************/
6155:
6156: FND_MESSAGE.set_name('MRP','EC_DATE');
6157: l_trans_var1 := FND_MESSAGE.get;
6158: SELECT to_char(sysdate)
6159: INTO l_trans_var2
6160: FROM dual;
6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6160: FROM dual;
6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6162: MRP_UTIL.MRP_OUT(l_out_message);
6163:
6164: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');
6165: l_out_message := FND_MESSAGE.get;
6166: MRP_UTIL.MRP_OUT(' '||l_out_message);
6167:
6168: /*-----------------------------------------------------+
6161: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6162: MRP_UTIL.MRP_OUT(l_out_message);
6163:
6164: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');
6165: l_out_message := FND_MESSAGE.get;
6166: MRP_UTIL.MRP_OUT(' '||l_out_message);
6167:
6168: /*-----------------------------------------------------+
6169: | Do setup for report by inserting existing records |
6338:
6339: IF p_output = 2 THEN
6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6339: IF p_output = 2 THEN
6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE
6350: IF l_msg_count > 0 THEN
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6346: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6347: l_log_message := FND_MESSAGE.get;
6348: MRP_UTIL.MRP_LOG(l_log_message);
6349: ELSE
6350: IF l_msg_count > 0 THEN
6351: FOR i in 1..l_msg_count LOOP
6396: +-----------------------------*/
6397: Update_Quantity(l_wip_entity_id,
6398: l_update_variance);
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6397: Update_Quantity(l_wip_entity_id,
6398: l_update_variance);
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6398: l_update_variance);
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6399: IF p_output = 2 THEN
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6400: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6408: MRP_UTIL.MRP_LOG(l_log_message);
6401: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6402: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6408: MRP_UTIL.MRP_LOG(l_log_message);
6409: END IF;
6403: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6404: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6405: FND_MESSAGE.set_token('NEW_QTY',
6406: (l_planned_quantity + l_update_variance));
6407: l_log_message := FND_MESSAGE.get;
6408: MRP_UTIL.MRP_LOG(l_log_message);
6409: END IF;
6410: l_update_variance := 0;
6411: ELSIF -(l_update_variance) >= (l_planned_quantity -
6440: END IF;
6441:
6442: END IF;
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6441:
6442: END IF;
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6442: END IF;
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6443: IF p_output = 2 THEN
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6451: END IF;
6444: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6451: END IF;
6452: l_update_variance := l_update_variance +
6445: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6446: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6447: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6448: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6449: l_log_message := FND_MESSAGE.get;
6450: MRP_UTIL.MRP_LOG(l_log_message);
6451: END IF;
6452: l_update_variance := l_update_variance +
6453: (l_planned_quantity-l_quantity_completed);
6479: | then generate an error message to the log |
6480: +---------------------------------------------------------*/
6481: IF l_update_variance < 0 THEN
6482: -- Log what's going on
6483: FND_MESSAGE.set_name('MRP','MRP_ROLL_SECOND_LOOP');
6484: l_log_message := FND_MESSAGE.get;
6485: MRP_UTIL.MRP_LOG(l_log_message);
6486:
6487: OPEN C5(fs_report_rec.line_id, fs_report_rec.primary_item_id,
6480: +---------------------------------------------------------*/
6481: IF l_update_variance < 0 THEN
6482: -- Log what's going on
6483: FND_MESSAGE.set_name('MRP','MRP_ROLL_SECOND_LOOP');
6484: l_log_message := FND_MESSAGE.get;
6485: MRP_UTIL.MRP_LOG(l_log_message);
6486:
6487: OPEN C5(fs_report_rec.line_id, fs_report_rec.primary_item_id,
6488: l_to_start_date, l_to_end_date); --fix bug#3170105
6509: Update_Quantity(l_wip_entity_id,
6510: l_update_variance);
6511:
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6510: l_update_variance);
6511:
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6511:
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6512: IF p_output = 2 THEN
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6513: FND_MESSAGE.set_name('MRP','MRP_ROLL_UPDATE');
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6521: END IF;
6514: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6515: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6521: END IF;
6522: l_update_variance := 0;
6516: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6517: FND_MESSAGE.set_token('OLD_QTY',l_planned_quantity);
6518: FND_MESSAGE.set_token('NEW_QTY',
6519: (l_planned_quantity + l_update_variance));
6520: l_log_message := FND_MESSAGE.get;
6521: END IF;
6522: l_update_variance := 0;
6523: ELSIF -(l_update_variance) >= (l_planned_quantity -
6524: l_quantity_completed) THEN
6553: END IF;
6554: END IF;
6555:
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6554: END IF;
6555:
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6555:
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6556: IF p_output = 2 THEN
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6564: END IF;
6557: FND_MESSAGE.set_name('MRP','MRP_ROLL_DELETE');
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6564: END IF;
6565: l_update_variance := l_update_variance +
6558: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6559: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6560: FND_MESSAGE.set_token('COMP_DATE',l_completion_date);
6561: FND_MESSAGE.set_token('QTY',l_planned_quantity);
6562: l_log_message := FND_MESSAGE.get;
6563: MRP_UTIL.MRP_LOG(l_log_message);
6564: END IF;
6565: l_update_variance := l_update_variance +
6566: (l_planned_quantity-l_quantity_completed);
6572: | If l_update_variance is still less than zero, print a |
6573: | message to the log. |
6574: +-------------------------------------------------------*/
6575: IF l_update_variance < 0 THEN
6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');
6577: FND_MESSAGE.set_token('QTY',l_update_variance);
6578: l_log_message := FND_MESSAGE.get;
6579: MRP_UTIL.MRP_LOG(l_log_message);
6580: RETCODE := G_WARNING;
6573: | message to the log. |
6574: +-------------------------------------------------------*/
6575: IF l_update_variance < 0 THEN
6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');
6577: FND_MESSAGE.set_token('QTY',l_update_variance);
6578: l_log_message := FND_MESSAGE.get;
6579: MRP_UTIL.MRP_LOG(l_log_message);
6580: RETCODE := G_WARNING;
6581: l_update_variance := 0;
6574: +-------------------------------------------------------*/
6575: IF l_update_variance < 0 THEN
6576: FND_MESSAGE.set_name('MRP','MRP_ROLL_QTY_REMAINDER');
6577: FND_MESSAGE.set_token('QTY',l_update_variance);
6578: l_log_message := FND_MESSAGE.get;
6579: MRP_UTIL.MRP_LOG(l_log_message);
6580: RETCODE := G_WARNING;
6581: l_update_variance := 0;
6582: END IF;
6939:
6940: IF p_output = 2 THEN
6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6940: IF p_output = 2 THEN
6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE
6951: IF l_msg_count > 0 THEN
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6947: FND_MESSAGE.set_token('QTY',l_x_flow_schedule_rec.planned_quantity);
6948: l_log_message := FND_MESSAGE.get;
6949: MRP_UTIL.MRP_LOG(l_log_message);
6950: ELSE
6951: IF l_msg_count > 0 THEN
6952: FOR i in 1..l_msg_count LOOP
7104: END IF;
7105: IF p_spread_qty = 3 THEN
7106: RETURN;
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7105: IF p_spread_qty = 3 THEN
7106: RETURN;
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7106: RETURN;
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7107: END IF;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7108: FND_MESSAGE.set_name('MRP','EC_FROM');
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7109: l_trans_var1 := FND_MESSAGE.get;
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7117: l_out_message := ' ' ||
7110: FND_MESSAGE.set_name('MRP','EC_TO');
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7117: l_out_message := ' ' ||
7118: rpad(substr(l_trans_var1,1,8),38) || ' ' ||
7111: l_trans_var2 := FND_MESSAGE.get;
7112: FND_MESSAGE.set_name('MRP','EC_ORIGINAL');
7113: l_trans_var3 := FND_MESSAGE.get;
7114: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7115: l_trans_var4 := FND_MESSAGE.get;
7116:
7117: l_out_message := ' ' ||
7118: rpad(substr(l_trans_var1,1,8),38) || ' ' ||
7119: rpad(substr(l_trans_var2,1,9),9) || ' ' ||
7120: rpad(substr(l_trans_var3,1,8),8) || ' ' ||
7121: rpad(substr(l_trans_var4,1,8),8);
7122: MRP_UTIL.MRP_OUT(l_out_message);
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7121: rpad(substr(l_trans_var4,1,8),8);
7122: MRP_UTIL.MRP_OUT(l_out_message);
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7122: MRP_UTIL.MRP_OUT(l_out_message);
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7123:
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7124: FND_MESSAGE.set_name('MRP','EC_SCHEDULE');
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7125: l_trans_var1 := FND_MESSAGE.get;
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7133: l_out_message := ' ' ||
7126: FND_MESSAGE.set_name('MRP','EC_SCHEDULED');
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7133: l_out_message := ' ' ||
7134: rpad(substr(l_trans_var1,1,8),8) || ' ' ||
7127: l_trans_var2 := FND_MESSAGE.get;
7128: FND_MESSAGE.set_name('MRP','EC_COMPLETED');
7129: l_trans_var3 := FND_MESSAGE.get;
7130: FND_MESSAGE.set_name('MRP','EC_ADJUSTED');
7131: l_trans_var4 := FND_MESSAGE.get;
7132:
7133: l_out_message := ' ' ||
7134: rpad(substr(l_trans_var1,1,8),8) || ' ' ||
7135: rpad(substr(l_trans_var1,1,9),9) || ' ' ||
7141: rpad(substr(l_trans_var4,1,8),8);
7142:
7143: MRP_UTIL.MRP_OUT(l_out_message);
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7142:
7143: MRP_UTIL.MRP_OUT(l_out_message);
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7143: MRP_UTIL.MRP_OUT(l_out_message);
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7144:
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7145: FND_MESSAGE.set_name('MRP','EC_LINE');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7146: l_trans_var1 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7147: FND_MESSAGE.set_name('MRP','EC_ITEM');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7148: l_trans_var2 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7149: FND_MESSAGE.set_name('MRP','EC_GROUP');
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7150: l_trans_var3 := FND_MESSAGE.get;
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7158: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7151: FND_MESSAGE.set_name('MRP','EC_DATE');
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7158: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7159: rpad(substr(l_trans_var2,1,14),14) || ' ' ||
7152: l_trans_var4 := FND_MESSAGE.get;
7153: FND_MESSAGE.set_name('MRP','EC_QUANTITY');
7154: l_trans_var5 := FND_MESSAGE.get;
7155: FND_MESSAGE.set_name('MRP','EC_VARIANCE');
7156: l_trans_var6 := FND_MESSAGE.get;
7157:
7158: l_out_message := rpad(substr(l_trans_var1,1,10),10) || ' ' ||
7159: rpad(substr(l_trans_var2,1,14),14) || ' ' ||
7160: rpad(substr(l_trans_var3,1,8),8) || ' ' ||
7221:
7222: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7223: MRP_UTIL.MRP_OUT(l_out_message);
7224:
7225: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7226: l_out_message := FND_MESSAGE.get;
7227:
7228: l_out_message := rpad(substr(l_out_message,1,8),8) || ' '||
7229: lpad(l_planned_total,9) || ' ' ||
7222: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7223: MRP_UTIL.MRP_OUT(l_out_message);
7224:
7225: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7226: l_out_message := FND_MESSAGE.get;
7227:
7228: l_out_message := rpad(substr(l_out_message,1,8),8) || ' '||
7229: lpad(l_planned_total,9) || ' ' ||
7230: lpad(l_completed_total,9) || ' ' || lpad(l_variance1_total,8) ||
7238: MRP_UTIL.MRP_OUT(l_out_message);
7239: END IF;
7240:
7241: IF REPORT_CURSOR%NOTFOUND THEN
7242: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');
7243: l_out_message := FND_MESSAGE.get;
7244: MRP_UTIL.MRP_OUT(l_out_message);
7245: EXIT;
7246: END IF;
7239: END IF;
7240:
7241: IF REPORT_CURSOR%NOTFOUND THEN
7242: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');
7243: l_out_message := FND_MESSAGE.get;
7244: MRP_UTIL.MRP_OUT(l_out_message);
7245: EXIT;
7246: END IF;
7247:
7279: ROLLBACK;
7280: IF RETCODE <> 1 THEN
7281: RETCODE := G_ERROR;
7282: END IF;
7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7284: ERRBUF := FND_MESSAGE.get;
7285: l_log_message := FND_MESSAGE.get;
7286: MRP_UTIL.MRP_LOG(l_log_message);
7287: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7280: IF RETCODE <> 1 THEN
7281: RETCODE := G_ERROR;
7282: END IF;
7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7284: ERRBUF := FND_MESSAGE.get;
7285: l_log_message := FND_MESSAGE.get;
7286: MRP_UTIL.MRP_LOG(l_log_message);
7287: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7288: MRP_UTIL.MRP_LOG(l_log_message);
7281: RETCODE := G_ERROR;
7282: END IF;
7283: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7284: ERRBUF := FND_MESSAGE.get;
7285: l_log_message := FND_MESSAGE.get;
7286: MRP_UTIL.MRP_LOG(l_log_message);
7287: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7288: MRP_UTIL.MRP_LOG(l_log_message);
7289:
7289:
7290: WHEN unexpected_error THEN
7291: ROLLBACK;
7292: RETCODE := G_ERROR;
7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7294: ERRBUF := FND_MESSAGE.get;
7295: l_log_message := FND_MESSAGE.get;
7296: MRP_UTIL.MRP_LOG(l_log_message);
7297: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7290: WHEN unexpected_error THEN
7291: ROLLBACK;
7292: RETCODE := G_ERROR;
7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7294: ERRBUF := FND_MESSAGE.get;
7295: l_log_message := FND_MESSAGE.get;
7296: MRP_UTIL.MRP_LOG(l_log_message);
7297: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7298: MRP_UTIL.MRP_LOG(l_log_message);
7291: ROLLBACK;
7292: RETCODE := G_ERROR;
7293: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7294: ERRBUF := FND_MESSAGE.get;
7295: l_log_message := FND_MESSAGE.get;
7296: MRP_UTIL.MRP_LOG(l_log_message);
7297: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7298: MRP_UTIL.MRP_LOG(l_log_message);
7299:
7299:
7300: WHEN OTHERS THEN
7301: ROLLBACK;
7302: RETCODE := G_ERROR;
7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7304: ERRBUF := FND_MESSAGE.get;
7305: l_log_message := FND_MESSAGE.get;
7306: MRP_UTIL.MRP_LOG(l_log_message);
7307: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7300: WHEN OTHERS THEN
7301: ROLLBACK;
7302: RETCODE := G_ERROR;
7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7304: ERRBUF := FND_MESSAGE.get;
7305: l_log_message := FND_MESSAGE.get;
7306: MRP_UTIL.MRP_LOG(l_log_message);
7307: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7308: MRP_UTIL.MRP_LOG(l_log_message);
7301: ROLLBACK;
7302: RETCODE := G_ERROR;
7303: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_ERROR');
7304: ERRBUF := FND_MESSAGE.get;
7305: l_log_message := FND_MESSAGE.get;
7306: MRP_UTIL.MRP_LOG(l_log_message);
7307: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7308: MRP_UTIL.MRP_LOG(l_log_message);
7309:
7577: -- Do nothing, there was just no bill to explode
7578: NULL;
7579: ELSIF l_error_code <> 0 THEN
7580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7581: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7582: FND_MSG_PUB.Add;
7583: END IF;
7584: RAISE FND_API.G_EXC_ERROR;
7585: END IF;