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 3742: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');

3738:
3739: CLOSE cur_transaction_code;
3740:
3741: IF (p_order_number IS NOT NULL) THEN
3742: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3743: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3744: ELSE
3745: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3746: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);

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

3739: CLOSE cur_transaction_code;
3740:
3741: IF (p_order_number IS NOT NULL) THEN
3742: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3743: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3744: ELSE
3745: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3746: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3747: END IF;

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

3741: IF (p_order_number IS NOT NULL) THEN
3742: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3743: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3744: ELSE
3745: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3746: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3747: END IF;
3748:
3749: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

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

3742: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3743: FND_MESSAGE.SET_TOKEN('ORDER', p_order_number);
3744: ELSE
3745: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3746: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3747: END IF;
3748:
3749: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3750: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

Line 3749: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3745: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_ALREADY_PURGED');
3746: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3747: END IF;
3748:
3749: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3750: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3751: l_error_message := FND_MESSAGE.GET;
3752: p_error_message := l_error_message;
3753: p_is_purgable := 'N';

Line 3750: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3746: FND_MESSAGE.SET_TOKEN('ORDER', p_quote_number);
3747: END IF;
3748:
3749: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3750: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3751: l_error_message := FND_MESSAGE.GET;
3752: p_error_message := l_error_message;
3753: p_is_purgable := 'N';
3754: RETURN;

Line 3751: l_error_message := FND_MESSAGE.GET;

3747: END IF;
3748:
3749: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3750: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3751: l_error_message := FND_MESSAGE.GET;
3752: p_error_message := l_error_message;
3753: p_is_purgable := 'N';
3754: RETURN;
3755: ELSE

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

3763: AND nvl(l_transaction_phase_code,'F')='N' THEN
3764:
3765: IF l_return_status = FND_API.G_TRUE THEN
3766:
3767: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3768: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3769: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3770: l_error_message := FND_MESSAGE.GET;
3771: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);

Line 3768: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

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

Line 3769: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

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

Line 3770: l_error_message := FND_MESSAGE.GET;

3766:
3767: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3768: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3769: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3770: l_error_message := FND_MESSAGE.GET;
3771: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
3772:
3773: END IF;
3774:

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

3774:
3775: ELSE
3776:
3777: IF l_return_status = FND_API.G_TRUE THEN
3778: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3779: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3780: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3781: l_error_message := FND_MESSAGE.GET;
3782: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);

Line 3779: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3775: ELSE
3776:
3777: IF l_return_status = FND_API.G_TRUE THEN
3778: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3779: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3780: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3781: l_error_message := FND_MESSAGE.GET;
3782: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3783: END IF;

Line 3780: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3776:
3777: IF l_return_status = FND_API.G_TRUE THEN
3778: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3779: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3780: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3781: l_error_message := FND_MESSAGE.GET;
3782: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3783: END IF;
3784:

Line 3781: l_error_message := FND_MESSAGE.GET;

3777: IF l_return_status = FND_API.G_TRUE THEN
3778: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3779: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3780: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3781: l_error_message := FND_MESSAGE.GET;
3782: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3783: END IF;
3784:
3785: IF l_return_status = FND_API.G_TRUE THEN

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

3793: WHERE installed_flag = 'B')
3794: AND otl.transaction_type_id = ooh.order_type_id
3795: AND ooh.header_id = p_header_id;
3796:
3797: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3798: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3799: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3800: l_error_message := FND_MESSAGE.GET;
3801: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders

Line 3798: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3794: AND otl.transaction_type_id = ooh.order_type_id
3795: AND ooh.header_id = p_header_id;
3796:
3797: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3798: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3799: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3800: l_error_message := FND_MESSAGE.GET;
3801: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3802: ( TO_CHAR(p_order_number), l_order_type_name );

Line 3799: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3795: AND ooh.header_id = p_header_id;
3796:
3797: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3798: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3799: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3800: l_error_message := FND_MESSAGE.GET;
3801: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3802: ( TO_CHAR(p_order_number), l_order_type_name );
3803: END IF;

Line 3800: l_error_message := FND_MESSAGE.GET;

3796:
3797: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3798: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3799: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3800: l_error_message := FND_MESSAGE.GET;
3801: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3802: ( TO_CHAR(p_order_number), l_order_type_name );
3803: END IF;
3804:

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

3803: END IF;
3804:
3805:
3806: IF l_return_status = FND_API.G_TRUE THEN
3807: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns

Line 3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3804:
3805:
3806: IF l_return_status = FND_API.G_TRUE THEN
3807: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3812: (p_order_number, p_order_type_name);

Line 3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3805:
3806: IF l_return_status = FND_API.G_TRUE THEN
3807: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3812: (p_order_number, p_order_type_name);
3813: END IF;

Line 3810: l_error_message := FND_MESSAGE.GET;

3806: IF l_return_status = FND_API.G_TRUE THEN
3807: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3812: (p_order_number, p_order_type_name);
3813: END IF;
3814:

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

3819:
3820:
3821:
3822: IF l_return_status = FND_API.G_TRUE THEN
3823: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3824: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3825: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3826: l_error_message := FND_MESSAGE.GET;
3827:

Line 3824: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3820:
3821:
3822: IF l_return_status = FND_API.G_TRUE THEN
3823: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3824: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3825: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3826: l_error_message := FND_MESSAGE.GET;
3827:
3828: SELECT count(*)

Line 3825: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3821:
3822: IF l_return_status = FND_API.G_TRUE THEN
3823: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3824: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3825: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3826: l_error_message := FND_MESSAGE.GET;
3827:
3828: SELECT count(*)
3829: INTO l_cnt

Line 3826: l_error_message := FND_MESSAGE.GET;

3822: IF l_return_status = FND_API.G_TRUE THEN
3823: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_DELIVERIES');
3824: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3825: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3826: l_error_message := FND_MESSAGE.GET;
3827:
3828: SELECT count(*)
3829: INTO l_cnt
3830: FROM wsh_delivery_details dd,

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

3857: (p_header_id => p_header_id );
3858:
3859: IF l_return_status = FND_API.G_FALSE THEN
3860:
3861: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3862: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3863: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3864: l_error_message := FND_MESSAGE.GET;
3865:

Line 3862: l_temp_mesg := FND_MESSAGE.GET_ENCODED;

3858:
3859: IF l_return_status = FND_API.G_FALSE THEN
3860:
3861: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3862: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3863: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3864: l_error_message := FND_MESSAGE.GET;
3865:
3866: END IF;

Line 3863: FND_MESSAGE.SET_ENCODED(l_temp_mesg);

3859: IF l_return_status = FND_API.G_FALSE THEN
3860:
3861: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3862: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3863: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3864: l_error_message := FND_MESSAGE.GET;
3865:
3866: END IF;
3867:

Line 3864: l_error_message := FND_MESSAGE.GET;

3860:
3861: FND_MESSAGE.SET_NAME('ONT','OE_PURGE_OPEN_PO_REQ');
3862: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3863: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3864: l_error_message := FND_MESSAGE.GET;
3865:
3866: END IF;
3867:
3868: END IF;