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.OE_LINE_FULLFILL dependencies on OE_ORDER_UTIL

Line 909: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

905: -- calling notification framework to get index position
906: IF l_debug_level > 0 THEN
907: oe_debug_pub.add('Line_id is:' || p_line_rec.line_id ) ;
908: END IF;
909: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
910: p_header_id=>p_line_rec.header_id,
911: p_line_rec =>l_line_tbl(1),
912: p_line_id => p_line_rec.line_id,
913: x_index => l_notify_index,

Line 926: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(1);

922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: END IF;
924: IF l_notify_index IS NOT NULL THEN
925: --update Global Picture directly
926: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(1);
927: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
928:
929: oe_debug_pub.add('line_rec line id is :'|| l_line_rec.line_id);
930: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);

Line 927: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

923: END IF;
924: IF l_notify_index IS NOT NULL THEN
925: --update Global Picture directly
926: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(1);
927: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
928:
929: oe_debug_pub.add('line_rec line id is :'|| l_line_rec.line_id);
930: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);
931:

Line 933: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;

929: oe_debug_pub.add('line_rec line id is :'|| l_line_rec.line_id);
930: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);
931:
932: /* commented as unnecessary for 3803251
933: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
934: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
935: */
936: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;

Line 934: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;

930: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);
931:
932: /* commented as unnecessary for 3803251
933: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
934: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
935: */
936: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
938: IF l_fulfilled_quantity2 <> 0 then

Line 936: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';

932: /* commented as unnecessary for 3803251
933: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
934: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
935: */
936: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
938: IF l_fulfilled_quantity2 <> 0 then
939: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
940: ELSE

Line 937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;

933: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
934: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
935: */
936: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
938: IF l_fulfilled_quantity2 <> 0 then
939: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
940: ELSE
941: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;

Line 939: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873

935: */
936: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
938: IF l_fulfilled_quantity2 <> 0 then
939: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
940: ELSE
941: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
942: END IF;
943:

Line 941: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;

937: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
938: IF l_fulfilled_quantity2 <> 0 then
939: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
940: ELSE
941: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
942: END IF;
943:
944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;

Line 944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;

940: ELSE
941: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
942: END IF;
943:
944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;

Line 945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;

941: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
942: END IF;
943:
944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;

Line 946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637

942: END IF;
943:
944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
950: /* changes for AFD */

Line 947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;

943:
944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
950: /* changes for AFD */
951: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

Line 948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;

944: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
950: /* changes for AFD */
951: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
952:

Line 949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;

945: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
946: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
950: /* changes for AFD */
951: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
952:
953: IF l_debug_level > 0 THEN

Line 951: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

947: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
949: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
950: /* changes for AFD */
951: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
952:
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1) ;
955: END IF;

Line 954: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1) ;

950: /* changes for AFD */
951: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
952:
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1) ;
955: END IF;
956: END IF;
957: END IF; /*code_release_level*/
958: -- notification framework end

Line 1132: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

1128: -- added for notification framework
1129: --check code release level first. Notification framework is at Pack H level
1130: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1131: -- calling notification framework to get index position
1132: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
1133: p_header_id=>l_line_tbl(l_index).header_id,
1134: p_line_rec=>l_line_tbl(l_index),
1135: p_line_id => p_line_tbl(l_index).line_id,
1136: x_index => l_notify_index,

Line 1150: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);

1146: END IF;
1147: IF l_notify_index IS NOT NULL THEN
1148: --update Global Picture directly
1149: -- Fix for the bug2635911
1150: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;

Line 1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);

1147: IF l_notify_index IS NOT NULL THEN
1148: --update Global Picture directly
1149: -- Fix for the bug2635911
1150: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;

Line 1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

1148: --update Global Picture directly
1149: -- Fix for the bug2635911
1150: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;

Line 1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;

1149: -- Fix for the bug2635911
1150: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1157: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873

Line 1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;

1150: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1157: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;

Line 1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;

1151: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1157: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1159: ELSE

Line 1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;

1152: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1153: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1157: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1159: ELSE
1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873

Line 1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;

1154: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1155: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1157: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1159: ELSE
1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1161: END IF;
1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;

Line 1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873

1156: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1157: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1159: ELSE
1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1161: END IF;
1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637

Line 1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;

1158: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1159: ELSE
1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1161: END IF;
1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;

Line 1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;

1159: ELSE
1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1161: END IF;
1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;

Line 1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637

1160: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1161: END IF;
1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1168: -- Changes for AFD

Line 1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;

1161: END IF;
1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1168: -- Changes for AFD
1169: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

Line 1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;

1162: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1168: -- Changes for AFD
1169: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1170: -- end Changes for AFD

Line 1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;

1163: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1164: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1168: -- Changes for AFD
1169: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1170: -- end Changes for AFD
1171: IF l_debug_level > 0 THEN

Line 1169: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

1165: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1166: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1167: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1168: -- Changes for AFD
1169: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1170: -- end Changes for AFD
1171: IF l_debug_level > 0 THEN
1172: oe_debug_pub.add('Line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1);
1173: END IF;

Line 1172: oe_debug_pub.add('Line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1);

1168: -- Changes for AFD
1169: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1170: -- end Changes for AFD
1171: IF l_debug_level > 0 THEN
1172: oe_debug_pub.add('Line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1);
1173: END IF;
1174: END IF;
1175: END IF; --code_release_level
1176: -- notification framework end

Line 2165: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

2161: -- check code release level first.
2162: -- Notification framework is at Pack H level
2163: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2164: -- calling notification framework to get index position
2165: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
2166: p_header_id=>l_line_tbl(1).header_id,
2167: p_old_line_rec => l_old_line_tbl(1),
2168: p_line_rec =>l_line_tbl(1),
2169: p_line_id =>l_line_tbl(1).line_id ,

Line 2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);

2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: END IF;
2181: IF l_index IS NOT NULL THEN
2182: --update Global Picture directly
2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;

Line 2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);

2180: END IF;
2181: IF l_index IS NOT NULL THEN
2182: --update Global Picture directly
2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;

Line 2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;

2181: IF l_index IS NOT NULL THEN
2182: --update Global Picture directly
2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;

Line 2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;

2182: --update Global Picture directly
2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;

Line 2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;

2183: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2191: -- Changes for AFD

Line 2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;

2184: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2191: -- Changes for AFD
2192: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;

Line 2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;

2185: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2191: -- Changes for AFD
2192: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2193: -- end Changes for AFD

Line 2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;

2186: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2187: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2191: -- Changes for AFD
2192: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2193: -- end Changes for AFD
2194: IF l_debug_level > 0 THEN

Line 2192: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;

2188: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2189: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2190: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2191: -- Changes for AFD
2192: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2193: -- end Changes for AFD
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(l_index).fulfilled_flag,1) ;
2196: END IF;

Line 2195: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(l_index).fulfilled_flag,1) ;

2191: -- Changes for AFD
2192: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2193: -- end Changes for AFD
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(l_index).fulfilled_flag,1) ;
2196: END IF;
2197: END IF;
2198:
2199: