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_PC_GLOBALS

Line 307: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.NO;');

303: utl_file.put_line(l_bodyFileHandle , ' l_currGrpNumber number;');
304: utl_file.put_line(l_bodyFileHandle , ' l_currGrpResult boolean;');
305: utl_file.put_line(l_bodyFileHandle , 'BEGIN ');
306: utl_file.put_line(l_bodyFileHandle , ' ');
307: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.NO;');
308: utl_file.put_line(l_bodyFileHandle , ' l_rule_count := 0;');
309: utl_file.put_line(l_bodyFileHandle , ' i := 0;');
310: utl_file.put_line(l_bodyFileHandle , ' l_currGrpNumber := -1;');
311: utl_file.put_line(l_bodyFileHandle , ' l_currGrpResult := FALSE;');

Line 332: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.YES;');

328: utl_file.put_line(l_bodyFileHandle , ' ');
329: utl_file.put_line(l_bodyFileHandle , ' -- EXIT from loop ');
330: utl_file.put_line(l_bodyFileHandle , ' IF (C_R%NOTFOUND) THEN');
331: utl_file.put_line(l_bodyFileHandle , ' IF (l_currGrpNumber != -1 AND l_currGrpResult = TRUE) THEN');
332: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.YES;');
333: utl_file.put_line(l_bodyFileHandle , ' END IF;');
334: utl_file.put_line(l_bodyFileHandle , ' EXIT; -- exit the loop');
335: utl_file.put_line(l_bodyFileHandle , ' END IF;');
336: utl_file.put_line(l_bodyFileHandle , ' ');

Line 341: utl_file.put_line(l_bodyFileHandle , ' -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.');

337: utl_file.put_line(l_bodyFileHandle , ' IF (l_currGrpNumber != l_constraintRuleRec.group_number) THEN');
338: utl_file.put_line(l_bodyFileHandle , ' ');
339: utl_file.put_line(l_bodyFileHandle , ' -- we are entering the new group of conditions.. ');
340: utl_file.put_line(l_bodyFileHandle , ' -- groups are ORd together, so if the previous group was evaluated');
341: utl_file.put_line(l_bodyFileHandle , ' -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.');
342: utl_file.put_line(l_bodyFileHandle , ' IF (l_currGrpResult = TRUE) THEN');
343: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.YES;');
344: utl_file.put_line(l_bodyFileHandle , ' EXIT; -- exit the loop');
345: utl_file.put_line(l_bodyFileHandle , ' END IF;');

Line 343: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.YES;');

339: utl_file.put_line(l_bodyFileHandle , ' -- we are entering the new group of conditions.. ');
340: utl_file.put_line(l_bodyFileHandle , ' -- groups are ORd together, so if the previous group was evaluated');
341: utl_file.put_line(l_bodyFileHandle , ' -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.');
342: utl_file.put_line(l_bodyFileHandle , ' IF (l_currGrpResult = TRUE) THEN');
343: utl_file.put_line(l_bodyFileHandle , ' l_ConstrainedStatus := OE_PC_GLOBALS.YES;');
344: utl_file.put_line(l_bodyFileHandle , ' EXIT; -- exit the loop');
345: utl_file.put_line(l_bodyFileHandle , ' END IF;');
346: utl_file.put_line(l_bodyFileHandle , ' ');
347: utl_file.put_line(l_bodyFileHandle , ' -- previous group did not evaluvate to TRUE, so lets pursue this new group');

Line 403: utl_file.put_line(l_bodyFileHandle , ' if(l_constraintRuleRec.modifier_flag = OE_PC_GLOBALS.YES_FLAG) then');

399: utl_file.put_line(l_bodyFileHandle , ' ELSE');
400: utl_file.put_line(l_bodyFileHandle , ' l_tempResult := TRUE;');
401: utl_file.put_line(l_bodyFileHandle , ' END IF;');
402: utl_file.put_line(l_bodyFileHandle , ' -- apply the modifier on the result');
403: utl_file.put_line(l_bodyFileHandle , ' if(l_constraintRuleRec.modifier_flag = OE_PC_GLOBALS.YES_FLAG) then');
404: utl_file.put_line(l_bodyFileHandle , ' l_tempResult := NOT(l_tempResult);');
405: utl_file.put_line(l_bodyFileHandle , ' end if;');
406: utl_file.put_line(l_bodyFileHandle , ' ');
407: utl_file.put_line(l_bodyFileHandle , ' IF (i = 0) THEN');

Line 424: utl_file.put_line(l_bodyFileHandle , ' x_result := OE_PC_GLOBALS.YES;');

420: utl_file.put_line(l_bodyFileHandle , ' -- constraint is valid and we will return YES ');
421: utl_file.put_line(l_bodyFileHandle , ' IF (l_rule_count = 0) THEN');
422: utl_file.put_line(l_bodyFileHandle , ' x_condition_count := 0;');
423: utl_file.put_line(l_bodyFileHandle , ' x_valid_condition_group := -1;');
424: utl_file.put_line(l_bodyFileHandle , ' x_result := OE_PC_GLOBALS.YES;');
425: utl_file.put_line(l_bodyFileHandle , ' ELSE ');
426: utl_file.put_line(l_bodyFileHandle , ' x_condition_count := l_rule_count;');
427: utl_file.put_line(l_bodyFileHandle , ' x_valid_condition_group := l_currGrpNumber;');
428: utl_file.put_line(l_bodyFileHandle , ' x_result := l_ConstrainedStatus;');

Line 433: utl_file.put_line(l_bodyFileHandle , ' x_result := OE_PC_GLOBALS.ERROR; ');

429: utl_file.put_line(l_bodyFileHandle , ' END IF;');
430: utl_file.put_line(l_bodyFileHandle , ' -------------------------------------------');
431: utl_file.put_line(l_bodyFileHandle , ' EXCEPTION ');
432: utl_file.put_line(l_bodyFileHandle , ' WHEN OTHERS THEN ');
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 ');

Line 508: utl_file.put_line(l_bodyFileHandle , ' AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP');

504: utl_file.put_line(l_bodyFileHandle , ' AND a.application_id = p_application_id OR a.application_id IS NULL'); --bug3631547
505: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(a.start_date_active, sysdate) AND nvl(a.end_date_active, sysdate)');
506: utl_file.put_line(l_bodyFileHandle , ' AND a.constraint_id = c.constraint_id');
507: utl_file.put_line(l_bodyFileHandle , ' AND c.entity_id = G_ENTITY_ID');
508: utl_file.put_line(l_bodyFileHandle , ' AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP');
509: utl_file.put_line(l_bodyFileHandle , ' AND c.check_on_insert_flag = ''Y''');
510: utl_file.put_line(l_bodyFileHandle , ' AND nvl(c.column_name, ' || l_DUMMY_COL || ') = p_column_name');
511: utl_file.put_line(l_bodyFileHandle , ' -- if caller is defaulting then DO NOT CHECK those constraints');
512: utl_file.put_line(l_bodyFileHandle , ' -- that have honored_by_def_flag = ''N''');

Line 531: utl_file.put_line(l_bodyFileHandle , ' l_validation_result := OE_PC_GLOBALS.NO; ');

527: utl_file.put_line(l_bodyFileHandle , ' l_condition_count number;');
528: utl_file.put_line(l_bodyFileHandle , ' l_valid_condition_group number;');
529: utl_file.put_line(l_bodyFileHandle , ' BEGIN ');
530: utl_file.put_line(l_bodyFileHandle , ' g_record := p_record; ');
531: utl_file.put_line(l_bodyFileHandle , ' l_validation_result := OE_PC_GLOBALS.NO; ');
532: utl_file.put_line(l_bodyFileHandle , ' FOR c_rec in C_C LOOP ');
533: utl_file.put_line(l_bodyFileHandle , ' Validate_Constraint ( ');
534: utl_file.put_line(l_bodyFileHandle , ' p_constraint_id => c_rec.constraint_id');
535: utl_file.put_line(l_bodyFileHandle , ' ,x_condition_count => l_condition_count');

Line 539: utl_file.put_line(l_bodyFileHandle , ' IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then');

535: utl_file.put_line(l_bodyFileHandle , ' ,x_condition_count => l_condition_count');
536: utl_file.put_line(l_bodyFileHandle , ' ,x_valid_condition_group => l_valid_condition_group');
537: utl_file.put_line(l_bodyFileHandle , ' ,x_result => l_validation_result');
538: utl_file.put_line(l_bodyFileHandle , ' );');
539: utl_file.put_line(l_bodyFileHandle , ' IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then');
540: utl_file.put_line(l_bodyFileHandle , ' x_constraint_id := c_rec.constraint_id;');
541: utl_file.put_line(l_bodyFileHandle , ' x_on_operation_action := c_rec.on_operation_action;');
542: --utl_file.put_line(l_bodyFileHandle , ' x_message_name := c_rec.message_name;');
543: utl_file.put_line(l_bodyFileHandle , ' x_constraining_conditions_grp := l_valid_condition_group;');

Line 547: utl_file.put_line(l_bodyFileHandle , ' IF ( p_operation = OE_PC_GLOBALS.CREATE_OP');

543: utl_file.put_line(l_bodyFileHandle , ' x_constraining_conditions_grp := l_valid_condition_group;');
544: utl_file.put_line(l_bodyFileHandle , ' EXIT;');
545: utl_file.put_line(l_bodyFileHandle , ' END IF;');
546: utl_file.put_line(l_bodyFileHandle , ' END LOOP;');
547: utl_file.put_line(l_bodyFileHandle , ' IF ( p_operation = OE_PC_GLOBALS.CREATE_OP');
548: utl_file.put_line(l_bodyFileHandle , ' AND l_validation_result = OE_PC_GLOBALS.NO');
549: utl_file.put_line(l_bodyFileHandle , ' AND p_column_name IS NOT NULL) THEN');
550: utl_file.put_line(l_bodyFileHandle , ' FOR c_rec in C_CHECK_ON_INSERT LOOP');
551: utl_file.put_line(l_bodyFileHandle , ' Validate_Constraint ( ');

Line 548: utl_file.put_line(l_bodyFileHandle , ' AND l_validation_result = OE_PC_GLOBALS.NO');

544: utl_file.put_line(l_bodyFileHandle , ' EXIT;');
545: utl_file.put_line(l_bodyFileHandle , ' END IF;');
546: utl_file.put_line(l_bodyFileHandle , ' END LOOP;');
547: utl_file.put_line(l_bodyFileHandle , ' IF ( p_operation = OE_PC_GLOBALS.CREATE_OP');
548: utl_file.put_line(l_bodyFileHandle , ' AND l_validation_result = OE_PC_GLOBALS.NO');
549: utl_file.put_line(l_bodyFileHandle , ' AND p_column_name IS NOT NULL) THEN');
550: utl_file.put_line(l_bodyFileHandle , ' FOR c_rec in C_CHECK_ON_INSERT LOOP');
551: utl_file.put_line(l_bodyFileHandle , ' Validate_Constraint ( ');
552: utl_file.put_line(l_bodyFileHandle , ' p_constraint_id => c_rec.constraint_id');

Line 557: utl_file.put_line(l_bodyFileHandle , ' IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then');

553: utl_file.put_line(l_bodyFileHandle , ' ,x_condition_count => l_condition_count');
554: utl_file.put_line(l_bodyFileHandle , ' ,x_valid_condition_group => l_valid_condition_group');
555: utl_file.put_line(l_bodyFileHandle , ' ,x_result => l_validation_result');
556: utl_file.put_line(l_bodyFileHandle , ' );');
557: utl_file.put_line(l_bodyFileHandle , ' IF (l_condition_count = 0 OR l_validation_result = OE_PC_GLOBALS.YES) then');
558: utl_file.put_line(l_bodyFileHandle , ' x_constraint_id := c_rec.constraint_id;');
559: utl_file.put_line(l_bodyFileHandle , ' x_on_operation_action := c_rec.on_operation_action;');
560: --utl_file.put_line(l_bodyFileHandle , ' x_message_name := c_rec.message_name;');
561: utl_file.put_line(l_bodyFileHandle , ' x_constraining_conditions_grp := l_valid_condition_group;');

Line 569: utl_file.put_line(l_bodyFileHandle , ' RETURN OE_PC_GLOBALS.ERROR; ');

565: utl_file.put_line(l_bodyFileHandle , ' END IF;');
566: utl_file.put_line(l_bodyFileHandle , ' return l_validation_result;');
567: utl_file.put_line(l_bodyFileHandle , ' EXCEPTION ');
568: utl_file.put_line(l_bodyFileHandle , ' WHEN OTHERS THEN ');
569: utl_file.put_line(l_bodyFileHandle , ' RETURN OE_PC_GLOBALS.ERROR; ');
570: utl_file.put_line(l_bodyFileHandle , 'END Is_Op_Constrained; ');
571: utl_file.put_line(l_bodyFileHandle , '------------------------------------------- ');
572: utl_file.put_line(l_bodyFileHandle , 'END ' || l_pkg_name || ';');
573: utl_file.put_line(l_bodyFileHandle , '/');

Line 615: RETURN OE_PC_GLOBALS.Authorized_WF_Roles_TBL

611: p_constraint_id IN NUMBER
612: , x_return_status OUT NOCOPY VARCHAR2
613:
614: )
615: RETURN OE_PC_GLOBALS.Authorized_WF_Roles_TBL
616: -----------------------------------------------------
617: IS
618:
619: CURSOR C_ASSIGNED_RESP IS

Line 644: x_WF_Roles_TBL OE_PC_GLOBALS.Authorized_WF_Roles_TBL;

640: ORDER BY role_display_name;
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;

Line 713: IF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN

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
715: IF nvl(p_group_number,-1) = -1 THEN
716: FND_MESSAGE.SET_NAME('ONT','OE_PC_UPDATE_FIELD_NO_CONDN');
717: ELSE

Line 729: ELSIF p_operation = OE_PC_GLOBALS.CREATE_OP THEN

725: FND_MESSAGE.SET_NAME('ONT','OE_PC_UPDATE_VIOLATION');
726: END IF;
727: FND_MESSAGE.SET_TOKEN('OBJECT',p_object_name);
728: END IF;
729: ELSIF p_operation = OE_PC_GLOBALS.CREATE_OP THEN
730: IF nvl(p_group_number,-1) = -1 THEN
731: FND_MESSAGE.SET_NAME('ONT','OE_PC_CREATE_NO_CONDN');
732: ELSE
733: FND_MESSAGE.SET_NAME('ONT','OE_PC_CREATE_VIOLATION');

Line 736: ELSIF p_operation = OE_PC_GLOBALS.DELETE_OP THEN

732: ELSE
733: FND_MESSAGE.SET_NAME('ONT','OE_PC_CREATE_VIOLATION');
734: END IF;
735: FND_MESSAGE.SET_TOKEN('OBJECT',p_object_name);
736: ELSIF p_operation = OE_PC_GLOBALS.DELETE_OP THEN
737: IF nvl(p_group_number,-1) = -1 THEN
738: FND_MESSAGE.SET_NAME('ONT','OE_PC_DELETE_NO_CONDN');
739: ELSE
740: FND_MESSAGE.SET_NAME('ONT','OE_PC_DELETE_VIOLATION');

Line 743: ELSIF p_operation = OE_PC_GLOBALS.CANCEL_OP THEN

739: ELSE
740: FND_MESSAGE.SET_NAME('ONT','OE_PC_DELETE_VIOLATION');
741: END IF;
742: FND_MESSAGE.SET_TOKEN('OBJECT',p_object_name);
743: ELSIF p_operation = OE_PC_GLOBALS.CANCEL_OP THEN
744: IF nvl(p_group_number,-1) = -1 THEN
745: FND_MESSAGE.SET_NAME('ONT','OE_PC_CANCEL_NO_CONDN');
746: ELSE
747: FND_MESSAGE.SET_NAME('ONT','OE_PC_CANCEL_VIOLATION');

Line 750: ELSIF p_operation = OE_PC_GLOBALS.SPLIT_OP THEN

746: ELSE
747: FND_MESSAGE.SET_NAME('ONT','OE_PC_CANCEL_VIOLATION');
748: END IF;
749: FND_MESSAGE.SET_TOKEN('OBJECT',p_object_name);
750: ELSIF p_operation = OE_PC_GLOBALS.SPLIT_OP THEN
751: IF nvl(p_group_number,-1) = -1 THEN
752: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_NO_CONDN');
753: ELSE
754: FND_MESSAGE.SET_NAME('ONT','OE_PC_SPLIT_VIOLATION');

Line 815: IF l_operation = OE_PC_GLOBALS.CREATE_OP

811: and o.application_id = p_application_id
812: and a.database_object_name = o.database_object_name
813: and a.application_id = o.application_id;
814:
815: IF l_operation = OE_PC_GLOBALS.CREATE_OP
816: OR l_operation = OE_PC_GLOBALS.UPDATE_OP
817: THEN
818:
819: SELECT c.constrained_operation, c.column_name

Line 816: OR l_operation = OE_PC_GLOBALS.UPDATE_OP

812: and a.database_object_name = o.database_object_name
813: and a.application_id = o.application_id;
814:
815: IF l_operation = OE_PC_GLOBALS.CREATE_OP
816: OR l_operation = OE_PC_GLOBALS.UPDATE_OP
817: THEN
818:
819: SELECT c.constrained_operation, c.column_name
820: INTO l_operation, l_column_name

Line 879: l_reason := substr(l_reason||OE_PC_GLOBALS.NEWLINE||l_condn.msg,1,l_reason_length);

875: FOR l_condn IN CONDN LOOP
876: IF i = 0 THEN
877: l_reason := substr(l_condn.msg,1,l_reason_length);
878: ELSE
879: l_reason := substr(l_reason||OE_PC_GLOBALS.NEWLINE||l_condn.msg,1,l_reason_length);
880: END IF;
881: i := i+1;
882: END LOOP;
883: FND_MESSAGE.SET_TOKEN('REASON',l_reason);