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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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(dateval => sysdate,calendar_aware => 2), 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,
1513: x_return_status => l_returnMsg,
1514: x_msg_count => l_msgCount,
1515: x_msg_data => l_errMsg);
1516: if (l_errMsg is not null) then
1517: fnd_message.set_name('WIP', 'OWNING_DEPARTMENT');
1518: fnd_message.set_token('owning_department', wjsi_row.owning_department, false);
1519: wip_jsi_utils.record_current_error;
1520: end if ;
1521: elsif(wjsi_row.owning_department_code is not null) then
1514: x_msg_count => l_msgCount,
1515: x_msg_data => l_errMsg);
1516: if (l_errMsg is not null) then
1517: fnd_message.set_name('WIP', 'OWNING_DEPARTMENT');
1518: fnd_message.set_token('owning_department', wjsi_row.owning_department, false);
1519: wip_jsi_utils.record_current_error;
1520: end if ;
1521: elsif(wjsi_row.owning_department_code is not null) then
1522: WIP_JSI_Utils.record_ignored_column_warning('OWNING_DEPARTMENT_CODE');
1551: x_return_status => l_returnMsg,
1552: x_msg_count => l_msgCount,
1553: x_msg_data => l_errMsg);
1554: if (l_errMsg is not null) then
1555: fnd_message.set_name('WIP', 'NOTIFICATION_REQUIRED');
1556: fnd_message.set_token('notification_required', wjsi_row.notification_required, false);
1557: wip_jsi_utils.record_current_error;
1558: end if ;
1559: end if;
1552: x_msg_count => l_msgCount,
1553: x_msg_data => l_errMsg);
1554: if (l_errMsg is not null) then
1555: fnd_message.set_name('WIP', 'NOTIFICATION_REQUIRED');
1556: fnd_message.set_token('notification_required', wjsi_row.notification_required, false);
1557: wip_jsi_utils.record_current_error;
1558: end if ;
1559: end if;
1560:
1587: x_return_status => l_returnMsg,
1588: x_msg_count => l_msgCount,
1589: x_msg_data => l_errMsg);
1590: if (l_errMsg is not null) then
1591: fnd_message.set_name('WIP', 'SHUTDOWN_TYPE');
1592: fnd_message.set_token('shutdown_type', wjsi_row.shutdown_type, false);
1593: wip_jsi_utils.record_current_error;
1594: end if ;
1595: end if;
1588: x_msg_count => l_msgCount,
1589: x_msg_data => l_errMsg);
1590: if (l_errMsg is not null) then
1591: fnd_message.set_name('WIP', 'SHUTDOWN_TYPE');
1592: fnd_message.set_token('shutdown_type', wjsi_row.shutdown_type, false);
1593: wip_jsi_utils.record_current_error;
1594: end if ;
1595: end if;
1596:
1630: x_return_status => l_returnMsg,
1631: x_msg_count => l_msgCount,
1632: x_msg_data => l_errMsg);
1633: if (l_errMsg is not null) then
1634: fnd_message.set_name('WIP', 'TAGOUT_REQUIRED');
1635: fnd_message.set_token('tagout_required', wjsi_row.tagout_required, false);
1636: wip_jsi_utils.record_current_error;
1637: end if ;
1638: end if;
1631: x_msg_count => l_msgCount,
1632: x_msg_data => l_errMsg);
1633: if (l_errMsg is not null) then
1634: fnd_message.set_name('WIP', 'TAGOUT_REQUIRED');
1635: fnd_message.set_token('tagout_required', wjsi_row.tagout_required, false);
1636: wip_jsi_utils.record_current_error;
1637: end if ;
1638: end if;
1639:
1675: x_return_status => l_returnMsg,
1676: x_msg_count => l_msgCount,
1677: x_msg_data => l_errMsg);
1678: if (l_errMsg is not null) then
1679: fnd_message.set_name('WIP', 'ACTIVITY_TYPE');
1680: fnd_message.set_token('activity_type', wjsi_row.activity_type, false);
1681: wip_jsi_utils.record_current_error;
1682: end if;
1683: end if;
1676: x_msg_count => l_msgCount,
1677: x_msg_data => l_errMsg);
1678: if (l_errMsg is not null) then
1679: fnd_message.set_name('WIP', 'ACTIVITY_TYPE');
1680: fnd_message.set_token('activity_type', wjsi_row.activity_type, false);
1681: wip_jsi_utils.record_current_error;
1682: end if;
1683: end if;
1684:
1711: x_return_status => l_returnMsg,
1712: x_msg_count => l_msgCount,
1713: x_msg_data => l_errMsg);
1714: if (l_errMsg is not null) then
1715: fnd_message.set_name('WIP', 'ACTIVITY_CAUSE');
1716: fnd_message.set_token('activity_cause', wjsi_row.activity_cause, false);
1717: wip_jsi_utils.record_current_error;
1718: end if;
1719: end if;
1712: x_msg_count => l_msgCount,
1713: x_msg_data => l_errMsg);
1714: if (l_errMsg is not null) then
1715: fnd_message.set_name('WIP', 'ACTIVITY_CAUSE');
1716: fnd_message.set_token('activity_cause', wjsi_row.activity_cause, false);
1717: wip_jsi_utils.record_current_error;
1718: end if;
1719: end if;
1720:
1875: x_return_status => l_returnMsg,
1876: x_msg_count => l_msgCount,
1877: x_msg_data => l_errMsg);
1878: if (l_errMsg is not null) then
1879: fnd_message.set_name('WIP', 'ACTIVITY_SOURCE');
1880: fnd_message.set_token('activity_source', wjsi_row.activity_source, false);
1881: wip_jsi_utils.record_current_error;
1882: end if;
1883: end if;
1876: x_msg_count => l_msgCount,
1877: x_msg_data => l_errMsg);
1878: if (l_errMsg is not null) then
1879: fnd_message.set_name('WIP', 'ACTIVITY_SOURCE');
1880: fnd_message.set_token('activity_source', wjsi_row.activity_source, false);
1881: wip_jsi_utils.record_current_error;
1882: end if;
1883: end if;
1884: