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

Line 127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

123: l_api_name CONSTANT VARCHAR2(30) := 'Match_RevenueCOGS';
124: l_api_version CONSTANT NUMBER := 1.0;
125: l_api_message VARCHAR2(1000);
126:
127: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
128: l_dummy_status VARCHAR2(1); /* not sure why AR needs this, hopefully can remove it ... */
129: l_msg_count NUMBER := 0;
130: l_msg_data VARCHAR2(8000) := '';
131: l_stmt_num NUMBER := 0;

Line 177: IF NOT FND_API.Compatible_API_Call (

173: debug(' p_ledger_id : '|| p_ledger_id);
174: debug(' p_neg_req_id: '|| p_neg_req_id);
175:
176: -- Standard call to check for call compatibility
177: IF NOT FND_API.Compatible_API_Call (
178: l_api_version,
179: p_api_version,
180: l_api_name,
181: G_PKG_NAME ) THEN

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: l_api_version,
179: p_api_version,
180: l_api_name,
181: G_PKG_NAME ) THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184:
185: -- Initialize message list if p_init_msg_list is set to TRUE
186: FND_MSG_PUB.initialize;

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

185: -- Initialize message list if p_init_msg_list is set to TRUE
186: FND_MSG_PUB.initialize;
187:
188: -- Initialize API return status to success
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:
191: -- API Body
192:
193: -- Populate WHO column variables

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

250: p_pgm_app_id => l_pgm_app_id,
251: p_pgm_id => l_pgm_id,
252: x_return_status => l_return_status);
253:
254: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
255: IF l_errorLog THEN
256: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
257: END IF;
258: raise program_exception;

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

266: p_pgm_app_id => l_pgm_app_id,
267: p_pgm_id => l_pgm_id,
268: x_return_status => l_return_status);
269:
270: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
271: IF l_errorLog THEN
272: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
273: END IF;
274: raise program_exception;

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

334: x_msg_count => l_msg_count,
335: x_msg_data => l_msg_data
336: );
337:
338: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
339: IF l_errorLog THEN
340: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
341: END IF;
342: raise program_exception;

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: -- with potentially_unmatched_flag = 'Y'. This column is a histogram, so we
412: -- need to gather stats before running phase 3, which relies heavily on this
413: -- column.
414: IF NOT FND_INSTALLATION.GET_APP_INFO('BOM', l_status, l_industry, l_schema) THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418:
419: --{BUG#10627578

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

456: x_return_status => l_return_status,
457: p_ledger_id => p_ledger_id -- BUG#5726230
458: ,p_neg_req_id => p_neg_req_id); -- BUG#7387575
459:
460: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
461: IF l_errorLog THEN
462: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
463: END IF;
464: raise program_exception;

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

502: x_return_status => l_return_status,
503: p_ledger_id => p_ledger_id --BUG5726230
504: ,p_neg_req_id => p_neg_req_id);--BUG7387575
505:
506: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
507: IF l_errorLog THEN
508: FND_LOG.string(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,substr(SQLERRM,1,250));
509: END IF;
510: raise program_exception;

Line 540: x_return_status := fnd_api.G_RET_STS_ERROR;

536:
537: EXCEPTION
538: WHEN already_running THEN
539: FND_FILE.PUT_LINE(FND_FILE.LOG, x_out_msg);
540: x_return_status := fnd_api.G_RET_STS_ERROR;
541:
542: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_module||' failed to complete.');
543:
544: Print_MessageStack;

Line 547: x_return_status := fnd_api.g_ret_sts_error;

543:
544: Print_MessageStack;
545:
546: WHEN program_exception THEN
547: x_return_status := fnd_api.g_ret_sts_error;
548:
549: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
550: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
551: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

Line 581: x_return_status := fnd_api.g_ret_sts_unexp_error ;

577: Print_MessageStack;
578:
579: WHEN OTHERS THEN
580:
581: x_return_status := fnd_api.g_ret_sts_unexp_error ;
582:
583: IF l_unexpLog THEN
584: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
585: ,substrb(SQLERRM,1,250));

Line 639: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

635:
636: l_api_name CONSTANT VARCHAR2(30) := 'Insert_SoIssues';
637: l_api_message VARCHAR2(100);
638: l_stmt_num NUMBER := 0;
639: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
640:
641: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
642: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
643: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736: );
737: END IF;
738:
739: -- Initialize return values
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742: -- API Body
743:
744: debug(' g_ledger_id : '||g_ledger_id);

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

767: p_cost_group_id => cv_so_issues.cost_group_id,
768: p_quantity => cv_so_issues.quantity
769: );
770:
771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := fnd_api.g_ret_sts_error;
773: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
774: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
775: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));

Line 772: x_return_status := fnd_api.g_ret_sts_error;

768: p_quantity => cv_so_issues.quantity
769: );
770:
771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := fnd_api.g_ret_sts_error;
773: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
774: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
775: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 806: x_return_status := fnd_api.g_ret_sts_unexp_error ;

802: EXCEPTION
803:
804: WHEN OTHERS THEN
805: ROLLBACK TO Insert_SoIssues_PVT;
806: x_return_status := fnd_api.g_ret_sts_unexp_error ;
807:
808: IF l_unexpLog THEN
809: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
810: ,'Insert_SoIssues ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));

Line 1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

1034:
1035: l_stmt_num := 0;
1036:
1037: -- Initialize return values
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- API Body
1041:
1042: l_last_fetch := FALSE; -- initialize boolean variable

Line 1446: x_return_status := fnd_api.g_ret_sts_error;

1442: x_error_code => l_error_code,
1443: x_error_message => l_error_message);
1444:
1445: IF (l_return_num <> 0) THEN
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1448: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1449: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1484: x_return_status := fnd_api.g_ret_sts_error;

1480: debug('Insert_RmaReceipts-');
1481: EXCEPTION
1482: WHEN program_exception THEN
1483: ROLLBACK TO Insert_RmaReceipts_PVT;
1484: x_return_status := fnd_api.g_ret_sts_error;
1485:
1486: WHEN OTHERS THEN
1487: ROLLBACK TO Insert_RmaReceipts_PVT;
1488: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 1488: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1484: x_return_status := fnd_api.g_ret_sts_error;
1485:
1486: WHEN OTHERS THEN
1487: ROLLBACK TO Insert_RmaReceipts_PVT;
1488: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1489:
1490: IF l_unexpLog THEN
1491: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
1492: ,'Insert_RmaReceipts ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));

Line 1540: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1536: ) IS
1537:
1538: l_api_name CONSTANT VARCHAR2(30) := 'Create_CogsRecognitionEvents';
1539: l_api_message VARCHAR2(1000);
1540: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1541: l_stmt_num NUMBER := 0;
1542:
1543: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1544: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 1735: x_return_status := FND_API.G_RET_STS_SUCCESS;

1731:
1732: debug(' p_ledger_id :'||p_ledger_id);
1733:
1734: -- Initialize return values
1735: x_return_status := FND_API.G_RET_STS_SUCCESS;
1736:
1737: -- Populate offset for each organization that might be affected
1738:
1739: l_dummy_date := sysdate;

Line 1748: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1744:
1745: -- ER 10030862
1746: check_eligible_lines(p_ledger_id, x_return_status,l_error_message);
1747:
1748: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1749: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_message);
1750: RAISE program_exception;
1751: END IF;
1752:

Line 2387: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2383: ensure_mmt_per_and_date(x_return_status => l_return_status,
2384: x_msg_count => l_msg_count,
2385: x_msg_data => l_error_message);
2386:
2387: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2388: debug(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num));
2389: raise program_exception;
2390: END IF;
2391: --}

Line 2403: x_return_status := fnd_api.g_ret_sts_error;

2399: x_error_code => l_error_code,
2400: x_error_message => l_error_message);
2401:
2402: IF (l_return_num <> 0) THEN
2403: x_return_status := fnd_api.g_ret_sts_error;
2404: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2405: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2406: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2506: x_return_status := FND_API.G_RET_STS_SUCCESS;

2502: EXCEPTION
2503: WHEN end_of_program THEN
2504: ROLLBACK TO Create_CogsRecEvents_PVT;
2505: -- Let the program end normally
2506: x_return_status := FND_API.G_RET_STS_SUCCESS;
2507: debug('EXCEPTION end_of_program Create_CogsRecognitionEvents '||l_stmt_num||' : no ledger found - p_ledger_id :'||p_ledger_id);
2508:
2509: WHEN no_crrl THEN
2510: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2510: x_return_status := FND_API.G_RET_STS_SUCCESS;

2506: x_return_status := FND_API.G_RET_STS_SUCCESS;
2507: debug('EXCEPTION end_of_program Create_CogsRecognitionEvents '||l_stmt_num||' : no ledger found - p_ledger_id :'||p_ledger_id);
2508:
2509: WHEN no_crrl THEN
2510: x_return_status := FND_API.G_RET_STS_SUCCESS;
2511: debug('EXCEPTION no_crrl for COGS to match to Revenue Create_CogsRecognitionEvents '||l_stmt_num||' : no CRRL found - p_ledger_id :'||p_ledger_id);
2512:
2513: WHEN program_exception THEN
2514: ROLLBACK TO Create_CogsRecEvents_PVT;

Line 2515: x_return_status := fnd_api.g_ret_sts_error;

2511: debug('EXCEPTION no_crrl for COGS to match to Revenue Create_CogsRecognitionEvents '||l_stmt_num||' : no CRRL found - p_ledger_id :'||p_ledger_id);
2512:
2513: WHEN program_exception THEN
2514: ROLLBACK TO Create_CogsRecEvents_PVT;
2515: x_return_status := fnd_api.g_ret_sts_error;
2516: FND_FILE.put_line(fnd_file.log, 'program_exception EXCEPTION IN Create_CogsRecognitionEvents');
2517:
2518: WHEN OTHERS THEN
2519: ROLLBACK TO Create_CogsRecEvents_PVT;

Line 2520: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2516: FND_FILE.put_line(fnd_file.log, 'program_exception EXCEPTION IN Create_CogsRecognitionEvents');
2517:
2518: WHEN OTHERS THEN
2519: ROLLBACK TO Create_CogsRecEvents_PVT;
2520: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2521:
2522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2523: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2524: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

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

2569: -----------------------------------------------------------------------------
2570:
2571: PROCEDURE Insert_OneSoIssue(
2572: p_api_version IN NUMBER,
2573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2574: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2576: p_user_id IN NUMBER,
2577: p_login_id IN NUMBER,

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

2570:
2571: PROCEDURE Insert_OneSoIssue(
2572: p_api_version IN NUMBER,
2573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2574: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2576: p_user_id IN NUMBER,
2577: p_login_id IN NUMBER,
2578: p_request_id IN NUMBER,

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

2571: PROCEDURE Insert_OneSoIssue(
2572: p_api_version IN NUMBER,
2573: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2574: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2575: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2576: p_user_id IN NUMBER,
2577: p_login_id IN NUMBER,
2578: p_request_id IN NUMBER,
2579: p_pgm_app_id IN NUMBER,

Line 2596: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2592:
2593: l_api_name CONSTANT VARCHAR2(30) := 'Insert_OneSoIssue';
2594: l_api_message VARCHAR2(1000);
2595: l_api_version CONSTANT NUMBER := 1.0;
2596: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2597: l_msg_count NUMBER := 0;
2598: l_msg_data VARCHAR2(8000) := '';
2599: l_stmt_num NUMBER := 0;
2600:

Line 2636: IF NOT FND_API.Compatible_API_Call (

2632: l_stmt_num := 0;
2633: debug(l_stmt_num);
2634:
2635: -- Standard call to check for call compatibility
2636: IF NOT FND_API.Compatible_API_Call (
2637: l_api_version,
2638: p_api_version,
2639: l_api_name,
2640: G_PKG_NAME ) THEN

Line 2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2637: l_api_version,
2638: p_api_version,
2639: l_api_name,
2640: G_PKG_NAME ) THEN
2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2642: END IF;
2643:
2644: -- Initialize message list if p_init_msg_list is set to TRUE
2645: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2645: IF FND_API.to_Boolean(p_init_msg_list) THEN

2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2642: END IF;
2643:
2644: -- Initialize message list if p_init_msg_list is set to TRUE
2645: IF FND_API.to_Boolean(p_init_msg_list) THEN
2646: FND_MSG_PUB.initialize;
2647: END IF;
2648:
2649: -- Initialize API return status to success

Line 2650: x_return_status := FND_API.G_RET_STS_SUCCESS;

2646: FND_MSG_PUB.initialize;
2647: END IF;
2648:
2649: -- Initialize API return status to success
2650: x_return_status := FND_API.G_RET_STS_SUCCESS;
2651:
2652: -- API Body
2653:
2654: -- initialize

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

2675: x_return_status => l_return_status,
2676: x_msg_count => l_msg_count,
2677: x_msg_data => l_msg_data);
2678:
2679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2680: FND_MESSAGE.set_name('BOM', 'CST_NO_REVENUE_OM_LINE');
2681: FND_MESSAGE.set_token('COGS_LINE_ID', to_char(p_cogs_om_line_id));
2682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2683: FND_MSG_PUB.ADD;

Line 2844: x_return_status := fnd_api.g_ret_sts_error;

2840:
2841: EXCEPTION
2842: WHEN program_exception THEN
2843: ROLLBACK TO Insert_OneSoIssue_PVT; /*Bug 7384398*/
2844: x_return_status := fnd_api.g_ret_sts_error;
2845: WHEN OTHERS THEN
2846: ROLLBACK TO Insert_OneSoIssue_PVT;
2847: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2848:

Line 2847: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2843: ROLLBACK TO Insert_OneSoIssue_PVT; /*Bug 7384398*/
2844: x_return_status := fnd_api.g_ret_sts_error;
2845: WHEN OTHERS THEN
2846: ROLLBACK TO Insert_OneSoIssue_PVT;
2847: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2848:
2849: IF l_unexpLog THEN
2850: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2851: ,'Insert_OneSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));

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

2892: -----------------------------------------------------------------------------
2893:
2894: PROCEDURE Insert_OneRmaReceipt(
2895: p_api_version IN NUMBER,
2896: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2897: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2898: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2899: p_user_id IN NUMBER,
2900: p_login_id IN NUMBER,

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

2893:
2894: PROCEDURE Insert_OneRmaReceipt(
2895: p_api_version IN NUMBER,
2896: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2897: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2898: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2899: p_user_id IN NUMBER,
2900: p_login_id IN NUMBER,
2901: p_request_id IN NUMBER,

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

2894: PROCEDURE Insert_OneRmaReceipt(
2895: p_api_version IN NUMBER,
2896: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2897: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2898: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2899: p_user_id IN NUMBER,
2900: p_login_id IN NUMBER,
2901: p_request_id IN NUMBER,
2902: p_pgm_app_id IN NUMBER,

Line 2961: IF NOT FND_API.Compatible_API_Call (

2957: l_stmt_num := 0;
2958: debug(l_stmt_num);
2959:
2960: -- Standard call to check for call compatibility
2961: IF NOT FND_API.Compatible_API_Call (
2962: l_api_version,
2963: p_api_version,
2964: l_api_name,
2965: G_PKG_NAME ) THEN

Line 2966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2962: l_api_version,
2963: p_api_version,
2964: l_api_name,
2965: G_PKG_NAME ) THEN
2966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2967: END IF;
2968:
2969: -- Initialize message list if p_init_msg_list is set to TRUE
2970: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2970: IF FND_API.to_Boolean(p_init_msg_list) THEN

2966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2967: END IF;
2968:
2969: -- Initialize message list if p_init_msg_list is set to TRUE
2970: IF FND_API.to_Boolean(p_init_msg_list) THEN
2971: FND_MSG_PUB.initialize;
2972: END IF;
2973:
2974: -- Initialize API return status to success

Line 2975: x_return_status := FND_API.G_RET_STS_SUCCESS;

2971: FND_MSG_PUB.initialize;
2972: END IF;
2973:
2974: -- Initialize API return status to success
2975: x_return_status := FND_API.G_RET_STS_SUCCESS;
2976: x_msg_count := 0;
2977: x_msg_data := '';
2978:
2979:

Line 3350: x_return_status := fnd_api.g_ret_sts_error;

3346: x_error_code => l_error_code,
3347: x_error_message => l_error_message);
3348:
3349: IF (l_return_num <> 0) THEN
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3352: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3353: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3354: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3394: x_return_status := fnd_api.g_ret_sts_error;

3390: debug('Insert_OneRmaReceipt-');
3391: EXCEPTION
3392: WHEN program_exception THEN
3393: ROLLBACK TO Insert_OneRmaReceipt_PVT;
3394: x_return_status := fnd_api.g_ret_sts_error;
3395: WHEN OTHERS THEN
3396: ROLLBACK TO Insert_OneRmaReceipt_PVT;
3397: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3398:

Line 3397: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3393: ROLLBACK TO Insert_OneRmaReceipt_PVT;
3394: x_return_status := fnd_api.g_ret_sts_error;
3395: WHEN OTHERS THEN
3396: ROLLBACK TO Insert_OneRmaReceipt_PVT;
3397: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3398:
3399: IF l_unexpLog THEN
3400: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3401: ,'Insert_OneRmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));

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

3445: -----------------------------------------------------------------------------
3446:
3447: PROCEDURE Record_SoIssueCost(
3448: p_api_version IN NUMBER,
3449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3450: p_user_id IN NUMBER,
3451: p_login_id IN NUMBER,
3452: p_request_id IN NUMBER,
3453: p_pgm_app_id IN NUMBER,

Line 3474: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3470: l_api_message VARCHAR2(1000);
3471: l_stmt_num NUMBER := 0;
3472: l_api_version CONSTANT NUMBER := 1.0;
3473:
3474: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3475:
3476: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
3477: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
3478: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

Line 3507: IF NOT FND_API.Compatible_API_Call (

3503: );
3504: END IF;
3505:
3506: -- Standard call to check for call compatibility
3507: IF NOT FND_API.Compatible_API_Call (
3508: l_api_version,
3509: p_api_version,
3510: l_api_name,
3511: G_PKG_NAME ) THEN

Line 3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3508: l_api_version,
3509: p_api_version,
3510: l_api_name,
3511: G_PKG_NAME ) THEN
3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3513: END IF;
3514:
3515: -- Initialize message list if p_init_msg_list is set to TRUE
3516: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3516: IF FND_API.to_Boolean(p_init_msg_list) THEN

3512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3513: END IF;
3514:
3515: -- Initialize message list if p_init_msg_list is set to TRUE
3516: IF FND_API.to_Boolean(p_init_msg_list) THEN
3517: FND_MSG_PUB.initialize;
3518: END IF;
3519:
3520: -- Initialize API return status to success

Line 3521: x_return_status := FND_API.G_RET_STS_SUCCESS;

3517: FND_MSG_PUB.initialize;
3518: END IF;
3519:
3520: -- Initialize API return status to success
3521: x_return_status := FND_API.G_RET_STS_SUCCESS;
3522: x_msg_count := 0;
3523: x_msg_data := '';
3524:
3525: -- API Body

Line 3573: , p_encoded => FND_API.g_false

3569:
3570: FND_MSG_PUB.count_and_get
3571: ( p_count => x_msg_count
3572: , p_data => x_msg_data
3573: , p_encoded => FND_API.g_false
3574: );
3575:
3576: x_return_status := l_return_status;
3577:

Line 3588: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3584: EXCEPTION
3585:
3586: WHEN OTHERS THEN
3587: ROLLBACK TO Record_SoIssueCost_PVT;
3588: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3589:
3590: IF l_unexpLog THEN
3591: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3592: ,'Record_SoIssueCost '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));

Line 3606: , p_encoded => FND_API.g_false

3602:
3603: FND_MSG_PUB.count_and_get
3604: ( p_count => x_msg_count
3605: , p_data => x_msg_data
3606: , p_encoded => FND_API.g_false
3607: );
3608:
3609: END Record_SoIssueCost;
3610:

Line 3666: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3662:
3663: l_api_name CONSTANT VARCHAR2(30) := 'Process_RmaReceipt';
3664: l_api_message VARCHAR2(1000);
3665: l_stmt_num NUMBER := 0;
3666: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3667: l_msg_count NUMBER := 0;
3668: l_msg_data VARCHAR2(8000) := '';
3669:
3670: l_elemental_cost number_table;

Line 3725: x_return_status := FND_API.G_RET_STS_SUCCESS;

3721: );
3722: END IF;
3723:
3724: -- Initialize API return status to success
3725: x_return_status := FND_API.G_RET_STS_SUCCESS;
3726: x_msg_count := 0;
3727: x_msg_data := '';
3728:
3729: -- API Body

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

3756: x_event_id => l_rma_cce_id,
3757: x_cogs_percentage => l_cogs_percentage
3758: );
3759:
3760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3761: x_return_status := fnd_api.g_ret_sts_error;
3762: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3763: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3764: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));

Line 3761: x_return_status := fnd_api.g_ret_sts_error;

3757: x_cogs_percentage => l_cogs_percentage
3758: );
3759:
3760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3761: x_return_status := fnd_api.g_ret_sts_error;
3762: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3763: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3764: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3886: , p_encoded => FND_API.g_false

3882:
3883: FND_MSG_PUB.count_and_get
3884: ( p_count => x_msg_count
3885: , p_data => x_msg_data
3886: , p_encoded => FND_API.g_false
3887: );
3888:
3889: IF l_proclog THEN
3890: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

Line 3900: x_return_status := fnd_api.g_ret_sts_error ;

3896: EXCEPTION
3897:
3898: WHEN program_exception THEN
3899: ROLLBACK TO Process_RmaReceipt_PVT;
3900: x_return_status := fnd_api.g_ret_sts_error ;
3901:
3902: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3903: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3904: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

Line 3917: p_encoded => FND_API.g_false

3913:
3914: FND_MSG_PUB.count_and_get
3915: ( p_count => x_msg_count,
3916: p_data => x_msg_data,
3917: p_encoded => FND_API.g_false
3918: );
3919:
3920: WHEN OTHERS THEN
3921: ROLLBACK TO Process_RmaReceipt_PVT;

Line 3922: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3918: );
3919:
3920: WHEN OTHERS THEN
3921: ROLLBACK TO Process_RmaReceipt_PVT;
3922: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3923:
3924: IF l_unexpLog THEN
3925: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||'.'||l_stmt_num
3926: ,'Process_RmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));

Line 3940: , p_encoded => FND_API.g_false

3936:
3937: FND_MSG_PUB.count_and_get
3938: ( p_count => x_msg_count
3939: , p_data => x_msg_data
3940: , p_encoded => FND_API.g_false
3941: );
3942:
3943: END Process_RmaReceipt;
3944:

Line 4041: x_return_status := FND_API.G_RET_STS_SUCCESS;

4037: );
4038: END IF;
4039:
4040: -- Initialize API return status to success
4041: x_return_status := FND_API.G_RET_STS_SUCCESS;
4042: x_msg_count := 0;
4043: x_msg_data := '';
4044:
4045: -- API Body

Line 4114: , p_encoded => FND_API.g_false

4110:
4111: FND_MSG_PUB.count_and_get
4112: ( p_count => x_msg_count
4113: , p_data => x_msg_data
4114: , p_encoded => FND_API.g_false
4115: );
4116:
4117: IF l_proclog THEN
4118: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module||'.end',

Line 4127: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4123:
4124: EXCEPTION
4125: WHEN OTHERS THEN
4126: ROLLBACK TO Process_CogsRecognitionTxn_PVT;
4127: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4128:
4129: IF l_unexpLog THEN
4130: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
4131: ,'Process_CogsRecognitionTxn ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));

Line 4145: , p_encoded => FND_API.g_false

4141:
4142: FND_MSG_PUB.count_and_get
4143: ( p_count => x_msg_count
4144: , p_data => x_msg_data
4145: , p_encoded => FND_API.g_false
4146: );
4147:
4148: END Process_CogsRecognitionTxn;
4149:

Line 4191: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4187: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
4188: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
4189: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
4190:
4191: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4192: l_stmt_num NUMBER := 0;
4193:
4194: CURSOR c_uncosted_cogs_events(p_sob_id IN NUMBER) IS
4195: SELECT cce.cogs_om_line_id,

Line 4305: x_return_status := FND_API.G_RET_STS_SUCCESS;

4301: );
4302: END IF;
4303:
4304: -- Initialize API return status to success
4305: x_return_status := FND_API.G_RET_STS_SUCCESS;
4306:
4307: -- API Body
4308: -- Need to loop by set of books (ledger) because the call to the SLA
4309: -- API requires the ledger as an input parameter. So we'll have to

Line 4601: x_return_status := FND_API.G_RET_STS_SUCCESS;

4597: EXCEPTION
4598: WHEN end_of_program THEN
4599: ROLLBACK TO Cost_BulkCogsRecTxns_PVT;
4600: -- Let the program end normally
4601: x_return_status := FND_API.G_RET_STS_SUCCESS;
4602: debug('EXCEPTION end_of_program - Cost_BulkCogsRecTxns '||l_stmt_num||' : no ledger found - p_ledger_id :'||p_ledger_id);
4603:
4604: WHEN OTHERS THEN
4605: ROLLBACK TO Cost_BulkCogsRecTxns_PVT;

Line 4606: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4602: debug('EXCEPTION end_of_program - Cost_BulkCogsRecTxns '||l_stmt_num||' : no ledger found - p_ledger_id :'||p_ledger_id);
4603:
4604: WHEN OTHERS THEN
4605: ROLLBACK TO Cost_BulkCogsRecTxns_PVT;
4606: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4607:
4608: IF l_unexpLog THEN
4609: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
4610: ,'Cost_BulkCogsRecTxns '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));

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

4644: -- End of comments --
4645: -----------------------------------------------------------------------------
4646: PROCEDURE Insert_PacSoIssue(
4647: p_api_version IN NUMBER,
4648: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4649: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4651: x_return_status OUT NOCOPY VARCHAR2,
4652: x_msg_count OUT NOCOPY NUMBER,

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

4645: -----------------------------------------------------------------------------
4646: PROCEDURE Insert_PacSoIssue(
4647: p_api_version IN NUMBER,
4648: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4649: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4651: x_return_status OUT NOCOPY VARCHAR2,
4652: x_msg_count OUT NOCOPY NUMBER,
4653: x_msg_data OUT NOCOPY VARCHAR2,

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

4646: PROCEDURE Insert_PacSoIssue(
4647: p_api_version IN NUMBER,
4648: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4649: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4651: x_return_status OUT NOCOPY VARCHAR2,
4652: x_msg_count OUT NOCOPY NUMBER,
4653: x_msg_data OUT NOCOPY VARCHAR2,
4654: p_transaction_id IN NUMBER,

Line 4705: IF NOT FND_API.Compatible_API_Call (

4701: );
4702: END IF;
4703:
4704: -- Standard call to check for call compatibility
4705: IF NOT FND_API.Compatible_API_Call (
4706: l_api_version,
4707: p_api_version,
4708: l_api_name,
4709: G_PKG_NAME ) THEN

Line 4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4706: l_api_version,
4707: p_api_version,
4708: l_api_name,
4709: G_PKG_NAME ) THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: END IF;
4712:
4713: -- Initialize message list if p_init_msg_list is set to TRUE
4714: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 4714: IF FND_API.to_Boolean(p_init_msg_list) THEN

4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: END IF;
4712:
4713: -- Initialize message list if p_init_msg_list is set to TRUE
4714: IF FND_API.to_Boolean(p_init_msg_list) THEN
4715: FND_MSG_PUB.initialize;
4716: END IF;
4717:
4718: -- Initialize API return status to success

Line 4719: x_return_status := FND_API.G_RET_STS_SUCCESS;

4715: FND_MSG_PUB.initialize;
4716: END IF;
4717:
4718: -- Initialize API return status to success
4719: x_return_status := FND_API.G_RET_STS_SUCCESS;
4720: x_msg_count := 0;
4721: x_msg_data := '';
4722:
4723: -- API Body

Line 4875: , p_encoded => FND_API.g_false

4871:
4872: FND_MSG_PUB.count_and_get
4873: ( p_count => x_msg_count
4874: , p_data => x_msg_data
4875: , p_encoded => FND_API.g_false
4876: );
4877:
4878:
4879:

Line 4884: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4880: EXCEPTION
4881:
4882: WHEN OTHERS THEN
4883: ROLLBACK TO Insert_PacSoIssue_PVT;
4884: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4885:
4886: IF l_unexpLog THEN
4887: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
4888: ,'Insert_PacSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));

Line 4902: , p_encoded => FND_API.g_false

4898:
4899: FND_MSG_PUB.count_and_get
4900: ( p_count => x_msg_count
4901: , p_data => x_msg_data
4902: , p_encoded => FND_API.g_false
4903: );
4904:
4905: END Insert_PacSoIssue;
4906:

Line 5305: p_encoded => FND_API.g_false

5301: BEGIN
5302: FND_MSG_PUB.count_and_get
5303: ( p_count => l_msg_count,
5304: p_data => l_msg_data,
5305: p_encoded => FND_API.g_false
5306: );
5307: IF (l_msg_count > 1) THEN
5308: FOR i IN 1..l_msg_count LOOP
5309: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);

Line 5309: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);

5305: p_encoded => FND_API.g_false
5306: );
5307: IF (l_msg_count > 1) THEN
5308: FOR i IN 1..l_msg_count LOOP
5309: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);
5310: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
5311: END LOOP;
5312: ELSIF (l_msg_count = 1) THEN
5313: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 5407: l_return_status := fnd_api.g_ret_sts_success;

5403: -- Initialize variables
5404:
5405: l_amount := 16383;
5406: l_offset := 1;
5407: l_return_status := fnd_api.g_ret_sts_success;
5408: l_msg_count := 0;
5409: if(p_cost_method = 1) then
5410: l_operating_unit := mo_global.get_current_org_id;
5411: else

Line 5458: if(not fnd_api.Compatible_API_Call( l_api_version,

5454: );
5455:
5456: -- Standard call to check the API version
5457:
5458: if(not fnd_api.Compatible_API_Call( l_api_version,
5459: p_api_version,
5460: l_api_name,
5461: G_PKG_NAME)) then
5462: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 5462: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

5458: if(not fnd_api.Compatible_API_Call( l_api_version,
5459: p_api_version,
5460: l_api_name,
5461: G_PKG_NAME)) then
5462: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5463: end if;
5464:
5465: l_stmt_num := 10;
5466:

Line 5487: p_init_msg_list => fnd_api.G_FALSE,

5483: -- XML data
5484: /*========================================================================*/
5485:
5486: Add_Parameters ( p_api_version => 1.0,
5487: p_init_msg_list => fnd_api.G_FALSE,
5488: p_validation_level => fnd_api.G_VALID_LEVEL_FULL,
5489: x_return_status => l_return_status,
5490: x_msg_count => l_msg_count,
5491: x_msg_data => l_msg_data,

Line 5488: p_validation_level => fnd_api.G_VALID_LEVEL_FULL,

5484: /*========================================================================*/
5485:
5486: Add_Parameters ( p_api_version => 1.0,
5487: p_init_msg_list => fnd_api.G_FALSE,
5488: p_validation_level => fnd_api.G_VALID_LEVEL_FULL,
5489: x_return_status => l_return_status,
5490: x_msg_count => l_msg_count,
5491: x_msg_data => l_msg_data,
5492: i_cost_method => p_cost_method,

Line 5507: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then

5503: x_xml_doc => l_xml_doc);
5504:
5505: -- Standard call to check the return status from API called
5506:
5507: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5508: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5509: end if;
5510:
5511:

Line 5508: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

5504:
5505: -- Standard call to check the return status from API called
5506:
5507: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5508: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5509: end if;
5510:
5511:
5512: l_stmt_num := 20;

Line 5519: p_init_msg_list => FND_API.G_FALSE,

5515: -- Call to Procedure Add Parameters. To Add AP and PO data to XML data
5516: /*========================================================================*/
5517:
5518: Add_DefCOGSData (p_api_version => 1.0,
5519: p_init_msg_list => FND_API.G_FALSE,
5520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5521: x_return_status => l_return_status,
5522: x_msg_count => l_msg_count,
5523: x_msg_data => l_msg_data,

Line 5520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

5516: /*========================================================================*/
5517:
5518: Add_DefCOGSData (p_api_version => 1.0,
5519: p_init_msg_list => FND_API.G_FALSE,
5520: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5521: x_return_status => l_return_status,
5522: x_msg_count => l_msg_count,
5523: x_msg_data => l_msg_data,
5524: i_cost_method => p_cost_method,

Line 5539: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then

5535: x_xml_doc => l_xml_doc);
5536:
5537: -- Standard call to check the return status from API called
5538:
5539: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5540: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5541: end if;
5542:
5543: -- write the closing tag to the XML data

Line 5540: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

5536:
5537: -- Standard call to check the return status from API called
5538:
5539: if(l_return_status <> fnd_api.G_RET_STS_SUCCESS) then
5540: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5541: end if;
5542:
5543: -- write the closing tag to the XML data
5544:

Line 5577: when fnd_api.G_EXC_ERROR then

5573: debug('err_code = '||err_code);
5574: debug('Generate_DefCOGSXml-');
5575:
5576: exception
5577: when fnd_api.G_EXC_ERROR then
5578: l_return_status := fnd_api.G_RET_STS_ERROR ;
5579: fnd_msg_pub.Count_And_Get
5580: ( p_count => l_msg_count,
5581: p_data => l_msg_data

Line 5578: l_return_status := fnd_api.G_RET_STS_ERROR ;

5574: debug('Generate_DefCOGSXml-');
5575:
5576: exception
5577: when fnd_api.G_EXC_ERROR then
5578: l_return_status := fnd_api.G_RET_STS_ERROR ;
5579: fnd_msg_pub.Count_And_Get
5580: ( p_count => l_msg_count,
5581: p_data => l_msg_data
5582: );

Line 5584: when fnd_api.G_EXC_UNEXPECTED_ERROR then

5580: ( p_count => l_msg_count,
5581: p_data => l_msg_data
5582: );
5583:
5584: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5585: fnd_msg_pub.Count_And_Get
5586: ( p_count => l_msg_count,
5587: p_data => l_msg_data
5588: );

Line 5732: if(not fnd_api.Compatible_API_Call ( l_api_version,

5728:
5729:
5730: -- Standard call to check for call compatibility.
5731:
5732: if(not fnd_api.Compatible_API_Call ( l_api_version,
5733: p_api_version,
5734: l_api_name,
5735: G_PKG_NAME )) then
5736: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 5736: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

5732: if(not fnd_api.Compatible_API_Call ( l_api_version,
5733: p_api_version,
5734: l_api_name,
5735: G_PKG_NAME )) then
5736: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
5737: end if;
5738:
5739: -- Initialize message list if p_init_msg_list is set to TRUE.
5740:

Line 5741: if(fnd_api.to_boolean( p_init_msg_list )) then

5737: end if;
5738:
5739: -- Initialize message list if p_init_msg_list is set to TRUE.
5740:
5741: if(fnd_api.to_boolean( p_init_msg_list )) then
5742: fnd_msg_pub.initialize;
5743: end if;
5744:
5745: -- Initialize API return status to success

Line 5747: x_return_status := fnd_api.G_RET_STS_SUCCESS;

5743: end if;
5744:
5745: -- Initialize API return status to success
5746:
5747: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5748:
5749: -- Initialize temporary variable to hold xml data
5750:
5751: dbms_lob.createtemporary(l_xml_temp, TRUE);

Line 5874: when fnd_api.G_EXC_ERROR then

5870: debug( 'x_msg_data ='||x_msg_data);
5871: debug('Add_Parameters-');
5872:
5873: exception
5874: when fnd_api.G_EXC_ERROR then
5875: x_return_status := fnd_api.G_RET_STS_ERROR;
5876: fnd_msg_pub.Count_And_Get
5877: ( p_count => x_msg_count,
5878: p_data => x_msg_data

Line 5875: x_return_status := fnd_api.G_RET_STS_ERROR;

5871: debug('Add_Parameters-');
5872:
5873: exception
5874: when fnd_api.G_EXC_ERROR then
5875: x_return_status := fnd_api.G_RET_STS_ERROR;
5876: fnd_msg_pub.Count_And_Get
5877: ( p_count => x_msg_count,
5878: p_data => x_msg_data
5879: );

Line 5881: when fnd_api.G_EXC_UNEXPECTED_ERROR then

5877: ( p_count => x_msg_count,
5878: p_data => x_msg_data
5879: );
5880:
5881: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5882: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5883: fnd_msg_pub.Count_And_Get
5884: ( p_count => x_msg_count,
5885: p_data => x_msg_data

Line 5882: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

5878: p_data => x_msg_data
5879: );
5880:
5881: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5882: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5883: fnd_msg_pub.Count_And_Get
5884: ( p_count => x_msg_count,
5885: p_data => x_msg_data
5886: );

Line 5889: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

5885: p_data => x_msg_data
5886: );
5887:
5888: when others then
5889: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5890: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
5891: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
5892: l_module || '.' || l_stmt_num,
5893: substrb(SQLERRM , 1 , 240));

Line 6007: if(not fnd_api.Compatible_API_Call( l_api_version,

6003: debug('i_amt_tolerance = '||i_amt_tolerance);
6004:
6005: -- Standard call to check for call compatibility.
6006:
6007: if(not fnd_api.Compatible_API_Call( l_api_version,
6008: p_api_version,
6009: l_api_name,
6010: G_PKG_NAME)) then
6011: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

Line 6011: raise fnd_api.G_EXC_UNEXPECTED_ERROR;

6007: if(not fnd_api.Compatible_API_Call( l_api_version,
6008: p_api_version,
6009: l_api_name,
6010: G_PKG_NAME)) then
6011: raise fnd_api.G_EXC_UNEXPECTED_ERROR;
6012: end if;
6013:
6014: -- Initialize message list if p_init_msg_list is set to TRUE.
6015:

Line 6016: if(fnd_api.to_boolean(p_init_msg_list)) then

6012: end if;
6013:
6014: -- Initialize message list if p_init_msg_list is set to TRUE.
6015:
6016: if(fnd_api.to_boolean(p_init_msg_list)) then
6017: fnd_msg_pub.initialize;
6018: end if;
6019:
6020: -- Initialize API return status to success

Line 6022: x_return_status := fnd_api.G_RET_STS_SUCCESS;

6018: end if;
6019:
6020: -- Initialize API return status to success
6021:
6022: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6023:
6024: -- Initialize temporary variable to hold xml data
6025:
6026: dbms_lob.createtemporary(l_xml_temp, TRUE);

Line 6758: when fnd_api.G_EXC_ERROR then

6754: debug('x_msg_data = '||x_msg_data);
6755: debug('Add_DefCOGSData-');
6756:
6757: exception
6758: when fnd_api.G_EXC_ERROR then
6759: x_return_status := fnd_api.G_RET_STS_ERROR;
6760: fnd_msg_pub.Count_And_Get
6761: ( p_count => x_msg_count,
6762: p_data => x_msg_data

Line 6759: x_return_status := fnd_api.G_RET_STS_ERROR;

6755: debug('Add_DefCOGSData-');
6756:
6757: exception
6758: when fnd_api.G_EXC_ERROR then
6759: x_return_status := fnd_api.G_RET_STS_ERROR;
6760: fnd_msg_pub.Count_And_Get
6761: ( p_count => x_msg_count,
6762: p_data => x_msg_data
6763: );

Line 6765: when fnd_api.G_EXC_UNEXPECTED_ERROR then

6761: ( p_count => x_msg_count,
6762: p_data => x_msg_data
6763: );
6764:
6765: when fnd_api.G_EXC_UNEXPECTED_ERROR then
6766: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6767: fnd_msg_pub.Count_And_Get
6768: ( p_count => x_msg_count,
6769: p_data => x_msg_data

Line 6766: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

6762: p_data => x_msg_data
6763: );
6764:
6765: when fnd_api.G_EXC_UNEXPECTED_ERROR then
6766: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6767: fnd_msg_pub.Count_And_Get
6768: ( p_count => x_msg_count,
6769: p_data => x_msg_data
6770: );

Line 6773: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

6769: p_data => x_msg_data
6770: );
6771:
6772: when others then
6773: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6774: if(fnd_log.LEVEL_UNEXPECTED >= G_LOG_LEVEL) then
6775: fnd_log.string(fnd_log.LEVEL_UNEXPECTED,
6776: l_module || '.' || l_stmt_num,
6777: substrb(SQLERRM , 1 , 240));

Line 6909: x_return_status := fnd_api.g_ret_sts_success;

6905: l_stmt_num NUMBER := 0;
6906: BEGIN
6907: debug('ensure_mmt_per_and_date+');
6908: SAVEPOINT ensure_mmt_per_and_date;
6909: x_return_status := fnd_api.g_ret_sts_success;
6910:
6911: OPEN ctrx;
6912: LOOP
6913: l_stmt_num := 1;

Line 6989: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6985: --log a message
6986: ROLLBACK TO ensure_mmt_per_and_date;
6987: IF ctrx%ISOPEN THEN CLOSE ctrx; END IF;
6988: IF next_inv_period%ISOPEN THEN CLOSE next_inv_period; END IF;
6989: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6990: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');

Line 6997: p_encoded => fnd_api.g_false,

6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6995: fnd_msg_pub.ADD;
6996: fnd_msg_pub.count_and_get(
6997: p_encoded => fnd_api.g_false,
6998: p_count => x_msg_count,
6999: p_data => x_msg_data);
7000: END ensure_mmt_per_and_date;
7001:

Line 7597: x_status := FND_API.G_RET_STS_SUCCESS;

7593: BEGIN
7594: debug ('check_eligible_lines +');
7595: debug (' p_ledger_id : '||p_ledger_id);
7596:
7597: x_status := FND_API.G_RET_STS_SUCCESS;
7598: x_out_msg := '';
7599:
7600: debug ('1');
7601:

Line 7645: x_status := fnd_api.G_RET_STS_UNEXP_ERROR;

7641: EXCEPTION
7642: WHEN OTHERS THEN
7643: IF c_revenue_only_lines%ISOPEN THEN CLOSE c_revenue_only_lines; END IF;
7644: IF c_prepare%ISOPEN THEN CLOSE c_prepare; END IF;
7645: x_status := fnd_api.G_RET_STS_UNEXP_ERROR;
7646: x_out_msg := 'EXCEPTION OTHERS in check_eligible_lines:'||SQLERRM;
7647: debug(x_out_msg);
7648:
7649: END check_eligible_lines;