[Home] [Help]
7959: l_description := FND_MSG_PUB.Get
7960: (p_encoded => FND_API.G_FALSE);
7961: FND_MSG_PUB.Delete_Msg;
7962:
7963: -- Constraint Validation failures are logged in PSB_ERROR_MESSAGES and
7964: -- viewed using a Form
7965:
7966: insert into PSB_ERROR_MESSAGES
7967: (Concurrent_Request_ID,
7962:
7963: -- Constraint Validation failures are logged in PSB_ERROR_MESSAGES and
7964: -- viewed using a Form
7965:
7966: insert into PSB_ERROR_MESSAGES
7967: (Concurrent_Request_ID,
7968: Process_ID,
7969: Source_Process,
7970: Description,
8468: l_description := FND_MSG_PUB.Get
8469: (p_encoded => FND_API.G_FALSE);
8470: FND_MSG_PUB.Delete_Msg;
8471:
8472: insert into PSB_ERROR_MESSAGES
8473: (Concurrent_Request_ID,
8474: Process_ID,
8475: Source_Process,
8476: Description,
8552: l_description := FND_MSG_PUB.Get
8553: (p_encoded => FND_API.G_FALSE);
8554: FND_MSG_PUB.Delete_Msg;
8555:
8556: insert into PSB_ERROR_MESSAGES
8557: (Concurrent_Request_ID,
8558: Process_ID,
8559: Source_Process,
8560: Description,
8675: l_description := FND_MSG_PUB.Get
8676: (p_encoded => FND_API.G_FALSE);
8677: FND_MSG_PUB.Delete_Msg;
8678:
8679: insert into PSB_ERROR_MESSAGES
8680: (Concurrent_Request_ID,
8681: Process_ID,
8682: Source_Process,
8683: Description,
8950: l_description := FND_MSG_PUB.Get
8951: (p_encoded => FND_API.G_FALSE);
8952: FND_MSG_PUB.Delete_Msg;
8953:
8954: insert into PSB_ERROR_MESSAGES
8955: (Concurrent_Request_ID,
8956: Process_ID,
8957: Source_Process,
8958: Description,
9280:
9281: if g_constraint_set_id is not null then
9282: begin
9283:
9284: delete from PSB_ERROR_MESSAGES
9285: where source_process = 'BUDGET_REVISION'
9286: and process_id = p_budget_revision_id;
9287:
9288: if g_constraint_set_id <> p_constraint_set_id then
10884: --
10885: /*For Bug No : 2125969 Start*/
10886: IF g_constraint_set_id IS NULL THEN
10887: BEGIN
10888: DELETE FROM PSB_ERROR_MESSAGES
10889: WHERE source_process = 'BUDGET_REVISION'
10890: AND process_id = p_budget_revision_id;
10891: END;
10892: END IF;
11057: END IF;
11058: /*For Bug No : 2150471 End*/
11059:
11060:
11061: insert into PSB_ERROR_MESSAGES
11062: (Concurrent_Request_ID,
11063: Process_ID,
11064: Source_Process,
11065: Description,