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.CSI_ITEM_INSTANCE_PVT dependencies on CSI_INSTANCE_PARTIES_VLD_PVT

Line 23647: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

23643:
23644: -- Start API body
23645: --
23646: -- Check if all the required parameters are passed
23647: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
23648: ( p_version_label_rec.INSTANCE_ID ,
23649: ' p_version_label_rec.INSTANCE_ID ',
23650: l_api_name );
23651:

Line 23652: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

23648: ( p_version_label_rec.INSTANCE_ID ,
23649: ' p_version_label_rec.INSTANCE_ID ',
23650: l_api_name );
23651:
23652: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
23653: ( p_version_label_rec.version_label ,
23654: ' p_version_label_rec.version_label ',
23655: l_api_name );
23656:

Line 23657: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date

23653: ( p_version_label_rec.version_label ,
23654: ' p_version_label_rec.version_label ',
23655: l_api_name );
23656:
23657: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date
23658: ( p_version_label_rec.date_time_stamp ,
23659: ' p_version_label_rec.date_time_stamp ',
23660: l_api_name );
23661: -- Validate the Instance id exists in csi_item_instances

Line 23662: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid

23658: ( p_version_label_rec.date_time_stamp ,
23659: ' p_version_label_rec.date_time_stamp ',
23660: l_api_name );
23661: -- Validate the Instance id exists in csi_item_instances
23662: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid
23663: (p_version_label_rec.INSTANCE_ID)) THEN
23664: RAISE FND_API.G_EXC_ERROR;
23665: END IF;
23666: -- If active_start_date is null or G_MISS value then assign sysdate

Line 23698: IF NOT(CSI_Instance_parties_vld_pvt.Is_timestamp_Valid

23694:
23695: -- Verify the timestamp is less than the end effective date but greater then
23696: -- the start effective date
23697: IF p_version_label_rec.date_time_stamp is NOT NULL THEN
23698: IF NOT(CSI_Instance_parties_vld_pvt.Is_timestamp_Valid
23699: (p_version_label_rec.date_time_stamp,
23700: p_version_label_rec.INSTANCE_ID )) THEN
23701: RAISE FND_API.G_EXC_ERROR;
23702: END IF;

Line 23712: p_version_label_rec.VERSION_LABEL_ID := CSI_Instance_parties_vld_pvt.gen_ver_label_id;

23708: -- If the vesrion label id passed is null then generate from sequence
23709: -- and check if the value exists . If exists then generate
23710: -- again from the sequence till we get a value that does not exist
23711: while l_process_flag loop
23712: p_version_label_rec.VERSION_LABEL_ID := CSI_Instance_parties_vld_pvt.gen_ver_label_id;
23713: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23714: FALSE )) THEN
23715: l_process_flag := FALSE;
23716: END IF;

Line 23713: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,

23709: -- and check if the value exists . If exists then generate
23710: -- again from the sequence till we get a value that does not exist
23711: while l_process_flag loop
23712: p_version_label_rec.VERSION_LABEL_ID := CSI_Instance_parties_vld_pvt.gen_ver_label_id;
23713: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23714: FALSE )) THEN
23715: l_process_flag := FALSE;
23716: END IF;
23717: end loop;

Line 23720: IF CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,

23716: END IF;
23717: end loop;
23718: ELSE
23719: -- Validate the version label id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
23720: IF CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23721: TRUE ) THEN
23722: RAISE FND_API.G_EXC_ERROR;
23723: END IF;
23724: END IF;

Line 23785: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;

23781: RAISE FND_API.G_EXC_ERROR;
23782: END IF;
23783:
23784: -- Generate a unique instance_party_history_id from the sequence
23785: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
23786:
23787: -- Call the table handlers to insert into history table
23788:
23789: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

Line 24009: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

24005:
24006: -- Start API body
24007: --
24008: -- Check if all the required parameters are passed
24009: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
24010: ( p_version_label_rec.version_label_id ,
24011: ' p_version_label_rec.version_label_id ',
24012: l_api_name );
24013:

Line 24016: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid

24012: l_api_name );
24013:
24014: -- Validate the Instance id exists in csi_item_instances
24015: IF p_version_label_rec.INSTANCE_ID <> FND_API.G_MISS_NUM THEN
24016: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid
24017: (p_version_label_rec.INSTANCE_ID)) THEN
24018: RAISE FND_API.G_EXC_ERROR;
24019: END IF;
24020: END IF;

Line 24025: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,

24021:
24022: IF p_version_label_rec.VERSION_LABEL_ID <> FND_API.G_MISS_NUM THEN
24023:
24024: -- Validate the version label id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
24025: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
24026: FALSE )) THEN
24027: RAISE FND_API.G_EXC_ERROR;
24028: END IF;
24029: END IF;

Line 24110: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;

24106: RAISE FND_API.G_EXC_ERROR;
24107: END IF;
24108: END IF;
24109: -- Generate a unique instance_party_history_id from the sequence
24110: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
24111:
24112: -- Get the full_dump_frequency from csi_install_parameter
24113: --
24114: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 25125: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

25121:
25122: -- Start API body
25123:
25124: -- Check if all the required parameters are passed
25125: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
25126: ( p_version_label_rec.version_label_id ,
25127: ' p_version_label_rec.version_label_id ',
25128: l_api_name );
25129:

Line 25130: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

25126: ( p_version_label_rec.version_label_id ,
25127: ' p_version_label_rec.version_label_id ',
25128: l_api_name );
25129:
25130: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
25131: ( p_version_label_rec.object_version_number ,
25132: ' p_version_label_rec.object_version_number ',
25133: l_api_name );
25134:

Line 25135: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date

25131: ( p_version_label_rec.object_version_number ,
25132: ' p_version_label_rec.object_version_number ',
25133: l_api_name );
25134:
25135: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date
25136: ( p_version_label_rec.active_end_date ,
25137: ' p_version_label_rec.active_end_date ',
25138: l_api_name );
25139:

Line 25142: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists

25138: l_api_name );
25139:
25140: IF p_version_label_rec.version_label_id <> FND_API.G_MISS_NUM THEN
25141: -- Validate the version label id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
25142: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists
25143: (p_version_label_rec.version_label_id,
25144: FALSE )) THEN
25145: RAISE FND_API.G_EXC_ERROR;
25146: END IF;

Line 25226: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;

25222: RAISE FND_API.G_EXC_ERROR;
25223: END IF;
25224:
25225: -- Generate a unique instance_party_history_id from the sequence
25226: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
25227:
25228: -- Get the full_dump_frequency from csi_install_parameter
25229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
25230: csi_gen_utility_pvt.populate_install_param_rec;

Line 26407: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN

26403: ,1
26404: );
26405:
26406:
26407: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
26408: -- Call create_transaction to create txn log
26409:
26410: CSI_TRANSACTIONS_PVT.Create_transaction
26411: ( p_api_version => p_api_version

Line 26772: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN

26768: );
26769:
26770:
26771:
26772: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
26773: -- Call create_transaction to create txn log
26774:
26775: CSI_TRANSACTIONS_PVT.Create_transaction
26776: ( p_api_version => p_api_version