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 2361: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2357: l_operation VARCHAR2(1);
2358: l_on_operation_action NUMBER;
2359: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
2360: --
2361: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2362: --
2363: BEGIN
2364: IF l_debug_level > 0 THEN
2365: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;

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

2361: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2362: --
2363: BEGIN
2364: IF l_debug_level > 0 THEN
2365: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ENTITY' , 1 ) ;
2366: END IF;
2367:
2368: -- Initializing return status to SUCCESS
2369: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2375: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
2376: l_operation := OE_PC_GLOBALS.DELETE_OP;
2377: ELSE
2378: IF l_debug_level > 0 THEN
2379: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2380: END IF;
2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383:

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

2392: ,x_on_operation_action => l_on_operation_action
2393: );
2394:
2395: IF l_debug_level > 0 THEN
2396: oe_debug_pub.add( 'EXIT OE_HEADER_SECURITY.ENTITY' , 1 ) ;
2397: END IF;
2398:
2399: EXCEPTION
2400: WHEN OTHERS THEN

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

2425: l_active_flag VARCHAR2(1);
2426: e_inacitve_pl EXCEPTION;
2427: l_check_all_cols_constraint VARCHAR2(1);
2428: --
2429: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2430: --
2431: BEGIN
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;

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

2429: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2430: --
2431: BEGIN
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'ENTER OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
2434: END IF;
2435:
2436: -- Initializing return status to SUCCESS
2437: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2465: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2466: l_operation := OE_PC_GLOBALS.UPDATE_OP;
2467: ELSE
2468: IF l_debug_level > 0 THEN
2469: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
2470: END IF;
2471: RAISE FND_API.G_EXC_ERROR;
2472: END IF;
2473:

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

2517: RAISE e_inacitve_pl ;
2518:
2519: WHEN OTHERS THEN
2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'WHEN OTHERS' , 2 ) ;
2522: END IF;
2523: END;
2524: END IF;
2525:

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

3941: END IF;
3942:
3943: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
3944: IF l_debug_level > 0 THEN
3945: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
3946: END IF;
3947: g_check_all_cols_constraint := l_check_all_cols_constraint;
3948: END IF;
3949:

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

3951: -- NOTE: Please add constraints check for new attributes before the
3952: -- descriptive flexfield attributes check.
3953:
3954: IF l_debug_level > 0 THEN
3955: oe_debug_pub.add( 'EXIT OE_HEADER_SECURITY.ATTRIBUTES' , 1 ) ;
3956: END IF;
3957:
3958: EXCEPTION
3959: WHEN e_inacitve_pl THEN

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

4001: FROM OE_ORDER_HEADER_HISTORY
4002: WHERE header_id = l_source_document_id
4003: AND version_number = l_source_document_ver_num
4004: AND version_flag = 'Y';
4005: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4006: BEGIN
4007:
4008: if l_debug_level > 0 then
4009: oe_debug_pub.add('Enter Copied_From_Quote');

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

4005: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4006: BEGIN
4007:
4008: if l_debug_level > 0 then
4009: oe_debug_pub.add('Enter Copied_From_Quote');
4010: end if;
4011:
4012: x_result := 0;
4013:

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

4036:
4037: END IF;
4038:
4039: if l_debug_level > 0 then
4040: oe_debug_pub.add('Exit Copied_From_Quote');
4041: end if;
4042:
4043: EXCEPTION
4044: WHEN OTHERS THEN

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

4042:
4043: EXCEPTION
4044: WHEN OTHERS THEN
4045: if l_debug_level > 0 then
4046: oe_debug_pub.add('Others error :'||substr(sqlerrm,1,200));
4047: end if;
4048: x_result := 0;
4049: END Copied_From_Quote;
4050: