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.XNB_SALES_ORDER_PVT dependencies on XNB_DEBUG

Line 1211: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Just After Begin');

1207: AND item.invoiceable_item_flag = 'N';
1208:
1209: BEGIN
1210:
1211: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Just After Begin');
1212:
1213: l_order_number := wf_engine.getitemattrtext (
1214: itemtype => itemtype,
1215: itemkey => itemkey,

Line 1228: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Before Opening the cursor for Line_ids');

1224: --Open the Cursor to retrieve all the LINE_IDs associated with ORDER NUMBER
1225: --
1226: ----------------------------------------------------------------------------------
1227: --debug
1228: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Before Opening the cursor for Line_ids');
1229:
1230:
1231:
1232: OPEN l_line_ids (l_order_number);

Line 1236: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Fetching line_id_'||l_line_id);

1232: OPEN l_line_ids (l_order_number);
1233: FETCH l_line_ids INTO l_line_id;
1234:
1235: --debug
1236: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Fetching line_id_'||l_line_id);
1237:
1238: WHILE (l_line_ids%FOUND) LOOP
1239:
1240: l_bill_to_owner_flag := 'N';

Line 1245: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In While loop for line_id_'||l_line_id);

1241: l_primary_bill_to_flag := 'N';
1242: l_flag := 'N';
1243:
1244: --debug
1245: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In While loop for line_id_'||l_line_id);
1246:
1247:
1248: -----------------------------------------------------------------------------
1249: --Get the Customer Account Site Id and Customer Account Id of the Order Line

Line 1271: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Invoice_to_org_id_'||l_inv_to_org_id);

1267: resultout := 1;
1268: END;
1269:
1270: --debug
1271: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Invoice_to_org_id_'||l_inv_to_org_id);
1272: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Sold_to_org_id_'||l_sold_to_org_id);
1273:
1274: ----------------------------------------------------------------------------------
1275: --Retrieve the Primary BILL_TO address associated with Customer Account Id

Line 1272: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Sold_to_org_id_'||l_sold_to_org_id);

1268: END;
1269:
1270: --debug
1271: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Invoice_to_org_id_'||l_inv_to_org_id);
1272: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Sold_to_org_id_'||l_sold_to_org_id);
1273:
1274: ----------------------------------------------------------------------------------
1275: --Retrieve the Primary BILL_TO address associated with Customer Account Id
1276: --of ORDER LINE

Line 1304: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Pri_bill_to_site_id_'||l_pri_bill_to_site_id);

1300:
1301: END;
1302:
1303: --debug
1304: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','Extracted the Pri_bill_to_site_id_'||l_pri_bill_to_site_id);
1305:
1306: OPEN l_sites (l_sold_to_org_id, l_org_id);
1307: FETCH l_sites INTO l_site_ids;
1308: WHILE (l_sites%FOUND) LOOP

Line 1311: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In While loop for site_use_id_'||l_site_ids);

1307: FETCH l_sites INTO l_site_ids;
1308: WHILE (l_sites%FOUND) LOOP
1309:
1310: --debug
1311: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In While loop for site_use_id_'||l_site_ids);
1312:
1313:
1314:
1315: -------------------------------------------------------------------------------------------

Line 1330: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In If loop l_site_ids = l_inv_to_org_id_'||l_flag);

1326:
1327: l_flag := 'Y';
1328:
1329: --debug
1330: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In If loop l_site_ids = l_inv_to_org_id_'||l_flag);
1331:
1332:
1333: -------------------------------------------------------------------------------------------
1334: --Check to see if Cust Account Site Id is the Primary BILL_TO of the

Line 1344: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In If loop l_site_ids = l_pri_bill_to_site_id');

1340: IF(l_site_ids = l_pri_bill_to_site_id) THEN
1341: l_primary_bill_to_flag := 'Y';
1342:
1343: --debug
1344: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In If loop l_site_ids = l_pri_bill_to_site_id');
1345:
1346:
1347: ---------------------------------------------------------------------------
1348: --Get the Details of PRIMARY BILL_TO Address

Line 1399: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In ELSE loop l_site_ids = l_pri_bill_to_site_id');

1395: --
1396: ---------------------------------------------------------------------------
1397:
1398: --debug
1399: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In ELSE loop l_site_ids = l_pri_bill_to_site_id');
1400:
1401:
1402: get_bill_to_address ( l_inv_to_org_id,
1403: l_party_id,

Line 1451: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','END of While loop for site_use_id_');

1447: -- End of While
1448: END LOOP;
1449:
1450: --debug
1451: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','END of While loop for site_use_id_');
1452:
1453:
1454: l_bill_to_owner_flag := 'N';
1455:

Line 1468: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In the If Flag = N_'||l_flag);

1464:
1465: IF l_flag = 'N' THEN
1466:
1467: --debug
1468: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','In the If Flag = N_'||l_flag);
1469:
1470:
1471:
1472: get_bill_to_address ( l_inv_to_org_id,

Line 1512: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','END of While loop for Line_Ids_');

1508: -- End of While
1509: END LOOP;
1510:
1511: --debug
1512: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','END of While loop for Line_Ids_');
1513: RETURN;
1514:
1515:
1516: --CLOSE CURSOR AND RETURN

Line 1520: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','After Close for Cursor Line_Ids');

1516: --CLOSE CURSOR AND RETURN
1517: CLOSE l_line_ids;
1518:
1519: --debug
1520: XNB_DEBUG.log('XNB_SO_PVT.PUBLISH_LINES_BILL_TOS','After Close for Cursor Line_Ids');
1521:
1522:
1523: EXCEPTION
1524: