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.CN_ACC_PERIODS_PVT dependencies on FND_API

Line 110: RAISE fnd_api.g_exc_unexpected_error;

106: -- get current working org ID
107: l_org_id := mo_global.get_current_org_id;
108: IF l_org_id IS NULL THEN
109: -- org ID is not set... raise error
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;
112:
113: fnd_file.put_line(fnd_file.Log, 'start open period');
114:

Line 131: p_init_msg_list => fnd_api.g_true,

127: fnd_file.put_line(fnd_file.Log, 'open acc periods');
128:
129: update_acc_periods
130: (p_api_version => 1.0,
131: p_init_msg_list => fnd_api.g_true,
132: p_org_id => l_org_id,
133: p_acc_period_tbl => l_acc_period_tbl,
134: x_return_status => x_return_status,
135: x_msg_count => x_msg_count,

Line 138: IF x_return_status <> fnd_api.g_ret_sts_success THEN

134: x_return_status => x_return_status,
135: x_msg_count => x_msg_count,
136: x_msg_data => x_msg_data);
137:
138: IF x_return_status <> fnd_api.g_ret_sts_success THEN
139: RAISE fnd_api.g_exc_error;
140: END IF;
141:
142: fnd_file.put_line(fnd_file.Log, 'start request');

Line 139: RAISE fnd_api.g_exc_error;

135: x_msg_count => x_msg_count,
136: x_msg_data => x_msg_data);
137:
138: IF x_return_status <> fnd_api.g_ret_sts_success THEN
139: RAISE fnd_api.g_exc_error;
140: END IF;
141:
142: fnd_file.put_line(fnd_file.Log, 'start request');
143:

Line 148: RAISE fnd_api.g_exc_unexpected_error;

144: -- submit concurrent program
145: start_request(l_org_id, l_request_id);
146:
147: IF l_request_id = 0 THEN
148: RAISE fnd_api.g_exc_unexpected_error;
149: END IF;
150:
151: COMMIT;
152: EXCEPTION

Line 160: p_encoded => FND_API.G_FALSE);

156: -- capture messages
157: l_msgs := '';
158: FOR l_counter IN 1..x_msg_count LOOP
159: my_message := FND_MSG_PUB.get(p_msg_index => l_counter,
160: p_encoded => FND_API.G_FALSE);
161: fnd_file.put_line(fnd_file.Log, my_message);
162: l_msgs := l_msgs || my_message || ' ';
163: end loop;
164: errbuf := l_msgs;

Line 193: -- Default = FND_API.G_FALSE

189: -- Pre-reqs : None.
190: -- Parameters :
191: -- IN : p_api_version IN NUMBER Required
192: -- p_init_msg_list IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_commit IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional
197: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 195: -- Default = FND_API.G_FALSE

191: -- IN : p_api_version IN NUMBER Required
192: -- p_init_msg_list IN VARCHAR2 Optional
193: -- Default = FND_API.G_FALSE
194: -- p_commit IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional
197: -- Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_acc_period_tbl IN acc_period_tbl_type Required
199: -- Default = null

Line 197: -- Default = FND_API.G_VALID_LEVEL_FULL

193: -- Default = FND_API.G_FALSE
194: -- p_commit IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional
197: -- Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_acc_period_tbl IN acc_period_tbl_type Required
199: -- Default = null
200: -- IN p_org_id IN NUMBER Required
201: -- OUT : x_return_status OUT VARCHAR2(1)

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

211: -- End of comments
212:
213: PROCEDURE Update_Acc_Periods
214: (p_api_version IN NUMBER ,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_acc_period_tbl IN acc_period_tbl_type ,
219: p_org_id IN NUMBER,

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

212:
213: PROCEDURE Update_Acc_Periods
214: (p_api_version IN NUMBER ,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_acc_period_tbl IN acc_period_tbl_type ,
219: p_org_id IN NUMBER,
220: x_return_status OUT NOCOPY VARCHAR2 ,

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

213: PROCEDURE Update_Acc_Periods
214: (p_api_version IN NUMBER ,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
216: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: p_acc_period_tbl IN acc_period_tbl_type ,
219: p_org_id IN NUMBER,
220: x_return_status OUT NOCOPY VARCHAR2 ,
221: x_msg_count OUT NOCOPY NUMBER ,

Line 357: IF NOT FND_API.Compatible_API_Call

353:
354:
355: BEGIN
356: -- Standard call to check for call compatibility.
357: IF NOT FND_API.Compatible_API_Call
358: (l_api_version ,
359: p_api_version ,
360: l_api_name ,
361: G_PKG_NAME )

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: p_api_version ,
360: l_api_name ,
361: G_PKG_NAME )
362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.to_Boolean( p_init_msg_list ) THEN
367: FND_MSG_PUB.initialize;

Line 366: IF FND_API.to_Boolean( p_init_msg_list ) THEN

362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365: -- Initialize message list if p_init_msg_list is set to TRUE.
366: IF FND_API.to_Boolean( p_init_msg_list ) THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369: -- Initialize API return status to success
370: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 370: x_return_status := FND_API.G_RET_STS_SUCCESS;

366: IF FND_API.to_Boolean( p_init_msg_list ) THEN
367: FND_MSG_PUB.initialize;
368: END IF;
369: -- Initialize API return status to success
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371:
372: -- API body
373: UPDATE cn_repositories
374: SET status = 'A'

Line 397: RAISE fnd_api.g_exc_unexpected_error;

393: -- CLOSE period_info;
394: IF l_org_id <> p_org_id THEN
395: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
396: fnd_msg_pub.add;
397: RAISE fnd_api.g_exc_unexpected_error;
398: END IF;
399: -- CLOSE period_info;
400:
401: IF (l_object_version_number <> p_acc_period_tbl(i).object_version_number) THEN

Line 404: RAISE fnd_api.g_exc_unexpected_error;

400:
401: IF (l_object_version_number <> p_acc_period_tbl(i).object_version_number) THEN
402: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
403: fnd_msg_pub.add;
404: RAISE fnd_api.g_exc_unexpected_error;
405: END IF;
406:
407: l_closing_status := get_closing_status(p_acc_period_tbl(i).closing_status_meaning);
408: IF l_closing_status = 'X' THEN

Line 482: RAISE fnd_api.g_exc_error;

478: /* commented out for bug 5035044
479: IF (l_quarter_num NOT IN (1, 2, 3, 4)) THEN
480: fnd_message.set_name('CN', 'CNSYPR_QUARTER_NUMBER');
481: fnd_msg_pub.add;
482: RAISE fnd_api.g_exc_error;
483: END IF;
484: */
485:
486: IF (l_closing_status = 'O' AND l_closing_status_old <> 'O' ) THEN

Line 490: RAISE fnd_api.g_exc_error;

486: IF (l_closing_status = 'O' AND l_closing_status_old <> 'O' ) THEN
487: IF (l_closing_status_old = 'P') THEN
488: fnd_message.set_name('CN', 'CNSYPR_OPEN_PERIOD');
489: fnd_msg_pub.add;
490: RAISE fnd_api.g_exc_error;
491: END IF;
492:
493: -- can not open a period whose previous period is Never Opened
494: IF (l_pre_status = 'N') THEN

Line 497: RAISE fnd_api.g_exc_error;

493: -- can not open a period whose previous period is Never Opened
494: IF (l_pre_status = 'N') THEN
495: fnd_message.set_name('CN', 'CNSYPR_OPEN_PRE_NEVER');
496: fnd_msg_pub.add;
497: RAISE fnd_api.g_exc_error;
498: -- can not open a period whose previous period is Future Enterable
499: elsif (l_pre_status = 'F') then
500: fnd_message.set_name('CN', 'CNSYPR_OPEN_PRE_FUTURE');
501: fnd_msg_pub.add;

Line 502: raise fnd_api.g_exc_error;

498: -- can not open a period whose previous period is Future Enterable
499: elsif (l_pre_status = 'F') then
500: fnd_message.set_name('CN', 'CNSYPR_OPEN_PRE_FUTURE');
501: fnd_msg_pub.add;
502: raise fnd_api.g_exc_error;
503:
504: -- can not open a period whose next period is Closed or Permanently Closed
505: elsif (l_next_status IN ('P', 'C')) then
506: fnd_message.set_name('CN', 'CNSYPR_OPEN_NEXT_CLOSE');

Line 508: raise fnd_api.g_exc_error;

504: -- can not open a period whose next period is Closed or Permanently Closed
505: elsif (l_next_status IN ('P', 'C')) then
506: fnd_message.set_name('CN', 'CNSYPR_OPEN_NEXT_CLOSE');
507: fnd_msg_pub.add;
508: raise fnd_api.g_exc_error;
509: end if;
510: END IF;
511:
512: IF ((l_closing_status = 'C' AND l_closing_status_old <> 'C') OR (l_closing_status = 'P' AND l_closing_status_old <> 'P')) THEN

Line 516: -- RAISE fnd_api.g_exc_error;

512: IF ((l_closing_status = 'C' AND l_closing_status_old <> 'C') OR (l_closing_status = 'P' AND l_closing_status_old <> 'P')) THEN
513: --IF ((l_closing_status = 'C' AND l_closing_status_old <> 'O') OR (l_closing_status = 'P' AND l_closing_status_old NOT IN ('O', 'C'))) THEN
514: -- fnd_message.set_name('CN', 'CN_CLOSE_PERIOD');
515: -- fnd_msg_pub.add;
516: -- RAISE fnd_api.g_exc_error;
517: --END IF;
518:
519: -- can not close/permanently close a period whose previous period is not closed
520: -- Note: when a period is open, it is impossible for its previous period to be Never Opened or Future Entry

Line 524: raise fnd_api.g_exc_error;

520: -- Note: when a period is open, it is impossible for its previous period to be Never Opened or Future Entry
521: if (l_pre_status = 'O') then
522: fnd_message.set_name('CN', 'CNSYPR_CLOSE_PRE_OPEN');
523: fnd_msg_pub.add;
524: raise fnd_api.g_exc_error;
525: END IF;
526: END IF;
527:
528: IF (l_closing_status = 'F' AND l_closing_status_old <> 'F') THEN

Line 532: RAISE fnd_api.g_exc_error;

528: IF (l_closing_status = 'F' AND l_closing_status_old <> 'F') THEN
529: IF (l_closing_status_old <> 'N') THEN
530: fnd_message.set_name('CN', 'CNSYPR_FUTURE_ENTERABLE');
531: fnd_msg_pub.add;
532: RAISE fnd_api.g_exc_error;
533: END IF;
534:
535: -- can not set a period to F whose previous period is Never Opened
536: if (l_pre_status = 'N') then

Line 539: raise fnd_api.g_exc_error;

535: -- can not set a period to F whose previous period is Never Opened
536: if (l_pre_status = 'N') then
537: fnd_message.set_name('CN', 'CNSYPR_FUTURE_PRE_NEVER');
538: fnd_msg_pub.add;
539: raise fnd_api.g_exc_error;
540: END IF;
541: END IF;
542:
543: cn_periods_api.update_gl_status(p_org_id, -- MOAC Change

Line 597: -- RAISE FND_API.g_exc_unexpected_error;

593: -- ,start_time => NULL
594: -- ,sub_request => NULL);
595: --
596: -- IF l_request_id = 0 THEN
597: -- RAISE FND_API.g_exc_unexpected_error;
598: -- END IF;
599: -- END IF;
600:
601: -- End of API body.

Line 604: IF FND_API.To_Boolean( p_commit ) THEN

600:
601: -- End of API body.
602:
603: -- Standard check of p_commit.
604: IF FND_API.To_Boolean( p_commit ) THEN
605: COMMIT WORK;
606: END IF;
607: -- Standard call to get message count and if count is 1, get message info.
608: FND_MSG_PUB.count_and_get

Line 611: p_encoded => FND_API.G_FALSE );

607: -- Standard call to get message count and if count is 1, get message info.
608: FND_MSG_PUB.count_and_get
609: (p_count => x_msg_count ,
610: p_data => x_msg_data ,
611: p_encoded => FND_API.G_FALSE );
612: EXCEPTION
613: WHEN FND_API.G_EXC_ERROR THEN
614: x_return_status := FND_API.G_RET_STS_ERROR ;
615: FND_MSG_PUB.count_and_get

Line 613: WHEN FND_API.G_EXC_ERROR THEN

609: (p_count => x_msg_count ,
610: p_data => x_msg_data ,
611: p_encoded => FND_API.G_FALSE );
612: EXCEPTION
613: WHEN FND_API.G_EXC_ERROR THEN
614: x_return_status := FND_API.G_RET_STS_ERROR ;
615: FND_MSG_PUB.count_and_get
616: (p_count => x_msg_count ,
617: p_data => x_msg_data ,

Line 614: x_return_status := FND_API.G_RET_STS_ERROR ;

610: p_data => x_msg_data ,
611: p_encoded => FND_API.G_FALSE );
612: EXCEPTION
613: WHEN FND_API.G_EXC_ERROR THEN
614: x_return_status := FND_API.G_RET_STS_ERROR ;
615: FND_MSG_PUB.count_and_get
616: (p_count => x_msg_count ,
617: p_data => x_msg_data ,
618: p_encoded => FND_API.G_FALSE );

Line 618: p_encoded => FND_API.G_FALSE );

614: x_return_status := FND_API.G_RET_STS_ERROR ;
615: FND_MSG_PUB.count_and_get
616: (p_count => x_msg_count ,
617: p_data => x_msg_data ,
618: p_encoded => FND_API.G_FALSE );
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
621: FND_MSG_PUB.count_and_get
622: (p_count => x_msg_count ,

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: FND_MSG_PUB.count_and_get
616: (p_count => x_msg_count ,
617: p_data => x_msg_data ,
618: p_encoded => FND_API.G_FALSE );
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
621: FND_MSG_PUB.count_and_get
622: (p_count => x_msg_count ,
623: p_data => x_msg_data ,

Line 620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

616: (p_count => x_msg_count ,
617: p_data => x_msg_data ,
618: p_encoded => FND_API.G_FALSE );
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
621: FND_MSG_PUB.count_and_get
622: (p_count => x_msg_count ,
623: p_data => x_msg_data ,
624: p_encoded => FND_API.G_FALSE );

Line 624: p_encoded => FND_API.G_FALSE );

620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
621: FND_MSG_PUB.count_and_get
622: (p_count => x_msg_count ,
623: p_data => x_msg_data ,
624: p_encoded => FND_API.G_FALSE );
625: WHEN OTHERS THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: IF FND_MSG_PUB.check_msg_level
628: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

622: (p_count => x_msg_count ,
623: p_data => x_msg_data ,
624: p_encoded => FND_API.G_FALSE );
625: WHEN OTHERS THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: IF FND_MSG_PUB.check_msg_level
628: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: FND_MSG_PUB.add_exc_msg

Line 637: p_encoded => FND_API.G_FALSE );

633: END IF;
634: FND_MSG_PUB.count_and_get
635: (p_count => x_msg_count ,
636: p_data => x_msg_data ,
637: p_encoded => FND_API.G_FALSE );
638: END update_acc_periods;
639:
640: -- populate the accumulation periods screen
641: PROCEDURE get_acc_periods