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.ARI_SELF_REG_CONFIG dependencies on FUN_RULE_PUB

Line 84: FUN_RULE_PUB.SET_INSTANCE_CONTEXT('ARI_VALIDATE_SITE_ACCESS', 'AR', NULL, cust_site_org_id );

80: end if;
81:
82: IF(FUN_RULE_OBJECTS_PUB.rule_object_instance_exists(222,'ARI_VALIDATE_SITE_ACCESS', NULL,cust_site_org_id)) THEN
83:
84: FUN_RULE_PUB.SET_INSTANCE_CONTEXT('ARI_VALIDATE_SITE_ACCESS', 'AR', NULL, cust_site_org_id );
85: FUN_RULE_PUB.init_parameter_list;
86: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', p_customer_id);
87: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_SITE_USE_ID', p_customer_site_use_id);
88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');

Line 85: FUN_RULE_PUB.init_parameter_list;

81:
82: IF(FUN_RULE_OBJECTS_PUB.rule_object_instance_exists(222,'ARI_VALIDATE_SITE_ACCESS', NULL,cust_site_org_id)) THEN
83:
84: FUN_RULE_PUB.SET_INSTANCE_CONTEXT('ARI_VALIDATE_SITE_ACCESS', 'AR', NULL, cust_site_org_id );
85: FUN_RULE_PUB.init_parameter_list;
86: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', p_customer_id);
87: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_SITE_USE_ID', p_customer_site_use_id);
88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');
89:

Line 86: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', p_customer_id);

82: IF(FUN_RULE_OBJECTS_PUB.rule_object_instance_exists(222,'ARI_VALIDATE_SITE_ACCESS', NULL,cust_site_org_id)) THEN
83:
84: FUN_RULE_PUB.SET_INSTANCE_CONTEXT('ARI_VALIDATE_SITE_ACCESS', 'AR', NULL, cust_site_org_id );
85: FUN_RULE_PUB.init_parameter_list;
86: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', p_customer_id);
87: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_SITE_USE_ID', p_customer_site_use_id);
88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');
89:
90: -- begin added for bug 7713325

Line 87: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_SITE_USE_ID', p_customer_site_use_id);

83:
84: FUN_RULE_PUB.SET_INSTANCE_CONTEXT('ARI_VALIDATE_SITE_ACCESS', 'AR', NULL, cust_site_org_id );
85: FUN_RULE_PUB.init_parameter_list;
86: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', p_customer_id);
87: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_SITE_USE_ID', p_customer_site_use_id);
88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');
89:
90: -- begin added for bug 7713325
91:

Line 88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');

84: FUN_RULE_PUB.SET_INSTANCE_CONTEXT('ARI_VALIDATE_SITE_ACCESS', 'AR', NULL, cust_site_org_id );
85: FUN_RULE_PUB.init_parameter_list;
86: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', p_customer_id);
87: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_SITE_USE_ID', p_customer_site_use_id);
88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');
89:
90: -- begin added for bug 7713325
91:
92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN

Line 92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN

88: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_SITE_ACCESS');
89:
90: -- begin added for bug 7713325
91:
92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN
93:
94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);
95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:

Line 94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);

90: -- begin added for bug 7713325
91:
92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN
93:
94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);
95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:
97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:

Line 95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);

91:
92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN
93:
94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);
95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:
97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:
99: arp_standard.debug('l_answer :: '||l_answer);

Line 97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);

93:
94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);
95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:
97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:
99: arp_standard.debug('l_answer :: '||l_answer);
100:
101: x_verify_access(i).question := FUN_RULE_PUB.get_attribute15;

Line 101: x_verify_access(i).question := FUN_RULE_PUB.get_attribute15;

97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:
99: arp_standard.debug('l_answer :: '||l_answer);
100:
101: x_verify_access(i).question := FUN_RULE_PUB.get_attribute15;
102: x_verify_access(i).expected_answer := l_answer;
103:
104: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
105:

Line 110: IF (FUN_RULE_PUB.get_attribute10 is not null and FUN_RULE_PUB.get_attribute6 is not null) THEN -- to confirm that 2nd custom question is defined

106: i := i+1;
107:
108: END IF;
109:
110: IF (FUN_RULE_PUB.get_attribute10 is not null and FUN_RULE_PUB.get_attribute6 is not null) THEN -- to confirm that 2nd custom question is defined
111:
112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);
113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:

Line 112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);

108: END IF;
109:
110: IF (FUN_RULE_PUB.get_attribute10 is not null and FUN_RULE_PUB.get_attribute6 is not null) THEN -- to confirm that 2nd custom question is defined
111:
112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);
113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:
115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);
116:

Line 113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);

109:
110: IF (FUN_RULE_PUB.get_attribute10 is not null and FUN_RULE_PUB.get_attribute6 is not null) THEN -- to confirm that 2nd custom question is defined
111:
112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);
113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:
115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);
116:
117: x_verify_access(i).question := FUN_RULE_PUB.get_attribute10;

Line 115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);

111:
112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);
113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:
115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);
116:
117: x_verify_access(i).question := FUN_RULE_PUB.get_attribute10;
118: x_verify_access(i).expected_answer := l_answer;
119:

Line 117: x_verify_access(i).question := FUN_RULE_PUB.get_attribute10;

113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:
115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);
116:
117: x_verify_access(i).question := FUN_RULE_PUB.get_attribute10;
118: x_verify_access(i).expected_answer := l_answer;
119:
120: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
121:

Line 124: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN

120: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
121:
122: i := i+1;
123:
124: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN
125:
126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);

Line 126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined

122: i := i+1;
123:
124: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN
125:
126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);

Line 128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);

124: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN
125:
126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);
131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;

Line 129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);

125:
126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);
131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;
133: x_verify_access(i).expected_answer := l_answer;

Line 130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);

126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);
131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;
133: x_verify_access(i).expected_answer := l_answer;
134:

Line 132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;

128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);
131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;
133: x_verify_access(i).expected_answer := l_answer;
134:
135: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
136:

Line 139: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN

135: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
136:
137: i := i+1;
138:
139: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN
140:
141: -- end for bug 7713325
142:
143: IF (FUN_RULE_PUB.get_attribute1 is not null and FUN_RULE_PUB.get_attribute5 is null) THEN

Line 143: IF (FUN_RULE_PUB.get_attribute1 is not null and FUN_RULE_PUB.get_attribute5 is null) THEN

139: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN
140:
141: -- end for bug 7713325
142:
143: IF (FUN_RULE_PUB.get_attribute1 is not null and FUN_RULE_PUB.get_attribute5 is null) THEN
144: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
145: x_verify_access(i).expected_answer := FUN_RULE_PUB.get_attribute2;
146: i := i+1;
147: return;

Line 144: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;

140:
141: -- end for bug 7713325
142:
143: IF (FUN_RULE_PUB.get_attribute1 is not null and FUN_RULE_PUB.get_attribute5 is null) THEN
144: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
145: x_verify_access(i).expected_answer := FUN_RULE_PUB.get_attribute2;
146: i := i+1;
147: return;
148: END IF;

Line 145: x_verify_access(i).expected_answer := FUN_RULE_PUB.get_attribute2;

141: -- end for bug 7713325
142:
143: IF (FUN_RULE_PUB.get_attribute1 is not null and FUN_RULE_PUB.get_attribute5 is null) THEN
144: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
145: x_verify_access(i).expected_answer := FUN_RULE_PUB.get_attribute2;
146: i := i+1;
147: return;
148: END IF;
149:

Line 150: IF( FUN_RULE_PUB.get_attribute3 = 'Y' OR

146: i := i+1;
147: return;
148: END IF;
149:
150: IF( FUN_RULE_PUB.get_attribute3 = 'Y' OR
151: FUN_RULE_PUB.get_attribute5 = 'Y') THEN
152: BEGIN
153: --Select an open invoice
154: SELECT trx_number

Line 151: FUN_RULE_PUB.get_attribute5 = 'Y') THEN

147: return;
148: END IF;
149:
150: IF( FUN_RULE_PUB.get_attribute3 = 'Y' OR
151: FUN_RULE_PUB.get_attribute5 = 'Y') THEN
152: BEGIN
153: --Select an open invoice
154: SELECT trx_number
155: INTO l_trx_number

Line 187: IF ( FUN_RULE_PUB.get_attribute4 = 'Y' OR

183: END;
184: i := i+1;
185: END IF;
186: --Questions can be defined on payment too
187: IF ( FUN_RULE_PUB.get_attribute4 = 'Y' OR
188: FUN_RULE_PUB.get_attribute5 = 'Y' ) THEN
189: BEGIN
190: --Select a receipt at this customer site
191: SELECT receipt_number

Line 188: FUN_RULE_PUB.get_attribute5 = 'Y' ) THEN

184: i := i+1;
185: END IF;
186: --Questions can be defined on payment too
187: IF ( FUN_RULE_PUB.get_attribute4 = 'Y' OR
188: FUN_RULE_PUB.get_attribute5 = 'Y' ) THEN
189: BEGIN
190: --Select a receipt at this customer site
191: SELECT receipt_number
192: INTO l_receipt_number

Line 205: (FUN_RULE_PUB.get_attribute3 is null AND FUN_RULE_PUB.get_attribute5 is null) ) THEN

201: --Set this as another question in the 'x_verify_access' var
202: FND_MESSAGE.SET_NAME('AR', 'ARI_REG_VERIFY_ADDL_QUESTION');
203: FND_MESSAGE.SET_TOKEN('RECEIPT', l_receipt_number);
204: IF ( l_no_inv_flag OR
205: (FUN_RULE_PUB.get_attribute3 is null AND FUN_RULE_PUB.get_attribute5 is null) ) THEN
206: x_verify_access(i).question := FND_MESSAGE.get;
207: ELSE
208: x_verify_access(i).question := FND_MESSAGE.get;
209: END IF;

Line 222: (FUN_RULE_PUB.get_attribute3 is null AND FUN_RULE_PUB.get_attribute5 is null)) THEN

218: AND customer_site_use_id = nvl(p_customer_site_use_id,customer_site_use_id)
219: AND rownum = 1;
220:
221: IF ( l_no_inv_flag OR
222: (FUN_RULE_PUB.get_attribute3 is null AND FUN_RULE_PUB.get_attribute5 is null)) THEN
223: x_verify_access(i).expected_answer := l_temp;
224: ELSE
225: x_verify_access(i).expected_answer := l_temp;
226: END IF;

Line 280: FUN_RULE_PUB.init_parameter_list;

276: Customize this portion to specify the parameters for different
277: customers
278: */
279: arp_standard.debug('Begin procedure validate_cust_detail_access ');
280: FUN_RULE_PUB.init_parameter_list;
281: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', to_char(p_customer_id));
282: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_CUST_ACCESS');
283:
284: BEGIN

Line 281: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', to_char(p_customer_id));

277: customers
278: */
279: arp_standard.debug('Begin procedure validate_cust_detail_access ');
280: FUN_RULE_PUB.init_parameter_list;
281: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', to_char(p_customer_id));
282: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_CUST_ACCESS');
283:
284: BEGIN
285:

Line 282: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_CUST_ACCESS');

278: */
279: arp_standard.debug('Begin procedure validate_cust_detail_access ');
280: FUN_RULE_PUB.init_parameter_list;
281: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', to_char(p_customer_id));
282: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_CUST_ACCESS');
283:
284: BEGIN
285:
286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN

Line 286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN

282: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_CUST_ACCESS');
283:
284: BEGIN
285:
286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined
288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);

Line 287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined

283:
284: BEGIN
285:
286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined
288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:

Line 289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);

285:
286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined
288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);

Line 290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);

286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined
288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);
294:

Line 292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);

288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);
294:
295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
296: l_answer := FUN_RULE_PUB.get_attribute2;

Line 295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN

291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);
294:
295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
296: l_answer := FUN_RULE_PUB.get_attribute2;
297: arp_standard.debug('l_answer for static question '||l_answer);
298: END IF; --IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
299:

Line 296: l_answer := FUN_RULE_PUB.get_attribute2;

292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);
294:
295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
296: l_answer := FUN_RULE_PUB.get_attribute2;
297: arp_standard.debug('l_answer for static question '||l_answer);
298: END IF; --IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
299:
300: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;

Line 298: END IF; --IF (FUN_RULE_PUB.get_attribute5 is not null) THEN

294:
295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
296: l_answer := FUN_RULE_PUB.get_attribute2;
297: arp_standard.debug('l_answer for static question '||l_answer);
298: END IF; --IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
299:
300: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
301: x_verify_access(i).expected_answer := l_answer;
302:

Line 300: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;

296: l_answer := FUN_RULE_PUB.get_attribute2;
297: arp_standard.debug('l_answer for static question '||l_answer);
298: END IF; --IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
299:
300: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
301: x_verify_access(i).expected_answer := l_answer;
302:
303: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
304: i := i+1;

Line 306: END IF; --IF (FUN_RULE_PUB.get_attribute1 is not null) THEN

302:
303: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
304: i := i+1;
305:
306: END IF; --IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
307:
308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined
309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);

Line 308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined

304: i := i+1;
305:
306: END IF; --IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
307:
308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined
309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);
311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:

Line 310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);

306: END IF; --IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
307:
308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined
309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);
311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:
313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);
314:

Line 311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);

307:
308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined
309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);
311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:
313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);
314:
315: x_verify_access(i).question := FUN_RULE_PUB.get_attribute6;

Line 313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);

309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);
311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:
313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);
314:
315: x_verify_access(i).question := FUN_RULE_PUB.get_attribute6;
316: x_verify_access(i).expected_answer := l_answer;
317:

Line 315: x_verify_access(i).question := FUN_RULE_PUB.get_attribute6;

311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:
313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);
314:
315: x_verify_access(i).question := FUN_RULE_PUB.get_attribute6;
316: x_verify_access(i).expected_answer := l_answer;
317:
318: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
319:

Line 322: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN

318: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
319:
320: i := i+1;
321:
322: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN
323:
324:
325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined
326:

Line 325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined

321:
322: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN
323:
324:
325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined
326:
327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);
328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:

Line 327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);

323:
324:
325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined
326:
327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);
328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:
330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);
331:

Line 328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);

324:
325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined
326:
327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);
328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:
330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);
331:
332: x_verify_access(i).question := FUN_RULE_PUB.get_attribute11;

Line 330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);

326:
327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);
328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:
330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);
331:
332: x_verify_access(i).question := FUN_RULE_PUB.get_attribute11;
333: x_verify_access(i).expected_answer := l_answer;
334:

Line 332: x_verify_access(i).question := FUN_RULE_PUB.get_attribute11;

328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:
330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);
331:
332: x_verify_access(i).question := FUN_RULE_PUB.get_attribute11;
333: x_verify_access(i).expected_answer := l_answer;
334:
335: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
336:

Line 339: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN

335: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
336:
337: i := i+1;
338:
339: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN
340: --Modified for Bug# 13506129
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: arp_standard.debug('In Exception.. Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);