APPS.HZ_PARTY_INFO_V2PVT dependencies on FND_API

Line 25: x_credit_rating_rec.credit_rating_id := FND_API.G_MISS_NUM;

21:
22: BEGIN
23:
24: IF p_credit_rating_rec.credit_rating_id IS NULL THEN
25: x_credit_rating_rec.credit_rating_id := FND_API.G_MISS_NUM;
26: ELSIF p_credit_rating_rec.credit_rating_id <> FND_API.G_MISS_NUM THEN
27: x_credit_rating_rec.credit_rating_id := p_credit_rating_rec.credit_rating_id;
28: END IF;
29:

Line 26: ELSIF p_credit_rating_rec.credit_rating_id <> FND_API.G_MISS_NUM THEN

22: BEGIN
23:
24: IF p_credit_rating_rec.credit_rating_id IS NULL THEN
25: x_credit_rating_rec.credit_rating_id := FND_API.G_MISS_NUM;
26: ELSIF p_credit_rating_rec.credit_rating_id <> FND_API.G_MISS_NUM THEN
27: x_credit_rating_rec.credit_rating_id := p_credit_rating_rec.credit_rating_id;
28: END IF;
29:
30: IF p_credit_rating_rec.description IS NULL THEN

Line 31: x_credit_rating_rec.description := FND_API.G_MISS_CHAR;

27: x_credit_rating_rec.credit_rating_id := p_credit_rating_rec.credit_rating_id;
28: END IF;
29:
30: IF p_credit_rating_rec.description IS NULL THEN
31: x_credit_rating_rec.description := FND_API.G_MISS_CHAR;
32: ELSIF p_credit_rating_rec.description <> FND_API.G_MISS_CHAR THEN
33: x_credit_rating_rec.description := p_credit_rating_rec.description;
34: END IF;
35:

Line 32: ELSIF p_credit_rating_rec.description <> FND_API.G_MISS_CHAR THEN

28: END IF;
29:
30: IF p_credit_rating_rec.description IS NULL THEN
31: x_credit_rating_rec.description := FND_API.G_MISS_CHAR;
32: ELSIF p_credit_rating_rec.description <> FND_API.G_MISS_CHAR THEN
33: x_credit_rating_rec.description := p_credit_rating_rec.description;
34: END IF;
35:
36: IF p_credit_rating_rec.party_id IS NULL THEN

Line 37: x_credit_rating_rec.party_id := FND_API.G_MISS_NUM;

33: x_credit_rating_rec.description := p_credit_rating_rec.description;
34: END IF;
35:
36: IF p_credit_rating_rec.party_id IS NULL THEN
37: x_credit_rating_rec.party_id := FND_API.G_MISS_NUM;
38: ELSIF p_credit_rating_rec.party_id <> FND_API.G_MISS_NUM THEN
39: x_credit_rating_rec.party_id := p_credit_rating_rec.party_id;
40: END IF;
41:

Line 38: ELSIF p_credit_rating_rec.party_id <> FND_API.G_MISS_NUM THEN

34: END IF;
35:
36: IF p_credit_rating_rec.party_id IS NULL THEN
37: x_credit_rating_rec.party_id := FND_API.G_MISS_NUM;
38: ELSIF p_credit_rating_rec.party_id <> FND_API.G_MISS_NUM THEN
39: x_credit_rating_rec.party_id := p_credit_rating_rec.party_id;
40: END IF;
41:
42: IF p_credit_rating_rec.rating IS NULL THEN

Line 43: x_credit_rating_rec.rating := FND_API.G_MISS_CHAR;

39: x_credit_rating_rec.party_id := p_credit_rating_rec.party_id;
40: END IF;
41:
42: IF p_credit_rating_rec.rating IS NULL THEN
43: x_credit_rating_rec.rating := FND_API.G_MISS_CHAR;
44: ELSIF p_credit_rating_rec.rating <> FND_API.G_MISS_CHAR THEN
45: x_credit_rating_rec.rating := p_credit_rating_rec.rating;
46: END IF;
47:

Line 44: ELSIF p_credit_rating_rec.rating <> FND_API.G_MISS_CHAR THEN

40: END IF;
41:
42: IF p_credit_rating_rec.rating IS NULL THEN
43: x_credit_rating_rec.rating := FND_API.G_MISS_CHAR;
44: ELSIF p_credit_rating_rec.rating <> FND_API.G_MISS_CHAR THEN
45: x_credit_rating_rec.rating := p_credit_rating_rec.rating;
46: END IF;
47:
48: IF p_credit_rating_rec.rated_as_of_date IS NULL THEN

Line 49: x_credit_rating_rec.rated_as_of_date := FND_API.G_MISS_DATE;

45: x_credit_rating_rec.rating := p_credit_rating_rec.rating;
46: END IF;
47:
48: IF p_credit_rating_rec.rated_as_of_date IS NULL THEN
49: x_credit_rating_rec.rated_as_of_date := FND_API.G_MISS_DATE;
50: ELSIF p_credit_rating_rec.rated_as_of_date <> FND_API.G_MISS_DATE THEN
51: x_credit_rating_rec.rated_as_of_date := p_credit_rating_rec.rated_as_of_date;
52: END IF;
53:

Line 50: ELSIF p_credit_rating_rec.rated_as_of_date <> FND_API.G_MISS_DATE THEN

46: END IF;
47:
48: IF p_credit_rating_rec.rated_as_of_date IS NULL THEN
49: x_credit_rating_rec.rated_as_of_date := FND_API.G_MISS_DATE;
50: ELSIF p_credit_rating_rec.rated_as_of_date <> FND_API.G_MISS_DATE THEN
51: x_credit_rating_rec.rated_as_of_date := p_credit_rating_rec.rated_as_of_date;
52: END IF;
53:
54: IF p_credit_rating_rec.rating_organization IS NULL THEN

Line 55: x_credit_rating_rec.rating_organization := FND_API.G_MISS_CHAR;

51: x_credit_rating_rec.rated_as_of_date := p_credit_rating_rec.rated_as_of_date;
52: END IF;
53:
54: IF p_credit_rating_rec.rating_organization IS NULL THEN
55: x_credit_rating_rec.rating_organization := FND_API.G_MISS_CHAR;
56: ELSIF p_credit_rating_rec.rating_organization <> FND_API.G_MISS_CHAR THEN
57: x_credit_rating_rec.rating_organization := p_credit_rating_rec.rating_organization;
58: END IF;
59:

Line 56: ELSIF p_credit_rating_rec.rating_organization <> FND_API.G_MISS_CHAR THEN

52: END IF;
53:
54: IF p_credit_rating_rec.rating_organization IS NULL THEN
55: x_credit_rating_rec.rating_organization := FND_API.G_MISS_CHAR;
56: ELSIF p_credit_rating_rec.rating_organization <> FND_API.G_MISS_CHAR THEN
57: x_credit_rating_rec.rating_organization := p_credit_rating_rec.rating_organization;
58: END IF;
59:
60: IF p_credit_rating_rec.comments IS NULL THEN

Line 61: x_credit_rating_rec.comments := FND_API.G_MISS_CHAR;

57: x_credit_rating_rec.rating_organization := p_credit_rating_rec.rating_organization;
58: END IF;
59:
60: IF p_credit_rating_rec.comments IS NULL THEN
61: x_credit_rating_rec.comments := FND_API.G_MISS_CHAR;
62: ELSIF p_credit_rating_rec.comments <> FND_API.G_MISS_CHAR THEN
63: x_credit_rating_rec.comments := p_credit_rating_rec.comments;
64: END IF;
65:

Line 62: ELSIF p_credit_rating_rec.comments <> FND_API.G_MISS_CHAR THEN

58: END IF;
59:
60: IF p_credit_rating_rec.comments IS NULL THEN
61: x_credit_rating_rec.comments := FND_API.G_MISS_CHAR;
62: ELSIF p_credit_rating_rec.comments <> FND_API.G_MISS_CHAR THEN
63: x_credit_rating_rec.comments := p_credit_rating_rec.comments;
64: END IF;
65:
66: IF p_credit_rating_rec.det_history_ind IS NULL THEN

Line 67: x_credit_rating_rec.det_history_ind := FND_API.G_MISS_CHAR;

63: x_credit_rating_rec.comments := p_credit_rating_rec.comments;
64: END IF;
65:
66: IF p_credit_rating_rec.det_history_ind IS NULL THEN
67: x_credit_rating_rec.det_history_ind := FND_API.G_MISS_CHAR;
68: ELSIF p_credit_rating_rec.det_history_ind <> FND_API.G_MISS_CHAR THEN
69: x_credit_rating_rec.det_history_ind := p_credit_rating_rec.det_history_ind;
70: END IF;
71:

Line 68: ELSIF p_credit_rating_rec.det_history_ind <> FND_API.G_MISS_CHAR THEN

64: END IF;
65:
66: IF p_credit_rating_rec.det_history_ind IS NULL THEN
67: x_credit_rating_rec.det_history_ind := FND_API.G_MISS_CHAR;
68: ELSIF p_credit_rating_rec.det_history_ind <> FND_API.G_MISS_CHAR THEN
69: x_credit_rating_rec.det_history_ind := p_credit_rating_rec.det_history_ind;
70: END IF;
71:
72: IF p_credit_rating_rec.fincl_embt_ind IS NULL THEN

Line 73: x_credit_rating_rec.fincl_embt_ind := FND_API.G_MISS_CHAR;

69: x_credit_rating_rec.det_history_ind := p_credit_rating_rec.det_history_ind;
70: END IF;
71:
72: IF p_credit_rating_rec.fincl_embt_ind IS NULL THEN
73: x_credit_rating_rec.fincl_embt_ind := FND_API.G_MISS_CHAR;
74: ELSIF p_credit_rating_rec.fincl_embt_ind <> FND_API.G_MISS_CHAR THEN
75: x_credit_rating_rec.fincl_embt_ind := p_credit_rating_rec.fincl_embt_ind;
76: END IF;
77:

Line 74: ELSIF p_credit_rating_rec.fincl_embt_ind <> FND_API.G_MISS_CHAR THEN

70: END IF;
71:
72: IF p_credit_rating_rec.fincl_embt_ind IS NULL THEN
73: x_credit_rating_rec.fincl_embt_ind := FND_API.G_MISS_CHAR;
74: ELSIF p_credit_rating_rec.fincl_embt_ind <> FND_API.G_MISS_CHAR THEN
75: x_credit_rating_rec.fincl_embt_ind := p_credit_rating_rec.fincl_embt_ind;
76: END IF;
77:
78: IF p_credit_rating_rec.criminal_proceeding_ind IS NULL THEN

Line 79: x_credit_rating_rec.criminal_proceeding_ind := FND_API.G_MISS_CHAR;

75: x_credit_rating_rec.fincl_embt_ind := p_credit_rating_rec.fincl_embt_ind;
76: END IF;
77:
78: IF p_credit_rating_rec.criminal_proceeding_ind IS NULL THEN
79: x_credit_rating_rec.criminal_proceeding_ind := FND_API.G_MISS_CHAR;
80: ELSIF p_credit_rating_rec.criminal_proceeding_ind <> FND_API.G_MISS_CHAR THEN
81: x_credit_rating_rec.criminal_proceeding_ind := p_credit_rating_rec.criminal_proceeding_ind;
82: END IF;
83:

Line 80: ELSIF p_credit_rating_rec.criminal_proceeding_ind <> FND_API.G_MISS_CHAR THEN

76: END IF;
77:
78: IF p_credit_rating_rec.criminal_proceeding_ind IS NULL THEN
79: x_credit_rating_rec.criminal_proceeding_ind := FND_API.G_MISS_CHAR;
80: ELSIF p_credit_rating_rec.criminal_proceeding_ind <> FND_API.G_MISS_CHAR THEN
81: x_credit_rating_rec.criminal_proceeding_ind := p_credit_rating_rec.criminal_proceeding_ind;
82: END IF;
83:
84: IF p_credit_rating_rec.claims_ind IS NULL THEN

Line 85: x_credit_rating_rec.claims_ind := FND_API.G_MISS_CHAR;

81: x_credit_rating_rec.criminal_proceeding_ind := p_credit_rating_rec.criminal_proceeding_ind;
82: END IF;
83:
84: IF p_credit_rating_rec.claims_ind IS NULL THEN
85: x_credit_rating_rec.claims_ind := FND_API.G_MISS_CHAR;
86: ELSIF p_credit_rating_rec.claims_ind <> FND_API.G_MISS_CHAR THEN
87: x_credit_rating_rec.claims_ind := p_credit_rating_rec.claims_ind;
88: END IF;
89:

Line 86: ELSIF p_credit_rating_rec.claims_ind <> FND_API.G_MISS_CHAR THEN

82: END IF;
83:
84: IF p_credit_rating_rec.claims_ind IS NULL THEN
85: x_credit_rating_rec.claims_ind := FND_API.G_MISS_CHAR;
86: ELSIF p_credit_rating_rec.claims_ind <> FND_API.G_MISS_CHAR THEN
87: x_credit_rating_rec.claims_ind := p_credit_rating_rec.claims_ind;
88: END IF;
89:
90: IF p_credit_rating_rec.secured_flng_ind IS NULL THEN

Line 91: x_credit_rating_rec.secured_flng_ind := FND_API.G_MISS_CHAR;

87: x_credit_rating_rec.claims_ind := p_credit_rating_rec.claims_ind;
88: END IF;
89:
90: IF p_credit_rating_rec.secured_flng_ind IS NULL THEN
91: x_credit_rating_rec.secured_flng_ind := FND_API.G_MISS_CHAR;
92: ELSIF p_credit_rating_rec.secured_flng_ind <> FND_API.G_MISS_CHAR THEN
93: x_credit_rating_rec.secured_flng_ind := p_credit_rating_rec.secured_flng_ind;
94: END IF;
95:

Line 92: ELSIF p_credit_rating_rec.secured_flng_ind <> FND_API.G_MISS_CHAR THEN

88: END IF;
89:
90: IF p_credit_rating_rec.secured_flng_ind IS NULL THEN
91: x_credit_rating_rec.secured_flng_ind := FND_API.G_MISS_CHAR;
92: ELSIF p_credit_rating_rec.secured_flng_ind <> FND_API.G_MISS_CHAR THEN
93: x_credit_rating_rec.secured_flng_ind := p_credit_rating_rec.secured_flng_ind;
94: END IF;
95:
96: IF p_credit_rating_rec.fincl_lgl_event_ind IS NULL THEN

Line 97: x_credit_rating_rec.fincl_lgl_event_ind := FND_API.G_MISS_CHAR;

93: x_credit_rating_rec.secured_flng_ind := p_credit_rating_rec.secured_flng_ind;
94: END IF;
95:
96: IF p_credit_rating_rec.fincl_lgl_event_ind IS NULL THEN
97: x_credit_rating_rec.fincl_lgl_event_ind := FND_API.G_MISS_CHAR;
98: ELSIF p_credit_rating_rec.fincl_lgl_event_ind <> FND_API.G_MISS_CHAR THEN
99: x_credit_rating_rec.fincl_lgl_event_ind := p_credit_rating_rec.fincl_lgl_event_ind;
100: END IF;
101:

Line 98: ELSIF p_credit_rating_rec.fincl_lgl_event_ind <> FND_API.G_MISS_CHAR THEN

94: END IF;
95:
96: IF p_credit_rating_rec.fincl_lgl_event_ind IS NULL THEN
97: x_credit_rating_rec.fincl_lgl_event_ind := FND_API.G_MISS_CHAR;
98: ELSIF p_credit_rating_rec.fincl_lgl_event_ind <> FND_API.G_MISS_CHAR THEN
99: x_credit_rating_rec.fincl_lgl_event_ind := p_credit_rating_rec.fincl_lgl_event_ind;
100: END IF;
101:
102: IF p_credit_rating_rec.disaster_ind IS NULL THEN

Line 103: x_credit_rating_rec.disaster_ind := FND_API.G_MISS_CHAR;

99: x_credit_rating_rec.fincl_lgl_event_ind := p_credit_rating_rec.fincl_lgl_event_ind;
100: END IF;
101:
102: IF p_credit_rating_rec.disaster_ind IS NULL THEN
103: x_credit_rating_rec.disaster_ind := FND_API.G_MISS_CHAR;
104: ELSIF p_credit_rating_rec.disaster_ind <> FND_API.G_MISS_CHAR THEN
105: x_credit_rating_rec.disaster_ind := p_credit_rating_rec.disaster_ind;
106: END IF;
107:

Line 104: ELSIF p_credit_rating_rec.disaster_ind <> FND_API.G_MISS_CHAR THEN

100: END IF;
101:
102: IF p_credit_rating_rec.disaster_ind IS NULL THEN
103: x_credit_rating_rec.disaster_ind := FND_API.G_MISS_CHAR;
104: ELSIF p_credit_rating_rec.disaster_ind <> FND_API.G_MISS_CHAR THEN
105: x_credit_rating_rec.disaster_ind := p_credit_rating_rec.disaster_ind;
106: END IF;
107:
108: IF p_credit_rating_rec.oprg_spec_evnt_ind IS NULL THEN

Line 109: x_credit_rating_rec.oprg_spec_evnt_ind := FND_API.G_MISS_CHAR;

105: x_credit_rating_rec.disaster_ind := p_credit_rating_rec.disaster_ind;
106: END IF;
107:
108: IF p_credit_rating_rec.oprg_spec_evnt_ind IS NULL THEN
109: x_credit_rating_rec.oprg_spec_evnt_ind := FND_API.G_MISS_CHAR;
110: ELSIF p_credit_rating_rec.oprg_spec_evnt_ind <> FND_API.G_MISS_CHAR THEN
111: x_credit_rating_rec.oprg_spec_evnt_ind := p_credit_rating_rec.oprg_spec_evnt_ind;
112: END IF;
113:

Line 110: ELSIF p_credit_rating_rec.oprg_spec_evnt_ind <> FND_API.G_MISS_CHAR THEN

106: END IF;
107:
108: IF p_credit_rating_rec.oprg_spec_evnt_ind IS NULL THEN
109: x_credit_rating_rec.oprg_spec_evnt_ind := FND_API.G_MISS_CHAR;
110: ELSIF p_credit_rating_rec.oprg_spec_evnt_ind <> FND_API.G_MISS_CHAR THEN
111: x_credit_rating_rec.oprg_spec_evnt_ind := p_credit_rating_rec.oprg_spec_evnt_ind;
112: END IF;
113:
114: IF p_credit_rating_rec.other_spec_evnt_ind IS NULL THEN

Line 115: x_credit_rating_rec.other_spec_evnt_ind := FND_API.G_MISS_CHAR;

111: x_credit_rating_rec.oprg_spec_evnt_ind := p_credit_rating_rec.oprg_spec_evnt_ind;
112: END IF;
113:
114: IF p_credit_rating_rec.other_spec_evnt_ind IS NULL THEN
115: x_credit_rating_rec.other_spec_evnt_ind := FND_API.G_MISS_CHAR;
116: ELSIF p_credit_rating_rec.other_spec_evnt_ind <> FND_API.G_MISS_CHAR THEN
117: x_credit_rating_rec.other_spec_evnt_ind := p_credit_rating_rec.other_spec_evnt_ind;
118: END IF;
119:

Line 116: ELSIF p_credit_rating_rec.other_spec_evnt_ind <> FND_API.G_MISS_CHAR THEN

112: END IF;
113:
114: IF p_credit_rating_rec.other_spec_evnt_ind IS NULL THEN
115: x_credit_rating_rec.other_spec_evnt_ind := FND_API.G_MISS_CHAR;
116: ELSIF p_credit_rating_rec.other_spec_evnt_ind <> FND_API.G_MISS_CHAR THEN
117: x_credit_rating_rec.other_spec_evnt_ind := p_credit_rating_rec.other_spec_evnt_ind;
118: END IF;
119:
120: IF p_credit_rating_rec.status IS NULL THEN

Line 121: x_credit_rating_rec.status := FND_API.G_MISS_CHAR;

117: x_credit_rating_rec.other_spec_evnt_ind := p_credit_rating_rec.other_spec_evnt_ind;
118: END IF;
119:
120: IF p_credit_rating_rec.status IS NULL THEN
121: x_credit_rating_rec.status := FND_API.G_MISS_CHAR;
122: ELSIF p_credit_rating_rec.status <> FND_API.G_MISS_CHAR THEN
123: x_credit_rating_rec.status := p_credit_rating_rec.status;
124: END IF;
125:

Line 122: ELSIF p_credit_rating_rec.status <> FND_API.G_MISS_CHAR THEN

118: END IF;
119:
120: IF p_credit_rating_rec.status IS NULL THEN
121: x_credit_rating_rec.status := FND_API.G_MISS_CHAR;
122: ELSIF p_credit_rating_rec.status <> FND_API.G_MISS_CHAR THEN
123: x_credit_rating_rec.status := p_credit_rating_rec.status;
124: END IF;
125:
126: IF p_credit_rating_rec.avg_high_credit IS NULL THEN

Line 127: x_credit_rating_rec.avg_high_credit := FND_API.G_MISS_NUM;

123: x_credit_rating_rec.status := p_credit_rating_rec.status;
124: END IF;
125:
126: IF p_credit_rating_rec.avg_high_credit IS NULL THEN
127: x_credit_rating_rec.avg_high_credit := FND_API.G_MISS_NUM;
128: ELSIF p_credit_rating_rec.avg_high_credit <> FND_API.G_MISS_NUM THEN
129: x_credit_rating_rec.avg_high_credit := p_credit_rating_rec.avg_high_credit;
130: END IF;
131:

Line 128: ELSIF p_credit_rating_rec.avg_high_credit <> FND_API.G_MISS_NUM THEN

124: END IF;
125:
126: IF p_credit_rating_rec.avg_high_credit IS NULL THEN
127: x_credit_rating_rec.avg_high_credit := FND_API.G_MISS_NUM;
128: ELSIF p_credit_rating_rec.avg_high_credit <> FND_API.G_MISS_NUM THEN
129: x_credit_rating_rec.avg_high_credit := p_credit_rating_rec.avg_high_credit;
130: END IF;
131:
132: IF p_credit_rating_rec.credit_score IS NULL THEN

Line 133: x_credit_rating_rec.credit_score := FND_API.G_MISS_CHAR;

129: x_credit_rating_rec.avg_high_credit := p_credit_rating_rec.avg_high_credit;
130: END IF;
131:
132: IF p_credit_rating_rec.credit_score IS NULL THEN
133: x_credit_rating_rec.credit_score := FND_API.G_MISS_CHAR;
134: ELSIF p_credit_rating_rec.credit_score <> FND_API.G_MISS_CHAR THEN
135: x_credit_rating_rec.credit_score := p_credit_rating_rec.credit_score;
136: END IF;
137:

Line 134: ELSIF p_credit_rating_rec.credit_score <> FND_API.G_MISS_CHAR THEN

130: END IF;
131:
132: IF p_credit_rating_rec.credit_score IS NULL THEN
133: x_credit_rating_rec.credit_score := FND_API.G_MISS_CHAR;
134: ELSIF p_credit_rating_rec.credit_score <> FND_API.G_MISS_CHAR THEN
135: x_credit_rating_rec.credit_score := p_credit_rating_rec.credit_score;
136: END IF;
137:
138: IF p_credit_rating_rec.credit_score_age IS NULL THEN

Line 139: x_credit_rating_rec.credit_score_age := FND_API.G_MISS_NUM;

135: x_credit_rating_rec.credit_score := p_credit_rating_rec.credit_score;
136: END IF;
137:
138: IF p_credit_rating_rec.credit_score_age IS NULL THEN
139: x_credit_rating_rec.credit_score_age := FND_API.G_MISS_NUM;
140: ELSIF p_credit_rating_rec.credit_score_age <> FND_API.G_MISS_NUM THEN
141: x_credit_rating_rec.credit_score_age := p_credit_rating_rec.credit_score_age;
142: END IF;
143:

Line 140: ELSIF p_credit_rating_rec.credit_score_age <> FND_API.G_MISS_NUM THEN

136: END IF;
137:
138: IF p_credit_rating_rec.credit_score_age IS NULL THEN
139: x_credit_rating_rec.credit_score_age := FND_API.G_MISS_NUM;
140: ELSIF p_credit_rating_rec.credit_score_age <> FND_API.G_MISS_NUM THEN
141: x_credit_rating_rec.credit_score_age := p_credit_rating_rec.credit_score_age;
142: END IF;
143:
144: IF p_credit_rating_rec.credit_score_class IS NULL THEN

Line 145: x_credit_rating_rec.credit_score_class := FND_API.G_MISS_NUM;

141: x_credit_rating_rec.credit_score_age := p_credit_rating_rec.credit_score_age;
142: END IF;
143:
144: IF p_credit_rating_rec.credit_score_class IS NULL THEN
145: x_credit_rating_rec.credit_score_class := FND_API.G_MISS_NUM;
146: ELSIF p_credit_rating_rec.credit_score_class <> FND_API.G_MISS_NUM THEN
147: x_credit_rating_rec.credit_score_class := p_credit_rating_rec.credit_score_class;
148: END IF;
149:

Line 146: ELSIF p_credit_rating_rec.credit_score_class <> FND_API.G_MISS_NUM THEN

142: END IF;
143:
144: IF p_credit_rating_rec.credit_score_class IS NULL THEN
145: x_credit_rating_rec.credit_score_class := FND_API.G_MISS_NUM;
146: ELSIF p_credit_rating_rec.credit_score_class <> FND_API.G_MISS_NUM THEN
147: x_credit_rating_rec.credit_score_class := p_credit_rating_rec.credit_score_class;
148: END IF;
149:
150: IF p_credit_rating_rec.credit_score_commentary IS NULL THEN

Line 151: x_credit_rating_rec.credit_score_commentary := FND_API.G_MISS_CHAR;

147: x_credit_rating_rec.credit_score_class := p_credit_rating_rec.credit_score_class;
148: END IF;
149:
150: IF p_credit_rating_rec.credit_score_commentary IS NULL THEN
151: x_credit_rating_rec.credit_score_commentary := FND_API.G_MISS_CHAR;
152: ELSIF p_credit_rating_rec.credit_score_commentary <> FND_API.G_MISS_CHAR THEN
153: x_credit_rating_rec.credit_score_commentary := p_credit_rating_rec.credit_score_commentary;
154: END IF;
155:

Line 152: ELSIF p_credit_rating_rec.credit_score_commentary <> FND_API.G_MISS_CHAR THEN

148: END IF;
149:
150: IF p_credit_rating_rec.credit_score_commentary IS NULL THEN
151: x_credit_rating_rec.credit_score_commentary := FND_API.G_MISS_CHAR;
152: ELSIF p_credit_rating_rec.credit_score_commentary <> FND_API.G_MISS_CHAR THEN
153: x_credit_rating_rec.credit_score_commentary := p_credit_rating_rec.credit_score_commentary;
154: END IF;
155:
156: IF p_credit_rating_rec.credit_score_commentary2 IS NULL THEN

Line 157: x_credit_rating_rec.credit_score_commentary2 := FND_API.G_MISS_CHAR;

153: x_credit_rating_rec.credit_score_commentary := p_credit_rating_rec.credit_score_commentary;
154: END IF;
155:
156: IF p_credit_rating_rec.credit_score_commentary2 IS NULL THEN
157: x_credit_rating_rec.credit_score_commentary2 := FND_API.G_MISS_CHAR;
158: ELSIF p_credit_rating_rec.credit_score_commentary2 <> FND_API.G_MISS_CHAR THEN
159: x_credit_rating_rec.credit_score_commentary2 := p_credit_rating_rec.credit_score_commentary2;
160: END IF;
161:

Line 158: ELSIF p_credit_rating_rec.credit_score_commentary2 <> FND_API.G_MISS_CHAR THEN

154: END IF;
155:
156: IF p_credit_rating_rec.credit_score_commentary2 IS NULL THEN
157: x_credit_rating_rec.credit_score_commentary2 := FND_API.G_MISS_CHAR;
158: ELSIF p_credit_rating_rec.credit_score_commentary2 <> FND_API.G_MISS_CHAR THEN
159: x_credit_rating_rec.credit_score_commentary2 := p_credit_rating_rec.credit_score_commentary2;
160: END IF;
161:
162: IF p_credit_rating_rec.credit_score_commentary3 IS NULL THEN

Line 163: x_credit_rating_rec.credit_score_commentary3 := FND_API.G_MISS_CHAR;

159: x_credit_rating_rec.credit_score_commentary2 := p_credit_rating_rec.credit_score_commentary2;
160: END IF;
161:
162: IF p_credit_rating_rec.credit_score_commentary3 IS NULL THEN
163: x_credit_rating_rec.credit_score_commentary3 := FND_API.G_MISS_CHAR;
164: ELSIF p_credit_rating_rec.credit_score_commentary3 <> FND_API.G_MISS_CHAR THEN
165: x_credit_rating_rec.credit_score_commentary3 := p_credit_rating_rec.credit_score_commentary3;
166: END IF;
167:

Line 164: ELSIF p_credit_rating_rec.credit_score_commentary3 <> FND_API.G_MISS_CHAR THEN

160: END IF;
161:
162: IF p_credit_rating_rec.credit_score_commentary3 IS NULL THEN
163: x_credit_rating_rec.credit_score_commentary3 := FND_API.G_MISS_CHAR;
164: ELSIF p_credit_rating_rec.credit_score_commentary3 <> FND_API.G_MISS_CHAR THEN
165: x_credit_rating_rec.credit_score_commentary3 := p_credit_rating_rec.credit_score_commentary3;
166: END IF;
167:
168: IF p_credit_rating_rec.credit_score_commentary4 IS NULL THEN

Line 169: x_credit_rating_rec.credit_score_commentary4 := FND_API.G_MISS_CHAR;

165: x_credit_rating_rec.credit_score_commentary3 := p_credit_rating_rec.credit_score_commentary3;
166: END IF;
167:
168: IF p_credit_rating_rec.credit_score_commentary4 IS NULL THEN
169: x_credit_rating_rec.credit_score_commentary4 := FND_API.G_MISS_CHAR;
170: ELSIF p_credit_rating_rec.credit_score_commentary4 <> FND_API.G_MISS_CHAR THEN
171: x_credit_rating_rec.credit_score_commentary4 := p_credit_rating_rec.credit_score_commentary4;
172: END IF;
173:

Line 170: ELSIF p_credit_rating_rec.credit_score_commentary4 <> FND_API.G_MISS_CHAR THEN

166: END IF;
167:
168: IF p_credit_rating_rec.credit_score_commentary4 IS NULL THEN
169: x_credit_rating_rec.credit_score_commentary4 := FND_API.G_MISS_CHAR;
170: ELSIF p_credit_rating_rec.credit_score_commentary4 <> FND_API.G_MISS_CHAR THEN
171: x_credit_rating_rec.credit_score_commentary4 := p_credit_rating_rec.credit_score_commentary4;
172: END IF;
173:
174: IF p_credit_rating_rec.credit_score_commentary5 IS NULL THEN

Line 175: x_credit_rating_rec.credit_score_commentary5 := FND_API.G_MISS_CHAR;

171: x_credit_rating_rec.credit_score_commentary4 := p_credit_rating_rec.credit_score_commentary4;
172: END IF;
173:
174: IF p_credit_rating_rec.credit_score_commentary5 IS NULL THEN
175: x_credit_rating_rec.credit_score_commentary5 := FND_API.G_MISS_CHAR;
176: ELSIF p_credit_rating_rec.credit_score_commentary5 <> FND_API.G_MISS_CHAR THEN
177: x_credit_rating_rec.credit_score_commentary5 := p_credit_rating_rec.credit_score_commentary5;
178: END IF;
179:

Line 176: ELSIF p_credit_rating_rec.credit_score_commentary5 <> FND_API.G_MISS_CHAR THEN

172: END IF;
173:
174: IF p_credit_rating_rec.credit_score_commentary5 IS NULL THEN
175: x_credit_rating_rec.credit_score_commentary5 := FND_API.G_MISS_CHAR;
176: ELSIF p_credit_rating_rec.credit_score_commentary5 <> FND_API.G_MISS_CHAR THEN
177: x_credit_rating_rec.credit_score_commentary5 := p_credit_rating_rec.credit_score_commentary5;
178: END IF;
179:
180: IF p_credit_rating_rec.credit_score_commentary6 IS NULL THEN

Line 181: x_credit_rating_rec.credit_score_commentary6 := FND_API.G_MISS_CHAR;

177: x_credit_rating_rec.credit_score_commentary5 := p_credit_rating_rec.credit_score_commentary5;
178: END IF;
179:
180: IF p_credit_rating_rec.credit_score_commentary6 IS NULL THEN
181: x_credit_rating_rec.credit_score_commentary6 := FND_API.G_MISS_CHAR;
182: ELSIF p_credit_rating_rec.credit_score_commentary6 <> FND_API.G_MISS_CHAR THEN
183: x_credit_rating_rec.credit_score_commentary6 := p_credit_rating_rec.credit_score_commentary6;
184: END IF;
185:

Line 182: ELSIF p_credit_rating_rec.credit_score_commentary6 <> FND_API.G_MISS_CHAR THEN

178: END IF;
179:
180: IF p_credit_rating_rec.credit_score_commentary6 IS NULL THEN
181: x_credit_rating_rec.credit_score_commentary6 := FND_API.G_MISS_CHAR;
182: ELSIF p_credit_rating_rec.credit_score_commentary6 <> FND_API.G_MISS_CHAR THEN
183: x_credit_rating_rec.credit_score_commentary6 := p_credit_rating_rec.credit_score_commentary6;
184: END IF;
185:
186: IF p_credit_rating_rec.credit_score_commentary7 IS NULL THEN

Line 187: x_credit_rating_rec.credit_score_commentary7 := FND_API.G_MISS_CHAR;

183: x_credit_rating_rec.credit_score_commentary6 := p_credit_rating_rec.credit_score_commentary6;
184: END IF;
185:
186: IF p_credit_rating_rec.credit_score_commentary7 IS NULL THEN
187: x_credit_rating_rec.credit_score_commentary7 := FND_API.G_MISS_CHAR;
188: ELSIF p_credit_rating_rec.credit_score_commentary7 <> FND_API.G_MISS_CHAR THEN
189: x_credit_rating_rec.credit_score_commentary7 := p_credit_rating_rec.credit_score_commentary7;
190: END IF;
191:

Line 188: ELSIF p_credit_rating_rec.credit_score_commentary7 <> FND_API.G_MISS_CHAR THEN

184: END IF;
185:
186: IF p_credit_rating_rec.credit_score_commentary7 IS NULL THEN
187: x_credit_rating_rec.credit_score_commentary7 := FND_API.G_MISS_CHAR;
188: ELSIF p_credit_rating_rec.credit_score_commentary7 <> FND_API.G_MISS_CHAR THEN
189: x_credit_rating_rec.credit_score_commentary7 := p_credit_rating_rec.credit_score_commentary7;
190: END IF;
191:
192: IF p_credit_rating_rec.credit_score_commentary8 IS NULL THEN

Line 193: x_credit_rating_rec.credit_score_commentary8 := FND_API.G_MISS_CHAR;

189: x_credit_rating_rec.credit_score_commentary7 := p_credit_rating_rec.credit_score_commentary7;
190: END IF;
191:
192: IF p_credit_rating_rec.credit_score_commentary8 IS NULL THEN
193: x_credit_rating_rec.credit_score_commentary8 := FND_API.G_MISS_CHAR;
194: ELSIF p_credit_rating_rec.credit_score_commentary8 <> FND_API.G_MISS_CHAR THEN
195: x_credit_rating_rec.credit_score_commentary8 := p_credit_rating_rec.credit_score_commentary8;
196: END IF;
197:

Line 194: ELSIF p_credit_rating_rec.credit_score_commentary8 <> FND_API.G_MISS_CHAR THEN

190: END IF;
191:
192: IF p_credit_rating_rec.credit_score_commentary8 IS NULL THEN
193: x_credit_rating_rec.credit_score_commentary8 := FND_API.G_MISS_CHAR;
194: ELSIF p_credit_rating_rec.credit_score_commentary8 <> FND_API.G_MISS_CHAR THEN
195: x_credit_rating_rec.credit_score_commentary8 := p_credit_rating_rec.credit_score_commentary8;
196: END IF;
197:
198: IF p_credit_rating_rec.credit_score_commentary9 IS NULL THEN

Line 199: x_credit_rating_rec.credit_score_commentary9 := FND_API.G_MISS_CHAR;

195: x_credit_rating_rec.credit_score_commentary8 := p_credit_rating_rec.credit_score_commentary8;
196: END IF;
197:
198: IF p_credit_rating_rec.credit_score_commentary9 IS NULL THEN
199: x_credit_rating_rec.credit_score_commentary9 := FND_API.G_MISS_CHAR;
200: ELSIF p_credit_rating_rec.credit_score_commentary9 <> FND_API.G_MISS_CHAR THEN
201: x_credit_rating_rec.credit_score_commentary9 := p_credit_rating_rec.credit_score_commentary9;
202: END IF;
203:

Line 200: ELSIF p_credit_rating_rec.credit_score_commentary9 <> FND_API.G_MISS_CHAR THEN

196: END IF;
197:
198: IF p_credit_rating_rec.credit_score_commentary9 IS NULL THEN
199: x_credit_rating_rec.credit_score_commentary9 := FND_API.G_MISS_CHAR;
200: ELSIF p_credit_rating_rec.credit_score_commentary9 <> FND_API.G_MISS_CHAR THEN
201: x_credit_rating_rec.credit_score_commentary9 := p_credit_rating_rec.credit_score_commentary9;
202: END IF;
203:
204: IF p_credit_rating_rec.credit_score_commentary10 IS NULL THEN

Line 205: x_credit_rating_rec.credit_score_commentary10 := FND_API.G_MISS_CHAR;

201: x_credit_rating_rec.credit_score_commentary9 := p_credit_rating_rec.credit_score_commentary9;
202: END IF;
203:
204: IF p_credit_rating_rec.credit_score_commentary10 IS NULL THEN
205: x_credit_rating_rec.credit_score_commentary10 := FND_API.G_MISS_CHAR;
206: ELSIF p_credit_rating_rec.credit_score_commentary10 <> FND_API.G_MISS_CHAR THEN
207: x_credit_rating_rec.credit_score_commentary10 := p_credit_rating_rec.credit_score_commentary10;
208: END IF;
209:

Line 206: ELSIF p_credit_rating_rec.credit_score_commentary10 <> FND_API.G_MISS_CHAR THEN

202: END IF;
203:
204: IF p_credit_rating_rec.credit_score_commentary10 IS NULL THEN
205: x_credit_rating_rec.credit_score_commentary10 := FND_API.G_MISS_CHAR;
206: ELSIF p_credit_rating_rec.credit_score_commentary10 <> FND_API.G_MISS_CHAR THEN
207: x_credit_rating_rec.credit_score_commentary10 := p_credit_rating_rec.credit_score_commentary10;
208: END IF;
209:
210: IF p_credit_rating_rec.credit_score_date IS NULL THEN

Line 211: x_credit_rating_rec.credit_score_date := FND_API.G_MISS_DATE;

207: x_credit_rating_rec.credit_score_commentary10 := p_credit_rating_rec.credit_score_commentary10;
208: END IF;
209:
210: IF p_credit_rating_rec.credit_score_date IS NULL THEN
211: x_credit_rating_rec.credit_score_date := FND_API.G_MISS_DATE;
212: ELSIF p_credit_rating_rec.credit_score_date <> FND_API.G_MISS_DATE THEN
213: x_credit_rating_rec.credit_score_date := p_credit_rating_rec.credit_score_date;
214: END IF;
215:

Line 212: ELSIF p_credit_rating_rec.credit_score_date <> FND_API.G_MISS_DATE THEN

208: END IF;
209:
210: IF p_credit_rating_rec.credit_score_date IS NULL THEN
211: x_credit_rating_rec.credit_score_date := FND_API.G_MISS_DATE;
212: ELSIF p_credit_rating_rec.credit_score_date <> FND_API.G_MISS_DATE THEN
213: x_credit_rating_rec.credit_score_date := p_credit_rating_rec.credit_score_date;
214: END IF;
215:
216: IF p_credit_rating_rec.credit_score_incd_default IS NULL THEN

Line 217: x_credit_rating_rec.credit_score_incd_default := FND_API.G_MISS_NUM;

213: x_credit_rating_rec.credit_score_date := p_credit_rating_rec.credit_score_date;
214: END IF;
215:
216: IF p_credit_rating_rec.credit_score_incd_default IS NULL THEN
217: x_credit_rating_rec.credit_score_incd_default := FND_API.G_MISS_NUM;
218: ELSIF p_credit_rating_rec.credit_score_incd_default <> FND_API.G_MISS_NUM THEN
219: x_credit_rating_rec.credit_score_incd_default := p_credit_rating_rec.credit_score_incd_default;
220: END IF;
221:

Line 218: ELSIF p_credit_rating_rec.credit_score_incd_default <> FND_API.G_MISS_NUM THEN

214: END IF;
215:
216: IF p_credit_rating_rec.credit_score_incd_default IS NULL THEN
217: x_credit_rating_rec.credit_score_incd_default := FND_API.G_MISS_NUM;
218: ELSIF p_credit_rating_rec.credit_score_incd_default <> FND_API.G_MISS_NUM THEN
219: x_credit_rating_rec.credit_score_incd_default := p_credit_rating_rec.credit_score_incd_default;
220: END IF;
221:
222: IF p_credit_rating_rec.credit_score_natl_percentile IS NULL THEN

Line 223: x_credit_rating_rec.credit_score_natl_percentile := FND_API.G_MISS_NUM;

219: x_credit_rating_rec.credit_score_incd_default := p_credit_rating_rec.credit_score_incd_default;
220: END IF;
221:
222: IF p_credit_rating_rec.credit_score_natl_percentile IS NULL THEN
223: x_credit_rating_rec.credit_score_natl_percentile := FND_API.G_MISS_NUM;
224: ELSIF p_credit_rating_rec.credit_score_natl_percentile <> FND_API.G_MISS_NUM THEN
225: x_credit_rating_rec.credit_score_natl_percentile := p_credit_rating_rec.credit_score_natl_percentile;
226: END IF;
227:

Line 224: ELSIF p_credit_rating_rec.credit_score_natl_percentile <> FND_API.G_MISS_NUM THEN

220: END IF;
221:
222: IF p_credit_rating_rec.credit_score_natl_percentile IS NULL THEN
223: x_credit_rating_rec.credit_score_natl_percentile := FND_API.G_MISS_NUM;
224: ELSIF p_credit_rating_rec.credit_score_natl_percentile <> FND_API.G_MISS_NUM THEN
225: x_credit_rating_rec.credit_score_natl_percentile := p_credit_rating_rec.credit_score_natl_percentile;
226: END IF;
227:
228: IF p_credit_rating_rec.failure_score IS NULL THEN

Line 229: x_credit_rating_rec.failure_score := FND_API.G_MISS_CHAR;

225: x_credit_rating_rec.credit_score_natl_percentile := p_credit_rating_rec.credit_score_natl_percentile;
226: END IF;
227:
228: IF p_credit_rating_rec.failure_score IS NULL THEN
229: x_credit_rating_rec.failure_score := FND_API.G_MISS_CHAR;
230: ELSIF p_credit_rating_rec.failure_score <> FND_API.G_MISS_CHAR THEN
231: x_credit_rating_rec.failure_score := p_credit_rating_rec.failure_score;
232: END IF;
233:

Line 230: ELSIF p_credit_rating_rec.failure_score <> FND_API.G_MISS_CHAR THEN

226: END IF;
227:
228: IF p_credit_rating_rec.failure_score IS NULL THEN
229: x_credit_rating_rec.failure_score := FND_API.G_MISS_CHAR;
230: ELSIF p_credit_rating_rec.failure_score <> FND_API.G_MISS_CHAR THEN
231: x_credit_rating_rec.failure_score := p_credit_rating_rec.failure_score;
232: END IF;
233:
234: IF p_credit_rating_rec.failure_score_age IS NULL THEN

Line 235: x_credit_rating_rec.failure_score_age := FND_API.G_MISS_NUM;

231: x_credit_rating_rec.failure_score := p_credit_rating_rec.failure_score;
232: END IF;
233:
234: IF p_credit_rating_rec.failure_score_age IS NULL THEN
235: x_credit_rating_rec.failure_score_age := FND_API.G_MISS_NUM;
236: ELSIF p_credit_rating_rec.failure_score_age <> FND_API.G_MISS_NUM THEN
237: x_credit_rating_rec.failure_score_age := p_credit_rating_rec.failure_score_age;
238: END IF;
239:

Line 236: ELSIF p_credit_rating_rec.failure_score_age <> FND_API.G_MISS_NUM THEN

232: END IF;
233:
234: IF p_credit_rating_rec.failure_score_age IS NULL THEN
235: x_credit_rating_rec.failure_score_age := FND_API.G_MISS_NUM;
236: ELSIF p_credit_rating_rec.failure_score_age <> FND_API.G_MISS_NUM THEN
237: x_credit_rating_rec.failure_score_age := p_credit_rating_rec.failure_score_age;
238: END IF;
239:
240: IF p_credit_rating_rec.failure_score_class IS NULL THEN

Line 241: x_credit_rating_rec.failure_score_class := FND_API.G_MISS_NUM;

237: x_credit_rating_rec.failure_score_age := p_credit_rating_rec.failure_score_age;
238: END IF;
239:
240: IF p_credit_rating_rec.failure_score_class IS NULL THEN
241: x_credit_rating_rec.failure_score_class := FND_API.G_MISS_NUM;
242: ELSIF p_credit_rating_rec.failure_score_class <> FND_API.G_MISS_NUM THEN
243: x_credit_rating_rec.failure_score_class := p_credit_rating_rec.failure_score_class;
244: END IF;
245:

Line 242: ELSIF p_credit_rating_rec.failure_score_class <> FND_API.G_MISS_NUM THEN

238: END IF;
239:
240: IF p_credit_rating_rec.failure_score_class IS NULL THEN
241: x_credit_rating_rec.failure_score_class := FND_API.G_MISS_NUM;
242: ELSIF p_credit_rating_rec.failure_score_class <> FND_API.G_MISS_NUM THEN
243: x_credit_rating_rec.failure_score_class := p_credit_rating_rec.failure_score_class;
244: END IF;
245:
246: IF p_credit_rating_rec.failure_score_commentary IS NULL THEN

Line 247: x_credit_rating_rec.failure_score_commentary := FND_API.G_MISS_CHAR;

243: x_credit_rating_rec.failure_score_class := p_credit_rating_rec.failure_score_class;
244: END IF;
245:
246: IF p_credit_rating_rec.failure_score_commentary IS NULL THEN
247: x_credit_rating_rec.failure_score_commentary := FND_API.G_MISS_CHAR;
248: ELSIF p_credit_rating_rec.failure_score_commentary <> FND_API.G_MISS_CHAR THEN
249: x_credit_rating_rec.failure_score_commentary := p_credit_rating_rec.failure_score_commentary;
250: END IF;
251:

Line 248: ELSIF p_credit_rating_rec.failure_score_commentary <> FND_API.G_MISS_CHAR THEN

244: END IF;
245:
246: IF p_credit_rating_rec.failure_score_commentary IS NULL THEN
247: x_credit_rating_rec.failure_score_commentary := FND_API.G_MISS_CHAR;
248: ELSIF p_credit_rating_rec.failure_score_commentary <> FND_API.G_MISS_CHAR THEN
249: x_credit_rating_rec.failure_score_commentary := p_credit_rating_rec.failure_score_commentary;
250: END IF;
251:
252: IF p_credit_rating_rec.failure_score_commentary2 IS NULL THEN

Line 253: x_credit_rating_rec.failure_score_commentary2 := FND_API.G_MISS_CHAR;

249: x_credit_rating_rec.failure_score_commentary := p_credit_rating_rec.failure_score_commentary;
250: END IF;
251:
252: IF p_credit_rating_rec.failure_score_commentary2 IS NULL THEN
253: x_credit_rating_rec.failure_score_commentary2 := FND_API.G_MISS_CHAR;
254: ELSIF p_credit_rating_rec.failure_score_commentary2 <> FND_API.G_MISS_CHAR THEN
255: x_credit_rating_rec.failure_score_commentary2 := p_credit_rating_rec.failure_score_commentary2;
256: END IF;
257:

Line 254: ELSIF p_credit_rating_rec.failure_score_commentary2 <> FND_API.G_MISS_CHAR THEN

250: END IF;
251:
252: IF p_credit_rating_rec.failure_score_commentary2 IS NULL THEN
253: x_credit_rating_rec.failure_score_commentary2 := FND_API.G_MISS_CHAR;
254: ELSIF p_credit_rating_rec.failure_score_commentary2 <> FND_API.G_MISS_CHAR THEN
255: x_credit_rating_rec.failure_score_commentary2 := p_credit_rating_rec.failure_score_commentary2;
256: END IF;
257:
258: IF p_credit_rating_rec.failure_score_commentary3 IS NULL THEN

Line 259: x_credit_rating_rec.failure_score_commentary3 := FND_API.G_MISS_CHAR;

255: x_credit_rating_rec.failure_score_commentary2 := p_credit_rating_rec.failure_score_commentary2;
256: END IF;
257:
258: IF p_credit_rating_rec.failure_score_commentary3 IS NULL THEN
259: x_credit_rating_rec.failure_score_commentary3 := FND_API.G_MISS_CHAR;
260: ELSIF p_credit_rating_rec.failure_score_commentary3 <> FND_API.G_MISS_CHAR THEN
261: x_credit_rating_rec.failure_score_commentary3 := p_credit_rating_rec.failure_score_commentary3;
262: END IF;
263:

Line 260: ELSIF p_credit_rating_rec.failure_score_commentary3 <> FND_API.G_MISS_CHAR THEN

256: END IF;
257:
258: IF p_credit_rating_rec.failure_score_commentary3 IS NULL THEN
259: x_credit_rating_rec.failure_score_commentary3 := FND_API.G_MISS_CHAR;
260: ELSIF p_credit_rating_rec.failure_score_commentary3 <> FND_API.G_MISS_CHAR THEN
261: x_credit_rating_rec.failure_score_commentary3 := p_credit_rating_rec.failure_score_commentary3;
262: END IF;
263:
264: IF p_credit_rating_rec.failure_score_commentary4 IS NULL THEN

Line 265: x_credit_rating_rec.failure_score_commentary4 := FND_API.G_MISS_CHAR;

261: x_credit_rating_rec.failure_score_commentary3 := p_credit_rating_rec.failure_score_commentary3;
262: END IF;
263:
264: IF p_credit_rating_rec.failure_score_commentary4 IS NULL THEN
265: x_credit_rating_rec.failure_score_commentary4 := FND_API.G_MISS_CHAR;
266: ELSIF p_credit_rating_rec.failure_score_commentary4 <> FND_API.G_MISS_CHAR THEN
267: x_credit_rating_rec.failure_score_commentary4 := p_credit_rating_rec.failure_score_commentary4;
268: END IF;
269:

Line 266: ELSIF p_credit_rating_rec.failure_score_commentary4 <> FND_API.G_MISS_CHAR THEN

262: END IF;
263:
264: IF p_credit_rating_rec.failure_score_commentary4 IS NULL THEN
265: x_credit_rating_rec.failure_score_commentary4 := FND_API.G_MISS_CHAR;
266: ELSIF p_credit_rating_rec.failure_score_commentary4 <> FND_API.G_MISS_CHAR THEN
267: x_credit_rating_rec.failure_score_commentary4 := p_credit_rating_rec.failure_score_commentary4;
268: END IF;
269:
270: IF p_credit_rating_rec.failure_score_commentary5 IS NULL THEN

Line 271: x_credit_rating_rec.failure_score_commentary5 := FND_API.G_MISS_CHAR;

267: x_credit_rating_rec.failure_score_commentary4 := p_credit_rating_rec.failure_score_commentary4;
268: END IF;
269:
270: IF p_credit_rating_rec.failure_score_commentary5 IS NULL THEN
271: x_credit_rating_rec.failure_score_commentary5 := FND_API.G_MISS_CHAR;
272: ELSIF p_credit_rating_rec.failure_score_commentary5 <> FND_API.G_MISS_CHAR THEN
273: x_credit_rating_rec.failure_score_commentary5 := p_credit_rating_rec.failure_score_commentary5;
274: END IF;
275:

Line 272: ELSIF p_credit_rating_rec.failure_score_commentary5 <> FND_API.G_MISS_CHAR THEN

268: END IF;
269:
270: IF p_credit_rating_rec.failure_score_commentary5 IS NULL THEN
271: x_credit_rating_rec.failure_score_commentary5 := FND_API.G_MISS_CHAR;
272: ELSIF p_credit_rating_rec.failure_score_commentary5 <> FND_API.G_MISS_CHAR THEN
273: x_credit_rating_rec.failure_score_commentary5 := p_credit_rating_rec.failure_score_commentary5;
274: END IF;
275:
276: IF p_credit_rating_rec.failure_score_commentary6 IS NULL THEN

Line 277: x_credit_rating_rec.failure_score_commentary6 := FND_API.G_MISS_CHAR;

273: x_credit_rating_rec.failure_score_commentary5 := p_credit_rating_rec.failure_score_commentary5;
274: END IF;
275:
276: IF p_credit_rating_rec.failure_score_commentary6 IS NULL THEN
277: x_credit_rating_rec.failure_score_commentary6 := FND_API.G_MISS_CHAR;
278: ELSIF p_credit_rating_rec.failure_score_commentary6 <> FND_API.G_MISS_CHAR THEN
279: x_credit_rating_rec.failure_score_commentary6 := p_credit_rating_rec.failure_score_commentary6;
280: END IF;
281:

Line 278: ELSIF p_credit_rating_rec.failure_score_commentary6 <> FND_API.G_MISS_CHAR THEN

274: END IF;
275:
276: IF p_credit_rating_rec.failure_score_commentary6 IS NULL THEN
277: x_credit_rating_rec.failure_score_commentary6 := FND_API.G_MISS_CHAR;
278: ELSIF p_credit_rating_rec.failure_score_commentary6 <> FND_API.G_MISS_CHAR THEN
279: x_credit_rating_rec.failure_score_commentary6 := p_credit_rating_rec.failure_score_commentary6;
280: END IF;
281:
282: IF p_credit_rating_rec.failure_score_commentary7 IS NULL THEN

Line 283: x_credit_rating_rec.failure_score_commentary7 := FND_API.G_MISS_CHAR;

279: x_credit_rating_rec.failure_score_commentary6 := p_credit_rating_rec.failure_score_commentary6;
280: END IF;
281:
282: IF p_credit_rating_rec.failure_score_commentary7 IS NULL THEN
283: x_credit_rating_rec.failure_score_commentary7 := FND_API.G_MISS_CHAR;
284: ELSIF p_credit_rating_rec.failure_score_commentary7 <> FND_API.G_MISS_CHAR THEN
285: x_credit_rating_rec.failure_score_commentary7 := p_credit_rating_rec.failure_score_commentary7;
286: END IF;
287:

Line 284: ELSIF p_credit_rating_rec.failure_score_commentary7 <> FND_API.G_MISS_CHAR THEN

280: END IF;
281:
282: IF p_credit_rating_rec.failure_score_commentary7 IS NULL THEN
283: x_credit_rating_rec.failure_score_commentary7 := FND_API.G_MISS_CHAR;
284: ELSIF p_credit_rating_rec.failure_score_commentary7 <> FND_API.G_MISS_CHAR THEN
285: x_credit_rating_rec.failure_score_commentary7 := p_credit_rating_rec.failure_score_commentary7;
286: END IF;
287:
288: IF p_credit_rating_rec.failure_score_commentary8 IS NULL THEN

Line 289: x_credit_rating_rec.failure_score_commentary8 := FND_API.G_MISS_CHAR;

285: x_credit_rating_rec.failure_score_commentary7 := p_credit_rating_rec.failure_score_commentary7;
286: END IF;
287:
288: IF p_credit_rating_rec.failure_score_commentary8 IS NULL THEN
289: x_credit_rating_rec.failure_score_commentary8 := FND_API.G_MISS_CHAR;
290: ELSIF p_credit_rating_rec.failure_score_commentary8 <> FND_API.G_MISS_CHAR THEN
291: x_credit_rating_rec.failure_score_commentary8 := p_credit_rating_rec.failure_score_commentary8;
292: END IF;
293:

Line 290: ELSIF p_credit_rating_rec.failure_score_commentary8 <> FND_API.G_MISS_CHAR THEN

286: END IF;
287:
288: IF p_credit_rating_rec.failure_score_commentary8 IS NULL THEN
289: x_credit_rating_rec.failure_score_commentary8 := FND_API.G_MISS_CHAR;
290: ELSIF p_credit_rating_rec.failure_score_commentary8 <> FND_API.G_MISS_CHAR THEN
291: x_credit_rating_rec.failure_score_commentary8 := p_credit_rating_rec.failure_score_commentary8;
292: END IF;
293:
294: IF p_credit_rating_rec.failure_score_commentary9 IS NULL THEN

Line 295: x_credit_rating_rec.failure_score_commentary9 := FND_API.G_MISS_CHAR;

291: x_credit_rating_rec.failure_score_commentary8 := p_credit_rating_rec.failure_score_commentary8;
292: END IF;
293:
294: IF p_credit_rating_rec.failure_score_commentary9 IS NULL THEN
295: x_credit_rating_rec.failure_score_commentary9 := FND_API.G_MISS_CHAR;
296: ELSIF p_credit_rating_rec.failure_score_commentary9 <> FND_API.G_MISS_CHAR THEN
297: x_credit_rating_rec.failure_score_commentary9 := p_credit_rating_rec.failure_score_commentary9;
298: END IF;
299:

Line 296: ELSIF p_credit_rating_rec.failure_score_commentary9 <> FND_API.G_MISS_CHAR THEN

292: END IF;
293:
294: IF p_credit_rating_rec.failure_score_commentary9 IS NULL THEN
295: x_credit_rating_rec.failure_score_commentary9 := FND_API.G_MISS_CHAR;
296: ELSIF p_credit_rating_rec.failure_score_commentary9 <> FND_API.G_MISS_CHAR THEN
297: x_credit_rating_rec.failure_score_commentary9 := p_credit_rating_rec.failure_score_commentary9;
298: END IF;
299:
300: IF p_credit_rating_rec.failure_score_commentary10 IS NULL THEN

Line 301: x_credit_rating_rec.failure_score_commentary10 := FND_API.G_MISS_CHAR;

297: x_credit_rating_rec.failure_score_commentary9 := p_credit_rating_rec.failure_score_commentary9;
298: END IF;
299:
300: IF p_credit_rating_rec.failure_score_commentary10 IS NULL THEN
301: x_credit_rating_rec.failure_score_commentary10 := FND_API.G_MISS_CHAR;
302: ELSIF p_credit_rating_rec.failure_score_commentary10 <> FND_API.G_MISS_CHAR THEN
303: x_credit_rating_rec.failure_score_commentary10 := p_credit_rating_rec.failure_score_commentary10;
304: END IF;
305:

Line 302: ELSIF p_credit_rating_rec.failure_score_commentary10 <> FND_API.G_MISS_CHAR THEN

298: END IF;
299:
300: IF p_credit_rating_rec.failure_score_commentary10 IS NULL THEN
301: x_credit_rating_rec.failure_score_commentary10 := FND_API.G_MISS_CHAR;
302: ELSIF p_credit_rating_rec.failure_score_commentary10 <> FND_API.G_MISS_CHAR THEN
303: x_credit_rating_rec.failure_score_commentary10 := p_credit_rating_rec.failure_score_commentary10;
304: END IF;
305:
306: IF p_credit_rating_rec.failure_score_date IS NULL THEN

Line 307: x_credit_rating_rec.failure_score_date := FND_API.G_MISS_DATE;

303: x_credit_rating_rec.failure_score_commentary10 := p_credit_rating_rec.failure_score_commentary10;
304: END IF;
305:
306: IF p_credit_rating_rec.failure_score_date IS NULL THEN
307: x_credit_rating_rec.failure_score_date := FND_API.G_MISS_DATE;
308: ELSIF p_credit_rating_rec.failure_score_date <> FND_API.G_MISS_DATE THEN
309: x_credit_rating_rec.failure_score_date := p_credit_rating_rec.failure_score_date;
310: END IF;
311:

Line 308: ELSIF p_credit_rating_rec.failure_score_date <> FND_API.G_MISS_DATE THEN

304: END IF;
305:
306: IF p_credit_rating_rec.failure_score_date IS NULL THEN
307: x_credit_rating_rec.failure_score_date := FND_API.G_MISS_DATE;
308: ELSIF p_credit_rating_rec.failure_score_date <> FND_API.G_MISS_DATE THEN
309: x_credit_rating_rec.failure_score_date := p_credit_rating_rec.failure_score_date;
310: END IF;
311:
312: IF p_credit_rating_rec.failure_score_incd_default IS NULL THEN

Line 313: x_credit_rating_rec.failure_score_incd_default := FND_API.G_MISS_NUM;

309: x_credit_rating_rec.failure_score_date := p_credit_rating_rec.failure_score_date;
310: END IF;
311:
312: IF p_credit_rating_rec.failure_score_incd_default IS NULL THEN
313: x_credit_rating_rec.failure_score_incd_default := FND_API.G_MISS_NUM;
314: ELSIF p_credit_rating_rec.failure_score_incd_default <> FND_API.G_MISS_NUM THEN
315: x_credit_rating_rec.failure_score_incd_default := p_credit_rating_rec.failure_score_incd_default;
316: END IF;
317:

Line 314: ELSIF p_credit_rating_rec.failure_score_incd_default <> FND_API.G_MISS_NUM THEN

