Search Results api_error

Overview

APPS.PJM_SEIBAN_PKG is a PL/SQL package designed to support project creation workflows in Oracle EBS Projects (Oracle Project Management / Project Costing), with a specific focus on validating Seiban number usage. Seiban is a Japanese project-numbering discipline that ties project identifiers to contracts, budgets, and cost-control structures; the package name reflects that heritage. It acts as a lightweight API layer that allows callers to detect duplicate project numbers and project names before records are committed, and it exposes utility entry points for creating projects and tasks (CREATE_AMG_PROJECT, CREATE_AMG_TASK) as well as a concurrent-driver wrapper (CONC_CREATE).

The source header identifies the file as PJMSEBNB.pls, version 120.1 (2005/11/23), indicating this package body predates the 12.x upgrade cycles but remains compatible with EBS 12.1.1 and 12.2.2 because it depends only on long-stable PA and PJM tables. The package is registered in ETRM as an OTHER-classification API, meaning Oracle does not document it as a formal public interface; it is intended for internal or controlled use by project-creation logic.

Key Procedures and Functions

• PROJECT_NUMBER_DUP — A wrapper procedure that determines whether a supplied project number already exists, returning a duplication flag to the caller. It delegates to CHECK_DUP_PROJECT_NUM.
• PROJECT_NAME_DUP — A wrapper procedure that determines whether a supplied project name already exists, returning a duplication flag. It delegates to CHECK_DUP_PROJECT_NAME.
• CHECK_DUP_PROJECT_NUM — A function that performs the duplicate-number check. It queries PA_PROJECTS_ALL and PJM_SEIBAN_NUMBERS using a UNION ALL so that both standard project numbers and Seiban-registered numbers are considered. It returns 'N' when the number is null or unused, 'Y' when a match exists, and 'E' on an unexpected error.
• CHECK_DUP_PROJECT_NAME — A function mirroring the above for project names, verifying uniqueness across PA_PROJECTS_ALL and PJM_SEIBAN_NUMBERS.
• CREATE_AMG_PROJECT — A procedure that creates an AMG-type project, likely orchestrating validation and insert logic against the PA project tables.
• CREATE_AMG_TASK — A procedure that creates a task within a project, writing to PA_TASKS.
• CONC_CREATE — An entry point intended to be invoked as a concurrent program, driving project and task creation in a batch context.

Tables Accessed

• PA_PROJECTS_ALL — The master project table; queried for duplicate number/name detection and populated during project creation.
• PA_PROJECTS — The base project table underlying the _ALL view; used in project and task creation logic.
• PA_TASKS — Stores task structure; written by CREATE_AMG_TASK.
• PJM_SEIBAN_NUMBERS — A Seiban-specific table holding project numbers and names registered under the Seiban scheme; queried during duplicate checks.
• FND_RESPONSIBILITY — Referenced for responsibility/security context, commonly used to authorize the concurrent creation path.

Usage Notes

The package is typically invoked from project-creation forms, custom validation logic, or the CONC_CREATE concurrent program when users need to guarantee that new project numbers and names do not collide with existing PA or Seiban records. Customizations extending project setup often call PROJECT_NUMBER_DUP and PROJECT_NAME_DUP as pre-validation steps. Because it is an OTHER-classification API, it is not part of Oracle's supported public interface, and any reliance on it should be treated as custom. Callers encountering the search term "api_error" should note that CHECK_DUP_PROJECT_NUM and CHECK_DUP_PROJECT_NAME catch WHEN OTHERS and return 'E', so a returned 'E' generally signals a database or cursor-level fault rather than a duplicate.