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 410: OKE_API.set_message(p_app_name => G_APP_NAME ,

406: IF (c_org%NOTFOUND) THEN
407:
408: CLOSE c_org;
409:
410: OKE_API.set_message(p_app_name => G_APP_NAME ,
411: p_msg_name => 'OKE_API_INVALID_VALUE' ,
412: p_token1 => 'VALUE' ,
413: p_token1_value => 'agreement_id'
414: );

Line 411: p_msg_name => 'OKE_API_INVALID_VALUE' ,

407:
408: CLOSE c_org;
409:
410: OKE_API.set_message(p_app_name => G_APP_NAME ,
411: p_msg_name => 'OKE_API_INVALID_VALUE' ,
412: p_token1 => 'VALUE' ,
413: p_token1_value => 'agreement_id'
414: );
415:

Line 416: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

412: p_token1 => 'VALUE' ,
413: p_token1_value => 'agreement_id'
414: );
415:
416: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
417:
418: END IF;
419:
420: CLOSE c_org;

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

450: FETCH c_project into p_project_funding;
451:
452: IF (c_project%NOTFOUND) THEN
453:
454: OKE_API.set_message(p_app_name => G_APP_NAME ,
455: p_msg_name => 'OKE_API_INVALID_VALUE' ,
456: p_token1 => 'VALUE' ,
457: p_token1_value => 'project_funding_id'
458: );

Line 455: p_msg_name => 'OKE_API_INVALID_VALUE' ,

451:
452: IF (c_project%NOTFOUND) THEN
453:
454: OKE_API.set_message(p_app_name => G_APP_NAME ,
455: p_msg_name => 'OKE_API_INVALID_VALUE' ,
456: p_token1 => 'VALUE' ,
457: p_token1_value => 'project_funding_id'
458: );
459:

Line 462: RAISE OKE_API.G_EXCEPTION_ERROR;

458: );
459:
460: CLOSE c_project;
461:
462: RAISE OKE_API.G_EXCEPTION_ERROR;
463:
464: END IF;
465:
466: CLOSE c_project;

Line 469: WHEN G_EXCEPTION_HALT_VALIDATION OR OKE_API.G_EXCEPTION_ERROR THEN

465:
466: CLOSE c_project;
467:
468: EXCEPTION
469: WHEN G_EXCEPTION_HALT_VALIDATION OR OKE_API.G_EXCEPTION_ERROR THEN
470: raise G_EXCEPTION_HALT_VALIDATION;
471:
472: WHEN OTHERS THEN
473: OKE_API.set_message(p_app_name => G_APP_NAME ,

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

469: WHEN G_EXCEPTION_HALT_VALIDATION OR OKE_API.G_EXCEPTION_ERROR THEN
470: raise G_EXCEPTION_HALT_VALIDATION;
471:
472: WHEN OTHERS THEN
473: OKE_API.set_message(p_app_name => G_APP_NAME ,
474: p_msg_name => G_UNEXPECTED_ERROR ,
475: p_token1 => G_SQLCODE_TOKEN ,
476: p_token1_value => SQLCODE ,
477: p_token2 => G_SQLERRM_TOKEN ,

Line 485: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

481: IF c_project%ISOPEN THEN
482: CLOSE c_project;
483: END IF;
484:
485: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
486:
487: END get_proj_funding;
488:
489:

Line 502: p_return_status := OKE_API.G_RET_STS_SUCCESS;

498: p_return_status OUT NOCOPY VARCHAR2
499: ) is
500: BEGIN
501:
502: p_return_status := OKE_API.G_RET_STS_SUCCESS;
503:
504: IF (p_agreement_id is null) OR
505: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
506:

Line 505: (p_agreement_id = OKE_API.G_MISS_NUM) THEN

501:
502: p_return_status := OKE_API.G_RET_STS_SUCCESS;
503:
504: IF (p_agreement_id is null) OR
505: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
506:
507: OKE_API.set_message(p_app_name => G_APP_NAME ,
508: p_msg_name => 'OKE_API_MISSING_VALUE' ,
509: p_token1 => 'VALUE' ,

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

503:
504: IF (p_agreement_id is null) OR
505: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
506:
507: OKE_API.set_message(p_app_name => G_APP_NAME ,
508: p_msg_name => 'OKE_API_MISSING_VALUE' ,
509: p_token1 => 'VALUE' ,
510: p_token1_value => 'agreement_id'
511: );

Line 508: p_msg_name => 'OKE_API_MISSING_VALUE' ,

504: IF (p_agreement_id is null) OR
505: (p_agreement_id = OKE_API.G_MISS_NUM) THEN
506:
507: OKE_API.set_message(p_app_name => G_APP_NAME ,
508: p_msg_name => 'OKE_API_MISSING_VALUE' ,
509: p_token1 => 'VALUE' ,
510: p_token1_value => 'agreement_id'
511: );
512:

Line 513: p_return_status := OKE_API.G_RET_STS_ERROR;

509: p_token1 => 'VALUE' ,
510: p_token1_value => 'agreement_id'
511: );
512:
513: p_return_status := OKE_API.G_RET_STS_ERROR;
514:
515: END IF;
516:
517: END validate_agreement_id;

Line 532: p_return_status := OKE_API.G_RET_STS_SUCCESS;

528: p_return_status OUT NOCOPY VARCHAR2
529: ) is
530: BEGIN
531:
532: p_return_status := OKE_API.G_RET_STS_SUCCESS;
533:
534: IF (p_project_id is null) OR
535: (p_project_id = OKE_API.G_MISS_NUM) THEN
536:

Line 535: (p_project_id = OKE_API.G_MISS_NUM) THEN

531:
532: p_return_status := OKE_API.G_RET_STS_SUCCESS;
533:
534: IF (p_project_id is null) OR
535: (p_project_id = OKE_API.G_MISS_NUM) THEN
536:
537: OKE_API.set_message(p_app_name => G_APP_NAME ,
538: p_msg_name => 'OKE_API_MISSING_VALUE' ,
539: p_token1 => 'VALUE' ,

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

533:
534: IF (p_project_id is null) OR
535: (p_project_id = OKE_API.G_MISS_NUM) THEN
536:
537: OKE_API.set_message(p_app_name => G_APP_NAME ,
538: p_msg_name => 'OKE_API_MISSING_VALUE' ,
539: p_token1 => 'VALUE' ,
540: p_token1_value => 'project_id'
541: );

Line 538: p_msg_name => 'OKE_API_MISSING_VALUE' ,

534: IF (p_project_id is null) OR
535: (p_project_id = OKE_API.G_MISS_NUM) THEN
536:
537: OKE_API.set_message(p_app_name => G_APP_NAME ,
538: p_msg_name => 'OKE_API_MISSING_VALUE' ,
539: p_token1 => 'VALUE' ,
540: p_token1_value => 'project_id'
541: );
542:

Line 543: p_return_status := OKE_API.G_RET_STS_ERROR;

539: p_token1 => 'VALUE' ,
540: p_token1_value => 'project_id'
541: );
542:
543: p_return_status := OKE_API.G_RET_STS_ERROR;
544:
545: END IF;
546:
547: END validate_project_id;

Line 567: p_return_status := OKE_API.G_RET_STS_SUCCESS;

563: l_project_number VARCHAR2(25);
564:
565: BEGIN
566:
567: p_return_status := OKE_API.G_RET_STS_SUCCESS;
568:
569: IF (p_task_id is not null) OR
570: (p_task_id <> OKE_API.G_MISS_NUM) THEN
571:

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

566:
567: p_return_status := OKE_API.G_RET_STS_SUCCESS;
568:
569: IF (p_task_id is not null) OR
570: (p_task_id <> OKE_API.G_MISS_NUM) THEN
571:
572: OKE_FUNDING_UTIL_PKG.multi_customer(x_project_id => p_project_id ,
573: x_project_number => l_project_number,
574: x_count => l_count

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

575: );
576:
577: IF (l_count > 1) then
578:
579: OKE_API.set_message(p_app_name => G_APP_NAME ,
580: p_msg_name => 'OKE_MULTI_CUSTOMER_PROJ' ,
581: p_token1 => 'PROJECT' ,
582: p_token1_value => l_project_number
583: );

Line 585: p_return_status := OKE_API.G_RET_STS_ERROR;

581: p_token1 => 'PROJECT' ,
582: p_token1_value => l_project_number
583: );
584:
585: p_return_status := OKE_API.G_RET_STS_ERROR;
586:
587: END IF;
588:
589: END IF;

Line 606: p_return_status := OKE_API.G_RET_STS_SUCCESS;

602: p_return_status OUT NOCOPY VARCHAR2
603: ) is
604: BEGIN
605:
606: p_return_status := OKE_API.G_RET_STS_SUCCESS;
607:
608: IF (p_date_allocated is null) OR
609: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
610:

Line 609: (p_date_allocated = OKE_API.G_MISS_DATE) THEN

605:
606: p_return_status := OKE_API.G_RET_STS_SUCCESS;
607:
608: IF (p_date_allocated is null) OR
609: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
610:
611: OKE_API.set_message(p_app_name => G_APP_NAME ,
612: p_msg_name => 'OKE_API_MISSING_VALUE' ,
613: p_token1 => 'VALUE' ,

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

607:
608: IF (p_date_allocated is null) OR
609: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
610:
611: OKE_API.set_message(p_app_name => G_APP_NAME ,
612: p_msg_name => 'OKE_API_MISSING_VALUE' ,
613: p_token1 => 'VALUE' ,
614: p_token1_value => 'start_date_active'
615: );

Line 612: p_msg_name => 'OKE_API_MISSING_VALUE' ,

608: IF (p_date_allocated is null) OR
609: (p_date_allocated = OKE_API.G_MISS_DATE) THEN
610:
611: OKE_API.set_message(p_app_name => G_APP_NAME ,
612: p_msg_name => 'OKE_API_MISSING_VALUE' ,
613: p_token1 => 'VALUE' ,
614: p_token1_value => 'start_date_active'
615: );
616:

Line 617: p_return_status := OKE_API.G_RET_STS_ERROR;

613: p_token1 => 'VALUE' ,
614: p_token1_value => 'start_date_active'
615: );
616:
617: p_return_status := OKE_API.G_RET_STS_ERROR;
618:
619: END IF;
620:
621: END validate_date_allocated;

Line 636: p_return_status := OKE_API.G_RET_STS_SUCCESS;

632: p_return_status OUT NOCOPY VARCHAR2
633: ) is
634: BEGIN
635:
636: p_return_status := OKE_API.G_RET_STS_SUCCESS;
637:
638: IF (p_funding_category is null) OR
639: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
640:

Line 639: (p_funding_category = OKE_API.G_MISS_CHAR) THEN

635:
636: p_return_status := OKE_API.G_RET_STS_SUCCESS;
637:
638: IF (p_funding_category is null) OR
639: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
640:
641: OKE_API.set_message(p_app_name => G_APP_NAME ,
642: p_msg_name => 'OKE_API_MISSING_VALUE' ,
643: p_token1 => 'VALUE' ,

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

637:
638: IF (p_funding_category is null) OR
639: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
640:
641: OKE_API.set_message(p_app_name => G_APP_NAME ,
642: p_msg_name => 'OKE_API_MISSING_VALUE' ,
643: p_token1 => 'VALUE' ,
644: p_token1_value => 'funding_category'
645: );

Line 642: p_msg_name => 'OKE_API_MISSING_VALUE' ,

638: IF (p_funding_category is null) OR
639: (p_funding_category = OKE_API.G_MISS_CHAR) THEN
640:
641: OKE_API.set_message(p_app_name => G_APP_NAME ,
642: p_msg_name => 'OKE_API_MISSING_VALUE' ,
643: p_token1 => 'VALUE' ,
644: p_token1_value => 'funding_category'
645: );
646:

Line 647: p_return_status := OKE_API.G_RET_STS_ERROR;

643: p_token1 => 'VALUE' ,
644: p_token1_value => 'funding_category'
645: );
646:
647: p_return_status := OKE_API.G_RET_STS_ERROR;
648:
649: END IF;
650:
651: END validate_funding_category;

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

668:
669: validate_agreement_id(p_agreement_id => p_allocation_in_rec.agreement_id ,
670: p_return_status => l_return_status);
671:
672: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
673:
674: RAISE G_EXCEPTION_HALT_VALIDATION;
675:
676: END IF;

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

681:
682: validate_project_id(p_project_id => p_allocation_in_rec.project_id ,
683: p_return_status => l_return_status);
684:
685: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
686:
687: RAISE G_EXCEPTION_HALT_VALIDATION;
688:
689: END IF;

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

