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.AMW_LOAD_CONSTRAINT_DATA dependencies on AMW_CONSTRAINTS_B

Line 418: -- insert new constraint into AMW_CONSTRAINTS_B/_TL

414: -- =============================================================================
415: -- Procedure name
416: -- insert_constraint
417: -- Purpose
418: -- insert new constraint into AMW_CONSTRAINTS_B/_TL
419: -- History
420: -- 09.13.2005 tsho: consider classification, objective of constraint
421: -- 19.04.2006 PSOMANAT: Default Objective_code = 'DT'
422: -- Default Classification to the seeded Constraint Classification

Line 535: -- update existing constraint in AMW_CONSTRAINTS_B/_TL

531: -- ===============================================================
532: -- Procedure name
533: -- update_constraint
534: -- Purpose
535: -- update existing constraint in AMW_CONSTRAINTS_B/_TL
536: -- History
537: -- 09.13.2005 tsho: consider classification, objective of constraint
538: -- ===============================================================
539: PROCEDURE update_constraint(

Line 568: FROM amw_constraints_b

564: FROM dual;
565:
566: CURSOR c_classification(c_cst_rev_id number) IS
567: SELECT classification
568: FROM amw_constraints_b
569: WHERE constraint_rev_id=c_cst_rev_id;
570:
571: CURSOR c_objective_code(c_cst_rev_id number) IS
572: SELECT objective_code

Line 573: FROM amw_constraints_b

569: WHERE constraint_rev_id=c_cst_rev_id;
570:
571: CURSOR c_objective_code(c_cst_rev_id number) IS
572: SELECT objective_code
573: FROM amw_constraints_b
574: WHERE constraint_rev_id=c_cst_rev_id;
575: BEGIN
576: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
577: OPEN c_constraint_rev_id;

Line 648: -- from interface table to AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL

644: -- Procedure name
645: -- create_constraints
646: -- Purpose
647: -- import constraints
648: -- from interface table to AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
649: -- Notes
650: -- this procedure is called in Concurrent Executable
651: -- History
652: -- 09.13.2005 tsho: consider group_code, object_type of constraint entries

Line 697: FROM amw_constraints_b b, amw_constraints_tl tl

693:
694: -- check if the constraint already existed
695: CURSOR c_constraint_exists (l_cst_name IN VARCHAR2) IS
696: SELECT b.constraint_id, b.constraint_rev_id, b.approval_status
697: FROM amw_constraints_b b, amw_constraints_tl tl
698: WHERE tl.name = l_cst_name
699: AND tl.language = USERENV('LANG')
700: AND tl.constraint_id = b.constraint_id;
701:

Line 842: -- use party_id as entered_by_id in AMW_CONSTRAINTS_B

838: --fnd_file.put_line (fnd_file.LOG, 'resp id: '||fnd_global.RESP_ID);
839: --fnd_file.put_line (fnd_file.LOG, 'resp appl id: '||fnd_global.RESP_APPL_ID);
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: -- use party_id as entered_by_id in AMW_CONSTRAINTS_B
843: l_entered_by_id := Get_Party_Id(p_user_id);
844: IF (l_entered_by_id is NULL) THEN
845: RAISE e_invalid_entered_by_id;
846: END IF;

Line 882: ,p_table_name => 'AMW_CONSTRAINTS_B'

878: END IF;
879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_check_inv_func*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
880: update_interface_with_error(
881: p_ERR_MSG => v_err_msg
882: ,p_table_name => 'AMW_CONSTRAINTS_B'
883: ,P_INTERFACE_ID => L_INTERFACE_ID);
884: EXCEPTION
885: WHEN OTHERS THEN
886: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

Line 915: ,p_table_name => 'AMW_CONSTRAINTS_B'

911: END IF;
912: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_check_inv_resp*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
913: update_interface_with_error(
914: p_ERR_MSG => v_err_msg
915: ,p_table_name => 'AMW_CONSTRAINTS_B'
916: ,P_INTERFACE_ID => L_INTERFACE_ID);
917: EXCEPTION
918: WHEN OTHERS THEN
919: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

Line 943: ,p_table_name => 'AMW_CONSTRAINTS_B'

939: v_err_msg := AMW_UTILITY_PVT.get_message_text('AMW_CONSTRAINT_UPL_INCONSIST');
940: FND_FILE.PUT_LINE(FND_FILE.LOG, 'c_chk_dup_csts*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
941: update_interface_with_error(
942: p_ERR_MSG => v_err_msg
943: ,p_table_name => 'AMW_CONSTRAINTS_B'
944: ,P_INTERFACE_ID => L_INTERFACE_ID);
945: EXCEPTION
946: WHEN OTHERS THEN
947: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

Line 969: ,p_table_name => 'AMW_CONSTRAINTS_B'

965: v_err_msg := 'Concurrent Program ID is not unique. Please create this constraint from Self-Service UI.';
966: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
967: update_interface_with_error(
968: p_ERR_MSG => v_err_msg
969: ,p_table_name => 'AMW_CONSTRAINTS_B'
970: ,P_INTERFACE_ID => L_INTERFACE_ID);
971: EXCEPTION
972: WHEN OTHERS THEN
973: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);

Line 995: ,p_table_name => 'AMW_CONSTRAINTS_B'

991: v_err_msg := 'Responsibility ID is not unique. Please create this constraint from Self-Service UI.';
992: FND_FILE.PUT_LINE(FND_FILE.LOG, '*** '||v_err_msg||' for interface_id: '||L_INTERFACE_ID);
993: update_interface_with_error(
994: p_ERR_MSG => v_err_msg
995: ,p_table_name => 'AMW_CONSTRAINTS_B'
996: ,P_INTERFACE_ID => L_INTERFACE_ID);
997: EXCEPTION
998: WHEN OTHERS THEN
999: fnd_file.put_line (fnd_file.LOG, 'unexpected exception in handling INCONSIST_CST_UPL: '||sqlerrm);