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 3467: MRP_UTIL.MRP_LOG(l_log_message);

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');
3471: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');

Line 3474: MRP_UTIL.MRP_LOG(l_log_message);

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');
3478: FND_MESSAGE.set_token('TOKEN','(START_DATE)');

Line 3481: MRP_UTIL.MRP_LOG(l_log_message);

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');
3485: FND_MESSAGE.set_token('TOKEN','(END_DATE)');

Line 3488: MRP_UTIL.MRP_LOG(l_log_message);

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');
3492: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');

Line 3495: MRP_UTIL.MRP_LOG(l_log_message);

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');
3499: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');

Line 3502: MRP_UTIL.MRP_LOG(l_log_message);

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');
3506: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');

Line 3509: MRP_UTIL.MRP_LOG(l_log_message);

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');
3513: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');

Line 3516: MRP_UTIL.MRP_LOG(l_log_message);

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');
3520: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');

Line 3523: MRP_UTIL.MRP_LOG(l_log_message);

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');
3527: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');

Line 3530: MRP_UTIL.MRP_LOG(l_log_message);

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');
3534: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');

Line 3537: MRP_UTIL.MRP_LOG(l_log_message);

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');
3541: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');

Line 3544: MRP_UTIL.MRP_LOG(l_log_message);

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
3548: -- if NULL. If line, item or category are null, assume all.

Line 3552: MRP_UTIL.MRP_LOG(l_log_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
3556: FND_MESSAGE.set_name('MRP','MRP_START_DATE_REQUIRED');

Line 3558: MRP_UTIL.MRP_LOG(l_log_message);

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
3562: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');

Line 3564: MRP_UTIL.MRP_LOG(l_log_message);

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:
3568: -- begin new binds

Line 3591: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3593: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3614: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3616: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3689: MRP_UTIL.MRP_LOG(l_msg_data);

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

Line 3721: MRP_UTIL.MRP_LOG(l_log_message);

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;
3725: MRP_UTIL.MRP_LOG(l_log_message);

Line 3725: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 3735: MRP_UTIL.MRP_LOG(l_log_message);

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;
3739: IF RETCODE <> 1 THEN

Line 3745: MRP_UTIL.MRP_LOG(l_log_message);

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;
3749: RETCODE := G_ERROR;

Line 3753: MRP_UTIL.MRP_LOG(l_log_message);

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;
3757: RETCODE := G_ERROR;

Line 3761: MRP_UTIL.MRP_LOG(l_log_message);

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:
3765: END Delete_Flow_Schedules;

Line 3763: MRP_UTIL.MRP_LOG(l_log_message);

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:
3765: END Delete_Flow_Schedules;
3766:
3767:

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

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

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

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

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

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

Line 4279: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4281: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4301: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4303: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4381: MRP_UTIL.MRP_LOG(l_log_message);

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
4385: -- English because unexpected error

Line 4387: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4390: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4434: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4436: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4455: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4457: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4558: MRP_UTIL.MRP_LOG(l_log_message);

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:
4562: WHEN OTHERS THEN

Line 4566: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4569: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4616: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4618: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4638: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4640: MRP_UTIL.MRP_LOG(l_log_message);

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

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

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

Line 4827: MRP_UTIL.MRP_LOG(l_log_message);

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:
4831: WHEN OTHERS THEN

Line 4835: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4838: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4865: MRP_UTIL.MRP_LOG(l_log_message);

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:
4869: WHEN OTHERS THEN

Line 4873: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4876: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4909: MRP_UTIL.MRP_LOG(l_log_message);

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:
4913: WHEN OTHERS THEN

Line 4917: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4920: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4968: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4970: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4990: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 4992: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5085: MRP_UTIL.MRP_LOG(l_log_message);

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:
5089: WHEN OTHERS THEN

Line 5093: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5096: MRP_UTIL.MRP_LOG(l_log_message);

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

Line 5335: MRP_UTIL.MRP_LOG(l_log_message);

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;
5339:

Line 5337: MRP_UTIL.MRP_LOG(l_log_message);

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;
5339:
5340: END initialize_report_WOD;
5341:

Line 5559: MRP_UTIL.MRP_LOG(l_log_message);

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;
5563:

Line 5561: MRP_UTIL.MRP_LOG(l_log_message);

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;
5563:
5564: END initialize_report_WD;
5565:

Line 5685: MRP_UTIL.MRP_LOG(l_log_message);

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;
5689: MRP_UTIL.MRP_LOG(l_log_message);

Line 5687: MRP_UTIL.MRP_LOG(l_log_message);

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;
5689: MRP_UTIL.MRP_LOG(l_log_message);
5690: END report_update_WD;
5691:

Line 5689: MRP_UTIL.MRP_LOG(l_log_message);

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;
5689: MRP_UTIL.MRP_LOG(l_log_message);
5690: END report_update_WD;
5691:
5692: PROCEDURE report_update_WOD(p_query_id IN NUMBER,
5693: p_line_id IN NUMBER,

Line 5810: MRP_UTIL.MRP_LOG(l_log_message);

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;
5814: MRP_UTIL.MRP_LOG(l_log_message);

Line 5812: MRP_UTIL.MRP_LOG(l_log_message);

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;
5814: MRP_UTIL.MRP_LOG(l_log_message);
5815:
5816: END report_update_WOD;

Line 5814: MRP_UTIL.MRP_LOG(l_log_message);

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;
5814: MRP_UTIL.MRP_LOG(l_log_message);
5815:
5816: END report_update_WOD;
5817:
5818: PROCEDURE relieve_rolled_schedules(p_wip_entity_id IN NUMBER) IS

Line 5927: MRP_UTIL.MRP_LOG(l_log_message);

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');
5931: FND_MESSAGE.set_token('TOKEN','(ORGANIZATION_ID)');

Line 5934: MRP_UTIL.MRP_LOG(l_log_message);

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');
5938: FND_MESSAGE.set_token('TOKEN','(OUTPUT)');

Line 5941: MRP_UTIL.MRP_LOG(l_log_message);

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');
5945: FND_MESSAGE.set_token('TOKEN','(FROM_START_DATE)');

Line 5948: MRP_UTIL.MRP_LOG(l_log_message);

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');
5952: FND_MESSAGE.set_token('TOKEN','(FROM_END_DATE)');

Line 5955: MRP_UTIL.MRP_LOG(l_log_message);

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');
5959: FND_MESSAGE.set_token('TOKEN','(TO_START_DATE)');

Line 5962: MRP_UTIL.MRP_LOG(l_log_message);

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');
5966: FND_MESSAGE.set_token('TOKEN','(TO_END_DATE)');

Line 5969: MRP_UTIL.MRP_LOG(l_log_message);

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');
5973: FND_MESSAGE.set_token('TOKEN','(FROM_LINE)');

Line 5976: MRP_UTIL.MRP_LOG(l_log_message);

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');
5980: FND_MESSAGE.set_token('TOKEN','(TO_LINE)');

Line 5983: MRP_UTIL.MRP_LOG(l_log_message);

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');
5987: FND_MESSAGE.set_token('TOKEN','(FROM_ITEM)');

Line 5990: MRP_UTIL.MRP_LOG(l_log_message);

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');
5994: FND_MESSAGE.set_token('TOKEN','(TO_ITEM)');

Line 5997: MRP_UTIL.MRP_LOG(l_log_message);

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');
6001: FND_MESSAGE.set_token('TOKEN','(CATEGORY_SET_ID)');

Line 6004: MRP_UTIL.MRP_LOG(l_log_message);

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');
6008: FND_MESSAGE.set_token('TOKEN','(CATEGORY_STRUCTURE_ID)');

Line 6011: MRP_UTIL.MRP_LOG(l_log_message);

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');
6015: FND_MESSAGE.set_token('TOKEN','(FROM_CATEGORY)');

Line 6018: MRP_UTIL.MRP_LOG(l_log_message);

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');
6022: FND_MESSAGE.set_token('TOKEN','(TO_CATEGORY)');

Line 6025: MRP_UTIL.MRP_LOG(l_log_message);

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');
6029: FND_MESSAGE.set_token('TOKEN','(SPREAD_QTY)');

Line 6032: MRP_UTIL.MRP_LOG(l_log_message);

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.
6036: IF p_organization_id IS NULL THEN

Line 6039: MRP_UTIL.MRP_LOG(l_log_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
6043: (p_spread_qty <> 3) THEN

Line 6046: MRP_UTIL.MRP_LOG(l_log_message);

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
6050: FND_MESSAGE.set_name('MRP','MRP_END_DATE_REQUIRED');

Line 6052: MRP_UTIL.MRP_LOG(l_log_message);

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:
6056: IF p_to_end_date IS NULL AND (p_spread_qty = 1) THEN

Line 6059: MRP_UTIL.MRP_LOG(l_log_message);

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:
6063: -- If either the from_end_date or the to_end_date are non-workdays

Line 6078: MRP_UTIL.MRP_LOG(l_log_message);

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;
6082:

Line 6100: MRP_UTIL.MRP_LOG(l_log_message);

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
6104: l_to_start_date := l_temp_date;

Line 6131: MRP_UTIL.MRP_LOG(l_log_message);

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
6134:
6135: --bug 3832684: need it also for Spread Evenly wo Details

Line 6151: MRP_UTIL.MRP_LOG(l_log_message);

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: ****************************************************************************/
6155:

Line 6162: MRP_UTIL.MRP_OUT(l_out_message);

6158: SELECT to_char(sysdate)
6159: INTO 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);

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

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 |
6170: | into mrp_form_query |

Line 6348: MRP_UTIL.MRP_LOG(l_log_message);

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
6352: l_log_message := fnd_msg_pub.get(i,'F');

Line 6353: 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
6352: l_log_message := fnd_msg_pub.get(i,'F');
6353: MRP_UTIL.MRP_LOG(l_log_message);
6354: END LOOP;
6355: END IF;
6356: END IF;
6357: -- End if for p_output = 2 loop (report and update)

Line 6408: MRP_UTIL.MRP_LOG(l_log_message);

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 -
6412: l_quantity_completed) THEN

Line 6450: MRP_UTIL.MRP_LOG(l_log_message);

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);
6454: END IF;

