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_PC_CONSTRAINTS_ADMIN_PUB dependencies on OE_DEBUG_PUB

Line 60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

56: IS SELECT application_short_name, db_object_name, entity_id
57: FROM OE_PC_ENTITIES_V
58: where application_id = p_application_id
59: AND entity_short_name = p_entity_short_name;
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN
62: IF l_debug_level > 0 THEN
63: OE_Debug_PUB.ADD('Generate_Constraint_API: begin ');
64: END IF;

Line 63: OE_Debug_PUB.ADD('Generate_Constraint_API: begin ');

59: AND entity_short_name = p_entity_short_name;
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: BEGIN
62: IF l_debug_level > 0 THEN
63: OE_Debug_PUB.ADD('Generate_Constraint_API: begin ');
64: END IF;
65: OPEN C_APP;
66: Fetch C_APP into l_app_short_name, l_db_object_name, l_entity_id;
67: Close C_APP;

Line 69: OE_Debug_PUB.ADD('Entity ID: '||l_entity_id);

65: OPEN C_APP;
66: Fetch C_APP into l_app_short_name, l_db_object_name, l_entity_id;
67: Close C_APP;
68: IF l_debug_level > 0 THEN
69: OE_Debug_PUB.ADD('Entity ID: '||l_entity_id);
70: END IF;
71:
72:
73: l_fileDir := ltrim(rtrim(fnd_profile.value('OE_PC_FILE_DIRECTORY')));

Line 86: OE_Debug_PUB.ADD('couldnt find the log file directory.. profile missing..returning. End');

82: -- raise error;
83: fnd_message.set_name('OE', 'OE_PC_FILE_DIRECTORY_MISSING');
84: --
85: IF l_debug_level > 0 THEN
86: OE_Debug_PUB.ADD('couldnt find the log file directory.. profile missing..returning. End');
87: END IF;
88: --
89: -- ** In future, the PCFWK admin may maintain a log file and log the errors in it.
90: return;

Line 94: OE_Debug_PUB.ADD('log file directory : ' || l_fileDir);

90: return;
91: end if;
92: --
93: IF l_debug_level > 0 THEN
94: OE_Debug_PUB.ADD('log file directory : ' || l_fileDir);
95: END IF;
96: --
97: open C_FILENO;
98: fetch C_FILENO into l_fileNumber;

Line 114: OE_Debug_PUB.ADD('script (SQL) file name : ' || l_sqlFileName || ' DIR: ' ||l_fileDir);

110: l_bodyFileName := l_fileNameTag || '_B.PLS';
111:
112: --
113: IF l_debug_level > 0 THEN
114: OE_Debug_PUB.ADD('script (SQL) file name : ' || l_sqlFileName || ' DIR: ' ||l_fileDir);
115: END IF;
116: --
117: l_sqlFileHandle := utl_file.fopen(
118: location => l_fileDir

Line 124: OE_Debug_PUB.ADD('Spec file name : ' || l_specFileName || ' DIR: ' ||l_fileDir);

120: ,open_mode => 'w'
121: );
122: --
123: IF l_debug_level > 0 THEN
124: OE_Debug_PUB.ADD('Spec file name : ' || l_specFileName || ' DIR: ' ||l_fileDir);
125: END IF;
126: --
127: l_specFileHandle := utl_file.fopen(
128: location => l_fileDir

Line 134: OE_Debug_PUB.ADD('Body file name : ' || l_bodyFileName || ' DIR: ' ||l_fileDir);

130: ,open_mode => 'w'
131: );
132: --
133: IF l_debug_level > 0 THEN
134: OE_Debug_PUB.ADD('Body file name : ' || l_bodyFileName || ' DIR: ' ||l_fileDir);
135: END IF;
136: --
137: l_bodyFileHandle := utl_file.fopen(
138: location => l_fileDir

Line 215: OE_Debug_PUB.ADD('generate body');

211: utl_file.put_line(l_specFileHandle , 'COMMIT;');
212: --utl_file.put_line(l_specFileHandle , 'EXIT;');
213: utl_file.fclose(l_specFileHandle);
214: IF l_debug_level > 0 THEN
215: OE_Debug_PUB.ADD('generate body');
216: END IF;
217:
218: --generate body
219: utl_file.put_line(l_bodyFileHandle, '-- ');

Line 246: OE_Debug_PUB.ADD('generateValidate_Constraint ');

242: utl_file.put_line(l_bodyFileHandle , ' g_application_id constant number := ' || to_char(p_application_id) || ';');
243: utl_file.put_line(l_bodyFileHandle , ' g_entity_id constant number := ' || to_char(l_entity_id) || ';');
244: utl_file.put_line(l_bodyFileHandle , ' g_entity_short_name constant varchar2(15) := ' || '''' ||p_entity_short_name || '''' || ';');
245: IF l_debug_level > 0 THEN
246: OE_Debug_PUB.ADD('generateValidate_Constraint ');
247: END IF;
248:
249: utl_file.put_line(l_bodyFileHandle , '------------------------------------------- ');
250: utl_file.put_line(l_bodyFileHandle , 'PROCEDURE Validate_Constraint ');

Line 437: OE_Debug_PUB.ADD(' generate Is_Op_Constrained ');

433: utl_file.put_line(l_bodyFileHandle , ' x_result := OE_PC_GLOBALS.ERROR; ');
434: utl_file.put_line(l_bodyFileHandle , 'END Validate_Constraint; ');
435: utl_file.put_line(l_bodyFileHandle , '------------------------------------------- ');
436: IF l_debug_level > 0 THEN
437: OE_Debug_PUB.ADD(' generate Is_Op_Constrained ');
438: END IF;
439:
440: utl_file.put_line(l_bodyFileHandle , '------------------------------------------- ');
441: utl_file.put_line(l_bodyFileHandle , 'FUNCTION Is_Op_Constrained ');

Line 590: OE_Debug_PUB.ADD('Oe_PC_Constraints_Admin_Pub.Generate_Constraint_API: EXCEPTION');

586: EXCEPTION
587:
588: when others then
589: IF l_debug_level > 0 THEN
590: OE_Debug_PUB.ADD('Oe_PC_Constraints_Admin_Pub.Generate_Constraint_API: EXCEPTION');
591: END IF;
592: END Generate_Constraint_API;
593: ----------------------------------------------------------------------
594:

Line 645: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

641:
642: I NUMBER := 1;
643:
644: x_WF_Roles_TBL OE_PC_GLOBALS.Authorized_WF_Roles_TBL;
645: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
646: BEGIN
647:
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649:

Line 710: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

706: , p_attribute_name IN VARCHAR2
707: , p_object_name IN VARCHAR2
708: )
709: IS
710: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
711: BEGIN
712:
713: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
714: IF p_attribute_name IS NOT NULL THEN

Line 789: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

785: SELECT USER_MESSAGE msg
786: FROM OE_PC_CONDITIONS_VL
787: WHERE CONSTRAINT_ID = p_constraint_id
788: AND GROUP_NUMBER = p_group_number;
789: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
790: BEGIN
791:
792: l_operation := p_operation;
793: