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.AHL_WARRANTY_UTILS_PVT dependencies on STANDARD

Line 29: -- Standard IN Parameters :

25: --
26: -- Pre-reqs :
27: -- Parameters :
28: --
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 35: -- Standard OUT Parameters :

31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: --
35: -- Standard OUT Parameters :
36: -- x_return_status OUT VARCHAR2 Required
37: -- x_msg_count OUT NUMBER Required
38: -- x_msg_data OUT VARCHAR2 Required
39: --

Line 58: --Standard local variables

54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2)
57: IS
58: --Standard local variables
59: L_API_NAME CONSTANT VARCHAR2(30) := 'Calc_Contract_Exp_Date';
60: L_API_VERSION CONSTANT NUMBER := 1.0;
61: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
62: l_msg_data VARCHAR2(2000);

Line 125: -- Standard start of API savepoint

121:
122: -- initialize return status.
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: -- Standard start of API savepoint
126: SAVEPOINT Calc_Contract_Exp_Date_Pvt;
127:
128: -- Initialize message list if p_init_msg_list is set to TRUE
129: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 136: -- Standard call to check for call compatibility.

132:
133: -- Initialize API return status to success
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: -- Standard call to check for call compatibility.
137: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
138: p_api_version,
139: l_api_name,G_PKG_NAME) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 269: -- Standard check of p_commit

265: WHERE WARRANTY_CONTRACT_ID = l_warranty_contract_id ;
266:
267: END LOOP;
268:
269: -- Standard check of p_commit
270: IF FND_API.TO_BOOLEAN(p_commit) THEN
271: COMMIT WORK;
272: END IF;
273:

Line 354: -- Standard start of API savepoint

350: --WHERE contract_status_code = 'ACTIVE';
351:
352: BEGIN
353:
354: -- Standard start of API savepoint
355: SAVEPOINT Calc_Contract_Exp_Date_CP;
356:
357: -- 1. Initialize error message stack by default
358: FND_MSG_PUB.Initialize;

Line 363: -- Standard call to check for call compatibility

359:
360: -- initialize return status to success
361: retcode := 0;
362:
363: -- Standard call to check for call compatibility
364: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
365: retcode := 2;
366: errbuf := FND_MSG_PUB.Get;
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 514: -- Standard start of API savepoint

510: csrTbl disable_templates_csr_type;
511:
512: BEGIN
513:
514: -- Standard start of API savepoint
515: SAVEPOINT Disable_Templates_CP_PVT;
516:
517: -- 1. Initialize error message stack by default
518: FND_MSG_PUB.Initialize;

Line 523: -- Standard call to check for call compatibility

519:
520: -- initialize return status to success
521: retcode := 0;
522:
523: -- Standard call to check for call compatibility
524: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
525: retcode := 2;
526: errbuf := FND_MSG_PUB.Get;
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 600: -- Standard IN Parameters :

596: --
597: -- Pre-reqs :
598: -- Parameters :
599: --
600: -- Standard IN Parameters :
601: -- p_api_version IN NUMBER Required
602: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
603: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
604: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 606: -- Standard OUT Parameters :

602: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
603: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
604: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
605: --
606: -- Standard OUT Parameters :
607: -- x_return_status OUT VARCHAR2 Required
608: -- x_msg_count OUT NUMBER Required
609: -- x_msg_data OUT VARCHAR2 Required
610: --

Line 631: --Standard local variables

627: x_msg_data OUT NOCOPY VARCHAR2
628: )
629:
630: IS
631: --Standard local variables
632: L_API_NAME CONSTANT VARCHAR2(30) := 'Disable_Templates_For_Vendor';
633: L_API_VERSION CONSTANT NUMBER := 1.0;
634: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
635:

Line 659: -- Standard start of API savepoint

655: IF (l_log_procedure >= l_log_current_level) THEN
656: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure, count = '||p_warranty_vendor_id_tbl.COUNT);
657: END IF;
658:
659: -- Standard start of API savepoint
660: SAVEPOINT Disable_Tmpls_For_Vendor_Pvt;
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE
663: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 670: -- Standard call to check for call compatibility.

666:
667: -- Initialize API return status to success
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669:
670: -- Standard call to check for call compatibility.
671: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
672: p_api_version,
673: l_api_name,G_PKG_NAME) THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 725: -- Standard check of p_commit

721: WHERE WARRANTY_TEMPLATE_ID = csr_index.warranty_template_id;
722:
723: END LOOP;
724: */
725: -- Standard check of p_commit
726: IF FND_API.TO_BOOLEAN(p_commit) THEN
727: COMMIT WORK;
728: END IF;
729:

Line 777: -- Standard IN Parameters :

773: --
774: -- Pre-reqs :
775: -- Parameters :
776: --
777: -- Standard IN Parameters :
778: -- p_api_version IN NUMBER Required
779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 783: -- Standard OUT Parameters :

779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
782: --
783: -- Standard OUT Parameters :
784: -- x_return_status OUT VARCHAR2 Required
785: -- x_msg_count OUT NUMBER Required
786: -- x_msg_data OUT VARCHAR2 Required
787: --

Line 813: --Standard local variables

809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2
811: )
812: IS
813: --Standard local variables
814: L_API_NAME CONSTANT VARCHAR2(30) := 'Process_Attachments';
815: L_API_VERSION CONSTANT NUMBER := 1.0;
816: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
817: l_msg_data VARCHAR2(2000);

Line 864: -- Standard start of API savepoint

860: IF (l_log_procedure >= l_log_current_level) THEN
861: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure');
862: END IF;
863:
864: -- Standard start of API savepoint
865: SAVEPOINT Process_Attachments_Pvt;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE
868: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 875: -- Standard call to check for call compatibility.

871:
872: -- Initialize API return status to success
873: x_return_status := FND_API.G_RET_STS_SUCCESS;
874:
875: -- Standard call to check for call compatibility.
876: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
877: p_api_version,
878: l_api_name,G_PKG_NAME) THEN
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1091: -- Standard check of p_commit

1087: END IF;
1088:
1089:
1090:
1091: -- Standard check of p_commit
1092: IF FND_API.TO_BOOLEAN(p_commit) THEN
1093: COMMIT WORK;
1094: END IF;
1095:

Line 1143: -- Standard IN Parameters :

1139: --
1140: -- Pre-reqs :
1141: -- Parameters :
1142: --
1143: -- Standard IN Parameters :
1144: -- p_api_version IN NUMBER Required
1145: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1146: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1147: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

Line 1150: -- Standard OUT Parameters :

1146: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1147: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1148: -- p_default IN VARCHAR2 Default FND_API.G_FALSE
1149: -- p_module_type IN VARCHAR2 Default Null
1150: -- Standard OUT Parameters :
1151: -- x_return_status OUT VARCHAR2 Required
1152: -- x_msg_count OUT NUMBER Required
1153: -- x_msg_data OUT VARCHAR2 Required
1154: --

Line 1187: -- Standard start of API savepoint

1183: 'At the start of PLSQL procedure'
1184: );
1185: END IF;
1186:
1187: -- Standard start of API savepoint
1188: SAVEPOINT Insert_Turnover_Notes;
1189:
1190: -- Standard call to check for call compatibility
1191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

Line 1190: -- Standard call to check for call compatibility

1186:
1187: -- Standard start of API savepoint
1188: SAVEPOINT Insert_Turnover_Notes;
1189:
1190: -- Standard call to check for call compatibility
1191: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END IF;
1194:

Line 1280: -- Standard check of p_commit

1276: IF x_msg_count > 0 THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: END IF;
1279:
1280: -- Standard check of p_commit
1281: IF FND_API.TO_BOOLEAN(p_commit) THEN
1282: COMMIT WORK;
1283: END IF;
1284:

Line 1285: -- Standard call to get message count and if count is 1, get message info

1281: IF FND_API.TO_BOOLEAN(p_commit) THEN
1282: COMMIT WORK;
1283: END IF;
1284:
1285: -- Standard call to get message count and if count is 1, get message info
1286: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1287: p_data => x_msg_data,
1288: p_encoded => fnd_api.g_false
1289: );