eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_FLOW_SCHEDULE_UTIL dependencies on MRP_UTIL

Line 3470: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3477: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3484: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3491: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3498: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3505: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3512: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3519: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3526: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3533: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3540: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3547: MRP_UTIL.MRP_LOG(l_log_message);

3543: FND_MESSAGE.set_token('NUMBER','11');
3544: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');
3545: FND_MESSAGE.set_token('VALUE',p_to_category);
3546: l_log_message := FND_MESSAGE.get;
3547: MRP_UTIL.MRP_LOG(l_log_message);
3548:
3549: -- Check for mandatory parameters and issue an error message
3550: -- Check for mandatory parameters and issue an error message
3551: -- if NULL. If line, item or category are null, assume all.

Line 3555: MRP_UTIL.MRP_LOG(l_log_message);

3551: -- if NULL. If line, item or category are null, assume all.
3552: IF p_organization_id IS NULL THEN
3553: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
3554: l_log_message := FND_MESSAGE.get;
3555: MRP_UTIL.MRP_LOG(l_log_message);
3556: RAISE expected_error;
3557: END IF;
3558: IF p_start_date IS NULL THEN
3559: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');

Line 3561: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3567: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3594: MRP_UTIL.MRP_LOG(l_log_message);

3590:
3591: IF NOT l_return THEN
3592: -- English because unexpected error
3593: l_log_message := 'Problem constructing item_where_clause';
3594: MRP_UTIL.MRP_LOG(l_log_message);
3595: l_log_message := l_err_buf;
3596: MRP_UTIL.MRP_LOG(l_log_message);
3597: RAISE unexpected_error;
3598: END IF;

Line 3596: MRP_UTIL.MRP_LOG(l_log_message);

3592: -- English because unexpected error
3593: l_log_message := 'Problem constructing item_where_clause';
3594: MRP_UTIL.MRP_LOG(l_log_message);
3595: l_log_message := l_err_buf;
3596: MRP_UTIL.MRP_LOG(l_log_message);
3597: RAISE unexpected_error;
3598: END IF;
3599: l_item_where_clause := ' AND wfs.primary_item_id in ' ||
3600: '(select inventory_item_id from mtl_system_items msi ' ||

Line 3617: MRP_UTIL.MRP_LOG(l_log_message);

3613:
3614: IF NOT l_return THEN
3615: -- English because unexpected error
3616: l_log_message := 'Problem constructing category_where_clause';
3617: MRP_UTIL.MRP_LOG(l_log_message);
3618: l_log_message := l_err_buf;
3619: MRP_UTIL.MRP_LOG(l_log_message);
3620: RAISE unexpected_error;
3621: END IF;

Line 3619: MRP_UTIL.MRP_LOG(l_log_message);

3615: -- English because unexpected error
3616: l_log_message := 'Problem constructing category_where_clause';
3617: MRP_UTIL.MRP_LOG(l_log_message);
3618: l_log_message := l_err_buf;
3619: MRP_UTIL.MRP_LOG(l_log_message);
3620: RAISE unexpected_error;
3621: END IF;
3622: l_cat_where_clause := ' AND wfs.primary_item_id in (select ' ||
3623: ' inventory_item_id from mtl_item_categories mic, '||

Line 3692: MRP_UTIL.MRP_LOG(l_msg_data);

3688: -- Added to support component picking. It will cancel the move order when the flow
3689: -- schedule is to be deleted.
3690: wip_picking_pvt.cancel_allocations(l_wip_entity_id, 4, null, l_return_status, l_msg_data);
3691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3692: MRP_UTIL.MRP_LOG(l_msg_data);
3693: ELSE
3694: DELETE FROM wip_flow_schedules
3695: WHERE wip_entity_id = l_wip_entity_id AND organization_id = p_organization_id;
3696:

Line 3724: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3728: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3738: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3748: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3756: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3764: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3766: MRP_UTIL.MRP_LOG(l_log_message);

3762: ERRBUF := FND_MESSAGE.get;
3763: l_log_message := FND_MESSAGE.get;
3764: MRP_UTIL.MRP_LOG(l_log_message);
3765: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
3766: MRP_UTIL.MRP_LOG(l_log_message);
3767:
3768: END Delete_Flow_Schedules;
3769:
3770:

Line 4222: MRP_UTIL.MRP_LOG('the client date before :'||to_char(l_schedule_date,'DD-MON-YYYY HH24:MI:SS'));

4218: END IF;
4219: l_time := l_start_time + 60*60*(p_quantity/l_maximum_rate);
4220:
4221: --fix bug#3170105 not yet
4222: MRP_UTIL.MRP_LOG('the client date before :'||to_char(l_schedule_date,'DD-MON-YYYY HH24:MI:SS'));
4223:
4224: --TZ 3832684: Will have to do the time addition in Client TZ doe to some corner cases
4225: --The p_completion_date is assumed to be in Client00_in_server
4226: l_schedule_date := l_schedule_date+(l_time/86400);

Line 4228: MRP_UTIL.MRP_LOG('the client date after :'||to_char(l_schedule_date,'DD-MON-YYYY HH24:MI:SS'));

4224: --TZ 3832684: Will have to do the time addition in Client TZ doe to some corner cases
4225: --The p_completion_date is assumed to be in Client00_in_server
4226: l_schedule_date := l_schedule_date+(l_time/86400);
4227:
4228: MRP_UTIL.MRP_LOG('the client date after :'||to_char(l_schedule_date,'DD-MON-YYYY HH24:MI:SS'));
4229: --end of fix bug#3170105
4230:
4231: --TZ 3832684: conversion back to server to be passed back to caller
4232: if flm_timezone.g_enabled then

Line 4234: MRP_UTIL.MRP_LOG('the datetime after conv :'||to_char(l_schedule_date,'DD-MON-YY HH24:MI:SS'));

4230:
4231: --TZ 3832684: conversion back to server to be passed back to caller
4232: if flm_timezone.g_enabled then
4233: l_schedule_date := flm_timezone.client_to_server(l_schedule_date);
4234: MRP_UTIL.MRP_LOG('the datetime after conv :'||to_char(l_schedule_date,'DD-MON-YY HH24:MI:SS'));
4235: end if;
4236:
4237: CLOSE Line_Details;
4238: ELSE

Line 4282: MRP_UTIL.MRP_LOG(l_log_message);

4278:
4279: IF NOT l_return THEN
4280: -- English because unexpected error
4281: l_log_message := 'Problem constructing item_where_clause';
4282: MRP_UTIL.MRP_LOG(l_log_message);
4283: l_log_message := l_err_buf;
4284: MRP_UTIL.MRP_LOG(l_log_message);
4285: RAISE unexpected_error;
4286: END IF;

Line 4284: MRP_UTIL.MRP_LOG(l_log_message);

4280: -- English because unexpected error
4281: l_log_message := 'Problem constructing item_where_clause';
4282: MRP_UTIL.MRP_LOG(l_log_message);
4283: l_log_message := l_err_buf;
4284: MRP_UTIL.MRP_LOG(l_log_message);
4285: RAISE unexpected_error;
4286: END IF;
4287: l_item_where_clause := ' AND ' || l_item_where_clause;
4288: END IF;

Line 4304: MRP_UTIL.MRP_LOG(l_log_message);

4300:
4301: IF NOT l_return THEN
4302: -- English because unexpected error
4303: l_log_message := 'Problem constructing category_where_clause';
4304: MRP_UTIL.MRP_LOG(l_log_message);
4305: l_log_message := l_err_buf;
4306: MRP_UTIL.MRP_LOG(l_log_message);
4307: RAISE unexpected_error;
4308: END IF;

Line 4306: MRP_UTIL.MRP_LOG(l_log_message);

4302: -- English because unexpected error
4303: l_log_message := 'Problem constructing category_where_clause';
4304: MRP_UTIL.MRP_LOG(l_log_message);
4305: l_log_message := l_err_buf;
4306: MRP_UTIL.MRP_LOG(l_log_message);
4307: RAISE unexpected_error;
4308: END IF;
4309: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4310: ' inventory_item_id from mtl_item_categories mic, '||

Line 4384: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4390: MRP_UTIL.MRP_LOG(l_log_message);

4386:
4387: WHEN OTHERS THEN
4388: -- English because unexpected error
4389: l_log_message := 'Problem Closing all past Schedules';
4390: MRP_UTIL.MRP_LOG(l_log_message);
4391: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4392: l_log_message := l_err_buf;
4393: MRP_UTIL.MRP_LOG(l_log_message);
4394: RAISE unexpected_error;

Line 4393: MRP_UTIL.MRP_LOG(l_log_message);

4389: l_log_message := 'Problem Closing all past Schedules';
4390: MRP_UTIL.MRP_LOG(l_log_message);
4391: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4392: l_log_message := l_err_buf;
4393: MRP_UTIL.MRP_LOG(l_log_message);
4394: RAISE unexpected_error;
4395: RETURN NULL;
4396: END Close_All_Past_Schedules;
4397:

Line 4437: MRP_UTIL.MRP_LOG(l_log_message);

4433:
4434: IF NOT l_return THEN
4435: -- English because unexpected error
4436: l_log_message := 'Problem constructing item_where_clause';
4437: MRP_UTIL.MRP_LOG(l_log_message);
4438: l_log_message := l_err_buf;
4439: MRP_UTIL.MRP_LOG(l_log_message);
4440: RAISE unexpected_error;
4441: END IF;

Line 4439: MRP_UTIL.MRP_LOG(l_log_message);

4435: -- English because unexpected error
4436: l_log_message := 'Problem constructing item_where_clause';
4437: MRP_UTIL.MRP_LOG(l_log_message);
4438: l_log_message := l_err_buf;
4439: MRP_UTIL.MRP_LOG(l_log_message);
4440: RAISE unexpected_error;
4441: END IF;
4442: l_item_where_clause := ' AND ' || l_item_where_clause;
4443: END IF;

Line 4458: MRP_UTIL.MRP_LOG(l_log_message);

4454:
4455: IF NOT l_return THEN
4456: -- English because unexpected error
4457: l_log_message := 'Problem constructing category_where_clause';
4458: MRP_UTIL.MRP_LOG(l_log_message);
4459: l_log_message := l_err_buf;
4460: MRP_UTIL.MRP_LOG(l_log_message);
4461: RAISE unexpected_error;
4462: END IF;

Line 4460: MRP_UTIL.MRP_LOG(l_log_message);

4456: -- English because unexpected error
4457: l_log_message := 'Problem constructing category_where_clause';
4458: MRP_UTIL.MRP_LOG(l_log_message);
4459: l_log_message := l_err_buf;
4460: MRP_UTIL.MRP_LOG(l_log_message);
4461: RAISE unexpected_error;
4462: END IF;
4463: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4464: ' inventory_item_id from mtl_item_categories mic, '||

Line 4561: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4569: MRP_UTIL.MRP_LOG(l_log_message);

4565: WHEN OTHERS THEN
4566:
4567: -- English because unexpected error
4568: l_log_message := 'Problem constructing cursor';
4569: MRP_UTIL.MRP_LOG(l_log_message);
4570: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4571: l_log_message := l_err_buf;
4572: MRP_UTIL.MRP_LOG(l_log_message);
4573: RAISE unexpected_error;

Line 4572: MRP_UTIL.MRP_LOG(l_log_message);

4568: l_log_message := 'Problem constructing cursor';
4569: MRP_UTIL.MRP_LOG(l_log_message);
4570: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4571: l_log_message := l_err_buf;
4572: MRP_UTIL.MRP_LOG(l_log_message);
4573: RAISE unexpected_error;
4574:
4575: RETURN NULL;
4576:

Line 4619: MRP_UTIL.MRP_LOG(l_log_message);

4615:
4616: IF NOT l_return THEN
4617: -- English because unexpected error
4618: l_log_message := 'Problem constructing item_where_clause';
4619: MRP_UTIL.MRP_LOG(l_log_message);
4620: l_log_message := l_err_buf;
4621: MRP_UTIL.MRP_LOG(l_log_message);
4622: RAISE unexpected_error;
4623: END IF;

Line 4621: MRP_UTIL.MRP_LOG(l_log_message);

4617: -- English because unexpected error
4618: l_log_message := 'Problem constructing item_where_clause';
4619: MRP_UTIL.MRP_LOG(l_log_message);
4620: l_log_message := l_err_buf;
4621: MRP_UTIL.MRP_LOG(l_log_message);
4622: RAISE unexpected_error;
4623: END IF;
4624: l_item_where_clause := ' AND ' || l_item_where_clause;
4625: END IF;

Line 4641: MRP_UTIL.MRP_LOG(l_log_message);

4637:
4638: IF NOT l_return THEN
4639: -- English because unexpected error
4640: l_log_message := 'Problem constructing category_where_clause';
4641: MRP_UTIL.MRP_LOG(l_log_message);
4642: l_log_message := l_err_buf;
4643: MRP_UTIL.MRP_LOG(l_log_message);
4644: RAISE unexpected_error;
4645: END IF;

Line 4643: MRP_UTIL.MRP_LOG(l_log_message);

4639: -- English because unexpected error
4640: l_log_message := 'Problem constructing category_where_clause';
4641: MRP_UTIL.MRP_LOG(l_log_message);
4642: l_log_message := l_err_buf;
4643: MRP_UTIL.MRP_LOG(l_log_message);
4644: RAISE unexpected_error;
4645: END IF;
4646: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4647: ' inventory_item_id from mtl_item_categories mic, '||

Line 4731: --MRP_UTIL.MRP_LOG(l_sql_stmt);

4727: /*
4728: Bug 2213859 - Removed ' order by line.line_code, msi.concatenated_segments,fs.build_sequence '
4729: and added a new order by above
4730: */
4731: --MRP_UTIL.MRP_LOG(l_sql_stmt);
4732: -- get the cursor
4733: l_cursor_name := dbms_sql.open_cursor;
4734:
4735: -- parse the sql statement

Line 4830: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4838: MRP_UTIL.MRP_LOG(l_log_message);

4834: WHEN OTHERS THEN
4835:
4836: -- English because unexpected error
4837: l_log_message := 'Problem constructing cursor';
4838: MRP_UTIL.MRP_LOG(l_log_message);
4839: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4840: l_log_message := l_err_buf;
4841: MRP_UTIL.MRP_LOG(l_log_message);
4842: RAISE unexpected_error;

Line 4841: MRP_UTIL.MRP_LOG(l_log_message);

4837: l_log_message := 'Problem constructing cursor';
4838: MRP_UTIL.MRP_LOG(l_log_message);
4839: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4840: l_log_message := l_err_buf;
4841: MRP_UTIL.MRP_LOG(l_log_message);
4842: RAISE unexpected_error;
4843:
4844: RETURN NULL;
4845:

Line 4868: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4876: MRP_UTIL.MRP_LOG(l_log_message);

4872: WHEN OTHERS THEN
4873:
4874: -- English because unexpected error
4875: l_log_message := 'Problem Closing Schedule';
4876: MRP_UTIL.MRP_LOG(l_log_message);
4877: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4878: l_log_message := l_err_buf;
4879: MRP_UTIL.MRP_LOG(l_log_message);
4880: RAISE unexpected_error;

Line 4879: MRP_UTIL.MRP_LOG(l_log_message);

4875: l_log_message := 'Problem Closing Schedule';
4876: MRP_UTIL.MRP_LOG(l_log_message);
4877: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4878: l_log_message := l_err_buf;
4879: MRP_UTIL.MRP_LOG(l_log_message);
4880: RAISE unexpected_error;
4881:
4882: RETURN FALSE;
4883:

