APPS.OKE_AGREEMENT_PVT dependencies on OKE_API

Line 29: (p_hard_limit = OKE_API.G_MISS_NUM) OR

25:
26: BEGIN
27:
28: IF (p_hard_limit is null) OR
29: (p_hard_limit = OKE_API.G_MISS_NUM) OR
30: (p_hard_limit = 0) THEN
31:
32: return('N');
33:

Line 70: OKE_API.set_message(p_app_name => G_APP_NAME ,

66:
67: IF (c_term%NOTFOUND) THEN
68:
69: CLOSE c_term;
70: OKE_API.set_message(p_app_name => G_APP_NAME ,
71: p_msg_name => 'OKE_API_MISSING_VALUE' ,
72: p_token1 => 'VALUE' ,
73: p_token1_value => 'receivable term_id'
74: );

Line 71: p_msg_name => 'OKE_API_MISSING_VALUE' ,

67: IF (c_term%NOTFOUND) THEN
68:
69: CLOSE c_term;
70: OKE_API.set_message(p_app_name => G_APP_NAME ,
71: p_msg_name => 'OKE_API_MISSING_VALUE' ,
72: p_token1 => 'VALUE' ,
73: p_token1_value => 'receivable term_id'
74: );
75:

Line 76: RAISE OKE_API.G_EXCEPTION_ERROR;

72: p_token1 => 'VALUE' ,
73: p_token1_value => 'receivable term_id'
74: );
75:
76: RAISE OKE_API.G_EXCEPTION_ERROR;
77:
78: END IF;
79:
80: CLOSE c_term;

Line 84: WHEN OKE_API.G_EXCEPTION_ERROR THEN

