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 1100: rlm_message_sv.dump_messages(v_header_id);

1096: IF (l_debug <> -1) THEN
1097: rlm_core_sv.dlog(C_DEBUG,' Header_id :', v_header_id);
1098: END IF;
1099: --
1100: rlm_message_sv.dump_messages(v_header_id);
1101: rlm_dp_sv.PurgeInterfaceLines(v_header_id);
1102: rlm_message_sv.initialize_messages;
1103: COMMIT;
1104: --

Line 1102: rlm_message_sv.initialize_messages;

1098: END IF;
1099: --
1100: rlm_message_sv.dump_messages(v_header_id);
1101: rlm_dp_sv.PurgeInterfaceLines(v_header_id);
1102: rlm_message_sv.initialize_messages;
1103: COMMIT;
1104: --
1105: resultout := 'COMPLETE:SUCCESS';
1106: --

Line 1237: rlm_message_sv.dump_messages(v_header_id);

1233: IF (l_debug <> -1) THEN
1234: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
1235: END IF;
1236: --
1237: rlm_message_sv.dump_messages(v_header_id);
1238: rlm_message_sv.initialize_messages;
1239: --
1240: -- Check for Errors
1241: -- After PurgeInterface, the succesfully processed schedule

Line 1238: rlm_message_sv.initialize_messages;

1234: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
1235: END IF;
1236: --
1237: rlm_message_sv.dump_messages(v_header_id);
1238: rlm_message_sv.initialize_messages;
1239: --
1240: -- Check for Errors
1241: -- After PurgeInterface, the succesfully processed schedule
1242: -- should have been deleted from interface tables.

Line 2231: rlm_message_sv.removeMessages(

2227: rlm_core_sv.k_PS_ERROR);
2228:
2229: -- Bug#: 2771756 - Start
2230: -- Bug: 4198330 added grouping info
2231: rlm_message_sv.removeMessages(
2232: p_header_id => v_header_id,
2233: p_message => 'RLM_RSO_CREATION_INFO',
2234: p_message_type => 'I',
2235: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,

Line 2276: rlm_message_sv.removeMessages(

2272: rlm_core_sv.k_PS_ERROR);
2273:
2274: -- Bug#: 2771756 - Start
2275: -- Bug: 4198330 added grouping info
2276: rlm_message_sv.removeMessages(
2277: p_header_id => v_header_id,
2278: p_message => 'RLM_RSO_CREATION_INFO',
2279: p_message_type => 'I',
2280: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,

Line 2319: rlm_message_sv.removeMessages(

2315: g_Grp_rec,
2316: rlm_core_sv.k_PS_ERROR);
2317: -- Bug#: 2771756 - Start
2318: -- Bug: 4198330 added grouping info
2319: rlm_message_sv.removeMessages(
2320: p_header_id => v_header_id,
2321: p_message => 'RLM_RSO_CREATION_INFO',
2322: p_message_type => 'I',
2323: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,

Line 2362: rlm_message_sv.app_error(

2358: g_Grp_rec,
2359: rlm_core_sv.k_PS_ERROR,
2360: 'ALL');
2361: --
2362: rlm_message_sv.app_error(
2363: x_ExceptionLevel => rlm_message_sv.k_error_level,
2364: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2365: x_InterfaceHeaderId => v_header_id,
2366: x_InterfaceLineId => NULL,

Line 2363: x_ExceptionLevel => rlm_message_sv.k_error_level,

2359: rlm_core_sv.k_PS_ERROR,
2360: 'ALL');
2361: --
2362: rlm_message_sv.app_error(
2363: x_ExceptionLevel => rlm_message_sv.k_error_level,
2364: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2365: x_InterfaceHeaderId => v_header_id,
2366: x_InterfaceLineId => NULL,
2367: x_OrderLineId => NULL,

Line 2391: rlm_message_sv.removeMessages(

2387: rlm_core_sv.k_PS_ERROR);
2388:
2389: -- Bug#: 2771756 - Start
2390: -- Bug: 4198330 added grouping info
2391: rlm_message_sv.removeMessages(
2392: p_header_id => v_header_id,
2393: p_message => 'RLM_RSO_CREATION_INFO',
2394: p_message_type => 'I',
2395: p_ship_from_org_id => g_Grp_rec.ship_from_org_id,

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

2555: --
2556: rlm_dp_sv.UpdateHeaderPS(v_header_id,
2557: g_Sch_rec.schedule_header_id);
2558: --
2559: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);
2560: --
2561: rlm_message_sv.dump_messages(v_header_id);
2562: rlm_message_sv.initialize_messages;
2563: --

Line 2561: rlm_message_sv.dump_messages(v_header_id);

2557: g_Sch_rec.schedule_header_id);
2558: --
2559: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);
2560: --
2561: rlm_message_sv.dump_messages(v_header_id);
2562: rlm_message_sv.initialize_messages;
2563: --
2564: COMMIT;
2565: --

Line 2562: rlm_message_sv.initialize_messages;

2558: --
2559: rlm_message_sv.sql_error('rlm_wf_sv.ArchiveDemand', v_Progress);
2560: --
2561: rlm_message_sv.dump_messages(v_header_id);
2562: rlm_message_sv.initialize_messages;
2563: --
2564: COMMIT;
2565: --
2566: IF (l_debug <> -1) THEN

Line 2609: rlm_message_sv.app_error(

2605: --
2606: EXCEPTION
2607: WHEN e_wftestschedule THEN
2608: --
2609: rlm_message_sv.app_error(
2610: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2611: x_MessageName => 'RLM_TEST_SCHEDULE_DETECTED',
2612: x_InterfaceHeaderId => v_header_id,
2613: x_InterfaceLineId => NULL,

Line 2610: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2606: EXCEPTION
2607: WHEN e_wftestschedule THEN
2608: --
2609: rlm_message_sv.app_error(
2610: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2611: x_MessageName => 'RLM_TEST_SCHEDULE_DETECTED',
2612: x_InterfaceHeaderId => v_header_id,
2613: x_InterfaceLineId => NULL,
2614: x_OrderLineId => NULL,

Line 2912: rlm_message_sv.app_error(

2908: g_Grp_rec,
2909: rlm_core_sv.k_PS_ERROR,
2910: 'ALL');
2911: --
2912: rlm_message_sv.app_error(
2913: x_ExceptionLevel => rlm_message_sv.k_error_level,
2914: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2915: x_InterfaceHeaderId => v_header_id,
2916: x_InterfaceLineId => NULL,

Line 2913: x_ExceptionLevel => rlm_message_sv.k_error_level,

2909: rlm_core_sv.k_PS_ERROR,
2910: 'ALL');
2911: --
2912: rlm_message_sv.app_error(
2913: x_ExceptionLevel => rlm_message_sv.k_error_level,
2914: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
2915: x_InterfaceHeaderId => v_header_id,
2916: x_InterfaceLineId => NULL,
2917: x_OrderLineId => NULL,

Line 3091: rlm_message_sv.dump_messages(v_header_id);

3087: --
3088: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3089: g_Sch_rec.schedule_header_id);
3090: --
3091: rlm_message_sv.dump_messages(v_header_id);
3092: rlm_message_sv.initialize_messages;
3093: --
3094:
3095: wf_core.context('RLM_WF_SV','PostValidate',

Line 3092: rlm_message_sv.initialize_messages;

3088: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3089: g_Sch_rec.schedule_header_id);
3090: --
3091: rlm_message_sv.dump_messages(v_header_id);
3092: rlm_message_sv.initialize_messages;
3093: --
3094:
3095: wf_core.context('RLM_WF_SV','PostValidate',
3096: itemtype, itemkey,TO_CHAR(actid),funcmode);

Line 3109: rlm_message_sv.app_error(

3105: IF (l_debug <> -1) THEN
3106: rlm_core_sv.dlog(C_DEBUG,'RLM_CONF_SCH_RCD');
3107: END IF;
3108: --
3109: rlm_message_sv.app_error(
3110: x_ExceptionLevel => rlm_message_sv.k_warn_level,
3111: x_MessageName => 'RLM_CONF_SCH_RCD',
3112: x_InterfaceHeaderId => g_Sch_rec.header_id,
3113: x_InterfaceLineId => null,

Line 3110: x_ExceptionLevel => rlm_message_sv.k_warn_level,

3106: rlm_core_sv.dlog(C_DEBUG,'RLM_CONF_SCH_RCD');
3107: END IF;
3108: --
3109: rlm_message_sv.app_error(
3110: x_ExceptionLevel => rlm_message_sv.k_warn_level,
3111: x_MessageName => 'RLM_CONF_SCH_RCD',
3112: x_InterfaceHeaderId => g_Sch_rec.header_id,
3113: x_InterfaceLineId => null,
3114: x_ScheduleHeaderId => g_Sch_rec.schedule_header_id,

Line 3130: rlm_message_sv.dump_messages(v_header_id);

3126: --
3127: rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
3128: g_Sch_rec.Schedule_header_id);
3129: --
3130: rlm_message_sv.dump_messages(v_header_id);
3131: rlm_message_sv.initialize_messages;
3132: --
3133: COMMIT;
3134: -- Bug#: 3053299 -- Setting the output

Line 3131: rlm_message_sv.initialize_messages;

3127: rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
3128: g_Sch_rec.Schedule_header_id);
3129: --
3130: rlm_message_sv.dump_messages(v_header_id);
3131: rlm_message_sv.initialize_messages;
3132: --
3133: COMMIT;
3134: -- Bug#: 3053299 -- Setting the output
3135: resultout := 'COMPLETE:SUCCESS';

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

3153: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3154: g_Sch_rec.schedule_header_id);
3155: --
3156: -- Bug 2930695: Frontport bug 2912996
3157: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3158: --
3159: rlm_message_sv.dump_messages(v_header_id);
3160: rlm_message_sv.initialize_messages;
3161: --

Line 3159: rlm_message_sv.dump_messages(v_header_id);

3155: --
3156: -- Bug 2930695: Frontport bug 2912996
3157: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3158: --
3159: rlm_message_sv.dump_messages(v_header_id);
3160: rlm_message_sv.initialize_messages;
3161: --
3162: COMMIT;
3163: --

Line 3160: rlm_message_sv.initialize_messages;

3156: -- Bug 2930695: Frontport bug 2912996
3157: -- rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3158: --
3159: rlm_message_sv.dump_messages(v_header_id);
3160: rlm_message_sv.initialize_messages;
3161: --
3162: COMMIT;
3163: --
3164: IF (l_debug <> -1) THEN

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

3178: --
3179: rlm_dp_sv.UpdateHeaderPS(v_header_id,
3180: g_Sch_rec.schedule_header_id);
3181: --
3182: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3183: --
3184: rlm_message_sv.dump_messages(v_header_id);
3185: rlm_message_sv.initialize_messages;
3186: --

Line 3184: rlm_message_sv.dump_messages(v_header_id);

3180: g_Sch_rec.schedule_header_id);
3181: --
3182: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3183: --
3184: rlm_message_sv.dump_messages(v_header_id);
3185: rlm_message_sv.initialize_messages;
3186: --
3187: COMMIT;
3188: --

Line 3185: rlm_message_sv.initialize_messages;

3181: --
3182: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
3183: --
3184: rlm_message_sv.dump_messages(v_header_id);
3185: rlm_message_sv.initialize_messages;
3186: --
3187: COMMIT;
3188: --
3189: IF (l_debug <> -1) THEN

Line 3242: rlm_message_sv.dump_messages(v_header_id);

3238: IF (l_debug <> -1) THEN
3239: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
3240: END IF;
3241: --
3242: rlm_message_sv.dump_messages(v_header_id);
3243: rlm_message_sv.initialize_messages;
3244:
3245: -- Check for Errors
3246:

Line 3243: rlm_message_sv.initialize_messages;

3239: rlm_core_sv.dlog(C_DEBUG,' Schedule Number :', v_schedule_num);
3240: END IF;
3241: --
3242: rlm_message_sv.dump_messages(v_header_id);
3243: rlm_message_sv.initialize_messages;
3244:
3245: -- Check for Errors
3246:
3247: wf_engine.SetItemAttrNumber( itemtype,

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

3381: EXCEPTION
3382: --
3383: WHEN e_UserNotFound THEN
3384: --
3385: rlm_message_sv.sql_error('RLM_WF_SV.Notification_ToUser',user_id);
3386: --
3387: IF (l_debug <> -1) THEN
3388: rlm_core_sv.dlog(C_DEBUG, 'Exception : e_UserNotFound');
3389: rlm_core_sv.dpop(C_SDEBUG);

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

3453: EXCEPTION
3454: --
3455: WHEN OTHERS THEN
3456: --
3457: rlm_message_sv.sql_error('RLM_WF_SV.Notification_FromUser',
3458: SUBSTRB(SQLERRM, 1, 200));
3459: --
3460: IF (l_debug <> -1) THEN
3461: rlm_core_sv.dlog(C_DEBUG, 'When Others - ' || SUBSTRB(SQLERRM, 1, 200));