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.MSC_CL_PRE_PROCESS dependencies on MSC_ST_TRADING_PARTNER_SITES

Line 1108: ||' on MSC_ST_TRADING_PARTNER_SITES '

1104: application_short_name => 'MSC',
1105: statement_type => AD_DDL.CREATE_INDEX,
1106: statement =>
1107: 'create index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code
1108: ||' on MSC_ST_TRADING_PARTNER_SITES '
1109: ||'(sr_instance_code ,tp_site_code, partner_name, partner_type) '
1110: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1111: object_name =>'MSC_ST_TRD_PART_SITES_N1_'||v_instance_code);
1112:

Line 1217: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNER_SITES', v_instance_id, -1);

1213:
1214:
1215:
1216: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNERS', v_instance_id, -1);
1217: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNER_SITES', v_instance_id, -1);
1218: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUB_INVENTORIES', v_instance_id, -1);
1219: msc_analyse_tables_pk.analyse_table( 'MSC_ST_LOCATION_ASSOCIATIONS', v_instance_id, -1);
1220: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PARTNER_CONTACTS', v_instance_id, -1);
1221:

Line 6284: FROM msc_st_trading_partner_sites

6280: AND deleted_flag = SYS_NO;
6281:
6282: CURSOR c3(p_batch_id NUMBER) IS
6283: SELECT rowid
6284: FROM msc_st_trading_partner_sites
6285: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6286: AND sr_instance_code = v_instance_code
6287: AND batch_id = p_batch_id;
6288:

Line 6291: FROM msc_st_trading_partner_sites

6287: AND batch_id = p_batch_id;
6288:
6289: CURSOR c4(p_batch_id NUMBER) IS
6290: SELECT rowid
6291: FROM msc_st_trading_partner_sites
6292: WHERE process_flag = G_IN_PROCESS
6293: AND sr_instance_code = v_instance_code
6294: AND batch_id = p_batch_id
6295: AND NVL(sr_tp_site_id,NULL_VALUE) = NULL_VALUE

Line 6315: FROM msc_st_trading_partner_sites

6311: AND batch_id = p_batch_id;
6312:
6313: CURSOR c7(p_batch_id NUMBER) IS
6314: SELECT max(rowid)
6315: FROM msc_st_trading_partner_sites
6316: WHERE process_flag = G_IN_PROCESS
6317: AND deleted_flag = SYS_NO
6318: AND NVL(sr_tp_site_id,NULL_VALUE) = NULL_VALUE
6319: AND partner_type = 3

Line 6433: FROM msc_st_trading_partner_sites

6429: GROUP BY location_code;
6430:
6431: CURSOR c15(p_batch_id NUMBER) IS
6432: SELECT max(rowid)
6433: FROM msc_st_trading_partner_sites
6434: WHERE process_flag = G_IN_PROCESS
6435: AND deleted_flag = SYS_NO
6436: AND NVL(location_id,NULL_VALUE) = NULL_VALUE
6437: AND partner_type = 2

Line 7632: --Validation for MSC_ST_TRADING_PARTNER_SITES

7628: END IF ;
7629: COMMIT;
7630: END LOOP;
7631:
7632: --Validation for MSC_ST_TRADING_PARTNER_SITES
7633:
7634: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
7635: (p_app_short_name => 'MSC',
7636: p_error_code => 'MSC_PP_DUP_REC_FOR_BATCH_LOAD',

Line 7647: ' UPDATE msc_st_trading_partner_sites mstp1'

7643: /*
7644: -- UDK validations
7645: v_sql_stmt := 19;
7646: lv_sql_stmt :=
7647: ' UPDATE msc_st_trading_partner_sites mstp1'
7648: ||' SET process_flag = '||G_ERROR_FLG||', '
7649: ||' error_text = '||''''||lv_message_text||''''
7650: ||' WHERE EXISTS ( SELECT 1 '
7651: ||' FROM msc_st_trading_partner_sites mstp2 '

Line 7651: ||' FROM msc_st_trading_partner_sites mstp2 '

7647: ' UPDATE msc_st_trading_partner_sites mstp1'
7648: ||' SET process_flag = '||G_ERROR_FLG||', '
7649: ||' error_text = '||''''||lv_message_text||''''
7650: ||' WHERE EXISTS ( SELECT 1 '
7651: ||' FROM msc_st_trading_partner_sites mstp2 '
7652: ||' WHERE mstp2.sr_instance_code = mstp1.sr_instance_code '
7653: ||' AND NVL(mstp2.company_name, '||''''||NULL_CHAR||''''||') = '
7654: ||' NVL(mstp1.company_name, '||''''||NULL_CHAR||''''||')'
7655: ||' AND mstp2.partner_name = mstp1.partner_name '

Line 7678: ' UPDATE msc_st_trading_partner_sites mstp1'

7674:
7675: -- UDK validations for locations
7676: v_sql_stmt := 19;
7677: lv_sql_stmt :=
7678: ' UPDATE msc_st_trading_partner_sites mstp1'
7679: ||' SET process_flag = '||G_ERROR_FLG||', '
7680: ||' error_text = '||''''||lv_message_text||''''
7681: ||' WHERE EXISTS ( SELECT 1 '
7682: ||' FROM msc_st_trading_partner_sites mstp2 '

Line 7682: ||' FROM msc_st_trading_partner_sites mstp2 '

7678: ' UPDATE msc_st_trading_partner_sites mstp1'
7679: ||' SET process_flag = '||G_ERROR_FLG||', '
7680: ||' error_text = '||''''||lv_message_text||''''
7681: ||' WHERE EXISTS ( SELECT 1 '
7682: ||' FROM msc_st_trading_partner_sites mstp2 '
7683: ||' WHERE mstp2.sr_instance_code = mstp1.sr_instance_code '
7684: ||' AND NVL(mstp2.company_name, '||''''||NULL_CHAR||''''||') = '
7685: ||' NVL(mstp1.company_name, '||''''||NULL_CHAR||''''||')'
7686: ||' AND mstp2.partner_name = mstp1.partner_name '

Line 7709: ' UPDATE msc_st_trading_partner_sites mstp1'

7705:
7706: -- UDK validations for tp sites
7707: v_sql_stmt := 19;
7708: lv_sql_stmt :=
7709: ' UPDATE msc_st_trading_partner_sites mstp1'
7710: ||' SET process_flag = '||G_ERROR_FLG||', '
7711: ||' error_text = '||''''||lv_message_text||''''
7712: ||' WHERE EXISTS ( SELECT 1 '
7713: ||' FROM msc_st_trading_partner_sites mstp2 '

Line 7713: ||' FROM msc_st_trading_partner_sites mstp2 '

7709: ' UPDATE msc_st_trading_partner_sites mstp1'
7710: ||' SET process_flag = '||G_ERROR_FLG||', '
7711: ||' error_text = '||''''||lv_message_text||''''
7712: ||' WHERE EXISTS ( SELECT 1 '
7713: ||' FROM msc_st_trading_partner_sites mstp2 '
7714: ||' WHERE mstp2.sr_instance_code = mstp1.sr_instance_code '
7715: ||' AND NVL(mstp2.company_name, '||''''||NULL_CHAR||''''||') = '
7716: ||' NVL(mstp1.company_name, '||''''||NULL_CHAR||''''||')'
7717: ||' AND mstp2.partner_name = mstp1.partner_name '

Line 7750: ' UPDATE msc_st_trading_partner_sites mstp1'

7746:
7747: -- Duplicate UDK validation for XML message
7748: v_sql_stmt := 20;
7749: lv_sql_stmt :=
7750: ' UPDATE msc_st_trading_partner_sites mstp1'
7751: ||' SET process_flag = '||G_ERROR_FLG||', '
7752: ||' error_text = '||''''||lv_message_text||''''
7753: ||' WHERE message_id < ( SELECT max(message_id) '
7754: ||' FROM msc_st_trading_partner_sites mstp2 '

Line 7754: ||' FROM msc_st_trading_partner_sites mstp2 '

7750: ' UPDATE msc_st_trading_partner_sites mstp1'
7751: ||' SET process_flag = '||G_ERROR_FLG||', '
7752: ||' error_text = '||''''||lv_message_text||''''
7753: ||' WHERE message_id < ( SELECT max(message_id) '
7754: ||' FROM msc_st_trading_partner_sites mstp2 '
7755: ||' WHERE mstp2.sr_instance_code = mstp1.sr_instance_code '
7756: ||' AND NVL(mstp2.company_name, '||''''||NULL_CHAR||''''||') = '
7757: ||' NVL(mstp1.company_name, '||''''||NULL_CHAR||''''||')'
7758: ||' AND mstp2.partner_name = mstp1.partner_name '

Line 7797: 'UPDATE msc_st_trading_partner_sites '

7793: FROM DUAL;
7794:
7795: v_sql_stmt := 22;
7796: lv_sql_stmt :=
7797: 'UPDATE msc_st_trading_partner_sites '
7798: ||' SET batch_id = :lv_batch_id'
7799: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
7800: ||' AND sr_instance_code = :v_instance_code'
7801: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 7821: UPDATE msc_st_trading_partner_sites

7817:
7818: -- Populate the st_transaction_id and WHO columns
7819: v_sql_stmt := 23;
7820: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7821: UPDATE msc_st_trading_partner_sites
7822: SET st_transaction_id = msc_st_trading_partner_sites_s.NEXTVAL ,
7823: refresh_id = v_refresh_id,
7824: last_update_date = v_current_date,
7825: last_updated_by = v_current_user,

Line 7822: SET st_transaction_id = msc_st_trading_partner_sites_s.NEXTVAL ,

7818: -- Populate the st_transaction_id and WHO columns
7819: v_sql_stmt := 23;
7820: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
7821: UPDATE msc_st_trading_partner_sites
7822: SET st_transaction_id = msc_st_trading_partner_sites_s.NEXTVAL ,
7823: refresh_id = v_refresh_id,
7824: last_update_date = v_current_date,
7825: last_updated_by = v_current_user,
7826: creation_date = v_current_date,

Line 7836: p_token_value1 => 'MSC_ST_TRADING_PARTNER_SITES');

7832: p_error_code => 'MSC_PP_NO_DELETION',
7833: p_message_text => lv_message_text,
7834: p_error_text => lv_error_text,
7835: p_token1 => 'TABLE_NAME',
7836: p_token_value1 => 'MSC_ST_TRADING_PARTNER_SITES');
7837:
7838: IF lv_return <> 0 THEN
7839: RAISE ex_logging_err;
7840: END IF;

Line 7845: 'UPDATE msc_st_trading_partner_sites '

7841:
7842: -- Deletion is not allowed for this table
7843: v_sql_stmt := 24;
7844: lv_sql_stmt :=
7845: 'UPDATE msc_st_trading_partner_sites '
7846: ||' SET process_flag = '||G_ERROR_FLG||','
7847: ||' error_text = '||''''||lv_message_text||''''
7848: ||' WHERE deleted_flag = '||SYS_YES
7849: ||' AND process_flag = '||G_IN_PROCESS

Line 7883: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',

7879: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
7880: ||' NOT IN(1,2)';
7881:
7882: lv_return := MSC_ST_UTIL.LOG_ERROR
7883: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',
7884: p_instance_code => v_instance_code,
7885: p_row => lv_column_names,
7886: p_severity => G_SEV_WARNING,
7887: p_message_text => lv_message_text,

Line 7915: 'UPDATE msc_st_trading_partner_sites '

7911:
7912: -- Error out records where partner_type NOT in (1,2,3)
7913: v_sql_stmt := 25;
7914: lv_sql_stmt :=
7915: 'UPDATE msc_st_trading_partner_sites '
7916: ||' SET process_flag = '||G_ERROR_FLG||', '
7917: ||' error_text = '||''''||lv_message_text||''''
7918: ||' WHERE sr_instance_code = :v_instance_code'
7919: ||' AND batch_id = :lv_batch_id'

Line 7950: 'UPDATE msc_st_trading_partner_sites '

7946:
7947: -- Error out records where partner_type NOT in (2)
7948: v_sql_stmt := 25;
7949: lv_sql_stmt :=
7950: 'UPDATE msc_st_trading_partner_sites '
7951: ||' SET process_flag = '||G_ERROR_FLG||', '
7952: ||' error_text = '||''''||lv_message_text||''''
7953: ||' WHERE sr_instance_code = :v_instance_code'
7954: ||' AND batch_id = :lv_batch_id'

Line 7985: 'UPDATE msc_st_trading_partner_sites '

7981: -- Error out records where partner_name/tp_site_code is NULL
7982: -- For partner type 1 and 2
7983: v_sql_stmt := 26;
7984: lv_sql_stmt :=
7985: 'UPDATE msc_st_trading_partner_sites '
7986: ||' SET process_flag = '||G_ERROR_FLG||','
7987: ||' error_text = '||''''||lv_message_text||''''
7988: ||' WHERE sr_instance_code = :v_instance_code'
7989: ||' AND batch_id = :lv_batch_id'

Line 8022: 'UPDATE msc_st_trading_partner_sites '

8018: -- Error out records where partner_name/location is NULL
8019: -- For partner type 3
8020: v_sql_stmt := 27;
8021: lv_sql_stmt :=
8022: 'UPDATE msc_st_trading_partner_sites '
8023: ||' SET process_flag = '||G_ERROR_FLG||','
8024: ||' error_text = '||''''||lv_message_text||''''
8025: ||' WHERE sr_instance_code = :v_instance_code'
8026: ||' AND batch_id = :lv_batch_id'

Line 8056: (p_table_name =>'MSC_ST_TRADING_PARTNER_SITES',

8052: END IF;
8053:
8054: -- Update sr_tp_id(customer)
8055: lv_return :=msc_st_util.derive_partner_org_id
8056: (p_table_name =>'MSC_ST_TRADING_PARTNER_SITES',
8057: p_org_partner_name =>'PARTNER_NAME',
8058: p_cust_account_number=>'CUST_ACCOUNT_NUMBER',
8059: p_org_partner_id =>'SR_TP_ID',
8060: p_instance_code => v_instance_code,

Line 8072: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',

8068: END IF;
8069:
8070: -- Update sr_tp_id(Organization)
8071: lv_return :=msc_st_util.derive_partner_org_id
8072: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',
8073: p_org_partner_name => 'PARTNER_NAME',
8074: p_org_partner_id => 'SR_TP_ID',
8075: p_instance_code => v_instance_code,
8076: p_partner_type => G_ORGANIZATION,

Line 8088: (p_table_name =>'MSC_ST_TRADING_PARTNER_SITES',

8084: END IF ; --v_install_msc
8085:
8086: -- Update sr_tp_id(supplier)
8087: lv_return :=msc_st_util.derive_partner_org_id
8088: (p_table_name =>'MSC_ST_TRADING_PARTNER_SITES',
8089: p_org_partner_name =>'PARTNER_NAME',
8090: p_org_partner_id =>'SR_TP_ID',
8091: p_instance_code => v_instance_code,
8092: p_partner_type => G_VENDOR,

Line 8106: 'UPDATE msc_st_trading_partner_sites'

8102:
8103: -- Error out the record if sr_tp_id is NULL
8104: v_sql_stmt := 28;
8105: lv_sql_stmt :=
8106: 'UPDATE msc_st_trading_partner_sites'
8107: ||' SET process_flag = '||G_ERROR_FLG||','
8108: ||' error_text = '||''''||lv_message_text||''''
8109: ||' WHERE NVL(sr_tp_id,'||NULL_VALUE||')= '||NULL_VALUE
8110: ||' AND batch_id = :lv_batch_id'

Line 8135: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',

8131: END IF;
8132:
8133: -- Update sr_tp_site_id(Vendor)
8134: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
8135: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',
8136: p_partner_name => 'PARTNER_NAME',
8137: p_partner_site_code => 'TP_SITE_CODE',
8138: p_partner_site_id => 'SR_TP_SITE_ID',
8139: p_instance_code => v_instance_code,

Line 8153: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',

8149:
8150: IF(v_install_msc) THEN
8151: -- Update sr_tp_site_id(Customer)
8152: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
8153: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',
8154: p_partner_name => 'PARTNER_NAME',
8155: p_partner_site_code => 'TP_SITE_CODE',
8156: p_CUST_ACCOUNT_NUMBER =>'CUST_ACCOUNT_NUMBER',
8157: p_partner_site_id => 'SR_TP_SITE_ID',

Line 8173: 'UPDATE msc_st_trading_partner_sites mts'

8169: -- Update sr_tp_site_id(Organization)
8170: -- location_id goes into sr_tp_site_id
8171: v_sql_stmt := 28;
8172: lv_sql_stmt :=
8173: 'UPDATE msc_st_trading_partner_sites mts'
8174: ||' SET sr_tp_site_id = (SELECT local_id'
8175: ||' FROM msc_local_id_setup mls'
8176: ||' WHERE mls.char1 = mts.sr_instance_code'
8177: ||' AND mls.char3 = mts.location'

Line 8205: ||' FROM msc_st_trading_partner_sites mts'

8201: v_sql_stmt := 29;
8202: lv_sql_stmt :=
8203: 'UPDATE msc_local_id_setup mls'
8204: ||' SET mls.char4 = NVL( (select mts.location '
8205: ||' FROM msc_st_trading_partner_sites mts'
8206: ||' WHERE mls.char1 = mts.sr_instance_code'
8207: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '
8208: ||' NVL(mts.company_name,'||''''||NULL_CHAR||''''||') '
8209: ||' AND mls.char3 = mts.partner_name'

Line 8234: pEntityName => 'MSC_ST_TRADING_PARTNER_SITES',

8230: (ERRBUF => lv_error_text,
8231: RETCODE => lv_return,
8232: pBatchID => lv_batch_id,
8233: pInstanceCode => v_instance_code,
8234: pEntityName => 'MSC_ST_TRADING_PARTNER_SITES',
8235: pInstanceID => v_instance_id);
8236:
8237: IF NVL(lv_return,0) <> 0 THEN
8238: RAISE ex_logging_err;

Line 8247: UPDATE msc_st_trading_partner_sites

8243:
8244: IF c4%ROWCOUNT > 0 THEN
8245: v_sql_stmt := 29;
8246: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8247: UPDATE msc_st_trading_partner_sites
8248: SET sr_tp_site_id = msc_st_sr_tp_site_id_s.NEXTVAL
8249: WHERE rowid = lb_rowid(j);
8250:
8251: -- Insert record in LID

Line 8290: FROM msc_st_trading_partner_sites

8286: v_current_date,
8287: v_current_user,
8288: v_current_date,
8289: v_current_user
8290: FROM msc_st_trading_partner_sites
8291: WHERE rowid = lb_rowid(j);
8292: END IF;
8293: CLOSE C4;
8294:

Line 8302: UPDATE msc_st_trading_partner_sites

8298:
8299: IF c7%ROWCOUNT > 0 THEN
8300: v_sql_stmt := 31;
8301: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8302: UPDATE msc_st_trading_partner_sites
8303: SET sr_tp_site_id = msc_st_location_id_s.NEXTVAL
8304: WHERE rowid = lb_rowid(j);
8305:
8306: -- Insert record in LID

Line 8337: FROM msc_st_trading_partner_sites

8333: v_current_date,
8334: v_current_user,
8335: v_current_date,
8336: v_current_user
8337: FROM msc_st_trading_partner_sites
8338: WHERE rowid = lb_rowid(j);
8339: END IF;
8340: CLOSE C7;
8341:

Line 8345: 'UPDATE msc_st_trading_partner_sites mts'

8341:
8342: --Deriving location_id
8343: v_sql_stmt := 32.1;
8344: lv_sql_stmt :=
8345: 'UPDATE msc_st_trading_partner_sites mts'
8346: ||' SET sr_tp_site_id = (SELECT local_id'
8347: ||' FROM msc_local_id_setup mls'
8348: ||' WHERE mls.char1 = mts.sr_instance_code'
8349: ||' AND mls.char3 = mts.location'

Line 8372: 'UPDATE msc_st_trading_partner_sites '

8368: -- of Customer Sites SCE would pick LOCATION as the COMPANY_SITE_NAME for MSC_COMPANY_SITES.
8369:
8370: v_sql_stmt := 33;
8371: lv_sql_stmt :=
8372: 'UPDATE msc_st_trading_partner_sites '
8373: ||' SET LOCATION = TP_SITE_CODE '
8374: ||' WHERE process_flag = '|| G_IN_PROCESS
8375: ||' AND partner_type = '|| G_CUSTOMER
8376: ||' AND NVL(batch_id,'||NULL_VALUE||') = :p_batch_id'

Line 8392: 'UPDATE msc_st_trading_partner_sites mts'

8388:
8389: --Deriving location_id for G_CUSTOMERS --- for E1 integration 8651763 .
8390: v_sql_stmt := 32.2;
8391: lv_sql_stmt :=
8392: 'UPDATE msc_st_trading_partner_sites mts'
8393: ||' SET location_id = (SELECT local_id'
8394: ||' FROM msc_local_id_setup mls'
8395: ||' WHERE mls.char1 = mts.sr_instance_code'
8396: ||' AND mls.char3 = mts.location'

Line 8421: UPDATE msc_st_trading_partner_sites

8417:
8418: IF c15%ROWCOUNT > 0 THEN
8419: v_sql_stmt := 32.3;
8420: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8421: UPDATE msc_st_trading_partner_sites
8422: SET location_id = msc_st_location_id_s.NEXTVAL
8423: WHERE rowid = lb_rowid(j);
8424:
8425: -- Insert record in LID

Line 8456: FROM msc_st_trading_partner_sites

8452: v_current_date,
8453: v_current_user,
8454: v_current_date,
8455: v_current_user
8456: FROM msc_st_trading_partner_sites
8457: WHERE rowid = lb_rowid(j);
8458: END IF;
8459: CLOSE C15;
8460:

Line 8464: 'UPDATE msc_st_trading_partner_sites mts'

8460:
8461: --Deriving location_id
8462: v_sql_stmt := 32.5;
8463: lv_sql_stmt :=
8464: 'UPDATE msc_st_trading_partner_sites mts'
8465: ||' SET location_id = (SELECT local_id'
8466: ||' FROM msc_local_id_setup mls'
8467: ||' WHERE mls.char1 = mts.sr_instance_code'
8468: ||' AND mls.char3 = mts.location'

Line 8488: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',

8484:
8485:
8486: -- Set the process flag as Valid and poulate instance_id
8487: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
8488: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',
8489: p_instance_id => v_instance_id,
8490: p_instance_code => v_instance_code,
8491: p_process_flag => G_VALID,
8492: p_error_text => lv_error_text,

Line 8503: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',

8499:
8500: -- At the end calling the LOG_ERROR for logging all errored out records
8501:
8502: lv_return := MSC_ST_UTIL.LOG_ERROR
8503: (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES',
8504: p_instance_code => v_instance_code,
8505: p_row => lv_column_names,
8506: p_severity => G_SEV_ERROR,
8507: p_message_text => NULL,

Line 55920: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES');

55916: IF lv_count > 0 Then
55917: prec.tp_customer_flag:= SYS_YES;
55918: prec.tp_vendor_flag:= SYS_YES;
55919: End IF;
55920: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_TRADING_PARTNER_SITES');
55921: IF lv_count > 0 Then
55922: prec.tp_customer_flag:= SYS_YES;
55923: prec.tp_vendor_flag:= SYS_YES;
55924: End IF;