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: IF l_result = OE_PC_GLOBALS.YES THEN
97: IF x_on_operation_action IN (.05,.1,.2,.5,1) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3121: l_on_operation_action NUMBER;
3122: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
3123: l_flow_status_code VARCHAR2(30);
3124: --
3125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3126: --
3127: BEGIN
3128:
3129: IF l_debug_level > 0 THEN

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

3126: --
3127: BEGIN
3128:
3129: IF l_debug_level > 0 THEN
3130: oe_debug_pub.add('Enter OE_LINE_Security.Entity',1);
3131: END IF;
3132:
3133: -- Initializing return status to SUCCESS
3134: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3135:
3136: /* start of bug 2922204 */
3137:
3138: IF l_debug_level > 0 THEN
3139: oe_debug_pub.add('hash before create operation');
3140: END IF;
3141:
3142: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3143:

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

3141:
3142: IF p_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3143:
3144: IF l_debug_level > 0 THEN
3145: oe_debug_pub.add('hash in create operation');
3146: END IF;
3147:
3148: IF p_Line_rec.item_type_code = 'SERVICE' AND
3149: p_line_rec.service_reference_type_code = 'ORDER' AND --3390589

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

3157: END;
3158:
3159: IF l_flow_status_code = 'CANCELLED' THEN
3160: IF l_debug_level > 0 THEN
3161: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3162: END IF;
3163: x_result := OE_PC_GLOBALS.YES;
3164: IF l_debug_level > 0 THEN
3165: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);

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

3161: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3162: END IF;
3163: x_result := OE_PC_GLOBALS.YES;
3164: IF l_debug_level > 0 THEN
3165: oe_debug_pub.add('hash flow status is cancelled..x_result is' || x_result);
3166: END IF;
3167: -- Add msg to stack
3168: FND_MESSAGE.SET_NAME('ONT','OE_SVC_PROD_CANCELLED');
3169: OE_MSG_PUB.Add;

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

3169: OE_MSG_PUB.Add;
3170: RETURN;
3171: ELSE
3172: IF l_debug_level > 0 THEN
3173: oe_debug_pub.add('hash flow status is not cancelled');
3174: END IF;
3175: l_operation := OE_PC_GLOBALS.CREATE_OP;
3176: END IF; -- if cancelled
3177: ElSE

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

3175: l_operation := OE_PC_GLOBALS.CREATE_OP;
3176: END IF; -- if cancelled
3177: ElSE
3178: IF l_debug_level > 0 THEN
3179: oe_debug_pub.add('hash not a service');
3180: END IF;
3181: l_operation := OE_PC_GLOBALS.CREATE_OP;
3182: END IF; -- end if service
3183:

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

3191: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
3192: l_operation := OE_PC_GLOBALS.DELETE_OP;
3193: ELSE
3194: IF l_debug_level > 0 THEN
3195: oe_debug_pub.add('Invalid operation',1);
3196: END IF;
3197: RAISE FND_API.G_EXC_ERROR;
3198: END IF;
3199:

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

3204: --Initialize security global record
3205: OE_LINE_SECURITY.g_record := l_rowtype_rec;
3206:
3207: IF l_debug_level > 0 THEN
3208: oe_debug_pub.add('OEXXLINB operation is ' || p_line_rec.operation);
3209: END IF;
3210: IF (p_line_rec.split_from_line_id IS NOT NULL AND p_line_rec.operation = 'CREATE')
3211: THEN
3212: l_operation := OE_PC_GLOBALS.SPLIT_OP;

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

3218: );
3219:
3220:
3221: IF l_debug_level > 0 THEN
3222: oe_debug_pub.add('Exit OE_LINE_Security.Entity',1);
3223: END IF;
3224: EXCEPTION
3225: WHEN FND_API.G_EXC_ERROR THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;

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

3250: l_column_name VARCHAR2(30);
3251: l_active_flag VARCHAR2(1);
3252: l_check_all_cols_constraint VARCHAR2(1);
3253: --
3254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3255: --
3256: BEGIN
3257: IF l_debug_level > 0 THEN
3258: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);

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

3254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3255: --
3256: BEGIN
3257: IF l_debug_level > 0 THEN
3258: oe_debug_pub.add('Enter OE_LINE_Security.Attributes',1);
3259: END IF;
3260:
3261: -- Initializing return status to SUCCESS
3262: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3296: ELSIF p_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3297: l_operation := OE_PC_GLOBALS.UPDATE_OP;
3298: ELSE
3299: IF l_debug_level > 0 THEN
3300: oe_debug_pub.add('Invalid operation',1);
3301: END IF;
3302: RAISE FND_API.G_EXC_ERROR;
3303: END IF;
3304:

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

4895: END IF;
4896: EXCEPTION
4897: WHEN OTHERS THEN
4898: IF l_debug_level > 0 THEN
4899: oe_debug_pub.add('when others',1);
4900: END IF;
4901: END;
4902: END IF;
4903:

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

5343: /* Customer Acceptance - End */
5344:
5345: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
5346: IF l_debug_level > 0 THEN
5347: oe_debug_pub.add('setting check all cols constraint to:'||l_check_all_cols_constraint);
5348: END IF;
5349: g_check_all_cols_constraint := l_check_all_cols_constraint;
5350: END IF;
5351:

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

5353: -- NOTE: Please add constraints check for new attributes before the
5354: -- descriptive flexfield attributes check.
5355:
5356: IF l_debug_level > 0 THEN
5357: oe_debug_pub.add('Exit OE_LINE_Security.Attributes',1);
5358: END IF;
5359:
5360: EXCEPTION
5361: WHEN FND_API.G_EXC_ERROR THEN