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_ORDER_PURGE_PVT dependencies on FND_MESSAGE

Line 1347: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');

1343: AND nvl(l_transaction_phase_code,'F')='N' THEN
1344:
1345: IF l_return_status = FND_API.G_TRUE THEN
1346:
1347: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
1348: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1349: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1350: l_error_message := FND_MESSAGE.GET;
1351: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);

Line 1348: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

1344:
1345: IF l_return_status = FND_API.G_TRUE THEN
1346:
1347: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
1348: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1349: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1350: l_error_message := FND_MESSAGE.GET;
1351: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
1352:

Line 1349: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

1345: IF l_return_status = FND_API.G_TRUE THEN
1346:
1347: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
1348: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1349: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1350: l_error_message := FND_MESSAGE.GET;
1351: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
1352:
1353: END IF;

Line 1350: l_error_message := FND_MESSAGE.GET;

1346:
1347: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
1348: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1349: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1350: l_error_message := FND_MESSAGE.GET;
1351: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
1352:
1353: END IF;
1354:

Line 1357: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');

1353: END IF;
1354:
1355: ELSE
1356: IF l_return_status = FND_API.G_TRUE THEN
1357: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
1358: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1359: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1360: l_error_message := FND_MESSAGE.GET;
1361: --for Bug # 4516769

Line 1358: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

1354:
1355: ELSE
1356: IF l_return_status = FND_API.G_TRUE THEN
1357: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
1358: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1359: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1360: l_error_message := FND_MESSAGE.GET;
1361: --for Bug # 4516769
1362: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders

Line 1359: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

1355: ELSE
1356: IF l_return_status = FND_API.G_TRUE THEN
1357: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
1358: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1359: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1360: l_error_message := FND_MESSAGE.GET;
1361: --for Bug # 4516769
1362: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders
1363: ( p_header_id);

Line 1360: l_error_message := FND_MESSAGE.GET;

1356: IF l_return_status = FND_API.G_TRUE THEN
1357: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
1358: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1359: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1360: l_error_message := FND_MESSAGE.GET;
1361: --for Bug # 4516769
1362: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders
1363: ( p_header_id);
1364: END IF;

Line 1378: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');

1374: where installed_flag = 'B')
1375: AND otl.transaction_type_id = ooh.order_type_id
1376: AND ooh.header_id = p_header_id;
1377:
1378: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
1379: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1380: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1381: l_error_message := FND_MESSAGE.GET;
1382: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders

Line 1379: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

1375: AND otl.transaction_type_id = ooh.order_type_id
1376: AND ooh.header_id = p_header_id;
1377:
1378: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
1379: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1380: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1381: l_error_message := FND_MESSAGE.GET;
1382: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
1383: ( TO_CHAR(p_order_number), l_order_type_name );

Line 1380: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

1376: AND ooh.header_id = p_header_id;
1377:
1378: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
1379: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1380: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1381: l_error_message := FND_MESSAGE.GET;
1382: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
1383: ( TO_CHAR(p_order_number), l_order_type_name );
1384: END IF;

Line 1381: l_error_message := FND_MESSAGE.GET;

1377:
1378: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
1379: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1380: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1381: l_error_message := FND_MESSAGE.GET;
1382: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
1383: ( TO_CHAR(p_order_number), l_order_type_name );
1384: END IF;
1385:

Line 1387: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');

1383: ( TO_CHAR(p_order_number), l_order_type_name );
1384: END IF;
1385:
1386: IF l_return_status = FND_API.G_TRUE THEN
1387: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
1388: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1389: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1390: l_error_message := FND_MESSAGE.GET;
1391: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns

Line 1388: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

1384: END IF;
1385:
1386: IF l_return_status = FND_API.G_TRUE THEN
1387: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
1388: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1389: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1390: l_error_message := FND_MESSAGE.GET;
1391: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
1392: (p_order_number, p_order_type_name);

Line 1389: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

1385:
1386: IF l_return_status = FND_API.G_TRUE THEN
1387: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
1388: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1389: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1390: l_error_message := FND_MESSAGE.GET;
1391: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
1392: (p_order_number, p_order_type_name);
1393: END IF;

Line 1390: l_error_message := FND_MESSAGE.GET;

1386: IF l_return_status = FND_API.G_TRUE THEN
1387: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
1388: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1389: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1390: l_error_message := FND_MESSAGE.GET;
1391: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
1392: (p_order_number, p_order_type_name);
1393: END IF;
1394:

Line 1402: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');

1398: END IF;
1399:
1400: -- 3789233
1401: IF l_return_status = FND_API.G_TRUE THEN
1402: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
1403: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1404: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1405: l_error_message := FND_MESSAGE.GET;
1406:

Line 1403: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

1399:
1400: -- 3789233
1401: IF l_return_status = FND_API.G_TRUE THEN
1402: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
1403: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1404: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1405: l_error_message := FND_MESSAGE.GET;
1406:
1407: select count(*)

Line 1404: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

1400: -- 3789233
1401: IF l_return_status = FND_API.G_TRUE THEN
1402: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
1403: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1404: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1405: l_error_message := FND_MESSAGE.GET;
1406:
1407: select count(*)
1408: into l_cnt

Line 1405: l_error_message := FND_MESSAGE.GET;

1401: IF l_return_status = FND_API.G_TRUE THEN
1402: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
1403: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1404: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1405: l_error_message := FND_MESSAGE.GET;
1406:
1407: select count(*)
1408: into l_cnt
1409: from wsh_delivery_details dd,

Line 1442: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');

1438: );
1439:
1440: IF l_return_status = FND_API.G_FALSE THEN
1441:
1442: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
1443: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1444: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1445: l_error_message := FND_MESSAGE.GET;
1446:

Line 1443: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

1439:
1440: IF l_return_status = FND_API.G_FALSE THEN
1441:
1442: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
1443: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1444: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1445: l_error_message := FND_MESSAGE.GET;
1446:
1447: END IF;

Line 1444: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

1440: IF l_return_status = FND_API.G_FALSE THEN
1441:
1442: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
1443: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1444: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1445: l_error_message := FND_MESSAGE.GET;
1446:
1447: END IF;
1448:

Line 1445: l_error_message := FND_MESSAGE.GET;

1441:
1442: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
1443: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1444: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1445: l_error_message := FND_MESSAGE.GET;
1446:
1447: END IF;
1448:
1449: END IF;

Line 1561: FND_MESSAGE.SET_NAME ('ONT', 'ONT_ONLY_CREATOR_CAN_PURGE');

1557:
1558:
1559: IF l_created_by <> FND_GLOBAL.USER_ID THEN
1560:
1561: FND_MESSAGE.SET_NAME ('ONT', 'ONT_ONLY_CREATOR_CAN_PURGE');
1562: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1563: APP_EXCEPTION.RAISE_EXCEPTION;
1564:
1565: END IF;

Line 1562: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1558:
1559: IF l_created_by <> FND_GLOBAL.USER_ID THEN
1560:
1561: FND_MESSAGE.SET_NAME ('ONT', 'ONT_ONLY_CREATOR_CAN_PURGE');
1562: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1563: APP_EXCEPTION.RAISE_EXCEPTION;
1564:
1565: END IF;
1566:

Line 1690: FND_MESSAGE.SET_NAME ('ONT', 'ONT_FAILED_ORD_SECURITY');

1686: --added for bug 3680441
1687: l_purge_failure := l_number_of_orders - l_purged_success;
1688:
1689: IF ( l_purge_failure > 0 )THEN
1690: FND_MESSAGE.SET_NAME ('ONT', 'ONT_FAILED_ORD_SECURITY');
1691: FND_MESSAGE.SET_TOKEN ('SNAME',l_purge_set_name );
1692: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1693: END IF;
1694:

Line 1691: FND_MESSAGE.SET_TOKEN ('SNAME',l_purge_set_name );

1687: l_purge_failure := l_number_of_orders - l_purged_success;
1688:
1689: IF ( l_purge_failure > 0 )THEN
1690: FND_MESSAGE.SET_NAME ('ONT', 'ONT_FAILED_ORD_SECURITY');
1691: FND_MESSAGE.SET_TOKEN ('SNAME',l_purge_set_name );
1692: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1693: END IF;
1694:
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of orders/quotes selected for purge : '||l_number_of_orders);

Line 1692: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());

1688:
1689: IF ( l_purge_failure > 0 )THEN
1690: FND_MESSAGE.SET_NAME ('ONT', 'ONT_FAILED_ORD_SECURITY');
1691: FND_MESSAGE.SET_TOKEN ('SNAME',l_purge_set_name );
1692: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET ());
1693: END IF;
1694:
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of orders/quotes selected for purge : '||l_number_of_orders);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of orders/quotes purged successfully : '||l_purged_success);

Line 3688: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');

3684:
3685: CLOSE cur_transaction_code;
3686:
3687: IF (p_order_number IS NOT NULL) THEN
3688: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3689: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3690: ELSE
3691: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);

Line 3689: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);

3685: CLOSE cur_transaction_code;
3686:
3687: IF (p_order_number IS NOT NULL) THEN
3688: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3689: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3690: ELSE
3691: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3693: END IF;

Line 3691: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');

3687: IF (p_order_number IS NOT NULL) THEN
3688: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3689: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3690: ELSE
3691: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3693: END IF;
3694:
3695: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

Line 3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);

3688: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3689: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3690: ELSE
3691: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3693: END IF;
3694:
3695: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3696: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

Line 3695: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3691: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3693: END IF;
3694:
3695: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3696: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3697: l_error_message := FND_MESSAGE.GET;
3698: p_error_message := l_error_message;
3699: p_is_purgable := 'N';

Line 3696: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3692: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3693: END IF;
3694:
3695: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3696: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3697: l_error_message := FND_MESSAGE.GET;
3698: p_error_message := l_error_message;
3699: p_is_purgable := 'N';
3700: RETURN;

Line 3697: l_error_message := FND_MESSAGE.GET;

3693: END IF;
3694:
3695: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3696: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3697: l_error_message := FND_MESSAGE.GET;
3698: p_error_message := l_error_message;
3699: p_is_purgable := 'N';
3700: RETURN;
3701: ELSE

Line 3713: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');

3709: AND nvl(l_transaction_phase_code,'F')='N' THEN
3710:
3711: IF l_return_status = FND_API.G_TRUE THEN
3712:
3713: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3714: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3715: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3716: l_error_message := FND_MESSAGE.GET;
3717: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);

Line 3714: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3710:
3711: IF l_return_status = FND_API.G_TRUE THEN
3712:
3713: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3714: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3715: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3716: l_error_message := FND_MESSAGE.GET;
3717: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
3718:

Line 3715: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3711: IF l_return_status = FND_API.G_TRUE THEN
3712:
3713: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3714: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3715: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3716: l_error_message := FND_MESSAGE.GET;
3717: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
3718:
3719: END IF;

Line 3716: l_error_message := FND_MESSAGE.GET;

3712:
3713: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3714: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3715: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3716: l_error_message := FND_MESSAGE.GET;
3717: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
3718:
3719: END IF;
3720:

Line 3724: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');

3720:
3721: ELSE
3722:
3723: IF l_return_status = FND_API.G_TRUE THEN
3724: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3725: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3726: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3727: l_error_message := FND_MESSAGE.GET;
3728: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);

Line 3725: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3721: ELSE
3722:
3723: IF l_return_status = FND_API.G_TRUE THEN
3724: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3725: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3726: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3727: l_error_message := FND_MESSAGE.GET;
3728: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3729: END IF;

Line 3726: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3722:
3723: IF l_return_status = FND_API.G_TRUE THEN
3724: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3725: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3726: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3727: l_error_message := FND_MESSAGE.GET;
3728: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3729: END IF;
3730:

Line 3727: l_error_message := FND_MESSAGE.GET;

3723: IF l_return_status = FND_API.G_TRUE THEN
3724: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3725: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3726: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3727: l_error_message := FND_MESSAGE.GET;
3728: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3729: END IF;
3730:
3731: IF l_return_status = FND_API.G_TRUE THEN

Line 3743: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');

3739: WHERE installed_flag = 'B')
3740: AND otl.transaction_type_id = ooh.order_type_id
3741: AND ooh.header_id = p_header_id;
3742:
3743: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3744: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3745: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3746: l_error_message := FND_MESSAGE.GET;
3747: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders

Line 3744: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3740: AND otl.transaction_type_id = ooh.order_type_id
3741: AND ooh.header_id = p_header_id;
3742:
3743: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3744: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3745: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3746: l_error_message := FND_MESSAGE.GET;
3747: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3748: ( TO_CHAR(p_order_number), l_order_type_name );

Line 3745: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3741: AND ooh.header_id = p_header_id;
3742:
3743: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3744: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3745: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3746: l_error_message := FND_MESSAGE.GET;
3747: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3748: ( TO_CHAR(p_order_number), l_order_type_name );
3749: END IF;

Line 3746: l_error_message := FND_MESSAGE.GET;

3742:
3743: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3744: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3745: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3746: l_error_message := FND_MESSAGE.GET;
3747: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3748: ( TO_CHAR(p_order_number), l_order_type_name );
3749: END IF;
3750:

Line 3753: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');

3749: END IF;
3750:
3751:
3752: IF l_return_status = FND_API.G_TRUE THEN
3753: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3754: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3755: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3756: l_error_message := FND_MESSAGE.GET;
3757: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns

Line 3754: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3750:
3751:
3752: IF l_return_status = FND_API.G_TRUE THEN
3753: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3754: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3755: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3756: l_error_message := FND_MESSAGE.GET;
3757: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3758: (p_order_number, p_order_type_name);

Line 3755: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3751:
3752: IF l_return_status = FND_API.G_TRUE THEN
3753: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3754: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3755: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3756: l_error_message := FND_MESSAGE.GET;
3757: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3758: (p_order_number, p_order_type_name);
3759: END IF;

Line 3756: l_error_message := FND_MESSAGE.GET;

3752: IF l_return_status = FND_API.G_TRUE THEN
3753: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3754: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3755: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3756: l_error_message := FND_MESSAGE.GET;
3757: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3758: (p_order_number, p_order_type_name);
3759: END IF;
3760:

Line 3769: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');

3765:
3766:
3767:
3768: IF l_return_status = FND_API.G_TRUE THEN
3769: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3770: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3771: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3772: l_error_message := FND_MESSAGE.GET;
3773:

Line 3770: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3766:
3767:
3768: IF l_return_status = FND_API.G_TRUE THEN
3769: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3770: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3771: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3772: l_error_message := FND_MESSAGE.GET;
3773:
3774: SELECT count(*)

Line 3771: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3767:
3768: IF l_return_status = FND_API.G_TRUE THEN
3769: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3770: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3771: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3772: l_error_message := FND_MESSAGE.GET;
3773:
3774: SELECT count(*)
3775: INTO l_cnt

Line 3772: l_error_message := FND_MESSAGE.GET;

3768: IF l_return_status = FND_API.G_TRUE THEN
3769: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3770: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3771: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3772: l_error_message := FND_MESSAGE.GET;
3773:
3774: SELECT count(*)
3775: INTO l_cnt
3776: FROM wsh_delivery_details dd,

Line 3807: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');

3803: (p_header_id => p_header_id );
3804:
3805: IF l_return_status = FND_API.G_FALSE THEN
3806:
3807: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811:

Line 3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3804:
3805: IF l_return_status = FND_API.G_FALSE THEN
3806:
3807: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811:
3812: END IF;

Line 3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3805: IF l_return_status = FND_API.G_FALSE THEN
3806:
3807: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811:
3812: END IF;
3813:

Line 3810: l_error_message := FND_MESSAGE.GET;

3806:
3807: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811:
3812: END IF;
3813:
3814: END IF;