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

Line 123: IF NOT FND_API.Compatible_API_Call

119:
120: IF G_DEBUG_HIGH_ON THEN
121: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');
122: END IF;
123: IF NOT FND_API.Compatible_API_Call
124: (l_api_version_number
125: ,p_api_version_number
126: ,l_api_name
127: ,G_PKG_NAME

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: ,l_api_name
127: ,G_PKG_NAME
128: )
129: THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132:
133: -- get account from the fund
134: IF p_budget_id is not null OR

Line 135: p_budget_id <> FND_API.G_MISS_NUM

131: END IF;
132:
133: -- get account from the fund
134: IF p_budget_id is not null OR
135: p_budget_id <> FND_API.G_MISS_NUM
136: THEN
137: -- get default accounts from system parameters
138: OPEN get_sys_param_csr(p_budget_id);
139: FETCH get_sys_param_csr INTO l_expense_account,

Line 179: x_return_status := FND_API.g_ret_sts_error;

175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
176: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_ACC_LIAB_ACCT');
177: FND_MSG_PUB.add;
178: END IF;
179: x_return_status := FND_API.g_ret_sts_error;
180: ELSE
181: l_post_account := l_fund_accrual_liability;
182: END IF;
183: ELSIF p_account_type = 'EXPENSE ACCOUNT' THEN

Line 189: x_return_status := FND_API.g_ret_sts_error;

185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
186: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_EXP_ACCT');
187: FND_MSG_PUB.add;
188: END IF;
189: x_return_status := FND_API.g_ret_sts_error;
190: ELSE
191: l_post_account := l_fund_expense_account;
192: END IF;
193: ELSIF p_account_type = 'VEN_CLEARING' THEN

Line 199: x_return_status := FND_API.g_ret_sts_error;

195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
196: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_VEN_CLEAR_ACCT');
197: FND_MSG_PUB.add;
198: END IF;
199: x_return_status := FND_API.g_ret_sts_error;
200: ELSE
201: l_post_account := l_ven_clearing;
202: END IF;
203: ELSIF p_account_type = 'REC_CLEARING' THEN

Line 209: x_return_status := FND_API.g_ret_sts_error;

205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
206: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_REC_CLEAR_ACCT');
207: FND_MSG_PUB.add;
208: END IF;
209: x_return_status := FND_API.g_ret_sts_error;
210: ELSE
211: l_post_account := l_rec_clearing;
212: END IF;
213: ELSE

Line 242: x_return_status := FND_API.g_ret_sts_error;

238: END IF;
239: FND_MSG_PUB.Count_And_Get
240: (p_count => x_msg_count,
241: p_data => x_msg_data);
242: x_return_status := FND_API.g_ret_sts_error;
243: RETURN l_post_account;
244: WHEN FND_API.G_EXC_ERROR THEN
245: l_post_account := 0;
246: -- Standard call to get message count and if count=1, get the message

Line 244: WHEN FND_API.G_EXC_ERROR THEN

240: (p_count => x_msg_count,
241: p_data => x_msg_data);
242: x_return_status := FND_API.g_ret_sts_error;
243: RETURN l_post_account;
244: WHEN FND_API.G_EXC_ERROR THEN
245: l_post_account := 0;
246: -- Standard call to get message count and if count=1, get the message
247: FND_MSG_PUB.Count_And_Get (
248: p_encoded => FND_API.G_FALSE,

Line 248: p_encoded => FND_API.G_FALSE,

244: WHEN FND_API.G_EXC_ERROR THEN
245: l_post_account := 0;
246: -- Standard call to get message count and if count=1, get the message
247: FND_MSG_PUB.Count_And_Get (
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: x_return_status := FND_API.g_ret_sts_error;
252: RETURN l_post_account;

Line 251: x_return_status := FND_API.g_ret_sts_error;

247: FND_MSG_PUB.Count_And_Get (
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: x_return_status := FND_API.g_ret_sts_error;
252: RETURN l_post_account;
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: l_post_account := 0;
255: -- Standard call to get message count and if count=1, get the message

Line 253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

249: p_count => x_msg_count,
250: p_data => x_msg_data);
251: x_return_status := FND_API.g_ret_sts_error;
252: RETURN l_post_account;
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: l_post_account := 0;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,

Line 257: p_encoded => FND_API.G_FALSE,

253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: l_post_account := 0;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data);
260: x_return_status := FND_API.g_ret_sts_unexp_error;
261: RETURN l_post_account;

Line 260: x_return_status := FND_API.g_ret_sts_unexp_error;

256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data);
260: x_return_status := FND_API.g_ret_sts_unexp_error;
261: RETURN l_post_account;
262: WHEN OTHERS THEN
263: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 269: p_encoded => FND_API.G_FALSE,

