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.WMS_WAVE_PLANNING_PVT dependencies on FND_GLOBAL

Line 70: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;

66: l_net_value num_tab;
67:
68: TYPE psrTabTyp IS TABLE OF psrTyp INDEX BY BINARY_INTEGER;
69: --
70: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
71: -- PACKAGE CONSTANTS
72: --
73:
74: -- Indicate what attributes are used in Pick Sequence Rules

Line 724: set request_id = fnd_global.conc_request_id

720: p_carrier_id,
721: p_category_id);
722:
723: update wms_wp_wave_headers_vl
724: set request_id = fnd_global.conc_request_id
725: where wave_header_id = v_wave_header_id;
726:
727: --Call the Dynamic SQL
728: get_dynamic_sql(v_wave_header_id, p_org_id, x_return_status);

Line 737: parent_request_id := fnd_global.conc_request_id;

733:
734: if p_plan_wave = 'Y' then
735:
736: print_debug('Calling Plan Wave Concurrent program:', l_debug);
737: parent_request_id := fnd_global.conc_request_id;
738:
739:
740: -- Bug 12733479 change. Commenting out the following call.
741: --FND_CONC_GLOBAL.Set_Req_Globals(Conc_Status => 'PAUSED',

Line 1058: fnd_global.user_id,

1054: TABLE_NAME,
1055: ADVANCED_CRITERIA,
1056: CREATED_BY,
1057: CREATION_DATE,
1058: fnd_global.user_id,
1059: sysdate,
1060: fnd_global.login_id,
1061: ORGANIZATION_ID,
1062: PICK_SEQ_RULE_ID,

Line 1060: fnd_global.login_id,

1056: CREATED_BY,
1057: CREATION_DATE,
1058: fnd_global.user_id,
1059: sysdate,
1060: fnd_global.login_id,
1061: ORGANIZATION_ID,
1062: PICK_SEQ_RULE_ID,
1063: PICK_GROUPING_RULE_ID,
1064: TRIP_ID,

Line 1146: fnd_global.user_id,

1142: BRACKET_CLOSE)
1143: SELECT wms_wp_advanced_criteria_s.NEXTVAL,
1144: l_wave_header_id,
1145: SEQUENCE_NUMBER,
1146: fnd_global.user_id,
1147: sysdate,
1148: CREATED_BY,
1149: CREATION_DATE,
1150: fnd_global.login_id,

Line 1150: fnd_global.login_id,

1146: fnd_global.user_id,
1147: sysdate,
1148: CREATED_BY,
1149: CREATION_DATE,
1150: fnd_global.login_id,
1151: LOGICAL_OPERATOR_CODE,
1152: LOGICAL_OPERATOR_MEANING,
1153: BRACKET_OPEN,
1154: OBJECT_ID,

Line 2582: FND_GLOBAL.USER_ID,

2578: NULL,
2579: NULL,
2580: INV_Globals.G_TO_STATUS_PREAPPROVED,
2581: NULL,
2582: FND_GLOBAL.USER_ID,
2583: FND_GLOBAL.CONC_LOGIN_ID,
2584: SYSDATE,
2585: FND_GLOBAL.USER_ID,
2586: SYSDATE,

Line 2583: FND_GLOBAL.CONC_LOGIN_ID,

2579: NULL,
2580: INV_Globals.G_TO_STATUS_PREAPPROVED,
2581: NULL,
2582: FND_GLOBAL.USER_ID,
2583: FND_GLOBAL.CONC_LOGIN_ID,
2584: SYSDATE,
2585: FND_GLOBAL.USER_ID,
2586: SYSDATE,
2587: NULL,

Line 2585: FND_GLOBAL.USER_ID,

2581: NULL,
2582: FND_GLOBAL.USER_ID,
2583: FND_GLOBAL.CONC_LOGIN_ID,
2584: SYSDATE,
2585: FND_GLOBAL.USER_ID,
2586: SYSDATE,
2587: NULL,
2588: NULL,
2589: NULL,

Line 2786: g_mtrl_tbl(i).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2782: g_mtrl_tbl(i).TASK_ID := g_troline_table(i).task_id;
2783: g_mtrl_tbl(i).TRANSACTION_HEADER_ID := null;
2784: g_mtrl_tbl(i).LINE_STATUS := INV_Globals.G_TO_STATUS_PREAPPROVED;
2785: g_mtrl_tbl(i).STATUS_DATE := SYSDATE;
2786: g_mtrl_tbl(i).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2787: g_mtrl_tbl(i).LAST_UPDATE_LOGIN := FND_GLOBAL.CONC_LOGIN_ID;
2788: g_mtrl_tbl(i).LAST_UPDATE_DATE := SYSDATE;
2789: g_mtrl_tbl(i).CREATED_BY := FND_GLOBAL.USER_ID;
2790: g_mtrl_tbl(i).CREATION_DATE := SYSDATE;

Line 2787: g_mtrl_tbl(i).LAST_UPDATE_LOGIN := FND_GLOBAL.CONC_LOGIN_ID;

2783: g_mtrl_tbl(i).TRANSACTION_HEADER_ID := null;
2784: g_mtrl_tbl(i).LINE_STATUS := INV_Globals.G_TO_STATUS_PREAPPROVED;
2785: g_mtrl_tbl(i).STATUS_DATE := SYSDATE;
2786: g_mtrl_tbl(i).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2787: g_mtrl_tbl(i).LAST_UPDATE_LOGIN := FND_GLOBAL.CONC_LOGIN_ID;
2788: g_mtrl_tbl(i).LAST_UPDATE_DATE := SYSDATE;
2789: g_mtrl_tbl(i).CREATED_BY := FND_GLOBAL.USER_ID;
2790: g_mtrl_tbl(i).CREATION_DATE := SYSDATE;
2791: g_mtrl_tbl(i).REQUEST_ID := null;

Line 2789: g_mtrl_tbl(i).CREATED_BY := FND_GLOBAL.USER_ID;

2785: g_mtrl_tbl(i).STATUS_DATE := SYSDATE;
2786: g_mtrl_tbl(i).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2787: g_mtrl_tbl(i).LAST_UPDATE_LOGIN := FND_GLOBAL.CONC_LOGIN_ID;
2788: g_mtrl_tbl(i).LAST_UPDATE_DATE := SYSDATE;
2789: g_mtrl_tbl(i).CREATED_BY := FND_GLOBAL.USER_ID;
2790: g_mtrl_tbl(i).CREATION_DATE := SYSDATE;
2791: g_mtrl_tbl(i).REQUEST_ID := null;
2792: g_mtrl_tbl(i).PROGRAM_APPLICATION_ID := null;
2793: g_mtrl_tbl(i).PROGRAM_ID := null;

Line 8999: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;

8995:
8996: function check_min_equip_Capacity(l_mmtt_tbl in num_t)
8997: return boolean is
8998:
8999: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
9000: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),
9001: 0);
9002: g_bulk_fetch_limit NUMBER := 1000;
9003:

Line 10781: l_trohdr_rec.created_by := fnd_global.user_id;

10777:
10778: print_debug('Assigning Values to Header Record ----> ',
10779: l_debug);
10780:
10781: l_trohdr_rec.created_by := fnd_global.user_id;
10782: l_trohdr_rec.creation_date := sysdate;
10783: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
10784: l_trohdr_rec.last_updated_by := fnd_global.user_id;
10785: l_trohdr_rec.last_update_date := sysdate;

Line 10784: l_trohdr_rec.last_updated_by := fnd_global.user_id;

10780:
10781: l_trohdr_rec.created_by := fnd_global.user_id;
10782: l_trohdr_rec.creation_date := sysdate;
10783: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
10784: l_trohdr_rec.last_updated_by := fnd_global.user_id;
10785: l_trohdr_rec.last_update_date := sysdate;
10786: l_trohdr_rec.last_update_login := fnd_global.user_id;
10787: l_trohdr_rec.organization_id := p_organization_id; -- assigned inside the loop
10788: l_trohdr_rec.status_date := sysdate;

Line 10786: l_trohdr_rec.last_update_login := fnd_global.user_id;

10782: l_trohdr_rec.creation_date := sysdate;
10783: l_trohdr_rec.header_status := INV_Globals.g_to_status_preapproved;
10784: l_trohdr_rec.last_updated_by := fnd_global.user_id;
10785: l_trohdr_rec.last_update_date := sysdate;
10786: l_trohdr_rec.last_update_login := fnd_global.user_id;
10787: l_trohdr_rec.organization_id := p_organization_id; -- assigned inside the loop
10788: l_trohdr_rec.status_date := sysdate;
10789: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_PICK_WAVE;
10790: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;

Line 11429: print_debug('Concurrent Request Id' || fnd_global.conc_request_id,

11425: p_WAVE_NAME := p_wave_header_rec.WAVE_NAME || '-' ||
11426: p_wave_header_rec.WAVE_HEADER_ID;
11427:
11428: end if;
11429: print_debug('Concurrent Request Id' || fnd_global.conc_request_id,
11430: l_debug);
11431: insert into wms_wp_wave_headers_vl
11432: (WAVE_HEADER_ID,
11433: WAVE_NAME,

Line 11581: fnd_global.conc_request_id,

11577: p_wave_header_rec.CROSS_DOCK_CRITERIA,
11578: p_wave_header_rec.PICK_SUBINVENTORY,
11579: p_wave_header_rec.PLANNING_CRITERIA,
11580: p_wave_header_rec.PLANNING_CRITERIA_ID,
11581: fnd_global.conc_request_id,
11582: p_wave_header_rec.WAVE_FIRMED_FLAG);
11583:
11584: x_return_status := 'S';
11585: COMMIT;

Line 12375: fnd_global.user_id,

12371: (p_wave_header_id,
12372: WMS_WP_WAVE_LINES_S.NEXTVAL,
12373: 'OE',
12374: 'Created',
12375: fnd_global.user_id,
12376: sysdate,
12377: fnd_global.user_id,
12378: sysdate,
12379: fnd_global.login_id,

Line 12377: fnd_global.user_id,

12373: 'OE',
12374: 'Created',
12375: fnd_global.user_id,
12376: sysdate,
12377: fnd_global.user_id,
12378: sysdate,
12379: fnd_global.login_id,
12380: l_delivery_Detail_id_tb(i),
12381: l_organization_id_tb(i),

Line 12379: fnd_global.login_id,

12375: fnd_global.user_id,
12376: sysdate,
12377: fnd_global.user_id,
12378: sysdate,
12379: fnd_global.login_id,
12380: l_delivery_Detail_id_tb(i),
12381: l_organization_id_tb(i),
12382: inv_salesorder.get_salesorder_for_oeheader(l_source_header_id_tb(i)), --???????? Demand Source Header Id
12383: l_requested_quantity_uom_tb(i));--11775489 this column added

Line 16249: X_CONCURRENT_REQUEST_ID => fnd_global.conc_request_id,

16245: X_PACKED => null,
16246: X_STAGED => null,
16247: X_LOADED_TO_DOCK => null,
16248: X_SHIPPED => null,
16249: X_CONCURRENT_REQUEST_ID => fnd_global.conc_request_id,
16250: X_PROGRAM_ID => fnd_global.conc_program_id, --
16251: X_EXCEPTION_NAME => p_exception_name,
16252: X_CREATION_DATE => sysdate,
16253: X_CREATED_BY => fnd_global.user_id,

Line 16250: X_PROGRAM_ID => fnd_global.conc_program_id, --

16246: X_STAGED => null,
16247: X_LOADED_TO_DOCK => null,
16248: X_SHIPPED => null,
16249: X_CONCURRENT_REQUEST_ID => fnd_global.conc_request_id,
16250: X_PROGRAM_ID => fnd_global.conc_program_id, --
16251: X_EXCEPTION_NAME => p_exception_name,
16252: X_CREATION_DATE => sysdate,
16253: X_CREATED_BY => fnd_global.user_id,
16254: X_LAST_UPDATE_DATE => sysdate,

Line 16253: X_CREATED_BY => fnd_global.user_id,

16249: X_CONCURRENT_REQUEST_ID => fnd_global.conc_request_id,
16250: X_PROGRAM_ID => fnd_global.conc_program_id, --
16251: X_EXCEPTION_NAME => p_exception_name,
16252: X_CREATION_DATE => sysdate,
16253: X_CREATED_BY => fnd_global.user_id,
16254: X_LAST_UPDATE_DATE => sysdate,
16255: X_LAST_UPDATED_BY => fnd_global.user_id,
16256: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id);
16257:

Line 16255: X_LAST_UPDATED_BY => fnd_global.user_id,

16251: X_EXCEPTION_NAME => p_exception_name,
16252: X_CREATION_DATE => sysdate,
16253: X_CREATED_BY => fnd_global.user_id,
16254: X_LAST_UPDATE_DATE => sysdate,
16255: X_LAST_UPDATED_BY => fnd_global.user_id,
16256: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id);
16257:
16258: /* INSERT INTO wms_wp_wave_exceptions_vl
16259: (exception_id,

Line 16256: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id);

16252: X_CREATION_DATE => sysdate,
16253: X_CREATED_BY => fnd_global.user_id,
16254: X_LAST_UPDATE_DATE => sysdate,
16255: X_LAST_UPDATED_BY => fnd_global.user_id,
16256: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id);
16257:
16258: /* INSERT INTO wms_wp_wave_exceptions_vl
16259: (exception_id,
16260: exception_name,

Line 16291: fnd_global.conc_request_id,

16287: p_delivery_id,
16288: p_order_number,
16289: p_order_line_id,
16290: 'Active',
16291: fnd_global.conc_request_id,
16292: fnd_global.conc_program_id,
16293: fnd_global.user_id,
16294: sysdate,
16295: sysdate,

Line 16292: fnd_global.conc_program_id,

16288: p_order_number,
16289: p_order_line_id,
16290: 'Active',
16291: fnd_global.conc_request_id,
16292: fnd_global.conc_program_id,
16293: fnd_global.user_id,
16294: sysdate,
16295: sysdate,
16296: fnd_global.user_id,

Line 16293: fnd_global.user_id,

16289: p_order_line_id,
16290: 'Active',
16291: fnd_global.conc_request_id,
16292: fnd_global.conc_program_id,
16293: fnd_global.user_id,
16294: sysdate,
16295: sysdate,
16296: fnd_global.user_id,
16297: fnd_global.conc_login_id);*/

Line 16296: fnd_global.user_id,

16292: fnd_global.conc_program_id,
16293: fnd_global.user_id,
16294: sysdate,
16295: sysdate,
16296: fnd_global.user_id,
16297: fnd_global.conc_login_id);*/
16298:
16299: print_debug('exception id for current exception :=' ||
16300: l_seq_val, -- Changed

Line 16297: fnd_global.conc_login_id);*/

16293: fnd_global.user_id,
16294: sysdate,
16295: sysdate,
16296: fnd_global.user_id,
16297: fnd_global.conc_login_id);*/
16298:
16299: print_debug('exception id for current exception :=' ||
16300: l_seq_val, -- Changed
16301: l_debug);

Line 16321: AND concurrent_request_id != fnd_global.conc_request_id

16317: order_line_id IS NULL) OR
16318: (p_exception_entity = 'Order' AND order_number = p_order_number AND
16319: order_line_id IS NULL) OR (p_exception_entity = 'Order Line' AND
16320: order_line_id = p_order_line_id))
16321: AND concurrent_request_id != fnd_global.conc_request_id
16322: AND exception_id != (l_currval);
16323:
16324: COMMIT; */
16325:

Line 16363: WHERE concurrent_request_id = fnd_global.conc_request_id

16359: print_debug('In check_so procedure', l_debug);
16360: SELECT exception_id, delivery_id, trip_id
16361: INTO l_exception_id, l_previous_delivery, l_previous_trip
16362: FROM wms_wp_wave_exceptions_vl
16363: WHERE concurrent_request_id = fnd_global.conc_request_id
16364: AND order_number = p_current_order;
16365:
16366: print_debug('exception_id fetched =' || l_exception_id, l_debug);
16367:

Line 16382: last_update_login = fnd_global.conc_login_id,

16378: nvl(l_previous_delivery, -999) <> nvl(p_current_delivery, -999)) THEN
16379:
16380: update wms_wp_wave_exceptions_b
16381: set delivery_id = null,
16382: last_update_login = fnd_global.conc_login_id,
16383: last_updated_by = fnd_global.user_id,
16384: last_update_date = l_date
16385: where exception_id = l_exception_id;
16386:

Line 16383: last_updated_by = fnd_global.user_id,

16379:
16380: update wms_wp_wave_exceptions_b
16381: set delivery_id = null,
16382: last_update_login = fnd_global.conc_login_id,
16383: last_updated_by = fnd_global.user_id,
16384: last_update_date = l_date
16385: where exception_id = l_exception_id;
16386:
16387: update WMS_WP_WAVE_EXCEPTIONS_TL

Line 16389: LAST_UPDATED_BY = fnd_global.user_id,

16385: where exception_id = l_exception_id;
16386:
16387: update WMS_WP_WAVE_EXCEPTIONS_TL
16388: set LAST_UPDATE_DATE = l_date,
16389: LAST_UPDATED_BY = fnd_global.user_id,
16390: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16391: SOURCE_LANG = userenv('LANG')
16392: where EXCEPTION_ID = l_exception_id
16393: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16390: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16386:
16387: update WMS_WP_WAVE_EXCEPTIONS_TL
16388: set LAST_UPDATE_DATE = l_date,
16389: LAST_UPDATED_BY = fnd_global.user_id,
16390: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16391: SOURCE_LANG = userenv('LANG')
16392: where EXCEPTION_ID = l_exception_id
16393: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16394:

Line 16406: last_update_login = fnd_global.conc_login_id,

16402:
16403: update wms_wp_wave_exceptions_b
16404: set trip_id = null,
16405: delivery_id = null,
16406: last_update_login = fnd_global.conc_login_id,
16407: last_updated_by = fnd_global.user_id,
16408: last_update_date = l_date
16409: where exception_id = l_exception_id;
16410:

Line 16407: last_updated_by = fnd_global.user_id,

16403: update wms_wp_wave_exceptions_b
16404: set trip_id = null,
16405: delivery_id = null,
16406: last_update_login = fnd_global.conc_login_id,
16407: last_updated_by = fnd_global.user_id,
16408: last_update_date = l_date
16409: where exception_id = l_exception_id;
16410:
16411: update WMS_WP_WAVE_EXCEPTIONS_TL

Line 16413: LAST_UPDATED_BY = fnd_global.user_id,

16409: where exception_id = l_exception_id;
16410:
16411: update WMS_WP_WAVE_EXCEPTIONS_TL
16412: set LAST_UPDATE_DATE = l_date,
16413: LAST_UPDATED_BY = fnd_global.user_id,
16414: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16415: SOURCE_LANG = userenv('LANG')
16416: where EXCEPTION_ID = l_exception_id
16417: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16414: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16410:
16411: update WMS_WP_WAVE_EXCEPTIONS_TL
16412: set LAST_UPDATE_DATE = l_date,
16413: LAST_UPDATED_BY = fnd_global.user_id,
16414: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16415: SOURCE_LANG = userenv('LANG')
16416: where EXCEPTION_ID = l_exception_id
16417: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16418: /*

Line 16466: WHERE concurrent_request_id = fnd_global.conc_request_id

16462: print_debug('In check_line procedure', l_debug);
16463: SELECT exception_id, delivery_id, trip_id
16464: INTO l_exception_id, l_previous_delivery, l_previous_trip
16465: FROM wms_wp_wave_exceptions_vl
16466: WHERE concurrent_request_id = fnd_global.conc_request_id
16467: AND ORDER_LINE_ID = p_current_line;
16468:
16469: print_debug('exception_id fetched =' || l_exception_id, l_debug);
16470:

Line 16480: last_update_login = fnd_global.conc_login_id,

16476: nvl(l_previous_delivery, -999) <> nvl(p_current_delivery, -999)) THEN
16477:
16478: update wms_wp_wave_exceptions_b
16479: set delivery_id = null,
16480: last_update_login = fnd_global.conc_login_id,
16481: last_updated_by = fnd_global.user_id,
16482: last_update_date = l_date
16483: where exception_id = l_exception_id;
16484:

Line 16481: last_updated_by = fnd_global.user_id,

16477:
16478: update wms_wp_wave_exceptions_b
16479: set delivery_id = null,
16480: last_update_login = fnd_global.conc_login_id,
16481: last_updated_by = fnd_global.user_id,
16482: last_update_date = l_date
16483: where exception_id = l_exception_id;
16484:
16485: update WMS_WP_WAVE_EXCEPTIONS_TL

Line 16487: LAST_UPDATED_BY = fnd_global.user_id,

16483: where exception_id = l_exception_id;
16484:
16485: update WMS_WP_WAVE_EXCEPTIONS_TL
16486: set LAST_UPDATE_DATE = l_date,
16487: LAST_UPDATED_BY = fnd_global.user_id,
16488: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16489: SOURCE_LANG = userenv('LANG')
16490: where EXCEPTION_ID = l_exception_id
16491: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16488: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16484:
16485: update WMS_WP_WAVE_EXCEPTIONS_TL
16486: set LAST_UPDATE_DATE = l_date,
16487: LAST_UPDATED_BY = fnd_global.user_id,
16488: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16489: SOURCE_LANG = userenv('LANG')
16490: where EXCEPTION_ID = l_exception_id
16491: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16492:

Line 16500: last_update_login = fnd_global.conc_login_id,

16496:
16497: update wms_wp_wave_exceptions_b
16498: set trip_id = null,
16499: delivery_id = null,
16500: last_update_login = fnd_global.conc_login_id,
16501: last_updated_by = fnd_global.user_id,
16502: last_update_date = l_date
16503: where exception_id = l_exception_id;
16504:

Line 16501: last_updated_by = fnd_global.user_id,

16497: update wms_wp_wave_exceptions_b
16498: set trip_id = null,
16499: delivery_id = null,
16500: last_update_login = fnd_global.conc_login_id,
16501: last_updated_by = fnd_global.user_id,
16502: last_update_date = l_date
16503: where exception_id = l_exception_id;
16504:
16505: update WMS_WP_WAVE_EXCEPTIONS_TL

Line 16507: LAST_UPDATED_BY = fnd_global.user_id,

16503: where exception_id = l_exception_id;
16504:
16505: update WMS_WP_WAVE_EXCEPTIONS_TL
16506: set LAST_UPDATE_DATE = l_date,
16507: LAST_UPDATED_BY = fnd_global.user_id,
16508: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16509: SOURCE_LANG = userenv('LANG')
16510: where EXCEPTION_ID = l_exception_id
16511: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16508: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16504:
16505: update WMS_WP_WAVE_EXCEPTIONS_TL
16506: set LAST_UPDATE_DATE = l_date,
16507: LAST_UPDATED_BY = fnd_global.user_id,
16508: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16509: SOURCE_LANG = userenv('LANG')
16510: where EXCEPTION_ID = l_exception_id
16511: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16512:

Line 16724: concurrent_request_id = fnd_global.conc_request_id,

16720: packed = l_packed,
16721: staged = l_staged,
16722: loaded_to_dock = l_loadedtodock,
16723: shipped = l_shipped,
16724: concurrent_request_id = fnd_global.conc_request_id,
16725: program_id = fnd_global.conc_program_id,
16726: last_updated_by = fnd_global.user_id,
16727: last_update_login = fnd_global.conc_login_id,
16728: last_update_date = SYSDATE

Line 16725: program_id = fnd_global.conc_program_id,

16721: staged = l_staged,
16722: loaded_to_dock = l_loadedtodock,
16723: shipped = l_shipped,
16724: concurrent_request_id = fnd_global.conc_request_id,
16725: program_id = fnd_global.conc_program_id,
16726: last_updated_by = fnd_global.user_id,
16727: last_update_login = fnd_global.conc_login_id,
16728: last_update_date = SYSDATE
16729:

Line 16726: last_updated_by = fnd_global.user_id,

16722: loaded_to_dock = l_loadedtodock,
16723: shipped = l_shipped,
16724: concurrent_request_id = fnd_global.conc_request_id,
16725: program_id = fnd_global.conc_program_id,
16726: last_updated_by = fnd_global.user_id,
16727: last_update_login = fnd_global.conc_login_id,
16728: last_update_date = SYSDATE
16729:
16730: WHERE exception_id = p_exception_id;

Line 16727: last_update_login = fnd_global.conc_login_id,

16723: shipped = l_shipped,
16724: concurrent_request_id = fnd_global.conc_request_id,
16725: program_id = fnd_global.conc_program_id,
16726: last_updated_by = fnd_global.user_id,
16727: last_update_login = fnd_global.conc_login_id,
16728: last_update_date = SYSDATE
16729:
16730: WHERE exception_id = p_exception_id;
16731:

Line 16734: LAST_UPDATED_BY = fnd_global.user_id,

16730: WHERE exception_id = p_exception_id;
16731:
16732: update WMS_WP_WAVE_EXCEPTIONS_TL
16733: set LAST_UPDATE_DATE = SYSDATE,
16734: LAST_UPDATED_BY = fnd_global.user_id,
16735: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16736: SOURCE_LANG = userenv('LANG')
16737: where EXCEPTION_ID = p_exception_id
16738: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16735: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16731:
16732: update WMS_WP_WAVE_EXCEPTIONS_TL
16733: set LAST_UPDATE_DATE = SYSDATE,
16734: LAST_UPDATED_BY = fnd_global.user_id,
16735: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16736: SOURCE_LANG = userenv('LANG')
16737: where EXCEPTION_ID = p_exception_id
16738: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16739:

Line 16783: last_updated_by = fnd_global.user_id,

16779:
16780: UPDATE wms_wp_wave_exceptions_b
16781: SET status = 'Closed',
16782: last_update_date = sysdate,
16783: last_updated_by = fnd_global.user_id,
16784: last_update_login = fnd_global.login_id
16785: WHERE exception_id = p_exception_id;
16786:
16787: update WMS_WP_WAVE_EXCEPTIONS_TL

Line 16784: last_update_login = fnd_global.login_id

16780: UPDATE wms_wp_wave_exceptions_b
16781: SET status = 'Closed',
16782: last_update_date = sysdate,
16783: last_updated_by = fnd_global.user_id,
16784: last_update_login = fnd_global.login_id
16785: WHERE exception_id = p_exception_id;
16786:
16787: update WMS_WP_WAVE_EXCEPTIONS_TL
16788: set LAST_UPDATE_DATE = SYSDATE,

Line 16789: LAST_UPDATED_BY = fnd_global.user_id,

16785: WHERE exception_id = p_exception_id;
16786:
16787: update WMS_WP_WAVE_EXCEPTIONS_TL
16788: set LAST_UPDATE_DATE = SYSDATE,
16789: LAST_UPDATED_BY = fnd_global.user_id,
16790: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16791: SOURCE_LANG = userenv('LANG')
16792: where EXCEPTION_ID = p_exception_id
16793: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16790: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16786:
16787: update WMS_WP_WAVE_EXCEPTIONS_TL
16788: set LAST_UPDATE_DATE = SYSDATE,
16789: LAST_UPDATED_BY = fnd_global.user_id,
16790: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16791: SOURCE_LANG = userenv('LANG')
16792: where EXCEPTION_ID = p_exception_id
16793: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16794:

Line 16906: concurrent_request_id = fnd_global.conc_request_id,

16902: packed = l_packed,
16903: staged = l_staged,
16904: loaded_to_dock = l_loadedtodock,
16905: shipped = l_shipped,
16906: concurrent_request_id = fnd_global.conc_request_id,
16907: program_id = fnd_global.conc_program_id,
16908: last_update_date = sysdate,
16909: last_updated_by = fnd_global.user_id,
16910: last_update_login = fnd_global.conc_login_id

Line 16907: program_id = fnd_global.conc_program_id,

16903: staged = l_staged,
16904: loaded_to_dock = l_loadedtodock,
16905: shipped = l_shipped,
16906: concurrent_request_id = fnd_global.conc_request_id,
16907: program_id = fnd_global.conc_program_id,
16908: last_update_date = sysdate,
16909: last_updated_by = fnd_global.user_id,
16910: last_update_login = fnd_global.conc_login_id
16911: WHERE exception_id = l_update_exception_id;

Line 16909: last_updated_by = fnd_global.user_id,

16905: shipped = l_shipped,
16906: concurrent_request_id = fnd_global.conc_request_id,
16907: program_id = fnd_global.conc_program_id,
16908: last_update_date = sysdate,
16909: last_updated_by = fnd_global.user_id,
16910: last_update_login = fnd_global.conc_login_id
16911: WHERE exception_id = l_update_exception_id;
16912:
16913: update WMS_WP_WAVE_EXCEPTIONS_TL

Line 16910: last_update_login = fnd_global.conc_login_id

16906: concurrent_request_id = fnd_global.conc_request_id,
16907: program_id = fnd_global.conc_program_id,
16908: last_update_date = sysdate,
16909: last_updated_by = fnd_global.user_id,
16910: last_update_login = fnd_global.conc_login_id
16911: WHERE exception_id = l_update_exception_id;
16912:
16913: update WMS_WP_WAVE_EXCEPTIONS_TL
16914: set LAST_UPDATE_DATE = SYSDATE,

Line 16915: LAST_UPDATED_BY = fnd_global.user_id,

16911: WHERE exception_id = l_update_exception_id;
16912:
16913: update WMS_WP_WAVE_EXCEPTIONS_TL
16914: set LAST_UPDATE_DATE = SYSDATE,
16915: LAST_UPDATED_BY = fnd_global.user_id,
16916: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16917: SOURCE_LANG = userenv('LANG')
16918: where EXCEPTION_ID = l_update_exception_id
16919: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 16916: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

16912:
16913: update WMS_WP_WAVE_EXCEPTIONS_TL
16914: set LAST_UPDATE_DATE = SYSDATE,
16915: LAST_UPDATED_BY = fnd_global.user_id,
16916: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
16917: SOURCE_LANG = userenv('LANG')
16918: where EXCEPTION_ID = l_update_exception_id
16919: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
16920:

Line 17317: print_DEBUG('p_user_id => ' || fnd_global.user_id, l_debug);

17313: IF l_updated_record > 0 then
17314: print_DEBUG('Calling wms_waveplan_tasks_pvt.save_tasks ', l_debug);
17315: print_DEBUG('Input Parameters passed', l_debug);
17316: print_DEBUG('p_commit => TRUE', l_debug);
17317: print_DEBUG('p_user_id => ' || fnd_global.user_id, l_debug);
17318: print_DEBUG('p_login_id => ' || fnd_global.login_id, l_debug);
17319:
17320: save_tasks(p_commit => TRUE,
17321: p_user_id => fnd_global.user_id,

Line 17318: print_DEBUG('p_login_id => ' || fnd_global.login_id, l_debug);

17314: print_DEBUG('Calling wms_waveplan_tasks_pvt.save_tasks ', l_debug);
17315: print_DEBUG('Input Parameters passed', l_debug);
17316: print_DEBUG('p_commit => TRUE', l_debug);
17317: print_DEBUG('p_user_id => ' || fnd_global.user_id, l_debug);
17318: print_DEBUG('p_login_id => ' || fnd_global.login_id, l_debug);
17319:
17320: save_tasks(p_commit => TRUE,
17321: p_user_id => fnd_global.user_id,
17322: p_login_id => fnd_global.login_id,

Line 17321: p_user_id => fnd_global.user_id,

17317: print_DEBUG('p_user_id => ' || fnd_global.user_id, l_debug);
17318: print_DEBUG('p_login_id => ' || fnd_global.login_id, l_debug);
17319:
17320: save_tasks(p_commit => TRUE,
17321: p_user_id => fnd_global.user_id,
17322: p_login_id => fnd_global.login_id,
17323: x_save_count => l_save_count,
17324: x_return_status => l_return_status,
17325: x_msg_data => l_msg_data,

Line 17322: p_login_id => fnd_global.login_id,

17318: print_DEBUG('p_login_id => ' || fnd_global.login_id, l_debug);
17319:
17320: save_tasks(p_commit => TRUE,
17321: p_user_id => fnd_global.user_id,
17322: p_login_id => fnd_global.login_id,
17323: x_save_count => l_save_count,
17324: x_return_status => l_return_status,
17325: x_msg_data => l_msg_data,
17326: x_msg_count => l_msg_count);

Line 17562: LAST_UPDATED_BY = fnd_global.user_id,

17558: WHERE exception_id = p_exception_id;
17559:
17560: update WMS_WP_WAVE_EXCEPTIONS_TL
17561: set LAST_UPDATE_DATE = SYSDATE,
17562: LAST_UPDATED_BY = fnd_global.user_id,
17563: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
17564: SOURCE_LANG = userenv('LANG')
17565: where EXCEPTION_ID = p_exception_id
17566: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 17563: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,

17559:
17560: update WMS_WP_WAVE_EXCEPTIONS_TL
17561: set LAST_UPDATE_DATE = SYSDATE,
17562: LAST_UPDATED_BY = fnd_global.user_id,
17563: LAST_UPDATE_LOGIN = fnd_global.conc_login_id,
17564: SOURCE_LANG = userenv('LANG')
17565: where EXCEPTION_ID = p_exception_id
17566: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
17567:

Line 19542: fnd_global.user_id,

19538: 'N',
19539: P_RELEASE_IMMEDIATELY,
19540: null,
19541: null,
19542: fnd_global.user_id,
19543: sysdate,
19544: fnd_global.user_id,
19545: sysdate,
19546: fnd_global.login_id,

Line 19544: fnd_global.user_id,

19540: null,
19541: null,
19542: fnd_global.user_id,
19543: sysdate,
19544: fnd_global.user_id,
19545: sysdate,
19546: fnd_global.login_id,
19547: P_ORGANIZATION_ID,
19548: P_PICK_SEQ_RULE_ID,

Line 19546: fnd_global.login_id,

19542: fnd_global.user_id,
19543: sysdate,
19544: fnd_global.user_id,
19545: sysdate,
19546: fnd_global.login_id,
19547: P_ORGANIZATION_ID,
19548: P_PICK_SEQ_RULE_ID,
19549: P_PICK_GROUPING_RULE_ID,
19550: P_TRIP_ID,