Line 6485: MRP_UTIL.MRP_LOG(l_log_message);

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
6489: LOOP

Line 6563: MRP_UTIL.MRP_LOG(l_log_message);

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);
6567: END IF;

Line 6579: MRP_UTIL.MRP_LOG(l_log_message);

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;
6583: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 6949: MRP_UTIL.MRP_LOG(l_log_message);

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
6953: l_log_message := fnd_msg_pub.get(i,'F');

Line 6954: 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
6953: l_log_message := fnd_msg_pub.get(i,'F');
6954: MRP_UTIL.MRP_LOG(l_log_message);
6955: END LOOP;
6956: END IF;
6957: END IF;
6958: -- end if for p_output = 2

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

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

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

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

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

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

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

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

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

7093: EXIT WHEN l_rows = 0;
7094: UPDATE wip_flow_schedules SET status = 2,
7095: date_closed = flm_timezone.sysdate00_in_server --fix bug#3170105
7096: WHERE wip_entity_id = l_flow_schedule_rec.wip_entity_id;
7097: MRP_UTIL.MRP_LOG('Closed Schedule with wip_entity_id:'||to_char(
7098: l_flow_schedule_rec.wip_entity_id));
7099: END LOOP;
7100: END IF;
7101:

Line 7122: MRP_UTIL.MRP_OUT(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');

Line 7143: MRP_UTIL.MRP_OUT(l_out_message);

7139: rpad(substr(l_trans_var1,1,8),8) || ' ' ||
7140: rpad(substr(l_trans_var1,1,8),8) || ' ' ||
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');

Line 7169: MRP_UTIL.MRP_OUT(l_out_message);

7165: rpad(substr(l_trans_var4,1,9),9) || ' ' ||
7166: rpad(substr(l_trans_var5,1,8),8) || ' ' ||
7167: rpad(substr(l_trans_var5,1,8),8) || ' ' ||
7168: rpad(substr(l_trans_var5,1,8),8);
7169: MRP_UTIL.MRP_OUT(l_out_message);
7170: l_out_message := '---------- -------------- -------- --------- --------- --------- -------- --------- -------- -------- --------';
7171: MRP_UTIL.MRP_OUT(l_out_message);
7172:
7173: -- Reinitialize values

Line 7171: MRP_UTIL.MRP_OUT(l_out_message);

7167: rpad(substr(l_trans_var5,1,8),8) || ' ' ||
7168: rpad(substr(l_trans_var5,1,8),8);
7169: MRP_UTIL.MRP_OUT(l_out_message);
7170: l_out_message := '---------- -------------- -------- --------- --------- --------- -------- --------- -------- -------- --------';
7171: MRP_UTIL.MRP_OUT(l_out_message);
7172:
7173: -- Reinitialize values
7174: l_old_line_id := -1;
7175: l_old_item_id := -1;

Line 7223: MRP_UTIL.MRP_OUT(l_out_message);

7219:
7220: CLOSE REPORT_TOTALS;
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:

Line 7235: MRP_UTIL.MRP_OUT(l_out_message);

7231: ' ' ||
7232: lpad(l_scheduled_total,8) || ' ' || lpad(l_adjusted_total,8) || ' ' ||
7233: lpad(l_variance2_total,8);
7234:
7235: MRP_UTIL.MRP_OUT(l_out_message);
7236:
7237: l_out_message := ' ';
7238: MRP_UTIL.MRP_OUT(l_out_message);
7239: END IF;

Line 7238: MRP_UTIL.MRP_OUT(l_out_message);

7234:
7235: MRP_UTIL.MRP_OUT(l_out_message);
7236:
7237: l_out_message := ' ';
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');

Line 7244: MRP_UTIL.MRP_OUT(l_out_message);

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:
7248: l_out_message := fs_report_rec.line_code || ' ' ||

Line 7260: MRP_UTIL.MRP_OUT(l_out_message);

7256: lpad(fs_report_rec.to_scheduled_qty,8) || ' ' ||
7257: lpad(fs_report_rec.to_adjusted_qty,8) || ' ' ||
7258: lpad(fs_report_rec.variance2,8);
7259:
7260: MRP_UTIL.MRP_OUT(l_out_message);
7261:
7262: l_old_sg_id := fs_report_rec.schedule_group_id;
7263: l_old_item_id := fs_report_rec.primary_item_id;
7264: l_old_line_id := fs_report_rec.line_id;

Line 7286: MRP_UTIL.MRP_LOG(l_log_message);

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:
7290: WHEN unexpected_error THEN

Line 7288: MRP_UTIL.MRP_LOG(l_log_message);

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:
7290: WHEN unexpected_error THEN
7291: ROLLBACK;
7292: RETCODE := G_ERROR;

Line 7296: MRP_UTIL.MRP_LOG(l_log_message);

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:
7300: WHEN OTHERS THEN

Line 7298: MRP_UTIL.MRP_LOG(l_log_message);

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:
7300: WHEN OTHERS THEN
7301: ROLLBACK;
7302: RETCODE := G_ERROR;

Line 7306: MRP_UTIL.MRP_LOG(l_log_message);

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:
7310: END Roll_Flow_Schedules;

Line 7308: MRP_UTIL.MRP_LOG(l_log_message);

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:
7310: END Roll_Flow_Schedules;
7311:
7312: -- ========================================================================

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

8000: return l_return;
8001:
8002: EXCEPTION
8003: WHEN OTHERS THEN
8004: mrp_util.mrp_log('Excpetion during checking holds ' || sqlerrm );
8005: return 1;
8006:
8007: END Check_ATO_Holds;
8008:

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

8141:
8142: return l_return;
8143: EXCEPTION
8144: WHEN OTHERS THEN
8145: mrp_util.mrp_log('Excpetion during checking holds ' || sqlerrm );
8146: return 1;
8147: END Check_Holds;
8148:
8149: FUNCTION get_routing_designator(