265: END IF;
266: l_post_account := 0;
267: -- Standard call to get message count and if count=1, get the message
268: FND_MSG_PUB.Count_And_Get (
269: p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count,
271: p_data => x_msg_data);
272: RETURN l_post_account;
273: END gl_post_account;

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

279: | 'Sales Expense Account' |
280: +===========================================================================*/
281: PROCEDURE Start_Process (
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285:
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,

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

280: +===========================================================================*/
281: PROCEDURE Start_Process (
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285:
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,

Line 408: IF NOT FND_API.Compatible_API_Call

404: BEGIN
405: IF G_DEBUG_HIGH_ON THEN
406: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_full_name || ' START');
407: END IF;
408: IF NOT FND_API.Compatible_API_Call
409: (l_api_version_number
410: ,p_api_version_number
411: ,l_api_name
412: ,G_PKG_NAME

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: ,l_api_name
412: ,G_PKG_NAME
413: )
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: --Initialize message list if p_init_msg_list is TRUE.
418: IF FND_API.To_Boolean (p_init_msg_list) THEN
419: FND_MSG_PUB.initialize;

Line 418: IF FND_API.To_Boolean (p_init_msg_list) THEN

414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: --Initialize message list if p_init_msg_list is TRUE.
418: IF FND_API.To_Boolean (p_init_msg_list) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421: -- Initialize API return status to sucess
422: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: IF FND_API.To_Boolean (p_init_msg_list) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421: -- Initialize API return status to sucess
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: IF G_DEBUG_HIGH_ON THEN
425: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
426: END IF;

Line 428: IF p_budget_id <> FND_API.G_MISS_NUM OR

424: IF G_DEBUG_HIGH_ON THEN
425: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
426: END IF;
427: /* get org id */
428: IF p_budget_id <> FND_API.G_MISS_NUM OR
429: p_budget_id IS NOT NULL
430: THEN
431: OPEN budget_org_csr(p_budget_id);
432: FETCH budget_org_csr INTO l_org_id;

Line 446: RAISE FND_API.G_EXC_ERROR;

442: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
443: FND_MESSAGE.SET_NAME('OZF','OZF_GL_CHART_OF_ACCT_MISSING');
444: FND_MESSAGE.SET_TOKEN('BUDGET',p_budget_id);
445: END IF;
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: /* This will retrieve the account_id for gl_posting purposes*/
450: l_account_id := gl_post_account(p_api_version_number => 1.0,

Line 456: IF x_return_status = FND_API.g_ret_sts_error THEN

452: p_budget_id => p_budget_id,
453: x_msg_count => x_msg_count,
454: x_msg_data => x_msg_data,
455: x_return_status => x_return_status);
456: IF x_return_status = FND_API.g_ret_sts_error THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;

Line 457: RAISE FND_API.G_EXC_ERROR;

453: x_msg_count => x_msg_count,
454: x_msg_data => x_msg_data,
455: x_return_status => x_return_status);
456: IF x_return_status = FND_API.g_ret_sts_error THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:

Line 458: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

454: x_msg_data => x_msg_data,
455: x_return_status => x_return_status);
456: IF x_return_status = FND_API.g_ret_sts_error THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: -- call account generator workflow to get the cost of sale account

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455: x_return_status => x_return_status);
456: IF x_return_status = FND_API.g_ret_sts_error THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: -- call account generator workflow to get the cost of sale account
463: -- get order header/line details from price adjustment

Line 464: IF p_price_adj_id <> FND_API.G_MISS_NUM OR

460: END IF;
461:
462: -- call account generator workflow to get the cost of sale account
463: -- get order header/line details from price adjustment
464: IF p_price_adj_id <> FND_API.G_MISS_NUM OR
465: p_price_adj_id IS NOT NULL
466: THEN
467:
468: --kdass 16-Aug-07 bug 6345327 - for third party utilizations, do not pass line_id and header_id

Line 495: IF l_line_id <> FND_API.G_MISS_NUM OR

491: END IF;
492: END IF;
493:
494: -- line id is found -- Accruals at Order Line level
495: IF l_line_id <> FND_API.G_MISS_NUM OR
496: l_line_id IS NOT NULL
497: THEN
498: IF G_DEBUG_HIGH_ON THEN
499: OZF_UTILITY_PVT.debug_message('Checking Order Category');

Line 533: RAISE FND_API.G_EXC_ERROR;

529: FND_MESSAGE.SET_NAME('OZF','OZF_GL_HEADER_DETAIL_MISSING');
530: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
531: FND_MSG_PUB.ADD;
532: END IF;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:
536: IF l_ship_from_org_id IS NULL THEN
537: -- 19-JUL-2004 yizhang: bill only orders do not have ship from org

Line 544: RAISE FND_API.G_EXC_ERROR;

