499:
500: procedure description is begin
501: if(wjsi_row.description is null) then
502: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
503: fnd_message.set_name('WIP','WIP_MLD_DESC');
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
500: procedure description is begin
501: if(wjsi_row.description is null) then
502: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
503: fnd_message.set_name('WIP','WIP_MLD_DESC');
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
508: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
501: if(wjsi_row.description is null) then
502: if(wjsi_row.load_type in (wip_constants.create_job, wip_constants.create_ns_job)) then
503: fnd_message.set_name('WIP','WIP_MLD_DESC');
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
508: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
509: wjsi_row.description := fnd_message.get;
503: fnd_message.set_name('WIP','WIP_MLD_DESC');
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
508: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
509: wjsi_row.description := fnd_message.get;
510: end if;
511: end if;
504: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
508: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
509: wjsi_row.description := fnd_message.get;
510: end if;
511: end if;
512: end description;
505: wjsi_row.description := fnd_message.get;
506: elsif(wjsi_row.load_type = wip_constants.create_sched) then
507: fnd_message.set_name('WIP','WIP_MLR_DESC');
508: fnd_message.set_token('LOAD_DATE', fnd_date.date_to_charDT(sysdate), false);
509: wjsi_row.description := fnd_message.get;
510: end if;
511: end if;
512: end description;
513:
801: x_return_status => l_returnMsg, -- Return Status
802: x_msg_data => l_errMsg1); -- Error messages
803: end if;
804: if (l_errMsg1 is not null) then
805: fnd_message.set_name('WIP', l_errMsg1);
806: fnd_message.set_token('class_code', l_errClass1, false);
807: wip_jsi_utils.record_current_error ;
808: end if ;
809: if (l_errMsg2 is not null) then
802: x_msg_data => l_errMsg1); -- Error messages
803: end if;
804: if (l_errMsg1 is not null) then
805: fnd_message.set_name('WIP', l_errMsg1);
806: fnd_message.set_token('class_code', l_errClass1, false);
807: wip_jsi_utils.record_current_error ;
808: end if ;
809: if (l_errMsg2 is not null) then
810: fnd_message.set_name('WIP', l_errMsg2);
806: fnd_message.set_token('class_code', l_errClass1, false);
807: wip_jsi_utils.record_current_error ;
808: end if ;
809: if (l_errMsg2 is not null) then
810: fnd_message.set_name('WIP', l_errMsg2);
811: fnd_message.set_token('class_code', l_errClass2, false);
812: wip_jsi_utils.record_current_error ;
813: end if ;
814: elsif(wjsi_row.load_type in (wip_constants.resched_job,
807: wip_jsi_utils.record_current_error ;
808: end if ;
809: if (l_errMsg2 is not null) then
810: fnd_message.set_name('WIP', l_errMsg2);
811: fnd_message.set_token('class_code', l_errClass2, false);
812: wip_jsi_utils.record_current_error ;
813: end if ;
814: elsif(wjsi_row.load_type in (wip_constants.resched_job,
815: wip_constants.resched_eam_job,
1489: x_return_status => l_returnMsg,
1490: x_msg_count => l_msgCount,
1491: x_msg_data => l_errMsg);
1492: if (l_errMsg is not null) then
1493: fnd_message.set_name('WIP', 'OWNING_DEPARTMENT');
1494: fnd_message.set_token('owning_department', wjsi_row.owning_department, false);
1495: wip_jsi_utils.record_current_error;
1496: end if ;
1497: elsif(wjsi_row.owning_department_code is not null) then
1490: x_msg_count => l_msgCount,
1491: x_msg_data => l_errMsg);
1492: if (l_errMsg is not null) then
1493: fnd_message.set_name('WIP', 'OWNING_DEPARTMENT');
1494: fnd_message.set_token('owning_department', wjsi_row.owning_department, false);
1495: wip_jsi_utils.record_current_error;
1496: end if ;
1497: elsif(wjsi_row.owning_department_code is not null) then
1498: WIP_JSI_Utils.record_ignored_column_warning('OWNING_DEPARTMENT_CODE');
1527: x_return_status => l_returnMsg,
1528: x_msg_count => l_msgCount,
1529: x_msg_data => l_errMsg);
1530: if (l_errMsg is not null) then
1531: fnd_message.set_name('WIP', 'NOTIFICATION_REQUIRED');
1532: fnd_message.set_token('notification_required', wjsi_row.notification_required, false);
1533: wip_jsi_utils.record_current_error;
1534: end if ;
1535: end if;
1528: x_msg_count => l_msgCount,
1529: x_msg_data => l_errMsg);
1530: if (l_errMsg is not null) then
1531: fnd_message.set_name('WIP', 'NOTIFICATION_REQUIRED');
1532: fnd_message.set_token('notification_required', wjsi_row.notification_required, false);
1533: wip_jsi_utils.record_current_error;
1534: end if ;
1535: end if;
1536:
1563: x_return_status => l_returnMsg,
1564: x_msg_count => l_msgCount,
1565: x_msg_data => l_errMsg);
1566: if (l_errMsg is not null) then
1567: fnd_message.set_name('WIP', 'SHUTDOWN_TYPE');
1568: fnd_message.set_token('shutdown_type', wjsi_row.shutdown_type, false);
1569: wip_jsi_utils.record_current_error;
1570: end if ;
1571: end if;
1564: x_msg_count => l_msgCount,
1565: x_msg_data => l_errMsg);
1566: if (l_errMsg is not null) then
1567: fnd_message.set_name('WIP', 'SHUTDOWN_TYPE');
1568: fnd_message.set_token('shutdown_type', wjsi_row.shutdown_type, false);
1569: wip_jsi_utils.record_current_error;
1570: end if ;
1571: end if;
1572:
1606: x_return_status => l_returnMsg,
1607: x_msg_count => l_msgCount,
1608: x_msg_data => l_errMsg);
1609: if (l_errMsg is not null) then
1610: fnd_message.set_name('WIP', 'TAGOUT_REQUIRED');
1611: fnd_message.set_token('tagout_required', wjsi_row.tagout_required, false);
1612: wip_jsi_utils.record_current_error;
1613: end if ;
1614: end if;
1607: x_msg_count => l_msgCount,
1608: x_msg_data => l_errMsg);
1609: if (l_errMsg is not null) then
1610: fnd_message.set_name('WIP', 'TAGOUT_REQUIRED');
1611: fnd_message.set_token('tagout_required', wjsi_row.tagout_required, false);
1612: wip_jsi_utils.record_current_error;
1613: end if ;
1614: end if;
1615:
1651: x_return_status => l_returnMsg,
1652: x_msg_count => l_msgCount,
1653: x_msg_data => l_errMsg);
1654: if (l_errMsg is not null) then
1655: fnd_message.set_name('WIP', 'ACTIVITY_TYPE');
1656: fnd_message.set_token('activity_type', wjsi_row.activity_type, false);
1657: wip_jsi_utils.record_current_error;
1658: end if;
1659: end if;
1652: x_msg_count => l_msgCount,
1653: x_msg_data => l_errMsg);
1654: if (l_errMsg is not null) then
1655: fnd_message.set_name('WIP', 'ACTIVITY_TYPE');
1656: fnd_message.set_token('activity_type', wjsi_row.activity_type, false);
1657: wip_jsi_utils.record_current_error;
1658: end if;
1659: end if;
1660:
1687: x_return_status => l_returnMsg,
1688: x_msg_count => l_msgCount,
1689: x_msg_data => l_errMsg);
1690: if (l_errMsg is not null) then
1691: fnd_message.set_name('WIP', 'ACTIVITY_CAUSE');
1692: fnd_message.set_token('activity_cause', wjsi_row.activity_cause, false);
1693: wip_jsi_utils.record_current_error;
1694: end if;
1695: end if;
1688: x_msg_count => l_msgCount,
1689: x_msg_data => l_errMsg);
1690: if (l_errMsg is not null) then
1691: fnd_message.set_name('WIP', 'ACTIVITY_CAUSE');
1692: fnd_message.set_token('activity_cause', wjsi_row.activity_cause, false);
1693: wip_jsi_utils.record_current_error;
1694: end if;
1695: end if;
1696:
1851: x_return_status => l_returnMsg,
1852: x_msg_count => l_msgCount,
1853: x_msg_data => l_errMsg);
1854: if (l_errMsg is not null) then
1855: fnd_message.set_name('WIP', 'ACTIVITY_SOURCE');
1856: fnd_message.set_token('activity_source', wjsi_row.activity_source, false);
1857: wip_jsi_utils.record_current_error;
1858: end if;
1859: end if;
1852: x_msg_count => l_msgCount,
1853: x_msg_data => l_errMsg);
1854: if (l_errMsg is not null) then
1855: fnd_message.set_name('WIP', 'ACTIVITY_SOURCE');
1856: fnd_message.set_token('activity_source', wjsi_row.activity_source, false);
1857: wip_jsi_utils.record_current_error;
1858: end if;
1859: end if;
1860: