DBA Data[Home] [Help]

APPS.QP_DEFAULT_PRICE_LIST dependencies on OE_DEBUG_PUB

Line 19: oe_debug_pub.add('entering automatic');

15: RETURN VARCHAR2
16: IS
17: BEGIN
18:
19: oe_debug_pub.add('entering automatic');
20:
21: oe_debug_pub.add('exiting automatic');
22:
23: RETURN 'Y';

Line 21: oe_debug_pub.add('exiting automatic');

17: BEGIN
18:
19: oe_debug_pub.add('entering automatic');
20:
21: oe_debug_pub.add('exiting automatic');
22:
23: RETURN 'Y';
24:
25: END Get_Automatic;

Line 62: oe_debug_Pub.add('entering currency');

58: l_currency_code VARCHAR2(15) := '';
59: l_org_id NUMBER;
60: BEGIN
61:
62: oe_debug_Pub.add('entering currency');
63:
64: --added for moac to call Oe_sys_params only if org_id is not null
65: l_org_id := QP_UTIL.get_org_id;
66: IF l_org_id IS NOT NULL THEN

Line 81: oe_debug_Pub.add('exiting currency');

77: WHERE SET_OF_BOOKS_ID = l_set_of_books_id;
78:
79: END IF;
80:
81: oe_debug_Pub.add('exiting currency');
82:
83: RETURN l_currency_code;
84:
85: EXCEPTION

Line 156: oe_debug_pub.add('Entering QP_Default_Price_List.Get_Price_List');

152: IS
153: l_list_header_id NUMBER := NULL;
154: BEGIN
155:
156: oe_debug_pub.add('Entering QP_Default_Price_List.Get_Price_List');
157:
158: select qp_list_headers_b_s.nextval into l_list_header_id
159: from dual;
160:

Line 161: oe_debug_pub.add('Exiting QP_Default_Price_List.Get_Price_List');

157:
158: select qp_list_headers_b_s.nextval into l_list_header_id
159: from dual;
160:
161: oe_debug_pub.add('Exiting QP_Default_Price_List.Get_Price_List');
162: RETURN l_list_header_id;
163:
164: EXCEPTION
165:

Line 474: oe_debug_pub.add('entering get_rounding_factor');

470: l_extended_precision number := 0;
471:
472: BEGIN
473:
474: oe_debug_pub.add('entering get_rounding_factor');
475:
476: l_unit_precision_type :=
477: FND_PROFILE.VALUE('QP_UNIT_PRICE_PRECISION_TYPE');
478:

Line 487: oe_debug_pub.add('exiting get_rounding_factor');

483: FROM FND_CURRENCIES
484: WHERE CURRENCY_CODE = G_PRICE_LIST_REC.CURRENCY_CODE;
485:
486: IF l_unit_precision_type = 'STANDARD' THEN
487: oe_debug_pub.add('exiting get_rounding_factor');
488: return l_precision;
489: ELSE
490: return l_extended_precision;
491: END IF;

Line 526: oe_debug_pub.add('entering start date active');

522: IS
523: l_sysdate date;
524: BEGIN
525:
526: oe_debug_pub.add('entering start date active');
527: SELECT TRUNC(SYSDATE)
528: INTO l_sysdate
529: FROM DUAL;
530:

Line 531: oe_debug_pub.add('exiting start date active');

527: SELECT TRUNC(SYSDATE)
528: INTO l_sysdate
529: FROM DUAL;
530:
531: oe_debug_pub.add('exiting start date active');
532:
533: RETURN l_sysdate;
534:
535: EXCEPTION

Line 710: oe_debug_pub.add('entering attributes');

706: IS
707: g_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
708: BEGIN
709:
710: oe_debug_pub.add('entering attributes');
711:
712: -- Check number of iterations.
713:
714: IF p_iteration > QP_GLOBALS.G_MAX_DEF_ITERATIONS THEN

Line 1157: oe_debug_pub.add('start date active is not null');

1153:
1154: /*
1155: IF g_PRICE_LIST_rec.start_date_active IS NOT NULL THEN
1156:
1157: oe_debug_pub.add('start date active is not null');
1158:
1159: IF QP_Validate.Start_Date_Active(g_PRICE_LIST_rec.start_date_active)
1160: THEN
1161: oe_debug_pub.add('valid start date');

Line 1161: oe_debug_pub.add('valid start date');

1157: oe_debug_pub.add('start date active is not null');
1158:
1159: IF QP_Validate.Start_Date_Active(g_PRICE_LIST_rec.start_date_active)
1160: THEN
1161: oe_debug_pub.add('valid start date');
1162: QP_Price_List_Util.Clear_Dependent_Attr
1163: ( p_attr_id => QP_Price_List_Util.G_START_DATE_ACTIVE
1164: , p_PRICE_LIST_rec => g_PRICE_LIST_rec
1165: , x_PRICE_LIST_rec => g_PRICE_LIST_rec

Line 1168: oe_debug_pub.add('setting start date to be null');

1164: , p_PRICE_LIST_rec => g_PRICE_LIST_rec
1165: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1166: );
1167: ELSE
1168: oe_debug_pub.add('setting start date to be null');
1169: g_PRICE_LIST_rec.start_date_active := NULL;
1170: END IF;
1171:
1172: END IF;

Line 1179: oe_debug_pub.add('defaulting terms id');

1175: END IF;
1176:
1177: IF g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1178:
1179: oe_debug_pub.add('defaulting terms id');
1180: g_PRICE_LIST_rec.terms_id := Get_Terms;
1181:
1182: IF g_PRICE_LIST_rec.terms_id IS NOT NULL THEN
1183:

Line 1197: oe_debug_pub.add('defaulted terms id');

1193: g_PRICE_LIST_rec.terms_id := NULL;
1194: END IF;
1195:
1196: END IF;
1197: oe_debug_pub.add('defaulted terms id');
1198:
1199: END IF;
1200:
1201: --Blanket Sales Order

Line 1216: oe_debug_pub.add('setting list_source_code and orig_system_header_ref to be null');

1212: , p_PRICE_LIST_rec => g_p_PRICE_LIST_rec
1213: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1214: );
1215: ELSE
1216: oe_debug_pub.add('setting list_source_code and orig_system_header_ref to be null');
1217: g_PRICE_LIST_rec.list_source_code := NULL;
1218: END IF;
1219:
1220: END IF;

Line 1238: oe_debug_pub.add('setting list_source_code and orig_system_header_ref to be null');

1234: , p_PRICE_LIST_rec => g_PRICE_LIST_rec
1235: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1236: );
1237: ELSE
1238: oe_debug_pub.add('setting list_source_code and orig_system_header_ref to be null');
1239: g_PRICE_LIST_rec.list_source_code := NULL;
1240: END IF;
1241:
1242: END IF;

Line 1261: oe_debug_pub.add('setting source_system_code to be null');

1257: , p_PRICE_LIST_rec => g_p_PRICE_LIST_rec
1258: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1259: );
1260: ELSE
1261: oe_debug_pub.add('setting source_system_code to be null');
1262: g_PRICE_LIST_rec.source_system_code := NULL;
1263: END IF;
1264:
1265: END IF;

Line 1282: oe_debug_pub.add('setting shareable_flag to be null');

1278: , p_PRICE_LIST_rec => g_p_PRICE_LIST_rec
1279: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1280: );
1281: ELSE
1282: oe_debug_pub.add('setting shareable_flag to be null');
1283: g_PRICE_LIST_rec.shareable_flag := NULL;
1284: END IF;
1285:
1286: END IF;

Line 1304: oe_debug_pub.add('setting sold_to_org_id to be null');

1300: , p_PRICE_LIST_rec => g_p_PRICE_LIST_rec
1301: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1302: );
1303: ELSE
1304: oe_debug_pub.add('setting sold_to_org_id to be null');
1305: g_PRICE_LIST_rec.sold_to_org_id := NULL;
1306: END IF;
1307:
1308: END IF;

Line 1325: oe_debug_pub.add('setting locked_from_list_header_id to be null');

1321: , p_PRICE_LIST_rec => g_p_PRICE_LIST_rec
1322: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1323: );
1324: ELSE
1325: oe_debug_pub.add('setting locked_from_list_header_id to be null');
1326: g_PRICE_LIST_rec.locked_from_list_header_id := NULL;
1327: END IF;
1328:
1329: END IF;

Line 1353: oe_debug_pub.add('setting ORG_ID to be null');

1349: , p_PRICE_LIST_rec => g_p_PRICE_LIST_rec
1350: , x_PRICE_LIST_rec => g_PRICE_LIST_rec
1351: );
1352: ELSE
1353: oe_debug_pub.add('setting ORG_ID to be null');
1354: g_PRICE_LIST_rec.org_id := NULL;
1355: END IF;
1356:
1357: END IF;

Line 1378: oe_debug_Pub.add('getting flex field info');

1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1375: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1376: THEN
1377:
1378: oe_debug_Pub.add('getting flex field info');
1379:
1380: Get_Flex_Price_List;
1381: oe_debug_Pub.add('after getting flex field');
1382:

Line 1381: oe_debug_Pub.add('after getting flex field');

1377:
1378: oe_debug_Pub.add('getting flex field info');
1379:
1380: Get_Flex_Price_List;
1381: oe_debug_Pub.add('after getting flex field');
1382:
1383: END IF;
1384:
1385: IF g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1483: oe_debug_pub.add('redefault attributes 1');

1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1480: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
1481: THEN
1482:
1483: oe_debug_pub.add('redefault attributes 1');
1484:
1485: QP_Default_Price_List.Attributes
1486: ( p_PRICE_LIST_rec => g_PRICE_LIST_rec
1487: , p_iteration => p_iteration + 1

Line 1491: oe_debug_pub.add('redefault attributes 2');

1487: , p_iteration => p_iteration + 1
1488: , x_PRICE_LIST_rec => x_PRICE_LIST_rec
1489: );
1490:
1491: oe_debug_pub.add('redefault attributes 2');
1492:
1493: ELSE
1494:
1495: -- Done defaulting attributes

Line 1501: oe_debug_pub.add('exiting attributes');

1497: x_PRICE_LIST_rec := g_PRICE_LIST_rec;
1498:
1499: END IF;
1500:
1501: oe_debug_pub.add('exiting attributes');
1502:
1503: END Attributes;
1504:
1505: END QP_Default_Price_List;