540: FND_MESSAGE.SET_NAME('OZF','OZF_WAREHOUSE_MISSING');
541: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
542: FND_MSG_PUB.ADD;
543: END IF;
544: RAISE FND_API.G_EXC_ERROR;
545: */
546: l_ship_from_org_id := l_org_id;
547: END IF;
548:

Line 566: ELSIF l_header_id <> FND_API.G_MISS_NUM OR

562: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;
563: CLOSE chart_of_acct_csr;
564:
565: -- line is null and header is found -- Accruals at Order header level
566: ELSIF l_header_id <> FND_API.G_MISS_NUM OR
567: l_header_id IS NOT NULL
568: THEN
569: IF G_DEBUG_HIGH_ON THEN
570: OZF_UTILITY_PVT.debug_message('Retreiving Header');

Line 611: ELSIF p_item_id <> FND_API.G_MISS_NUM OR

607: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;
608: CLOSE chart_of_acct_csr;
609:
610: -- line id and header is null and item id passed -- Lumpsums
611: ELSIF p_item_id <> FND_API.G_MISS_NUM OR
612: p_item_id is not null
613: THEN
614: IF p_item_type = 'PRODUCT' THEN
615: -- set the inventory item id

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: IF l_result THEN
781: IF G_DEBUG_HIGH_ON THEN
782: OZF_UTILITY_PVT.debug_message('Success OZFACCTG WF'||'-'||x_return_ccid);
783: END IF;
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: ELSE
786: IF l_debug_flag = 'Y' THEN
787: IF G_DEBUG_HIGH_ON THEN
788: OZF_UTILITY_PVT.debug_message('Returning Default on Error'||'-'||l_account_id);

Line 791: x_return_status := FND_API.G_RET_STS_SUCCESS;

787: IF G_DEBUG_HIGH_ON THEN
788: OZF_UTILITY_PVT.debug_message('Returning Default on Error'||'-'||l_account_id);
789: END IF;
790: x_return_ccid := l_account_id;
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792: ELSE
793: IF G_DEBUG_HIGH_ON THEN
794: OZF_UTILITY_PVT.debug_message('Error in OZFACCTG WF'||'-'||x_return_ccid);
795: END IF;

Line 800: x_return_status := FND_API.G_RET_STS_ERROR;

796: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
797: FND_MESSAGE.SET_NAME('OZF','OZF_GL_ACC_GEN_FAILED');
798: FND_MSG_PUB.ADD;
799: END IF;
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: END IF;
802: END IF;
803:
804: IF G_DEBUG_HIGH_ON THEN

Line 809: p_encoded => FND_API.G_FALSE,

805: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');
806: END IF;
807: --Standard call to get message count and if count=1, get the message
808: FND_MSG_PUB.Count_And_Get (
809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data
812: );
813: EXCEPTION

Line 815: x_return_status := FND_API.G_RET_STS_ERROR;

811: p_data => x_msg_data
812: );
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.SET_NAME('OZF','OZF_COGS_NOT_FOUND');
818: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
819: FND_MSG_PUB.ADD;

Line 822: p_encoded => FND_API.G_FALSE,

818: FND_MESSAGE.SET_TOKEN('LINE_ID',l_line_id);
819: FND_MSG_PUB.ADD;
820: END IF;
821: FND_MSG_PUB.Count_And_Get (
822: p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data
825: );
826: WHEN FND_API.G_EXC_ERROR THEN

Line 826: WHEN FND_API.G_EXC_ERROR THEN

822: p_encoded => FND_API.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data
825: );
826: WHEN FND_API.G_EXC_ERROR THEN
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,

Line 827: x_return_status := FND_API.G_RET_STS_ERROR;

823: p_count => x_msg_count,
824: p_data => x_msg_data
825: );
826: WHEN FND_API.G_EXC_ERROR THEN
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,
831: p_count => x_msg_count,

Line 830: p_encoded => FND_API.G_FALSE,

826: WHEN FND_API.G_EXC_ERROR THEN
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: -- Standard call to get message count and if count=1, get the message
829: FND_MSG_PUB.Count_And_Get (
830: p_encoded => FND_API.G_FALSE,
831: p_count => x_msg_count,
832: p_data => x_msg_data
833: );
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: p_encoded => FND_API.G_FALSE,
831: p_count => x_msg_count,
832: p_data => x_msg_data
833: );
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,

Line 835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

831: p_count => x_msg_count,
832: p_data => x_msg_data
833: );
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,

Line 838: p_encoded => FND_API.G_FALSE,

834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: -- Standard call to get message count and if count=1, get the message
837: FND_MSG_PUB.Count_And_Get (
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: WHEN OTHERS THEN

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

839: p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842: WHEN OTHERS THEN
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
845: THEN
846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;

Line 850: p_encoded => FND_API.G_FALSE,

846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;
848: -- Standard call to get message count and if count=1, get the message
849: FND_MSG_PUB.Count_And_Get (
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: END Start_Process; /* START_PROCESS */