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.OKS_WF_K_PROCESS_PVT dependencies on DBMS_TRANSACTION

Line 2510: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

2506: 'Entered '||G_PKG_NAME ||'.'||l_api_name||' with p_contract_id'||
2507: p_contract_id||' p_item_key'||p_item_key);
2508: END IF;
2509:
2510: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
2511: -- Standard call to check for call compatibility.
2512: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;

Line 2761: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

2757: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
2758: END IF;
2759: EXCEPTION
2760: WHEN FND_API.G_EXC_ERROR THEN
2761: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2762: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2765: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 2770: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

2766: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
2767: END IF;
2768: x_return_status := G_RET_STS_ERROR;
2769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2770: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2771: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2774: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 2779: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

2775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
2776: END IF;
2777: x_return_status := G_RET_STS_UNEXP_ERROR ;
2778: WHEN OTHERS THEN
2779: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
2780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2782: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
2783: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 2862: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

2858: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
2859: 'p_reason_code:'||p_reason_code||' p_comments:'||p_comments);
2860: END IF;
2861:
2862: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
2863: -- Standard call to check for call compatibility.
2864: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2866: END IF;

Line 3140: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3136: END IF;
3137:
3138: EXCEPTION
3139: WHEN FND_API.G_EXC_ERROR THEN
3140: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3142: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3144: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 3149: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3146: END IF;
3147: x_return_status := G_RET_STS_ERROR;
3148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3149: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3153: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 3158: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3155: END IF;
3156: x_return_status := G_RET_STS_UNEXP_ERROR ;
3157: WHEN OTHERS THEN
3158: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3161: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3162: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 3222: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

3218: ',p_subject=>'||p_subject||
3219: ',p_message=>'||p_message||')');
3220: END IF;
3221:
3222: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
3223: -- Standard call to check for call compatibility.
3224: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: END IF;

Line 3549: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3545: END IF;
3546:
3547: EXCEPTION
3548: WHEN FND_API.G_EXC_ERROR THEN
3549: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3550: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3551: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3553: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 3558: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3555: END IF;
3556: x_return_status := G_RET_STS_ERROR;
3557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3558: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3559: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3562: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 3567: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3563: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3564: END IF;
3565: x_return_status := G_RET_STS_UNEXP_ERROR ;
3566: WHEN OTHERS THEN
3567: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3568: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3570: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3571: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 3624: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

3620: 'Entered '||G_PKG_NAME ||'.'||l_api_name||
3621: '(p_chr_id=>'||p_chr_id||'p_negotiation_status=>'||p_negotiation_status||')');
3622: END IF;
3623:
3624: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
3625: -- Standard call to check for call compatibility.
3626: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3628: END IF;

Line 3678: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3674: END IF;
3675:
3676: EXCEPTION
3677: WHEN FND_API.G_EXC_ERROR THEN
3678: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3679: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3682: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 3687: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3684: END IF;
3685: x_return_status := G_RET_STS_ERROR;
3686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3687: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3688: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3690: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
3691: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 3696: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

3692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
3693: END IF;
3694: x_return_status := G_RET_STS_UNEXP_ERROR ;
3695: WHEN OTHERS THEN
3696: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
3697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
3699: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
3700: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 4444: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

4440: 'NEGOTIATION_STATUS=>'||p_wf_attributes.NEGOTIATION_STATUS||
4441: 'ITEM_KEY=>'||p_wf_attributes.ITEM_KEY||')');
4442: END IF;
4443:
4444: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
4445: -- Initialize message list if p_init_msg_list is set to TRUE.
4446: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4447: FND_MSG_PUB.initialize;
4448: END IF;

Line 4702: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

4698: END IF;
4699:
4700: EXCEPTION
4701: WHEN FND_API.G_EXC_ERROR THEN
4702: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4704: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4705: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4706: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 4711: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

4707: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4708: END IF;
4709: x_return_status := G_RET_STS_ERROR;
4710: WHEN OTHERS THEN
4711: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4713: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4714: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4715: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 4773: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

4769: 'Entered '||G_PKG_NAME ||'.'||l_api_name||
4770: '(p_contract_id=>'||p_contract_id||'p_item_key=>'||p_item_key||')');
4771: END IF;
4772:
4773: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
4774: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4776: END IF;
4777: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4857: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

4853: END IF;
4854:
4855: EXCEPTION
4856: WHEN FND_API.G_EXC_ERROR THEN
4857: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4858: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4860: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4861: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 4866: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

4862: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4863: END IF;
4864: x_return_status := G_RET_STS_ERROR;
4865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4866: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4867: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4868: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4869: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
4870: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 4875: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

4871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
4872: END IF;
4873: x_return_status := G_RET_STS_UNEXP_ERROR ;
4874: WHEN OTHERS THEN
4875: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
4876: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4877: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
4878: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
4879: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 4935: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

4931: 'Entered '||G_PKG_NAME ||'.'||l_api_name||
4932: '(p_contract_id=>'||p_contract_id||'p_item_key=>'||p_item_key||')');
4933: END IF;
4934:
4935: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
4936: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4938: END IF;
4939: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5015: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

5011: END IF;
5012:
5013: EXCEPTION
5014: WHEN FND_API.G_EXC_ERROR THEN
5015: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
5016: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5017: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5018: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5019: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 5024: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

5020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
5021: END IF;
5022: x_return_status := G_RET_STS_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
5025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5027: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
5028: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 5033: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

5029: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
5030: END IF;
5031: x_return_status := G_RET_STS_UNEXP_ERROR ;
5032: WHEN OTHERS THEN
5033: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
5034: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5035: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
5036: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
5037: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 6111: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

6107: ' with Contract Id '||p_contract_id ||
6108: ' p_validate_yn '||p_validate_yn||' p_qa_required_yn '||p_qa_required_yn);
6109: END IF;
6110:
6111: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
6112: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6114: END IF;
6115:

Line 6359: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6355: END IF;
6356:
6357: EXCEPTION
6358: WHEN ActionNotAllowedException THEN
6359: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6360: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6361: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6362: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6363: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||

Line 6367: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6363: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
6364: ' Contract is either waiting for customer acceptance or not in entered status');
6365: END IF;
6366: WHEN FND_API.G_EXC_ERROR THEN
6367: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6368: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6369: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6370: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6371: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 6376: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6373: END IF;
6374: x_return_status := G_RET_STS_ERROR;
6375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6376: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6377: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6378: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6380: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 6385: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6382: END IF;
6383: x_return_status := G_RET_STS_UNEXP_ERROR ;
6384: WHEN OTHERS THEN
6385: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6386: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6388: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6389: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 6450: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

6446: 'Entered '||G_PKG_NAME ||'.'||l_api_name||
6447: '(p_contract_id=>'||p_contract_id||'p_item_key=>'||p_item_key||')');
6448: END IF;
6449:
6450: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
6451: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
6452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6453: END IF;
6454: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 6556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6552: END IF;
6553:
6554: EXCEPTION
6555: WHEN ActionNotAllowedException THEN
6556: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6557: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6558: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6559: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
6560: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||

Line 6565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6561: ' Contract cannot be published since it is not in entered status');
6562: END IF;
6563: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
6564: WHEN AlreadyPublishedException THEN
6565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6566: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6569: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from AlreadyPublishedException');

Line 6573: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6569: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from AlreadyPublishedException');
6570: END IF;
6571: x_return_status := G_RET_STS_ALREADY_PUBLISHED;
6572: WHEN FND_API.G_EXC_ERROR THEN
6573: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6574: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6575: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6577: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 6582: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6578: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6579: END IF;
6580: x_return_status := G_RET_STS_ERROR;
6581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6582: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6583: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6584: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6585: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
6586: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 6591: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

6587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
6588: END IF;
6589: x_return_status := G_RET_STS_UNEXP_ERROR ;
6590: WHEN OTHERS THEN
6591: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
6592: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6593: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6594: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
6595: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 8083: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

8079: 'Item key: ' || NVL(p_item_key,'NULL') ||
8080: ' Accept Confirm Flag: ' || p_accept_confirm_yn);
8081: END IF;
8082:
8083: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
8084: -- Standard call to check for call compatibility.
8085: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
8086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8087: END IF;

Line 8211: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

8207: END IF;
8208:
8209: EXCEPTION
8210: WHEN FND_API.G_EXC_ERROR THEN
8211: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8212: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8215: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');

Line 8220: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

8216: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8217: END IF;
8218: x_return_status := G_RET_STS_ERROR;
8219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8220: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8221: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
8222: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8224: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');

Line 8229: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

8225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8226: END IF;
8227: x_return_status := G_RET_STS_UNEXP_ERROR ;
8228: WHEN OTHERS THEN
8229: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8230: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8232: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8233: ||SQLCODE||', sqlerrm = '||SQLERRM);

Line 8316: DBMS_TRANSACTION.SAVEPOINT(l_api_name);

8312: 'Cancellation reason: ' || substr(NVL(p_cancellation_reason,'NULL'),1,1500)
8313: || ' Cancellation date: ' || to_char(p_cancellation_date));
8314: END IF;
8315:
8316: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
8317: -- Standard call to check for call compatibility.
8318: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
8319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8320: END IF;

Line 8557: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

8553: END IF;
8554:
8555: EXCEPTION
8556: WHEN FND_API.G_EXC_ERROR THEN
8557: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8558: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8559: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8560: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_ERROR');
8561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 8565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

8561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8562: END IF;
8563: x_return_status := G_RET_STS_ERROR;
8564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8565: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8566: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
8568: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from G_EXC_UNEXPECTED_ERROR');
8569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);

Line 8573: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);

8569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,get_fnd_message);
8570: END IF;
8571: x_return_status := G_RET_STS_UNEXP_ERROR ;
8572: WHEN OTHERS THEN
8573: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
8574: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8576: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
8577: ||SQLCODE||', sqlerrm = '||SQLERRM);