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

Line 1: PACKAGE BODY CSD_SPLIT_PKG as

1: PACKAGE BODY CSD_SPLIT_PKG as
2: /* $Header: csdspltb.pls 120.13.12020000.2 2013/01/23 20:47:26 vicli ship $ */
3: -- Start of Comments
4: -- Package name : CSD_SPLIT_PKG
5: -- Purpose :

Line 4: -- Package name : CSD_SPLIT_PKG

1: PACKAGE BODY CSD_SPLIT_PKG as
2: /* $Header: csdspltb.pls 120.13.12020000.2 2013/01/23 20:47:26 vicli ship $ */
3: -- Start of Comments
4: -- Package name : CSD_SPLIT_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_SPLIT_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_SPLIT_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(15) := 'csdspltb.pls';
12:
13: PROCEDURE Split_Repair_Order (
14: p_api_version IN NUMBER,

Line 64: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',

60: Begin
61:
62: IF(l_procedure_level >= l_debug_level) THEN
63: FND_LOG.STRING(l_procedure_level,
64: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
65: 'Entered Split_Repair_Order API');
66: END IF;
67:
68: IF(l_statement_level >= l_debug_level) THEN

Line 70: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',

66: END IF;
67:
68: IF(l_statement_level >= l_debug_level) THEN
69: FND_LOG.STRING(l_statement_level,
70: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
71: 'Enabling the Split_Repair_Order savepoint');
72: END IF;
73:
74: -- Standard Start of API Savepoint

Line 75: SAVEPOINT CSD_SPLIT_PKG ;

71: 'Enabling the Split_Repair_Order savepoint');
72: END IF;
73:
74: -- Standard Start of API Savepoint
75: SAVEPOINT CSD_SPLIT_PKG ;
76:
77: -- Standard Call to check API compatibility
78: IF NOT FND_API.Compatible_API_Call( l_api_version,
79: p_api_version,

Line 106: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','failed');

102: x_return_status => x_return_status
103: );
104: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
105: IF(l_statement_level >= l_debug_level) THEN
106: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','failed');
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:

Line 173: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');

169: p_rep_line_rec => l_rep_line_rec
170: );
171: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
172: IF(l_statement_level >= l_debug_level) THEN
173: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
174: END IF;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:

Line 312: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');

308: p_rep_line_rec => l_rep_line_rec
309: );
310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
311: IF(l_statement_level >= l_debug_level) THEN
312: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:

Line 402: ROLLBACK TO CSD_SPLIT_PKG;

398: p_data => x_msg_data
399: );
400: EXCEPTION
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO CSD_SPLIT_PKG;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,
406: p_data => x_msg_data

Line 410: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',

406: p_data => x_msg_data
407: );
408: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
409: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
410: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
411: 'EXC_ERROR ['||x_msg_data||']');
412: END IF;
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO CSD_SPLIT_PKG;

Line 414: ROLLBACK TO CSD_SPLIT_PKG;

410: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
411: 'EXC_ERROR ['||x_msg_data||']');
412: END IF;
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO CSD_SPLIT_PKG;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data

Line 422: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',

418: p_data => x_msg_data
419: );
420: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
421: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
422: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
423: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
424: END IF;
425: WHEN OTHERS THEN
426: ROLLBACK TO CSD_SPLIT_PKG;

Line 426: ROLLBACK TO CSD_SPLIT_PKG;

422: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
423: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
424: END IF;
425: WHEN OTHERS THEN
426: ROLLBACK TO CSD_SPLIT_PKG;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: IF FND_MSG_PUB.Check_Msg_Level
429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN

Line 442: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',

438: p_data => x_msg_data
439: );
440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
442: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
443: 'SQL Message ['||sqlerrm||']');
444: END IF;
445:
446: End Split_Repair_Order;

Line 543: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','At the Begin in Build_Repln_Record');

539: -- Initialize API return status to success
540: x_return_status := FND_API.G_RET_STS_SUCCESS;
541:
542: IF(l_statement_level >= l_debug_level) THEN
543: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','At the Begin in Build_Repln_Record');
544: END IF;
545:
546: IF NVL(p_repair_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
547:

Line 639: ROLLBACK TO CSD_SPLIT_PKG;

635: END IF;
636:
637: EXCEPTION
638: WHEN FND_API.G_EXC_ERROR THEN
639: ROLLBACK TO CSD_SPLIT_PKG;
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO CSD_SPLIT_PKG;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 642: ROLLBACK TO CSD_SPLIT_PKG;

638: WHEN FND_API.G_EXC_ERROR THEN
639: ROLLBACK TO CSD_SPLIT_PKG;
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO CSD_SPLIT_PKG;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
644: WHEN OTHERS THEN
645: ROLLBACK TO CSD_SPLIT_PKG;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 645: ROLLBACK TO CSD_SPLIT_PKG;

641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO CSD_SPLIT_PKG;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
644: WHEN OTHERS THEN
645: ROLLBACK TO CSD_SPLIT_PKG;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: End Build_Repln_Record;
648:
649:

Line 787: ROLLBACK TO CSD_SPLIT_PKG;

783:
784: -- Standard call to get message count and if count is 1, get message info.
785: EXCEPTION
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO CSD_SPLIT_PKG;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: ROLLBACK TO CSD_SPLIT_PKG;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 790: ROLLBACK TO CSD_SPLIT_PKG;

786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO CSD_SPLIT_PKG;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: ROLLBACK TO CSD_SPLIT_PKG;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: WHEN OTHERS THEN
793: ROLLBACK TO CSD_SPLIT_PKG;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 793: ROLLBACK TO CSD_SPLIT_PKG;

789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: ROLLBACK TO CSD_SPLIT_PKG;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
792: WHEN OTHERS THEN
793: ROLLBACK TO CSD_SPLIT_PKG;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
795: End Build_Product_TXN_Record;
796:
797:

Line 1006: ROLLBACK TO CSD_SPLIT_PKG;

1002: );
1003:
1004: EXCEPTION
1005: WHEN FND_API.G_EXC_ERROR THEN
1006: ROLLBACK TO CSD_SPLIT_PKG;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: FND_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count,
1010: p_data => x_msg_data

Line 1014: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',

1010: p_data => x_msg_data
1011: );
1012: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1013: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1014: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1015: 'EXC_ERROR ['||x_msg_data||']');
1016: END IF;
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO CSD_SPLIT_PKG;

Line 1018: ROLLBACK TO CSD_SPLIT_PKG;

1014: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1015: 'EXC_ERROR ['||x_msg_data||']');
1016: END IF;
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ROLLBACK TO CSD_SPLIT_PKG;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: FND_MSG_PUB.Count_And_Get
1021: ( p_count => x_msg_count,
1022: p_data => x_msg_data

Line 1026: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',

1022: p_data => x_msg_data
1023: );
1024: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1025: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1026: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1027: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1028: END IF;
1029: WHEN OTHERS THEN
1030: ROLLBACK TO CSD_SPLIT_PKG;

Line 1030: ROLLBACK TO CSD_SPLIT_PKG;

1026: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1027: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1028: END IF;
1029: WHEN OTHERS THEN
1030: ROLLBACK TO CSD_SPLIT_PKG;
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level
1033: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN

Line 1046: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',

1042: p_data => x_msg_data
1043: );
1044: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1046: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1047: 'SQL Message ['||sqlerrm||']');
1048: END IF;
1049:
1050: End Is_Split_Repair_Order_Allow;

Line 1132: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Product_TXN_Record','failed');

1128: x_return_status => x_return_status
1129: );
1130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1131: IF(l_statement_level >= l_debug_level) THEN
1132: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Product_TXN_Record','failed');
1133: END IF;
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:

Line 1209: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Ship_Prod_Txn_Tbl','failed');

1205: x_return_status => x_return_status );
1206:
1207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1208: IF(l_statement_level >= l_debug_level) THEN
1209: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Ship_Prod_Txn_Tbl','failed');
1210: END IF;
1211: RAISE FND_API.G_EXC_ERROR;
1212: END IF;
1213:

Line 1251: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History','failed');

1247: p_new_repair_line_id => l_repair_line_id);
1248:
1249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1250: IF(l_statement_level >= l_debug_level) THEN
1251: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History','failed');
1252: END IF;
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;
1255:

Line 1269: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes','failed');

1265: p_new_repair_line_id => l_repair_line_id);
1266:
1267: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1268: IF(l_statement_level >= l_debug_level) THEN
1269: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes','failed');
1270: END IF;
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:

Line 1309: ROLLBACK TO CSD_SPLIT_PKG;

1305: );
1306:
1307: EXCEPTION
1308: WHEN FND_API.G_EXC_ERROR THEN
1309: ROLLBACK TO CSD_SPLIT_PKG;
1310: x_return_status := FND_API.G_RET_STS_ERROR;
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data

Line 1317: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',

1313: p_data => x_msg_data
1314: );
1315: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1316: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1317: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1318: 'EXC_ERROR ['||x_msg_data||']');
1319: END IF;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO CSD_SPLIT_PKG;

Line 1321: ROLLBACK TO CSD_SPLIT_PKG;

1317: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1318: 'EXC_ERROR ['||x_msg_data||']');
1319: END IF;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO CSD_SPLIT_PKG;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1323: FND_MSG_PUB.Count_And_Get
1324: ( p_count => x_msg_count,
1325: p_data => x_msg_data

Line 1329: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',

1325: p_data => x_msg_data
1326: );
1327: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1328: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1329: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1330: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1331: END IF;
1332: WHEN OTHERS THEN
1333: ROLLBACK TO CSD_SPLIT_PKG;

Line 1333: ROLLBACK TO CSD_SPLIT_PKG;

1329: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1330: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1331: END IF;
1332: WHEN OTHERS THEN
1333: ROLLBACK TO CSD_SPLIT_PKG;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1335: IF FND_MSG_PUB.Check_Msg_Level
1336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1337: THEN

Line 1349: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',

1345: p_data => x_msg_data
1346: );
1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1348: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1349: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1350: 'SQL Message ['||sqlerrm||']');
1351: END IF;
1352:
1353: End Create_New_Repair_Order;

Line 1409: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repair_History_Record','failed');

1405: x_return_status => x_return_status
1406: );
1407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1408: IF(l_statement_level >= l_debug_level) THEN
1409: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repair_History_Record','failed');
1410: END IF;
1411: RAISE FND_API.G_EXC_ERROR;
1412: END IF;
1413:

Line 1455: ROLLBACK TO CSD_SPLIT_PKG;

1451: p_data => x_msg_data
1452: );
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: ROLLBACK TO CSD_SPLIT_PKG;
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: FND_MSG_PUB.Count_And_Get
1458: ( p_count => x_msg_count,
1459: p_data => x_msg_data

Line 1463: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',

1459: p_data => x_msg_data
1460: );
1461: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1462: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1463: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1464: 'EXC_ERROR ['||x_msg_data||']');
1465: END IF;
1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1467: ROLLBACK TO CSD_SPLIT_PKG;

Line 1467: ROLLBACK TO CSD_SPLIT_PKG;

1463: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1464: 'EXC_ERROR ['||x_msg_data||']');
1465: END IF;
1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1467: ROLLBACK TO CSD_SPLIT_PKG;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1469: FND_MSG_PUB.Count_And_Get
1470: ( p_count => x_msg_count,
1471: p_data => x_msg_data

Line 1475: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',

1471: p_data => x_msg_data
1472: );
1473: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1475: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1476: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1477: END IF;
1478: WHEN OTHERS THEN
1479: ROLLBACK TO CSD_SPLIT_PKG;

Line 1479: ROLLBACK TO CSD_SPLIT_PKG;

1475: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1476: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1477: END IF;
1478: WHEN OTHERS THEN
1479: ROLLBACK TO CSD_SPLIT_PKG;
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1481: IF FND_MSG_PUB.Check_Msg_Level
1482: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1483: THEN

Line 1495: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',

1491: p_data => x_msg_data
1492: );
1493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1495: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1496: 'SQL Message ['||sqlerrm||']');
1497: END IF;
1498:
1499: End Copy_Repair_History;

Line 1682: ROLLBACK TO CSD_SPLIT_PKG;

1678: );
1679:
1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: ROLLBACK TO CSD_SPLIT_PKG;
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: FND_MSG_PUB.Count_And_Get
1685: ( p_count => x_msg_count,
1686: p_data => x_msg_data

Line 1690: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',

1686: p_data => x_msg_data
1687: );
1688: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1690: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1691: 'EXC_ERROR ['||x_msg_data||']');
1692: END IF;
1693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1694: ROLLBACK TO CSD_SPLIT_PKG;

Line 1694: ROLLBACK TO CSD_SPLIT_PKG;

1690: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1691: 'EXC_ERROR ['||x_msg_data||']');
1692: END IF;
1693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1694: ROLLBACK TO CSD_SPLIT_PKG;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1696: FND_MSG_PUB.Count_And_Get
1697: ( p_count => x_msg_count,
1698: p_data => x_msg_data

Line 1702: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',

1698: p_data => x_msg_data
1699: );
1700: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1701: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1702: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1703: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1704: END IF;
1705: WHEN OTHERS THEN
1706: ROLLBACK TO CSD_SPLIT_PKG;

Line 1706: ROLLBACK TO CSD_SPLIT_PKG;

1702: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1703: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1704: END IF;
1705: WHEN OTHERS THEN
1706: ROLLBACK TO CSD_SPLIT_PKG;
1707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1708: IF FND_MSG_PUB.Check_Msg_Level
1709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1710: THEN

Line 1722: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',

1718: p_data => x_msg_data
1719: );
1720: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1721: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
1722: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1723: 'SQL Message ['||sqlerrm||']');
1724: END IF;
1725: End Copy_JTF_Notes;
1726:

Line 1906: End CSD_SPLIT_PKG;

1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1903: END build_ship_prod_txn_tbl;
1904:
1905:
1906: End CSD_SPLIT_PKG;
1907: