507: --
508: rlm_dp_sv.UpdateHeaderPS(v_header_id,
509: g_Sch_rec.schedule_header_id);
510: --
511: rlm_message_sv.dump_messages(v_header_id);
512: rlm_message_sv.initialize_messages;
513: --
514: COMMIT;
515: --
508: rlm_dp_sv.UpdateHeaderPS(v_header_id,
509: g_Sch_rec.schedule_header_id);
510: --
511: rlm_message_sv.dump_messages(v_header_id);
512: rlm_message_sv.initialize_messages;
513: --
514: COMMIT;
515: --
516: wf_core.context('RLM_WF_SV','ValidateDemand',
535: --
536: rlm_dp_sv.UpdateHeaderPS(v_header_id,
537: g_Sch_rec.schedule_header_id);
538: --
539: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
540: --
541: rlm_message_sv.dump_messages(v_header_id);
542: rlm_message_sv.initialize_messages;
543: --
537: g_Sch_rec.schedule_header_id);
538: --
539: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
540: --
541: rlm_message_sv.dump_messages(v_header_id);
542: rlm_message_sv.initialize_messages;
543: --
544: COMMIT;
545: --
538: --
539: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
540: --
541: rlm_message_sv.dump_messages(v_header_id);
542: rlm_message_sv.initialize_messages;
543: --
544: COMMIT;
545: --
546: IF (l_debug <> -1) THEN
1085: IF (l_debug <> -1) THEN
1086: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1087: END IF;
1088: --
1089: rlm_message_sv.dump_messages(v_header_id);
1090: rlm_dp_sv.PurgeInterfaceLines(v_header_id);
1091: rlm_message_sv.initialize_messages;
1092: COMMIT;
1093: --
1087: END IF;
1088: --
1089: rlm_message_sv.dump_messages(v_header_id);
1090: rlm_dp_sv.PurgeInterfaceLines(v_header_id);
1091: rlm_message_sv.initialize_messages;
1092: COMMIT;
1093: --
1094: resultout := 'COMPLETE:SUCCESS';
1095: --
1222: IF (l_debug <> -1) THEN
1223: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
1224: END IF;
1225: --
1226: rlm_message_sv.dump_messages(v_header_id);
1227: rlm_message_sv.initialize_messages;
1228: --
1229: -- Check for Errors
1230: -- After PurgeInterface, the succesfully processed schedule
1223: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
1224: END IF;
1225: --
1226: rlm_message_sv.dump_messages(v_header_id);
1227: rlm_message_sv.initialize_messages;
1228: --
1229: -- Check for Errors
1230: -- After PurgeInterface, the succesfully processed schedule
1231: -- should have been deleted from interface tables.
2205: rlm_core_sv.k_PS_ERROR);
2206:
2207: -- Bug#: 2771756 - Start
2208: -- Bug: 4198330 added grouping info
2209: rlm_message_sv.removeMessages(
2210: p_header_id => v_header_id,
2211: p_message => 'RLM_RSO_CREATION_INFO',
2212: p_message_type => 'I',
2213: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,
2250: rlm_core_sv.k_PS_ERROR);
2251:
2252: -- Bug#: 2771756 - Start
2253: -- Bug: 4198330 added grouping info
2254: rlm_message_sv.removeMessages(
2255: p_header_id => v_header_id,
2256: p_message => 'RLM_RSO_CREATION_INFO',
2257: p_message_type => 'I',
2258: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,
2293: g_Grp_rec,
2294: rlm_core_sv.k_PS_ERROR);
2295: -- Bug#: 2771756 - Start
2296: -- Bug: 4198330 added grouping info
2297: rlm_message_sv.removeMessages(
2298: p_header_id => v_header_id,
2299: p_message => 'RLM_RSO_CREATION_INFO',
2300: p_message_type => 'I',
2301: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,
2336: g_Grp_rec,
2337: rlm_core_sv.k_PS_ERROR,
2338: 'ALL');
2339: --
2340: rlm_message_sv.app_error(
2341: x_ExceptionLevel => rlm_message_sv.k_error_level,
2342: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2343: x_InterfaceHeaderId => v_header_id,
2344: x_InterfaceLineId => NULL,
2337: rlm_core_sv.k_PS_ERROR,
2338: 'ALL');
2339: --
2340: rlm_message_sv.app_error(
2341: x_ExceptionLevel => rlm_message_sv.k_error_level,
2342: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2343: x_InterfaceHeaderId => v_header_id,
2344: x_InterfaceLineId => NULL,
2345: x_OrderLineId => NULL,
2365: rlm_core_sv.k_PS_ERROR);
2366:
2367: -- Bug#: 2771756 - Start
2368: -- Bug: 4198330 added grouping info
2369: rlm_message_sv.removeMessages(
2370: p_header_id => v_header_id,
2371: p_message => 'RLM_RSO_CREATION_INFO',
2372: p_message_type => 'I',
2373: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,
2533: --
2534: rlm_dp_sv.UpdateHeaderPS(v_header_id,
2535: g_Sch_rec.schedule_header_id);
2536: --
2537: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);
2538: --
2539: rlm_message_sv.dump_messages(v_header_id);
2540: rlm_message_sv.initialize_messages;
2541: --
2535: g_Sch_rec.schedule_header_id);
2536: --
2537: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);
2538: --
2539: rlm_message_sv.dump_messages(v_header_id);
2540: rlm_message_sv.initialize_messages;
2541: --
2542: COMMIT;
2543: --
2536: --
2537: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);
2538: --
2539: rlm_message_sv.dump_messages(v_header_id);
2540: rlm_message_sv.initialize_messages;
2541: --
2542: COMMIT;
2543: --
2544: IF (l_debug <> -1) THEN
2583: --
2584: EXCEPTION
2585: WHEN e_wftestschedule THEN
2586: --
2587: rlm_message_sv.app_error(
2588: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2589: x_MessageName => 'RLM_TEST_SCHEDULE_DETECTED',
2590: x_InterfaceHeaderId => v_header_id,
2591: x_InterfaceLineId => NULL,
2584: EXCEPTION
2585: WHEN e_wftestschedule THEN
2586: --
2587: rlm_message_sv.app_error(
2588: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2589: x_MessageName => 'RLM_TEST_SCHEDULE_DETECTED',
2590: x_InterfaceHeaderId => v_header_id,
2591: x_InterfaceLineId => NULL,
2592: x_OrderLineId => NULL,
2886: g_Grp_rec,
2887: rlm_core_sv.k_PS_ERROR,
2888: 'ALL');
2889: --
2890: rlm_message_sv.app_error(
2891: x_ExceptionLevel => rlm_message_sv.k_error_level,
2892: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2893: x_InterfaceHeaderId => v_header_id,
2894: x_InterfaceLineId => NULL,
2887: rlm_core_sv.k_PS_ERROR,
2888: 'ALL');
2889: --
2890: rlm_message_sv.app_error(
2891: x_ExceptionLevel => rlm_message_sv.k_error_level,
2892: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2893: x_InterfaceHeaderId => v_header_id,
2894: x_InterfaceLineId => NULL,
2895: x_OrderLineId => NULL,
3065: --
3066: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3067: g_Sch_rec.schedule_header_id);
3068: --
3069: rlm_message_sv.dump_messages(v_header_id);
3070: rlm_message_sv.initialize_messages;
3071: --
3072:
3073: wf_core.context('RLM_WF_SV','PostValidate',
3066: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3067: g_Sch_rec.schedule_header_id);
3068: --
3069: rlm_message_sv.dump_messages(v_header_id);
3070: rlm_message_sv.initialize_messages;
3071: --
3072:
3073: wf_core.context('RLM_WF_SV','PostValidate',
3074: itemtype, itemkey,TO_CHAR(actid),funcmode);
3083: IF (l_debug <> -1) THEN
3084: rlm_core_sv.dlog(C_DEBUG,'RLM_CONF_SCH_RCD');
3085: END IF;
3086: --
3087: rlm_message_sv.app_error(
3088: x_ExceptionLevel => rlm_message_sv.k_warn_level,
3089: x_MessageName => 'RLM_CONF_SCH_RCD',
3090: x_InterfaceHeaderId => g_Sch_rec.header_id,
3091: x_InterfaceLineId => null,
3084: rlm_core_sv.dlog(C_DEBUG,'RLM_CONF_SCH_RCD');
3085: END IF;
3086: --
3087: rlm_message_sv.app_error(
3088: x_ExceptionLevel => rlm_message_sv.k_warn_level,
3089: x_MessageName => 'RLM_CONF_SCH_RCD',
3090: x_InterfaceHeaderId => g_Sch_rec.header_id,
3091: x_InterfaceLineId => null,
3092: x_ScheduleHeaderId => g_Sch_rec.schedule_header_id,
3104: --
3105: rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
3106: g_Sch_rec.Schedule_header_id);
3107: --
3108: rlm_message_sv.dump_messages(v_header_id);
3109: rlm_message_sv.initialize_messages;
3110: --
3111: COMMIT;
3112: -- Bug#: 3053299 -- Setting the output
3105: rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
3106: g_Sch_rec.Schedule_header_id);
3107: --
3108: rlm_message_sv.dump_messages(v_header_id);
3109: rlm_message_sv.initialize_messages;
3110: --
3111: COMMIT;
3112: -- Bug#: 3053299 -- Setting the output
3113: resultout := 'COMPLETE:SUCCESS';
3131: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3132: g_Sch_rec.schedule_header_id);
3133: --
3134: -- Bug 2930695: Frontport bug 2912996
3135: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3136: --
3137: rlm_message_sv.dump_messages(v_header_id);
3138: rlm_message_sv.initialize_messages;
3139: --
3133: --
3134: -- Bug 2930695: Frontport bug 2912996
3135: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3136: --
3137: rlm_message_sv.dump_messages(v_header_id);
3138: rlm_message_sv.initialize_messages;
3139: --
3140: COMMIT;
3141: --
3134: -- Bug 2930695: Frontport bug 2912996
3135: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3136: --
3137: rlm_message_sv.dump_messages(v_header_id);
3138: rlm_message_sv.initialize_messages;
3139: --
3140: COMMIT;
3141: --
3142: IF (l_debug <> -1) THEN
3156: --
3157: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3158: g_Sch_rec.schedule_header_id);
3159: --
3160: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3161: --
3162: rlm_message_sv.dump_messages(v_header_id);
3163: rlm_message_sv.initialize_messages;
3164: --
3158: g_Sch_rec.schedule_header_id);
3159: --
3160: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3161: --
3162: rlm_message_sv.dump_messages(v_header_id);
3163: rlm_message_sv.initialize_messages;
3164: --
3165: COMMIT;
3166: --
3159: --
3160: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3161: --
3162: rlm_message_sv.dump_messages(v_header_id);
3163: rlm_message_sv.initialize_messages;
3164: --
3165: COMMIT;
3166: --
3167: IF (l_debug <> -1) THEN
3216: IF (l_debug <> -1) THEN
3217: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
3218: END IF;
3219: --
3220: rlm_message_sv.dump_messages(v_header_id);
3221: rlm_message_sv.initialize_messages;
3222:
3223: -- Check for Errors
3224:
3217: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
3218: END IF;
3219: --
3220: rlm_message_sv.dump_messages(v_header_id);
3221: rlm_message_sv.initialize_messages;
3222:
3223: -- Check for Errors
3224:
3225: wf_engine.SetItemAttrNumber( itemtype,
3359: EXCEPTION
3360: --
3361: WHEN e_UserNotFound THEN
3362: --
3363: rlm_message_sv.sql_error('RLM_WF_SV.Notification_ToUser',user_id);
3364: --
3365: IF (l_debug <> -1) THEN
3366: rlm_core_sv.dlog(C_DEBUG, 'Exception : e_UserNotFound');
3367: rlm_core_sv.dpop(C_SDEBUG);
3431: EXCEPTION
3432: --
3433: WHEN OTHERS THEN
3434: --
3435: rlm_message_sv.sql_error('RLM_WF_SV.Notification_FromUser',
3436: SUBSTRB(SQLERRM, 1, 200));
3437: --
3438: IF (l_debug <> -1) THEN
3439: rlm_core_sv.dlog(C_DEBUG, 'When Others - ' || SUBSTRB(SQLERRM, 1, 200));