DBA Data[Home] [Help]

APPS.ASO_ATP_INT dependencies on FND_MSG_PUB

Line 599: FND_MSG_PUB.initialize;

595: END IF;
596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list ) THEN
599: FND_MSG_PUB.initialize;
600: END IF;
601:
602: x_return_status := fnd_api.g_ret_sts_success;
603:

Line 635: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

631: if aso_debug_pub.g_debug_flag = 'Y' THEN
632: aso_debug_pub.add('do_check_atp: p_qte_line_tbl and p_shipment_tbl is null. Also p_qte_header_rec.quote_header_id is null');
633: end if;
634:
635: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
636: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
637: FND_MESSAGE.Set_Token('API_NAME', 'Check_ATP', FALSE);
638: FND_MESSAGE.Set_Token('PARAMETER', 'p_qte_header_rec', FALSE);
639: FND_MSG_PUB.ADD;

Line 639: FND_MSG_PUB.ADD;

635: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
636: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
637: FND_MESSAGE.Set_Token('API_NAME', 'Check_ATP', FALSE);
638: FND_MESSAGE.Set_Token('PARAMETER', 'p_qte_header_rec', FALSE);
639: FND_MSG_PUB.ADD;
640: end if;
641: x_return_status := fnd_api.g_ret_sts_error;
642: raise fnd_api.g_exc_error;
643:

Line 710: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

706: aso_debug_pub.add('do_check_atp: p_qte_line_tbl(i).quote_line_id: ' || p_qte_line_tbl(i).quote_line_id,1,'Y');
707: aso_debug_pub.add('do_check_atp: Quote_line_id is passed as nulll or g_miss_num in line record' ,1,'Y');
708: end if;
709:
710: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
711: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
712: FND_MESSAGE.Set_Token('COLUMN', 'Quote_Line_Id', FALSE);
713: FND_MSG_PUB.ADD;
714: end if;

Line 713: FND_MSG_PUB.ADD;

709:
710: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
711: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
712: FND_MESSAGE.Set_Token('COLUMN', 'Quote_Line_Id', FALSE);
713: FND_MSG_PUB.ADD;
714: end if;
715: x_return_status := fnd_api.g_ret_sts_error;
716: raise fnd_api.g_exc_error;
717:

Line 749: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

745: close c_shipment_id;
746:
747: l_shipment_search_tbl(l_shipment_tbl(i).shipment_id) := i;
748: /*
749: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
750: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
751: FND_MESSAGE.Set_Token('COLUMN', 'Shipment_Id', FALSE);
752: FND_MSG_PUB.ADD;
753: end if;

Line 752: FND_MSG_PUB.ADD;

748: /*
749: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
750: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
751: FND_MESSAGE.Set_Token('COLUMN', 'Shipment_Id', FALSE);
752: FND_MSG_PUB.ADD;
753: end if;
754: x_return_status := fnd_api.g_ret_sts_error;
755: raise fnd_api.g_exc_error;
756: */

Line 1931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1929: P_API_NAME => L_API_NAME
1930: ,P_PKG_NAME => G_PKG_NAME
1931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1933: ,X_MSG_COUNT => X_MSG_COUNT
1934: ,X_MSG_DATA => X_MSG_DATA
1935: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1939: P_API_NAME => L_API_NAME
1940: ,P_PKG_NAME => G_PKG_NAME
1941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1942: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1943: ,X_MSG_COUNT => X_MSG_COUNT
1944: ,X_MSG_DATA => X_MSG_DATA
1945: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2029: FND_MSG_PUB.initialize;

2025:
2026:
2027: -- Initialize message list if p_init_msg_list is set to TRUE.
2028: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2029: FND_MSG_PUB.initialize;
2030: END IF;
2031:
2032: /*
2033: If p_qte_line_tbl.FIRST IS NULL or p_shipment_tbl.FIRST IS NULL Then

Line 2095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2091:
2092: -- Get the value for Ship from org Id.
2093: l_ship_from_org_id := fnd_profile.value(name => 'ASO_SHIP_FROM_ORG_ID');
2094: If l_ship_from_org_id IS NULL Then
2095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2096: select user_profile_option_name
2097: into l_profile_name
2098: from fnd_profile_options_vl
2099: where profile_option_name = 'ASO_SHIP_FROM_ORG_ID';

Line 2103: FND_MSG_PUB.ADD;

2099: where profile_option_name = 'ASO_SHIP_FROM_ORG_ID';
2100:
2101: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2102: fnd_message.set_token('PROFILE', l_profile_name);
2103: FND_MSG_PUB.ADD;
2104: END IF;
2105: raise FND_API.G_EXC_ERROR;
2106: End If;
2107:

Line 2119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2115: aso_debug_pub.add('Check_atp: Default Customer Id from profile'||l_customer_id,1,'Y');
2116: END IF;
2117:
2118: IF l_customer_id IS NULL Then
2119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: select user_profile_option_name
2121: into l_profile_name
2122: from fnd_profile_options_vl
2123: where profile_option_name = 'ASO_ATP_DEFAULT_CUSTOMER_ID';

Line 2127: FND_MSG_PUB.ADD;

2123: where profile_option_name = 'ASO_ATP_DEFAULT_CUSTOMER_ID';
2124:
2125: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2126: fnd_message.set_token('PROFILE', l_profile_name);
2127: FND_MSG_PUB.ADD;
2128: END IF;
2129: raise FND_API.G_EXC_ERROR;
2130: END IF;
2131:

Line 2142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2138: aso_debug_pub.add('Check_atp : Default Customer Site Id from profile'||l_cust_ship_site_id);
2139: END IF;
2140:
2141: IF l_cust_ship_site_id IS NULL Then
2142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2143: select user_profile_option_name
2144: into l_profile_name
2145: from fnd_profile_options_vl
2146: where profile_option_name = 'ASO_ATP_SHIP_TO_SITE_ID';

Line 2150: FND_MSG_PUB.ADD;

2146: where profile_option_name = 'ASO_ATP_SHIP_TO_SITE_ID';
2147:
2148: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
2149: fnd_message.set_token('PROFILE', l_profile_name);
2150: FND_MSG_PUB.ADD;
2151: END IF;
2152: raise FND_API.G_EXC_ERROR;
2153: END IF;
2154:

Line 2329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2327: P_API_NAME => L_API_NAME
2328: ,P_PKG_NAME => G_PKG_NAME
2329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2331: ,X_MSG_COUNT => X_MSG_COUNT
2332: ,X_MSG_DATA => X_MSG_DATA
2333: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2337: P_API_NAME => L_API_NAME
2338: ,P_PKG_NAME => G_PKG_NAME
2339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2341: ,X_MSG_COUNT => X_MSG_COUNT
2342: ,X_MSG_DATA => X_MSG_DATA
2343: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2383: FND_MSG_PUB.initialize;

2379: END IF;
2380:
2381: -- Initialize message list if p_init_msg_list is set to TRUE.
2382: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2383: FND_MSG_PUB.initialize;
2384: END IF;
2385:
2386: if p_qte_line_tbl.count > 0 then
2387: l_qte_header_rec.quote_header_id := p_qte_line_tbl(1).quote_header_id;

Line 2503: FND_MSG_PUB.initialize;

2499: END IF;
2500:
2501: -- Initialize message list if p_init_msg_list is set to TRUE.
2502: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2503: FND_MSG_PUB.initialize;
2504: END IF;
2505:
2506: x_return_status := fnd_api.g_ret_sts_success;
2507: -- check to see if the quote header info is missing

Line 2514: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2510: if aso_debug_pub.g_debug_flag = 'Y' THEN
2511: aso_debug_pub.add('p_qte_header_rec.quote_header_id is null');
2512: end if;
2513:
2514: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2515: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
2516: FND_MESSAGE.Set_Token('API_NAME', 'UPDATE_CONFIGURATION', FALSE);
2517: FND_MESSAGE.Set_Token('PARAMETER', 'p_qte_header_rec', FALSE);
2518: FND_MSG_PUB.ADD;

Line 2518: FND_MSG_PUB.ADD;

2514: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2515: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
2516: FND_MESSAGE.Set_Token('API_NAME', 'UPDATE_CONFIGURATION', FALSE);
2517: FND_MESSAGE.Set_Token('PARAMETER', 'p_qte_header_rec', FALSE);
2518: FND_MSG_PUB.ADD;
2519: end if;
2520: x_return_status := fnd_api.g_ret_sts_error;
2521: raise fnd_api.g_exc_error;
2522: end if;

Line 2548: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2544: fetch get_no_of_lines into l_count;
2545: close get_no_of_lines;
2546:
2547: if p_qte_line_dtl_tbl.count > l_count then
2548: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2549: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
2550: FND_MESSAGE.Set_Token('API_NAME', 'UPDATE_CONFIGURATION', FALSE);
2551: FND_MESSAGE.Set_Token('PARAMETER', 'p_qte_line_dtl_tbl', FALSE);
2552: FND_MSG_PUB.ADD;

Line 2552: FND_MSG_PUB.ADD;

2548: if fnd_msg_pub.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2549: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ALL_MISSING_PARAM');
2550: FND_MESSAGE.Set_Token('API_NAME', 'UPDATE_CONFIGURATION', FALSE);
2551: FND_MESSAGE.Set_Token('PARAMETER', 'p_qte_line_dtl_tbl', FALSE);
2552: FND_MSG_PUB.ADD;
2553: end if;
2554: else
2555: l_qte_line_dtl_tbl := p_qte_line_dtl_tbl;
2556: end if;

Line 2570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

2566: -- check to see if the qte line detail table is properly populated before processing the row
2567: if (((l_qte_line_dtl_tbl(i).config_header_id is null) or (l_qte_line_dtl_tbl(i).config_header_id = FND_API.G_MISS_NUM)) or
2568: ((l_qte_line_dtl_tbl(i).config_revision_num is null) or (l_qte_line_dtl_tbl(i).config_revision_num = FND_API.G_MISS_NUM))) then
2569:
2570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2571: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_MISSING_COLUMN' );
2572: FND_MESSAGE.Set_Token ('COLUMN' , '.config_header_id', FALSE );
2573: FND_MSG_PUB.ADD;
2574: END IF;

Line 2573: FND_MSG_PUB.ADD;

2569:
2570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
2571: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_MISSING_COLUMN' );
2572: FND_MESSAGE.Set_Token ('COLUMN' , '.config_header_id', FALSE );
2573: FND_MSG_PUB.ADD;
2574: END IF;
2575: RAISE FND_API.G_EXC_ERROR;
2576: end if;
2577:

Line 2610: fnd_msg_pub.count_and_get(p_encoded => 'F',

2606: END IF;
2607: COMMIT WORK;
2608: END IF;
2609:
2610: fnd_msg_pub.count_and_get(p_encoded => 'F',
2611: p_count => x_msg_count,
2612: p_data => x_msg_data);
2613: for k in 1..x_msg_count loop
2614: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

Line 2614: x_msg_data := fnd_msg_pub.get(p_msg_index => k,

2610: fnd_msg_pub.count_and_get(p_encoded => 'F',
2611: p_count => x_msg_count,
2612: p_data => x_msg_data);
2613: for k in 1..x_msg_count loop
2614: x_msg_data := fnd_msg_pub.get(p_msg_index => k,
2615: p_encoded => 'F');
2616: end loop;
2617:
2618: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2624: WHEN FND_API.G_EXC_ERROR THEN
2625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2626: P_API_NAME => L_API_NAME
2627: ,P_PKG_NAME => G_PKG_NAME
2628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2630: ,X_MSG_COUNT => X_MSG_COUNT
2631: ,X_MSG_DATA => X_MSG_DATA
2632: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2635: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2636: P_API_NAME => L_API_NAME
2637: ,P_PKG_NAME => G_PKG_NAME
2638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2639: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2640: ,X_MSG_COUNT => X_MSG_COUNT
2641: ,X_MSG_DATA => X_MSG_DATA
2642: ,X_RETURN_STATUS => X_RETURN_STATUS);