APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 944: from JAI_CMN_INVENTORY_ORGS

940: excise_rcvble_account,
941: rtv_expense_account_id,
942: nvl(trading, 'N') receving_org_trading, /* Bug#4171469 */
943: NVL(manufacturing, 'N') receiving_org_manufacturing --Added by Ramananda for Bug #4516577
944: from JAI_CMN_INVENTORY_ORGS
945: where organization_id = cp_organization_id
946: and location_id = cp_location_id;
947:
948: cursor c_rcv_parameters(cp_organization_id number) is

Line 986: from JAI_CMN_INVENTORY_ORGS

982: and to_organization_id = cp_to_organization_id;
983:
984: cursor c_iso_from_org_type(cp_organization_id number) is
985: select nvl(trading, 'N') source_org_trading /* Bug#4171469 */
986: from JAI_CMN_INVENTORY_ORGS
987: where organization_id = cp_organization_id;
988:
989:
990:

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

1534: if p_excise_expense_account is null then
1535:
1536: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1537: p_process_flag := 'E';
1538: p_process_message := 'Excise Expense Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1539: 'for the organization location or null location, cannot proceed as transaction type is RMA';
1540:
1541: goto exit_from_procedure;
1542:

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

1608:
1609: if p_excise_rcvble_account is null then
1610: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
1611: p_process_flag := 'E';
1612: p_process_message := 'Excise Receivable Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1613: 'for the organization location or null location, cannot proceed as transaction type is RMA';
1614: goto exit_from_procedure;
1615: else
1616: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */

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

1657:
1658: if p_rtv_expense_account_id is null then
1659: p_codepath := jai_general_pkg.plot_codepath(22, p_codepath); /* 22 */
1660: p_process_flag := 'E';
1661: p_process_message := 'RTV Expense Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1662: 'for the organization location or null location, cannot proceed as transaction type is RTV';
1663: goto exit_from_procedure;
1664: end if;
1665:

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

1687:
1688: if p_boe_account_id is null then
1689: p_codepath := jai_general_pkg.plot_codepath(24, p_codepath); /* 24 */
1690: p_process_flag := 'E';
1691: p_process_message := 'BOE Account is not defined in JAI_CMN_INVENTORY_ORGS, ' ||
1692: 'for the organization location or null location.';
1693: goto exit_from_procedure;
1694: end if;
1695: end if;