310: END IF;
311:
312: IF p_credit_rating_rec.failure_score_incd_default IS NULL THEN
313: x_credit_rating_rec.failure_score_incd_default := FND_API.G_MISS_NUM;
314: ELSIF p_credit_rating_rec.failure_score_incd_default <> FND_API.G_MISS_NUM THEN
315: x_credit_rating_rec.failure_score_incd_default := p_credit_rating_rec.failure_score_incd_default;
316: END IF;
317:
318: IF p_credit_rating_rec.failure_score_natnl_percentile IS NULL THEN

Line 319: x_credit_rating_rec.failure_score_natnl_percentile := FND_API.G_MISS_NUM;

315: x_credit_rating_rec.failure_score_incd_default := p_credit_rating_rec.failure_score_incd_default;
316: END IF;
317:
318: IF p_credit_rating_rec.failure_score_natnl_percentile IS NULL THEN
319: x_credit_rating_rec.failure_score_natnl_percentile := FND_API.G_MISS_NUM;
320: ELSIF p_credit_rating_rec.failure_score_natnl_percentile <> FND_API.G_MISS_NUM THEN
321: x_credit_rating_rec.failure_score_natnl_percentile := p_credit_rating_rec.failure_score_natnl_percentile;
322: END IF;
323:

Line 320: ELSIF p_credit_rating_rec.failure_score_natnl_percentile <> FND_API.G_MISS_NUM THEN

316: END IF;
317:
318: IF p_credit_rating_rec.failure_score_natnl_percentile IS NULL THEN
319: x_credit_rating_rec.failure_score_natnl_percentile := FND_API.G_MISS_NUM;
320: ELSIF p_credit_rating_rec.failure_score_natnl_percentile <> FND_API.G_MISS_NUM THEN
321: x_credit_rating_rec.failure_score_natnl_percentile := p_credit_rating_rec.failure_score_natnl_percentile;
322: END IF;
323:
324: IF p_credit_rating_rec.failure_score_override_code IS NULL THEN

Line 325: x_credit_rating_rec.failure_score_override_code := FND_API.G_MISS_CHAR;

321: x_credit_rating_rec.failure_score_natnl_percentile := p_credit_rating_rec.failure_score_natnl_percentile;
322: END IF;
323:
324: IF p_credit_rating_rec.failure_score_override_code IS NULL THEN
325: x_credit_rating_rec.failure_score_override_code := FND_API.G_MISS_CHAR;
326: ELSIF p_credit_rating_rec.failure_score_override_code <> FND_API.G_MISS_CHAR THEN
327: x_credit_rating_rec.failure_score_override_code := p_credit_rating_rec.failure_score_override_code;
328: END IF;
329:

Line 326: ELSIF p_credit_rating_rec.failure_score_override_code <> FND_API.G_MISS_CHAR THEN

322: END IF;
323:
324: IF p_credit_rating_rec.failure_score_override_code IS NULL THEN
325: x_credit_rating_rec.failure_score_override_code := FND_API.G_MISS_CHAR;
326: ELSIF p_credit_rating_rec.failure_score_override_code <> FND_API.G_MISS_CHAR THEN
327: x_credit_rating_rec.failure_score_override_code := p_credit_rating_rec.failure_score_override_code;
328: END IF;
329:
330: IF p_credit_rating_rec.global_failure_score IS NULL THEN

Line 331: x_credit_rating_rec.global_failure_score := FND_API.G_MISS_CHAR;

327: x_credit_rating_rec.failure_score_override_code := p_credit_rating_rec.failure_score_override_code;
328: END IF;
329:
330: IF p_credit_rating_rec.global_failure_score IS NULL THEN
331: x_credit_rating_rec.global_failure_score := FND_API.G_MISS_CHAR;
332: ELSIF p_credit_rating_rec.global_failure_score <> FND_API.G_MISS_CHAR THEN
333: x_credit_rating_rec.global_failure_score := p_credit_rating_rec.global_failure_score;
334: END IF;
335:

Line 332: ELSIF p_credit_rating_rec.global_failure_score <> FND_API.G_MISS_CHAR THEN

328: END IF;
329:
330: IF p_credit_rating_rec.global_failure_score IS NULL THEN
331: x_credit_rating_rec.global_failure_score := FND_API.G_MISS_CHAR;
332: ELSIF p_credit_rating_rec.global_failure_score <> FND_API.G_MISS_CHAR THEN
333: x_credit_rating_rec.global_failure_score := p_credit_rating_rec.global_failure_score;
334: END IF;
335:
336: IF p_credit_rating_rec.debarment_ind IS NULL THEN

Line 337: x_credit_rating_rec.debarment_ind := FND_API.G_MISS_CHAR;

333: x_credit_rating_rec.global_failure_score := p_credit_rating_rec.global_failure_score;
334: END IF;
335:
336: IF p_credit_rating_rec.debarment_ind IS NULL THEN
337: x_credit_rating_rec.debarment_ind := FND_API.G_MISS_CHAR;
338: ELSIF p_credit_rating_rec.debarment_ind <> FND_API.G_MISS_CHAR THEN
339: x_credit_rating_rec.debarment_ind := p_credit_rating_rec.debarment_ind;
340: END IF;
341:

Line 338: ELSIF p_credit_rating_rec.debarment_ind <> FND_API.G_MISS_CHAR THEN

334: END IF;
335:
336: IF p_credit_rating_rec.debarment_ind IS NULL THEN
337: x_credit_rating_rec.debarment_ind := FND_API.G_MISS_CHAR;
338: ELSIF p_credit_rating_rec.debarment_ind <> FND_API.G_MISS_CHAR THEN
339: x_credit_rating_rec.debarment_ind := p_credit_rating_rec.debarment_ind;
340: END IF;
341:
342: IF p_credit_rating_rec.debarments_count IS NULL THEN

Line 343: x_credit_rating_rec.debarments_count := FND_API.G_MISS_NUM;

339: x_credit_rating_rec.debarment_ind := p_credit_rating_rec.debarment_ind;
340: END IF;
341:
342: IF p_credit_rating_rec.debarments_count IS NULL THEN
343: x_credit_rating_rec.debarments_count := FND_API.G_MISS_NUM;
344: ELSIF p_credit_rating_rec.debarments_count <> FND_API.G_MISS_NUM THEN
345: x_credit_rating_rec.debarments_count := p_credit_rating_rec.debarments_count;
346: END IF;
347:

Line 344: ELSIF p_credit_rating_rec.debarments_count <> FND_API.G_MISS_NUM THEN

340: END IF;
341:
342: IF p_credit_rating_rec.debarments_count IS NULL THEN
343: x_credit_rating_rec.debarments_count := FND_API.G_MISS_NUM;
344: ELSIF p_credit_rating_rec.debarments_count <> FND_API.G_MISS_NUM THEN
345: x_credit_rating_rec.debarments_count := p_credit_rating_rec.debarments_count;
346: END IF;
347:
348: IF p_credit_rating_rec.debarments_date IS NULL THEN

Line 349: x_credit_rating_rec.debarments_date := FND_API.G_MISS_DATE;

345: x_credit_rating_rec.debarments_count := p_credit_rating_rec.debarments_count;
346: END IF;
347:
348: IF p_credit_rating_rec.debarments_date IS NULL THEN
349: x_credit_rating_rec.debarments_date := FND_API.G_MISS_DATE;
350: ELSIF p_credit_rating_rec.debarments_date <> FND_API.G_MISS_DATE THEN
351: x_credit_rating_rec.debarments_date := p_credit_rating_rec.debarments_date;
352: END IF;
353:

Line 350: ELSIF p_credit_rating_rec.debarments_date <> FND_API.G_MISS_DATE THEN

346: END IF;
347:
348: IF p_credit_rating_rec.debarments_date IS NULL THEN
349: x_credit_rating_rec.debarments_date := FND_API.G_MISS_DATE;
350: ELSIF p_credit_rating_rec.debarments_date <> FND_API.G_MISS_DATE THEN
351: x_credit_rating_rec.debarments_date := p_credit_rating_rec.debarments_date;
352: END IF;
353:
354: IF p_credit_rating_rec.high_credit IS NULL THEN

Line 355: x_credit_rating_rec.high_credit := FND_API.G_MISS_NUM;

351: x_credit_rating_rec.debarments_date := p_credit_rating_rec.debarments_date;
352: END IF;
353:
354: IF p_credit_rating_rec.high_credit IS NULL THEN
355: x_credit_rating_rec.high_credit := FND_API.G_MISS_NUM;
356: ELSIF p_credit_rating_rec.high_credit <> FND_API.G_MISS_NUM THEN
357: x_credit_rating_rec.high_credit := p_credit_rating_rec.high_credit;
358: END IF;
359:

Line 356: ELSIF p_credit_rating_rec.high_credit <> FND_API.G_MISS_NUM THEN

352: END IF;
353:
354: IF p_credit_rating_rec.high_credit IS NULL THEN
355: x_credit_rating_rec.high_credit := FND_API.G_MISS_NUM;
356: ELSIF p_credit_rating_rec.high_credit <> FND_API.G_MISS_NUM THEN
357: x_credit_rating_rec.high_credit := p_credit_rating_rec.high_credit;
358: END IF;
359:
360: IF p_credit_rating_rec.maximum_credit_currency_code IS NULL THEN

Line 361: x_credit_rating_rec.maximum_credit_currency_code := FND_API.G_MISS_CHAR;

357: x_credit_rating_rec.high_credit := p_credit_rating_rec.high_credit;
358: END IF;
359:
360: IF p_credit_rating_rec.maximum_credit_currency_code IS NULL THEN
361: x_credit_rating_rec.maximum_credit_currency_code := FND_API.G_MISS_CHAR;
362: ELSIF p_credit_rating_rec.maximum_credit_currency_code <> FND_API.G_MISS_CHAR THEN
363: x_credit_rating_rec.maximum_credit_currency_code := p_credit_rating_rec.maximum_credit_currency_code;
364: END IF;
365:

Line 362: ELSIF p_credit_rating_rec.maximum_credit_currency_code <> FND_API.G_MISS_CHAR THEN

358: END IF;
359:
360: IF p_credit_rating_rec.maximum_credit_currency_code IS NULL THEN
361: x_credit_rating_rec.maximum_credit_currency_code := FND_API.G_MISS_CHAR;
362: ELSIF p_credit_rating_rec.maximum_credit_currency_code <> FND_API.G_MISS_CHAR THEN
363: x_credit_rating_rec.maximum_credit_currency_code := p_credit_rating_rec.maximum_credit_currency_code;
364: END IF;
365:
366: IF p_credit_rating_rec.maximum_credit_rcmd IS NULL THEN

Line 367: x_credit_rating_rec.maximum_credit_rcmd := FND_API.G_MISS_NUM;

363: x_credit_rating_rec.maximum_credit_currency_code := p_credit_rating_rec.maximum_credit_currency_code;
364: END IF;
365:
366: IF p_credit_rating_rec.maximum_credit_rcmd IS NULL THEN
367: x_credit_rating_rec.maximum_credit_rcmd := FND_API.G_MISS_NUM;
368: ELSIF p_credit_rating_rec.maximum_credit_rcmd <> FND_API.G_MISS_NUM THEN
369: x_credit_rating_rec.maximum_credit_rcmd := p_credit_rating_rec.maximum_credit_rcmd;
370: END IF;
371:

Line 368: ELSIF p_credit_rating_rec.maximum_credit_rcmd <> FND_API.G_MISS_NUM THEN

364: END IF;
365:
366: IF p_credit_rating_rec.maximum_credit_rcmd IS NULL THEN
367: x_credit_rating_rec.maximum_credit_rcmd := FND_API.G_MISS_NUM;
368: ELSIF p_credit_rating_rec.maximum_credit_rcmd <> FND_API.G_MISS_NUM THEN
369: x_credit_rating_rec.maximum_credit_rcmd := p_credit_rating_rec.maximum_credit_rcmd;
370: END IF;
371:
372: IF p_credit_rating_rec.paydex_norm IS NULL THEN

Line 373: x_credit_rating_rec.paydex_norm := FND_API.G_MISS_CHAR;

369: x_credit_rating_rec.maximum_credit_rcmd := p_credit_rating_rec.maximum_credit_rcmd;
370: END IF;
371:
372: IF p_credit_rating_rec.paydex_norm IS NULL THEN
373: x_credit_rating_rec.paydex_norm := FND_API.G_MISS_CHAR;
374: ELSIF p_credit_rating_rec.paydex_norm <> FND_API.G_MISS_CHAR THEN
375: x_credit_rating_rec.paydex_norm := p_credit_rating_rec.paydex_norm;
376: END IF;
377:

Line 374: ELSIF p_credit_rating_rec.paydex_norm <> FND_API.G_MISS_CHAR THEN

370: END IF;
371:
372: IF p_credit_rating_rec.paydex_norm IS NULL THEN
373: x_credit_rating_rec.paydex_norm := FND_API.G_MISS_CHAR;
374: ELSIF p_credit_rating_rec.paydex_norm <> FND_API.G_MISS_CHAR THEN
375: x_credit_rating_rec.paydex_norm := p_credit_rating_rec.paydex_norm;
376: END IF;
377:
378: IF p_credit_rating_rec.paydex_score IS NULL THEN

Line 379: x_credit_rating_rec.paydex_score := FND_API.G_MISS_CHAR;

375: x_credit_rating_rec.paydex_norm := p_credit_rating_rec.paydex_norm;
376: END IF;
377:
378: IF p_credit_rating_rec.paydex_score IS NULL THEN
379: x_credit_rating_rec.paydex_score := FND_API.G_MISS_CHAR;
380: ELSIF p_credit_rating_rec.paydex_score <> FND_API.G_MISS_CHAR THEN
381: x_credit_rating_rec.paydex_score := p_credit_rating_rec.paydex_score;
382: END IF;
383:

Line 380: ELSIF p_credit_rating_rec.paydex_score <> FND_API.G_MISS_CHAR THEN

376: END IF;
377:
378: IF p_credit_rating_rec.paydex_score IS NULL THEN
379: x_credit_rating_rec.paydex_score := FND_API.G_MISS_CHAR;
380: ELSIF p_credit_rating_rec.paydex_score <> FND_API.G_MISS_CHAR THEN
381: x_credit_rating_rec.paydex_score := p_credit_rating_rec.paydex_score;
382: END IF;
383:
384: IF p_credit_rating_rec.paydex_three_months_ago IS NULL THEN

Line 385: x_credit_rating_rec.paydex_three_months_ago := FND_API.G_MISS_CHAR;

381: x_credit_rating_rec.paydex_score := p_credit_rating_rec.paydex_score;
382: END IF;
383:
384: IF p_credit_rating_rec.paydex_three_months_ago IS NULL THEN
385: x_credit_rating_rec.paydex_three_months_ago := FND_API.G_MISS_CHAR;
386: ELSIF p_credit_rating_rec.paydex_three_months_ago <> FND_API.G_MISS_CHAR THEN
387: x_credit_rating_rec.paydex_three_months_ago := p_credit_rating_rec.paydex_three_months_ago;
388: END IF;
389:

Line 386: ELSIF p_credit_rating_rec.paydex_three_months_ago <> FND_API.G_MISS_CHAR THEN

382: END IF;
383:
384: IF p_credit_rating_rec.paydex_three_months_ago IS NULL THEN
385: x_credit_rating_rec.paydex_three_months_ago := FND_API.G_MISS_CHAR;
386: ELSIF p_credit_rating_rec.paydex_three_months_ago <> FND_API.G_MISS_CHAR THEN
387: x_credit_rating_rec.paydex_three_months_ago := p_credit_rating_rec.paydex_three_months_ago;
388: END IF;
389:
390: IF p_credit_rating_rec.credit_score_override_code IS NULL THEN

Line 391: x_credit_rating_rec.credit_score_override_code := FND_API.G_MISS_CHAR;

387: x_credit_rating_rec.paydex_three_months_ago := p_credit_rating_rec.paydex_three_months_ago;
388: END IF;
389:
390: IF p_credit_rating_rec.credit_score_override_code IS NULL THEN
391: x_credit_rating_rec.credit_score_override_code := FND_API.G_MISS_CHAR;
392: ELSIF p_credit_rating_rec.credit_score_override_code <> FND_API.G_MISS_CHAR THEN
393: x_credit_rating_rec.credit_score_override_code := p_credit_rating_rec.credit_score_override_code;
394: END IF;
395:

Line 392: ELSIF p_credit_rating_rec.credit_score_override_code <> FND_API.G_MISS_CHAR THEN

388: END IF;
389:
390: IF p_credit_rating_rec.credit_score_override_code IS NULL THEN
391: x_credit_rating_rec.credit_score_override_code := FND_API.G_MISS_CHAR;
392: ELSIF p_credit_rating_rec.credit_score_override_code <> FND_API.G_MISS_CHAR THEN
393: x_credit_rating_rec.credit_score_override_code := p_credit_rating_rec.credit_score_override_code;
394: END IF;
395:
396: IF p_credit_rating_rec.cr_scr_clas_expl IS NULL THEN

Line 397: x_credit_rating_rec.cr_scr_clas_expl := FND_API.G_MISS_CHAR;

393: x_credit_rating_rec.credit_score_override_code := p_credit_rating_rec.credit_score_override_code;
394: END IF;
395:
396: IF p_credit_rating_rec.cr_scr_clas_expl IS NULL THEN
397: x_credit_rating_rec.cr_scr_clas_expl := FND_API.G_MISS_CHAR;
398: ELSIF p_credit_rating_rec.cr_scr_clas_expl <> FND_API.G_MISS_CHAR THEN
399: x_credit_rating_rec.cr_scr_clas_expl := p_credit_rating_rec.cr_scr_clas_expl;
400: END IF;
401:

Line 398: ELSIF p_credit_rating_rec.cr_scr_clas_expl <> FND_API.G_MISS_CHAR THEN

394: END IF;
395:
396: IF p_credit_rating_rec.cr_scr_clas_expl IS NULL THEN
397: x_credit_rating_rec.cr_scr_clas_expl := FND_API.G_MISS_CHAR;
398: ELSIF p_credit_rating_rec.cr_scr_clas_expl <> FND_API.G_MISS_CHAR THEN
399: x_credit_rating_rec.cr_scr_clas_expl := p_credit_rating_rec.cr_scr_clas_expl;
400: END IF;
401:
402: IF p_credit_rating_rec.low_rng_delq_scr IS NULL THEN

Line 403: x_credit_rating_rec.low_rng_delq_scr := FND_API.G_MISS_NUM;

399: x_credit_rating_rec.cr_scr_clas_expl := p_credit_rating_rec.cr_scr_clas_expl;
400: END IF;
401:
402: IF p_credit_rating_rec.low_rng_delq_scr IS NULL THEN
403: x_credit_rating_rec.low_rng_delq_scr := FND_API.G_MISS_NUM;
404: ELSIF p_credit_rating_rec.low_rng_delq_scr <> FND_API.G_MISS_NUM THEN
405: x_credit_rating_rec.low_rng_delq_scr := p_credit_rating_rec.low_rng_delq_scr;
406: END IF;
407:

Line 404: ELSIF p_credit_rating_rec.low_rng_delq_scr <> FND_API.G_MISS_NUM THEN

400: END IF;
401:
402: IF p_credit_rating_rec.low_rng_delq_scr IS NULL THEN
403: x_credit_rating_rec.low_rng_delq_scr := FND_API.G_MISS_NUM;
404: ELSIF p_credit_rating_rec.low_rng_delq_scr <> FND_API.G_MISS_NUM THEN
405: x_credit_rating_rec.low_rng_delq_scr := p_credit_rating_rec.low_rng_delq_scr;
406: END IF;
407:
408: IF p_credit_rating_rec.high_rng_delq_scr IS NULL THEN

Line 409: x_credit_rating_rec.high_rng_delq_scr := FND_API.G_MISS_NUM;

405: x_credit_rating_rec.low_rng_delq_scr := p_credit_rating_rec.low_rng_delq_scr;
406: END IF;
407:
408: IF p_credit_rating_rec.high_rng_delq_scr IS NULL THEN
409: x_credit_rating_rec.high_rng_delq_scr := FND_API.G_MISS_NUM;
410: ELSIF p_credit_rating_rec.high_rng_delq_scr <> FND_API.G_MISS_NUM THEN
411: x_credit_rating_rec.high_rng_delq_scr := p_credit_rating_rec.high_rng_delq_scr;
412: END IF;
413:

Line 410: ELSIF p_credit_rating_rec.high_rng_delq_scr <> FND_API.G_MISS_NUM THEN

406: END IF;
407:
408: IF p_credit_rating_rec.high_rng_delq_scr IS NULL THEN
409: x_credit_rating_rec.high_rng_delq_scr := FND_API.G_MISS_NUM;
410: ELSIF p_credit_rating_rec.high_rng_delq_scr <> FND_API.G_MISS_NUM THEN
411: x_credit_rating_rec.high_rng_delq_scr := p_credit_rating_rec.high_rng_delq_scr;
412: END IF;
413:
414: IF p_credit_rating_rec.delq_pmt_rng_prcnt IS NULL THEN

Line 415: x_credit_rating_rec.delq_pmt_rng_prcnt := FND_API.G_MISS_NUM;

411: x_credit_rating_rec.high_rng_delq_scr := p_credit_rating_rec.high_rng_delq_scr;
412: END IF;
413:
414: IF p_credit_rating_rec.delq_pmt_rng_prcnt IS NULL THEN
415: x_credit_rating_rec.delq_pmt_rng_prcnt := FND_API.G_MISS_NUM;
416: ELSIF p_credit_rating_rec.delq_pmt_rng_prcnt <> FND_API.G_MISS_NUM THEN
417: x_credit_rating_rec.delq_pmt_rng_prcnt := p_credit_rating_rec.delq_pmt_rng_prcnt;
418: END IF;
419:

Line 416: ELSIF p_credit_rating_rec.delq_pmt_rng_prcnt <> FND_API.G_MISS_NUM THEN

412: END IF;
413:
414: IF p_credit_rating_rec.delq_pmt_rng_prcnt IS NULL THEN
415: x_credit_rating_rec.delq_pmt_rng_prcnt := FND_API.G_MISS_NUM;
416: ELSIF p_credit_rating_rec.delq_pmt_rng_prcnt <> FND_API.G_MISS_NUM THEN
417: x_credit_rating_rec.delq_pmt_rng_prcnt := p_credit_rating_rec.delq_pmt_rng_prcnt;
418: END IF;
419:
420: IF p_credit_rating_rec.delq_pmt_pctg_for_all_firms IS NULL THEN

Line 421: x_credit_rating_rec.delq_pmt_pctg_for_all_firms := FND_API.G_MISS_NUM;

417: x_credit_rating_rec.delq_pmt_rng_prcnt := p_credit_rating_rec.delq_pmt_rng_prcnt;
418: END IF;
419:
420: IF p_credit_rating_rec.delq_pmt_pctg_for_all_firms IS NULL THEN
421: x_credit_rating_rec.delq_pmt_pctg_for_all_firms := FND_API.G_MISS_NUM;
422: ELSIF p_credit_rating_rec.delq_pmt_pctg_for_all_firms <> FND_API.G_MISS_NUM THEN
423: x_credit_rating_rec.delq_pmt_pctg_for_all_firms := p_credit_rating_rec.delq_pmt_pctg_for_all_firms;
424: END IF;
425:

Line 422: ELSIF p_credit_rating_rec.delq_pmt_pctg_for_all_firms <> FND_API.G_MISS_NUM THEN

418: END IF;
419:
420: IF p_credit_rating_rec.delq_pmt_pctg_for_all_firms IS NULL THEN
421: x_credit_rating_rec.delq_pmt_pctg_for_all_firms := FND_API.G_MISS_NUM;
422: ELSIF p_credit_rating_rec.delq_pmt_pctg_for_all_firms <> FND_API.G_MISS_NUM THEN
423: x_credit_rating_rec.delq_pmt_pctg_for_all_firms := p_credit_rating_rec.delq_pmt_pctg_for_all_firms;
424: END IF;
425:
426: IF p_credit_rating_rec.num_trade_experiences IS NULL THEN

Line 427: x_credit_rating_rec.num_trade_experiences := FND_API.G_MISS_NUM;

423: x_credit_rating_rec.delq_pmt_pctg_for_all_firms := p_credit_rating_rec.delq_pmt_pctg_for_all_firms;
424: END IF;
425:
426: IF p_credit_rating_rec.num_trade_experiences IS NULL THEN
427: x_credit_rating_rec.num_trade_experiences := FND_API.G_MISS_NUM;
428: ELSIF p_credit_rating_rec.num_trade_experiences <> FND_API.G_MISS_NUM THEN
429: x_credit_rating_rec.num_trade_experiences := p_credit_rating_rec.num_trade_experiences;
430: END IF;
431:

Line 428: ELSIF p_credit_rating_rec.num_trade_experiences <> FND_API.G_MISS_NUM THEN

424: END IF;
425:
426: IF p_credit_rating_rec.num_trade_experiences IS NULL THEN
427: x_credit_rating_rec.num_trade_experiences := FND_API.G_MISS_NUM;
428: ELSIF p_credit_rating_rec.num_trade_experiences <> FND_API.G_MISS_NUM THEN
429: x_credit_rating_rec.num_trade_experiences := p_credit_rating_rec.num_trade_experiences;
430: END IF;
431:
432: IF p_credit_rating_rec.paydex_firm_days IS NULL THEN

Line 433: x_credit_rating_rec.paydex_firm_days := FND_API.G_MISS_CHAR;

429: x_credit_rating_rec.num_trade_experiences := p_credit_rating_rec.num_trade_experiences;
430: END IF;
431:
432: IF p_credit_rating_rec.paydex_firm_days IS NULL THEN
433: x_credit_rating_rec.paydex_firm_days := FND_API.G_MISS_CHAR;
434: ELSIF p_credit_rating_rec.paydex_firm_days <> FND_API.G_MISS_CHAR THEN
435: x_credit_rating_rec.paydex_firm_days := p_credit_rating_rec.paydex_firm_days;
436: END IF;
437:

Line 434: ELSIF p_credit_rating_rec.paydex_firm_days <> FND_API.G_MISS_CHAR THEN

430: END IF;
431:
432: IF p_credit_rating_rec.paydex_firm_days IS NULL THEN
433: x_credit_rating_rec.paydex_firm_days := FND_API.G_MISS_CHAR;
434: ELSIF p_credit_rating_rec.paydex_firm_days <> FND_API.G_MISS_CHAR THEN
435: x_credit_rating_rec.paydex_firm_days := p_credit_rating_rec.paydex_firm_days;
436: END IF;
437:
438: IF p_credit_rating_rec.paydex_firm_comment IS NULL THEN

Line 439: x_credit_rating_rec.paydex_firm_comment := FND_API.G_MISS_CHAR;

435: x_credit_rating_rec.paydex_firm_days := p_credit_rating_rec.paydex_firm_days;
436: END IF;
437:
438: IF p_credit_rating_rec.paydex_firm_comment IS NULL THEN
439: x_credit_rating_rec.paydex_firm_comment := FND_API.G_MISS_CHAR;
440: ELSIF p_credit_rating_rec.paydex_firm_comment <> FND_API.G_MISS_CHAR THEN
441: x_credit_rating_rec.paydex_firm_comment := p_credit_rating_rec.paydex_firm_comment;
442: END IF;
443:

Line 440: ELSIF p_credit_rating_rec.paydex_firm_comment <> FND_API.G_MISS_CHAR THEN

436: END IF;
437:
438: IF p_credit_rating_rec.paydex_firm_comment IS NULL THEN
439: x_credit_rating_rec.paydex_firm_comment := FND_API.G_MISS_CHAR;
440: ELSIF p_credit_rating_rec.paydex_firm_comment <> FND_API.G_MISS_CHAR THEN
441: x_credit_rating_rec.paydex_firm_comment := p_credit_rating_rec.paydex_firm_comment;
442: END IF;
443:
444: IF p_credit_rating_rec.paydex_industry_days IS NULL THEN

Line 445: x_credit_rating_rec.paydex_industry_days := FND_API.G_MISS_CHAR;

441: x_credit_rating_rec.paydex_firm_comment := p_credit_rating_rec.paydex_firm_comment;
442: END IF;
443:
444: IF p_credit_rating_rec.paydex_industry_days IS NULL THEN
445: x_credit_rating_rec.paydex_industry_days := FND_API.G_MISS_CHAR;
446: ELSIF p_credit_rating_rec.paydex_industry_days <> FND_API.G_MISS_CHAR THEN
447: x_credit_rating_rec.paydex_industry_days := p_credit_rating_rec.paydex_industry_days;
448: END IF;
449:

Line 446: ELSIF p_credit_rating_rec.paydex_industry_days <> FND_API.G_MISS_CHAR THEN

442: END IF;
443:
444: IF p_credit_rating_rec.paydex_industry_days IS NULL THEN
445: x_credit_rating_rec.paydex_industry_days := FND_API.G_MISS_CHAR;
446: ELSIF p_credit_rating_rec.paydex_industry_days <> FND_API.G_MISS_CHAR THEN
447: x_credit_rating_rec.paydex_industry_days := p_credit_rating_rec.paydex_industry_days;
448: END IF;
449:
450: IF p_credit_rating_rec.paydex_industry_comment IS NULL THEN

Line 451: x_credit_rating_rec.paydex_industry_comment := FND_API.G_MISS_CHAR;

447: x_credit_rating_rec.paydex_industry_days := p_credit_rating_rec.paydex_industry_days;
448: END IF;
449:
450: IF p_credit_rating_rec.paydex_industry_comment IS NULL THEN
451: x_credit_rating_rec.paydex_industry_comment := FND_API.G_MISS_CHAR;
452: ELSIF p_credit_rating_rec.paydex_industry_comment <> FND_API.G_MISS_CHAR THEN
453: x_credit_rating_rec.paydex_industry_comment := p_credit_rating_rec.paydex_industry_comment;
454: END IF;
455:

Line 452: ELSIF p_credit_rating_rec.paydex_industry_comment <> FND_API.G_MISS_CHAR THEN

448: END IF;
449:
450: IF p_credit_rating_rec.paydex_industry_comment IS NULL THEN
451: x_credit_rating_rec.paydex_industry_comment := FND_API.G_MISS_CHAR;
452: ELSIF p_credit_rating_rec.paydex_industry_comment <> FND_API.G_MISS_CHAR THEN
453: x_credit_rating_rec.paydex_industry_comment := p_credit_rating_rec.paydex_industry_comment;
454: END IF;
455:
456: IF p_credit_rating_rec.paydex_comment IS NULL THEN

Line 457: x_credit_rating_rec.paydex_comment := FND_API.G_MISS_CHAR;

453: x_credit_rating_rec.paydex_industry_comment := p_credit_rating_rec.paydex_industry_comment;
454: END IF;
455:
456: IF p_credit_rating_rec.paydex_comment IS NULL THEN
457: x_credit_rating_rec.paydex_comment := FND_API.G_MISS_CHAR;
458: ELSIF p_credit_rating_rec.paydex_comment <> FND_API.G_MISS_CHAR THEN
459: x_credit_rating_rec.paydex_comment := p_credit_rating_rec.paydex_comment;
460: END IF;
461:

Line 458: ELSIF p_credit_rating_rec.paydex_comment <> FND_API.G_MISS_CHAR THEN

454: END IF;
455:
456: IF p_credit_rating_rec.paydex_comment IS NULL THEN
457: x_credit_rating_rec.paydex_comment := FND_API.G_MISS_CHAR;
458: ELSIF p_credit_rating_rec.paydex_comment <> FND_API.G_MISS_CHAR THEN
459: x_credit_rating_rec.paydex_comment := p_credit_rating_rec.paydex_comment;
460: END IF;
461:
462: IF p_credit_rating_rec.suit_ind IS NULL THEN

Line 463: x_credit_rating_rec.suit_ind := FND_API.G_MISS_CHAR;

459: x_credit_rating_rec.paydex_comment := p_credit_rating_rec.paydex_comment;
460: END IF;
461:
462: IF p_credit_rating_rec.suit_ind IS NULL THEN
463: x_credit_rating_rec.suit_ind := FND_API.G_MISS_CHAR;
464: ELSIF p_credit_rating_rec.suit_ind <> FND_API.G_MISS_CHAR THEN
465: x_credit_rating_rec.suit_ind := p_credit_rating_rec.suit_ind;
466: END IF;
467:

Line 464: ELSIF p_credit_rating_rec.suit_ind <> FND_API.G_MISS_CHAR THEN

460: END IF;
461:
462: IF p_credit_rating_rec.suit_ind IS NULL THEN
463: x_credit_rating_rec.suit_ind := FND_API.G_MISS_CHAR;
464: ELSIF p_credit_rating_rec.suit_ind <> FND_API.G_MISS_CHAR THEN
465: x_credit_rating_rec.suit_ind := p_credit_rating_rec.suit_ind;
466: END IF;
467:
468: IF p_credit_rating_rec.lien_ind IS NULL THEN

Line 469: x_credit_rating_rec.lien_ind := FND_API.G_MISS_CHAR;

465: x_credit_rating_rec.suit_ind := p_credit_rating_rec.suit_ind;
466: END IF;
467:
468: IF p_credit_rating_rec.lien_ind IS NULL THEN
469: x_credit_rating_rec.lien_ind := FND_API.G_MISS_CHAR;
470: ELSIF p_credit_rating_rec.lien_ind <> FND_API.G_MISS_CHAR THEN
471: x_credit_rating_rec.lien_ind := p_credit_rating_rec.lien_ind;
472: END IF;
473:

Line 470: ELSIF p_credit_rating_rec.lien_ind <> FND_API.G_MISS_CHAR THEN

466: END IF;
467:
468: IF p_credit_rating_rec.lien_ind IS NULL THEN
469: x_credit_rating_rec.lien_ind := FND_API.G_MISS_CHAR;
470: ELSIF p_credit_rating_rec.lien_ind <> FND_API.G_MISS_CHAR THEN
471: x_credit_rating_rec.lien_ind := p_credit_rating_rec.lien_ind;
472: END IF;
473:
474: IF p_credit_rating_rec.judgement_ind IS NULL THEN

Line 475: x_credit_rating_rec.judgement_ind := FND_API.G_MISS_CHAR;

471: x_credit_rating_rec.lien_ind := p_credit_rating_rec.lien_ind;
472: END IF;
473:
474: IF p_credit_rating_rec.judgement_ind IS NULL THEN
475: x_credit_rating_rec.judgement_ind := FND_API.G_MISS_CHAR;
476: ELSIF p_credit_rating_rec.judgement_ind <> FND_API.G_MISS_CHAR THEN
477: x_credit_rating_rec.judgement_ind := p_credit_rating_rec.judgement_ind;
478: END IF;
479:

Line 476: ELSIF p_credit_rating_rec.judgement_ind <> FND_API.G_MISS_CHAR THEN

472: END IF;
473:
474: IF p_credit_rating_rec.judgement_ind IS NULL THEN
475: x_credit_rating_rec.judgement_ind := FND_API.G_MISS_CHAR;
476: ELSIF p_credit_rating_rec.judgement_ind <> FND_API.G_MISS_CHAR THEN
477: x_credit_rating_rec.judgement_ind := p_credit_rating_rec.judgement_ind;
478: END IF;
479:
480: IF p_credit_rating_rec.bankruptcy_ind IS NULL THEN

Line 481: x_credit_rating_rec.bankruptcy_ind := FND_API.G_MISS_CHAR;

477: x_credit_rating_rec.judgement_ind := p_credit_rating_rec.judgement_ind;
478: END IF;
479:
480: IF p_credit_rating_rec.bankruptcy_ind IS NULL THEN
481: x_credit_rating_rec.bankruptcy_ind := FND_API.G_MISS_CHAR;
482: ELSIF p_credit_rating_rec.bankruptcy_ind <> FND_API.G_MISS_CHAR THEN
483: x_credit_rating_rec.bankruptcy_ind := p_credit_rating_rec.bankruptcy_ind;
484: END IF;
485:

Line 482: ELSIF p_credit_rating_rec.bankruptcy_ind <> FND_API.G_MISS_CHAR THEN

478: END IF;
479:
480: IF p_credit_rating_rec.bankruptcy_ind IS NULL THEN
481: x_credit_rating_rec.bankruptcy_ind := FND_API.G_MISS_CHAR;
482: ELSIF p_credit_rating_rec.bankruptcy_ind <> FND_API.G_MISS_CHAR THEN
483: x_credit_rating_rec.bankruptcy_ind := p_credit_rating_rec.bankruptcy_ind;
484: END IF;
485:
486: IF p_credit_rating_rec.no_trade_ind IS NULL THEN

Line 487: x_credit_rating_rec.no_trade_ind := FND_API.G_MISS_CHAR;

483: x_credit_rating_rec.bankruptcy_ind := p_credit_rating_rec.bankruptcy_ind;
484: END IF;
485:
486: IF p_credit_rating_rec.no_trade_ind IS NULL THEN
487: x_credit_rating_rec.no_trade_ind := FND_API.G_MISS_CHAR;
488: ELSIF p_credit_rating_rec.no_trade_ind <> FND_API.G_MISS_CHAR THEN
489: x_credit_rating_rec.no_trade_ind := p_credit_rating_rec.no_trade_ind;
490: END IF;
491:

Line 488: ELSIF p_credit_rating_rec.no_trade_ind <> FND_API.G_MISS_CHAR THEN

484: END IF;
485:
486: IF p_credit_rating_rec.no_trade_ind IS NULL THEN
487: x_credit_rating_rec.no_trade_ind := FND_API.G_MISS_CHAR;
488: ELSIF p_credit_rating_rec.no_trade_ind <> FND_API.G_MISS_CHAR THEN
489: x_credit_rating_rec.no_trade_ind := p_credit_rating_rec.no_trade_ind;
490: END IF;
491:
492: IF p_credit_rating_rec.prnt_hq_bkcy_ind IS NULL THEN

Line 493: x_credit_rating_rec.prnt_hq_bkcy_ind := FND_API.G_MISS_CHAR;

489: x_credit_rating_rec.no_trade_ind := p_credit_rating_rec.no_trade_ind;
490: END IF;
491:
492: IF p_credit_rating_rec.prnt_hq_bkcy_ind IS NULL THEN
493: x_credit_rating_rec.prnt_hq_bkcy_ind := FND_API.G_MISS_CHAR;
494: ELSIF p_credit_rating_rec.prnt_hq_bkcy_ind <> FND_API.G_MISS_CHAR THEN
495: x_credit_rating_rec.prnt_hq_bkcy_ind := p_credit_rating_rec.prnt_hq_bkcy_ind;
496: END IF;
497:

Line 494: ELSIF p_credit_rating_rec.prnt_hq_bkcy_ind <> FND_API.G_MISS_CHAR THEN

490: END IF;
491:
492: IF p_credit_rating_rec.prnt_hq_bkcy_ind IS NULL THEN
493: x_credit_rating_rec.prnt_hq_bkcy_ind := FND_API.G_MISS_CHAR;
494: ELSIF p_credit_rating_rec.prnt_hq_bkcy_ind <> FND_API.G_MISS_CHAR THEN
495: x_credit_rating_rec.prnt_hq_bkcy_ind := p_credit_rating_rec.prnt_hq_bkcy_ind;
496: END IF;
497:
498: IF p_credit_rating_rec.num_prnt_bkcy_filing IS NULL THEN

Line 499: x_credit_rating_rec.num_prnt_bkcy_filing := FND_API.G_MISS_NUM;

495: x_credit_rating_rec.prnt_hq_bkcy_ind := p_credit_rating_rec.prnt_hq_bkcy_ind;
496: END IF;
497:
498: IF p_credit_rating_rec.num_prnt_bkcy_filing IS NULL THEN
499: x_credit_rating_rec.num_prnt_bkcy_filing := FND_API.G_MISS_NUM;
500: ELSIF p_credit_rating_rec.num_prnt_bkcy_filing <> FND_API.G_MISS_NUM THEN
501: x_credit_rating_rec.num_prnt_bkcy_filing := p_credit_rating_rec.num_prnt_bkcy_filing;
502: END IF;
503:

Line 500: ELSIF p_credit_rating_rec.num_prnt_bkcy_filing <> FND_API.G_MISS_NUM THEN

496: END IF;
497:
498: IF p_credit_rating_rec.num_prnt_bkcy_filing IS NULL THEN
499: x_credit_rating_rec.num_prnt_bkcy_filing := FND_API.G_MISS_NUM;
500: ELSIF p_credit_rating_rec.num_prnt_bkcy_filing <> FND_API.G_MISS_NUM THEN
501: x_credit_rating_rec.num_prnt_bkcy_filing := p_credit_rating_rec.num_prnt_bkcy_filing;
502: END IF;
503:
504: IF p_credit_rating_rec.prnt_bkcy_filg_type IS NULL THEN

Line 505: x_credit_rating_rec.prnt_bkcy_filg_type := FND_API.G_MISS_CHAR;

501: x_credit_rating_rec.num_prnt_bkcy_filing := p_credit_rating_rec.num_prnt_bkcy_filing;
502: END IF;
503:
504: IF p_credit_rating_rec.prnt_bkcy_filg_type IS NULL THEN
505: x_credit_rating_rec.prnt_bkcy_filg_type := FND_API.G_MISS_CHAR;
506: ELSIF p_credit_rating_rec.prnt_bkcy_filg_type <> FND_API.G_MISS_CHAR THEN
507: x_credit_rating_rec.prnt_bkcy_filg_type := p_credit_rating_rec.prnt_bkcy_filg_type;
508: END IF;
509:

Line 506: ELSIF p_credit_rating_rec.prnt_bkcy_filg_type <> FND_API.G_MISS_CHAR THEN

502: END IF;
503:
504: IF p_credit_rating_rec.prnt_bkcy_filg_type IS NULL THEN
505: x_credit_rating_rec.prnt_bkcy_filg_type := FND_API.G_MISS_CHAR;
506: ELSIF p_credit_rating_rec.prnt_bkcy_filg_type <> FND_API.G_MISS_CHAR THEN
507: x_credit_rating_rec.prnt_bkcy_filg_type := p_credit_rating_rec.prnt_bkcy_filg_type;
508: END IF;
509:
510: IF p_credit_rating_rec.prnt_bkcy_filg_chapter IS NULL THEN

Line 511: x_credit_rating_rec.prnt_bkcy_filg_chapter := FND_API.G_MISS_NUM;

507: x_credit_rating_rec.prnt_bkcy_filg_type := p_credit_rating_rec.prnt_bkcy_filg_type;
508: END IF;
509:
510: IF p_credit_rating_rec.prnt_bkcy_filg_chapter IS NULL THEN
511: x_credit_rating_rec.prnt_bkcy_filg_chapter := FND_API.G_MISS_NUM;
512: ELSIF p_credit_rating_rec.prnt_bkcy_filg_chapter <> FND_API.G_MISS_NUM THEN
513: x_credit_rating_rec.prnt_bkcy_filg_chapter := p_credit_rating_rec.prnt_bkcy_filg_chapter;
514: END IF;
515:

Line 512: ELSIF p_credit_rating_rec.prnt_bkcy_filg_chapter <> FND_API.G_MISS_NUM THEN

508: END IF;
509:
510: IF p_credit_rating_rec.prnt_bkcy_filg_chapter IS NULL THEN
511: x_credit_rating_rec.prnt_bkcy_filg_chapter := FND_API.G_MISS_NUM;
512: ELSIF p_credit_rating_rec.prnt_bkcy_filg_chapter <> FND_API.G_MISS_NUM THEN
513: x_credit_rating_rec.prnt_bkcy_filg_chapter := p_credit_rating_rec.prnt_bkcy_filg_chapter;
514: END IF;
515:
516: IF p_credit_rating_rec.prnt_bkcy_filg_date IS NULL THEN

Line 517: x_credit_rating_rec.prnt_bkcy_filg_date := FND_API.G_MISS_DATE;

513: x_credit_rating_rec.prnt_bkcy_filg_chapter := p_credit_rating_rec.prnt_bkcy_filg_chapter;
514: END IF;
515:
516: IF p_credit_rating_rec.prnt_bkcy_filg_date IS NULL THEN
517: x_credit_rating_rec.prnt_bkcy_filg_date := FND_API.G_MISS_DATE;
518: ELSIF p_credit_rating_rec.prnt_bkcy_filg_date <> FND_API.G_MISS_DATE THEN
519: x_credit_rating_rec.prnt_bkcy_filg_date := p_credit_rating_rec.prnt_bkcy_filg_date;
520: END IF;
521:

Line 518: ELSIF p_credit_rating_rec.prnt_bkcy_filg_date <> FND_API.G_MISS_DATE THEN

514: END IF;
515:
516: IF p_credit_rating_rec.prnt_bkcy_filg_date IS NULL THEN
517: x_credit_rating_rec.prnt_bkcy_filg_date := FND_API.G_MISS_DATE;
518: ELSIF p_credit_rating_rec.prnt_bkcy_filg_date <> FND_API.G_MISS_DATE THEN
519: x_credit_rating_rec.prnt_bkcy_filg_date := p_credit_rating_rec.prnt_bkcy_filg_date;
520: END IF;
521:
522: IF p_credit_rating_rec.num_prnt_bkcy_convs IS NULL THEN

Line 523: x_credit_rating_rec.num_prnt_bkcy_convs := FND_API.G_MISS_NUM;

519: x_credit_rating_rec.prnt_bkcy_filg_date := p_credit_rating_rec.prnt_bkcy_filg_date;
520: END IF;
521:
522: IF p_credit_rating_rec.num_prnt_bkcy_convs IS NULL THEN
523: x_credit_rating_rec.num_prnt_bkcy_convs := FND_API.G_MISS_NUM;
524: ELSIF p_credit_rating_rec.num_prnt_bkcy_convs <> FND_API.G_MISS_NUM THEN
525: x_credit_rating_rec.num_prnt_bkcy_convs := p_credit_rating_rec.num_prnt_bkcy_convs;
526: END IF;
527:

Line 524: ELSIF p_credit_rating_rec.num_prnt_bkcy_convs <> FND_API.G_MISS_NUM THEN

520: END IF;
521:
522: IF p_credit_rating_rec.num_prnt_bkcy_convs IS NULL THEN
523: x_credit_rating_rec.num_prnt_bkcy_convs := FND_API.G_MISS_NUM;
524: ELSIF p_credit_rating_rec.num_prnt_bkcy_convs <> FND_API.G_MISS_NUM THEN
525: x_credit_rating_rec.num_prnt_bkcy_convs := p_credit_rating_rec.num_prnt_bkcy_convs;
526: END IF;
527:
528: IF p_credit_rating_rec.prnt_bkcy_conv_date IS NULL THEN

