[Home] [Help]
26: --| added to convert clob |
27: --| field to varchar2 as to_char function(clob) is not |
28: --| supported for version 8i. |
29: --| 14/06/2004 shpandey Modified the If condition used before inserting the|
30: --| Qualitative data into MTL_COPY_ORG_REPORT table. |
31: --| for bug# 3678706. |
32: --| 18/08/2004 aujain Modified size of variables retreiving FND Messages |
33: --| for Bug 3838706. |
34: --| 12/04/2004 shpandey Added a function Get_Err_Wip_Acc_Classes for |
271: END IF;
272: ---------------------------------------------------------------------------
273: -- Call Validate_Locs() function to validate the location
274: -- created by Copy Org and write an appropriate message
275: -- to the Report Table : MTL_COPY_ORG_REPORT.
276: ---------------------------------------------------------------------------
277: Validate_Locs;
278:
279: IF G_DEBUG = 'Y' THEN
287: END IF;
288: -------------------------------------------------------------------------
289: -- Call Validate_Orgs() function to validate the organization
290: -- created by Copy Org and write appropriate messages
291: -- to the Report Table : MTL_COPY_ORG_REPORT.
292: -------------------------------------------------------------------------
293: Validate_Orgs();
294: -------------------------------------------------------------------------
295: -- Standard check of p_commit.
331: --IS
332: -- CURSOR l_user_values ( p_group_code VARCHAR2 )
333: -- IS
334: -- SELECT entity_type, entity_name, field_name
335: -- FROM mtl_copy_org_report
336: -- WHERE rec_type = 'INPUT_XML'
337: -- AND group_code = p_group_code;
338: --
339: -- l_user_rec l_user_values%ROWTYPE;
4009: FND_MESSAGE.SET_TOKEN ( 'entity_type', g_entity_type );
4010: l_message := FND_MESSAGE.GET();
4011: --dbms_output.put_line(l_message);
4012: FORALL i IN 1..l_entity_count
4013: INSERT INTO mtl_copy_org_report
4014: ( GROUP_CODE
4015: , MODEL_ORGANIZATION_CODE
4016: , ORGANIZATION_CODE
4017: , ERROR_MSG
4098: l_new_org := g_organization_code;
4099: l_model_org := g_model_org_code;
4100: END IF;
4101:
4102: INSERT INTO MTL_COPY_ORG_REPORT
4103: ( group_code
4104: , model_organization_code
4105: , organization_code
4106: , location_code
4299: IF (g_group_code = 'SEED') THEN
4300: RETURN false;
4301: END IF;
4302:
4303: DELETE mtl_copy_org_report
4304: WHERE group_code = g_group_code;
4305:
4306: IF G_DEBUG = 'Y' THEN
4307: FND_MSG_PUB.ADD_EXC_MSG