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 930: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

926: -- calling notification framework to get index position
927: IF l_debug_level > 0 THEN
928: oe_debug_pub.add('Line_id is:' || p_line_rec.line_id ) ;
929: END IF;
930: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
931: p_header_id=>p_line_rec.header_id,
932: p_line_rec =>l_line_tbl(1),
933: p_line_id => p_line_rec.line_id,
934: x_index => l_notify_index,

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

943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END IF;
945: IF l_notify_index IS NOT NULL THEN
946: --update Global Picture directly
947: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(1);
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
949:
950: oe_debug_pub.add('line_rec line id is :'|| l_line_rec.line_id);
951: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);

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

944: END IF;
945: IF l_notify_index IS NOT NULL THEN
946: --update Global Picture directly
947: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= l_old_line_tbl(1);
948: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
949:
950: oe_debug_pub.add('line_rec line id is :'|| l_line_rec.line_id);
951: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);
952:

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

950: oe_debug_pub.add('line_rec line id is :'|| l_line_rec.line_id);
951: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);
952:
953: /* commented as unnecessary for 3803251
954: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
955: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
956: */
957: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
958: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;

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

951: oe_debug_pub.add('line_rec header id is :'|| l_line_rec.header_id);
952:
953: /* commented as unnecessary for 3803251
954: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
955: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
956: */
957: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
958: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
959: IF l_fulfilled_quantity2 <> 0 then

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

953: /* commented as unnecessary for 3803251
954: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
955: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
956: */
957: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
958: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
959: IF l_fulfilled_quantity2 <> 0 then
960: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
961: ELSE

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

954: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := l_line_rec.line_id;
955: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := l_line_rec.header_id;
956: */
957: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
958: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
959: IF l_fulfilled_quantity2 <> 0 then
960: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
961: ELSE
962: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;

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

956: */
957: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := 'Y';
958: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
959: IF l_fulfilled_quantity2 <> 0 then
960: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
961: ELSE
962: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
963: END IF;
964:

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

958: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := l_fulfilled_quantity;
959: IF l_fulfilled_quantity2 <> 0 then
960: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := l_fulfilled_quantity2; -- 5126873
961: ELSE
962: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
963: END IF;
964:
965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;

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

961: ELSE
962: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
963: END IF;
964:
965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;

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

962: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
963: END IF;
964:
965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;

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

963: END IF;
964:
965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
971: /* changes for AFD */

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

964:
965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
971: /* changes for AFD */
972: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

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

965: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := SYSDATE;
966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
971: /* changes for AFD */
972: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
973:

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

966: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
967: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
971: /* changes for AFD */
972: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
973:
974: IF l_debug_level > 0 THEN

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

968: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
969: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
970: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
971: /* changes for AFD */
972: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
973:
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1) ;
976: END IF;

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

971: /* changes for AFD */
972: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
973:
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1) ;
976: END IF;
977: END IF;
978: END IF; /*code_release_level*/
979: -- notification framework end

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

1185: -- added for notification framework
1186: --check code release level first. Notification framework is at Pack H level
1187: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1188: -- calling notification framework to get index position
1189: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
1190: p_header_id=>l_line_tbl(l_index).header_id,
1191: p_line_rec=>l_line_tbl(l_index),
1192: p_line_id => p_line_tbl(l_index).line_id,
1193: x_index => l_notify_index,

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

1203: END IF;
1204: IF l_notify_index IS NOT NULL THEN
1205: --update Global Picture directly
1206: -- Fix for the bug2635911
1207: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1208: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;

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

1204: IF l_notify_index IS NOT NULL THEN
1205: --update Global Picture directly
1206: -- Fix for the bug2635911
1207: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1208: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;

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

1205: --update Global Picture directly
1206: -- Fix for the bug2635911
1207: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1208: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;

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

1206: -- Fix for the bug2635911
1207: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1208: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1214: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873

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

1207: -- OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(l_index);
1208: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1214: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1215: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;

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

1208: OE_ORDER_UTIL.g_old_line_tbl(l_notify_index) := l_old_line_tbl(1);
1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1214: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1215: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1216: ELSE

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

1209: OE_ORDER_UTIL.g_line_tbl(l_notify_index) := OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
1210: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id := p_line_tbl(l_index).line_id;
1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1214: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1215: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1216: ELSE
1217: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873

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

1211: OE_ORDER_UTIL.g_line_tbl(l_notify_index).header_id := p_line_tbl(l_index).header_id;
1212: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_flag := p_line_tbl(l_index).fulfilled_flag;
1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1214: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1215: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1216: ELSE
1217: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;

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

1213: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity := p_line_tbl(l_index).fulfilled_quantity;
1214: IF p_line_tbl(l_index).fulfilled_quantity2 = 0 then -- 5126873
1215: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1216: ELSE
1217: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637

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

1215: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := NULL;
1216: ELSE
1217: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;

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

1216: ELSE
1217: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;

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

1217: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfilled_quantity2 := p_line_tbl(l_index).fulfilled_quantity2; -- 5126873
1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1225: -- Changes for AFD

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

1218: END IF;
1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1225: -- Changes for AFD
1226: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;

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

1219: OE_ORDER_UTIL.g_line_tbl(l_notify_index).fulfillment_date := p_line_tbl(l_index).fulfillment_date;
1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1225: -- Changes for AFD
1226: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1227: -- end Changes for AFD

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

1220: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_date := SYSDATE;
1221: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_updated_by := l_user; -- 3169637
1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1225: -- Changes for AFD
1226: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1227: -- end Changes for AFD
1228: IF l_debug_level > 0 THEN

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

1222: OE_ORDER_UTIL.g_line_tbl(l_notify_index).last_update_login :=FND_GLOBAL.LOGIN_ID;
1223: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_start_date :=l_line_rec.service_start_date;
1224: OE_ORDER_UTIL.g_line_tbl(l_notify_index).service_end_date := l_line_rec.service_end_date;
1225: -- Changes for AFD
1226: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1227: -- end Changes for AFD
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add('Line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1);
1230: END IF;

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

1225: -- Changes for AFD
1226: OE_ORDER_UTIL.g_line_tbl(l_notify_index).actual_fulfillment_date := l_actual_fulfillment_date;
1227: -- end Changes for AFD
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add('Line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).FULFILLED_FLAG,1);
1230: END IF;
1231: END IF;
1232: END IF; --code_release_level
1233: -- notification framework end

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

2283: -- check code release level first.
2284: -- Notification framework is at Pack H level
2285: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2286: -- calling notification framework to get index position
2287: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
2288: p_header_id=>l_line_tbl(1).header_id,
2289: p_old_line_rec => l_old_line_tbl(1),
2290: p_line_rec =>l_line_tbl(1),
2291: p_line_id =>l_line_tbl(1).line_id ,

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

2301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2302: END IF;
2303: IF l_index IS NOT NULL THEN
2304: --update Global Picture directly
2305: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2306: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;

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

2302: END IF;
2303: IF l_index IS NOT NULL THEN
2304: --update Global Picture directly
2305: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2306: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;

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

2303: IF l_index IS NOT NULL THEN
2304: --update Global Picture directly
2305: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2306: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;

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

2304: --update Global Picture directly
2305: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2306: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2312: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;

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

2305: OE_ORDER_UTIL.g_old_line_tbl(l_index) := l_old_line_tbl(1);
2306: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2312: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2313: -- Changes for AFD

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

2306: OE_ORDER_UTIL.g_line_tbl(l_index) := OE_ORDER_UTIL.g_old_line_tbl(l_index);
2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2312: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2313: -- Changes for AFD
2314: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;

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

2307: OE_ORDER_UTIL.g_line_tbl(l_index).header_id:= l_line_tbl(1).header_id;
2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2312: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2313: -- Changes for AFD
2314: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2315: -- end Changes for AFD

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

2308: OE_ORDER_UTIL.g_line_tbl(l_index).line_id:= l_line_tbl(1).line_id;
2309: OE_ORDER_UTIL.g_line_tbl(l_index).last_update_date:= l_line_tbl(1).last_update_date;
2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2312: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2313: -- Changes for AFD
2314: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2315: -- end Changes for AFD
2316: IF l_debug_level > 0 THEN

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

2310: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_flag := l_line_tbl(1).fulfilled_flag;
2311: OE_ORDER_UTIL.g_line_tbl(l_index).fulfilled_quantity := l_line_tbl(1).fulfilled_quantity;
2312: OE_ORDER_UTIL.g_line_tbl(l_index).fulfillment_date := l_line_tbl(1).fulfillment_date;
2313: -- Changes for AFD
2314: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2315: -- end Changes for AFD
2316: IF l_debug_level > 0 THEN
2317: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(l_index).fulfilled_flag,1) ;
2318: END IF;

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

2313: -- Changes for AFD
2314: OE_ORDER_UTIL.g_line_tbl(l_index).actual_fulfillment_date := l_line_tbl(1).actual_fulfillment_date;
2315: -- end Changes for AFD
2316: IF l_debug_level > 0 THEN
2317: oe_debug_pub.add('global line fulfilled_flag is: '||OE_ORDER_UTIL.G_LINE_TBL(l_index).fulfilled_flag,1) ;
2318: END IF;
2319: END IF;
2320:
2321: