APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 1087: from JAI_CMN_INVENTORY_ORGS

1083: excise_rcvble_account,
1084: rtv_expense_account_id,
1085: nvl(trading, 'N') receving_org_trading, /* Bug#4171469 */
1086: NVL(manufacturing, 'N') receiving_org_manufacturing --Added by Ramananda for Bug #4516577
1087: from JAI_CMN_INVENTORY_ORGS
1088: where organization_id = cp_organization_id
1089: and location_id = cp_location_id;
1090:
1091: cursor c_rcv_parameters(cp_organization_id number) is

Line 1129: from JAI_CMN_INVENTORY_ORGS

1125: and to_organization_id = cp_to_organization_id;
1126:
1127: cursor c_iso_from_org_type(cp_organization_id number) is
1128: select nvl(trading, 'N') source_org_trading /* Bug#4171469 */
1129: from JAI_CMN_INVENTORY_ORGS
1130: where organization_id = cp_organization_id;
1131:
1132:
1133:

Line 1836: p_process_message := 'Excise Expense Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||

1832: if p_excise_expense_account is null then
1833:
1834: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1835: p_process_flag := 'E';
1836: p_process_message := 'Excise Expense Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1837: 'for the organization location or null location, cannot proceed as transaction type is RMA';
1838:
1839: goto exit_from_procedure;
1840:

Line 1911: p_process_message := 'Excise Receivable Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||

1907:
1908: if p_excise_rcvble_account is null then
1909: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1910: p_process_flag := 'E';
1911: p_process_message := 'Excise Receivable Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1912: 'for the organization location or null location, cannot proceed as transaction type is RMA';
1913: goto exit_from_procedure;
1914: else
1915: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */

Line 1960: p_process_message := 'RTV Expense Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||

1956:
1957: if p_rtv_expense_account_id is null then
1958: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); /* 22 */
1959: p_process_flag := 'E';
1960: p_process_message := 'RTV Expense Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1961: 'for the organization location or null location, cannot proceed as transaction type is RTV';
1962: goto exit_from_procedure;
1963: end if;
1964:

Line 1990: p_process_message := 'BOE Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||

1986:
1987: if p_boe_account_id is null then
1988: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
1989: p_process_flag := 'E';
1990: p_process_message := 'BOE Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1991: 'for the organization location or null location.';
1992: goto exit_from_procedure;
1993: end if;
1994: end if;