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

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

34: l_gen_xml Varchar2(1) := 'P';
35: --
36:
37: --
38: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
39: --
40: BEGIN
41:
42: -- Bug 1755817: if line belongs to a different order, then

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

74: FROM oe_pc_constraints
75: WHERE constraint_id = l_constraint_id;
76: if l_column_name is null then
77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
79: END IF;
80: RAISE FND_API.G_EXC_ERROR;
81: end if;
82: END IF;

Line 93: OE_DEBUG_PUB.add('Action performed code : '||x_on_operation_action,1);

89:
90: g_check_all_cols_constraint := 'N';
91:
92: IF l_debug_level > 0 THEN
93: OE_DEBUG_PUB.add('Action performed code : '||x_on_operation_action,1);
94: END IF;
95:
96: -- Bug 8537214, Reason requirement to be set for operation actions .1,.5 and 1 only
97:

Line 106: oe_debug_pub.add('Setting Cancellation Flag to True',1);

102: -- for lines in fulfillment phase
103: AND nvl(p_record.transaction_phase_code,'F') = 'F'
104: THEN
105: IF l_debug_level > 0 THEN
106: oe_debug_pub.add('Setting Cancellation Flag to True',1);
107: END IF;
108: oe_sales_can_util.G_REQUIRE_REASON := TRUE;
109: END IF;
110: END IF;

Line 381: OE_DEBUG_PUB.add('Audit Trail enabled ',5);

377: IF l_code_level >= '110508' and nvl(l_audit_trail_enabled,'D') <> 'D' and
378: nvl(p_record.transaction_phase_code,'F') = 'F' and
379: not OE_GLOBALS.G_HEADER_CREATED THEN
380: IF l_debug_level > 0 THEN
381: OE_DEBUG_PUB.add('Audit Trail enabled ',5);
382: END IF;
383: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
384: IF l_debug_level > 0 THEN
385: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);

Line 385: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);

381: OE_DEBUG_PUB.add('Audit Trail enabled ',5);
382: END IF;
383: IF l_audit_trail_enabled = 'B' THEN -- capture only for booked orders
384: IF l_debug_level > 0 THEN
385: OE_DEBUG_PUB.add('Audit Trail enabled for booked orders only ...',5);
386: END IF;
387: IF p_record.booked_flag = 'Y' THEN
388: IF l_result = OE_PC_GLOBALS.YES THEN
389: l_history_captured := FALSE;

Line 401: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

397: END IF;
398: END LOOP;
399: EXCEPTION WHEN OTHERS THEN
400: IF l_debug_level > 0 THEN
401: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
402: END IF;
403: NULL;
404: END;
405: IF NOT l_history_captured THEN

Line 409: oe_debug_pub.add('Line Security, attribute change requires reason',1);

405: IF NOT l_history_captured THEN
406: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
407: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
408: IF l_debug_level > 0 THEN
409: oe_debug_pub.add('Line Security, attribute change requires reason',1);
410: END IF;
411: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
412: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
413: END IF;

Line 423: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

419: END IF;
420: END LOOP;
421: EXCEPTION WHEN OTHERS THEN
422: IF l_debug_level > 0 THEN
423: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
424: END IF;
425: NULL;
426: END;
427: IF NOT l_history_captured THEN

Line 431: oe_debug_pub.add('Line Security, attribute change requires history',7);

427: IF NOT l_history_captured THEN
428: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
429: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add('Line Security, attribute change requires history',7);
432: END IF;
433: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add('Line Security, attribute change requires history',7);

Line 435: oe_debug_pub.add('Line Security, attribute change requires history',7);

431: oe_debug_pub.add('Line Security, attribute change requires history',7);
432: END IF;
433: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add('Line Security, attribute change requires history',7);
436: END IF;
437: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
438: END IF;
439: END IF;

Line 457: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

453: END IF;
454: END LOOP;
455: EXCEPTION WHEN OTHERS THEN
456: IF l_debug_level > 0 THEN
457: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
458: END IF;
459: NULL;
460: END;
461: IF NOT l_history_captured THEN

Line 465: oe_debug_pub.add('Line Security, attribute change requires reason',1);

461: IF NOT l_history_captured THEN
462: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
463: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'R';
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add('Line Security, attribute change requires reason',1);
466: END IF;
467: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
468: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
469: END IF;

Line 479: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);

475: END IF;
476: END LOOP;
477: EXCEPTION WHEN OTHERS THEN
478: IF l_debug_level > 0 THEN
479: OE_DEBUG_PUB.add('While capturing history : '||sqlerrm,1);
480: END IF;
481: NULL;
482: END;
483: IF NOT l_history_captured THEN

Line 487: oe_debug_pub.add('Line Security, attribute change requires history',7);

483: IF NOT l_history_captured THEN
484: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).LINE_ID := p_record.line_id;
485: OE_GLOBALS.OE_AUDIT_HISTORY_TBL(l_ctr+1).HISTORY_TYPE := 'H';
486: IF l_debug_level > 0 THEN
487: oe_debug_pub.add('Line Security, attribute change requires history',7);
488: END IF;
489: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
490: IF l_debug_level > 0 THEN
491: oe_debug_pub.add('Line Security, attribute change requires history',7);

Line 491: oe_debug_pub.add('Line Security, attribute change requires history',7);

487: oe_debug_pub.add('Line Security, attribute change requires history',7);
488: END IF;
489: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
490: IF l_debug_level > 0 THEN
491: oe_debug_pub.add('Line Security, attribute change requires history',7);
492: END IF;
493: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
494: END IF;
495: END IF;

Line 501: OE_DEBUG_PUB.add('Audit Trail is disabled..',5);

497: END IF;
498: END IF;
499: ELSE
500: IF l_debug_level > 0 THEN
501: OE_DEBUG_PUB.add('Audit Trail is disabled..',5);
502: END IF;
503: END IF;
504: END IF;
505: IF g_operation_action is null THEN

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

3293: l_on_operation_action NUMBER;
3294: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
3295: l_flow_status_code VARCHAR2(30);
3296: --
3297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3298: --
3299: BEGIN
3300:
3301: IF l_debug_level > 0 THEN

Line 3302: oe_debug_pub.add('Enter OE_LINE_Security.Entity',1);

3298: --
3299: BEGIN
3300:
3301: IF l_debug_level > 0 THEN
3302: oe_debug_pub.add('Enter OE_LINE_Security.Entity',1);
3303: END IF;
3304:
3305: -- Initializing return status to SUCCESS
3306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3311: oe_debug_pub.add('hash before create operation');

3307:
3308: /* start of bug 2922204 */
3309:
3310: IF l_debug_level > 0 THEN
3311: oe_debug_pub.add('hash before create operation');
3312: END IF;
3313:
3314: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3315:

Line 3317: oe_debug_pub.add('hash in create operation');

3313:
3314: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3315:
3316: IF l_debug_level > 0 THEN
3317: oe_debug_pub.add('hash in create operation');
3318: END IF;
3319:
3320: IF p_Line_rec.item_type_code = 'SERVICE' AND
3321: p_line_rec.service_reference_type_code = 'ORDER' AND --3390589

Line 3333: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);

3329: END;
3330:
3331: IF l_flow_status_code = 'CANCELLED' THEN
3332: IF l_debug_level > 0 THEN
3333: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3334: END IF;
3335: x_result := OE_PC_GLOBALS.YES;
3336: IF l_debug_level > 0 THEN
3337: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);

Line 3337: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);

3333: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3334: END IF;
3335: x_result := OE_PC_GLOBALS.YES;
3336: IF l_debug_level > 0 THEN
3337: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3338: END IF;
3339: -- Add msg to stack
3340: FND_MESSAGE.SET_NAME('ONT','OE_SVC_PROD_CANCELLED');
3341: OE_MSG_PUB.Add;

Line 3345: oe_debug_pub.add('hash flow status is not cancelled');

3341: OE_MSG_PUB.Add;
3342: RETURN;
3343: ELSE
3344: IF l_debug_level > 0 THEN
3345: oe_debug_pub.add('hash flow status is not cancelled');
3346: END IF;
3347: l_operation := OE_PC_GLOBALS.CREATE_OP;
3348: END IF; -- if cancelled
3349: ElSE

Line 3351: oe_debug_pub.add('hash not a service');

3347: l_operation := OE_PC_GLOBALS.CREATE_OP;
3348: END IF; -- if cancelled
3349: ElSE
3350: IF l_debug_level > 0 THEN
3351: oe_debug_pub.add('hash not a service');
3352: END IF;
3353: l_operation := OE_PC_GLOBALS.CREATE_OP;
3354: END IF; -- end if service
3355:

Line 3367: oe_debug_pub.add('Invalid operation',1);

3363: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3364: l_operation := OE_PC_GLOBALS.DELETE_OP;
3365: ELSE
3366: IF l_debug_level > 0 THEN
3367: oe_debug_pub.add('Invalid operation',1);
3368: END IF;
3369: RAISE FND_API.G_EXC_ERROR;
3370: END IF;
3371:

Line 3380: oe_debug_pub.add('OEXXLINB operation is ' || p_line_rec.operation);

3376: --Initialize security global record
3377: OE_LINE_SECURITY.g_record := l_rowtype_rec;
3378:
3379: IF l_debug_level > 0 THEN
3380: oe_debug_pub.add('OEXXLINB operation is ' || p_line_rec.operation);
3381: END IF;
3382: IF (p_line_rec.split_from_line_id IS NOT NULL AND p_line_rec.operation = 'CREATE')
3383: THEN
3384: l_operation := OE_PC_GLOBALS.SPLIT_OP;

Line 3388: oe_debug_pub.add('resetting operation from Update to SPLIT before Is_OP_constrained');

3384: l_operation := OE_PC_GLOBALS.SPLIT_OP;
3385: -- --12849745 Elsif below added
3386: ELSIF ( p_line_rec.operation = 'UPDATE' and p_line_rec.split_action_code='SPLIT' ) THEN
3387: IF l_debug_level > 0 THEN
3388: oe_debug_pub.add('resetting operation from Update to SPLIT before Is_OP_constrained');
3389: END IF;
3390: l_operation := OE_PC_GLOBALS.SPLIT_OP; --12849745 End
3391: END IF;
3392: x_result := Is_OP_constrained

Line 3400: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);

3396: );
3397:
3398:
3399: IF l_debug_level > 0 THEN
3400: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);
3401: END IF;
3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: x_return_status := FND_API.G_RET_STS_ERROR;

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

3428: l_column_name VARCHAR2(30);
3429: l_active_flag VARCHAR2(1);
3430: l_check_all_cols_constraint VARCHAR2(1);
3431: --
3432: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3433: --
3434: BEGIN
3435: IF l_debug_level > 0 THEN
3436: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);

Line 3436: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);

3432: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3433: --
3434: BEGIN
3435: IF l_debug_level > 0 THEN
3436: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);
3437: END IF;
3438:
3439: -- Initializing return status to SUCCESS
3440: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3478: oe_debug_pub.add('Invalid operation',1);

3474: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3475: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3476: ELSE
3477: IF l_debug_level > 0 THEN
3478: oe_debug_pub.add('Invalid operation',1);
3479: END IF;
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482:

Line 5166: oe_debug_pub.add('when others',1);

5162: END IF;
5163: EXCEPTION
5164: WHEN OTHERS THEN
5165: IF l_debug_level > 0 THEN
5166: oe_debug_pub.add('when others',1);
5167: END IF;
5168: END;
5169: END IF;
5170:

Line 5664: oe_debug_pub.add('setting check all cols constraint to:'||l_check_all_cols_constraint);

5660: /* Customer Acceptance - End */
5661:
5662: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
5663: IF l_debug_level > 0 THEN
5664: oe_debug_pub.add('setting check all cols constraint to:'||l_check_all_cols_constraint);
5665: END IF;
5666: g_check_all_cols_constraint := l_check_all_cols_constraint;
5667: END IF;
5668:

Line 5674: oe_debug_pub.add('Exit OE_LINE_Security.Attributes',1);

5670: -- NOTE: Please add constraints check for new attributes before the
5671: -- descriptive flexfield attributes check.
5672:
5673: IF l_debug_level > 0 THEN
5674: oe_debug_pub.add('Exit OE_LINE_Security.Attributes',1);
5675: END IF;
5676:
5677: EXCEPTION
5678: WHEN FND_API.G_EXC_ERROR THEN