696: validate_task_id(p_task_id => p_allocation_in_rec.task_id ,
697: 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:
712: validate_date_allocated(p_date_allocated => p_allocation_in_rec.start_date_active ,
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 728: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN

724:
725: validate_funding_category(p_funding_category => p_allocation_in_rec.funding_category ,
726: p_return_status => l_return_status);
727:
728: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
729:
730: RAISE G_EXCEPTION_HALT_VALIDATION;
731:
732: END IF;

Line 760: WHEN OKE_API.G_EXCEPTION_ERROR THEN

756: FETCH c_currency into p_min_unit;
757: CLOSE c_currency;
758:
759: EXCEPTION
760: WHEN OKE_API.G_EXCEPTION_ERROR THEN
761: RAISE OKE_API.G_EXCEPTION_ERROR;
762:
763: WHEN OTHERS THEN
764: OKE_API.set_message(p_app_name => G_APP_NAME ,

Line 761: RAISE OKE_API.G_EXCEPTION_ERROR;

757: CLOSE c_currency;
758:
759: EXCEPTION
760: WHEN OKE_API.G_EXCEPTION_ERROR THEN
761: RAISE OKE_API.G_EXCEPTION_ERROR;
762:
763: WHEN OTHERS THEN
764: OKE_API.set_message(p_app_name => G_APP_NAME ,
765: p_msg_name => G_UNEXPECTED_ERROR ,

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

760: WHEN OKE_API.G_EXCEPTION_ERROR THEN
761: RAISE OKE_API.G_EXCEPTION_ERROR;
762:
763: WHEN OTHERS THEN
764: OKE_API.set_message(p_app_name => G_APP_NAME ,
765: p_msg_name => G_UNEXPECTED_ERROR ,
766: p_token1 => G_SQLCODE_TOKEN ,
767: p_token1_value => SQLCODE ,
768: p_token2 => G_SQLERRM_TOKEN ,

Line 776: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

772: IF c_currency%ISOPEN THEN
773: CLOSE c_currency;
774: END IF;
775:
776: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
777:
778: END get_min_unit;
779:
780:

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

875: END IF;
876:
877: EXCEPTION
878: WHEN NO_FUND THEN
879: OKE_API.set_message(p_app_name => G_APP_NAME ,
880: p_msg_name => 'OKE_API_INVALID_VALUE' ,
881: p_token1 => 'VALUE' ,
882: p_token1_value => 'funding_source_id'
883: );

Line 880: p_msg_name => 'OKE_API_INVALID_VALUE' ,

876:
877: EXCEPTION
878: WHEN NO_FUND THEN
879: OKE_API.set_message(p_app_name => G_APP_NAME ,
880: p_msg_name => 'OKE_API_INVALID_VALUE' ,
881: p_token1 => 'VALUE' ,
882: p_token1_value => 'funding_source_id'
883: );
884:

Line 889: RAISE OKE_API.G_EXCEPTION_ERROR;

885: IF c_currency%ISOPEN THEN
886: CLOSE c_currency;
887: END IF;
888:
889: RAISE OKE_API.G_EXCEPTION_ERROR;
890:
891: WHEN OTHERS THEN
892: OKE_API.set_message(p_app_name => G_APP_NAME ,
893: p_msg_name => G_UNEXPECTED_ERROR ,

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

888:
889: RAISE OKE_API.G_EXCEPTION_ERROR;
890:
891: WHEN OTHERS THEN
892: OKE_API.set_message(p_app_name => G_APP_NAME ,
893: p_msg_name => G_UNEXPECTED_ERROR ,
894: p_token1 => G_SQLCODE_TOKEN ,
895: p_token1_value => SQLCODE ,
896: p_token2 => G_SQLERRM_TOKEN ,

Line 912: RAISE OKE_API.G_EXCEPTION_ERROR;

908: IF c_ou%ISOPEN THEN
909: CLOSE c_ou;
910: END IF;
911:
912: RAISE OKE_API.G_EXCEPTION_ERROR;
913:
914: END get_converted_amount;
915:
916:

Line 937: p_return_status := OKE_API.G_RET_STS_SUCCESS;

933: l_dummy_value VARCHAR2(1) := '?';
934:
935: BEGIN
936:
937: p_return_status := OKE_API.G_RET_STS_SUCCESS;
938:
939: IF (p_agreement_type is not null) OR
940: (p_agreement_type <> OKE_API.G_MISS_CHAR) THEN
941:

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

936:
937: p_return_status := OKE_API.G_RET_STS_SUCCESS;
938:
939: IF (p_agreement_type is not null) OR
940: (p_agreement_type <> OKE_API.G_MISS_CHAR) THEN
941:
942: OPEN c_agreement_type;
943: FETCH c_agreement_type into l_dummy_value;
944: CLOSE c_agreement_type;

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

944: CLOSE c_agreement_type;
945:
946: IF (l_dummy_value = '?') THEN
947:
948: OKE_API.set_message(p_app_name => G_APP_NAME ,
949: p_msg_name => 'OKE_API_INVALID_VALUE' ,
950: p_token1 => 'VALUE' ,
951: p_token1_value => 'agreement_type'
952: );

Line 949: p_msg_name => 'OKE_API_INVALID_VALUE' ,

945:
946: IF (l_dummy_value = '?') THEN
947:
948: OKE_API.set_message(p_app_name => G_APP_NAME ,
949: p_msg_name => 'OKE_API_INVALID_VALUE' ,
950: p_token1 => 'VALUE' ,
951: p_token1_value => 'agreement_type'
952: );
953:

Line 954: p_return_status := OKE_API.G_RET_STS_ERROR;

950: p_token1 => 'VALUE' ,
951: p_token1_value => 'agreement_type'
952: );
953:
954: p_return_status := OKE_API.G_RET_STS_ERROR;
955:
956: END IF;
957:
958: ELSE

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

956: END IF;
957:
958: ELSE
959:
960: OKE_API.set_message(p_app_name => G_APP_NAME ,
961: p_msg_name => 'OKE_API_MISSING_VALUE' ,
962: p_token1 => 'VALUE' ,
963: p_token1_value => 'p_agreement_type'
964: );

Line 961: p_msg_name => 'OKE_API_MISSING_VALUE' ,

957:
958: ELSE
959:
960: OKE_API.set_message(p_app_name => G_APP_NAME ,
961: p_msg_name => 'OKE_API_MISSING_VALUE' ,
962: p_token1 => 'VALUE' ,
963: p_token1_value => 'p_agreement_type'
964: );
965:

Line 966: p_return_status := OKE_API.G_RET_STS_ERROR;

962: p_token1 => 'VALUE' ,
963: p_token1_value => 'p_agreement_type'
964: );
965:
966: p_return_status := OKE_API.G_RET_STS_ERROR;
967:
968: END IF;
969:
970: EXCEPTION

Line 972: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

968: END IF;
969:
970: EXCEPTION
971: WHEN OTHERS THEN
972: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
973: OKE_API.set_message(p_app_name => G_APP_NAME ,
974: p_msg_name => G_UNEXPECTED_ERROR ,
975: p_token1 => G_SQLCODE_TOKEN ,
976: p_token1_value => SQLCODE ,

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

969:
970: EXCEPTION
971: WHEN OTHERS THEN
972: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
973: OKE_API.set_message(p_app_name => G_APP_NAME ,
974: p_msg_name => G_UNEXPECTED_ERROR ,
975: p_token1 => G_SQLCODE_TOKEN ,
976: p_token1_value => SQLCODE ,
977: p_token2 => G_SQLERRM_TOKEN ,

Line 1012: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1008: l_dummy_value VARCHAR2(1) := '?';
1009:
1010: BEGIN
1011:
1012: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1013:
1014: IF (p_customer_num is null) OR
1015: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1016:

Line 1015: (p_customer_num = OKE_API.G_MISS_CHAR) THEN

1011:
1012: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1013:
1014: IF (p_customer_num is null) OR
1015: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1016:
1017: OKE_API.set_message(p_app_name => G_APP_NAME ,
1018: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1019: p_token1 => 'VALUE' ,

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

1013:
1014: IF (p_customer_num is null) OR
1015: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1016:
1017: OKE_API.set_message(p_app_name => G_APP_NAME ,
1018: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1019: p_token1 => 'VALUE' ,
1020: p_token1_value => 'customer_number'
1021: );

Line 1018: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1014: IF (p_customer_num is null) OR
1015: (p_customer_num = OKE_API.G_MISS_CHAR) THEN
1016:
1017: OKE_API.set_message(p_app_name => G_APP_NAME ,
1018: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1019: p_token1 => 'VALUE' ,
1020: p_token1_value => 'customer_number'
1021: );
1022:

Line 1023: p_return_status := OKE_API.G_RET_STS_ERROR;

1019: p_token1 => 'VALUE' ,
1020: p_token1_value => 'customer_number'
1021: );
1022:
1023: p_return_status := OKE_API.G_RET_STS_ERROR;
1024:
1025: ELSE
1026:
1027: OPEN c_customer;

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

1029: CLOSE c_customer;
1030:
1031: IF (l_dummy_value = '?') THEN
1032:
1033: OKE_API.set_message(p_app_name => G_APP_NAME ,
1034: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1035: p_token1 => 'VALUE' ,
1036: p_token1_value => 'customer_number'
1037: );

Line 1034: p_msg_name => 'OKE_API_INVALID_VALUE' ,

1030:
1031: IF (l_dummy_value = '?') THEN
1032:
1033: OKE_API.set_message(p_app_name => G_APP_NAME ,
1034: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1035: p_token1 => 'VALUE' ,
1036: p_token1_value => 'customer_number'
1037: );
1038:

Line 1039: p_return_status := OKE_API.G_RET_STS_ERROR;

1035: p_token1 => 'VALUE' ,
1036: p_token1_value => 'customer_number'
1037: );
1038:
1039: p_return_status := OKE_API.G_RET_STS_ERROR;
1040:
1041: END IF;
1042:
1043: END IF;

Line 1047: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1043: END IF;
1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1048: OKE_API.set_message(p_app_name => G_APP_NAME ,
1049: p_msg_name => G_UNEXPECTED_ERROR ,
1050: p_token1 => G_SQLCODE_TOKEN ,
1051: p_token1_value => SQLCODE ,

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

1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1048: OKE_API.set_message(p_app_name => G_APP_NAME ,
1049: p_msg_name => G_UNEXPECTED_ERROR ,
1050: p_token1 => G_SQLCODE_TOKEN ,
1051: p_token1_value => SQLCODE ,
1052: p_token2 => G_SQLERRM_TOKEN ,

Line 1085: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1081: l_dummy_value VARCHAR2(1) := '?';
1082:
1083: BEGIN
1084:
1085: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1086:
1087: IF (p_customer_id is null) OR
1088: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1089:

Line 1088: (p_customer_id = OKE_API.G_MISS_NUM) THEN

1084:
1085: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1086:
1087: IF (p_customer_id is null) OR
1088: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1089:
1090: OKE_API.set_message(p_app_name => G_APP_NAME ,
1091: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1092: p_token1 => 'VALUE' ,

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

1086:
1087: IF (p_customer_id is null) OR
1088: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1089:
1090: OKE_API.set_message(p_app_name => G_APP_NAME ,
1091: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1092: p_token1 => 'VALUE' ,
1093: p_token1_value => 'customer_id'
1094: );

Line 1091: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1087: IF (p_customer_id is null) OR
1088: (p_customer_id = OKE_API.G_MISS_NUM) THEN
1089:
1090: OKE_API.set_message(p_app_name => G_APP_NAME ,
1091: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1092: p_token1 => 'VALUE' ,
1093: p_token1_value => 'customer_id'
1094: );
1095:

Line 1096: p_return_status := OKE_API.G_RET_STS_ERROR;

1092: p_token1 => 'VALUE' ,
1093: p_token1_value => 'customer_id'
1094: );
1095:
1096: p_return_status := OKE_API.G_RET_STS_ERROR;
1097:
1098: ELSE
1099:
1100: OPEN c_customer_id;

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

1102: CLOSE c_customer_id;
1103: --dbms_output.put_line('l_dummy_value' || l_dummy_value);
1104: IF (l_dummy_value = '?') THEN
1105:
1106: OKE_API.set_message(p_app_name => G_APP_NAME ,
1107: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1108: p_token1 => 'VALUE' ,
1109: p_token1_value => 'customer_id'
1110: );

Line 1107: p_msg_name => 'OKE_API_INVALID_VALUE' ,

1103: --dbms_output.put_line('l_dummy_value' || l_dummy_value);
1104: IF (l_dummy_value = '?') THEN
1105:
1106: OKE_API.set_message(p_app_name => G_APP_NAME ,
1107: p_msg_name => 'OKE_API_INVALID_VALUE' ,
1108: p_token1 => 'VALUE' ,
1109: p_token1_value => 'customer_id'
1110: );
1111:

Line 1112: p_return_status := OKE_API.G_RET_STS_ERROR;

1108: p_token1 => 'VALUE' ,
1109: p_token1_value => 'customer_id'
1110: );
1111:
1112: p_return_status := OKE_API.G_RET_STS_ERROR;
1113:
1114: END IF;
1115:
1116: END IF;

Line 1120: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;

1116: END IF;
1117:
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1121: OKE_API.set_message(p_app_name => G_APP_NAME ,
1122: p_msg_name => G_UNEXPECTED_ERROR ,
1123: p_token1 => G_SQLCODE_TOKEN ,
1124: p_token1_value => SQLCODE ,

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

1117:
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: p_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
1121: OKE_API.set_message(p_app_name => G_APP_NAME ,
1122: p_msg_name => G_UNEXPECTED_ERROR ,
1123: p_token1 => G_SQLCODE_TOKEN ,
1124: p_token1_value => SQLCODE ,
1125: p_token2 => G_SQLERRM_TOKEN ,

Line 1148: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1144: p_return_status OUT NOCOPY VARCHAR2
1145: ) is
1146: BEGIN
1147:
1148: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1149:
1150: IF (p_agreement_num is null) OR
1151: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1152:

Line 1151: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN

1147:
1148: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1149:
1150: IF (p_agreement_num is null) OR
1151: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1152:
1153: OKE_API.set_message(p_app_name => G_APP_NAME ,
1154: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1155: p_token1 => 'VALUE' ,

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

1149:
1150: IF (p_agreement_num is null) OR
1151: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1152:
1153: OKE_API.set_message(p_app_name => G_APP_NAME ,
1154: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1155: p_token1 => 'VALUE' ,
1156: p_token1_value => 'agreement_number'
1157: );

Line 1154: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1150: IF (p_agreement_num is null) OR
1151: (p_agreement_num = OKE_API.G_MISS_CHAR) THEN
1152:
1153: OKE_API.set_message(p_app_name => G_APP_NAME ,
1154: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1155: p_token1 => 'VALUE' ,
1156: p_token1_value => 'agreement_number'
1157: );
1158:

Line 1159: p_return_status := OKE_API.G_RET_STS_ERROR;

1155: p_token1 => 'VALUE' ,
1156: p_token1_value => 'agreement_number'
1157: );
1158:
1159: p_return_status := OKE_API.G_RET_STS_ERROR;
1160:
1161: END IF;
1162:
1163: END validate_agreement_number;

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

1194: CLOSE c_exist;
1195:
1196: IF (l_dummy_value = '?') THEN
1197:
1198: OKE_API.set_message(p_app_name => G_APP_NAME ,
1199: p_msg_name => 'OKE_NO_FUND_LINES'
1200: );
1201:
1202: RAISE G_EXCEPTION_HALT_VALIDATION;

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

1209: CLOSE c_project;
1210: --dbms_output.put_line('project null l_dummy_value ' || l_dummy_value);
1211: IF (l_dummy_value = 'x') THEN
1212:
1213: OKE_API.set_message(p_app_name => G_APP_NAME ,
1214: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1215: p_token1 => 'VALUE' ,
1216: p_token1_value => 'project_id'
1217: );

Line 1214: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1210: --dbms_output.put_line('project null l_dummy_value ' || l_dummy_value);
1211: IF (l_dummy_value = 'x') THEN
1212:
1213: OKE_API.set_message(p_app_name => G_APP_NAME ,
1214: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1215: p_token1 => 'VALUE' ,
1216: p_token1_value => 'project_id'
1217: );
1218:

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

1226: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1227: raise G_EXCEPTION_HALT_VALIDATION;
1228:
1229: WHEN OTHERS THEN
1230: OKE_API.set_message(p_app_name => G_APP_NAME ,
1231: p_msg_name => G_UNEXPECTED_ERROR ,
1232: p_token1 => G_SQLCODE_TOKEN ,
1233: p_token1_value => SQLCODE ,
1234: p_token2 => G_SQLERRM_TOKEN ,

Line 1242: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1238: IF c_project%ISOPEN THEN
1239: CLOSE c_project;
1240: END IF;
1241:
1242: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243:
1244: END check_project_null;
1245:
1246:

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

1263: --
1264: validate_agreement_type(p_agreement_type => p_agreement_type ,
1265: p_return_status => l_return_status );
1266:
1267: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
1268:
1269: RAISE G_EXCEPTION_HALT_VALIDATION;
1270:
1271: END IF;

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

1276:
1277: validate_agreement_number(p_agreement_num => p_funding_in_rec.agreement_number ,
1278: p_return_status => l_return_status );
1279:
1280: IF (l_return_status <> OKE_API.G_RET_STS_SUCCESS) THEN
1281:
1282: RAISE G_EXCEPTION_HALT_VALIDATION;
1283:
1284: END IF;

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

1291: p_k_party_id => p_funding_in_rec.k_party_id ,
1292: p_return_status => l_return_status
1293: );
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_customer_num => p_funding_in_rec.customer_number ,
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 1350: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1346:
1347: IF (c_agreement%NOTFOUND) THEN
1348:
1349: CLOSE c_agreement;
1350: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1351:
1352: END IF;
1353:
1354: CLOSE c_agreement;

Line 1431: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1427: p_agreement_in_rec_new.template_flag := l_agreement_row.template_flag;
1428: END IF;
1429:
1430: EXCEPTION
1431: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433:
1434: WHEN OTHERS THEN
1435: OKE_API.set_message(p_app_name => G_APP_NAME ,

Line 1432: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1428: END IF;
1429:
1430: EXCEPTION
1431: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433:
1434: WHEN OTHERS THEN
1435: OKE_API.set_message(p_app_name => G_APP_NAME ,
1436: p_msg_name => G_UNEXPECTED_ERROR ,

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

1431: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1432: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1433:
1434: WHEN OTHERS THEN
1435: OKE_API.set_message(p_app_name => G_APP_NAME ,
1436: p_msg_name => G_UNEXPECTED_ERROR ,
1437: p_token1 => G_SQLCODE_TOKEN ,
1438: p_token1_value => SQLCODE ,
1439: p_token2 => G_SQLERRM_TOKEN ,

Line 1551: p_return_status := OKE_API.G_RET_STS_SUCCESS;

1547:
1548: --oke_debug.debug('entering upd_insert_agreement');
1549: --dbms_output.put_line('entering upd_insert_agreement');
1550:
1551: p_return_status := OKE_API.G_RET_STS_SUCCESS;
1552:
1553: l_length := LENGTH(p_funding_source_id);
1554:
1555: OPEN c_agreement_count(l_length + 1);

Line 1711: p_commit => OKE_API.G_FALSE ,

1707:
1708: END IF;
1709:
1710: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1711: p_commit => OKE_API.G_FALSE ,
1712: p_init_msg_list => OKE_API.G_FALSE ,
1713: p_msg_count => p_msg_count ,
1714: p_msg_data => p_msg_data ,
1715: p_return_status => p_return_status ,

Line 1712: p_init_msg_list => OKE_API.G_FALSE ,

1708: END IF;
1709:
1710: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1711: p_commit => OKE_API.G_FALSE ,
1712: p_init_msg_list => OKE_API.G_FALSE ,
1713: p_msg_count => p_msg_count ,
1714: p_msg_data => p_msg_data ,
1715: p_return_status => p_return_status ,
1716: p_pm_product_code => G_PRODUCT_CODE ,

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

1719: p_funding_in_tbl => l_funding_in_tbl ,
1720: p_funding_out_tbl => l_funding_out_tbl
1721: );
1722:
1723: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1724:
1725: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726:
1727: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1725: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1721: );
1722:
1723: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1724:
1725: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726:
1727: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1728:
1729: RAISE OKE_API.G_EXCEPTION_ERROR;

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

1723: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1724:
1725: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726:
1727: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1728:
1729: RAISE OKE_API.G_EXCEPTION_ERROR;
1730:
1731: END IF;

Line 1729: RAISE OKE_API.G_EXCEPTION_ERROR;

1725: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726:
1727: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1728:
1729: RAISE OKE_API.G_EXCEPTION_ERROR;
1730:
1731: END IF;
1732:
1733: END LOOP;

Line 1790: p_commit => OKE_API.G_FALSE ,

1786:
1787: l_agreement_in_rec.amount := 99999999999999999.99999;
1788:
1789: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
1790: p_commit => OKE_API.G_FALSE ,
1791: p_init_msg_list => OKE_API.G_FALSE ,
1792: p_msg_count => p_msg_count ,
1793: p_msg_data => p_msg_data ,
1794: p_return_status => p_return_status ,

Line 1791: p_init_msg_list => OKE_API.G_FALSE ,

1787: l_agreement_in_rec.amount := 99999999999999999.99999;
1788:
1789: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
1790: p_commit => OKE_API.G_FALSE ,
1791: p_init_msg_list => OKE_API.G_FALSE ,
1792: p_msg_count => p_msg_count ,
1793: p_msg_data => p_msg_data ,
1794: p_return_status => p_return_status ,
1795: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

1798: p_funding_in_tbl => l_funding_in_tbl ,
1799: p_funding_out_tbl => l_funding_out_tbl
1800: );
1801:
1802: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1803:
1804: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1805:
1806: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1804: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1800: );
1801:
1802: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1803:
1804: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1805:
1806: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1807:
1808: RAISE OKE_API.G_EXCEPTION_ERROR;

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

1802: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1803:
1804: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1805:
1806: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1807:
1808: RAISE OKE_API.G_EXCEPTION_ERROR;
1809:
1810: END IF;

Line 1808: RAISE OKE_API.G_EXCEPTION_ERROR;

1804: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1805:
1806: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1807:
1808: RAISE OKE_API.G_EXCEPTION_ERROR;
1809:
1810: END IF;
1811:
1812: l_agreement_in_rec_new := l_agreement_in_rec;

Line 1869: p_commit => OKE_API.G_FALSE ,

1865:
1866: END IF;
1867:
1868: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1869: p_commit => OKE_API.G_FALSE ,
1870: p_init_msg_list => OKE_API.G_FALSE ,
1871: p_msg_count => p_msg_count ,
1872: p_msg_data => p_msg_data ,
1873: p_return_status => p_return_status ,

Line 1870: p_init_msg_list => OKE_API.G_FALSE ,

1866: END IF;
1867:
1868: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1869: p_commit => OKE_API.G_FALSE ,
1870: p_init_msg_list => OKE_API.G_FALSE ,
1871: p_msg_count => p_msg_count ,
1872: p_msg_data => p_msg_data ,
1873: p_return_status => p_return_status ,
1874: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

1877: p_funding_in_tbl => l_funding_in_tbl ,
1878: p_funding_out_tbl => l_funding_out_tbl
1879: );
1880:
1881: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1882:
1883: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884:
1885: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1883: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1879: );
1880:
1881: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1882:
1883: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884:
1885: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1886:
1887: RAISE OKE_API.G_EXCEPTION_ERROR;

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

1881: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1882:
1883: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884:
1885: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1886:
1887: RAISE OKE_API.G_EXCEPTION_ERROR;
1888:
1889: END IF;

Line 1887: RAISE OKE_API.G_EXCEPTION_ERROR;

1883: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884:
1885: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1886:
1887: RAISE OKE_API.G_EXCEPTION_ERROR;
1888:
1889: END IF;
1890:
1891: IF (l_org_count = 1) THEN

Line 1953: p_commit => OKE_API.G_FALSE ,

1949:
1950: END IF;
1951:
1952: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1953: p_commit => OKE_API.G_FALSE ,
1954: p_init_msg_list => OKE_API.G_FALSE ,
1955: p_msg_count => p_msg_count ,
1956: p_msg_data => p_msg_data ,
1957: p_return_status => p_return_status ,

Line 1954: p_init_msg_list => OKE_API.G_FALSE ,

1950: END IF;
1951:
1952: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1953: p_commit => OKE_API.G_FALSE ,
1954: p_init_msg_list => OKE_API.G_FALSE ,
1955: p_msg_count => p_msg_count ,
1956: p_msg_data => p_msg_data ,
1957: p_return_status => p_return_status ,
1958: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

1961: p_funding_in_tbl => l_funding_in_tbl ,
1962: p_funding_out_tbl => l_funding_out_tbl
1963: );
1964:
1965: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1966:
1967: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1968:
1969: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 1967: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

1963: );
1964:
1965: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1966:
1967: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1968:
1969: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1970:
1971: RAISE OKE_API.G_EXCEPTION_ERROR;

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

1965: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1966:
1967: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1968:
1969: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1970:
1971: RAISE OKE_API.G_EXCEPTION_ERROR;
1972:
1973: END IF;

Line 1971: RAISE OKE_API.G_EXCEPTION_ERROR;

1967: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1968:
1969: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
1970:
1971: RAISE OKE_API.G_EXCEPTION_ERROR;
1972:
1973: END IF;
1974:
1975: IF (l_org_count = 1) THEN

Line 2030: p_commit => OKE_API.G_FALSE ,

2026:
2027: END IF;
2028:
2029: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2030: p_commit => OKE_API.G_FALSE ,
2031: p_init_msg_list => OKE_API.G_FALSE ,
2032: p_msg_count => p_msg_count ,
2033: p_msg_data => p_msg_data ,
2034: p_return_status => p_return_status ,

Line 2031: p_init_msg_list => OKE_API.G_FALSE ,

2027: END IF;
2028:
2029: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2030: p_commit => OKE_API.G_FALSE ,
2031: p_init_msg_list => OKE_API.G_FALSE ,
2032: p_msg_count => p_msg_count ,
2033: p_msg_data => p_msg_data ,
2034: p_return_status => p_return_status ,
2035: p_pm_product_code => G_PRODUCT_CODE ,

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

2038: p_funding_in_tbl => l_funding_in_tbl ,
2039: p_funding_out_tbl => l_funding_out_tbl
2040: );
2041:
2042: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2043:
2044: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045:
2046: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2044: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2040: );
2041:
2042: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2043:
2044: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045:
2046: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2047:
2048: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2042: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2043:
2044: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045:
2046: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2047:
2048: RAISE OKE_API.G_EXCEPTION_ERROR;
2049:
2050: END IF;

Line 2048: RAISE OKE_API.G_EXCEPTION_ERROR;

2044: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045:
2046: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2047:
2048: RAISE OKE_API.G_EXCEPTION_ERROR;
2049:
2050: END IF;
2051:
2052: END LOOP;

Line 2118: p_return_status := OKE_API.G_RET_STS_SUCCESS;

2114:
2115: --oke_debug.debug('entering upd_insert_agreement');
2116: --dbms_output.put_line('entering upd_insert_agreement');
2117:
2118: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2119:
2120: l_length := LENGTH(p_funding_source_id);
2121:
2122: OPEN c_agreement_count(l_length);

Line 2203: p_commit => OKE_API.G_FALSE ,

2199:
2200: END IF;
2201:
2202: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2203: p_commit => OKE_API.G_FALSE ,
2204: p_init_msg_list => OKE_API.G_FALSE ,
2205: p_msg_count => p_msg_count ,
2206: p_msg_data => p_msg_data ,
2207: p_return_status => p_return_status ,

Line 2204: p_init_msg_list => OKE_API.G_FALSE ,

2200: END IF;
2201:
2202: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2203: p_commit => OKE_API.G_FALSE ,
2204: p_init_msg_list => OKE_API.G_FALSE ,
2205: p_msg_count => p_msg_count ,
2206: p_msg_data => p_msg_data ,
2207: p_return_status => p_return_status ,
2208: p_pm_product_code => G_PRODUCT_CODE ,

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

2211: p_funding_in_tbl => l_funding_in_tbl ,
2212: p_funding_out_tbl => l_funding_out_tbl
2213: );
2214:
2215: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2216:
2217: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218:
2219: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2217: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2213: );
2214:
2215: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2216:
2217: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218:
2219: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2220:
2221: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2215: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2216:
2217: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218:
2219: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2220:
2221: RAISE OKE_API.G_EXCEPTION_ERROR;
2222:
2223: END IF;

Line 2221: RAISE OKE_API.G_EXCEPTION_ERROR;

2217: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218:
2219: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2220:
2221: RAISE OKE_API.G_EXCEPTION_ERROR;
2222:
2223: END IF;
2224:
2225: IF (p_agreement_tbl.COUNT > 0) THEN

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

2320: END IF;
2321:
2322: EXCEPTION
2323: WHEN OTHERS THEN
2324: OKE_API.set_message(p_app_name => G_APP_NAME ,
2325: p_msg_name => G_UNEXPECTED_ERROR ,
2326: p_token1 => G_SQLCODE_TOKEN ,
2327: p_token1_value => SQLCODE ,
2328: p_token2 => G_SQLERRM_TOKEN ,

Line 2352: -- Calling subprograms: OKE_API.start_activity

2348: -- Procedure create_agreement
2349: --
2350: -- Description: This procedure is used to create pa agreement
2351: --
2352: -- Calling subprograms: OKE_API.start_activity
2353: -- OKE_API.end_activity
2354: -- OKE_FUNDING_UTIL_PKG.funding_mode
2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag

Line 2353: -- OKE_API.end_activity

2349: --
2350: -- Description: This procedure is used to create pa agreement
2351: --
2352: -- Calling subprograms: OKE_API.start_activity
2353: -- OKE_API.end_activity
2354: -- OKE_FUNDING_UTIL_PKG.funding_mode
2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2357: -- PA_AGREEMENT_PUB.create_agreement

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

2362: -- set_hard_limit
2363: --
2364:
2365: PROCEDURE create_agreement(p_api_version IN NUMBER ,
2366: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
2367: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
2368: p_msg_count OUT NOCOPY NUMBER ,
2369: p_msg_data OUT NOCOPY VARCHAR2 ,
2370: p_agreement_type IN VARCHAR2 ,

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

2363: --
2364:
2365: PROCEDURE create_agreement(p_api_version IN NUMBER ,
2366: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
2367: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
2368: p_msg_count OUT NOCOPY NUMBER ,
2369: p_msg_data OUT NOCOPY VARCHAR2 ,
2370: p_agreement_type IN VARCHAR2 ,
2371: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,

Line 2486: p_return_status := OKE_API.G_RET_STS_SUCCESS;

2482:
2483: --oke_debug.debug('entering oke_agreement_pvt.create_agreement');
2484: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');
2485:
2486: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2487:
2488: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
2489: p_pkg_name => G_PKG_NAME ,
2490: p_init_msg_list => p_init_msg_list ,

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

2484: --dbms_output.put_line('enter oke_agreement_pvt.create_agreement');
2485:
2486: p_return_status := OKE_API.G_RET_STS_SUCCESS;
2487:
2488: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
2489: p_pkg_name => G_PKG_NAME ,
2490: p_init_msg_list => p_init_msg_list ,
2491: l_api_version => G_API_VERSION_NUMBER ,
2492: p_api_version => p_api_version ,

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

2493: p_api_type => '_PVT' ,
2494: x_return_status => p_return_status
2495: );
2496:
2497: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2498:
2499: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500:
2501: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2499: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2495: );
2496:
2497: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2498:
2499: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500:
2501: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
2502:
2503: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2497: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2498:
2499: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500:
2501: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
2502:
2503: RAISE OKE_API.G_EXCEPTION_ERROR;
2504:
2505: END IF;

Line 2503: RAISE OKE_API.G_EXCEPTION_ERROR;

2499: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500:
2501: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
2502:
2503: RAISE OKE_API.G_EXCEPTION_ERROR;
2504:
2505: END IF;
2506:
2507: --

Line 2567: RAISE OKE_API.G_EXCEPTION_ERROR;

2563: );
2564:
2565: IF (l_return_status = 'E') THEN
2566:
2567: RAISE OKE_API.G_EXCEPTION_ERROR;
2568:
2569: ELSIF (l_return_status = 'U') THEN
2570:
2571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2567: RAISE OKE_API.G_EXCEPTION_ERROR;
2568:
2569: ELSIF (l_return_status = 'U') THEN
2570:
2571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2572:
2573: END IF;
2574:
2575: ELSE

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

