54:
55: /* 5126974 - this was raising an error if MOAC not init'd
56: so I moved it to inv_org_id function where it initializes
57: on the first call
58: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
59: */
60:
61: OPEN c_get_category_set;
62: FETCH c_get_category_set INTO g_category_set_id, g_category_structure_id;
897: /* 5126974 - move initialization to this function
898: to avoid org-specific failure in constant_system_values */
899: IF g_inv_org_id IS NULL
900: THEN
901: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
902: END IF;
903:
904: -- Initialize message list if p_init_msg_list is set to TRUE.
905: IF FND_API.to_Boolean( p_init_msg_list )
1216: /* 5126974 - move initialization to this function
1217: to avoid org-specific failure in constant_system_values */
1218: IF g_inv_org_id IS NULL
1219: THEN
1220: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
1221: END IF;
1222: -- Initialize message list if p_init_msg_list is set to TRUE.
1223: IF FND_API.to_Boolean( p_init_msg_list )
1224: THEN
1885: /* 5126974 - move initialization to this function
1886: to avoid org-specific failure in constant_system_values */
1887: IF g_inv_org_id IS NULL
1888: THEN
1889: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
1890: END IF;
1891: -- Initialize message list if p_init_msg_list is set to TRUE.
1892: IF FND_API.to_Boolean( p_init_msg_list )
1893: THEN
1970: /* 5126974 - move initialization to this function
1971: to avoid org-specific failure in constant_system_values */
1972: IF g_inv_org_id IS NULL
1973: THEN
1974: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
1975: END IF;
1976: OPEN c_all_line_total;
1977: FETCH c_all_line_total INTO l_all_line_total;
1978: CLOSE c_all_line_total;
2157: /* 5126974 - move initialization to this function
2158: to avoid org-specific failure in constant_system_values */
2159: IF g_inv_org_id IS NULL
2160: THEN
2161: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
2162: END IF;
2163: /* 5011151 - If a user attempts to RAM or API an invoice that has
2164: credits which have not (yet) been through Rev Rec, the UNEARN
2165: will total incorrectly for the target transaction and allow
2363: /* 5126974 - move initialization to this function
2364: to avoid org-specific failure in constant_system_values */
2365: IF g_inv_org_id IS NULL
2366: THEN
2367: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
2368: END IF;
2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF FND_API.to_Boolean( p_init_msg_list )
2765: /* NOTE: This is returned as a varchar.. not sure why */
2766: /* 5861728 - Initialize the value if null */
2767: IF g_inv_org_id IS NULL
2768: THEN
2769: oe_profile.get('SO_ORGANIZATION_ID',g_inv_org_id);
2770: END IF;
2771: RETURN g_inv_org_id;
2772: END inv_org_id;
2773: