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.ASO_SOURCING_PVT dependencies on FND_API

Line 71: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then

67: END IF;
68: CLOSE C_get_quote_info;
69:
70:
71: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then
72: l_cust_account_id := l_ship_to_cust_account_id;
73: end if;
74:
75: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 91: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

87: ,P_Acct_Site_type => 'SHIP_TO'
88: ,x_return_status => l_return_status
89: ,x_site_use_id => x_ship_to_org_id
90: );
91: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
92: x_ship_to_org_id := NULL;
93: END IF;
94:
95: END IF; -- not null

Line 137: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then

133: return x_ship_to_org_id;
134: END IF;
135: CLOSE C_get_quote_info;
136:
137: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then
138: l_cust_account_id := l_ship_to_cust_account_id;
139: end if;
140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
141: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');

Line 157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

153: ,x_site_use_id => x_ship_to_org_id
154: );
155:
156:
157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
158: x_ship_to_org_id := NULL;
159: END IF;
160: ELSE
161: x_ship_to_org_id := get_ship_to_site_use(l_quote_header_id);

Line 203: if l_invoice_to_cust_account_id is not null OR l_invoice_to_cust_account_id <> fnd_api.G_MISS_NUM then

199: CLOSE C_get_quote_info;
200:
201: -- ----------------dbms_output.put_line(l_cust_account_id || l_invoice_party_site_id);
202:
203: if l_invoice_to_cust_account_id is not null OR l_invoice_to_cust_account_id <> fnd_api.G_MISS_NUM then
204: l_cust_account_id := l_invoice_to_cust_account_id;
205: end if;
206:
207: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 226: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

222: ,x_site_use_id => x_invoice_to_org_id
223: );
224:
225: -- ----------------dbms_output.put_line(l_return_status || ' '||x_invoice_to_org_id );
226: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
227: x_invoice_to_org_id := NULL;
228: END IF;
229:
230: END IF; -- not null

Line 272: if l_invoice_to_cust_account_id is not null OR l_invoice_to_cust_account_id <> fnd_api.G_MISS_NUM then

268: return x_invoice_to_org_id;
269: END IF;
270: CLOSE C_get_quote_info;
271:
272: if l_invoice_to_cust_account_id is not null OR l_invoice_to_cust_account_id <> fnd_api.G_MISS_NUM then
273: l_cust_account_id := l_invoice_to_cust_account_id;
274: end if;
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

288: ,x_return_status => l_return_status
289: ,x_site_use_id => x_invoice_to_org_id
290: );
291:
292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
293: x_invoice_to_org_id := NULL;
294: END IF;
295: ELSE
296: x_invoice_to_org_id := get_invoice_to_site_use(l_quote_header_id);

Line 789: If l_pmnt_term_id is NULL or l_pmnt_term_id = fnd_api.g_miss_num then

785: OPEN get_pmnt_term;
786: fetch get_pmnt_term into l_pmnt_term_id;
787: CLOSE get_pmnt_term;
788:
789: If l_pmnt_term_id is NULL or l_pmnt_term_id = fnd_api.g_miss_num then
790: OPEN get_hdr_pmnt_term;
791: fetch get_hdr_pmnt_term into l_pmnt_term_id;
792: CLOSE get_hdr_pmnt_term;
793: end if;

Line 847: IF (C_hdr_freight_terms_code%FOUND AND (x_freight_terms_code <> FND_API.G_MISS_CHAR)) THEN

843: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
844: aso_debug_pub.add('Header Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');
845: END IF;
846:
847: IF (C_hdr_freight_terms_code%FOUND AND (x_freight_terms_code <> FND_API.G_MISS_CHAR)) THEN
848: CLOSE C_hdr_freight_terms_code;
849: return x_freight_terms_code;
850: ELSE
851: CLOSE C_hdr_freight_terms_code;

Line 855: ELSIF x_freight_terms_code = FND_API.G_MISS_CHAR THEN

851: CLOSE C_hdr_freight_terms_code;
852: return null;
853: END IF;
854:
855: ELSIF x_freight_terms_code = FND_API.G_MISS_CHAR THEN
856: CLOSE C_line_freight_terms_code;
857: return null;
858: END IF;
859:

Line 912: IF (C_hdr_ship_method_code%FOUND AND (x_ship_method_code <> FND_API.G_MISS_CHAR)) THEN

908: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
909: aso_debug_pub.add('Header Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');
910: END IF;
911:
912: IF (C_hdr_ship_method_code%FOUND AND (x_ship_method_code <> FND_API.G_MISS_CHAR)) THEN
913: CLOSE C_hdr_ship_method_code;
914: return x_ship_method_code;
915: ELSE
916: CLOSE C_hdr_ship_method_code;

Line 919: ELSIF x_ship_method_code = FND_API.G_MISS_CHAR THEN

915: ELSE
916: CLOSE C_hdr_ship_method_code;
917: return null;
918: END IF;
919: ELSIF x_ship_method_code = FND_API.G_MISS_CHAR THEN
920: CLOSE C_line_ship_method_code;
921: return null;
922: END IF;
923: CLOSE C_line_ship_method_code;

Line 959: IF ASO_PRICING_INT.G_LINE_REC.MODEL_ID IS NOT NULL AND ASO_PRICING_INT.G_LINE_REC.MODEL_ID <> FND_API.G_MISS_NUM THEN

955: aso_debug_pub.add('Get_top_model_item_id - Begin ',1,'Y');
956: aso_debug_pub.add('Get_top_model_item_id G_LINE_REC.MODEL_ID '||ASO_PRICING_INT.G_LINE_REC.MODEL_ID,1,'Y');
957: END IF;
958: /* iStore Cataloge is directly setting G_LINE_REC.model_id,Hence we need to return the same value*/
959: IF ASO_PRICING_INT.G_LINE_REC.MODEL_ID IS NOT NULL AND ASO_PRICING_INT.G_LINE_REC.MODEL_ID <> FND_API.G_MISS_NUM THEN
960: Return ASO_PRICING_INT.G_LINE_REC.MODEL_ID;
961: END IF;
962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
963: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');

Line 1001: IF C_item_id%FOUND AND x_inventory_item_id <> FND_API.G_MISS_NUM THEN

997: End Loop;
998:
999: open C_item_id;
1000: fetch C_item_id INTO x_inventory_item_id;
1001: IF C_item_id%FOUND AND x_inventory_item_id <> FND_API.G_MISS_NUM THEN
1002: return x_inventory_item_id;
1003: ELSE
1004: return null;
1005: END IF;

Line 1131: ASO_PRICING_INT.G_LINE_REC.MINISITE_ID <> FND_API.G_MISS_NUM

1127: aso_debug_pub.add('G_HEADER_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_HEADER_REC.minisite_id),'null'),1,'N');
1128: aso_debug_pub.add('G_LINE_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_LINE_REC.minisite_id),'null'),1,'N');
1129: END IF;
1130: IF ASO_PRICING_INT.G_LINE_REC.MINISITE_ID IS NOT NULL AND
1131: ASO_PRICING_INT.G_LINE_REC.MINISITE_ID <> FND_API.G_MISS_NUM
1132: THEN
1133: x_minisite_id := ASO_PRICING_INT.G_LINE_REC.MINISITE_ID;
1134: ELSIF ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID IS NOT NULL AND
1135: ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID <> FND_API.G_MISS_NUM

Line 1135: ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID <> FND_API.G_MISS_NUM

1131: ASO_PRICING_INT.G_LINE_REC.MINISITE_ID <> FND_API.G_MISS_NUM
1132: THEN
1133: x_minisite_id := ASO_PRICING_INT.G_LINE_REC.MINISITE_ID;
1134: ELSIF ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID IS NOT NULL AND
1135: ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID <> FND_API.G_MISS_NUM
1136: THEN
1137: x_minisite_id := ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID;
1138: END IF;
1139: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN