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.ENG_ECO_REVISION_UTIL dependencies on ENG_GLOBALS

Line 152: l_user_id := Eng_Globals.Get_User_Id;

148:
149: BEGIN
150:
151:
152: l_user_id := Eng_Globals.Get_User_Id;
153: l_login_id := Eng_Globals.Get_Login_Id;
154: l_request_id := ENG_GLOBALS.Get_request_id;
155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
156: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 153: l_login_id := Eng_Globals.Get_Login_Id;

149: BEGIN
150:
151:
152: l_user_id := Eng_Globals.Get_User_Id;
153: l_login_id := Eng_Globals.Get_Login_Id;
154: l_request_id := ENG_GLOBALS.Get_request_id;
155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
156: l_prog_id := ENG_GLOBALS.Get_prog_id;
157:

Line 154: l_request_id := ENG_GLOBALS.Get_request_id;

150:
151:
152: l_user_id := Eng_Globals.Get_User_Id;
153: l_login_id := Eng_Globals.Get_Login_Id;
154: l_request_id := ENG_GLOBALS.Get_request_id;
155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
156: l_prog_id := ENG_GLOBALS.Get_prog_id;
157:
158: UPDATE ENG_CHANGE_ORDER_REVISIONS

Line 155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

151:
152: l_user_id := Eng_Globals.Get_User_Id;
153: l_login_id := Eng_Globals.Get_Login_Id;
154: l_request_id := ENG_GLOBALS.Get_request_id;
155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
156: l_prog_id := ENG_GLOBALS.Get_prog_id;
157:
158: UPDATE ENG_CHANGE_ORDER_REVISIONS
159: SET REVISION = DECODE

Line 156: l_prog_id := ENG_GLOBALS.Get_prog_id;

152: l_user_id := Eng_Globals.Get_User_Id;
153: l_login_id := Eng_Globals.Get_Login_Id;
154: l_request_id := ENG_GLOBALS.Get_request_id;
155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
156: l_prog_id := ENG_GLOBALS.Get_prog_id;
157:
158: UPDATE ENG_CHANGE_ORDER_REVISIONS
159: SET REVISION = DECODE
160: ( p_eco_revision_rec.new_revision, NULL,

Line 255: l_user_id := Eng_Globals.Get_User_Id;

251: l_priority_code eng_engineering_changes.priority_code%TYPE; -- Bug 3665542
252:
253: BEGIN
254:
255: l_user_id := Eng_Globals.Get_User_Id;
256: l_login_id := Eng_Globals.Get_Login_Id;
257: l_request_id := ENG_GLOBALS.Get_request_id;
258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
259: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 256: l_login_id := Eng_Globals.Get_Login_Id;

252:
253: BEGIN
254:
255: l_user_id := Eng_Globals.Get_User_Id;
256: l_login_id := Eng_Globals.Get_Login_Id;
257: l_request_id := ENG_GLOBALS.Get_request_id;
258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
259: l_prog_id := ENG_GLOBALS.Get_prog_id;
260:

Line 257: l_request_id := ENG_GLOBALS.Get_request_id;

253: BEGIN
254:
255: l_user_id := Eng_Globals.Get_User_Id;
256: l_login_id := Eng_Globals.Get_Login_Id;
257: l_request_id := ENG_GLOBALS.Get_request_id;
258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
259: l_prog_id := ENG_GLOBALS.Get_prog_id;
260:
261:

Line 258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

254:
255: l_user_id := Eng_Globals.Get_User_Id;
256: l_login_id := Eng_Globals.Get_Login_Id;
257: l_request_id := ENG_GLOBALS.Get_request_id;
258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
259: l_prog_id := ENG_GLOBALS.Get_prog_id;
260:
261:
262: INSERT INTO ENG_CHANGE_ORDER_REVISIONS

Line 259: l_prog_id := ENG_GLOBALS.Get_prog_id;

255: l_user_id := Eng_Globals.Get_User_Id;
256: l_login_id := Eng_Globals.Get_Login_Id;
257: l_request_id := ENG_GLOBALS.Get_request_id;
258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
259: l_prog_id := ENG_GLOBALS.Get_prog_id;
260:
261:
262: INSERT INTO ENG_CHANGE_ORDER_REVISIONS
263: ( REVISION_ID

Line 342: if ENG_GLOBALS.G_ENG_LAUNCH_IMPORT = 1 then --this should'nt be done for propagation

338: SET approval_status_type = 1
339: WHERE change_id = p_Eco_Rev_Unexp_Rec.change_id;
340: end of Bug no:3047312 */
341: /* Bug no:3047312*/
342: if ENG_GLOBALS.G_ENG_LAUNCH_IMPORT = 1 then --this should'nt be done for propagation
343: l_chk_co_app := ret_app_status ( p_Eco_Rev_Unexp_Rec.change_id,l_change_order_type_id,l_route_id, l_priority_code);
344: if l_route_id is null then
345: l_process := ret_pro_name (l_change_order_type_id, l_priority_code );
346: end if;

Line 534: x_Return_Status := Eng_Globals.G_RECORD_FOUND;

530: WHERE REVISION = p_revision
531: AND CHANGE_NOTICE = p_Change_Notice
532: AND ORGANIZATION_ID = p_Organization_Id;
533:
534: x_Return_Status := Eng_Globals.G_RECORD_FOUND;
535:
536: EXCEPTION
537:
538: WHEN NO_DATA_FOUND THEN

Line 539: x_Return_Status := Eng_Globals.G_RECORD_NOT_FOUND;

535:
536: EXCEPTION
537:
538: WHEN NO_DATA_FOUND THEN
539: x_Return_Status := Eng_Globals.G_RECORD_NOT_FOUND;
540: WHEN OTHERS THEN
541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
542:
543: END Query_Row;

Line 571: IF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_CREATE

567: l_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: G_CONTROL_REC := p_control_rec;
570:
571: IF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_CREATE
572: THEN
573: Insert_Row
574: ( p_eco_revision_rec => p_eco_revision_rec
575: , p_eco_rev_unexp_rec => p_eco_rev_unexp_rec

Line 579: ELSIF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_UPDATE

575: , p_eco_rev_unexp_rec => p_eco_rev_unexp_rec
576: , x_mesg_token_tbl => l_mesg_token_tbl
577: , x_return_status => l_return_status
578: );
579: ELSIF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_UPDATE
580: THEN
581: Update_Row
582: ( p_eco_revision_rec => p_eco_revision_rec
583: , p_eco_rev_unexp_rec => p_eco_rev_unexp_rec

Line 588: ELSIF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_DELETE

584: , x_mesg_token_tbl => l_mesg_token_tbl
585: , x_return_status => l_return_status
586: );
587:
588: ELSIF p_eco_revision_rec.transaction_type = Eng_Globals.G_OPR_DELETE
589: THEN
590: Delete_Row
591: ( p_revision_id => p_eco_rev_unexp_rec.revision_id
592: , x_mesg_token_tbl => l_mesg_token_tbl

Line 849: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC

845: -- Row has changed by another user.
846:
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
849: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
850: , p_msg_name => 'OE_LOCK_ROW_CHANGED'
851: , x_err_text => x_err_text );
852: END IF;
853:

Line 860: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC

856: WHEN NO_DATA_FOUND THEN
857:
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
860: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
861: , p_msg_name => 'OE_LOCK_ROW_DELETED'
862: , x_err_text => x_err_text );
863:
864: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 868: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC

864: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
865:
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: x_eco_revision_rec.return_status := FND_API.G_RET_STS_ERROR;
868: Eng_Eco_Pub.Log_Error( p_who_rec => ENG_GLOBALS.G_WHO_REC
869: , p_msg_name => 'OE_LOCK_ROW_ALREADY_LOCKED'
870: , x_err_text => x_err_text );
871: WHEN OTHERS THEN
872: