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.OE_HEADER_SCREDIT_UTIL dependencies on OE_DEBUG_PUB

Line 13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

9: FUNCTION G_MISS_OE_AK_HSCREDIT_REC
10: RETURN OE_AK_HEADER_SCREDITS_V%ROWTYPE IS
11: l_rowtype_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
12: --
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: --
15: BEGIN
16:
17: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;

Line 59: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

55: ( p_HEADER_SCREDIT_rec IN OE_Order_PUB.HEADER_SCREDIT_Rec_Type
56: , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_SCREDITS_V%ROWTYPE
57: ) IS
58: --
59: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
60: --
61: BEGIN
62:
63: x_rowtype_rec.ATTRIBUTE1 := p_header_scredit_rec.ATTRIBUTE1;

Line 104: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

100: ( p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
101: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_SCREDIT_Rec_Type
102: ) IS
103: --
104: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
105: --
106: BEGIN
107:
108: x_api_rec.ATTRIBUTE1 := p_record.ATTRIBUTE1;

Line 156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

152: l_index NUMBER :=0;
153: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
154: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159:
160: -- Load out record

Line 513: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

509: IS
510: l_Header_Scredit_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
511: l_old_Header_Scredit_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
512: --
513: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
514: --
515: BEGIN
516:
517: API_Rec_To_Rowtype_Rec(p_x_Header_Scredit_rec, l_Header_Scredit_rec);

Line 545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

541: l_out Varchar2(240);
542: l_status Varchar2(30);
543: --SG}
544: --
545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
546: --
547: BEGIN
548:
549: -- Load out record

Line 719: oe_debug_pub.add(' Warning:Null header_id for header sales credits');

715: --header not available in cache, load info to cache
716: IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
717: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
718: ELSE
719: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
720: END IF;
721: END IF;
722:
723: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN

Line 732: oe_debug_pub.add('Before get_sales_group:'||p_x_Header_Scredit_rec.sales_group_id);

728:
729: --5620190: Added the IF condition, so that Get_Sales_Group id is called only if
730: --the record doesn't have a sales group id, which could have been populated
731: --when copying order.
732: oe_debug_pub.add('Before get_sales_group:'||p_x_Header_Scredit_rec.sales_group_id);
733: IF p_x_Header_Scredit_rec.sales_group_id IS NULL THEN
734: Get_Sales_Group(p_date => l_sg_date,
735: p_sales_rep_id =>p_x_Header_Scredit_rec.salesrep_id,
736: x_sales_group_id=>p_x_Header_Scredit_rec.sales_group_id,

Line 753: oe_debug_pub.add(' Warning:Null header_id for header sales credits');

749: --header not available in cache, load info to cache
750: IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
751: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
752: ELSE
753: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
754: END IF;
755: END IF;
756:
757: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN

Line 762: oe_debug_pub.add('Before getting sales group');

758: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
759: ELSE
760: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
761: END IF;
762: oe_debug_pub.add('Before getting sales group');
763: Get_Sales_Group(p_date => l_sg_date,
764: p_sales_rep_id =>p_x_Header_Scredit_rec.salesrep_id,
765: x_sales_group_id=>p_x_Header_Scredit_rec.sales_group_id,
766: --x_sales_group =>l_out,

Line 797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

793: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
794: )
795: IS
796: --
797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
798: --
799: BEGIN
800:
801: IF p_x_Header_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

925: )
926: IS
927:
928: --
929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
930: --
931: BEGIN
932:
933: IF p_x_Header_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1066: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1062: l_return_status VARCHAR2(1);
1063:
1064:
1065: --
1066: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1067: --
1068: BEGIN
1069:
1070: SELECT lock_control

Line 1081: oe_debug_pub.add( 'JFC: SALES_CREDIT_ID' || P_HEADER_SCREDIT_REC.SALES_CREDIT_ID ) ;

1077: --calling notification framework to update global picture
1078: --check code release level first. Notification framework is at Pack H level
1079: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add( 'JFC: SALES_CREDIT_ID' || P_HEADER_SCREDIT_REC.SALES_CREDIT_ID ) ;
1082: END IF;
1083: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
1084: p_Hdr_scr_rec =>p_header_scredit_rec,
1085: p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,

Line 1089: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;

1085: p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,
1086: x_index => l_index,
1087: x_return_status => l_return_status);
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1090: END IF;
1091: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

1089: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1090: END IF;
1091: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1094: END IF;
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1097: END IF;

Line 1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1094: END IF;
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1097: END IF;
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: IF l_debug_level > 0 THEN

Line 1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;

1097: END IF;
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
1102: END IF;
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1105: END IF;

Line 1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;

1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
1102: END IF;
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1105: END IF;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: END IF; /*code_release_level*/

Line 1177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1173: l_lock_control NUMBER:= 1;
1174: l_index NUMBER;
1175: l_return_status VARCHAR2(1);
1176: --
1177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1178: --
1179: BEGIN
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

Line 1181: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1178: --
1179: BEGIN
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1182: END IF;
1183:
1184: INSERT INTO OE_SALES_CREDITS
1185: ( ATTRIBUTE1

Line 1271: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;

1267: p_hdr_scr_id => p_header_scredit_rec.sales_credit_id,
1268: x_index => l_index,
1269: x_return_status => l_return_status);
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
1272: END IF;
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
1275: END IF;

Line 1274: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;

1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
1272: END IF;
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
1275: END IF;
1276:
1277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1278: IF l_debug_level > 0 THEN

Line 1279: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

1275: END IF;
1276:
1277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1278: IF l_debug_level > 0 THEN
1279: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1280: END IF;
1281: IF l_debug_level > 0 THEN
1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1283: END IF;

Line 1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1278: IF l_debug_level > 0 THEN
1279: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1280: END IF;
1281: IF l_debug_level > 0 THEN
1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1283: END IF;
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: IF l_debug_level > 0 THEN

Line 1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;

1283: END IF;
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: IF l_debug_level > 0 THEN
1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
1288: END IF;
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1291: END IF;

Line 1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1286: IF l_debug_level > 0 THEN
1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
1288: END IF;
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1291: END IF;
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294: END IF; /*code_release_level*/

Line 1298: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;

1294: END IF; /*code_release_level*/
1295: -- notification framework end
1296:
1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1299: END IF;
1300:
1301: EXCEPTION
1302:

Line 1335: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1331: -- added for notification framework
1332: l_new_header_scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1333: l_index NUMBER;
1334: --
1335: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1336: --
1337: BEGIN
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

Line 1339: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1335: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1336: --
1337: BEGIN
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1340: END IF;
1341:
1342: IF p_header_id <> FND_API.G_MISS_NUM
1343: THEN

Line 1359: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

1355: p_hdr_scr_id => l_scr.sales_credit_id,
1356: x_index => l_index,
1357: x_return_status => l_return_status);
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

1359: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1364: END IF;
1365: IF l_debug_level > 0 THEN
1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1367: END IF;

Line 1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1364: END IF;
1365: IF l_debug_level > 0 THEN
1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1367: END IF;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: IF l_debug_level > 0 THEN

Line 1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;

1367: END IF;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1372: END IF;
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1375: END IF;

Line 1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1372: END IF;
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1375: END IF;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378: END IF; /*code_release_level*/

Line 1408: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;

1404: p_hdr_scr_id => p_sales_credit_id,
1405: x_index => l_index,
1406: x_return_status => l_return_status);
1407: IF l_debug_level > 0 THEN
1408: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1409: END IF;
1410:
1411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: IF l_debug_level > 0 THEN

Line 1413: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

1409: END IF;
1410:
1411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1414: END IF;
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1417: END IF;

Line 1416: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1414: END IF;
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1417: END IF;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1420: IF l_debug_level > 0 THEN

Line 1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;

1417: END IF;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1422: END IF;
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1425: END IF;

Line 1424: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;

1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1422: END IF;
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1425: END IF;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428: END IF; /*code_release_level*/

Line 1481: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1477: )
1478: IS
1479: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1480: --
1481: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1482: --
1483: BEGIN
1484:
1485: Query_Rows

Line 1590: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1586: l_implicit_rec l_header_scredit_csr_s%ROWTYPE;
1587: l_entity NUMBER;
1588:
1589: --
1590: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1591: --
1592: BEGIN
1593:
1594: IF

Line 1731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1727: l_sales_credit_id NUMBER;
1728: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1729: l_lock_control NUMBER;
1730: --
1731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1732: --
1733: BEGIN
1734:
1735: IF l_debug_level > 0 THEN

Line 1736: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;

1732: --
1733: BEGIN
1734:
1735: IF l_debug_level > 0 THEN
1736: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.LOCK_ROW' , 1 ) ;
1737: END IF;
1738:
1739: SAVEPOINT Lock_Row;
1740:

Line 1758: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;

1754: WHERE sales_credit_id = l_sales_credit_id
1755: FOR UPDATE NOWAIT;
1756:
1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
1759: END IF;
1760:
1761: OE_Header_Scredit_Util.Query_Row
1762: (p_sales_credit_id => l_sales_credit_id

Line 1873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1869: FOR UPDATE NOWAIT;
1870:
1871: l_sales_credit_id NUMBER;
1872: --
1873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1874: --
1875: BEGIN
1876:
1877: IF l_debug_level > 0 THEN

Line 1878: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;

1874: --
1875: BEGIN
1876:
1877: IF l_debug_level > 0 THEN
1878: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;
1879: END IF;
1880:
1881: IF (p_sales_credit_id IS NOT NULL AND
1882: p_sales_credit_id <> FND_API.G_MISS_NUM) AND

Line 1950: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;

1946:
1947: x_return_status := FND_API.G_RET_STS_SUCCESS;
1948:
1949: IF l_debug_level > 0 THEN
1950: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;
1951: END IF;
1952:
1953: EXCEPTION
1954: WHEN NO_DATA_FOUND THEN

Line 1998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1994: )RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type
1995: IS
1996: l_Header_Scredit_val_rec OE_Order_PUB.Header_Scredit_Val_Rec_Type;
1997: --
1998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1999: --
2000: --sg{
2001: l_sg_name Varchar2(60);
2002: --sg}

Line 2038: Oe_Debug_Pub.add('OEXUHSCB.pls--get_values:'||SQLERRM);

2034: Exception
2035: When no_data_found Then
2036: l_Header_Scredit_val_rec.sales_group:='Group name not available';
2037: When others then
2038: Oe_Debug_Pub.add('OEXUHSCB.pls--get_values:'||SQLERRM);
2039: End;
2040: End If;
2041: --SG}
2042:

Line 2056: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2052: )
2053: IS
2054:
2055: --
2056: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2057: --
2058: BEGIN
2059:
2060: -- initialize return_status.

Line 2139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2135: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC )
2136: IS
2137: l_return_status varchar2(30);
2138: --
2139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2140: --
2141: BEGIN
2142:
2143: --11.5.10 Versioning/Audit Trail updates

Line 2154: OE_DEBUG_PUB.add('Reason code missing for versioning', 1);

2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;
2151: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2152: ELSE
2153: IF l_debug_level > 0 THEN
2154: OE_DEBUG_PUB.add('Reason code missing for versioning', 1);
2155: END IF;
2156: IF OE_GLOBALS.G_UI_FLAG THEN
2157: raise FND_API.G_EXC_ERROR;
2158: END IF;

Line 2164: oe_debug_pub.add('log versioning request',1);

2160: END IF;
2161:
2162: --log delayed request
2163: IF l_debug_level > 0 THEN
2164: oe_debug_pub.add('log versioning request',1);
2165: END IF;
2166: OE_Delayed_Requests_Pvt.Log_Request(p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2167: p_entity_id => p_x_header_scredit_rec.header_id,
2168: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

Line 2178: oe_debug_pub.add( 'AUDIT TRAIL , CHANGE ATTRIBUTE REQUIRES REASON' , 1 ) ;

2174: IF (p_x_header_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2175:
2176: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
2177: IF l_debug_level > 0 THEN
2178: oe_debug_pub.add( 'AUDIT TRAIL , CHANGE ATTRIBUTE REQUIRES REASON' , 1 ) ;
2179: END IF;
2180: IF (p_x_header_scredit_rec.change_reason IS NULL OR
2181: p_x_header_scredit_rec.change_reason = FND_API.G_MISS_CHAR OR
2182: NOT OE_Validate.Change_Reason_Code(p_x_header_scredit_rec.change_reason)) THEN

Line 2186: oe_debug_pub.add('Defaulting Audit Reason for Order Sales Credit', 1);

2182: NOT OE_Validate.Change_Reason_Code(p_x_header_scredit_rec.change_reason)) THEN
2183: -- bug 3636884, defaulting reason from group API
2184: IF OE_GLOBALS.G_DEFAULT_REASON THEN
2185: if l_debug_level > 0 then
2186: oe_debug_pub.add('Defaulting Audit Reason for Order Sales Credit', 1);
2187: end if;
2188: p_x_header_scredit_rec.change_reason := 'SYSTEM';
2189: ELSE
2190: IF l_debug_level > 0 THEN

Line 2191: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);

2187: end if;
2188: p_x_header_scredit_rec.change_reason := 'SYSTEM';
2189: ELSE
2190: IF l_debug_level > 0 THEN
2191: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
2192: END IF;
2193: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
2194: fnd_message.set_token('OBJECT','ORDER SALES CREDIT');
2195: oe_msg_pub.add;

Line 2203: oe_debug_pub.add( 'OEXUHSCB:Calling oe_order_chg_pvt.recordhscredithist') ;

2199: END IF;
2200: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2201: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
2202: IF l_debug_level > 0 THEN
2203: oe_debug_pub.add( 'OEXUHSCB:Calling oe_order_chg_pvt.recordhscredithist') ;
2204: END IF;
2205: --11.5.10 Versioning/Audit Trail updates
2206: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2207: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_SCREDIT,

Line 2232: oe_debug_pub.add( 'INSERTING HEADER SCREDIT HISTORY CAUSED ERROR' , 1 ) ;

2228: x_return_status => l_return_status);
2229: END IF;
2230: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'INSERTING HEADER SCREDIT HISTORY CAUSED ERROR' , 1 ) ;
2233: END IF;
2234: if l_return_status = FND_API.G_RET_STS_ERROR then
2235: raise FND_API.G_EXC_ERROR;
2236: else

Line 2257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2253: i PLS_INTEGER;
2254: plsql_block Varchar2(2000);
2255: l_nlp Number;
2256: --
2257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2258: --
2259: Begin
2260: x_return_status := FND_API.G_RET_STS_SUCCESS;
2261:

Line 2326: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2322: x_msg_count NUMBER;
2323: x_msg_data VARCHAR2(2000);
2324: l_header_id NUMBER;
2325: --
2326: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2327: --
2328: Begin
2329:
2330: IF l_debug_level > 0 THEN

Line 2331: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;

2327: --
2328: Begin
2329:
2330: IF l_debug_level > 0 THEN
2331: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;
2332: END IF;
2333:
2334: BEGIN
2335: SELECT header_id INTO l_header_id

Line 2341: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP,header not created' , 1 ) ;

2337: WHERE header_id = p_header_id;
2338: EXCEPTION
2339: WHEN NO_DATA_FOUND THEN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP,header not created' , 1 ) ;
2342: END IF;
2343: RETURN;
2344: END;
2345:

Line 2493: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;

2489: OE_MSG_PUB.Add;
2490: END IF;
2491:
2492: IF l_debug_level > 0 THEN
2493: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;
2494: END IF;
2495:
2496: EXCEPTION
2497:

Line 2532: oe_debug_pub.add('OE_GLOBALS.G_ORG_ID IS null');

2528:
2529: G_ORG_ID := OE_GLOBALS.G_ORG_ID;
2530:
2531: IF G_ORG_ID IS NULL THEN
2532: oe_debug_pub.add('OE_GLOBALS.G_ORG_ID IS null');
2533: END IF;
2534:
2535: Begin
2536: x_sales_group_id:=jtf_rs_integration_pub.get_default_sales_group(p_sales_rep_id,g_org_id,p_date);

Line 2539: oe_debug_pub.add('Setting sales group id to null:'||SQLERRM);

2535: Begin
2536: x_sales_group_id:=jtf_rs_integration_pub.get_default_sales_group(p_sales_rep_id,g_org_id,p_date);
2537: Exception
2538: When others Then
2539: oe_debug_pub.add('Setting sales group id to null:'||SQLERRM);
2540: x_sales_group_id:=null;
2541: End;
2542:
2543: Exception

Line 2568: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2564:
2565: j number:=1;
2566: l_status Varchar2(30);
2567: l_sales_group_id Number;
2568: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2569: Begin
2570:
2571: if l_debug_level > 0 then
2572: oe_debug_pub.add('Entering redefault sales group');

Line 2572: oe_debug_pub.add('Entering redefault sales group');

2568: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2569: Begin
2570:
2571: if l_debug_level > 0 then
2572: oe_debug_pub.add('Entering redefault sales group');
2573: end if;
2574:
2575: For i In none_fixed_sales_group Loop
2576: Get_Sales_Group(p_date =>p_date

Line 2582: oe_debug_pub.add(' sales credit id passed:'||i.salesrep_id);

2578: ,x_sales_group_id=>l_sales_group_id
2579: ,x_return_status =>l_status);
2580:
2581: if l_debug_level > 0 then
2582: oe_debug_pub.add(' sales credit id passed:'||i.salesrep_id);
2583: oe_debug_pub.add(' date passed:'||p_date);
2584: oe_debug_pub.add(' return status from get_sales_group:'||l_status);
2585: end if;
2586:

Line 2583: oe_debug_pub.add(' date passed:'||p_date);

2579: ,x_return_status =>l_status);
2580:
2581: if l_debug_level > 0 then
2582: oe_debug_pub.add(' sales credit id passed:'||i.salesrep_id);
2583: oe_debug_pub.add(' date passed:'||p_date);
2584: oe_debug_pub.add(' return status from get_sales_group:'||l_status);
2585: end if;
2586:
2587: If l_status = FND_API.G_RET_STS_SUCCESS

Line 2584: oe_debug_pub.add(' return status from get_sales_group:'||l_status);

2580:
2581: if l_debug_level > 0 then
2582: oe_debug_pub.add(' sales credit id passed:'||i.salesrep_id);
2583: oe_debug_pub.add(' date passed:'||p_date);
2584: oe_debug_pub.add(' return status from get_sales_group:'||l_status);
2585: end if;
2586:
2587: If l_status = FND_API.G_RET_STS_SUCCESS
2588: and nvl(l_sales_group_id,-101) <> nvl(i.sales_group_id,-101) Then

Line 2590: oe_debug_pub.add(' l_sales_group_id_tbl index j:'||j);

2586:
2587: If l_status = FND_API.G_RET_STS_SUCCESS
2588: and nvl(l_sales_group_id,-101) <> nvl(i.sales_group_id,-101) Then
2589: if l_debug_level > 0 then
2590: oe_debug_pub.add(' l_sales_group_id_tbl index j:'||j);
2591: oe_debug_pub.add(' old sales group id:'||i.sales_credit_id);
2592: oe_debug_pub.add(' new sales group id:'||l_sales_group_id);
2593: end if;
2594: l_sales_group_id_tbl(j):=l_sales_group_id;

Line 2591: oe_debug_pub.add(' old sales group id:'||i.sales_credit_id);

2587: If l_status = FND_API.G_RET_STS_SUCCESS
2588: and nvl(l_sales_group_id,-101) <> nvl(i.sales_group_id,-101) Then
2589: if l_debug_level > 0 then
2590: oe_debug_pub.add(' l_sales_group_id_tbl index j:'||j);
2591: oe_debug_pub.add(' old sales group id:'||i.sales_credit_id);
2592: oe_debug_pub.add(' new sales group id:'||l_sales_group_id);
2593: end if;
2594: l_sales_group_id_tbl(j):=l_sales_group_id;
2595: l_sales_credit_id_tbl(j):=i.sales_credit_id;

Line 2592: oe_debug_pub.add(' new sales group id:'||l_sales_group_id);

2588: and nvl(l_sales_group_id,-101) <> nvl(i.sales_group_id,-101) Then
2589: if l_debug_level > 0 then
2590: oe_debug_pub.add(' l_sales_group_id_tbl index j:'||j);
2591: oe_debug_pub.add(' old sales group id:'||i.sales_credit_id);
2592: oe_debug_pub.add(' new sales group id:'||l_sales_group_id);
2593: end if;
2594: l_sales_group_id_tbl(j):=l_sales_group_id;
2595: l_sales_credit_id_tbl(j):=i.sales_credit_id;
2596: if l_debug_level > 0 then

Line 2597: oe_debug_pub.add(' group id in tbl:'||l_sales_group_id_tbl(j));

2593: end if;
2594: l_sales_group_id_tbl(j):=l_sales_group_id;
2595: l_sales_credit_id_tbl(j):=i.sales_credit_id;
2596: if l_debug_level > 0 then
2597: oe_debug_pub.add(' group id in tbl:'||l_sales_group_id_tbl(j));
2598: oe_debug_pub.add(' sales credit id in tbl:'||l_sales_credit_id_tbl(j));
2599: end if;
2600: j:=j+1;
2601: End If;

Line 2598: oe_debug_pub.add(' sales credit id in tbl:'||l_sales_credit_id_tbl(j));

2594: l_sales_group_id_tbl(j):=l_sales_group_id;
2595: l_sales_credit_id_tbl(j):=i.sales_credit_id;
2596: if l_debug_level > 0 then
2597: oe_debug_pub.add(' group id in tbl:'||l_sales_group_id_tbl(j));
2598: oe_debug_pub.add(' sales credit id in tbl:'||l_sales_credit_id_tbl(j));
2599: end if;
2600: j:=j+1;
2601: End If;
2602: End Loop;

Line 2612: oe_debug_pub.add('Leaving redefault sales group');

2608: WHERE Sales_Credit_Id = l_sales_credit_id_tbl(i);
2609: END IF;
2610:
2611: if l_debug_level > 0 then
2612: oe_debug_pub.add('Leaving redefault sales group');
2613: end If;
2614: Exception
2615: When Others Then
2616: Oe_Debug_Pub.add('Exception occured OE_Header_Scredit_Util.Redefaut..:'||SQLERRM);

Line 2616: Oe_Debug_Pub.add('Exception occured OE_Header_Scredit_Util.Redefaut..:'||SQLERRM);

2612: oe_debug_pub.add('Leaving redefault sales group');
2613: end If;
2614: Exception
2615: When Others Then
2616: Oe_Debug_Pub.add('Exception occured OE_Header_Scredit_Util.Redefaut..:'||SQLERRM);
2617: End;
2618: --SG}
2619:
2620: