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_RECEIPTACCRUALPEREND_PVT dependencies on FND_API

Line 94: l_return_status := FND_API.G_RET_STS_SUCCESS;

90: -- Initialize message list.
91: FND_MSG_PUB.initialize;
92:
93: -- Initialize API return status to success
94: l_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: -------------------------------------------------------------------------
97: -- Get system set-up information e.g. set_of_books, chart_of_accounts
98: -- purchase_encumbrance_flag etc.

Line 103: p_init_msg_list => FND_API.G_FALSE,

99: -------------------------------------------------------------------------
100: l_stmt_num := 20;
101: Get_SystemSetup (
102: p_api_version => 1.0,
103: p_init_msg_list => FND_API.G_FALSE,
104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
105: x_return_status => l_return_status,
106: x_msg_count => l_msg_count,
107: x_msg_data => l_msg_data,

Line 104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

100: l_stmt_num := 20;
101: Get_SystemSetup (
102: p_api_version => 1.0,
103: p_init_msg_list => FND_API.G_FALSE,
104: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
105: x_return_status => l_return_status,
106: x_msg_count => l_msg_count,
107: x_msg_data => l_msg_data,
108: p_period_name => p_period_name,

Line 112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

108: p_period_name => p_period_name,
109: x_sys_setup_rec => l_sys_setup_rec
110: );
111: -- If return status is not success, add message to the log
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
113: l_msg_data := 'Failed getting system setup' ;
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: );
111: -- If return status is not success, add message to the log
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
113: l_msg_data := 'Failed getting system setup' ;
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: -------------------------------------------------------------------------
118: -- Call the common API CST_PerEndAccruals_PVT.Create_PerEndAccruals()

Line 125: p_init_msg_list => FND_API.G_FALSE,

121: -------------------------------------------------------------------------
122: l_stmt_num := 40;
123: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
124: p_api_version => 1.0,
125: p_init_msg_list => FND_API.G_FALSE,
126: p_commit => FND_API.G_FALSE,
127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
128: x_return_status => l_return_status,
129: x_msg_count => l_msg_count,

Line 126: p_commit => FND_API.G_FALSE,

122: l_stmt_num := 40;
123: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
124: p_api_version => 1.0,
125: p_init_msg_list => FND_API.G_FALSE,
126: p_commit => FND_API.G_FALSE,
127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
128: x_return_status => l_return_status,
129: x_msg_count => l_msg_count,
130: x_msg_data => l_msg_data,

Line 127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

123: CST_PerEndAccruals_PVT.Create_PerEndAccruals (
124: p_api_version => 1.0,
125: p_init_msg_list => FND_API.G_FALSE,
126: p_commit => FND_API.G_FALSE,
127: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
128: x_return_status => l_return_status,
129: x_msg_count => l_msg_count,
130: x_msg_data => l_msg_data,
131: p_min_accrual_amount => p_min_accrual_amount,

Line 141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

137: p_closed_pos => 'N',
138: p_calling_api => CST_PerEndAccruals_PVT.G_RECEIPT_ACCRUAL_PER_END
139: );
140: -- If return status is not success, add message to the log
141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
142: l_msg_data := 'Failed generating Period End Accrual information';
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: );
140: -- If return status is not success, add message to the log
141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
142: l_msg_data := 'Failed generating Period End Accrual information';
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: -------------------------------------------------------------------------
147: -- Create events in RCV_ACCOUNTING_EVENTS

Line 152: p_init_msg_list => FND_API.G_FALSE,

148: -------------------------------------------------------------------------
149: l_stmt_num := 50;
150: Seed_RcvAccountingEvents (
151: p_api_version => 1.0,
152: p_init_msg_list => FND_API.G_FALSE,
153: p_commit => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,

Line 153: p_commit => FND_API.G_FALSE,

149: l_stmt_num := 50;
150: Seed_RcvAccountingEvents (
151: p_api_version => 1.0,
152: p_init_msg_list => FND_API.G_FALSE,
153: p_commit => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data,

Line 154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

150: Seed_RcvAccountingEvents (
151: p_api_version => 1.0,
152: p_init_msg_list => FND_API.G_FALSE,
153: p_commit => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data,
158: p_sys_setup_rec => l_sys_setup_rec

Line 161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

157: x_msg_data => l_msg_data,
158: p_sys_setup_rec => l_sys_setup_rec
159: );
160: -- If return status is not success, add message to the log
161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
162: l_msg_data := 'Failed creating event in RCV_ACCOUNTING_EVENTS' ;
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: );
160: -- If return status is not success, add message to the log
161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
162: l_msg_data := 'Failed creating event in RCV_ACCOUNTING_EVENTS' ;
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: -------------------------------------------------------------------------
167: -- Create accounting entries in RCV_RECEIVING_SUB_LEDGER

Line 172: p_init_msg_list => FND_API.G_FALSE,

168: -------------------------------------------------------------------------
169: l_stmt_num := 60;
170: Create_AccrualAccount (
171: p_api_version => 1.0,
172: p_init_msg_list => FND_API.G_FALSE,
173: p_commit => FND_API.G_FALSE,
174: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,

Line 173: p_commit => FND_API.G_FALSE,

169: l_stmt_num := 60;
170: Create_AccrualAccount (
171: p_api_version => 1.0,
172: p_init_msg_list => FND_API.G_FALSE,
173: p_commit => FND_API.G_FALSE,
174: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,
177: x_msg_data => l_msg_data,

Line 174: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

170: Create_AccrualAccount (
171: p_api_version => 1.0,
172: p_init_msg_list => FND_API.G_FALSE,
173: p_commit => FND_API.G_FALSE,
174: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
175: x_return_status => l_return_status,
176: x_msg_count => l_msg_count,
177: x_msg_data => l_msg_data,
178: p_sys_setup_rec => l_sys_setup_rec

Line 181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

177: x_msg_data => l_msg_data,
178: p_sys_setup_rec => l_sys_setup_rec
179: );
180: -- If return status is not success, add message to the log
181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
182: l_msg_data := 'Failed creating Period End Accrual entries ' ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: );
180: -- If return status is not success, add message to the log
181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
182: l_msg_data := 'Failed creating Period End Accrual entries ' ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: -------------------------------------------------------------------------
187: -- Update the Accrued PO distribution, and mark accrued_flag as 'Y'

Line 208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

204: x_return_status => l_return_status
205: );
206:
207: -- If return status is not success, add message to the log
208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
209: l_msg_data := 'Failed writing log messages' ;
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206:
207: -- If return status is not success, add message to the log
208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
209: l_msg_data := 'Failed writing log messages' ;
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: -- Procedure level log message for exit point
214: IF (l_pLog) THEN

Line 225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

221:
222: COMMIT WORK;
223:
224: EXCEPTION
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO Start_Process_PVT;
227:
228: IF (l_exceptionLog) THEN
229: FND_LOG.STRING(

Line 362: IF NOT FND_API.Compatible_API_Call ( l_api_version,

358: 'Insert_AccrualSubLedger <<');
359: END IF;
360:
361: -- Standard call to check for call compatibility.
362: IF NOT FND_API.Compatible_API_Call ( l_api_version,
363: p_api_version,
364: l_api_name,
365: G_PKG_NAME )
366: THEN

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: p_api_version,
364: l_api_name,
365: G_PKG_NAME )
366: THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369:
370: -- Initialize message list if p_init_msg_list is set to TRUE.
371: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 371: IF FND_API.to_Boolean( p_init_msg_list ) THEN

367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369:
370: -- Initialize message list if p_init_msg_list is set to TRUE.
371: IF FND_API.to_Boolean( p_init_msg_list ) THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374:
375: -- Initialize API return status to success

Line 376: x_return_status := FND_API.G_RET_STS_SUCCESS;

372: FND_MSG_PUB.initialize;
373: END IF;
374:
375: -- Initialize API return status to success
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377: l_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: l_stmt_num := 10;
380: l_user_id := FND_GLOBAL.USER_ID;

Line 377: l_return_status := FND_API.G_RET_STS_SUCCESS;

373: END IF;
374:
375: -- Initialize API return status to success
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377: l_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: l_stmt_num := 10;
380: l_user_id := FND_GLOBAL.USER_ID;
381: l_login_id := FND_GLOBAL.LOGIN_ID;

Line 672: IF FND_API.To_Boolean( p_commit ) THEN

668: p_data => x_msg_data
669: );
670:
671: -- Standard check of p_commit.
672: IF FND_API.To_Boolean( p_commit ) THEN
673: COMMIT WORK;
674: END IF;
675:
676: EXCEPTION

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: END IF;
675:
676: EXCEPTION
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO Seed_RcvAccountingEvents_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681:
682: IF (l_exceptionLog) THEN

Line 680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

676: EXCEPTION
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO Seed_RcvAccountingEvents_PVT;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681:
682: IF (l_exceptionLog) THEN
683: FND_LOG.STRING(
684: FND_LOG.LEVEL_EXCEPTION,

Line 697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

693: );
694:
695: WHEN OTHERS THEN
696: ROLLBACK TO Seed_RcvAccountingEvents_PVT;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698:
699: -- Unexpected level log message
700: IF (l_uLog) THEN
701: FND_LOG.STRING(

Line 844: IF NOT FND_API.Compatible_API_Call ( l_api_version,

840: 'Create_AccrualAccount <<');
841: END IF;
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call ( l_api_version,
845: p_api_version,
846: l_api_name,
847: G_PKG_NAME )
848: THEN

Line 849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

845: p_api_version,
846: l_api_name,
847: G_PKG_NAME )
848: THEN
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END IF;
851:
852: -- Initialize message list if p_init_msg_list is set to TRUE.
853: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 853: IF FND_API.to_Boolean( p_init_msg_list ) THEN

849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END IF;
851:
852: -- Initialize message list if p_init_msg_list is set to TRUE.
853: IF FND_API.to_Boolean( p_init_msg_list ) THEN
854: FND_MSG_PUB.initialize;
855: END IF;
856:
857: -- Initialize API return status to success

Line 858: x_return_status := FND_API.G_RET_STS_SUCCESS;

854: FND_MSG_PUB.initialize;
855: END IF;
856:
857: -- Initialize API return status to success
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859: l_return_status := FND_API.G_RET_STS_SUCCESS;
860:
861: l_func_currency_code := p_sys_setup_rec.functional_currency_code;
862:

Line 859: l_return_status := FND_API.G_RET_STS_SUCCESS;

855: END IF;
856:
857: -- Initialize API return status to success
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859: l_return_status := FND_API.G_RET_STS_SUCCESS;
860:
861: l_func_currency_code := p_sys_setup_rec.functional_currency_code;
862:
863: -- Loop for each row of accrual cursor

Line 912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

908: l_accrual_info_rec.parent_rcv_acc_event_id := NULL;
909: ELSE
910: l_msg_data := 'Failed getting corresponding RCV_ACCOUNTING_EVENT_ID for distribution_id :'
911: || l_accrual_rec.distribution_id;
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914:
915: -- Populate the accrual_info_rec record
916: l_stmt_num := 70;

Line 965: p_init_msg_list => FND_API.G_FALSE,

961: -- Add a new row to the PL/SQL tables for the accrual_info_rec
962: l_stmt_num := 90;
963: Insert_Account (
964: p_api_version => 1.0,
965: p_init_msg_list => FND_API.G_FALSE,
966: p_commit => FND_API.G_FALSE,
967: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
968: x_return_status => l_return_status,
969: x_msg_count => x_msg_count,

Line 966: p_commit => FND_API.G_FALSE,

962: l_stmt_num := 90;
963: Insert_Account (
964: p_api_version => 1.0,
965: p_init_msg_list => FND_API.G_FALSE,
966: p_commit => FND_API.G_FALSE,
967: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
968: x_return_status => l_return_status,
969: x_msg_count => x_msg_count,
970: x_msg_data => x_msg_data,

Line 967: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

963: Insert_Account (
964: p_api_version => 1.0,
965: p_init_msg_list => FND_API.G_FALSE,
966: p_commit => FND_API.G_FALSE,
967: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
968: x_return_status => l_return_status,
969: x_msg_count => x_msg_count,
970: x_msg_data => x_msg_data,
971: p_accrual_info_rec => l_accrual_info_rec,

Line 975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

971: p_accrual_info_rec => l_accrual_info_rec,
972: p_sys_setup_rec => p_sys_setup_rec
973: );
974: -- If return status is not success, add message to the log
975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
976: l_msg_data := 'Failed inserting data in Accrual table';
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978: END IF;
979:

Line 977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

973: );
974: -- If return status is not success, add message to the log
975: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
976: l_msg_data := 'Failed inserting data in Accrual table';
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978: END IF;
979:
980: END IF;
981:

Line 1013: p_init_msg_list => FND_API.G_FALSE,

1009: -- Add a new row to the PL/SQL tables for the accrual_info_rec
1010: l_stmt_num := 110;
1011: Insert_Account (
1012: p_api_version => 1.0,
1013: p_init_msg_list => FND_API.G_FALSE,
1014: p_commit => FND_API.G_FALSE,
1015: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1016: x_return_status => l_return_status,
1017: x_msg_count => x_msg_count,

Line 1014: p_commit => FND_API.G_FALSE,

1010: l_stmt_num := 110;
1011: Insert_Account (
1012: p_api_version => 1.0,
1013: p_init_msg_list => FND_API.G_FALSE,
1014: p_commit => FND_API.G_FALSE,
1015: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1016: x_return_status => l_return_status,
1017: x_msg_count => x_msg_count,
1018: x_msg_data => x_msg_data,

Line 1015: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1011: Insert_Account (
1012: p_api_version => 1.0,
1013: p_init_msg_list => FND_API.G_FALSE,
1014: p_commit => FND_API.G_FALSE,
1015: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1016: x_return_status => l_return_status,
1017: x_msg_count => x_msg_count,
1018: x_msg_data => x_msg_data,
1019: p_accrual_info_rec => l_accrual_info_rec,

Line 1023: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1019: p_accrual_info_rec => l_accrual_info_rec,
1020: p_sys_setup_rec => p_sys_setup_rec
1021: );
1022: -- If return status is not success, add message to the log
1023: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1024: l_msg_data := 'Failed inserting data in Accrual table';
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027:

Line 1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1021: );
1022: -- If return status is not success, add message to the log
1023: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1024: l_msg_data := 'Failed inserting data in Accrual table';
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027:
1028: END IF;
1029:

Line 1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1045: ELSE
1046:
1047: l_msg_data := 'Failed getting corresponding RCV_ACCOUNTING_EVENT_ID for distribution_id :'
1048: || l_accrual_rec.distribution_id;
1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1050:
1051: END IF;
1052:
1053: l_accrual_info_rec.code_combination_id := l_accrual_rec.enc_credit_ccid;

Line 1085: p_init_msg_list => FND_API.G_FALSE,

1081: -- corresponding to the encumbrance reversals
1082: l_stmt_num := 140;
1083: Insert_Account (
1084: p_api_version => 1.0,
1085: p_init_msg_list => FND_API.G_FALSE,
1086: p_commit => FND_API.G_FALSE,
1087: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1088: x_return_status => l_return_status,
1089: x_msg_count => x_msg_count,

Line 1086: p_commit => FND_API.G_FALSE,

1082: l_stmt_num := 140;
1083: Insert_Account (
1084: p_api_version => 1.0,
1085: p_init_msg_list => FND_API.G_FALSE,
1086: p_commit => FND_API.G_FALSE,
1087: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1088: x_return_status => l_return_status,
1089: x_msg_count => x_msg_count,
1090: x_msg_data => x_msg_data,

Line 1087: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1083: Insert_Account (
1084: p_api_version => 1.0,
1085: p_init_msg_list => FND_API.G_FALSE,
1086: p_commit => FND_API.G_FALSE,
1087: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1088: x_return_status => l_return_status,
1089: x_msg_count => x_msg_count,
1090: x_msg_data => x_msg_data,
1091: p_accrual_info_rec => l_accrual_info_rec,

Line 1095: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1091: p_accrual_info_rec => l_accrual_info_rec,
1092: p_sys_setup_rec => p_sys_setup_rec
1093: );
1094: -- If return status is not success, add message to the log
1095: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1096: l_msg_data := 'Failed inserting data in Accrual table';
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099:

Line 1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1093: );
1094: -- If return status is not success, add message to the log
1095: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1096: l_msg_data := 'Failed inserting data in Accrual table';
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099:
1100: END IF;
1101:

Line 1110: p_init_msg_list => FND_API.G_FALSE,

1106: -------------------------------------------------------------------------
1107: l_stmt_num := 160;
1108: Insert_AccrualSubLedger (
1109: p_api_version => 1.0,
1110: p_init_msg_list => FND_API.G_FALSE,
1111: p_commit => FND_API.G_FALSE,
1112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1113: x_return_status => l_return_status,
1114: x_msg_count => x_msg_count,

Line 1111: p_commit => FND_API.G_FALSE,

1107: l_stmt_num := 160;
1108: Insert_AccrualSubLedger (
1109: p_api_version => 1.0,
1110: p_init_msg_list => FND_API.G_FALSE,
1111: p_commit => FND_API.G_FALSE,
1112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1113: x_return_status => l_return_status,
1114: x_msg_count => x_msg_count,
1115: x_msg_data => x_msg_data,

Line 1112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1108: Insert_AccrualSubLedger (
1109: p_api_version => 1.0,
1110: p_init_msg_list => FND_API.G_FALSE,
1111: p_commit => FND_API.G_FALSE,
1112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1113: x_return_status => l_return_status,
1114: x_msg_count => x_msg_count,
1115: x_msg_data => x_msg_data,
1116: p_sys_setup_rec => p_sys_setup_rec

Line 1119: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1115: x_msg_data => x_msg_data,
1116: p_sys_setup_rec => p_sys_setup_rec
1117: );
1118: -- If return status is not success, add message to the log
1119: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1120: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:

Line 1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1117: );
1118: -- If return status is not success, add message to the log
1119: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1120: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:
1124: IF (g_counter = 0) THEN
1125: GOTO END_PROCEDURE;

Line 1221: IF FND_API.To_Boolean( p_commit ) THEN

1217: p_data => x_msg_data
1218: );
1219:
1220: -- Standard check of p_commit.
1221: IF FND_API.To_Boolean( p_commit ) THEN
1222: COMMIT WORK;
1223: END IF;
1224:
1225: EXCEPTION

Line 1227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1223: END IF;
1224:
1225: EXCEPTION
1226:
1227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1228: ROLLBACK TO Create_AccrualAccount_PVT;
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1230:
1231: IF (l_exceptionLog) THEN

Line 1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1225: EXCEPTION
1226:
1227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1228: ROLLBACK TO Create_AccrualAccount_PVT;
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1230:
1231: IF (l_exceptionLog) THEN
1232: FND_LOG.STRING(
1233: FND_LOG.LEVEL_EXCEPTION,

Line 1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1242: );
1243:
1244: WHEN OTHERS THEN
1245: ROLLBACK TO Create_AccrualAccount_PVT;
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: -- Unexpected level log message
1249: IF (l_uLog) THEN
1250: FND_LOG.STRING(

Line 1324: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1320: 'Insert_Account <<');
1321: END IF;
1322:
1323: -- Standard call to check for call compatibility.
1324: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1325: p_api_version,
1326: l_api_name,
1327: G_PKG_NAME )
1328: THEN

Line 1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1325: p_api_version,
1326: l_api_name,
1327: G_PKG_NAME )
1328: THEN
1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1330: END IF;
1331:
1332: -- Initialize message list if p_init_msg_list is set to TRUE.
1333: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1333: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1330: END IF;
1331:
1332: -- Initialize message list if p_init_msg_list is set to TRUE.
1333: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1334: FND_MSG_PUB.initialize;
1335: END IF;
1336:
1337: -- Initialize API return status to success

Line 1338: x_return_status := FND_API.G_RET_STS_SUCCESS;

1334: FND_MSG_PUB.initialize;
1335: END IF;
1336:
1337: -- Initialize API return status to success
1338: x_return_status := FND_API.G_RET_STS_SUCCESS;
1339: l_return_status := FND_API.G_RET_STS_SUCCESS;
1340:
1341: -- Get the position of the new row to be added
1342: g_counter := g_distribution_id_tbl.COUNT + 1;

Line 1339: l_return_status := FND_API.G_RET_STS_SUCCESS;

1335: END IF;
1336:
1337: -- Initialize API return status to success
1338: x_return_status := FND_API.G_RET_STS_SUCCESS;
1339: l_return_status := FND_API.G_RET_STS_SUCCESS;
1340:
1341: -- Get the position of the new row to be added
1342: g_counter := g_distribution_id_tbl.COUNT + 1;
1343:

Line 1386: p_init_msg_list => FND_API.G_FALSE,

1382: -------------------------------------------------------------------------
1383: l_stmt_num := 40;
1384: Insert_AccrualSubLedger (
1385: p_api_version => 1.0,
1386: p_init_msg_list => FND_API.G_FALSE,
1387: p_commit => FND_API.G_FALSE,
1388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1389: x_return_status => l_return_status,
1390: x_msg_count => x_msg_count,

Line 1387: p_commit => FND_API.G_FALSE,

1383: l_stmt_num := 40;
1384: Insert_AccrualSubLedger (
1385: p_api_version => 1.0,
1386: p_init_msg_list => FND_API.G_FALSE,
1387: p_commit => FND_API.G_FALSE,
1388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1389: x_return_status => l_return_status,
1390: x_msg_count => x_msg_count,
1391: x_msg_data => x_msg_data,

Line 1388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1384: Insert_AccrualSubLedger (
1385: p_api_version => 1.0,
1386: p_init_msg_list => FND_API.G_FALSE,
1387: p_commit => FND_API.G_FALSE,
1388: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1389: x_return_status => l_return_status,
1390: x_msg_count => x_msg_count,
1391: x_msg_data => x_msg_data,
1392: p_sys_setup_rec => p_sys_setup_rec

Line 1395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1391: x_msg_data => x_msg_data,
1392: p_sys_setup_rec => p_sys_setup_rec
1393: );
1394: -- If return status is not success, add message to the log
1395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1396: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399:

Line 1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1393: );
1394: -- If return status is not success, add message to the log
1395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1396: l_msg_data := 'Failed inserting data in RCV_RECEIVING_SUB_LEDGER';
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399:
1400: END IF;
1401:

Line 1418: IF FND_API.To_Boolean( p_commit ) THEN

1414: p_data => x_msg_data
1415: );
1416:
1417: -- Standard check of p_commit.
1418: IF FND_API.To_Boolean( p_commit ) THEN
1419: COMMIT WORK;
1420: END IF;
1421:
1422: EXCEPTION

Line 1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1420: END IF;
1421:
1422: EXCEPTION
1423:
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: ROLLBACK TO Insert_Account_PVT;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427:
1428: IF (l_exceptionLog) THEN

Line 1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1422: EXCEPTION
1423:
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: ROLLBACK TO Insert_Account_PVT;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427:
1428: IF (l_exceptionLog) THEN
1429: FND_LOG.STRING(
1430: FND_LOG.LEVEL_EXCEPTION,

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1439: );
1440:
1441: WHEN OTHERS THEN
1442: ROLLBACK TO Insert_Account_PVT;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444:
1445: -- Unexpected level log message
1446: IF (l_uLog) THEN
1447: FND_LOG.STRING(

Line 1523: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1519: 'Insert_AccrualSubLedger <<');
1520: END IF;
1521:
1522: -- Standard call to check for call compatibility.
1523: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1524: p_api_version,
1525: l_api_name,
1526: G_PKG_NAME )
1527: THEN

Line 1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1524: p_api_version,
1525: l_api_name,
1526: G_PKG_NAME )
1527: THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;
1530:
1531: -- Initialize message list if p_init_msg_list is set to TRUE.
1532: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1532: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;
1530:
1531: -- Initialize message list if p_init_msg_list is set to TRUE.
1532: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1533: FND_MSG_PUB.initialize;
1534: END IF;
1535:
1536: -- Initialize API return status to success

Line 1537: x_return_status := FND_API.G_RET_STS_SUCCESS;

1533: FND_MSG_PUB.initialize;
1534: END IF;
1535:
1536: -- Initialize API return status to success
1537: x_return_status := FND_API.G_RET_STS_SUCCESS;
1538: l_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: l_stmt_num := 10;
1541: l_user_id := FND_GLOBAL.USER_ID;

Line 1538: l_return_status := FND_API.G_RET_STS_SUCCESS;

1534: END IF;
1535:
1536: -- Initialize API return status to success
1537: x_return_status := FND_API.G_RET_STS_SUCCESS;
1538: l_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: l_stmt_num := 10;
1541: l_user_id := FND_GLOBAL.USER_ID;
1542: l_login_id := FND_GLOBAL.LOGIN_ID;

Line 1673: IF FND_API.To_Boolean( p_commit ) THEN

1669: p_data => x_msg_data
1670: );
1671:
1672: -- Standard check of p_commit.
1673: IF FND_API.To_Boolean( p_commit ) THEN
1674: COMMIT WORK;
1675: END IF;
1676:
1677: EXCEPTION

Line 1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1675: END IF;
1676:
1677: EXCEPTION
1678:
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: ROLLBACK TO Insert_AccrualSubLedger_PVT;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1682:
1683: IF (l_exceptionLog) THEN

Line 1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1677: EXCEPTION
1678:
1679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1680: ROLLBACK TO Insert_AccrualSubLedger_PVT;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1682:
1683: IF (l_exceptionLog) THEN
1684: FND_LOG.STRING(
1685: FND_LOG.LEVEL_EXCEPTION,

Line 1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1694: );
1695:
1696: WHEN OTHERS THEN
1697: ROLLBACK TO Insert_AccrualSubLedger_PVT;
1698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1699:
1700: -- Unexpected level log message
1701: IF (l_uLog) THEN
1702: FND_LOG.STRING(

Line 1785: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1781: 'p_period_name =' || p_period_name);
1782: END IF;
1783:
1784: -- Standard call to check for call compatibility.
1785: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1786: p_api_version,
1787: l_api_name,
1788: G_PKG_NAME )
1789: THEN

Line 1790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1786: p_api_version,
1787: l_api_name,
1788: G_PKG_NAME )
1789: THEN
1790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1791: END IF;
1792:
1793: -- Initialize message list if p_init_msg_list is set to TRUE.
1794: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1794: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1791: END IF;
1792:
1793: -- Initialize message list if p_init_msg_list is set to TRUE.
1794: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1795: FND_MSG_PUB.initialize;
1796: END IF;
1797:
1798: -- Initialize API return status to success

Line 1799: x_return_status := FND_API.G_RET_STS_SUCCESS;

1795: FND_MSG_PUB.initialize;
1796: END IF;
1797:
1798: -- Initialize API return status to success
1799: x_return_status := FND_API.G_RET_STS_SUCCESS;
1800: l_return_status := FND_API.G_RET_STS_SUCCESS;
1801:
1802: -- Check whether GL is installed
1803: l_stmt_num := 20;

Line 1800: l_return_status := FND_API.G_RET_STS_SUCCESS;

1796: END IF;
1797:
1798: -- Initialize API return status to success
1799: x_return_status := FND_API.G_RET_STS_SUCCESS;
1800: l_return_status := FND_API.G_RET_STS_SUCCESS;
1801:
1802: -- Check whether GL is installed
1803: l_stmt_num := 20;
1804: l_gl_installed := FND_INSTALLATION.GET_APP_INFO ( 'SQLGL',

Line 1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1904: p_data => x_msg_data
1905: );
1906:
1907: EXCEPTION
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO Get_SystemSetup_PVT;
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1911:
1912: IF (l_exceptionLog) THEN

Line 1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1906:
1907: EXCEPTION
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO Get_SystemSetup_PVT;
1910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1911:
1912: IF (l_exceptionLog) THEN
1913: FND_LOG.STRING(
1914: FND_LOG.LEVEL_EXCEPTION,

Line 1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1923: );
1924:
1925: WHEN OTHERS THEN
1926: ROLLBACK TO Get_SystemSetup_PVT;
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1928:
1929: -- Unexpected level log message
1930: IF (l_uLog) THEN
1931: FND_LOG.STRING(