DBA Data[Home] [Help]

APPS.RLM_WF_SV dependencies on RLM_MESSAGE_SV

Line 511: rlm_message_sv.dump_messages(v_header_id);

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

Line 512: rlm_message_sv.initialize_messages;

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',

Line 539: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);

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

Line 541: rlm_message_sv.dump_messages(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: --
544: COMMIT;
545: --

Line 542: rlm_message_sv.initialize_messages;

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

Line 1089: rlm_message_sv.dump_messages(v_header_id);

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

Line 1091: rlm_message_sv.initialize_messages;

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

Line 1226: rlm_message_sv.dump_messages(v_header_id);

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

Line 1227: rlm_message_sv.initialize_messages;

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.

Line 2209: rlm_message_sv.removeMessages(

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,

Line 2254: rlm_message_sv.removeMessages(

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,

Line 2297: rlm_message_sv.removeMessages(

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,

Line 2340: rlm_message_sv.app_error(

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,

Line 2341: x_ExceptionLevel => rlm_message_sv.k_error_level,

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,

Line 2369: rlm_message_sv.removeMessages(

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,

Line 2537: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);

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

Line 2539: rlm_message_sv.dump_messages(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: --
2542: COMMIT;
2543: --

Line 2540: rlm_message_sv.initialize_messages;

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

Line 2587: rlm_message_sv.app_error(

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,

Line 2588: x_ExceptionLevel => rlm_message_sv.k_warn_level,

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,

Line 2890: rlm_message_sv.app_error(

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,

Line 2891: x_ExceptionLevel => rlm_message_sv.k_error_level,

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,

Line 3069: rlm_message_sv.dump_messages(v_header_id);

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',

Line 3070: rlm_message_sv.initialize_messages;

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);

Line 3087: rlm_message_sv.app_error(

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,

Line 3088: x_ExceptionLevel => rlm_message_sv.k_warn_level,

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,

Line 3108: rlm_message_sv.dump_messages(v_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

Line 3109: rlm_message_sv.initialize_messages;

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';

Line 3135: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);

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

Line 3137: rlm_message_sv.dump_messages(v_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: --
3140: COMMIT;
3141: --

Line 3138: rlm_message_sv.initialize_messages;

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

Line 3160: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);

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

Line 3162: rlm_message_sv.dump_messages(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: --
3165: COMMIT;
3166: --

Line 3163: rlm_message_sv.initialize_messages;

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

Line 3220: rlm_message_sv.dump_messages(v_header_id);

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:

Line 3221: rlm_message_sv.initialize_messages;

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,

Line 3363: rlm_message_sv.sql_error('RLM_WF_SV.Notification_ToUser',user_id);

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);

Line 3435: rlm_message_sv.sql_error('RLM_WF_SV.Notification_FromUser',

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));