APPS.FTE_TENDER_PVT dependencies on WF_EVENT

Line 56: wf_event.AddParameterToList(p_name=>'SHIPPER_CUTOFF_TIME',

52: -- raise event
53:
54: -- should save the weight volume snap shot
55:
56: wf_event.AddParameterToList(p_name=>'SHIPPER_CUTOFF_TIME',
57: p_value=> p_shipper_wait_time,
58: p_parameterlist=>l_parameter_list);
59:
60: wf_event.AddParameterToList(p_name=>'TENDER_ID',

Line 60: wf_event.AddParameterToList(p_name=>'TENDER_ID',

56: wf_event.AddParameterToList(p_name=>'SHIPPER_CUTOFF_TIME',
57: p_value=> p_shipper_wait_time,
58: p_parameterlist=>l_parameter_list);
59:
60: wf_event.AddParameterToList(p_name=>'TENDER_ID',
61: p_value=> p_tender_id,
62: p_parameterlist=>l_parameter_list);
63:
64: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

Line 64: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

60: wf_event.AddParameterToList(p_name=>'TENDER_ID',
61: p_value=> p_tender_id,
62: p_parameterlist=>l_parameter_list);
63:
64: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
65: p_value=> p_shipper_name,
66: p_parameterlist=>l_parameter_list);
67:
68: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

Line 68: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

64: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
65: p_value=> p_shipper_name,
66: p_parameterlist=>l_parameter_list);
67:
68: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
69: p_value=> p_carrier_name,
70: p_parameterlist=>l_parameter_list);
71:
72: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

Line 72: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

68: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
69: p_value=> p_carrier_name,
70: p_parameterlist=>l_parameter_list);
71:
72: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
73: p_value=> p_contact_name,
74: p_parameterlist=>l_parameter_list);
75:
76: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

Line 76: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

72: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
73: p_value=> p_contact_name,
74: p_parameterlist=>l_parameter_list);
75:
76: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
77: p_value=> p_contact_perf,
78: p_parameterlist=>l_parameter_list);
79:
80:

Line 88: wf_event.AddParameterToList(p_name=> 'AUTO_ACCEPT',

84: -- see notifications in worklist
85:
86:
87:
88: wf_event.AddParameterToList(p_name=> 'AUTO_ACCEPT',
89: p_value=> p_autoaccept,
90: p_parameterlist=>l_parameter_list);
91:
92: wf_event.AddParameterToList(p_name=> 'RESPONSE_URL',

Line 92: wf_event.AddParameterToList(p_name=> 'RESPONSE_URL',

88: wf_event.AddParameterToList(p_name=> 'AUTO_ACCEPT',
89: p_value=> p_autoaccept,
90: p_parameterlist=>l_parameter_list);
91:
92: wf_event.AddParameterToList(p_name=> 'RESPONSE_URL',
93: p_value=> p_url,
94: p_parameterlist=>l_parameter_list);
95:
96: IF l_debug_on THEN

Line 101: wf_event.raise(

97: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:22 ',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99: -- event key should be based on some other value
100:
101: wf_event.raise(
102: p_event_name => 'oracle.apps.fte.lt.tenderrequest',
103: p_event_key => p_item_key,
104: p_parameters => l_parameter_list
105: );

Line 274: wf_event.AddParameterToList(p_name=>'TENDER_ID',

270:
271:
272: -- raise event
273:
274: wf_event.AddParameterToList(p_name=>'TENDER_ID',
275: p_value=> p_tender_id,
276: p_parameterlist=>l_parameter_list);
277:
278:

Line 279: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

275: p_value=> p_tender_id,
276: p_parameterlist=>l_parameter_list);
277:
278:
279: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
280: p_value=> p_shipper_name,
281: p_parameterlist=>l_parameter_list);
282:
283: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

Line 283: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

279: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
280: p_value=> p_shipper_name,
281: p_parameterlist=>l_parameter_list);
282:
283: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
284: p_value=> p_carrier_name,
285: p_parameterlist=>l_parameter_list);
286:
287: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

Line 287: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

283: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
284: p_value=> p_carrier_name,
285: p_parameterlist=>l_parameter_list);
286:
287: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
288: p_value=> p_contact_name,
289: p_parameterlist=>l_parameter_list);
290:
291: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

Line 291: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

287: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
288: p_value=> p_contact_name,
289: p_parameterlist=>l_parameter_list);
290:
291: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
292: p_value=> p_contact_perf,
293: p_parameterlist=>l_parameter_list);
294:
295: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

Line 295: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

291: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
292: p_value=> p_contact_perf,
293: p_parameterlist=>l_parameter_list);
294:
295: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
296: p_value => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,
297: p_parameterlist => l_parameter_list);
298:
299: wf_event.raise(

Line 299: wf_event.raise(

295: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
296: p_value => FTE_TENDER_PVT.S_SHIPPER_CANCELLED,
297: p_parameterlist => l_parameter_list);
298:
299: wf_event.raise(
300: p_event_name => 'oracle.apps.fte.lt.tendercancel',
301: p_event_key => p_item_key,
302: p_parameters => l_parameter_list
303: );

Line 419: wf_event.AddParameterToList(p_name=>'TENDER_ID',

415: -- raise event
416:
417:
418:
419: wf_event.AddParameterToList(p_name=>'TENDER_ID',
420: p_value=> p_tender_id,
421: p_parameterlist=>l_parameter_list);
422:
423:

Line 424: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

420: p_value=> p_tender_id,
421: p_parameterlist=>l_parameter_list);
422:
423:
424: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
425: p_value=> p_shipper_name,
426: p_parameterlist=>l_parameter_list);
427:
428: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

Line 428: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

424: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
425: p_value=> p_shipper_name,
426: p_parameterlist=>l_parameter_list);
427:
428: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
429: p_value=> p_carrier_name,
430: p_parameterlist=>l_parameter_list);
431:
432: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

Line 432: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

428: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
429: p_value=> p_carrier_name,
430: p_parameterlist=>l_parameter_list);
431:
432: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
433: p_value=> p_contact_name,
434: p_parameterlist=>l_parameter_list);
435:
436: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

Line 436: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

432: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
433: p_value=> p_contact_name,
434: p_parameterlist=>l_parameter_list);
435:
436: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
437: p_value=> p_contact_perf,
438: p_parameterlist=>l_parameter_list);
439:
440: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

Line 440: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

436: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
437: p_value=> p_contact_perf,
438: p_parameterlist=>l_parameter_list);
439:
440: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
441: p_value => FTE_TENDER_PVT.S_ACCEPTED,
442: p_parameterlist => l_parameter_list);
443:
444: --Rel 12 Changes for Freight Class

Line 447: wf_event.AddParameterToList(p_name => 'MODE_OF_TRANSPORT',

443:
444: --Rel 12 Changes for Freight Class
445: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');
446:
447: wf_event.AddParameterToList(p_name => 'MODE_OF_TRANSPORT',
448: p_value => l_mode_transport,
449: p_parameterlist => l_parameter_list);
450:
451:

Line 452: wf_event.raise(

448: p_value => l_mode_transport,
449: p_parameterlist => l_parameter_list);
450:
451:
452: wf_event.raise(
453: p_event_name => 'oracle.apps.fte.lt.tenderaccept',
454: p_event_key => p_item_key,
455: p_parameters => l_parameter_list
456: );

Line 578: wf_event.AddParameterToList(p_name=>'TENDER_ID',

574:
575: --------------------------------------------------------------------------------------
576:
577:
578: wf_event.AddParameterToList(p_name=>'TENDER_ID',
579: p_value=> p_tender_id,
580: p_parameterlist=>l_parameter_list);
581:
582: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

Line 582: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

578: wf_event.AddParameterToList(p_name=>'TENDER_ID',
579: p_value=> p_tender_id,
580: p_parameterlist=>l_parameter_list);
581:
582: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
583: p_value=> l_shipper_name,
584: p_parameterlist=>l_parameter_list);
585:
586:

Line 587: wf_event.AddParameterToList(p_name=>'CONTACT_PERFORMER',

583: p_value=> l_shipper_name,
584: p_parameterlist=>l_parameter_list);
585:
586:
587: wf_event.AddParameterToList(p_name=>'CONTACT_PERFORMER',
588: p_value=> p_contact_perf,
589: p_parameterlist=>l_parameter_list);
590:
591: wf_event.AddParameterToList(p_name=>'CARRIER_ID',

Line 591: wf_event.AddParameterToList(p_name=>'CARRIER_ID',

587: wf_event.AddParameterToList(p_name=>'CONTACT_PERFORMER',
588: p_value=> p_contact_perf,
589: p_parameterlist=>l_parameter_list);
590:
591: wf_event.AddParameterToList(p_name=>'CARRIER_ID',
592: p_value=> l_carrier_id,
593: p_parameterlist=>l_parameter_list);
594:
595: wf_event.AddParameterToList(p_name=>'CARRIER_SITE_ID',

Line 595: wf_event.AddParameterToList(p_name=>'CARRIER_SITE_ID',

591: wf_event.AddParameterToList(p_name=>'CARRIER_ID',
592: p_value=> l_carrier_id,
593: p_parameterlist=>l_parameter_list);
594:
595: wf_event.AddParameterToList(p_name=>'CARRIER_SITE_ID',
596: p_value=> l_carrier_site_id,
597: p_parameterlist=>l_parameter_list);
598:
599: wf_event.AddParameterToList(p_name=>'RESPONSE_URL',

Line 599: wf_event.AddParameterToList(p_name=>'RESPONSE_URL',

595: wf_event.AddParameterToList(p_name=>'CARRIER_SITE_ID',
596: p_value=> l_carrier_site_id,
597: p_parameterlist=>l_parameter_list);
598:
599: wf_event.AddParameterToList(p_name=>'RESPONSE_URL',
600: p_value=> l_response_url,
601: p_parameterlist=>l_parameter_list);
602:
603: wf_event.AddParameterToList(p_name=>'NOTIF_TYPE',

Line 603: wf_event.AddParameterToList(p_name=>'NOTIF_TYPE',

599: wf_event.AddParameterToList(p_name=>'RESPONSE_URL',
600: p_value=> l_response_url,
601: p_parameterlist=>l_parameter_list);
602:
603: wf_event.AddParameterToList(p_name=>'NOTIF_TYPE',
604: p_value=> l_notif_type,
605: p_parameterlist=>l_parameter_list);
606:
607:

Line 608: wf_event.AddParameterToList(p_name=>'TRIP_ID',

604: p_value=> l_notif_type,
605: p_parameterlist=>l_parameter_list);
606:
607:
608: wf_event.AddParameterToList(p_name=>'TRIP_ID',
609: p_value=> l_trip_id,
610: p_parameterlist=>l_parameter_list);
611:
612: wf_event.AddParameterToList(p_name=>'RANK_ID',

Line 612: wf_event.AddParameterToList(p_name=>'RANK_ID',

608: wf_event.AddParameterToList(p_name=>'TRIP_ID',
609: p_value=> l_trip_id,
610: p_parameterlist=>l_parameter_list);
611:
612: wf_event.AddParameterToList(p_name=>'RANK_ID',
613: p_value=> l_rank_id,
614: p_parameterlist=>l_parameter_list);
615:
616: wf_event.AddParameterToList(p_name=>'RANK_VERSION',

Line 616: wf_event.AddParameterToList(p_name=>'RANK_VERSION',

612: wf_event.AddParameterToList(p_name=>'RANK_ID',
613: p_value=> l_rank_id,
614: p_parameterlist=>l_parameter_list);
615:
616: wf_event.AddParameterToList(p_name=>'RANK_VERSION',
617: p_value=> l_rank_version,
618: p_parameterlist=>l_parameter_list);
619:
620: wf_event.AddParameterToList(p_name=>'TENDER_STATUS',

Line 620: wf_event.AddParameterToList(p_name=>'TENDER_STATUS',

616: wf_event.AddParameterToList(p_name=>'RANK_VERSION',
617: p_value=> l_rank_version,
618: p_parameterlist=>l_parameter_list);
619:
620: wf_event.AddParameterToList(p_name=>'TENDER_STATUS',
621: p_value=> l_tender_status,
622: p_parameterlist=>l_parameter_list);
623:
624: wf_event.AddParameterToList(p_name=>'SHIPPER_USER_ID',

Line 624: wf_event.AddParameterToList(p_name=>'SHIPPER_USER_ID',

620: wf_event.AddParameterToList(p_name=>'TENDER_STATUS',
621: p_value=> l_tender_status,
622: p_parameterlist=>l_parameter_list);
623:
624: wf_event.AddParameterToList(p_name=>'SHIPPER_USER_ID',
625: p_value=> l_shipper_user_id,
626: p_parameterlist=>l_parameter_list);
627:
628: wf_event.AddParameterToList(p_name=>'MODE_OF_TRANSPORT',

Line 628: wf_event.AddParameterToList(p_name=>'MODE_OF_TRANSPORT',

624: wf_event.AddParameterToList(p_name=>'SHIPPER_USER_ID',
625: p_value=> l_shipper_user_id,
626: p_parameterlist=>l_parameter_list);
627:
628: wf_event.AddParameterToList(p_name=>'MODE_OF_TRANSPORT',
629: p_value=> l_mode_of_transport,
630: p_parameterlist=>l_parameter_list);
631:
632:

Line 633: wf_event.raise(

629: p_value=> l_mode_of_transport,
630: p_parameterlist=>l_parameter_list);
631:
632:
633: wf_event.raise(
634: p_event_name => 'oracle.apps.fte.lt.tenderupdate',
635: p_event_key => GET_ITEM_KEY(p_tender_id),--p_item_key,
636: p_parameters => l_parameter_list
637: );

Line 744: wf_event.AddParameterToList(p_name=>'TENDER_ID',

740:
741:
742: -- raise event
743:
744: wf_event.AddParameterToList(p_name=>'TENDER_ID',
745: p_value=> p_tender_id,
746: p_parameterlist=>l_parameter_list);
747:
748:

Line 749: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

745: p_value=> p_tender_id,
746: p_parameterlist=>l_parameter_list);
747:
748:
749: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
750: p_value=> p_shipper_name,
751: p_parameterlist=>l_parameter_list);
752:
753: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

Line 753: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',

749: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
750: p_value=> p_shipper_name,
751: p_parameterlist=>l_parameter_list);
752:
753: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
754: p_value=> p_carrier_name,
755: p_parameterlist=>l_parameter_list);
756:
757: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

Line 757: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',

753: wf_event.AddParameterToList(p_name=> 'CARRIER_NAME',
754: p_value=> p_carrier_name,
755: p_parameterlist=>l_parameter_list);
756:
757: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
758: p_value=> p_contact_name,
759: p_parameterlist=>l_parameter_list);
760:
761: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

Line 761: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',

757: wf_event.AddParameterToList(p_name=> 'CONTACT_NAME',
758: p_value=> p_contact_name,
759: p_parameterlist=>l_parameter_list);
760:
761: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
762: p_value=> p_contact_perf,
763: p_parameterlist=>l_parameter_list);
764:
765: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

Line 765: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

761: wf_event.AddParameterToList(p_name=> 'CONTACT_PERFORMER',
762: p_value=> p_contact_perf,
763: p_parameterlist=>l_parameter_list);
764:
765: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
766: p_value => FTE_TENDER_PVT.S_REJECTED,
767: p_parameterlist => l_parameter_list);
768:
769: --Rel 12 Changes for Freight Class

Line 771: wf_event.AddParameterToList(p_name => 'MODE_OF_TRANSPORT',

767: p_parameterlist => l_parameter_list);
768:
769: --Rel 12 Changes for Freight Class
770: l_mode_transport := wf_engine.GetItemAttrText('FTETEREQ', p_item_key, 'MODE_OF_TRANSPORT');
771: wf_event.AddParameterToList(p_name => 'MODE_OF_TRANSPORT',
772: p_value => l_mode_transport,
773: p_parameterlist => l_parameter_list);
774:
775:

Line 776: wf_event.raise(

772: p_value => l_mode_transport,
773: p_parameterlist => l_parameter_list);
774:
775:
776: wf_event.raise(
777: p_event_name => 'oracle.apps.fte.lt.tenderreject',
778: p_event_key => p_item_key,
779: p_parameters => l_parameter_list
780: );

Line 3785: wf_event.AddParameterToList(p_name=>'TRIP_ID',

3781: END IF;
3782:
3783:
3784:
3785: wf_event.AddParameterToList(p_name=>'TRIP_ID',
3786: p_value=> p_trip_info.trip_id,
3787: p_parameterlist=>l_parameter_list);
3788:
3789:

Line 3790: wf_event.AddParameterToList(p_name=>'TENDER_ID',

3786: p_value=> p_trip_info.trip_id,
3787: p_parameterlist=>l_parameter_list);
3788:
3789:
3790: wf_event.AddParameterToList(p_name=>'TENDER_ID',
3791: p_value=> p_trip_info.tender_id,
3792: p_parameterlist=>l_parameter_list);
3793:
3794:

Line 3795: wf_event.AddParameterToList(p_name=>'MBOL_NUM',

3791: p_value=> p_trip_info.tender_id,
3792: p_parameterlist=>l_parameter_list);
3793:
3794:
3795: wf_event.AddParameterToList(p_name=>'MBOL_NUM',
3796: p_value=> p_mbol_number,
3797: p_parameterlist=>l_parameter_list);
3798:
3799: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

Line 3799: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

3795: wf_event.AddParameterToList(p_name=>'MBOL_NUM',
3796: p_value=> p_mbol_number,
3797: p_parameterlist=>l_parameter_list);
3798:
3799: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
3800: p_value=> FND_GLOBAL.USER_NAME,
3801: p_parameterlist=>l_parameter_list);
3802:
3803: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',

Line 3803: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',

3799: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
3800: p_value=> FND_GLOBAL.USER_NAME,
3801: p_parameterlist=>l_parameter_list);
3802:
3803: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',
3804: p_value=> FND_GLOBAL.USER_ID,
3805: p_parameterlist=>l_parameter_list);
3806:
3807: wf_event.AddParameterToList(p_name=> 'USER_ID',

Line 3807: wf_event.AddParameterToList(p_name=> 'USER_ID',

3803: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',
3804: p_value=> FND_GLOBAL.USER_ID,
3805: p_parameterlist=>l_parameter_list);
3806:
3807: wf_event.AddParameterToList(p_name=> 'USER_ID',
3808: p_value=> FND_GLOBAL.USER_ID,
3809: p_parameterlist=>l_parameter_list);
3810:
3811: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',

Line 3811: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',

3807: wf_event.AddParameterToList(p_name=> 'USER_ID',
3808: p_value=> FND_GLOBAL.USER_ID,
3809: p_parameterlist=>l_parameter_list);
3810:
3811: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
3812: p_value=> FND_GLOBAL.RESP_ID,
3813: p_parameterlist=>l_parameter_list);
3814:
3815: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

Line 3815: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

3811: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
3812: p_value=> FND_GLOBAL.RESP_ID,
3813: p_parameterlist=>l_parameter_list);
3814:
3815: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
3816: p_value=> FND_GLOBAL.RESP_APPL_ID,
3817: p_parameterlist=>l_parameter_list);
3818:
3819:

Line 3820: wf_event.AddParameterToList(p_name=> 'SHIPPER_RESP_ID',

3816: p_value=> FND_GLOBAL.RESP_APPL_ID,
3817: p_parameterlist=>l_parameter_list);
3818:
3819:
3820: wf_event.AddParameterToList(p_name=> 'SHIPPER_RESP_ID',
3821: p_value=> FND_GLOBAL.RESP_ID,
3822: p_parameterlist=>l_parameter_list);
3823:
3824:

Line 3825: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',

3821: p_value=> FND_GLOBAL.RESP_ID,
3822: p_parameterlist=>l_parameter_list);
3823:
3824:
3825: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',
3826: p_value => l_role_name,
3827: p_parameterlist => l_parameter_list);
3828:
3829:

Line 3839: wf_event.raise(

3835: WSH_DEBUG_SV.C_PROC_LEVEL);
3836: END IF;
3837:
3838:
3839: wf_event.raise(
3840: p_event_name => 'oracle.apps.fte.lt.tenderrequest',
3841: p_event_key => p_trip_info.wf_item_key,
3842: p_parameters => l_parameter_list
3843: );

Line 4542: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

4538: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4539: END IF;
4540:
4541:
4542: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
4543: p_value => p_trip_info.tender_status,
4544: p_parameterlist => l_parameter_list);
4545:
4546: IF l_debug_on THEN

Line 4553: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',

4549: WSH_DEBUG_SV.C_PROC_LEVEL);
4550: END IF;
4551:
4552:
4553: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',
4554: p_value => p_trip_info.tender_status,
4555: p_parameterlist => l_parameter_list);
4556:
4557: wf_event.AddParameterToList(p_name => 'TENDER_ID',

Line 4557: wf_event.AddParameterToList(p_name => 'TENDER_ID',

4553: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',
4554: p_value => p_trip_info.tender_status,
4555: p_parameterlist => l_parameter_list);
4556:
4557: wf_event.AddParameterToList(p_name => 'TENDER_ID',
4558: p_value => p_trip_info.tender_id,
4559: p_parameterlist => l_parameter_list);
4560:
4561: wf_event.AddParameterToList(p_name => 'TRIP_ID',

Line 4561: wf_event.AddParameterToList(p_name => 'TRIP_ID',

4557: wf_event.AddParameterToList(p_name => 'TENDER_ID',
4558: p_value => p_trip_info.tender_id,
4559: p_parameterlist => l_parameter_list);
4560:
4561: wf_event.AddParameterToList(p_name => 'TRIP_ID',
4562: p_value => p_trip_info.trip_id,
4563: p_parameterlist => l_parameter_list);
4564:
4565: wf_event.AddParameterToList(p_name => 'CONTACT_USER_NAME',

Line 4565: wf_event.AddParameterToList(p_name => 'CONTACT_USER_NAME',

4561: wf_event.AddParameterToList(p_name => 'TRIP_ID',
4562: p_value => p_trip_info.trip_id,
4563: p_parameterlist => l_parameter_list);
4564:
4565: wf_event.AddParameterToList(p_name => 'CONTACT_USER_NAME',
4566: p_value => FND_GLOBAL.USER_NAME,
4567: p_parameterlist => l_parameter_list);
4568:
4569: wf_event.AddParameterToList(p_name => 'CONTACT_USER_ID',

Line 4569: wf_event.AddParameterToList(p_name => 'CONTACT_USER_ID',

4565: wf_event.AddParameterToList(p_name => 'CONTACT_USER_NAME',
4566: p_value => FND_GLOBAL.USER_NAME,
4567: p_parameterlist => l_parameter_list);
4568:
4569: wf_event.AddParameterToList(p_name => 'CONTACT_USER_ID',
4570: p_value => FND_GLOBAL.USER_ID,
4571: p_parameterlist => l_parameter_list);
4572:
4573:

Line 4574: wf_event.AddParameterToList(p_name => 'CARRIER_REMARKS',

4570: p_value => FND_GLOBAL.USER_ID,
4571: p_parameterlist => l_parameter_list);
4572:
4573:
4574: wf_event.AddParameterToList(p_name => 'CARRIER_REMARKS',
4575: p_value => p_trip_info.remarks,
4576: p_parameterlist => l_parameter_list);
4577:
4578:

Line 4579: wf_event.AddParameterToList(p_name=> 'USER_ID',

4575: p_value => p_trip_info.remarks,
4576: p_parameterlist => l_parameter_list);
4577:
4578:
4579: wf_event.AddParameterToList(p_name=> 'USER_ID',
4580: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4581: p_trip_info.wf_item_key,'USER_ID'),
4582: p_parameterlist=>l_parameter_list);
4583:

Line 4585: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',

4581: p_trip_info.wf_item_key,'USER_ID'),
4582: p_parameterlist=>l_parameter_list);
4583:
4584:
4585: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
4586: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4587: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4588: p_parameterlist=>l_parameter_list);
4589:

Line 4590: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

4586: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4587: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4588: p_parameterlist=>l_parameter_list);
4589:
4590: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
4591: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4592: p_trip_info.wf_item_key,'RESP_APPL_ID'),
4593: p_parameterlist=>l_parameter_list);
4594:

Line 4597: wf_event.raise(

4593: p_parameterlist=>l_parameter_list);
4594:
4595:
4596: IF (p_trip_info.tender_status = FTE_TENDER_PVT.S_ACCEPTED) THEN
4597: wf_event.raise(
4598: p_event_name => 'oracle.apps.fte.lt.tenderaccept',
4599: p_event_key => p_trip_info.wf_item_key,
4600: p_parameters => l_parameter_list
4601: );

Line 4604: wf_event.raise(

4600: p_parameters => l_parameter_list
4601: );
4602:
4603: ELSIF (p_trip_info.tender_status = FTE_TENDER_PVT.S_REJECTED) THEN
4604: wf_event.raise(
4605: p_event_name => 'oracle.apps.fte.lt.tenderreject',
4606: p_event_key => p_trip_info.wf_item_key,
4607: p_parameters => l_parameter_list);
4608: END IF;

Line 4829: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',

4825: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4826: END IF;
4827:
4828:
4829: wf_event.AddParameterToList(p_name => 'TENDER_ACTION',
4830: p_value => p_trip_info.tender_status,
4831: p_parameterlist => l_parameter_list);
4832:
4833: IF l_debug_on THEN

Line 4840: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',

4836: WSH_DEBUG_SV.C_PROC_LEVEL);
4837: END IF;
4838:
4839:
4840: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',
4841: p_value => p_trip_info.tender_status,
4842: p_parameterlist => l_parameter_list);
4843:
4844: wf_event.AddParameterToList(p_name => 'TENDER_ID',

Line 4844: wf_event.AddParameterToList(p_name => 'TENDER_ID',

4840: wf_event.AddParameterToList(p_name => 'TENDER_STATUS',
4841: p_value => p_trip_info.tender_status,
4842: p_parameterlist => l_parameter_list);
4843:
4844: wf_event.AddParameterToList(p_name => 'TENDER_ID',
4845: p_value => p_trip_info.tender_id,
4846: p_parameterlist => l_parameter_list);
4847:
4848: wf_event.AddParameterToList(p_name => 'TRIP_ID',

Line 4848: wf_event.AddParameterToList(p_name => 'TRIP_ID',

4844: wf_event.AddParameterToList(p_name => 'TENDER_ID',
4845: p_value => p_trip_info.tender_id,
4846: p_parameterlist => l_parameter_list);
4847:
4848: wf_event.AddParameterToList(p_name => 'TRIP_ID',
4849: p_value => p_trip_info.trip_id,
4850: p_parameterlist => l_parameter_list);
4851:
4852:

Line 4853: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',

4849: p_value => p_trip_info.trip_id,
4850: p_parameterlist => l_parameter_list);
4851:
4852:
4853: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
4854: p_value=> wf_engine.GetItemAttrText('FTETEREQ',
4855: p_trip_info.wf_item_key,'SHIPPER_NAME'),
4856: p_parameterlist=>l_parameter_list);
4857:

Line 4858: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',

4854: p_value=> wf_engine.GetItemAttrText('FTETEREQ',
4855: p_trip_info.wf_item_key,'SHIPPER_NAME'),
4856: p_parameterlist=>l_parameter_list);
4857:
4858: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',
4859: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4860: p_trip_info.wf_item_key,'USER_ID'),
4861: p_parameterlist=>l_parameter_list);
4862:

Line 4863: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',

4859: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4860: p_trip_info.wf_item_key,'USER_ID'),
4861: p_parameterlist=>l_parameter_list);
4862:
4863: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',
4864: p_value => wf_engine.getItemAttrText(
4865: 'FTETEREQ', p_trip_info.wf_item_key,
4866: 'CONTACT_PERFORMER'),
4867: p_parameterlist => l_parameter_list);

Line 4869: wf_event.AddParameterToList(p_name=> 'USER_ID',

4865: 'FTETEREQ', p_trip_info.wf_item_key,
4866: 'CONTACT_PERFORMER'),
4867: p_parameterlist => l_parameter_list);
4868:
4869: wf_event.AddParameterToList(p_name=> 'USER_ID',
4870: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4871: p_trip_info.wf_item_key,'USER_ID'),
4872: p_parameterlist=>l_parameter_list);
4873:

Line 4875: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',

4871: p_trip_info.wf_item_key,'USER_ID'),
4872: p_parameterlist=>l_parameter_list);
4873:
4874:
4875: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
4876: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4877: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4878: p_parameterlist=>l_parameter_list);
4879:

Line 4880: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

4876: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4877: p_trip_info.wf_item_key,'RESPONSIBILITY_ID'),
4878: p_parameterlist=>l_parameter_list);
4879:
4880: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
4881: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
4882: p_trip_info.wf_item_key,'RESP_APPL_ID'),
4883: p_parameterlist=>l_parameter_list);
4884:

Line 4886: wf_event.raise(

4882: p_trip_info.wf_item_key,'RESP_APPL_ID'),
4883: p_parameterlist=>l_parameter_list);
4884:
4885:
4886: wf_event.raise(
4887: p_event_name => 'oracle.apps.fte.lt.tendercancel',
4888: p_event_key => p_trip_info.wf_item_key,
4889: p_parameters => l_parameter_list
4890: );

Line 5011: wf_event.AddParameterToList( p_name => 'MBOL_NUM',

5007:
5008: l_item_key := p_trip_info.WF_ITEM_KEY;
5009:
5010:
5011: wf_event.AddParameterToList( p_name => 'MBOL_NUM',
5012: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5013: l_item_key,'MBOL_NUM'),
5014: p_parameterlist => l_parameter_list);
5015:

Line 5016: wf_event.AddParameterToList( p_name => 'TENDER_TEXT_ID',

5012: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5013: l_item_key,'MBOL_NUM'),
5014: p_parameterlist => l_parameter_list);
5015:
5016: wf_event.AddParameterToList( p_name => 'TENDER_TEXT_ID',
5017: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5018: l_item_key,'TENDER_TEXT_ID'),
5019: p_parameterlist => l_parameter_list);
5020:

Line 5022: wf_event.AddParameterToList( p_name => 'RESPOND_BY_DATE',

5018: l_item_key,'TENDER_TEXT_ID'),
5019: p_parameterlist => l_parameter_list);
5020:
5021:
5022: wf_event.AddParameterToList( p_name => 'RESPOND_BY_DATE',
5023: p_value => wf_engine.GetItemAttrDate('FTETEREQ',
5024: l_item_key,'RESPOND_BY_DATE'),
5025: p_parameterlist => l_parameter_list);
5026:

Line 5027: wf_event.AddParameterToList( p_name => 'TENDERED_DATE',

5023: p_value => wf_engine.GetItemAttrDate('FTETEREQ',
5024: l_item_key,'RESPOND_BY_DATE'),
5025: p_parameterlist => l_parameter_list);
5026:
5027: wf_event.AddParameterToList( p_name => 'TENDERED_DATE',
5028: p_value => wf_engine.GetItemAttrDate('FTETEREQ',
5029: l_item_key,'TENDERED_DATE'),
5030: p_parameterlist => l_parameter_list);
5031:

Line 5032: wf_event.AddParameterToList( p_name => 'MODE_OF_TRANSPORT',

5028: p_value => wf_engine.GetItemAttrDate('FTETEREQ',
5029: l_item_key,'TENDERED_DATE'),
5030: p_parameterlist => l_parameter_list);
5031:
5032: wf_event.AddParameterToList( p_name => 'MODE_OF_TRANSPORT',
5033: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5034: l_item_key,'MODE_OF_TRANSPORT'),
5035: p_parameterlist => l_parameter_list);
5036:

Line 5037: wf_event.AddParameterToList( p_name => 'SHIPPER_WAIT_TIME',

5033: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5034: l_item_key,'MODE_OF_TRANSPORT'),
5035: p_parameterlist => l_parameter_list);
5036:
5037: wf_event.AddParameterToList( p_name => 'SHIPPER_WAIT_TIME',
5038: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5039: l_item_key,'SHIPPER_WAIT_TIME'),
5040: p_parameterlist => l_parameter_list);
5041:

Line 5043: wf_event.AddParameterToList( p_name => 'SHIPPING_ORG_NAME',

5039: l_item_key,'SHIPPER_WAIT_TIME'),
5040: p_parameterlist => l_parameter_list);
5041:
5042:
5043: wf_event.AddParameterToList( p_name => 'SHIPPING_ORG_NAME',
5044: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5045: l_item_key,'SHIPPING_ORG_NAME'),
5046: p_parameterlist => l_parameter_list);
5047:

Line 5048: wf_event.AddParameterToList( p_name => 'TENDER_ID',

5044: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5045: l_item_key,'SHIPPING_ORG_NAME'),
5046: p_parameterlist => l_parameter_list);
5047:
5048: wf_event.AddParameterToList( p_name => 'TENDER_ID',
5049: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5050: l_item_key,'TENDER_ID'),
5051: p_parameterlist => l_parameter_list);
5052:

Line 5053: wf_event.AddParameterToList( p_name => 'SHIPPER_NAME',

5049: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5050: l_item_key,'TENDER_ID'),
5051: p_parameterlist => l_parameter_list);
5052:
5053: wf_event.AddParameterToList( p_name => 'SHIPPER_NAME',
5054: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5055: l_item_key,'SHIPPER_NAME'),
5056: p_parameterlist => l_parameter_list);
5057:

Line 5058: wf_event.AddParameterToList( p_name => 'CONTACT_PERFORMER',

5054: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5055: l_item_key,'SHIPPER_NAME'),
5056: p_parameterlist => l_parameter_list);
5057:
5058: wf_event.AddParameterToList( p_name => 'CONTACT_PERFORMER',
5059: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5060: l_item_key,'CONTACT_PERFORMER'),
5061: p_parameterlist => l_parameter_list);
5062:

Line 5063: wf_event.AddParameterToList( p_name => 'CARRIER_ID',

5059: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5060: l_item_key,'CONTACT_PERFORMER'),
5061: p_parameterlist => l_parameter_list);
5062:
5063: wf_event.AddParameterToList( p_name => 'CARRIER_ID',
5064: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5065: l_item_key,'CARRIER_ID'),
5066: p_parameterlist => l_parameter_list);
5067:

Line 5068: wf_event.AddParameterToList( p_name => 'CARRIER_SITE_ID',

5064: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5065: l_item_key,'CARRIER_ID'),
5066: p_parameterlist => l_parameter_list);
5067:
5068: wf_event.AddParameterToList( p_name => 'CARRIER_SITE_ID',
5069: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5070: l_item_key,'CARRIER_SITE_ID'),
5071: p_parameterlist => l_parameter_list);
5072:

Line 5073: wf_event.AddParameterToList( p_name => 'RESPONSE_URL',

5069: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5070: l_item_key,'CARRIER_SITE_ID'),
5071: p_parameterlist => l_parameter_list);
5072:
5073: wf_event.AddParameterToList( p_name => 'RESPONSE_URL',
5074: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5075: l_item_key,'RESPONSE_URL'),
5076: p_parameterlist => l_parameter_list);
5077:

Line 5078: wf_event.AddParameterToList( p_name => 'NOTIF_TYPE',

5074: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5075: l_item_key,'RESPONSE_URL'),
5076: p_parameterlist => l_parameter_list);
5077:
5078: wf_event.AddParameterToList( p_name => 'NOTIF_TYPE',
5079: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5080: l_item_key,'NOTIF_TYPE'),
5081: p_parameterlist => l_parameter_list);
5082:

Line 5083: wf_event.AddParameterToList( p_name => 'TRIP_ID',

5079: p_value => wf_engine.GetItemAttrText('FTETEREQ',
5080: l_item_key,'NOTIF_TYPE'),
5081: p_parameterlist => l_parameter_list);
5082:
5083: wf_event.AddParameterToList( p_name => 'TRIP_ID',
5084: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5085: l_item_key,'TRIP_ID'),
5086: p_parameterlist => l_parameter_list);
5087:

Line 5088: wf_event.AddParameterToList( p_name => 'SHIPPER_USER_ID',

5084: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5085: l_item_key,'TRIP_ID'),
5086: p_parameterlist => l_parameter_list);
5087:
5088: wf_event.AddParameterToList( p_name => 'SHIPPER_USER_ID',
5089: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5090: l_item_key,'SHIPPER_USER_ID'),
5091: p_parameterlist => l_parameter_list);
5092:

Line 5093: wf_event.AddParameterToList(p_name=> 'USER_ID',

5089: p_value => wf_engine.GetItemAttrNumber('FTETEREQ',
5090: l_item_key,'SHIPPER_USER_ID'),
5091: p_parameterlist => l_parameter_list);
5092:
5093: wf_event.AddParameterToList(p_name=> 'USER_ID',
5094: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5095: l_item_key,'USER_ID'),
5096: p_parameterlist=>l_parameter_list);
5097:

Line 5099: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',

5095: l_item_key,'USER_ID'),
5096: p_parameterlist=>l_parameter_list);
5097:
5098:
5099: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
5100: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5101: l_item_key,'RESPONSIBILITY_ID'),
5102: p_parameterlist=>l_parameter_list);
5103:

Line 5104: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',

5100: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5101: l_item_key,'RESPONSIBILITY_ID'),
5102: p_parameterlist=>l_parameter_list);
5103:
5104: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
5105: p_value=> wf_engine.GetItemAttrNumber('FTETEREQ',
5106: l_item_key,'RESP_APPL_ID'),
5107: p_parameterlist=>l_parameter_list);
5108:

Line 5110: wf_event.raise(

5106: l_item_key,'RESP_APPL_ID'),
5107: p_parameterlist=>l_parameter_list);
5108:
5109:
5110: wf_event.raise(
5111: p_event_name => 'oracle.apps.fte.lt.tenderupdate',
5112: p_event_key => GET_ITEM_KEY(p_trip_info.trip_id),--p_item_key,
5113: p_parameters => l_parameter_list
5114: );