Line 529: x_credit_rating_rec.prnt_bkcy_conv_date := FND_API.G_MISS_DATE;

525: x_credit_rating_rec.num_prnt_bkcy_convs := p_credit_rating_rec.num_prnt_bkcy_convs;
526: END IF;
527:
528: IF p_credit_rating_rec.prnt_bkcy_conv_date IS NULL THEN
529: x_credit_rating_rec.prnt_bkcy_conv_date := FND_API.G_MISS_DATE;
530: ELSIF p_credit_rating_rec.prnt_bkcy_conv_date <> FND_API.G_MISS_DATE THEN
531: x_credit_rating_rec.prnt_bkcy_conv_date := p_credit_rating_rec.prnt_bkcy_conv_date;
532: END IF;
533:

Line 530: ELSIF p_credit_rating_rec.prnt_bkcy_conv_date <> FND_API.G_MISS_DATE THEN

526: END IF;
527:
528: IF p_credit_rating_rec.prnt_bkcy_conv_date IS NULL THEN
529: x_credit_rating_rec.prnt_bkcy_conv_date := FND_API.G_MISS_DATE;
530: ELSIF p_credit_rating_rec.prnt_bkcy_conv_date <> FND_API.G_MISS_DATE THEN
531: x_credit_rating_rec.prnt_bkcy_conv_date := p_credit_rating_rec.prnt_bkcy_conv_date;
532: END IF;
533:
534: IF p_credit_rating_rec.prnt_bkcy_chapter_conv IS NULL THEN

Line 535: x_credit_rating_rec.prnt_bkcy_chapter_conv := FND_API.G_MISS_CHAR;

531: x_credit_rating_rec.prnt_bkcy_conv_date := p_credit_rating_rec.prnt_bkcy_conv_date;
532: END IF;
533:
534: IF p_credit_rating_rec.prnt_bkcy_chapter_conv IS NULL THEN
535: x_credit_rating_rec.prnt_bkcy_chapter_conv := FND_API.G_MISS_CHAR;
536: ELSIF p_credit_rating_rec.prnt_bkcy_chapter_conv <> FND_API.G_MISS_CHAR THEN
537: x_credit_rating_rec.prnt_bkcy_chapter_conv := p_credit_rating_rec.prnt_bkcy_chapter_conv;
538: END IF;
539:

Line 536: ELSIF p_credit_rating_rec.prnt_bkcy_chapter_conv <> FND_API.G_MISS_CHAR THEN

532: END IF;
533:
534: IF p_credit_rating_rec.prnt_bkcy_chapter_conv IS NULL THEN
535: x_credit_rating_rec.prnt_bkcy_chapter_conv := FND_API.G_MISS_CHAR;
536: ELSIF p_credit_rating_rec.prnt_bkcy_chapter_conv <> FND_API.G_MISS_CHAR THEN
537: x_credit_rating_rec.prnt_bkcy_chapter_conv := p_credit_rating_rec.prnt_bkcy_chapter_conv;
538: END IF;
539:
540: IF p_credit_rating_rec.slow_trade_expl IS NULL THEN

Line 541: x_credit_rating_rec.slow_trade_expl := FND_API.G_MISS_CHAR;

537: x_credit_rating_rec.prnt_bkcy_chapter_conv := p_credit_rating_rec.prnt_bkcy_chapter_conv;
538: END IF;
539:
540: IF p_credit_rating_rec.slow_trade_expl IS NULL THEN
541: x_credit_rating_rec.slow_trade_expl := FND_API.G_MISS_CHAR;
542: ELSIF p_credit_rating_rec.slow_trade_expl <> FND_API.G_MISS_CHAR THEN
543: x_credit_rating_rec.slow_trade_expl := p_credit_rating_rec.slow_trade_expl;
544: END IF;
545:

Line 542: ELSIF p_credit_rating_rec.slow_trade_expl <> FND_API.G_MISS_CHAR THEN

538: END IF;
539:
540: IF p_credit_rating_rec.slow_trade_expl IS NULL THEN
541: x_credit_rating_rec.slow_trade_expl := FND_API.G_MISS_CHAR;
542: ELSIF p_credit_rating_rec.slow_trade_expl <> FND_API.G_MISS_CHAR THEN
543: x_credit_rating_rec.slow_trade_expl := p_credit_rating_rec.slow_trade_expl;
544: END IF;
545:
546: IF p_credit_rating_rec.negv_pmt_expl IS NULL THEN

Line 547: x_credit_rating_rec.negv_pmt_expl := FND_API.G_MISS_CHAR;

543: x_credit_rating_rec.slow_trade_expl := p_credit_rating_rec.slow_trade_expl;
544: END IF;
545:
546: IF p_credit_rating_rec.negv_pmt_expl IS NULL THEN
547: x_credit_rating_rec.negv_pmt_expl := FND_API.G_MISS_CHAR;
548: ELSIF p_credit_rating_rec.negv_pmt_expl <> FND_API.G_MISS_CHAR THEN
549: x_credit_rating_rec.negv_pmt_expl := p_credit_rating_rec.negv_pmt_expl;
550: END IF;
551:

Line 548: ELSIF p_credit_rating_rec.negv_pmt_expl <> FND_API.G_MISS_CHAR THEN

544: END IF;
545:
546: IF p_credit_rating_rec.negv_pmt_expl IS NULL THEN
547: x_credit_rating_rec.negv_pmt_expl := FND_API.G_MISS_CHAR;
548: ELSIF p_credit_rating_rec.negv_pmt_expl <> FND_API.G_MISS_CHAR THEN
549: x_credit_rating_rec.negv_pmt_expl := p_credit_rating_rec.negv_pmt_expl;
550: END IF;
551:
552: IF p_credit_rating_rec.pub_rec_expl IS NULL THEN

Line 553: x_credit_rating_rec.pub_rec_expl := FND_API.G_MISS_CHAR;

549: x_credit_rating_rec.negv_pmt_expl := p_credit_rating_rec.negv_pmt_expl;
550: END IF;
551:
552: IF p_credit_rating_rec.pub_rec_expl IS NULL THEN
553: x_credit_rating_rec.pub_rec_expl := FND_API.G_MISS_CHAR;
554: ELSIF p_credit_rating_rec.pub_rec_expl <> FND_API.G_MISS_CHAR THEN
555: x_credit_rating_rec.pub_rec_expl := p_credit_rating_rec.pub_rec_expl;
556: END IF;
557:

Line 554: ELSIF p_credit_rating_rec.pub_rec_expl <> FND_API.G_MISS_CHAR THEN

550: END IF;
551:
552: IF p_credit_rating_rec.pub_rec_expl IS NULL THEN
553: x_credit_rating_rec.pub_rec_expl := FND_API.G_MISS_CHAR;
554: ELSIF p_credit_rating_rec.pub_rec_expl <> FND_API.G_MISS_CHAR THEN
555: x_credit_rating_rec.pub_rec_expl := p_credit_rating_rec.pub_rec_expl;
556: END IF;
557:
558: IF p_credit_rating_rec.business_discontinued IS NULL THEN

Line 559: x_credit_rating_rec.business_discontinued := FND_API.G_MISS_CHAR;

555: x_credit_rating_rec.pub_rec_expl := p_credit_rating_rec.pub_rec_expl;
556: END IF;
557:
558: IF p_credit_rating_rec.business_discontinued IS NULL THEN
559: x_credit_rating_rec.business_discontinued := FND_API.G_MISS_CHAR;
560: ELSIF p_credit_rating_rec.business_discontinued <> FND_API.G_MISS_CHAR THEN
561: x_credit_rating_rec.business_discontinued := p_credit_rating_rec.business_discontinued;
562: END IF;
563:

Line 560: ELSIF p_credit_rating_rec.business_discontinued <> FND_API.G_MISS_CHAR THEN

556: END IF;
557:
558: IF p_credit_rating_rec.business_discontinued IS NULL THEN
559: x_credit_rating_rec.business_discontinued := FND_API.G_MISS_CHAR;
560: ELSIF p_credit_rating_rec.business_discontinued <> FND_API.G_MISS_CHAR THEN
561: x_credit_rating_rec.business_discontinued := p_credit_rating_rec.business_discontinued;
562: END IF;
563:
564: IF p_credit_rating_rec.spcl_event_comment IS NULL THEN

Line 565: x_credit_rating_rec.spcl_event_comment := FND_API.G_MISS_CHAR;

561: x_credit_rating_rec.business_discontinued := p_credit_rating_rec.business_discontinued;
562: END IF;
563:
564: IF p_credit_rating_rec.spcl_event_comment IS NULL THEN
565: x_credit_rating_rec.spcl_event_comment := FND_API.G_MISS_CHAR;
566: ELSIF p_credit_rating_rec.spcl_event_comment <> FND_API.G_MISS_CHAR THEN
567: x_credit_rating_rec.spcl_event_comment := p_credit_rating_rec.spcl_event_comment;
568: END IF;
569:

Line 566: ELSIF p_credit_rating_rec.spcl_event_comment <> FND_API.G_MISS_CHAR THEN

562: END IF;
563:
564: IF p_credit_rating_rec.spcl_event_comment IS NULL THEN
565: x_credit_rating_rec.spcl_event_comment := FND_API.G_MISS_CHAR;
566: ELSIF p_credit_rating_rec.spcl_event_comment <> FND_API.G_MISS_CHAR THEN
567: x_credit_rating_rec.spcl_event_comment := p_credit_rating_rec.spcl_event_comment;
568: END IF;
569:
570: IF p_credit_rating_rec.num_spcl_event IS NULL THEN

Line 571: x_credit_rating_rec.num_spcl_event := FND_API.G_MISS_NUM;

567: x_credit_rating_rec.spcl_event_comment := p_credit_rating_rec.spcl_event_comment;
568: END IF;
569:
570: IF p_credit_rating_rec.num_spcl_event IS NULL THEN
571: x_credit_rating_rec.num_spcl_event := FND_API.G_MISS_NUM;
572: ELSIF p_credit_rating_rec.num_spcl_event <> FND_API.G_MISS_NUM THEN
573: x_credit_rating_rec.num_spcl_event := p_credit_rating_rec.num_spcl_event;
574: END IF;
575:

Line 572: ELSIF p_credit_rating_rec.num_spcl_event <> FND_API.G_MISS_NUM THEN

568: END IF;
569:
570: IF p_credit_rating_rec.num_spcl_event IS NULL THEN
571: x_credit_rating_rec.num_spcl_event := FND_API.G_MISS_NUM;
572: ELSIF p_credit_rating_rec.num_spcl_event <> FND_API.G_MISS_NUM THEN
573: x_credit_rating_rec.num_spcl_event := p_credit_rating_rec.num_spcl_event;
574: END IF;
575:
576: IF p_credit_rating_rec.spcl_event_update_date IS NULL THEN

Line 577: x_credit_rating_rec.spcl_event_update_date := FND_API.G_MISS_DATE;

573: x_credit_rating_rec.num_spcl_event := p_credit_rating_rec.num_spcl_event;
574: END IF;
575:
576: IF p_credit_rating_rec.spcl_event_update_date IS NULL THEN
577: x_credit_rating_rec.spcl_event_update_date := FND_API.G_MISS_DATE;
578: ELSIF p_credit_rating_rec.spcl_event_update_date <> FND_API.G_MISS_DATE THEN
579: x_credit_rating_rec.spcl_event_update_date := p_credit_rating_rec.spcl_event_update_date;
580: END IF;
581:

Line 578: ELSIF p_credit_rating_rec.spcl_event_update_date <> FND_API.G_MISS_DATE THEN

574: END IF;
575:
576: IF p_credit_rating_rec.spcl_event_update_date IS NULL THEN
577: x_credit_rating_rec.spcl_event_update_date := FND_API.G_MISS_DATE;
578: ELSIF p_credit_rating_rec.spcl_event_update_date <> FND_API.G_MISS_DATE THEN
579: x_credit_rating_rec.spcl_event_update_date := p_credit_rating_rec.spcl_event_update_date;
580: END IF;
581:
582: IF p_credit_rating_rec.spcl_evnt_txt IS NULL THEN

Line 583: x_credit_rating_rec.spcl_evnt_txt := FND_API.G_MISS_CHAR;

579: x_credit_rating_rec.spcl_event_update_date := p_credit_rating_rec.spcl_event_update_date;
580: END IF;
581:
582: IF p_credit_rating_rec.spcl_evnt_txt IS NULL THEN
583: x_credit_rating_rec.spcl_evnt_txt := FND_API.G_MISS_CHAR;
584: ELSIF p_credit_rating_rec.spcl_evnt_txt <> FND_API.G_MISS_CHAR THEN
585: x_credit_rating_rec.spcl_evnt_txt := p_credit_rating_rec.spcl_evnt_txt;
586: END IF;
587:

Line 584: ELSIF p_credit_rating_rec.spcl_evnt_txt <> FND_API.G_MISS_CHAR THEN

580: END IF;
581:
582: IF p_credit_rating_rec.spcl_evnt_txt IS NULL THEN
583: x_credit_rating_rec.spcl_evnt_txt := FND_API.G_MISS_CHAR;
584: ELSIF p_credit_rating_rec.spcl_evnt_txt <> FND_API.G_MISS_CHAR THEN
585: x_credit_rating_rec.spcl_evnt_txt := p_credit_rating_rec.spcl_evnt_txt;
586: END IF;
587:
588: IF p_credit_rating_rec.actual_content_source IS NULL THEN

Line 589: x_credit_rating_rec.actual_content_source := FND_API.G_MISS_CHAR;

585: x_credit_rating_rec.spcl_evnt_txt := p_credit_rating_rec.spcl_evnt_txt;
586: END IF;
587:
588: IF p_credit_rating_rec.actual_content_source IS NULL THEN
589: x_credit_rating_rec.actual_content_source := FND_API.G_MISS_CHAR;
590: ELSIF p_credit_rating_rec.actual_content_source <> FND_API.G_MISS_CHAR THEN
591: x_credit_rating_rec.actual_content_source := p_credit_rating_rec.actual_content_source;
592: END IF;
593: IF p_create_update_flag = 'C' THEN

Line 590: ELSIF p_credit_rating_rec.actual_content_source <> FND_API.G_MISS_CHAR THEN

586: END IF;
587:
588: IF p_credit_rating_rec.actual_content_source IS NULL THEN
589: x_credit_rating_rec.actual_content_source := FND_API.G_MISS_CHAR;
590: ELSIF p_credit_rating_rec.actual_content_source <> FND_API.G_MISS_CHAR THEN
591: x_credit_rating_rec.actual_content_source := p_credit_rating_rec.actual_content_source;
592: END IF;
593: IF p_create_update_flag = 'C' THEN
594: x_credit_rating_rec.created_by_module := DEFAULT_CREATED_BY_MODULE;

Line 646: p_last_update_date = FND_API.G_MISS_DATE

642: BEGIN
643:
644: -- check required fields:
645: IF p_last_update_date IS NULL OR
646: p_last_update_date = FND_API.G_MISS_DATE
647: THEN
648: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
649: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
650: FND_MSG_PUB.ADD;

Line 651: RAISE FND_API.G_EXC_ERROR;

647: THEN
648: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
649: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: -- get object_version_number
655: BEGIN

Line 668: RAISE FND_API.G_EXC_ERROR;

664: THEN
665: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
666: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_credit_ratings' );
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

Line 677: RAISE FND_API.G_EXC_ERROR;

673: FND_MESSAGE.SET_TOKEN( 'RECORD', 'credit ratings' );
674: FND_MESSAGE.SET_TOKEN( 'VALUE',
675: NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;
678: END;
679:
680: -- pre-process v1 and v2 record.
681: v2_credit_rating_pre (