eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_SS_INTERFACE dependencies on FTE_SS_ATTR_REC

Line 250: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,

246: P_API_VERSION_NUMBER IN NUMBER,
247: P_INIT_MSG_LIST IN VARCHAR2,
248: P_COMMIT IN VARCHAR2,
249: P_CALLER IN VARCHAR2,
250: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
251: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
252: X_SAVE_RANK_LIST OUT NOCOPY VARCHAR2,
253: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 322: p_trip_id => P_FTE_SS_ATTR_REC.TRIP_ID);

318: x_return_status => l_return_status,
319: x_msg_count => l_msg_count,
320: x_msg_data => l_msg_data,
321: x_ranklist => l_rank_list_tbl,
322: p_trip_id => P_FTE_SS_ATTR_REC.TRIP_ID);
323:
324: l_tbl_count := l_rank_list_tbl.COUNT;
325:
326: IF l_debug_on

Line 331: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,

327: THEN
328: LOG(l_module_name,' Carrier Rank list count ' ||
329: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);
330: LOG(l_module_name,' Append list flag = ' ||
331: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||
334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
335: LOG(l_module_name,' Existing Rank Id = ' ||

Line 334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

330: LOG(l_module_name,' Append list flag = ' ||
331: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||
334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
335: LOG(l_module_name,' Existing Rank Id = ' ||
336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
337: END IF;
338:

Line 336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||
334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
335: LOG(l_module_name,' Existing Rank Id = ' ||
336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
337: END IF;
338:
339: IF (l_tbl_count = 0)
340: THEN

Line 394: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')

390: END IF;
391:
392: -- 1 Full SM / 1 Full SM with Service Case
393: -- Check append list flag
394: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')
395: THEN
396: --{
397: IF l_debug_on
398: THEN

Line 401: P_FTE_SS_ATTR_REC.RULE_ID,

397: IF l_debug_on
398: THEN
399: LOG(l_module_name,
400: ' Calling Routing Guide Rule _id ' ||
401: P_FTE_SS_ATTR_REC.RULE_ID,
402: WSH_DEBUG_SV.C_PROC_LEVEL);
403: END IF;
404:
405: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,

Line 405: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,

401: P_FTE_SS_ATTR_REC.RULE_ID,
402: WSH_DEBUG_SV.C_PROC_LEVEL);
403: END IF;
404:
405: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,
406: x_routing_results => l_routing_results,
407: x_return_status => l_return_status);
408:
409:

Line 641: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,

637: P_API_VERSION_NUMBER IN NUMBER,
638: P_INIT_MSG_LIST IN VARCHAR2,
639: P_COMMIT IN VARCHAR2,
640: P_CALLER IN VARCHAR2,
641: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
642: X_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
643: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
644: X_SAVE_RANK_LIST OUT NOCOPY VARCHAR2,
645: X_RANK_EXIST_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

Line 729: p_trip_id => P_FTE_SS_ATTR_REC.TRIP_ID);

725: x_return_status => l_return_status,
726: x_msg_count => l_msg_count,
727: x_msg_data => l_msg_data,
728: x_ranklist => l_rank_list_tbl,
729: p_trip_id => P_FTE_SS_ATTR_REC.TRIP_ID);
730:
731: l_tbl_count := l_rank_list_tbl.COUNT;
732:
733: IF l_debug_on

Line 738: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,

734: THEN
735: LOG(l_module_name,' Carrier Rank list count ' ||
736: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);
737: LOG(l_module_name,' Append list flag = ' ||
738: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||
741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||

Line 741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

737: LOG(l_module_name,' Append list flag = ' ||
738: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||
741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,

Line 743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||
741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,

Line 745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,

741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
748: WSH_DEBUG_SV.C_PROC_LEVEL);
749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,

Line 747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,

743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
748: WSH_DEBUG_SV.C_PROC_LEVEL);
749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
750: WSH_DEBUG_SV.C_PROC_LEVEL);
751:

Line 749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,

745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
748: WSH_DEBUG_SV.C_PROC_LEVEL);
749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
750: WSH_DEBUG_SV.C_PROC_LEVEL);
751:
752:
753: END IF;

Line 765: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;

761: ' and user does search services from UI ' ||
762: ' In this case just add user pref to search criteira ', WSH_DEBUG_SV.C_PROC_LEVEL);
763: END IF;
764:
765: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
766: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
767: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
768: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
769: l_new_rank_list_rec.SORT := 'UI';

Line 766: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;

762: ' In this case just add user pref to search criteira ', WSH_DEBUG_SV.C_PROC_LEVEL);
763: END IF;
764:
765: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
766: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
767: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
768: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
769: l_new_rank_list_rec.SORT := 'UI';
770:

Line 767: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;

763: END IF;
764:
765: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
766: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
767: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
768: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
769: l_new_rank_list_rec.SORT := 'UI';
770:
771: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_new_rank_list_rec;

Line 828: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')

824: END IF;
825:
826: -- 1 Full SM / 1 Full SM with Service Case
827: -- Check append list flag
828: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')
829: THEN
830: --{
831: IF l_debug_on
832: THEN

Line 835: P_FTE_SS_ATTR_REC.RULE_ID,

831: IF l_debug_on
832: THEN
833: LOG(l_module_name,
834: ' Calling Routing Guide Rule _id ' ||
835: P_FTE_SS_ATTR_REC.RULE_ID,
836: WSH_DEBUG_SV.C_PROC_LEVEL);
837: END IF;
838:
839: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,

Line 839: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,

835: P_FTE_SS_ATTR_REC.RULE_ID,
836: WSH_DEBUG_SV.C_PROC_LEVEL);
837: END IF;
838:
839: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,
840: x_routing_results => l_routing_results,
841: x_return_status => l_return_status);
842:
843:

Line 916: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')

912:
913: END IF;
914:
915:
916: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')
917: THEN
918: X_SAVE_RANK_LIST := FND_API.G_TRUE;
919: l_rank_list_rec.SORT := 'RL';
920: l_rank_list_rec.RANK_ID := null;

Line 942: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,

938: x_msg_count => l_msg_count,
939: x_msg_data => l_msg_data,
940: p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_DELETE,
941: p_ranklist => l_temp_rank_tbl,
942: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,
943: p_rank_id => null);
944:
945: wsh_util_core.api_post_call(
946: p_return_status =>l_return_status,

Line 959: p_trip_info.TRIP_ID := P_FTE_SS_ATTR_REC.trip_id;

955: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
956:
957: -- Update trip information
958: p_trip_info.RANK_ID := NULL;
959: p_trip_info.TRIP_ID := P_FTE_SS_ATTR_REC.trip_id;
960:
961: p_trip_info_tab(1) :=p_trip_info;
962: p_trip_in_rec.caller :='FTE_LOAD_TENDER';
963: p_trip_in_rec.phase :=NULL;

Line 1032: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')

1028: X_RANK_EXIST_TAB(1) := l_rank_list_rec;
1029:
1030: -- 1 Full SM / 1 Full SM with Service Case
1031: -- Check append list flag
1032: IF (P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG = 'Y')
1033: THEN
1034: --{
1035: IF l_debug_on
1036: THEN

Line 1039: P_FTE_SS_ATTR_REC.RULE_ID,

1035: IF l_debug_on
1036: THEN
1037: LOG(l_module_name,
1038: ' Calling Routing Guide Rule _id ' ||
1039: P_FTE_SS_ATTR_REC.RULE_ID,
1040: WSH_DEBUG_SV.C_PROC_LEVEL);
1041: END IF;
1042:
1043: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,

Line 1043: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,

1039: P_FTE_SS_ATTR_REC.RULE_ID,
1040: WSH_DEBUG_SV.C_PROC_LEVEL);
1041: END IF;
1042:
1043: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,
1044: x_routing_results => l_routing_results,
1045: x_return_status => l_return_status);
1046:
1047:

Line 1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,

1155: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
1156: WSH_DEBUG_SV.C_PROC_LEVEL);
1157: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
1158: WSH_DEBUG_SV.C_PROC_LEVEL);
1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);
1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,

Line 1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,

1157: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
1158: WSH_DEBUG_SV.C_PROC_LEVEL);
1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);
1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
1164: WSH_DEBUG_SV.C_PROC_LEVEL);
1165:

Line 1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,

1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);
1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
1164: WSH_DEBUG_SV.C_PROC_LEVEL);
1165:
1166: END IF;
1167:

Line 1169: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_rec.CARRIER_ID)

1165:
1166: END IF;
1167:
1168:
1169: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_rec.CARRIER_ID)
1170: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_rec.SERVICE_LEVEL)
1171: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_rec.MODE_OF_TRANSPORT))
1172: THEN
1173: --{

Line 1170: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_rec.SERVICE_LEVEL)

1166: END IF;
1167:
1168:
1169: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_rec.CARRIER_ID)
1170: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_rec.SERVICE_LEVEL)
1171: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_rec.MODE_OF_TRANSPORT))
1172: THEN
1173: --{
1174:

Line 1171: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_rec.MODE_OF_TRANSPORT))

1167:
1168:
1169: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_rec.CARRIER_ID)
1170: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_rec.SERVICE_LEVEL)
1171: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_rec.MODE_OF_TRANSPORT))
1172: THEN
1173: --{
1174:
1175:

Line 1190: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;

1186: LOG(l_module_name,' Different ',WSH_DEBUG_SV.C_PROC_LEVEL);
1187: END IF;
1188:
1189:
1190: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1191: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1192: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1193: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1194: l_new_rank_list_rec.SORT := 'UI';

Line 1191: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;

1187: END IF;
1188:
1189:
1190: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1191: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1192: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1193: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1194: l_new_rank_list_rec.SORT := 'UI';
1195:

Line 1192: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;

1188:
1189:
1190: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1191: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1192: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1193: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1194: l_new_rank_list_rec.SORT := 'UI';
1195:
1196: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_new_rank_list_rec;

Line 1250: IF (P_FTE_SS_ATTR_REC.RANK_ID = l_rank_list_tbl(i).RANK_ID)

1246: -- delete this from rank list table.
1247: DELETE FTE_CARRIER_RANK_LIST
1248: WHERE RANK_ID = l_rank_list_tbl(i).RANK_ID;
1249:
1250: IF (P_FTE_SS_ATTR_REC.RANK_ID = l_rank_list_tbl(i).RANK_ID)
1251: THEN
1252:
1253: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
1254:

Line 1257: p_trip_info.TRIP_ID := P_FTE_SS_ATTR_REC.trip_id;

1253: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
1254:
1255: -- Update trip information
1256: p_trip_info.RANK_ID := NULL;
1257: p_trip_info.TRIP_ID := P_FTE_SS_ATTR_REC.trip_id;
1258:
1259: p_trip_info_tab(1) :=p_trip_info;
1260: p_trip_in_rec.caller :='FTE_LOAD_TENDER';
1261: p_trip_in_rec.phase :=NULL;

Line 1325: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_tbl(i).CARRIER_ID)

1321: IF (l_sm_modified = 'Y')
1322: THEN
1323:
1324:
1325: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_tbl(i).CARRIER_ID)
1326: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_tbl(i).SERVICE_LEVEL)
1327: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_tbl(i).MODE_OF_TRANSPORT))
1328: THEN
1329: --{

Line 1326: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_tbl(i).SERVICE_LEVEL)

1322: THEN
1323:
1324:
1325: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_tbl(i).CARRIER_ID)
1326: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_tbl(i).SERVICE_LEVEL)
1327: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_tbl(i).MODE_OF_TRANSPORT))
1328: THEN
1329: --{
1330: IF l_debug_on

Line 1327: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_tbl(i).MODE_OF_TRANSPORT))

1323:
1324:
1325: IF ((P_FTE_SS_ATTR_REC.CARRIER_ID = l_rank_list_tbl(i).CARRIER_ID)
1326: AND (P_FTE_SS_ATTR_REC.SERVICE_LEVEL = l_rank_list_tbl(i).SERVICE_LEVEL)
1327: AND (P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT = l_rank_list_tbl(i).MODE_OF_TRANSPORT))
1328: THEN
1329: --{
1330: IF l_debug_on
1331: THEN

Line 1344: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;

1340:
1341: IF (l_sm_modified = 'Y')
1342: THEN
1343:
1344: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1345: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1346: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1347:
1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;

Line 1345: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;

1341: IF (l_sm_modified = 'Y')
1342: THEN
1343:
1344: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1345: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1346: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1347:
1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1349:

Line 1346: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;

1342: THEN
1343:
1344: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
1345: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;
1346: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1347:
1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1349:
1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL

Line 1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL

1346: l_new_rank_list_rec.MODE_OF_TRANSPORT := P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT;
1347:
1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1349:
1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL
1351: AND P_FTE_SS_ATTR_REC.SERVICE_LEVEL IS NULL
1352: AND P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT IS NULL)
1353: THEN
1354: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;

Line 1351: AND P_FTE_SS_ATTR_REC.SERVICE_LEVEL IS NULL

1347:
1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1349:
1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL
1351: AND P_FTE_SS_ATTR_REC.SERVICE_LEVEL IS NULL
1352: AND P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT IS NULL)
1353: THEN
1354: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;
1355: END IF;

Line 1352: AND P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT IS NULL)

1348: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_UI;
1349:
1350: IF (P_FTE_SS_ATTR_REC.CARRIER_ID IS NULL
1351: AND P_FTE_SS_ATTR_REC.SERVICE_LEVEL IS NULL
1352: AND P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT IS NULL)
1353: THEN
1354: l_new_rank_list_rec.SOURCE := FTE_CARRIER_RANK_LIST_PVT.S_SOURCE_LCSS;
1355: END IF;
1356:

Line 1450: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,

1446: P_INIT_MSG_LIST IN VARCHAR2,
1447: P_API_VERSION_NUMBER IN NUMBER,
1448: P_COMMIT IN VARCHAR2,
1449: P_CALLER IN VARCHAR2,
1450: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
1451: X_RATING_REQUEST_ID OUT NOCOPY NUMBER,
1452: X_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
1453: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
1454: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1529: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

1525: THEN
1526: LOG(l_module_name,' P_caller ' ||
1527: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
1528: LOG(l_module_name,' Append list flag ' ||
1529: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
1530: END IF;
1531:
1532: IF (p_caller = S_CALLER_WF)
1533: THEN

Line 1537: IF (P_FTE_SS_ATTR_REC.append_list_flag = 'N' OR

1533: THEN
1534: --{
1535:
1536: -- Use NVL
1537: IF (P_FTE_SS_ATTR_REC.append_list_flag = 'N' OR
1538: P_FTE_SS_ATTR_REC.append_list_flag IS NULL)
1539: THEN
1540: --{
1541: IF l_debug_on

Line 1538: P_FTE_SS_ATTR_REC.append_list_flag IS NULL)

1534: --{
1535:
1536: -- Use NVL
1537: IF (P_FTE_SS_ATTR_REC.append_list_flag = 'N' OR
1538: P_FTE_SS_ATTR_REC.append_list_flag IS NULL)
1539: THEN
1540: --{
1541: IF l_debug_on
1542: THEN

Line 1563: P_FTE_SS_ATTR_REC => p_fte_ss_attr_rec,

1559: P_API_VERSION_NUMBER => 1.0,
1560: P_INIT_MSG_LIST => FND_API.G_FALSE,
1561: P_COMMIT => p_commit,
1562: P_CALLER => p_caller,
1563: P_FTE_SS_ATTR_REC => p_fte_ss_attr_rec,
1564: X_SS_RATE_SORT_TAB => l_search_criteria_tbl,
1565: X_SAVE_RANK_LIST => l_save_rank_list,
1566: X_RANK_EXIST_TAB => l_existing_service_tbl,
1567: X_RETURN_STATUS => l_return_status,

Line 1604: P_FTE_SS_ATTR_REC => p_fte_ss_attr_rec,

1600: P_API_VERSION_NUMBER => 1.0,
1601: P_INIT_MSG_LIST => FND_API.G_FALSE,
1602: P_COMMIT => p_commit,
1603: P_CALLER => p_caller,
1604: P_FTE_SS_ATTR_REC => p_fte_ss_attr_rec,
1605: X_LIST_CREATE_TYPE => x_list_create_type,
1606: X_SS_RATE_SORT_TAB => l_search_criteria_tbl,
1607: X_SAVE_RANK_LIST => l_save_rank_list,
1608: X_RANK_EXIST_TAB => l_existing_service_tbl,

Line 1700: p_ss_rate_sort_atr_rec => P_FTE_SS_ATTR_REC,

1696: FTE_TRIP_RATING_GRP.Search_Rate_Sort(
1697: p_api_version => 1.0,
1698: p_init_msg_list => FND_API.G_FALSE,
1699: p_ss_rate_sort_tab => l_search_criteria_tbl,
1700: p_ss_rate_sort_atr_rec => P_FTE_SS_ATTR_REC,
1701: x_ss_rate_sort_tab => l_search_results_tbl,
1702: x_rating_request_id => x_rating_request_id,
1703: x_return_status => l_return_status,
1704: x_msg_count => l_msg_count,

Line 1963: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,

1959: x_msg_count => l_msg_count,
1960: x_msg_data => l_msg_data,
1961: p_action_code => l_rank_list_action,
1962: p_ranklist => l_rank_list_in_param_tbl,
1963: p_trip_id => P_FTE_SS_ATTR_REC.trip_id,
1964: p_rank_id => null);
1965:
1966: wsh_util_core.api_post_call(
1967: p_return_status =>l_return_status,

Line 2088: IF (P_FTE_SS_ATTR_REC.TRIP_ID IS NOT NULL)

2084:
2085: -- If trip is is null, in DWB case, we should not update the trip
2086: -- because there is no trip. UI call is going to set append flag to N
2087: -- later : HBHAGAVA
2088: IF (P_FTE_SS_ATTR_REC.TRIP_ID IS NOT NULL)
2089: THEN
2090:
2091: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
2092:

Line 2095: p_trip_info.TRIP_ID := P_FTE_SS_ATTR_REC.trip_id;

2091: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
2092:
2093: -- Update trip information
2094: p_trip_info.APPEND_FLAG := 'N';
2095: p_trip_info.TRIP_ID := P_FTE_SS_ATTR_REC.trip_id;
2096:
2097: p_trip_info_tab(1) :=p_trip_info;
2098: p_trip_in_rec.caller :='FTE_LOAD_TENDER';
2099: p_trip_in_rec.phase :=NULL;

Line 2267: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,

2263: P_INIT_MSG_LIST IN VARCHAR2,
2264: P_API_VERSION_NUMBER IN NUMBER,
2265: P_COMMIT IN VARCHAR2,
2266: P_CALLER IN VARCHAR2,
2267: P_FTE_SS_ATTR_REC IN FTE_SS_ATTR_REC,
2268: X_RATING_REQUEST_ID OUT NOCOPY NUMBER,
2269: X_LIST_CREATE_TYPE OUT NOCOPY VARCHAR2,
2270: X_SS_RATE_SORT_TAB OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
2271: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

2322: THEN
2323: LOG(l_module_name,' P_caller ' ||
2324: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
2325: LOG(l_module_name,' Append list flag ' ||
2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2327: LOG(l_module_name,' Calling FTE_SS_INTERFACE.SEARCH_SERVICES ' ||
2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2329:
2330: END IF;

Line 2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

2324: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
2325: LOG(l_module_name,' Append list flag ' ||
2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2327: LOG(l_module_name,' Calling FTE_SS_INTERFACE.SEARCH_SERVICES ' ||
2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2329:
2330: END IF;
2331:
2332:

Line 2338: P_FTE_SS_ATTR_REC => p_FTE_SS_ATTR_REC,

2334: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
2335: P_API_VERSION_NUMBER => 1.0,
2336: P_COMMIT => P_COMMIT,
2337: P_CALLER => P_CALLER,
2338: P_FTE_SS_ATTR_REC => p_FTE_SS_ATTR_REC,
2339: X_RATING_REQUEST_ID => X_RATING_REQUEST_ID,
2340: X_LIST_CREATE_TYPE => X_LIST_CREATE_TYPE,
2341: X_SS_RATE_SORT_TAB => l_SS_RATE_SORT_TAB,
2342: x_return_status => l_return_status,

Line 2715: -- If FTE_SS_ATTR_REC.DELIVERY_ID and

2711: -- PROCEDURE : ASSIGN_SERVICE_TENDER FTE wrapper
2712: --
2713: -- COMMENT : Procedure assigns service, creates/updates ranked list,
2714: -- tenders, and deletes rates. TripId should exist in the db.
2715: -- If FTE_SS_ATTR_REC.DELIVERY_ID and
2716: -- FTE_SS_ATTR_REC.DELIVERY_LEG_ID are null, then it means the
2717: -- caller is TWB. Otherwise, the caller is DWB or ManItinerary
2718: -- CALLER : FTE UI: TripWB, DeliveryWB, ManageItinerary
2719: --========================================================================

Line 2716: -- FTE_SS_ATTR_REC.DELIVERY_LEG_ID are null, then it means the

2712: --
2713: -- COMMENT : Procedure assigns service, creates/updates ranked list,
2714: -- tenders, and deletes rates. TripId should exist in the db.
2715: -- If FTE_SS_ATTR_REC.DELIVERY_ID and
2716: -- FTE_SS_ATTR_REC.DELIVERY_LEG_ID are null, then it means the
2717: -- caller is TWB. Otherwise, the caller is DWB or ManItinerary
2718: -- CALLER : FTE UI: TripWB, DeliveryWB, ManageItinerary
2719: --========================================================================
2720: --

Line 2726: p_SS_ATTR_REC IN FTE_SS_ATTR_REC,

2722: (
2723: p_API_VERSION_NUMBER IN NUMBER,
2724: p_INIT_MSG_LIST IN VARCHAR2,
2725: p_COMMIT IN VARCHAR2,
2726: p_SS_ATTR_REC IN FTE_SS_ATTR_REC,
2727: p_SS_RATE_SORT_TAB IN OUT NOCOPY FTE_SS_RATE_SORT_TAB_TYPE,
2728: p_TENDER_ATTR_REC IN FTE_TENDER_ATTR_REC,
2729: p_REQUEST_ID IN NUMBER,
2730: p_SERVICE_ACTION IN VARCHAR2,

Line 2905: -- current service from FTE_SS_ATTR_REC and rank id.

2901: */
2902:
2903: -- Step 4: Update Trip
2904: -- If delivery_id is null, this call is coming from TripWB. Update Trip with
2905: -- current service from FTE_SS_ATTR_REC and rank id.
2906: -- Else this call is coming from DWB or MI. Update Trip with Rank Id only.
2907:
2908: -- Step 4a: Set reprice flag to N
2909: