eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_SUBELEMENTS_PVT dependencies on FND_API

Line 24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

20: ----------------------------------------------------------------------------
21:
22: PROCEDURE processInterface (
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
27:
28: x_return_status OUT NOCOPY VARCHAR2,

Line 25: p_commit IN VARCHAR2 := FND_API.G_FALSE,

21:
22: PROCEDURE processInterface (
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,

Line 26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

22: PROCEDURE processInterface (
23: p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25: p_commit IN VARCHAR2 := FND_API.G_FALSE,
26: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,

Line 49: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

45:
46: l_api_name CONSTANT VARCHAR2(30) := 'processInterface';
47: l_api_version CONSTANT NUMBER := 1.0;
48:
49: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
50: l_msg_count NUMBER := 0;
51: l_msg_data VARCHAR2(240) := '';
52: l_counter INTEGER := 0;
53: l_statement NUMBER;

Line 70: IF NOT FND_API.Compatible_API_Call (

66: -- Standard Start of API savepoint
67: SAVEPOINT processInterface_PVT;
68:
69: -- Standard call to check for call compatibility
70: IF NOT FND_API.Compatible_API_Call (
71: l_api_version,
72: p_api_version,
73: l_api_name,
74: G_PKG_NAME ) THEN

Line 75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

71: l_api_version,
72: p_api_version,
73: l_api_name,
74: G_PKG_NAME ) THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 79: IF FND_API.to_Boolean(p_init_msg_list) THEN

75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: END IF;
77:
78: -- Initialize message list if p_init_msg_list is set to TRUE
79: IF FND_API.to_Boolean(p_init_msg_list) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Initialize API return status to success

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: -- Initialize API return status to success
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: if (p_from_organization_id IS NULL OR
87: p_to_organization_id IS NULL OR
88: p_from_cost_type_id IS NULL OR

Line 90: RAISE fnd_api.g_exc_error;

86: if (p_from_organization_id IS NULL OR
87: p_to_organization_id IS NULL OR
88: p_from_cost_type_id IS NULL OR
89: p_to_cost_type_id IS NULL ) then
90: RAISE fnd_api.g_exc_error;
91: end if;
92:
93: -- Call API depending on summary option
94: fnd_file.put_line(fnd_file.log,'Calling getNonMatchingSubElements...');

Line 121: RAISE fnd_api.g_exc_error ;

117: l_api_message := 'Compatible_API_Call returned Error';
118: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
119: FND_MESSAGE.set_token('TEXT', l_api_message);
120: fnd_msg_pub.add;
121: RAISE fnd_api.g_exc_error ;
122: END IF;
123:
124:
125: -- Verify summary option

Line 143: p_exact_copy_flag => FND_API.G_FALSE,

139: p_department_count => l_department_count,
140: p_activity_count => l_activity_count,
141: p_from_organization_id => p_from_organization_id,
142: p_to_organization_id => p_to_organization_id,
143: p_exact_copy_flag => FND_API.G_FALSE,
144: x_return_status => l_return_status,
145: x_msg_count => l_msg_count,
146: x_msg_data => l_msg_data );
147:

Line 156: RAISE fnd_api.g_exc_error ;

152: l_api_message := 'createSubElements returned Error';
153: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
154: FND_MESSAGE.set_token('TEXT', l_api_message);
155: fnd_msg_pub.add;
156: RAISE fnd_api.g_exc_error ;
157: END IF;
158:
159: end if;
160: elsif ((p_summary_option = 2)

Line 194: RAISE fnd_api.g_exc_error ;

190: l_api_message := 'summarizeSubElements returned Error';
191: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
192: FND_MESSAGE.set_token('TEXT', l_api_message);
193: fnd_msg_pub.add;
194: RAISE fnd_api.g_exc_error ;
195: END IF;
196:
197: end if;
198:

Line 200: IF FND_API.to_Boolean(p_commit) THEN

196:
197: end if;
198:
199: -- Standard check of p_commit
200: IF FND_API.to_Boolean(p_commit) THEN
201: COMMIT WORK;
202: END IF;
203:
204: -- Standard Call to get message count and if count = 1, get message info

Line 211: WHEN fnd_api.g_exc_error THEN

207: p_data => x_msg_data );
208:
209:
210: EXCEPTION
211: WHEN fnd_api.g_exc_error THEN
212: x_return_status := fnd_api.g_ret_sts_error;
213:
214: -- Get message count and data
215: fnd_msg_pub.count_and_get

Line 212: x_return_status := fnd_api.g_ret_sts_error;

208:
209:
210: EXCEPTION
211: WHEN fnd_api.g_exc_error THEN
212: x_return_status := fnd_api.g_ret_sts_error;
213:
214: -- Get message count and data
215: fnd_msg_pub.count_and_get
216: ( p_count => x_msg_count

Line 220: WHEN fnd_api.g_exc_unexpected_error THEN

216: ( p_count => x_msg_count
217: , p_data => x_msg_data
218: );
219:
220: WHEN fnd_api.g_exc_unexpected_error THEN
221: x_return_status := fnd_api.g_ret_sts_unexp_error ;
222:
223: -- Get message count and data
224: fnd_msg_pub.count_and_get

Line 221: x_return_status := fnd_api.g_ret_sts_unexp_error ;

217: , p_data => x_msg_data
218: );
219:
220: WHEN fnd_api.g_exc_unexpected_error THEN
221: x_return_status := fnd_api.g_ret_sts_unexp_error ;
222:
223: -- Get message count and data
224: fnd_msg_pub.count_and_get
225: ( p_count => x_msg_count

Line 230: x_return_status := fnd_api.g_ret_sts_unexp_error ;

226: , p_data => x_msg_data
227: );
228: --
229: WHEN OTHERS THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error ;
231: --
232: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
233: THEN
234: fnd_msg_pub.add_exc_msg

Line 268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

264: ----------------------------------------------------------------------------
265:
266: PROCEDURE getNonMatchingSubElements (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271:
272: x_return_status OUT NOCOPY VARCHAR2,

Line 269: p_commit IN VARCHAR2 := FND_API.G_FALSE,

265:
266: PROCEDURE getNonMatchingSubElements (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271:
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,

Line 270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

266: PROCEDURE getNonMatchingSubElements (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269: p_commit IN VARCHAR2 := FND_API.G_FALSE,
270: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271:
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,

Line 290: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

286:
287: l_api_name CONSTANT VARCHAR2(30) := 'getNonMatchingSubElements';
288: l_api_version CONSTANT NUMBER := 1.0;
289:
290: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
291: l_counter INTEGER := 0;
292: l_statement NUMBER;
293: l_exists NUMBER;
294: l_current_rec CST_SubElements_PVT.nonmatching_rec_type;

Line 329: IF NOT FND_API.Compatible_API_Call(

325: -- Standard Start of API savepoint
326: SAVEPOINT getNonMatchingSubElements_PVT;
327:
328: -- Standard Call to check for call compatibility
329: IF NOT FND_API.Compatible_API_Call(
330: l_api_version,
331: p_api_version,
332: l_api_name,
333: G_PKG_NAME ) THEN

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330: l_api_version,
331: p_api_version,
332: l_api_name,
333: G_PKG_NAME ) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE
338: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 338: IF FND_API.to_Boolean(p_init_msg_list) THEN

334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE
338: IF FND_API.to_Boolean(p_init_msg_list) THEN
339: FND_MSG_PUB.initialize;
340: END IF;
341:
342: -- Initiliaze API return status to success

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339: FND_MSG_PUB.initialize;
340: END IF;
341:
342: -- Initiliaze API return status to success
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344:
345: IF(p_from_organization_id IS NULL OR
346: p_to_organization_id IS NULL OR
347: p_group_id IS NULL) THEN

Line 355: RAISE fnd_api.g_exc_error;

351: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
352: FND_MESSAGE.set_token('TEXT', l_api_message);
353: FND_MSG_PUB.ADD;
354:
355: RAISE fnd_api.g_exc_error;
356: END IF;
357:
358: -- Check for non matching subelements
359: FOR subelement_rec IN C_from_subelements LOOP

Line 379: RAISE fnd_api.g_exc_error;

375: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
376: FND_MESSAGE.set_token('TEXT', l_api_message);
377: FND_MSG_PUB.ADD;
378:
379: RAISE fnd_api.g_exc_error;
380: elsif (l_exists = 0) then
381: l_statement := 30;
382: l_current_rec.code := subelement_rec.resource_code;
383:

Line 422: RAISE fnd_api.g_exc_error;

418: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
419: FND_MESSAGE.set_token('TEXT', l_api_message);
420: FND_MSG_PUB.ADD;
421:
422: RAISE fnd_api.g_exc_error;
423: elsif (l_exists = 0) then
424: l_statement := 80;
425: l_current_rec.code := department_rec.department;
426:

Line 464: RAISE fnd_api.g_exc_error;

460: FND_MESSAGE.set_token('TEXT', l_api_message);
461: FND_MSG_PUB.ADD;
462:
463:
464: RAISE fnd_api.g_exc_error;
465: elsif (l_exists = 0) then
466: l_statement := 130;
467: l_current_rec.code := activity_rec.activity;
468:

Line 486: IF FND_API.to_Boolean(p_commit) THEN

482: END LOOP;
483: x_activity_count := l_counter;
484:
485: -- Standard check of p_commit
486: IF FND_API.to_Boolean(p_commit) THEN
487: COMMIT WORK;
488: END IF;
489:
490: -- Standard Call to get message count and if count = 1, get message info

Line 497: WHEN fnd_api.g_exc_error THEN

493: p_data => x_msg_data );
494:
495:
496: EXCEPTION
497: WHEN fnd_api.g_exc_error THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499:
500: -- Get message count and data
501: fnd_msg_pub.count_and_get

Line 498: x_return_status := fnd_api.g_ret_sts_error;

494:
495:
496: EXCEPTION
497: WHEN fnd_api.g_exc_error THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499:
500: -- Get message count and data
501: fnd_msg_pub.count_and_get
502: ( p_count => x_msg_count

Line 506: WHEN fnd_api.g_exc_unexpected_error THEN

502: ( p_count => x_msg_count
503: , p_data => x_msg_data
504: );
505: --
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error ;
508:
509: -- Get message count and data
510: fnd_msg_pub.count_and_get

Line 507: x_return_status := fnd_api.g_ret_sts_unexp_error ;

503: , p_data => x_msg_data
504: );
505: --
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error ;
508:
509: -- Get message count and data
510: fnd_msg_pub.count_and_get
511: ( p_count => x_msg_count

Line 516: x_return_status := fnd_api.g_ret_sts_unexp_error ;

512: , p_data => x_msg_data
513: );
514: --
515: WHEN OTHERS THEN
516: x_return_status := fnd_api.g_ret_sts_unexp_error ;
517: --
518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
519: THEN
520: fnd_msg_pub.add_exc_msg

Line 552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

548: ----------------------------------------------------------------------------
549:
550: PROCEDURE createSubElements (
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553: p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555:
556:

Line 553: p_commit IN VARCHAR2 := FND_API.G_FALSE,

549:
550: PROCEDURE createSubElements (
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553: p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555:
556:
557: p_subelement_tbl IN nonmatching_tbl_type,

Line 554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

550: PROCEDURE createSubElements (
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553: p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555:
556:
557: p_subelement_tbl IN nonmatching_tbl_type,
558: p_department_tbl IN nonmatching_tbl_type,

Line 573: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

569:
570: l_api_name CONSTANT VARCHAR2(30) := 'createSubElements';
571: l_api_version CONSTANT NUMBER := 1.0;
572:
573: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
574: l_counter INTEGER := 0;
575: l_statement NUMBER;
576:
577: l_to_wsm_flag NUMBER;

Line 625: IF NOT FND_API.Compatible_API_Call(

621: -------------------------------------------------------------------------
622: -- Standard Call to check for call compatibility
623: -------------------------------------------------------------------------
624:
625: IF NOT FND_API.Compatible_API_Call(
626: l_api_version,
627: p_api_version,
628: l_api_name,
629: G_PKG_NAME ) THEN

Line 630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

626: l_api_version,
627: p_api_version,
628: l_api_name,
629: G_PKG_NAME ) THEN
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632:
633: -------------------------------------------------------------------------
634: -- Initialize message list if p_init_msg_list is set to TRUE

Line 637: IF FND_API.to_Boolean(p_init_msg_list) THEN

633: -------------------------------------------------------------------------
634: -- Initialize message list if p_init_msg_list is set to TRUE
635: -------------------------------------------------------------------------
636:
637: IF FND_API.to_Boolean(p_init_msg_list) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: -------------------------------------------------------------------------

Line 658: x_return_status := FND_API.G_RET_STS_SUCCESS;

654: -------------------------------------------------------------------------
655: -- Initiliaze API return status to success
656: -------------------------------------------------------------------------
657:
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659:
660:
661: l_statement := 20;
662:

Line 666: RAISE fnd_api.g_exc_error;

662:
663: IF(p_from_organization_id IS NULL OR
664: p_to_organization_id IS NULL ) THEN
665:
666: RAISE fnd_api.g_exc_error;
667:
668: END IF;
669:
670: ----------------------------------------------------------------------

Line 835: IF p_exact_copy_flag = FND_API.G_FALSE THEN

831: l_source_department_id := p_department_tbl( l_counter).ID;
832:
833: l_statement := 100;
834:
835: IF p_exact_copy_flag = FND_API.G_FALSE THEN
836:
837: IF (l_to_wsm_flag = 1) THEN
838:
839: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>getDeptAccounts()');

Line 854: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

850: x_msg_data => x_msg_data );
851:
852: FND_FILE.PUT_LINE(FND_FILE.LOG, '< 853:
854: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
855: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
856: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);
857: fnd_msg_pub.add;
858: RAISE fnd_api.g_exc_error ;

Line 858: RAISE fnd_api.g_exc_error ;

854: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
855: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
856: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);
857: fnd_msg_pub.add;
858: RAISE fnd_api.g_exc_error ;
859: END IF;
860:
861: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
862: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');

Line 861: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

857: fnd_msg_pub.add;
858: RAISE fnd_api.g_exc_error ;
859: END IF;
860:
861: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
862: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
863: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);
864: fnd_msg_pub.add;
865: RAISE fnd_api.g_exc_unexpected_error ;

Line 865: RAISE fnd_api.g_exc_unexpected_error ;

861: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
862: fnd_message.set_name('BOM', 'CST_DEPT_ACCOUNTS_NULL');
863: fnd_message.set_token('DEPT_CODE',p_department_tbl( l_counter).CODE,TRUE);
864: fnd_msg_pub.add;
865: RAISE fnd_api.g_exc_unexpected_error ;
866: END IF;
867:
868: END IF; --check for wsm flag
869:

Line 894: RAISE fnd_api.g_exc_error;

890:
891: fnd_file.put_line(fnd_file.log,'Estimated Scrap Accounting Flag: '||x_est_scrap_acct_flag);
892:
893: IF (x_est_scrap_acct_flag = 0) THEN
894: RAISE fnd_api.g_exc_error;
895: END IF;
896:
897: l_statement := 120;
898:

Line 901: RAISE fnd_api.g_exc_error;

897: l_statement := 120;
898:
899: IF x_est_scrap_acct_flag = 1 AND
900: (l_scrap_acct IS NULL OR l_est_abs_acct IS NULL) THEN
901: RAISE fnd_api.g_exc_error;
902: END IF;
903:
904: END IF;
905:

Line 1195: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1191: x_msg_data => x_msg_data );
1192:
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1194:
1195: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1196: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1197: fnd_msg_pub.add;
1198: RAISE fnd_api.g_exc_error ;
1199: END IF;

Line 1198: RAISE fnd_api.g_exc_error ;

1194:
1195: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1196: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1197: fnd_msg_pub.add;
1198: RAISE fnd_api.g_exc_error ;
1199: END IF;
1200:
1201: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1202: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');

Line 1201: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1197: fnd_msg_pub.add;
1198: RAISE fnd_api.g_exc_error ;
1199: END IF;
1200:
1201: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1202: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1203: fnd_msg_pub.add;
1204: RAISE fnd_api.g_exc_unexpected_error ;
1205: END IF;

Line 1204: RAISE fnd_api.g_exc_unexpected_error ;

1200:
1201: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1202: fnd_message.set_name('BOM', 'CST_PURCHASE_ITEM_ERROR');
1203: fnd_msg_pub.add;
1204: RAISE fnd_api.g_exc_unexpected_error ;
1205: END IF;
1206:
1207:
1208: END IF;

Line 1224: --RAISE fnd_api.g_exc_error;

1220:
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,
1222: 'WARNING: OSP Item is missing for Res_id: '
1223: ||TO_CHAR(l_source_resource_id));
1224: --RAISE fnd_api.g_exc_error;
1225: END IF;
1226:
1227: END IF; -- check for CE=4 (OSP)
1228:

Line 1268: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1264: x_msg_data => x_msg_data );
1265:
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1267:
1268: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1269: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1270: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1271: fnd_msg_pub.add;
1272: RAISE fnd_api.g_exc_error ;

Line 1272: RAISE fnd_api.g_exc_error ;

1268: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1269: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1270: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1271: fnd_msg_pub.add;
1272: RAISE fnd_api.g_exc_error ;
1273: END IF;
1274:
1275: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1276: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');

Line 1275: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1271: fnd_msg_pub.add;
1272: RAISE fnd_api.g_exc_error ;
1273: END IF;
1274:
1275: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1276: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1277: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1278: fnd_msg_pub.add;
1279: RAISE fnd_api.g_exc_unexpected_error ;

Line 1279: RAISE fnd_api.g_exc_unexpected_error ;

1275: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1276: fnd_message.set_name('BOM', 'CST_NO_DEFAULT_ACTIVITY');
1277: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1278: fnd_msg_pub.add;
1279: RAISE fnd_api.g_exc_unexpected_error ;
1280: END IF;
1281: ELSE
1282: l_default_activity_id := l_dummy;
1283: END IF;

Line 1287: RAISE fnd_api.g_exc_error;

1283: END IF;
1284:
1285: IF l_default_activity_id IS NULL THEN
1286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Default Activity is null');
1287: RAISE fnd_api.g_exc_error;
1288: END IF;
1289:
1290: END IF; /* default activity in from org is not null */
1291:

Line 1315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1311: x_msg_data => x_msg_data );
1312:
1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1314:
1315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1316: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1317: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1318: fnd_msg_pub.add;
1319: RAISE fnd_api.g_exc_error ;

Line 1319: RAISE fnd_api.g_exc_error ;

1315: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1316: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1317: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1318: fnd_msg_pub.add;
1319: RAISE fnd_api.g_exc_error ;
1320: END IF;
1321:
1322: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1323: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');

Line 1322: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1318: fnd_msg_pub.add;
1319: RAISE fnd_api.g_exc_error ;
1320: END IF;
1321:
1322: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1323: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1324: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1325: fnd_msg_pub.add;
1326: RAISE fnd_api.g_exc_unexpected_error ;

Line 1326: RAISE fnd_api.g_exc_unexpected_error ;

1322: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1323: fnd_message.set_name('BOM', 'CST_EXPENDITURE_TYPE_NULL');
1324: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1325: fnd_msg_pub.add;
1326: RAISE fnd_api.g_exc_unexpected_error ;
1327: END IF;
1328:
1329: IF (l_expenditure_type IS NULL) THEN
1330: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expenditure type is null');

Line 1331: RAISE fnd_api.g_exc_error;

1327: END IF;
1328:
1329: IF (l_expenditure_type IS NULL) THEN
1330: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expenditure type is null');
1331: RAISE fnd_api.g_exc_error;
1332: END IF;
1333: END IF;
1334:
1335: -------------------------------------------------------------------------

Line 1341: IF p_exact_copy_flag = FND_API.G_FALSE THEN

1337: -------------------------------------------------------------------------
1338:
1339: IF (l_cost_element_id <> 1) THEN
1340:
1341: IF p_exact_copy_flag = FND_API.G_FALSE THEN
1342:
1343: l_absorption_acct := NULL;
1344: l_rate_variance_acct := NULL;
1345:

Line 1363: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1359: x_msg_data => x_msg_data );
1360:
1361: FND_FILE.PUT_LINE(FND_FILE.LOG,'< 1362:
1363: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1364: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1365: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1366: fnd_msg_pub.add;
1367: RAISE fnd_api.g_exc_error ;

Line 1367: RAISE fnd_api.g_exc_error ;

1363: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1364: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1365: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1366: fnd_msg_pub.add;
1367: RAISE fnd_api.g_exc_error ;
1368: END IF;
1369:
1370: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1371: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');

Line 1370: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1366: fnd_msg_pub.add;
1367: RAISE fnd_api.g_exc_error ;
1368: END IF;
1369:
1370: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1371: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1372: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1373: fnd_msg_pub.add;
1374: RAISE fnd_api.g_exc_unexpected_error ;

Line 1374: RAISE fnd_api.g_exc_unexpected_error ;

1370: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1371: fnd_message.set_name('BOM', 'CST_SUBELEMENT_ACCTS_NULL');
1372: fnd_message.set_token('RESOURCE_CODE',p_subelement_tbl( l_counter).CODE,TRUE);
1373: fnd_msg_pub.add;
1374: RAISE fnd_api.g_exc_unexpected_error ;
1375: END IF;
1376:
1377: END IF; -- check for exact copy
1378:

Line 1385: RAISE fnd_api.g_exc_error;

1381: ----------------------------------------------------------------------
1382:
1383: IF (l_absorption_acct IS NULL ) THEN
1384:
1385: RAISE fnd_api.g_exc_error;
1386:
1387: END IF;
1388:
1389: END IF; -- Check for non-material subelement

Line 1515: IF FND_API.to_Boolean(p_commit) THEN

1511: ---------------------------------------------------------------------------
1512: -- Standard check of p_commit
1513: ---------------------------------------------------------------------------
1514:
1515: IF FND_API.to_Boolean(p_commit) THEN
1516: COMMIT WORK;
1517: END IF;
1518:
1519: ---------------------------------------------------------------------------

Line 1529: WHEN fnd_api.g_exc_error THEN

1525: p_data => x_msg_data );
1526:
1527:
1528: EXCEPTION
1529: WHEN fnd_api.g_exc_error THEN
1530: x_return_status := fnd_api.g_ret_sts_error;
1531:
1532: -- Get message count and data
1533: fnd_msg_pub.count_and_get

Line 1530: x_return_status := fnd_api.g_ret_sts_error;

1526:
1527:
1528: EXCEPTION
1529: WHEN fnd_api.g_exc_error THEN
1530: x_return_status := fnd_api.g_ret_sts_error;
1531:
1532: -- Get message count and data
1533: fnd_msg_pub.count_and_get
1534: ( p_count => x_msg_count

Line 1538: WHEN fnd_api.g_exc_unexpected_error THEN

1534: ( p_count => x_msg_count
1535: , p_data => x_msg_data
1536: );
1537: --
1538: WHEN fnd_api.g_exc_unexpected_error THEN
1539: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1540:
1541: -- Get message count and data
1542: fnd_msg_pub.count_and_get

Line 1539: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1535: , p_data => x_msg_data
1536: );
1537: --
1538: WHEN fnd_api.g_exc_unexpected_error THEN
1539: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1540:
1541: -- Get message count and data
1542: fnd_msg_pub.count_and_get
1543: ( p_count => x_msg_count

Line 1548: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1544: , p_data => x_msg_data
1545: );
1546: --
1547: WHEN OTHERS THEN
1548: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1549: --
1550: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1551: THEN
1552: fnd_msg_pub.add_exc_msg

Line 1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1580: ----------------------------------------------------------------------------
1581:
1582: PROCEDURE getDeptAccounts (
1583: p_api_version IN NUMBER,
1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER
1587: := FND_API.G_VALID_LEVEL_FULL,
1588: p_department_id IN NUMBER,

Line 1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1581:
1582: PROCEDURE getDeptAccounts (
1583: p_api_version IN NUMBER,
1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER
1587: := FND_API.G_VALID_LEVEL_FULL,
1588: p_department_id IN NUMBER,
1589: p_from_organization_id IN NUMBER,

Line 1587: := FND_API.G_VALID_LEVEL_FULL,

1583: p_api_version IN NUMBER,
1584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1586: p_validation_level IN NUMBER
1587: := FND_API.G_VALID_LEVEL_FULL,
1588: p_department_id IN NUMBER,
1589: p_from_organization_id IN NUMBER,
1590: p_to_organization_id IN NUMBER,
1591: x_scrap_account OUT NOCOPY NUMBER,

Line 1601: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1597:
1598: l_api_name CONSTANT VARCHAR2(30) := 'getDeptAccounts';
1599: l_api_version CONSTANT NUMBER := 1.0;
1600:
1601: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1602: l_counter INTEGER := 0;
1603: l_statement NUMBER;
1604:
1605: BEGIN

Line 1611: IF NOT FND_API.Compatible_API_Call(

1607: -------------------------------------------------------------------------
1608: -- Standard Call to check for call compatibility
1609: -------------------------------------------------------------------------
1610:
1611: IF NOT FND_API.Compatible_API_Call(
1612: l_api_version,
1613: p_api_version,
1614: l_api_name,
1615: G_PKG_NAME ) THEN

Line 1616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1612: l_api_version,
1613: p_api_version,
1614: l_api_name,
1615: G_PKG_NAME ) THEN
1616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1617: END IF;
1618:
1619: -------------------------------------------------------------------------
1620: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1623: IF FND_API.to_Boolean(p_init_msg_list) THEN

1619: -------------------------------------------------------------------------
1620: -- Initialize message list if p_init_msg_list is set to TRUE
1621: -------------------------------------------------------------------------
1622:
1623: IF FND_API.to_Boolean(p_init_msg_list) THEN
1624: FND_MSG_PUB.initialize;
1625: END IF;
1626:
1627: -------------------------------------------------------------------------

Line 1631: x_return_status := FND_API.G_RET_STS_SUCCESS;

1627: -------------------------------------------------------------------------
1628: -- Initiliaze API return status to success
1629: -------------------------------------------------------------------------
1630:
1631: x_return_status := FND_API.G_RET_STS_SUCCESS;
1632:
1633: ---------------------------------------------------------------------------
1634: -- Place Extension code here
1635: -- The default code will return the organization's expense account as the

Line 1653: IF FND_API.to_Boolean(p_commit) THEN

1649: ---------------------------------------------------------------------------
1650: -- Standard check of p_commit
1651: ---------------------------------------------------------------------------
1652:
1653: IF FND_API.to_Boolean(p_commit) THEN
1654: COMMIT WORK;
1655: END IF;
1656:
1657: --------------------------------------------------------------------------

Line 1667: WHEN fnd_api.g_exc_error THEN

1663: p_data => x_msg_data );
1664:
1665:
1666: EXCEPTION
1667: WHEN fnd_api.g_exc_error THEN
1668: x_return_status := fnd_api.g_ret_sts_error;
1669:
1670: -- Get message count and data
1671: fnd_msg_pub.count_and_get

Line 1668: x_return_status := fnd_api.g_ret_sts_error;

1664:
1665:
1666: EXCEPTION
1667: WHEN fnd_api.g_exc_error THEN
1668: x_return_status := fnd_api.g_ret_sts_error;
1669:
1670: -- Get message count and data
1671: fnd_msg_pub.count_and_get
1672: ( p_count => x_msg_count

Line 1676: WHEN fnd_api.g_exc_unexpected_error THEN

1672: ( p_count => x_msg_count
1673: , p_data => x_msg_data
1674: );
1675: --
1676: WHEN fnd_api.g_exc_unexpected_error THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678:
1679: -- Get message count and data
1680: fnd_msg_pub.count_and_get

Line 1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1673: , p_data => x_msg_data
1674: );
1675: --
1676: WHEN fnd_api.g_exc_unexpected_error THEN
1677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1678:
1679: -- Get message count and data
1680: fnd_msg_pub.count_and_get
1681: ( p_count => x_msg_count

Line 1686: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1682: , p_data => x_msg_data
1683: );
1684: --
1685: WHEN OTHERS THEN
1686: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1687: --
1688: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1689: THEN
1690: fnd_msg_pub.add_exc_msg

Line 1721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1717: ----------------------------------------------------------------------------
1718:
1719: PROCEDURE getOSPItem (
1720: p_api_version IN NUMBER,
1721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1722: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1723: p_validation_level IN NUMBER
1724: := FND_API.G_VALID_LEVEL_FULL,
1725: p_resource_id IN NUMBER,

Line 1722: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1718:
1719: PROCEDURE getOSPItem (
1720: p_api_version IN NUMBER,
1721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1722: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1723: p_validation_level IN NUMBER
1724: := FND_API.G_VALID_LEVEL_FULL,
1725: p_resource_id IN NUMBER,
1726: p_from_organization_id IN NUMBER,

Line 1724: := FND_API.G_VALID_LEVEL_FULL,

1720: p_api_version IN NUMBER,
1721: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1722: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1723: p_validation_level IN NUMBER
1724: := FND_API.G_VALID_LEVEL_FULL,
1725: p_resource_id IN NUMBER,
1726: p_from_organization_id IN NUMBER,
1727: p_to_organization_id IN NUMBER,
1728:

Line 1738: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1734:
1735: l_api_name CONSTANT VARCHAR2(30) := 'getOSPItem';
1736: l_api_version CONSTANT NUMBER := 1.0;
1737:
1738: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1739: l_counter INTEGER := 0;
1740: l_statement NUMBER;
1741:
1742: BEGIN

Line 1748: IF NOT FND_API.Compatible_API_Call(

1744: -------------------------------------------------------------------------
1745: -- Standard Call to check for call compatibility
1746: -------------------------------------------------------------------------
1747:
1748: IF NOT FND_API.Compatible_API_Call(
1749: l_api_version,
1750: p_api_version,
1751: l_api_name,
1752: G_PKG_NAME ) THEN

Line 1753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1749: l_api_version,
1750: p_api_version,
1751: l_api_name,
1752: G_PKG_NAME ) THEN
1753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1754: END IF;
1755:
1756: -------------------------------------------------------------------------
1757: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1760: IF FND_API.to_Boolean(p_init_msg_list) THEN

1756: -------------------------------------------------------------------------
1757: -- Initialize message list if p_init_msg_list is set to TRUE
1758: -------------------------------------------------------------------------
1759:
1760: IF FND_API.to_Boolean(p_init_msg_list) THEN
1761: FND_MSG_PUB.initialize;
1762: END IF;
1763:
1764: -------------------------------------------------------------------------

Line 1768: x_return_status := FND_API.G_RET_STS_SUCCESS;

1764: -------------------------------------------------------------------------
1765: -- Initiliaze API return status to success
1766: -------------------------------------------------------------------------
1767:
1768: x_return_status := FND_API.G_RET_STS_SUCCESS;
1769:
1770: -------------------------------------------------------------------------
1771: -- Place Extension code here
1772: -------------------------------------------------------------------------

Line 1778: IF FND_API.to_Boolean(p_commit) THEN

1774: -------------------------------------------------------------------------
1775: -- Standard check of p_commit
1776: -------------------------------------------------------------------------
1777:
1778: IF FND_API.to_Boolean(p_commit) THEN
1779: COMMIT WORK;
1780: END IF;
1781:
1782: -------------------------------------------------------------------------

Line 1792: WHEN fnd_api.g_exc_error THEN

1788: p_data => x_msg_data );
1789:
1790:
1791: EXCEPTION
1792: WHEN fnd_api.g_exc_error THEN
1793: x_return_status := fnd_api.g_ret_sts_error;
1794:
1795: -- Get message count and data
1796: fnd_msg_pub.count_and_get

Line 1793: x_return_status := fnd_api.g_ret_sts_error;

1789:
1790:
1791: EXCEPTION
1792: WHEN fnd_api.g_exc_error THEN
1793: x_return_status := fnd_api.g_ret_sts_error;
1794:
1795: -- Get message count and data
1796: fnd_msg_pub.count_and_get
1797: ( p_count => x_msg_count

Line 1801: WHEN fnd_api.g_exc_unexpected_error THEN

1797: ( p_count => x_msg_count
1798: , p_data => x_msg_data
1799: );
1800: --
1801: WHEN fnd_api.g_exc_unexpected_error THEN
1802: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1803:
1804: -- Get message count and data
1805: fnd_msg_pub.count_and_get

Line 1802: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1798: , p_data => x_msg_data
1799: );
1800: --
1801: WHEN fnd_api.g_exc_unexpected_error THEN
1802: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1803:
1804: -- Get message count and data
1805: fnd_msg_pub.count_and_get
1806: ( p_count => x_msg_count

Line 1811: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1807: , p_data => x_msg_data
1808: );
1809: --
1810: WHEN OTHERS THEN
1811: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1812: --
1813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1814: THEN
1815: fnd_msg_pub.add_exc_msg

Line 1847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1843: ----------------------------------------------------------------------------
1844:
1845: PROCEDURE getDefaultActivity (
1846: p_api_version IN NUMBER,
1847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1848: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1849: p_validation_level IN NUMBER
1850: := FND_API.G_VALID_LEVEL_FULL,
1851:

Line 1848: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1844:
1845: PROCEDURE getDefaultActivity (
1846: p_api_version IN NUMBER,
1847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1848: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1849: p_validation_level IN NUMBER
1850: := FND_API.G_VALID_LEVEL_FULL,
1851:
1852: p_resource_id IN NUMBER,

Line 1850: := FND_API.G_VALID_LEVEL_FULL,

1846: p_api_version IN NUMBER,
1847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1848: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1849: p_validation_level IN NUMBER
1850: := FND_API.G_VALID_LEVEL_FULL,
1851:
1852: p_resource_id IN NUMBER,
1853: p_from_organization_id IN NUMBER,
1854: p_to_organization_id IN NUMBER,

Line 1864: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1860:
1861: l_api_name CONSTANT VARCHAR2(30) := 'getDefaultActivity';
1862: l_api_version CONSTANT NUMBER := 1.0;
1863:
1864: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1865: l_counter INTEGER := 0;
1866: l_statement NUMBER;
1867:
1868: BEGIN

Line 1874: IF NOT FND_API.Compatible_API_Call(

1870: -------------------------------------------------------------------------
1871: -- Standard Call to check for call compatibility
1872: -------------------------------------------------------------------------
1873:
1874: IF NOT FND_API.Compatible_API_Call(
1875: l_api_version,
1876: p_api_version,
1877: l_api_name,
1878: G_PKG_NAME ) THEN

Line 1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1875: l_api_version,
1876: p_api_version,
1877: l_api_name,
1878: G_PKG_NAME ) THEN
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880: END IF;
1881:
1882: -------------------------------------------------------------------------
1883: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1886: IF FND_API.to_Boolean(p_init_msg_list) THEN

1882: -------------------------------------------------------------------------
1883: -- Initialize message list if p_init_msg_list is set to TRUE
1884: -------------------------------------------------------------------------
1885:
1886: IF FND_API.to_Boolean(p_init_msg_list) THEN
1887: FND_MSG_PUB.initialize;
1888: END IF;
1889:
1890: -------------------------------------------------------------------------

Line 1894: x_return_status := FND_API.G_RET_STS_SUCCESS;

1890: -------------------------------------------------------------------------
1891: -- Initiliaze API return status to success
1892: -------------------------------------------------------------------------
1893:
1894: x_return_status := FND_API.G_RET_STS_SUCCESS;
1895:
1896: -------------------------------------------------------------------------
1897: -- Place Extension code here
1898: -------------------------------------------------------------------------

Line 1904: IF FND_API.to_Boolean(p_commit) THEN

1900: -------------------------------------------------------------------------
1901: -- Standard check of p_commit
1902: -------------------------------------------------------------------------
1903:
1904: IF FND_API.to_Boolean(p_commit) THEN
1905: COMMIT WORK;
1906: END IF;
1907:
1908: -------------------------------------------------------------------------

Line 1918: WHEN fnd_api.g_exc_error THEN

1914: p_data => x_msg_data );
1915:
1916:
1917: EXCEPTION
1918: WHEN fnd_api.g_exc_error THEN
1919: x_return_status := fnd_api.g_ret_sts_error;
1920:
1921: -- Get message count and data
1922: fnd_msg_pub.count_and_get

Line 1919: x_return_status := fnd_api.g_ret_sts_error;

1915:
1916:
1917: EXCEPTION
1918: WHEN fnd_api.g_exc_error THEN
1919: x_return_status := fnd_api.g_ret_sts_error;
1920:
1921: -- Get message count and data
1922: fnd_msg_pub.count_and_get
1923: ( p_count => x_msg_count

Line 1927: WHEN fnd_api.g_exc_unexpected_error THEN

1923: ( p_count => x_msg_count
1924: , p_data => x_msg_data
1925: );
1926: --
1927: WHEN fnd_api.g_exc_unexpected_error THEN
1928: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1929:
1930: -- Get message count and data
1931: fnd_msg_pub.count_and_get

Line 1928: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1924: , p_data => x_msg_data
1925: );
1926: --
1927: WHEN fnd_api.g_exc_unexpected_error THEN
1928: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1929:
1930: -- Get message count and data
1931: fnd_msg_pub.count_and_get
1932: ( p_count => x_msg_count

Line 1937: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1933: , p_data => x_msg_data
1934: );
1935: --
1936: WHEN OTHERS THEN
1937: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1938: --
1939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1940: THEN
1941: fnd_msg_pub.add_exc_msg

Line 1973: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1969: ----------------------------------------------------------------------------
1970:
1971: PROCEDURE getExpenditureType (
1972: p_api_version IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1975: p_validation_level IN NUMBER
1976: := FND_API.G_VALID_LEVEL_FULL,
1977:

Line 1974: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1970:
1971: PROCEDURE getExpenditureType (
1972: p_api_version IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1975: p_validation_level IN NUMBER
1976: := FND_API.G_VALID_LEVEL_FULL,
1977:
1978: p_resource_id IN NUMBER,

Line 1976: := FND_API.G_VALID_LEVEL_FULL,

1972: p_api_version IN NUMBER,
1973: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1975: p_validation_level IN NUMBER
1976: := FND_API.G_VALID_LEVEL_FULL,
1977:
1978: p_resource_id IN NUMBER,
1979: p_from_organization_id IN NUMBER,
1980: p_to_organization_id IN NUMBER,

Line 1990: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1986:
1987: l_api_name CONSTANT VARCHAR2(30) := 'getExpenditureType';
1988: l_api_version CONSTANT NUMBER := 1.0;
1989:
1990: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1991: l_counter INTEGER := 0;
1992: l_statement NUMBER;
1993:
1994: BEGIN

Line 2000: IF NOT FND_API.Compatible_API_Call(

1996: -------------------------------------------------------------------------
1997: -- Standard Call to check for call compatibility
1998: -------------------------------------------------------------------------
1999:
2000: IF NOT FND_API.Compatible_API_Call(
2001: l_api_version,
2002: p_api_version,
2003: l_api_name,
2004: G_PKG_NAME ) THEN

Line 2005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2001: l_api_version,
2002: p_api_version,
2003: l_api_name,
2004: G_PKG_NAME ) THEN
2005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2006: END IF;
2007:
2008: -------------------------------------------------------------------------
2009: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2012: IF FND_API.to_Boolean(p_init_msg_list) THEN

2008: -------------------------------------------------------------------------
2009: -- Initialize message list if p_init_msg_list is set to TRUE
2010: -------------------------------------------------------------------------
2011:
2012: IF FND_API.to_Boolean(p_init_msg_list) THEN
2013: FND_MSG_PUB.initialize;
2014: END IF;
2015:
2016: -------------------------------------------------------------------------

Line 2020: x_return_status := FND_API.G_RET_STS_SUCCESS;

2016: -------------------------------------------------------------------------
2017: -- Initiliaze API return status to success
2018: -------------------------------------------------------------------------
2019:
2020: x_return_status := FND_API.G_RET_STS_SUCCESS;
2021:
2022: -------------------------------------------------------------------------
2023: -- Place Extension code here
2024: -- The default code will return random expenditure type for

Line 2043: IF FND_API.to_Boolean(p_commit) THEN

2039: -------------------------------------------------------------------------
2040: -- Standard check of p_commit
2041: -------------------------------------------------------------------------
2042:
2043: IF FND_API.to_Boolean(p_commit) THEN
2044: COMMIT WORK;
2045: END IF;
2046:
2047: -------------------------------------------------------------------------

Line 2057: WHEN fnd_api.g_exc_error THEN

2053: p_data => x_msg_data );
2054:
2055:
2056: EXCEPTION
2057: WHEN fnd_api.g_exc_error THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059:
2060: -- Get message count and data
2061: fnd_msg_pub.count_and_get

Line 2058: x_return_status := fnd_api.g_ret_sts_error;

2054:
2055:
2056: EXCEPTION
2057: WHEN fnd_api.g_exc_error THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059:
2060: -- Get message count and data
2061: fnd_msg_pub.count_and_get
2062: ( p_count => x_msg_count

Line 2066: WHEN fnd_api.g_exc_unexpected_error THEN

2062: ( p_count => x_msg_count
2063: , p_data => x_msg_data
2064: );
2065: --
2066: WHEN fnd_api.g_exc_unexpected_error THEN
2067: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2068:
2069: -- Get message count and data
2070: fnd_msg_pub.count_and_get

Line 2067: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2063: , p_data => x_msg_data
2064: );
2065: --
2066: WHEN fnd_api.g_exc_unexpected_error THEN
2067: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2068:
2069: -- Get message count and data
2070: fnd_msg_pub.count_and_get
2071: ( p_count => x_msg_count

Line 2076: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2072: , p_data => x_msg_data
2073: );
2074: --
2075: WHEN OTHERS THEN
2076: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2077: --
2078: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2079: THEN
2080: fnd_msg_pub.add_exc_msg

Line 2112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2108: ----------------------------------------------------------------------------
2109:
2110: PROCEDURE getSubelementAcct (
2111: p_api_version IN NUMBER,
2112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2114: p_validation_level IN NUMBER
2115: := FND_API.G_VALID_LEVEL_FULL,
2116:

Line 2113: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2109:
2110: PROCEDURE getSubelementAcct (
2111: p_api_version IN NUMBER,
2112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2114: p_validation_level IN NUMBER
2115: := FND_API.G_VALID_LEVEL_FULL,
2116:
2117: p_resource_id IN NUMBER,

Line 2115: := FND_API.G_VALID_LEVEL_FULL,

2111: p_api_version IN NUMBER,
2112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2114: p_validation_level IN NUMBER
2115: := FND_API.G_VALID_LEVEL_FULL,
2116:
2117: p_resource_id IN NUMBER,
2118: p_from_organization_id IN NUMBER,
2119: p_to_organization_id IN NUMBER,

Line 2130: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2126:
2127: l_api_name CONSTANT VARCHAR2(30) := 'getSubelementAcct';
2128: l_api_version CONSTANT NUMBER := 1.0;
2129:
2130: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2131: l_counter INTEGER := 0;
2132: l_statement NUMBER;
2133:
2134:

Line 2143: IF NOT FND_API.Compatible_API_Call(

2139: -------------------------------------------------------------------------
2140: -- Standard Call to check for call compatibility
2141: -------------------------------------------------------------------------
2142:
2143: IF NOT FND_API.Compatible_API_Call(
2144: l_api_version,
2145: p_api_version,
2146: l_api_name,
2147: G_PKG_NAME ) THEN

Line 2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2144: l_api_version,
2145: p_api_version,
2146: l_api_name,
2147: G_PKG_NAME ) THEN
2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2149: END IF;
2150:
2151: -------------------------------------------------------------------------
2152: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2155: IF FND_API.to_Boolean(p_init_msg_list) THEN

2151: -------------------------------------------------------------------------
2152: -- Initialize message list if p_init_msg_list is set to TRUE
2153: -------------------------------------------------------------------------
2154:
2155: IF FND_API.to_Boolean(p_init_msg_list) THEN
2156: FND_MSG_PUB.initialize;
2157: END IF;
2158:
2159: -------------------------------------------------------------------------

Line 2163: x_return_status := FND_API.G_RET_STS_SUCCESS;

2159: -------------------------------------------------------------------------
2160: -- Initiliaze API return status to success
2161: -------------------------------------------------------------------------
2162:
2163: x_return_status := FND_API.G_RET_STS_SUCCESS;
2164:
2165: -------------------------------------------------------------------------
2166: -- Place Extension code here
2167: -- The default code will return organization level element accounts

Line 2192: IF FND_API.to_Boolean(p_commit) THEN

2188: -------------------------------------------------------------------------
2189: -- Standard check of p_commit
2190: -------------------------------------------------------------------------
2191:
2192: IF FND_API.to_Boolean(p_commit) THEN
2193: COMMIT WORK;
2194: END IF;
2195:
2196: -------------------------------------------------------------------------

Line 2206: WHEN fnd_api.g_exc_error THEN

2202: p_data => x_msg_data );
2203:
2204:
2205: EXCEPTION
2206: WHEN fnd_api.g_exc_error THEN
2207: x_return_status := fnd_api.g_ret_sts_error;
2208:
2209: -- Get message count and data
2210: fnd_msg_pub.count_and_get

Line 2207: x_return_status := fnd_api.g_ret_sts_error;

2203:
2204:
2205: EXCEPTION
2206: WHEN fnd_api.g_exc_error THEN
2207: x_return_status := fnd_api.g_ret_sts_error;
2208:
2209: -- Get message count and data
2210: fnd_msg_pub.count_and_get
2211: ( p_count => x_msg_count

Line 2215: WHEN fnd_api.g_exc_unexpected_error THEN

2211: ( p_count => x_msg_count
2212: , p_data => x_msg_data
2213: );
2214: --
2215: WHEN fnd_api.g_exc_unexpected_error THEN
2216: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2217:
2218: -- Get message count and data
2219: fnd_msg_pub.count_and_get

Line 2216: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2212: , p_data => x_msg_data
2213: );
2214: --
2215: WHEN fnd_api.g_exc_unexpected_error THEN
2216: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2217:
2218: -- Get message count and data
2219: fnd_msg_pub.count_and_get
2220: ( p_count => x_msg_count

Line 2225: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2221: , p_data => x_msg_data
2222: );
2223: --
2224: WHEN OTHERS THEN
2225: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2226: --
2227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2228: THEN
2229: fnd_msg_pub.add_exc_msg

Line 2263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2259: ----------------------------------------------------------------------------
2260:
2261: PROCEDURE summarizeSubElements (
2262: p_api_version IN NUMBER,
2263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2266:
2267: x_return_status OUT NOCOPY VARCHAR2,

Line 2264: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2260:
2261: PROCEDURE summarizeSubElements (
2262: p_api_version IN NUMBER,
2263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2266:
2267: x_return_status OUT NOCOPY VARCHAR2,
2268: x_msg_count OUT NOCOPY NUMBER,

Line 2265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2261: PROCEDURE summarizeSubElements (
2262: p_api_version IN NUMBER,
2263: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2264: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2265: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2266:
2267: x_return_status OUT NOCOPY VARCHAR2,
2268: x_msg_count OUT NOCOPY NUMBER,
2269: x_msg_data OUT NOCOPY VARCHAR2,

Line 2293: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2289:
2290: l_api_name CONSTANT VARCHAR2(30) := 'summarizeSubElements';
2291: l_api_version CONSTANT NUMBER := 1.0;
2292:
2293: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2294: l_counter INTEGER := 0;
2295: l_statement NUMBER;
2296:
2297: l_resource_code VARCHAR2(10);

Line 2324: IF NOT FND_API.Compatible_API_Call(

2320: -- Standard Start of API savepoint
2321: SAVEPOINT summarizeSubElements_PVT;
2322:
2323: -- Standard Call to check for call compatibility
2324: IF NOT FND_API.Compatible_API_Call(
2325: l_api_version,
2326: p_api_version,
2327: l_api_name,
2328: G_PKG_NAME ) THEN

Line 2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2325: l_api_version,
2326: p_api_version,
2327: l_api_name,
2328: G_PKG_NAME ) THEN
2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2330: END IF;
2331:
2332: -- Initialize message list if p_init_msg_list is set to TRUE
2333: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2333: IF FND_API.to_Boolean(p_init_msg_list) THEN

2329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2330: END IF;
2331:
2332: -- Initialize message list if p_init_msg_list is set to TRUE
2333: IF FND_API.to_Boolean(p_init_msg_list) THEN
2334: FND_MSG_PUB.initialize;
2335: END IF;
2336:
2337: -- Initiliaze API return status to success

Line 2338: x_return_status := FND_API.G_RET_STS_SUCCESS;

2334: FND_MSG_PUB.initialize;
2335: END IF;
2336:
2337: -- Initiliaze API return status to success
2338: x_return_status := FND_API.G_RET_STS_SUCCESS;
2339:
2340:
2341: IF(p_from_organization_id IS NULL OR
2342: p_to_organization_id IS NULL OR

Line 2347: RAISE fnd_api.g_exc_error;

2343: p_from_cost_type_id IS NULL OR
2344: p_to_cost_type_id IS NULL OR
2345: p_group_id IS NULL ) THEN
2346:
2347: RAISE fnd_api.g_exc_error;
2348: END IF;
2349:
2350: /* ***** intitialize all the codes values to NULL **** */
2351: l_material_subelement_code := NULL;

Line 2811: RAISE fnd_api.g_exc_error ;

2807: l_api_message := 'At Least One required Default Subelement is missing';
2808: FND_MESSAGE.set_name('BOM', 'CST_API_MESSAGE');
2809: FND_MESSAGE.set_token('TEXT', l_api_message);
2810: fnd_msg_pub.add;
2811: RAISE fnd_api.g_exc_error ;
2812: END IF;
2813:
2814:
2815: l_statement := 130;

Line 2822: IF FND_API.to_Boolean(p_commit) THEN

2818:
2819: l_statement := 140;
2820:
2821: -- Standard check of p_commit
2822: IF FND_API.to_Boolean(p_commit) THEN
2823: COMMIT WORK;
2824: END IF;
2825:
2826:

Line 2837: WHEN fnd_api.g_exc_error THEN

2833:
2834:
2835:
2836: EXCEPTION
2837: WHEN fnd_api.g_exc_error THEN
2838: x_return_status := fnd_api.g_ret_sts_error;
2839:
2840: -- Get message count and data
2841: fnd_msg_pub.count_and_get

Line 2838: x_return_status := fnd_api.g_ret_sts_error;

2834:
2835:
2836: EXCEPTION
2837: WHEN fnd_api.g_exc_error THEN
2838: x_return_status := fnd_api.g_ret_sts_error;
2839:
2840: -- Get message count and data
2841: fnd_msg_pub.count_and_get
2842: ( p_count => x_msg_count

Line 2846: WHEN fnd_api.g_exc_unexpected_error THEN

2842: ( p_count => x_msg_count
2843: , p_data => x_msg_data
2844: );
2845: --
2846: WHEN fnd_api.g_exc_unexpected_error THEN
2847: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2848:
2849: -- Get message count and data
2850: fnd_msg_pub.count_and_get

Line 2847: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2843: , p_data => x_msg_data
2844: );
2845: --
2846: WHEN fnd_api.g_exc_unexpected_error THEN
2847: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2848:
2849: -- Get message count and data
2850: fnd_msg_pub.count_and_get
2851: ( p_count => x_msg_count

Line 2856: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2852: , p_data => x_msg_data
2853: );
2854: --
2855: WHEN OTHERS THEN
2856: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2857: --
2858: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2859: THEN
2860: fnd_msg_pub.add_exc_msg