80: CLOSE c_term;
81: return(l_term);
82:
83: EXCEPTION
84: WHEN OKE_API.G_EXCEPTION_ERROR THEN
85: RAISE OKE_API.G_EXCEPTION_ERROR;
86:
87: WHEN OTHERS THEN
88: OKE_API.set_message(p_app_name => G_APP_NAME ,

Line 85: RAISE OKE_API.G_EXCEPTION_ERROR;

81: return(l_term);
82:
83: EXCEPTION
84: WHEN OKE_API.G_EXCEPTION_ERROR THEN
85: RAISE OKE_API.G_EXCEPTION_ERROR;
86:
87: WHEN OTHERS THEN
88: OKE_API.set_message(p_app_name => G_APP_NAME ,
89: p_msg_name => G_UNEXPECTED_ERROR ,

Line 88: OKE_API.set_message(p_app_name => G_APP_NAME ,

84: WHEN OKE_API.G_EXCEPTION_ERROR THEN
85: RAISE OKE_API.G_EXCEPTION_ERROR;
86:
87: WHEN OTHERS THEN
88: OKE_API.set_message(p_app_name => G_APP_NAME ,
89: p_msg_name => G_UNEXPECTED_ERROR ,
90: p_token1 => G_SQLCODE_TOKEN ,
91: p_token1_value => SQLCODE ,
92: p_token2 => G_SQLERRM_TOKEN ,

Line 100: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

96: IF c_term%ISOPEN THEN
97: CLOSE c_term;
98: END IF;
99:
100: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
101:
102: END get_term_id;
103:
104:

Line 119: IF l_funding_in_rec.pa_attribute_category = OKE_API.G_MISS_CHAR THEN

115: l_funding_in_rec OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE := p_funding_in_rec;
116:
117: BEGIN
118:
119: IF l_funding_in_rec.pa_attribute_category = OKE_API.G_MISS_CHAR THEN
120: l_funding_in_rec.pa_attribute_category := null;
121: END IF;
122:
123: IF l_funding_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN

Line 123: IF l_funding_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN

119: IF l_funding_in_rec.pa_attribute_category = OKE_API.G_MISS_CHAR THEN
120: l_funding_in_rec.pa_attribute_category := null;
121: END IF;
122:
123: IF l_funding_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN
124: l_funding_in_rec.pa_attribute1 := null;
125: END IF;
126:
127: IF l_funding_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN

Line 127: IF l_funding_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN

123: IF l_funding_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN
124: l_funding_in_rec.pa_attribute1 := null;
125: END IF;
126:
127: IF l_funding_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN
128: l_funding_in_rec.pa_attribute2 := null;
129: END IF;
130:
131: IF l_funding_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN

Line 131: IF l_funding_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN

127: IF l_funding_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN
128: l_funding_in_rec.pa_attribute2 := null;
129: END IF;
130:
131: IF l_funding_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN
132: l_funding_in_rec.pa_attribute3 := null;
133: END IF;
134:
135: IF l_funding_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN

Line 135: IF l_funding_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN

131: IF l_funding_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN
132: l_funding_in_rec.pa_attribute3 := null;
133: END IF;
134:
135: IF l_funding_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN
136: l_funding_in_rec.pa_attribute4 := null;
137: END IF;
138:
139: IF l_funding_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN

Line 139: IF l_funding_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN

135: IF l_funding_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN
136: l_funding_in_rec.pa_attribute4 := null;
137: END IF;
138:
139: IF l_funding_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN
140: l_funding_in_rec.pa_attribute5 := null;
141: END IF;
142:
143: IF l_funding_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN

Line 143: IF l_funding_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN

139: IF l_funding_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN
140: l_funding_in_rec.pa_attribute5 := null;
141: END IF;
142:
143: IF l_funding_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN
144: l_funding_in_rec.pa_attribute6 := null;
145: END IF;
146:
147: IF l_funding_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN

Line 147: IF l_funding_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN

143: IF l_funding_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN
144: l_funding_in_rec.pa_attribute6 := null;
145: END IF;
146:
147: IF l_funding_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN
148: l_funding_in_rec.pa_attribute7 := null;
149: END IF;
150:
151: IF l_funding_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN

Line 151: IF l_funding_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN

147: IF l_funding_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN
148: l_funding_in_rec.pa_attribute7 := null;
149: END IF;
150:
151: IF l_funding_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN
152: l_funding_in_rec.pa_attribute8 := null;
153: END IF;
154:
155: IF l_funding_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN

Line 155: IF l_funding_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN

151: IF l_funding_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN
152: l_funding_in_rec.pa_attribute8 := null;
153: END IF;
154:
155: IF l_funding_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN
156: l_funding_in_rec.pa_attribute9 := null;
157: END IF;
158:
159: IF l_funding_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN

Line 159: IF l_funding_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN

155: IF l_funding_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN
156: l_funding_in_rec.pa_attribute9 := null;
157: END IF;
158:
159: IF l_funding_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN
160: l_funding_in_rec.pa_attribute10 := null;
161: END IF;
162:
163: IF l_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM THEN

Line 163: IF l_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM THEN

159: IF l_funding_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN
160: l_funding_in_rec.pa_attribute10 := null;
161: END IF;
162:
163: IF l_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM THEN
164: l_funding_in_rec.agreement_org_id := null;
165: END IF;
166:
167: return(l_funding_in_rec);

Line 203: IF l_allocation_in_rec.pa_attribute_category = OKE_API.G_MISS_CHAR THEN

199: l_allocation_in_rec.task_id := l_allocation_row.task_id;
200: l_allocation_in_rec.start_date_active := l_allocation_row.start_date_active;
201: l_allocation_in_rec.funding_category := l_allocation_row.funding_category;
202:
203: IF l_allocation_in_rec.pa_attribute_category = OKE_API.G_MISS_CHAR THEN
204: l_allocation_in_rec.pa_attribute_category := l_allocation_row.pa_attribute_category;
205: END IF;
206:
207: IF l_allocation_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN

Line 207: IF l_allocation_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN

203: IF l_allocation_in_rec.pa_attribute_category = OKE_API.G_MISS_CHAR THEN
204: l_allocation_in_rec.pa_attribute_category := l_allocation_row.pa_attribute_category;
205: END IF;
206:
207: IF l_allocation_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN
208: l_allocation_in_rec.pa_attribute1 := l_allocation_row.pa_attribute1;
209: END IF;
210:
211: IF l_allocation_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN

Line 211: IF l_allocation_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN

207: IF l_allocation_in_rec.pa_attribute1 = OKE_API.G_MISS_CHAR THEN
208: l_allocation_in_rec.pa_attribute1 := l_allocation_row.pa_attribute1;
209: END IF;
210:
211: IF l_allocation_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN
212: l_allocation_in_rec.pa_attribute2 := l_allocation_row.pa_attribute2;
213: END IF;
214:
215: IF l_allocation_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN

Line 215: IF l_allocation_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN

211: IF l_allocation_in_rec.pa_attribute2 = OKE_API.G_MISS_CHAR THEN
212: l_allocation_in_rec.pa_attribute2 := l_allocation_row.pa_attribute2;
213: END IF;
214:
215: IF l_allocation_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN
216: l_allocation_in_rec.pa_attribute3 := l_allocation_row.pa_attribute3;
217: END IF;
218:
219: IF l_allocation_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN

Line 219: IF l_allocation_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN

215: IF l_allocation_in_rec.pa_attribute3 = OKE_API.G_MISS_CHAR THEN
216: l_allocation_in_rec.pa_attribute3 := l_allocation_row.pa_attribute3;
217: END IF;
218:
219: IF l_allocation_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN
220: l_allocation_in_rec.pa_attribute4 := l_allocation_row.pa_attribute4;
221: END IF;
222:
223: IF l_allocation_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN

Line 223: IF l_allocation_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN

219: IF l_allocation_in_rec.pa_attribute4 = OKE_API.G_MISS_CHAR THEN
220: l_allocation_in_rec.pa_attribute4 := l_allocation_row.pa_attribute4;
221: END IF;
222:
223: IF l_allocation_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN
224: l_allocation_in_rec.pa_attribute5 := l_allocation_row.pa_attribute5;
225: END IF;
226:
227: IF l_allocation_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN

Line 227: IF l_allocation_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN

223: IF l_allocation_in_rec.pa_attribute5 = OKE_API.G_MISS_CHAR THEN
224: l_allocation_in_rec.pa_attribute5 := l_allocation_row.pa_attribute5;
225: END IF;
226:
227: IF l_allocation_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN
228: l_allocation_in_rec.pa_attribute6 := l_allocation_row.pa_attribute6;
229: END IF;
230:
231: IF l_allocation_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN

Line 231: IF l_allocation_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN

227: IF l_allocation_in_rec.pa_attribute6 = OKE_API.G_MISS_CHAR THEN
228: l_allocation_in_rec.pa_attribute6 := l_allocation_row.pa_attribute6;
229: END IF;
230:
231: IF l_allocation_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN
232: l_allocation_in_rec.pa_attribute7 := l_allocation_row.pa_attribute7;
233: END IF;
234:
235: IF l_allocation_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN

Line 235: IF l_allocation_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN

231: IF l_allocation_in_rec.pa_attribute7 = OKE_API.G_MISS_CHAR THEN
232: l_allocation_in_rec.pa_attribute7 := l_allocation_row.pa_attribute7;
233: END IF;
234:
235: IF l_allocation_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN
236: l_allocation_in_rec.pa_attribute8 := l_allocation_row.pa_attribute8;
237: END IF;
238:
239: IF l_allocation_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN

Line 239: IF l_allocation_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN

235: IF l_allocation_in_rec.pa_attribute8 = OKE_API.G_MISS_CHAR THEN
236: l_allocation_in_rec.pa_attribute8 := l_allocation_row.pa_attribute8;
237: END IF;
238:
239: IF l_allocation_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN
240: l_allocation_in_rec.pa_attribute9 := l_allocation_row.pa_attribute9;
241: END IF;
242:
243: IF l_allocation_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN

Line 243: IF l_allocation_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN

239: IF l_allocation_in_rec.pa_attribute9 = OKE_API.G_MISS_CHAR THEN
240: l_allocation_in_rec.pa_attribute9 := l_allocation_row.pa_attribute9;
241: END IF;
242:
243: IF l_allocation_in_rec.pa_attribute10 = OKE_API.G_MISS_CHAR THEN
244: l_allocation_in_rec.pa_attribute10 := l_allocation_row.pa_attribute10;
245: END IF;
246:
247: return(l_allocation_in_rec);

Line 425: OKE_API.set_message(p_app_name => G_APP_NAME ,

421: IF (c_org%NOTFOUND) THEN
422:
423: CLOSE c_org;
424:
425: OKE_API.set_message(p_app_name => G_APP_NAME ,
426: p_msg_name => 'OKE_API_INVALID_VALUE' ,
427: p_token1 => 'VALUE' ,
428: p_token1_value => 'agreement_id'
429: );

Line 426: p_msg_name => 'OKE_API_INVALID_VALUE' ,

422:
423: CLOSE c_org;
424:
425: OKE_API.set_message(p_app_name => G_APP_NAME ,
426: p_msg_name => 'OKE_API_INVALID_VALUE' ,
427: p_token1 => 'VALUE' ,
428: p_token1_value => 'agreement_id'
429: );
430:

Line 431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

427: p_token1 => 'VALUE' ,
428: p_token1_value => 'agreement_id'
429: );
430:
431: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
432:
433: END IF;
434:
435: CLOSE c_org;

Line 469: OKE_API.set_message(p_app_name => G_APP_NAME ,

465: FETCH c_project into p_project_funding;
466:
467: IF (c_project%NOTFOUND) THEN
468:
469: OKE_API.set_message(p_app_name => G_APP_NAME ,
470: p_msg_name => 'OKE_API_INVALID_VALUE' ,
471: p_token1 => 'VALUE' ,
472: p_token1_value => 'project_funding_id'
473: );

Line 470: p_msg_name => 'OKE_API_INVALID_VALUE' ,

466:
467: IF (c_project%NOTFOUND) THEN
468:
469: OKE_API.set_message(p_app_name => G_APP_NAME ,
470: p_msg_name => 'OKE_API_INVALID_VALUE' ,
471: p_token1 => 'VALUE' ,
472: p_token1_value => 'project_funding_id'
473: );
474:

Line 477: RAISE OKE_API.G_EXCEPTION_ERROR;

473: );
474:
475: CLOSE c_project;
476:
477: RAISE OKE_API.G_EXCEPTION_ERROR;
478:
479: END IF;
480:
481: CLOSE c_project;

Line 484: WHEN G_EXCEPTION_HALT_VALIDATION OR OKE_API.G_EXCEPTION_ERROR THEN

480:
481: CLOSE c_project;
482:
483: EXCEPTION
484: WHEN G_EXCEPTION_HALT_VALIDATION OR OKE_API.G_EXCEPTION_ERROR THEN
485: raise G_EXCEPTION_HALT_VALIDATION;
486:
487: WHEN OTHERS THEN
488: OKE_API.set_message(p_app_name => G_APP_NAME ,

Line 488: OKE_API.set_message(p_app_name => G_APP_NAME ,

484: WHEN G_EXCEPTION_HALT_VALIDATION OR OKE_API.G_EXCEPTION_ERROR THEN
485: raise G_EXCEPTION_HALT_VALIDATION;
486:
487: WHEN OTHERS THEN
488: OKE_API.set_message(p_app_name => G_APP_NAME ,
489: p_msg_name => G_UNEXPECTED_ERROR ,
490: p_token1 => G_SQLCODE_TOKEN ,
491: p_token1_value => SQLCODE ,
492: p_token2 => G_SQLERRM_TOKEN ,

Line 500: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

496: IF c_project%ISOPEN THEN
497: CLOSE c_project;
498: END IF;
499:
500: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
501:
502: END get_proj_funding;
503:
504:

Line 517: p_return_status := OKE_API.G_RET_STS_SUCCESS;

513: p_return_status OUT NOCOPY VARCHAR2
514: ) is
515: BEGIN
516:
517: p_return_status := OKE_API.G_RET_STS_SUCCESS;
518:
519: IF (p_agreement_id is null) OR
520: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
521:

Line 520: (p_agreement_id = OKE_API.G_MISS_NUM) THEN

516:
517: p_return_status := OKE_API.G_RET_STS_SUCCESS;
518:
519: IF (p_agreement_id is null) OR
520: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
521:
522: OKE_API.set_message(p_app_name => G_APP_NAME ,
523: p_msg_name => 'OKE_API_MISSING_VALUE' ,
524: p_token1 => 'VALUE' ,

Line 522: OKE_API.set_message(p_app_name => G_APP_NAME ,

518:
519: IF (p_agreement_id is null) OR
520: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
521:
522: OKE_API.set_message(p_app_name => G_APP_NAME ,
523: p_msg_name => 'OKE_API_MISSING_VALUE' ,
524: p_token1 => 'VALUE' ,
525: p_token1_value => 'agreement_id'
526: );

Line 523: p_msg_name => 'OKE_API_MISSING_VALUE' ,

519: IF (p_agreement_id is null) OR
520: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
521:
522: OKE_API.set_message(p_app_name => G_APP_NAME ,
523: p_msg_name => 'OKE_API_MISSING_VALUE' ,
524: p_token1 => 'VALUE' ,
525: p_token1_value => 'agreement_id'
526: );
527:

Line 528: p_return_status := OKE_API.G_RET_STS_ERROR;

524: p_token1 => 'VALUE' ,
525: p_token1_value => 'agreement_id'
526: );
527:
528: p_return_status := OKE_API.G_RET_STS_ERROR;
529:
530: END IF;
531:
532: END validate_agreement_id;

Line 547: p_return_status := OKE_API.G_RET_STS_SUCCESS;

543: p_return_status OUT NOCOPY VARCHAR2
544: ) is
545: BEGIN
546:
547: p_return_status := OKE_API.G_RET_STS_SUCCESS;
548:
549: IF (p_project_id is null) OR
550: (p_project_id = OKE_API.G_MISS_NUM) THEN
551:

Line 550: (p_project_id = OKE_API.G_MISS_NUM) THEN

546:
547: p_return_status := OKE_API.G_RET_STS_SUCCESS;
548:
549: IF (p_project_id is null) OR
550: (p_project_id = OKE_API.G_MISS_NUM) THEN
551:
552: OKE_API.set_message(p_app_name => G_APP_NAME ,
553: p_msg_name => 'OKE_API_MISSING_VALUE' ,
554: p_token1 => 'VALUE' ,

Line 552: OKE_API.set_message(p_app_name => G_APP_NAME ,

548:
549: IF (p_project_id is null) OR
550: (p_project_id = OKE_API.G_MISS_NUM) THEN
551:
552: OKE_API.set_message(p_app_name => G_APP_NAME ,
553: p_msg_name => 'OKE_API_MISSING_VALUE' ,
554: p_token1 => 'VALUE' ,
555: p_token1_value => 'project_id'
556: );

Line 553: p_msg_name => 'OKE_API_MISSING_VALUE' ,

549: IF (p_project_id is null) OR
550: (p_project_id = OKE_API.G_MISS_NUM) THEN
551:
552: OKE_API.set_message(p_app_name => G_APP_NAME ,
553: p_msg_name => 'OKE_API_MISSING_VALUE' ,
554: p_token1 => 'VALUE' ,
555: p_token1_value => 'project_id'
556: );
557:

Line 558: p_return_status := OKE_API.G_RET_STS_ERROR;

554: p_token1 => 'VALUE' ,
555: p_token1_value => 'project_id'
556: );
557:
558: p_return_status := OKE_API.G_RET_STS_ERROR;
559:
560: END IF;
561:
562: END validate_project_id;

Line 582: p_return_status := OKE_API.G_RET_STS_SUCCESS;

578: l_project_number VARCHAR2(25);
579:
580: BEGIN
581:
582: p_return_status := OKE_API.G_RET_STS_SUCCESS;
583:
584: IF (p_task_id is not null) OR
585: (p_task_id <> OKE_API.G_MISS_NUM) THEN
586:

Line 585: (p_task_id <> OKE_API.G_MISS_NUM) THEN

581:
582: p_return_status := OKE_API.G_RET_STS_SUCCESS;
583:
584: IF (p_task_id is not null) OR
585: (p_task_id <> OKE_API.G_MISS_NUM) THEN
586:
587: OKE_FUNDING_UTIL_PKG.multi_customer(x_project_id => p_project_id ,
588: x_project_number => l_project_number,
589: x_count => l_count

Line 594: OKE_API.set_message(p_app_name => G_APP_NAME ,

590: );
591:
592: IF (l_count > 1) then
593:
594: OKE_API.set_message(p_app_name => G_APP_NAME ,
595: p_msg_name => 'OKE_MULTI_CUSTOMER_PROJ' ,
596: p_token1 => 'PROJECT' ,
597: p_token1_value => l_project_number
598: );

Line 600: p_return_status := OKE_API.G_RET_STS_ERROR;

596: p_token1 => 'PROJECT' ,
597: p_token1_value => l_project_number
598: );
599:
600: p_return_status := OKE_API.G_RET_STS_ERROR;
601:
602: END IF;
603:
604: END IF;

Line 621: p_return_status := OKE_API.G_RET_STS_SUCCESS;

617: p_return_status OUT NOCOPY VARCHAR2
618: ) is
619: BEGIN
620:
621: p_return_status := OKE_API.G_RET_STS_SUCCESS;
622:
623: IF (p_date_allocated is null) OR
624: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
625:

Line 624: (p_date_allocated = OKE_API.G_MISS_DATE) THEN

620:
621: p_return_status := OKE_API.G_RET_STS_SUCCESS;
622:
623: IF (p_date_allocated is null) OR
624: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
625:
626: OKE_API.set_message(p_app_name => G_APP_NAME ,
627: p_msg_name => 'OKE_API_MISSING_VALUE' ,
628: p_token1 => 'VALUE' ,

Line 626: OKE_API.set_message(p_app_name => G_APP_NAME ,

622:
623: IF (p_date_allocated is null) OR
624: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
625:
626: OKE_API.set_message(p_app_name => G_APP_NAME ,
627: p_msg_name => 'OKE_API_MISSING_VALUE' ,
628: p_token1 => 'VALUE' ,
629: p_token1_value => 'start_date_active'
630: );

Line 627: p_msg_name => 'OKE_API_MISSING_VALUE' ,

623: IF (p_date_allocated is null) OR
624: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
625:
626: OKE_API.set_message(p_app_name => G_APP_NAME ,
627: p_msg_name => 'OKE_API_MISSING_VALUE' ,
628: p_token1 => 'VALUE' ,
629: p_token1_value => 'start_date_active'
630: );
631:

Line 632: p_return_status := OKE_API.G_RET_STS_ERROR;

628: p_token1 => 'VALUE' ,
629: p_token1_value => 'start_date_active'
630: );
631:
632: p_return_status := OKE_API.G_RET_STS_ERROR;
633:
634: END IF;
635:
636: END validate_date_allocated;

Line 651: p_return_status := OKE_API.G_RET_STS_SUCCESS;

647: p_return_status OUT NOCOPY VARCHAR2
648: ) is
649: BEGIN
650:
651: p_return_status := OKE_API.G_RET_STS_SUCCESS;
652:
653: IF (p_funding_category is null) OR
654: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
655:

Line 654: (p_funding_category = OKE_API.G_MISS_CHAR) THEN

650:
651: p_return_status := OKE_API.G_RET_STS_SUCCESS;
652:
653: IF (p_funding_category is null) OR
654: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
655:
656: OKE_API.set_message(p_app_name => G_APP_NAME ,
657: p_msg_name => 'OKE_API_MISSING_VALUE' ,
658: p_token1 => 'VALUE' ,

Line 656: OKE_API.set_message(p_app_name => G_APP_NAME ,

652:
653: IF (p_funding_category is null) OR
654: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
655:
656: OKE_API.set_message(p_app_name => G_APP_NAME ,
657: p_msg_name => 'OKE_API_MISSING_VALUE' ,
658: p_token1 => 'VALUE' ,
659: p_token1_value => 'funding_category'
660: );

Line 657: p_msg_name => 'OKE_API_MISSING_VALUE' ,

653: IF (p_funding_category is null) OR
654: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
655:
656: OKE_API.set_message(p_app_name => G_APP_NAME ,
657: p_msg_name => 'OKE_API_MISSING_VALUE' ,
658: p_token1 => 'VALUE' ,
659: p_token1_value => 'funding_category'
660: );
661:

Line 662: p_return_status := OKE_API.G_RET_STS_ERROR;

658: p_token1 => 'VALUE' ,
659: p_token1_value => 'funding_category'
660: );
661:
662: p_return_status := OKE_API.G_RET_STS_ERROR;
663:
664: END IF;
665:
666: END validate_funding_category;

Line 687: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

683:
684: validate_agreement_id(p_agreement_id => p_allocation_in_rec.agreement_id ,
685: p_return_status => l_return_status);
686:
687: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
688:
689: RAISE G_EXCEPTION_HALT_VALIDATION;
690:
691: END IF;

Line 700: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

696:
697: validate_project_id(p_project_id => p_allocation_in_rec.project_id ,
698: p_return_status => l_return_status);
699:
700: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
701:
702: RAISE G_EXCEPTION_HALT_VALIDATION;
703:
704: END IF;

Line 715: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

711: validate_task_id(p_task_id => p_allocation_in_rec.task_id ,
712: p_project_id => p_allocation_in_rec.project_id ,
713: p_return_status => l_return_status);
714:
715: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
716:
717: RAISE G_EXCEPTION_HALT_VALIDATION;
718:
719: END IF;

Line 730: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

726:
727: validate_date_allocated(p_date_allocated => p_allocation_in_rec.start_date_active ,
728: p_return_status => l_return_status);
729:
730: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
731:
732: RAISE G_EXCEPTION_HALT_VALIDATION;
733:
734: END IF;

Line 743: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

739:
740: validate_funding_category(p_funding_category => p_allocation_in_rec.funding_category ,
741: p_return_status => l_return_status);
742:
743: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
744:
745: RAISE G_EXCEPTION_HALT_VALIDATION;
746:
747: END IF;

Line 775: WHEN OKE_API.G_EXCEPTION_ERROR THEN

771: FETCH c_currency into p_min_unit;
772: CLOSE c_currency;
773:
774: EXCEPTION
775: WHEN OKE_API.G_EXCEPTION_ERROR THEN
776: RAISE OKE_API.G_EXCEPTION_ERROR;
777:
778: WHEN OTHERS THEN
779: OKE_API.set_message(p_app_name => G_APP_NAME ,

Line 776: RAISE OKE_API.G_EXCEPTION_ERROR;

772: CLOSE c_currency;
773:
774: EXCEPTION
775: WHEN OKE_API.G_EXCEPTION_ERROR THEN
776: RAISE OKE_API.G_EXCEPTION_ERROR;
777:
778: WHEN OTHERS THEN
779: OKE_API.set_message(p_app_name => G_APP_NAME ,
780: p_msg_name => G_UNEXPECTED_ERROR ,

Line 779: OKE_API.set_message(p_app_name => G_APP_NAME ,

775: WHEN OKE_API.G_EXCEPTION_ERROR THEN
776: RAISE OKE_API.G_EXCEPTION_ERROR;
777:
778: WHEN OTHERS THEN
779: OKE_API.set_message(p_app_name => G_APP_NAME ,
780: p_msg_name => G_UNEXPECTED_ERROR ,
781: p_token1 => G_SQLCODE_TOKEN ,
782: p_token1_value => SQLCODE ,
783: p_token2 => G_SQLERRM_TOKEN ,

Line 791: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

787: IF c_currency%ISOPEN THEN
788: CLOSE c_currency;
789: END IF;
790:
791: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
792:
793: END get_min_unit;
794:
795:

Line 894: OKE_API.set_message(p_app_name => G_APP_NAME ,

890: END IF;
891:
892: EXCEPTION
893: WHEN NO_FUND THEN
894: OKE_API.set_message(p_app_name => G_APP_NAME ,
895: p_msg_name => 'OKE_API_INVALID_VALUE' ,
896: p_token1 => 'VALUE' ,
897: p_token1_value => 'funding_source_id'
898: );

Line 895: p_msg_name => 'OKE_API_INVALID_VALUE' ,

891:
892: EXCEPTION
893: WHEN NO_FUND THEN
894: OKE_API.set_message(p_app_name => G_APP_NAME ,
895: p_msg_name => 'OKE_API_INVALID_VALUE' ,
896: p_token1 => 'VALUE' ,
897: p_token1_value => 'funding_source_id'
898: );
899:

Line 904: RAISE OKE_API.G_EXCEPTION_ERROR;

900: IF c_currency%ISOPEN THEN
901: CLOSE c_currency;
902: END IF;
903:
904: RAISE OKE_API.G_EXCEPTION_ERROR;
905:
906: WHEN OTHERS THEN
907: OKE_API.set_message(p_app_name => G_APP_NAME ,
908: p_msg_name => G_UNEXPECTED_ERROR ,

Line 907: OKE_API.set_message(p_app_name => G_APP_NAME ,

903:
904: RAISE OKE_API.G_EXCEPTION_ERROR;
905:
906: WHEN OTHERS THEN
907: OKE_API.set_message(p_app_name => G_APP_NAME ,
908: p_msg_name => G_UNEXPECTED_ERROR ,
909: p_token1 => G_SQLCODE_TOKEN ,
910: p_token1_value => SQLCODE ,
911: p_token2 => G_SQLERRM_TOKEN ,

Line 927: RAISE OKE_API.G_EXCEPTION_ERROR;

923: IF c_ou%ISOPEN THEN
924: CLOSE c_ou;
925: END IF;
926:
927: RAISE OKE_API.G_EXCEPTION_ERROR;
928:
929: END get_converted_amount;
930:
931:

Line 952: p_return_status := OKE_API.G_RET_STS_SUCCESS;

948: l_dummy_value VARCHAR2(1) := '?';
949:
950: BEGIN
951:
952: p_return_status := OKE_API.G_RET_STS_SUCCESS;
953:
954: IF (p_agreement_type is not null) OR
955: (p_agreement_type <> OKE_API.G_MISS_CHAR) THEN
956:

Line 955: (p_agreement_type <> OKE_API.G_MISS_CHAR) THEN

951:
952: p_return_status := OKE_API.G_RET_STS_SUCCESS;
953:
954: IF (p_agreement_type is not null) OR
955: (p_agreement_type <> OKE_API.G_MISS_CHAR) THEN
956:
957: OPEN c_agreement_type;
958: FETCH c_agreement_type into l_dummy_value;
959: CLOSE c_agreement_type;

Line 963: OKE_API.set_message(p_app_name => G_APP_NAME ,

959: CLOSE c_agreement_type;
960:
961: IF (l_dummy_value = '?') THEN
962:
963: OKE_API.set_message(p_app_name => G_APP_NAME ,
964: p_msg_name => 'OKE_API_INVALID_VALUE' ,
965: p_token1 => 'VALUE' ,
966: p_token1_value => 'agreement_type'
967: );

Line 964: p_msg_name => 'OKE_API_INVALID_VALUE' ,

960:
961: IF (l_dummy_value = '?') THEN
962:
963: OKE_API.set_message(p_app_name => G_APP_NAME ,
964: p_msg_name => 'OKE_API_INVALID_VALUE' ,
965: p_token1 => 'VALUE' ,
966: p_token1_value => 'agreement_type'
967: );
968:

Line 969: p_return_status := OKE_API.G_RET_STS_ERROR;

965: p_token1 => 'VALUE' ,
966: p_token1_value => 'agreement_type'
967: );
968:
969: p_return_status := OKE_API.G_RET_STS_ERROR;
970:
971: END IF;
972:
973: ELSE

Line 975: OKE_API.set_message(p_app_name => G_APP_NAME ,

971: END IF;
972:
973: ELSE
974:
975: OKE_API.set_message(p_app_name => G_APP_NAME ,
976: p_msg_name => 'OKE_API_MISSING_VALUE' ,
977: p_token1 => 'VALUE' ,
978: p_token1_value => 'p_agreement_type'
979: );

Line 976: p_msg_name => 'OKE_API_MISSING_VALUE' ,

972:
973: ELSE
974:
975: OKE_API.set_message(p_app_name => G_APP_NAME ,
976: p_msg_name => 'OKE_API_MISSING_VALUE' ,
977: p_token1 => 'VALUE' ,
978: p_token1_value => 'p_agreement_type'
979: );
980:

Line 981: p_return_status := OKE_API.G_RET_STS_ERROR;

977: p_token1 => 'VALUE' ,
978: p_token1_value => 'p_agreement_type'
979: );
980:
981: p_return_status := OKE_API.G_RET_STS_ERROR;
982:
983: END IF;
984:
985: EXCEPTION

Line 987: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

983: END IF;
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
988: OKE_API.set_message(p_app_name => G_APP_NAME ,
989: p_msg_name => G_UNEXPECTED_ERROR ,
990: p_token1 => G_SQLCODE_TOKEN ,
991: p_token1_value => SQLCODE ,

Line 988: OKE_API.set_message(p_app_name => G_APP_NAME ,

984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
988: OKE_API.set_message(p_app_name => G_APP_NAME ,
989: p_msg_name => G_UNEXPECTED_ERROR ,
990: p_token1 => G_SQLCODE_TOKEN ,
991: p_token1_value => SQLCODE ,
992: p_token2 => G_SQLERRM_TOKEN ,

Line 1027: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1023: l_dummy_value VARCHAR2(1) := '?';
1024:
1025: BEGIN
1026:
1027: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1028:
1029: IF (p_customer_num is null) OR
1030: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1031:

Line 1030: (p_customer_num = OKE_API.G_MISS_CHAR) THEN

1026:
1027: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1028:
1029: IF (p_customer_num is null) OR
1030: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1031:
1032: OKE_API.set_message(p_app_name => G_APP_NAME ,
1033: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1034: p_token1 => 'VALUE' ,

Line 1032: OKE_API.set_message(p_app_name => G_APP_NAME ,

1028:
1029: IF (p_customer_num is null) OR
1030: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1031:
1032: OKE_API.set_message(p_app_name => G_APP_NAME ,
1033: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1034: p_token1 => 'VALUE' ,
1035: p_token1_value => 'customer_number'
1036: );

Line 1033: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1029: IF (p_customer_num is null) OR
1030: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1031:
1032: OKE_API.set_message(p_app_name => G_APP_NAME ,
1033: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1034: p_token1 => 'VALUE' ,
1035: p_token1_value => 'customer_number'
1036: );
1037:

Line 1038: p_return_status := OKE_API.G_RET_STS_ERROR;

1034: p_token1 => 'VALUE' ,
1035: p_token1_value => 'customer_number'
1036: );
1037:
1038: p_return_status := OKE_API.G_RET_STS_ERROR;
1039:
1040: ELSE
1041:
1042: OPEN c_customer;

Line 1048: OKE_API.set_message(p_app_name => G_APP_NAME ,

1044: CLOSE c_customer;
1045:
1046: IF (l_dummy_value = '?') THEN
1047:
1048: OKE_API.set_message(p_app_name => G_APP_NAME ,
1049: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1050: p_token1 => 'VALUE' ,
1051: p_token1_value => 'customer_number'
1052: );

Line 1049: p_msg_name => 'OKE_API_INVALID_VALUE' ,

1045:
1046: IF (l_dummy_value = '?') THEN
1047:
1048: OKE_API.set_message(p_app_name => G_APP_NAME ,
1049: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1050: p_token1 => 'VALUE' ,
1051: p_token1_value => 'customer_number'
1052: );
1053:

Line 1054: p_return_status := OKE_API.G_RET_STS_ERROR;

1050: p_token1 => 'VALUE' ,
1051: p_token1_value => 'customer_number'
1052: );
1053:
1054: p_return_status := OKE_API.G_RET_STS_ERROR;
1055:
1056: END IF;
1057:
1058: END IF;

Line 1062: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1058: END IF;
1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1063: OKE_API.set_message(p_app_name => G_APP_NAME ,
1064: p_msg_name => G_UNEXPECTED_ERROR ,
1065: p_token1 => G_SQLCODE_TOKEN ,
1066: p_token1_value => SQLCODE ,

Line 1063: OKE_API.set_message(p_app_name => G_APP_NAME ,

1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1063: OKE_API.set_message(p_app_name => G_APP_NAME ,
1064: p_msg_name => G_UNEXPECTED_ERROR ,
1065: p_token1 => G_SQLCODE_TOKEN ,
1066: p_token1_value => SQLCODE ,
1067: p_token2 => G_SQLERRM_TOKEN ,

Line 1100: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1096: l_dummy_value VARCHAR2(1) := '?';
1097:
1098: BEGIN
1099:
1100: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1101:
1102: IF (p_customer_id is null) OR
1103: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1104:

Line 1103: (p_customer_id = OKE_API.G_MISS_NUM) THEN

1099:
1100: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1101:
1102: IF (p_customer_id is null) OR
1103: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1104:
1105: OKE_API.set_message(p_app_name => G_APP_NAME ,
1106: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1107: p_token1 => 'VALUE' ,

Line 1105: OKE_API.set_message(p_app_name => G_APP_NAME ,

1101:
1102: IF (p_customer_id is null) OR
1103: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1104:
1105: OKE_API.set_message(p_app_name => G_APP_NAME ,
1106: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1107: p_token1 => 'VALUE' ,
1108: p_token1_value => 'customer_id'
1109: );

Line 1106: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1102: IF (p_customer_id is null) OR
1103: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1104:
1105: OKE_API.set_message(p_app_name => G_APP_NAME ,
1106: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1107: p_token1 => 'VALUE' ,
1108: p_token1_value => 'customer_id'
1109: );
1110:

Line 1111: p_return_status := OKE_API.G_RET_STS_ERROR;

1107: p_token1 => 'VALUE' ,
1108: p_token1_value => 'customer_id'
1109: );
1110:
1111: p_return_status := OKE_API.G_RET_STS_ERROR;
1112:
1113: ELSE
1114:
1115: OPEN c_customer_id;

Line 1121: OKE_API.set_message(p_app_name => G_APP_NAME ,

1117: CLOSE c_customer_id;
1118: --dbms_output.put_line('l_dummy_value' || l_dummy_value);
1119: IF (l_dummy_value = '?') THEN
1120:
1121: OKE_API.set_message(p_app_name => G_APP_NAME ,
1122: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1123: p_token1 => 'VALUE' ,
1124: p_token1_value => 'customer_id'
1125: );

Line 1122: p_msg_name => 'OKE_API_INVALID_VALUE' ,

1118: --dbms_output.put_line('l_dummy_value' || l_dummy_value);
1119: IF (l_dummy_value = '?') THEN
1120:
1121: OKE_API.set_message(p_app_name => G_APP_NAME ,
1122: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1123: p_token1 => 'VALUE' ,
1124: p_token1_value => 'customer_id'
1125: );
1126:

Line 1127: p_return_status := OKE_API.G_RET_STS_ERROR;

1123: p_token1 => 'VALUE' ,
1124: p_token1_value => 'customer_id'
1125: );
1126:
1127: p_return_status := OKE_API.G_RET_STS_ERROR;
1128:
1129: END IF;
1130:
1131: END IF;

Line 1135: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1131: END IF;
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1136: OKE_API.set_message(p_app_name => G_APP_NAME ,
1137: p_msg_name => G_UNEXPECTED_ERROR ,
1138: p_token1 => G_SQLCODE_TOKEN ,
1139: p_token1_value => SQLCODE ,

Line 1136: OKE_API.set_message(p_app_name => G_APP_NAME ,

1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1136: OKE_API.set_message(p_app_name => G_APP_NAME ,
1137: p_msg_name => G_UNEXPECTED_ERROR ,
1138: p_token1 => G_SQLCODE_TOKEN ,
1139: p_token1_value => SQLCODE ,
1140: p_token2 => G_SQLERRM_TOKEN ,

Line 1163: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1159: p_return_status OUT NOCOPY VARCHAR2
1160: ) is
1161: BEGIN
1162:
1163: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1164:
1165: IF (p_agreement_num is null) OR
1166: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1167:

Line 1166: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN

1162:
1163: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1164:
1165: IF (p_agreement_num is null) OR
1166: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1167:
1168: OKE_API.set_message(p_app_name => G_APP_NAME ,
1169: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1170: p_token1 => 'VALUE' ,

Line 1168: OKE_API.set_message(p_app_name => G_APP_NAME ,

1164:
1165: IF (p_agreement_num is null) OR
1166: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1167:
1168: OKE_API.set_message(p_app_name => G_APP_NAME ,
1169: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1170: p_token1 => 'VALUE' ,
1171: p_token1_value => 'agreement_number'
1172: );

Line 1169: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1165: IF (p_agreement_num is null) OR
1166: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1167:
1168: OKE_API.set_message(p_app_name => G_APP_NAME ,
1169: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1170: p_token1 => 'VALUE' ,
1171: p_token1_value => 'agreement_number'
1172: );
1173:

Line 1174: p_return_status := OKE_API.G_RET_STS_ERROR;

1170: p_token1 => 'VALUE' ,
1171: p_token1_value => 'agreement_number'
1172: );
1173:
1174: p_return_status := OKE_API.G_RET_STS_ERROR;
1175:
1176: END IF;
1177:
1178: END validate_agreement_number;

Line 1213: OKE_API.set_message(p_app_name => G_APP_NAME ,

1209: CLOSE c_exist;
1210:
1211: IF (l_dummy_value = '?') THEN
1212:
1213: OKE_API.set_message(p_app_name => G_APP_NAME ,
1214: p_msg_name => 'OKE_NO_FUND_LINES'
1215: );
1216:
1217: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1228: OKE_API.set_message(p_app_name => G_APP_NAME ,

1224: CLOSE c_project;
1225: --dbms_output.put_line('project null l_dummy_value ' || l_dummy_value);
1226: IF (l_dummy_value = 'x') THEN
1227:
1228: OKE_API.set_message(p_app_name => G_APP_NAME ,
1229: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1230: p_token1 => 'VALUE' ,
1231: p_token1_value => 'project_id'
1232: );

Line 1229: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1225: --dbms_output.put_line('project null l_dummy_value ' || l_dummy_value);
1226: IF (l_dummy_value = 'x') THEN
1227:
1228: OKE_API.set_message(p_app_name => G_APP_NAME ,
1229: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1230: p_token1 => 'VALUE' ,
1231: p_token1_value => 'project_id'
1232: );
1233:

Line 1245: OKE_API.set_message(p_app_name => G_APP_NAME ,

1241: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1242: raise G_EXCEPTION_HALT_VALIDATION;
1243:
1244: WHEN OTHERS THEN
1245: OKE_API.set_message(p_app_name => G_APP_NAME ,
1246: p_msg_name => G_UNEXPECTED_ERROR ,
1247: p_token1 => G_SQLCODE_TOKEN ,
1248: p_token1_value => SQLCODE ,
1249: p_token2 => G_SQLERRM_TOKEN ,

Line 1257: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1253: IF c_project%ISOPEN THEN
1254: CLOSE c_project;
1255: END IF;
1256:
1257: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1258:
1259: END check_project_null;
1260:
1261:

Line 1282: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

1278: --
1279: validate_agreement_type(p_agreement_type => p_agreement_type ,
1280: p_return_status => l_return_status );
1281:
1282: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
1283:
1284: RAISE G_EXCEPTION_HALT_VALIDATION;
1285:
1286: END IF;

Line 1295: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

1291:
1292: validate_agreement_number(p_agreement_num => p_funding_in_rec.agreement_number ,
1293: p_return_status => l_return_status );
1294:
1295: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
1296:
1297: RAISE G_EXCEPTION_HALT_VALIDATION;
1298:
1299: END IF;

Line 1310: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

1306: p_k_party_id => p_funding_in_rec.k_party_id ,
1307: p_return_status => l_return_status
1308: );
1309:
1310: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
1311:
1312: RAISE G_EXCEPTION_HALT_VALIDATION;
1313:
1314: END IF;

Line 1325: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

1321: p_customer_num => p_funding_in_rec.customer_number ,
1322: p_return_status => l_return_status
1323: );
1324:
1325: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
1326:
1327: RAISE G_EXCEPTION_HALT_VALIDATION;
1328:
1329: END IF;

Line 1365: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1361:
1362: IF (c_agreement%NOTFOUND) THEN
1363:
1364: CLOSE c_agreement;
1365: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1366:
1367: END IF;
1368:
1369: CLOSE c_agreement;

Line 1446: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1442: p_agreement_in_rec_new.template_flag := l_agreement_row.template_flag;
1443: END IF;
1444:
1445: EXCEPTION
1446: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1447: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448:
1449: WHEN OTHERS THEN
1450: OKE_API.set_message(p_app_name => G_APP_NAME ,

Line 1447: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1443: END IF;
1444:
1445: EXCEPTION
1446: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1447: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448:
1449: WHEN OTHERS THEN
1450: OKE_API.set_message(p_app_name => G_APP_NAME ,
1451: p_msg_name => G_UNEXPECTED_ERROR ,

Line 1450: OKE_API.set_message(p_app_name => G_APP_NAME ,

1446: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1447: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448:
1449: WHEN OTHERS THEN
1450: OKE_API.set_message(p_app_name => G_APP_NAME ,
1451: p_msg_name => G_UNEXPECTED_ERROR ,
1452: p_token1 => G_SQLCODE_TOKEN ,
1453: p_token1_value => SQLCODE ,
1454: p_token2 => G_SQLERRM_TOKEN ,

Line 1566: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1562:
1563: --oke_debug.debug('entering upd_insert_agreement');
1564: --dbms_output.put_line('entering upd_insert_agreement');
1565:
1566: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1567:
1568: l_length := LENGTH(p_funding_source_id);
1569:
1570: OPEN c_agreement_count(l_length + 1);

Line 1726: p_commit => OKE_API.G_FALSE ,

1722:
1723: END IF;
1724:
1725: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1726: p_commit => OKE_API.G_FALSE ,
1727: p_init_msg_list => OKE_API.G_FALSE ,
1728: p_msg_count => p_msg_count ,
1729: p_msg_data => p_msg_data ,
1730: p_return_status => p_return_status ,

Line 1727: p_init_msg_list => OKE_API.G_FALSE ,

1723: END IF;
1724:
1725: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1726: p_commit => OKE_API.G_FALSE ,
1727: p_init_msg_list => OKE_API.G_FALSE ,
1728: p_msg_count => p_msg_count ,
1729: p_msg_data => p_msg_data ,
1730: p_return_status => p_return_status ,
1731: p_pm_product_code => G_PRODUCT_CODE ,

Line 1738: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1734: p_funding_in_tbl => l_funding_in_tbl ,
1735: p_funding_out_tbl => l_funding_out_tbl
1736: );
1737:
1738: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1739:
1740: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741:
1742: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1740: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1736: );
1737:
1738: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1739:
1740: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741:
1742: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1743:
1744: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1742: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

1738: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1739:
1740: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741:
1742: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1743:
1744: RAISE OKE_API.G_EXCEPTION_ERROR;
1745:
1746: END IF;

Line 1744: RAISE OKE_API.G_EXCEPTION_ERROR;

1740: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1741:
1742: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1743:
1744: RAISE OKE_API.G_EXCEPTION_ERROR;
1745:
1746: END IF;
1747:
1748: END LOOP;

Line 1805: p_commit => OKE_API.G_FALSE ,

1801:
1802: l_agreement_in_rec.amount := 99999999999999999.99999;
1803:
1804: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
1805: p_commit => OKE_API.G_FALSE ,
1806: p_init_msg_list => OKE_API.G_FALSE ,
1807: p_msg_count => p_msg_count ,
1808: p_msg_data => p_msg_data ,
1809: p_return_status => p_return_status ,

Line 1806: p_init_msg_list => OKE_API.G_FALSE ,

1802: l_agreement_in_rec.amount := 99999999999999999.99999;
1803:
1804: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
1805: p_commit => OKE_API.G_FALSE ,
1806: p_init_msg_list => OKE_API.G_FALSE ,
1807: p_msg_count => p_msg_count ,
1808: p_msg_data => p_msg_data ,
1809: p_return_status => p_return_status ,
1810: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 1817: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1813: p_funding_in_tbl => l_funding_in_tbl ,
1814: p_funding_out_tbl => l_funding_out_tbl
1815: );
1816:
1817: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1818:
1819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1820:
1821: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1815: );
1816:
1817: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1818:
1819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1820:
1821: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1822:
1823: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1821: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

1817: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1818:
1819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1820:
1821: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1822:
1823: RAISE OKE_API.G_EXCEPTION_ERROR;
1824:
1825: END IF;

Line 1823: RAISE OKE_API.G_EXCEPTION_ERROR;

1819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1820:
1821: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1822:
1823: RAISE OKE_API.G_EXCEPTION_ERROR;
1824:
1825: END IF;
1826:
1827: l_agreement_in_rec_new := l_agreement_in_rec;

Line 1884: p_commit => OKE_API.G_FALSE ,

1880:
1881: END IF;
1882:
1883: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1884: p_commit => OKE_API.G_FALSE ,
1885: p_init_msg_list => OKE_API.G_FALSE ,
1886: p_msg_count => p_msg_count ,
1887: p_msg_data => p_msg_data ,
1888: p_return_status => p_return_status ,

Line 1885: p_init_msg_list => OKE_API.G_FALSE ,

1881: END IF;
1882:
1883: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1884: p_commit => OKE_API.G_FALSE ,
1885: p_init_msg_list => OKE_API.G_FALSE ,
1886: p_msg_count => p_msg_count ,
1887: p_msg_data => p_msg_data ,
1888: p_return_status => p_return_status ,
1889: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 1896: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1892: p_funding_in_tbl => l_funding_in_tbl ,
1893: p_funding_out_tbl => l_funding_out_tbl
1894: );
1895:
1896: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1897:
1898: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899:
1900: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1898: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1894: );
1895:
1896: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1897:
1898: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899:
1900: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1901:
1902: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1900: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

1896: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1897:
1898: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899:
1900: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1901:
1902: RAISE OKE_API.G_EXCEPTION_ERROR;
1903:
1904: END IF;

Line 1902: RAISE OKE_API.G_EXCEPTION_ERROR;

1898: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899:
1900: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1901:
1902: RAISE OKE_API.G_EXCEPTION_ERROR;
1903:
1904: END IF;
1905:
1906: IF (l_org_count = 1) THEN

Line 1968: p_commit => OKE_API.G_FALSE ,

1964:
1965: END IF;
1966:
1967: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1968: p_commit => OKE_API.G_FALSE ,
1969: p_init_msg_list => OKE_API.G_FALSE ,
1970: p_msg_count => p_msg_count ,
1971: p_msg_data => p_msg_data ,
1972: p_return_status => p_return_status ,

Line 1969: p_init_msg_list => OKE_API.G_FALSE ,

1965: END IF;
1966:
1967: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1968: p_commit => OKE_API.G_FALSE ,
1969: p_init_msg_list => OKE_API.G_FALSE ,
1970: p_msg_count => p_msg_count ,
1971: p_msg_data => p_msg_data ,
1972: p_return_status => p_return_status ,
1973: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 1980: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

1976: p_funding_in_tbl => l_funding_in_tbl ,
1977: p_funding_out_tbl => l_funding_out_tbl
1978: );
1979:
1980: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1981:
1982: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983:
1984: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1982: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1978: );
1979:
1980: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1981:
1982: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983:
1984: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1985:
1986: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 1984: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

1980: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1981:
1982: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983:
1984: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1985:
1986: RAISE OKE_API.G_EXCEPTION_ERROR;
1987:
1988: END IF;

Line 1986: RAISE OKE_API.G_EXCEPTION_ERROR;

1982: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1983:
1984: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1985:
1986: RAISE OKE_API.G_EXCEPTION_ERROR;
1987:
1988: END IF;
1989:
1990: IF (l_org_count = 1) THEN

Line 2045: p_commit => OKE_API.G_FALSE ,

2041:
2042: END IF;
2043:
2044: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2045: p_commit => OKE_API.G_FALSE ,
2046: p_init_msg_list => OKE_API.G_FALSE ,
2047: p_msg_count => p_msg_count ,
2048: p_msg_data => p_msg_data ,
2049: p_return_status => p_return_status ,

Line 2046: p_init_msg_list => OKE_API.G_FALSE ,

2042: END IF;
2043:
2044: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2045: p_commit => OKE_API.G_FALSE ,
2046: p_init_msg_list => OKE_API.G_FALSE ,
2047: p_msg_count => p_msg_count ,
2048: p_msg_data => p_msg_data ,
2049: p_return_status => p_return_status ,
2050: p_pm_product_code => G_PRODUCT_CODE ,

Line 2057: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

2053: p_funding_in_tbl => l_funding_in_tbl ,
2054: p_funding_out_tbl => l_funding_out_tbl
2055: );
2056:
2057: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2058:
2059: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060:
2061: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2059: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2055: );
2056:
2057: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2058:
2059: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060:
2061: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2062:
2063: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 2061: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

2057: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2058:
2059: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060:
2061: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2062:
2063: RAISE OKE_API.G_EXCEPTION_ERROR;
2064:
2065: END IF;

Line 2063: RAISE OKE_API.G_EXCEPTION_ERROR;

2059: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060:
2061: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2062:
2063: RAISE OKE_API.G_EXCEPTION_ERROR;
2064:
2065: END IF;
2066:
2067: END LOOP;

Line 2133: p_return_status := OKE_API.G_RET_STS_SUCCESS;

2129:
2130: --oke_debug.debug('entering upd_insert_agreement');
2131: --dbms_output.put_line('entering upd_insert_agreement');
2132:
2133: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2134:
2135: l_length := LENGTH(p_funding_source_id);
2136:
2137: OPEN c_agreement_count(l_length);

Line 2218: p_commit => OKE_API.G_FALSE ,

2214:
2215: END IF;
2216:
2217: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2218: p_commit => OKE_API.G_FALSE ,
2219: p_init_msg_list => OKE_API.G_FALSE ,
2220: p_msg_count => p_msg_count ,
2221: p_msg_data => p_msg_data ,
2222: p_return_status => p_return_status ,

Line 2219: p_init_msg_list => OKE_API.G_FALSE ,

2215: END IF;
2216:
2217: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2218: p_commit => OKE_API.G_FALSE ,
2219: p_init_msg_list => OKE_API.G_FALSE ,
2220: p_msg_count => p_msg_count ,
2221: p_msg_data => p_msg_data ,
2222: p_return_status => p_return_status ,
2223: p_pm_product_code => G_PRODUCT_CODE ,

Line 2230: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

2226: p_funding_in_tbl => l_funding_in_tbl ,
2227: p_funding_out_tbl => l_funding_out_tbl
2228: );
2229:
2230: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2231:
2232: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2233:
2234: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2232: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2228: );
2229:
2230: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2231:
2232: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2233:
2234: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2235:
2236: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 2234: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

2230: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2231:
2232: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2233:
2234: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2235:
2236: RAISE OKE_API.G_EXCEPTION_ERROR;
2237:
2238: END IF;

Line 2236: RAISE OKE_API.G_EXCEPTION_ERROR;

2232: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2233:
2234: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2235:
2236: RAISE OKE_API.G_EXCEPTION_ERROR;
2237:
2238: END IF;
2239:
2240: IF (p_agreement_tbl.COUNT > 0) THEN

Line 2339: OKE_API.set_message(p_app_name => G_APP_NAME ,

2335: END IF;
2336:
2337: EXCEPTION
2338: WHEN OTHERS THEN
2339: OKE_API.set_message(p_app_name => G_APP_NAME ,
2340: p_msg_name => G_UNEXPECTED_ERROR ,
2341: p_token1 => G_SQLCODE_TOKEN ,
2342: p_token1_value => SQLCODE ,
2343: p_token2 => G_SQLERRM_TOKEN ,

Line 2367: -- Calling subprograms: OKE_API.start_activity

2363: -- Procedure create_agreement
2364: --
2365: -- Description: This procedure is used to create pa agreement
2366: --
2367: -- Calling subprograms: OKE_API.start_activity
2368: -- OKE_API.end_activity
2369: -- OKE_FUNDING_UTIL_PKG.funding_mode
2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag

Line 2368: -- OKE_API.end_activity

2364: --
2365: -- Description: This procedure is used to create pa agreement
2366: --
2367: -- Calling subprograms: OKE_API.start_activity
2368: -- OKE_API.end_activity
2369: -- OKE_FUNDING_UTIL_PKG.funding_mode
2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2372: -- PA_AGREEMENT_PUB.create_agreement

Line 2381: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

2377: -- set_hard_limit
2378: --
2379:
2380: PROCEDURE create_agreement(p_api_version IN NUMBER ,
2381: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
2382: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
2383: p_msg_count OUT NOCOPY NUMBER ,
2384: p_msg_data OUT NOCOPY VARCHAR2 ,
2385: p_agreement_type IN VARCHAR2 ,

Line 2382: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

2378: --
2379:
2380: PROCEDURE create_agreement(p_api_version IN NUMBER ,
2381: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
2382: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
2383: p_msg_count OUT NOCOPY NUMBER ,
2384: p_msg_data OUT NOCOPY VARCHAR2 ,
2385: p_agreement_type IN VARCHAR2 ,
2386: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,

Line 2502: p_return_status := OKE_API.G_RET_STS_SUCCESS;

2498:
2499: --oke_debug.debug('entering oke_agreement_pvt.create_agreement');
2500: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');
2501:
2502: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2503:
2504: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
2505: p_pkg_name => G_PKG_NAME ,
2506: p_init_msg_list => p_init_msg_list ,

Line 2504: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

2500: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');
2501:
2502: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2503:
2504: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
2505: p_pkg_name => G_PKG_NAME ,
2506: p_init_msg_list => p_init_msg_list ,
2507: l_api_version => G_API_VERSION_NUMBER ,
2508: p_api_version => p_api_version ,

Line 2513: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

2509: p_api_type => '_PVT' ,
2510: x_return_status => p_return_status
2511: );
2512:
2513: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2514:
2515: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2516:
2517: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2515: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2511: );
2512:
2513: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2514:
2515: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2516:
2517: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
2518:
2519: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 2517: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

2513: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2514:
2515: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2516:
2517: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
2518:
2519: RAISE OKE_API.G_EXCEPTION_ERROR;
2520:
2521: END IF;

Line 2519: RAISE OKE_API.G_EXCEPTION_ERROR;

2515: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2516:
2517: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
2518:
2519: RAISE OKE_API.G_EXCEPTION_ERROR;
2520:
2521: END IF;
2522:
2523: --

Line 2583: RAISE OKE_API.G_EXCEPTION_ERROR;

2579: );
2580:
2581: IF (l_return_status = 'E') THEN
2582:
2583: RAISE OKE_API.G_EXCEPTION_ERROR;
2584:
2585: ELSIF (l_return_status = 'U') THEN
2586:
2587: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2587: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2583: RAISE OKE_API.G_EXCEPTION_ERROR;
2584:
2585: ELSIF (l_return_status = 'U') THEN
2586:
2587: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2588:
2589: END IF;
2590:
2591: ELSE

Line 2599: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN

2595: END IF;
2596:
2597: l_agreement_tbl(i).object_id := l_allocation.org_id;
2598: l_agreement_tbl(i).agreement_currency_code := l_allocation.projfunc_currency_code;
2599: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2600: l_agreement_tbl(i).total_amount := 0;
2601: END IF;
2602: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2603: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN

Line 2603: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN

2599: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2600: l_agreement_tbl(i).total_amount := 0;
2601: END IF;
2602: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2603: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN
2604: l_agreement_tbl(i).org_total_amount := 0;
2605: END IF;
2606: l_agreement_tbl(i).org_total_amount := l_agreement_tbl(i).org_total_amount + l_allocation.amount;
2607:

Line 2647: RAISE OKE_API.G_EXCEPTION_ERROR;

2643: );
2644:
2645: IF (l_return_status = 'E') THEN
2646:
2647: RAISE OKE_API.G_EXCEPTION_ERROR;
2648:
2649: ELSIF (l_return_status = 'U') THEN
2650:
2651: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2651: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2647: RAISE OKE_API.G_EXCEPTION_ERROR;
2648:
2649: ELSIF (l_return_status = 'U') THEN
2650:
2651: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2652:
2653: END IF;
2654:
2655: l_agreement_tbl(i).object_id := l_allocation.org_id;

Line 2657: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN

2653: END IF;
2654:
2655: l_agreement_tbl(i).object_id := l_allocation.org_id;
2656: l_agreement_tbl(i).agreement_currency_code := l_allocation.projfunc_currency_code;
2657: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2658: l_agreement_tbl(i).total_amount := 0;
2659: END IF;
2660: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2661: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN

Line 2661: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN

2657: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2658: l_agreement_tbl(i).total_amount := 0;
2659: END IF;
2660: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2661: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN
2662: l_agreement_tbl(i).org_total_amount := 0;
2663: END IF;
2664: l_agreement_tbl(i).org_total_amount := l_agreement_tbl(i).org_total_amount + l_allocation.amount;
2665:

Line 2687: IF (l_agreement_tbl(i + 1).total_amount = OKE_API.G_MISS_NUM) THEN

2683: ELSE
2684:
2685: l_agreement_tbl(i + 1).object_id := l_allocation.org_id;
2686: l_agreement_tbl(i + 1).agreement_currency_code := l_funding_in_rec.currency_code;
2687: IF (l_agreement_tbl(i + 1).total_amount = OKE_API.G_MISS_NUM) THEN
2688: l_agreement_tbl(i + 1).total_amount := 0;
2689: END IF;
2690: l_agreement_tbl(i + 1).total_amount := l_agreement_tbl(i + 1).total_amount + l_allocation.amount;
2691: IF (l_agreement_tbl(i + 1).org_total_amount = OKE_API.G_MISS_NUM) THEN

Line 2691: IF (l_agreement_tbl(i + 1).org_total_amount = OKE_API.G_MISS_NUM) THEN

2687: IF (l_agreement_tbl(i + 1).total_amount = OKE_API.G_MISS_NUM) THEN
2688: l_agreement_tbl(i + 1).total_amount := 0;
2689: END IF;
2690: l_agreement_tbl(i + 1).total_amount := l_agreement_tbl(i + 1).total_amount + l_allocation.amount;
2691: IF (l_agreement_tbl(i + 1).org_total_amount = OKE_API.G_MISS_NUM) THEN
2692: l_agreement_tbl(i + 1).org_total_amount := 0;
2693: END IF;
2694: l_agreement_tbl(i + 1).org_total_amount := l_agreement_tbl(i + 1).org_total_amount + l_allocation.amount;
2695:

Line 2725: OKE_API.set_message(

2721: --
2722: -- Check if valid allocations exist -- bug#4322146
2723: --
2724: IF l_agreement_tbl.COUNT = 0 THEN
2725: OKE_API.set_message(
2726: p_app_name => G_APP_NAME, p_msg_name => 'OKE_FUND_NO_VALID_ALLOCATIONS'
2727: );
2728: RAISE OKE_API.G_EXCEPTION_ERROR;
2729: END IF;

Line 2728: RAISE OKE_API.G_EXCEPTION_ERROR;

2724: IF l_agreement_tbl.COUNT = 0 THEN
2725: OKE_API.set_message(
2726: p_app_name => G_APP_NAME, p_msg_name => 'OKE_FUND_NO_VALID_ALLOCATIONS'
2727: );
2728: RAISE OKE_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:
2731: --
2732: -- Check if mixed mode exists

Line 2747: OKE_API.set_message(p_app_name => G_APP_NAME ,

2743: );
2744:
2745: IF (l_return_status = 'E') THEN
2746:
2747: OKE_API.set_message(p_app_name => G_APP_NAME ,
2748: p_msg_name => 'OKE_FUNDING_LEVEL' ,
2749: p_token1 => 'PROJECT' ,
2750: p_token1_value => l_err_project_number
2751: );

Line 2753: RAISE OKE_API.G_EXCEPTION_ERROR;

2749: p_token1 => 'PROJECT' ,
2750: p_token1_value => l_err_project_number
2751: );
2752:
2753: RAISE OKE_API.G_EXCEPTION_ERROR;
2754:
2755: END IF;
2756:
2757: --

Line 2826: p_commit => OKE_API.G_FALSE ,

2822:
2823: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2824:
2825: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
2826: p_commit => OKE_API.G_FALSE ,
2827: p_init_msg_list => OKE_API.G_FALSE ,
2828: p_msg_count => p_msg_count ,
2829: p_msg_data => p_msg_data ,
2830: p_return_status => p_return_status ,

Line 2827: p_init_msg_list => OKE_API.G_FALSE ,

2823: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2824:
2825: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
2826: p_commit => OKE_API.G_FALSE ,
2827: p_init_msg_list => OKE_API.G_FALSE ,
2828: p_msg_count => p_msg_count ,
2829: p_msg_data => p_msg_data ,
2830: p_return_status => p_return_status ,
2831: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 2838: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

2834: p_funding_in_tbl => l_funding_in_tbl ,
2835: p_funding_out_tbl => l_funding_out_tbl
2836: );
2837:
2838: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2839:
2840: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2841:
2842: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2840: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2836: );
2837:
2838: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2839:
2840: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2841:
2842: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2843:
2844: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 2842: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

2838: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2839:
2840: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2841:
2842: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2843:
2844: RAISE OKE_API.G_EXCEPTION_ERROR;
2845:
2846: END IF;

Line 2844: RAISE OKE_API.G_EXCEPTION_ERROR;

2840: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2841:
2842: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2843:
2844: RAISE OKE_API.G_EXCEPTION_ERROR;
2845:
2846: END IF;
2847:
2848: EXIT WHEN (i = l_agreement_tbl.LAST);

Line 2884: p_init_msg_list => OKE_API.G_FALSE ,

2880: --oke_debug.debug('calling add_pa_funding - project_level');
2881: --dbms_output.put_line('calling add_pa_funding - project level');
2882:
2883: add_pa_funding(p_api_version => p_api_version ,
2884: p_init_msg_list => OKE_API.G_FALSE ,
2885: p_commit => OKE_API.G_FALSE ,
2886: p_msg_count => p_msg_count ,
2887: p_msg_data => p_msg_data ,
2888: p_allocation_in_rec => l_allocation_in_rec ,

Line 2885: p_commit => OKE_API.G_FALSE ,

2881: --dbms_output.put_line('calling add_pa_funding - project level');
2882:
2883: add_pa_funding(p_api_version => p_api_version ,
2884: p_init_msg_list => OKE_API.G_FALSE ,
2885: p_commit => OKE_API.G_FALSE ,
2886: p_msg_count => p_msg_count ,
2887: p_msg_data => p_msg_data ,
2888: p_allocation_in_rec => l_allocation_in_rec ,
2889: p_return_status => p_return_status

Line 2892: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

2888: p_allocation_in_rec => l_allocation_in_rec ,
2889: p_return_status => p_return_status
2890: );
2891:
2892: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2893:
2894: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2895:
2896: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2894: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2890: );
2891:
2892: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2893:
2894: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2895:
2896: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2897:
2898: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 2896: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

2892: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2893:
2894: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2895:
2896: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2897:
2898: RAISE OKE_API.G_EXCEPTION_ERROR;
2899:
2900: END IF;

Line 2898: RAISE OKE_API.G_EXCEPTION_ERROR;

2894: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2895:
2896: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2897:
2898: RAISE OKE_API.G_EXCEPTION_ERROR;
2899:
2900: END IF;
2901:
2902: END LOOP;

Line 2921: p_init_msg_list => OKE_API.G_FALSE ,

2917: --oke_debug.debug('calling add_pa_funding - task level');
2918: --dbms_output.put_line('calling add_pa_funding - task level');
2919:
2920: add_pa_funding(p_api_version => p_api_version ,
2921: p_init_msg_list => OKE_API.G_FALSE ,
2922: p_commit => OKE_API.G_FALSE ,
2923: p_msg_count => p_msg_count ,
2924: p_msg_data => p_msg_data ,
2925: p_allocation_in_rec => l_allocation_in_rec ,

Line 2922: p_commit => OKE_API.G_FALSE ,

2918: --dbms_output.put_line('calling add_pa_funding - task level');
2919:
2920: add_pa_funding(p_api_version => p_api_version ,
2921: p_init_msg_list => OKE_API.G_FALSE ,
2922: p_commit => OKE_API.G_FALSE ,
2923: p_msg_count => p_msg_count ,
2924: p_msg_data => p_msg_data ,
2925: p_allocation_in_rec => l_allocation_in_rec ,
2926: p_return_status => p_return_status

Line 2929: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

2925: p_allocation_in_rec => l_allocation_in_rec ,
2926: p_return_status => p_return_status
2927: );
2928:
2929: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2930:
2931: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2932:
2933: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2931: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2927: );
2928:
2929: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2930:
2931: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2932:
2933: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2934:
2935: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 2933: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

2929: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2930:
2931: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2932:
2933: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2934:
2935: RAISE OKE_API.G_EXCEPTION_ERROR;
2936:
2937: END IF;

Line 2935: RAISE OKE_API.G_EXCEPTION_ERROR;

2931: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2932:
2933: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2934:
2935: RAISE OKE_API.G_EXCEPTION_ERROR;
2936:
2937: END IF;
2938:
2939: END LOOP;

Line 3002: p_commit => OKE_API.G_FALSE ,

2998:
2999: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
3000:
3001: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3002: p_commit => OKE_API.G_FALSE ,
3003: p_init_msg_list => OKE_API.G_FALSE ,
3004: p_msg_count => p_msg_count ,
3005: p_msg_data => p_msg_data ,
3006: p_return_status => p_return_status ,

Line 3003: p_init_msg_list => OKE_API.G_FALSE ,

2999: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
3000:
3001: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3002: p_commit => OKE_API.G_FALSE ,
3003: p_init_msg_list => OKE_API.G_FALSE ,
3004: p_msg_count => p_msg_count ,
3005: p_msg_data => p_msg_data ,
3006: p_return_status => p_return_status ,
3007: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 3014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3010: p_funding_in_tbl => l_funding_in_tbl ,
3011: p_funding_out_tbl => l_funding_out_tbl
3012: );
3013:
3014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3015:
3016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3017:
3018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3012: );
3013:
3014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3015:
3016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3017:
3018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3019:
3020: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3015:
3016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3017:
3018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3019:
3020: RAISE OKE_API.G_EXCEPTION_ERROR;
3021:
3022: END IF;

Line 3020: RAISE OKE_API.G_EXCEPTION_ERROR;

3016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3017:
3018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3019:
3020: RAISE OKE_API.G_EXCEPTION_ERROR;
3021:
3022: END IF;
3023:
3024: EXIT WHEN (i = l_agreement_tbl.LAST);

Line 3042: x_commit => OKE_API.G_FALSE

3038: --dbms_output.put_line('calling oke_funding_util.update_source_flag');
3039: --oke_debug.debug('calling oke_funding_util.update_source_flag');
3040:
3041: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => p_funding_in_rec.funding_source_id ,
3042: x_commit => OKE_API.G_FALSE
3043: );
3044:
3045: IF FND_API.to_boolean(p_commit) THEN
3046:

Line 3054: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,

3050:
3051: --dbms_output.put_line('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3052: --oke_debug.debug('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3053:
3054: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
3055: x_msg_data => p_msg_data
3056: );
3057:
3058: EXCEPTION

Line 3059: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

3055: x_msg_data => p_msg_data
3056: );
3057:
3058: EXCEPTION
3059: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
3060: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3061: p_pkg_name => G_PKG_NAME ,
3062: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
3063: x_msg_count => p_msg_count ,

Line 3060: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

3056: );
3057:
3058: EXCEPTION
3059: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
3060: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3061: p_pkg_name => G_PKG_NAME ,
3062: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
3063: x_msg_count => p_msg_count ,
3064: x_msg_data => p_msg_data ,

Line 3062: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

3058: EXCEPTION
3059: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
3060: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3061: p_pkg_name => G_PKG_NAME ,
3062: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
3063: x_msg_count => p_msg_count ,
3064: x_msg_data => p_msg_data ,
3065: p_api_type => '_PVT'
3066: );

Line 3068: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3064: x_msg_data => p_msg_data ,
3065: p_api_type => '_PVT'
3066: );
3067:
3068: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3069: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3070: p_pkg_name => G_PKG_NAME ,
3071: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
3072: x_msg_count => p_msg_count ,

Line 3069: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

3065: p_api_type => '_PVT'
3066: );
3067:
3068: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3069: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3070: p_pkg_name => G_PKG_NAME ,
3071: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
3072: x_msg_count => p_msg_count ,
3073: x_msg_data => p_msg_data ,

Line 3071: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

3067:
3068: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3069: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3070: p_pkg_name => G_PKG_NAME ,
3071: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
3072: x_msg_count => p_msg_count ,
3073: x_msg_data => p_msg_data ,
3074: p_api_type => '_PVT'
3075: );

Line 3078: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

3074: p_api_type => '_PVT'
3075: );
3076:
3077: WHEN OTHERS THEN
3078: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3079: p_pkg_name => G_PKG_NAME ,
3080: p_exc_name => 'OTHERS' ,
3081: x_msg_count => p_msg_count ,
3082: x_msg_data => p_msg_data ,

Line 3094: -- Calling subprograms: OKE_API.start_activity

3090: -- Procedure update_agreement
3091: --
3092: -- Description: This procedure is used to update pa agreement
3093: --
3094: -- Calling subprograms: OKE_API.start_activity
3095: -- OKE_API.end_activity
3096: -- validate_agreement_attributes
3097: -- check_project_null
3098: -- prepare_upd_funding

Line 3095: -- OKE_API.end_activity

3091: --
3092: -- Description: This procedure is used to update pa agreement
3093: --
3094: -- Calling subprograms: OKE_API.start_activity
3095: -- OKE_API.end_activity
3096: -- validate_agreement_attributes
3097: -- check_project_null
3098: -- prepare_upd_funding
3099: --

Line 3102: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

3098: -- prepare_upd_funding
3099: --
3100:
3101: PROCEDURE update_agreement(p_api_version IN NUMBER ,
3102: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
3103: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
3104: p_msg_count OUT NOCOPY NUMBER ,
3105: p_msg_data OUT NOCOPY VARCHAR2 ,
3106: p_agreement_type IN VARCHAR2 ,

Line 3103: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

3099: --
3100:
3101: PROCEDURE update_agreement(p_api_version IN NUMBER ,
3102: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
3103: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
3104: p_msg_count OUT NOCOPY NUMBER ,
3105: p_msg_data OUT NOCOPY VARCHAR2 ,
3106: p_agreement_type IN VARCHAR2 ,
3107: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,

Line 3348: p_return_status := OKE_API.G_RET_STS_SUCCESS;

3344:
3345: --dbms_output.put_line('entering oke_agreement_pvt.update_agreement');
3346: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');
3347:
3348: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3349:
3350: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
3351: p_pkg_name => G_PKG_NAME ,
3352: p_init_msg_list => p_init_msg_list ,

Line 3350: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

3346: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');
3347:
3348: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3349:
3350: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
3351: p_pkg_name => G_PKG_NAME ,
3352: p_init_msg_list => p_init_msg_list ,
3353: l_api_version => G_API_VERSION_NUMBER ,
3354: p_api_version => p_api_version ,

Line 3359: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3355: p_api_type => '_PVT' ,
3356: x_return_status => p_return_status
3357: );
3358:
3359: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3360:
3361: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3362:
3363: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3361: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3357: );
3358:
3359: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3360:
3361: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3362:
3363: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3364:
3365: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3363: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

3359: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3360:
3361: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3362:
3363: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3364:
3365: RAISE OKE_API.G_EXCEPTION_ERROR;
3366:
3367: END IF;

Line 3365: RAISE OKE_API.G_EXCEPTION_ERROR;

3361: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3362:
3363: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3364:
3365: RAISE OKE_API.G_EXCEPTION_ERROR;
3366:
3367: END IF;
3368:
3369: --

Line 3435: OKE_API.set_message(p_app_name => G_APP_NAME ,

3431: );
3432:
3433: IF (l_return_status = 'E') THEN
3434:
3435: OKE_API.set_message(p_app_name => G_APP_NAME ,
3436: p_msg_name => 'OKE_FUNDING_LEVEL' ,
3437: p_token1 => 'PROJECT' ,
3438: p_token1_value => l_err_project_number
3439: );

Line 3441: RAISE OKE_API.G_EXCEPTION_ERROR;

3437: p_token1 => 'PROJECT' ,
3438: p_token1_value => l_err_project_number
3439: );
3440:
3441: RAISE OKE_API.G_EXCEPTION_ERROR;
3442:
3443: END IF;
3444:
3445: --

Line 3469: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

3465: --
3466: FOR l_agreement in c_agreement LOOP
3467:
3468: IF (nvl(l_org_id_vc, -99) <> nvl(l_agreement.org_id, -99)) OR
3469: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3470: l_agreement_in_rec.owning_organization_id := null;
3471: ELSE
3472: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3473: END IF;

Line 3488: p_commit => OKE_API.G_FALSE ,

3484:
3485: END IF;
3486:
3487: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3488: p_commit => OKE_API.G_FALSE ,
3489: p_init_msg_list => OKE_API.G_FALSE ,
3490: p_msg_count => p_msg_count ,
3491: p_msg_data => p_msg_data ,
3492: p_return_status => p_return_status ,

Line 3489: p_init_msg_list => OKE_API.G_FALSE ,

3485: END IF;
3486:
3487: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3488: p_commit => OKE_API.G_FALSE ,
3489: p_init_msg_list => OKE_API.G_FALSE ,
3490: p_msg_count => p_msg_count ,
3491: p_msg_data => p_msg_data ,
3492: p_return_status => p_return_status ,
3493: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 3500: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3496: p_funding_in_tbl => l_funding_in_tbl ,
3497: p_funding_out_tbl => l_funding_out_tbl
3498: );
3499:
3500: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3501:
3502: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3503:
3504: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3502: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3498: );
3499:
3500: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3501:
3502: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3503:
3504: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3505:
3506: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3504: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3500: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3501:
3502: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3503:
3504: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3505:
3506: RAISE OKE_API.G_EXCEPTION_ERROR;
3507:
3508: END IF;

Line 3506: RAISE OKE_API.G_EXCEPTION_ERROR;

3502: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3503:
3504: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3505:
3506: RAISE OKE_API.G_EXCEPTION_ERROR;
3507:
3508: END IF;
3509:
3510: END LOOP;

Line 3529: OKE_API.set_message(p_app_name => G_APP_NAME ,

3525: IF c_non_mcb%NOTFOUND THEN
3526: null;
3527: ELSE
3528:
3529: OKE_API.set_message(p_app_name => G_APP_NAME ,
3530: p_msg_name => 'OKE_NONMCB_PROJECT' ,
3531: p_token1 => 'PROJECT' ,
3532: p_token1_value => l_project_number
3533: );

Line 3535: RAISE OKE_API.G_EXCEPTION_ERROR;

3531: p_token1 => 'PROJECT' ,
3532: p_token1_value => l_project_number
3533: );
3534:
3535: RAISE OKE_API.G_EXCEPTION_ERROR;
3536:
3537: END IF;
3538: CLOSE c_non_mcb;
3539:

Line 3569: p_init_msg_list => OKE_API.G_FALSE ,

3565:
3566: IF (l_allocation.agreement_id <> -99) THEN
3567:
3568: update_pa_funding(p_api_version => p_api_version ,
3569: p_init_msg_list => OKE_API.G_FALSE ,
3570: p_commit => OKE_API.G_FALSE ,
3571: p_msg_count => p_msg_count ,
3572: p_msg_data => p_msg_data ,
3573: p_allocation_in_rec => l_allocation_in_rec ,

Line 3570: p_commit => OKE_API.G_FALSE ,

3566: IF (l_allocation.agreement_id <> -99) THEN
3567:
3568: update_pa_funding(p_api_version => p_api_version ,
3569: p_init_msg_list => OKE_API.G_FALSE ,
3570: p_commit => OKE_API.G_FALSE ,
3571: p_msg_count => p_msg_count ,
3572: p_msg_data => p_msg_data ,
3573: p_allocation_in_rec => l_allocation_in_rec ,
3574: p_return_status => p_return_status

Line 3586: p_init_msg_list => OKE_API.G_FALSE ,

3582:
3583: l_allocation_in_rec.agreement_id := l_agreement_id;
3584:
3585: add_pa_funding(p_api_version => p_api_version ,
3586: p_init_msg_list => OKE_API.G_FALSE ,
3587: p_commit => OKE_API.G_FALSE ,
3588: p_msg_count => p_msg_count ,
3589: p_msg_data => p_msg_data ,
3590: p_allocation_in_rec => l_allocation_in_rec ,

Line 3587: p_commit => OKE_API.G_FALSE ,

3583: l_allocation_in_rec.agreement_id := l_agreement_id;
3584:
3585: add_pa_funding(p_api_version => p_api_version ,
3586: p_init_msg_list => OKE_API.G_FALSE ,
3587: p_commit => OKE_API.G_FALSE ,
3588: p_msg_count => p_msg_count ,
3589: p_msg_data => p_msg_data ,
3590: p_allocation_in_rec => l_allocation_in_rec ,
3591: p_return_status => p_return_status

Line 3594: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3590: p_allocation_in_rec => l_allocation_in_rec ,
3591: p_return_status => p_return_status
3592: );
3593:
3594: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3595:
3596: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3597:
3598: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3596: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3592: );
3593:
3594: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3595:
3596: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3597:
3598: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3599:
3600: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3598: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3594: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3595:
3596: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3597:
3598: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3599:
3600: RAISE OKE_API.G_EXCEPTION_ERROR;
3601:
3602: END IF;

Line 3600: RAISE OKE_API.G_EXCEPTION_ERROR;

3596: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3597:
3598: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3599:
3600: RAISE OKE_API.G_EXCEPTION_ERROR;
3601:
3602: END IF;
3603:
3604: ELSIF (nvl(l_allocation.multi_currency_billing_flag, 'N') = 'Y') THEN

Line 3624: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

3620:
3621: l_agreement_in_rec.amount := 99999999999999999.99999;
3622:
3623: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3624: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3625: l_agreement_in_rec.owning_organization_id := null;
3626: ELSE
3627: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3628: END IF;

Line 3652: p_commit => OKE_API.G_FALSE ,

3648:
3649: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3650:
3651: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3652: p_commit => OKE_API.G_FALSE ,
3653: p_init_msg_list => OKE_API.G_FALSE ,
3654: p_msg_count => p_msg_count ,
3655: p_msg_data => p_msg_data ,
3656: p_return_status => p_return_status ,

Line 3653: p_init_msg_list => OKE_API.G_FALSE ,

3649: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3650:
3651: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3652: p_commit => OKE_API.G_FALSE ,
3653: p_init_msg_list => OKE_API.G_FALSE ,
3654: p_msg_count => p_msg_count ,
3655: p_msg_data => p_msg_data ,
3656: p_return_status => p_return_status ,
3657: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 3664: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3660: p_funding_in_tbl => l_funding_in_tbl ,
3661: p_funding_out_tbl => l_funding_out_tbl
3662: );
3663:
3664: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3665:
3666: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667:
3668: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3666: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3662: );
3663:
3664: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3665:
3666: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667:
3668: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3669:
3670: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3668: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3664: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3665:
3666: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667:
3668: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3669:
3670: RAISE OKE_API.G_EXCEPTION_ERROR;
3671:
3672: END IF;

Line 3670: RAISE OKE_API.G_EXCEPTION_ERROR;

3666: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667:
3668: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3669:
3670: RAISE OKE_API.G_EXCEPTION_ERROR;
3671:
3672: END IF;
3673:
3674: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 3687: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

3683:
3684: l_agreement_in_rec.amount := 99999999999999999.99999;
3685:
3686: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3687: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3688: l_agreement_in_rec.owning_organization_id := null;
3689: ELSE
3690: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3691: END IF;

Line 3715: p_commit => OKE_API.G_FALSE ,

3711:
3712: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3713:
3714: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3715: p_commit => OKE_API.G_FALSE ,
3716: p_init_msg_list => OKE_API.G_FALSE ,
3717: p_msg_count => p_msg_count ,
3718: p_msg_data => p_msg_data ,
3719: p_return_status => p_return_status ,

Line 3716: p_init_msg_list => OKE_API.G_FALSE ,

3712: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3713:
3714: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3715: p_commit => OKE_API.G_FALSE ,
3716: p_init_msg_list => OKE_API.G_FALSE ,
3717: p_msg_count => p_msg_count ,
3718: p_msg_data => p_msg_data ,
3719: p_return_status => p_return_status ,
3720: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 3727: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3723: p_funding_in_tbl => l_funding_in_tbl ,
3724: p_funding_out_tbl => l_funding_out_tbl
3725: );
3726:
3727: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3728:
3729: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3730:
3731: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3729: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3725: );
3726:
3727: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3728:
3729: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3730:
3731: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3732:
3733: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3731: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3727: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3728:
3729: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3730:
3731: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3732:
3733: RAISE OKE_API.G_EXCEPTION_ERROR;
3734:
3735: END IF;

Line 3733: RAISE OKE_API.G_EXCEPTION_ERROR;

3729: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3730:
3731: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3732:
3733: RAISE OKE_API.G_EXCEPTION_ERROR;
3734:
3735: END IF;
3736:
3737: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 3748: p_init_msg_list => OKE_API.G_FALSE ,

3744:
3745: l_allocation_in_rec.agreement_id := l_agreement_id;
3746:
3747: add_pa_funding(p_api_version => p_api_version ,
3748: p_init_msg_list => OKE_API.G_FALSE ,
3749: p_commit => OKE_API.G_FALSE ,
3750: p_msg_count => p_msg_count ,
3751: p_msg_data => p_msg_data ,
3752: p_allocation_in_rec => l_allocation_in_rec ,

Line 3749: p_commit => OKE_API.G_FALSE ,

3745: l_allocation_in_rec.agreement_id := l_agreement_id;
3746:
3747: add_pa_funding(p_api_version => p_api_version ,
3748: p_init_msg_list => OKE_API.G_FALSE ,
3749: p_commit => OKE_API.G_FALSE ,
3750: p_msg_count => p_msg_count ,
3751: p_msg_data => p_msg_data ,
3752: p_allocation_in_rec => l_allocation_in_rec ,
3753: p_return_status => p_return_status

Line 3756: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3752: p_allocation_in_rec => l_allocation_in_rec ,
3753: p_return_status => p_return_status
3754: );
3755:
3756: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3757:
3758: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759:
3760: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3758: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3754: );
3755:
3756: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3757:
3758: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759:
3760: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3761:
3762: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3760: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3756: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3757:
3758: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759:
3760: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3761:
3762: RAISE OKE_API.G_EXCEPTION_ERROR;
3763:
3764: END IF;

Line 3762: RAISE OKE_API.G_EXCEPTION_ERROR;

3758: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3759:
3760: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3761:
3762: RAISE OKE_API.G_EXCEPTION_ERROR;
3763:
3764: END IF;
3765:
3766: ELSE

Line 3776: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

3772:
3773: l_agreement_in_rec.amount := 99999999999999999.99999;
3774:
3775: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3776: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3777: l_agreement_in_rec.owning_organization_id := null;
3778: ELSE
3779: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3780: END IF;

Line 3804: p_commit => OKE_API.G_FALSE ,

3800:
3801: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3802:
3803: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3804: p_commit => OKE_API.G_FALSE ,
3805: p_init_msg_list => OKE_API.G_FALSE ,
3806: p_msg_count => p_msg_count ,
3807: p_msg_data => p_msg_data ,
3808: p_return_status => p_return_status ,

Line 3805: p_init_msg_list => OKE_API.G_FALSE ,

3801: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3802:
3803: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3804: p_commit => OKE_API.G_FALSE ,
3805: p_init_msg_list => OKE_API.G_FALSE ,
3806: p_msg_count => p_msg_count ,
3807: p_msg_data => p_msg_data ,
3808: p_return_status => p_return_status ,
3809: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 3816: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3812: p_funding_in_tbl => l_funding_in_tbl ,
3813: p_funding_out_tbl => l_funding_out_tbl
3814: );
3815:
3816: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3817:
3818: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819:
3820: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3818: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3814: );
3815:
3816: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3817:
3818: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819:
3820: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3821:
3822: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3820: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3816: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3817:
3818: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819:
3820: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3821:
3822: RAISE OKE_API.G_EXCEPTION_ERROR;
3823:
3824: END IF;

Line 3822: RAISE OKE_API.G_EXCEPTION_ERROR;

3818: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3819:
3820: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3821:
3822: RAISE OKE_API.G_EXCEPTION_ERROR;
3823:
3824: END IF;
3825:
3826: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 3834: p_init_msg_list => OKE_API.G_FALSE ,

3830:
3831: l_allocation_in_rec.agreement_id := l_agreement_id;
3832:
3833: add_pa_funding(p_api_version => p_api_version ,
3834: p_init_msg_list => OKE_API.G_FALSE ,
3835: p_commit => OKE_API.G_FALSE ,
3836: p_msg_count => p_msg_count ,
3837: p_msg_data => p_msg_data ,
3838: p_allocation_in_rec => l_allocation_in_rec ,

Line 3835: p_commit => OKE_API.G_FALSE ,

3831: l_allocation_in_rec.agreement_id := l_agreement_id;
3832:
3833: add_pa_funding(p_api_version => p_api_version ,
3834: p_init_msg_list => OKE_API.G_FALSE ,
3835: p_commit => OKE_API.G_FALSE ,
3836: p_msg_count => p_msg_count ,
3837: p_msg_data => p_msg_data ,
3838: p_allocation_in_rec => l_allocation_in_rec ,
3839: p_return_status => p_return_status

Line 3842: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3838: p_allocation_in_rec => l_allocation_in_rec ,
3839: p_return_status => p_return_status
3840: );
3841:
3842: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3843:
3844: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3845:
3846: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3844: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3840: );
3841:
3842: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3843:
3844: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3845:
3846: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3847:
3848: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3846: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3842: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3843:
3844: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3845:
3846: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3847:
3848: RAISE OKE_API.G_EXCEPTION_ERROR;
3849:
3850: END IF;

Line 3848: RAISE OKE_API.G_EXCEPTION_ERROR;

3844: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3845:
3846: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3847:
3848: RAISE OKE_API.G_EXCEPTION_ERROR;
3849:
3850: END IF;
3851:
3852: END IF;

Line 3872: p_init_msg_list => OKE_API.G_FALSE ,

3868:
3869: IF (l_allocation.agreement_id <> -99) THEN
3870:
3871: update_pa_funding(p_api_version => p_api_version ,
3872: p_init_msg_list => OKE_API.G_FALSE ,
3873: p_commit => OKE_API.G_FALSE ,
3874: p_msg_count => p_msg_count ,
3875: p_msg_data => p_msg_data ,
3876: p_allocation_in_rec => l_allocation_in_rec ,

Line 3873: p_commit => OKE_API.G_FALSE ,

3869: IF (l_allocation.agreement_id <> -99) THEN
3870:
3871: update_pa_funding(p_api_version => p_api_version ,
3872: p_init_msg_list => OKE_API.G_FALSE ,
3873: p_commit => OKE_API.G_FALSE ,
3874: p_msg_count => p_msg_count ,
3875: p_msg_data => p_msg_data ,
3876: p_allocation_in_rec => l_allocation_in_rec ,
3877: p_return_status => p_return_status

Line 3880: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3876: p_allocation_in_rec => l_allocation_in_rec ,
3877: p_return_status => p_return_status
3878: );
3879:
3880: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3881:
3882: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3883:
3884: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3882: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3878: );
3879:
3880: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3881:
3882: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3883:
3884: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3885:
3886: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3884: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3880: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3881:
3882: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3883:
3884: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3885:
3886: RAISE OKE_API.G_EXCEPTION_ERROR;
3887:
3888: END IF;

Line 3886: RAISE OKE_API.G_EXCEPTION_ERROR;

3882: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3883:
3884: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3885:
3886: RAISE OKE_API.G_EXCEPTION_ERROR;
3887:
3888: END IF;
3889:
3890: ELSIF (l_across_flag = 'Y') THEN

Line 3899: p_init_msg_list => OKE_API.G_FALSE ,

3895:
3896: l_allocation_in_rec.agreement_id := l_agreement_id;
3897:
3898: add_pa_funding(p_api_version => p_api_version ,
3899: p_init_msg_list => OKE_API.G_FALSE ,
3900: p_commit => OKE_API.G_FALSE ,
3901: p_msg_count => p_msg_count ,
3902: p_msg_data => p_msg_data ,
3903: p_allocation_in_rec => l_allocation_in_rec ,

Line 3900: p_commit => OKE_API.G_FALSE ,

3896: l_allocation_in_rec.agreement_id := l_agreement_id;
3897:
3898: add_pa_funding(p_api_version => p_api_version ,
3899: p_init_msg_list => OKE_API.G_FALSE ,
3900: p_commit => OKE_API.G_FALSE ,
3901: p_msg_count => p_msg_count ,
3902: p_msg_data => p_msg_data ,
3903: p_allocation_in_rec => l_allocation_in_rec ,
3904: p_return_status => p_return_status

Line 3907: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3903: p_allocation_in_rec => l_allocation_in_rec ,
3904: p_return_status => p_return_status
3905: );
3906:
3907: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3908:
3909: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3910:
3911: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3909: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3905: );
3906:
3907: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3908:
3909: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3910:
3911: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3912:
3913: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3911: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3907: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3908:
3909: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3910:
3911: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3912:
3913: RAISE OKE_API.G_EXCEPTION_ERROR;
3914:
3915: END IF;

Line 3913: RAISE OKE_API.G_EXCEPTION_ERROR;

3909: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3910:
3911: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3912:
3913: RAISE OKE_API.G_EXCEPTION_ERROR;
3914:
3915: END IF;
3916:
3917: ELSIF (nvl(l_allocation.multi_currency_billing_flag, 'N') = 'Y') THEN

Line 3936: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

3932:
3933: l_agreement_in_rec.amount := 99999999999999999.99999;
3934:
3935: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3936: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3937: l_agreement_in_rec.owning_organization_id := null;
3938: ELSE
3939: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3940: END IF;

Line 3964: p_commit => OKE_API.G_FALSE ,

3960:
3961: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3962:
3963: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3964: p_commit => OKE_API.G_FALSE ,
3965: p_init_msg_list => OKE_API.G_FALSE ,
3966: p_msg_count => p_msg_count ,
3967: p_msg_data => p_msg_data ,
3968: p_return_status => p_return_status ,

Line 3965: p_init_msg_list => OKE_API.G_FALSE ,

3961: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3962:
3963: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3964: p_commit => OKE_API.G_FALSE ,
3965: p_init_msg_list => OKE_API.G_FALSE ,
3966: p_msg_count => p_msg_count ,
3967: p_msg_data => p_msg_data ,
3968: p_return_status => p_return_status ,
3969: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 3976: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

3972: p_funding_in_tbl => l_funding_in_tbl ,
3973: p_funding_out_tbl => l_funding_out_tbl
3974: );
3975:
3976: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3977:
3978: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3979:
3980: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3978: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3974: );
3975:
3976: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3977:
3978: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3979:
3980: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3981:
3982: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 3980: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

3976: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3977:
3978: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3979:
3980: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3981:
3982: RAISE OKE_API.G_EXCEPTION_ERROR;
3983:
3984: END IF;

Line 3982: RAISE OKE_API.G_EXCEPTION_ERROR;

3978: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3979:
3980: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3981:
3982: RAISE OKE_API.G_EXCEPTION_ERROR;
3983:
3984: END IF;
3985:
3986: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 3999: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

3995:
3996: l_agreement_in_rec.amount := 99999999999999999.99999;
3997:
3998: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3999: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
4000: l_agreement_in_rec.owning_organization_id := null;
4001: ELSE
4002: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
4003: END IF;

Line 4027: p_commit => OKE_API.G_FALSE ,

4023:
4024: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4025:
4026: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4027: p_commit => OKE_API.G_FALSE ,
4028: p_init_msg_list => OKE_API.G_FALSE ,
4029: p_msg_count => p_msg_count ,
4030: p_msg_data => p_msg_data ,
4031: p_return_status => p_return_status ,

Line 4028: p_init_msg_list => OKE_API.G_FALSE ,

4024: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4025:
4026: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4027: p_commit => OKE_API.G_FALSE ,
4028: p_init_msg_list => OKE_API.G_FALSE ,
4029: p_msg_count => p_msg_count ,
4030: p_msg_data => p_msg_data ,
4031: p_return_status => p_return_status ,
4032: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 4039: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4035: p_funding_in_tbl => l_funding_in_tbl ,
4036: p_funding_out_tbl => l_funding_out_tbl
4037: );
4038:
4039: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4040:
4041: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4042:
4043: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4041: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4037: );
4038:
4039: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4040:
4041: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4042:
4043: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4044:
4045: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4043: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4039: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4040:
4041: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4042:
4043: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4044:
4045: RAISE OKE_API.G_EXCEPTION_ERROR;
4046:
4047: END IF;

Line 4045: RAISE OKE_API.G_EXCEPTION_ERROR;

4041: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4042:
4043: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4044:
4045: RAISE OKE_API.G_EXCEPTION_ERROR;
4046:
4047: END IF;
4048:
4049: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 4060: p_init_msg_list => OKE_API.G_FALSE ,

4056:
4057: l_allocation_in_rec.agreement_id := l_agreement_id;
4058:
4059: add_pa_funding(p_api_version => p_api_version ,
4060: p_init_msg_list => OKE_API.G_FALSE ,
4061: p_commit => OKE_API.G_FALSE ,
4062: p_msg_count => p_msg_count ,
4063: p_msg_data => p_msg_data ,
4064: p_allocation_in_rec => l_allocation_in_rec ,

Line 4061: p_commit => OKE_API.G_FALSE ,

4057: l_allocation_in_rec.agreement_id := l_agreement_id;
4058:
4059: add_pa_funding(p_api_version => p_api_version ,
4060: p_init_msg_list => OKE_API.G_FALSE ,
4061: p_commit => OKE_API.G_FALSE ,
4062: p_msg_count => p_msg_count ,
4063: p_msg_data => p_msg_data ,
4064: p_allocation_in_rec => l_allocation_in_rec ,
4065: p_return_status => p_return_status

Line 4068: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4064: p_allocation_in_rec => l_allocation_in_rec ,
4065: p_return_status => p_return_status
4066: );
4067:
4068: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4069:
4070: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4071:
4072: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4070: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4066: );
4067:
4068: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4069:
4070: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4071:
4072: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4073:
4074: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4072: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4068: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4069:
4070: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4071:
4072: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4073:
4074: RAISE OKE_API.G_EXCEPTION_ERROR;
4075:
4076: END IF;

Line 4074: RAISE OKE_API.G_EXCEPTION_ERROR;

4070: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4071:
4072: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4073:
4074: RAISE OKE_API.G_EXCEPTION_ERROR;
4075:
4076: END IF;
4077:
4078: ELSE

Line 4088: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

4084:
4085: l_agreement_in_rec.amount := 99999999999999999.99999;
4086:
4087: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
4088: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
4089: l_agreement_in_rec.owning_organization_id := null;
4090: ELSE
4091: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
4092: END IF;

Line 4116: p_commit => OKE_API.G_FALSE ,

4112:
4113: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4114:
4115: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4116: p_commit => OKE_API.G_FALSE ,
4117: p_init_msg_list => OKE_API.G_FALSE ,
4118: p_msg_count => p_msg_count ,
4119: p_msg_data => p_msg_data ,
4120: p_return_status => p_return_status ,

Line 4117: p_init_msg_list => OKE_API.G_FALSE ,

4113: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4114:
4115: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4116: p_commit => OKE_API.G_FALSE ,
4117: p_init_msg_list => OKE_API.G_FALSE ,
4118: p_msg_count => p_msg_count ,
4119: p_msg_data => p_msg_data ,
4120: p_return_status => p_return_status ,
4121: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 4128: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4124: p_funding_in_tbl => l_funding_in_tbl ,
4125: p_funding_out_tbl => l_funding_out_tbl
4126: );
4127:
4128: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4129:
4130: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4131:
4132: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4130: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4126: );
4127:
4128: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4129:
4130: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4131:
4132: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4133:
4134: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4132: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4128: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4129:
4130: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4131:
4132: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4133:
4134: RAISE OKE_API.G_EXCEPTION_ERROR;
4135:
4136: END IF;

Line 4134: RAISE OKE_API.G_EXCEPTION_ERROR;

4130: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4131:
4132: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4133:
4134: RAISE OKE_API.G_EXCEPTION_ERROR;
4135:
4136: END IF;
4137:
4138: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 4146: p_init_msg_list => OKE_API.G_FALSE ,

4142:
4143: l_allocation_in_rec.agreement_id := l_agreement_id;
4144:
4145: add_pa_funding(p_api_version => p_api_version ,
4146: p_init_msg_list => OKE_API.G_FALSE ,
4147: p_commit => OKE_API.G_FALSE ,
4148: p_msg_count => p_msg_count ,
4149: p_msg_data => p_msg_data ,
4150: p_allocation_in_rec => l_allocation_in_rec ,

Line 4147: p_commit => OKE_API.G_FALSE ,

4143: l_allocation_in_rec.agreement_id := l_agreement_id;
4144:
4145: add_pa_funding(p_api_version => p_api_version ,
4146: p_init_msg_list => OKE_API.G_FALSE ,
4147: p_commit => OKE_API.G_FALSE ,
4148: p_msg_count => p_msg_count ,
4149: p_msg_data => p_msg_data ,
4150: p_allocation_in_rec => l_allocation_in_rec ,
4151: p_return_status => p_return_status

Line 4154: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4150: p_allocation_in_rec => l_allocation_in_rec ,
4151: p_return_status => p_return_status
4152: );
4153:
4154: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4155:
4156: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4157:
4158: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4156: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4152: );
4153:
4154: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4155:
4156: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4157:
4158: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4159:
4160: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4158: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4154: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4155:
4156: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4157:
4158: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4159:
4160: RAISE OKE_API.G_EXCEPTION_ERROR;
4161:
4162: END IF;

Line 4160: RAISE OKE_API.G_EXCEPTION_ERROR;

4156: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4157:
4158: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4159:
4160: RAISE OKE_API.G_EXCEPTION_ERROR;
4161:
4162: END IF;
4163:
4164: END IF;

Line 4185: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN

4181:
4182: FOR l_agreement in c_agreement3 LOOP
4183:
4184: IF (nvl(l_org_id_vc, -99) <> nvl(l_agreement.org_id, -99)) OR
4185: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
4186: l_agreement_in_rec.owning_organization_id := null;
4187: ELSE
4188: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
4189: END IF;

Line 4224: p_commit => OKE_API.G_FALSE ,

4220:
4221: END IF;
4222:
4223: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
4224: p_commit => OKE_API.G_FALSE ,
4225: p_init_msg_list => OKE_API.G_FALSE ,
4226: p_msg_count => p_msg_count ,
4227: p_msg_data => p_msg_data ,
4228: p_return_status => p_return_status ,

Line 4225: p_init_msg_list => OKE_API.G_FALSE ,

4221: END IF;
4222:
4223: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
4224: p_commit => OKE_API.G_FALSE ,
4225: p_init_msg_list => OKE_API.G_FALSE ,
4226: p_msg_count => p_msg_count ,
4227: p_msg_data => p_msg_data ,
4228: p_return_status => p_return_status ,
4229: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 4236: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4232: p_funding_in_tbl => l_funding_in_tbl ,
4233: p_funding_out_tbl => l_funding_out_tbl
4234: );
4235:
4236: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4237:
4238: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239:
4240: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4238: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4234: );
4235:
4236: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4237:
4238: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239:
4240: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4241:
4242: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4240: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4236: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4237:
4238: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239:
4240: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4241:
4242: RAISE OKE_API.G_EXCEPTION_ERROR;
4243:
4244: END IF;

Line 4242: RAISE OKE_API.G_EXCEPTION_ERROR;

4238: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4239:
4240: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4241:
4242: RAISE OKE_API.G_EXCEPTION_ERROR;
4243:
4244: END IF;
4245:
4246: END LOOP;

Line 4260: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,

4256:
4257: --dbms_output.put_line('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4258: --oke_debug.debug('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4259:
4260: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4261: x_msg_data => p_msg_data
4262: );
4263:
4264: EXCEPTION

Line 4265: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

4261: x_msg_data => p_msg_data
4262: );
4263:
4264: EXCEPTION
4265: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4266: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4267: p_pkg_name => G_PKG_NAME ,
4268: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4269: x_msg_count => p_msg_count ,

Line 4266: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4262: );
4263:
4264: EXCEPTION
4265: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4266: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4267: p_pkg_name => G_PKG_NAME ,
4268: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4269: x_msg_count => p_msg_count ,
4270: x_msg_data => p_msg_data ,

Line 4268: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

4264: EXCEPTION
4265: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4266: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4267: p_pkg_name => G_PKG_NAME ,
4268: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4269: x_msg_count => p_msg_count ,
4270: x_msg_data => p_msg_data ,
4271: p_api_type => '_PVT'
4272: );

Line 4274: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4270: x_msg_data => p_msg_data ,
4271: p_api_type => '_PVT'
4272: );
4273:
4274: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4275: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4276: p_pkg_name => G_PKG_NAME ,
4277: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4278: x_msg_count => p_msg_count ,

Line 4275: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4271: p_api_type => '_PVT'
4272: );
4273:
4274: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4275: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4276: p_pkg_name => G_PKG_NAME ,
4277: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4278: x_msg_count => p_msg_count ,
4279: x_msg_data => p_msg_data ,

Line 4277: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

4273:
4274: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4275: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4276: p_pkg_name => G_PKG_NAME ,
4277: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4278: x_msg_count => p_msg_count ,
4279: x_msg_data => p_msg_data ,
4280: p_api_type => '_PVT'
4281: );

Line 4284: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4280: p_api_type => '_PVT'
4281: );
4282:
4283: WHEN OTHERS THEN
4284: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4285: p_pkg_name => G_PKG_NAME ,
4286: p_exc_name => 'OTHERS' ,
4287: x_msg_count => p_msg_count ,
4288: x_msg_data => p_msg_data ,

Line 4300: -- Calling subprograms: OKE_API.start_activity

4296: -- Procedure: update_pa_funding
4297: --
4298: -- Description: This procedure is used to update record in pa project funding table
4299: --
4300: -- Calling subprograms: OKE_API.start_activity
4301: -- OKE_API.end_activity
4302: -- PA_AGREEMENT_PUB.update_funding
4303: -- PA_AGREEMENT_PUB.add_funding
4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount

Line 4301: -- OKE_API.end_activity

4297: --
4298: -- Description: This procedure is used to update record in pa project funding table
4299: --
4300: -- Calling subprograms: OKE_API.start_activity
4301: -- OKE_API.end_activity
4302: -- PA_AGREEMENT_PUB.update_funding
4303: -- PA_AGREEMENT_PUB.add_funding
4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4305: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

Line 4312: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

4308: -- get_proj_funding
4309: --
4310:
4311: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
4312: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4313: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4314: p_msg_count OUT NOCOPY NUMBER ,
4315: p_msg_data OUT NOCOPY VARCHAR2 ,
4316: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

Line 4313: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

4309: --
4310:
4311: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
4312: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4313: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4314: p_msg_count OUT NOCOPY NUMBER ,
4315: p_msg_data OUT NOCOPY VARCHAR2 ,
4316: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4317: p_return_status OUT NOCOPY VARCHAR2

Line 4397: p_return_status := OKE_API.G_RET_STS_SUCCESS;

4393:
4394: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');
4395: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');
4396:
4397: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4398:
4399: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4400: p_pkg_name => G_PKG_NAME ,
4401: p_init_msg_list => p_init_msg_list ,

Line 4399: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

4395: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');
4396:
4397: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4398:
4399: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4400: p_pkg_name => G_PKG_NAME ,
4401: p_init_msg_list => p_init_msg_list ,
4402: l_api_version => G_API_VERSION_NUMBER ,
4403: p_api_version => p_api_version ,

Line 4408: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4404: p_api_type => '_PVT' ,
4405: x_return_status => p_return_status
4406: );
4407:
4408: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4409:
4410: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4411:
4412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4410: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4406: );
4407:
4408: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4409:
4410: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4411:
4412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4413:
4414: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

4408: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4409:
4410: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4411:
4412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4413:
4414: RAISE OKE_API.G_EXCEPTION_ERROR;
4415:
4416: END IF;

Line 4414: RAISE OKE_API.G_EXCEPTION_ERROR;

4410: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4411:
4412: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4413:
4414: RAISE OKE_API.G_EXCEPTION_ERROR;
4415:
4416: END IF;
4417:
4418: --

Line 4469: RAISE OKE_API.G_EXCEPTION_ERROR;

4465: );
4466:
4467: IF (l_return_status = 'E') THEN
4468:
4469: RAISE OKE_API.G_EXCEPTION_ERROR;
4470:
4471: ELSIF (l_return_status = 'U') THEN
4472:
4473: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4473: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4469: RAISE OKE_API.G_EXCEPTION_ERROR;
4470:
4471: ELSIF (l_return_status = 'U') THEN
4472:
4473: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4474:
4475: END IF;
4476:
4477: ELSE

Line 4550: p_commit => OKE_API.G_FALSE ,

4546: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4547: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4548:
4549: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4550: p_commit => OKE_API.G_FALSE ,
4551: p_init_msg_list => OKE_API.G_FALSE ,
4552: p_msg_count => p_msg_count ,
4553: p_msg_data => p_msg_data ,
4554: p_return_status => p_return_status ,

Line 4551: p_init_msg_list => OKE_API.G_FALSE ,

4547: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4548:
4549: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4550: p_commit => OKE_API.G_FALSE ,
4551: p_init_msg_list => OKE_API.G_FALSE ,
4552: p_msg_count => p_msg_count ,
4553: p_msg_data => p_msg_data ,
4554: p_return_status => p_return_status ,
4555: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 4594: x_commit => OKE_API.G_FALSE

4590: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4591:
4592: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4593: x_version_add => 1 ,
4594: x_commit => OKE_API.G_FALSE
4595: );
4596: END IF;
4597:
4598: ELSE

Line 4614: p_commit => OKE_API.G_FALSE ,

4610: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4611: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4612:
4613: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4614: p_commit => OKE_API.G_FALSE ,
4615: p_init_msg_list => OKE_API.G_FALSE ,
4616: p_msg_count => p_msg_count ,
4617: p_msg_data => p_msg_data ,
4618: p_return_status => p_return_status ,

Line 4615: p_init_msg_list => OKE_API.G_FALSE ,

4611: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4612:
4613: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4614: p_commit => OKE_API.G_FALSE ,
4615: p_init_msg_list => OKE_API.G_FALSE ,
4616: p_msg_count => p_msg_count ,
4617: p_msg_data => p_msg_data ,
4618: p_return_status => p_return_status ,
4619: p_pm_product_code => G_PRODUCT_CODE ,

Line 4658: x_commit => OKE_API.G_FALSE

4654: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4655:
4656: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4657: x_version_add => 0 ,
4658: x_commit => OKE_API.G_FALSE
4659: );
4660:
4661: END IF;
4662:

Line 4666: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4662:
4663: -- fnd_client_info.set_org_context(to_number(l_org_id_vc));
4664: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4665:
4666: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4667:
4668: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4669:
4670: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4668: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4664: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4665:
4666: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4667:
4668: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4669:
4670: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4671:
4672: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4670: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4666: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4667:
4668: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4669:
4670: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4671:
4672: RAISE OKE_API.G_EXCEPTION_ERROR;
4673:
4674: END IF;

Line 4672: RAISE OKE_API.G_EXCEPTION_ERROR;

4668: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4669:
4670: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4671:
4672: RAISE OKE_API.G_EXCEPTION_ERROR;
4673:
4674: END IF;
4675:
4676: -- syho, bug 2328311

Line 4681: p_commit => OKE_API.G_FALSE ,

4677: -- update the ff of the existing project funding lines
4678: --FOR l_project_funding IN c_project_funding (length(p_allocation_in_rec.fund_allocation_id)) LOOP
4679: /*
4680: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4681: p_commit => OKE_API.G_FALSE ,
4682: p_init_msg_list => OKE_API.G_FALSE ,
4683: p_msg_count => p_msg_count ,
4684: p_msg_data => p_msg_data ,
4685: p_return_status => p_return_status ,

Line 4682: p_init_msg_list => OKE_API.G_FALSE ,

4678: --FOR l_project_funding IN c_project_funding (length(p_allocation_in_rec.fund_allocation_id)) LOOP
4679: /*
4680: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4681: p_commit => OKE_API.G_FALSE ,
4682: p_init_msg_list => OKE_API.G_FALSE ,
4683: p_msg_count => p_msg_count ,
4684: p_msg_data => p_msg_data ,
4685: p_return_status => p_return_status ,
4686: p_pm_product_code => G_PRODUCT_CODE ,

Line 4709: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4705: p_attribute10 => l_allocation_in_rec.pa_attribute10 ,
4706: p_funding_id_out => l_funding_id
4707: );
4708:
4709: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4710:
4711: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4712:
4713: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4711: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4707: );
4708:
4709: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4710:
4711: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4712:
4713: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4714:
4715: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4713: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4709: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4710:
4711: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4712:
4713: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4714:
4715: RAISE OKE_API.G_EXCEPTION_ERROR;
4716:
4717: END IF;

Line 4715: RAISE OKE_API.G_EXCEPTION_ERROR;

4711: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4712:
4713: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4714:
4715: RAISE OKE_API.G_EXCEPTION_ERROR;
4716:
4717: END IF;
4718: */
4719: update pa_project_fundings

Line 4748: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,

4744: COMMIT WORK;
4745:
4746: END IF;
4747:
4748: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4749: x_msg_data => p_msg_data
4750: );
4751:
4752: EXCEPTION

Line 4753: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

4749: x_msg_data => p_msg_data
4750: );
4751:
4752: EXCEPTION
4753: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4754: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4755: p_pkg_name => G_PKG_NAME ,
4756: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4757: x_msg_count => p_msg_count ,

Line 4754: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4750: );
4751:
4752: EXCEPTION
4753: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4754: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4755: p_pkg_name => G_PKG_NAME ,
4756: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4757: x_msg_count => p_msg_count ,
4758: x_msg_data => p_msg_data ,

Line 4756: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

4752: EXCEPTION
4753: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4754: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4755: p_pkg_name => G_PKG_NAME ,
4756: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4757: x_msg_count => p_msg_count ,
4758: x_msg_data => p_msg_data ,
4759: p_api_type => '_PVT'
4760: );

Line 4762: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4758: x_msg_data => p_msg_data ,
4759: p_api_type => '_PVT'
4760: );
4761:
4762: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4763: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4764: p_pkg_name => G_PKG_NAME ,
4765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4766: x_msg_count => p_msg_count ,

Line 4763: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4759: p_api_type => '_PVT'
4760: );
4761:
4762: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4763: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4764: p_pkg_name => G_PKG_NAME ,
4765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4766: x_msg_count => p_msg_count ,
4767: x_msg_data => p_msg_data ,

Line 4765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

4761:
4762: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4763: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4764: p_pkg_name => G_PKG_NAME ,
4765: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4766: x_msg_count => p_msg_count ,
4767: x_msg_data => p_msg_data ,
4768: p_api_type => '_PVT'
4769: );

Line 4772: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4768: p_api_type => '_PVT'
4769: );
4770:
4771: WHEN OTHERS THEN
4772: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4773: p_pkg_name => G_PKG_NAME ,
4774: p_exc_name => 'OTHERS' ,
4775: x_msg_count => p_msg_count ,
4776: x_msg_data => p_msg_data ,

Line 4787: -- Calling subprograms: OKE_API.start_activity

4783: -- Procedure: add_pa_funding
4784: --
4785: -- Description: This procedure is used to add pa funding
4786: --
4787: -- Calling subprograms: OKE_API.start_activity
4788: -- OKE_API.end_activity
4789: -- PA_AGREEMENT_PUB.add_funding
4790: -- validate_line_attributes
4791: -- get_converted_amount

Line 4788: -- OKE_API.end_activity

4784: --
4785: -- Description: This procedure is used to add pa funding
4786: --
4787: -- Calling subprograms: OKE_API.start_activity
4788: -- OKE_API.end_activity
4789: -- PA_AGREEMENT_PUB.add_funding
4790: -- validate_line_attributes
4791: -- get_converted_amount
4792: -- get_agreement_org

Line 4796: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,

4792: -- get_agreement_org
4793: --
4794:
4795: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
4796: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4797: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4798: p_msg_count OUT NOCOPY NUMBER ,
4799: p_msg_data OUT NOCOPY VARCHAR2 ,
4800: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

Line 4797: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,

4793: --
4794:
4795: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
4796: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4797: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4798: p_msg_count OUT NOCOPY NUMBER ,
4799: p_msg_data OUT NOCOPY VARCHAR2 ,
4800: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4801: p_return_status OUT NOCOPY VARCHAR2

Line 4817: p_return_status := OKE_API.G_RET_STS_SUCCESS;

4813:
4814: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');
4815: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');
4816:
4817: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4818:
4819: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4820: p_pkg_name => G_PKG_NAME ,
4821: p_init_msg_list => p_init_msg_list ,

Line 4819: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,

4815: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');
4816:
4817: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4818:
4819: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4820: p_pkg_name => G_PKG_NAME ,
4821: p_init_msg_list => p_init_msg_list ,
4822: l_api_version => G_API_VERSION_NUMBER ,
4823: p_api_version => p_api_version ,

Line 4828: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4824: p_api_type => '_PVT' ,
4825: x_return_status => p_return_status
4826: );
4827:
4828: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4829:
4830: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4831:
4832: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4830: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4826: );
4827:
4828: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4829:
4830: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4831:
4832: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4833:
4834: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4832: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

4828: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4829:
4830: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4831:
4832: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4833:
4834: RAISE OKE_API.G_EXCEPTION_ERROR;
4835:
4836: END IF;

Line 4834: RAISE OKE_API.G_EXCEPTION_ERROR;

4830: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4831:
4832: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4833:
4834: RAISE OKE_API.G_EXCEPTION_ERROR;
4835:
4836: END IF;
4837:
4838: --

Line 4863: RAISE OKE_API.G_EXCEPTION_ERROR;

4859: );
4860:
4861: IF (p_return_status = 'E') THEN
4862:
4863: RAISE OKE_API.G_EXCEPTION_ERROR;
4864:
4865: ELSIF (p_return_status = 'U') THEN
4866:
4867: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4867: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4863: RAISE OKE_API.G_EXCEPTION_ERROR;
4864:
4865: ELSIF (p_return_status = 'U') THEN
4866:
4867: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4868:
4869: END IF;
4870:
4871: --

Line 4899: p_commit => OKE_API.G_FALSE ,

4895:
4896: IF (p_allocation_in_rec.amount <> 0) THEN
4897:
4898: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4899: p_commit => OKE_API.G_FALSE ,
4900: p_init_msg_list => OKE_API.G_FALSE ,
4901: p_msg_count => p_msg_count ,
4902: p_msg_data => p_msg_data ,
4903: p_return_status => p_return_status ,

Line 4900: p_init_msg_list => OKE_API.G_FALSE ,

4896: IF (p_allocation_in_rec.amount <> 0) THEN
4897:
4898: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4899: p_commit => OKE_API.G_FALSE ,
4900: p_init_msg_list => OKE_API.G_FALSE ,
4901: p_msg_count => p_msg_count ,
4902: p_msg_data => p_msg_data ,
4903: p_return_status => p_return_status ,
4904: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 4942: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

4938:
4939: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4940: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4941:
4942: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4943:
4944: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4945:
4946: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4944: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4940: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4941:
4942: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4943:
4944: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4945:
4946: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4947:
4948: RAISE OKE_API.G_EXCEPTION_ERROR;

Line 4946: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

4942: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4943:
4944: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4945:
4946: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4947:
4948: RAISE OKE_API.G_EXCEPTION_ERROR;
4949:
4950: END IF;

Line 4948: RAISE OKE_API.G_EXCEPTION_ERROR;

4944: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4945:
4946: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4947:
4948: RAISE OKE_API.G_EXCEPTION_ERROR;
4949:
4950: END IF;
4951:
4952: --

Line 4981: x_commit => OKE_API.G_FALSE

4977: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4978:
4979: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4980: x_version_add => 1 ,
4981: x_commit => OKE_API.G_FALSE
4982: );
4983:
4984: IF FND_API.to_boolean(p_commit) THEN
4985:

Line 4993: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,

4989:
4990: --dbms_output.put_line('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4991: --oke_debug.debug('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4992:
4993: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4994: x_msg_data => p_msg_data
4995: );
4996:
4997: EXCEPTION

Line 4998: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

4994: x_msg_data => p_msg_data
4995: );
4996:
4997: EXCEPTION
4998: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4999: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5000: p_pkg_name => G_PKG_NAME ,
5001: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
5002: x_msg_count => p_msg_count ,

Line 4999: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

4995: );
4996:
4997: EXCEPTION
4998: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4999: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5000: p_pkg_name => G_PKG_NAME ,
5001: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
5002: x_msg_count => p_msg_count ,
5003: x_msg_data => p_msg_data ,

Line 5001: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,

4997: EXCEPTION
4998: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4999: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5000: p_pkg_name => G_PKG_NAME ,
5001: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
5002: x_msg_count => p_msg_count ,
5003: x_msg_data => p_msg_data ,
5004: p_api_type => '_PVT'
5005: );

Line 5007: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5003: x_msg_data => p_msg_data ,
5004: p_api_type => '_PVT'
5005: );
5006:
5007: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5008: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5009: p_pkg_name => G_PKG_NAME ,
5010: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
5011: x_msg_count => p_msg_count ,

Line 5008: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

5004: p_api_type => '_PVT'
5005: );
5006:
5007: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5008: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5009: p_pkg_name => G_PKG_NAME ,
5010: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
5011: x_msg_count => p_msg_count ,
5012: x_msg_data => p_msg_data ,

Line 5010: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,

5006:
5007: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5008: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5009: p_pkg_name => G_PKG_NAME ,
5010: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
5011: x_msg_count => p_msg_count ,
5012: x_msg_data => p_msg_data ,
5013: p_api_type => '_PVT'
5014: );

Line 5017: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,

5013: p_api_type => '_PVT'
5014: );
5015:
5016: WHEN OTHERS THEN
5017: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
5018: p_pkg_name => G_PKG_NAME ,
5019: p_exc_name => 'OTHERS' ,
5020: x_msg_count => p_msg_count ,
5021: x_msg_data => p_msg_data ,