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

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

22: l_column_name VARCHAR2(30);
23: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
24: l_code_level varchar2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
25: --
26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
27:
28: -- Variables for Integration Event Code
29: l_party_id Number;
30: l_party_site_id Number;

Line 64: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);

60: FROM oe_pc_constraints
61: WHERE constraint_id = l_constraint_id;
62: if l_column_name is null then
63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
65: END IF;
66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;

Line 261: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

257: IF l_result = OE_PC_GLOBALS.YES THEN
258: IF x_on_operation_action = 1 THEN
259: -- set OUT result to NOT CONSTRAINED
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
262: END IF;
263: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
264: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
265: ELSIF x_on_operation_action = 2 THEN

Line 269: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

265: ELSIF x_on_operation_action = 2 THEN
266: -- set OUT result to NOT CONSTRAINED
267: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
270: END IF;
271: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
272: END IF;
273: END IF;

Line 281: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

277: IF l_result = OE_PC_GLOBALS.YES THEN
278: IF x_on_operation_action = 1 THEN
279: -- set OUT result to NOT CONSTRAINED
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
282: END IF;
283: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
284: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
285: ELSIF x_on_operation_action = 2 THEN

Line 289: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

285: ELSIF x_on_operation_action = 2 THEN
286: -- set OUT result to NOT CONSTRAINED
287: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add( 'HEADER SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
290: END IF;
291: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
292: END IF;
293: END IF;

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

2393: l_operation VARCHAR2(1);
2394: l_on_operation_action NUMBER;
2395: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
2396: --
2397: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2398: --
2399: BEGIN
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;

Line 2401: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;

2397: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2398: --
2399: BEGIN
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;
2402: END IF;
2403:
2404: -- Initializing return status to SUCCESS
2405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2415: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

2411: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2412: l_operation := OE_PC_GLOBALS.DELETE_OP;
2413: ELSE
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2416: END IF;
2417: RAISE FND_API.G_EXC_ERROR;
2418: END IF;
2419:

Line 2432: oe_debug_pub.add( 'EXIT OE_HEADER_SECURITY.ENTITY' , 1 ) ;

2428: ,x_on_operation_action => l_on_operation_action
2429: );
2430:
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'EXIT OE_HEADER_SECURITY.ENTITY' , 1 ) ;
2433: END IF;
2434:
2435: EXCEPTION
2436: WHEN OTHERS THEN

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

2479: l_active_flag VARCHAR2(1);
2480: e_inacitve_pl EXCEPTION;
2481: l_check_all_cols_constraint VARCHAR2(1);
2482: --
2483: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2484: --
2485: BEGIN
2486: IF l_debug_level > 0 THEN
2487: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

Line 2487: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

2483: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2484: --
2485: BEGIN
2486: IF l_debug_level > 0 THEN
2487: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
2488: END IF;
2489:
2490: -- Initializing return status to SUCCESS
2491: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2523: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

2519: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2520: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2521: ELSE
2522: IF l_debug_level > 0 THEN
2523: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2524: END IF;
2525: RAISE FND_API.G_EXC_ERROR;
2526: END IF;
2527:

Line 2575: oe_debug_pub.add( 'WHEN OTHERS' , 2 ) ;

2571: RAISE e_inacitve_pl ;
2572:
2573: WHEN OTHERS THEN
2574: IF l_debug_level > 0 THEN
2575: oe_debug_pub.add( 'WHEN OTHERS' , 2 ) ;
2576: END IF;
2577: END;
2578: END IF;
2579:

Line 4017: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;

4013: END IF;
4014:
4015: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
4016: IF l_debug_level > 0 THEN
4017: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
4018: END IF;
4019: g_check_all_cols_constraint := l_check_all_cols_constraint;
4020: END IF;
4021:

Line 4027: oe_debug_pub.add( 'EXIT OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

4023: -- NOTE: Please add constraints check for new attributes before the
4024: -- descriptive flexfield attributes check.
4025:
4026: IF l_debug_level > 0 THEN
4027: oe_debug_pub.add( 'EXIT OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
4028: END IF;
4029:
4030: EXCEPTION
4031: WHEN e_inacitve_pl THEN

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

4073: FROM OE_ORDER_HEADER_HISTORY
4074: WHERE header_id = l_source_document_id
4075: AND version_number = l_source_document_ver_num
4076: AND version_flag = 'Y';
4077: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4078: BEGIN
4079:
4080: if l_debug_level > 0 then
4081: oe_debug_pub.add('Enter Copied_From_Quote');

Line 4081: oe_debug_pub.add('Enter Copied_From_Quote');

4077: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4078: BEGIN
4079:
4080: if l_debug_level > 0 then
4081: oe_debug_pub.add('Enter Copied_From_Quote');
4082: end if;
4083:
4084: x_result := 0;
4085:

Line 4112: oe_debug_pub.add('Exit Copied_From_Quote');

4108:
4109: END IF;
4110:
4111: if l_debug_level > 0 then
4112: oe_debug_pub.add('Exit Copied_From_Quote');
4113: end if;
4114:
4115: EXCEPTION
4116: WHEN OTHERS THEN

Line 4118: oe_debug_pub.add('Others error :'||substr(sqlerrm,1,200));

4114:
4115: EXCEPTION
4116: WHEN OTHERS THEN
4117: if l_debug_level > 0 then
4118: oe_debug_pub.add('Others error :'||substr(sqlerrm,1,200));
4119: end if;
4120: x_result := 0;
4121: END Copied_From_Quote;
4122: