eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_EXT_FWK_PUB

Line 6199: EGO_EXT_FWK_PUB.Create_Value_Set

6195: IF l_validation_code=G_TABLE_VALIDATION_CODE THEN
6196: --Write code to create VS and values for table type.
6197: IF l_process_status = G_PROCESS_RECORD THEN
6198:
6199: EGO_EXT_FWK_PUB.Create_Value_Set
6200: (
6201: p_api_version => 1.0
6202: ,p_value_set_name => l_value_set_name
6203: ,p_description => l_description

Line 6238: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

6234: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
6235: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6236: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6237: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6238: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
6239: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6240: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set';
6241:
6242:

Line 6259: ||l_value_set_name||','||l_value_set_id||')'||' Creation of table type value set failed. Call to EGO_EXT_FWK_PUB.Create_Value_Set threw unexpected error ');

6255: ELSE
6256:
6257:
6258: write_debug(G_PKG_Name,l_api_name,'Err_Msg-TID=' ||l_transaction_id||'-(VS,VS Id)=('
6259: ||l_value_set_name||','||l_value_set_id||')'||' Creation of table type value set failed. Call to EGO_EXT_FWK_PUB.Create_Value_Set threw unexpected error ');
6260:
6261:
6262: x_return_status := G_RET_STS_UNEXP_ERROR;
6263: x_return_msg:= l_return_msg;

Line 6275: EGO_EXT_FWK_PUB.Insert_Value_Set_Table_Inf

6271: AND l_value_column_type IS NOT NULL AND l_value_column_size IS NOT NULL ) THEN
6272:
6273: IF l_process_status = G_PROCESS_RECORD THEN
6274:
6275: EGO_EXT_FWK_PUB.Insert_Value_Set_Table_Inf
6276: (
6277: p_api_version => 1.0
6278: ,p_value_set_id => l_value_set_id
6279: ,p_table_application_id => l_table_application_id

Line 6317: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

6313: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_TABLE;
6314: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6315: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6316: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6317: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
6318: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6319: G_TOKEN_TBL(4).Token_Value := 'Insert_Value_Set_Table_Inf';
6320:
6321:

Line 6386: write_debug(G_PKG_Name,l_api_name,' Process_Value_Set : Calling EGO_EXT_FWK_PUB.Create_Value_Set API for I X and N type of vali code ');

6382: write_debug(G_PKG_Name,l_api_name,'If Validate_type is Independent or Trans_IND Set Max & Min to void');
6383: END IF;--END bug 9830718
6384:
6385: IF l_process_status = G_PROCESS_RECORD THEN
6386: write_debug(G_PKG_Name,l_api_name,' Process_Value_Set : Calling EGO_EXT_FWK_PUB.Create_Value_Set API for I X and N type of vali code ');
6387:
6388: EGO_EXT_FWK_PUB.Create_Value_Set
6389: (
6390: p_api_version => l_api_version

Line 6388: EGO_EXT_FWK_PUB.Create_Value_Set

6384:
6385: IF l_process_status = G_PROCESS_RECORD THEN
6386: write_debug(G_PKG_Name,l_api_name,' Process_Value_Set : Calling EGO_EXT_FWK_PUB.Create_Value_Set API for I X and N type of vali code ');
6387:
6388: EGO_EXT_FWK_PUB.Create_Value_Set
6389: (
6390: p_api_version => l_api_version
6391: ,p_value_set_name => l_value_set_name
6392: ,p_description => l_description

Line 6426: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

6422: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
6423: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6424: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6425: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6426: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
6427: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6428: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set';
6429:
6430:

Line 6465: write_debug(G_PKG_Name,l_api_name,' Calling EGO_EXT_FWK_PUB.Create_Value_Set to create Value Set ');

6461: END LOOP;
6462:
6463: IF l_value_set_id IS NULL THEN
6464: -- If VS has not been created then create VS
6465: write_debug(G_PKG_Name,l_api_name,' Calling EGO_EXT_FWK_PUB.Create_Value_Set to create Value Set ');
6466:
6467: IF l_process_status = G_PROCESS_RECORD THEN
6468:
6469: EGO_EXT_FWK_PUB.Create_Value_Set

Line 6469: EGO_EXT_FWK_PUB.Create_Value_Set

6465: write_debug(G_PKG_Name,l_api_name,' Calling EGO_EXT_FWK_PUB.Create_Value_Set to create Value Set ');
6466:
6467: IF l_process_status = G_PROCESS_RECORD THEN
6468:
6469: EGO_EXT_FWK_PUB.Create_Value_Set
6470: (
6471: p_api_version => l_api_version
6472: ,p_value_set_name => l_value_set_name
6473: ,p_description => l_description

Line 6507: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

6503: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
6504: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6505: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6506: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6507: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
6508: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6509: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set';
6510:
6511:

Line 6532: write_debug(G_PKG_Name,l_api_name,' API EGO_EXT_FWK_PUB.Create_Value_Set return status x_return_status = '

6528:
6529:
6530:
6531:
6532: write_debug(G_PKG_Name,l_api_name,' API EGO_EXT_FWK_PUB.Create_Value_Set return status x_return_status = '
6533: ||x_return_status||' l_value_set_id= '||l_value_set_id );
6534:
6535:
6536: END IF; --IF NOT exist THEN

Line 6648: write_debug(G_PKG_Name,l_api_name,' Calling EGO_EXT_FWK_PUB.Update_Value_Set API ');

6644: */
6645:
6646: IF l_process_status = G_PROCESS_RECORD THEN
6647: -- Call update API to update value set.
6648: write_debug(G_PKG_Name,l_api_name,' Calling EGO_EXT_FWK_PUB.Update_Value_Set API ');
6649: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Calling EGO_EXT_FWK_PUB.Update_Value_Set API '||l_validation_code);
6650:
6651: --IF l_validation_code <> G_TABLE_VALIDATION_CODE THEN
6652:

Line 6649: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Calling EGO_EXT_FWK_PUB.Update_Value_Set API '||l_validation_code);

6645:
6646: IF l_process_status = G_PROCESS_RECORD THEN
6647: -- Call update API to update value set.
6648: write_debug(G_PKG_Name,l_api_name,' Calling EGO_EXT_FWK_PUB.Update_Value_Set API ');
6649: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Calling EGO_EXT_FWK_PUB.Update_Value_Set API '||l_validation_code);
6650:
6651: --IF l_validation_code <> G_TABLE_VALIDATION_CODE THEN
6652:
6653: EGO_EXT_FWK_PUB.Update_Value_Set

Line 6653: EGO_EXT_FWK_PUB.Update_Value_Set

6649: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Calling EGO_EXT_FWK_PUB.Update_Value_Set API '||l_validation_code);
6650:
6651: --IF l_validation_code <> G_TABLE_VALIDATION_CODE THEN
6652:
6653: EGO_EXT_FWK_PUB.Update_Value_Set
6654: (
6655: p_api_version => l_api_version
6656: ,p_value_set_id => l_value_set_id
6657: ,p_description => CASE l_description

Line 6701: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

6697: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS;
6698: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6699: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6700: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6701: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
6702: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6703: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set';
6704:
6705:

Line 6731: write_debug(G_PKG_Name,l_api_name,' Call to EGO_EXT_FWK_PUB.Update_Value_Set done x_return_status := '||x_return_status );

6727:
6728:
6729:
6730:
6731: write_debug(G_PKG_Name,l_api_name,' Call to EGO_EXT_FWK_PUB.Update_Value_Set done x_return_status := '||x_return_status );
6732: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Call to EGO_EXT_FWK_PUB.Update_Value_Set done x_return_status := '||x_return_status );
6733:
6734: -- Call API based on validation code
6735:

Line 6732: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Call to EGO_EXT_FWK_PUB.Update_Value_Set done x_return_status := '||x_return_status );

6728:
6729:
6730:
6731: write_debug(G_PKG_Name,l_api_name,' Call to EGO_EXT_FWK_PUB.Update_Value_Set done x_return_status := '||x_return_status );
6732: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Call to EGO_EXT_FWK_PUB.Update_Value_Set done x_return_status := '||x_return_status );
6733:
6734: -- Call API based on validation code
6735:
6736: IF l_validation_code=G_TABLE_VALIDATION_CODE THEN

Line 6756: EGO_EXT_FWK_PUB.Update_Value_Set_Table_Inf

6752:
6753: IF l_table_exist IS NOT NULL THEN
6754:
6755: -- Call API to update table information
6756: EGO_EXT_FWK_PUB.Update_Value_Set_Table_Inf
6757: (
6758: p_api_version => 1.0
6759: ,p_value_set_id => l_value_set_id
6760: ,p_table_application_id => CASE l_table_application_id

Line 6805: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB' ;

6801: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_TABLE;
6802: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6803: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6804: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6805: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB' ;
6806: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6807: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Table_Inf';
6808:
6809:

Line 6833: EGO_EXT_FWK_PUB.Insert_Value_Set_Table_Inf

6829:
6830: ELSE
6831:
6832: -- CREATE data for table type VS
6833: EGO_EXT_FWK_PUB.Insert_Value_Set_Table_Inf
6834: (
6835: p_api_version => 1.0
6836: ,p_value_set_id => l_value_set_id
6837: ,p_table_application_id => l_table_application_id

Line 6875: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

6871: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_TABLE;
6872: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
6873: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
6874: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
6875: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
6876: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
6877: G_TOKEN_TBL(4).Token_Value := 'Insert_Value_Set_Table_Inf';
6878:
6879:

Line 8335: EGO_EXT_FWK_PUB.Create_Value_Set_Val

8331: -- Create value only is it has not been created.
8332: IF l_process_status = G_PROCESS_RECORD THEN
8333: write_debug(G_PKG_Name,l_api_name,' TL value, lang CREATE=>'||l_flex_value||','||p_value_set_val_tl_tbl(j).language);
8334:
8335: EGO_EXT_FWK_PUB.Create_Value_Set_Val
8336: (
8337: p_api_version => p_api_version
8338: ,p_value_set_name => l_value_set_name
8339: ,p_internal_name => l_flex_value

Line 8374: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

8370: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VAL;
8371: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
8372: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
8373: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
8374: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
8375: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
8376: G_TOKEN_TBL(4).Token_Value := 'Create_Value_Set_Val';
8377:
8378:

Line 8504: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API ');

8500:
8501:
8502: ELSIF l_transaction_type=G_UPDATE THEN
8503:
8504: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API ');
8505: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API value=>'||l_flex_value);
8506:
8507: IF l_process_status = G_PROCESS_RECORD THEN
8508: EGO_EXT_FWK_PUB.Update_Value_Set_Val

Line 8505: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API value=>'||l_flex_value);

8501:
8502: ELSIF l_transaction_type=G_UPDATE THEN
8503:
8504: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API ');
8505: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API value=>'||l_flex_value);
8506:
8507: IF l_process_status = G_PROCESS_RECORD THEN
8508: EGO_EXT_FWK_PUB.Update_Value_Set_Val
8509: (

Line 8508: EGO_EXT_FWK_PUB.Update_Value_Set_Val

8504: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API ');
8505: write_debug(G_PKG_Name,l_api_name,' UPDATE MODE : calling EGO_EXT_FWK_PUB.Update_Value_Set_Val API value=>'||l_flex_value);
8506:
8507: IF l_process_status = G_PROCESS_RECORD THEN
8508: EGO_EXT_FWK_PUB.Update_Value_Set_Val
8509: (
8510: p_api_version => p_api_version
8511: ,p_value_set_name => l_value_set_name
8512: ,p_internal_name => l_flex_value

Line 8563: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

8559: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VAL;
8560: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
8561: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
8562: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
8563: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
8564: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
8565: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Val';
8566:
8567:

Line 8579: --Dbms_Output.put_line(' unexpected error in EGO_EXT_FWK_PUB.Update_Value_Set_Val '||l_return_msg||SQLERRM);

8575: ,p_table_name => G_ENTITY_VAL_HEADER_TAB );
8576:
8577:
8578: ELSE
8579: --Dbms_Output.put_line(' unexpected error in EGO_EXT_FWK_PUB.Update_Value_Set_Val '||l_return_msg||SQLERRM);
8580: write_debug(G_PKG_Name,l_api_name,' : Unexpected exception ' );
8581: x_return_status := G_RET_STS_UNEXP_ERROR;
8582: x_return_msg := l_return_msg;
8583: RETURN;

Line 9706: EGO_EXT_FWK_PUB.Update_Value_Set_Val

9702:
9703: IF l_process_status = G_PROCESS_RECORD THEN
9704:
9705:
9706: EGO_EXT_FWK_PUB.Update_Value_Set_Val
9707: (
9708: p_api_version => p_api_version
9709: ,p_value_set_name => l_value_set_name
9710: ,p_internal_name => l_flex_value

Line 9755: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

9751: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VAL;
9752: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
9753: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
9754: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
9755: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
9756: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
9757: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Val';
9758:
9759:

Line 10331: EGO_EXT_FWK_PUB.Update_Value_Set_Val

10327:
10328: IF l_process_status = G_PROCESS_RECORD THEN
10329:
10330:
10331: EGO_EXT_FWK_PUB.Update_Value_Set_Val
10332: (
10333: p_api_version => p_api_version
10334: ,p_value_set_name => l_value_set_name
10335: ,p_internal_name => l_flex_value

Line 10380: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

10376: G_TOKEN_TBL(1).Token_Value := G_ENTITY_VS_VAL;
10377: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
10378: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
10379: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
10380: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
10381: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
10382: G_TOKEN_TBL(4).Token_Value := 'Update_Value_Set_Val';
10383:
10384:

Line 10601: l_child_vs_value_ids EGO_EXT_FWK_PUB.EGO_VALUE_SET_VALUE_IDS := NULL;

10597: l_last_update_login NUMBER(15);
10598:
10599: l_versioned_vs VARCHAR2(10):= 'False'; -- Parameter to check if vs is versioned.
10600:
10601: l_child_vs_value_ids EGO_EXT_FWK_PUB.EGO_VALUE_SET_VALUE_IDS := NULL;
10602: --l_child_vs_value VALUE_SET_VALUE_Name_Tbl := NULL;
10603: l_child_vs_id NUMBER;
10604: l_parent_vs_id NUMBER;
10605: l_valid_parent NUMBER :=NULL;

Line 10680: l_child_vs_value_ids := EGO_EXT_FWK_PUB.EGO_VALUE_SET_VALUE_IDS();

10676: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Start of API. ' );
10677:
10678:
10679:
10680: l_child_vs_value_ids := EGO_EXT_FWK_PUB.EGO_VALUE_SET_VALUE_IDS();
10681: -- Get Application Id
10682: --G_Application_Id := Get_Application_Id();
10683:
10684: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_VS);

Line 11321: --Dbms_Output.put_line(' Calling EGO_EXT_FWK_PUB.Create_Child_Value_Set API. Count of child values : '||l_child_vs_value_ids.Count);

11317: -- Check for ValueSetType/Validation type is done as bulk check..
11318: -- Create a value set to keep sync with existing framework
11319: IF l_process_status = G_PROCESS_RECORD THEN
11320:
11321: --Dbms_Output.put_line(' Calling EGO_EXT_FWK_PUB.Create_Child_Value_Set API. Count of child values : '||l_child_vs_value_ids.Count);
11322:
11323: EGO_EXT_FWK_PUB.Create_Child_Value_Set
11324: (
11325: p_api_version => l_api_version

Line 11323: EGO_EXT_FWK_PUB.Create_Child_Value_Set

11319: IF l_process_status = G_PROCESS_RECORD THEN
11320:
11321: --Dbms_Output.put_line(' Calling EGO_EXT_FWK_PUB.Create_Child_Value_Set API. Count of child values : '||l_child_vs_value_ids.Count);
11322:
11323: EGO_EXT_FWK_PUB.Create_Child_Value_Set
11324: (
11325: p_api_version => l_api_version
11326: ,p_value_set_name => l_value_set_name
11327: ,p_description => l_description

Line 11404: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';

11400: G_TOKEN_TBL(1).Token_Value := G_ENTITY_CHILD_VS;
11401: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
11402: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
11403: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
11404: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB';
11405: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
11406: G_TOKEN_TBL(4).Token_Value := 'Create_Child_Value_Set';
11407:
11408:

Line 11709: write_debug(G_PKG_Name,l_api_name,' : calling EGO_EXT_FWK_PUB.Update_Child_Value_Set API ');

11705:
11706: END IF; -- END IF l_process_status = G_PROCESS_RECORD THEN
11707:
11708:
11709: write_debug(G_PKG_Name,l_api_name,' : calling EGO_EXT_FWK_PUB.Update_Child_Value_Set API ');
11710: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' : calling EGO_EXT_FWK_PUB.Update_Child_Value_Set API ');
11711:
11712: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' : Format Coed '||l_format_code||' Desc = '||l_description||' VS Id = '||l_value_set_id);
11713:

Line 11710: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' : calling EGO_EXT_FWK_PUB.Update_Child_Value_Set API ');

11706: END IF; -- END IF l_process_status = G_PROCESS_RECORD THEN
11707:
11708:
11709: write_debug(G_PKG_Name,l_api_name,' : calling EGO_EXT_FWK_PUB.Update_Child_Value_Set API ');
11710: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' : calling EGO_EXT_FWK_PUB.Update_Child_Value_Set API ');
11711:
11712: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' : Format Coed '||l_format_code||' Desc = '||l_description||' VS Id = '||l_value_set_id);
11713:
11714: IF l_process_status = G_PROCESS_RECORD THEN

Line 11717: EGO_EXT_FWK_PUB.Update_Child_Value_Set

11713:
11714: IF l_process_status = G_PROCESS_RECORD THEN
11715:
11716: -- Call update API to update value set.
11717: EGO_EXT_FWK_PUB.Update_Child_Value_Set
11718: (
11719: p_api_version => l_api_version
11720: ,p_value_set_id => l_value_set_id
11721: ,p_description => l_description

Line 11734: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Return status post call to EGO_EXT_FWK_PUB.Update_Child_Value_Set API = '||l_return_status||' Msg is ; '||l_return_msg);

11730: ,x_msg_data => l_return_msg
11731: );
11732:
11733:
11734: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Return status post call to EGO_EXT_FWK_PUB.Update_Child_Value_Set API = '||l_return_status||' Msg is ; '||l_return_msg);
11735:
11736: -- check the return status
11737: IF (Nvl(l_return_status,G_RET_STS_SUCCESS) =G_RET_STS_SUCCESS ) THEN
11738:

Line 11780: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB' ;

11776: G_TOKEN_TBL(1).Token_Value := G_ENTITY_CHILD_VS;
11777: G_TOKEN_TBL(2).Token_Name := 'Transaction_Type';
11778: G_TOKEN_TBL(2).Token_Value := l_transaction_type;
11779: G_TOKEN_TBL(3).Token_Name := 'Package_Name';
11780: G_TOKEN_TBL(3).Token_Value := 'EGO_EXT_FWK_PUB' ;
11781: G_TOKEN_TBL(4).Token_Name := 'Proc_Name';
11782: G_TOKEN_TBL(4).Token_Value := 'Update_Child_Value_Set';
11783:
11784: