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.DPP_TRANSACTION_PVT dependencies on DPP_TRANSACTION_PVT

Line 1: PACKAGE BODY DPP_TRANSACTION_PVT AS

1: PACKAGE BODY DPP_TRANSACTION_PVT AS
2: /* $Header: dppvtxnb.pls 120.103.12020000.2 2012/07/16 09:12:29 rvkondur ship $ */
3: -- Package name : DPP_TRANSACTION_PVT
4: -- Purpose : For Validation and Creation of Price Protection Transaction
5: -- History :

Line 3: -- Package name : DPP_TRANSACTION_PVT

1: PACKAGE BODY DPP_TRANSACTION_PVT AS
2: /* $Header: dppvtxnb.pls 120.103.12020000.2 2012/07/16 09:12:29 rvkondur ship $ */
3: -- Package name : DPP_TRANSACTION_PVT
4: -- Purpose : For Validation and Creation of Price Protection Transaction
5: -- History :
6: --27-Aug-07 sanagar Creation
7: --29-Jan-08 sanagar Bug 6773981

Line 33: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';

29: dpp_debug_high_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
30: dpp_debug_low_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low);
31: dpp_debug_medium_on constant boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_medium);
32:
33: g_pkg_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
34: g_debug boolean := fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_high);
35: g_file_name constant VARCHAR2(14) := 'dppvtxnb.pls';
36:
37: PROCEDURE Update_InterfaceErrSts(

Line 75: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

71: WHEN OTHERS THEN
72: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
73: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
74: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
75: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
76: fnd_message.set_token('ERRNO', SQLCODE);
77: fnd_message.set_token('REASON', sqlerrm);
78: END IF;
79: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);

Line 197: l_valid_doc := dpp_transaction_pvt.has_docnum_chars(

193: p_txn_header_rec_type.error_code := 'DPP_DOC_REF_NUM_NULL';
194: RAISE Fnd_Api.G_EXC_ERROR;
195: END IF;
196: --Call function to validate the document ref number for special characters other than _ and -.
197: l_valid_doc := dpp_transaction_pvt.has_docnum_chars(
198: p_docnum => p_txn_header_rec_type.ref_document_number
199: );
200:
201: IF l_valid_doc = 'N' OR length(p_txn_header_rec_type.ref_document_number) > 40 THEN

Line 652: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

648: WHEN others THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
652: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
653: fnd_message.set_token('ERRNO', SQLCODE);
654: fnd_message.set_token('REASON', sqlerrm);
655: END IF;
656: END Get_DaysCovered;

Line 1036: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

1032: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1033: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1034: THEN
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1036: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
1037: fnd_message.set_token('ERRNO', SQLCODE);
1038: fnd_message.set_token('REASON', sqlerrm);
1039: END IF;
1040: x_msg_data := fnd_message.get;

Line 1706: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');

1702: WHEN OTHERS THEN
1703: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1705: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1706: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT VALIDATE SUPPLIER PART NUMBER');
1707: fnd_message.set_token('ERRNO', SQLCODE);
1708: fnd_message.set_token('REASON', sqlerrm);
1709: END IF;
1710: x_msg_data := fnd_message.get();

Line 2261: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2257: WHEN others THEN
2258: x_return_status := fnd_api.g_ret_sts_unexp_error;
2259: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2260: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2261: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2262: fnd_message.set_token('ERRNO', SQLCODE);
2263: fnd_message.set_token('REASON', sqlerrm);
2264: END IF;
2265: x_msg_data := fnd_message.get();

Line 2530: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2526: WHEN OTHERS THEN
2527: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2529: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2530: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2531: fnd_message.set_token('ERRNO', SQLCODE);
2532: fnd_message.set_token('REASON', sqlerrm);
2533: END IF;
2534: x_msg_data := fnd_message.get();

Line 2846: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2842: WHEN OTHERS THEN
2843: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2844: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2846: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2847: fnd_message.set_token('ERRNO', SQLCODE);
2848: fnd_message.set_token('REASON', sqlerrm);
2849: END IF;
2850: x_msg_data := fnd_message.get();

Line 2909: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

2905: WHEN OTHERS THEN
2906: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2907: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2908: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2909: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
2910: fnd_message.set_token('ERRNO', SQLCODE);
2911: fnd_message.set_token('REASON', sqlerrm);
2912: END IF;
2913: FND_FILE.PUT_LINE(FND_FILE.LOG,' '||sqlerrm);

Line 3970: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

3966: WHEN others THEN
3967: x_return_status := fnd_api.g_ret_sts_unexp_error;
3968: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3969: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
3970: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
3971: fnd_message.set_token('ERRNO', SQLCODE);
3972: fnd_message.set_token('REASON', sqlerrm);
3973: END IF;
3974:

Line 4117: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');

4113: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Create IntLines : SQLERRM:'||SQLERRM);
4114: x_return_status := fnd_api.g_ret_sts_unexp_error;
4115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4116: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
4117: fnd_message.set_token('ROUTINE', 'DPP_TRANSACTION_PVT');
4118: fnd_message.set_token('ERRNO', SQLCODE);
4119: fnd_message.set_token('REASON', sqlerrm);
4120: END IF;
4121: x_msg_data := fnd_message.get();

Line 4206: l_api_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';

4202: p_dtlattribute29 IN VARCHAR2,
4203: p_dtlattribute30 IN VARCHAR2
4204: ) AS
4205:
4206: l_api_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
4207: l_api_version constant NUMBER := 1.0;
4208: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
4209:
4210: --l_commit VARCHAR2(30) := fnd_api.g_true;

Line 4530: DPP_TRANSACTION_Pvt.Insert_Transaction(

4526: --call insert transaction procedure
4527:
4528:
4529: --dpp_inbound_pvt.Insert_Transaction(
4530: DPP_TRANSACTION_Pvt.Insert_Transaction(
4531: p_api_version =>l_api_version
4532: , p_init_msg_list =>l_init_msg_list
4533: , p_commit =>l_commit
4534: , p_validation_level =>l_validation_level

Line 4747: l_api_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';

4743: p_dtlattribute30 IN VARCHAR2,
4744: x_return_status OUT NOCOPY VARCHAR2
4745: ) AS
4746: l_error_message VARCHAR2(4000);
4747: l_api_name constant VARCHAR2(30) := 'DPP_TRANSACTION_PVT';
4748: l_api_version constant NUMBER := 1.0;
4749: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
4750: l_return_status VARCHAR2(30);
4751: l_msg_count NUMBER;

Line 5143: DPP_TRANSACTION_PVT.Insert_Transaction(

5139: fnd_file.put_line(fnd_file.log, 'Error in updating request id into the table.');
5140: RAISE Fnd_Api.G_EXC_ERROR;
5141: END;
5142: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Call Insert Transaction p_transaction_int_header_id:'||transaction_rec.transaction_int_header_id);
5143: DPP_TRANSACTION_PVT.Insert_Transaction(
5144: p_api_version =>l_api_version
5145: , p_init_msg_list =>l_init_msg_list
5146: , p_commit =>l_commit
5147: , p_validation_level =>l_validation_level

Line 5224: END DPP_TRANSACTION_PVT;

5220: p_encoded => Fnd_Api.G_FALSE
5221: );
5222:
5223: END Create_Transaction;
5224: END DPP_TRANSACTION_PVT;