Line 4912: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4920: MRP_UTIL.MRP_LOG(l_log_message);

4916: WHEN OTHERS THEN
4917:
4918: -- English because unexpected error
4919: l_log_message := 'Problem Closing Schedule';
4920: MRP_UTIL.MRP_LOG(l_log_message);
4921: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4922: l_log_message := l_err_buf;
4923: MRP_UTIL.MRP_LOG(l_log_message);
4924: RAISE unexpected_error;

Line 4923: MRP_UTIL.MRP_LOG(l_log_message);

4919: l_log_message := 'Problem Closing Schedule';
4920: MRP_UTIL.MRP_LOG(l_log_message);
4921: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
4922: l_log_message := l_err_buf;
4923: MRP_UTIL.MRP_LOG(l_log_message);
4924: RAISE unexpected_error;
4925:
4926: RETURN FALSE;
4927:

Line 4971: MRP_UTIL.MRP_LOG(l_log_message);

4967:
4968: IF NOT l_return THEN
4969: -- English because unexpected error
4970: l_log_message := 'Problem constructing item_where_clause';
4971: MRP_UTIL.MRP_LOG(l_log_message);
4972: l_log_message := l_err_buf;
4973: MRP_UTIL.MRP_LOG(l_log_message);
4974: RAISE unexpected_error;
4975: END IF;

Line 4973: MRP_UTIL.MRP_LOG(l_log_message);

4969: -- English because unexpected error
4970: l_log_message := 'Problem constructing item_where_clause';
4971: MRP_UTIL.MRP_LOG(l_log_message);
4972: l_log_message := l_err_buf;
4973: MRP_UTIL.MRP_LOG(l_log_message);
4974: RAISE unexpected_error;
4975: END IF;
4976: l_item_where_clause := ' AND ' || l_item_where_clause;
4977: END IF;

Line 4993: MRP_UTIL.MRP_LOG(l_log_message);

4989:
4990: IF NOT l_return THEN
4991: -- English because unexpected error
4992: l_log_message := 'Problem constructing category_where_clause';
4993: MRP_UTIL.MRP_LOG(l_log_message);
4994: l_log_message := l_err_buf;
4995: MRP_UTIL.MRP_LOG(l_log_message);
4996: RAISE unexpected_error;
4997: END IF;

Line 4995: MRP_UTIL.MRP_LOG(l_log_message);

4991: -- English because unexpected error
4992: l_log_message := 'Problem constructing category_where_clause';
4993: MRP_UTIL.MRP_LOG(l_log_message);
4994: l_log_message := l_err_buf;
4995: MRP_UTIL.MRP_LOG(l_log_message);
4996: RAISE unexpected_error;
4997: END IF;
4998: l_cat_where_clause := ' AND fs.primary_item_id in (select ' ||
4999: ' inventory_item_id from mtl_item_categories mic, '||

Line 5088: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5096: MRP_UTIL.MRP_LOG(l_log_message);

5092: WHEN OTHERS THEN
5093:
5094: -- English because unexpected error
5095: l_log_message := 'Problem constructing Relieve cursor';
5096: MRP_UTIL.MRP_LOG(l_log_message);
5097: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
5098: l_log_message := l_err_buf;
5099: MRP_UTIL.MRP_LOG(l_log_message);
5100: RAISE unexpected_error;

Line 5099: MRP_UTIL.MRP_LOG(l_log_message);

5095: l_log_message := 'Problem constructing Relieve cursor';
5096: MRP_UTIL.MRP_LOG(l_log_message);
5097: l_err_buf := 'Unexpected SQL Error: '||sqlerrm;
5098: l_log_message := l_err_buf;
5099: MRP_UTIL.MRP_LOG(l_log_message);
5100: RAISE unexpected_error;
5101:
5102: RETURN NULL;
5103:

Line 5338: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5340: MRP_UTIL.MRP_LOG(l_log_message);

5336: ERRBUF := FND_MESSAGE.get;
5337: l_log_message := FND_MESSAGE.get;
5338: MRP_UTIL.MRP_LOG(l_log_message);
5339: l_log_message := 'Problem with initialize_report procedure';
5340: MRP_UTIL.MRP_LOG(l_log_message);
5341: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5342:
5343: END initialize_report_WOD;
5344:

Line 5562: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5564: MRP_UTIL.MRP_LOG(l_log_message);

5560: ERRBUF := FND_MESSAGE.get;
5561: l_log_message := FND_MESSAGE.get;
5562: MRP_UTIL.MRP_LOG(l_log_message);
5563: l_log_message := 'Problem with initialize_report procedure';
5564: MRP_UTIL.MRP_LOG(l_log_message);
5565: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5566:
5567: END initialize_report_WD;
5568:

Line 5688: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5690: MRP_UTIL.MRP_LOG(l_log_message);

5686: ERRBUF := FND_MESSAGE.get;
5687: l_log_message := FND_MESSAGE.get;
5688: MRP_UTIL.MRP_LOG(l_log_message);
5689: l_log_message := 'Problem in report_update_WD procedure';
5690: MRP_UTIL.MRP_LOG(l_log_message);
5691: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5692: MRP_UTIL.MRP_LOG(l_log_message);
5693: END report_update_WD;
5694:

Line 5692: MRP_UTIL.MRP_LOG(l_log_message);

5688: MRP_UTIL.MRP_LOG(l_log_message);
5689: l_log_message := 'Problem in report_update_WD procedure';
5690: MRP_UTIL.MRP_LOG(l_log_message);
5691: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5692: MRP_UTIL.MRP_LOG(l_log_message);
5693: END report_update_WD;
5694:
5695: PROCEDURE report_update_WOD(p_query_id IN NUMBER,
5696: p_line_id IN NUMBER,

Line 5813: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5815: MRP_UTIL.MRP_LOG(l_log_message);

5811: ERRBUF := FND_MESSAGE.get;
5812: l_log_message := FND_MESSAGE.get;
5813: MRP_UTIL.MRP_LOG(l_log_message);
5814: l_log_message := 'Problem in report_update_WOD procedure';
5815: MRP_UTIL.MRP_LOG(l_log_message);
5816: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5817: MRP_UTIL.MRP_LOG(l_log_message);
5818:
5819: END report_update_WOD;

Line 5817: MRP_UTIL.MRP_LOG(l_log_message);

5813: MRP_UTIL.MRP_LOG(l_log_message);
5814: l_log_message := 'Problem in report_update_WOD procedure';
5815: MRP_UTIL.MRP_LOG(l_log_message);
5816: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
5817: MRP_UTIL.MRP_LOG(l_log_message);
5818:
5819: END report_update_WOD;
5820:
5821: PROCEDURE relieve_rolled_schedules(p_wip_entity_id IN NUMBER) IS

Line 5930: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5937: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5944: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5951: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5958: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5965: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5972: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5979: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5986: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5993: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6000: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6007: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6014: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6021: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6028: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6035: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6042: MRP_UTIL.MRP_LOG(l_log_message);

6038: -- if NULL. If line, item or category are null, assume all.
6039: IF p_organization_id IS NULL THEN
6040: FND_MESSAGE.set_name('MRP','MRP_ORG_ID_REQUIRED');
6041: l_log_message := FND_MESSAGE.get;
6042: MRP_UTIL.MRP_LOG(l_log_message);
6043: RAISE expected_error;
6044: END IF;
6045: IF (p_from_start_date IS NULL OR p_to_start_date IS NULL) AND
6046: (p_spread_qty <> 3) THEN

Line 6049: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6055: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6062: MRP_UTIL.MRP_LOG(l_log_message);

6058:
6059: IF p_to_end_date IS NULL AND (p_spread_qty = 1) THEN
6060: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');
6061: l_log_message := FND_MESSAGE.get;
6062: MRP_UTIL.MRP_LOG(l_log_message);
6063: RAISE expected_error;
6064: END IF;
6065:
6066: -- If either the from_end_date or the to_end_date are non-workdays

Line 6081: MRP_UTIL.MRP_LOG(l_log_message);

6077: FND_MESSAGE.set_name('MRP','MRP_FROM_DATE_CHANGED');
6078: FND_MESSAGE.set_token('ORIG_DATE',p_from_end_date);
6079: FND_MESSAGE.set_token('NEW_DATE',l_from_end_date);
6080: l_log_message := FND_MESSAGE.get;
6081: MRP_UTIL.MRP_LOG(l_log_message);
6082: END IF;
6083: ******************** Comment ends ***********************/
6084: END IF;
6085:

Line 6103: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6134: MRP_UTIL.MRP_LOG(l_log_message);

6130: FND_MESSAGE.set_token('ORIG_DATE',l_to_end_date);
6131: FND_MESSAGE.set_token('NEW_DATE',l_temp_date);
6132: l_log_message := FND_MESSAGE.get;
6133: l_to_end_date := l_temp_date;
6134: MRP_UTIL.MRP_LOG(l_log_message);
6135: END IF;
6136: --end of fix bug#3170105
6137:
6138: --bug 3832684: need it also for Spread Evenly wo Details

Line 6154: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6165: MRP_UTIL.MRP_OUT(l_out_message);

6161: SELECT to_char(sysdate)
6162: INTO l_trans_var2
6163: FROM dual;
6164: l_out_message := l_trans_var1 || ': ' || l_trans_var2;
6165: MRP_UTIL.MRP_OUT(l_out_message);
6166:
6167: FND_MESSAGE.set_name('MRP','MRP_ROLL_FLOW_REPORT');
6168: l_out_message := FND_MESSAGE.get;
6169: MRP_UTIL.MRP_OUT(' '||l_out_message);

Line 6169: MRP_UTIL.MRP_OUT(' '||l_out_message);

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

Line 6351: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6356: MRP_UTIL.MRP_LOG(l_log_message);

6352: ELSE
6353: IF l_msg_count > 0 THEN
6354: FOR i in 1..l_msg_count LOOP
6355: l_log_message := fnd_msg_pub.get(i,'F');
6356: MRP_UTIL.MRP_LOG(l_log_message);
6357: END LOOP;
6358: END IF;
6359: END IF;
6360: -- End if for p_output = 2 loop (report and update)

Line 6411: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6453: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6488: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6566: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6582: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6697: MRP_UTIL.MRP_LOG('quantity OK');

6693: THEN
6694:
6695: l_update_variance := fs_report_rec.planned_quantity
6696: - fs_report_rec.quantity_completed;
6697: MRP_UTIL.MRP_LOG('quantity OK');
6698:
6699: /*--------------------------------------------------------------+
6700: | We can have more than one schedule on a given date |
6701: | The cursor is sorted descending so we get the last schedule |

Line 6735: MRP_UTIL.MRP_LOG('Creating new build sequence for line='||fs_report_rec.line_id);

6731: | Start with a BASE NUMBER and keep incrementing it |
6732: | Keep separate counter linewise |
6733: | Keep NULL build sequence as NULL (manual) |
6734: +-----------------------------------------------------------------*/
6735: MRP_UTIL.MRP_LOG('Creating new build sequence for line='||fs_report_rec.line_id);
6736: if (fs_report_rec.build_sequence is not null) then
6737: if ( not l_build_seq_counter.exists(fs_report_rec.line_id) ) then
6738: -- Initialization of the Seq Counter table
6739: MRP_UTIL.MRP_LOG('Initialize the counter for line='||fs_report_rec.line_id);

Line 6739: MRP_UTIL.MRP_LOG('Initialize the counter for line='||fs_report_rec.line_id);

6735: MRP_UTIL.MRP_LOG('Creating new build sequence for line='||fs_report_rec.line_id);
6736: if (fs_report_rec.build_sequence is not null) then
6737: if ( not l_build_seq_counter.exists(fs_report_rec.line_id) ) then
6738: -- Initialization of the Seq Counter table
6739: MRP_UTIL.MRP_LOG('Initialize the counter for line='||fs_report_rec.line_id);
6740: l_build_seq_counter(fs_report_rec.line_id).base_number
6741: := Get_Base_Number(fs_report_rec.line_id,
6742: flm_timezone.client00_in_server(l_flow_schedule_rec.scheduled_completion_date),
6743: l_from_start_date, l_from_end_date); --fix bug#3170105

Line 6744: MRP_UTIL.MRP_LOG('Initialized base number='||

6740: l_build_seq_counter(fs_report_rec.line_id).base_number
6741: := Get_Base_Number(fs_report_rec.line_id,
6742: flm_timezone.client00_in_server(l_flow_schedule_rec.scheduled_completion_date),
6743: l_from_start_date, l_from_end_date); --fix bug#3170105
6744: MRP_UTIL.MRP_LOG('Initialized base number='||
6745: l_build_seq_counter(fs_report_rec.line_id).base_number);
6746: l_build_seq_counter(fs_report_rec.line_id).current_build_seq :=
6747: l_build_seq_counter(fs_report_rec.line_id).base_number + 1;
6748: MRP_UTIL.MRP_LOG('Initialized current build Seq number='||

Line 6748: MRP_UTIL.MRP_LOG('Initialized current build Seq number='||

6744: MRP_UTIL.MRP_LOG('Initialized base number='||
6745: l_build_seq_counter(fs_report_rec.line_id).base_number);
6746: l_build_seq_counter(fs_report_rec.line_id).current_build_seq :=
6747: l_build_seq_counter(fs_report_rec.line_id).base_number + 1;
6748: MRP_UTIL.MRP_LOG('Initialized current build Seq number='||
6749: l_build_seq_counter(fs_report_rec.line_id).current_build_seq);
6750: else
6751: MRP_UTIL.MRP_LOG('Increment the counter for line='||fs_report_rec.line_id);
6752: l_build_seq_counter(fs_report_rec.line_id).current_build_seq :=

Line 6751: MRP_UTIL.MRP_LOG('Increment the counter for line='||fs_report_rec.line_id);

6747: l_build_seq_counter(fs_report_rec.line_id).base_number + 1;
6748: MRP_UTIL.MRP_LOG('Initialized current build Seq number='||
6749: l_build_seq_counter(fs_report_rec.line_id).current_build_seq);
6750: else
6751: MRP_UTIL.MRP_LOG('Increment the counter for line='||fs_report_rec.line_id);
6752: l_build_seq_counter(fs_report_rec.line_id).current_build_seq :=
6753: l_build_seq_counter(fs_report_rec.line_id).current_build_seq + 1;
6754: end if;
6755: l_temp_build_sequence := l_build_seq_counter(fs_report_rec.line_id).current_build_seq;

Line 6757: MRP_UTIL.MRP_LOG('Build Seq Counter is NULL for line='||fs_report_rec.line_id);

6753: l_build_seq_counter(fs_report_rec.line_id).current_build_seq + 1;
6754: end if;
6755: l_temp_build_sequence := l_build_seq_counter(fs_report_rec.line_id).current_build_seq;
6756: else
6757: MRP_UTIL.MRP_LOG('Build Seq Counter is NULL for line='||fs_report_rec.line_id);
6758: l_temp_build_sequence := null;
6759: l_build_seq_counter(fs_report_rec.line_id).current_build_seq := NULL;
6760: end if;
6761: MRP_UTIL.MRP_LOG('Resultant Build Seq Counter is ='||l_temp_build_sequence);

Line 6761: MRP_UTIL.MRP_LOG('Resultant Build Seq Counter is ='||l_temp_build_sequence);

6757: MRP_UTIL.MRP_LOG('Build Seq Counter is NULL for line='||fs_report_rec.line_id);
6758: l_temp_build_sequence := null;
6759: l_build_seq_counter(fs_report_rec.line_id).current_build_seq := NULL;
6760: end if;
6761: MRP_UTIL.MRP_LOG('Resultant Build Seq Counter is ='||l_temp_build_sequence);
6762:
6763: l_flow_schedule_rec.build_sequence:= l_temp_build_sequence;
6764:
6765: -- Bug 2213859

Line 6887: MRP_UTIL.MRP_LOG('Calling MRP_Flow_Schedule_PVT.Process_Flow_Schedule');

6883: l_to_start_date,
6884: l_to_end_date);
6885:
6886: -- Bug 2213859
6887: MRP_UTIL.MRP_LOG('Calling MRP_Flow_Schedule_PVT.Process_Flow_Schedule');
6888: -- Bug 2213859
6889:
6890: MRP_Flow_Schedule_PVT.Process_Flow_Schedule
6891: ( p_api_version_number => 1.0,

Line 6952: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 6957: MRP_UTIL.MRP_LOG(l_log_message);

6953: ELSE
6954: IF l_msg_count > 0 THEN
6955: FOR i in 1..l_msg_count LOOP
6956: l_log_message := fnd_msg_pub.get(i,'F');
6957: MRP_UTIL.MRP_LOG(l_log_message);
6958: END LOOP;
6959: END IF;
6960: END IF;
6961: -- end if for p_output = 2

Line 6972: MRP_UTIL.MRP_LOG('item = '||to_char(l_old_item_id)||' var = '||to_char(l_unprocessed_var));

6968: l_old_line_code := fs_report_rec.line_code;
6969: l_old_item_id := fs_report_rec.primary_item_id;
6970: l_old_item := fs_report_rec.item;
6971: l_old_sg_id := fs_report_rec.schedule_group_id;
6972: MRP_UTIL.MRP_LOG('item = '||to_char(l_old_item_id)||' var = '||to_char(l_unprocessed_var));
6973: END LOOP;
6974:
6975: -- Bug 2213859
6976: /*-----------------------------------------------------------------+

Line 6989: MRP_UTIL.MRP_LOG('Shift build sequences of existing schedules on destination day');

6985: where roll_forwarded_flag =
6986: G_INTERMEDIATE_ROLL_FORWARDED;
6987: **************************************************/
6988:
6989: MRP_UTIL.MRP_LOG('Shift build sequences of existing schedules on destination day');
6990: -- Bug 2558664 handled NULL build sequence counter gracefully
6991: if (l_build_seq_counter.count > 0) then
6992: l_index := l_build_seq_counter.first;
6993: loop

Line 6995: MRP_UTIL.MRP_LOG('Proccessing for line='||l_index);

6991: if (l_build_seq_counter.count > 0) then
6992: l_index := l_build_seq_counter.first;
6993: loop
6994: if (l_build_seq_counter.exists(l_index)) then
6995: MRP_UTIL.MRP_LOG('Proccessing for line='||l_index);
6996: l_base_number := nvl(l_build_seq_counter(l_index).base_number,0);
6997: l_total_count := nvl(l_build_seq_counter(l_index).current_build_seq,0) - l_base_number;
6998: MRP_UTIL.MRP_LOG('Shift each BUILD_SEQ of existing eligible schedules by '||l_total_count);
6999:

Line 6998: MRP_UTIL.MRP_LOG('Shift each BUILD_SEQ of existing eligible schedules by '||l_total_count);

6994: if (l_build_seq_counter.exists(l_index)) then
6995: MRP_UTIL.MRP_LOG('Proccessing for line='||l_index);
6996: l_base_number := nvl(l_build_seq_counter(l_index).base_number,0);
6997: l_total_count := nvl(l_build_seq_counter(l_index).current_build_seq,0) - l_base_number;
6998: MRP_UTIL.MRP_LOG('Shift each BUILD_SEQ of existing eligible schedules by '||l_total_count);
6999:
7000: UPDATE wip_flow_schedules
7001: set BUILD_SEQUENCE = BUILD_SEQUENCE + l_total_count
7002: WHERE organization_id = p_organization_id

Line 7122: MRP_UTIL.MRP_LOG('Closed Schedule with wip_entity_id:'||to_char(

7118: EXIT WHEN l_rows = 0;
7119: UPDATE wip_flow_schedules SET status = 2,
7120: date_closed = flm_timezone.sysdate00_in_server --fix bug#3170105
7121: WHERE wip_entity_id = l_flow_schedule_rec.wip_entity_id;
7122: MRP_UTIL.MRP_LOG('Closed Schedule with wip_entity_id:'||to_char(
7123: l_flow_schedule_rec.wip_entity_id));
7124: END LOOP;
7125: END IF;
7126:

Line 7147: MRP_UTIL.MRP_OUT(l_out_message);

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

Line 7168: MRP_UTIL.MRP_OUT(l_out_message);

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

Line 7194: MRP_UTIL.MRP_OUT(l_out_message);

7190: rpad(substr(l_trans_var4,1,9),9) || ' ' ||
7191: rpad(substr(l_trans_var5,1,8),8) || ' ' ||
7192: rpad(substr(l_trans_var5,1,8),8) || ' ' ||
7193: rpad(substr(l_trans_var5,1,8),8);
7194: MRP_UTIL.MRP_OUT(l_out_message);
7195: l_out_message := '---------- -------------- -------- --------- --------- --------- -------- --------- -------- -------- --------';
7196: MRP_UTIL.MRP_OUT(l_out_message);
7197:
7198: -- Reinitialize values

Line 7196: MRP_UTIL.MRP_OUT(l_out_message);

7192: rpad(substr(l_trans_var5,1,8),8) || ' ' ||
7193: rpad(substr(l_trans_var5,1,8),8);
7194: MRP_UTIL.MRP_OUT(l_out_message);
7195: l_out_message := '---------- -------------- -------- --------- --------- --------- -------- --------- -------- -------- --------';
7196: MRP_UTIL.MRP_OUT(l_out_message);
7197:
7198: -- Reinitialize values
7199: l_old_line_id := -1;
7200: l_old_item_id := -1;

Line 7248: MRP_UTIL.MRP_OUT(l_out_message);

7244:
7245: CLOSE REPORT_TOTALS;
7246:
7247: l_out_message := '-------------------------------------------- --------- --------- -------- --------- -------- -------- --------';
7248: MRP_UTIL.MRP_OUT(l_out_message);
7249:
7250: FND_MESSAGE.set_name('MRP','EC_TOTAL');
7251: l_out_message := FND_MESSAGE.get;
7252:

Line 7260: MRP_UTIL.MRP_OUT(l_out_message);

7256: ' ' ||
7257: lpad(l_scheduled_total,8) || ' ' || lpad(l_adjusted_total,8) || ' ' ||
7258: lpad(l_variance2_total,8);
7259:
7260: MRP_UTIL.MRP_OUT(l_out_message);
7261:
7262: l_out_message := ' ';
7263: MRP_UTIL.MRP_OUT(l_out_message);
7264: END IF;

Line 7263: MRP_UTIL.MRP_OUT(l_out_message);

7259:
7260: MRP_UTIL.MRP_OUT(l_out_message);
7261:
7262: l_out_message := ' ';
7263: MRP_UTIL.MRP_OUT(l_out_message);
7264: END IF;
7265:
7266: IF REPORT_CURSOR%NOTFOUND THEN
7267: FND_MESSAGE.set_name('MRP','EC_END_OF_REPORT');

Line 7269: MRP_UTIL.MRP_OUT(l_out_message);

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

Line 7285: MRP_UTIL.MRP_OUT(l_out_message);

7281: lpad(fs_report_rec.to_scheduled_qty,8) || ' ' ||
7282: lpad(fs_report_rec.to_adjusted_qty,8) || ' ' ||
7283: lpad(fs_report_rec.variance2,8);
7284:
7285: MRP_UTIL.MRP_OUT(l_out_message);
7286:
7287: l_old_sg_id := fs_report_rec.schedule_group_id;
7288: l_old_item_id := fs_report_rec.primary_item_id;
7289: l_old_line_id := fs_report_rec.line_id;

Line 7311: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 7313: MRP_UTIL.MRP_LOG(l_log_message);

7309: ERRBUF := FND_MESSAGE.get;
7310: l_log_message := FND_MESSAGE.get;
7311: MRP_UTIL.MRP_LOG(l_log_message);
7312: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7313: MRP_UTIL.MRP_LOG(l_log_message);
7314:
7315: WHEN unexpected_error THEN
7316: ROLLBACK;
7317: RETCODE := G_ERROR;

Line 7321: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 7323: MRP_UTIL.MRP_LOG(l_log_message);

7319: ERRBUF := FND_MESSAGE.get;
7320: l_log_message := FND_MESSAGE.get;
7321: MRP_UTIL.MRP_LOG(l_log_message);
7322: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7323: MRP_UTIL.MRP_LOG(l_log_message);
7324:
7325: WHEN OTHERS THEN
7326: ROLLBACK;
7327: RETCODE := G_ERROR;

Line 7331: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 7333: MRP_UTIL.MRP_LOG(l_log_message);

7329: ERRBUF := FND_MESSAGE.get;
7330: l_log_message := FND_MESSAGE.get;
7331: MRP_UTIL.MRP_LOG(l_log_message);
7332: l_log_message := 'Unexpected SQL Error: '||sqlerrm;
7333: MRP_UTIL.MRP_LOG(l_log_message);
7334:
7335: END Roll_Flow_Schedules;
7336:
7337: -- ========================================================================

Line 8031: mrp_util.mrp_log('Excpetion during checking holds ' || sqlerrm );

8027: return l_return;
8028:
8029: EXCEPTION
8030: WHEN OTHERS THEN
8031: mrp_util.mrp_log('Excpetion during checking holds ' || sqlerrm );
8032: return 1;
8033:
8034: END Check_ATO_Holds;
8035:

Line 8172: mrp_util.mrp_log('Excpetion during checking holds ' || sqlerrm );

8168:
8169: return l_return;
8170: EXCEPTION
8171: WHEN OTHERS THEN
8172: mrp_util.mrp_log('Excpetion during checking holds ' || sqlerrm );
8173: return 1;
8174: END Check_Holds;
8175:
8176: FUNCTION get_routing_designator(