2579: END IF;
2580:
2581: l_agreement_tbl(i).object_id := l_allocation.org_id;
2582: l_agreement_tbl(i).agreement_currency_code := l_allocation.projfunc_currency_code;
2583: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2584: l_agreement_tbl(i).total_amount := 0;
2585: END IF;
2586: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2587: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN

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

2583: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2584: l_agreement_tbl(i).total_amount := 0;
2585: END IF;
2586: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2587: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN
2588: l_agreement_tbl(i).org_total_amount := 0;
2589: END IF;
2590: l_agreement_tbl(i).org_total_amount := l_agreement_tbl(i).org_total_amount + l_allocation.amount;
2591:

Line 2631: RAISE OKE_API.G_EXCEPTION_ERROR;

2627: );
2628:
2629: IF (l_return_status = 'E') THEN
2630:
2631: RAISE OKE_API.G_EXCEPTION_ERROR;
2632:
2633: ELSIF (l_return_status = 'U') THEN
2634:
2635: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2635: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2631: RAISE OKE_API.G_EXCEPTION_ERROR;
2632:
2633: ELSIF (l_return_status = 'U') THEN
2634:
2635: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2636:
2637: END IF;
2638:
2639: l_agreement_tbl(i).object_id := l_allocation.org_id;

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

2637: END IF;
2638:
2639: l_agreement_tbl(i).object_id := l_allocation.org_id;
2640: l_agreement_tbl(i).agreement_currency_code := l_allocation.projfunc_currency_code;
2641: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2642: l_agreement_tbl(i).total_amount := 0;
2643: END IF;
2644: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2645: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN

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

2641: IF (l_agreement_tbl(i).total_amount = OKE_API.G_MISS_NUM) THEN
2642: l_agreement_tbl(i).total_amount := 0;
2643: END IF;
2644: l_agreement_tbl(i).total_amount := l_agreement_tbl(i).total_amount + l_amount;
2645: IF (l_agreement_tbl(i).org_total_amount = OKE_API.G_MISS_NUM) THEN
2646: l_agreement_tbl(i).org_total_amount := 0;
2647: END IF;
2648: l_agreement_tbl(i).org_total_amount := l_agreement_tbl(i).org_total_amount + l_allocation.amount;
2649:

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

2667: ELSE
2668:
2669: l_agreement_tbl(i + 1).object_id := l_allocation.org_id;
2670: l_agreement_tbl(i + 1).agreement_currency_code := l_funding_in_rec.currency_code;
2671: IF (l_agreement_tbl(i + 1).total_amount = OKE_API.G_MISS_NUM) THEN
2672: l_agreement_tbl(i + 1).total_amount := 0;
2673: END IF;
2674: l_agreement_tbl(i + 1).total_amount := l_agreement_tbl(i + 1).total_amount + l_allocation.amount;
2675: IF (l_agreement_tbl(i + 1).org_total_amount = OKE_API.G_MISS_NUM) THEN

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

2671: IF (l_agreement_tbl(i + 1).total_amount = OKE_API.G_MISS_NUM) THEN
2672: l_agreement_tbl(i + 1).total_amount := 0;
2673: END IF;
2674: l_agreement_tbl(i + 1).total_amount := l_agreement_tbl(i + 1).total_amount + l_allocation.amount;
2675: IF (l_agreement_tbl(i + 1).org_total_amount = OKE_API.G_MISS_NUM) THEN
2676: l_agreement_tbl(i + 1).org_total_amount := 0;
2677: END IF;
2678: l_agreement_tbl(i + 1).org_total_amount := l_agreement_tbl(i + 1).org_total_amount + l_allocation.amount;
2679:

Line 2709: OKE_API.set_message(

2705: --
2706: -- Check if valid allocations exist -- bug#4322146
2707: --
2708: IF l_agreement_tbl.COUNT = 0 THEN
2709: OKE_API.set_message(
2710: p_app_name => G_APP_NAME, p_msg_name => 'OKE_FUND_NO_VALID_ALLOCATIONS'
2711: );
2712: RAISE OKE_API.G_EXCEPTION_ERROR;
2713: END IF;

Line 2712: RAISE OKE_API.G_EXCEPTION_ERROR;

2708: IF l_agreement_tbl.COUNT = 0 THEN
2709: OKE_API.set_message(
2710: p_app_name => G_APP_NAME, p_msg_name => 'OKE_FUND_NO_VALID_ALLOCATIONS'
2711: );
2712: RAISE OKE_API.G_EXCEPTION_ERROR;
2713: END IF;
2714:
2715: --
2716: -- Check if mixed mode exists

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

2727: );
2728:
2729: IF (l_return_status = 'E') THEN
2730:
2731: OKE_API.set_message(p_app_name => G_APP_NAME ,
2732: p_msg_name => 'OKE_FUNDING_LEVEL' ,
2733: p_token1 => 'PROJECT' ,
2734: p_token1_value => l_err_project_number
2735: );

Line 2737: RAISE OKE_API.G_EXCEPTION_ERROR;

2733: p_token1 => 'PROJECT' ,
2734: p_token1_value => l_err_project_number
2735: );
2736:
2737: RAISE OKE_API.G_EXCEPTION_ERROR;
2738:
2739: END IF;
2740:
2741: --

Line 2806: p_commit => OKE_API.G_FALSE ,

2802:
2803: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2804:
2805: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
2806: p_commit => OKE_API.G_FALSE ,
2807: p_init_msg_list => OKE_API.G_FALSE ,
2808: p_msg_count => p_msg_count ,
2809: p_msg_data => p_msg_data ,
2810: p_return_status => p_return_status ,

Line 2807: p_init_msg_list => OKE_API.G_FALSE ,

2803: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2804:
2805: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
2806: p_commit => OKE_API.G_FALSE ,
2807: p_init_msg_list => OKE_API.G_FALSE ,
2808: p_msg_count => p_msg_count ,
2809: p_msg_data => p_msg_data ,
2810: p_return_status => p_return_status ,
2811: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

2814: p_funding_in_tbl => l_funding_in_tbl ,
2815: p_funding_out_tbl => l_funding_out_tbl
2816: );
2817:
2818: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2819:
2820: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2821:
2822: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2820: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2816: );
2817:
2818: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2819:
2820: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2821:
2822: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2823:
2824: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2818: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2819:
2820: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2821:
2822: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2823:
2824: RAISE OKE_API.G_EXCEPTION_ERROR;
2825:
2826: END IF;

Line 2824: RAISE OKE_API.G_EXCEPTION_ERROR;

2820: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2821:
2822: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2823:
2824: RAISE OKE_API.G_EXCEPTION_ERROR;
2825:
2826: END IF;
2827:
2828: EXIT WHEN (i = l_agreement_tbl.LAST);

Line 2864: p_init_msg_list => OKE_API.G_FALSE ,

2860: --oke_debug.debug('calling add_pa_funding - project_level');
2861: --dbms_output.put_line('calling add_pa_funding - project level');
2862:
2863: add_pa_funding(p_api_version => p_api_version ,
2864: p_init_msg_list => OKE_API.G_FALSE ,
2865: p_commit => OKE_API.G_FALSE ,
2866: p_msg_count => p_msg_count ,
2867: p_msg_data => p_msg_data ,
2868: p_allocation_in_rec => l_allocation_in_rec ,

Line 2865: p_commit => OKE_API.G_FALSE ,

2861: --dbms_output.put_line('calling add_pa_funding - project level');
2862:
2863: add_pa_funding(p_api_version => p_api_version ,
2864: p_init_msg_list => OKE_API.G_FALSE ,
2865: p_commit => OKE_API.G_FALSE ,
2866: p_msg_count => p_msg_count ,
2867: p_msg_data => p_msg_data ,
2868: p_allocation_in_rec => l_allocation_in_rec ,
2869: p_return_status => p_return_status

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

2868: p_allocation_in_rec => l_allocation_in_rec ,
2869: p_return_status => p_return_status
2870: );
2871:
2872: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2873:
2874: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875:
2876: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2874: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2870: );
2871:
2872: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2873:
2874: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875:
2876: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2877:
2878: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2872: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2873:
2874: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875:
2876: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2877:
2878: RAISE OKE_API.G_EXCEPTION_ERROR;
2879:
2880: END IF;

Line 2878: RAISE OKE_API.G_EXCEPTION_ERROR;

2874: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875:
2876: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2877:
2878: RAISE OKE_API.G_EXCEPTION_ERROR;
2879:
2880: END IF;
2881:
2882: END LOOP;

Line 2901: p_init_msg_list => OKE_API.G_FALSE ,

2897: --oke_debug.debug('calling add_pa_funding - task level');
2898: --dbms_output.put_line('calling add_pa_funding - task level');
2899:
2900: add_pa_funding(p_api_version => p_api_version ,
2901: p_init_msg_list => OKE_API.G_FALSE ,
2902: p_commit => OKE_API.G_FALSE ,
2903: p_msg_count => p_msg_count ,
2904: p_msg_data => p_msg_data ,
2905: p_allocation_in_rec => l_allocation_in_rec ,

Line 2902: p_commit => OKE_API.G_FALSE ,

2898: --dbms_output.put_line('calling add_pa_funding - task level');
2899:
2900: add_pa_funding(p_api_version => p_api_version ,
2901: p_init_msg_list => OKE_API.G_FALSE ,
2902: p_commit => OKE_API.G_FALSE ,
2903: p_msg_count => p_msg_count ,
2904: p_msg_data => p_msg_data ,
2905: p_allocation_in_rec => l_allocation_in_rec ,
2906: p_return_status => p_return_status

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

2905: p_allocation_in_rec => l_allocation_in_rec ,
2906: p_return_status => p_return_status
2907: );
2908:
2909: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2910:
2911: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2912:
2913: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2911: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2907: );
2908:
2909: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2910:
2911: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2912:
2913: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2914:
2915: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2909: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2910:
2911: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2912:
2913: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2914:
2915: RAISE OKE_API.G_EXCEPTION_ERROR;
2916:
2917: END IF;

Line 2915: RAISE OKE_API.G_EXCEPTION_ERROR;

2911: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2912:
2913: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2914:
2915: RAISE OKE_API.G_EXCEPTION_ERROR;
2916:
2917: END IF;
2918:
2919: END LOOP;

Line 2982: p_commit => OKE_API.G_FALSE ,

2978:
2979: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2980:
2981: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2982: p_commit => OKE_API.G_FALSE ,
2983: p_init_msg_list => OKE_API.G_FALSE ,
2984: p_msg_count => p_msg_count ,
2985: p_msg_data => p_msg_data ,
2986: p_return_status => p_return_status ,

Line 2983: p_init_msg_list => OKE_API.G_FALSE ,

2979: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2980:
2981: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2982: p_commit => OKE_API.G_FALSE ,
2983: p_init_msg_list => OKE_API.G_FALSE ,
2984: p_msg_count => p_msg_count ,
2985: p_msg_data => p_msg_data ,
2986: p_return_status => p_return_status ,
2987: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

2990: p_funding_in_tbl => l_funding_in_tbl ,
2991: p_funding_out_tbl => l_funding_out_tbl
2992: );
2993:
2994: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2995:
2996: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997:
2998: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 2996: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

2992: );
2993:
2994: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2995:
2996: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997:
2998: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2999:
3000: RAISE OKE_API.G_EXCEPTION_ERROR;

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

2994: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
2995:
2996: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997:
2998: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2999:
3000: RAISE OKE_API.G_EXCEPTION_ERROR;
3001:
3002: END IF;

Line 3000: RAISE OKE_API.G_EXCEPTION_ERROR;

2996: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
2997:
2998: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
2999:
3000: RAISE OKE_API.G_EXCEPTION_ERROR;
3001:
3002: END IF;
3003:
3004: EXIT WHEN (i = l_agreement_tbl.LAST);

Line 3022: x_commit => OKE_API.G_FALSE

3018: --dbms_output.put_line('calling oke_funding_util.update_source_flag');
3019: --oke_debug.debug('calling oke_funding_util.update_source_flag');
3020:
3021: OKE_FUNDING_UTIL_PKG.update_source_flag(x_funding_source_id => p_funding_in_rec.funding_source_id ,
3022: x_commit => OKE_API.G_FALSE
3023: );
3024:
3025: IF FND_API.to_boolean(p_commit) THEN
3026:

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

3030:
3031: --dbms_output.put_line('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3032: --oke_debug.debug('finished oke_agreement_pvt.create_agreement w/ ' || p_return_status);
3033:
3034: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
3035: x_msg_data => p_msg_data
3036: );
3037:
3038: EXCEPTION

Line 3039: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

3035: x_msg_data => p_msg_data
3036: );
3037:
3038: EXCEPTION
3039: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
3040: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3041: p_pkg_name => G_PKG_NAME ,
3042: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
3043: x_msg_count => p_msg_count ,

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

3036: );
3037:
3038: EXCEPTION
3039: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
3040: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3041: p_pkg_name => G_PKG_NAME ,
3042: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
3043: x_msg_count => p_msg_count ,
3044: x_msg_data => p_msg_data ,

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

3038: EXCEPTION
3039: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
3040: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3041: p_pkg_name => G_PKG_NAME ,
3042: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
3043: x_msg_count => p_msg_count ,
3044: x_msg_data => p_msg_data ,
3045: p_api_type => '_PVT'
3046: );

Line 3048: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3044: x_msg_data => p_msg_data ,
3045: p_api_type => '_PVT'
3046: );
3047:
3048: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3049: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3050: p_pkg_name => G_PKG_NAME ,
3051: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
3052: x_msg_count => p_msg_count ,

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

3045: p_api_type => '_PVT'
3046: );
3047:
3048: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3049: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3050: p_pkg_name => G_PKG_NAME ,
3051: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
3052: x_msg_count => p_msg_count ,
3053: x_msg_data => p_msg_data ,

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

3047:
3048: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3049: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3050: p_pkg_name => G_PKG_NAME ,
3051: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
3052: x_msg_count => p_msg_count ,
3053: x_msg_data => p_msg_data ,
3054: p_api_type => '_PVT'
3055: );

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

3054: p_api_type => '_PVT'
3055: );
3056:
3057: WHEN OTHERS THEN
3058: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
3059: p_pkg_name => G_PKG_NAME ,
3060: p_exc_name => 'OTHERS' ,
3061: x_msg_count => p_msg_count ,
3062: x_msg_data => p_msg_data ,

Line 3074: -- Calling subprograms: OKE_API.start_activity

3070: -- Procedure update_agreement
3071: --
3072: -- Description: This procedure is used to update pa agreement
3073: --
3074: -- Calling subprograms: OKE_API.start_activity
3075: -- OKE_API.end_activity
3076: -- validate_agreement_attributes
3077: -- check_project_null
3078: -- prepare_upd_funding

Line 3075: -- OKE_API.end_activity

3071: --
3072: -- Description: This procedure is used to update pa agreement
3073: --
3074: -- Calling subprograms: OKE_API.start_activity
3075: -- OKE_API.end_activity
3076: -- validate_agreement_attributes
3077: -- check_project_null
3078: -- prepare_upd_funding
3079: --

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

3078: -- prepare_upd_funding
3079: --
3080:
3081: PROCEDURE update_agreement(p_api_version IN NUMBER ,
3082: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
3083: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
3084: p_msg_count OUT NOCOPY NUMBER ,
3085: p_msg_data OUT NOCOPY VARCHAR2 ,
3086: p_agreement_type IN VARCHAR2 ,

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

3079: --
3080:
3081: PROCEDURE update_agreement(p_api_version IN NUMBER ,
3082: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
3083: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
3084: p_msg_count OUT NOCOPY NUMBER ,
3085: p_msg_data OUT NOCOPY VARCHAR2 ,
3086: p_agreement_type IN VARCHAR2 ,
3087: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,

Line 3327: p_return_status := OKE_API.G_RET_STS_SUCCESS;

3323:
3324: --dbms_output.put_line('entering oke_agreement_pvt.update_agreement');
3325: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');
3326:
3327: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3328:
3329: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
3330: p_pkg_name => G_PKG_NAME ,
3331: p_init_msg_list => p_init_msg_list ,

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

3325: --oke_debug.debug('entering oke_agreement_pvt.update_agreement');
3326:
3327: p_return_status := OKE_API.G_RET_STS_SUCCESS;
3328:
3329: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
3330: p_pkg_name => G_PKG_NAME ,
3331: p_init_msg_list => p_init_msg_list ,
3332: l_api_version => G_API_VERSION_NUMBER ,
3333: p_api_version => p_api_version ,

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

3334: p_api_type => '_PVT' ,
3335: x_return_status => p_return_status
3336: );
3337:
3338: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3339:
3340: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3341:
3342: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3340: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3336: );
3337:
3338: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3339:
3340: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3341:
3342: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3343:
3344: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3338: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3339:
3340: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3341:
3342: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3343:
3344: RAISE OKE_API.G_EXCEPTION_ERROR;
3345:
3346: END IF;

Line 3344: RAISE OKE_API.G_EXCEPTION_ERROR;

3340: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3341:
3342: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
3343:
3344: RAISE OKE_API.G_EXCEPTION_ERROR;
3345:
3346: END IF;
3347:
3348: --

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

3410: );
3411:
3412: IF (l_return_status = 'E') THEN
3413:
3414: OKE_API.set_message(p_app_name => G_APP_NAME ,
3415: p_msg_name => 'OKE_FUNDING_LEVEL' ,
3416: p_token1 => 'PROJECT' ,
3417: p_token1_value => l_err_project_number
3418: );

Line 3420: RAISE OKE_API.G_EXCEPTION_ERROR;

3416: p_token1 => 'PROJECT' ,
3417: p_token1_value => l_err_project_number
3418: );
3419:
3420: RAISE OKE_API.G_EXCEPTION_ERROR;
3421:
3422: END IF;
3423:
3424: --

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

3440: --
3441: FOR l_agreement in c_agreement LOOP
3442:
3443: IF (nvl(l_org_id_vc, -99) <> nvl(l_agreement.org_id, -99)) OR
3444: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3445: l_agreement_in_rec.owning_organization_id := null;
3446: ELSE
3447: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3448: END IF;

Line 3463: p_commit => OKE_API.G_FALSE ,

3459:
3460: END IF;
3461:
3462: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3463: p_commit => OKE_API.G_FALSE ,
3464: p_init_msg_list => OKE_API.G_FALSE ,
3465: p_msg_count => p_msg_count ,
3466: p_msg_data => p_msg_data ,
3467: p_return_status => p_return_status ,

Line 3464: p_init_msg_list => OKE_API.G_FALSE ,

3460: END IF;
3461:
3462: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3463: p_commit => OKE_API.G_FALSE ,
3464: p_init_msg_list => OKE_API.G_FALSE ,
3465: p_msg_count => p_msg_count ,
3466: p_msg_data => p_msg_data ,
3467: p_return_status => p_return_status ,
3468: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

3471: p_funding_in_tbl => l_funding_in_tbl ,
3472: p_funding_out_tbl => l_funding_out_tbl
3473: );
3474:
3475: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3476:
3477: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3478:
3479: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3477: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3473: );
3474:
3475: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3476:
3477: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3478:
3479: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3480:
3481: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3475: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3476:
3477: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3478:
3479: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3480:
3481: RAISE OKE_API.G_EXCEPTION_ERROR;
3482:
3483: END IF;

Line 3481: RAISE OKE_API.G_EXCEPTION_ERROR;

3477: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3478:
3479: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3480:
3481: RAISE OKE_API.G_EXCEPTION_ERROR;
3482:
3483: END IF;
3484:
3485: END LOOP;

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

3500: IF c_non_mcb%NOTFOUND THEN
3501: null;
3502: ELSE
3503:
3504: OKE_API.set_message(p_app_name => G_APP_NAME ,
3505: p_msg_name => 'OKE_NONMCB_PROJECT' ,
3506: p_token1 => 'PROJECT' ,
3507: p_token1_value => l_project_number
3508: );

Line 3510: RAISE OKE_API.G_EXCEPTION_ERROR;

3506: p_token1 => 'PROJECT' ,
3507: p_token1_value => l_project_number
3508: );
3509:
3510: RAISE OKE_API.G_EXCEPTION_ERROR;
3511:
3512: END IF;
3513: CLOSE c_non_mcb;
3514:

Line 3544: p_init_msg_list => OKE_API.G_FALSE ,

3540:
3541: IF (l_allocation.agreement_id <> -99) THEN
3542:
3543: update_pa_funding(p_api_version => p_api_version ,
3544: p_init_msg_list => OKE_API.G_FALSE ,
3545: p_commit => OKE_API.G_FALSE ,
3546: p_msg_count => p_msg_count ,
3547: p_msg_data => p_msg_data ,
3548: p_allocation_in_rec => l_allocation_in_rec ,

Line 3545: p_commit => OKE_API.G_FALSE ,

3541: IF (l_allocation.agreement_id <> -99) THEN
3542:
3543: update_pa_funding(p_api_version => p_api_version ,
3544: p_init_msg_list => OKE_API.G_FALSE ,
3545: p_commit => OKE_API.G_FALSE ,
3546: p_msg_count => p_msg_count ,
3547: p_msg_data => p_msg_data ,
3548: p_allocation_in_rec => l_allocation_in_rec ,
3549: p_return_status => p_return_status

Line 3561: p_init_msg_list => OKE_API.G_FALSE ,

3557:
3558: l_allocation_in_rec.agreement_id := l_agreement_id;
3559:
3560: add_pa_funding(p_api_version => p_api_version ,
3561: p_init_msg_list => OKE_API.G_FALSE ,
3562: p_commit => OKE_API.G_FALSE ,
3563: p_msg_count => p_msg_count ,
3564: p_msg_data => p_msg_data ,
3565: p_allocation_in_rec => l_allocation_in_rec ,

Line 3562: p_commit => OKE_API.G_FALSE ,

3558: l_allocation_in_rec.agreement_id := l_agreement_id;
3559:
3560: add_pa_funding(p_api_version => p_api_version ,
3561: p_init_msg_list => OKE_API.G_FALSE ,
3562: p_commit => OKE_API.G_FALSE ,
3563: p_msg_count => p_msg_count ,
3564: p_msg_data => p_msg_data ,
3565: p_allocation_in_rec => l_allocation_in_rec ,
3566: p_return_status => p_return_status

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

3565: p_allocation_in_rec => l_allocation_in_rec ,
3566: p_return_status => p_return_status
3567: );
3568:
3569: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3570:
3571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3572:
3573: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3567: );
3568:
3569: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3570:
3571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3572:
3573: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3574:
3575: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3569: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3570:
3571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3572:
3573: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3574:
3575: RAISE OKE_API.G_EXCEPTION_ERROR;
3576:
3577: END IF;

Line 3575: RAISE OKE_API.G_EXCEPTION_ERROR;

3571: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3572:
3573: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3574:
3575: RAISE OKE_API.G_EXCEPTION_ERROR;
3576:
3577: END IF;
3578:
3579: ELSIF (nvl(l_allocation.multi_currency_billing_flag, 'N') = 'Y') THEN

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

3595:
3596: l_agreement_in_rec.amount := 99999999999999999.99999;
3597:
3598: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3599: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3600: l_agreement_in_rec.owning_organization_id := null;
3601: ELSE
3602: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3603: END IF;

Line 3627: p_commit => OKE_API.G_FALSE ,

3623:
3624: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3625:
3626: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3627: p_commit => OKE_API.G_FALSE ,
3628: p_init_msg_list => OKE_API.G_FALSE ,
3629: p_msg_count => p_msg_count ,
3630: p_msg_data => p_msg_data ,
3631: p_return_status => p_return_status ,

Line 3628: p_init_msg_list => OKE_API.G_FALSE ,

3624: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3625:
3626: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3627: p_commit => OKE_API.G_FALSE ,
3628: p_init_msg_list => OKE_API.G_FALSE ,
3629: p_msg_count => p_msg_count ,
3630: p_msg_data => p_msg_data ,
3631: p_return_status => p_return_status ,
3632: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

3635: p_funding_in_tbl => l_funding_in_tbl ,
3636: p_funding_out_tbl => l_funding_out_tbl
3637: );
3638:
3639: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3640:
3641: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3642:
3643: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3641: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3637: );
3638:
3639: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3640:
3641: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3642:
3643: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3644:
3645: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3639: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3640:
3641: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3642:
3643: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3644:
3645: RAISE OKE_API.G_EXCEPTION_ERROR;
3646:
3647: END IF;

Line 3645: RAISE OKE_API.G_EXCEPTION_ERROR;

3641: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3642:
3643: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3644:
3645: RAISE OKE_API.G_EXCEPTION_ERROR;
3646:
3647: END IF;
3648:
3649: l_agreement_id := l_agreement_out_rec.agreement_id;

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

3658:
3659: l_agreement_in_rec.amount := 99999999999999999.99999;
3660:
3661: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3662: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3663: l_agreement_in_rec.owning_organization_id := null;
3664: ELSE
3665: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3666: END IF;

Line 3690: p_commit => OKE_API.G_FALSE ,

3686:
3687: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3688:
3689: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3690: p_commit => OKE_API.G_FALSE ,
3691: p_init_msg_list => OKE_API.G_FALSE ,
3692: p_msg_count => p_msg_count ,
3693: p_msg_data => p_msg_data ,
3694: p_return_status => p_return_status ,

Line 3691: p_init_msg_list => OKE_API.G_FALSE ,

3687: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3688:
3689: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3690: p_commit => OKE_API.G_FALSE ,
3691: p_init_msg_list => OKE_API.G_FALSE ,
3692: p_msg_count => p_msg_count ,
3693: p_msg_data => p_msg_data ,
3694: p_return_status => p_return_status ,
3695: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

3698: p_funding_in_tbl => l_funding_in_tbl ,
3699: p_funding_out_tbl => l_funding_out_tbl
3700: );
3701:
3702: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3703:
3704: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3705:
3706: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3704: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3700: );
3701:
3702: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3703:
3704: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3705:
3706: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3707:
3708: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3702: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3703:
3704: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3705:
3706: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3707:
3708: RAISE OKE_API.G_EXCEPTION_ERROR;
3709:
3710: END IF;

Line 3708: RAISE OKE_API.G_EXCEPTION_ERROR;

3704: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3705:
3706: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3707:
3708: RAISE OKE_API.G_EXCEPTION_ERROR;
3709:
3710: END IF;
3711:
3712: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 3723: p_init_msg_list => OKE_API.G_FALSE ,

3719:
3720: l_allocation_in_rec.agreement_id := l_agreement_id;
3721:
3722: add_pa_funding(p_api_version => p_api_version ,
3723: p_init_msg_list => OKE_API.G_FALSE ,
3724: p_commit => OKE_API.G_FALSE ,
3725: p_msg_count => p_msg_count ,
3726: p_msg_data => p_msg_data ,
3727: p_allocation_in_rec => l_allocation_in_rec ,

Line 3724: p_commit => OKE_API.G_FALSE ,

3720: l_allocation_in_rec.agreement_id := l_agreement_id;
3721:
3722: add_pa_funding(p_api_version => p_api_version ,
3723: p_init_msg_list => OKE_API.G_FALSE ,
3724: p_commit => OKE_API.G_FALSE ,
3725: p_msg_count => p_msg_count ,
3726: p_msg_data => p_msg_data ,
3727: p_allocation_in_rec => l_allocation_in_rec ,
3728: p_return_status => p_return_status

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

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

Line 3733: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

3731: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3732:
3733: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3734:
3735: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3736:
3737: RAISE OKE_API.G_EXCEPTION_ERROR;
3738:
3739: END IF;

Line 3737: RAISE OKE_API.G_EXCEPTION_ERROR;

3733: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3734:
3735: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3736:
3737: RAISE OKE_API.G_EXCEPTION_ERROR;
3738:
3739: END IF;
3740:
3741: ELSE

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

3747:
3748: l_agreement_in_rec.amount := 99999999999999999.99999;
3749:
3750: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3751: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3752: l_agreement_in_rec.owning_organization_id := null;
3753: ELSE
3754: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3755: END IF;

Line 3779: p_commit => OKE_API.G_FALSE ,

3775:
3776: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3777:
3778: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3779: p_commit => OKE_API.G_FALSE ,
3780: p_init_msg_list => OKE_API.G_FALSE ,
3781: p_msg_count => p_msg_count ,
3782: p_msg_data => p_msg_data ,
3783: p_return_status => p_return_status ,

Line 3780: p_init_msg_list => OKE_API.G_FALSE ,

3776: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3777:
3778: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3779: p_commit => OKE_API.G_FALSE ,
3780: p_init_msg_list => OKE_API.G_FALSE ,
3781: p_msg_count => p_msg_count ,
3782: p_msg_data => p_msg_data ,
3783: p_return_status => p_return_status ,
3784: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

3787: p_funding_in_tbl => l_funding_in_tbl ,
3788: p_funding_out_tbl => l_funding_out_tbl
3789: );
3790:
3791: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3792:
3793: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3794:
3795: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3793: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3789: );
3790:
3791: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3792:
3793: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3794:
3795: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3796:
3797: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3791: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3792:
3793: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3794:
3795: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3796:
3797: RAISE OKE_API.G_EXCEPTION_ERROR;
3798:
3799: END IF;

Line 3797: RAISE OKE_API.G_EXCEPTION_ERROR;

3793: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3794:
3795: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3796:
3797: RAISE OKE_API.G_EXCEPTION_ERROR;
3798:
3799: END IF;
3800:
3801: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 3809: p_init_msg_list => OKE_API.G_FALSE ,

3805:
3806: l_allocation_in_rec.agreement_id := l_agreement_id;
3807:
3808: add_pa_funding(p_api_version => p_api_version ,
3809: p_init_msg_list => OKE_API.G_FALSE ,
3810: p_commit => OKE_API.G_FALSE ,
3811: p_msg_count => p_msg_count ,
3812: p_msg_data => p_msg_data ,
3813: p_allocation_in_rec => l_allocation_in_rec ,

Line 3810: p_commit => OKE_API.G_FALSE ,

3806: l_allocation_in_rec.agreement_id := l_agreement_id;
3807:
3808: add_pa_funding(p_api_version => p_api_version ,
3809: p_init_msg_list => OKE_API.G_FALSE ,
3810: p_commit => OKE_API.G_FALSE ,
3811: p_msg_count => p_msg_count ,
3812: p_msg_data => p_msg_data ,
3813: p_allocation_in_rec => l_allocation_in_rec ,
3814: p_return_status => p_return_status

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

3813: p_allocation_in_rec => l_allocation_in_rec ,
3814: p_return_status => p_return_status
3815: );
3816:
3817: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3818:
3819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3820:
3821: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3819: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 3823: RAISE OKE_API.G_EXCEPTION_ERROR;

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

Line 3847: p_init_msg_list => OKE_API.G_FALSE ,

3843:
3844: IF (l_allocation.agreement_id <> -99) THEN
3845:
3846: update_pa_funding(p_api_version => p_api_version ,
3847: p_init_msg_list => OKE_API.G_FALSE ,
3848: p_commit => OKE_API.G_FALSE ,
3849: p_msg_count => p_msg_count ,
3850: p_msg_data => p_msg_data ,
3851: p_allocation_in_rec => l_allocation_in_rec ,

Line 3848: p_commit => OKE_API.G_FALSE ,

3844: IF (l_allocation.agreement_id <> -99) THEN
3845:
3846: update_pa_funding(p_api_version => p_api_version ,
3847: p_init_msg_list => OKE_API.G_FALSE ,
3848: p_commit => OKE_API.G_FALSE ,
3849: p_msg_count => p_msg_count ,
3850: p_msg_data => p_msg_data ,
3851: p_allocation_in_rec => l_allocation_in_rec ,
3852: p_return_status => p_return_status

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

3851: p_allocation_in_rec => l_allocation_in_rec ,
3852: p_return_status => p_return_status
3853: );
3854:
3855: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3856:
3857: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3858:
3859: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3857: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3853: );
3854:
3855: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3856:
3857: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3858:
3859: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3860:
3861: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3855: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3856:
3857: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3858:
3859: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3860:
3861: RAISE OKE_API.G_EXCEPTION_ERROR;
3862:
3863: END IF;

Line 3861: RAISE OKE_API.G_EXCEPTION_ERROR;

3857: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3858:
3859: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3860:
3861: RAISE OKE_API.G_EXCEPTION_ERROR;
3862:
3863: END IF;
3864:
3865: ELSIF (l_across_flag = 'Y') THEN

Line 3874: p_init_msg_list => OKE_API.G_FALSE ,

3870:
3871: l_allocation_in_rec.agreement_id := l_agreement_id;
3872:
3873: add_pa_funding(p_api_version => p_api_version ,
3874: p_init_msg_list => OKE_API.G_FALSE ,
3875: p_commit => OKE_API.G_FALSE ,
3876: p_msg_count => p_msg_count ,
3877: p_msg_data => p_msg_data ,
3878: p_allocation_in_rec => l_allocation_in_rec ,

Line 3875: p_commit => OKE_API.G_FALSE ,

3871: l_allocation_in_rec.agreement_id := l_agreement_id;
3872:
3873: add_pa_funding(p_api_version => p_api_version ,
3874: p_init_msg_list => OKE_API.G_FALSE ,
3875: p_commit => OKE_API.G_FALSE ,
3876: p_msg_count => p_msg_count ,
3877: p_msg_data => p_msg_data ,
3878: p_allocation_in_rec => l_allocation_in_rec ,
3879: p_return_status => p_return_status

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

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

Line 3884: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 3888: RAISE OKE_API.G_EXCEPTION_ERROR;

3884: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3885:
3886: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3887:
3888: RAISE OKE_API.G_EXCEPTION_ERROR;
3889:
3890: END IF;
3891:
3892: ELSIF (nvl(l_allocation.multi_currency_billing_flag, 'N') = 'Y') THEN

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

3907:
3908: l_agreement_in_rec.amount := 99999999999999999.99999;
3909:
3910: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3911: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3912: l_agreement_in_rec.owning_organization_id := null;
3913: ELSE
3914: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3915: END IF;

Line 3939: p_commit => OKE_API.G_FALSE ,

3935:
3936: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3937:
3938: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3939: p_commit => OKE_API.G_FALSE ,
3940: p_init_msg_list => OKE_API.G_FALSE ,
3941: p_msg_count => p_msg_count ,
3942: p_msg_data => p_msg_data ,
3943: p_return_status => p_return_status ,

Line 3940: p_init_msg_list => OKE_API.G_FALSE ,

3936: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3937:
3938: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3939: p_commit => OKE_API.G_FALSE ,
3940: p_init_msg_list => OKE_API.G_FALSE ,
3941: p_msg_count => p_msg_count ,
3942: p_msg_data => p_msg_data ,
3943: p_return_status => p_return_status ,
3944: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

3947: p_funding_in_tbl => l_funding_in_tbl ,
3948: p_funding_out_tbl => l_funding_out_tbl
3949: );
3950:
3951: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3952:
3953: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3954:
3955: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 3953: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

3949: );
3950:
3951: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3952:
3953: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3954:
3955: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3956:
3957: RAISE OKE_API.G_EXCEPTION_ERROR;

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

3951: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
3952:
3953: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3954:
3955: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3956:
3957: RAISE OKE_API.G_EXCEPTION_ERROR;
3958:
3959: END IF;

Line 3957: RAISE OKE_API.G_EXCEPTION_ERROR;

3953: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
3954:
3955: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
3956:
3957: RAISE OKE_API.G_EXCEPTION_ERROR;
3958:
3959: END IF;
3960:
3961: l_agreement_id := l_agreement_out_rec.agreement_id;

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

3970:
3971: l_agreement_in_rec.amount := 99999999999999999.99999;
3972:
3973: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
3974: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
3975: l_agreement_in_rec.owning_organization_id := null;
3976: ELSE
3977: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
3978: END IF;

Line 4002: p_commit => OKE_API.G_FALSE ,

3998:
3999: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4000:
4001: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4002: p_commit => OKE_API.G_FALSE ,
4003: p_init_msg_list => OKE_API.G_FALSE ,
4004: p_msg_count => p_msg_count ,
4005: p_msg_data => p_msg_data ,
4006: p_return_status => p_return_status ,

Line 4003: p_init_msg_list => OKE_API.G_FALSE ,

3999: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4000:
4001: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4002: p_commit => OKE_API.G_FALSE ,
4003: p_init_msg_list => OKE_API.G_FALSE ,
4004: p_msg_count => p_msg_count ,
4005: p_msg_data => p_msg_data ,
4006: p_return_status => p_return_status ,
4007: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

4010: p_funding_in_tbl => l_funding_in_tbl ,
4011: p_funding_out_tbl => l_funding_out_tbl
4012: );
4013:
4014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4015:
4016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017:
4018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4012: );
4013:
4014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4015:
4016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017:
4018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4019:
4020: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4014: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4015:
4016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017:
4018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4019:
4020: RAISE OKE_API.G_EXCEPTION_ERROR;
4021:
4022: END IF;

Line 4020: RAISE OKE_API.G_EXCEPTION_ERROR;

4016: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017:
4018: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4019:
4020: RAISE OKE_API.G_EXCEPTION_ERROR;
4021:
4022: END IF;
4023:
4024: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 4035: p_init_msg_list => OKE_API.G_FALSE ,

4031:
4032: l_allocation_in_rec.agreement_id := l_agreement_id;
4033:
4034: add_pa_funding(p_api_version => p_api_version ,
4035: p_init_msg_list => OKE_API.G_FALSE ,
4036: p_commit => OKE_API.G_FALSE ,
4037: p_msg_count => p_msg_count ,
4038: p_msg_data => p_msg_data ,
4039: p_allocation_in_rec => l_allocation_in_rec ,

Line 4036: p_commit => OKE_API.G_FALSE ,

4032: l_allocation_in_rec.agreement_id := l_agreement_id;
4033:
4034: add_pa_funding(p_api_version => p_api_version ,
4035: p_init_msg_list => OKE_API.G_FALSE ,
4036: p_commit => OKE_API.G_FALSE ,
4037: p_msg_count => p_msg_count ,
4038: p_msg_data => p_msg_data ,
4039: p_allocation_in_rec => l_allocation_in_rec ,
4040: p_return_status => p_return_status

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

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

Line 4045: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

4043: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4044:
4045: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4046:
4047: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4048:
4049: RAISE OKE_API.G_EXCEPTION_ERROR;
4050:
4051: END IF;

Line 4049: RAISE OKE_API.G_EXCEPTION_ERROR;

4045: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4046:
4047: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4048:
4049: RAISE OKE_API.G_EXCEPTION_ERROR;
4050:
4051: END IF;
4052:
4053: ELSE

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

4059:
4060: l_agreement_in_rec.amount := 99999999999999999.99999;
4061:
4062: IF (nvl(l_org_id_vc, -99) <> nvl(l_allocation.org_id, -99)) OR
4063: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
4064: l_agreement_in_rec.owning_organization_id := null;
4065: ELSE
4066: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
4067: END IF;

Line 4091: p_commit => OKE_API.G_FALSE ,

4087:
4088: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4089:
4090: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4091: p_commit => OKE_API.G_FALSE ,
4092: p_init_msg_list => OKE_API.G_FALSE ,
4093: p_msg_count => p_msg_count ,
4094: p_msg_data => p_msg_data ,
4095: p_return_status => p_return_status ,

Line 4092: p_init_msg_list => OKE_API.G_FALSE ,

4088: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4089:
4090: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4091: p_commit => OKE_API.G_FALSE ,
4092: p_init_msg_list => OKE_API.G_FALSE ,
4093: p_msg_count => p_msg_count ,
4094: p_msg_data => p_msg_data ,
4095: p_return_status => p_return_status ,
4096: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

4099: p_funding_in_tbl => l_funding_in_tbl ,
4100: p_funding_out_tbl => l_funding_out_tbl
4101: );
4102:
4103: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4104:
4105: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4106:
4107: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4105: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4101: );
4102:
4103: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4104:
4105: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4106:
4107: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4108:
4109: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4103: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4104:
4105: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4106:
4107: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4108:
4109: RAISE OKE_API.G_EXCEPTION_ERROR;
4110:
4111: END IF;

Line 4109: RAISE OKE_API.G_EXCEPTION_ERROR;

4105: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4106:
4107: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4108:
4109: RAISE OKE_API.G_EXCEPTION_ERROR;
4110:
4111: END IF;
4112:
4113: l_agreement_id := l_agreement_out_rec.agreement_id;

Line 4121: p_init_msg_list => OKE_API.G_FALSE ,

4117:
4118: l_allocation_in_rec.agreement_id := l_agreement_id;
4119:
4120: add_pa_funding(p_api_version => p_api_version ,
4121: p_init_msg_list => OKE_API.G_FALSE ,
4122: p_commit => OKE_API.G_FALSE ,
4123: p_msg_count => p_msg_count ,
4124: p_msg_data => p_msg_data ,
4125: p_allocation_in_rec => l_allocation_in_rec ,

Line 4122: p_commit => OKE_API.G_FALSE ,

4118: l_allocation_in_rec.agreement_id := l_agreement_id;
4119:
4120: add_pa_funding(p_api_version => p_api_version ,
4121: p_init_msg_list => OKE_API.G_FALSE ,
4122: p_commit => OKE_API.G_FALSE ,
4123: p_msg_count => p_msg_count ,
4124: p_msg_data => p_msg_data ,
4125: p_allocation_in_rec => l_allocation_in_rec ,
4126: p_return_status => p_return_status

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

4125: p_allocation_in_rec => l_allocation_in_rec ,
4126: p_return_status => p_return_status
4127: );
4128:
4129: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4130:
4131: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4132:
4133: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4131: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 4135: RAISE OKE_API.G_EXCEPTION_ERROR;

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

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

4156:
4157: FOR l_agreement in c_agreement3 LOOP
4158:
4159: IF (nvl(l_org_id_vc, -99) <> nvl(l_agreement.org_id, -99)) OR
4160: (p_funding_in_rec.agreement_org_id = OKE_API.G_MISS_NUM) THEN
4161: l_agreement_in_rec.owning_organization_id := null;
4162: ELSE
4163: l_agreement_in_rec.owning_organization_id := p_funding_in_rec.agreement_org_id;
4164: END IF;

Line 4199: p_commit => OKE_API.G_FALSE ,

4195:
4196: END IF;
4197:
4198: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
4199: p_commit => OKE_API.G_FALSE ,
4200: p_init_msg_list => OKE_API.G_FALSE ,
4201: p_msg_count => p_msg_count ,
4202: p_msg_data => p_msg_data ,
4203: p_return_status => p_return_status ,

Line 4200: p_init_msg_list => OKE_API.G_FALSE ,

4196: END IF;
4197:
4198: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
4199: p_commit => OKE_API.G_FALSE ,
4200: p_init_msg_list => OKE_API.G_FALSE ,
4201: p_msg_count => p_msg_count ,
4202: p_msg_data => p_msg_data ,
4203: p_return_status => p_return_status ,
4204: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

4207: p_funding_in_tbl => l_funding_in_tbl ,
4208: p_funding_out_tbl => l_funding_out_tbl
4209: );
4210:
4211: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4212:
4213: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4214:
4215: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4213: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4209: );
4210:
4211: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4212:
4213: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4214:
4215: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4216:
4217: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4211: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4212:
4213: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4214:
4215: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4216:
4217: RAISE OKE_API.G_EXCEPTION_ERROR;
4218:
4219: END IF;

Line 4217: RAISE OKE_API.G_EXCEPTION_ERROR;

4213: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4214:
4215: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4216:
4217: RAISE OKE_API.G_EXCEPTION_ERROR;
4218:
4219: END IF;
4220:
4221: END LOOP;

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

4231:
4232: --dbms_output.put_line('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4233: --oke_debug.debug('finished oke_agreement_pvt.update_agreement w/ ' || p_return_status);
4234:
4235: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4236: x_msg_data => p_msg_data
4237: );
4238:
4239: EXCEPTION

Line 4240: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

4236: x_msg_data => p_msg_data
4237: );
4238:
4239: EXCEPTION
4240: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4241: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4242: p_pkg_name => G_PKG_NAME ,
4243: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4244: x_msg_count => p_msg_count ,

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

4237: );
4238:
4239: EXCEPTION
4240: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4241: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4242: p_pkg_name => G_PKG_NAME ,
4243: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4244: x_msg_count => p_msg_count ,
4245: x_msg_data => p_msg_data ,

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

4239: EXCEPTION
4240: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4241: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4242: p_pkg_name => G_PKG_NAME ,
4243: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4244: x_msg_count => p_msg_count ,
4245: x_msg_data => p_msg_data ,
4246: p_api_type => '_PVT'
4247: );

Line 4249: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4245: x_msg_data => p_msg_data ,
4246: p_api_type => '_PVT'
4247: );
4248:
4249: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4250: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4251: p_pkg_name => G_PKG_NAME ,
4252: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4253: x_msg_count => p_msg_count ,

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

4246: p_api_type => '_PVT'
4247: );
4248:
4249: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4250: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4251: p_pkg_name => G_PKG_NAME ,
4252: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4253: x_msg_count => p_msg_count ,
4254: x_msg_data => p_msg_data ,

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

4248:
4249: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4250: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4251: p_pkg_name => G_PKG_NAME ,
4252: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4253: x_msg_count => p_msg_count ,
4254: x_msg_data => p_msg_data ,
4255: p_api_type => '_PVT'
4256: );

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

4255: p_api_type => '_PVT'
4256: );
4257:
4258: WHEN OTHERS THEN
4259: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4260: p_pkg_name => G_PKG_NAME ,
4261: p_exc_name => 'OTHERS' ,
4262: x_msg_count => p_msg_count ,
4263: x_msg_data => p_msg_data ,

Line 4275: -- Calling subprograms: OKE_API.start_activity

4271: -- Procedure: update_pa_funding
4272: --
4273: -- Description: This procedure is used to update record in pa project funding table
4274: --
4275: -- Calling subprograms: OKE_API.start_activity
4276: -- OKE_API.end_activity
4277: -- PA_AGREEMENT_PUB.update_funding
4278: -- PA_AGREEMENT_PUB.add_funding
4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount

Line 4276: -- OKE_API.end_activity

4272: --
4273: -- Description: This procedure is used to update record in pa project funding table
4274: --
4275: -- Calling subprograms: OKE_API.start_activity
4276: -- OKE_API.end_activity
4277: -- PA_AGREEMENT_PUB.update_funding
4278: -- PA_AGREEMENT_PUB.add_funding
4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4280: -- OKE_FUNDING_UTIL_PKG.update_alloc_version

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

4283: -- get_proj_funding
4284: --
4285:
4286: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
4287: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4288: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4289: p_msg_count OUT NOCOPY NUMBER ,
4290: p_msg_data OUT NOCOPY VARCHAR2 ,
4291: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

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

4284: --
4285:
4286: PROCEDURE update_pa_funding(p_api_version IN NUMBER ,
4287: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4288: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4289: p_msg_count OUT NOCOPY NUMBER ,
4290: p_msg_data OUT NOCOPY VARCHAR2 ,
4291: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4292: p_return_status OUT NOCOPY VARCHAR2

Line 4372: p_return_status := OKE_API.G_RET_STS_SUCCESS;

4368:
4369: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');
4370: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');
4371:
4372: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4373:
4374: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4375: p_pkg_name => G_PKG_NAME ,
4376: p_init_msg_list => p_init_msg_list ,

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

4370: --oke_debug.debug('entering oke_agreement_pvt.update_pa_funding');
4371:
4372: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4373:
4374: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4375: p_pkg_name => G_PKG_NAME ,
4376: p_init_msg_list => p_init_msg_list ,
4377: l_api_version => G_API_VERSION_NUMBER ,
4378: p_api_version => p_api_version ,

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

4379: p_api_type => '_PVT' ,
4380: x_return_status => p_return_status
4381: );
4382:
4383: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4384:
4385: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386:
4387: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4385: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4381: );
4382:
4383: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4384:
4385: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386:
4387: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4388:
4389: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4383: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4384:
4385: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386:
4387: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4388:
4389: RAISE OKE_API.G_EXCEPTION_ERROR;
4390:
4391: END IF;

Line 4389: RAISE OKE_API.G_EXCEPTION_ERROR;

4385: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386:
4387: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4388:
4389: RAISE OKE_API.G_EXCEPTION_ERROR;
4390:
4391: END IF;
4392:
4393: --

Line 4444: RAISE OKE_API.G_EXCEPTION_ERROR;

4440: );
4441:
4442: IF (l_return_status = 'E') THEN
4443:
4444: RAISE OKE_API.G_EXCEPTION_ERROR;
4445:
4446: ELSIF (l_return_status = 'U') THEN
4447:
4448: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4448: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4444: RAISE OKE_API.G_EXCEPTION_ERROR;
4445:
4446: ELSIF (l_return_status = 'U') THEN
4447:
4448: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4449:
4450: END IF;
4451:
4452: ELSE

Line 4525: p_commit => OKE_API.G_FALSE ,

4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,
4526: p_init_msg_list => OKE_API.G_FALSE ,
4527: p_msg_count => p_msg_count ,
4528: p_msg_data => p_msg_data ,
4529: p_return_status => p_return_status ,

Line 4526: p_init_msg_list => OKE_API.G_FALSE ,

4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,
4526: p_init_msg_list => OKE_API.G_FALSE ,
4527: p_msg_count => p_msg_count ,
4528: p_msg_data => p_msg_data ,
4529: p_return_status => p_return_status ,
4530: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

Line 4569: x_commit => OKE_API.G_FALSE

4565: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4566:
4567: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4568: x_version_add => 1 ,
4569: x_commit => OKE_API.G_FALSE
4570: );
4571: END IF;
4572:
4573: ELSE

Line 4589: p_commit => OKE_API.G_FALSE ,

4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,
4590: p_init_msg_list => OKE_API.G_FALSE ,
4591: p_msg_count => p_msg_count ,
4592: p_msg_data => p_msg_data ,
4593: p_return_status => p_return_status ,

Line 4590: p_init_msg_list => OKE_API.G_FALSE ,

4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,
4590: p_init_msg_list => OKE_API.G_FALSE ,
4591: p_msg_count => p_msg_count ,
4592: p_msg_data => p_msg_data ,
4593: p_return_status => p_return_status ,
4594: p_pm_product_code => G_PRODUCT_CODE ,

Line 4633: x_commit => OKE_API.G_FALSE

4629: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4630:
4631: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4632: x_version_add => 0 ,
4633: x_commit => OKE_API.G_FALSE
4634: );
4635:
4636: END IF;
4637:

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

4637:
4638: -- fnd_client_info.set_org_context(to_number(l_org_id_vc));
4639: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4640:
4641: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4642:
4643: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4644:
4645: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4643: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4639: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4640:
4641: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4642:
4643: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4644:
4645: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4646:
4647: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4641: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4642:
4643: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4644:
4645: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4646:
4647: RAISE OKE_API.G_EXCEPTION_ERROR;
4648:
4649: END IF;

Line 4647: RAISE OKE_API.G_EXCEPTION_ERROR;

4643: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4644:
4645: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4646:
4647: RAISE OKE_API.G_EXCEPTION_ERROR;
4648:
4649: END IF;
4650:
4651: -- syho, bug 2328311

Line 4656: p_commit => OKE_API.G_FALSE ,

4652: -- update the ff of the existing project funding lines
4653: --FOR l_project_funding IN c_project_funding (length(p_allocation_in_rec.fund_allocation_id)) LOOP
4654: /*
4655: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4656: p_commit => OKE_API.G_FALSE ,
4657: p_init_msg_list => OKE_API.G_FALSE ,
4658: p_msg_count => p_msg_count ,
4659: p_msg_data => p_msg_data ,
4660: p_return_status => p_return_status ,

Line 4657: p_init_msg_list => OKE_API.G_FALSE ,

4653: --FOR l_project_funding IN c_project_funding (length(p_allocation_in_rec.fund_allocation_id)) LOOP
4654: /*
4655: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4656: p_commit => OKE_API.G_FALSE ,
4657: p_init_msg_list => OKE_API.G_FALSE ,
4658: p_msg_count => p_msg_count ,
4659: p_msg_data => p_msg_data ,
4660: p_return_status => p_return_status ,
4661: p_pm_product_code => G_PRODUCT_CODE ,

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

4680: p_attribute10 => l_allocation_in_rec.pa_attribute10 ,
4681: p_funding_id_out => l_funding_id
4682: );
4683:
4684: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4685:
4686: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4687:
4688: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4686: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4682: );
4683:
4684: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4685:
4686: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4687:
4688: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4689:
4690: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4684: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4685:
4686: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4687:
4688: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4689:
4690: RAISE OKE_API.G_EXCEPTION_ERROR;
4691:
4692: END IF;

Line 4690: RAISE OKE_API.G_EXCEPTION_ERROR;

4686: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4687:
4688: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4689:
4690: RAISE OKE_API.G_EXCEPTION_ERROR;
4691:
4692: END IF;
4693: */
4694: update pa_project_fundings

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

4719: COMMIT WORK;
4720:
4721: END IF;
4722:
4723: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4724: x_msg_data => p_msg_data
4725: );
4726:
4727: EXCEPTION

Line 4728: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

4724: x_msg_data => p_msg_data
4725: );
4726:
4727: EXCEPTION
4728: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4729: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4730: p_pkg_name => G_PKG_NAME ,
4731: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4732: x_msg_count => p_msg_count ,

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

4725: );
4726:
4727: EXCEPTION
4728: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4729: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4730: p_pkg_name => G_PKG_NAME ,
4731: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4732: x_msg_count => p_msg_count ,
4733: x_msg_data => p_msg_data ,

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

4727: EXCEPTION
4728: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4729: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4730: p_pkg_name => G_PKG_NAME ,
4731: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4732: x_msg_count => p_msg_count ,
4733: x_msg_data => p_msg_data ,
4734: p_api_type => '_PVT'
4735: );

Line 4737: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4733: x_msg_data => p_msg_data ,
4734: p_api_type => '_PVT'
4735: );
4736:
4737: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4738: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4739: p_pkg_name => G_PKG_NAME ,
4740: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4741: x_msg_count => p_msg_count ,

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

4734: p_api_type => '_PVT'
4735: );
4736:
4737: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4738: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4739: p_pkg_name => G_PKG_NAME ,
4740: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4741: x_msg_count => p_msg_count ,
4742: x_msg_data => p_msg_data ,

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

4736:
4737: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4738: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4739: p_pkg_name => G_PKG_NAME ,
4740: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4741: x_msg_count => p_msg_count ,
4742: x_msg_data => p_msg_data ,
4743: p_api_type => '_PVT'
4744: );

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

4743: p_api_type => '_PVT'
4744: );
4745:
4746: WHEN OTHERS THEN
4747: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4748: p_pkg_name => G_PKG_NAME ,
4749: p_exc_name => 'OTHERS' ,
4750: x_msg_count => p_msg_count ,
4751: x_msg_data => p_msg_data ,

Line 4762: -- Calling subprograms: OKE_API.start_activity

4758: -- Procedure: add_pa_funding
4759: --
4760: -- Description: This procedure is used to add pa funding
4761: --
4762: -- Calling subprograms: OKE_API.start_activity
4763: -- OKE_API.end_activity
4764: -- PA_AGREEMENT_PUB.add_funding
4765: -- validate_line_attributes
4766: -- get_converted_amount

Line 4763: -- OKE_API.end_activity

4759: --
4760: -- Description: This procedure is used to add pa funding
4761: --
4762: -- Calling subprograms: OKE_API.start_activity
4763: -- OKE_API.end_activity
4764: -- PA_AGREEMENT_PUB.add_funding
4765: -- validate_line_attributes
4766: -- get_converted_amount
4767: -- get_agreement_org

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

4767: -- get_agreement_org
4768: --
4769:
4770: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
4771: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4772: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4773: p_msg_count OUT NOCOPY NUMBER ,
4774: p_msg_data OUT NOCOPY VARCHAR2 ,
4775: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

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

4768: --
4769:
4770: PROCEDURE add_pa_funding(p_api_version IN NUMBER ,
4771: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4772: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4773: p_msg_count OUT NOCOPY NUMBER ,
4774: p_msg_data OUT NOCOPY VARCHAR2 ,
4775: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4776: p_return_status OUT NOCOPY VARCHAR2

Line 4792: p_return_status := OKE_API.G_RET_STS_SUCCESS;

4788:
4789: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');
4790: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');
4791:
4792: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4793:
4794: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4795: p_pkg_name => G_PKG_NAME ,
4796: p_init_msg_list => p_init_msg_list ,

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

4790: --oke_debug.debug('entering oke_agreement_pvt.add_pa_funding');
4791:
4792: p_return_status := OKE_API.G_RET_STS_SUCCESS;
4793:
4794: l_return_status := OKE_API.START_ACTIVITY(p_api_name => l_api_name ,
4795: p_pkg_name => G_PKG_NAME ,
4796: p_init_msg_list => p_init_msg_list ,
4797: l_api_version => G_API_VERSION_NUMBER ,
4798: p_api_version => p_api_version ,

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

4799: p_api_type => '_PVT' ,
4800: x_return_status => p_return_status
4801: );
4802:
4803: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4804:
4805: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4806:
4807: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4805: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4801: );
4802:
4803: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4804:
4805: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4806:
4807: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4808:
4809: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4803: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4804:
4805: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4806:
4807: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4808:
4809: RAISE OKE_API.G_EXCEPTION_ERROR;
4810:
4811: END IF;

Line 4809: RAISE OKE_API.G_EXCEPTION_ERROR;

4805: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4806:
4807: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
4808:
4809: RAISE OKE_API.G_EXCEPTION_ERROR;
4810:
4811: END IF;
4812:
4813: --

Line 4838: RAISE OKE_API.G_EXCEPTION_ERROR;

4834: );
4835:
4836: IF (p_return_status = 'E') THEN
4837:
4838: RAISE OKE_API.G_EXCEPTION_ERROR;
4839:
4840: ELSIF (p_return_status = 'U') THEN
4841:
4842: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4842: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4838: RAISE OKE_API.G_EXCEPTION_ERROR;
4839:
4840: ELSIF (p_return_status = 'U') THEN
4841:
4842: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4843:
4844: END IF;
4845:
4846: --

Line 4874: p_commit => OKE_API.G_FALSE ,

4870:
4871: IF (p_allocation_in_rec.amount <> 0) THEN
4872:
4873: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4874: p_commit => OKE_API.G_FALSE ,
4875: p_init_msg_list => OKE_API.G_FALSE ,
4876: p_msg_count => p_msg_count ,
4877: p_msg_data => p_msg_data ,
4878: p_return_status => p_return_status ,

Line 4875: p_init_msg_list => OKE_API.G_FALSE ,

4871: IF (p_allocation_in_rec.amount <> 0) THEN
4872:
4873: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4874: p_commit => OKE_API.G_FALSE ,
4875: p_init_msg_list => OKE_API.G_FALSE ,
4876: p_msg_count => p_msg_count ,
4877: p_msg_data => p_msg_data ,
4878: p_return_status => p_return_status ,
4879: p_pm_product_code => OKE_FUNDING_PUB.G_PRODUCT_CODE ,

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

4913:
4914: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4915: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4916:
4917: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4918:
4919: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4920:
4921: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN

Line 4919: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

4915: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4916:
4917: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4918:
4919: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4920:
4921: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4922:
4923: RAISE OKE_API.G_EXCEPTION_ERROR;

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

4917: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4918:
4919: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4920:
4921: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4922:
4923: RAISE OKE_API.G_EXCEPTION_ERROR;
4924:
4925: END IF;

Line 4923: RAISE OKE_API.G_EXCEPTION_ERROR;

4919: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
4920:
4921: ELSIF (p_return_status = OKE_API.G_RET_STS_ERROR) THEN
4922:
4923: RAISE OKE_API.G_EXCEPTION_ERROR;
4924:
4925: END IF;
4926:
4927: --

Line 4956: x_commit => OKE_API.G_FALSE

4952: --oke_debug.debug('calling oke_funding_util.update_alloc_version');
4953:
4954: OKE_FUNDING_UTIL_PKG.update_alloc_version(x_fund_allocation_id => p_allocation_in_rec.fund_allocation_id ,
4955: x_version_add => 1 ,
4956: x_commit => OKE_API.G_FALSE
4957: );
4958:
4959: IF FND_API.to_boolean(p_commit) THEN
4960:

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

4964:
4965: --dbms_output.put_line('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4966: --oke_debug.debug('finished oke_agreement_pvt.add_pa_funding w/ ' || p_return_status);
4967:
4968: OKE_API.END_ACTIVITY(x_msg_count => p_msg_count ,
4969: x_msg_data => p_msg_data
4970: );
4971:
4972: EXCEPTION

Line 4973: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN

4969: x_msg_data => p_msg_data
4970: );
4971:
4972: EXCEPTION
4973: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4974: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4975: p_pkg_name => G_PKG_NAME ,
4976: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4977: x_msg_count => p_msg_count ,

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

4970: );
4971:
4972: EXCEPTION
4973: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4974: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4975: p_pkg_name => G_PKG_NAME ,
4976: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4977: x_msg_count => p_msg_count ,
4978: x_msg_data => p_msg_data ,

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

4972: EXCEPTION
4973: WHEN OKE_API.G_EXCEPTION_ERROR OR G_EXCEPTION_HALT_VALIDATION THEN
4974: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4975: p_pkg_name => G_PKG_NAME ,
4976: p_exc_name => 'OKE_API.G_RET_STS_ERROR' ,
4977: x_msg_count => p_msg_count ,
4978: x_msg_data => p_msg_data ,
4979: p_api_type => '_PVT'
4980: );

Line 4982: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4978: x_msg_data => p_msg_data ,
4979: p_api_type => '_PVT'
4980: );
4981:
4982: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4983: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4984: p_pkg_name => G_PKG_NAME ,
4985: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4986: x_msg_count => p_msg_count ,

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

4979: p_api_type => '_PVT'
4980: );
4981:
4982: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4983: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4984: p_pkg_name => G_PKG_NAME ,
4985: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4986: x_msg_count => p_msg_count ,
4987: x_msg_data => p_msg_data ,

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

4981:
4982: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4983: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4984: p_pkg_name => G_PKG_NAME ,
4985: p_exc_name => 'OKE_API.G_RET_STS_UNEXP_ERROR' ,
4986: x_msg_count => p_msg_count ,
4987: x_msg_data => p_msg_data ,
4988: p_api_type => '_PVT'
4989: );

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

4988: p_api_type => '_PVT'
4989: );
4990:
4991: WHEN OTHERS THEN
4992: p_return_status := OKE_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name ,
4993: p_pkg_name => G_PKG_NAME ,
4994: p_exc_name => 'OTHERS' ,
4995: x_msg_count => p_msg_count ,
4996: x_msg_data => p_msg_data ,